Smart Home Hersteller 🏅 in der Übersicht

[smarthome_hersteller anchor_link="true"]

Amazon

Geräte von Amazon

8,5

Echo Show 15

-32%

Nicht auf Lager* Zum Produkttest

Echo Hub | Smart-Home-Panel mit Alexa

Nicht auf Lager* Mehr Infos

5,0

Echo Auto 2

Nicht auf Lager* Zum Produkttest

Alle Geräte von Amazon

Aqara

Geräte von Aqara

Aqara Smarte Video-Türklingel G4 (inkl. Klingel)

-25%

Nicht auf Lager* Mehr Infos

Alle Geräte von Aqara

Blink

Geräte von Blink

Alle Geräte von Blink

Bosch

Geräte von Bosch

Alle Geräte von Bosch

Bresser

Geräte von Bresser

Alle Geräte von Bresser

Dreame

Geräte von Dreame

Dreame L20 Ultra Complete Saugroboter

Nicht auf Lager* Mehr Infos

Dreame D10s Saugroboter mit Wischfunktion

-35%

Nicht auf Lager* Mehr Infos

Dreame A1 Mähroboter

Nicht auf Lager* Mehr Infos

Dreame L10s Pro Ultra Heat

Nicht auf Lager* Mehr Infos

Alle Geräte von Dreame

Ecovacs

Geräte von Ecovacs

ECOVACS DEEBOT T10+ Saug- & Wischroboter

Nicht auf Lager* Mehr Infos

ECOVACS Goat GX-600 Mähroboter für bis zu 600m²

Nicht auf Lager* Mehr Infos

ECOVACS AIRBOT Z1 Luftreiniger-Roboter

Nicht auf Lager* Mehr Infos

Ecovacs Winbot W1 Pro Fensterputzroboter

Nicht auf Lager* Mehr Infos

Alle Geräte von Ecovacs

Egardia

Geräte von Egardia

9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Nicht auf Lager* Zum Produkttest

Alle Geräte von Egardia

Elgato Eve

Geräte von Elgato Eve

Alle Geräte von Elgato Eve

eufy

Geräte von eufy

Alle Geräte von eufy

Fibaro

Geräte von Fibaro

Alle Geräte von Fibaro

Fritz!Dect

Geräte von Fritz!Dect

Alle Geräte von Fritz!Dect

Gardena

Geräte von Gardena

Alle Geräte von Gardena

Google

Geräte von Google

Google Nest Audio Smart Speaker

Bei MediaMarkt ansehen*

Google Nest Mini Smart Speaker

Bei MediaMarkt ansehen*

Google Nest Hub (2. Generation)

Bei Tink ansehen*

Alle Geräte von Google

Govee

Geräte von Govee

Govee Glide Hexa Pro 3D - 10 Panels

Nicht auf Lager* Mehr Infos

Govee Alexa Smarte Glühbirne E27 (4er Set)

Nicht auf Lager* Mehr Infos

Govee DreamView G1 Gaming Light

Nicht auf Lager* Mehr Infos

Govee Envisual TV Hintergrundbeleuchtung T2 55-65 Zoll

-36%

Nicht auf Lager* Mehr Infos

Alle Geräte von Govee

Husqvarna

Geräte von Husqvarna

Alle Geräte von Husqvarna

Innr

Geräte von Innr

Alle Geräte von Innr

iRobot

Geräte von iRobot

iRobot Braava Jet m6 Wischroboter

Nicht auf Lager* Mehr Infos

Alle Geräte von iRobot

Klyqa

Geräte von Klyqa

Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

Nicht auf Lager* Mehr Infos

Alle Geräte von Klyqa

Lytmi

Geräte von Lytmi

Lytmi Fantasy 65~70 Zoll

Nicht auf Lager* Mehr Infos

Lytmi Neo Sync Box

Nicht auf Lager* Mehr Infos

