Sandbox

SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 9944 
ORDER BY 
  exception_id

Query time 0.00030

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cscart_product_options_exceptions	ref	product	product	3	const	9	Using where; Using filesort

Result

exception_id	product_id	combination
4336	9944	a:1:{i:599;s:5:"24216";}
4337	9944	a:1:{i:599;s:5:"24213";}
4338	9944	a:1:{i:599;s:5:"24207";}
4339	9944	a:1:{i:599;s:5:"24212";}
4340	9944	a:1:{i:599;s:5:"24211";}
4341	9944	a:1:{i:599;s:5:"24215";}
4342	9944	a:1:{i:599;s:5:"24209";}
4343	9944	a:1:{i:599;s:5:"24214";}
4344	9944	a:1:{i:599;s:5:"24208";}
4345	9944	a:1:{i:599;s:5:"24217";}