SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 10141 
  AND company_id = 3 
  AND lang_code = 'fr'

Query time 0.00030

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
10141 fr 3 Fenêtre isolantes à ouverture latérale VELUX GXL 3066 N N