Mysql 查询优化不佳

Question

我不是 sql 专家，我需要以下查询的帮助。它优化不佳，执行时间太长。是否可以将 IN() 替换为 JOIN() 以加快查询速度？怎么做？

SELECT * 
FROM   shop_orders 
WHERE  id IN (SELECT orders_id 
              FROM   shop_orders_data 
              WHERE  closed = '1' /*AND backorder='0'*/) 
       AND id IN (SELECT orders_id 
                  FROM   shop_orders_products 
                  WHERE  products_id IN (SELECT id 
                                         FROM   shop_products 
                                         WHERE  artno = '120000' 
                                                 OR name LIKE '%120000%')) 
ORDER  BY created DESC 

Answer 1

我会说 LIKE 在这里造成了最大的延迟……难道 artno 还不够吗？ LIKE 通常是一个非常昂贵的过程。