Sandbox

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, 
    1074, 
    600, 
    1133, 
    847, 
    1033, 
    1040, 
    874, 
    1037, 
    875, 
    1019, 
    848, 
    849, 
    1059, 
    850, 
    1005, 
    1034, 
    882, 
    835, 
    851, 
    1067, 
    1130, 
    1088, 
    876, 
    1036, 
    1015, 
    1035, 
    1120, 
    1119, 
    1118, 
    1121, 
    1124, 
    1078, 
    1077, 
    877, 
    1094, 
    853, 
    1038, 
    852, 
    1022, 
    854, 
    1021, 
    855, 
    856, 
    878, 
    879, 
    1039, 
    1071, 
    817, 
    741, 
    707, 
    1095, 
    766, 
    782, 
    770, 
    622, 
    660, 
    609, 
    704, 
    1096, 
    645, 
    815, 
    771, 
    772, 
    774, 
    747, 
    816, 
    663, 
    765, 
    711, 
    756, 
    706, 
    1097, 
    751, 
    729, 
    719, 
    725, 
    29, 
    733, 
    608, 
    750, 
    743, 
    669, 
    757, 
    670, 
    648, 
    773, 
    548, 
    665, 
    758, 
    649, 
    581, 
    760, 
    18, 
    28, 
    759, 
    601, 
    726, 
    761, 
    762, 
    702, 
    619, 
    554, 
    15, 
    968, 
    605, 
    606, 
    16, 
    960, 
    17, 
    963, 
    1004, 
    1134, 
    1129
  )

Query time 0.00116

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": 162,
      "filtered": "30.24",
      "cost_info": {
        "read_cost": "81.20",
        "eval_cost": "32.60",
        "prefix_cost": "113.80",
        "data_read_per_join": "70K"
      },
      "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,1074,600,1133,847,1033,1040,874,1037,875,1019,848,849,1059,850,1005,1034,882,835,851,1067,1130,1088,876,1036,1015,1035,1120,1119,1118,1121,1124,1078,1077,877,1094,853,1038,852,1022,854,1021,855,856,878,879,1039,1071,817,741,707,1095,766,782,770,622,660,609,704,1096,645,815,771,772,774,747,816,663,765,711,756,706,1097,751,729,719,725,29,733,608,750,743,669,757,670,648,773,548,665,758,649,581,760,18,28,759,601,726,761,762,702,619,554,15,968,605,606,16,960,17,963,1004,1134,1129))"
    }
  }
}

Result

feature_id	feature_type
15	S
16	S
17	S
18	E
28	S
29	S
548	S
554	S
581	S
600	M
601	S
605	S
606	S
608	S
609	S
619	S
622	S
645	M
648	S
649	S
660	S
663	S
665	S
669	S
670	S
702	S
704	S
706	M
707	M
711	S
719	S
725	S
726	S
729	M
733	M
741	M
743	S
747	M
750	M
751	M
756	S
757	S
758	M
759	S
760	S
761	S
762	M
765	M
766	S
770	S
771	S
772	S
773	S
774	S
782	S
815	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
1004	S
1005	S
1012	E
1013	S
1014	M
1015	M
1016	M
1017	M
1018	M
1019	M
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
1038	S
1039	M
1040	M
1041	M
1043	M
1059	S
1064	S
1067	S
1071	E
1074	E
1077	S
1078	S
1088	S
1094	S
1095	S
1096	S
1097	S
1118	M
1119	M
1120	S
1121	S
1124	S
1125	M
1129	S
1130	S
1133	S
1134	S
1142	S
1143	S
1146	S
1147	S
1148	S
1149	S
1152	M