SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 9871 
ORDER BY 
  exception_id

Query time 0.00027

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
2960 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18191";}
2961 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18192";}
2962 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18195";}
2963 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18189";}
2964 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18197";}
2965 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18199";}
2966 9871 a:3:{i:949;s:2:"-1";i:934;s:5:"18377";i:928;s:5:"18200";}