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

Query time 0.00057

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
1157 en 2 Hand saw with cutting tips for YTONG, H+H, SOLBET cellular concrete <p>Hand saw with cutting tips for YTONG, H+H, SOLBET cellular concrete</p> N N