show full columns from `xms_category` [ runtime:0.001165s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000865s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.001052s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.001125s ]
show full columns from `xms_site` [ runtime:0.001066s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000547s ]
show full columns from `xms_document` [ runtime:0.001015s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000519s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000400s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000971s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002169s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000815s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000666s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000683s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000804s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000653s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000712s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000605s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000613s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000676s ]
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.000695s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000696s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000735s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000619s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000737s ]
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.000697s ]
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.000635s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000605s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002072s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001950s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002067s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002093s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002106s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001941s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000810s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000813s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000812s ]
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=19 ) order by sortid asc [ runtime:0.000613s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000620s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000642s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000607s ]
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.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000590s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000573s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000565s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000572s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000683s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000721s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000801s ]
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.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000550s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000514s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000705s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000461s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000436s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000573s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000565s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000552s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000563s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000641s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000552s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000352s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000342s ]
(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 = 343) [ runtime:0.001634s ]
(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.002116s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000588s ]
show full columns from `xms_pagemodel` [ runtime:0.000730s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000425s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000537s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000359s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 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=33 order by id asc,sortid desc ) as t1 where id = 343) [ runtime:0.001730s ]
(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.001990s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000668s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000716s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000351s ]
(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 = 343) [ runtime:0.001577s ]
(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.001933s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000660s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000364s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000326s ]
(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 = 343) [ runtime:0.001625s ]
(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 =5) [ runtime:0.001977s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000595s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000501s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000508s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000365s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000318s ]
(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 = 343) [ runtime:0.001668s ]
(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 =5) [ runtime:0.001959s ]
select * from `xms_document` where `id` = 343 limit 1 [ runtime:0.000658s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 343 limit 1 [ runtime:0.000417s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000339s ]
(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 = 343) [ runtime:0.001685s ]
(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 =5) [ runtime:0.001920s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000601s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000641s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000403s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000928s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000502s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001018s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000618s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000417s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000504s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000340s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000507s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000327s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000363s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001196s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000553s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000375s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000451s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000362s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000314s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000962s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000575s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000480s ]
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.001035s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000550s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000371s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000443s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000347s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000555s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000542s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000561s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000552s ]
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=19 ) order by sortid asc [ runtime:0.000687s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) 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.000715s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000720s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) 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.000565s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000602s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000530s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000548s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000555s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000511s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) 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.000592s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000615s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000708s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000489s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001513s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002032s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001985s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002099s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000608s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000467s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001948s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000586s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000375s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001831s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000631s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000389s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001895s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000646s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000368s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001898s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001894s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001976s ]
