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 (651, 10702) 
  AND cscart_ult_product_descriptions.company_id = 2 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00033

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 2 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
651 <p style="text-align: justify;">OSB Superfinish is the most progressive OSB type that is currently available. OSB Superfinish is developed and manufactured entirely in compliance with the current demand of ecological living focused on organic materials. Selecting suitable wood and binder, OSB Superfinish meets high standards of not only environmental buildings. Strands are bound with a formaldehyde-free binder. Formaldehyde emissions are limited to the natural content of formaldehyde in solid wood (&lt;0.03 ppm).</p> <p><strong>Standard</strong><br /> EN 300 - type OSB 3; EN 13501-1: class D-s1, d0</p> <p><strong>Formaldehyde class</strong><br /> E0 (EN 120)</p> <p><strong>Characteristics</strong></p> <ul> <li>Excellent processing capabilities</li> <li>High durability and resistance</li> <li>High load-bearing capacity</li> <li>High performance material</li> <li>High stability</li> </ul> <p><strong>Applications</strong></p> <ul> <li>Interior design</li> <li>Billboard production</li> <li>Exhibitions (displays, stands, kiosks)</li> <li>Flooring base</li> <li>Framework for upholstered furniture</li> <li>Internal load-bearing cladding of walls and ceilings, partitions</li> <li>Load-bearing wall sheathing</li> <li>Packaging</li> <li>Warehouse management (racks, fences, etc.)</li> </ul> <p><strong>Parameters</strong></p> <div style="overflow-x: auto;"> <table id="table1"> <tbody> <tr> <td>Thickness [mm]</td> <td>Tongue&amp;Groove</td> <td>Lenght x Width [mm]</td> <td>Boards / Pallet [pcs]</td> <td>&nbsp;Weight - 1 pallet [kg]</td> <td>Pallets / Truck</td> <td>Weight / Truck [kg]</td> </tr> <tr> <td style="text-align: center;">9</td> <td style="text-align: center;">no</td> <td style="text-align: center;">2500 x 1250</td> <td style="text-align: center;">108</td> <td style="text-align: center;">1843</td> <td style="text-align: center;">13</td> <td style="text-align: center;">23 953</td> </tr> <tr> <td style="text-align: center;">12</td> <td style="text-align: center;">no</td> <td style="text-align: center;">2500 x 1250</td> <td style="text-align: center;">90</td> <td style="text-align: center;">1994</td> <td style="text-align: center;">12</td> <td style="text-align: center;">23 953</td> </tr> <tr class="alt"> <td style="text-align: center;">15</td> <td style="text-align: center;">no</td> <td style="text-align: center;">2500 x 1250</td> <td style="text-align: center;">64</td> <td style="text-align: center;">1775</td> <td style="text-align: center;">13</td> <td style="text-align: center;">23 075</td> </tr> <tr> <td style="text-align: center;">18</td> <td style="text-align: center;">no</td> <td style="text-align: center;">2500 x 1250</td> <td style="text-align: center;">48</td> <td style="text-align: center;">1586</td> <td style="text-align: center;">13</td> <td style="text-align: center;">20 618</td> </tr> <tr class="alt"> <td style="text-align: center;">22</td> <td style="text-align: center;">no</td> <td style="text-align: center;">2500 x 1250</td> <td style="text-align: center;">42</td> <td style="text-align: center;">1666</td> <td style="text-align: center;">13</td> <td style="text-align: center;">21 656</td> </tr> </tbody> </table> </div>
10702 <p style="text-align: justify;">OSB Superfinish is the most progressive OSB type that is currently available. OSB Superfinish is developed and manufactured entirely in compliance with the current demand of ecological living focused on organic materials. Selecting suitable wood and binder, OSB Superfinish meets high standards of not only environmental buildings. Strands are bound with a formaldehyde-free binder. Formaldehyde emissions are limited to the natural content of formaldehyde in solid wood (&lt;0.03 ppm).</p> <p><strong>Standard</strong><br /> EN 300 - type OSB 3; EN 13501-1: class D-s1, d0</p> <p><strong>Formaldehyde class</strong><br /> E0 (EN 120)</p> <p><strong>Characteristics</strong></p> <ul> <li>Excellent processing capabilities</li> <li>High durability and resistance</li> <li>High load-bearing capacity</li> <li>High performance material</li> <li>High stability</li> </ul> <p><strong>Applications</strong></p> <ul> <li>Interior design</li> <li>Billboard production</li> <li>Exhibitions (displays, stands, kiosks)</li> <li>Flooring base</li> <li>Framework for upholstered furniture</li> <li>Internal load-bearing cladding of walls and ceilings, partitions</li> <li>Load-bearing wall sheathing</li> <li>Packaging</li> <li>Warehouse management (racks, fences, etc.)</li> </ul> <p><strong>Parameters</strong></p> <table id="table1"> <tbody> <tr> <td>Thickness [mm]</td> <td>Tongue&amp;Groove</td> <td>Lenght x Width [mm]</td> <td>m²&nbsp;/ Piece</td> <td>Boards / Pallet [pcs]</td> <td>m² / Pal</td> <td>Pal / Truck</td> <td>m² / Truck</td> </tr> <tr> <td style="text-align: center;">12</td> <td style="text-align: center;">yes</td> <td style="text-align: center;">2500 x 625</td> <td style="text-align: center;">1,5625</td> <td style="text-align: center;">59</td> <td style="text-align: center;">92,1875</td> <td style="text-align: center;">36</td> <td style="text-align: center;">3318,75</td> </tr> <tr class="alt"> <td style="text-align: center;">15</td> <td style="text-align: center;"><span style="text-align: center;">yes</span></td> <td style="text-align: center;">2500 x 625</td> <td style="text-align: center;">1,5625</td> <td style="text-align: center;">47</td> <td style="text-align: center;">73,4375</td> <td style="text-align: center;">36</td> <td style="text-align: center;">2643,75</td> </tr> <tr> <td style="text-align: center;">18</td> <td style="text-align: center;"><span style="text-align: center;">yes</span></td> <td style="text-align: center;">2500 x 625</td> <td style="text-align: center;">1,5625</td> <td style="text-align: center;">39</td> <td style="text-align: center;">60,9375</td> <td style="text-align: center;">36</td> <td style="text-align: center;">2193,75</td> </tr> <tr class="alt"> <td style="text-align: center;">22</td> <td style="text-align: center;"><span style="text-align: center;">yes</span><span style="text-align: center;"></span></td> <td style="text-align: center;">2500 x 625</td> <td style="text-align: center;">1,5625</td> <td style="text-align: center;">32</td> <td style="text-align: center;">50,00</td> <td style="text-align: center;">36</td> <td style="text-align: center;">1800,00</td> </tr> <tr> <td style="text-align: center;">25</td> <td style="text-align: center;"><span style="text-align: center;">yes</span></td> <td style="text-align: center;">2500 x 625</td> <td style="text-align: center;">1,5625</td> <td style="text-align: center;">28</td> <td style="text-align: center;">43,75</td> <td style="text-align: center;">36</td> <td style="text-align: center;">1575,00</td> </tr> </tbody> </table> <p>&nbsp;</p>