记录findFailJobLogIds 扫描整个表导致超时，无法发送邮件问题

< select id="findFailJobLogIds" resultType="long"> SELECT id FROM `xxl_job_log` WHERE ! ( (trigger_code in (0, 200) and handle_code = 0) OR (handle_code = 200) ) AND `alarm_status` = 0 ORDER BY id ASC LIMIT #{pagesize} </select>