SELECT 
  feature_id, 
  variant_id, 
  value, 
  value_int 
FROM 
  cscart_product_features_values 
WHERE 
  product_id = 230173 
  AND lang_code = 'en'

Query time 0.00135

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "673.20"
    },
    "table": {
      "table_name": "cscart_product_features_values",
      "access_type": "ref",
      "possible_keys": [
        "lang_code",
        "product_id",
        "idx_product_feature_variant_id"
      ],
      "key": "product_id",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 561,
      "rows_produced_per_join": 27,
      "filtered": "4.94",
      "index_condition": "(`webmarco`.`cscart_product_features_values`.`lang_code` = 'en')",
      "cost_info": {
        "read_cost": "561.00",
        "eval_cost": "5.54",
        "prefix_cost": "673.20",
        "data_read_per_join": "21K"
      },
      "used_columns": [
        "feature_id",
        "product_id",
        "variant_id",
        "value",
        "value_int",
        "lang_code"
      ]
    }
  }
}

Result

feature_id variant_id value value_int
611 8188
621 36925
741 59394
835 59737
865 60108
897 62572
908 62634
909 62636
910 62671
911 62642
912 62675 37.00
914 62647
915 62676 0.00
917 62651
919 62677 0.00
920 62655
921 62659