show full columns from `xms_category` [ runtime:0.001548s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001332s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000889s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000999s ]
show full columns from `xms_site` [ runtime:0.001327s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000716s ]
show full columns from `xms_document` [ runtime:0.001550s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 91 limit 1 [ runtime:0.000618s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000592s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001223s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.003037s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000846s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000747s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000758s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000780s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000788s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000859s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.001390s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.001015s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000877s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.001044s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.001672s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000953s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000852s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000925s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.001008s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.001197s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000946s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000797s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000867s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000844s ]
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=22 ) order by sortid asc [ runtime:0.000839s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002316s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002260s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002057s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002095s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002482s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002507s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000748s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000648s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000586s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000860s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000659s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000740s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000824s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000747s ]
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.000596s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000585s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000620s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000586s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000621s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000558s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000614s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000602s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000649s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000577s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000627s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000513s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000484s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000426s ]
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 `id` = 33 limit 1 [ runtime:0.000610s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000471s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000572s ]
select * from `xms_document` where `id` = 91 limit 1 [ runtime:0.000580s ]
select * from `xms_document` where `id` = 91 limit 1 [ runtime:0.000686s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 91 limit 1 [ runtime:0.000615s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000458s ]
(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 = 91) [ runtime:0.001729s ]
(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 =0) [ runtime:0.001961s ]
select * from `xms_document` where `id` = 91 limit 1 [ runtime:0.000757s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 91 limit 1 [ runtime:0.000436s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000394s ]
(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 = 91) [ runtime:0.001923s ]
(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 =0) [ runtime:0.002099s ]
select * from `xms_document` where `id` = 91 limit 1 [ runtime:0.000714s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 91 limit 1 [ runtime:0.000448s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000363s ]
(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 = 91) [ runtime:0.001651s ]
(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 =2) [ runtime:0.002113s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000633s ]
show full columns from `xms_pagemodel` [ runtime:0.000706s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000421s ]
select * from `xms_document` where `id` = 91 limit 1 [ runtime:0.000556s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 91 limit 1 [ runtime:0.000361s ]
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 = 91) [ runtime:0.001659s ]
(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 =2) [ runtime:0.001950s ]
select * from `xms_document` where `id` = 91 limit 1 [ runtime:0.000681s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 91 limit 1 [ runtime:0.000458s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 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=33 order by id asc,sortid desc ) as t1 where id = 91) [ runtime:0.001635s ]
(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 =2) [ runtime:0.001981s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000680s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000699s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000453s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000986s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000435s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.000972s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000635s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000434s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000472s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000365s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000461s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000354s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000351s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001018s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000716s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000452s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000496s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000328s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000328s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.001044s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000547s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000392s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000383s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001009s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000583s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000350s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000458s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000333s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000667s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000645s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000579s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000668s ]
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=21 ) order by sortid asc [ runtime:0.000626s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000601s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000606s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000593s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000566s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000648s ]
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=37 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000593s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000601s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000546s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000599s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001497s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001989s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002071s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002056s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000643s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000411s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002091s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000622s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000386s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.002040s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000584s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000365s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001980s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000613s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000399s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001917s ]
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='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002142s ]
