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 (
    37521, 37522, 37523, 37524, 37525, 37526, 
    37527, 37528, 37529, 37530, 37531, 
    37532, 37533, 37534, 37535, 37536
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00047

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 (37521,37522,37523,37524,37525,37526,37527,37528,37529,37530,37531,37532,37533,37534,37535,37536)) 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
37521 <ul><li>Unit Components CAs the most valuable fragrance of the world, Amouage has roots in the Oman Sultanate. Their perfume production is never fast, but it is about years of patience and painstaking work. Gold ornaments on beautiful bottles were handmade. Amouage uses original ingredients from Omana - silver incense, lemon and bush. Today, as in ancient times, valuable powders from the tamarisk tree manually collect the burial of selected shepherds. Amouage uses the essence of an extremely rare flower (an omelet bore), which grows and blooms in a short period of time every year on the remote Oman Mountains.ount 1</li> </ul>
37522 <ul><li>Brand:Antonio Banderas</li> <li>Blue Seduction </li> <li>Men</li> </ul>
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>