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

Query time 0.00031

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
1155 en 2 Abrasive plane for YTONG, H+H, SOLBET cellular concrete <p>Abrasive plane 400 x 180 mm for cellular concrete eg. YTONG, H+H, SOLBET</p> N N