大家好!
是否有一种方法可以优化此SQL查询,使其更快?例如:
伪:
[...]NOT IN(表格1、表格2、表格3...)
有问题的查询:
SELECT data FROM _ WHERE p_=:e
AND status <= 1
AND s_ >= :f
AND c_ IS NULL
AND _.id NOT IN (SELECT id FROM c_)
AND _.id NOT IN (SELECT id FROM p_)
AND _.id NOT IN (SELECT id FROM e_)
AND _.id NOT IN (SELECT id FROM f_)
AND _.id NOT IN (SELECT id FROM w_)
AND _.id NOT IN (SELECT id FROM a_)
AND _.id NOT IN (SELECT id FROM k_)
AND _.id NOT IN (SELECT id FROM w_)
AND _.id NOT IN (SELECT id FROM r_) ORDER BY s_ DESC
1条答案
按热度按时间xj3cbfub1#
不存在可能有帮助