| 1 |
SIMPLE |
country_state.country.salesChannels |
const |
PRIMARY |
PRIMARY |
16 |
const |
1 |
Using index |
| 1 |
SIMPLE |
country_state |
range |
fk.country_state.country_id |
fk.country_state.country_id |
16 |
|
18 |
Using index condition |
| 1 |
SIMPLE |
country_state.country.salesChannels.mapping |
eq_ref |
PRIMARY, fk.sales_channel_country.country_id |
PRIMARY |
32 |
const, showcase_sw6.country_state.country_id |
1 |
Using where; Using index |
| 1 |
SIMPLE |
country_state.country |
eq_ref |
PRIMARY |
PRIMARY |
16 |
showcase_sw6.country_state.country_id |
1 |
Using index |
| 1 |
SIMPLE |
country_state.translation |
eq_ref |
PRIMARY, fk.country_state_translation.language_id |
PRIMARY |
32 |
showcase_sw6.country_state.id, const |
1 |
Using where |