SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    8685, 530, 10119, 1184, 10118, 11203, 
    10649, 11220
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00041

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions range PRIMARY,product_id,company_id PRIMARY 13 8 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
530
1184
8685 <p style="text-align: justify;">12.5 x 1200 x 2000 mm fire-proof and water-proof plasterboards are dedicated for use in rooms with fire protection requirements. They're characterized by increased fire resistance and acoustic insulation. Approved for use in rooms with a relative air humidity of up to 85%. Perfect for:</p> <ul> <li style="text-align: justify;"><strong>partition walls,</strong></li> <li style="text-align: justify;"><strong>walls and ceilings,</strong></li> <li style="text-align: justify;"><strong>on a load-bearing structure</strong></li> <li style="text-align: justify;"><strong>as dry plaster</strong></li> <li style="text-align: justify;"><strong>fire reaction according to PN-EN 520+A1:2012 norm</strong></li> </ul> <p style="text-align: justify;">Benefits</p> <ul> <li style="text-align: justify;"><strong>increased fire resistance, </strong></li> <li style="text-align: justify;"><strong><strong>reduced water absorption, </strong></strong></li> <li style="text-align: justify;"><strong><strong><strong>acoustic insulation, </strong></strong></strong></li> <li style="text-align: justify;"><strong><strong><strong><strong>resistant to moisture, </strong></strong></strong></strong></li> <li style="text-align: justify;"><strong><strong><strong><strong>impact resistance </strong></strong></strong></strong></li> </ul> <h2>Logistics</h2> <div style="overflow-x: auto;"> <table border="1" cellpadding="1" cellspacing="1" style="width:400px;"> <tbody> <tr> <td style="text-align: center;">Unit</td> <td style="text-align: center;">Quantity</td> </tr> <tr> <td>1 board</td> <td style="text-align: center;">2,4 m2</td> </tr> <tr> <td>1 pallet</td> <td style="text-align: center;">66 pcs | 158,40 m2</td> </tr> <tr> <td>1 truck</td> <td style="text-align: center;">14 pallets | 924 pcs | 2217,60 m2</td> </tr> </tbody> </table> <p>&nbsp;</p> </div> ✓Plasterboard 2000 mm long ✓fireproof ✓waterproof ✓for partition walls ✓boards for walls and ceilings ✓drywall systems ✓easy to process and assemble ✓check it now!
10118 <p style="text-align: justify;"><strong>Atlas optiFarba</strong> is a white latex paint designed as a decorative or protective coverage of indoor walls and ceilings surfaces.</p> <h2>The main characteristics</h2> <ul style="text-align: justify;"> <li>matt, snow-white;</li> <li>characterised by very good coating properties;</li> <li>elastic;</li> <li>scrub - resistant;</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>Types of painted substrates – cement or cement-lime plasters, thin-coat mineral renders, gypsum plasters and top finishes, polymer top finishes, plasterboards, wallpapers, rough walls of concrete, bricks, blocks</li> </ul> <h2>Consumption</h2> <p>Up to 14m2/1l of paint with single painting of smooth surface. Consumption depends on the substrate absorptiveness.</p> <h2>Packaging</h2> <p>Plastic buckets: 10 l<br /> Pallet: 440 l in 10 l buckets</p> Latex indoor paint ensures super coating, high efficiency and vapor permeability. It is fast drying and easy to clean and not dripping. More durable than standard indoor paints. Check it now!
10119 <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!
10649 <p style="text-align: justify;">Atlas GIPSAR GO! - ready-to-use gypsum finishing coat based on resin binders, mineral fillers and modifiers. Easy to apply - thanks to its special consistency, the compound is easy to apply with a trowel, painting roll or aggregate. Can be applied “wet on wet” - the next layer can already be applied when the previous layer has partially set, which shortens the working time considerably. Working comfort through long processing time; the compound applied to the substrate can be smoothed without hurry and the connection points between the working fields remain invisible.</p> <ul> <li>quck and easy application - manual or mechanical,</li> <li>perfect surface - without holes, or bubbles,</li> <li>color changing allows to control work's progress,</li> <li>wet to wet - the next layer can already be applied when the previous layer has partially set,</li> <li>to each paint type - acryllic, latex, ceramic,</li> <li>long time of work - no need to rush while application,</li> <li>easy grinding,</li> <li>dust reduction,</li> <li>for interior walls, ceilings,</li> <li>layer thickness: 1-3 mm</li> <li>time of drying 1 mm layer - up to 6 hours</li> <li>types of substrates: concrete, cement puts, gypsum puts, GKB boards.</li> </ul> <h2>Consumption</h2> <p style="text-align: justify;">The average consumption is at 1 kg /1 m2 /1 application.</p> <h2>Packaging</h2> <p style="text-align: justify;">Plastic buckets: 18 kg<br /> Pallet: 702 kg (39 pcs)&nbsp; in 18 kg bags</p> ✓ready-to-use at once! ✓easy application ✓long open time ✓perfect, smooth surface ✓reduced amount of dust ✓easy painting ✓for each type of paint ✓check it now!
11203 ✓For plasterboards jointing ✓tapeless jointing ✓flexible and crack-resistant ✓very good plasticity ✓high joint strength ✓ fast drying ✓Low shrinkage during setting ✓check it now!
11220 <p>Knauf Perlfix 25 kg is a special gypsum-based adhesive for attaching gypsum boards. It is applied directly to uneven masonry or concrete in interior areas to attach plasterboards and composite boards to the wall. In this way, the plasterboards also act as a dry plaster in the wall area. The result: a smooth and even wall, ideal for painting, wallpapering or decorative plaster.</p> <p>The plasterboard scores points for its excellent adhesion. Thanks to its excellent adhesion-promoting properties, the plasterboards form a strong bond with the substrate. This means that the boards hold optimally.</p> <h3><strong>Properties</strong></h3> <ul> <li>Pasty consistency</li> <li>Optimum bonding and very good adhesion</li> <li>Easy to apply special gypsum-based adhesive</li> <li>Easy to process</li> <li>Ready to mix and very economical</li> </ul>