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 (
    9966, 9967, 9968, 9969, 9970, 9971, 9972, 
    9973, 9974, 9975, 9976, 9977, 9978, 
    9979, 9980, 9981
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00049

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 (9966,9967,9968,9969,9970,9971,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981)) 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
9966 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Elevates iMac or external display to your optimal viewing height up to 93 mm 3 3 point 66 in</span></li> <li><span class="a-list-item">Creates hidden desktop storage for hard drives hubs or personal items</span></li> <li><span class="a-list-item">Features a reversible walnut aluminum front plate and padded leather top</span></li> <li><span class="a-list-item">Internal shelf adusts to four different screen height options</span></li> <li><span class="a-list-item">Works with all iMacs and most displays</span></li> <li><span class="a-list-item">Displays fit up to maximum base depth of 235 mm 9 point 25 in and max base witdth of 235 mm 9 point 25 in</span></li> </ul>
9967 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Genuine leather case for Apple Pencil</span></li> <li><span class="a-list-item">Magnetically attaches to most iPad cases</span></li> <li><span class="a-list-item">Helps transport and protect Apple Pencil with your iPad</span></li> <li><span class="a-list-item">Compatible with Apple Smart Cover, Apple Smart Keyboard and Twelve South Surface Pad for iPad Pro</span></li> </ul>
9968 <ul><li><span>A built-in typing/sketching angle protects your wrists for long sessions on iPad</span></li> <li><span>An incorporated display stand allows you to show your work anywhere</span></li> <li><span>Hardback covers, crush resistant spine and a soft interior lining keep iPad safe wherever you go</span></li> <li><span>iPad Pro and 2018 versions include Apple Pencil storage in the spine</span></li> </ul><p><span>BookBook for iPad is a gorgeous leather case designed to fit the family of iPads like a glove. Each BookBook is a handmade, one-of-a-kind, hardback leather case designed to protect and enhance your iPad experience.</span></p>
9969 <ul><li><span>Vintage style leather portfolio case for iPad Pro 12.9</span></li> <li><span>Unique book design protects and disguises iPad for added security</span></li> <li><span>Integrated kickstand angles iPad for comfortable sketching and typing</span></li> <li><span>Converts to adjustable display and movie watching stand</span></li> <li><span>Interior pocket stores Apple Pencil or iPad stylus inside spine</span></li> </ul>
9970 <ul><li><span>Allows wireless headphones to connect to wired headphone jacks</span></li> <li><span>Use to pair AirPods with airline in-flight entertainment systems</span></li> <li><span>Listen to your health club’s TVs with your wireless sport headphones</span></li> <li><span>Built-in battery lasts up to 8 hours & recharges via USB</span></li> </ul><p><span>Wish you could listen to in-flight TV with your AirPods? Want to hear the gym cardio machine's TV audio with your wireless headphones? Now you can, thanks to AirFly - a tiny device that connects wireless headphones to wired-audio jacks on planes, in fitness centers and anywhere else wired headphones were previously required.</span></p>
9971 <p><span>Compatible with all Qi enabled smartphones iPhone Pixel Galaxy etc</span><br /><span>Works with cases up to 3mm thick and up to 6 point 5 inches tall</span><br /><span>Qi certified fast charger delivers up to 10W wireless power</span><br /><span>New Zealand pine frame holds any 5 inches x 7 inches photo</span></p> <p>Looking for a wireless phone charger that does not like another dock or charger Meet PowerPic the picture frame that wirelessly charges your phone</p> <p>PowerPic has hidden Qi charger is capable of providing up to 10 watts of fast charging power just set any Qi compatible phone inside the frame to begin charging The contemporary frame is made of New Zealand Pine and holds any 5 inches x 7 inches photo</p>
9972 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9973 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9974 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> <li>Easy to attach and hang to your car seat</li> <li>Have fun characters</li> <li>Can watch videos or play games comfortably</li> </ul>
9975 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9976 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9977 <ul><li>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9978 <ul><li><span>Wise Pet is a huggable protective cover. This makes the Wise Pet suitable for children. The cover is suitable for iOS and Android phones or tablets.</span></li> <li>Compatible with: Smartphones and tablets</li> <li>Smooth touch operation</li> <li>Make the Pet alive with the special app</li> <li><span>Made of soft material that will not scratch or tear. You can even hang Wise-Pet in the car with its plastic hook and a rubber loop</span></li> <li>In order to use the Wise-Pet in the car, insert the plastic hook into its matching loop. Place the Wise-Pet with the strap on or below the head of the seat. Ensure that it is facing the child, and make sure that it is tightly secured. It is that simple! Now place the device inside the Wise-Pet and let your child play</li> </ul>
9979 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">The ZENS Dual Aluminum Wireless Charger has an ultra thin design that is made from one piece high grade aluminum and it is designed to efficiently fast charge two devices simultaneously The charger supports Apple and Samsung fast charge with a maximum output of 20W 2 x 10w The charger comes with a power adapter</span></li> <li><span class="a-list-item">Charging your device wirelessly has never been easier The charging pad itself is powered via an included adapter that features ultra low standby power Charging stops when your phone reaches full charge, then resumes as battery life drops Simply place your Qi enabled device on the charger and it will begin charging</span></li> <li><span class="a-list-item">The underlying inductive technology ensures foolproof charging every time your device is placed on the charger Your phone can be freely placed and doesnt have to be locked into position A flawless performance is ensured time and again</span></li> </ul>
9980 <ul><li><span>Max total output of 20W 2 10W</span></li> <li><span>Supports Apple and Samsung Fast Charge</span></li> <li><span>Ultra thin 8mm design</span></li> <li><span>Made out of one piece high grade aluminium</span></li> <li><span>Changes two devices and an Apple Watch simultaneously</span></li> <li><span>Power adapter included EU</span></li> <li><span>MFi certified</span></li> <li><span>Qi certified</span></li> </ul>
9981 <div> <ul><li><span>Max 5W output</span></li> <li><span>4500mAh capacity (recharge your phone up to 2 times)</span></li> <li><span>Adhesive grip; keeps phone in place while charging</span></li> <li><span>Wirelessly rechargeable</span></li> <li><span>USB-C cable included</span></li> </ul></div> <p>With a sleek ultra slim design the ZENS Powerbank Wireless Charger is a fantastic space saving way to charge your smartphone everywhere at home in the office or on the go</p> <p>Designed for quick and intuitive charging this powerbank allows you to charge any compatible smartphone without the tangle of power cords</p> <p>With a strong 4500 mAh capacity this wireless charging solution fuels your mobile device and keeps it going at any place and time</p>