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 (
    10514, 10341, 10353, 10366, 10367, 10371, 
    10372, 10373, 10374, 10022, 10026, 
    10031, 10033, 10035, 10036, 10037, 
    10038, 10041, 10042, 10045, 10046, 
    10048, 10051, 8682, 8214, 4584
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00078

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "62.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": 26,
      "rows_produced_per_join": 26,
      "filtered": "100.00",
      "index_condition": "((`portal`.`q_product_descriptions`.`product_id` in (10514,10341,10353,10366,10367,10371,10372,10373,10374,10022,10026,10031,10033,10035,10036,10037,10038,10041,10042,10045,10046,10048,10051,8682,8214,4584)) and (`portal`.`q_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "57.21",
        "eval_cost": "5.20",
        "prefix_cost": "62.41",
        "data_read_per_join": "99K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
4584 <ul><li>SPECIFICATIONSBrandXiaomi<br /></li><li>RAM Size512</li><li>Package thickness8.6 centimeters</li><li>Package weight in KGs240 grams</li><li>Read more</li></ul>
8214 <ul class="generatedBullets"><li>Brand : JETTOM</li> <li>Color : Yellow</li> <li>Operating System Type : Android</li> <li>Storage Capacity : 4 GB</li> <li>Screen Size : 7 - 7.9 Inch</li> <li>Rear Camera Resolution : 5MP</li> <li>Bluetooth : Yes</li> <li>Front Camera : 2MP</li> <li>Number of SIM : Dual SIM</li> <li>Display Size (Inch) : 7 Inch</li> <li>RAM Size : 512 MB</li> <li>Cellular Network Technology : 2G</li> <li>Display Type : IPS LCD</li> <li>Number of Processor Core : 1.3GHz Quad-Core</li> <li>Battery Capacity in mAh : 2000 mAH</li> <li>Model Number : J1</li> <li>Are batteries needed to power the product or is this product a battery : Yes</li> <li>Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</li> </ul>
8682 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Model Number : Stratos</span></li> <li><span class="a-list-item">External Product ID : 851572007924</span></li> <li><span class="a-list-item">Brand : Xiaomi</span></li> <li><span class="a-list-item">External Product ID Type : EAN-13</span></li> <li><span class="a-list-item">With Camera: No </span></li> <li><span class="a-list-item">RAM Size: 512 MB</span></li> <li><span class="a-list-item">SIM card support : No</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">Operating System : Multi</span></li> <li><span class="a-list-item">Compatible Operating Systems : Android & iOS </span></li> </ul></div> </div>
10022 <div class="celwidget aplus-module basic-module-13-text"> <div class="a-section a-spacing-none aplus-module aplus-module-13"> <div class="a-section a-spacing-none aplus-module-section aplus-text-section"> <p class="description">Xiaomi AMAZFIT smart watch has tons of features for fitness lovers. The Xiaomi Smart Watch AMAZFIT is the perfect pick for fitness enthusiasts. With its built-in GPS, you can calculate your pace and distance while running. Moreover, it features IP67 waterproof rating, which makes it ideal for your swimming sessions as well. The timepiece features an incredible battery life of 11 days making it perfect for everyday use. Plus, it incorporates multiple sports recorders with which you can track your heart rate, pace, calories, speed, altitude, cadence, etc. All the more, it allows you to listen to phone-free music, which you can store in its internal memory. Therefore, it is your go-to watch whenever you head out for jogging or gyming or cardio sessions.</p> </div> </div> </div> <br /><div class="celwidget aplus-module basic-module-13-text"><br /><div class="a-section a-spacing-none aplus-module aplus-module-13"><br /><div class="a-section a-spacing-none aplus-13-heading"><br /><h1 class="aplus-13-heading-text a-text-bold">Product Specifications</h1> </div> <br /><div class="a-section a-spacing-none aplus-module-section aplus-text-section"><br /><p class="description"> </p> <br /><br /><ul class="a-unordered-list a-vertical"><li><ul class="a-unordered-list a-vertical"><li><span class="a-list-item">Memory (ROM) : 4096 MB</span></li> </ul></li></ul><br /><ul class="a-unordered-list a-vertical"><li><ul class="a-unordered-list a-vertical"><li><span class="a-list-item">Screen size: 1.34 inches</span></li> </ul></li></ul><br /><ul class="a-unordered-list a-vertical"><li><ul class="a-unordered-list a-vertical"><li><span class="a-list-item">Screen resolution: 320 x300 pixels</span></li> </ul></li></ul><br /><ul class="a-unordered-list a-vertical"><li><ul class="a-unordered-list a-vertical"><li><span class="a-list-item">Connection mode: bluetooth 4.0</span></li> </ul></li></ul><br /><br /><p> </p> </div> </div> </div> <br /><div class="celwidget aplus-module module-3"><br /><div class="a-expander-collapsed-height a-row a-expander-container a-expander-partial-collapse-container"><br /><div class="a-expander-content a-expander-partial-collapse-content"><br /><div class="aplus-module-wrapper apm-floatnone"><br /><div class="apm-sidemodule apm-spacing"><br /><div class="apm-sidemodule-imageright"><img class="a-spacing-mini" src="https://m.media-amazon.com/images/S/aplus-media/sota/1ee0a6d1-37f0-4891-ae78-148fdf16c641._CR50,0,350,350_PT0_SX300__.jpg" alt="D" /></div> <br /><div class="apm-sidemodule-textleft"><br /><h3 class="a-spacing-mini">Your Everyday Companion</h3> <br /><p>This Xiaomi watch is an excellent communication tool. It helps you receive incoming calls, emails, messages, etc. with ease. Plus, it flaunts a stopwatch, compass, alarms, and more. You can receive calls and messages directly on your watch and can be available to your loved ones even while you are jogging or trekking. Plus, you can hide the screen from your palm to reject a call when you are in a meeting. The watch can connect to iOS and Android devices, allowing you to take advantage of the fitness features, apps, and notifications. The Alipay allows you to make payment via your smartphone, but it is supported for Chinese version only.</p> </div> </div> </div> <br /><div> </div> </div> </div> </div> <br /><div class="celwidget aplus-module module-2"><br /><div class="a-expander-collapsed-height a-row a-expander-container a-expander-partial-collapse-container"><br /><div class="a-expander-content a-expander-partial-collapse-content"><br /><div class="aplus-module-wrapper apm-floatnone"><br /><div class="apm-sidemodule apm-spacing"><br /><div class="apm-sidemodule-imageleft"><img src="https://m.media-amazon.com/images/S/aplus-media/sota/ce868505-d45b-4855-a1e1-56a60b78d016._CR50,0,350,350_PT0_SX300__.jpg" alt="J" /></div> <br /><div class="apm-sidemodule-textright"><br /><h3 class="a-spacing-mini">Superb Design</h3> <br /><p>The Xiaomi AMAZFIT smartwatch is designed using a ceramic bezel, which makes it durable and resistant to scratches. The Xiaomi smartwatch is IP67 rated, which means it is impervious to dust, splashes, rain, and accidental submersion. The design incorporates Wi-Fi connectivity. You can also pair it with your Bluetooth headphones and listen to your favorite music easily.</p> </div> </div> </div> <br /><div> </div> </div> </div> </div> <br /><div class="celwidget aplus-module module-3"><br /><div class="a-expander-collapsed-height a-row a-expander-container a-expander-partial-collapse-container"><br /><div class="a-expander-content a-expander-partial-collapse-content"><br /><div class="aplus-module-wrapper apm-floatnone"><br /><div class="apm-sidemodule apm-spacing"><br /><div class="apm-sidemodule-imageright"><img class="a-spacing-mini" src="https://m.media-amazon.com/images/S/aplus-media/sota/677ba10f-8347-40b0-b299-654e44b4d425._CR50,0,350,350_PT0_SX300__.jpg" alt="J" /></div> <br /><div class="apm-sidemodule-textleft"><br /><h3 class="a-spacing-mini">Stay Focused</h3> <br /><p>With the help of this smart fitness watch, you can increase your productivity in each workout every day. The 24-hour continuous heart rate monitor will keep a track of your heart rate all day long even when you are busy with your daily schedule. The multiple recording modes allow you to check the distance covered, track your runs, time calories, altitude, and the maximum average of pace, speed, and cadence. The built-in GPS makes it even more accurate than your smartphone and other tracking devices.</p> </div> </div> </div> </div> </div> </div>
10026 <ul class="generatedBullets"><li>Brand : Xiaomi</li> <li>Color: White</li> <li>Port Type: Wireless</li> <li>Number of Pieces: 2</li> <li>Speaker Type: Bluetooth Speakers</li> <li>Product weight: 237g</li> <li>Connectivity Technology: Wireless</li> <li>Compatible with: All</li> <li>Model Number: Mi1003</li> <li>Shape: Rectangle</li> <li>Nominal Output: 5 - 10 Watt</li> <li>Are batteries needed to power the product or is this product a battery: Yes</li> <li>Is this a Dangerous Good or a Hazardous Material, Substance or Waste that is regulated for transportation, storage, and/or disposal? : No</li> <li>External Product ID Type : EAN-13</li> </ul>
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>
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>
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>
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>
10051 <p>Bracket Type Xiaomi Selfie Stick and Tripod Mount (2 in 1) design is more creative and records different moments of your life. It has a highly sensitive Bluetooth 3.0 remote control with built-in 60mAH rechargeable Li-ion battery to get the best shots and videos without asking a stranger. It can be rotated 360 degrees to get the perfect view angles, convenient to take pictures. It is made up of Aluminium alloy with anti-slip pull rod ranged up to 56-89mm which makes it lightweight, firm and non-slip. With its minimal and exquisite design, it is very easy to hold and put anywhere you want, a bag or even a pocket.</p> <p>Brand: Xiaomi </p> <p>Accessories type: Selfie Stick, Stand </p> <p>Features: Selfie Stick, with Bluetooth, with Remote Control, with Tripod </p> <p>Bluetooth Version: Bluetooth3.0 </p> <p>Material: Aluminium Alloy </p> <p>Folding Length: 19cm </p> <p>Extended Length: 42cm </p> <p>Clip Holder Range: 56 - 89mm</p> <p>Dimensions and Weight</p> <p>Product weight: 0.1550 kg </p> <p>Package weight: 0.2000 kg </p> <p>Product size: 19.00 x 4.50 x 5.00 cm / 7.48 x 1.77 x 1.97 inches </p> <p>Package size: 22.00 x 6.00 x 7.00 cm / 8.66 x 2.36 x 2.76 inches</p> <p>Package Contents</p> <p>1 x Selfie Stick</p> <p>1 x Bluetooth Remote Control</p>
10341 <ul><li>Support Multi-Languages, Touch Big Screen, 50 Meters Waterproof We Chat, Incoming Calls and Other Message Content Directly Display</li> <li>50 Meters Swimming Waterproof Heart Rate, Sleep, Step Count, Health Management</li> <li>Up to 20 Days Battery Life New 0.78 Inch Oled Touch Screen - Well-Informed, Visible on The Wrist We Chat, Qq, Incoming Calls and Other Message Content Are Directly Displayed</li> <li>Real-Time Display of Exercise Duration, Mileage, Heart Rate and Other Data, 50 Meters Swimming Waterproof - Movement Is Always Known, All-Weather Health Management More Accurate Pedometer, Heart Rate, Sleep Quality Monitoring, Sedentary Reminder Daily Pedometer, Heart Rate Monitoring</li> <li>Sedentary Reminder</li> <li>Unlocked and More Convenient Unlocked and More Convenient Can Be Done without A Mobile Phone</li> <li>New Xiaomi Sports App - Light to 20 Grams,20 Days Long Life - One Black Screen Design, Drip-Like Smart on The Wrist</li> <li> Delivery : 2-5 Weeks Free World Wide</li> </ul>
10353 <ul><li>Brand : Huawei</li> <li>Null : CM-H2S</li> <li>Color : Blue</li> <li>Null : CM-H2S</li> <li>Connectivity : Wireless</li> <li>Compatible with : All</li> <li>Type : In Ear</li> <li>Microphone included : Yes</li> <li>Noise Cancelling : Yes</li> <li>Are batteries needed to power the product or is this product a battery : Yes</li> </ul>
10366 <ul><li><span>This is Huawei Honor Band 4 Standard version so it's without NFC function. CAN NOT make sure NFC version works outside of China mainland. </span></li> <li><span>FW 1.0.10.30 ver. (136). Band screen supports 8 </span><span>languages<strong> </strong>(regions) for Android/iOS</span><span></span></li> <li>APP suports multi-languages.</li> <li><span>For safe reason, you can ONLY see and pair the device in APP Huawei Health.</span></li> <li>You could reboot the band by charging it to fix bluetooth pairing problem if any.</li> <li><span><strong>Alarm: </strong>Smart vibration</span></li> <li><span><span><strong>For Bluetooth: </strong>4.2, compatible with 4.0/4.1</span></span></li> <li><span><span><strong>Swimmable: </strong>5ATM(Swim or Shower in not-hot water), show swimming time and calories</span></span></li> <li><span><strong>Strap: </strong>Streamline Texture, Skin Care, Nimble Design, Detached Without Screwdriver</span></li> </ul>
10367 <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">Water resistant up to 50m</span></li> <li><span class="a-list-item">Advanced sleep tracking</span></li> <li><span class="a-list-item">Long battery life: Up to 30 days</span></li> <li><span class="a-list-item">Smart notifications</span></li> <li><span class="a-list-item">Heart rate monitoring</span></li> </ul><p> </p>
10371 <p><strong>Product Summary:</strong></p> <ul><li>The Ultimate Smartwatch For Today'S Serious Athlete.</li> <li>The Latest Smartwatch In Lineup Of Fitness Wearables.</li> <li>The Perfect Companion To Keep You Organized And Productive All Day Long.</li> <li>Receive Notifications For Emails, Sms, Phone Calls, Facebook, Twitter, Whatsapp, Linkedin, Snap, Slack, Weather Forecasts, And Other Apps From Your Mobile Phone.</li> </ul><p><strong>Specifications:</strong></p> <ul><li><span>Package Dimensions: 7.9 x 7.9 x 7.9 inches</span></li> <li><span>Item Weight: 1.76 ounces</span></li> <li><span>Color: Black</span></li> </ul>
10372 <p>Age: Blue</p> <p>Features: GPS, Glonass, Wrist Heart Rate, Daily Activity Tracker, Accelerometer</p> <p><span>Manufactured with A Polycarbonate Body and Zirconia Ceramic that Gives It a Modern and Elegant Design, It Is Accompanied by A 1.3´´ AMOLED Screen Covered by Corning Gorilla Glass 3 The IP68 Certification Allows You to Submerge in Water up To 2 Meters with A Maximum Time of 30 Minutes.</span></p> <p><span>The Xiaomi Amazfit Verge wIll Perform Constant Measurements Throughout the Day. In Addition, Your Heart Rate Sensor Has an Efficiency of 98%, So, Any Strange Change of The Constants Will Be Recorded to Help You Take Care of Your Health. Using Gps and Glonass Positioning, It Will Detect Any Action You Take.<br /></span></p>
10373 <p style="font-weight:400;"><strong>KEY FEATURES</strong></p> <p style="font-weight:400;">Track 11 Sports, Including Running, Walking, Climbing, Tennis, Skiing, Soccer,Cycling, Elliptical Training, and Others.</p> <p style="font-weight:400;">GPS +GLONASS To Accurately Track Routes and Distances Traveled.</p> <p style="font-weight:400;">Answer Incoming Calls Right on Your Wrist (via Bluetooth Connection to The Phone).</p> <p style="font-weight:400;">Check Your Emails Right on Your Wrist.</p> <p style="font-weight:400;"> </p>
10374 <div class="izq">Age: Adult</div> <div class="izq">Features: GPS, Glonass, Wrist Heart Rate, Daily Activity Tracker, Accelerometer.</div> <div class="izq">Color: White</div> <div class="izq"> </div> <div class="izq"><span>Manufactured with a polycarbonate body and zirconia ceramic that gives it a modern and elegant design, it is accompanied by a 1.3´´ AMOLED screen covered by Corning Gorilla Glass 3 The IP68 certification allows you to submerge in water up to 2 meters with a maximum time of 30 minutes.</span></div> <div class="izq"> </div> <div class="izq"><span>The Xiaomi Amazfit Verge will perform constant measurements throughout the day. In addition, your heart rate sensor has an efficiency of 98%, so, any strange change of the constants will be recorded to help you take care of your health. Using GPS and Glonass positioning, it will detect any action you take.</span></div> <div class="der"> </div>
10514 <div><strong>Main Features:</strong><span> </span></div> <div> </div> <div><span>- Bluetooth 4.0 chip, low consumption and fast-paced </span></div> <div><span>- 3ATM Waterproof, Not Afraid of Rainy Days or Any Outdoor Activities </span></div> <div><span>- 1.5 Inch Round Glass Screen, Show You High-Resolution Images </span></div> <div><span>- Automatic Calibration Time Switch Time Zone Freely </span></div> <div><span>- Pedometer, Built-In Motion Sensor, Record Every Step of Life</span></div>