SELECT 
  product_id, 
  feature_id, 
  variant_id 
FROM 
  cscart_product_features_values 
WHERE 
  product_id IN (
    13159, 13160, 13161, 13157, 13158, 13155, 
    13156, 13152, 13154, 13150, 13151, 
    13153
  ) 
  AND feature_id IN (
    595, 628, 627, 624, 625, 553, 626, 622, 
    623, 646, 647, 636, 637
  ) 
  AND lang_code = 'en'

Query time 0.00743

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "9.73"
    },
    "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": 27,
      "rows_produced_per_join": 27,
      "filtered": "100.00",
      "using_index_for_skip_scan": true,
      "cost_info": {
        "read_cost": "7.03",
        "eval_cost": "2.70",
        "prefix_cost": "9.73",
        "data_read_per_join": "20K"
      },
      "used_columns": [
        "feature_id",
        "product_id",
        "variant_id",
        "lang_code"
      ],
      "attached_condition": "((`test2_gaseus`.`cscart_product_features_values`.`product_id` in (13159,13160,13161,13157,13158,13155,13156,13152,13154,13150,13151,13153)) and (`test2_gaseus`.`cscart_product_features_values`.`feature_id` in (595,628,627,624,625,553,626,622,623,646,647,636,637)) and (`test2_gaseus`.`cscart_product_features_values`.`lang_code` = 'en'))"
    }
  }
}

Result

product_id feature_id variant_id
13150 553 1912
13151 553 1912
13152 553 1912
13153 553 1912
13154 553 1912
13155 553 1912
13156 553 1912
13157 553 1912
13158 553 1912
13159 553 1912
13160 553 1912
13161 553 1912
13150 595 1905
13151 595 1905
13152 595 1789
13153 595 1789
13154 595 2499
13155 595 2499
13156 595 1787
13157 595 1787
13158 595 1900
13159 595 1900
13160 595 1899
13161 595 1899
13150 622 2497
13151 622 2497
13152 622 2497
13153 622 2497
13154 622 2497
13155 622 2497
13156 622 2497
13157 622 2497
13158 622 2497
13159 622 2497
13160 622 2497
13161 622 2497
13150 623 2524
13151 623 2524
13152 623 2524
13153 623 2524
13154 623 2524
13155 623 2524
13156 623 2524
13157 623 2524
13158 623 2524
13159 623 2524
13160 623 2524
13161 623 2524
13150 624 1803
13151 624 1803
13152 624 1803
13153 624 1803
13154 624 1803
13155 624 1803
13156 624 1803
13157 624 1803
13158 624 1803
13159 624 1803
13160 624 1803
13161 624 1803
13150 625 2122
13151 625 2122
13152 625 2122
13153 625 2122
13154 625 2122
13155 625 2122
13156 625 2122
13157 625 2122
13158 625 2122
13159 625 2122
13160 625 2122
13161 625 2122
13150 626 1928
13151 626 1928
13152 626 1928
13153 626 1928
13154 626 1928
13155 626 1928
13156 626 1928
13157 626 1928
13158 626 1928
13159 626 1928
13160 626 1928
13161 626 1928
13150 627 2378
13151 627 2378
13152 627 2378
13153 627 2378
13154 627 2378
13155 627 2378
13156 627 2378
13157 627 2378
13158 627 2378
13159 627 2378
13160 627 2378
13161 627 2378
13150 628 1712
13151 628 1712
13152 628 1712
13153 628 1712
13154 628 1712
13155 628 1712
13156 628 1712
13157 628 1712
13158 628 1712
13159 628 1712
13160 628 1712
13161 628 1712
13150 636 2348
13151 636 2348
13152 636 2348
13153 636 2348
13154 636 2348
13155 636 2348
13156 636 2348
13157 636 2348
13158 636 2348
13159 636 2348
13160 636 2348
13161 636 2348
13150 637 2345
13151 637 2345
13152 637 2345
13153 637 2345
13154 637 2345
13155 637 2345
13156 637 2345
13157 637 2345
13158 637 2345
13159 637 2345
13160 637 2345
13161 637 2345
13150 646 2369
13151 646 2370
13152 646 2369
13153 646 2370
13154 646 2369
13155 646 2370
13156 646 2369
13157 646 2370
13158 646 2369
13159 646 2370
13160 646 2369
13161 646 2370
13150 647 2373
13151 647 2374
13152 647 2373
13153 647 2374
13154 647 2373
13155 647 2374
13156 647 2373
13157 647 2374
13158 647 2373
13159 647 2374
13160 647 2373
13161 647 2374