SELECT 
  feature_id, 
  feature_type 
FROM 
  cscart_product_features 
WHERE 
  feature_id IN (
    307, 
    231, 
    146, 
    147, 
    232, 
    56, 
    157, 
    248, 
    308, 
    260, 
    249, 
    174, 
    175, 
    164, 
    49, 
    238, 
    193, 
    140, 
    275, 
    211, 
    212, 
    217, 
    202, 
    234, 
    289, 
    288, 
    286, 
    155, 
    273, 
    195, 
    312, 
    172, 
    127, 
    227, 
    149, 
    179, 
    152, 
    186, 
    135, 
    30, 
    159, 
    109, 
    310, 
    284, 
    123, 
    136, 
    129, 
    130, 
    137, 
    325, 
    321, 
    322, 
    263, 
    48, 
    313, 
    239, 
    311, 
    309, 
    142, 
    184, 
    163, 
    188, 
    113, 
    251, 
    256, 
    320, 
    225, 
    222, 
    255, 
    44, 
    258, 
    315, 
    158, 
    57, 
    233, 
    201, 
    167, 
    25, 
    161, 
    276, 
    252, 
    259, 
    262, 
    115, 
    122, 
    323, 
    316, 
    50, 
    59, 
    200, 
    224, 
    208, 
    220, 
    181, 
    274, 
    117, 
    240, 
    245, 
    46, 
    51, 
    219, 
    221, 
    272, 
    226, 
    156, 
    265, 
    317, 
    324, 
    183, 
    166, 
    176, 
    160, 
    264, 
    132, 
    270, 
    269, 
    148, 
    168, 
    54, 
    47, 
    253, 
    279, 
    35, 
    210, 
    111, 
    150, 
    154, 
    24, 
    13, 
    27, 
    180, 
    153, 
    173, 
    214, 
    177, 
    223, 
    228, 
    192, 
    58, 
    261, 
    162, 
    218, 
    206, 
    182, 
    250, 
    257, 
    190, 
    26, 
    268, 
    55, 
    125, 
    283, 
    282, 
    45, 
    285, 
    28, 
    230, 
    121, 
    114, 
    145, 
    141, 
    120, 
    119, 
    118, 
    278, 
    280, 
    281, 
    277, 
    207, 
    187, 
    116, 
    169, 
    199, 
    197, 
    198, 
    209, 
    215, 
    243, 
    242, 
    247, 
    236, 
    246, 
    241, 
    235, 
    244, 
    216, 
    165, 
    205, 
    204, 
    203, 
    267, 
    266, 
    134, 
    185, 
    171, 
    191, 
    60, 
    254, 
    131, 
    29, 
    271, 
    229, 
    144, 
    143, 
    139, 
    290, 
    292, 
    293, 
    291, 
    294, 
    319, 
    318, 
    314, 
    213, 
    287, 
    31, 
    189, 
    194, 
    126, 
    112, 
    133
  )

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.05733942,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_features",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "loops": 1,
          "rows": 284,
          "cost": 0.05733942,
          "filtered": 77.81690216,
          "attached_condition": "cscart_product_features.feature_id in (307,231,146,147,232,56,157,248,308,260,249,174,175,164,49,238,193,140,275,211,212,217,202,234,289,288,286,155,273,195,312,172,127,227,149,179,152,186,135,30,159,109,310,284,123,136,129,130,137,325,321,322,263,48,313,239,311,309,142,184,163,188,113,251,256,320,225,222,255,44,258,315,158,57,233,201,167,25,161,276,252,259,262,115,122,323,316,50,59,200,224,208,220,181,274,117,240,245,46,51,219,221,272,226,156,265,317,324,183,166,176,160,264,132,270,269,148,168,54,47,253,279,35,210,111,150,154,24,13,27,180,153,173,214,177,223,228,192,58,261,162,218,206,182,250,257,190,26,268,55,125,283,282,45,285,28,230,121,114,145,141,120,119,118,278,280,281,277,207,187,116,169,199,197,198,209,215,243,242,247,236,246,241,235,244,216,165,205,204,203,267,266,134,185,171,191,60,254,131,29,271,229,144,143,139,290,292,293,291,294,319,318,314,213,287,31,189,194,126,112,133)"
        }
      }
    ]
  }
}

Result

feature_id feature_type
29 S
13 E
126 S
127 M
109 M
118 S
119 S
120 S
121 S
25 S
26 S
27 S
28 S
30 M
31 S
35 E
111 S
112 S
113 S
114 S
115 S
116 M
117 S
122 S
123 S
54 S
44 S
45 S
46 S
47 S
48 S
49 S
50 S
51 S
55 E
59 S
60 S
132 S
135 M
139 S
140 S
141 S
142 S
143 S
144 S
145 S
146 S
147 S
148 S
149 M
150 S
152 M
153 S
154 S
155 S
156 S
157 S
158 M
159 M
160 M
161 S
162 S
163 S
164 S
165 S
166 S
167 M
168 M
169 S
171 S
172 M
173 S
174 S
175 S
176 S
177 M
179 S
180 S
181 S
182 S
183 S
184 S
185 S
186 M
187 S
188 S
189 S
190 S
191 S
192 S
193 S
194 S
195 S
197 S
198 S
199 S
200 S
201 M
202 S
203 M
204 S
205 S
206 S
207 S
208 S
209 S
210 S
211 S
212 S
213 M
214 S
215 S
216 S
217 S
218 S
219 S
220 M
221 S
222 S
223 M
224 S
225 S
226 S
227 M
228 M
229 M
230 M
231 M
232 M
233 S
234 S
235 S
236 S
238 S
239 M
240 M
241 M
242 S
243 M
244 S
245 S
246 S
247 S
248 S
249 S
250 S
251 S
252 S
253 M
254 M
255 S
256 S
257 S
258 M
259 M
260 S
261 S
262 S
263 S
264 M
265 S
266 S
267 M
268 S
269 S
270 M
271 S
272 S
273 S
274 S
275 S
276 S
277 S
278 S
279 S
280 S
281 S
282 S
283 S
284 S
285 S
286 S
287 S
288 S
289 S
24 E
125 S
129 S
56 S
130 S
57 S
58 S
131 S
133 S
134 S
136 S
137 S
290 M
291 S
292 S
293 S
294 S
307 S
308 S
309 S
310 M
311 S
312 M
313 S
314 S
315 M
316 S
317 S
318 S
319 S
320 S
321 M
322 S
323 S
324 S
325 S