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

Query time 0.00029

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
9892 en 2 XT insulation band for roof windows <p style="text-align: justify;">The XT insulation band ensures professional insulation of the lower installation level between the window frame and the roof structure. This effectively prevents a thermal bridge in this area. The band’s shape and material allow for adjusting it to the size of a particular window. It is installed on the inside part of the frame, while its design enables quick and easy installation.&nbsp;The frame is made of polyethylene and has a very low coefficient of thermal conductivity.&nbsp;</p> <h2>Advantages:</h2> <ul> <li>Insulation of a roof window,</li> <li>The band’s material features a very low heat conduction coefficient;&nbsp; ʎ=0,04 W/(m*K).</li> <li>The band’s size is adapted to the window size to ensure quick and easy installation process.</li> </ul> N N