SwitchBot

SwitchBot hat Produkte in den folgenden Kategorien: Smart Home Hub Produkttests Geräte Saugroboter IP Kameras Amazon Alexa Zubehör Google Home Zubehör Gadgets Siri Zubehör Saugroboter mit Absaugstation Elektrische Gardinen

Alle Geräte von SwitchBot


Filtern

 9,0

SwitchBot Indoor Cam

SwitchBot Indoor Cam

  Nicht auf Lager* Zum Produkttest 

 9,5

SwitchBot Bot - Smarter Kippschalter

SwitchBot Bot - Smarter Kippschalter

  Nicht auf Lager* Zum Produkttest 

 9,0

SwitchBot Hub Mini Smart Fernbedienung

SwitchBot Hub Mini Smart Fernbedienung

  Nicht auf Lager* Zum Produkttest 
SwitchBot Hub 2

SwitchBot Hub 2

  Nicht auf Lager*  Mehr Infos
SwitchBot Curtain 3 Vorhangmotor

SwitchBot Curtain 3 Vorhangmotor

  Nicht auf Lager*  Mehr Infos
SwitchBot Minisaugroboter K10+ mit Absaugstation

SwitchBot Minisaugroboter K10+ mit Absaugstation

  Nicht auf Lager*  Mehr Infos

  • 31 Anfragen; Gesamtdauer: 39.455413818359 Millisekunden

  • Query Dauer (ms)
    SELECT * FROM user__session where (session_key = "223ce2fa6ea73f73a5574763969ec595" and session_expires > CURRENT_TIMESTAMP()) 0.56290626525879
    SELECT * FROM user__session where (session_key = "223ce2fa6ea73f73a5574763969ec595" and session_expires > CURRENT_TIMESTAMP()) 0.26512145996094
    SELECT *, (page_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(page_date, "%d.%m.%Y") as formatted_date FROM page where permalink = "switchbot" LIMIT 1 1.0712146759033
    SELECT *, (brand_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(brand_date, "%d.%m.%Y") as formatted_date FROM brand where permalink = "switchbot" LIMIT 1 3.0741691589355
    SELECT * FROM brand__meta where brand_id = 15 1.2831687927246
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and brand__product_mapping.brand_id in (15)) group by product.product_id 2.9010772705078
    SELECT * FROM product__meta where product_id IN (14, 492, 494, 762, 996, 1038) 6.4730644226074
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 14 0.2589225769043
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 0.34117698669434
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 492 0.28491020202637
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 494 0.36001205444336
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 762 1.835823059082
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 762 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC 0.61798095703125
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 762 0.43487548828125
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 762 0.38313865661621
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 996 0.40602684020996
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 996 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC 0.50806999206543
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 996 0.87499618530273
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 996 3.5500526428223
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1038 0.51784515380859
    SELECT distinct(product__taxonomy_mapping.taxonomy_id) as id FROM product__taxonomy_mapping JOIN brand__product_mapping on brand__product_mapping.product_id = product__taxonomy_mapping.product_id JOIN product on product__taxonomy_mapping.product_id = product.product_id WHERE brand__product_mapping.brand_id = 15 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.51283836364746
    SELECT * FROM product__taxonomy where product__taxonomy_id IN (8, 9, 18, 19, 20, 24, 34, 6, 65, 15, 64) 0.9150505065918
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.33998489379883
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.2439022064209
    SELECT product__taxonomy.* FROM product__taxonomy join product__taxonomy_mapping on product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id join product on product.product_id = product__taxonomy_mapping.product_id join product__link on product.product_id = product__link.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (product__taxonomy.status = "publish" and product__taxonomy.show_in_filter = true and ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and brand__product_mapping.brand_id = 15 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) group by product__taxonomy.product__taxonomy_id order by product__taxonomy.title asc 5.385160446167
    SELECT smarthome_system.* FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id join product on product.product_id = smarthome_system__product_mapping.product_id join product__link on product.product_id = product__link.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (smarthome_system.status = "publish" and smarthome_system.show_in_filter = true and ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and brand__product_mapping.brand_id = 15 and product__link.reduced_price > 0 and ( ( product__link.price is not null and product__link.price > 0 and product__link.reduced_price is not null and product__link.reduced_price > 0 ) and (product__link.reduced_price < product__link.price) and (1 - (product__link.reduced_price / product__link.price)) > 0.1 and (1 - (product__link.reduced_price / product__link.price)) < 0.5 )) group by smarthome_system.smarthome_system_id order by smarthome_system.title asc 0.80204010009766
    SELECT smarthome_room.* FROM smarthome_room join smarthome_room__product_mapping on smarthome_room__product_mapping.smarthome_room_id = smarthome_room.smarthome_room_id join product on product.product_id = smarthome_room__product_mapping.product_id join product__link on product.product_id = product__link.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (smarthome_room.status = "publish" and smarthome_room.show_in_filter = true and ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and brand__product_mapping.brand_id = 15 and product__link.reduced_price > 0 and ( ( product__link.price is not null and product__link.price > 0 and product__link.reduced_price is not null and product__link.reduced_price > 0 ) and (product__link.reduced_price < product__link.price) and (1 - (product__link.reduced_price / product__link.price)) > 0.1 and (1 - (product__link.reduced_price / product__link.price)) < 0.5 )) group by smarthome_room.smarthome_room_id order by smarthome_room.title asc 0.92887878417969
    SELECT LEAST(min(product__link.reduced_price), min(product__link.price)) as min_price, GREATEST(max(product__link.reduced_price), max(product__link.price)) as max_price FROM product__link join product on product.product_id = product__link.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and brand__product_mapping.brand_id = 15 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.5638599395752
    SELECT LEAST(min(product__link.reduced_price), min(product__link.price)) as min_price, GREATEST(max(product__link.reduced_price), max(product__link.price)) as max_price FROM product__link join product on product.product_id = product__link.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and brand__product_mapping.brand_id = 15 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.33807754516602
    SELECT distinct(product__taxonomy_mapping.taxonomy_id) as id FROM product__taxonomy_mapping JOIN brand__product_mapping on brand__product_mapping.product_id = product__taxonomy_mapping.product_id JOIN product on product__taxonomy_mapping.product_id = product.product_id WHERE brand__product_mapping.brand_id = 15 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.42200088500977
    SELECT * FROM product__taxonomy where product__taxonomy_id IN (8, 9, 18, 19, 20, 24, 34, 6, 65, 15, 64) 2.9990673065186