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.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "114.00"
    },
    "table": {
      "table_name": "cscart_product_features",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 540,
      "rows_produced_per_join": 99,
      "filtered": "18.33",
      "cost_info": {
        "read_cost": "94.20",
        "eval_cost": "19.80",
        "prefix_cost": "114.00",
        "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))"
    }
  }
}

Result

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