1 |
SIMPLE |
m |
range |
IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID |
IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID |
767 |
|
4 |
Using where; Using index |
1 |
SIMPLE |
d |
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.m.entity_id |
3 |
Using where |
1 |
SIMPLE |
c |
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) |