mysql版本优化子查询_MySQL优化子查询

我想优化这个查询(因为子查询一般来说速度不快),但是我输了,因为我无法使用连接来重写它,这对于性能更好,你能帮助mi吗？

SELECT id, company, street, number, number_addition, postalcode, telephone

FROM clients

WHERE (postalcode BETWEEN '1000' AND '9000') AND street = (

SELECT DISTINCT street FROM clients WHERE (postalcode BETWEEN '1000' AND '9000') AND postalcode <= (

SELECT MIN(postalcode) FROM clients WHERE street = 'Main Street' AND (postalcode BETWEEN '1000' AND '9000'))

ORDER BY postalcode DESC LIMIT 1, 1)

ORDER BY postalcode DESC, street DESC, number DESC, number_addition DESC, telephone DESC

LIMIT 1

谢谢你的时间.