select 
  product_amount_postfix 
from 
  cscart_product_descriptions 
where 
  product_id = 1527 
  and lang_code = 'ru'

Query time 0.00066

Result

product_amount_postfix