SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.005395s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001607s ]
SELECT * FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000763s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000750s ]
SELECT * FROM `xms_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000494s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.001875s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.002849s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 1786 LIMIT 1 [ RunTime:0.000423s ]
SELECT * FROM `xms_document` WHERE `id` = 1786 LIMIT 1 [ RunTime:0.000369s ]
SELECT * FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000292s ]
SELECT * FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000263s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000543s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 1 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000512s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 2 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000496s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 13 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000458s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 14 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000444s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000441s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 16 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000437s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 13 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000507s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 14 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000803s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000709s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 16 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000729s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 3 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000663s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000380s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '3' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.009158s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000630s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.001339s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000407s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000545s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000380s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000353s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000516s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000391s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000505s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000405s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000532s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000392s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000343s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000533s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 19 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000649s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000518s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 48 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000528s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 19 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000539s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000525s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 48 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000528s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000541s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 38 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000517s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 40 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000505s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 41 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001371s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 38 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001193s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 40 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001180s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 41 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.001161s ]
SELECT * FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`title`,`pid`,`weburl`,`subimgurlmate` FROM `xms_category` WHERE `states` = 1 [ RunTime:0.000722s ]
SELECT `id`,`title`,`pid`,`weburl`,`subimgurlmate` FROM `xms_category` WHERE `states` = 1 [ RunTime:0.000700s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 1786 LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000362s ]
(SELECT rownum - 1 AS ROWINDEXS FROM (SELECT *, (@i :=@i + 1) AS rownum FROM xms_document, (SELECT @i := 0) AS it WHERE states=1 and catid=18 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 1786) [ RunTime:0.000982s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=18 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =0) [ RunTime:0.013654s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 1786 LIMIT 1 [ RunTime:0.000296s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000228s ]
(SELECT rownum + 1 AS ROWINDEXS FROM (SELECT *, (@i :=@i + 1) AS rownum FROM xms_document, (SELECT @i := 0) AS it WHERE states=1 and catid=18 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 1786) [ RunTime:0.000388s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=18 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =2) [ RunTime:0.009927s ]
SELECT * FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000455s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000287s ]
SELECT * FROM `xms_document` WHERE `id` = 179 LIMIT 1 [ RunTime:0.000436s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000600s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 2 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000561s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '3' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.008602s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000403s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000355s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000339s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000294s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000431s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000298s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000267s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000268s ]
SELECT * FROM `xms_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000376s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000278s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000583s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.000594s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 71 LIMIT 1 [ RunTime:0.000305s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '71' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.008601s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 72 LIMIT 1 [ RunTime:0.000291s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '72' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.008394s ]
SELECT * FROM `xms_category` WHERE `id` = 72 LIMIT 1 [ RunTime:0.000370s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000233s ]