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, 1029, 842, 904, 1030, 1031, 
    866, 962, 873, 834, 1032, 1012, 843, 
    844, 845, 846, 600, 847, 1033, 874, 1037, 
    875, 848, 849, 850, 1034, 882, 835, 851, 
    1130, 1088, 876, 1036, 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.00104

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": 99,
      "filtered": "18.37",
      "cost_info": {
        "read_cost": "94.00",
        "eval_cost": "19.80",
        "prefix_cost": "113.80",
        "data_read_per_join": "42K"
      },
      "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,1029,842,904,1030,1031,866,962,873,834,1032,1012,843,844,845,846,600,847,1033,874,1037,875,848,849,850,1034,882,835,851,1130,1088,876,1036,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))"
    }
  }
}