SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2764, 12676, 12655, 2831, 2832, 15312, 
    13836, 2844, 2679, 2669, 2683, 2680, 
    2675, 2674, 4357, 11901, 11902, 11919, 
    11906, 11662, 11903, 11661, 11907, 
    11908
  )

Query time 0.00080

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 (2764,12676,12655,2831,2832,15312,13836,2844,2679,2669,2683,2680,2675,2674,4357,11901,11902,11919,11906,11662,11903,11661,11907,11908)"
    }
  }
}