show full columns from `xms_category` [ runtime:0.000702s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000492s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000411s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000333s ]
show full columns from `xms_site` [ runtime:0.000506s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000290s ]
show full columns from `xms_document` [ runtime:0.000690s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000283s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000255s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000477s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000943s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000486s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000402s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000441s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000413s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000361s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000343s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000370s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000350s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000340s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000333s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000564s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000427s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000349s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000335s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000320s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000488s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000346s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000335s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000387s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000328s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000345s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000334s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000856s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000871s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000759s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000689s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000729s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000741s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000412s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000344s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000351s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000324s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000330s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000338s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000317s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000363s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000314s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000367s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000362s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000350s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000373s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000350s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000356s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000310s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000335s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000311s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000337s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000333s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000350s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000344s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000256s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000247s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000318s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000328s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000274s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000239s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000321s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000449s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000289s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000242s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000188s ]
(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 = 227) [ runtime:0.001198s ]
(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 =6) [ runtime:0.001241s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000326s ]
show full columns from `xms_pagemodel` [ runtime:0.000388s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000188s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000318s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000174s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000174s ]
(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 = 227) [ runtime:0.001080s ]
(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 =6) [ runtime:0.001184s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000318s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000179s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000172s ]
(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 = 227) [ runtime:0.001119s ]
(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 =6) [ runtime:0.001159s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000331s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000199s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000182s ]
(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 = 227) [ runtime:0.001063s ]
(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 =8) [ runtime:0.001161s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000311s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000197s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000308s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000194s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000174s ]
(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 = 227) [ runtime:0.001084s ]
(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 =8) [ runtime:0.001272s ]
select * from `xms_document` where `id` = 227 limit 1 [ runtime:0.000371s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 227 limit 1 [ runtime:0.000244s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000235s ]
(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 = 227) [ runtime:0.001103s ]
(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 =8) [ runtime:0.001285s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000355s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000399s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000236s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000667s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000255s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.000818s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000335s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000203s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000301s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000214s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000253s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000246s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000316s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000245s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000322s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000237s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000231s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000758s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000291s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000217s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000336s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000227s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000296s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000226s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000185s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000811s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000303s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000230s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000273s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000219s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000353s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000390s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000335s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000310s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000336s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000315s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000339s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000321s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000310s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000319s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000305s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000358s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000356s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000371s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000336s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000312s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000330s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000328s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000317s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000314s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000300s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000306s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.000526s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000771s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000703s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.000725s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000269s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000176s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.000685s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000281s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000184s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.000679s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000297s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000238s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.000803s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000275s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000187s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000679s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000702s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.000705s ]