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 (
    29714, 29715, 29716, 29717, 29718, 29719, 
    29720, 29721, 29722, 29723, 29724, 
    29725, 29726, 29727, 29728, 29729
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00086

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 (29714,29715,29716,29717,29718,29719,29720,29721,29722,29723,29724,29725,29726,29727,29728,29729)) 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
29714 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Manufacturer Number : 1</span></li> <li><span class="a-list-item">Accessory Type : Cases & Covers</span></li> <li><span class="a-list-item">Screen Size : 11 Inch</span></li> <li><span class="a-list-item">Color Family : Black</span></li> <li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Compatible with : Apple iPad Pro</span></li> </ul>
29715 <div>Item type: Accessories</div> <div>Applicable for: Tello WiFi FPV Quadcopter Drone</div> <div>Battery Weight:25g</div> <div>Battery Size:16*10*9mm</div> <div>Charging Time: about 45 minutes</div> <div>Charger Input:5V2A</div> <div>Charger Output:4.35V1A*2</div> <div>Charger Weight:26g</div> <div>Charger Size:180*23*11mm</div> <div> </div> <div>Features:</div> <div>--Safe and long-lasting</div> <div>--Easy to install</div> <div> </div> <div>Package include</div> <div>​1 * charger</div>
29716 <div>Product Description:</div> <div>. Dual : Mini USB 2 slots charger can simultaneously charge up to 2 batteries.</div> <div>. Charging Time: fully charge 2 battery at a time within a couple hours(usually takes around 3 hours).</div> <div>. Coper Plugs: made with premium copper to ensure high performance and stability</div> <div>. Strong compability: works with SHOOT battery pack and Original GoPro Hero 5 battery pack</div> <div>. SHOOT Double Channel charger can be powered by wall charger adapter, power bank, or your PC, Laptop, etc.</div> <div>. Micro interface and Type C interface: enables you to power the 3-channel charger with provided Micro USB cable or Type-C Cable</div> <div>. LED Charger Indicators:</div> <div>Design: 2 LED lights corresponding to 2 slots individually.</div> <div> </div> <div>Illustration:</div> <div>Indicate RED color when the battery is charging; </div> <div>Indicate GREEN color when charging is complete. </div> <div>Compatible With Battery Models: GoPro AHDBT-501 </div> <div>Compatible With Digital Models: GoPro HD Hero 5 Black</div> <div> </div> <div>Feature</div> <div>-1 AMP per port for a quick charging solution</div> <div>-Dual USB port quickly charges up to two cameras at a time (around 1.5 hours for an 80% charge, 2 hours for 100% full charging)</div> <div>-Simultaneously record video or photos while charging</div> <div>-Works with most devices that charge via USB, such as call phone, mini speaker, etc.</div> <div> </div> <div>Package Include</div> <div>1 x SHOOT 2-channel Charger</div> <div>2 x Battery Packs </div> <div>1 x USB Charging Cable(Micro)</div>
29717 <ul class="generatedBullets"><li>Brand : Other</li> <li>Type : Wall Decals</li> <li><span style="font-family:Arial, Verdana;"><span>Theme : </span><span>Food & Beverage </span></span></li> <li>Material : Paper</li> <li>Installation Type : Self-Adhesive</li> <li>Height : 50 cm</li> <li>Width : 35 cm</li> </ul>
29718 <div class="a-section a-spacing-extra-large"> <div class="feature"> <div class="a-row feature"> <div class="a-section a-spacing-small"> <p>Product Description: -Automatically wakes or puts your device to sleep when the lid is opened or closed -Folding front cover -Easily converts into typing and landscape modes -Perfect for video-chatting and movie-watching -Transparent Back Case adds minimal bulk while protecting your precious device -No bezels around the screen allowing for unobstructed gesture swipes -Made with premium PU leather and no-scratch microfiber interior -Ultra slim,lightweight,easy access to all ports and controls -Specifically made for Samsung Galaxy Tab S3 9.7 Package include: 1 x case</p> </div> </div> </div> </div> <div class="feature"> </div> <div> </div> <div> </div> <div class="celwidget"> <div> </div> <div> <div class="celwidget"> <div class="askInlineWidget"> </div> </div> </div> </div>
29719 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Accessory Type : Security Locks</span></li> <li><span class="a-list-item">Compatible with : PC & Laptop</span></li> <li><span class="a-list-item">Brand : Other</span></li> </ul>
29720 <span>Use this inspection camera to access place inaccessible or not viewable by the naked eye. Adjustable lights improve visibility in low-light environment and allow you to work better. Borescopes works with Android 4.0 or above system phone, does not support IOS system. Your Android Phone must support OTG function, and must support to connect external camera.Super Hi-Vision 1.3 Million Pixels CMOS cameraThe flexible camera is waterproof with 7mm diameter so that you can inspect area under water, gaps and holes.5M cable length. With accessories of mirror, small hook and Magnet tools.</span>
29721 <div>Double arm Laptop holder + Double arm Tablet PC holder</div> <div>Model No.: OA- 9X</div> <div>Material: Aluminum Alloy + ABS plastic</div> <div>Suitable for all  Laptop10-15 inch , for all Tablet PC 7-10 inch.</div> <div><span>Max</span><span> </span>Bear weight: 7KG</div> <div>Net Weight: 3.1KG</div> <div>Install range: Desk thickness within 42mm.</div> <div>Installation ways: desktop clamping or grommet mounting</div>
29722 <span>Specification: Microphone--- Polar Pattern: Uni-directional Frequency Response: 20Hz-20kHz Sensitivity: 45dB±1dB Output Impedance: 1500α30%(at 1kHz) Load Impedance: ‰1000 Î Equivalent Noise Level: 16dBA Electrical Current: 3mA Microphone Output Interface: 3.5mm (0.14 Inch) Usage Voltage: 48V phantom power supply Wire: 3.5 inserted audio interface, 3 meters long Microphone Body Weight: 0.51lb Size: Approx. 16 x 5 x 5cm (6.3 x 1.97 x 1.97inch) Microphone Material: Steel net + Zinc alloy hand holding part Pop Filter--- External Diameter: 155mm(6.10inch) Function: Reduce P-pops in recording Double-layer Net Diameter: 130mm(5.12inch) Tube Length: 375mm(14.76inch) Tube Diameter: 8mm(0.31inch) Mounting Clamp: Up to 35mm(1.38inch)(Clamp adjustable) Flexible Holder: 360 degree swivel mount Stand--- Material: Steel Arm Stand Weight: 850g(1.87lb) Each Arm: 36cm(14.1inch) Arm Stand Support: Up to 2kg(4.41lb) Double-braced Arms: Add strength Features: Stable, tough, and affordable Steel Construction: 9x9mm(0.35x0.35inch) cross-section Mount Base: Installed onto the desk up to 55mm(2.17inch) thickness Mount on: announcers' desk with the metal mounting base XLR Male to Female Microphone Cable: Pre-installed hidden inside the boom arm tubing Package Included: 1x Black Microphone 1x Shock Mount 1x Power Cord 1x Anti-wind Foam Cap 1x Microphone Pop Filter Wind Screen 1x Arm Stand Body 1x Clip 1x Mounting Base 1x Screw Nut 1x XLR Male to XLR Female Cable 1x User Manual</span>
29723 B07MX33DVL <div>Material:Aluminum Alloy + ABS</div> <div>Arm Quantity:2Pcs Long Arm</div> <div>Arm Length:420mm</div> <div>Monitor Height Adjustable Range:30-400mm</div> <div>Laptop Height Adjustable Range:30-100mm</div> <div>Arm 360 degree Rotation:Yes</div> <div>Monitor 360 degree Rotation:Yes</div> <div>Monitor Viewing angle:angle of depression 80 degree, </div> <div>angle of elevation 90 degree</div> <div>Laptop Viewing angle:Horizontal 360 degree rotation, </div> <div>Vertical 25 degree rotation</div> <div>Weight:3.8KG</div> <div>Bearing limits:Max 7KG</div> <div>Monitor Requirement:VESA standard (75x75mm or 100x100mm)</div> <div>Desk Thickness Requirement:0-75mm</div> <div>Suit for:Monitor within 27 inch,</div> <div>10-15.6 inch Laptop</div>
29724 Ninebot By Segway Es2 Kick Scooter 8-Inch Front And 7.5-Inch Back Tires, Up To 15.5 Mile Range, 15.5Mph Top Speed, Cruise Control, Mobile App Connectivity - International Version Black
29725 <span style="font-size:10pt;">Features:</span><br /><span style="font-size:10pt;">Sponge saddle cover to absorb shock and soften your ride, best choice for long-distance riding by mountain bike.</span><br /><span style="font-size:10pt;">Durable and comfortable, concave design.</span><br /><span style="font-size:10pt;">Made of soft silicone, skidproof and wear-resistant.</span><br /><span style="font-size:10pt;">The dots in the lining to ensure no slip.</span><br /><span style="font-size:10pt;">With adjustable drawstring, easy to use, just put it over your existing seat.</span><br /><br /><span style="font-size:10pt;">Specifications:</span><br /><span style="font-size:10pt;">Brand: JSZ</span><br /><span style="font-size:10pt;">Color: Black</span><br /><span style="font-size:10pt;">Material: Sponge</span><br /><span style="font-size:10pt;">Size: Approx. 26.5*19*3.5cm / 10.4*7.5*1.4in</span><br /><span style="font-size:10pt;">Weight: 163g / 5.7oz</span><br /><br /><span style="font-size:10pt;">Package List:</span><br /><span style="font-size:10pt;">1 * Saddle Cover</span>
29726 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : 3M</span></li> <li><span class="a-list-item">Type : 3D Screen Protectors</span></li> <li><span class="a-list-item">Compatible with : Smart Watch</span></li> <li><span class="a-list-item">Supported Screen Size : 3.1 - 3.5 Inch</span></li> </ul>
29727 <div>Product Description:</div> <div>Stand height adjustable from 80cm-180cm</div> <div>Sturdy and stable designed stand</div> <div>Heavy duty construction and durable material</div> <div>Adjustable legs for placing on uneven surfaces</div> <div>Free microphone mount</div> <div>Heavy duty leg tips</div> <div>Easy to adjust height clutches</div> <div>Weight: 1.3kg</div>
29728 <div>Product Description:</div> <div>-Compact, comfortable to use and easy to carry</div> <div>-Help you to handle with numbers more professional and efficiently wherever and whenever</div> <div>-Keyboard comes with 18 keys of 0-9 number keys, Del, Enter, Num Lock, Backspace, + - * /</div> <div>-Simple plug and play, no driver installation requirements</div> <div>-Wireless transmission, fast and sensitive, up to 10-meter working range</div> <div>-Best for Notebook users who always work with number keys / mini digital keyboard</div> <div>-"Num Lock" key, switch to the number(0-9) function and other functions.</div> <div> </div> <div>Specification:</div> <div>.Item Name: Wireless Numeric Keypad</div> <div>.Number of Keys: 18Keys</div> <div>.Interface: Wireless 2.4G</div> <div>.Voltage: DC 1.5V</div> <div>.Color: Black</div> <div>.Case Material: ABS</div> <div>.Dimension: 14*8.5x2 cm</div> <div>.Keycaps Life: More than 10 million times</div> <div>.Operation Range: 10M (Without signal disturbance and no direction limit)</div> <div>.Power: 1*AAA Battery (Not Included)</div> <div>.System Support: Windows XP/7/8/Vista, Linux, Mac os 9 etc.</div>
29729 <div>Features:</div> <div>-Paint Roller for painting wall, door, floor and other large surface.</div> <div>-Flocked Edger for painting door frames, window sills or other narrow surface.</div> <div>-Corner Cutter Painter for painting corners or edges.</div> <div>-Available for both indoor and outdoor.</div> <div>-Save the time, Skip the mess, Less wastage and Have fun painting.</div> <div>-Provide a perfect solution for the home decoration and furniture renovation.</div> <div> </div> <div>Description:</div> <div>.No wasting time bending down often to reload the roller.</div> <div>.Just pour in, snap on the lid and Paint.</div> <div>.After using, clean it, dry it and keep it for the next time.</div> <div>.Painting filling and clean-up are quick and easy.</div>