show full columns from `xms_category` [ runtime:0.001172s ]
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.000747s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000538s ]
show full columns from `xms_site` [ runtime:0.000865s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000697s ]
show full columns from `xms_document` [ runtime:0.001187s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000486s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000384s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000880s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001983s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001034s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000775s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000652s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000810s ]
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.000663s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000583s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) 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.000643s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000618s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000747s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000594s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000576s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000575s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000575s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000687s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000644s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000553s ]
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=22 ) order by sortid asc [ runtime:0.000527s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001944s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002081s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002083s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002068s ]
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.002231s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000864s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000642s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000775s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000676s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000650s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000615s ]
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.000590s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000571s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000657s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000625s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000891s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000806s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000686s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000793s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000826s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000753s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000732s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000689s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000692s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000681s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000643s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000577s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000605s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000569s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000698s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000625s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000560s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000714s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000675s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000716s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000461s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000386s ]
(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 = 325) [ runtime:0.001702s ]
(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.001932s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000692s ]
show full columns from `xms_pagemodel` [ runtime:0.000903s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000480s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000684s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000468s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000405s ]
(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 = 325) [ runtime:0.001683s ]
(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.001929s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000740s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000521s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000394s ]
(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 = 325) [ runtime:0.001673s ]
(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.002053s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000756s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000471s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000399s ]
(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 = 325) [ runtime:0.001655s ]
(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 =6) [ runtime:0.001912s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000638s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000430s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000661s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000464s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000409s ]
(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 = 325) [ runtime:0.001648s ]
(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 =6) [ runtime:0.001923s ]
select * from `xms_document` where `id` = 325 limit 1 [ runtime:0.000692s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 325 limit 1 [ runtime:0.000475s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000417s ]
(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 = 325) [ runtime:0.001672s ]
(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 =6) [ runtime:0.001899s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000726s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000728s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000469s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001089s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000479s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001144s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000647s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000440s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000597s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000407s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000540s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000471s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000432s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001117s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000618s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000536s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000612s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000426s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000418s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.001064s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000620s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000456s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000413s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001119s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000620s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000451s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000585s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000488s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000701s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000689s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000684s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000695s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) 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.000707s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000706s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000744s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000754s ]
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=21 ) order by sortid asc [ runtime:0.000731s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000758s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000745s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000732s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000737s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000718s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000697s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000688s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000691s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000683s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000694s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000827s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001536s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001988s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001974s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002016s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000654s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000484s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002026s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000664s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000451s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001893s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000691s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000431s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001973s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000645s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000434s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001880s ]
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.001951s ]
