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 (
    10367, 10368, 10369, 10370, 10371, 10372, 
    10373, 10374, 10022, 10023, 10024, 
    10025, 10026, 10027, 10028, 10029
  ) 
  AND q_product_descriptions.lang_code = 'en'

Query time 0.00063

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 (10367,10368,10369,10370,10371,10372,10373,10374,10022,10023,10024,10025,10026,10027,10028,10029)) 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
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>
10023 <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"> <div class="section-items projection-awards preload mj-active"> <div class="cont"> <h4>winner of Japan's 2017 Good Design Award</h4> <br /><h5>The Japan Good Design Award, iF Design Award, Red Dot Award and IDEA Award are known as the four major global design awards.</h5> <br /><p>This is the world's first ultra-short throw projector with advanced laser display (ALPD) technology, which delivers up to 150 inches of full HD quality images from a distance of 50 centimeters, with 1500 lumens and 3000:1 contrast Quality, and product life up to 20,000 hours. To achieve user-friendly design goals, the high-tech product uses a compact, minimalist "box" design language, and carefully maintains consistency between the host style and the Bluetooth remote control design. Control the host from any corner of the room. Voice assistant quickly find programs and other interactive ways for the user to bring a new movie viewing experience.</p> <br /><cite>-  Good Design Award Judging Panel</cite></div> </div> <br /><div class="section-items projection-02 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2"><small><small>A massive screen <br />for your home</small></small></h2> <br /><p class="mj-description">Xiaomi Laser Projector can project a screen as large as 150 inches. <br />Bring the private theatre into your home.</p> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-02-v2.jpg" alt="" /></div> <br /><div class="section-items projection-03 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">Massive 150” projection area</h2> <br /><h3 class="title-h3">Turn your home into a private cinema</h3> <br /><p class="mj-description">Easily adjust screen size to anywhere between 80-150 inches. <br />Experience the immersive pleasure of watching a movie, listening to a concert, or playing a game on a massive screen.</p> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-03.jpg" alt="" /></div> <br /><div class="section-items projection-04 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">Ultra-short throw distance</h2> <br /><h3 class="title-h3">Project a large screen, even from close range</h3> <br /><p class="mj-description">Uses a 0.233:1 ultra-short throw lens design to do away with the inconvenience of the long-distance projection needed by traditional projectors. The Mi Laser Projector can be positioned 5cm to 50cm away from the display surface on a TV cabinet or mounted to a wall. There is no need to deal with difficult wiring or obstructions.</p> <br /><br /><ul class="items-icon"><li> <ul class="items-icon"><li>5-50 cm from <br />display surface</li> </ul></li> </ul><br /><ul class="items-icon"><li> <ul class="items-icon"><li>Easy to move</li> </ul></li> </ul><br /><ul class="items-icon"><li> <ul class="items-icon"><li>No need for <br />special wiring</li> </ul></li> </ul><br /><br /></div> <br /><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/79/D5A1EF48-6A59-9486-26EE-CAA1743E010F.jpg" alt="" /></div> <br /><div class="section-items projection-05 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2"><small>Cinema-quality</small></h2> <br /><p class="mj-description">Xiaomi Laser Projector features 3000:1 native contrast, comparable to what is found in commercial cinemas. With red light ratios as high as 16-18%, colors are vivid and bright.</p> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-05.jpg" alt="" /></div> <br /><div class="section-items projection-06 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">ALPD 3.0 laser light source technology</h2> <br /><p class="mj-description">Features new ALPD 3.0 laser display technology by Appotronics*, which leads the market in screen color, contrast, and brightness. Not only are pictures bright and clear, the ALPD 3.0 allows us to enhance product life and reduce the machine's size.</p> <br /><div class="tips-items">* Appotronics is the world's leading high-brightness laser phosphor technology innovator. More than 3,000 theatres use this technology around the world.</div> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-06.jpg" alt="" /></div> <br /><div class="section-items projection-07 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2"><small>85%+ NTSC colour range</small></h2> <br /><h3 class="title-h3">Broad color range and distribution</h3> <br /><p class="mj-description">Color is an important part of the entire projection screen. If the colour range is too small, the projector cannot display the film's true colors. Xiaomi Laser Projector uses innovative five-stage color wheel technology for red light projection rates of 16-18% *. The NTSC color range of 85% provides rich and accurate color reproduction.</p> <br /><div class="tips-items">* Conventional projectors usually only use a three or four-stage color wheels. Red light projection rates usually fall below 10%</div> </div> <br /><div class="items-contrast"><span class="contrast-left"><em>Xiaomi Laser Projector 150"</em></span><span class="contrast-right"><em>Conventional projectors</em></span></div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-07.jpg" alt="" /></div> <br /><div class="section-items projection-08 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2"><small>3000:1 native contrast</small></h2> <br /><h3 class="title-h3">Even darker scenes are <br />projected clearly</h3> <br /><p class="mj-description">We often complain that it can be hard to clearly see important details in a cinema because dark pictures are not projected clearly. Xiaomi Laser Projector features 3000:1 native contrast, well over the 2000:1 standard in cinemas. It also features 1920x1080 resolution and support for HDR, so details are clear, even in the dark.</p> </div> <br /><div class="items-contrast"><span class="contrast-left"><em>Xiaomi Laser Projector 150"</em></span><span class="contrast-right"><em>Conventional projectors</em></span></div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-08.jpg" alt="" /></div> <br /><div class="section-items projection-09 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">5000 lumen brightness</h2> <br /><p class="mj-description">The projector's light source offers brightness of up to 5000 lumens.<br />Up to 15-18fL*, comparable to cinema standards.</p> </div> <br /><div class="tips-items">* fL is the Chinese cinema-wide standard for measuring brightness. A brightness of 14 fL is generally accepted for 2D cinema projection in China, and 4.5 fL for 3D pictures.</div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-09.jpg" alt="" /></div> <br /><div class="section-items projection-10 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">TI DLP digital light processing technology</h2> <br /><p class="mj-description">Features DLP digital light processing technology from Texas Instruments. This technology is based on the DMD chip for visual digital information display. Using this technology, Xiaomi Laser Projector can show the picture more clearly and vividly. <br />At the same time, details in the picture are vivid with a high restoration rate.</p> <br /><div class="texas-icon"> </div> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-10.jpg" alt="" /></div> <br /><div class="section-items projection-11 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">5.4um pixel DMD chip</h2> <br /><h3 class="title-h3">2.07 million reflective lenses, <br />so that every inch of the big screen is clear and crisp</h3> <br /><p class="mj-description">The chip has more than 2.07 million 5.4um reflectors, each like a small mirror that flips ± 17 ° independently at a rate of 16.66 million cycles per second, converging the different colors of the beam onto an ultra-short focal laser lens for a high-definition viewing experience.</p> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-11.jpg" alt="" /></div> <br /><div class="section-items projection-12 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">Lamp life of over 25000 hours</h2> <br /><h3 class="title-h3">Watch movies every day of the year.</h3> <br /><p class="mj-description">Appotronics ALPD 3.0 laser light source technology can effectively ensure lamp life of 25,000 hours or more, equivalent to the time needed to watch more than 10,000 movies (each 2 hours in length).</p> </div> <br /><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/18/9903F063-3F5D-F9FF-3FF7-8A69C6AE2CDF.jpg" alt="" /></div> <br /><div class="section-items projection-13 preload mj-active"><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/Joy/projection-4.jpg" alt="" /></div> <br /><div class="section-items projection-14 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">Dual full frequency + dual high frequency high fidelity speakers</h2> <br /><h3 class="title-h3">Mi TV-exclusive sound system</h3> <br /><p class="mj-description">A good picture needs to be accompanied by good sound. Xiaomi Laser Projector features the same custom speaker system developed for Mi TV, with built-in high power double full frequency + dual high-fidelity speakers. It has a unique inverted sound tube design and supports DOLBY, DTS dual decoding, so that you can have a cinema-level audio-visual experience right at home.</p> </div> <br /><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-14.jpg" alt="" /></div> <br /><div class="section-items projection-15 preload mj-active"><br /><div class="items-left"><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/79/B7112402-7937-443E-445E-97E7BDCD9FDC.jpg" alt="" /></div> <br /><div class="items-right"><br /><div class="text-content"><br /><h2 class="title-h2">Anti-direct-viewing sensor</h2> <br /><h3 class="title-h3">Automatic detection helps avoid damage from direct laser beams into the human eye.</h3> <br /><p class="mj-description">The projection reflection imaging principle helps to effectively reduce fatigue and the human eye's exposure to radiation. Lenses on both sides feature a human infrared sensor, so that the device can automatically detect the approach of a human body and lower laser projection brightness to a minimum to avoid direct laser beams into the human eye.</p> </div> </div> </div> <br /><div class="section-items projection-16 preload mj-active"><br /><div class="mj-tabsbox"><br /><div class="tabs-content"><br /><div class="content-ul"><br /><div class="mj-items items-03"><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-16-03.jpg" alt="" /></div> <br /><div class="mj-items items-04 tabs-active"><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-16-04.jpg" alt="" /></div> </div> </div> <br /><div class="text-content"><br /><h2 class="title-h2">Full custom modular hardware system</h2> <br /><h3 class="title-h3">Optimizes interior space, reduces machine size</h3> <br /><p class="mj-description">The use of fully customized modular hardware system and <br />cleverly partitioned internal space help optimize space <br />and reduce the size of the machine.</p> <br /><div class="mj-pages"><a class="pager">Light machine module</a> <a class="pager">Cooling system</a><a class="pager">Stereo speakers</a> <a class="pager pages-active">Android module</a><a class="pager">DLP module</a> <a class="pager">Power source</a><a class="pager">Human body sensor</a></div> </div> </div> </div> <br /><div class="section-items projection-17 preload mj-active"><br /><div class="items-left"><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-17.jpg" alt="" /></div> <br /><div class="items-right"><br /><div class="text-content"><br /><h2 class="title-h2">All new, <br />high-powered cooling system</h2> <br /><h3 class="title-h3">Effective cooling extends the life of the machine</h3> <br /><p class="mj-description">There is no need to worry about overheating or safety due to prolonged use of Xiaomi Laser Projector. The new cooling system, equipped with three large fans, modules designed with special air channels to optimize airflow, and a heat pipe with heat sink convergence quickly and efficiently dissipates heat.</p> </div> </div> </div> <br /><div class="section-items projection-19 preload mj-active"><br /><div class="text-content"><br /><h2 class="title-h2">Exquisitely bright, rounded design.</h2> <br /><h3 class="title-h3">Stylishly fits in anywhere</h3> <br /><p class="mj-description">Xiaomi Laser Projector, like other Mi Smarthome products, features an elegant white outer surface for a clean and delicate effect. It has the footprint of a 15-inch laptop, and features rounded corners for safety.</p> </div> <br /><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/79/B23BB7E7-C34C-C3EA-2B68-0AC867228217.jpg" alt="" /></div> <br /><div class="section-items projection-20 preload mj-active"><br /><div class="items-left"><img class="img-items" src="https://global.appmifile.com/f/i/16/chain/laser-projection/projection-20.jpg" alt="" /></div> <br /><div class="items-text"><br /><div class="text-content"><br /><h2 class="title-h2">Richly configured interface</h2> <br /><h3 class="title-h3">Accomodates a variety of external devices</h3> <br /><p class="mj-description">Xiaomi Laser Projector has a total of 10 expansion interfaces. Computers, speakers, microphones, game consoles, etc. can all be connected to meet your entertainment needs.</p> </div> </div> </div> <br /><div class="section-items projection-21 preload mj-active"><br /><div class="items-left items-right"><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/79/576FFB44-0482-DC86-91E5-9EBD36F8AAB7.jpg" alt="" /></div> <br /><div class="items-text items-text2"><br /><div class="text-content"><br /><h2 class="title-h2">New remote control design</h2> <br /><h3 class="title-h3">Ergonomic design features the same material used to <br />manufacture the main projector.</h3> <br /><p class="mj-description">To ensure the same beautiful overall design as that of the laser projector, the remote control has been completely redesigned. The remote features a compact, ergonomic design while retaining the functionality of the original Mi TV remote control.</p> </div> </div> </div> <br /><div class="section-items projection-22 preload mj-active"><img class="img-items" src="https://i01.appmifile.com/webfile/globalimg/79/4B581D4C-73F4-48AE-87B4-F3A0070DA76D.jpg" alt="" /><br /><div class="tips-items"> </div> </div> </div> </div> </div>
10024 <div>Main Features:</div> <div> </div> <div> Work with other Xiaomi smart devices</div> <div> Intelligent induction: when somebody goes through, the night light will turn on automatically</div> <div> Sense the lightness and dark of your room</div> <div> Notice function: sent alert to you through the APP</div> <div> ZigBee wireless connection</div> <div> Built-in 1pc CR2450 cell battery</div> <div> Detection distance: 7m</div> <div> Detection angle: 170 degree</div> <div> Working temperature: -10 - 45 Deg.C</div> <div> Working humidity: 0 - 95pct RH</div> <div> </div> <ul class="generatedBullets"><li>Brand : Xiaomi</li> <li>null : RTCGQ11LM</li> <li>Type : Security Sensors</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>
10025 <div> <p class="pageSecondTitle">Detects flood and protects your property.</p> <p class="pageContent">IP67 l Local & Remote Alarm l Automatically Turns off Solenoid Water Valve</p> <p class="pageSecondTitle"><span> An Aqara hub is required</span></p> <p class="pageSecondTitle"><span>Aqara Water Leak Sensor meets IP67 waterproof and dustproof rating. </span><br /><span>It is guaranteed to work in humid and dusty environments.</span></p> <p class="pageTitle">Designed to fit everywhere.</p> <p class="pageContent">Aqara Water Leak Sensor can be placed anywhere according to your needs, guarding your home with its elegant design.</p> <p class="pageContent"> </p> <p class="pageContent">Features:</p> </div> <span>Immersion monitoring, timely alarm by App</span><br /><span>IP67 waterproof grade, high-quality and durable</span><br /><span>No installation, place on the ground, small and exquisite</span><br /><span>Note: the CR2032 battery is included</span><br /><br /><span>Note:</span><br /><span>This product should be used with a multi-function gateway or air-condition</span><br /><br /><span>Specification</span><br /><br /><br /><span>General</span><br /><br /><span>Material: ABS,PC</span><br /><br /><span>Dimension and Weight</span><br /><br /><span>Product weight: 0.0200 kg </span><br /><span>Package weight: 0.0380 kg </span><br /><span>Product size (L x W x H): 5.00 x 5.00 x 1.50 cm / 1.97 x 1.97 x 0.59 inches </span><br /><span>Package size (L x W x H): 12.00 x 17.00 x 1.65 cm / 4.72 x 6.69 x 0.65 inches</span><br /><br /><span>Package Contents</span><br /><br /><span>Package Contents: 1 x Water Sensor</span> <ul class="generatedBullets"><li>Brand : Xiaomi</li> <li>Type : water sensor</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>
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>
10027 <p>New Oled Display, Real-Time Display Of Air Quality And Temperature.</p> <p>* The Standard Mode Of Purification Capacity Up To 330 Cubic Meters Per Hour, The Purification Area Can Be Up To 23.1 - 39.6 Square Meters.</p> <p>* Double Fan Four Wind Circulation System, Can Effectively Clean Air Circulation To Sites Throughout The Whole House.</p> <p>* Produces Nearly 10000 Liters Of Clean Air Per Minute.</p> <p>* Smartphone Remote Control And Alerts, Real-Time Air Quality Monitor And Auto Speed Control.</p> <p>* Working Modes: Automatic Mode, Sleeping Mode, High Speed Mode, Timing Mode, Etc.</p> <p>* Three Layers Of Activated Carbon Hepa Filter, Filter Removes 99.99 Percent Of Pm2.5 Particles, Can Effective Adsorb Of Formaldehyde, Removal Of The Second Hand Smoke, Dust.</p> <p>Brand : Xiaomi</p> <p>Type : Air Purifiers</p>
10028 <ul class="generatedBullets"><li>Brand : Xiaomi</li> <li>Color : White</li> <li>Energy consumption : Power (W): 58W Voltage(V): 14.4V Input Voltage (V): 100 - 240V Current : 2.2A Working Time: 2.5h</li> <li>Package weight in KGs : 7</li> <li>Tank Capacity : Water Tank 150 ML Dust Box 480 ML</li> <li>Bagged or Bagless : Bagless</li> <li>Cordless or Corded : Cordless</li> <li>Model Number : Roborock S50</li> <li>Type : Robotic Vacuum Cleaners</li> <li>Surface Type : Multi Surface</li> </ul>
10029 <div class="footer"> <div> <div class="footer-nav"> <div class="container"> <div class="row"> <div class="span3 span-service"> <p>Xiaomi released its electric scooter recently. Boasting a unique folding design, Xiaomi  electric scooter has been made from aircraft-grade aluminum alloy and weighs 12.5kg. Further, it adopts advanced E - ABS braking system, kinetic energy recovery system, cruise control system and intelligent BMS system. Smart and practical, as well as beautiful, you will love it!</p> <p> </p> <p><strong>Features：</strong></p> <ul class="a-unordered-list a-vertical a-spacing-none"><li><span class="a-list-item">- Model: M365 - Material: aircraft-grade aluminum alloy - Wheel size: 8.5 inch inflatable tire - Motor size: 6.7 inch</span></li> <li><span class="a-list-item">- Maximum torque: 16N.m - Maximum speed: 25km/h ( common mode ), 18km/h ( energy-saving mode ) - Cruising distance: 30km</span></li> <li><span class="a-list-item">- Braking system: front E-ABS anti-lock system, rear mechanical disk brake </span></li> <li><span class="a-list-item">- Climbing gradient: approx 14 degree - Waterproof grade: IP54 - Pedal ground clearance: 87.5mm - Max load: 100kg - Charger rated power: 71W</span></li> <li><span class="a-list-item">- Charger input voltage: 100 - 240V, 50 / 60Hz - Battery limited voltage: 42V - Charging time: 5.5 hours - Standard power consumption: 1.1kWh per 100km - Unfolding size: 108 x 43 x 114cm - Folding size: 108 x 43 x 49cm - Net weight: 12.5kg</span></li> </ul></div> </div> </div> </div> </div> </div>
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>
10368 Match The Es2 Colorful Ambient Lights To Your Personal Style And Stand Out Along The Way? The Front And Rear Wheel Shock Absorption Provides Maximum Rider Comfort, And The Anti-Lock Mechanical And Electrical Brakes Ensure A Safe Braking Distance ? Effortlessly Take The Es2 To Speeds Up To 25Km/H Or Use The Convenient Cruise Control Function ? Quick-Folding With A Total Weight Of 12.5Kg, Space-Saving And Portable To Carry ? During Your Riding, The Green Energy Recovery System Makes Sure No Power Goes To Waste ? Aluminum Alloy Body: Lightweight, High Strength, 100Kg Payload, Ip54 Waterproof In Main Body, Ip67 Waterproof In Battery Part ? Smart App: Remote Control By Mobile Phone And Detecting Scooter Datum ( Scanning Qr Code In User Manual ) Package Includes: 1 X Ninebot Kickscooter Es2 1 X Charger 1 X User Manual
10369 <div> <div class="Item-Details-Mini Clearfix"> <h4>Description:</h4> <div> <ul class="generatedBullets"><li>Light Type : Decorative Lights</li> <li>Brand : Other</li> </ul></div> </div> <h4 class="DarkGrey">Features:</h4> <ul><li class="DarkGrey">Energy Saving</li> <li class="DarkGrey">Long Life</li> <li class="DarkGrey">Pure Light</li> <li class="DarkGrey">High Brightness</li> <li class="DarkGrey">Resin Materials</li> <li class="DarkGrey">Heat Resistive</li> <li class="DarkGrey">Not Easily Damaged</li> <li class="DarkGrey">Weight: 200 g</li> <li class="DarkGrey">Use Scope: Wedding Background Layout, Hotels,Restaurants, Shopping Malls, Furniture, Windows, Clubs<br /><br /></li> </ul></div>
10370 <p><strong>Xiaomi Portable Flashlight</strong></p> <p>Xiaomi Portable Flashlight is a practical flashlight, featuring with its portable design.  Its premium aluminum alloy body provides a long service life for you. Coming with the max brightness, it gives you the max convenience. </p> <p><strong>Light-Weight Mini Design</strong></p> <p>With its mini size, Xiaomi Portable Flashlight weighs only 0.103kg, which is protable for you to bring it outside.</p> <p><strong>240 Lumens Brightness </strong></p> <p>Its Max Brightness Is 240 Lumens, Meeting Your Needs of Night Camping, Running, Observation or Exploration Perfectly.</p> <p><strong>3350 mAh Large Capacity Battery</strong></p> <p>Xiaomi Portable Flashlight Comes with A 3350m Ah Large Capacity Battery, Bringing You a Brightness  Endurance for 216mins. </p> <p><strong>Durable Design</strong></p> <p>The body is made of premium aluminum alloy with strong and sturdy design. </p> <p><strong>USB Charging Port</strong></p> <p>With the USB charging port, you can charge for the small current devices such as Xiaomi wristbands and Bluetooth earphones, providing great convenience for you.</p> <p><strong>Unique SOS Mode</strong></p> <p>Xiaomi Portable Flashlight is unique with the SOS mode. Press the function button continuously for 3 times, then it will send a distress signal. </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>