show full columns from `xms_category` [ runtime:0.001183s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000729s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000708s ]
select * from `xms_category` where `id` = 43 limit 1 [ runtime:0.000544s ]
show full columns from `xms_site` [ runtime:0.000917s ]
select * from `xms_site` where `id` = 1 limit 1 [ runtime:0.000542s ]
show full columns from `xms_document` [ runtime:0.001076s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000551s ]
select `id`,`title`,`seotitle`,`seokeywords`,`seodescription` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000374s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000864s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002207s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000751s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000694s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000749s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000777s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000894s ]
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.000711s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000785s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000734s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000751s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000742s ]
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.000746s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000751s ]
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=38 ) order by sortid asc [ runtime:0.000685s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000726s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000742s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000723s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000717s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000666s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.001952s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002196s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002048s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002051s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002121s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002052s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=0 ) order by sortid asc [ runtime:0.000872s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=17 ) order by sortid asc [ runtime:0.000760s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000751s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000706s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000886s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000761s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000858s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000708s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000648s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000621s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000647s ]
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=20 ) order by sortid asc [ runtime:0.000658s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000703s ]
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.000644s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000652s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000672s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000630s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000667s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000775s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_category` where `id` = 43 limit 1 [ runtime:0.000484s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000563s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000461s ]
select * from `xms_category` where `id` = 43 limit 1 [ runtime:0.000546s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000487s ]
select * from `xms_category` where `id` = 43 limit 1 [ runtime:0.000453s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000452s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000460s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000574s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000537s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000536s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.002075s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000590s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000388s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000348s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004502s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =1) [ runtime:0.004841s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000629s ]
show full columns from `xms_pagemodel` [ runtime:0.000891s ]
select * from `xms_pagemodel` where `id` = 20 limit 1 [ runtime:0.000481s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000582s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000401s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000392s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004405s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =1) [ runtime:0.004915s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000779s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000491s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000388s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004419s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =1) [ runtime:0.004712s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000754s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000520s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000443s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004494s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =1) [ runtime:0.005217s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000762s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000831s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000429s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004478s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =3) [ runtime:0.005013s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000720s ]
select * from `xms_pagemodel` where `id` = 20 limit 1 [ runtime:0.000492s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000645s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000819s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004742s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =3) [ runtime:0.004997s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000717s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000468s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000339s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004468s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =3) [ runtime:0.005206s ]
select * from `xms_document` where `id` = 353 limit 1 [ runtime:0.000897s ]
select `id`,`catid`,`sortid`,`createtime` from `xms_document` where `id` = 353 limit 1 [ runtime:0.000384s ]
select `id`,`title`,`orderby`,`suborderby` from `xms_category` where `id` = 59 limit 1 [ runtime:0.000338s ]
(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=59 order by createtime desc,sortid desc ) as t1 where id = 353) [ runtime:0.004539s ]
(select * from (select (@i :=@i 1) as rownum,a.* from (select @i := 0) as it, xms_document as a where states=1 and catid=59 order by createtime desc,sortid desc) as t1 where rownum =3) [ runtime:0.004922s ]
select * from `xms_category` where `id` = 59 limit 1 [ runtime:0.000664s ]
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.000527s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000578s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000791s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=23 ) order by sortid asc [ runtime:0.000854s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=19 ) order by sortid asc [ runtime:0.000630s ]
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.000613s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) order by sortid asc [ runtime:0.000634s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=21 ) 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.000709s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000590s ]
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.000553s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=20 ) order by sortid asc [ runtime:0.000646s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=37 ) order by sortid asc [ runtime:0.000788s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=38 ) order by sortid asc [ runtime:0.000731s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=71 ) order by sortid asc [ runtime:0.000630s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=43 ) order by sortid asc [ runtime:0.000558s ]
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.000540s ]
select * from `xms_category` where ( states=1 and isnav=1 and pid=22 ) order by sortid asc [ runtime:0.000553s ]
select * from `xms_document` where ( catid='87' and states=1 ) order by `id` desc limit 1 [ runtime:0.001670s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002035s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002100s ]
select * from `xms_document` where ( catid='62' and states=1 ) order by `id` desc limit 1 [ runtime:0.002154s ]
select * from `xms_category` where `id` = 62 limit 1 [ runtime:0.000632s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000389s ]
select * from `xms_document` where ( catid='63' and states=1 ) order by `id` desc limit 1 [ runtime:0.002063s ]
select * from `xms_category` where `id` = 63 limit 1 [ runtime:0.000591s ]
select * from `xms_pagemodel` where `id` = 27 limit 1 [ runtime:0.000394s ]
select * from `xms_document` where ( catid='64' and states=1 ) order by `id` desc limit 1 [ runtime:0.001944s ]
select * from `xms_category` where `id` = 64 limit 1 [ runtime:0.000757s ]
select * from `xms_pagemodel` where `id` = 29 limit 1 [ runtime:0.000590s ]
select * from `xms_document` where ( catid='45' and states=1 ) order by `id` desc limit 1 [ runtime:0.002037s ]
select * from `xms_category` where `id` = 45 limit 1 [ runtime:0.000750s ]
select * from `xms_pagemodel` where `id` = 23 limit 1 [ runtime:0.000371s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002046s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002122s ]
select * from `xms_document` where ( catid='65' and states=1 ) order by `id` desc limit 1 [ runtime:0.002198s ]