Lytmi Smart RGB LED Lightbar

Nicht auf Lager* Mehr Infos

Lytmi Fantasy 3 55~60 Zoll

Nicht auf Lager* Mehr Infos

Alle Geräte von Lytmi

Meross

Meross ist ein führender Hersteller von Smart-Home-Produkten, die es dem Nutzer ermöglichen, sein Zuhause komfortabel und effizient zu verwalten. Mit einer breiten Produktpalette, die Steckdosen, Thermostate, Glühbirnen, Rauchmelder, Sensoren und Türklingeln umfasst, bietet Meross eine intelligente Lösung für jeden Bedarf.

Geräte von Meross

8,8

Meross Smart WLAN Heizkörperthermostat Test

Nicht auf Lager* Zum Produkttest

9,0

Meross Steckdose Testbericht

-14%

Nicht auf Lager* Zum Produkttest

Alle Geräte von Meross

MIYO

Geräte von MIYO

8,5

MIYO smarte Bewässerung Starterset

Nicht auf Lager* Zum Produkttest

Alle Geräte von MIYO

Netatmo

Geräte von Netatmo

8,0

Netatmo smarter Raumluftsensor

-35%

Nicht auf Lager* Zum Produkttest

5,0

Netatmo Smartes Türschloss

-21%

Bei Tink ansehen* Zum Produkttest

Netatmo Smart Key (1Stück)

-11%

Bei Tink ansehen*

Netatmo smartes Türschloss Erweiterungs-Kit 45 mm

Bei Tink ansehen*

Alle Geräte von Netatmo

Nuki

Geräte von Nuki

Nuki Smart Lock 4.0

Nicht auf Lager* Mehr Infos

Nuki Opener - Steuerung der Gegensprechanlage

Nicht auf Lager* Mehr Infos

Alle Geräte von Nuki

Osram

Geräte von Osram

Alle Geräte von Osram

Philips Hue

Geräte von Philips Hue

Philips Hue Play HDMI Sync Box

Nicht auf Lager*

9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Nicht auf Lager* Zum Produkttest

Alle Geräte von Philips Hue

Ring

Geräte von Ring

Alle Geräte von Ring

Roborock

Geräte von Roborock

roborock Q Revo Saugroboter

Nicht auf Lager* Mehr Infos

roborock Q8 Max Plus

Nicht auf Lager* Mehr Infos

roborock S8 Pro Ultra

Nicht auf Lager* Mehr Infos

roborock Q5 Pro

-25%

Nicht auf Lager* Mehr Infos

Alle Geräte von Roborock

Rowenta

Geräte von Rowenta

Alle Geräte von Rowenta

Sainlogic

Geräte von Sainlogic

Alle Geräte von Sainlogic

Samsung

Geräte von Samsung

Samsung SmartThings Hub (3. Generation)

Nicht auf Lager* Mehr Infos

Alle Geräte von Samsung

Shelly

Geräte von Shelly

6,5

Shelly TRV Smart Home Heizkörperthermostat

Nicht auf Lager* Zum Produkttest

9,0

Shelly Plug S

Nicht auf Lager* Zum Produkttest

8,0

Shelly RGBW2

-13%

Nicht auf Lager* Zum Produkttest

Alle Geräte von Shelly

Sonoff

Geräte von Sonoff

SONOFF NSPanel

-23%

Nicht auf Lager* Mehr Infos

SONOFF SNZB-02 Mini-ZigBee Temperatur- und Feuchtigkeitssensor

Nicht auf Lager* Mehr Infos

SONOFF NSPanel Pro

Nicht auf Lager* Mehr Infos

SONOFF ZBMINIL2 Zigbee Smart Schalter (4 Stück)

Nicht auf Lager* Mehr Infos

Alle Geräte von Sonoff

SwitchBot

Geräte von SwitchBot

9,5

SwitchBot Bot - Smarter Kippschalter

