table表end_time为索引列,当end_time在同一天时,两个sql索引生效,非同一天时,索引无效;
explain select * from table where end_time >= '2019-04-22 00:00:00' and end_time <= '2019-04-22 23:59:59';
explain select * from table where end_time BETWEEN '2019-04-22 00:00:00' and '2019-04-22 23:59:59';
同一天:
非同一天: