索引数据是存在缓存吗
index:idx_status_created_at(status, created_at)
循环执行以下两条语句
select * FROM user_score_log WHERE status = 0 AND created_at BETWEEN “2020-10-15 00:00:00” and “2020-10-15 23:59:59” order by status limit 100;
update user_score_log set status = 1 where id in (xxx) and created_at BETWEEN “2020-10-15 00:00:00” and “2020-10-15 23:59:59”;
第一条语句刚执行的时候很快 执行了一段时间后速度明显变慢。