SELECT 
  product_id, 
  is_stock_split_by_warehouses 
FROM 
  cscart_products 
WHERE 
  product_id IN (
    111, 113, 115, 133, 136, 139, 141, 143, 
    144, 145, 147, 148, 158, 159, 179, 180, 
    191, 192, 195, 196, 211, 212, 213, 214, 
    215, 216, 217, 218, 226, 227, 275, 276, 
    277, 278, 279, 280, 281, 282, 287, 288, 
    289, 290
  )

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "ALL",
      "possible_keys": ["PRIMARY"],
      "rows": 152,
      "filtered": 27.63157845,
      "attached_condition": "cscart_products.product_id in (111,113,115,133,136,139,141,143,144,145,147,148,158,159,179,180,191,192,195,196,211,212,213,214,215,216,217,218,226,227,275,276,277,278,279,280,281,282,287,288,289,290)"
    }
  }
}

Result

product_id is_stock_split_by_warehouses
111 N
113 N
115 N
289 N
133 N
136 N
139 N
141 N
143 N
144 N
145 N
147 N
148 N
158 N
159 N
179 N
180 N
191 N
192 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
226 N
227 N
275 N
276 N
277 N
278 N
279 N
280 N
287 N
288 N