sql语句有没有怎么优化的空间，这条语句在我这里执行是死机

SELECT count(*) from urls where id not in (select distinct url_id from images where site='xx' and kind='image') and site='xx' and kind='detail' and success=1

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/lexus/p/1948419.html