SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.006476s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.006576s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.006316s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.006512s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.006145s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.006672s ]
SELECT * FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.006464s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.007231s ]
UPDATE `xms_document` SET `clickcount` = `clickcount` + 1 WHERE `id` = 5171 [ RunTime:0.011588s ]
SELECT * FROM `xms_document` WHERE ( catid='70' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.024141s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.006078s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.010885s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.005932s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.010923s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.005875s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011610s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.005908s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011079s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.005945s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc [ RunTime:0.020844s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.005916s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc [ RunTime:0.020211s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.005892s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc [ RunTime:0.020141s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.005852s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.012010s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.005909s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.019220s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.006038s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.017377s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.005873s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.025743s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.005938s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.029049s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.006037s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.031664s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006184s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.021044s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006049s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.025259s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006082s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc [ RunTime:0.022134s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.005991s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc [ RunTime:0.023592s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006071s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc [ RunTime:0.023636s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006110s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc [ RunTime:0.029072s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006112s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc [ RunTime:0.026383s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.006328s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.029379s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006018s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.006428s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.005940s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.029643s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006003s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.022687s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.006040s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.025924s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.005979s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.031896s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.006734s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.008852s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.006391s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.006194s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.006248s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.006348s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.006353s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.006233s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.006205s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.006234s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.006269s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.006342s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.006611s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.006387s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.006173s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.006225s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.006220s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY id asc [ RunTime:0.006230s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.005944s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.011659s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY id asc [ RunTime:0.006549s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=104 ) ORDER BY id asc [ RunTime:0.006311s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.005905s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011600s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY id asc [ RunTime:0.006449s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.005919s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.025779s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=18 ) ORDER BY id asc [ RunTime:0.466820s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=106 ) ORDER BY id asc [ RunTime:0.006260s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.005857s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.237201s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.011769s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.014368s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.011759s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.011635s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.011693s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.011611s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.011680s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.011869s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.011753s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.011769s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.011601s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.025652s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.012040s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.011904s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.230359s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.011713s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.011709s ]
SELECT * FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.014653s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.011788s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=26 ) ORDER BY id asc [ RunTime:0.011587s ]
SELECT * FROM `xms_document` WHERE `id` IN (548,889) AND `states` = 1 [ RunTime:0.011770s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.005869s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.005847s ]
(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 = 5171) [ RunTime:0.016896s ]
(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 =50) [ RunTime:0.020716s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.011668s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.006238s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.006029s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.005934s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.005940s ]
(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 = 5171) [ RunTime:0.017057s ]
(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 =50) [ RunTime:0.020146s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.006147s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.005942s ]
(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 = 5171) [ RunTime:0.018343s ]
(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 =52) [ RunTime:0.026075s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.011644s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.005961s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5171 LIMIT 1 [ RunTime:0.005957s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.005862s ]
(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 = 5171) [ RunTime:0.016719s ]
(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 =52) [ RunTime:0.025293s ]
SELECT * FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.006184s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=75 ) ORDER BY id asc [ RunTime:0.010226s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.008914s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.008995s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.008969s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.229388s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.011556s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.011601s ]
官方商城
