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 (
    37147, 37148, 37149, 37150, 37151, 37152, 
    37153, 37154, 37155, 37156, 37157, 
    37158, 37160, 37161, 37162, 37163
  ) 
  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 (37147,37148,37149,37150,37151,37152,37153,37154,37155,37156,37157,37158,37160,37161,37162,37163)) 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
37147
37148 <ul><li><span>Noran Perfumes Kador 1929 Platinum is a woody fragrance for women and men.<span> </span></span></li> </ul><span>Resistant, stub.</span>
37149 <ul><li>Noran Perfumes Moon 1947 Blue Edp 100 Ml</li> </ul>
37150 <ul><li class="page__p product__data__i">Country of manufacture: United Arab Emirates</li> <li class="page__p product__data__i">Gender: Female</li> <li class="page__p product__data__i">Release Year: 2018</li> <li class="page__p product__data__i product__data__i_last">Notes: bergamot, woody notes, jasmine, lychee, musk, peach, peony</li> <li class="page__p product__data__description">Noran Perfumes created a fragrance - the embodiment of an original Arabian culture inseparably linked with the masterly mastery of creating perfumes.</li> </ul>
37151 <span>Top notes: passion fruit, peach, raspberry, blackcurrant leaf, pear, sand<span> </span></span><br /><span>Middle notes: lily of the valley<span> </span></span><br /><span>Base notes: heliotrope, sandalwood, vanilla, patchouli, musk</span>
37152 <ul><li class="page__p product__data__i">Country of manufacture: United Arab Emirates</li> <li class="page__p product__data__i">Gender: Female</li> <li class="page__p product__data__i">Release Year: 2019</li> <li class="page__p product__data__i product__data__i_last">Notes: ambergris, cedar, narcissus, tuberose</li> <li class="page__p product__data__description">The Noran Perfumes brand introduced the fragrance Moon 1947 Red with a light, fragrant and captivating character.</li> </ul>
37153 <p>Eau de Toilette for women</p> <p>Gives every day the necessary pep! The headstrong mix of ripe blackcurrants and fiery pepper tastes especially energetic women who challenge life. Fruity-sweet freshness meets fiery spice. The fragrance is perfect for the summer and the first cool autumn days and may also pepper on cloudy winter days. The combination in the green notebook box belongs to us by dambiro to the surprise fragrances of the new season. Be sure to try!</p>
37154 <ul><li><span>Notebook Citrus & Green Tea Edt 100Ml</span></li> </ul>
37155 <ul><li>Notebook Patchouly & Cedar Wood (M) Edt 100Ml</li> </ul>
37156 <ul><li>Notebook Rose Musk & Vanilla (W) Edt 100Ml</li> </ul>
37157 <ul><li>Notebook White Wood & Vetiver (M) Edt 100Ml</li> </ul>
37158 <div class="centerColAlign"> <div class="feature"> <div class="a-section a-spacing-medium a-spacing-top-small"> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Targeted Group: Men</span></li> <li><span class="a-list-item">Brand: Nuroma</span></li> <li><span class="a-list-item">Fragrance Type: Eau de Toilette</span></li> <li><span class="a-list-item">Fragrance Family: Woody</span></li> <li><span class="a-list-item">Size: 100ml</span></li> <li><span class="a-list-item">Perfume Name: Explore</span></li> <li><span class="a-list-item">Country Of Origin: UAE</span></li> </ul></div> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> <div> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> <div class="feature"> </div> </div> <div class="centerColAlign"> <div class="feature"> </div> </div>
37160
37161 <ul><br /> <li>The Oduer Paris Espoir EDP Spray For Unisex, 100ML Perfumes is manufactured by Oduer.</li><br /> <li></li><br /> <li>Buy the Oduer Paris Espoir EDP Spray For Unisex, 100ML at the best price in the United Arab Emirates.</li><br /> <li>The purchased Oduer Paris Espoir EDP Spray For Unisex, 100ML can be delivered to United Arab Emirates.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Oduer Paris Espoir EDP Spray For Unisex, 100ML in United Arab Emirates of AED 199 and save 31%.</li> <br /> </ul>
37162 <ul><li>Odeur Paris </li> <li>Size:100 ml</li> <li>Unisex</li> </ul>
37163 <div>Olivier Strelli by Olivier Strelli is a Oriental Floral fragrance for women. Olivier Strelli was launched in 2005. The nose behind this fragrance is <a href="https://www.fragrantica.com/noses/Corinne_Cachen.html">Corinne Cachen</a>. Top notes are pineapple and rose; middle notes are lavender, jasmine and moroccan rose; base notes are sandalwood, tonka bean, amber, patchouli and musk.</div>