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 (
    10030, 10031, 10032, 10033, 10034, 10035, 
    10036, 10037, 10038, 10041, 10042, 
    10043, 10045, 10046, 10048, 10049
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00057

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 (10030,10031,10032,10033,10034,10035,10036,10037,10038,10041,10042,10043,10045,10046,10048,10049)) 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
10030 <ul class="generatedBullets"><li>Model Number : A1619</li> <li>Brand : Xiaomi</li> <li>RAM Size : 512 MB</li> <li>With Camera : No</li> <li>SIM card support : No</li> <li>Operating System : Android</li> <li>Compatible Operating Systems : Android & iOS</li> <li>Color : Black</li> <li>Band Material : Silicone</li> </ul><div> <div class="container"> <div class="tab-details"> <p class="longDesc">Amazfit Stratos. Display diagonal: 3.4 cm (1.34"), Display type: LCD, Display resolution: 320 x 300 pixels, Touchscreen, Processor frequency: 1200 MHz. RAM capacity: 512 MB, Flash memory: 4 GB. Wi-Fi. GPS (satellite). Battery life: 120 h. Weight: 70 g. Housing material: Carbon fiber,Ceramic, Housing colour: Black, Band material: Silicone, Band colour: Black</p> <p> </p> <p class="longDesc">it is a watch for athletes is not like the other clocks, this timepiece style and design is very elegant with its glass finishes 2.5 D Has a shape of a sphere made of steel 316L that makes it resistant to shock and to Corrosion by water. Finally its silicone strap will wrap your wrist in the most comfortable way for you to carry it without discomfort.<span> </span><br /><br /><strong>Your personal trainer</strong><br />But the most important thing of this watch, going inside. Xiaomi Amazfit Pace 2 detected the sport that we are practicing, such as running, climbing, hiking... up to 11 different sports. With this wearable from Xiaomi you can control your daily activity, monitor the quality of sleep, count calories, monitor your heart rate, steps, or simply set the alarm. As a novelty compared to previous models of Amazfit, this Pace 2 in addition to controlling the heart rate, calculates recovery time of your body. You'll be able to always be located thanks to your GPS function and a battery of 200mAh to not have to load it up in 5 days. Amazfit Pace 2 will be always connected to your smartphone so you can receive notifications from your mobile phone without having to be forced to take over.<span> </span><br /><br /><strong>Get all the data you need</strong><br />Amazfit account with connection WiFi 802.11 b/g and Bluetooth 4.0 you can synchronize it with your smartphone to accompany you in your day-to-day and to facilitate your daily life.<span> </span><br /><br />You'll have all the data registered in the clock monitored on your smartphone in real time, through the application Amazfit Watch 2.0 (compatible with Android and iOs). You will be more comfortable to consult and in addition you'll be able to lead the progression of your routine to go to fulfill goals and keep improving.<span> </span><br /><br />It is water resistant up to 5 ATM and although we do not recommend submerging it, you'll be able to leave a day of rain with him to the street that he will not be in danger. On your screen Amazfit Pace 2 has a size of 1.34 inches with a resolution of 320 x 300 pixels, to view all the information in a perfect quality.<br /><br />You'll be able to get out to do sport and you'll stay connected to your phone through this smart watch from Xiaomi. You can also listen to music while you go jogging or on your long walks in the mountain, with a space of 4GB of internal storage. Connect a headset via the bluetooth. Leave your cell phone at home and forget to bring the cords in the middle.<br /><br />- Ceramic bezel<br />- 50m water resistant<br />- Triathlon / Assessment of maximum oxygen uptake<br />- 5 days of battery<br />- Music player with Bluetooth</p> <p> </p> </div> </div> </div> <div> <div class="container"> </div> </div>
10031 <ul class="generatedBullets"><li>Model Number : Stratos</li> <li>External Product ID : 851572007924</li> <li>Brand : Xiaomi</li> <li>External Product ID Type : EAN-13</li> <li>With Camera : No </li> <li>RAM Size : 512 MB</li> <li>SIM card support : No</li> <li>Operating System : Multi</li> <li>Compatible Operating Systems : Android & iOS </li> </ul><div> <div>Amazfit Stratos is the ultimate smartwatch for today's serious athlete. The latest smartwatch in Amazfit's lineup of fitness wearables, the Stratos combines advanced performance tracking technologies and smart convenience features in a sleek, sophisticated design</div> <div> </div> <div>On the trail, in the gym, or even in the pool, the Stratos can help you take your game to the next level with GPS + GLONASS route tracking and special sports modes for running, walking, cycling, swimming, elliptical machine, mountaineering, trail running, triathlon, skiing, tennis and soccer</div> <div> </div> <div>Track every aspect of your daily fitness - steps taken, distance traveled, calories burned, heart rate, and sleep quality - and optimize your performance with advanced VO2max metrics and exercise load (TD) and recovery time recommendations.</div> <div> </div> <div>The Stratos is the perfect companion to keep you organized and productive all day long. Receive notifications for emails, SMS, phone calls, Facebook, Twitter, WhatsApp, LinkedIn, Snap, Slack, weather forecasts, and other apps from your mobile phone. Then rock out to your favorite workout tunes with the onboard music player.</div> <div> </div> <div>Highlights:</div> <div>Perfect Personal Health Tracker: Sleeping Monitor, Heart Rate Monitor</div> <div>Ultra-long Battery Life: it consumes less power and can generally standby for 5 days</div> <div>512MB RAM 4GB ROM: provides room to store pictures, videos, music and more</div> <div>Xiaomi Chip features low consumption detailed with high performance, flexible and quickly</div> <div>Data Synchronism: download APP named ""Amazfit Watch 2.0"" to save and sync the data to achieve your healthy goal</div> <div>Lift or turn over your hands, light up the screen</div> <div>Support firmware upgrade</div> <div> </div> <div>Specifications:</div> <div>Brand: Xiaomi</div> <div>Bluetooth Version: Bluetooth 4.2 </div> <div>RAM: 512MB </div> <div>ROM: 4GB </div> <div>Waterproof: Yes</div> <div>Alert type: Vibration </div> <div>Bluetooth calling: Caller's name display, Phone call reminder </div> <div>Groups of alarm: 3 </div> <div>Health tracker: Heart rate monitor, Sleep monitor </div> <div>Locking screen: 1 </div> <div>Messaging: Message reminder </div> <div>Notification: Yes </div> <div>Other Function: Alarm, Bluetooth, Calendar, Waterproof </div> <div>Notification type: Facebook, G-mail, Line, Skype, Twitter, Wechat, WhatsApp</div> <div>Screen: OLED </div> <div>Operating mode: Press button</div> <div>Battery Capacity: 280mAh </div> <div>Charging Time: About 2hours </div> <div>Standby time: 5 days </div> <div>Type of battery: Polymer Li-ion Battery</div> <div>Band material: Silicone </div> <div>Case material: Stainless Steel </div> <div>Shape of the dial: Round</div> <div>Compatibility: Android 4.4 / iOS 9.0 and above systems </div> <div>Compatible OS: Android, IOS</div> <div> </div> <div>Package Includes:</div> <div>1x Xiaomi Stratos Smart Watch</div> <div>1x Charging Cable</div> <div>1x User Manual</div> </div>
10032 <span>Connect to a world of content and entertainment at home with Mi Box S. Running on the latest Android TV 8.1 is easy to use, supports voice controls and your favorite apps such as Netflix, VUDU, YouTube, SlingTV and more! Experience stunning 4K HDR visuals and DOLBY DTS for an immersive experience. Catch your favorite TV shows, play games, watch the news or listen to the radio. Mi Box also recommends videos based on your personal YouTube and Google Play preferences. Vudu credit will be emailed separately post purchase.</span><br /><br /><strong>Powered by Android 8.1 for Superior Functionality</strong><br /><span>Enjoy the latest Version of Android TV 8.1, perfect for home entertainment, home theater, business use, and more</span><br /><br /><strong>Access Tons of Content</strong><br /><span>Access to 3000+ channels and Apps, Enjoy movies and TV episodes from Netflix, VUDU, YouTube, and more</span><sup>*</sup><br /><br /><strong>High Clarity 4K HDR</strong><br /><span>Supports 4K Ultra HD resolution and High Dynamic Range (HDR), experience clarity and smoothness like never before</span><br /><br /><strong>Voice Control that Does It All</strong><br /><span>Built-In Google Assistant and in Apps voice search. Search for photos, check the weather, set an alarm. Life should be simple.</span><br /><br /><strong>High Performance Storage Capacity</strong><br /><span>Powerful Quad-core CPU, 3+2-core GPU, provides fast and stable rendering to enjoy a high quality video experience</span><br /><br /><strong>A powerful little helper</strong><br /><span>Get hands-free help in any room with Google Home Mini. It's powered by the Google Assistant. You can ask it questions. Tell it to do things. Its your own personal Google.</span><br /><br /><strong>Get answers from Google</strong><br /><span>Use your voice to quickly find information about the weather, news, sports and more. "Hey Google, will I need an umbrella today?</span><br /><br /><strong>Specifications:</strong><br /><span>Operating System: 4K HDR Android TV 8.1 Oreo</span><br /><span>Streaming Services: Netflix, Vudu, Youtube, Sling TV</span><sup>*</sup><br /><span>Connector Type : HDMI 2.0a x 1, Audio out x 1, USB 2.0 x 1, Power Interface x 1</span><br /><span>Dimensions (L x W x H): 3.75 x 0.66 x 3.75 Inches</span>
10033 <p><span>Xiaomi smartwatch has a responsive touchscreen. This Xiaomi Amaxfit has a lightweight construction.The Xiaomi Amazfit Bip Smartwatch Youth Edition is the perfect companion for your fitness journey. It is packed with class-leading features that motivate you to push to your limits. This Xiaomi smartwatch has a long standby time of up to 45 days. It has a built-in Sony 28nm low-power GPS chip that precisely records your daily movement, pace, altitude, stride frequency, and other professional sports data. This watch helps you analyze and improve your performance levels. Furthermore, the built-in PPG heart rate sensor tracks your real-time heart rate to make your exercise more effective. Available in an obsidian black finish, the Xiaomi Amaxfit has a smart and sophisticated look that suits well with most of the casual clothes.</span></p> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">PPG heart rate sensor</span></li> <li><span class="a-list-item">GPS + GLONASS dual-mode positioning</span></li> <li><span class="a-list-item">Life 45 days</span></li> <li><span class="a-list-item">Notify you via vibration whenever your phone receives a call or message</span></li> <li><span class="a-list-item">1.28inch capacitive touchscreen</span></li> </ul>
10034 <p class="longDesc">Xiaomi Mi Electric Scooter. Type: Stunt scooter, Maximum speed: 25 km/h, Maximum load weight: 100 kg. Battery capacity: 12800 mAh, Battery voltage: 42 V, Charging time: 9 h. Width: 430 mm, Depth: 1130 mm, Height: 1180 mm</p> <p> </p> <p class="longDesc">There's nothing like rising early in the morning and going out to meet the sunlight and fresh air, seeing all the people and the scenery. It doesn't matter where you're coming from or where you're going. All that matters is simple, pure joy.<br /><br /><strong>See it all at a glance</strong><br />Important information is all displayed at once and clearly visible, from Bluetooth to repair warnings.<br /><br /><strong>One button, many uses</strong><br />Tap the button to turn the scooter on and hold it for three seconds to turn it off. While the scooter is on, tap once to turn the light on/off, or tap twice to switch between speed modes.<br /><br /><strong>3 speed modes</strong><br />Easily switch between ECO mode, Standard mode (D) and Sports mode (S) by double pressing the power button.<br /><br /><strong>Power and speed on display</strong><br />Remaining power and current speed are displayed in real time, reminding you when to charge and to ride safely.<br /><br /><strong>The only way to strive freely</strong><br />is to strive forward with a dream in your pocket and a song on your lips and a faithful partner under your feet.<br /><br /><strong>45km long-range battery<br />Take the journey further</strong><br />With the highly safe 18650 power lithium battery, 474Wh capacity, large power supply and efficient acceleration, the<br />scooter can take you up to 45km on a single charge. The smart power management system offers six different protective<br />measures, and you can easily check the health of the battery via the mobile app.<br /><br /><strong>Recovers and regenerates energy<br />For even longer lasting charge</strong><br />In order to extend battery life, the scooter converts and stores kinetic energy during acceleration into electrical power. It's also fitted with a regenerative braking system for addition power. This enhances the emergency braking system and improves the battery life at the same time.<br /><br /><strong>Simple yet sleek design<br />Hit the road with style</strong><br />Classic black geometrically studded with red, the simple dual color design brings a subtle but sleek look to the scooter. Whether on the road or parked outside of work, the scooter offers a pleasant visual experience.<br /><br /><strong>3 second fast folding<br />Take it along on your travels</strong><br />Simply flip, fold and clip to complete the fold and fit easily in the trunk.<br />Weighing just 14.2kg thanks to the aerospace grade aluminum body, it's easy to carry too.<br /><br /><strong>Turn your smartphone into your dashboard</strong><br />Simply pair with the scooter via Bluetooth and use the app to power on, update the firmware, view mileage, remaining power and current speed, or to enable cruise control<span> </span><sup>[4]</sup><span> </span>to save energy and give your wrist a break.</p>
10035 <ul class="a-unordered-list a-vertical"><li><span class="a-list-item">Type: Over Ear</span></li> <li><span class="a-list-item">Connectivity: Wired</span></li> <li><span class="a-list-item">Compatible With: Mobile Phones</span></li> <li><span class="a-list-item">Mic: Yes</span></li> <li><span class="a-list-item">Function: Answering Phone,Previou Track, Next Track, Play and Pause</span></li> <li><span class="a-list-item">Noise Isolation: Yes</span></li> </ul>
10036 <ul><li><span>With Digital Noise Reduction Control Box, Integrates the Digital Noise Cancellation System and Digital Music System Ensures the Noise Cancellation Performance</span></li> <li><span>USB Type-C Plug, Directly Powered by Cellphones, Convenient and Lightweight</span></li> <li><span>50 - 2000Hz Broadband Active Noise Cancellation</span></li> <li><span>Microelectromechanical Mic, Effectively Collect and Detect Noise</span></li> <li><span>Dynamic and Balanced Armature Structure, Provide High-Quality and Detailed Music</span></li> <li><span>Titanium Plating Metal Case, High Hardness and Durable</span></li> <li><span>With On-Cord Control for Music and Calls Control</span></li> <li><span>Ergonomics Design, Comfortable to Wear</span></li> </ul>
10037 Xiaomi Mi Bluetooth Speaker Is Compatible With All Touchscreen Tablets. Buy This Bluetooth Speaker From .Play Your Favorite Music Or Receive Calls Instantly With The Xiaomi Mi Bluetooth Speaker. This Stylish And Compact Device Is Extremely Portable And Fits Comfortably In Your Bag Or Pockets. As A Result, You Can Use It On-The-Go. It Is Compatible With All Touchscreen Tablets, Laptops, Smartphones, Iphones, Ipads, And Other Built-In Bluetooth Devices. The Built-In Rechargeable Battery Lets You Enjoy 8 Hours Of Non-Stop Playtime. The Stereo Sound Reaches 90Db That Ensures Incredible Sound Quality. It Supports A 32Gb Microsd Card. When There Is An Incoming Call, The Built-In Speaker Automatically Switches To A Phone Call. Key Features Compact Size Built-In Li-Ion Battery 2.5W Speaker X2 1500 Mah Battery 8 Hrs Battery Life 2.5 Hrs Charging Time Wireless Playing The Xiaomi Bluetooth Speaker Can Be Easily Paired With Any Bluetooth Enabled Devices Like Smartphones And Ipads. It Features Built-In Rechargeable Battery Lets You Enjoy 8 Hours Of Non-Stop Playtime. When There Is An Incoming Call, The Built-In Speaker Automatically Switches To A Phone Call. Dynamic Performance Get Enhanced Audio And Clarity With This Bluetooth Speaker. The Stereo Sound Reaches 90Db That Ensures Incredible Sound Quality. This Portable Speaker Fits Easily In Your Backpack Without Taking Much Space.
10038 Xiaomi Mi Bluetooth Speaker Is Perfect For Listening Music On The Go. This Portable Bluetooth Speaker Sports A Blue Finish.Get The Party Started With The Xiaomi Mi Bluetooth Speaker. It Is A Perfect Choice For A Passionate Music Listener. This Xiaomi Mi Speaker Features An Anerva Av3102 Chipset That A Balanced And Exquisite Tone. It Is Just As Big As A Size Of A Pencil Box, Which Means You Carry It Anywhere You Want To Enjoy High-Quality Music. Furthermore, The Dedicated Microphone Enables It To Receive Phone Calls While Connected To A Smartphone. With The 1500Mah Battery, This Bluetooth Speaker Provides Up To 8 Hours Of Music Playback. Available In A Blue Finish, The Xiaomi Mi Bluetooth Speaker Has An All-Aluminum Body That Offers The Best Of Both Sound And Looks. Key Features Type: Bluetooth Speakers Connectivity: Wireless Ports: 1 Battery: 3.8V, 1500Mah Speaker Impedance: 4 Ohms Frequency Response Range: 85 Hz - 20 Khz
10041 <p><span>Powerful connection range can be up to 5 meters in open area. Bluetooth V4.0 technology, compatible with most Bluetooth-enabled devices including iPhone 6S Plus, 6S, 6, 6 Plus, Samsung Galaxy S6 Edge, S6, etc.Built-in microphone for hands-free phone calls.With a rechargeable lithium battery which offers 4 hours of continuous playback.Supports song switch, volume control via your Bluetooth device.</span></p> <p><span>Specifications:</span></p> <p><span>Appearance: </span><span>52mm * 52mm * 25mm</span></p> <p><span>Color: Silver</span></p> <p><span>Bluetooth </span><span>Version: 4.0Effective distance: 5 meters in open areaRated power: 2 WSignal to noise</span></p> <p><span>Ratio: 53 dBRated impedance: 4</span></p> <p><span>Distortion: THD Battery type: Built-in rechargeable lithium battery (not replaced)Battery life: 4 hours (60dBA / 1m, powder noise)</span></p> <p><span>Packing Includes:1x Xiaomi Bluetooth Speaker1x User Manual (Excluding USB charging wire)</span></p>
10042 <p>Xiaomi Mi Bluetooth Speaker Packs A Powerful Battery. This Xiaomi Mi Speaker Delivers High-Definition Sound.The Xiaomi Mi Bluetooth Speaker Basic 2 Is Your Ideal Music Companion For Wherever You Go. It Has A Compact And Thin Body That Makes It Portable And Easy To Carry. This Xiaomi Mi Speaker Is Equipped With Bluetooth 4.2 Connectivity That Ensures Higher Compatibility, Lower Power Consumption, And A More Stable Connection. Moreover, The Aux Input Of This Bluetooth Speaker Allows A Cabled Connection To Devices Such As Phones, Computers, Or Mp3 Players. Furthermore, The Dual Speaker Unit Of Basic 2 Preserves And Pushes Higher Fidelity Sound. Available In A White Finish, This Xiaomi Mi Speaker Looks As Beautiful As It Sounds.</p> <p>– Portable Speakers (5 W, 100 – 18000 Hz, 3 Ω, Wired & Wireless, Bluetooth/3.5 mm, A2DP, AVRCP, HFP)</p>
10043 <ul><li><strong>Product Dimensions:<span> </span></strong>3.9 x 3.9 x 3.9 inches ; 99.8 g</li> <li><strong>Shipping Weight:</strong><span> </span>181 g</li> <li><strong>Batteries</strong><span> </span>1 Lithium Polymer batteries required. (included)</li> <li><strong>Item model number:</strong><span> </span>ZBW4379GL</li> <li><strong>ASIN:<span> </span></strong>B07BF5Q5N8</li> </ul><div class="section-items mj-camera360-02 preload mj-active"><br /><div class="text-content text-black"><br /><p><strong><span style="font-size:large;">Xiaomi Sports Bluetooth Headset</span></strong></p> <br /><p>IPX4 Waterproof | 7 Hours of Playtime | Comfy Ear Hook</p> <br /><p><img src="https://static.mi-store.co.nz/fileslib/_20180926140445_282.jpg" alt="" /></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Enjoy the Relax and Pleasure Sports - Get rid of wired, more free</span></strong></p> <br /><p>Xiaomi Bluetooth sport earbuds feature lightweight and comfortable to meeting sports addict's needs. With waterproof and swearproof design, and 7 hours music and talking time, it is suitable for most of the sports items. Meanwhile, special adjustable earhook design lets it keep stable in your ear during strenuous exercise.</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143151_843.jpg" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">IPX4 Waterproof Sweatproof - Durable to use</span></strong></p> <br /><p>With IPX4 waterproof sweatproof function, you will never need to worry about can't enjoy sport freely on a rainy day or have to stop exercising because of sweating. It will always keep with you.</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143207_139.jpg" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Long Standby Time and Working Time - It can play music continuously for 7 hours</span></strong></p> <br /><p>Xiaomi Bluetooth Sport Earbuds built-in 110mAh rechargeable Li-polymer battery and adopts professional power-saving circuit design, provides 7 hour working time and 11 days standby time for you.</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143221_501.jpg" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Bluetooth 4.1 HD Talking - Quick connection, one-key to answer</span></strong></p> <br /><p>Bluetooth 4.1 technology come with auto noise reduction function, provides the HD talking for you. 35 quick connection, no wiating. Furthermore, Xiaomi Bluetooth sport earbuds also can connect to 2 mobile devices simultaneously</p> <br /><h2 class="title-h2"><img src="https://static.mi-store.co.nz/fileslib/_20180926143232_425.jpg" alt="" /></h2> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Separating On-cord Control Design - Calls / music switch freely</span></strong></p> <br /><p>In order to control music play or calls answer freely, Xiaomi Bluetooth sport earbuds adopt the separating microphone and volume control button design, delivers clearer calls. Meanwhile, more tiny on-cord control also can bring you a more free exercise experience.</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143248_518.jpg" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">MEMS Microphone - Clear and stable sound</span></strong></p> <br /><p>Xiaomi Bluetooth sport earbuds adopt the high-technology MEMS microphone, provides the stable and clear sound, wherever you are, the high-quality calls always existed.</p> <br /><h2 class="title-h2"><img src="https://static.mi-store.co.nz/fileslib/_20180926143258_016.jpg" alt="" /></h2> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Soft and Comfortable Material - Wear-resistant and anti-oil</span></strong></p> <br /><p>The earbuds body adopts the nanometer spray technology, wear resistance, and anti-oil. You just need to wipe it lightly after long time use, and it will be like a new one. The earphone cable adopts the UV paint coating, offers you the comfortable hand feel.</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143318_232.jpg" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Lightweight - Comfort you ear every moment</span></strong></p> <br /><p>Xiaomi bluetooth sport earbuds are the only 17.8g. Meanwhile, combine with ergonomics design, it will bring the excellent music experience.</p> <br /><h2 class="title-h2"><img src="https://static.mi-store.co.nz/fileslib/_20180926143406_687.png" alt="" /></h2> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Multi-technology Metal Appearance - Exquisite texture</span></strong></p> <br /><p>Adopt the CNC carved cut, borax process, twice anodizing and so on technology, Xiaomi Bluetooth sport earbuds delivers the exquisite metal texture and wear resistant anti-scratch features</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143418_681.png" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Undistorted Sound - Movie-coil driver unit + Metal composite diaphragm</span></strong></p> <br /><p>High sensitivity loudspeaker provides the strong bass. Independent sound chamber structure efficiently divides the interference of sound wave, and make hte dynamic sound clearer, so that delivers a more logical sound, Metal composite diaphragm enables the sound effect to be more stable efficiently reduce the distortion of sound, let you experience the more realistic music.</p> <br /><p><strong><span style="font-size:large;"><img src="https://static.mi-store.co.nz/fileslib/_20180926143428_037.jpg" alt="" /></span></strong></p> <br /><p> </p> <br /><p><strong><span style="font-size:large;">Come with 5 Pairs Silicone Earbud Tips - Meets different peoples needs</span></strong></p> <br /><p><img src="https://static.mi-store.co.nz/fileslib/_20180926143443_445.jpg" alt="" /></p> </div> </div>
10045 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Control buttons on the side of the headphone to control music playback, answer incoming calls and activate voice assistant and a button at the bottom to control the volume of the headphone</span></li> <li><span class="a-list-item">Cover is made of a soft PU material and the headband is made of silicone material</span></li> <li><span class="a-list-item">Features two dynamic coils with tri-band equalization</span></li> <li><span class="a-list-item">Includes dual-mic noise reduction</span></li> <li><span class="a-list-item">Reflective design</span></li> </ul>
10046 <p>Fashionable Design A Pair Of Well-Designed Headphones Shouldn'T Just Sound Good, But Should Also Act Like An Ear Accessory.It Has Precise Cavity Structure Calibrations That Lets Music Sing Better. Comfortable Half In-Ear Design Half In-Ear Design, Ergonomically Designed For Comfort. Ergonomically Designed To Conform To The Shape Of Your Ear Canal. It Can Entirely Take Care Of Your Ears And You Can Use It For A Long Time Without Fatigue. Military-Grade Fiber Cable Stretchable Matte Wiring, Wires You Up On Long Music Journeys. We'Ve Specially Selected Tpe, With Elasticity Similar To That Of Rubber, As The Raw Material. It Is Environmental-Friendly, Non-Toxic, And Heat-Resistant. Mems Microphone, Three Sleek Buttons Mems Microphone Reduces Noise Interference. The Wired Remote Comes With Three Sleek Buttons For Answering Calls, Music Playback And Volume Adjustment. 90 Degree Ear Plug Adopts 90 Degree Ear Plug Design, Better Protect The Ear Plug, Ensure Long-Term Use. Moving Coil + Ceramics Dual Unit In Attempt To Create A More Precise Listening Experience, We Placed A Multilayer Ceramic Driver Unit And A Moving Coil Unit Into One Single Set Of Headphones. This Produces A Sound Clarity Across A Wider Audio Range: 20-40 Khz.</p> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Brand : Xiaomi</span></li> <li><span class="a-list-item">Color : White</span></li> <li><span class="a-list-item">Model Number : 4406W</span></li> <li><span class="a-list-item">Connectivity : Wired</span></li> <li><span class="a-list-item">Compatible with : Mobile Phones</span></li> <li><span class="a-list-item">Type : Headphone & Headset Accessories</span></li> <li><span class="a-list-item">Microphone included : Yes</span></li> </ul>
10048 <p>Xiaomi Bluetooth Mi Speaker Features A 5W Speaker That Produces Impressive Audio Output.</p> <p>This Xiaomi Bluetooth Speaker 2 Has Up To 10M Wireless Range.Experience The Powerful And Pulsating Sound Delivered By The Xiaomi Round Bluetooth Speaker 2 While You Are On The Go.</p> <p>The Round-Shape Speaker Will Add Life To All Your Favorite Tracks. Its Lightweight Design Also Makes It Portable So You Can Carry It Everywhere You Go. Whether It'S A Terrace Party Or An Outdoor Trip, This Speaker Is Sure To Impress You With Its Rich And Dynamic Audio Output. You Can Also Store It Easily In Your Backpack Or Your Pocket, Thanks To Its Compact Build. Plus, It'S Simple To Control. The Upper Part Of The Cylinder Performs Many Functions In Response To Your Touch Such As Connecting The Speaker To Other Devices, Starting Or Stopping The Playback, And Adjusting Its Volume. The Signal Reception Range Of This Black-Tone Speaker Is 10M. Its 5W Speaker Delivers A Crisp Sound With Rich Bass That Delights The Listeners. Physical Features Key Features Bluetooth Speaker 1200 Mah Battery Up To 10M Range 5W Maximum Power Slim And Minimalist Design The Easy-To-Carry Lightweight Xiaomi Bluetooth Speaker 2 Boasts A Segmented Design. While The Top Part Is Decorated From An Anodized Aluminum Alloy, The Lower Part Features A High-Quality Design Made Of Pc And Abs Material For Exceptional Durability. It Is Smooth To Touch And Has A Durable Construction. You Can Activate The Device With Just A Touch. Superior Quality Speaker This Xiaomi Bluetooth Mi Speaker Features A Classic Round Design That Boasts An Elegant Appeal. In Addition To The Amazing Design, It Produces Rich And Room Filling Sound That Assures Of An Incredibly Dynamic Listening Experience. Powered By A Built-In Battery Of 1200Mah Capacity, The Speaker Can Play Your Favorite Tracks For Up To 7 Hours At A Stretch. All The More, It Has A Perfect Audio Balance That Allows For Loud And Clear Sound Production.</p> <p> </p>
10049 <p>Mobile Accessory Type : Selfie Stick Compatible Devices</p> <p>Model : Multi</p> <p>Color Family : Black</p> <p>Brand : Xiaomi</p> <p>Compatible With : Multi Selfie Stick And Tripod Mount 2 In 1 Design With More Creative, Record Different Moments Of Your Life Independent Bluetooth 3.0 Remote Control Built-In 60Mah Rechargeable Li-Ion Battery Sensitive Bluetooth Remote Control, React Fast And Fine Get The Best Shots And Videos Without Asking A Stranger 360 Degree Rotation And Adjustable Phone Stand Provide The Perfect View Angles, Convenient To Take Pictures, Enjoy The Autodyne Life Phone Clip Range: 56 - 89Mm Aluminum Alloy Anti-Slip Pull Rod Lightweight, Firm And Non-Slip Anti-Slip Mats Design More Stable And Natural To Take Photos And Record Videos Mini And Exquisite Design Can Be Very Easy To Hold And Put Anywhere You Want, A Bag Or Even A Pocket</p> <p>Specifications:</p> <p>Brand: Xiaomi</p> <p>Accessories Type: Selfie Stick,</p> <p>Stand Features: Selfie Stick, With Bluetooth, With Remote Control, With Tripod</p> <p>Bluetooth Version: Bluetooth3.0</p> <p>Material: Aluminum</p> <p>Alloy Folding Length: 19Cm Extended Length: 42Cm Clip Holder</p> <p>Range: 56 - 89Mm Package Includes: 1X Xiaomi Selfie Stick Tripod</p>