| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | product | const | PRIMARY | PRIMARY | 32 | const, const | 1 | 100.00 | ||
| 1 | SIMPLE | product.parent | const | PRIMARY | 1 | 100.00 | Impossible ON condition | ||||
| 1 | SIMPLE | product.translation | const | PRIMARY, fk.product_translation.language_id | PRIMARY | 48 | const, const, const | 1 | 100.00 | Using where | |
| 1 | SIMPLE | product.parent.translation | const | PRIMARY, fk.product_translation.language_id | PRIMARY | 48 | const, const, const | 1 | 100.00 | Using where | |
| 1 | SIMPLE | product.tax | const | PRIMARY | PRIMARY | 16 | const | 1 | 100.00 |