SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.007716s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY sortid asc [ RunTime:0.008559s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007348s ]
SHOW FULL COLUMNS FROM `xms_site` [ RunTime:0.007452s ]
SELECT * FROM `xms_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.007259s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.007646s ]
SELECT * FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.007464s ]
SELECT `id`,`title`,`seotitle`,`seokeywords`,`seodescription` FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.007176s ]
UPDATE `xms_document` SET `clickcount` = `clickcount` + 1 WHERE `id` = 5157 [ RunTime:0.011903s ]
SELECT * FROM `xms_document` WHERE ( catid='70' and states=1 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.020562s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.007310s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.011812s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.007192s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.011932s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007185s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011813s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007228s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011952s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007237s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc [ RunTime:0.022078s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.008420s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc [ RunTime:0.020631s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007209s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc [ RunTime:0.020722s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007261s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011864s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007171s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5162 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.018872s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007181s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5163 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.016550s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 104 LIMIT 1 [ RunTime:0.007169s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=104 and expandmate=5166 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.018596s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.007161s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.020513s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.007183s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.020549s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007224s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.020791s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007193s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.020549s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007189s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc [ RunTime:0.020600s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007183s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc [ RunTime:0.020741s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007185s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc [ RunTime:0.020640s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007233s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc [ RunTime:0.021843s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007191s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc [ RunTime:0.020690s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007192s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.020703s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007247s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=519 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.007622s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007139s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=518 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.020607s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007150s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=517 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.020493s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007177s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=516 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.020704s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 106 LIMIT 1 [ RunTime:0.007128s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=106 and expandmate=515 ) ORDER BY id desc,id desc LIMIT 1 [ RunTime:0.020452s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.007512s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.007409s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.007439s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.007442s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.007388s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.007372s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.007385s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.007397s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.007360s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.007442s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.007421s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.007419s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.007406s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.007417s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.007357s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.007351s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.007339s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=20 ) ORDER BY id asc [ RunTime:0.007366s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 20 LIMIT 1 [ RunTime:0.007100s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=20 ) ORDER BY sortid asc,id desc [ RunTime:0.011878s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=21 ) ORDER BY id asc [ RunTime:0.007403s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=104 ) ORDER BY id asc [ RunTime:0.007419s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.007107s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=21 ) ORDER BY sortid asc,id desc [ RunTime:0.011771s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=19 ) ORDER BY id asc [ RunTime:0.007411s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 19 LIMIT 1 [ RunTime:0.007065s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=19 ) ORDER BY id desc,id desc [ RunTime:0.020389s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=18 ) ORDER BY id asc [ RunTime:0.007463s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=106 ) ORDER BY id asc [ RunTime:0.008635s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 18 LIMIT 1 [ RunTime:0.007073s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid=18 ) ORDER BY id desc,id desc [ RunTime:0.020662s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.007593s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.007652s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.007504s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.007481s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=35 ) ORDER BY id asc [ RunTime:0.007536s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.008999s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.007533s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.007685s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.007495s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.007451s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.007414s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.007495s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.007431s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=111 ) ORDER BY id asc [ RunTime:0.007445s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=116 ) ORDER BY id asc [ RunTime:0.007445s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=117 ) ORDER BY id asc [ RunTime:0.007480s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=118 ) ORDER BY id asc [ RunTime:0.007436s ]
SELECT * FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.008688s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007350s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=26 ) ORDER BY id asc [ RunTime:0.007553s ]
SELECT * FROM `xms_document` WHERE `id` = 889 AND `states` = 1 [ RunTime:0.007430s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.007142s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007156s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5157) [ RunTime:0.017383s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =54) [ RunTime:0.017454s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007375s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.007400s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.007244s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.007163s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007178s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5157) [ RunTime:0.017485s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =54) [ RunTime:0.018155s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.007240s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007264s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5157) [ RunTime:0.017528s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =56) [ RunTime:0.017581s ]
SELECT * FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007435s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 7 LIMIT 1 [ RunTime:0.007256s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 5157 LIMIT 1 [ RunTime:0.007234s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 26 LIMIT 1 [ RunTime:0.007203s ]
(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=26 ORDER BY sortid desc,id desc ) AS t1 WHERE id = 5157) [ RunTime:0.017522s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=26 ORDER BY sortid desc,id desc) AS t1 WHERE rownum =56) [ RunTime:0.017789s ]
SELECT * FROM `xms_category` WHERE `id` = 75 LIMIT 1 [ RunTime:0.007393s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=75 ) ORDER BY id asc [ RunTime:0.007479s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=22 ) ORDER BY id asc [ RunTime:0.007566s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=23 ) ORDER BY id asc [ RunTime:0.007450s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=24 ) ORDER BY id asc [ RunTime:0.007454s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=25 ) ORDER BY id asc [ RunTime:0.007447s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=27 ) ORDER BY id asc [ RunTime:0.007480s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=108 ) ORDER BY id asc [ RunTime:0.007485s ]