SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.000914s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003980s ]
SELECT * FROM `xms_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000557s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000360s ]
SELECT * FROM `xms_category` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000376s ]
SELECT `langid` FROM `xms_category` WHERE `states` = 1 AND `id` = 999 LIMIT 1 [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.000862s ]
SELECT `langid`,`cataddr` FROM `xms_document` WHERE `states` = 1 AND `id` = 999 LIMIT 1 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.000613s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`catid`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 999 LIMIT 1 [ RunTime:0.000298s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000206s ]
SELECT * FROM `xms_category` WHERE `id` = 65 LIMIT 1 [ RunTime:0.000509s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000381s ]
SELECT * FROM `xms_category` WHERE `id` = 999 LIMIT 1 [ RunTime:0.000388s ]
SELECT * FROM `xms_category` WHERE `id` = 997 LIMIT 1 [ RunTime:0.000347s ]
SELECT * FROM `xms_category` WHERE `id` = 996 LIMIT 1 [ RunTime:0.000359s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003691s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003584s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003583s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003602s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 6 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003577s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 6 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005130s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 94 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004058s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 94 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003593s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 95 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003599s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 95 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003558s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 259 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003564s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 259 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005544s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 261 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.006556s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 261 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005513s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005376s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 144 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004275s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 144 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003910s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 145 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003861s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 145 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005253s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 146 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004144s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 146 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005472s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 265 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005368s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 265 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003927s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003761s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 2561 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003877s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 2561 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003819s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 148 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005509s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 148 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003992s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 149 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003974s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 149 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005311s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003761s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 501 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003936s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 501 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004206s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 151 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003952s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 151 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004068s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 152 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003855s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 152 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003959s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 3742 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004166s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4318 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003802s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4318 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003829s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5492 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004076s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5492 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004127s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003830s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004016s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004033s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003772s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003861s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 3742 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003619s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '19' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.015642s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.000508s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000277s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000418s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000228s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000360s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000188s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000318s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000210s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000486s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000280s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000444s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000321s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000313s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000198s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000282s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000194s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000291s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000210s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003602s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004041s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 28 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.005782s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 29 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.004333s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 31 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003734s ]
SELECT * FROM `xms_document` WHERE `id` = 999 LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 999 LIMIT 1 [ RunTime:0.000260s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000201s ]
(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=70 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 999) [ RunTime:0.014246s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=70 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =8) [ RunTime:0.014050s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 999 LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000201s ]
(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=70 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 999) [ RunTime:0.013538s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=70 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =10) [ RunTime:0.013921s ]
SELECT * FROM `xms_category` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000582s ]
SELECT * FROM `xms_category` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000347s ]
SELECT * FROM `xms_document` WHERE `id` = 143 LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 0 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003493s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003537s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.003215s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003405s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 90 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003456s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.003258s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003560s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 91 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003617s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.003315s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003591s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 92 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003899s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.003539s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003645s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 5 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003743s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 4 ORDER BY `sortid` ASC [ RunTime:0.003285s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 3742 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003480s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 3742 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003664s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000284s ]
SELECT * FROM `xms_document` WHERE `states` = 1 AND `catid` = '19' ORDER BY `sortid` DESC,`createtime` DESC [ RunTime:0.013799s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000307s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000245s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000362s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000370s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000329s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000405s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000314s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000254s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000308s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000377s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 15 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003608s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 20 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003686s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 28 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003653s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 29 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003633s ]
SELECT * FROM `xms_category` WHERE `states` = 1 AND `pid` = 31 AND `isnav` = 1 ORDER BY `sortid` ASC [ RunTime:0.003763s ]
