Explain Query (mysql)
EXPLAIN SELECT `t`.`recipe_id` AS `t0_c0`, `t`.`name` AS `t0_c1`, `t`.`prep_time` AS `t0_c2`, `t`.`cook_time` AS `t0_c3`, `t`.`total_time` AS `t0_c4`, `t`.`image_url` AS `t0_c5`, `t`.`description` AS `t0_c6`, `t`.`steps` AS `t0_c7`, `t`.`extra_ingredients` AS `t0_c8`, `t`.`created_at_date` AS `t0_c9`, `t`.`created_at_time` AS `t0_c10`, `t`.`updated_at_date` AS `t0_c11`, `t`.`updated_at_time` AS `t0_c12`, `t`.`status` AS `t0_c13`, `t`.`portions` AS `t0_c14`, `t`.`instructions_list_product_id` AS `t0_c15`, `t`.`subcategory_id` AS `t0_c16`, `t`.`featured` AS `t0_c17`, `t`.`pdf_url` AS `t0_c18`, `t`.`is_bundle` AS `t0_c19`, `t`.`is_new` AS `t0_c20`, `t`.`first_published_at_date` AS `t0_c21`, `t`.`marketplace_family_id` AS `t0_c22`, `recipesLang`.`recipe_id` AS `t1_c0`, `recipesLang`.`l_name` AS `t1_c1`, `recipesLang`.`l_description` AS `t1_c2`, `recipesLang`.`l_steps` AS `t1_c3`, `recipesLang`.`l_extra_ingredients` AS `t1_c4`, `recipesLang`.`lang_id` AS `t1_c5`, `recipesLang`.`l_pdf_url` AS `t1_c6`, `sub_category`.`subcategory_id` AS `t7_c0`, `sub_category`.`category_id` AS `t7_c1`, `sub_category`.`name` AS `t7_c2`, `sub_category`.`weight` AS `t7_c3`, `sub_category`.`linked_subcategory_id` AS `t7_c4`, `i18nProductSubCategories`.`l_id` AS `t8_c0`, `i18nProductSubCategories`.`subcategory_id` AS `t8_c1`, `i18nProductSubCategories`.`lang_id` AS `t8_c2`, `i18nProductSubCategories`.`l_name` AS `t8_c3` FROM `recipes` `t` LEFT OUTER JOIN `recipesLang` `recipesLang` ON (`recipesLang`.`recipe_id`=`t`.`recipe_id`) AND (recipesLang.lang_id='fr') LEFT OUTER JOIN `productSubCategories` `sub_category` ON (`t`.`subcategory_id`=`sub_category`.`subcategory_id`) LEFT OUTER JOIN `productSubCategoriesLang` `i18nProductSubCategories` ON (`i18nProductSubCategories`.`subcategory_id`=`sub_category`.`subcategory_id`) AND (i18nProductSubCategories.lang_id='fr') WHERE (t.status = 1 OR t.recipe_id IN (0) ) ORDER BY t.name ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | index_merge | PRIMARY, status | status, PRIMARY | 2, 4 | 184 | 100.00 | Using union (status, PRIMARY); Using where; Using filesort | ||
| 1 | SIMPLE | recipesLang | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.t.recipe_id | 1 | 100.00 | Using where | |
| 1 | SIMPLE | sub_category | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.t.subcategory_id | 1 | 100.00 | ||
| 1 | SIMPLE | i18nProductSubCategories | ref | subcategory_id | subcategory_id | 4 | securelufacom.sub_category.subcategory_id | 1 | 100.00 | Using where |