大家好！

是否有一种方法可以优化此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