SELECT 
  product_id, 
  is_stock_split_by_warehouses 
FROM 
  cscart_products 
WHERE 
  product_id IN (
    111, 113, 115, 125, 129, 131, 133, 136, 
    139, 140, 141, 142, 143, 144, 145, 146, 
    147, 148, 149, 150, 158, 159, 177, 179, 
    180, 181, 182, 183, 184, 191, 192, 193, 
    194, 195, 196, 211, 212, 213, 214, 215, 
    216, 217, 218, 224, 225, 226, 227, 233, 
    234, 237, 238, 258, 259, 273, 274, 275, 
    276, 277, 278, 279, 280, 281, 282, 287, 
    288, 289, 290, 293, 294
  )

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY"],
      "rows": 152,
      "filtered": 45.39473724,
      "attached_condition": "cscart_products.product_id in (111,113,115,125,129,131,133,136,139,140,141,142,143,144,145,146,147,148,149,150,158,159,177,179,180,181,182,183,184,191,192,193,194,195,196,211,212,213,214,215,216,217,218,224,225,226,227,233,234,237,238,258,259,273,274,275,276,277,278,279,280,281,282,287,288,289,290,293,294)"
    }
  }
}

Result

product_id is_stock_split_by_warehouses
111 N
113 N
181 N
115 N
289 N
125 N
129 N
131 N
133 N
136 N
139 N
140 N
141 N
142 N
143 N
144 N
145 N
146 N
147 N
148 N
149 N
150 N
158 N
159 N
179 N
177 N
233 N
234 N
180 N
182 N
183 N
184 N
273 N
274 N
258 N
191 N
192 N
193 N
194 N
195 N
196 N
290 N
282 N
281 N
211 N
212 N
213 N
214 N
215 N
216 N
217 N
218 N
224 N
225 N
226 N
227 N
237 N
238 N
259 N
275 N
276 N
277 N
278 N
279 N
280 N
287 N
288 N
293 N
294 N