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

Query time 0.00027

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
9938 en 2 Air permeable underfelt collar for roof windows <p style="text-align: justify;">MXT vapour permeable&nbsp;membrane with insulating wool ensures durable connection with the roof&nbsp;construction and provides a complete protection for installed window. It also limits formation of thermal bridges through insulation of roof windows from the outside and drains the moisture from the area around roof window.&nbsp;Design of the flashing allows its direct installation on battens, irrespective of distances between them and their thickness. Appropriate corner connection ensures complete watertightness of the flashing.</p> <p style="text-align: justify;">As standard, vapour permeable flashing comes additionally with insulating material in the form of sheep wool tress which is used for insulation around the window. Natural and environment friendly, specially impregnated sheep wool features optimal density and high elasticity, hence it fills properly the space between the window and roof construction elements. The tress can be easily cut and formed.</p> <p class="hd1">Features:</p> <ul> <li>enables quick, easy and proper connection between roofing membrane and window as well as its insulation</li> <li>protects insulation material installed around the window against moisture</li> <li>does not require removal of battens and cutting counter-battens</li> <li>reduces thermal bridging and ensures additional window insulation</li> </ul> N N