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 (
    38189, 38190, 38191, 38192, 38193, 38194, 
    38195, 38198, 38202, 38203, 38204, 
    38205, 38206, 38207, 38208, 38209
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00051

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 (38189,38190,38191,38192,38193,38194,38195,38198,38202,38203,38204,38205,38206,38207,38208,38209)) 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
38189 <ul><li>atchouli is a material of great importance in the perfumer’s palette. It plays as first violin in the orchestra. Among all the woody notes, it is the most sensuous. Patchouli evokes richness”, writes Patricia de Nicolaï. With Patchouli Homme, the perfumer wanted to compose a woody oriental for men, but she ended up selling it to women too (which is why it will soon be renamed Patchouli Intense). And why not? This distinctly un-hippie patchouli straddles both sides of the olfactory gender spectrum, with Patricia de Nicolaï signature candied orange opening, sprinkled with cinnamon, sweetening the wedding of a deep, dark, earthy patch and its natural partner, rose. A passing quote of the fougère family</li> </ul>
38190 <ul><li><span>Olympea Perfume by Paco Rabanne, This fragrance was created by the house of paco rabanne with perfumers anne flipo, loc dong and dominique ropion. it was released in 2015. a sweet flowery perfume with a hint of salt and powder. a long lasting warm scent that is smooth and rewarding to wear. the top note is green mandarin. the heart notes are ginger lily, water jasmine and salted vanilla and the bottom notes are sandalwood, ambergris and cashmere wood.</span></li> </ul>
38191 <ul><li><span>“A modern-day goddess. Beauty, wit, glory. But why stop there? Olympéa is back at her best. Half-myth, half-muse. A goddess at the pinnacle of her power. High heels, highly desirable. With her fragrance, she announces and signs her success. Carnal and irresistible. Sensual salty-vanilla fused with deep amber.” Available in 50ml and 75ml EDP bottles.</span>Olympéa Intense<span class="Apple-converted-space"> </span>was launched in 2016.</li> </ul>
38192 <ul><li>Akaster is a masculine fragrance by Parfums de Marly. The scent was launched in 2015</li> <li>Akaster fragrance notes</li> <li>Top Notes</li> <li>Sicilian lemon, Cypress</li> <li>Heart Notes</li> <li>Bulgarian rose, African geranium</li> <li>Base notes</li> <li>Cardamom, Musk, Oud</li> </ul>
38193 <ul><li>Parfums De Marly Athalia Edp 1.2Ml Vails</li> </ul>
38194 <ul><li>Parfums De Marly Sedbury Edp 1.2Ml Vails</li> </ul>
38195 <ul><li><span>An exciting walk in the oriental markets being replete with precious jewels, finery and cinnamon scents. In the valleys of Kashmir blows warm breeze puffing deep and warm captivating sounds. The resinous note enhances the fragrance with sensuality and depth. The powdery and woody cinnamon in luxurious combination with amber accord creates warm, round, sensuous, almost carnal notes.</span></li> </ul>
38198 <ul><li>Premiere Note Rose Sheherazade Edp 2 Ml Vail</li> </ul>
38202 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand: Genie Collections</span></li> <li><span class="a-list-item">Targeted Group: Men</span></li> <li><span class="a-list-item">Model Number: 5516</span></li> <li><span class="a-list-item">Perfume Name: null</span></li> <li><span class="a-list-item">Fragrance Type: Eau de Parfum</span></li> <li><span class="a-list-item">Fragrance Family: Woody & Spicy</span></li> <li><span class="a-list-item">Size: 25 ml</span></li> </ul>
38203 <ul><br /> <li>The Mini Crystal EDP Natural Spray For Men, 25 ML, 1006 – Smell Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal EDP Natural Spray For Men, 25 ML, 1006 – Smell at the best price in the United Arab Emirates.</li><br /> <li>The purchased Mini Crystal EDP Natural Spray For Men, 25 ML, 1006 – Smell can be delivered to United Arab Emirates.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal EDP Natural Spray For Men, 25 ML, 1006 – Smell in United Arab Emirates of AED 12 and save 66%.</li> <br /> </ul>
38204 <ul><li><span>Gender: Gents<br /></span></li> <li><span>Fragrance Type:Eau De Parfum<br /></span></li> <li><span>Volume: 25ml<br /></span></li> <li><span>Application: Splash<br /></span></li> <li><span>Made in U.A.E</span></li> </ul>
38205 <ul><br /> <li>The Mini Crystal Homme EDP Natural Spray For Men, 25 ML, 1012 – Smell Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal Homme EDP Natural Spray For Men, 25 ML, 1012 – Smell at the best price in the United Arab Emirates.</li><br /> <li>The purchased Mini Crystal Homme EDP Natural Spray For Men, 25 ML, 1012 – Smell can be delivered to United Arab Emirates.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal Homme EDP Natural Spray For Men, 25 ML, 1012 – Smell in United Arab Emirates of AED 12 and save 66%.</li> <br /> </ul>
38206 <br /><ul><li><ul><li>The Mini Crystal Pure Mini EDP Natural Spray 1014 25ML For Unisex -SME Perfumes is manufactured by Mini Crystal.</li> </ul></li></ul><br /><br /><ul><li><ul><li>Buy the Mini Crystal Pure Mini EDP Natural Spray 1014 25ML For Unisex -SME at the best price in the United Arab Emirates.</li> </ul></li></ul><br /><ul><li><ul><li>The purchased Mini Crystal Pure Mini EDP Natural Spray 1014 25ML For Unisex -SME can be delivered to United Arab Emirates.</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 Pure Mini EDP Natural Spray 1014 25ML For Unisex -SME in United Arab Emirates of AED 15 and save 58%.</li> </ul></li></ul>
38207 <ul><li><span style="font-size:10pt;">MINI CRYSTAL NO.1062 FOR HER EDP 25 ML</span></li> <li><span style="font-size:10pt;">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. </span></li> <li><span style="font-size:10pt;">FEATURES:</span></li> <li><span style="font-size:10pt;">- Gender: Unisex</span></li> <li><span style="font-size:10pt;">- Fragrance Type:Eau De Parfum</span></li> </ul>
38208 <ul><br /> <li>The Mini Crystal Mini EDP Natural Spray For Women, 25 ML, 1067 – Smell Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal Mini EDP Natural Spray For Women, 25 ML, 1067 – Smell at the best price in the Pakistan.</li><br /> <li>The purchased Mini Crystal Mini EDP Natural Spray For Women, 25 ML, 1067 – Smell can be delivered to Pakistan.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal Mini EDP Natural Spray For Women, 25 ML, 1067 – Smell in Pakistan of PKR 522 and save 66%.</li> <br /> </ul>
38209 <ul><br /> <li>The Mini Crystal Mini EDP Natural Spray For Men, 25 ML, 1072 – Smell Perfumes is manufactured by Mini Crystal.</li><br /> <li></li><br /> <li>Buy the Mini Crystal Mini EDP Natural Spray For Men, 25 ML, 1072 – Smell at the best price in the Pakistan.</li><br /> <li>The purchased Mini Crystal Mini EDP Natural Spray For Men, 25 ML, 1072 – Smell can be delivered to Pakistan.</li><br /> <li>The product/item is Brand New.</li><br /> <li>Buy Mini Crystal Mini EDP Natural Spray For Men, 25 ML, 1072 – Smell in Pakistan of PKR 522 and save 66%.</li> <br /> </ul>