explain SELECT
sp.*
FROM
yjdf_innerbuy_goods_spu sp
LEFT JOIN (SELECT ias.spu_id, max( ias.create_date ) create_date FROM yjdf_innerbuy_activity_sku ias WHERE ias.innerbuy_activity_id = 587611923729879040 GROUP BY ias.spu_id ) ias_tmp ON sp.id = ias_tmp.spu_id
WHERE
sp.gcm_delete = 0
AND sp.activity_id = 587611923729879040
ORDER BY
sp.activity_sort DESC,
ias_tmp.create_date DESC
;
执行计划和相关表索引如下: