经过与企微服务人员对接，是由于一个sql查询导致特别慢，希望能及时解决
SELECT s_r.name AS test_name, if(s_r.end_time + 0 > s_r.create_time + 0, s_r.end_time, s_r.create_time) AS end_time, s_r.user_id, s_r.name, s_r.id, s_r.project_id, s_r.create_time, s_r.update_time, s_r.status, s_r.trigger_mode, s_r.execute_type, s_r.report_type FROM api_scenario_report s_r WHERE s_r.project_id = ‘project_id’ AND s_r.report_type NOT LIKE ‘UI%’ AND s_r.execute_type = ‘Saved’ AND s_r.relevance_test_plan_report_id IS NULL ORDER BY update_time DESC LIMIT 10;
你们这张表有多少数据，如果数据量太大，再怎么优化也是有限的。