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

Query time 0.00024

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
10119 en 2 Atlas proFARBA | white latex paint for indoor use <p style="text-align: justify;"><strong>Atlas proFARBA</strong> is a white latex paint designed as a decorative or protective coverage of indoor walls and ceilings surfaces.<br /> Latex paints forms a coat highly resistant to repeated washing, which is much more durable than traditional emulsion paints for indoor use.</p> <h2>The main characteristics</h2> <ul style="text-align: justify;"> <li>matt, snow-white;</li> <li>characterised by perfect coating properties;</li> <li>paint coat is flexible;</li> <li>highly scrub-resistant;</li> <li>with thixotropic effect;</li> <li>ecological – holds slender (close zero) content of volatile organic compounds;</li> <li>provides free transfer of vapour from walls;</li> <li>perfect for hydrodynamic spray painting;</li> <li>drying time - 2 hours.</li> <li>Use: <ul> <li>cement –based or cement-lime plasters;</li> <li>thin-coat mineral renders;</li> <li>gypsum plasters and finishing coats;</li> <li>polymer plasters;</li> <li>plasterboards;</li> <li>wallpapers;</li> <li>rough walls of concrete, bricks, blocks, hollow bricks.</li> </ul> </li> </ul> <h2>Consumption</h2> <p style="text-align: justify; background: #00cc99">Up to 14m<sup>2</sup>/1l of paint with single painting of smooth surface. Consumption depends on the substrate absorptiveness.</p> ✓Painting walls and ceilings indoors ✓Latex paint ✓Vapour permeable ✓matt, snow-white ✓elastic ✓Thixotropic ✓Perfect for hydrodynamic spraying ✓check it now! White latex interior paint | ATLAS proFARBA N N