Explain Query (mysql)
EXPLAIN SELECT
mp_meal_plans_id,
meal_date,
TIME_FORMAT(time_of_day, '%H:%i') AS time_of_day,
meal_type,
IF('fr' = 'en', recipe_name, recipe_name_fr) AS recipe_name,
cooking_time,
recipe_instructions,
servings,
calories_per_serving,
total_price,
nutrients_list
FROM
mp_meal_plans
WHERE
order_id = '22240692'
ORDER BY
meal_date ASC, time_of_day ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | mp_meal_plans | ref | order_id | order_id | 4 | const | 1 | 100.00 | Using filesort |