SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    1055, 1151, 1080, 1106, 1107, 1092, 1094, 
    1093, 18, 1152, 1041, 1096, 1057, 549, 
    1046, 1091, 1072, 1059, 1047, 1073, 
    1074, 1113, 1146, 1067, 1061, 45, 1087, 
    1088, 1089, 1044, 1144, 1069, 1143, 
    1145, 1097, 1048, 1103, 1155, 1119, 
    1076, 1114, 1100, 1078, 1079, 1137, 
    1118, 1112, 1098, 1099, 1101, 1056, 
    1052, 1070, 1042, 1142, 1105, 1111, 
    1077, 1066, 1054, 1139, 1138, 1058, 
    1084, 1110, 1116, 1108, 1062, 1043, 
    1053, 1049, 1102, 1104, 548, 1075, 1156, 
    1083, 1060, 1147, 1068, 1120, 1085, 
    1081, 1082, 1109, 1051, 1086, 1045, 
    1153, 1115, 1090, 1117, 1154, 15, 16, 
    1136, 1064, 17, 1071, 1063, 1135, 1140, 
    1141, 1050, 1065
  )

Query time 0.00041

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "32.06"
    },
    "table": {
      "table_name": "cscart_product_features",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 133,
      "rows_produced_per_join": 104,
      "filtered": "78.95",
      "cost_info": {
        "read_cost": "11.06",
        "eval_cost": "21.00",
        "prefix_cost": "32.06",
        "data_read_per_join": "123K"
      },
      "used_columns": [
        "feature_id",
        "feature_type"
      ],
      "attached_condition": "(`danishecarter_25_march`.`cscart_product_features`.`feature_id` in (1055,1151,1080,1106,1107,1092,1094,1093,18,1152,1041,1096,1057,549,1046,1091,1072,1059,1047,1073,1074,1113,1146,1067,1061,45,1087,1088,1089,1044,1144,1069,1143,1145,1097,1048,1103,1155,1119,1076,1114,1100,1078,1079,1137,1118,1112,1098,1099,1101,1056,1052,1070,1042,1142,1105,1111,1077,1066,1054,1139,1138,1058,1084,1110,1116,1108,1062,1043,1053,1049,1102,1104,548,1075,1156,1083,1060,1147,1068,1120,1085,1081,1082,1109,1051,1086,1045,1153,1115,1090,1117,1154,15,16,1136,1064,17,1071,1063,1135,1140,1141,1050,1065))"
    }
  }
}