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 (
    9837, 9838, 9839, 9840, 9841, 9842, 9843, 
    9844, 9845, 9846, 9847, 9848, 9849, 
    9850, 9851, 9852
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00052

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 (9837,9838,9839,9840,9841,9842,9843,9844,9845,9846,9847,9848,9849,9850,9851,9852)) 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
9837 <ul><li>Crystal Clear</li> <li>Shock Resistant (0.33-0.4 Mm Glass)</li> <li>Oleophobic Layer (anti-Fingerprint)</li> <li>Scratch Resistant</li> <li>100% Touch Preservation</li> <li>Full Frame Screen Coverage</li> <li>Different Color Options</li> <li>Rounded Edges (on Some Models)</li> <li>Optimised Adhesive and Anti-Scatter Film (up to 0.25 Mm in Thickness)</li> <li>Lifetime Warranty</li> <li>Contains Mineral Oil to Create the Dynamic Flowing Glitter Effect</li> </ul>
9838 <ul><li>Crystal Clear</li> <li>Shock Resistant (0.33-0.4 Mm Glass)</li> <li>Oleophobic Layer (anti-Fingerprint)</li> <li>Scratch Resistant</li> <li>100% Touch Preservation</li> <li>Full Frame Screen Coverage</li> <li>Different Color Options</li> <li>Rounded Edges (on Some Models)</li> <li>Optimised Adhesive and Anti-Scatter Film (up to 0.25 Mm in Thickness)</li> <li>Lifetime Warranty</li> <li>Contains Mineral Oil to Create the Dynamic Flowing Glitter Effect</li> </ul>
9839 <ul><li>Panzer Glass Is Minimum 04 Mm Thick.</li> <li>Completely Transparent.</li> <li>Hardness of Panzer Glass Is 9 Times Stronger than Regular Glass.</li> <li>Even Sharp Objects Such as Knives and Keys Will Not Scratch the Panzer Glass.</li> <li>Panzer Glass Has an Oleophobic Coating that Prevents Fingerprints and Other Contaminants and Makes the Glass Easy to Clean.</li> <li>Panzer Glass Is Coated on The Back with A Strong Silicone Adhesive that Makes Installation Easy and Attaches the Glass Firmly so As to Not Affect the Touch Screen S Sensitivity.</li> <li>If Broken Panzer Glass Breaks Into Small Unsharp Pieces Which Adheres to The Anti Shatter Film Making It Safer than Other Glass Products.</li> </ul>
9840 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Featuring a Privacy Filter, when Viewed from An Angle the Panzer Glass Screen Protector for I Phone 7 Will Ensure People Nearby Can't Glance Over and View Your Display.</span></li> <li><span class="a-list-item">Hardness of Panzer Glass Is 9 Times Stronger than Regular Glass.</span></li> <li><span class="a-list-item">Panzer Glass Has an Oleophobic Coating that Prevents Fingerprints and Other Contaminants and Makes the Glass Easy to Clean.</span></li> <li><span class="a-list-item">Panzer Glass Is Coated on The Back with A Strong Silicon Adhesive that Makes Installation Easy and Attaches the Glass Firmly so As to Not Affect the Touch Screen's Sensitivity.</span></li> <li><span class="a-list-item">Anti-Shatter Film. if Broken, Panzer Glass Breaks Into Small Unsharp Pieces, Which Adheres to The Anti-Shatter Film, Making It Safer than Other Glass Products.</span></li> </ul>
9841 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Original PanzerGlass screen protector trusted by millions worldwide</span></li> <li><span class="a-list-item">Shock and scratch resistant - PanzerGlass absorbs most shocks and scratches, so your screen does not have to</span></li> <li><span class="a-list-item">Edge-to-edge design – protect your entire screen and frame</span></li> <li><span class="a-list-item">Crystal clear – PanzerGlass is highly transparent, so you will hardly notice you are protecting your favourite mobile device</span></li> <li><span class="a-list-item">Oleophobic layer (anti-fingerprint) – High-tech finishing layer that greatly reduces fingerprints, smudges, and dirt to provide the best viewing experience possible</span></li> </ul><ul><li><span class="a-list-item">Shock resistant (0.33-0.4 mm glass)</span></li> <li><span class="a-list-item">Scratch resistant</span></li> <li><span class="a-list-item">Crystal Clear</span></li> <li><span class="a-list-item">100% touch preservation</span></li> <li><span class="a-list-item">Rounded edges</span></li> <li><span class="a-list-item">Oleophobic layer (anti-fingerprint)</span></li> </ul>
9842 <p><span>PanzerGlass™ Standard Fit Apple iPhone Xs Max Privacy screen protector is made of flat tempered glass. It is reduced in size and covers the entire non-curving area of the device. </span></p> <p><br /><span>The glass features a confidentiality filter, that renders the content of your display almost invisible to everyone except you. At the same time, it reduces blue light and features an anti-glare coating, that reduces light reflections. </span><br /><br /></p> <div> <div class="container"> <div class="tab-details"> <p class="longDesc"><strong>Key features:</strong><br />• Original PanzerGlass™ tempered glass screen protector<br />• Confidentiality filter<br />• Shock resistant (0.33- 0.4 mm glass)<span> </span><br />• Scratch resistant<br />• Oleophobic layer (antibacterial + anti-fingerprint)<span> </span><br />• 100% touch preservation<br />• Anti-glare coating (reduces light reflection)<span> </span><br />• Blue light reduction</p> <p> </p> <p> </p> </div> </div> </div> <div> <div class="container"> </div> </div>
9843 <ul><li>Original Panzer Glass™ Tampered Glass Screen Protector</li> <li>Confidentiality Filter</li> <li>Shock Resistant (0.33- 0.4 Mm Glass)</li> <li>Scratch Resistant</li> <li>Full Frame Coverage</li> <li>Oleophobic Layer (antibacterial + Anti-Fingerprint)</li> <li>100% Touch Preservation</li> <li>Anti-Glare Coating (reduces Light Reflection)</li> <li>Blue Light Reduction</li> </ul>
9844 <ul><li><span>Incredibly useful and unique tempered glass screen protector from PanzerGlass</span></li> <li><span>It protects the entire front of your iPhone XS and X thanks to Edge t -Edge coverage</span></li> <li><span>The PanzerGlass CF Privacy wont lift or detach when you put your device into a protective case</span></li> <li><span>The Privacy feature means the display of your iPhone wont be seen from the sides</span></li> <li><span>A special anti glare coating reduces light reflection and blue light</span></li> <li><span>The shatterproof feature prevents the screen protector from bursting into small pieces upon impact</span></li> <li><span>An integrated CamSlider blocks anyone to see you through the front-facing camera on your iPhone</span></li> <li><span>The PanzerGlass CF Privacy screen protector is only 04mm thin and doesnt add any bulk</span></li> <li><span>The oleophobic coating repels dirt dust fingerprint and other contaminants</span></li> <li><span>The PanzerGlass CF Privacy shields the display of your iPhone from damage during daily use</span></li> </ul>
9845 <ul><li><span>Incredibly useful and unique tempered glass screen protector from PanzerGlass</span></li> <li><span>It protects the entire front of your iPhone XS Max thanks to Edge t -Edge coverage</span></li> <li><span>The PanzerGlass CF Privacy wont lift or detach when you put your device into a protective case</span></li> <li><span>The Privacy feature means the display of your iPhone XS Max wont be seen from the sides</span></li> <li><span>A special anti glare coating reduces light reflection and blue light</span></li> <li><span>The shatterproof feature prevents the screen protector from bursting into small pieces upon impact</span></li> <li><span>An integrated CamSlider blocks anyone to see you through the front-facing camera on your iPhone XS Max</span></li> <li><span>The PanzerGlass CF Privacy screen protector is only 04mm thin and doesnt add any bulk</span></li> <li><span>The oleophobic coating repels dirt dust fingerprint and other contaminants</span></li> <li><span>The PanzerGlass CF Privacy shields the display of your iPhone XS Max from damage during daily use</span></li> </ul>
9846 <ul><li>Precision molded for perfect fit and stability</li> <li>Industry-leading thickness for max protection</li> <li>Design complements Apple's signature aesthetic</li> <li>Access to Lightning port</li> <li>Includes a premium key ring & clasp to secure your AirPods to whatever, whenever</li> </ul><p>Everyday Protection for your AirPods with the Silicone Case by Pod Pocket</p>
9847 <ul><li>Precision molded for perfect fit and stability</li> <li>Industry-leading thickness for max protection</li> <li>Design complements Apple's signature aesthetic</li> <li>Access to Lightning port</li> <li>Includes a premium key ring & clasp to secure your AirPods to whatever, whenever</li> </ul><p>Everyday Protection for your AirPods with the Red Silicone Case by Pod Pocket</p>
9848 <ul><li style="list-style-type:none;"> <ul><li>Precision Molded for Perfect Fit and Stability</li> <li>Industry-Leading Thickness for Max Protection</li> <li>Design Complements Apple's Signature Aesthetic</li> <li>Access to Lightning Port</li> <li>Includes a Premium Key Ring & Clasp to Secure Your Air Pods  to Whatever, Whenever</li> </ul><p>Everyday Protection for Your Air Pods with The Silicone Case by Pod Pocket</p> </li> </ul>
9849 <ul><li style="list-style-type:none;"> <ul><li>Precision Molded for Perfect Fit and Stability</li> <li>Industry-Leading Thickness for Max Protection</li> <li>Design Complements Apple's Signature Aesthetic</li> <li>Access to Lightning Port</li> <li>Includes a Premium Key Ring & Clasp to Secure Your Air Pods to Whatever, Whenever</li> </ul><p>Everyday Protection for Your Air Pods with The Red Silicone Case by Pod Pocket</p> </li> </ul>
9850 <ul><li>Precision Molded for Perfect Fit and Stability</li> <li>Industry-Leading Thickness for Max Protection</li> <li>Design Complements Apple's Signature Aesthetic</li> <li>Access to Lightning Port</li> <li>Includes a Premium Key Ring & Clasp to Secure Your Air Pods Whatever, Whenever</li> </ul><p>Everyday Protection for Your Air Pods with The Red Silicone Case by Pod Pocket</p>
9851 <ul><li>Precision Molded for Perfect Fit and Stability</li> <li>Industry-Leading Thickness for Max Protection</li> <li>Design Complements Apple's Signature Aesthetic</li> <li>Access to Lightning Port</li> <li>Includes a Premium Key Ring & Clasp to Secure Your Air Pods  to Whatever, Whenever</li> </ul><br /><ul><li style="list-style-type:none;"> <p>Everyday Protection for Your Air Pods with The Silicone Case by Pod Pocket</p> </li> </ul>
9852 <ul><li>Precision Molded for Perfect Fit and Stability</li> <li>Industry-Leading Thickness for Max Protection</li> <li>Design Complements Apple's Signature Aesthetic</li> <li>Access to Lightning Port</li> <li>Includes a Premium Key Ring & Clasp to Secure Your Air Pods  to Whatever, Whenever</li> </ul><p>Everyday Protection for Your Air Pods with The Red Silicone Case by Pod Pocket</p>