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 (
    38210, 38212, 38213, 38214, 38215, 38216, 
    38217, 38218, 38219, 38220, 38221, 
    38222, 38223, 38224, 38225, 35122
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00066

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 (38210,38212,38213,38214,38215,38216,38217,38218,38219,38220,38221,38222,38223,38224,38225,35122)) 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
35122 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> <div class="a-section a-spacing-small"> <p>Woody notes, vetiver and musk ambrette (musk mallow), musk and immortelle. The nose behind this fragrance is Marie Salamagne. A feast for the nose indeed and all in the bright brilliant opening. How could it be any better. Hold on for your olfactory vacation.</p> </div> </div> </div> </div> <div class="feature"> </div> <div> </div> <div class="celwidget"> <div> </div> <div> <div class="celwidget"> <div class="askInlineWidget"> </div> </div> </div> </div>
38210 <ul><br /> <li>The Mini Crystal Woman EDP Natural Spray 1080 25ML For Women -SME Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal Woman EDP Natural Spray 1080 25ML For Women -SME at the best price in the Pakistan.</li><br /> <li>The purchased Mini Crystal Woman EDP Natural Spray 1080 25ML For Women -SME can be delivered to Pakistan.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal Woman EDP Natural Spray 1080 25ML For Women -SME in Pakistan of PKR 653 and save 58%.</li> <br /> </ul>
38212 <ul><br /> <li>The Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1092 – Smell Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1092 – Smell at the best price in the Pakistan.</li><br /> <li>The purchased Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1092 – Smell can be delivered to Pakistan.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1092 – Smell in Pakistan of PKR 522 and save 66%.</li> <br /> </ul>
38213 <ul><br /> <li>The Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1093 – Smell Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1093 – Smell at the best price in the Pakistan.</li><br /> <li>The purchased Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1093 – Smell can be delivered to Pakistan.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal EDP Natural Spray For Unisex, 25 ML, 1093 – Smell in Pakistan of PKR 522 and save 66%.</li> <br /> </ul>
38214 <br /><ul><li><ul><li>The Mini Crystal Spirit EDP Natural Spray For Unisex, 25 ML, 1094 – Smell Perfumes is manufactured by Mini Crystal.</li> </ul></li></ul><br /><br /><ul><li><ul><li>Buy the Mini Crystal Spirit EDP Natural Spray For Unisex, 25 ML, 1094 – Smell at the best price in the Pakistan.</li> </ul></li></ul><br /><ul><li><ul><li>The purchased Mini Crystal Spirit EDP Natural Spray For Unisex, 25 ML, 1094 – Smell can be delivered to Pakistan.</li> </ul></li></ul><br /><ul><li><ul><li>The product/item is Brand New.</li> </ul></li></ul><br /><ul><li><ul><li>Buy Mini Crystal Spirit EDP Natural Spray For Unisex, 25 ML, 1094 – Smell in Pakistan of PKR 653 and save 58%.</li> </ul></li></ul>
38215 <ul><br /> <li>The Mini Crystal EDP Natural Spray 1107 25 ML For Women -SME Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal EDP Natural Spray 1107 25 ML For Women -SME at the best price in the Pakistan.</li><br /> <li>The purchased Mini Crystal EDP Natural Spray 1107 25 ML For Women -SME can be delivered to Pakistan.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal EDP Natural Spray 1107 25 ML For Women -SME in Pakistan of PKR 653 and save 58%.</li> <br /> </ul>
38216 <p><strong><strong>Dunhill Icon Absolute</strong></strong> by <strong><strong>Alfred Dunhill</strong></strong> is a Woody Spicy fragrance for men. <strong><strong>Dunhill Icon Absolute</strong></strong> was launched in 2015. Top notes are bergamot and black pepper; middle notes are saffron, black rose and jasmine; base notes are agarwood (oud), tobacco leaf and leather.</p>
38217 <br /><ul><li><ul><li>The Mini Crystal London Icon EDP Natural Spray 1114 25ML For Men -SME Perfumes is manufactured by Mini Crystal.</li> </ul></li></ul><br /><br /><ul><li><ul><li>Buy the Mini Crystal London Icon EDP Natural Spray 1114 25ML For Men -SME at the best price in the Pakistan.</li> </ul></li></ul><br /><ul><li><ul><li>The purchased Mini Crystal London Icon EDP Natural Spray 1114 25ML For Men -SME can be delivered to Pakistan.</li> </ul></li></ul><br /><ul><li><ul><li>The product/item is Brand New.</li> </ul></li></ul><br /><ul><li><ul><li>Buy Mini Crystal London Icon EDP Natural Spray 1114 25ML For Men -SME in Pakistan of PKR 653 and save 58%.</li> </ul></li></ul>
38218 <span style="color: black;">If you are tired of some of the overpowering scents out there, try the fresh, tangy tones in it, one of the classic fragrances for unisex. <br>Introducing a sophisticated &amp; luxurious floral perfume that reflects the emotional side of the secret lady. The fragrance's top notes is combined with a beautiful fragrance. Its arousing aroma catches the diverse aspects &amp; give you outstanding fragrance.</span>
38219 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Perfect Addition</span></li> <li><span class="a-list-item">Healthier Option</span></li> <li><span class="a-list-item">Minimum effort </span></li> </ul>
38220
38221
38222 <ul><li>The Gucci Guilty Pour Homme EDT 50ML & All Over Shampoo 50ML Gift Set Perfumes is manufactured by Gucci.</li> <li></li> <li>Buy the Gucci Guilty Pour Homme EDT 50ML & All Over Shampoo 50ML Gift Set at the best price in the Pakistan.</li> <li>The purchased Gucci Guilty Pour Homme EDT 50ML & All Over Shampoo 50ML Gift Set can be delivered to Pakistan.</li> <li>The product/item is Brand New.</li> <li>Buy Gucci Guilty Pour Homme EDT 50ML & All Over Shampoo 50ML Gift Set in Pakistan of PKR 7783 and save 33%.</li> </ul>
38223
38224
38225