Nicht auf Lager* Zum Produkttest

9,0

SwitchBot Hub Mini Smart Fernbedienung

Nicht auf Lager* Zum Produkttest

SwitchBot Minisaugroboter K10+ mit Absaugstation

Nicht auf Lager* Mehr Infos

SwitchBot Hub 2

Nicht auf Lager* Mehr Infos

Alle Geräte von SwitchBot

Tado

Geräte von Tado

tado° Smarte Klimaanlagen-Steuerung V3+

Nicht auf Lager*

tado° Starterset Fußbodenheizung

-19%

Nicht auf Lager*

7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%

Nicht auf Lager* Zum Produkttest

tado° Smartes Thermostat

-44%

Nicht auf Lager*

Alle Geräte von Tado

Tesvor

Geräte von Tesvor

Tesvor M2 Saugroboter mit Wischfunktion

-26%

Nicht auf Lager* Mehr Infos

8,2

Tesvor V300 Test

Nicht auf Lager* Zum Produkttest

Tesvor X500

Nicht auf Lager* Mehr Infos

Tesvor S7 Pro Saugroboter mit Wischfunktion

-33%

Nicht auf Lager* Mehr Infos

Alle Geräte von Tesvor

TFA Dostmann

Geräte von TFA Dostmann

Alle Geräte von TFA Dostmann

TP Link

Geräte von TP Link

Alle Geräte von TP Link

Wiser

Geräte von Wiser

8,0

Wiser Starter-Kit

Nicht auf Lager* Zum Produkttest

8,0

Wiser Plug Smart

Nicht auf Lager* Zum Produkttest

Alle Geräte von Wiser

Xiaomi

Geräte von Xiaomi

Alle Geräte von Xiaomi

334 Anfragen; Gesamtdauer: 121.67644500732 Millisekunden

