SHOW FULL COLUMNS FROM `system` [ RunTime:0.000692s ]
SELECT * FROM `system` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `category` [ RunTime:0.000464s ]
SELECT * FROM `category` WHERE `is_show` = 1 AND `pid` = -1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000326s ]
SELECT * FROM `category` WHERE `pid` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000299s ]
SELECT * FROM `category` WHERE `pid` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000266s ]
SELECT * FROM `category` WHERE `pid` = 3 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000273s ]
SELECT * FROM `category` WHERE `pid` = 4 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000247s ]
SELECT * FROM `category` WHERE `pid` = 5 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000233s ]
SELECT * FROM `category` WHERE `pid` = 6 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `banner` [ RunTime:0.000727s ]
SELECT * FROM `banner` WHERE `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000250s ]
SELECT COUNT(*) AS think_count FROM `category` WHERE `is_show` = 1 AND `pid` = -1 [ RunTime:0.000270s ]
UPDATE `category` SET `appoint` = 1 WHERE `is_show` = 1 AND `pid` = -1 AND `id` = 1 [ RunTime:0.001348s ]
UPDATE `category` SET `appoint` = 2 WHERE `is_show` = 1 AND `pid` = -1 AND `id` = 2 [ RunTime:0.001329s ]
UPDATE `category` SET `appoint` = 3 WHERE `is_show` = 1 AND `pid` = -1 AND `id` = 3 [ RunTime:0.001330s ]
UPDATE `category` SET `appoint` = 4 WHERE `is_show` = 1 AND `pid` = -1 AND `id` = 4 [ RunTime:0.001266s ]
UPDATE `category` SET `appoint` = 5 WHERE `is_show` = 1 AND `pid` = -1 AND `id` = 5 [ RunTime:0.001270s ]
UPDATE `category` SET `appoint` = 6 WHERE `is_show` = 1 AND `pid` = -1 AND `id` = 6 [ RunTime:0.001391s ]
SELECT * FROM `category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000307s ]
SELECT * FROM `category` WHERE `pid` = 3 AND `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000293s ]
SELECT * FROM `category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000267s ]
SELECT * FROM `category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `article` [ RunTime:0.000456s ]
SELECT COUNT(*) AS think_count FROM `article` `a` INNER JOIN `category` `b` ON `a`.`cate_id`=`b`.`id` WHERE `cate_id` = 21 [ RunTime:0.000281s ]
SELECT `a`.*,`b`.`catename` FROM `article` `a` INNER JOIN `category` `b` ON `a`.`cate_id`=`b`.`id` WHERE `cate_id` = 21 ORDER BY `sort` ASC,`id` DESC LIMIT 0,6 [ RunTime:0.000329s ]