SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.024706s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.245210s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.012062s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.006544s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006230s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.023448s ]
SELECT * FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.012205s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.006139s ]
UPDATE `xms_document` SET `clickcount` = `clickcount` + 1 WHERE `id` = 5175 [ RunTime:0.080275s ]
SELECT * FROM `xms_document` WHERE ( catid='70' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.030013s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006335s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.019940s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006179s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.021946s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006192s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.014128s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006093s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.042973s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006226s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc [ RunTime:0.252356s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006208s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc [ RunTime:0.029270s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006213s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc [ RunTime:0.243823s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006166s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.217855s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006151s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.026759s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.209714s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.022372s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006168s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.028356s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006208s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.026382s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006230s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.033733s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006241s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.031022s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006201s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.030994s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006172s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc [ RunTime:0.022873s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006254s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc [ RunTime:0.038512s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006288s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc [ RunTime:0.026274s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006207s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc [ RunTime:0.251698s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006224s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc [ RunTime:0.049689s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007342s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.023887s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006134s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.028147s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006217s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.036146s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006134s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.026229s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006177s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.025886s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006246s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.024342s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.012126s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.012240s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.012417s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.037637s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.270815s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.237093s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.040665s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.013558s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.012315s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.012344s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.012293s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.232283s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.247264s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.231683s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.031047s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.012650s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.012355s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY id asc [ RunTime:0.012233s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006355s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.440523s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY id asc [ RunTime:0.012174s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=104 ) ORDER BY id asc [ RunTime:0.012053s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006213s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.234476s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY id asc [ RunTime:0.026000s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006239s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.023925s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=18 ) ORDER BY id asc [ RunTime:0.012081s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=106 ) ORDER BY id asc [ RunTime:0.012164s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006205s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.023636s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.012173s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.023114s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.023336s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.012133s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.024128s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.643096s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.230959s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.039181s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.230701s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.012146s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.037229s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.231324s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.012366s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.449924s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.012337s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.012117s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.012317s ]
SELECT * FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.029112s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.012591s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=26 ) ORDER BY id asc [ RunTime:0.012422s ]
SELECT * FROM `xms_document` WHERE `id` = 548 AND `states` = 1 [ RunTime:0.028600s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.006309s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006252s ]
(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 = 5175) [ RunTime:0.020627s ]
(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 =49) [ RunTime:0.029015s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006698s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.006760s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.006199s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.006135s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006081s ]
(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 = 5175) [ RunTime:0.017007s ]
(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 =49) [ RunTime:0.030588s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.006319s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006340s ]
(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 = 5175) [ RunTime:0.021356s ]
(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 =51) [ RunTime:0.440532s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.012329s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.006294s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5175 LIMIT 1 [ RunTime:0.010224s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006339s ]
(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 = 5175) [ RunTime:0.021597s ]
(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 =51) [ RunTime:0.025657s ]
SELECT * FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.012411s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=75 ) ORDER BY id asc [ RunTime:0.027603s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.230951s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.039568s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.039647s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.027151s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.230743s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.025846s ]
官方商城
