show full columns from `xms_category` [ runtime:0.001200s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000802s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000714s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000621s ]
show full columns from `xms_site` [ runtime:0.001035s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000521s ]
show full columns from `xms_document` [ runtime:0.001020s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 347 limit 1 [ runtime:0.000565s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000444s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001098s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002262s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000687s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000860s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000644s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000762s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000788s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000560s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000549s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000519s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000496s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000619s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000569s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000611s ]
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=37 ) order by sortid asc [ runtime:0.000823s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000654s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000619s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000609s ]
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=43 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001872s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002155s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001969s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002071s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002154s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002109s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000712s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) 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.000595s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000621s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000598s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000571s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000637s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) 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.000603s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000563s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) 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.000589s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000566s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000709s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000692s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000713s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000642s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000610s ]
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=22 ) order by sortid asc [ runtime:0.000509s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000482s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000436s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000469s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000567s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000647s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000606s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000595s ]
select * from `xms_document` where `id` = 347 limit 1 [ runtime:0.000590s ]
select * from `xms_document` where `id` = 347 limit 1 [ runtime:0.000576s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 347 limit 1 [ runtime:0.000388s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000321s ]
(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 = 347) [ runtime:0.001753s ]
(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.001989s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000722s ]
show full columns from `xms_pagemodel` [ runtime:0.000836s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000418s ]
select * from `xms_document` where `id` = 347 limit 1 [ runtime:0.000504s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 347 limit 1 [ runtime:0.000395s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000372s ]
(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 = 347) [ runtime:0.001634s ]
(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.001968s ]
select * from `xms_document` where `id` = 347 limit 1 [ runtime:0.000736s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 347 limit 1 [ runtime:0.000420s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000354s ]
(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 = 347) [ runtime:0.001622s ]
(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.001908s ]
select * from `xms_document` where `id` = 347 limit 1 [ runtime:0.000692s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 347 limit 1 [ runtime:0.000394s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000369s ]
(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 = 347) [ runtime:0.001612s ]
(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 =8) [ runtime:0.001939s ]
select * from `xms_document` where `id` = 347 limit 1 [ runtime:0.000640s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 347 limit 1 [ runtime:0.000474s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000354s ]
(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 = 347) [ runtime:0.001656s ]
(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 =8) [ runtime:0.001916s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000687s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000644s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000440s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000926s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000523s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001194s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000678s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000418s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000504s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000699s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000658s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000385s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000325s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000972s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000581s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000390s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000453s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000526s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000395s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000932s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000576s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000365s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000306s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000964s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000695s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000424s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000450s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000530s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000753s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000531s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000686s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000581s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000511s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000570s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) 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.000563s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000606s ]
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.000598s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000618s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000643s ]
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=37 ) order by sortid asc [ runtime:0.000587s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000540s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000613s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000646s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000551s ]
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=22 ) order by sortid asc [ runtime:0.000626s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001567s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002058s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001827s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.001990s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000556s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000401s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001951s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000649s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000376s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001853s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000554s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000417s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002095s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000591s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000382s ]
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.002150s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001885s ]
