SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    8427, 7160, 8428, 8431, 9799, 8433, 8434, 
    8435, 8436, 8438, 8439, 8440, 8441, 
    8442, 7159, 8444, 8445, 8447, 8448, 
    8450, 10934, 7444, 7789, 7790
  )

Query time 0.00070

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "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 (8427,7160,8428,8431,9799,8433,8434,8435,8436,8438,8439,8440,8441,8442,7159,8444,8445,8447,8448,8450,10934,7444,7789,7790)"
        }
      }
    ]
  }
}