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