show full columns from `xms_category` [ runtime:0.001087s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000758s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000734s ]
select * from `xms_category` where `id` = 18 limit 1 [ runtime:0.000571s ]
select * from `xms_category` where `id` = 23 limit 1 [ runtime:0.000617s ]
show full columns from `xms_site` [ runtime:0.001010s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000553s ]
show full columns from `xms_document` [ runtime:0.001258s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000549s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000439s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000821s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002188s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000891s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000633s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000849s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000732s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000755s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000732s ]
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 ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000620s ]
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=21 ) order by sortid asc [ runtime:0.000644s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) 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.000597s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000653s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000623s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000618s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000663s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000788s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000741s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000645s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000650s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000534s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002189s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002088s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002093s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002123s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002023s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002130s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000805s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000604s ]
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.000641s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000666s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000635s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000641s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000653s ]
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.000599s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000748s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000728s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000673s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000746s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000706s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000641s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000594s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000571s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000583s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000547s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where `id` = 23 limit 1 [ runtime:0.000488s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000533s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000453s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=18 ) order by sortid asc [ runtime:0.000591s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000510s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000459s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=18 ) order by sortid asc [ runtime:0.000573s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000584s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000619s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000401s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000351s ]
(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=25 order by id asc,sortid desc ) as t1 where id = 241) [ runtime:0.001614s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=25 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001928s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000698s ]
show full columns from `xms_pagemodel` [ runtime:0.000895s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000494s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000549s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000392s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000347s ]
(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=25 order by id asc,sortid desc ) as t1 where id = 241) [ runtime:0.001664s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=25 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001937s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000752s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000399s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000347s ]
(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=25 order by id asc,sortid desc ) as t1 where id = 241) [ runtime:0.001636s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=25 order by id asc,sortid desc) as t1 where rownum =2) [ runtime:0.001981s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000846s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000526s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000373s ]
(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=25 order by id asc,sortid desc ) as t1 where id = 241) [ runtime:0.001792s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=25 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.001941s ]
select * from `xms_category` where `id` = 25 limit 1 [ runtime:0.000826s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000481s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000593s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000402s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000355s ]
(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=25 order by id asc,sortid desc ) as t1 where id = 241) [ runtime:0.001606s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=25 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.002067s ]
select * from `xms_document` where `id` = 241 limit 1 [ runtime:0.000790s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 241 limit 1 [ runtime:0.000438s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 25 limit 1 [ runtime:0.000384s ]
(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=25 order by id asc,sortid desc ) as t1 where id = 241) [ runtime:0.001598s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=25 order by id asc,sortid desc) as t1 where rownum =4) [ runtime:0.002004s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000629s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000435s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001005s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000617s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.001152s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000532s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000387s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000510s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000370s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000479s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000397s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 34 limit 1 [ runtime:0.000440s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001050s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000598s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000387s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000502s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000397s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000462s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000971s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000598s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000388s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 33 limit 1 [ runtime:0.000362s ]
select * from `xms_document` where `catid` = '33' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.001058s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000585s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000417s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000521s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000397s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000612s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000591s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000614s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) 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.000669s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000696s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000677s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000631s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000715s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000645s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000851s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000654s ]
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.000645s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000654s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000602s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000718s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000946s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000639s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000782s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000642s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000549s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001616s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002097s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001953s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002108s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000661s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000396s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002127s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000660s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000430s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001972s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000648s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000472s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002007s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000595s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000412s ]
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.001988s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002140s ]
