1 |
SIMPLE |
e |
range |
PRIMARY,IDX_CATALOG_CATEGORY_ENTITY_LEVEL |
PRIMARY |
4 |
|
5 |
Using where; Using temporary; Using filesort |
1 |
SIMPLE |
at_custom_use_parent_settings_default |
ref |
IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID |
IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID |
4 |
lalacurio_magn.e.entity_id |
3 |
Using where |
1 |
SIMPLE |
at_custom_use_parent_settings |
index_merge |
IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID |
IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID |
2,2 |
|
1 |
Using intersect(IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID); Using where; Using join buffer (Block Nested Loop) |