SELECT 
  product_id, 
  is_stock_split_by_warehouses 
FROM 
  cscart_products 
WHERE 
  product_id IN (
    111, 125, 127, 128, 129, 131, 132, 133, 
    134, 135, 136, 137, 139, 177, 179, 180, 
    191, 192, 200, 201, 202, 203, 204, 211, 
    212, 213, 214, 215, 216, 217, 218, 219, 
    220, 221, 222, 223, 224, 225, 233, 234, 
    237, 238, 256, 257, 260, 261, 262, 263, 
    264, 273, 274, 277, 278, 283, 284, 285, 
    286
  )

Query time 0.00056

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY"],
      "rows": 152,
      "filtered": 37.5,
      "attached_condition": "cscart_products.product_id in (111,125,127,128,129,131,132,133,134,135,136,137,139,177,179,180,191,192,200,201,202,203,204,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,233,234,237,238,256,257,260,261,262,263,264,273,274,277,278,283,284,285,286)"
    }
  }
}

Result

product_id is_stock_split_by_warehouses
111 N
125 N
127 N
128 N
129 N
131 N
132 N
133 N
134 N
135 N
136 N
137 N
139 N
179 N
177 N
233 N
234 N
200 N
201 N
202 N
203 N
204 N
180 N
273 N
274 N
260 N
261 N
262 N
263 N
264 N
191 N
192 N
220 N
256 N
257 N
219 N
211 N
212 N
213 N
214 N
215 N
216 N
217 N
218 N
221 N
222 N
223 N
224 N
225 N
237 N
238 N
277 N
278 N
283 N
284 N
285 N
286 N