SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62406, 63202, 61213, 62430, 64775, 65002, 
    65006, 65046, 65014, 65010, 65054, 
    64998, 65042, 65071, 64994, 65066, 
    65125, 65058, 65050, 65018, 65033, 
    65115, 65038, 65110
  )

Query time 0.00101

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,
      "attached_condition": "cscart_products.product_id in (62406,63202,61213,62430,64775,65002,65006,65046,65014,65010,65054,64998,65042,65071,64994,65066,65125,65058,65050,65018,65033,65115,65038,65110)"
    }
  }
}

Result