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 (
    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.00045

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "38.41"
    },
    "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": 16,
      "rows_produced_per_join": 16,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (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": "35.21",
        "eval_cost": "3.20",
        "prefix_cost": "38.41",
        "data_read_per_join": "61K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
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>