show full columns from `xms_category` [ runtime:0.001203s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000803s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000802s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000583s ]
show full columns from `xms_site` [ runtime:0.000950s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000597s ]
show full columns from `xms_document` [ runtime:0.001141s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000581s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000438s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001103s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002263s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000885s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000655s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000698s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000825s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000649s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000706s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000682s ]
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 ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000774s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000802s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) 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.000672s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000636s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000676s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000710s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000760s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000659s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000641s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000654s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000782s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000660s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000637s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002181s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002048s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002265s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002125s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002105s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002134s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000780s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000690s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000649s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000717s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000615s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000713s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000732s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000761s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000645s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000703s ]
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=20 ) 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.000709s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000617s ]
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.000628s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000617s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000618s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) 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.000657s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000685s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000533s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000520s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000594s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000671s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000565s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000459s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000586s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000664s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000639s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000414s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000440s ]
(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 = 229) [ runtime:0.001803s ]
(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 =1) [ runtime:0.002175s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000640s ]
show full columns from `xms_pagemodel` [ runtime:0.000836s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000447s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000556s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000415s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000347s ]
(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 = 229) [ runtime:0.001797s ]
(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 =1) [ runtime:0.002052s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000644s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000396s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000546s ]
(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 = 229) [ runtime:0.001883s ]
(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 =1) [ runtime:0.002128s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000664s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000431s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000365s ]
(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 = 229) [ runtime:0.001974s ]
(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 =3) [ runtime:0.002218s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000653s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000491s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000537s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000379s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000380s ]
(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 = 229) [ runtime:0.001749s ]
(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 =3) [ runtime:0.002009s ]
select * from `xms_document` where `id` = 229 limit 1 [ runtime:0.000720s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 229 limit 1 [ runtime:0.000374s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000407s ]
(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 = 229) [ runtime:0.001859s ]
(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 =3) [ runtime:0.002071s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000740s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000831s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000472s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000981s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000439s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.000976s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000706s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000465s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000500s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000414s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000494s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000373s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000328s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000949s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000604s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000379s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000514s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000352s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000340s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000941s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000591s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000405s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000347s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000948s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000546s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000353s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000447s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000336s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000560s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000665s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000717s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000590s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000586s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000657s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000635s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000917s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000753s ]
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.000542s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000616s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000903s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000743s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000802s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000563s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) 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.000596s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000549s ]
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.002112s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002141s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002109s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000680s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000481s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001952s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000807s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000484s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.002102s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000620s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000424s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002228s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000542s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000465s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001890s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002021s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002069s ]
