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 (
    629, 646, 635, 641, 631, 636, 10109, 10108
  ) 
  AND cscart_ult_product_descriptions.company_id = 2 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00038

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
629 <p>Ensures safety while walking on the roof. Installed on pitched roofs (with the pitch of over 25 degrees) with the use of one of the special supports.</p>
631 <p>Used for installation of benches and steps on pitched roofs with covered flat roofing.</p> <p>Bench grips are additionally required for the proper installation of benches.</p>
635 <p>Used for installation of benches directly to the wall or the chimney.</p> <p>Bench grips are additionally required for the proper installation benches.</p>
636 <p>Used for joining two benches into longer stretches.</p> <p>Benches should be joined together with the use of two connectors in each joining point</p> <p>Ssold together with installation screws.</p>
641 <p style="text-align: justify;">Used to install snow fence on <strong>flat roofing.</strong></p> <p style="text-align: justify;"><strong>- Thickness: 5 mm (vertical part),</strong></p> <p style="text-align: justify;"><strong>- 6 mm (horizontal part) Width: 25 mm</strong></p> <p style="text-align: justify;"><strong>- Length: 283 mm</strong></p> <p style="text-align: justify;"><strong>- Quantity per pallet 80 x 120 - 25 packs</strong></p>
646 <p style="text-align: justify;">Used to install snow balk on interlocking concrete or clay tiles.</p> <p style="text-align: justify;">- made of hot-dip galvanized steel</p> <p style="text-align: justify;">- width: 4 mm</p> <p style="text-align: justify;">- Length: 390 mm</p> <p style="text-align: justify;">- thickness:&nbsp;4 mm (vertical part), 4 mm (horizontal part)</p>
10108 <p style="text-align: justify;"><strong>BR-Vent</strong> is a rollable ridge vent providing a high level of ventilation between a roof covering and the roof thermal insulation parts. <strong>BR-Vent</strong> is made of technical fabric with very good diffusional properties which easily enable the airflow under the roof covering. A special design provides a good protection against water and dust. It can be successfully used in the hips area as well.</p> <p style="text-align: justify;">Structure: Two strips of 0.14 mm thick corrugated aluminium, glued and sewn to a technical fabric together with threads resistant to environmental factors; butyl glue strips applied to the edges on the bottom side.</p>
10109 <p style="text-align: justify;"><strong>Blach-Vent Plus</strong> is a high quality rollable ridge vent intended for roofs covered with metal sheet tiles. Product is a technologically advanced technical fabric reinforced with aluminium strips offers high durability and utility parametres. <strong>Blach-Vent Plus</strong> guarantees very good ventilation, and protects ridges and hips againts water, snow and dust. Air permeability (at 200 kPa): 380 cm<sup>3</sup>/cm<sup>2</sup>/s.</p> <p style="text-align: justify;">Structure: Two strips of 0.14 mm thick and 35 mm wide corrugated aluminium, glued and sewn to a technical fabric together with threads resistant to environmental factors; butyl glue strips applied to the edges on the bottom side.</p>