Query	Dauer (ms)
SELECT * FROM user__session where (session_key = "9a54a7778b5c13e69da140fbb364e6cd" and session_expires > CURRENT_TIMESTAMP())	0.51307678222656
SELECT * FROM user__session where (session_key = "9a54a7778b5c13e69da140fbb364e6cd" and session_expires > CURRENT_TIMESTAMP())	0.23388862609863
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 = "hersteller" LIMIT 1	0.72503089904785
SELECT *, (brand_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(brand_date, "%d. %M %Y") as formatted_date FROM brand where (status = "publish" and visible_on_brand_page = 1) order by title asc	2.4468898773193
SELECT * FROM brand__meta where brand_id IN (47, 16, 39, 57, 27, 48, 20, 45, 9, 40, 44, 19, 14, 49, 1, 34, 12, 22, 60, 64, 2, 8, 28, 32, 38, 5, 41, 21, 54, 30, 36, 4, 7, 15, 3, 42, 29, 18, 10, 24)	2.0160675048828
SELECT brand.brand_id as id, anzahl FROM brand LEFT JOIN (SELECT brand__product_mapping.brand_id, count(*) as anzahl FROM brand__product_mapping group by brand__product_mapping.brand_id) a on a.brand_id = brand.brand_id	1.1539459228516
SELECT brand.* FROM brand where permalink in ("amazon");	0.52714347839355
SELECT * FROM brand__meta where brand_id IN (47)	0.16903877258301
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 order by RAND() limit 4	0.73599815368652
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.3058910369873
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.25105476379395
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 = 880 and smarthome_system.status = "publish"))	0.2748966217041
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.25105476379395
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 = 843 and smarthome_system.status = "publish"))	0.24318695068359
SELECT brand.* FROM brand where permalink in ("aqara");	0.31495094299316
SELECT * FROM brand__meta where brand_id IN (16)	0.17309188842773
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 (16)) group by product.product_id order by RAND() limit 4	0.81110000610352
SELECT * FROM product__meta where product_id IN (980)	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 = 980	0.25391578674316
SELECT brand.* FROM brand where permalink in ("blink");	0.21886825561523
SELECT * FROM brand__meta where brand_id IN (39)	0.20194053649902
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 (39)) group by product.product_id order by RAND() limit 4	0.3819465637207
SELECT brand.* FROM brand where permalink in ("bosch");	0.23388862609863
SELECT * FROM brand__meta where brand_id IN (57)	0.2129077911377
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 order by RAND() limit 4	0.49591064453125
SELECT brand.* FROM brand where permalink in ("bresser");	0.1981258392334
SELECT * FROM brand__meta where brand_id IN (27)	0.16212463378906
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 (27)) group by product.product_id order by RAND() limit 4	0.38599967956543
SELECT brand.* FROM brand where permalink in ("dreame");	0.20098686218262
SELECT * FROM brand__meta where brand_id IN (48)	0.20194053649902
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 (48)) group by product.product_id order by RAND() limit 4	0.57601928710938
SELECT * FROM product__meta where product_id IN (1007, 750, 1090, 1019)	0.87213516235352
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1007	0.18095970153809
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 = 1007 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.34713745117188
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1007	0.39505958557129
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1007	0.23102760314941
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 = 1007 and smarthome_system.status = "publish"))	0.29611587524414
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.29683113098145
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 750	0.34785270690918
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.27704238891602
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1090	0.17309188842773
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 = 1090 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.34308433532715
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1090	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 = 1090	0.28395652770996
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 = 1090 and smarthome_system.status = "publish"))	0.28800964355469
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1019	0.23388862609863
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 = 1019 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.35786628723145
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1019	0.31304359436035
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1019	0.28896331787109
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 = 1019 and smarthome_system.status = "publish"))	0.30398368835449
SELECT brand.* FROM brand where permalink in ("ecovacs");	0.3049373626709
SELECT * FROM brand__meta where brand_id IN (20)	0.2140998840332
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 (20)) group by product.product_id order by RAND() limit 4	0.60606002807617
SELECT * FROM product__meta where product_id IN (1036, 1095, 809, 638)	2.6369094848633
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1036	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 = 1036 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.39196014404297
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1036	0.29993057250977
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1036	0.25701522827148
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 = 1036 and smarthome_system.status = "publish"))	0.23388862609863
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1095	0.18095970153809
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 = 1095 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.27704238891602
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1095	0.29301643371582
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1095	0.21791458129883
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 = 1095 and smarthome_system.status = "publish"))	0.26583671569824
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 809	0.17595291137695
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 = 809 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.27799606323242
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 809	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 = 809	0.21195411682129
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 = 809 and smarthome_system.status = "publish"))	0.23794174194336
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 638	0.17905235290527
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 = 638 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.31304359436035
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 638	0.28491020202637
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 638	0.25320053100586
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 = 638 and smarthome_system.status = "publish"))	0.3049373626709
SELECT brand.* FROM brand where permalink in ("egardia");	0.26202201843262
SELECT * FROM brand__meta where brand_id IN (45)	0.17714500427246
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 (45)) group by product.product_id order by RAND() limit 4	0.57506561279297
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 209	0.32496452331543
SELECT brand.* FROM brand where permalink in ("elgato-eve");	0.23698806762695
SELECT * FROM brand__meta where brand_id IN (9)	0.19311904907227
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 (9)) group by product.product_id order by RAND() limit 4	0.43916702270508
SELECT brand.* FROM brand where permalink in ("eufy");	0.26392936706543
SELECT * FROM brand__meta where brand_id IN (40)	0.19693374633789
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 (40)) group by product.product_id order by RAND() limit 4	0.49591064453125
SELECT brand.* FROM brand where permalink in ("fibaro");	0.23102760314941
SELECT * FROM brand__meta where brand_id IN (44)	0.24795532226562
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 (44)) group by product.product_id order by RAND() limit 4	0.41294097900391
SELECT brand.* FROM brand where permalink in ("fritz-dect");	0.23293495178223
SELECT * FROM brand__meta where brand_id IN (19)	0.15783309936523
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 (19)) group by product.product_id order by RAND() limit 4	0.37598609924316
SELECT brand.* FROM brand where permalink in ("gardena");	0.20694732666016
SELECT * FROM brand__meta where brand_id IN (14)	0.19502639770508
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 (14)) group by product.product_id order by RAND() limit 4	0.43201446533203
SELECT brand.* FROM brand where permalink in ("google");	0.24008750915527
SELECT * FROM brand__meta where brand_id IN (49)	0.18906593322754
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 (49)) group by product.product_id order by RAND() limit 4	0.44822692871094
SELECT * FROM product__meta where product_id IN (771, 772, 768)	0.23984909057617
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 771	0.28705596923828
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 772	0.30612945556641
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 768	0.31495094299316
SELECT brand.* FROM brand where permalink in ("govee");	0.27990341186523
SELECT * FROM brand__meta where brand_id IN (1)	0.20289421081543
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 (1)) group by product.product_id order by RAND() limit 4	1.011848449707
SELECT * FROM product__meta where product_id IN (605, 1015, 1017, 937)	0.8089542388916
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 605	0.20098686218262
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 = 605 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.3199577331543
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 605	0.38504600524902
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 605	0.30398368835449
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 = 605 and smarthome_system.status = "publish"))	0.41413307189941
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015	0.27990341186523
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1017	0.18095970153809
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 = 1017 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.28395652770996
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1017	0.33378601074219
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1017	0.25796890258789
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 = 1017 and smarthome_system.status = "publish"))	0.30303001403809
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 937	0.18191337585449
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 = 937 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.33283233642578
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 937	0.29492378234863
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 937	0.24890899658203
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 = 937 and smarthome_system.status = "publish"))	0.26893615722656
SELECT brand.* FROM brand where permalink in ("husqvarna");	0.29897689819336
SELECT * FROM brand__meta where brand_id IN (34)	0.1990795135498
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 (34)) group by product.product_id order by RAND() limit 4	0.50806999206543
SELECT brand.* FROM brand where permalink in ("innr");	0.2748966217041
SELECT * FROM brand__meta where brand_id IN (12)	0.20885467529297
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 (12)) group by product.product_id order by RAND() limit 4	0.53691864013672
SELECT brand.* FROM brand where permalink in ("irobot");	0.25796890258789
SELECT * FROM brand__meta where brand_id IN (22)	0.19001960754395
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 (22)) group by product.product_id order by RAND() limit 4	0.47087669372559
SELECT * FROM product__meta where product_id IN (870)	0.56695938110352
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 870	0.2439022064209
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 = 870 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.31590461730957
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 870	0.34594535827637
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 870	0.23698806762695
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 = 870 and smarthome_system.status = "publish"))	0.23388862609863
SELECT brand.* FROM brand where permalink in ("klyqa");	0.2739429473877
SELECT * FROM brand__meta where brand_id IN (60)	0.21815299987793
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 (60)) group by product.product_id order by RAND() limit 4	0.52213668823242
SELECT * FROM product__meta where product_id IN (1012)	0.49996376037598
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1012	0.21195411682129
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 = 1012 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.73790550231934
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1012	0.30183792114258
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1012	0.30398368835449
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 = 1012 and smarthome_system.status = "publish"))	0.27680397033691
SELECT brand.* FROM brand where permalink in ("lytmi");	0.2598762512207
SELECT * FROM brand__meta where brand_id IN (64)	0.16403198242188
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 (64)) group by product.product_id order by RAND() limit 4	0.5190372467041
SELECT * FROM product__meta where product_id IN (945, 1011, 1001, 938)	1.2271404266357
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945	0.34093856811523
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1011	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 = 1011 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.33092498779297
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1011	0.39982795715332
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1011	0.23698806762695
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 = 1011 and smarthome_system.status = "publish"))	0.34189224243164
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1001	0.18000602722168
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 = 1001 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 = 1001	0.35190582275391
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1001	0.26798248291016
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 = 1001 and smarthome_system.status = "publish"))	0.24795532226562
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 938	0.40888786315918
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 = 938 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.3211498260498
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 938	0.28109550476074
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 938	0.22983551025391
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 = 938 and smarthome_system.status = "publish"))	0.26988983154297
SELECT brand.* FROM brand where permalink in ("meross");	0.37980079650879
SELECT * FROM brand__meta where brand_id IN (2)	0.20408630371094
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 (2)) group by product.product_id order by RAND() limit 4	0.68187713623047
SELECT * FROM product__meta where product_id IN (293, 531)	0.57196617126465
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.28181076049805
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 531	0.25796890258789
SELECT brand.* FROM brand where permalink in ("miyo");	0.25200843811035
SELECT * FROM brand__meta where brand_id IN (8)	0.18405914306641
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 (8)) group by product.product_id order by RAND() limit 4	0.42390823364258
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 210	0.27894973754883
SELECT brand.* FROM brand where permalink in ("netatmo");	0.23508071899414
SELECT * FROM brand__meta where brand_id IN (28)	0.20098686218262
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 (28)) group by product.product_id order by RAND() limit 4	0.52404403686523
SELECT * FROM product__meta where product_id IN (992, 1044, 1076, 1081)	0.6110668182373
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.35500526428223
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 992	0.3199577331543
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.28204917907715
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.24700164794922
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1076	0.24294853210449
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 = 1076 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.36787986755371
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1076	0.29611587524414
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1076	0.29516220092773
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 = 1076 and smarthome_system.status = "publish"))	0.2739429473877
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1081	0.18191337585449
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 = 1081 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.33807754516602
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1081	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 = 1081	0.26106834411621
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 = 1081 and smarthome_system.status = "publish"))	0.23698806762695
SELECT brand.* FROM brand where permalink in ("nuki");	0.25510787963867
SELECT * FROM brand__meta where brand_id IN (32)	0.1978874206543
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 (32)) group by product.product_id order by RAND() limit 4	0.55909156799316
SELECT * FROM product__meta where product_id IN (990, 988)	0.46300888061523
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 990	0.26702880859375
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 988	0.20217895507812
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 = 988 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.33712387084961
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 988	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 = 988	0.26416778564453
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 = 988 and smarthome_system.status = "publish"))	0.31185150146484
SELECT brand.* FROM brand where permalink in ("osram");	0.23794174194336
SELECT * FROM brand__meta where brand_id IN (38)	0.19621849060059
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 (38)) group by product.product_id order by RAND() limit 4	0.44703483581543
SELECT brand.* FROM brand where permalink in ("philips-hue");	0.26178359985352
SELECT * FROM brand__meta where brand_id IN (5)	0.18215179443359
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 (5)) group by product.product_id order by RAND() limit 4	0.59604644775391
SELECT * FROM product__meta where product_id IN (454, 209)	1.723051071167
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 454	0.22578239440918
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 = 454 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.39100646972656
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 454	0.28085708618164
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 454	0.22196769714355
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 = 454 and smarthome_system.status = "publish"))	0.37193298339844
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 209	0.244140625
SELECT brand.* FROM brand where permalink in ("ring");	0.23794174194336
SELECT * FROM brand__meta where brand_id IN (41)	0.19288063049316
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 (41)) group by product.product_id order by RAND() limit 4	0.45895576477051
SELECT brand.* FROM brand where permalink in ("roborock");	0.21100044250488
SELECT * FROM brand__meta where brand_id IN (21)	0.19097328186035
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 (21)) group by product.product_id order by RAND() limit 4	0.50091743469238
SELECT * FROM product__meta where product_id IN (1070, 1071, 1008, 1022)	0.70786476135254
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.37002563476562
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1070	0.37908554077148
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.29301643371582
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.26416778564453
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1071	0.20003318786621
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 = 1071 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.30708312988281
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1071	0.29611587524414
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1071	0.28610229492188
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 = 1071 and smarthome_system.status = "publish"))	0.26512145996094
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1008	0.28204917907715
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 = 1008 and smarthome_system.status = "publish"))	0.22697448730469
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1022	0.26607513427734
SELECT brand.* FROM brand where permalink in ("rowenta");	0.31113624572754
SELECT * FROM brand__meta where brand_id IN (54)	0.20980834960938
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 (54)) group by product.product_id order by RAND() limit 4	0.49519538879395
SELECT brand.* FROM brand where permalink in ("sainlogic");	0.27203559875488
SELECT * FROM brand__meta where brand_id IN (30)	0.23603439331055
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 (30)) group by product.product_id order by RAND() limit 4	0.35810470581055
SELECT brand.* FROM brand where permalink in ("samsung");	0.19979476928711
SELECT * FROM brand__meta where brand_id IN (36)	0.16117095947266
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 (36)) group by product.product_id order by RAND() limit 4	0.43988227844238
SELECT * FROM product__meta where product_id IN (862)	0.23603439331055
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 862	0.19383430480957
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 = 862 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 = 862	0.27799606323242
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 862	0.23508071899414
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 = 862 and smarthome_system.status = "publish"))	0.25796890258789
SELECT brand.* FROM brand where permalink in ("shelly");	0.23317337036133
SELECT * FROM brand__meta where brand_id IN (4)	0.18811225891113
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 (4)) group by product.product_id order by RAND() limit 4	0.52380561828613
SELECT * FROM product__meta where product_id IN (590, 292, 301)	1.4228820800781
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.29110908508301
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 292	0.26392936706543
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 301	0.18906593322754
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 = 301 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.30398368835449
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 301	0.27894973754883
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 301	0.24604797363281
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 = 301 and smarthome_system.status = "publish"))	0.36907196044922
SELECT brand.* FROM brand where permalink in ("sonoff");	0.29897689819336
SELECT * FROM brand__meta where brand_id IN (7)	0.18095970153809
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 (7)) group by product.product_id order by RAND() limit 4	0.54001808166504
SELECT * FROM product__meta where product_id IN (993, 919, 918, 917)	1.2400150299072
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 993	0.37288665771484
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 919	0.27799606323242
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 918	0.2439022064209
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 917	0.30899047851562
SELECT brand.* FROM brand where permalink in ("switchbot");	0.26798248291016
SELECT * FROM brand__meta where brand_id IN (15)	0.2439022064209
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 (15)) group by product.product_id order by RAND() limit 4	0.67496299743652
SELECT * FROM product__meta where product_id IN (492, 494, 1038, 762)	1.1699199676514
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.30517578125
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 494	0.24294853210449
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1038	0.32901763916016
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 = 1038 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.36811828613281
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1038	0.33283233642578
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1038	0.30016899108887
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 = 1038 and smarthome_system.status = "publish"))	0.30016899108887
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 762	0.21791458129883
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 = 762 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.26202201843262
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 762	0.29301643371582
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 762	0.23794174194336
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 = 762 and smarthome_system.status = "publish"))	0.27108192443848
SELECT brand.* FROM brand where permalink in ("tado");	0.54287910461426
SELECT * FROM brand__meta where brand_id IN (3)	0.2129077911377
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 (3)) group by product.product_id order by RAND() limit 4	0.57196617126465
SELECT * FROM product__meta where product_id IN (258, 76, 933, 75)	1.8939971923828
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 258	0.21600723266602
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 = 258 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.40793418884277
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 258	0.43511390686035
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 258	0.31590461730957
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 = 258 and smarthome_system.status = "publish"))	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 = 76	0.25701522827148
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.41294097900391
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.30398368835449
SELECT brand.* FROM brand where permalink in ("tesvor");	0.27179718017578
SELECT * FROM brand__meta where brand_id IN (42)	0.21910667419434
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 (42)) group by product.product_id order by RAND() limit 4	0.76007843017578
SELECT * FROM product__meta where product_id IN (1075, 288, 240, 1092)	3.3469200134277
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1075	0.26702880859375
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 = 1075 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.34284591674805
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1075	0.3662109375
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1075	0.23198127746582
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 = 1075 and smarthome_system.status = "publish"))	0.3349781036377
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 288	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 = 288 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.29206275939941
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 288	0.30183792114258
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 288	0.21100044250488
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 = 288 and smarthome_system.status = "publish"))	0.30016899108887
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 240	0.18596649169922
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 = 240 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.29611587524414
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 240	0.31685829162598
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 240	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 = 240 and smarthome_system.status = "publish"))	0.2899169921875
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1092	0.19216537475586
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 = 1092 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.37193298339844
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1092	0.42986869812012
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1092	0.27298927307129
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 = 1092 and smarthome_system.status = "publish"))	0.27203559875488
SELECT brand.* FROM brand where permalink in ("tfa-dostmann");	0.28705596923828
SELECT * FROM brand__meta where brand_id IN (29)	0.18405914306641
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 (29)) group by product.product_id order by RAND() limit 4	0.52809715270996
SELECT brand.* FROM brand where permalink in ("tp-link");	0.28896331787109
SELECT * FROM brand__meta where brand_id IN (18)	0.20813941955566
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 (18)) group by product.product_id order by RAND() limit 4	0.38695335388184
SELECT brand.* FROM brand where permalink in ("wiser");	0.2291202545166
SELECT * FROM brand__meta where brand_id IN (10)	0.18000602722168
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 (10)) group by product.product_id order by RAND() limit 4	0.4730224609375
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 242	0.27918815612793
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 253	0.24700164794922
SELECT brand.* FROM brand where permalink in ("xiaomi");	0.2129077911377
SELECT * FROM brand__meta where brand_id IN (24)	0.17094612121582
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 (24)) group by product.product_id order by RAND() limit 4	0.43201446533203

