1 |
PRIMARY |
t_d |
range |
UNQ_CAT_CTGR_ENTT_VCHR_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID |
UNQ_CAT_CTGR_ENTT_VCHR_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID |
10 |
|
6 |
Using index condition |
1 |
PRIMARY |
t_s |
ref |
IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID |
IDX_CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID |
4 |
lalacurio_magn.t_d.entity_id |
5 |
Using where |
2 |
UNION |
t_d |
range |
UNQ_CAT_CTGR_ENTT_DTIME_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID |
IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID |
4 |
|
6 |
Using index condition; Using where |
2 |
UNION |
t_s |
ref |
IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID |
IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID |
4 |
lalacurio_magn.t_d.entity_id |
1 |
Using where |
3 |
UNION |
t_d |
range |
UNQ_CAT_CTGR_ENTT_TEXT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID |
UNQ_CAT_CTGR_ENTT_TEXT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID |
10 |
|
3 |
Using index condition |
3 |
UNION |
t_s |
ref |
IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID |
IDX_CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID |
4 |
lalacurio_magn.t_d.entity_id |
2 |
Using where |
4 |
UNION |
t_d |
range |
UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_CATEGORY_ENTITY_INT_STORE_ID |
UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID |
10 |
|
3 |
Using index condition |
4 |
UNION |
t_s |
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.t_d.entity_id |
3 |
Using where |
|
UNION RESULT |
<union1,2,3,4> |
ALL |
|
|
|
|
|
Using temporary |