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 (
    9549, 9550, 9551, 9552, 9553, 9554, 9555, 
    9556, 9557, 9558, 9559, 9560, 9561, 
    9562, 9563, 9564, 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.00078

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 (9549,9550,9551,9552,9553,9554,9555,9556,9557,9558,9559,9560,9561,9562,9563,9564,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": "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
9549 <ul><li>Parental Control: These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connectivity: Connect to any audio device with the line-in jack and listen to whatever you like</li> <li>Performance: Enter a world of your own and enjoy crisp quality sound from the makers of iHome</li> <li>Comfort & Quality: Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit</li> <li>Perfect Gift: This will make the perfect gift or birthday present for your little hero!</li> </ul>
9550 <ul><li>Parental Control These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and or Android users </li> <li>Connectivity Connect to any audio device with the line in jack and listen to whatever you like</li> <li>Performance Enter a world of your own and enjoy crisp quality sound from the makers of iHome</li> <li>Comfort and Quality Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit</li> <li>Perfect Gift This will make the perfect gift or birthday present for your little hero</li> </ul>
9551 <ul><li>Parental Control: These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connectivity: Connect to any audio device with the line-in jack and listen to whatever you like</li> <li>Performance: Enter a world of your own and enjoy crisp quality sound from the makers of iHome</li> <li>Comfort & Quality: Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit</li> <li>Perfect Gift: This will make the perfect gift or birthday present for your little hero!</li> </ul>
9552 <ul><li>These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connect to any audio device with the line-in jack and listen to whatever you like.</li> <li>Enter a world of your own and enjoy crisp quality sound from the makers of iHome.</li> <li> Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit.</li> <li>This will make the perfect gift or birthday present for your little Jedi!</li> </ul>
9553 <ul><li>These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connect to any audio device with the line-in jack and listen to whatever you like</li> <li>Enter a world of your own and enjoy crisp quality sound from the makers of iHome</li> <li>Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit</li> <li>This will make the perfect gift or birthday present for your little hero!</li> </ul>
9554 <ul><li>These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connect to any audio device with the line-in jack and listen to whatever you like.</li> <li>Enter a world of your own and enjoy crisp quality sound from the makers of iHome.</li> <li>Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit.</li> <li>This will make the perfect gift or birthday present for your little Jedi!</li> </ul>
9555 <ul><li>Bluetooth technology wirelessly connects to your MP3 player, smartphone, tablet, or computer so you can enjoy cord-free listening</li> <li>Integrated microphone and speaker phone function allow you to take calls hands-free, as well as answer and end calls with voice commands</li> <li>Built-in rechargeable battery lasts up to 6 hours on a single charge</li> <li>Includes a micro USB cable for charging the speaker</li> <li>Power and charging LED indicator lets you know when the speaker is on and when it's done charging</li> </ul>
9556 <ul><li>Bluetooth technology wirelessly connects to your MP3 player, smartphone, tablet, or computer so you can enjoy cord-free listening</li> <li>Integrated microphone and speaker phone function allow you to take calls hands-free, as well as answer and end calls with voice commands</li> <li>Built-in rechargeable battery lasts up to 6 hours on a single charge</li> <li>Includes a micro USB cable for charging the speaker</li> <li>Power and charging LED indicator lets you know when the speaker is on and when it's done charging</li> </ul>
9557 <ul><li>Bluetooth technology wirelessly connects to your MP3 player, smartphone, tablet, or computer so you can enjoy cord-free listening</li> <li>Integrated microphone and speaker phone function allow you to take calls hands-free, as well as answer and end calls with voice commands</li> <li>Built-in rechargeable battery lasts up to 6 hours on a single charge</li> <li>Includes a micro USB cable for charging the speaker</li> <li>Power and charging LED indicator lets you know when the speaker is on and when it's done charging</li> </ul>
9558 <ul><li> These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connect to any audio device with the line-in jack and listen to whatever you like</li> <li>Enter a world of your own and enjoy crisp quality sound from the makers of iHome</li> <li>Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit</li> <li>This will make the perfect gift or birthday present for your little hero!</li> </ul>
9559 <ul><li>Parental Control: These headphones come equipped with an adjustable volume limiter to provide a safe and optimal listening experience for iOS and/or Android users. (See back of packaging for more details)</li> <li>Connectivity: Connect to any audio device with the line-in jack and listen to whatever you like</li> <li>Performance: Enter a world of your own and enjoy crisp quality sound from the makers of iHome</li> <li>Comfort & Quality: Padded pivoting ear cushions and an adjustable headband allows for a comfortable custom fit</li> <li>Perfect Gift: This will make the perfect gift or birthday present for your little hero!</li> </ul>
9560 <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>
9561 <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>
9562 <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>
9563 <ul><li> Easy and quick installation complementing perfectly your iRing </li> <li> Small-sized Mount that doesn't block any air passing through the vent </li> <li> Ensures safe driving by securing wide field of view and easy mounting </li> <li> Rotate the clip depending on the horizontal or vertical vent type and mount on the vent </li> </ul>
9564 <p>Protective case that works with wireless charging compatibility. Simply Slide the iRing down to the bottom of the rail, and rest your phone on top of a wireless charger.</p> <ul><li>Wireless charger compatible</li> <li>Rotates 180 and 360 degrees</li> <li>Horizontal and Vertical Kickstand</li> <li>Patented Swivel Mechanism</li> <li>Minimal design</li> <li>Compatible with iRing hook and Dock accessories</li> <li>Dimensions:8 x 15 x 1,5 cm</li> </ul>
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>