Netatmo

Netatmo hat Produkte in den folgenden Kategorien: Zubehör Produkttests Geräte Smarte Heizungssteuerung Startersets Amazon Alexa Zubehör Google Home Zubehör Smarthome Rauchmelder Smart Garden Sensoren Siri Zubehör Smarte Wetterstation Smartes Türschloss Smart Home Thermostat Wandthermostat Luftmessgeräte

Alle Geräte von Netatmo


Filtern

 8,0

Netatmo smarter Raumluftsensor

Netatmo smarter Raumluftsensor

-35%
  Nicht auf Lager* Zum Produkttest 

 5,0

Netatmo Smartes Türschloss

Netatmo Smartes Türschloss

-21%
Bei Tink ansehen* Zum Produkttest 
Netatmo Smart Key (1Stück)

Netatmo Smart Key (1Stück)

-11%
Bei Tink ansehen*
Netatmo smartes Türschloss Erweiterungs-Kit 50 mm

Netatmo smartes Türschloss Erweiterungs-Kit 50 mm

Bei Tink ansehen*
Netatmo smartes Türschloss Erweiterungs-Kit 45 mm

Netatmo smartes Türschloss Erweiterungs-Kit 45 mm

Bei Tink ansehen*

  • 34 Anfragen; Gesamtdauer: 10.998010635376 Millisekunden

  • Query Dauer (ms)
    SELECT * FROM user__session where (session_key = "c3d04a7efe99412b90fc5dea9af222f8" and session_expires > CURRENT_TIMESTAMP()) 0.47588348388672
    SELECT * FROM user__session where (session_key = "c3d04a7efe99412b90fc5dea9af222f8" and session_expires > CURRENT_TIMESTAMP()) 0.18310546875
    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 = "netatmo" LIMIT 1 0.39100646972656
    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 = "netatmo" LIMIT 1 0.28204917907715
    SELECT * FROM brand__meta where brand_id = 28 0.22387504577637
    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 (28)) group by product.product_id 0.66208839416504
    SELECT * FROM product__meta where product_id IN (992, 1044, 1076, 1082, 1081) 0.63800811767578
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 992 0.21982192993164
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 992 0.35619735717773
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 992 0.25606155395508
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 0.23603439331055
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1076 0.20003318786621
    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 = 1076 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.36191940307617
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1076 0.24795532226562
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1076 0.21791458129883
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1082 0.19311904907227
    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 = 1082 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.28395652770996
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1082 0.24104118347168
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1082 0.21600723266602
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1081 0.17595291137695
    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 = 1081 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.28419494628906
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1081 0.23388862609863
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1081 0.2129077911377
    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 = 28 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.35619735717773
    SELECT * FROM product__taxonomy where product__taxonomy_id IN (9, 19, 25, 36, 10, 11, 20, 34, 57, 23, 8, 32, 85, 55, 50, 5) 0.37097930908203
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.19288063049316
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.16689300537109
    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 = 28 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 0.68283081054688
    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 = 28 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.58317184448242
    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 = 28 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.42605400085449
    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 = 28 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.3969669342041
    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 = 28 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.33402442932129
    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 = 28 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.29492378234863
    SELECT * FROM product__taxonomy where product__taxonomy_id IN (9, 19, 25, 36, 10, 11, 20, 34, 57, 23, 8, 32, 85, 55, 50, 5) 0.40006637573242