Bosch hat Produkte in den folgenden Kategorien: Smart Home Hub Geräte Smarte Heizungssteuerung Startersets IP Kameras Amazon Alexa Zubehör Google Home Zubehör Smarthome Rauchmelder Sensoren Siri Zubehör Smart Kitchen WLAN Backofen Smartes Türschloss Smart Home Alarmanlage Raumthermostat Fußbodenheizung
16 Anfragen; Gesamtdauer: 6.2699317932129 Millisekunden
| Query | Dauer (ms) |
|---|---|
| SELECT * FROM user__session where (session_key = "1d41ef2c45c94d75f490c976ee92a394" and session_expires > CURRENT_TIMESTAMP()) | 0.45490264892578 |
| SELECT * FROM user__session where (session_key = "1d41ef2c45c94d75f490c976ee92a394" and session_expires > CURRENT_TIMESTAMP()) | 0.17714500427246 |
| 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 = "bosch" LIMIT 1 | 0.41007995605469 |
| 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 = "bosch" LIMIT 1 | 0.37813186645508 |
| SELECT * FROM brand__meta where brand_id = 57 | 0.23484230041504 |
| 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 (57)) group by product.product_id | 0.59008598327637 |
| 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 = 57 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" | 0.38504600524902 |
| SELECT * FROM product__taxonomy where product__taxonomy_id IN (9, 23, 32, 10, 19, 37, 39, 6, 18, 11, 51, 20, 56, 34, 50) | 0.47993659973145 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 0.22196769714355 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 0.20003318786621 |
| 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 = 57 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.51498413085938 |
| 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 = 57 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.49591064453125 |
| 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 = 57 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.51617622375488 |
| 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 = 57 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) | 0.39196014404297 |
| 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 = 57 and brand__product_mapping.brand_id not in (8,9) and product.status = "publish" | 0.39386749267578 |
| SELECT * FROM product__taxonomy where product__taxonomy_id IN (9, 23, 32, 10, 19, 37, 39, 6, 18, 11, 51, 20, 56, 34, 50) | 0.42486190795898 |
Wird geladen...