explain SELECT ps.`id_product`, ps.`id_shop`, pl.`id_lang`, ps.`date_upd` AS `product_updated`,
eis.`date_upd` AS `product_indexed`
FROM `ps_product_shop` ps
LEFT JOIN `ps_product_lang` `pl` ON pl.`id_product` = ps.`id_pr[CSV][/CSV]oduct`
LEFT JOIN `ps_elasticsearch_index_status` `eis` ON ps.`id_product` = eis.`id_product` AND ps.`id_shop` = eis.`id_shop` AND eis.`id_lang` = pl.`id_lang`
INNER JOIN `ps_lang` l ON pl.`id_lang` = l.`id_lang` AND l.`active` = 1
WHERE (ps.`id_shop` = 1) AND (ps.`date_upd` != eis.`date_upd` OR eis.`date_upd` IS NULL)
GROUP BY ps.`id_product`, ps.`id_shop`, pl.`id_lang`
LIMIT 100