Smarthome Hersteller in der Übersicht

Amazon

Geräte von Amazon

Aqara

Geräte von Aqara

Blink

Geräte von Blink

Bosch

Geräte von Bosch

Bresser

Geräte von Bresser

Dreame

Geräte von Dreame

Ecovacs

Geräte von Ecovacs

Egardia

Geräte von Egardia

Elgato Eve

Geräte von Elgato Eve

eufy

Geräte von eufy

Fibaro

Geräte von Fibaro

Fritz!Dect

Geräte von Fritz!Dect

Gardena

Geräte von Gardena

Google

Geräte von Google

Govee

Geräte von Govee

Husqvarna

Geräte von Husqvarna

Innr

Geräte von Innr

iRobot

Geräte von iRobot

Klyqa

Geräte von Klyqa

Lytmi

Geräte von Lytmi

Meross

Geräte von Meross

MIYO

Geräte von MIYO

Netatmo

Geräte von Netatmo

Nuki

Geräte von Nuki

Osram

Geräte von Osram

Philips Hue

Geräte von Philips Hue

Ring

Geräte von Ring

Roborock

Geräte von Roborock

Rowenta

Geräte von Rowenta

Sainlogic

Geräte von Sainlogic

Samsung

Geräte von Samsung

Shelly

Geräte von Shelly

Sonoff

Geräte von Sonoff

SwitchBot

Geräte von SwitchBot

Tado

Geräte von Tado

Tesvor

Geräte von Tesvor

TFA Dostmann

Geräte von TFA Dostmann

TP Link

Geräte von TP Link

Wiser

Geräte von Wiser

Xiaomi