SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 1154 
  AND company_id = 2 
  AND lang_code = 'en'

Query time 0.00055

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions const PRIMARY,product_id,company_id PRIMARY 13 const,const,const 1

Result

product_id lang_code company_id product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message promo_text youtube_link show_youtube_video replace_main_image custom_header
1154 en 2 Trowel for YTONG, H+H, SOLBET cellular concrete <p>Trowel for cellular YTONG, H+H, SOLBET concrete</p> N N