Sandbox

SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 9470 
ORDER BY 
  exception_id

Query time 0.00036

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

Result

exception_id	product_id	combination
1673	9470	a:2:{i:697;s:5:"15777";i:696;s:2:"-1";}
1674	9470	a:2:{i:697;s:5:"15778";i:696;s:2:"-1";}
1675	9470	a:2:{i:697;s:5:"15779";i:696;s:2:"-1";}
1676	9470	a:2:{i:697;s:5:"15780";i:696;s:2:"-1";}
1677	9470	a:2:{i:697;s:5:"15784";i:696;s:2:"-1";}
1678	9470	a:2:{i:697;s:5:"15785";i:696;s:2:"-1";}
1679	9470	a:2:{i:697;s:5:"15786";i:696;s:2:"-1";}
1680	9470	a:2:{i:697;s:5:"15787";i:696;s:2:"-1";}
1681	9470	a:2:{i:697;s:5:"15788";i:696;s:2:"-1";}
1737	9470	a:2:{i:697;s:5:"15919";i:696;s:2:"-1";}
1738	9470	a:2:{i:697;s:5:"15919";i:696;s:2:"-2";}
1902	9470	a:2:{i:697;s:5:"15967";i:696;s:2:"-1";}
1903	9470	a:2:{i:697;s:5:"15967";i:696;s:2:"-2";}
1942	9470	a:2:{i:697;s:5:"15926";i:696;s:2:"-1";}
1943	9470	a:2:{i:697;s:5:"15926";i:696;s:2:"-2";}
3179	9470	a:2:{i:697;s:2:"-1";i:696;s:5:"15774";}