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

Query time 0.00059

Result

product_amount_postfix
шт.