一个 20 秒 SQL 慢查询优化的经历与处理方案

正文

请到「今天看啥」查看全文

SELECT * FROM a_table AS a

LEFT JOIN b_table AS b ON a.id = b.id

WHERE a.id IN (

SELECT DISTINCT id FROM a_table

WHERE user_id IN (100,102,103) GROUP

请到「今天看啥」查看全文