SELECT ifNull(sum(test.score), 0) score, ifNull(dr.count, 0) AS win_times, ifNull(a.state, 5) AS user_state, m., u.pic, u.uname, u.reg_time, u.last_login, c.uid AS MASTER, c.admin FROM mahjong_cms.club_member m LEFT JOIN mahjong.user0 u ON m.uid = u.uid LEFT JOIN mahjong.active_user_stats a ON m.uid = a.uid AND m.club_id = a.clubid LEFT JOIN mahjong.win_lose test ON test.uid = m.uid AND m.club_id = test.club_id AND test.playtime >= 1625673600 LEFT JOIN ( SELECT count() AS count, uid FROM mahjong_cms.dyj_record WHERE club_id = 116692 AND date >= ‘2021-07-08’ GROUP BY uid ) AS dr ON m.uid = dr.uid LEFT JOIN mahjong_cms.club c ON c.id = m.club_id WHERE m.uid IN (88327, 83937) AND m. STATUS = 0 AND c.id = 116692 GROUP BY find_in_set(m.uid, “88327,83937”)

这个sql 在 正常测试执行都很快，但是在线上却把 阿里从库干爆了，不知道什么地方可以优化下？求指点