1 |
SIMPLE |
sales_channel |
ref |
PRIMARY, fk.sales_channel.type_id |
fk.sales_channel.type_id |
16 |
const |
1 |
Using index condition; Using where |
1 |
SIMPLE |
theme_sales_channel |
eq_ref |
PRIMARY |
PRIMARY |
16 |
showcase_sw6.sales_channel.id |
1 |
|
1 |
SIMPLE |
theme |
eq_ref |
PRIMARY |
PRIMARY |
16 |
showcase_sw6.theme_sales_channel.theme_id |
1 |
Using where |
1 |
SIMPLE |
parentTheme |
eq_ref |
PRIMARY |
PRIMARY |
16 |
showcase_sw6.theme.parent_theme_id |
1 |
Using where |
1 |
SIMPLE |
snippet_set |
ALL |
PRIMARY |
|
|
|
2 |
Using join buffer (flat, BNL join) |
1 |
SIMPLE |
domain |
ALL |
fk.sales_channel_domain.snippet_set_id, fk.sales_channel_domain.sales_channel_id |
|
|
|
3 |
Using where; Using join buffer (incremental, BNL join) |