SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2788, 2612, 15385, 2608, 2609, 2561, 
    2610, 2611, 2571, 2317, 2318, 12754, 
    11610, 11606, 11818, 11607, 11608, 
    14076, 14077, 11135, 12977, 12677, 
    12654, 2763
  )

Query time 0.00044

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (2788,2612,15385,2608,2609,2561,2610,2611,2571,2317,2318,12754,11610,11606,11818,11607,11608,14076,14077,11135,12977,12677,12654,2763)"
    }
  }
}