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

Query time 0.00057

Result

product_amount_postfix
шт.