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

Result

exception_id product_id combination
3233 9843 a:4:{i:955;s:5:"18562";i:1154;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3234 9843 a:4:{i:955;s:5:"18573";i:1154;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3235 9843 a:4:{i:955;s:5:"18583";i:1154;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3236 9843 a:4:{i:955;s:5:"18591";i:1154;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
4308 9843 a:4:{i:955;s:5:"18539";i:1154;s:2:"-1";i:1155;s:2:"-1";i:1149;i:-1;}
4309 9843 a:4:{i:955;s:5:"18544";i:1154;s:2:"-1";i:1155;s:2:"-1";i:1149;i:-1;}
4310 9843 a:4:{i:955;s:5:"18551";i:1154;s:2:"-1";i:1155;s:2:"-1";i:1149;i:-1;}