Explain Query (mysql)

EXPLAIN SELECT `t`.`communication_messages_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`content` AS `t0_c2`, `t`.`start_date` AS `t0_c3`, `t`.`end_date` AS `t0_c4`, `t`.`status` AS `t0_c5`, `t`.`subject` AS `t0_c6`, `t`.`landing_message` AS `t0_c7`, `t`.`image_url` AS `t0_c8`, `t`.`type` AS `t0_c9`, `t`.`cancel_order_popup` AS `t0_c10`, `t`.`sms_content` AS `t0_c11`, `t`.`subject_active_with_activation_required` AS `t0_c12`, `t`.`subject_vacation` AS `t0_c13`, `t`.`subject_incompleted` AS `t0_c14`, `t`.`subject_inactive` AS `t0_c15`, `t`.`content_active` AS `t0_c16`, `t`.`content_active_with_activation_required` AS `t0_c17`, `t`.`content_vacation` AS `t0_c18`, `t`.`content_incompleted` AS `t0_c19`, `t`.`content_inactive` AS `t0_c20`, `t`.`preview` AS `t0_c21`, `t`.`preview_active_with_activation_required` AS `t0_c22`, `t`.`preview_vacation` AS `t0_c23`, `t`.`preview_incompleted` AS `t0_c24`, `t`.`preview_inactive` AS `t0_c25`, `t`.`preview_active` AS `t0_c26`, `i18nCommunicationMessages`.`l_id` AS `t1_c0`, `i18nCommunicationMessages`.`communication_messages_id` AS `t1_c1`, `i18nCommunicationMessages`.`lang_id` AS `t1_c2`, `i18nCommunicationMessages`.`l_content` AS `t1_c3`, `i18nCommunicationMessages`.`l_subject` AS `t1_c4`, `i18nCommunicationMessages`.`l_landing_message` AS `t1_c5`, `i18nCommunicationMessages`.`l_cancel_order_popup` AS `t1_c6`, `i18nCommunicationMessages`.`l_sms_content` AS `t1_c7`, `i18nCommunicationMessages`.`l_subject_active_with_activation_required` AS `t1_c8`, `i18nCommunicationMessages`.`l_subject_vacation` AS `t1_c9`, `i18nCommunicationMessages`.`l_subject_incompleted` AS `t1_c10`, `i18nCommunicationMessages`.`l_subject_inactive` AS `t1_c11`, `i18nCommunicationMessages`.`l_content_active` AS `t1_c12`, `i18nCommunicationMessages`.`l_content_active_with_activation_required` AS `t1_c13`, `i18nCommunicationMessages`.`l_content_vacation` AS `t1_c14`, `i18nCommunicationMessages`.`l_content_incompleted` AS `t1_c15`, `i18nCommunicationMessages`.`l_content_inactive` AS `t1_c16`, `i18nCommunicationMessages`.`l_preview` AS `t1_c17`, `i18nCommunicationMessages`.`l_preview_active_with_activation_required` AS `t1_c18`, `i18nCommunicationMessages`.`l_preview_vacation` AS `t1_c19`, `i18nCommunicationMessages`.`l_preview_incompleted` AS `t1_c20`, `i18nCommunicationMessages`.`l_preview_inactive` AS `t1_c21`, `i18nCommunicationMessages`.`l_preview_active` AS `t1_c22` FROM `communication_messages` `t` LEFT OUTER JOIN `communication_messagesLang` `i18nCommunicationMessages` ON (`i18nCommunicationMessages`.`communication_messages_id`=`t`.`communication_messages_id`) AND (i18nCommunicationMessages.lang_id='fr') WHERE (((status='1') AND (type='0')) AND ('2025-04-17' >= start_date AND end_date >= '2025-04-17')) ORDER BY name

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t		ALL					845	0.12	Using where; Using temporary; Using filesort
1	SIMPLE	i18nCommunicationMessages		ALL					946	100.00	Using where; Using join buffer (hash join)