SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    837, 1143, 1148, 1146, 1147, 1064, 1152, 
    1142, 1149, 865, 867, 1023, 838, 1024, 
    1041, 1125, 1025, 839, 840, 868, 869, 
    860, 870, 1026, 1027, 1043, 871, 1028, 
    841, 872, 1014, 1029, 842, 904, 1030, 
    1017, 1016, 1031, 866, 1013, 962, 873, 
    834, 1032, 1018, 1012, 843, 844, 845, 
    846, 600, 847, 1033, 874, 1037, 875, 
    1019, 848, 849, 850, 1034, 882, 835, 
    851, 1130, 1088, 876, 1036, 1015, 1035, 
    1078, 877, 853, 852, 1022, 854, 1021, 
    855, 856, 878, 879, 817, 741, 782, 622, 
    609, 747, 816, 711, 729, 719, 725, 608, 
    750, 648, 548, 665, 649, 18, 702, 619, 
    968, 960, 963, 1134, 1129
  )

Query time 0.00064

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "113.80"
    },
    "table": {
      "table_name": "cscart_product_features",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 539,
      "rows_produced_per_join": 105,
      "filtered": "19.67",
      "cost_info": {
        "read_cost": "92.60",
        "eval_cost": "21.20",
        "prefix_cost": "113.80",
        "data_read_per_join": "45K"
      },
      "used_columns": [
        "feature_id",
        "feature_type"
      ],
      "attached_condition": "(`webmarco`.`cscart_product_features`.`feature_id` in (837,1143,1148,1146,1147,1064,1152,1142,1149,865,867,1023,838,1024,1041,1125,1025,839,840,868,869,860,870,1026,1027,1043,871,1028,841,872,1014,1029,842,904,1030,1017,1016,1031,866,1013,962,873,834,1032,1018,1012,843,844,845,846,600,847,1033,874,1037,875,1019,848,849,850,1034,882,835,851,1130,1088,876,1036,1015,1035,1078,877,853,852,1022,854,1021,855,856,878,879,817,741,782,622,609,747,816,711,729,719,725,608,750,648,548,665,649,18,702,619,968,960,963,1134,1129))"
    }
  }
}