1.每次查询尽量限制查询的条数
表中总数据180w, task_id=209的数据100w, task_id字段上有索引
不限制条数:
SELECT * FROM `engine_picquery` WHERE (`engine_picquery`.`state` = 1 AND `engine_picquery`.`task_id` = 209) ORDER BY id ASC;
耗时:3.61
限制条数:
SELECT * FROM `engine_picquery` WHERE (`engine_picquery`.`state` = 1 AND `engine_picquery`.`task_id` = 209) ORDER BY id ASC limit 1000;
耗时:0.104