Sandbox

SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    17438, 37503, 23822, 38852, 67915, 33142, 
    67919, 67921, 67924, 67926
  )

Query time 0.00030

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": 10,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (17438,37503,23822,38852,67915,33142,67919,67921,67924,67926)"
    }
  }
}

Result

product_id	product_code	product_type	status	company_id	amount	timestamp	updated_timestamp	is_edp	edp_shipping	unlimited_download	tracking	free_shipping	is_pbp	is_op	is_oper	is_returnable	return_period	out_of_stock_actions	tax_ids	age_verification	show_price_per_x_units
17438	17140126	P	A	27	0	1729050057	1736390473	N	N	N	D	N	N	N	N	Y	10	N	7	N	1.000
23822	17140128	P	A	27	0	1729081064	1736390473	N	N	N	D	N	N	N	N	Y	10	N	7	N	1.000
33142	17140125	P	A	27	0	1729084904	1737007670	N	N	N	D	N	N	N	N	Y	10	N	7	N	1.000
37503	17140123	P	A	27	0	1729084904	1737007670	N	N	N	D	N	N	N	N	Y	10	N	7	N	1.000
38852	10299194	P	A	27	0	1729084904	1737007670	N	N	N	D	N	N	N	N	Y	10	N	7	N	1.000
67915	6611877	P	A	2	10	1729167885	1733359674	N	N	N		N	N	N	N	Y	10	N	7	N	1.000
67919	5613931	P	A	2	10	1729167885	1733359674	N	N	N		N	N	N	N	Y	10	N	7	N	1.000
67921	1664501	P	A	2	50	1729167885	1733359674	N	N	N		N	N	N	N	Y	10	N	7	N	1.000
67924	3695049	P	A	2	10	1729167885	1733359674	N	N	N		N	N	N	N	Y	10	N	7	N	1.000
67926	4658760	P	A	2	10	1729167885	1733359674	N	N	N		N	N	N	N	Y	10	N	7	N	1.000