数据量 大概 10W
explain select count(*) from predictions where predictions.deleted_at is null and (in_time between '2022-09-01' and '2022-09-13')
上面的走索引 大概3000
explain select count(*) from predictions where predictions.deleted_at is null and (in_time between '2022-09-01' and '2022-09-13')
上面的不走索引 大概4000
比较神奇
标签：时效,09,predictions,mysql,索引,2022,between From： https://www.cnblogs.com/cbywan/p/16725120.html