负向查询不命中索引
不命中
select account from user where id not in (1,2,3);
命中
select account from user where id in (4,5,6);
前置模糊查询
2019-02-21