Eigenschaften von ZigBee
| Typ | Neubau, Nachrüstung |
| Ohne Cloud nutzbar | |
| Übertragungsart | Kabellos |
| Kompatible Sprachassistenten | Amazon Alexa, Google Assistant |
| Verfügbare Gerätetypen | Beleuchtung, Bewegungsmelder, Heizungen |
Alle Geräte mit ZigBee
Filtern
9,5
Gledopto 12W E27 RGB CCT-Lampe
8,0
Gledopto LED E14 RGB CCT-Lampe
8,0
ZigBee LED Strip von Gledopto
6,0
Gledopto GU10 RGB CCT-Lampe
9,0
Gledopto LED E27 RGB CCT-Lampe (6 Watt)
9,5
Homey Pro (2023)
Homey Bridge
SONOFF SNZB-02 Mini-ZigBee Temperatur- und Feuchtigkeitssensor
SONOFF ZBMINIL2 Zigbee Smart Schalter (4 Stück)
NOUS A1Z ZigBee Steckdose
SONOFF NSPanel Pro
-
56 Anfragen; Gesamtdauer: 59.01837348938 Millisekunden
-
Query Dauer (ms) SELECT * FROM user__session where (session_key = "c17395b0185fdd101ff06ceab41cca14" and session_expires > CURRENT_TIMESTAMP()) 0.53691864013672 SELECT * FROM user__session where (session_key = "c17395b0185fdd101ff06ceab41cca14" and session_expires > CURRENT_TIMESTAMP()) 0.21004676818848 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 = "zigbee" LIMIT 1 0.35810470581055 SELECT *, (smarthome_system_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(smarthome_system_date, "%d.%m.%Y") as formatted_date FROM smarthome_system where permalink = "zigbee" LIMIT 1 1.0879039764404 SELECT * FROM smarthome_system__meta where smarthome_system_id = 2 1.0161399841309 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 smarthome_system__product_mapping on smarthome_system__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 smarthome_system__product_mapping.smarthome_system_id in (2)) group by product.product_id 2.5131702423096 SELECT * FROM product__meta where product_id IN (248, 249, 250, 251, 252, 859, 858, 919, 917, 1000, 918) 4.7891139984131 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 248 0.85997581481934 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 = 248 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.97894668579102 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 1.1119842529297 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.57101249694824 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 248 and smarthome_system.status = "publish")) 0.43892860412598 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 249 0.28300285339355 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 = 249 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.46396255493164 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.47397613525391 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.33688545227051 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 249 and smarthome_system.status = "publish")) 0.37407875061035 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 250 0.24914741516113 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 = 250 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.36907196044922 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 250 0.37789344787598 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 250 0.25701522827148 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 250 and smarthome_system.status = "publish")) 0.28085708618164 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 251 0.20217895507812 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 = 251 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.46610832214355 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.41604042053223 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.64921379089355 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 251 and smarthome_system.status = "publish")) 0.71597099304199 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 252 0.24914741516113 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 = 252 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.37598609924316 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.35715103149414 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.22697448730469 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 252 and smarthome_system.status = "publish")) 0.31113624572754 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 859 0.20480155944824 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 = 859 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.39005279541016 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 859 0.43582916259766 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 859 0.29301643371582 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 859 and smarthome_system.status = "publish")) 3.5970211029053 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 858 0.65803527832031 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 = 858 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.56600570678711 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 858 0.48089027404785 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 858 0.42009353637695 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 858 and smarthome_system.status = "publish")) 0.38003921508789 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 919 0.36716461181641 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 917 0.32401084899902 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1000 0.29993057250977 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 = 1000 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.43201446533203 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1000 0.37312507629395 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1000 0.48208236694336 SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1000 and smarthome_system.status = "publish")) 0.42486190795898 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 918 0.29516220092773 SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 1.9888877868652 SELECT *, (smarthome_system_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(smarthome_system_date, "%d.%m.%Y") as formatted_date FROM smarthome_system where smarthome_system_id = 2 LIMIT 1 0.32997131347656 SELECT smarthome_system__data_field.smarthome_system__data_field_id, field_name, field_type, field_prefix, field_suffix, value FROM smarthome_system__data_field LEFT JOIN smarthome_system__data on smarthome_system__data.smarthome_system__data_field_id = smarthome_system__data_field.smarthome_system__data_field_id where smarthome_system__data.smarthome_system_id = 2 order by field_order asc 5.7721138000488 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 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 (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 11.667966842651 SELECT brand.* FROM brand join brand__product_mapping on brand__product_mapping.brand_id = brand.brand_id join product on product.product_id = brand__product_mapping.product_id join product__link on product.product_id = product__link.product_id where (brand.status = "publish" and brand.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 (product__link.reduced_price > 0 or product__link.reduced_price is null)) group by brand.brand_id order by brand.title asc 3.7331581115723 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 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 (product__link.reduced_price > 0 or product__link.reduced_price is null)) 3.1940937042236