SHOW FULL COLUMNS FROM `blog_category` [ RunTime:0.010008s ]
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.010085s ]
SHOW FULL COLUMNS FROM `blog_post` [ RunTime:0.010078s ]
SELECT `id`,`title` FROM `blog_post` WHERE `status` = 'normal' ORDER BY `createtime` DESC LIMIT 10 [ RunTime:0.009661s ]
UPDATE `blog_post` SET `views` = `views` + 1 WHERE `id` = 8 [ RunTime:0.014477s ]
SELECT * FROM `blog_post` WHERE `id` = 8 LIMIT 1 [ RunTime:0.009852s ]
SELECT * FROM `blog_category` WHERE `id` = 1 [ RunTime:0.009776s ]
SELECT * FROM `blog_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.010088s ]
SELECT * FROM `blog_post` WHERE `category_id` = '1' LIMIT 3 [ RunTime:0.010028s ]
1 条评论