id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1       SIMPLE  ce      index   NULL    CATALOG_PRODUCT_ENTITY_SKU      194     NULL    38719   Using index; Using temporary
1       SIMPLE  ea      ref     EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE     EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE     2       const   240
1       SIMPLE  ce_varchar_0    eq_ref  CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID,CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID      CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID  8       magentodb.ce.entity_id,magentodb.ea.attribute_id,const      1       Using where
1       SIMPLE  ce_varchar_1    eq_ref  CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID,CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID      CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID  8       magentodb.ce.entity_id,magentodb.ea.attribute_id,const      1       Using where
1       SIMPLE  ce_int  ref     CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID,CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID_STORE_ID_VALUE       CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID      6       magentodb.ce.entity_id,magentodb.ea.attribute_id    1       Using where
1       SIMPLE  eao     eq_ref  PRIMARY,EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID       PRIMARY 4       magentodb.ce_varchar_0.value    1       Using where
1       SIMPLE  eaov_0  ref     EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID    EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID    4       magentodb.eao.option_id 1       Using where
1       SIMPLE  eaov_1  ref     EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID    EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID    4       magentodb.eao.option_id 1       Using where
1       SIMPLE  eao2    eq_ref  PRIMARY,EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID       PRIMARY 4       magentodb.ce_int.value  1       Using where
1       SIMPLE  eaov2   ref     EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID    EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID    4       magentodb.eao2.option_id        1       Using where
1       SIMPLE  ce_text ref     CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE_ID    CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID     6       magentodb.ce.entity_id,magentodb.ea.attribute_id        1       Using where
1       SIMPLE  ce_decimal      ref     CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE_ID      CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID  6       magentodb.ce.entity_id,magentodb.ea.attribute_id        1       Using where
1       SIMPLE  ce_datetime     ref     CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID,CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE_ID    CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID 6       magentodb.ce.entity_id,magentodb.ea.attribute_id        1       Using where
1       SIMPLE  eao3    index   NULL    EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID       2       NULL    2447    Using where; Using index; Using join buffer (flat, BNL join)