1 |
PRIMARY |
attr_table |
ref |
UNQ_CAT_PRD_ENTT_VCHR_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID,IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID |
UNQ_CAT_PRD_ENTT_VCHR_ENTT_ID_ATTR_ID_STORE_ID |
4 |
const |
19 |
Using index condition |
1 |
PRIMARY |
set_table |
eq_ref |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID |
4 |
const,lalacurio_magn.attr_table.attribute_id |
1 |
Using index |
2 |
UNION |
attr_table |
ref |
UNQ_CAT_PRD_ENTT_DEC_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID,IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE_ID |
UNQ_CAT_PRD_ENTT_DEC_ENTT_ID_ATTR_ID_STORE_ID |
4 |
const |
4 |
Using index condition |
2 |
UNION |
set_table |
eq_ref |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID |
4 |
const,lalacurio_magn.attr_table.attribute_id |
1 |
Using index |
3 |
UNION |
attr_table |
ref |
UNQ_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID,IDX_CATALOG_PRODUCT_ENTITY_INT_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID |
UNQ_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID |
4 |
const |
6 |
Using index condition |
3 |
UNION |
set_table |
eq_ref |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID |
4 |
const,lalacurio_magn.attr_table.attribute_id |
1 |
Using index |
4 |
UNION |
attr_table |
ref |
UNQ_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE_ID,IDX_CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID |
UNQ_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID |
4 |
const |
4 |
Using index condition |
4 |
UNION |
set_table |
eq_ref |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID |
4 |
const,lalacurio_magn.attr_table.attribute_id |
1 |
Using index |
5 |
UNION |
attr_table |
ref |
UNQ_CAT_PRD_ENTT_DTIME_ENTT_ID_ATTR_ID_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE_ID,IDX_CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID,IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID |
UNQ_CAT_PRD_ENTT_DTIME_ENTT_ID_ATTR_ID_STORE_ID |
4 |
const |
6 |
Using index condition |
5 |
UNION |
set_table |
eq_ref |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER,IDX_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID |
UNQ_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID |
4 |
const,lalacurio_magn.attr_table.attribute_id |
1 |
Using index |
|
UNION RESULT |
<union1,2,3,4,5> |
ALL |
|
|
|
|
|
Using temporary; Using filesort |