给shop_cr 字段加索引
not改成左外连接 + 空值判断
select a.* from dh_w a,(
select c.picture_id from dh_product c left outer join (
SELECT sm_product_id FROM dh_had_upload WHERE shop_cr='IU'
union
SELECT sm_product_id FROM dh_arrange_upload WHERE shop_cr='IU'
) d on c.id = d.sm_product_id
where d.sm_product_id is null
)b where a.num =b.picture_id
ORDER BY a.id limit 0,90
可以一部分一部分筛选吧，
尽量少用in，使用EXISTS；另外，必要时给连接的列加上索引
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024