SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.008070s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.008002s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007755s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.007838s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.007543s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.008081s ]
SELECT * FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.007909s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.007484s ]
UPDATE `xms_document` SET `clickcount` = `clickcount` + 1 WHERE `id` = 5198 [ RunTime:0.011534s ]
SELECT * FROM `xms_document` WHERE ( catid='70' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.020997s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.007444s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.012195s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.007390s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.012740s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007526s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.012817s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007509s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.012702s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007405s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc [ RunTime:0.023722s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007450s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc [ RunTime:0.024634s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007503s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc [ RunTime:0.028068s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.008776s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.014160s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007413s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.022768s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007521s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.019401s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007435s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.021616s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.007466s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.022754s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.007463s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.029016s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.008057s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.024042s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007496s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.024973s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007542s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc [ RunTime:0.023878s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007535s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc [ RunTime:0.024426s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007551s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc [ RunTime:0.023777s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007461s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc [ RunTime:0.022130s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007500s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc [ RunTime:0.026043s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007462s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.021501s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007563s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.008453s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.008723s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.022264s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007708s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.022059s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007446s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.025679s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007654s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.029921s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.008258s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.008186s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.218969s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.008200s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.007920s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.007978s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.008007s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.011562s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.044405s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.025582s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.014889s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.014780s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.014883s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.014786s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.014783s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.014767s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.014818s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY id asc [ RunTime:0.014819s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.007564s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.026503s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY id asc [ RunTime:0.014884s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=104 ) ORDER BY id asc [ RunTime:0.014825s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007588s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.242383s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY id asc [ RunTime:0.015066s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.007670s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.034204s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=18 ) ORDER BY id asc [ RunTime:0.014757s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=106 ) ORDER BY id asc [ RunTime:0.014656s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007497s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.029821s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.015863s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.014906s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.014995s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.014914s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.014955s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.015051s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.014937s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.014967s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.014909s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.014800s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.014906s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.014900s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.014887s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.014798s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.014846s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.014612s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.014673s ]
SELECT * FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.021924s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007758s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=26 ) ORDER BY id asc [ RunTime:0.007781s ]
SELECT * FROM `xms_document` WHERE `id` IN (548,889) AND `states` = 1 [ RunTime:0.014845s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.007494s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007412s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5198) [ RunTime:0.018044s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =41) [ RunTime:0.021526s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007603s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.007738s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.007416s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.007496s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007488s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5198) [ RunTime:0.018980s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =41) [ RunTime:0.021510s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.007499s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007467s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5198) [ RunTime:0.018867s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =43) [ RunTime:0.029473s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007737s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.007530s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5198 LIMIT 1 [ RunTime:0.007435s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007365s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5198) [ RunTime:0.019462s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =43) [ RunTime:0.027045s ]
SELECT * FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.007724s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=75 ) ORDER BY id asc [ RunTime:0.007830s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.007837s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.007705s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.007703s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.007739s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.007864s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.007734s ]
官方商城
