SHOW FULL COLUMNS FROM `blog_category` [ RunTime:0.011317s ]
SELECT c.id,c.name,count(bp.category_id) as catenum FROM `blog_category` `c` INNER JOIN `blog_post` `bp` ON `c`.`id`=`bp`.`category_id` GROUP BY `c`.`id` ORDER BY `catenum` DESC [ RunTime:0.010966s ]
SHOW FULL COLUMNS FROM `blog_post` [ RunTime:0.011447s ]
SELECT `id`,`title` FROM `blog_post` WHERE `status` = 'normal' ORDER BY `createtime` DESC LIMIT 10 [ RunTime:0.010745s ]
SELECT COUNT(*) AS think_count FROM `blog_post` WHERE `status` = 'normal' [ RunTime:0.010711s ]
SELECT * FROM `blog_post` WHERE `status` = 'normal' ORDER BY `weigh` DESC,`id` DESC LIMIT 5,5 [ RunTime:0.011075s ]
SELECT * FROM `blog_category` WHERE `id` = 5 [ RunTime:0.010782s ]
SELECT * FROM `blog_category` WHERE `id` = 4 [ RunTime:0.010651s ]
SELECT * FROM `blog_category` WHERE `id` = 3 [ RunTime:0.010712s ]
SELECT * FROM `blog_category` WHERE `id` = 2 [ RunTime:0.010778s ]
SELECT * FROM `blog_category` WHERE `id` = 2 [ RunTime:0.010667s ]