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

Result

exception_id product_id combination
3246 9839 a:4:{i:1160;s:5:"21912";i:1159;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3247 9839 a:4:{i:1160;s:5:"21914";i:1159;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3248 9839 a:4:{i:1160;s:5:"21940";i:1159;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3249 9839 a:4:{i:1160;s:5:"21950";i:1159;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3250 9839 a:4:{i:1160;s:5:"21959";i:1159;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
3251 9839 a:4:{i:1160;s:5:"21967";i:1159;s:2:"-1";i:1155;s:5:"21887";i:1149;i:-1;}
4303 9839 a:4:{i:1160;s:5:"21912";i:1159;s:2:"-1";i:1155;s:2:"-1";i:1149;i:-1;}
4304 9839 a:4:{i:1160;s:5:"21914";i:1159;s:2:"-1";i:1155;s:2:"-1";i:1149;i:-1;}