Amazon hat Produkte in den folgenden Kategorien: Sprachassistent Smart Home Hub Multisensor Produkttests Geräte Amazon Alexa Zubehör Gadgets Unterhaltung Heimkino Smarte Lautsprecher Android TV Box Sensoren Smart TV
Alle Geräte von Amazon
Filtern
8,5
Echo Show 15
5,0
Echo Auto 2
Echo Hub | Smart-Home-Panel mit Alexa
-
21 Anfragen; Gesamtdauer: 9.0994834899902 Millisekunden
-
Query Dauer (ms) SELECT * FROM user__session where (session_key = "c3d04a7efe99412b90fc5dea9af222f8" and session_expires > CURRENT_TIMESTAMP()) 0.70714950561523 SELECT * FROM user__session where (session_key = "c3d04a7efe99412b90fc5dea9af222f8" and session_expires > CURRENT_TIMESTAMP()) 0.28300285339355 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 = "amazon" LIMIT 1 0.45299530029297 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 = "amazon" LIMIT 1 0.32186508178711 SELECT * FROM brand__meta where brand_id = 47 0.2448558807373 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 (47)) group by product.product_id 0.82802772521973 SELECT * FROM product__meta where product_id IN (540, 843, 880) 0.40602684020996 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540 0.29206275939941 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 843 0.27608871459961 SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 880 0.40197372436523 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 = 47 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.50783157348633 SELECT * FROM product__taxonomy where product__taxonomy_id IN (2, 9, 19, 8, 24, 27, 29, 30, 71, 7, 32, 6, 28) 0.3960132598877 SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.22792816162109 SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.16617774963379 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 = 47 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.89001655578613 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 = 47 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.78511238098145 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 = 47 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.48303604125977 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 = 47 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 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 = 47 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.36406517028809 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 = 47 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" 0.35405158996582 SELECT * FROM product__taxonomy where product__taxonomy_id IN (2, 9, 19, 8, 24, 27, 29, 30, 71, 7, 32, 6, 28) 0.28514862060547