show full columns from `xms_category` [ runtime:0.001252s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000748s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000855s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000932s ]
show full columns from `xms_site` [ runtime:0.000896s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.001114s ]
show full columns from `xms_document` [ runtime:0.001127s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 92 limit 1 [ runtime:0.000672s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000434s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000843s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002080s ]
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.000674s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000656s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000559s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000762s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000634s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000726s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000697s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.001038s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000603s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000604s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000617s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000743s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000620s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000608s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000714s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000660s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000590s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000543s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000605s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001978s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002017s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002050s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002036s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001994s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002034s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000908s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) 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.000556s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000576s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000651s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000584s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000597s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000572s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000583s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000573s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000568s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000682s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000564s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000583s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000543s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000564s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000564s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000552s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000482s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000460s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000406s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000562s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000481s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000431s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000593s ]
select * from `xms_document` where `id` = 92 limit 1 [ runtime:0.000673s ]
select * from `xms_document` where `id` = 92 limit 1 [ runtime:0.000751s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 92 limit 1 [ runtime:0.000444s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000367s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 92) [ runtime:0.001600s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =0) [ runtime:0.001845s ]
select * from `xms_document` where `id` = 92 limit 1 [ runtime:0.000604s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 92 limit 1 [ runtime:0.000553s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000346s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 92) [ runtime:0.001551s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =0) [ runtime:0.001810s ]
select * from `xms_document` where `id` = 92 limit 1 [ runtime:0.000663s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 92 limit 1 [ runtime:0.000396s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000314s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 92) [ runtime:0.001545s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001837s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000648s ]
show full columns from `xms_pagemodel` [ runtime:0.000751s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000452s ]
select * from `xms_document` where `id` = 92 limit 1 [ runtime:0.000637s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 92 limit 1 [ runtime:0.000443s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000302s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 92) [ runtime:0.001573s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001969s ]
select * from `xms_document` where `id` = 92 limit 1 [ runtime:0.000656s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 92 limit 1 [ runtime:0.000482s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000312s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 92) [ runtime:0.001736s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001840s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000629s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000615s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000415s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000962s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000453s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.000991s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000659s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000395s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000424s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000468s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000439s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000313s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000335s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000991s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000828s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000441s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000648s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000359s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000343s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000974s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000604s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000477s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000352s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000968s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000596s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000378s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000462s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000371s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000628s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000521s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000614s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000774s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000695s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000666s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000575s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000611s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000522s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000554s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000533s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000602s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000554s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000663s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000596s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000739s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000613s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000604s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000569s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000527s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000535s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001328s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001825s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001948s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002011s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000665s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000387s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002014s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000806s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000464s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001953s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000545s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000371s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001833s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000529s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000390s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001850s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001975s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001975s ]