Explain Query (mysql)
EXPLAIN SELECT
DISTINCT recipeIngredients.product_id
FROM
recipeIngredients
INNER JOIN
recipes ON (recipes.recipe_id=recipeIngredients.recipe_id AND recipes.status=1)
WHERE
recipeIngredients.common IN (0,1)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | recipes | ref | PRIMARY, status | status | 2 | const | 183 | 100.00 | Using index; Using temporary | |
| 1 | SIMPLE | recipeIngredients | ref | recipe_id | recipe_id | 5 | securelufacom.recipes.recipe_id | 28 | 20.00 | Using index condition; Using where |