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 (10431, 10039, 10420, 10462, 10460) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00064

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
10039 <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>5</td> <td>0,32 m<sup>2</sup></td> <td>11,60 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>5</td> <td>0,58 lm</td> <td>11,55 kg</td> </tr> </tbody> </table> Corner GRENADA MOCCA ✔ for inside and outside ✔ made of concrete ✔ reminds of the atmosphere of Spanish cities ✔ light brown ✔ height - 11.7cm | Online! ☎ 030 30 807 169
10420 <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>6</td> <td>0,5m<sup>2</sup></td> <td>16,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>6</td> <td>0,9 lm</td> <td>16,9 kg</td> </tr> </tbody> </table> Corner CALIFORNIA MOCCA ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ similar to fine stone ✔ height - 15cm | ☎ 030 30 807 169
10431 <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>7</td> <td>0,5 m<sup>2</sup></td> <td>16,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>7</td> <td>1 lm</td> <td>15,7 kg</td> </tr> </tbody> </table> Corner MEXICANA GRAPHITE ✔ for inside and outside ✔ made of concrete ✔ height - 15 cm | Expert advice ! ☎ 030 30 807 169
10460 <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>63</td> <td>1m<sup>2</sup></td> <td>17,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>24</td> <td>1,8 lm</td> <td>10,4 kg</td> </tr> </tbody> </table> COUNTRY 680 corner ✔ for outside ✔ based on pressed concrete ✔ similar to Belgian architecture ✔ height - 6.2cm | Cheap ! ☎ 030 30 807 169
10462 <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>5</td> <td>0,32 m<sup>2</sup></td> <td>11,60 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>5</td> <td>0,58 lm</td> <td>11,55 kg</td> </tr> </tbody> </table> Corner GRENADA ROSA ✔ for inside and outside ✔ made of concrete ✔ reminds of the atmosphere of Spanish cities ✔ height - 11.7cm | Online! ☎ 030 30 807 169