SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    967, 1027, 987, 1014, 1015, 999, 1001, 
    1000, 18, 1028, 1029, 1030, 1003, 948, 
    549, 949, 1031, 950, 998, 958, 979, 970, 
    951, 984, 980, 978, 1019, 1032, 975, 
    972, 1002, 45, 946, 1033, 994, 995, 996, 
    973, 945, 977, 1004, 952, 1011, 1025, 
    982, 1020, 1008, 985, 986, 1024, 953, 
    1006, 1007, 1009, 955, 962, 964, 961, 
    963, 954, 947, 943, 968, 959, 1005, 1034, 
    1035, 1013, 983, 974, 966, 969, 991, 
    1018, 1022, 1016, 956, 944, 965, 957, 
    1010, 1012, 1036, 1037, 548, 981, 990, 
    971, 1038, 976, 1026, 992, 988, 989, 
    1039, 960, 993, 1040, 1021, 997, 1023, 
    1017
  )

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "31.57"
    },
    "table": {
      "table_name": "cscart_product_features",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 133,
      "rows_produced_per_join": 101,
      "filtered": "76.69",
      "cost_info": {
        "read_cost": "11.17",
        "eval_cost": "20.40",
        "prefix_cost": "31.57",
        "data_read_per_join": "120K"
      },
      "used_columns": [
        "feature_id",
        "feature_type"
      ],
      "attached_condition": "(`danishecarter_25_march`.`cscart_product_features`.`feature_id` in (967,1027,987,1014,1015,999,1001,1000,18,1028,1029,1030,1003,948,549,949,1031,950,998,958,979,970,951,984,980,978,1019,1032,975,972,1002,45,946,1033,994,995,996,973,945,977,1004,952,1011,1025,982,1020,1008,985,986,1024,953,1006,1007,1009,955,962,964,961,963,954,947,943,968,959,1005,1034,1035,1013,983,974,966,969,991,1018,1022,1016,956,944,965,957,1010,1012,1036,1037,548,981,990,971,1038,976,1026,992,988,989,1039,960,993,1040,1021,997,1023,1017))"
    }
  }
}