SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    4970, 4963, 4974, 4978, 4956, 4962, 4959, 
    12457, 11777, 12268, 12270, 12271, 
    12272, 12275, 12276, 12255, 12257, 
    12258, 12259, 12260, 12261, 12262, 
    12269, 12263, 12264, 12265, 12266, 
    12267, 12273, 12274
  )

Query time 0.00110

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": 30,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (4970,4963,4974,4978,4956,4962,4959,12457,11777,12268,12270,12271,12272,12275,12276,12255,12257,12258,12259,12260,12261,12262,12269,12263,12264,12265,12266,12267,12273,12274)"
    }
  }
}