SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.000797s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001446s ]
SELECT * FROM `xms_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000281s ]
SELECT * FROM `xms_category` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.000456s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000267s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.000791s ]
SELECT `id`,`catid`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000270s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000309s ]
SELECT * FROM `xms_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000443s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000326s ]
SELECT * FROM `xms_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000331s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000309s ]
SELECT * FROM `xms_category` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001553s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001400s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001431s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001407s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 6 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001412s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 94 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001263s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 95 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001540s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 259 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001430s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 261 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001448s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001351s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 144 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001344s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 145 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001365s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 146 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001339s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 264 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001329s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 265 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001281s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001369s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 147 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001327s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 148 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001260s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 149 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001271s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001241s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 501 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001297s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 151 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001242s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 152 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001287s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001288s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001537s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001549s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001443s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001320s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000280s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '19' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.009472s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.000490s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000287s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000351s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000279s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000358s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000334s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000212s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000363s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000201s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000300s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000265s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000308s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000292s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000201s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001360s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001402s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 28 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001493s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 29 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001605s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 31 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001404s ]
SELECT * FROM `xms_document` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000260s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000218s ]
(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=67 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 67) [ RunTime:0.008798s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=67 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =3) [ RunTime:0.008751s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000249s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000192s ]
(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=67 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 67) [ RunTime:0.008351s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=67 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =5) [ RunTime:0.008474s ]
SELECT * FROM `xms_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000357s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000345s ]
SELECT * FROM `xms_document` WHERE `id` = 143 LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001296s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001299s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001184s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001373s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001405s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001345s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001378s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001334s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001489s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001403s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001464s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001393s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001526s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001521s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000241s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '19' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.009888s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000369s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000227s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000361s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000231s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000335s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000208s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000297s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000188s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000301s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000215s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000271s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000206s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001320s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001333s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 28 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001336s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 29 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001291s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 31 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001308s ]
