[xuxueli/xxl-job]XXL_JOB_QRTZ_TRIGGER_LOG表有个慢sql，查询时间超过500s，很慢，怎么优化

XXL-JOB v2.1.0

希望XXL_JOB_QRTZ_TRIGGER_LOG走索引，并且降低执行时间

XXL_JOB_QRTZ_TRIGGER_LOG表有个慢sql，查询时间超过500s，很慢

 SELECT id FROM `XXL_JOB_QRTZ_TRIGGER_LOG`
        WHERE !(
            (trigger_code in (0, 200) and handle_code = 0)
            OR
            (handle_code = 200)
        )
        AND `alarm_status` = 0
        ORDER BY id ASC