show full columns from `xms_category` [ runtime:0.001186s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000962s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000620s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000786s ]
show full columns from `xms_site` [ runtime:0.000906s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000493s ]
show full columns from `xms_document` [ runtime:0.001116s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000470s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000395s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000779s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002122s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000746s ]
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.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000579s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000715s ]
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.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000704s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000776s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000708s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000754s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) 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.000709s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000719s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000724s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000671s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000703s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000687s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000690s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000674s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000647s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000642s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001940s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001970s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001934s ]
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.002029s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002187s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000902s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000788s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000669s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000713s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000723s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000723s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000715s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000729s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000730s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000782s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000700s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000768s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000746s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000707s ]
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.000677s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000718s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000698s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000689s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000684s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000688s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000686s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000600s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000600s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000569s ]
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` = 32 limit 1 [ runtime:0.000622s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000577s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000694s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000672s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000674s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000443s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000581s ]
(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=32 order by sortid desc,sortid desc ) as t1 where id = 333) [ runtime:0.001894s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=32 order by sortid desc,sortid desc) as t1 where rownum =3) [ runtime:0.002127s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000672s ]
show full columns from `xms_pagemodel` [ runtime:0.000875s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000492s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000622s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000462s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000410s ]
(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=32 order by sortid desc,sortid desc ) as t1 where id = 333) [ runtime:0.001853s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=32 order by sortid desc,sortid desc) as t1 where rownum =3) [ runtime:0.002080s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000785s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000488s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000420s ]
(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=32 order by sortid desc,sortid desc ) as t1 where id = 333) [ runtime:0.001842s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=32 order by sortid desc,sortid desc) as t1 where rownum =3) [ runtime:0.002161s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000923s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000577s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000427s ]
(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=32 order by sortid desc,sortid desc ) as t1 where id = 333) [ runtime:0.001893s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=32 order by sortid desc,sortid desc) as t1 where rownum =5) [ runtime:0.002099s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000688s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000500s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000641s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000464s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000467s ]
(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=32 order by sortid desc,sortid desc ) as t1 where id = 333) [ runtime:0.001848s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=32 order by sortid desc,sortid desc) as t1 where rownum =5) [ runtime:0.002108s ]
select * from `xms_document` where `id` = 333 limit 1 [ runtime:0.000758s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 333 limit 1 [ runtime:0.000495s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000416s ]
(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=32 order by sortid desc,sortid desc ) as t1 where id = 333) [ runtime:0.001861s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=32 order by sortid desc,sortid desc) as t1 where rownum =5) [ runtime:0.002170s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000664s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000781s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000474s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001055s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000478s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001150s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000640s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000447s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000567s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000488s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000552s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000431s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000584s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001177s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000634s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000437s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000570s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000433s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000463s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.001077s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000623s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000450s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000430s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001133s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000617s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000445s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000569s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000491s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000724s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000695s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000711s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000724s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000697s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000744s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000724s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000812s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000787s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000706s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000719s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000758s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000740s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000725s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000714s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000766s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000711s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000724s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000699s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000737s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000717s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000658s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001559s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002035s ]
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='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002022s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000639s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000453s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001969s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000643s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000487s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001914s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000629s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000428s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001890s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000643s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000455s ]
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.002017s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001979s ]
