Sandbox

SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 9941 
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	11	Using where; Using filesort

Result

exception_id	product_id	combination
305	9941	a:1:{i:599;s:5:"14922";}
306	9941	a:1:{i:599;s:5:"14923";}
307	9941	a:1:{i:599;s:5:"14924";}
308	9941	a:1:{i:599;s:5:"14925";}
309	9941	a:1:{i:599;s:5:"14927";}
310	9941	a:1:{i:599;s:5:"14929";}
311	9941	a:1:{i:599;s:5:"14930";}
312	9941	a:1:{i:599;s:5:"14931";}
313	9941	a:1:{i:599;s:5:"14939";}
314	9941	a:1:{i:599;s:5:"14937";}
315	9941	a:1:{i:599;s:5:"14938";}