show full columns from `xms_category` [ runtime:0.001258s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000950s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000679s ]
select * from `xms_category` where `id` = 18 limit 1 [ runtime:0.000510s ]
select * from `xms_category` where `id` = 23 limit 1 [ runtime:0.000587s ]
show full columns from `xms_site` [ runtime:0.000814s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000685s ]
show full columns from `xms_document` [ runtime:0.001046s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000510s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000371s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001108s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002238s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000791s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000672s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000675s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000575s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000789s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000630s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000583s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000545s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000574s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000585s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000887s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000686s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000674s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000721s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000776s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000848s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000701s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000722s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000734s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000864s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000875s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000812s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002278s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002337s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001963s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001946s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002103s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002262s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000956s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000612s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000544s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000544s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000568s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000506s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000835s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000606s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000561s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000536s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000713s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000649s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000549s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000650s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000540s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000728s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000572s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000634s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000594s ]
select * from `xms_category` where `id` = 23 limit 1 [ runtime:0.000461s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000494s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000412s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=18 ) order by sortid asc [ runtime:0.000527s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000500s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000470s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=18 ) order by sortid asc [ runtime:0.000717s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000573s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000537s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000391s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000328s ]
(select rownum - 1 as row from (select *, (@i :=@i 1) as rownum from xms_document, (select @i := 0) as it where states=1 and catid=24 order by id asc,sortid desc ) as t1 where id = 238) [ runtime:0.001566s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =1) [ runtime:0.001923s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000579s ]
show full columns from `xms_pagemodel` [ runtime:0.000763s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000511s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000502s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000332s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000361s ]
(select rownum - 1 as row from (select *, (@i :=@i 1) as rownum from xms_document, (select @i := 0) as it where states=1 and catid=24 order by id asc,sortid desc ) as t1 where id = 238) [ runtime:0.001608s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =1) [ runtime:0.001824s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000707s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000367s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000330s ]
(select rownum - 1 as row from (select *, (@i :=@i 1) as rownum from xms_document, (select @i := 0) as it where states=1 and catid=24 order by id asc,sortid desc ) as t1 where id = 238) [ runtime:0.001553s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =1) [ runtime:0.001752s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000709s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000363s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000318s ]
(select rownum 1 as row from (select *, (@i :=@i 1) as rownum from xms_document, (select @i := 0) as it where states=1 and catid=24 order by id asc,sortid desc ) as t1 where id = 238) [ runtime:0.001497s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =3) [ runtime:0.001803s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000605s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000393s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000555s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000370s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000542s ]
(select rownum 1 as row from (select *, (@i :=@i 1) as rownum from xms_document, (select @i := 0) as it where states=1 and catid=24 order by id asc,sortid desc ) as t1 where id = 238) [ runtime:0.001491s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =3) [ runtime:0.001788s ]
select * from `xms_document` where `id` = 238 limit 1 [ runtime:0.000644s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 238 limit 1 [ runtime:0.000409s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000317s ]
(select rownum 1 as row from (select *, (@i :=@i 1) as rownum from xms_document, (select @i := 0) as it where states=1 and catid=24 order by id asc,sortid desc ) as t1 where id = 238) [ runtime:0.001478s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =3) [ runtime:0.001785s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000745s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000594s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000421s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000889s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000452s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001176s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000618s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000442s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000493s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000341s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000704s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000423s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000389s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000975s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000475s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000485s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000677s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000321s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000417s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000986s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000566s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000368s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000305s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000906s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000561s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000437s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000444s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000474s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000518s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000559s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000598s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000676s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000512s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000598s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000856s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000573s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000619s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000557s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000628s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000618s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000643s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000571s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000593s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000616s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000545s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000567s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000532s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000525s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000572s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000554s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001443s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002040s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001996s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.001939s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000616s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000416s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001904s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000606s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000403s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001926s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000636s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000350s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002018s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000585s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000469s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001985s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001944s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002150s ]
