show full columns from `xms_category` [ runtime:0.001138s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000844s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000784s ]
select * from `xms_category` where `id` = 18 limit 1 [ runtime:0.000568s ]
select * from `xms_category` where `id` = 23 limit 1 [ runtime:0.000693s ]
show full columns from `xms_site` [ runtime:0.000969s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000482s ]
show full columns from `xms_document` [ runtime:0.001001s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000765s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000410s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000872s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002157s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000831s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000727s ]
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.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000689s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000778s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000670s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000791s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000713s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000690s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000677s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000664s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000991s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000650s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000639s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) 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.000611s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000629s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000634s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000597s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001992s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002157s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002167s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002064s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001922s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001943s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000951s ]
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.000615s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000682s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) 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.000665s ]
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.000694s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000633s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000615s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000613s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000608s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000707s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000597s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000599s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000625s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000601s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000586s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000826s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000616s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000599s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000555s ]
select * from `xms_category` where `id` = 23 limit 1 [ runtime:0.000759s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000502s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000454s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=18 ) order by sortid asc [ runtime:0.000555s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000553s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000453s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=18 ) order by sortid asc [ runtime:0.000541s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000565s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000583s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000381s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000324s ]
(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=24 order by id asc,sortid desc ) as t1 where id = 239) [ runtime:0.001823s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001844s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000642s ]
show full columns from `xms_pagemodel` [ runtime:0.000940s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000505s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000533s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000384s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 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=24 order by id asc,sortid desc ) as t1 where id = 239) [ runtime:0.001569s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001958s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000688s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000425s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000362s ]
(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=24 order by id asc,sortid desc ) as t1 where id = 239) [ runtime:0.001643s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001917s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000695s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000436s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000408s ]
(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=24 order by id asc,sortid desc ) as t1 where id = 239) [ runtime:0.001712s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001980s ]
select * from `xms_category` where `id` = 24 limit 1 [ runtime:0.000692s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000481s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000491s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000449s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000376s ]
(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=24 order by id asc,sortid desc ) as t1 where id = 239) [ runtime:0.001638s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001920s ]
select * from `xms_document` where `id` = 239 limit 1 [ runtime:0.000671s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 239 limit 1 [ runtime:0.000432s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 24 limit 1 [ runtime:0.000412s ]
(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=24 order by id asc,sortid desc ) as t1 where id = 239) [ runtime:0.001607s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=24 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001998s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000682s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000715s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000409s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000966s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000460s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001037s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000778s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000425s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000476s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000364s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000447s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000334s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000324s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001030s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000593s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000474s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000476s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000339s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000331s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000957s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000652s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000471s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000356s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001113s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000684s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000496s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000503s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000367s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000682s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000585s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000550s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000649s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000721s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000597s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000635s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000595s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000632s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000624s ]
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.000721s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000610s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000584s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000620s ]
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.000592s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000637s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001466s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002037s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002027s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002181s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000680s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000433s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001929s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000660s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000395s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001930s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000697s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000516s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002116s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000824s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000379s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002056s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002042s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001977s ]
