SHOW FULL COLUMNS FROM `xms_category` [ RunTime:0.011738s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY id asc [ RunTime:0.011522s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011380s ]
SELECT * FROM `xms_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.011590s ]
SHOW FULL COLUMNS FROM `xms_document` [ RunTime:0.011996s ]
SELECT * FROM `xms_document` WHERE `id` = 144 LIMIT 1 [ RunTime:0.011516s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011424s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011645s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011440s ]
SELECT * FROM `xms_document` WHERE ( id = 74 and states = 1 ) ORDER BY id desc LIMIT 1 [ RunTime:0.011506s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY id asc [ RunTime:0.011560s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=1 ) ORDER BY id asc [ RunTime:0.011744s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011325s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=4 ) ORDER BY id asc [ RunTime:0.011526s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011465s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=8 ) ORDER BY id asc [ RunTime:0.011522s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011555s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=9 ) ORDER BY id asc [ RunTime:0.011481s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011468s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=10 ) ORDER BY id asc [ RunTime:0.011668s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011306s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 28 LIMIT 1 [ RunTime:0.011026s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid in (28) ) ORDER BY sortid desc,id desc [ RunTime:0.011834s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 144 LIMIT 1 [ RunTime:0.011170s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.010857s ]
(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=22 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 144) [ RunTime:0.012164s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=22 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =4) [ RunTime:0.012624s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011373s ]
SHOW FULL COLUMNS FROM `xms_pagemodel` [ RunTime:0.011338s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 10 LIMIT 1 [ RunTime:0.011128s ]
SELECT `id`,`catid`,`sortid`,`createtime` FROM `xms_document` WHERE `id` = 144 LIMIT 1 [ RunTime:0.011075s ]
SELECT `id`,`title`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011079s ]
(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=22 ORDER BY sortid desc,createtime desc ) AS t1 WHERE id = 144) [ RunTime:0.012046s ]
(SELECT * FROM (SELECT (@i :=@i + 1) AS rownum,a.* FROM (SELECT @i := 0) AS it, xms_document AS a WHERE states=1 and catid=22 ORDER BY sortid desc,createtime desc) AS t1 WHERE rownum =6) [ RunTime:0.012414s ]
SELECT * FROM `xms_category` WHERE `id` = 22 LIMIT 1 [ RunTime:0.011409s ]
SELECT * FROM `xms_pagemodel` WHERE `id` = 10 LIMIT 1 [ RunTime:0.010886s ]
SELECT * FROM `xms_category` WHERE ( states=1 and isnav=1 and pid=0 ) ORDER BY id asc [ RunTime:0.011439s ]
SELECT `id`,`pid`,`orderby`,`suborderby` FROM `xms_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.010813s ]
SELECT * FROM `xms_document` WHERE ( states=1 and catid in (33) ) ORDER BY id desc,id desc [ RunTime:0.011896s ]
SELECT * FROM `xms_document` WHERE `id` = 71 LIMIT 1 [ RunTime:0.011519s ]
SELECT * FROM `xms_document` WHERE `id` = 71 LIMIT 1 [ RunTime:0.011486s ]
SELECT * FROM `xms_document` WHERE `id` = 71 LIMIT 1 [ RunTime:0.011413s ]
SELECT * FROM `xms_document` WHERE `id` = 71 LIMIT 1 [ RunTime:0.011333s ]
SELECT * FROM `xms_document` WHERE `id` = 71 LIMIT 1 [ RunTime:0.011491s ]