SELECT 
  product_id, 
  feature_id, 
  variant_id 
FROM 
  cscart_product_features_values 
WHERE 
  product_id IN (
    12483, 12484, 12485, 12486, 12487, 12488, 
    12489, 12490, 12491, 12482, 12481, 
    12480, 12479, 12478, 12477, 12476, 
    12475, 12474, 12473, 12472, 12471, 
    12470, 12469, 12468, 12467, 12466, 
    12465, 12464, 12493, 12492
  ) 
  AND feature_id IN (553, 628, 627, 624, 625) 
  AND lang_code = 'en'

Query time 0.00641

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "11.09"
    },
    "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": "PRIMARY",
      "used_key_parts": [
        "feature_id",
        "product_id",
        "variant_id",
        "lang_code"
      ],
      "key_length": "15",
      "rows_examined_per_scan": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "using_index_for_skip_scan": true,
      "cost_info": {
        "read_cost": "7.89",
        "eval_cost": "3.20",
        "prefix_cost": "11.09",
        "data_read_per_join": "24K"
      },
      "used_columns": [
        "feature_id",
        "product_id",
        "variant_id",
        "lang_code"
      ],
      "attached_condition": "((`test2_gaseus`.`cscart_product_features_values`.`product_id` in (12483,12484,12485,12486,12487,12488,12489,12490,12491,12482,12481,12480,12479,12478,12477,12476,12475,12474,12473,12472,12471,12470,12469,12468,12467,12466,12465,12464,12493,12492)) and (`test2_gaseus`.`cscart_product_features_values`.`feature_id` in (553,628,627,624,625)) and (`test2_gaseus`.`cscart_product_features_values`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id feature_id variant_id
12464 553 1935
12465 553 1935
12466 553 1935
12467 553 1935
12468 553 1935
12469 553 1935
12470 553 1935
12471 553 1935
12472 553 1935
12473 553 1935
12474 553 1935
12475 553 1935
12476 553 1935
12477 553 1935
12478 553 1935
12479 553 1935
12480 553 1935
12481 553 1935
12482 553 1935
12483 553 1935
12484 553 1935
12485 553 1935
12486 553 1935
12487 553 1935
12488 553 1935
12489 553 1935
12490 553 1935
12491 553 1935
12492 553 1935
12493 553 1935
12464 624 1705
12465 624 1705
12466 624 1705
12467 624 1705
12468 624 1705
12469 624 1803
12470 624 1803
12471 624 1803
12472 624 1803
12473 624 1803
12474 624 1705
12475 624 1705
12476 624 1705
12477 624 1705
12478 624 1705
12479 624 1803
12480 624 1803
12481 624 1803
12482 624 1803
12483 624 1803
12484 624 1705
12485 624 1705
12486 624 1705
12487 624 1705
12488 624 1705
12489 624 1803
12490 624 1803
12491 624 1803
12492 624 1803
12493 624 1803
12464 625 2413
12465 625 2415
12466 625 2419
12467 625 2420
12468 625 2421
12469 625 2413
12470 625 2415
12471 625 2419
12472 625 2420
12473 625 2421
12474 625 2413
12475 625 2415
12476 625 2419
12477 625 2420
12478 625 2421
12479 625 2413
12480 625 2415
12481 625 2419
12482 625 2420
12483 625 2421
12484 625 2413
12485 625 2415
12486 625 2419
12487 625 2420
12488 625 2421
12489 625 2413
12490 625 2415
12491 625 2419
12492 625 2420
12493 625 2421
12464 627 2290
12465 627 2290
12466 627 2290
12467 627 2290
12468 627 2290
12469 627 2290
12470 627 2290
12471 627 2290
12472 627 2290
12473 627 2290
12474 627 1836
12475 627 1836
12476 627 1836
12477 627 1836
12478 627 1836
12479 627 1836
12480 627 1836
12481 627 1836
12482 627 1836
12483 627 1836
12484 627 1954
12485 627 1954
12486 627 1954
12487 627 1954
12488 627 1954
12489 627 1954
12490 627 1954
12491 627 1954
12492 627 1954
12493 627 1954
12464 628 1660
12465 628 1660
12466 628 1660
12467 628 1660
12468 628 1660
12469 628 1660
12470 628 1660
12471 628 1660
12472 628 1660
12473 628 1660
12474 628 1660
12475 628 1660
12476 628 1660
12477 628 1660
12478 628 1660
12479 628 1660
12480 628 1660
12481 628 1660
12482 628 1660
12483 628 1660
12484 628 1660
12485 628 1660
12486 628 1660
12487 628 1660
12488 628 1660
12489 628 1660
12490 628 1660
12491 628 1660
12492 628 1660
12493 628 1660