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 (
    38173, 38174, 38175, 38176, 38177, 38178, 
    38179, 38180, 38181, 38182, 38183, 
    38184, 38185, 38186, 38187, 38188
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (38173,38174,38175,38176,38177,38178,38179,38180,38181,38182,38183,38184,38185,38186,38187,38188)) 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
38173 <ul><li>Montale Paris Aoud Ambre Edp 2Ml Vails</li> <li><span>Aoud Amber by Montale is a oriental fragrance for women and men</span></li> <li><span>Blended with the highest quality of rare and luxurious ingredients sourced from around the world.</span></li> </ul>
38174 <ul><li><span>This is probably the most courageous and deepest aroma from the entire montaleoud line. Aoud cuir d’arabie is a combination of tobacco, dry leathery and smoky notes of birch and oud. Extremely sharp and strong at the beginning, the composition becomes softer as the notes dry down, but remains very intensive, dry and strong.</span></li> </ul>
38175 <ul><li>Montale Paris Aoud Flowers Edp 2Ml Vails</li> <li class="shop-container"> <div class="product type-product post-194739 status-publish first instock product_cat-eau-de-parfum-spray product_cat-perfume-mini-and-vials has-post-thumbnail sale shipping-taxable purchasable product-type-simple"> <div class="product-main"> <div class="row content-row row-divided row-large"> <div class="col large-9"> <div class="product-footer"> <div class="woocommerce-tabs wc-tabs-wrapper container tabbed-content"> <div class="tab-panels"> <div class="woocommerce-Tabs-panel woocommerce-Tabs-panel--description panel entry-content active"> <p>Rose Absolute, Geranium, Gaiac Wood, Teak Wood, Sicilian Bergamot, Musk</p> </div> </div> </div> </div> </div> </div> </div> <div class="container clearfix"> <div class="footer-secondary pull-right"> <div class="payment-icons inline-block"> <div class="payment-icon"> </div> <div class="payment-icon"> </div> <div class="payment-icon"> </div> </div> </div> <div class="footer-primary pull-left"> </div> </div> </div> </li> </ul>
38176 <ul><li><span>Top notes are lemon and licorice</span></li> <li><span> middle notes are amber, floral notes and patchouli</span></li> <li><span> base notes are vetiver and white musk.</span></li> </ul>
38177 <ul><li><span>Aoud Leather fragrance notes</span></li> <li><span>Leather, Spices, Pepper, Cardamom, Saffron, Bergamot, Ambergris, Oud</span></li> </ul>
38178 <ul><li>Montale aoud night provides mysterious power of Malaysian oud accompanied by citruses (bergamot, lemon) and juicy fruity notes, with the opulence of Moroccan rose shades enhanced with earthy Indonesian patchouli in the heart of the composition, leaving an intense trail of amber and leather in harmony with creamy Mysore sandalwood and woody accords of guaiac. White musk provides a sensual embrace.</li> </ul>
38179 <ul><li><span>The fragrance features agar wood (oud) and taif rose.</span></li> <li><span>Size:2ml</span></li> </ul>
38180 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Eau de Parfum</span></li> <li><span class="a-list-item">Size : 100ML</span></li> <li><span class="a-list-item">Notes : blend of mandarin, rose petals, Cambodian agar wood, patchouli leaf, French labdanum and musk</span></li> </ul>
38181 <ul><li><span>Chocolate Greedy by Montale is a Oriental Vanilla fragrance for women and men. The nose behind this fragrance is Pierre Montale. The fragrance features coffee, cacao, tonka bean, bitter orange, vanilla and dried fruits.</span></li> </ul>
38182 <ul><li><span>Long Lasting:yes</span></li> <li><span>Brand:Montale</span></li> <li><span>Gender:Unisex</span></li> <li><span>Skin:All type of Skin</span><span></span><span></span></li> </ul>
38183 <ul><li><span>Elemi, Incense of Somalia, Labdanum, the sacred resins of trees in harmony with the Cedar Wood and the Patchouli Leaves are an offering of woody, dry, hot, smoky notes.</span></li> </ul>
38184 <ul><li><span>Sweet, balsamic and surprisingly light, Honey Aoud is a delightful new oriental vanilla confection with tremendous versatility. Focused around Montale's signature note of smoky, resinous agarwood, Honey Aoud adds (you guessed it) honey to the mix, a syrupy, cinnamon-inflected, wonderfully true honey note that smooths the aoud's rough edges, leading into a deep, earthy patchouli, vanilla and amber drydown. The result is somewhere between oriental and gourmand, sweet, creamy, spicy and sultry, but all without any of the cloying heaviness sometimes associated with either genre, making Honey Aoud easy to wear anywhere, any time.</span></li> </ul>
38185 <ul><li><span>An exciting blast of Peruvian Pink Pepper and Black Pepper from Madagascar unveils a beautiful Floral heart and leaves a very rich sillage of luxurious Aoud from Malaysia, hedonic Cedar Wood and precious Amber.</span></li> </ul>
38186 <ul><li><span>If anyone knows how to make an oud fragrance "Oudmazing, " it would of course be Montale- the brand that did oud long before it was </span><i>de </i>rigueur<span>. And Oudmazing, with its audacious blend of exquisite Malaysian oud and a mouthwatering combination of fresh fruit, citrus and rich leather, more than fits the bill. Opening with brilliantly bright orange and bergamot, Oudmazing is soon sweetened with a delectable Mediterranean fig note and a juicy burst of fresh pear.</span></li> </ul>
38187 <ul><li>Starry Nights is a shared / unisex perfume by Montale. The scent was launched in 2016</li> <li>Starry Nights fragrance notes</li> <li>Top Notes</li> <li>Calabrian bergamot</li> <li>Heart Notes</li> <li>Bulgarian rose, Egyptian jasmine</li> <li>Base notes</li> <li>Sumatran patchouli, White musk, Powdery notes</li> </ul>
38188 <ul><li>Patricia de Nicolaï conveys her fascination with ‘the city that never sleeps’ with her intoxicating oriental signature: after a start of citrus bursts, pepper and clove spice up the patchouli bordered with vanilla, incense and balm. This spicy oriental was endorsed by Luca Turin, one of the top perfume critics in 1992 in the cult book Perfume, The Guide.  It also haunts the San-Antonio crime novels, whose author, Frédéric Dard, was one of the first aficionados.</li> </ul>