Sandbox

SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    1359, 1365, 1358, 1357, 1366, 1356, 1355, 
    1354, 1353, 1367, 1352, 1351
  )

Query time 0.00081

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": 12,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (1359,1365,1358,1357,1366,1356,1355,1354,1353,1367,1352,1351)"
    }
  }
}

Result

product_id	product_code	product_type	status	company_id	timestamp	updated_timestamp	is_edp	edp_shipping	unlimited_download	free_shipping	is_pbp	is_op	is_oper	is_returnable	return_period	out_of_stock_actions	age_verification	show_price_per_x_units	split_for_sale	material_group
1351	T-0018	P	A	1	1670987757	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1352	T-0017	P	A	1	1670987767	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1353	T-0015	P	A	1	1670988017	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1354	T-0014	P	A	1	1670988036	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1355	T-0012	P	A	1	1670988100	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1356	T-0011	P	A	1	1670988132	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1357	T-0009	P	A	1	1670988162	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1358	T-0008	P	A	1	1670988189	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1359	T-0006	P	A	1	1670988217	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1365	T-0007	P	A	1	1670988389	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1366	T-0010	P	A	1	1670988417	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G
1367	T-0016	P	A	1	1670988473	1734422409	N	N	N	N	N	N	N	Y	10	N	N	1.000	N	G