mysql - 如何在不使用 UNION 的情况下优化 sql 中的查询

Question

我的查询为:

SELECT i.id AS id
    FROM table_a i
    WHERE (i.cat_id IN (92, 224))
    GROUP BY id
    HAVING (COUNT(i.cat_id) = 2 AND SUM(i.cat_id) = 316)

    UNION
    (
        SELECT i.id AS id
        FROM table_a i
        WHERE (i.cat_id IN (92, 227))
        GROUP BY id
        HAVING (COUNT(i.cat_id) = 2 AND SUM(i.cat_id) = 319)
    )

如何优化这个查询？

Answer 1

SELECT i.id AS id
    FROM table_a i
    WHERE (i.cat_id IN (92, 224) OR i.cat_id IN (92, 227))
    GROUP BY id
    HAVING (COUNT(i.cat_id) = 2 
       AND (SUM(i.cat_id) = 316 OR SUM(i.cat_id) = 319 )