show full columns from `xms_category` [ runtime:0.001131s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000731s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000706s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000519s ]
show full columns from `xms_site` [ runtime:0.000916s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000596s ]
show full columns from `xms_document` [ runtime:0.001097s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000608s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000380s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000864s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002221s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000731s ]
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.000696s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000768s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000703s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000654s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000581s ]
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.000603s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000579s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000834s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000644s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000779s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000709s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000632s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000753s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000597s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000591s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) 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.000555s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002052s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002000s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002078s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002001s ]
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='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001954s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000767s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000604s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000616s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000761s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000692s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000621s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000596s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000629s ]
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=20 ) order by sortid asc [ runtime:0.000655s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000601s ]
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.000675s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000595s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000774s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000704s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000606s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000816s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000671s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000658s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000567s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000529s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000532s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000484s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000675s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000630s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000583s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000398s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000336s ]
(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 = 271) [ runtime:0.001644s ]
(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 =3) [ runtime:0.001956s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000632s ]
show full columns from `xms_pagemodel` [ runtime:0.000784s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000437s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000787s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000537s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000355s ]
(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 = 271) [ runtime:0.001666s ]
(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 =3) [ runtime:0.001904s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000690s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000425s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000352s ]
(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 = 271) [ runtime:0.001586s ]
(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 =3) [ runtime:0.001923s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000708s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000457s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000449s ]
(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 = 271) [ runtime:0.001583s ]
(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 =5) [ runtime:0.001954s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000682s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000386s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000536s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000372s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000370s ]
(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 = 271) [ runtime:0.001614s ]
(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 =5) [ runtime:0.001951s ]
select * from `xms_document` where `id` = 271 limit 1 [ runtime:0.000714s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 271 limit 1 [ runtime:0.000396s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000349s ]
(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 = 271) [ runtime:0.001754s ]
(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 =5) [ runtime:0.002021s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000650s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000642s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000422s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000924s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000446s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001075s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000573s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000393s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000462s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000417s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000430s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000362s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000343s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001159s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000599s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000584s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000624s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000391s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000332s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000949s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000478s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000339s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000357s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000907s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000651s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000318s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000479s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000353s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000576s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000550s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000620s ]
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.000642s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000602s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000581s ]
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=21 ) order by sortid asc [ runtime:0.000562s ]
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.000558s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000563s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000581s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000811s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000606s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000805s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000518s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000565s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000526s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000529s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000533s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001499s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002142s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002178s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.001952s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000623s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000401s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001891s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000714s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000445s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001987s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000570s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000373s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002037s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000628s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000372s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002042s ]
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='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002023s ]
