Sandbox

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

Result

exception_id	product_id	combination
294	9940	a:2:{i:1354;i:-1;i:599;s:5:"14922";}
295	9940	a:2:{i:1354;i:-1;i:599;s:5:"14923";}
296	9940	a:2:{i:1354;i:-1;i:599;s:5:"14924";}
297	9940	a:2:{i:1354;i:-1;i:599;s:5:"14925";}
298	9940	a:2:{i:1354;i:-1;i:599;s:5:"14927";}
299	9940	a:2:{i:1354;i:-1;i:599;s:5:"14929";}
300	9940	a:2:{i:1354;i:-1;i:599;s:5:"14931";}
301	9940	a:2:{i:1354;i:-1;i:599;s:5:"14939";}
302	9940	a:2:{i:1354;i:-1;i:599;s:5:"14937";}
303	9940	a:2:{i:1354;i:-1;i:599;s:5:"14938";}
304	9940	a:2:{i:1354;i:-1;i:599;s:5:"14930";}