Explain Query (mysql)
EXPLAIN SELECT `t`.`marketplace_family_id` AS `t0_c0`, `t`.`title` AS `t0_c1`, `t`.`description` AS `t0_c2`, `t`.`image_url` AS `t0_c3`, `t`.`weight` AS `t0_c4`, `t`.`status` AS `t0_c5`, `t`.`is_new` AS `t0_c6`, `t`.`slug` AS `t0_c7`, `t`.`nosub` AS `t0_c8`, `t`.`nosub_title` AS `t0_c9`, `t`.`special_feature_text` AS `t0_c10`, `t`.`special_feature_title` AS `t0_c11`, `t`.`special` AS `t0_c12`, `t`.`featured_card_title` AS `t0_c13`, `i18nMarketplaceFamilies`.`l_id` AS `t1_c0`, `i18nMarketplaceFamilies`.`marketplace_family_id` AS `t1_c1`, `i18nMarketplaceFamilies`.`lang_id` AS `t1_c2`, `i18nMarketplaceFamilies`.`l_title` AS `t1_c3`, `i18nMarketplaceFamilies`.`l_description` AS `t1_c4`, `i18nMarketplaceFamilies`.`l_slug` AS `t1_c5`, `i18nMarketplaceFamilies`.`l_nosub_title` AS `t1_c6`, `i18nMarketplaceFamilies`.`l_special_feature_text` AS `t1_c7`, `i18nMarketplaceFamilies`.`l_special_feature_title` AS `t1_c8`, `i18nMarketplaceFamilies`.`l_featured_card_title` AS `t1_c9`, `multilangMarketplaceFamilies`.`l_id` AS `t2_c0`, `multilangMarketplaceFamilies`.`marketplace_family_id` AS `t2_c1`, `multilangMarketplaceFamilies`.`lang_id` AS `t2_c2`, `multilangMarketplaceFamilies`.`l_title` AS `t2_c3`, `multilangMarketplaceFamilies`.`l_description` AS `t2_c4`, `multilangMarketplaceFamilies`.`l_slug` AS `t2_c5`, `multilangMarketplaceFamilies`.`l_nosub_title` AS `t2_c6`, `multilangMarketplaceFamilies`.`l_special_feature_text` AS `t2_c7`, `multilangMarketplaceFamilies`.`l_special_feature_title` AS `t2_c8`, `multilangMarketplaceFamilies`.`l_featured_card_title` AS `t2_c9` FROM `marketplace_families` `t` LEFT OUTER JOIN `marketplace_families_lang` `i18nMarketplaceFamilies` ON (`i18nMarketplaceFamilies`.`marketplace_family_id`=`t`.`marketplace_family_id`) AND (i18nMarketplaceFamilies.lang_id='fr') LEFT OUTER JOIN `marketplace_families_lang` `multilangMarketplaceFamilies` ON (`multilangMarketplaceFamilies`.`marketplace_family_id`=`t`.`marketplace_family_id`) WHERE (`t`.`marketplace_family_id`=87)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | i18nMarketplaceFamilies | ref | marketplace_family_id | marketplace_family_id | 4 | const | 1 | 100.00 | Using where | |
| 1 | SIMPLE | multilangMarketplaceFamilies | ref | marketplace_family_id | marketplace_family_id | 4 | const | 1 | 100.00 |