SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.001417s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001190s ]
SELECT * FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.001109s ]
SELECT * FROM `xms_category` WHERE `id` = 37 LIMIT 1 [ RunTime:0.000719s ]
SELECT * FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000782s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.001160s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000825s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.001366s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000830s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000512s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001044s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002312s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001239s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.001045s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001012s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000887s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000907s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000963s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001173s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001000s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.001259s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.000860s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.000817s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001188s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001082s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.001298s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001169s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.001230s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.000972s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.000931s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.001171s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.000967s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.000982s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.000884s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002989s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002441s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002287s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002940s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003118s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002949s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001101s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.000922s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000904s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001252s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000983s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000937s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000959s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001101s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.000985s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.001125s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.001334s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001000s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001141s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.001402s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001030s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.000890s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.001187s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.000835s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.001058s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.000962s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.000762s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.000801s ]
SELECT * FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.000742s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.000971s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.000743s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.000952s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.000910s ]
SELECT * FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000816s ]
SELECT * FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000763s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000657s ]
(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=88 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 338) [ RunTime:0.002654s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=88 ORDER BY sortid desc,sortid desc) AS t1 WHERE rownum =1) [ RunTime:0.003002s ]
SELECT * FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000953s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.001110s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000688s ]
SELECT * FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000487s ]
(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=88 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 338) [ RunTime:0.001875s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=88 ORDER BY sortid desc,sortid desc) AS t1 WHERE rownum =1) [ RunTime:0.002318s ]
SELECT * FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.001056s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000805s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000810s ]
(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=88 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 338) [ RunTime:0.001901s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=88 ORDER BY sortid desc,sortid desc) AS t1 WHERE rownum =1) [ RunTime:0.002431s ]
SELECT * FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.001066s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000810s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000684s ]
(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=88 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 338) [ RunTime:0.002668s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=88 ORDER BY sortid desc,sortid desc) AS t1 WHERE rownum =3) [ RunTime:0.002994s ]
SELECT * FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.001467s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 338 LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000640s ]
(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=88 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 338) [ RunTime:0.002530s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=88 ORDER BY sortid desc,sortid desc) AS t1 WHERE rownum =3) [ RunTime:0.002759s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 89 LIMIT 1 [ RunTime:0.000775s ]
SELECT * FROM `xms_document` WHERE `catid` = '89' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` DESC,`sortid` DESC LIMIT 100 [ RunTime:0.001708s ]
SELECT * FROM `xms_category` WHERE `id` = 89 LIMIT 1 [ RunTime:0.000888s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000665s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001002s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.000812s ]
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=23 ) ORDER BY sortid asc [ RunTime:0.000787s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.000958s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000735s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.000931s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001067s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.000814s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.000696s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.001039s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.000874s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.000705s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.000947s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001139s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.000781s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.000811s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.000795s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.000735s ]
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.000864s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.000677s ]
SELECT * FROM `xms_document` WHERE ( catid='87' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001810s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002726s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003174s ]
SELECT * FROM `xms_document` WHERE ( catid='62' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003099s ]
SELECT * FROM `xms_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.001315s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000568s ]
SELECT * FROM `xms_document` WHERE ( catid='63' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002318s ]
SELECT * FROM `xms_category` WHERE `id` = 63 LIMIT 1 [ RunTime:0.000748s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000672s ]
SELECT * FROM `xms_document` WHERE ( catid='64' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002451s ]
SELECT * FROM `xms_category` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000801s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000555s ]
SELECT * FROM `xms_document` WHERE ( catid='45' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002512s ]
SELECT * FROM `xms_category` WHERE `id` = 45 LIMIT 1 [ RunTime:0.000701s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000892s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002231s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002630s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002291s ]
