Explain Query (mysql)
EXPLAIN SELECT `droppoints`.`droppoint_id` AS `t1_c0`, `droppoints`.`name` AS `t1_c1`, `droppoints`.`address` AS `t1_c2`, `droppoints`.`capacity` AS `t1_c3`, `droppoints`.`closing` AS `t1_c4`, `droppoints`.`zip_code` AS `t1_c5`, `droppoints`.`phone` AS `t1_c6`, `droppoints`.`contact_name` AS `t1_c7`, `droppoints`.`contact_email` AS `t1_c8`, `droppoints`.`delivery_instructions` AS `t1_c9`, `droppoints`.`image_url` AS `t1_c10`, `droppoints`.`lat` AS `t1_c11`, `droppoints`.`lng` AS `t1_c12`, `droppoints`.`top_subtitle` AS `t1_c13`, `droppoints`.`bottom_subtitle` AS `t1_c14`, `droppoints`.`city_name` AS `t1_c15`, `droppoints`.`state_id` AS `t1_c16`, `droppoints`.`fax` AS `t1_c17`, `droppoints`.`logo` AS `t1_c18`, `droppoints`.`website` AS `t1_c19`, `droppoints`.`description` AS `t1_c20`, `droppoints`.`district_id` AS `t1_c21`, `droppoints`.`featured` AS `t1_c22`, `droppoints`.`typepup` AS `t1_c23`, `droppoints`.`summary` AS `t1_c24`, `droppoints`.`meta_description` AS `t1_c25`, `droppoints`.`coordinator_name` AS `t1_c26`, `droppoints`.`coordinator_email` AS `t1_c27`, `droppoints`.`coordinator_phone` AS `t1_c28`, `droppoints`.`priority` AS `t1_c29`, `droppoints`.`published` AS `t1_c30`, `droppoints`.`creation_date` AS `t1_c31`, `droppoints`.`auto_deposit` AS `t1_c32`, `droppoints`.`deposit_amount` AS `t1_c33`, `droppoints`.`fixed_amount` AS `t1_c34`, `droppoints`.`publish_on` AS `t1_c35`, `droppoints`.`unlock_code` AS `t1_c36`, `droppoints`.`slug` AS `t1_c37`, `droppoints`.`droppoint_group_id` AS `t1_c38`, `droppoints`.`primary_contact_id` AS `t1_c39`, `droppoints`.`customer_instructions` AS `t1_c40`, `droppoints`.`territory_id` AS `t1_c41`, `droppoints`.`hd_product_id` AS `t1_c42`, `droppoints`.`fixed_service_time` AS `t1_c43`, `droppoints`.`per_basket_service_time` AS `t1_c44`, `droppoints`.`security_time_buffer` AS `t1_c45`, `droppoints`.`accepts_alcohol` AS `t1_c46`, `droppoints`.`droppoints_basket_id` AS `t1_c47`, `droppoints`.`province` AS `t1_c48`, `i18nDroppoints`.`l_id` AS `t2_c0`, `i18nDroppoints`.`droppoint_id` AS `t2_c1`, `i18nDroppoints`.`lang_id` AS `t2_c2`, `i18nDroppoints`.`l_name` AS `t2_c3`, `i18nDroppoints`.`l_address` AS `t2_c4`, `i18nDroppoints`.`l_delivery_instructions` AS `t2_c5`, `i18nDroppoints`.`l_top_subtitle` AS `t2_c6`, `i18nDroppoints`.`l_bottom_subtitle` AS `t2_c7`, `i18nDroppoints`.`l_city_name` AS `t2_c8`, `i18nDroppoints`.`l_description` AS `t2_c9`, `i18nDroppoints`.`l_summary` AS `t2_c10`, `i18nDroppoints`.`l_meta_description` AS `t2_c11`, `i18nDroppoints`.`l_slug` AS `t2_c12`, `i18nDroppoints`.`l_customer_instructions` AS `t2_c13` FROM `droppoints` `droppoints` LEFT OUTER JOIN `droppointsLang` `i18nDroppoints` ON (`i18nDroppoints`.`droppoint_id`=`droppoints`.`droppoint_id`) AND (i18nDroppoints.lang_id='fr') WHERE (`droppoints`.`droppoint_id`='1810')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | droppoints | const | PRIMARY, droppoints_idx_droppoint_id_hd_id | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | i18nDroppoints | ref | droppoint_id | droppoint_id | 4 | const | 1 | 100.00 | Using where |