| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | product_review.product | index_merge | PRIMARY, fk.product.parent_id | fk.product.parent_id, PRIMARY | 17, 16 | 2 | Using sort_union(fk.product.parent_id, PRIMARY); Using where; Using temporary; Using filesort | |
| 1 | SIMPLE | product_review | ref | fk.product_review.product_id | fk.product_review.product_id | 32 | look-beautiful_staging.product_review.product.id, look-beautiful_staging.product_review.product.version_id | 1 | Using where |