Sandbox

SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    217751, 217962, 219307, 219925, 220284, 
    220466, 220543, 222009, 223262, 223514, 
    224345, 216661, 216710, 216892, 217345, 
    221976, 222769, 224273, 224693, 216542, 
    216632, 220398, 223963, 224523, 216301, 
    225715
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00013

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 26,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (217751,217962,219307,219925,220284,220466,220543,222009,223262,223514,224345,216661,216710,216892,217345,221976,222769,224273,224693,216542,216632,220398,223963,224523,216301,225715) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id	short_description	full_description
216301		With sound designed by Meridian, TONE Free HBS-FN5W delivers clear and spatial audio. No matter where you are, become completely immersed in whatever you listen to and forget you are wearing earbuds.
216542		One sleek set of wireless earbuds to rule them all. The Klipsch T5 True wireless earbuds are the ultimate combination of comfort, design, efficiency, and legendary acoustic clarity.
216632		UA True Wireless Streak is engineered to maximize performance while minimizing size and distractions. A lightweight design with Sport Flex Fit ear tips provides optimized comfort andsecure fit tested by athletes. UA waterproof technology delivers element-battling protection,while JBL Charged Sound is boldly tuned with rich bass for motivation. Bionic Hearingfeatures TalkThru Technology to quickly interact with your workout partner, and Ambient AwareTechnology to hear your surroundings.
216661		Engineered to provide you with complete audio freedom without distraction, WF-1000XM3 True Wireless Noise-Canceling In-Ear Earphones from Sony incorporates sophisticated noise-canceling technologies to isolate you with only your favorite music, TV shows, podcasts, or other audio entertainment. The 1000XM3 earphones utilizes forward- and rear-facing microphones to take in distracting ambient sounds and noises, and Sony's QN1e HD noise-canceling processor works to completely filter them out.
216710		Minolta's MNCD53 captures all your driving's point of view. Features 1080p Full HD video resolution for superb clarity. Set it to record automatically when sensing motion. A high resolution 140 degrees wide-angle lens, Wide Dynamic Range, and a 12MP photo resolution captures the clearest footage. Play all of your trips back on the 3.0 230k LCD. Set your recording time to 3-10 minute intervals. The built-in G-sensor automatically senses a collision and begins recording emergency footage for safe keeping. Includes 8GB SD Card. Color: Gold.
216892		A Compact Charging Case provides 14 hours of charge, having a 3.5 hours of battery life on its own with one charge so that you can listen to music during your entire workout, along with managing your calls and music on the go with touch controls. With the function of a hear through, meaning you can hear the world outside unless you want to be able to hear your calls and music then noise cancelling would work for you.
217345		Enjoy all-day audio with the WI-C400 Headphones from Sony. These wireless headphones utilize an around-the-neck design for comfortable, all-day wear. They feature 9mm drivers and utilize Bluetooth connectivity to stream high-quality digital audio from compatible devices. NFC technology is also onboard for easy, one-touch pairing.
217751		UA Sport Wireless Train are built for the gym. SuperVent ear cushions keep them cool and dry while Under Armour grip material provides a soft feel and maximum stability. UA Train headphones elevate every rep with big, wireless JBL Charged Sound and all-new Bionic Hearing with TalkThru Technology. With a simple touch of the UA logo, TalkThru Technology is enabled so you can talk to your training partner or coach without having to remove the headphones.
217962		Pure Bass Sound and active noise-cancelling for punchy bass and an immersive audio experience. The lightweightover-ear design offers maximum comfort and sound quality while ready to travel everywhere you go with its compact foldable competence. 15 hours of battery life which recharge in only 2 hours enables noise-free, wireless playback. Allowing connection with two Bluetooth devices simultaneously, the multipoint connection makes sure you won't miss a call on your phone while streaming videos on your tablet.
219307		JBL TUNE 750BTNC wireless headphones feature powerful JBL Pure Bass Sound and active noise-cancelling for punchy bass and an immersive audio experience. The lightweightover-ear design offers maximum comfort and sound quality while ready to travel everywhere you go with its compact foldable competence. 15 hours of battery life which recharge in only 2 hours enables noise-free, wireless playback.
219925		The Coleman C40WP Waterproof Camera is durable and rugged, and is perfect for shooting photos and High Definition videos. Capture images at 20MP resolution and record ultra-smooth FULL HD videos. Shock proof and freeze proof to -10
220284		JBL TUNE 750BTNC wireless headphones feature powerful JBL Pure Bass Sound and active noise-cancelling for punchy bass and an immersive audio experience. The lightweightover-ear design offers maximum comfort and sound quality while ready to travel everywhere you go with its compact foldable competence. 15 hours of battery life which recharge in only 2 hours enables noise-free, wireless playback.
220398		Compact size for on-the-go. 2.7 TFT color display. Convert recorded sounds into a QR code and add it to the photo. Scan the QR code with smartphone to play the sound. Features fun frames and filters to add using the pre-installed or on the app. Using the app control from a smartphone. Remote image capturing. Print around 100 photos on a single charge. Built-in memory - expandable with microSD or microSDHC card (NOT included). Uses instax mini film. Built-in Lithium-ion battery. Includes: 10-Pack of Instax mini film. Hand strap. USB cable.
220466		Own your space. Stay connected to your music and your world with JBL LIVE 300TWS in-ear headphones. True wireless and free from wires for ultimate freedom, with incredible JBL Signature Sound. Tune in or out with noise control, stay alert to your surroundings with Ambient Aware or use TalkThru to chat with friends, all without removing your headphones. Voice Assistant, hands-free stereo calling, volume and noise control are all accessible via the touch controls for extra convenience.
220543		UA True Wireless Streak is engineered to maximize performance while minimizing size anddistractions. A lightweight design with Sport Flex Fit ear tips provides optimized comfort andsecure fit tested by athletes. UA waterproof technology delivers element-battling protection,while JBL Charged Sound is boldly tuned with rich bass for motivation. Bionic Hearingfeatures TalkThru Technology to quickly interact with your workout partner, and Ambient AwareTechnology to hear your surroundings.
221976		5MP camera has a built-in printer that takes and prints in 50 seconds or less. Features a small selfie mirror for the perfect selfie. Includes a pack of 2 x 3 Premium ZINK Photo paper. This photo paper creates vivid prints and borderless photos. Zero Ink Printing (ZINK) - requires no ink cartridges ribbons or toner. MicroSD card slot allows for space to save photos (MicroSD NOT included up to 256GB). 1-Year limited manufacturer warranty. Includes: 10 Pack of ZINK photo paper. Micro USB cable. Wrist strap. Rechargeable battery.
222009		Stay immersed in the action with wireless, noise-reducing home theater headphones. High quality sound from large drivers and a range of 150 feet for optimal performance. Enjoy crystal-clear voices in your favorite shows and movies with Voice Mode and binge-watch uninterrupted with 20 hours of battery life in a comfortable, adjustable design.
222769		Listen to your music on your next adventure with these black Under Armour Flash X True Wireless In-Ear Sport Headphones from JBL. Engineered to withstand all types of weather, the Flash X headphones are IPX7-rated sweat and waterproof. The cable-free design lets you work out without anything to hold you back, and JBL's sport flex ear fins help to keep the Under Armour earbuds in place, even during vigorous exercise.
223262		Plattan 2 Bluetooth combines the iconic Plattan design with 30+ hours of wireless playtime for a truly liberating listening experience. The headphone offers crisp, full spectrum sound with up to 10 meters of listening range, and an intuitive control knob for simplified navigation.
223514		The Coleman C20WP Xtreme digital camera is an 18 Mega Pixel HD waterproof digital camera that is easy to use, sleek and compact. Capture images at 18MP resolution and record ultra-smooth HD videos at 30fps. Shock proof and freeze proof to -10
223963		Experience the convenience of instant printing with MINOLTA's instapix
224273		Designed for Olympus and Panasonic Micro 4/3 (MFT) mirror-less digital cameras, the Rokinon 7.5mm T3.8 UMC Cine Fisheye lens is small in size and big on performance. With a frame filling 180
224345		The Coleman C40WP Waterproof Camera is durable and rugged, and is perfect for shooting photos and High Definition videos. Capture images at 20MP resolution and record ultra-smooth FULL HD videos. Shock proof and freeze proof to -10
224523		Experience the fun of instant printing & digital technology features with the MINOLTA instapix
224693		Feel at one with your music and your world. With no wires holding you back enjoy your favorite music with JBL Pure Bass. The JBL TUNE 225TWS earbuds seamlessly connect you to your music and calls. Just open the case and start listening, as the JBL TUNE 225TWS earbuds immediately pair with your device, while Dual Connect lets you use either earbud, or both. Listen longer and in comfort, with up to 25 hours of battery life. Find the JBL TUNE 225TWS earbuds that fit your style, with different color options.
225715		MINOLTA's MNCD60 is a hi-performance 1080p full HD dash cam that features a 140