MySQL 索引问题
EXPLAIN SELECT
user_id,
score
FROM
`members`
WHERE
`user_id` IN (4517, 4502, 4501, 4500)
执行上面的语句,在mysql5.6 执行上面的语句是用到索引的,
在5.7索引就是失效了,两个库的数据是一致的,请教下各位老哥
下面是表结构
CREATE TABLE `members` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL COMMENT '用户id',
`score` int(11) NOT NULL COMMENT '会员积分',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员身份表';