mysql - 在多个 NOT IN 上优化 MySQL 查询

Question

有什么办法可以优化这个sql语句吗？也许加入什么？

SELECT id, name
FROM item
WHERE id NOT IN (
    SELECT id 
FROM itemlock
) AND id NOT IN (
SELECT id
    FROM itemlog
)

谢谢

Answer 1

使用LEFT JOIN

SELECT  a.*
FROM    item a
        LEFT JOIN itemLock b
            ON a.ID = b.ID
        LEFT JOIN itemLog c
            ON a.ID = c.ID
WHERE   b.ID IS NULL AND 
        c.ID IS NULL