Gledopto hat Produkte in den folgenden Kategorien: Produkttests Geräte WLAN Lampe Amazon Alexa Zubehör Google Home Zubehör Siri Zubehör Smarte Glühbirne LED Strip
Alle Geräte von Gledopto
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)
-
36 Anfragen; Gesamtdauer: 28.015375137329 Millisekunden
-
Query Dauer (ms) SELECT * FROM user__session where (session_key = "9bf691ec16b6163829eb200697b19eec" and session_expires > CURRENT_TIMESTAMP()) 0.49805641174316 SELECT * FROM user__session where (session_key = "9bf691ec16b6163829eb200697b19eec" and session_expires > CURRENT_TIMESTAMP()) 0.24294853210449 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 = "gledopto" LIMIT 1 0.56195259094238 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 = "gledopto" LIMIT 1 1.3217926025391 SELECT * FROM brand__meta where brand_id = 11 3.7631988525391 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 (11)) group by product.product_id 1.101016998291 SELECT * FROM product__meta where product_id IN (248, 249, 250, 251, 252) 3.9639472961426 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 248 0.31185150146484 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.45394897460938 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.83494186401367 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.33998489379883 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.45895576477051 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.4889965057373 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.37407875061035 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 250 0.25296211242676 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.42891502380371 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 250 0.36787986755371 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.30803680419922 SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 251 0.23794174194336 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.78797340393066 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.61202049255371 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.4119873046875 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.48494338989258 SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.51593780517578 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.31304359436035 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 = 11 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.52595138549805 SELECT * FROM product__taxonomy where product__taxonomy_id IN (8, 9, 12, 19, 20, 34, 53, 54) 0.41890144348145 SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.24104118347168 SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.24104118347168 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 = 11 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 1.0800361633301 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 = 11 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.87809562683105 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 = 11 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 3.6509037017822 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 = 11 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.45299530029297 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 = 11 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.38909912109375 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 = 11 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.35715103149414 SELECT * FROM product__taxonomy where product__taxonomy_id IN (8, 9, 12, 19, 20, 34, 53, 54) 0.34284591674805