show full columns from `xms_category` [ runtime:0.001202s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000851s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000647s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000748s ]
show full columns from `xms_site` [ runtime:0.000841s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000561s ]
show full columns from `xms_document` [ runtime:0.001296s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000542s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000428s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001004s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002008s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000761s ]
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.000745s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000626s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000594s ]
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.000605s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000562s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000603s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000675s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000637s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) 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.000565s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000577s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000584s ]
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.000683s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000570s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000568s ]
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=43 ) order by sortid asc [ runtime:0.000780s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000584s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001918s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002049s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002074s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002066s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001929s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002063s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000866s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000598s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000612s ]
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.000665s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000596s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000602s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000568s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000587s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000611s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000674s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000598s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) 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.000736s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000678s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000727s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000723s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000567s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000796s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000652s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000564s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000470s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000416s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000565s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000498s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000536s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000696s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000625s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000373s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000329s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 225) [ runtime:0.001740s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.002064s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000662s ]
show full columns from `xms_pagemodel` [ runtime:0.000707s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000408s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000596s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000413s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000333s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 225) [ runtime:0.001557s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001924s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000808s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000522s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 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=34 order by id asc,sortid desc ) as t1 where id = 225) [ runtime:0.001615s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001906s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000679s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000405s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 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=34 order by id asc,sortid desc ) as t1 where id = 225) [ runtime:0.001570s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001983s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000727s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000413s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000526s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000380s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000332s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 225) [ runtime:0.001594s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001912s ]
select * from `xms_document` where `id` = 225 limit 1 [ runtime:0.000680s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 225 limit 1 [ runtime:0.000419s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000349s ]
(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=34 order by id asc,sortid desc ) as t1 where id = 225) [ runtime:0.001757s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=34 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001911s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000797s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000632s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000442s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000989s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000443s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001027s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000614s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000450s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000559s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000467s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000548s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000374s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000350s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000961s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000595s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000393s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000499s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000375s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000337s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000979s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000586s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000354s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000327s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001002s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000663s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000365s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000479s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000360s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000611s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000584s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000833s ]
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=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.000699s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000760s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000565s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000611s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000803s ]
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=20 ) order by sortid asc [ runtime:0.000595s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) 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.000928s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000569s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000727s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000526s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000547s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000747s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001461s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002005s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001941s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002019s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000651s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000530s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001905s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000711s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000329s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001949s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000636s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000373s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001902s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000630s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000392s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001876s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002000s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002011s ]
