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

Query time 0.00299

Result

product_amount_postfix
шт.