急急急,请教大神MYSQL 语句优化
select `s1`.`task_code` AS `task_code`,
`s1`.`user_id` AS `user_id`,
`s1`.`phase` AS `phase`,
`s1`.`operation` AS `operation`,
`s1`.`disposing_time` AS `dispatch_time`,
`s1`.`disposal_deadline` AS `disposal_deadline`,
(select `s`.`org_code` from `stats_snapshot_all_phase` `s`
where ((`s`.`phase` = 6)
and (`s`.`disposing_time` > `s1`.`disposing_time`))
order by `s`.`disposing_time` limit 1) AS `org`
from `stats_snapshot_all_phase` `s1`
where ((1 = 1)
and (`s1`.`phase` = 5)
and (`s1`.`operation` = 37))
请教大神如何优化查询速度会变快