| 1 |
SIMPLE |
language.salesChannels |
const |
PRIMARY |
PRIMARY |
16 |
const |
1 |
Using index; Using temporary; Using filesort |
| 1 |
SIMPLE |
language.salesChannelDomains |
ref |
fk.sales_channel_domain.language_id, fk.sales_channel_domain.sales_channel_id |
fk.sales_channel_domain.sales_channel_id |
16 |
const |
2 |
Using index condition |
| 1 |
SIMPLE |
language.salesChannels.mapping |
eq_ref |
PRIMARY, fk.sales_channel_language.language_id |
PRIMARY |
32 |
const, showcase_sw6.language.salesChannelDomains.language_id |
1 |
Using where; Using index |
| 1 |
SIMPLE |
language |
ALL |
PRIMARY, idx.language.language_id_parent_language_id |
|
|
|
3 |
Using where; Using join buffer (flat, BNL join) |