Amazon

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

Echo Show 15

-32%
  Nicht auf Lager* Zum Produkttest 

 5,0

Echo Auto 2

Echo Auto 2

  Nicht auf Lager* Zum Produkttest 
Echo Hub | Smart-Home-Panel mit Alexa

Echo Hub | Smart-Home-Panel mit Alexa

  Nicht auf Lager*  Mehr Infos

  • 24 Anfragen; Gesamtdauer: 13.190507888794 Millisekunden

  • Query Dauer (ms)
    SELECT * FROM user__session where (session_key = "c649db9eac5fb1faea8c41837051ab93" and session_expires > CURRENT_TIMESTAMP()) 0.71883201599121
    SELECT * FROM user__session where (session_key = "c649db9eac5fb1faea8c41837051ab93" and session_expires > CURRENT_TIMESTAMP()) 0.37884712219238
    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.75507164001465
    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.4429817199707
    SELECT * FROM brand__meta where brand_id = 47 0.52309036254883
    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.82898139953613
    SELECT * FROM product__meta where product_id IN (540, 843, 880) 1.4088153839111
    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.32210350036621
    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.35285949707031
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 880 0.82707405090332
    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 = 880 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.4270076751709
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 880 0.34999847412109
    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.33092498779297
    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.44393539428711
    SELECT * FROM product__taxonomy where product__taxonomy_id IN (2, 9, 19, 8, 24, 27, 29, 30, 71, 7, 32, 6, 28) 0.38504600524902
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.23198127746582
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.20194053649902
    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.92101097106934
    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.64802169799805
    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.79798698425293
    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.50592422485352
    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.49591064453125
    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.54216384887695
    SELECT * FROM product__taxonomy where product__taxonomy_id IN (2, 9, 19, 8, 24, 27, 29, 30, 71, 7, 32, 6, 28) 0.34999847412109