Sandbox

SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 9946 
ORDER BY 
  exception_id

Query time 0.00028

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	10	Using where; Using filesort

Result

exception_id	product_id	combination
349	9946	a:1:{i:599;s:5:"14922";}
350	9946	a:1:{i:599;s:5:"14923";}
351	9946	a:1:{i:599;s:5:"14924";}
352	9946	a:1:{i:599;s:5:"14925";}
353	9946	a:1:{i:599;s:5:"14927";}
354	9946	a:1:{i:599;s:5:"14929";}
355	9946	a:1:{i:599;s:5:"14930";}
356	9946	a:1:{i:599;s:5:"14931";}
357	9946	a:1:{i:599;s:5:"14939";}
358	9946	a:1:{i:599;s:5:"14928";}