mysql - MySQL-具有内部联接的SQL查询花费的时间太长

我想优化以下查询。在我的开发服务器上使用LIMIT 10需要150-200秒才能执行它。由于执行时间有限，因此无法在生产服务器上运行它。

SELECT
intensive.id AS intensive_id,
intensive.module_id AS intensive_module_id,
w.id AS w_id,
intensive.translation,
w.name_basic_lang,
w.image_name,
w.image_number,
w.image_ext
FROM mk_int_module_multiwordssentences intensive
INNER JOIN mk_words w ON intensive.translation= w.name_basic_lang
WHERE w.image_number <> '' AND w.image_number <> -1 AND intensive.img_name IS NULL
GROUP BY intensive.id

最佳答案

尝试这个：

SELECT
...
FROM mk_int_module_multiwordssentences intensive
INNER JOIN mk_words w ON intensive.translation = w.name_basic_lang
and w.image_number <> '' AND w.image_number <> -1 AND intensive.img_name IS NULL
Group by ...