show full columns from `xms_category` [ runtime:0.001305s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000936s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000918s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000688s ]
show full columns from `xms_site` [ runtime:0.000996s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000603s ]
show full columns from `xms_document` [ runtime:0.001170s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 345 limit 1 [ runtime:0.000751s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000482s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000989s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002296s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000740s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000800s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000809s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000844s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000755s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000769s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000742s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000836s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000863s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000815s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000820s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000832s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000832s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000824s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000741s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000847s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000776s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000772s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000775s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000838s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000769s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000808s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002291s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002189s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002226s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002233s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002411s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002274s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000848s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000766s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000848s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000948s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000800s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000751s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000731s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000736s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000743s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000725s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000742s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000983s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000778s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000794s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000883s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000775s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000903s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000754s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000779s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000742s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000856s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000814s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000693s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000695s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000696s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000722s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000651s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000727s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000782s ]
select * from `xms_document` where `id` = 345 limit 1 [ runtime:0.000820s ]
select * from `xms_document` where `id` = 345 limit 1 [ runtime:0.000861s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 345 limit 1 [ runtime:0.000517s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000476s ]
(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=33 order by id asc,sortid desc ) as t1 where id = 345) [ runtime:0.001844s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=33 order by id asc,sortid desc) as t1 where rownum =5) [ runtime:0.002196s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000887s ]
show full columns from `xms_pagemodel` [ runtime:0.000898s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000510s ]
select * from `xms_document` where `id` = 345 limit 1 [ runtime:0.000754s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 345 limit 1 [ runtime:0.000554s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000465s ]
(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=33 order by id asc,sortid desc ) as t1 where id = 345) [ runtime:0.001752s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=33 order by id asc,sortid desc) as t1 where rownum =5) [ runtime:0.002190s ]
select * from `xms_document` where `id` = 345 limit 1 [ runtime:0.000863s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 345 limit 1 [ runtime:0.000690s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000422s ]
(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=33 order by id asc,sortid desc ) as t1 where id = 345) [ runtime:0.001858s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=33 order by id asc,sortid desc) as t1 where rownum =5) [ runtime:0.002274s ]
select * from `xms_document` where `id` = 345 limit 1 [ runtime:0.000855s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 345 limit 1 [ runtime:0.000553s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000610s ]
(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=33 order by id asc,sortid desc ) as t1 where id = 345) [ runtime:0.001753s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=33 order by id asc,sortid desc) as t1 where rownum =7) [ runtime:0.002254s ]
select * from `xms_document` where `id` = 345 limit 1 [ runtime:0.000797s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 345 limit 1 [ runtime:0.000626s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000445s ]
(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=33 order by id asc,sortid desc ) as t1 where id = 345) [ runtime:0.001946s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=33 order by id asc,sortid desc) as t1 where rownum =7) [ runtime:0.002069s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000805s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000865s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000558s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001122s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000577s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001260s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000696s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000534s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000740s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000504s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000660s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000500s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000592s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001386s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000782s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000722s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000631s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000549s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000786s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.001212s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000795s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000695s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000531s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001167s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000651s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000473s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000513s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000400s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000620s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000654s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000757s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000611s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000570s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000564s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000572s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000589s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000610s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000646s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000641s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000591s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000576s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000554s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000621s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000563s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000550s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000550s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000595s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000519s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001474s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002144s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002051s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002070s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000618s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000395s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002054s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000683s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000437s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001957s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000803s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000402s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001947s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000573s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000361s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001932s ]
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.002014s ]