show full columns from `xms_category` [ runtime:0.001313s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000907s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000808s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000656s ]
show full columns from `xms_site` [ runtime:0.001083s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000604s ]
show full columns from `xms_document` [ runtime:0.001275s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000625s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000510s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.001072s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002324s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000785s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000634s ]
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.000558s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000590s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000614s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000582s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000577s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000580s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000559s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000584s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000591s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000579s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000671s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000629s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000578s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000624s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000574s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000569s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000638s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001903s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002139s ]
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.002047s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002135s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001976s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000798s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000637s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000688s ]
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.000634s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000600s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000601s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000588s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000681s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000627s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000630s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000607s ]
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.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000627s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000933s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000562s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000952s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000894s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000560s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000560s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000624s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000590s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000623s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000489s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000566s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000528s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000402s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000635s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000552s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000655s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000380s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000328s ]
(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 = 327) [ runtime:0.001856s ]
(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.002140s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000678s ]
show full columns from `xms_pagemodel` [ runtime:0.000727s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000471s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000515s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000370s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000343s ]
(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 = 327) [ runtime:0.001902s ]
(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.002017s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000753s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000481s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000368s ]
(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 = 327) [ runtime:0.001754s ]
(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.002016s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000679s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000371s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000337s ]
(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 = 327) [ runtime:0.001825s ]
(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 =8) [ runtime:0.002010s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000592s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000384s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000607s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000312s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000323s ]
(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 = 327) [ runtime:0.001800s ]
(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 =8) [ runtime:0.002046s ]
select * from `xms_document` where `id` = 327 limit 1 [ runtime:0.000697s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 327 limit 1 [ runtime:0.000405s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000377s ]
(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 = 327) [ runtime:0.001742s ]
(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 =8) [ runtime:0.002148s ]
select * from `xms_category` where `id` = 19 limit 1 [ runtime:0.000745s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000667s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 82 limit 1 [ runtime:0.000405s ]
select * from `xms_document` where `catid` = '82' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000981s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 32 limit 1 [ runtime:0.000496s ]
select * from `xms_document` where `catid` = '32' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` asc limit 100 [ runtime:0.000940s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000729s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000319s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000496s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000347s ]
select * from `xms_category` where `id` = 32 limit 1 [ runtime:0.000405s ]
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.000363s ]
select * from `xms_document` where `catid` = '34' and `isrecommend` = 1 and `states` = 1 order by `sortid` asc,`sortid` asc limit 100 [ runtime:0.000882s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000620s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000521s ]
select * from `xms_category` where `id` = 34 limit 1 [ runtime:0.000535s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000341s ]
select `id`,`pid`,`orderby`,`suborderby` from `xms_category` where `id` = 89 limit 1 [ runtime:0.000388s ]
select * from `xms_document` where `catid` = '89' and `isrecommend` = 1 and `states` = 1 order by `sortid` desc,`sortid` desc limit 100 [ runtime:0.000927s ]
select * from `xms_category` where `id` = 89 limit 1 [ runtime:0.000533s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000427s ]
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.000888s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000545s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000348s ]
select * from `xms_category` where `id` = 33 limit 1 [ runtime:0.000418s ]
select * from `xms_pagemodel` where `id` = 7 limit 1 [ runtime:0.000306s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000548s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000616s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000555s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000589s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000607s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000593s ]
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=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.000609s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000901s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000617s ]
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.000597s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000641s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000838s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000640s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000596s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000502s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000546s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000521s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000516s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001568s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002025s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001916s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002103s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000584s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000386s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.001865s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000591s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000341s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001777s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000642s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000360s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.001883s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000538s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000399s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001791s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001945s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001985s ]
