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 (
    34239, 34249, 34250, 34262, 34349, 34469, 
    34487, 34538, 2464, 2465, 2466, 2467, 
    2469, 1175, 1176, 1177, 1178, 1179, 
    1180, 1181, 1182, 1183, 1184, 1191, 
    1011, 1010, 1009, 999, 998, 997, 975, 
    958
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00075

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "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": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (34239,34249,34250,34262,34349,34469,34487,34538,2464,2465,2466,2467,2469,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1191,1011,1010,1009,999,998,997,975,958)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "122K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
958 <ul class="a-unordered-list a-vertical a-spacing-none collapsedFeatureBullets"><li class="showHiddenFeatureBullets"><span class="a-list-item">Total Repair 5 Leave-In Protein Treatment: This leave-in conditioner hair treatment for damaged hair recharges your hair and helps prevent the 5 signs of damage- spilt ends, weak, rough, dull, dehydrated for hair that feels soft and resilient.</span></li> </ul>
975 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">The Body Shop</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Manufacturer Number:</span> <span class="offer-product-attrValue ng-binding">111111</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Shampoo</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">400 ml</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Suitable Hair Type:</span> <span class="offer-product-attrValue ng-binding">Dry Hair</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Unisex</span></li> </ul>
997 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">4.4-fluid ounce bottle of Neutrogena T/Gel Therapeutic Stubborn Itch Shampoo with coal tar extract helps relieve the most persistent symptoms of an itchy, flaky scalp</span></li><li><span class="a-list-item">This anti-dandruff shampoo provides relief of scalp itch caused by scalp psoriasis, seborrheic dermatitis and common dandruff</span></li><li><span class="a-list-item">Its unique anti-itch formula contains Neutar Technology with 2% coal tar extract, an ingredient proven to deliver effective scalp therapy for a healthy scalp and is recognized by the National Psoriasis Foundation</span></li></ul>
998 <h6 style="font-family:opensans, 'Helvetica Neue', Helvetica, Helvetica, Arial, sans-serif;font-weight:400;margin-bottom:0px;color:#222222;line-height:1.4;text-transform:none;background-color:#ffffff;">Description:</h6><ul><li>Controls Redness, Intense Itching and Flaking of Severe Scalp Conditions</li> <li>Starts Working after Just One Use</li> <li>Dandruff, Psoriasis, Seborrheic Dermatitis</li> <li>#1 Dermatologist Recommended Brand</li> <li>4% Neutar (Coal Tar 1%)</li> </ul>
999 <h6 style="font-family:opensans, 'Helvetica Neue', Helvetica, Helvetica, Arial, sans-serif;font-weight:400;margin-bottom:0px;color:#222222;line-height:1.4;text-transform:none;background-color:#ffffff;">Description:</h6><ul><li>Controls Redness, Intense Itching and Flaking of Severe Scalp Conditions</li> <li>Starts Working after Just One Use</li> <li>Dandruff, Psoriasis, Seborrheic Dermatitis</li> <li>#1 Dermatologist Recommended Brand</li> <li>4% Neutar (Coal Tar 1%)</li> </ul>
1009 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">Batiste</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Dry Shampoo</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">200 ml</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Suitable Hair Type:</span> <span class="offer-product-attrValue ng-binding">Normal Hair</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Women</span></li> </ul>
1010 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">Batiste</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Dry Shampoo</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">200 ml</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Suitable Hair Type:</span> <span class="offer-product-attrValue ng-binding">All Hairs</span></li> </ul>
1011 <ul><li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Brand:</span> <span class="offer-product-attrValue ng-binding">batiste</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Type:</span> <span class="offer-product-attrValue ng-binding">Dry Shampoo</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Size:</span> <span class="offer-product-attrValue ng-binding">200 ml</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Suitable Hair Type:</span> <span class="offer-product-attrValue ng-binding">All Hairs</span></li> <li class="ng-scope"><span class="offer-product-attr ng-binding ng-scope">Targeted Group:</span> <span class="offer-product-attrValue ng-binding">Women</span></li> </ul>
1175 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">ARGININE RESIST X3 provides a triple action care designed for fragile hair so that it is more nourished and stronger.</span></li><li><span class="a-list-item">Nourishes the root</span></li><li><span class="a-list-item">Hair is stronger</span></li><li><span class="a-list-item">Restructures from root to tip.</span></li><li><span class="a-list-item">DIRECTIONS: Apply on wet hair, massage gently the entire scalp and rinse. For extra care, use as part of the complete ARGININE RESIST X3 range.</span></li></ul>
1176 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Nourishing Oil Shampoo transforms dry hair into looking and feeling soft, shiny and weightlessly detangled</span></li><li><span class="a-list-item">For even more nourishment try Elvive Extraordinary oil on wet or damp hair, as a mask treatment or as a finishing touch</span></li><li><span class="a-list-item">Enriched with 6 flower oil extracts</span></li></ul>
1177 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Nourishing Oil Shampoo transforms dry hair into looking and feeling soft, shiny and weightlessly detangled</span></li><li><span class="a-list-item">For even more nourishment try Elvive Extraordinary oil on wet or damp hair, as a mask treatment or as a finishing touch</span></li><li><span class="a-list-item">Enriched with 6 flower oil extracts</span></li></ul>
1178 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Packaging may vary</li><li class="jsx-1889249662">This triple action formula provides intense care that nourishes and reconstructs from root to tip</li><li class="jsx-1889249662">Hair becomes two times more resistant to breakage with 64 less hair fall after the first application</li></ul>
1179 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Healthier option</span></li><li><span class="a-list-item">Ideal for everyday use</span></li><li><span class="a-list-item">Brand : L'Oreal Paris</span></li></ul>
1180 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Nourishes, tames lasting smoothness</li><li class="jsx-1889249662">Beauty expertise for every hair care need</li><li class="jsx-1889249662">Your hair is silky, soft and manageable</li></ul>
1181 <ul class="jsx-1889249662 highlights"><li class="jsx-1889249662">Nourishes, tames lasting smoothness</li><li class="jsx-1889249662">Beauty expertise for every hair care need</li><li class="jsx-1889249662">Your hair is silky, soft and manageable</li></ul>
1182 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Our most luxurious shampoo enriched with 6 oily flower extracts nourishes dry hair right from the scalp and is the perfect balance of feeling light on the roots and nourishing on the ends.</span></li><li><span class="a-list-item">This transparent formula will leave your hair feeling beautifully nourished, soft and supple.</span></li><li><span class="a-list-item">Results: hair feels soft and has a lustrous shine. Your hair is weightlessly free-flowing and smells of luxurious flower oils.</span></li></ul>
1183 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Nourishing conditioner for dry to very dry hair</span></li><li><span class="a-list-item">A complete experience to transform dry to very dry hair</span></li><li><span class="a-list-item">Gives lustrous shine</span></li><li><span class="a-list-item">Touch voluptuous smoothness</span></li><li><span class="a-list-item">Feel weightlessly free-flowing lengths</span></li><li><span class="a-list-item">Rich formula that delivers intensive conditioning from the root to the tip</span></li><li><span class="a-list-item">Nourishing conditioner for dry to very dry hair</span></li></ul>
1184 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Blend of six flower extracts</span></li><li><span class="a-list-item">Suitable for dry, dull, rough hair</span></li><li><span class="a-list-item">Voluptuous softness</span></li><li><span class="a-list-item">Lustrous shine</span></li><li><span class="a-list-item">Effortlessly free-flowing, weightless touch</span></li></ul>
1191 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Deeply absorbs oil at the roots</span></li><li><span class="a-list-item">Up to 48HR purified roots plus hydrated ends</span></li><li><span class="a-list-item">Ultra-fresh, lightweight hair</span></li><li><span class="a-list-item">For Oily Roots and Dry Ends</span></li></ul>
2464 <ul><li>BELUX Keratin Shampoo helps to strengthen and soften the hair, while helping to smooth the cuticle for strong tresses, adding a brilliant, luxurious glow and luminescent shine.</li></ul><span></span>
2465 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : 111111</span></li><li><span class="a-list-item">Expirable : Yes</span></li><li><span class="a-list-item">Targeted Group : Unisex</span></li><li><span class="a-list-item">Suitable Hair Type : Damaged Hair</span></li><li><span class="a-list-item">Type : Shampoo</span></li><li><span class="a-list-item">Brand : Belux</span></li></ul>
2466 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Expirable : Yes</span></li><li><span class="a-list-item">Targeted Group : Unisex</span></li><li><span class="a-list-item">Suitable Hair Type : Damaged Hair</span></li><li><span class="a-list-item">Type : Shampoo</span></li><li><span class="a-list-item">Brand : Belux</span></li></ul>
2467 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Belux</span></li><li><span class="a-list-item">Type : Shampoo</span></li><li><span class="a-list-item">Size : 750 ml</span></li><li><span class="a-list-item">Suitable Hair Type : Colored Hair</span></li><li><span class="a-list-item">Targeted Group : Unisex</span></li><li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : No</span></li><li><span class="a-list-item">Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</span></li><li><span class="a-list-item">Expirable : Yes</span></li></ul>
2469 <ul><li>shampoo & shower gel 2 in 1</li><li>Belux Shower Gel & Shampoo will provide your hair with needed freshness and scent that will be felt</li><li>during the day. Furthermore, it is ideal for keeping your hair protected from dandru and will give you</li><li>needed shine and softness.</li><li>HOW TO USE: Pour a handful amount of liquid in your hand and scrub gently with plenty of water over your</li><li>head.</li><li>For both hair and body use</li></ul>
34239 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Moisturising shampoo that nourishes to make hair soft and up to 5x smooth</span></li> <li><span class="a-list-item">Helps to protect normal hair from daily wear and tear</span></li> <li><span class="a-list-item">Leaves your hair feeling silky and manageable every day</span></li> <li><span class="a-list-item">Progressively nourishes, leaving hair healthier looking in the long run</span></li> <li><span class="a-list-item">Formulated with Pro-moisture complex</span></li> <li><span class="a-list-item">Suitable for daily use</span></li> </ul>
34249 <ul class="a-unordered-list a-vertical a-spacing-none"><li class="showHiddenFeatureBullets"><span class="a-list-item">Godrej Expert Creme Hair Colour Natural Black 20G+20Ml</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">20 Milliliters</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Black</span></li> </ul>
34250 <ul class="a-unordered-list a-vertical a-spacing-none"><li class="showHiddenFeatureBullets"><span class="a-list-item">Godrej Expert Creme Hair Colour Natural Black 20G+20Ml</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">20 Milliliters</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Dark Brown</span></li> </ul>
34262 <ul><li>Take appropriate amount of oil, apply it on your hair roots, leave it for 3-4 hours, wash and shampoo.</li> </ul>
34349 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Type : Hair Treatment</span></li> <li><span class="a-list-item">Brand : L'Oreal Paris</span></li> </ul>
34469 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Portable and convenient: cordless light weight hair dryer powered by battery, perfect for drying hair and items on traveling, outdoor camping, hiking, swimming, BBQ, dry paintings in painting testing, etc.</span></li> <li><span class="a-list-item">Professional and Safe: DC hair dryer, the wind is mild and harmless , will not harm the human brain, more secure and assured.</span></li> <li><span class="a-list-item">Protect your hair: this mini hair dryer has only cold wind and no hot wind, which effectively avoids hurting hair due to high temperature.</span></li> <li><span class="a-list-item">Unique Design: foldable handle, easy to storage and carry, and the rechargeable design gives you more convenience.</span></li> <li><span class="a-list-item">Simple Operation: just turn the pulley down to start the machine, continue to slide down to adjust the wind.</span></li> </ul>
34487 <ul class="a-unordered-list a-vertical a-spacing-none"><li class="showHiddenFeatureBullets"><span class="a-list-item">Perfect Symmetric Trim Line – Get A Professional-Level Accurate Trim Or Crisp Shave, Without Your Barber'S Costly Services! Just Use This Amazing Grooming Guide Tool Along With Your Preferred Razor, Electric Trimmer Or Clipper,Grooming And Shaving Are Now Easier Than Ever</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Multiple Shapes & Styles - This Amazing Beard Comb Used For Neck Line, Cheek Line, Sideburns, Moustache, Jaw Line, Goatee and More. It Even Features Different Styles - Curve Cut Or Step Cut For Your Cheek For Example</span></li> </ul>
34538 <ul class="a-unordered-list a-vertical a-spacing-none"><li class="showHiddenFeatureBullets"><span class="a-list-item">3-month supply of Men's Rogaine 5% Minoxidil Foam hair growth treatment to help treat hair loss, maintain hair density and allow for the regrowth of fuller hair</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Formulated with 5% Minoxidil, our fast-working hair regrowth treatment works to boost hair follicle activity and hair protein production and is clinically proven to regrow up to 25% more hair</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Men's hair growth treatment also contains botanical extracts and emollient to help maintain a healthy, conditioned scalp, plus alphahydroxy acid (AHA) to promote natural skin exfoliation to help keep follicles open</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">From the #1 dermatologist-recommended brand, this anti-hair loss foam is ideal for use at the early stages of hair thinning and features Tricho-Prime Technology that works on contact to create a healthy hair regrowth environment</span></li> <li class="showHiddenFeatureBullets"><span class="a-list-item">Men's hair growth treatment delivers clinically visible results in as little as 12 weeks and comes in an easy-to-apply foam, specially designed to fit into your daily routine</span></li> </ul>