SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.000740s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001472s ]
SELECT * FROM `xms_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000298s ]
SELECT * FROM `xms_category` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.000503s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.000686s ]
SELECT `id`,`catid`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 418 LIMIT 1 [ RunTime:0.000248s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `xms_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000309s ]
SELECT * FROM `xms_category` WHERE `id` = 418 LIMIT 1 [ RunTime:0.000304s ]
SELECT * FROM `xms_category` WHERE `id` = 154 LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `xms_category` WHERE `id` = 153 LIMIT 1 [ RunTime:0.000290s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001556s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001345s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001401s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001317s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 6 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001326s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 94 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001261s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 95 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001327s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 259 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001304s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 261 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001338s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001625s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 144 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001551s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 145 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001490s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 146 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001444s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 264 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001481s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 265 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001558s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001572s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 147 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001476s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 148 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001422s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 149 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001356s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001323s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 501 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001385s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 151 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001557s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 152 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001470s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001486s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001349s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001367s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001514s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001329s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000268s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '19' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.009516s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.000511s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000339s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000212s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000300s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000291s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000282s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000354s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000246s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000293s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000299s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000188s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000317s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000330s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000227s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000304s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000228s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001434s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001425s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 28 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001324s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 29 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001344s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 31 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001365s ]
SELECT * FROM `xms_document` WHERE `id` = 418 LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 418 LIMIT 1 [ RunTime:0.000215s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.000198s ]
(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=75 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 418) [ RunTime:0.008855s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=75 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =2) [ RunTime:0.009231s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 418 LIMIT 1 [ RunTime:0.000272s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 75 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=75 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 418) [ RunTime:0.009458s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=75 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =4) [ RunTime:0.009857s ]
SELECT * FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `xms_document` WHERE `id` = 143 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001405s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001365s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001242s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001348s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001427s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001322s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001273s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001298s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001317s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001340s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001440s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.001278s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001515s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001293s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000226s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '19' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.009262s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000272s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000299s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000308s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000313s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000309s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000288s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000288s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000238s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000301s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000187s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000223s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001308s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001355s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 28 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001314s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 29 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001346s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 31 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001400s ]