show full columns from `xms_category` [ runtime:0.001115s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000925s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000782s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000537s ]
show full columns from `xms_site` [ runtime:0.000877s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000564s ]
show full columns from `xms_document` [ runtime:0.001179s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 99 limit 1 [ runtime:0.000589s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000543s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000853s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002266s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000968s ]
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.000890s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000629s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000636s ]
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.000678s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000948s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000632s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000737s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000658s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) 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.000792s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000672s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000571s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000594s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000627s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000571s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000675s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000660s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001967s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002273s ]
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.002097s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002101s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002126s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000834s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000617s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000610s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000720s ]
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.000709s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000577s ]
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=21 ) order by sortid asc [ runtime:0.000569s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000608s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000680s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000690s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000559s ]
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.000579s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) 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.000585s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000675s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000572s ]
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.000576s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000562s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000805s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000625s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000544s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000442s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000567s ]
select * from `xms_document` where `id` = 99 limit 1 [ runtime:0.000601s ]
select * from `xms_document` where `id` = 99 limit 1 [ runtime:0.000553s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 99 limit 1 [ runtime:0.000358s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000414s ]
(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 = 99) [ runtime:0.001912s ]
(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 =13) [ runtime:0.002217s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000717s ]
show full columns from `xms_pagemodel` [ runtime:0.000859s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000400s ]
select * from `xms_document` where `id` = 99 limit 1 [ runtime:0.000596s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 99 limit 1 [ runtime:0.000385s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000322s ]
(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 = 99) [ runtime:0.001811s ]
(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 =13) [ runtime:0.002188s ]
select * from `xms_document` where `id` = 99 limit 1 [ runtime:0.000735s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 99 limit 1 [ runtime:0.000465s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000398s ]
(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 = 99) [ runtime:0.001860s ]
(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 =13) [ runtime:0.002153s ]
select * from `xms_document` where `id` = 99 limit 1 [ runtime:0.000665s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 99 limit 1 [ runtime:0.000424s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000544s ]
(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 = 99) [ 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=32 order by sortid desc,sortid desc) as t1 where rownum =15) [ runtime:0.002089s ]
select * from `xms_document` where `id` = 99 limit 1 [ runtime:0.000803s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 99 limit 1 [ runtime:0.000558s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 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=32 order by sortid desc,sortid desc ) as t1 where id = 99) [ runtime:0.001880s ]
(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 =15) [ runtime:0.002135s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000693s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000611s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000384s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000965s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000515s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001046s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000574s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000397s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000426s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000379s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000419s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000376s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000327s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000998s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000578s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000556s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000864s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000408s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000459s ]
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.000598s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000397s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000323s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000915s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000565s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000388s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000489s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000367s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000632s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000629s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000646s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000581s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000643s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000786s ]
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=19 ) order by sortid asc [ runtime:0.000628s ]
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=21 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000539s ]
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=20 ) order by sortid asc [ runtime:0.000798s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000605s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000546s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000632s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000518s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000527s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000586s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000639s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000536s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000520s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001466s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001972s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002068s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002057s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000667s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000389s ]
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.000647s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000448s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001947s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000577s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000367s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001949s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000629s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000346s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001851s ]
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.002125s ]