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 (
    29698, 29699, 29700, 29701, 29702, 29703, 
    29704, 29705, 29706, 29707, 29708, 
    29709, 29710, 29711, 29712, 29713
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00055

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 (29698,29699,29700,29701,29702,29703,29704,29705,29706,29707,29708,29709,29710,29711,29712,29713)) 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
29698 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Color : Blue</span></li> <li><span class="a-list-item">Package weight in KGs : 1Kg</span></li> <li><span class="a-list-item">Material : Polyester</span></li> <li><span class="a-list-item">Type : Accessories Boxes and Organizers</span></li> </ul>
29699 <span>Heart ;Photo Locket Necklace, Silver PlatedPendant ;Size: about 4*4cmChain ;Length is shown in the Note Section</span>
29700 <div>Features:</div> <div>-One-piece design for advanced slim notebook</div> <div>-18 degree angle ergonomic design for more confortable typing experience</div> <div>-Humanize opening and silicon design for easier cables manage and anti-skid</div> <div>-Special holding design for macbook</div> <div>-Suit for 11-15 inch notebook</div> <div> </div> <div>Specifications:</div> <div>。Type: Laptop Cooling Stand</div> <div>。Material: Aluminum alloy</div> <div>。Viewing angle: 18 degree</div> <div>。Size: 240x210x65mm</div> <div>。Color: Silver</div> <div>。Using:Suit for 11-17 inch Laptop</div>
29701 <div>Product Description:</div> <div>BM-800 Microphone:</div> <div>Large dynamic microphone element for warm, rich recordings</div> <div>Cardioid pick-up pattern minimizes background noise and isolates the main sound source</div> <div>Smooth, extended frequency response is excellent for singing, speech and instruments</div> <div>Overload-protection swith (-10dB) minimizes distortion from loud sound sources</div> <div>Bass-reduction switch reduces room noise</div> <div>Bright color will reflesh your life</div> <div> </div> <div>NB-35 Microphone Stand:</div> <div>Microphone Stand</div> <div>Professional microphone stand</div> <div>This robust adjustable microphone boom stand it is one of our best selling products and offers absolutely superb quality at a great price</div> <div>A sturdy tripod base & boom arm with telescopic adjustment</div> <div>This hugely popular stand favoured by bands, solo artists, schools, colleges and teachers.</div> <div>Ideal accommodation for most instrument & vocal microphone's</div> <div> </div> <div>Microphone:</div> <div>Microphone-Core: Dia.16mm</div> <div>Sensitivity: 45dB +- 1dB</div> <div>Polar Pattern: Uni-directional</div> <div>Frequency Range: 20Hz-20KHz</div> <div>Output Impedance: 1500 Ohm +- 30% (at 1KHz)</div> <div>Load Impedance: >= 1000 Ohm</div> <div>Equivalent Noise: 16dBA</div> <div>Electrical Current: 3uA</div> <div> </div> <div>Microphone Stand:</div> <div>Maximum Bearing Weight: 2KG</div> <div> </div>
29702 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Fashion appearance,mini compact, very suitable for portable,put on the desk</span></li> <li><span class="a-list-item">Dual blade design,Quiet, large wind</span></li> <li><span class="a-list-item">USB powered,you can use the Phone charger plug, computer or laptop USB, portable source to powered by</span></li> <li><span class="a-list-item">USB Power Plug,two stalls</span></li> <li><span class="a-list-item">Material: high-grade ABS</span></li> <li><span class="a-list-item">Body size :130 x 100mm</span></li> <li><span class="a-list-item">Fan diameter : 96mm</span></li> </ul><div class="a-row a-expander-container a-expander-inline-container"> <div class="a-expander-content a-expander-extend-content a-expander-content-expanded"> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Power supply :DC5V</span></li> <li><span class="a-list-item">Power consumption :1.2W</span></li> <li><span class="a-list-item">Wire length :1.1mize</span></li> </ul></div> </div>
29703 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Type : Toilet Seat Covers</span></li> <li><span class="a-list-item">Material : Fiber</span></li> <li><span class="a-list-item">Color : Grey</span></li> </ul>
29704 <div>Built-in Apple Pencil Holder </div> <div>Holds the pencil in place tightly to avoid losing; Two holes behind the holder allow you to push your pencil out easily</div> <div> </div> <div>Magnetic Closure  </div> <div>Performs the auto sleep/wake function flawlessly for power reduction; Please open "Auto-Lock" setting before using</div> <div> </div> <div>Tri-fold Stand </div> <div>Keeps flip capability to transform it into a viewing stand and on-screen stand for FaceTime, reading, watching video, typing and drawing(NOT for portrait mode)</div> <div> </div> <div>Precise Cutout </div> <div>Designed specially for iPad 9.7 released in 2018(A1893/A1954),access to all buttons and ports aligned perfectly, including camera, speakers, lightning port, earphone jack, microphone</div> <div> </div> <div>Sturdy yet Portable  </div> <div>Lightweight enough to carry on the go, soft TPU material like rubber acts as an armor to protect your beloved device fully, not slippery or stick</div>
29705 <div>Product Description:</div> <div>-LED light and audio result indication.</div> <div>-The red light will be showed and the audio indicator will sound “beep” if the stone is real diamond.</div> <div>-Simple calibration for stones of various sizes.</div> <div>-Accurate and reliable reading.</div> <div>-Matched with a testing platform for loose stones.</div> <div>-Light weight, matched with a convenient carrying case.</div> <div>-Detailed user manual is included in the package.</div> <div> </div> <div>Specifications:</div> <div>。Power supply: 1 * DC006P 9V Battery</div> <div>。Item size: 16 * 4 * 2cm (6.6 * 1.6 * 0.8in)</div> <div>。Item weight: 62g / 2.2oz</div>
29706 <span>Length: 20 cmWeight: 50 gColor: Multi-colorTarget Throng: WomenPlating: Double-Layers Plating 925 Silver ;Material: Copper Alloy Colored Beads RhinestoresMatches well with your clothesGreat for gifting purposeGreat for casual and daily wear</span>
29707 <div>Description:  </div> <div>Premium composition leather exterior and soft interior offer great protection against daily use; </div> <div>Multiple slots able to set up multiple horizontal stand angles</div> <div>Support auto Sleep/Wake function; Full access to all features (Cameras, Speaker, Ports and Buttons)</div> <div>Built-in stylus pen holder</div> <div> </div>
29708 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Species : Cats & Dogs</span></li> <li><span class="a-list-item">Type : Grooming Supplies</span></li> <li><span class="a-list-item">Sub Type : Nail ClippersThis item is the revolutionary nail trimmer for your dog or cat Perfectly Groomed, No Pain! It's the newest and fastest way to keep your pet's nails trim rounded and smooth with no mess</span></li> <li><span class="a-list-item">Now you can painlessly and easily trim your pet's nails anywhere without the pain caused by traditional nail clippers With On/Off switch, easy to use</span></li> </ul>
29709 <p>Magic Cube Kindle Paperwhite 1/2/3 Case 6'' Ereader Leather Case For Kindle Paperwhite Cover </p>
29710 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Color : Blue</span></li> <li><span class="a-list-item">Screen Size : 10.5 Inch</span></li> <li><span class="a-list-item">Compatible with : Samsung Galaxy Tab S4</span></li> <li><span class="a-list-item">Accessory Type : Cases & Covers</span></li> <li><span class="a-list-item">Color Family : Blue</span></li> <li><span class="a-list-item">Are batteries needed to power the product or is this product a battery : No</span></li> <li><span class="a-list-item">Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</span><span class="a-list-item"></span></li> </ul>
29711 <span>Product Description:.Connect up to 3 devices simultaneously.Supports with the beat-per-view feature.SD browse file formats supported:- Photo: JPG, PNG, BMP- Video: MP4, AVI, MOV- Music: MP3, WAV.WiFi/SD settings: WiFi password, AP Mode and Station Mode switch, IP, channels, number or users, SSID.WIFI/SD Default Password: 99999999.WIFI/SD Apps Default Username: admin.WIFI/SD Apps Default Password: admin.Support with both Apple IOS and Android devices.Capacity: based on your micro SDHC/micro SDXC card (Max 32GB).Size: 3.1 x 2.3 cm.Note: WiFi adapter ONLY, micro SDHC / TF card not included Package List:1 x Micro SDHC / TF Card To SD Card WiFi Adapter</span>
29712 <div>Product Description:</div> <div>.Shockproof Impact Rugged Hybrid Protective Case</div> <div>.with Belt Clip Holster Armor Case</div> <div>.Feature: Hard Kickstand Cover + Inside Rubber Soft Case + Belt Clip Holster</div> <div>.Material: Plastic PC + Silicone TPU</div> <div>.Protec your Phone from Scratches Bumps & Shock</div> <div>.Compatible with:</div> <div>Samsung Galaxy TAB A T580N/T585N</div> <div> </div> <div>Package List: </div> <div>1 x Case</div> <div> </div>
29713 <div>Product Description:</div> <div>-Portable finger trackball mouse -with off-table design for free and comfortable operation. It is ideal for laptop users.</div> <div>-It can greatly ease the harm of palm joint or muscle for long time using mouse</div> <div>-Avoid sitting closely to the monitor and reduce the harm of radiation and eye fatigue</div> <div>-Dolphin shape design with left/right clickers fit left and right handed users.</div> <div>-Plug and play, no software required</div> <div>-2.4GHz Wireless connectivity with working distance within 32ft (10m)</div> <div> </div> <div>Specifications:</div> <div>.Power: With One AAA battery (not included)</div> <div>.Compatible with: for Windows 98 2000 XP VISTA wins 7 Linux UNIX for<span> </span><span>Mac</span><span> </span>OS, ect..</div> <div>.Resolution: 1000dpi</div> <div>.Color: Black</div> <div>.Size: 11*6*5cm/4.3*2.3*1.9inch</div> <div>.Wireless receiving distance: About 15M</div> <div> </div> <div>How to Use:</div> <div>. Put your index or middle finger into the hole of this mouse.</div> <div>. Control the track ball for moving cursor and press the right and left button with your thumb</div> <div>. When using "Drag and Go" function, press the button in the hole of the mouse that has the same function as the left button of the common mouse</div> <div>. Use the left button to lock the screen and then you can control the track ball to roll your screen freely</div>