1 |
SIMPLE |
product_media |
|
ref |
fk.product_media.product_id |
fk.product_media.product_id |
16 |
const |
1 |
10.00 |
Using index condition; Using temporary; Using filesort |
1 |
SIMPLE |
product_media.media |
|
eq_ref |
PRIMARY |
PRIMARY |
16 |
production_staging_6612.product_media.media_id |
1 |
100.00 |
|
1 |
SIMPLE |
product_media.media.translation |
|
eq_ref |
PRIMARY, fk.media_translation.language_id |
PRIMARY |
32 |
production_staging_6612.product_media.media.id, const |
1 |
100.00 |
Using where |
1 |
SIMPLE |
product_media.media.media |
|
ALL |
|
|
|
|
3187 |
100.00 |
Using where; Using join buffer (hash join) |