SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.007232s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.007206s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007005s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.007308s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006811s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.007311s ]
SELECT * FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.007087s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.006635s ]
UPDATE `xms_document` SET `clickcount` = `clickcount` + 1 WHERE `id` = 5237 [ RunTime:0.012797s ]
SELECT * FROM `xms_document` WHERE ( catid='70' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.035715s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006776s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.011717s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006670s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.024618s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006757s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011583s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006657s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.014870s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006704s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc [ RunTime:0.032128s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006789s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc [ RunTime:0.026700s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006824s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc [ RunTime:0.047045s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006739s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.014938s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006751s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.023132s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006737s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.021510s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006754s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.028681s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006743s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.024365s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006780s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.025387s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007900s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.242205s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006846s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.025560s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006776s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc [ RunTime:0.027255s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006829s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc [ RunTime:0.042092s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006697s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc [ RunTime:0.023326s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006686s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc [ RunTime:0.024398s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006649s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc [ RunTime:0.023212s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006738s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.028574s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006779s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.013402s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006732s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.024233s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006814s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.042700s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006710s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.027109s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006798s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.027212s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.013367s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.013464s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.013431s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.013350s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.014021s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.014612s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.013354s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.013246s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.013270s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.026523s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.013256s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.013339s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.013166s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.013193s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.244470s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.013389s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.013284s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY id asc [ RunTime:0.013276s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006838s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.018921s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY id asc [ RunTime:0.013367s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=104 ) ORDER BY id asc [ RunTime:0.013385s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.006827s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.018704s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY id asc [ RunTime:0.013436s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006762s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.029818s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=18 ) ORDER BY id asc [ RunTime:0.013296s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=106 ) ORDER BY id asc [ RunTime:0.024584s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006805s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.026978s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.013468s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.013293s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.013285s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.029662s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.013308s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.013287s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.013320s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.013247s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.025096s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.042286s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.013597s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.013271s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.013236s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.013265s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.233319s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.013386s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.013441s ]
SELECT * FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.036216s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.013574s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=26 ) ORDER BY id asc [ RunTime:0.013361s ]
SELECT * FROM `xms_document` WHERE `id` IN (547,548) AND `states` = 1 [ RunTime:0.013777s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.006885s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006831s ]
(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 = 5237) [ RunTime:0.018317s ]
(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 =9) [ RunTime:0.027450s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.013357s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.007097s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.006773s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.006713s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006703s ]
(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 = 5237) [ RunTime:0.017836s ]
(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 =9) [ RunTime:0.026868s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.006755s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006769s ]
(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 = 5237) [ RunTime:0.018746s ]
(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 =11) [ RunTime:0.023082s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007036s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.006796s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5237 LIMIT 1 [ RunTime:0.006698s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006720s ]
(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 = 5237) [ RunTime:0.018523s ]
(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 =11) [ RunTime:0.020800s ]
SELECT * FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.006981s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=75 ) ORDER BY id asc [ RunTime:0.010043s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.010088s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.010134s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.229889s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.013568s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.013445s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.013434s ]
官方商城
