| 1 |
SIMPLE |
product.categoriesRo |
ref |
PRIMARY |
PRIMARY |
16 |
const |
1 |
Using where; Using index; Using temporary; Using filesort |
| 1 |
SIMPLE |
product.categoriesRo.mapping |
ref |
PRIMARY, fk.product_category_tree.category_id |
fk.product_category_tree.category_id |
32 |
const, showcase_sw6.product.categoriesRo.version_id |
3 |
Using where; Using index |
| 1 |
SIMPLE |
product |
eq_ref |
PRIMARY |
PRIMARY |
32 |
showcase_sw6.product.categoriesRo.mapping.product_id, const |
1 |
Using where |
| 1 |
SIMPLE |
product.visibilities |
eq_ref |
uniq.product_id__sales_channel_id, idx.product_visibility.product_id, idx.product_visibility.sales_channel_id |
uniq.product_id__sales_channel_id |
48 |
showcase_sw6.product.visibilities, const, const |
1 |
Using index condition; Using where |
| 1 |
SIMPLE |
product.parent |
eq_ref |
PRIMARY |
PRIMARY |
32 |
showcase_sw6.product.parent_id, const |
1 |
Using where |
| 1 |
SIMPLE |
product.properties.mapping |
ref |
PRIMARY |
PRIMARY |
32 |
showcase_sw6.product.properties, const |
2 |
Using where; Using index |
| 1 |
SIMPLE |
product.properties |
eq_ref |
PRIMARY |
PRIMARY |
16 |
showcase_sw6.product.properties.mapping.property_group_option_id |
1 |
Using where; Using index |