Sandbox

SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (44891, 42627)

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_products	range	PRIMARY	PRIMARY	3		2	Using where

product_id	product_code	product_type	status	company_id	list_price	amount	weight	length	width	height	shipping_freight	low_avail_limit	timestamp	usergroup_ids	is_edp	edp_shipping	unlimited_download	tracking	free_shipping	zero_price_action	is_pbp	is_op	is_oper	is_returnable	return_period	avail_since	exclusive_end_date	out_of_stock_actions	localization	min_qty	max_qty	qty_step	list_qty_count	tax_ids	age_verification	age_limit	options_type	exceptions_type	details_layout	shipping_params	final_category	aggregator	aggregator_id	ean	isrc	tbid	is_album	from_album	publisher	writers	updated_timestamp	available_worldwide	stream_release_date	download_release_date	added_timestamp	parent_product_id
42627	RR002	P	A	1	1.69	1	0.000	0	0	0	0.00	0	1431644400	0	Y	N	N	B	N	R	Y	N	N	Y	10	1431644400	0	B		0	0	0	0	6	N	0	P	F		a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	4						N		Copyright Control	Michael Franklin, Julie Devlin	1431614881	Y			2021-12-17 17:37:27	0
44891	RR004	P	A	1	1.69	1	0.000	0	0	0	0.00	0	1440284400	0	Y	N	N	B	N	R	Y	N	N	Y	10	1440284400	0	B		0	0	0	0	6	N	0	P	F		a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}	4						N		Copyright control	Julie Devlin/Michael Franklin	1440330768	Y			2021-12-17 17:37:27	0