SELECT 
  * 
FROM 
  cscart_product_options_exceptions 
WHERE 
  product_id = 404 
ORDER BY 
  exception_id

Query time 0.00049

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
1700 404 a:3:{i:595;s:2:"-1";i:592;s:5:"14793";i:1149;i:-1;}
1701 404 a:3:{i:595;s:2:"-1";i:592;s:5:"14812";i:1149;i:-1;}
1972 404 a:3:{i:595;s:2:"-1";i:592;s:5:"14785";i:1149;i:-1;}
1975 404 a:3:{i:595;s:2:"-1";i:592;s:5:"14805";i:1149;i:-1;}
2864 404 a:3:{i:595;s:2:"-1";i:592;s:5:"14806";i:1149;i:-1;}
3585 404 a:3:{i:595;s:5:"15419";i:592;s:5:"14783";i:1149;i:-1;}
3586 404 a:3:{i:595;s:5:"15420";i:592;s:2:"-1";i:1149;i:-1;}
3587 404 a:3:{i:595;s:5:"15425";i:592;s:2:"-1";i:1149;i:-1;}