SELECT 
  prod.amount 
FROM 
  cscart_products AS prod 
WHERE 
  prod.product_id = 51

Query time 0.00022

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE prod const PRIMARY PRIMARY 3 const 1

Result

amount
9