SELECT 
  product_code, 
  amount 
FROM 
  cscart_product_options_inventory 
WHERE 
  combination_hash = 1406493483

Query time 0.00018

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_options_inventory const PRIMARY PRIMARY 4 const 1

Result

product_code amount
ATR-AAY-B1500-C2A 3.00