In Tutorials zeige ich dir Schritt für Schritt, wie du dein Zuhause für wenig Geld intelligenter machen kannst.
Smart Home News
Mit unseren Smart Home News bleibst du immer auf dem Laufenden!
Smart Home Guide
In unseren Ratgeber-Artikeln geben wir dir praktische Tipps, Tricks und Infos zu verschiedenen Themen aus der Smarthome Welt.
Smart Home Produkttests
In unseren Produkttests gehen wir auf unsere Erfahrungen mit den unterschiedlichsten Produkten ein.
9,5
Homey Pro (2023)
8,0
Netatmo smarter Raumluftsensor
5,0
Netatmo Smartes Türschloss
9,5
SwitchBot Bot - Smarter Kippschalter
Mittlerweile gibt es mehrere weit verbreitete Smart Speaker. Hier gelangst du direkt zu den kompatiblen Geräten für dein System:
Featured
Smarthome Blogger ist nicht nur einer von vielen Smart Home Blogs. Auf Smarthome Blogger möchte ich dir eine Mischung aus hilfreichen Tutorials und Kurztipps, informativen Ratgeber-Artikeln, ehrlichen Produkttests und den wichtigsten News aus der Smarthome-Welt bieten, damit dir zu deinem eigenen Hausautomations-System nichts mehr im Weg steht!
Tutorials
In Tutorials zeige ich dir Schritt für Schritt, wie du dein Zuhause für wenig Geld intelligenter machen kannst.
Dienstleister
Finde den passenden Dienstleister, der dir bei der Wahl der Produkte und der Installation in dein System hilft.
Produkte
Neben Produktvorstellungen teste ich auch verschiedene Produkte und sag dir meine ehrliche Meinung dazu.
Smart Home Systeme
Mittlerweile gibt es viele verschiedene Smart Home Systeme und unzählige Geräte, um dein Zuhause intelligenter zu machen. Damit du nicht den Überblick verlierst, findest du hier eine Übersicht der erhältlichen Systeme:
Kategorien
Bei der Flut an Smart Home Geräten ist es oft schwierig, den Überblick zu behalten. Deshalb findest du hier eine Übersicht mit den wichtigsten Produktkategorien!
Unser Tipp
Auf Smarthome Blogger zeigen wir dir alles mögliche, was mit Smarthome zu tun hat. Dazu gehört auch, wie du dein Zuhause mit dem Raspberry Pi für wenig Geld intelligenter machen kannst.
Von der simplen Steuerung von Funksteckdosen bis zur Installation des Z-Wave Moduls auf dem Raspberry Pi ist einiges dabei.
Neben ganzen Tutorials gibt es außerdem kleinere und eher allgemein gehaltene Kurztipps, damit dir beim Weg zum intelligenten Wohnen nichts mehr im Weg steht. Und weitere Artikel folgen.
157 Anfragen; Gesamtdauer: 199.57733154297 Millisekunden
| Query | Dauer (ms) |
|---|---|
| SELECT * FROM user__session where (session_key = "a98385276976c0d5e3644f215d6ef534" and session_expires > CURRENT_TIMESTAMP()) | 1.6739368438721 |
| SELECT * FROM user__session where (session_key = "a98385276976c0d5e3644f215d6ef534" and session_expires > CURRENT_TIMESTAMP()) | 0.40793418884277 |
| SELECT *, (news_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(news_date, "%d. %M %Y") as formatted_date FROM news where status = "publish" ORDER BY news_date desc LIMIT 3 | 4.6200752258301 |
| SELECT post.* FROM post JOIN post__taxonomy_mapping ON post__taxonomy_mapping.post_id = post.post_id JOIN post__taxonomy ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post__taxonomy.permalink IN ("guide") and post.status = "publish" and post_date < CURRENT_TIMESTAMP() order by post_date desc LIMIT 3 | 10.94388961792 |
| SELECT * FROM post__meta where post_id IN (119, 115, 106) | 3.715991973877 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 119 | 1.2760162353516 |
| SELECT * FROM post__taxonomy where (status = "publish") order by title ASC | 0.72383880615234 |
| SELECT file_path FROM attachment where attachment_id = 1051 | 5.2549839019775 |
| SELECT * FROM stock_attachment where stock_attachment_id = 67 | 4.1029453277588 |
| 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 left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_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 (product__taxonomy_mapping.taxonomy_id in (55) or product__taxonomy_virtual_mapping.taxonomy_id in (55))) group by product.product_id order by RAND() limit 4 | 17.395973205566 |
| SELECT * FROM product__meta where product_id IN (590, 933, 293) | 5.5069923400879 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 590 | 0.66018104553223 |
| 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 = 590 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 | 1.3771057128906 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590 | 3.5171508789062 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590 | 0.51403045654297 |
| 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 = 590 and smarthome_system.status = "publish")) | 1.6028881072998 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 933 | 0.37121772766113 |
| 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 = 933 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 = 933 | 0.99492073059082 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 | 0.29492378234863 |
| 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 = 933 and smarthome_system.status = "publish")) | 0.5180835723877 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 293 | 0.30708312988281 |
| 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 = 293 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.5488395690918 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 | 0.82492828369141 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 | 0.53906440734863 |
| 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 = 293 and smarthome_system.status = "publish")) | 0.42986869812012 |
| SELECT * FROM product__taxonomy where (status = "publish") order by title ASC | 3.0438899993896 |
| SELECT file_path FROM attachment where attachment_id = 1019 | 1.168966293335 |
| 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 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.product_id in (540)) group by product.product_id order by RAND() limit 4 | 1.7330646514893 |
| SELECT * FROM product__meta where product_id IN (540) | 2.1400451660156 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 540 | 0.76818466186523 |
| 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 = 540 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 | 1.0809898376465 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540 | 0.89383125305176 |
| 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.579833984375 |
| 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 = 540 and smarthome_system.status = "publish")) | 0.88405609130859 |
| SELECT file_path FROM attachment where attachment_id = 1013 | 0.29301643371582 |
| 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 left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_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 (product__taxonomy_mapping.taxonomy_id in (15) or product__taxonomy_virtual_mapping.taxonomy_id in (15))) group by product.product_id order by RAND() limit 4 | 5.2649974822998 |
| SELECT * FROM product__meta where product_id IN (750, 1026, 1070, 1037) | 2.2060871124268 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 750 | 0.27799606323242 |
| 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 = 750 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.45204162597656 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 750 | 0.76103210449219 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 750 | 0.32210350036621 |
| 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 = 750 and smarthome_system.status = "publish")) | 0.32997131347656 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1026 | 0.24700164794922 |
| 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 = 1026 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.40888786315918 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1026 | 0.37598609924316 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1026 | 0.36287307739258 |
| 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 = 1026 and smarthome_system.status = "publish")) | 0.34308433532715 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1070 | 0.19598007202148 |
| 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 = 1070 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.42605400085449 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1070 | 0.58197975158691 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1070 | 0.40483474731445 |
| 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 = 1070 and smarthome_system.status = "publish")) | 0.41007995605469 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1037 | 0.35309791564941 |
| 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 = 1037 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 | 1.5590190887451 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1037 | 1.2891292572021 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1037 | 0.83398818969727 |
| 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 = 1037 and smarthome_system.status = "publish")) | 0.7631778717041 |
| 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 left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_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 (product__taxonomy_mapping.taxonomy_id in (18) or product__taxonomy_virtual_mapping.taxonomy_id in (18))) group by product.product_id order by RAND() limit 4 | 8.3861351013184 |
| SELECT * FROM product__meta where product_id IN (490, 208, 14) | 5.7311058044434 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 490 | 1.2531280517578 |
| 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 = 490 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.96917152404785 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.73409080505371 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.5791187286377 |
| 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 = 490 and smarthome_system.status = "publish")) | 0.52309036254883 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 208 | 0.35810470581055 |
| 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 = 208 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.82707405090332 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 208 | 0.87213516235352 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 208 | 0.41508674621582 |
| 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 = 208 and smarthome_system.status = "publish")) | 0.48398971557617 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 14 | 0.3509521484375 |
| 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 = 14 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.88119506835938 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 | 0.91409683227539 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 | 0.57291984558105 |
| 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 = 14 and smarthome_system.status = "publish")) | 0.68497657775879 |
| 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 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.product_id in (859)) group by product.product_id order by RAND() limit 4 | 1.7409324645996 |
| SELECT * FROM product__meta where product_id IN (859) | 2.0790100097656 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 859 | 0.68211555480957 |
| 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.96607208251953 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 859 | 0.85592269897461 |
| 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.75197219848633 |
| 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")) | 1.5099048614502 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 115 | 1.7468929290771 |
| SELECT file_path FROM attachment where attachment_id = 921 | 1.2409687042236 |
| 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 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.product_id in (437,103,248,251,249,252,598,607,356,353,279,285,282,432,359,352,79,83,102,101,354,435,532,189,361,358,187,78,355,226,636,458,634,90,357,362)) group by product.product_id order by RAND() limit 4 | 3.0839443206787 |
| SELECT * FROM product__meta where product_id IN (248, 251, 252, 90) | 7.8678131103516 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 248 | 0.99301338195801 |
| 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 | 1.060962677002 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 | 0.72288513183594 |
| 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.39291381835938 |
| 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.47993659973145 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 251 | 0.54717063903809 |
| 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 | 1.0769367218018 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 | 0.79083442687988 |
| 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.71287155151367 |
| 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.44107437133789 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 252 | 0.27203559875488 |
| 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.48708915710449 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 | 0.62680244445801 |
| 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.26488304138184 |
| 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.37384033203125 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 90 | 0.25796890258789 |
| 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 = 90 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.44798851013184 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 | 0.42581558227539 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 | 0.27799606323242 |
| 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 = 90 and smarthome_system.status = "publish")) | 0.32210350036621 |
| 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 left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_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 (product__taxonomy_mapping.taxonomy_id in (56) or product__taxonomy_virtual_mapping.taxonomy_id in (56))) group by product.product_id order by RAND() limit 4 | 5.8660507202148 |
| SELECT * FROM product__meta where product_id IN (75) | 1.7678737640381 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 75 | 0.44608116149902 |
| 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 = 75 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.54001808166504 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 | 0.46491622924805 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 | 0.27203559875488 |
| 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 = 75 and smarthome_system.status = "publish")) | 0.30708312988281 |
| SELECT * FROM stock_attachment where stock_attachment_id = 61 | 0.24199485778809 |
| 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 left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_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 (product__taxonomy_mapping.taxonomy_id in (18,50,16,21) or product__taxonomy_virtual_mapping.taxonomy_id in (18,50,16,21))) group by product.product_id order by RAND() limit 4 | 5.6121349334717 |
| SELECT * FROM product__meta where product_id IN (961, 14, 1044, 1030) | 2.3739337921143 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 961 | 0.53596496582031 |
| 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 = 961 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.50806999206543 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 | 0.36191940307617 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 | 0.25391578674316 |
| 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 = 961 and smarthome_system.status = "publish")) | 0.29397010803223 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 | 0.23698806762695 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1044 | 0.21910667419434 |
| 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 = 1044 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.8389949798584 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 | 0.35619735717773 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 | 0.23889541625977 |
| 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 = 1044 and smarthome_system.status = "publish")) | 0.31614303588867 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1030 | 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 = 1030 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.38790702819824 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1030 | 0.36406517028809 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1030 | 0.28514862060547 |
| 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 = 1030 and smarthome_system.status = "publish")) | 0.2288818359375 |
| SELECT file_path FROM attachment where attachment_id = 1025 | 0.33402442932129 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 106 | 0.32687187194824 |
| SELECT file_path FROM attachment where attachment_id = 872 | 0.45204162597656 |
| SELECT * FROM stock_attachment where stock_attachment_id = 44 | 0.23508071899414 |
| SELECT product__taxonomy.* FROM product__taxonomy where permalink in ("produkttests"); | 0.55408477783203 |
| 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 left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_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 (product__taxonomy_mapping.taxonomy_id in (8) or product__taxonomy_virtual_mapping.taxonomy_id in (8))) group by product.product_id order by product.product_date DESC limit 4 | 6.4539909362793 |
| SELECT * FROM product__meta where product_id IN (859, 992, 1044, 492) | 1.6310214996338 |
| 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.36883354187012 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 992 | 0.23007392883301 |
| 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 = 992 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 = 992 | 0.32901763916016 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 992 | 0.244140625 |
| 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 = 992 and smarthome_system.status = "publish")) | 0.26583671569824 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 | 0.28085708618164 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 492 | 0.19598007202148 |
| 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 = 492 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.30303001403809 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 492 | 0.29706954956055 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 492 | 0.2751350402832 |
| 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 = 492 and smarthome_system.status = "publish")) | 0.244140625 |
| SELECT file_path FROM attachment where attachment_id = 1020 | 0.20790100097656 |
| 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 status = "publish" ORDER BY title asc | 0.91409683227539 |
| SELECT * FROM smarthome_system__meta where smarthome_system_id IN (5, 8, 15, 16, 22, 18, 3, 21, 14, 24, 20, 7, 26, 9, 12, 29, 17, 19, 32, 4, 23, 13, 10, 27, 25, 11, 28, 6, 1, 2) | 2.1920204162598 |
| SELECT file_path FROM icon where icon_id = 3 | 1.5439987182617 |
| SELECT file_path FROM icon where icon_id = 2 | 0.19288063049316 |
| SELECT file_path FROM icon where icon_id = 1 | 0.18095970153809 |
Wird geladen...
