SELECT 
  product_id, 
  is_stock_split_by_warehouses 
FROM 
  cscart_products 
WHERE 
  product_id IN (
    111, 125, 128, 129, 131, 133, 135, 136, 
    139, 177, 179, 180, 191, 192, 200, 201, 
    202, 203, 204, 211, 212, 213, 214, 215, 
    216, 217, 218, 224, 225, 233, 234, 237, 
    238, 256, 257, 273, 274, 277, 278
  )

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY"],
      "rows": 152,
      "filtered": 25.65789413,
      "attached_condition": "cscart_products.product_id in (111,125,128,129,131,133,135,136,139,177,179,180,191,192,200,201,202,203,204,211,212,213,214,215,216,217,218,224,225,233,234,237,238,256,257,273,274,277,278)"
    }
  }
}

Result

product_id is_stock_split_by_warehouses
111 N
125 N
128 N
129 N
131 N
133 N
135 N
136 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
191 N
192 N
256 N
257 N
211 N
212 N
213 N
214 N
215 N
216 N
217 N
218 N
224 N
225 N
237 N
238 N
277 N
278 N