SELECT 
  q_product_descriptions.product_id, 
  q_product_descriptions.short_description, 
  IF(
    q_product_descriptions.short_description = '', 
    q_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  q_product_descriptions 
WHERE 
  q_product_descriptions.product_id IN (
    37523, 37524, 37525, 37526, 37527, 37528, 
    37529, 37530, 37531, 37532, 37533, 
    37534, 37535, 37536, 37537, 37538, 
    37539, 37540, 37541, 37542, 37543, 
    37544, 37545, 37546, 37547, 37548, 
    37549, 37550, 37551, 37552
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00075

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.01"
    },
    "table": {
      "table_name": "q_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (37523,37524,37525,37526,37527,37528,37529,37530,37531,37532,37533,37534,37535,37536,37537,37538,37539,37540,37541,37542,37543,37544,37545,37546,37547,37548,37549,37550,37551,37552)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "66.01",
        "eval_cost": "6.00",
        "prefix_cost": "72.01",
        "data_read_per_join": "114K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
37523 <ul><li>Brand:Antonio Banderas  </li> <li>Women</li> </ul>
37524 <ul><li>Brand:Antonio Banderas </li> <li>Gender:Men</li> </ul>
37525 <ul><li><span>An elegant, sensual fragrance inspired by the power of attraction, for a woman who’s sophisticated, feminine and full of personality.</span></li> </ul>
37526 <ul><li><span>Aramis Miniature Gift Set for Men - 4 Piece - Aramis Eau De Toilette 7 Ml - Aftershave 7 Ml - Black Eau De Toilette 7 Ml - Voyager Eau De Toilette 7 Ml</span></li> </ul>
37527 <ul><li><span>Receive a FREE personalized 30 mL travel spray with the purchase of a Cologne Absolue 200 mL. Engrave your 30 mL travel spray refill with a personalized monogram and a leather case of your choice. </span></li> </ul>
37528 <ul><li>Brand Azzaro</li> <li>Item Azzaro Pour Homme Gift Set EDT 100Ml With Deodorant Travel 150Ml</li> <li>Quantity 100 Ml & 150Ml</li> <li>Fragrance EDT</li> </ul>
37529 <ul><li><span>Loris Azzaro WANTED Travel Exclusive set.</span></li> <li><span>1x Azzaro Wanted 100ml Eau de Toilette spray</span></li> <li><span>1x Azzaro Wanted 150ml Deodorant spray</span></li> </ul>
37530 <ul><li>Top notes</li> <li>Bergamot, Sea Notes, Nutmeg, Violet Leaf</li> <li>Middle notes</li> <li>Jasmine, Ambergris, Cashmere Wood</li> <li>Base notes</li> <li>Sandalwood, Tonka Bean, Moss, Musk</li> </ul>
37531 <ul><li>Beyonce Heat </li> <li>Gender:Unisex</li> </ul>
37532 <p>Boucheron Iris De Syracuse Edp 125Ml+Santal De Kandy Edp 125Ml+Ambre D'Alexandrie Edp 125Ml Set</p>
37533 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Britney Spears Fantasy (W) Edp 100ml+100ml Bl Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Labdanum: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37534 <ul><li>Brand:Britney Spears </li> <li>Gender:Women </li> </ul>
37535 <ul><li> Brand:Burberry</li> <li>Gender:Women </li> </ul>
37536 <ul><li>Burberry Mr Burberry </li> <li>Gender:Unisex</li> </ul>
37537 <ul><li>Brand: Mr Burberry </li> <li>Gender:Unisex</li> </ul>
37538 <ul><li>Burberry My Burberry </li> <li>Gender:Women</li> </ul>
37539 <ul><li>Brand: My Burberry </li> <li>Gender:Women</li> </ul>
37540 <ul><li>Brand:My Burberry</li> <li>Gender:Women</li> </ul>
37541 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Burberry My Burberry Black (W) Edp 50ml+75ml Bl Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Papyrus: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37542 <ul><li><span>My Burberry Black. A new fragrance joining the My Burberry collection, it follows the same codes of craftsmanship, innovation and appreciation of the iconic Heritage Trench Coat.</span></li> </ul>
37543 <ul><li>Burberry My Burberry Blush </li> <li>Gender:Women</li> </ul>
37544 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Burberry My Burberry Limited Edition Edp 90ml+30ml Body Oil+10G</span></li> <li><span class="a-list-item">Gold Glow Powder Set</span></li> <li><span class="a-list-item">Women Eau De Perfume</span></li> </ul>
37545 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Erwachsene</span></li> <li><span class="a-list-item">Multicolor</span></li> </ul>
37546 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Bvlgari Aqva Divina (W) Edt 65ml+100ml Bl+150G Soap+100ml Sg Set</span></li> <li><span class="a-list-item">Women Eau de Perfume</span></li> <li><span class="a-list-item">Patchouli: Rate Only The Most Important Ingredients You Sense In This Fragrance.</span></li> </ul>
37547 <ul><li>Bvlgari Aqva Divina (W) Edt 65Ml+40Ml Bl+40Ml Sg+50G Soap+Pouch Set</li> </ul>
37548 <ul><li>Size0.5 oz</li> <li>Fragrance NameAqva Pour Homme</li> <li>FormulationSpray</li> <li>Fragrance TypeEau de Toilette</li> </ul>
37549 <ul><li>Bvlgari Blv </li> <li>Men</li> <li> 100Ml+75Ml Asb+75Ml Sg+Pouch Set</li> </ul>
37550 <ul><li dir="ltr"><span>A dreamy fragrance that the use of emotions everyday.</span></li> <li dir="ltr"><span>Fragrance for Women.</span></li> <li dir="ltr"><span>High quality.</span></li> <li dir="ltr"><span>Aromatic Notes: Flowers, Sweets & Biuky.</span></li> </ul>
37551 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Bvlgari</span></li> <li><span class="a-list-item">Fragrance Type: Eau de Parfum</span></li> <li><span class="a-list-item">Targeted Group: Women</span></li> <li><span class="a-list-item">Fragrance Family: Aromatic</span></li> <li><span class="a-list-item">Number of Pieces: 2</span></li> </ul>
37552 <div class="a-column a-span4"> <div class="a-section a-text-left visualRpdColumnSmall firstColumn"> <div class="a-fixed-left-grid"> <div class="a-fixed-left-grid-inner"> <ul><li class="a-fixed-left-grid-col a-col-right"><span class="a-size-small a-color-base visualRpdText">Bvlgari goldea the roman night set (edp75ml+edp15ml+beauty mirror)</span></li> </ul></div> </div> </div> </div> <div class="a-column a-span4"> </div>