Explain Query (mysql)

EXPLAIN SELECT `t`.`droppoint_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`address` AS `t0_c2`, `t`.`capacity` AS `t0_c3`, `t`.`closing` AS `t0_c4`, `t`.`zip_code` AS `t0_c5`, `t`.`phone` AS `t0_c6`, `t`.`contact_name` AS `t0_c7`, `t`.`contact_email` AS `t0_c8`, `t`.`delivery_instructions` AS `t0_c9`, `t`.`image_url` AS `t0_c10`, `t`.`lat` AS `t0_c11`, `t`.`lng` AS `t0_c12`, `t`.`top_subtitle` AS `t0_c13`, `t`.`bottom_subtitle` AS `t0_c14`, `t`.`city_name` AS `t0_c15`, `t`.`state_id` AS `t0_c16`, `t`.`fax` AS `t0_c17`, `t`.`logo` AS `t0_c18`, `t`.`website` AS `t0_c19`, `t`.`description` AS `t0_c20`, `t`.`district_id` AS `t0_c21`, `t`.`featured` AS `t0_c22`, `t`.`typepup` AS `t0_c23`, `t`.`summary` AS `t0_c24`, `t`.`meta_description` AS `t0_c25`, `t`.`coordinator_name` AS `t0_c26`, `t`.`coordinator_email` AS `t0_c27`, `t`.`coordinator_phone` AS `t0_c28`, `t`.`priority` AS `t0_c29`, `t`.`published` AS `t0_c30`, `t`.`creation_date` AS `t0_c31`, `t`.`auto_deposit` AS `t0_c32`, `t`.`deposit_amount` AS `t0_c33`, `t`.`fixed_amount` AS `t0_c34`, `t`.`publish_on` AS `t0_c35`, `t`.`unlock_code` AS `t0_c36`, `t`.`slug` AS `t0_c37`, `t`.`droppoint_group_id` AS `t0_c38`, `t`.`primary_contact_id` AS `t0_c39`, `t`.`customer_instructions` AS `t0_c40`, `t`.`territory_id` AS `t0_c41`, `t`.`hd_product_id` AS `t0_c42`, `t`.`fixed_service_time` AS `t0_c43`, `t`.`per_basket_service_time` AS `t0_c44`, `t`.`security_time_buffer` AS `t0_c45`, `t`.`accepts_alcohol` AS `t0_c46`, `t`.`droppoints_basket_id` AS `t0_c47`, `t`.`province` AS `t0_c48`, `i18nDroppoints`.`l_id` AS `t1_c0`, `i18nDroppoints`.`droppoint_id` AS `t1_c1`, `i18nDroppoints`.`lang_id` AS `t1_c2`, `i18nDroppoints`.`l_name` AS `t1_c3`, `i18nDroppoints`.`l_address` AS `t1_c4`, `i18nDroppoints`.`l_delivery_instructions` AS `t1_c5`, `i18nDroppoints`.`l_top_subtitle` AS `t1_c6`, `i18nDroppoints`.`l_bottom_subtitle` AS `t1_c7`, `i18nDroppoints`.`l_city_name` AS `t1_c8`, `i18nDroppoints`.`l_description` AS `t1_c9`, `i18nDroppoints`.`l_summary` AS `t1_c10`, `i18nDroppoints`.`l_meta_description` AS `t1_c11`, `i18nDroppoints`.`l_slug` AS `t1_c12`, `i18nDroppoints`.`l_customer_instructions` AS `t1_c13` FROM `droppoints` `t` LEFT OUTER JOIN `droppointsLang` `i18nDroppoints` ON (`i18nDroppoints`.`droppoint_id`=`t`.`droppoint_id`) AND (i18nDroppoints.lang_id='fr') WHERE (slug = 'lufa-farms-home-delivery-and-pick-up-points-near-me')
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t ALL 1917 10.00 Using where
1 SIMPLE i18nDroppoints ref droppoint_id droppoint_id 4 securelufacom.t.droppoint_id 1 100.00 Using where