show full columns from `xms_category` [ runtime:0.001233s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000924s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000784s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000691s ]
show full columns from `xms_site` [ runtime:0.001070s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000586s ]
show full columns from `xms_document` [ runtime:0.001175s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000595s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000427s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000919s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002034s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000803s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000806s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000749s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000768s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000806s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000796s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000854s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000823s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000920s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000875s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000800s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000879s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000816s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000986s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000782s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000778s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000783s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000781s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000752s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000839s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000859s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000787s ]
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.002112s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002099s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002014s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002017s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002014s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000863s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000794s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000781s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000889s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000791s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000871s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000811s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000863s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000831s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000783s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000780s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000827s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.001155s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000893s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000880s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000858s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000896s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000847s ]
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.000802s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000787s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000749s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000768s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000661s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000679s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000845s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000670s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000651s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000792s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000835s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000823s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000538s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000489s ]
(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 = 332) [ runtime:0.002114s ]
(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 =4) [ runtime:0.002396s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000859s ]
show full columns from `xms_pagemodel` [ runtime:0.000942s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000558s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000791s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000612s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000528s ]
(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 = 332) [ runtime:0.002065s ]
(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 =4) [ runtime:0.002483s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000912s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000583s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000657s ]
(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 = 332) [ runtime:0.001946s ]
(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 =4) [ runtime:0.002458s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000886s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000744s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000619s ]
(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 = 332) [ runtime:0.001927s ]
(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.002295s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000797s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000514s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000809s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000534s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000532s ]
(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 = 332) [ runtime:0.001972s ]
(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.002474s ]
select * from `xms_document` where `id` = 332 limit 1 [ runtime:0.000939s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 332 limit 1 [ runtime:0.000615s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000487s ]
(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 = 332) [ runtime:0.001985s ]
(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.002174s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000884s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000918s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000617s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001239s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000651s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001314s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000750s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000518s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000702s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000556s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000661s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000512s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000511s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001257s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000763s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000532s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000687s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000617s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000515s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.001223s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000794s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000532s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000450s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001237s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000750s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000549s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000690s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000507s ]
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 ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000751s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000765s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000806s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000930s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000882s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000798s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000806s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000813s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000759s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000852s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000783s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000814s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000791s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000777s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000850s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000775s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000780s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000848s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000800s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000897s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000803s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001844s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002307s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002202s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002390s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000765s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000567s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002327s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000779s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000553s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.002459s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000828s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000577s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001995s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000730s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000674s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002257s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002434s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002277s ]
