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 (
    9565, 9566, 9567, 9568, 9569, 9570, 9571, 
    9572, 9573, 9574, 9575, 9576, 9577, 
    9578, 9579, 9580
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00044

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 (9565,9566,9567,9568,9569,9570,9571,9572,9573,9574,9575,9576,9577,9578,9579,9580)) 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
9565 <ul><li>Iring gives you comfortable and secure grip, reducing the damage caused by drop</li> <li>Wear an iring and enjoy tapping every corner of your smartphone only with a thumb</li> <li>Iring hook: attach the hook everywhere and hook your irking, so you can tilt your smartphone in any directions</li> <li>As a kickstand, horizontally and vertically, you can use irking at any angles</li> <li>Dimensions: 8 x 2 x 11 cm</li> </ul>
9566 <ul><li>Iring gives you comfortable and secure grip, reducing the damage caused by drop</li> <li>Wear an iring and enjoy tapping every corner of your smartphone only with a thumb</li> <li>Iring hook: attach the hook everywhere and hook your irking, so you can tilt your smartphone in any directions</li> <li>As a kickstand, horizontally and vertically, you can use irking at any angles</li> <li>Dimensions: 8 x 2 x 11 cm</li> </ul>
9567 <ul><li>Iring gives you comfortable and secure grip, reducing the damage caused by drop</li> <li>Wear an iring and enjoy tapping every corner of your smartphone only with a thumb</li> <li>Iring hook: attach the hook everywhere and hook your irking, so you can tilt your smartphone in any directions</li> <li>As a kickstand, horizontally and vertically, you can use irking at any angles</li> <li>Dimensions: 8 x 2 x 11 cm</li> </ul>
9568 <ul><li>Iring gives you comfortable and secure grip, reducing the damage caused by drop</li> <li>Wear an iring and enjoy tapping every corner of your smartphone only with a thumb</li> <li>Iring hook: attach the hook everywhere and hook your iring, so you can tilt your smartphone in any directions</li> <li>As a kickstand, horizontally and vertically, you can use iring at any angles</li> <li>Dimensions: 8 x 2 x 11 cm</li> </ul>
9569 <ul><li>Iring gives you comfortable and secure grip, reducing the damage caused by drop</li> <li>Wear an iring and enjoy tapping every corner of your smartphone only with a thumb</li> <li>Iring hook: attach the hook everywhere and hook your irking, so you can tilt your smartphone in any directions</li> <li>As a kickstand, horizontally and vertically, you can use irking at any angles</li> <li>Dimensions: 8 x 2 x 11 cm</li> </ul>
9570 <ul><li>Allows to comfortably and naturally grip and expand the use of your smart device</li> <li>Premium Smart Grip allows secure positioning & Kickstand which functions horizontal & vertical</li> <li>Patented Swivel Hinge: rotates 360 degrees and swivels 180 degrees</li> <li>Strong & Secure Adhesive: applied & removed anytime w/o leaving any excess residue</li> <li>Holds up to 6,8 kg making it also suitable for phones, iPads and other tablets</li> </ul>
9571 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">iRing plus card Pocket Replace your wallet with iRing pocket You can hold your credit card in the back pocket on your smartphone</span></li> <li><span class="a-list-item">iRing Pocket is made of dual structure for holding your card more safely</span></li> <li><span class="a-list-item">US designed product with guaranteed quality to last longer than any other ring holders </span></li> </ul>
9572 <ul><li>Allows to comfortably and naturally grip and expand the use of your smart device</li> <li>Premium Smart Grip allows secure positioning & Kickstand which functions horizontal & vertical</li> <li>Patented Swivel Hinge: rotates 360 degrees and swivels 180 degrees</li> <li>Strong & Secure Adhesive: applied & removed anytime w/o leaving any excess residue</li> <li>Holds up to 6,8 kg making it also suitable for phones, iPads and other tablets</li> </ul>
9573 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Draw with any pen thanks to the removable ring that gives to your physical tool a digital power.</span></li> <li><span class="a-list-item">Use any kind of paper to draw with the Slate, even a sketchpad (up to 7mm of thickness).</span></li> <li><span class="a-list-item">Use the Slate connected to your device to see your drawings in live, or in screen less mode to take it and draw everywhere thanks to its integrated battery.</span></li> <li><span class="a-list-item">Compatibility : iPad 3, iPad 4 | iPad Air, iPad Air 2 | iPad mini Retina, iPad mini 3, iPad mini 4 | iPad Pro | iPhone 6, iPhone 6 Plus, iPhone 6S, iPhone 6S Plus, iPhone 7, iPhone 7 Plus | Windows 7 or later | Mac OSX Yosemite 10.10 or later | Android Smartphones - Not Released</span></li> <li><span class="a-list-item">Box Contains : 1 Slate; 1 iskn black Pen with integrated ring; 1 pencil with removable ring (S size); 2 clips; 1 sketchpad; 1 USB cable</span></li> </ul>
9574 <ul><li>Easy to use flexible tripod for action video cameras like GoPro, Contour and Sony Action Cam</li> <li>Quick Set-ups: Comes with two quick-release clips Mount for GoPro and the standard 14-20 tripod clip so it works with all action cameras</li> <li>Precise control with integrated ballhead Quickly orient your action camera with 90 degrees tilting and 360 panning capabilities</li> <li>Secure camera almost anywhere</li> </ul>
9575 <ul><li>The perfect mount for quickly attaching your GoPro/action camera to smooth surfaces</li> <li>Movable arm for quick camera angle adjustments: The reliable GorillaPod ball & socket arm allows you to quickly change the action camera position</li> <li>Ultimate hold on smooth surfaces: Industrial-strength suction cup locks into place to provide a secure hold against smooth, non-porous and clean surfaces.</li> <li>Quick-twist lock for easy and fast set-up: Simplified, compact design makes it easy to grip and secure</li> </ul>
9576 <ul><li>Mount and flexible tripod for your iPhone, Android, Windows phone or smaller tablet</li> <li>Universal smartphone compatibility</li> <li>Flexible, wrappable joints secure phone to objects and allow for adaptable camera positioning</li> <li>Stability on flat or uneven surfaces.</li> <li>A reliable grip on the phone: rubber pads secure phone in place, even when turned sideways.</li> <li>Secure hold after repeated use</li> </ul>
9577 <ul class="pdp-info__bulletpoints"><li>Universal smartphone compatibility fits any model  56mm to 91mm</li> <li>Locking lever clamps phone securely within the TPE grip pads</li> <li>GoPro style pin joint mounts phone to any GoPro accessory</li> <li>Ergonomic handgrip pivots 180 degrees for optimal capture angles</li> <li>Impulse remote is certified Bluetooth for Android and IOS</li> </ul>
9578 <ul class="pdp-info__bulletpoints"><li>Universal smartphone compatibility</li> <li>Flexible legs wrap around objects for stability anywhere</li> <li>Legs create a handle for selfies vlogging or hand held video</li> <li>Rubber feet provide a stabile grip on any surface</li> <li>Compact and lightweight for easy transport</li> </ul>
9579 <ul><li>Apple MFi Certified 2-in-1 charging cable & compact portable battery booster</li> <li>Unlike power banks, JUMP charges itself after charging your device using auto-charge technology so it's always full and ready to go</li> <li>Plug it into your device for up to 30% extra battery power when you're on the go, or use its Lightning to USB connectors to charge from any USB power outlet</li> <li>The size of a matchbox and weighing just 42g, JUMP is compact enough to take with you everywhere</li> </ul>
9580 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Automatically ready and charged</span></li> <li><span class="a-list-item">Talk time up to 3 hours</span></li> <li><span class="a-list-item">Trigger Battery status button</span></li> <li><span class="a-list-item">Lightning connector</span></li> </ul>