SELECT 
  product_id, 
  feature_id, 
  variant_id 
FROM 
  cscart_product_features_values 
WHERE 
  product_id IN (
    7464, 
    7465, 
    7466, 
    7467, 
    7468, 
    7469, 
    7470, 
    7478, 
    7479, 
    7480, 
    7481, 
    7482, 
    7483, 
    470, 
    482, 
    483, 
    484, 
    3645, 
    485, 
    3646, 
    486, 
    3647, 
    3648, 
    3632, 
    3627, 
    465, 
    3628, 
    466, 
    467, 
    468, 
    471, 
    478, 
    479, 
    3640, 
    3641, 
    480, 
    3642, 
    469, 
    3629, 
    3630, 
    3631, 
    475, 
    476, 
    3637, 
    3638, 
    477, 
    3639, 
    472, 
    3633, 
    473, 
    3634, 
    3635, 
    3636, 
    474, 
    3643, 
    481, 
    3644, 
    3649, 
    487, 
    3650, 
    489, 
    488, 
    3651, 
    3652, 
    490, 
    3504, 
    3506, 
    504, 
    3665, 
    505, 
    3666, 
    3667, 
    3668, 
    506, 
    3669, 
    507, 
    3670, 
    508, 
    509, 
    510, 
    3671, 
    3854, 
    3855, 
    2973, 
    2974, 
    3856, 
    2975, 
    3656, 
    3657, 
    494, 
    495, 
    496, 
    3658, 
    3659, 
    497, 
    3660, 
    498, 
    499, 
    500, 
    3661, 
    423, 
    3623, 
    424, 
    3624, 
    3625, 
    4231, 
    425, 
    491, 
    492, 
    3653, 
    3654, 
    493, 
    3655, 
    516, 
    517, 
    3677, 
    3678, 
    518, 
    4271, 
    3662, 
    3663, 
    501, 
    502, 
    3664, 
    503, 
    3508, 
    3507, 
    3510, 
    3509, 
    3505
  ) 
  AND feature_id IN (
    627, 623, 622, 626, 553, 625, 624, 628, 
    595
  ) 
  AND lang_code = 'en'

Query time 0.01138

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "262.59"
    },
    "table": {
      "table_name": "cscart_product_features_values",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "fl",
        "lang_code",
        "product_id",
        "fpl",
        "idx_product_feature_variant_id"
      ],
      "key": "idx_product_feature_variant_id",
      "used_key_parts": [
        "product_id",
        "feature_id",
        "lang_code"
      ],
      "key_length": "12",
      "rows_examined_per_scan": 1170,
      "rows_produced_per_join": 1170,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "145.59",
        "eval_cost": "117.00",
        "prefix_cost": "262.59",
        "data_read_per_join": "904K"
      },
      "used_columns": [
        "feature_id",
        "product_id",
        "variant_id",
        "lang_code"
      ],
      "attached_condition": "((`gaseus`.`cscart_product_features_values`.`product_id` in (7464,7465,7466,7467,7468,7469,7470,7478,7479,7480,7481,7482,7483,470,482,483,484,3645,485,3646,486,3647,3648,3632,3627,465,3628,466,467,468,471,478,479,3640,3641,480,3642,469,3629,3630,3631,475,476,3637,3638,477,3639,472,3633,473,3634,3635,3636,474,3643,481,3644,3649,487,3650,489,488,3651,3652,490,3504,3506,504,3665,505,3666,3667,3668,506,3669,507,3670,508,509,510,3671,3854,3855,2973,2974,3856,2975,3656,3657,494,495,496,3658,3659,497,3660,498,499,500,3661,423,3623,424,3624,3625,4231,425,491,492,3653,3654,493,3655,516,517,3677,3678,518,4271,3662,3663,501,502,3664,503,3508,3507,3510,3509,3505)) and (`gaseus`.`cscart_product_features_values`.`feature_id` in (627,623,622,626,553,625,624,628,595)) and (`gaseus`.`cscart_product_features_values`.`lang_code` = 'en'))"
    }
  }
}