SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 10206 
ORDER BY 
  exception_id

Query time 0.00039

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

Result

exception_id product_id combination
3136 10206 a:2:{i:1105;s:5:"20889";i:762;s:5:"16365";}
3137 10206 a:2:{i:1105;s:5:"20889";i:762;s:5:"16366";}
3138 10206 a:2:{i:1105;s:5:"20889";i:762;s:5:"16464";}