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 (
    29811, 29812, 29813, 29814, 29815, 29816, 
    29817, 29818, 29819, 29820, 29821, 
    29822, 29823, 29824, 29825, 29826
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00065

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 (29811,29812,29813,29814,29815,29816,29817,29818,29819,29820,29821,29822,29823,29824,29825,29826)) 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
29811 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Bluetooth 3.0 Wireless 2.4GHz Keyboard</span></li> <li><span class="a-list-item">Material: Aluminum alloy and laser ABS+PC</span></li> <li><span class="a-list-item">Operation distance: 10 meters</span></li> <li><span class="a-list-item">Working current: 10mA</span></li> </ul>
29812 <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">Category Type : Beds & Mats</span></li> <li><span class="a-list-item">It is a warm cradle for pets, embrace into it and sleep softly.</span></li> <li><span class="a-list-item">Lightweight to move, and you can put it outside to enjoy sunshine shower and absorb heat energy into bed.</span></li> <li><span class="a-list-item">Cute design, which can be a decorative bed at home;</span></li> <li><span class="a-list-item">Pet language: Winter is cold, but that is the main reason that I rely on you.</span></li> </ul>
29813 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Accessory Type : Cases & Covers</span></li> <li><span class="a-list-item">Screen Size : 10.5 Inch</span></li> <li><span class="a-list-item">Color Family : Brown</span></li> <li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Compatible with : Samsung Galaxy Tab S4</span></li> <li><span class="a-list-item">Color : Brown</span></li> </ul>
29814 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Orico</span></li> <li><span class="a-list-item">Compatible with : Hard Disk Drive</span></li> <li><span class="a-list-item">Internal Interface : SATA</span></li> <li><span class="a-list-item">Size : 3.5",2.5"</span></li> <li><span class="a-list-item">External Interface : USB</span></li> <li><span class="a-list-item">Supporting Hard Drive Capacity : 16TB</span></li> <li><span class="a-list-item">Support HDD : 2.5''/3.5'' SATA HDD/SSD</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">Product size : 142*110*57.5mm</span></li> <li><span class="a-list-item">Power Adapter : 12V3A /EU/US/UK/AU Type Power Adapter Available</span></li> <li><span class="a-list-item">Note : Not Including the Hard Drive</span></li> </ul></div> </div>
29815 <div>Product Description:</div> <div>Track your mileage or map easily when you keep your phone in the GUB bike phone holder. Designed for the phone size in 3.5 - 6.2 inches, this phone holder is perfect for GPS and other bike riding applications. Easily install with the out mount and you can enjoy music or chat with your friends when you are riding.</div> <div> </div> <div>Features: </div> <div>You are no longer worried about the phone will fall or loose while down or up the stairs in a row or on the hillside road</div> <div>This phone holder comes with buffer patch for effectively shock absorption and protecting the phone from directly accessing to the rim surface while anti-slip four talons are stably and firmly lock the phone in position</div> <div> </div> <div>Easy installation and wide phone size adjustable range</div> <div>It can be assembled on the handlebar and stem cover and it is suitable for phone width is from 50 to 100mm / 1.97 to 3.94 inches that fits for 3.5 - 6.2 inches phones</div> <div> </div> <div>Super durability with nice appearance</div> <div>Constructed of high strength aluminum alloy material, sturdy, tough, durable and practical to use</div> <div> </div> <div>Compatible with different transport tools such as bicycle, scooter, electrocar and motorcycle</div> <div>Adjustable bike holder stand ( diameter is 31.8mm / 1.25 inches ) with pad, suitable for different diameters of handlebar</div>
29816 <div>Features:</div><div>- Scientific ergonomic design encourages healthy neutral "handshake" wrist and arm positions for smoother movement and less overall strain.</div><div>- 800 / 1200 / 1600 DPI Resolution Optical Tracking Technology provides more sensitivity than standard optical mice for smooth and precise tracking on a wide range of surfaces.</div><div>- Added next/previous buttons provide convenience when webpage browsing; the superior choice for internet surfers, gamers and people who work at length at the computer.</div><div>- REDUCE TENSION - The Sharkk vertical ergonomic mouse is designed to allow for natural hand positioning and ultimate comfort. It eases tension on the wrist and hand for right-handed users.</div><div>- ADJUSTABLE DPI – The adjustable DPI allows you change the sensitivity of the mouse’s pointer speed (800 / 1200 / 1600). You can make it slower for things that require precision like color correcting and photo edits or make it faster for browsing.</div><div>- COMPATIBILITY – This comfortable ergonomic mouse is compatible with Mac OS X, Linux and all versions of Windows. This mouse features a plug & play nano receiver that you plug into the USB port of your laptop or computer for connectivity.</div><div>- 2.4 GHz & AUTO-SLEEP FUNCTION – The Sharkk vertical mouse has an auto-sleep function that conserves power and extends battery life. The integrated 2.4GHz RF wireless technology allows this mouse to work seamlessly for your computer or laptop.</div><div> <div>FEATURES </div> <div>– You can browse web pages faster with the added next/previous buttons located on the side of the mouse. There is also an auto-sleep feature that conserves power and extends product life</div> <div> </div> <div>Ergonomic Design</div> <div>The unique, upright and ergonomically superior design of the Wireless Vertical Mouse reduces harmful arm</div> <div>and wrist tension by allowing your hand to operate the mouse while remaining in its natural position.</div> <div> </div> <div>Auto-Sleep Feature</div> <div>Integrated time-sensing technology will automatically place your mouse in sleep mode if it is left idle for 8 seconds;</div> <div>thereby conserving energy, maximizing battery life and eliminating the need to constantly power on and power off your device.</div> <div> </div> <div>Extended OS Compatibility</div> <div>The Wireless Vertical Mouse has been designed work with an extended range of operating systems,</div> <div>including: Mac OS X, Linux and all versions of Windows.</div> <div>The intersection of class, comfort and functionality. A mouse for the 21st century.</div> <div> </div> <div>Comfortable and classy</div> <div>Tired of using the traditional grip Take a break from overly-clunky or uncomfortably tiny mice. The ergonomically-designed thumb rests and grips fit the contour of your palm for maximum comfort.</div> <div> </div> <div>Sleek and Sexy</div> <div>Turn heads with a futuristic design. Made for increased functionality and comfort, this mouse combines a handshake grip with easy-access buttons and three levels of mouse sensitivity (800 / 1200 / 1600DPI) for improved tracking.</div> <div> </div> <div>Easy-access use</div> <div>Five buttons give you improved control over your computer's systems. Whether dragging and dropping, selecting large volumes of data, or casually gaming, this mouse provides a low-cost, effective solution for multiple computing needs.</div> </div>
29817 <div>Product Description:</div> <div>.Weight: 40g</div> <div>.Size: 7.5 x 2 x 2.8 cm</div> <div>.ITU-T V.92 / V9.0</div> <div>.56Kbps Data Download Rates</div> <div>.48Kbps Data Transmit Rates</div> <div>.14.4Kbps Send / Receive, G3 Fax</div> <div>.Telephone Answering Machine</div> <div>.Plug n play , Easy installation</div> <div>.No power supply needed</div> <div>.Windows 98 SE / ME / 2000 / XP</div> <div>.Data mode</div> <div>Support ITU-T V.92 Standards with receive data rates up to 56Kbps and transmit data rates up to 48Kbps upload</div> <div>.Support ITU-T V9.2 Stan darts with receive data rates up to 56Kbps and transmit data rates up to 33.6Kbps.</div> <div>.Support ITU-T V.34 , V.32bis, V.32 , V.22bis , V.22 , V.23 and V.21 ; Bell 212A and bell 103 protocol standards, support ITU-T V.42 LAP-M and MNP 2-4 error correction.</div> <div>.Support V.44 , V.42bisand MNP5 data compression.</div> <div>.Fax Mode</div> <div>.Fax mode with send and receive rates up to 14.4Kbps.</div> <div>.Support ITU-TV.17 , V.29 , V.27terand V.21 channel 2 protocol standards.</div> <div>.Support EIA / TIA 578 Class 1 and T.31 class 1.0 commands</div> <div>.Tam mode</div> <div>.Support 8-bit U-Law/A-Law coding(G.711) and 8 / 16-bit linear coding.</div> <div>.Support 8KHz sampling rate</div> <div>.TAM mode support concurrent DTMF detect ring detect</div> <div> </div>
29818 <span>Features: Double Space Key Double space key perfect for left or right hand user, convenient to control, humanized design. Ergonomic Design Delicate appearance, large and soft palm rest ensures you long time using without feeling tired. Multimedia Keys Easy-access dedicated multimedia controls, it is convenient and easy to switch between gaming. Recessed Design Four special keys WASD with red cap for game, convenient to touch middle row, quickly position every button. One Key to Swap The function key and the arrow keys can be swapped only by a key. Mini Portable 47 key, portable design so you can carry everywhere anytime, great for one hand control. Specification: Brand: DELUX Model: T9 Key number: 47 Keystroke life: ≥10,000,000 Working temperature: 0~45 Working voltage: DC 5V Key operating force: 55±7g Keycaps pulling force: ≥0.8kg Operation system for Windows2000/XP/VISTA/7/8 Interface: USB 2.0 Item size: 224.73 * 170.79 * 35.67mm / 8.84 * 6.72 * 1.40in (L * W * H) Item weight: 500.3g / 1.10lb Package size: 28 * 23 * 8.4cm / 11.02 * 9.05 * 3.30in (L * W * H) Package weight: 600g / 1.32lb Package list: 1 * keyboard 1 * user manual(Chinese) Note: Two types of keyboard, random shipments.</span>
29819 <div>Product Description:</div> <div>.innovative designed Snorkeling Set Equipment,</div> <div> </div> <div>.offers a unique diving experience to users allowing them to shoot wonderful underwater scenes.</div> <div> </div> <div>.Specially designed mechanism closes the top of the snorkel when immersed in water.</div> <div> </div> <div>.Above Water the Snorkel opens automatically so air can enter the mask.</div> <div> </div> <div>.180° field of vision and shatterproof polycarbonate window for added safety.</div> <div> </div> <div>.Full Face Diving Mask Details:</div> <div> </div> <div>.Material:Liquid Silicone + PC</div> <div> </div> <div>.Full Face Design with Snorkel,Breath smoothly through your nose and mouth;</div> <div> </div> <div>.Spherical Lens,With 180 Degree wide Vision;</div> <div> </div> <div>.PC plastic Frame,Durable Construction,Anti Fog;</div> <div> </div> <div>.Food-Grade Liquid Silicone Snorkel,Safety for your scuba;</div> <div> </div> <div>.With Mount for Sport Camera(the price is excluding the camera). </div> <div> </div> <div>Package includes:</div> <div>1 x Diving Mask</div> <div>1 x Breathing Tube</div>
29820 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Toy Category : Trains & Accessories</span></li> <li><span class="a-list-item">Targeted Group : Unisex</span></li> <li><span class="a-list-item">Manufacturer Recommended Age : All Ages</span></li> <li><span class="a-list-item">Age : All Ages</span></li> <li><span class="a-list-item">Brand : Other</span></li> <li><span class="a-list-item">Fresh look offers modern restyling of classic toy trains with more exposed wood and updated designs.</span></li> <li><span class="a-list-item">Premium, high-quality construction.</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">Thomas can connect to other Wooden Railway engines and vehicles with magnet connectors.</span></li> <li><span class="a-list-item">Perfect for Thomas & Friends Wooden Railway train sets.</span><span class="a-list-item"></span></li> </ul></div> </div>
29821 <span>Product Description:.Output bright can come to Max 7500 Lm/Lumens.Waterproof,but don\'t put it into water directly.Extensive Lifetime of LED (100,000 hours).Mode Arrangement: Hi Mid Low Fast Strobe.Power Source:4 x 18650 battery pack.LED Type: XM-L T6.Switch Type: Reverse clicky.Reflector: Aluminum Smooth.Flashlight Mounting: handlebar.Beam Range: 250 meters.Material: Aluminum alloy.Best suited for: camping,fishing,hiking,map reading,night fishing,night flying,sailing,caving and huntingPackage include:1 Pcs XM-L 3XT6 LED Bicycle light 1 Pcs 4x18650 Battery Pack 1 Pcs Charger 2 Pcs Rubber Ring</span>
29822 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">EASY TO CLEAN- Removable and washable bed cushion mat,can be easily assembled or disassembled for machine wash or travel.</span></li> <li><span class="a-list-item">SELF-WARMING MATERIAL- Both inside and outside are high-quality fiber fabrics,warm and comfortable,radiates heat back to your pet.</span></li> <li><span class="a-list-item">DAMP RESISTANCE- Bottom made of anti-slip material make it safer and keep it onto place.</span></li> <li><span class="a-list-item">WEIGHT RANGE- Suitable for pets within 12KG.</span></li> <li><span class="a-list-item">The dog bed are made from premium quality material and workmanship.</span></li> </ul>
29823 <br /><span>Features:</span><br /><span>AP Non-toxic</span><br /><span>Alcohol-based ink dries acid-free</span><br /><span>Great fit for artists,hobbyist and crafters.</span><br /><span>The brush marker, Sketch, is the ideal tool for sketching and scribbling.</span><br /><span>The Sketch has two standard tips: Medium Broad and Super Brush.</span><br /><span>Body Color:Black</span><br /><span>Package Included:</span><br /><span>1x 60 colors Marker Pens set</span>
29824 <span>Sporting Good Category : ExerciseType : Stretching Belts</span>
29825 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Accessory Type : Cases & Covers</span></li> <li><span class="a-list-item">Screen Size : 11inch</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>
29826 <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">null : 0.1kg</span></li> <li><span class="a-list-item">Targeted Group : Unisex</span></li> <li><span class="a-list-item">Age : 6 Years</span></li> <li><span class="a-list-item">Outdoor Play Activities : Swimming Pools & Water Toys</span></li> <li><span class="a-list-item">Recommended Age : 12 Years & Above</span></li> </ul>