-- 使用EXPLAIN分析查询性能 EXPLAIN SELECT u.*, COUNT(o.order_id) AS order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.status = 'active' GROUP BY u.id; -- 优化子查询为JOIN -- 优化前（慢） SELECT * F