id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | 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 | 4 | Using index condition | |
1 | SIMPLE | 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 |