MySQL查询优化–索引优化

废话就不多说了,先建一张表 CREATE TABLE IF NOT EXISTS `article`( `id` INT(10) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,#文章id `author_id` INT (10) UNSIGNED NOT NULL, #作者id `category_id` INT(10) UNSIGNED NOT NULL , #分类id `views` INT(10) UNSIGNED NOT NULL , #阅读数 `comments` INT(10) UNSIGNED NOT NULL, #评论数 `titl