sql速度优化 求大神来解答
SELECT a.createDate,
INSERT(b.userName, 4, 4, '****') AS 'userName', CASE WHEN a.uid =ci.uid THEN ci.shortName ELSE c.name END AS 'name', a.handleSum, a.bankName, a.`status`, a.withdrawNo, (
SELECT n.desc
FROM jz_message_log_record m, jz_code_desc n
WHERE m.requestId = a.withdrawNo AND m.result = n.code AND n.system = 'sumapay' AND m.result IS NOT NULL
ORDER BY m.id DESC
LIMIT 0, 1) AS ffStatus
FROM jz_withdraw a
LEFT JOIN jz_user b ON (a.uid=b.id)
LEFT JOIN jz_person c ON(a.uid=c.uid)
LEFT JOIN `jz_company_investor` ci ON a.uid=ci.uid
WHERE a.status!='0'
ORDER BY a.createDate DESC
LIMIT 0, 10