SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.001386s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.000798s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003138s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.004126s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.002673s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.001978s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.003013s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.002039s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.002017s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.013502s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005843s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.001287s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.002649s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001040s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.026907s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.004835s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003331s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.016204s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002266s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.003970s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.003570s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002639s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001841s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.004005s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002121s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002041s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002765s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.014395s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.002171s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002309s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.005017s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002017s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.001939s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003353s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006608s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.012286s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003554s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.028443s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004944s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.004212s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.002232s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.012517s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.002173s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.001333s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002303s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002162s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.001932s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002047s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.002305s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.010597s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002022s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.002190s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.002416s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.001918s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.001964s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.002494s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.020072s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002677s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.002719s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003570s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.005417s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000887s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.002332s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003548s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003366s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001190s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001632s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002536s ]
SELECT * FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.003560s ]
SELECT * FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.005339s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.001814s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.006539s ]
(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=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 90) [ RunTime:0.004401s ]
SELECT * FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.004227s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.001227s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004841s ]
(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=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 90) [ RunTime:0.002125s ]
SELECT * FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.008889s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.001606s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.001111s ]
(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=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 90) [ RunTime:0.003760s ]
SELECT * FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.006465s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 90 LIMIT 1 [ RunTime:0.003608s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004349s ]
(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=32 ORDER BY sortid desc,sortid desc ) AS t1 WHERE id = 90) [ RunTime:0.011276s ]
SELECT * FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.003845s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.003075s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 82 LIMIT 1 [ RunTime:0.004099s ]
SELECT * FROM `xms_document` WHERE `catid` = '82' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.002472s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003151s ]
SELECT * FROM `xms_document` WHERE `catid` = '32' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` DESC,`sortid` ASC LIMIT 100 [ RunTime:0.005866s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004063s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.002503s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002519s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.004983s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002587s ]
SELECT * FROM `xms_category` WHERE `id` = 32 LIMIT 1 [ RunTime:0.003230s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.003628s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.001964s ]
SELECT * FROM `xms_document` WHERE `catid` = '34' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.004434s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.007127s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000574s ]
SELECT * FROM `xms_category` WHERE `id` = 34 LIMIT 1 [ RunTime:0.002100s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.003835s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 89 LIMIT 1 [ RunTime:0.001193s ]
SELECT * FROM `xms_document` WHERE `catid` = '89' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` DESC,`sortid` DESC LIMIT 100 [ RunTime:0.006819s ]
SELECT * FROM `xms_category` WHERE `id` = 89 LIMIT 1 [ RunTime:0.004155s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.003529s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.002422s ]
SELECT * FROM `xms_document` WHERE `catid` = '33' AND `isrecommend` = 1 AND `states` = 1 ORDER BY `sortid` ASC,`sortid` ASC LIMIT 100 [ RunTime:0.006472s ]
SELECT * FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.006381s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002938s ]
SELECT * FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.002945s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.002223s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.004270s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=17 ) ORDER BY sortid asc [ RunTime:0.004815s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.005109s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.005207s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY sortid asc [ RunTime:0.004948s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.006609s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.005031s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY sortid asc [ RunTime:0.002882s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.005952s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.006503s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY sortid asc [ RunTime:0.003299s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.005702s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.003511s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.005699s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY sortid asc [ RunTime:0.005443s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=37 ) ORDER BY sortid asc [ RunTime:0.005645s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=38 ) ORDER BY sortid asc [ RunTime:0.004479s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=71 ) ORDER BY sortid asc [ RunTime:0.004695s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.004385s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.005662s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=43 ) ORDER BY sortid asc [ RunTime:0.003922s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY sortid asc [ RunTime:0.004924s ]
SELECT * FROM `xms_document` WHERE ( catid='87' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005671s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.013171s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010800s ]
SELECT * FROM `xms_document` WHERE ( catid='62' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.013077s ]
SELECT * FROM `xms_category` WHERE `id` = 62 LIMIT 1 [ RunTime:0.010561s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.005434s ]
SELECT * FROM `xms_document` WHERE ( catid='63' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003821s ]
SELECT * FROM `xms_category` WHERE `id` = 63 LIMIT 1 [ RunTime:0.007090s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 27 LIMIT 1 [ RunTime:0.004167s ]
SELECT * FROM `xms_document` WHERE ( catid='64' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002679s ]
SELECT * FROM `xms_category` WHERE `id` = 64 LIMIT 1 [ RunTime:0.007552s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 29 LIMIT 1 [ RunTime:0.000773s ]
SELECT * FROM `xms_document` WHERE ( catid='45' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005554s ]
SELECT * FROM `xms_category` WHERE `id` = 45 LIMIT 1 [ RunTime:0.007876s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000580s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004802s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009880s ]
SELECT * FROM `xms_document` WHERE ( catid='65' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.007328s ]