Smart Home Hersteller 🏅 in der Übersicht

[smarthome_hersteller anchor_link="true"]

Amazon

Geräte von Amazon

Echo Hub | Smart-Home-Panel mit Alexa

Nicht auf Lager* Mehr Infos

5,0

Echo Auto 2

Nicht auf Lager* Zum Produkttest

8,5

Echo Show 15

-32%

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 Saugroboter mit selbstreinigender Station

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 Saugroboter mit Wischfunktion

-18%

Nicht auf Lager* Mehr Infos

Alle Geräte von Dreame

Ecovacs

Geräte von Ecovacs

ECOVACS AIRBOT Z1 Luftreiniger-Roboter

Nicht auf Lager* Mehr Infos

ECOVACS Goat G1 Mähroboter (bis 1600 qm)

-14%

Nicht auf Lager* Mehr Infos

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

Nicht auf Lager* Mehr Infos

ECOVACS DEEBOT T10+ Saug- & Wischroboter

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 Mini Smart Speaker

Bei MediaMarkt ansehen*

Google Nest Audio Smart Speaker

Bei MediaMarkt ansehen*

Google Nest Hub (2. Generation)

Bei Tink ansehen*

Alle Geräte von Google

Govee

Geräte von Govee

Govee Sternenhimmel Projektor (Alexa & Google Home)

Nicht auf Lager* Mehr Infos

Govee AI Sync Box 27-34 Zoll mit Lightbar

Nicht auf Lager* Mehr Infos

Govee Outdoor Neon LED Strip 10m

-35%

Nicht auf Lager* Mehr Infos

9,0

Govee AI Gaming Sync Box 55-65 Zoll

Nicht auf Lager* Zum Produkttest

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 Smart RGB LED Lightbar

Nicht auf Lager* Mehr Infos

Lytmi Fantasy 3 55~60 Zoll

Nicht auf Lager* Mehr Infos

Lytmi Fantasy 65~70 Zoll

Nicht auf Lager* Mehr Infos

Lytmi Neo Sync Box

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

Netatmo Smart Key (1Stück)

-11%

Bei Tink ansehen*

5,0

Netatmo Smartes Türschloss

-21%

Bei Tink ansehen* Zum Produkttest

8,0

Netatmo smarter Raumluftsensor

-35%

Nicht auf Lager* Zum Produkttest

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 Q5 Pro

-25%

Nicht auf Lager* Mehr Infos

roborock S8 Pro Ultra

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

8,0

Shelly RGBW2

-13%

Nicht auf Lager* Zum Produkttest

9,0

Shelly Plug S

Nicht auf Lager* Zum Produkttest

Alle Geräte von Shelly

Sonoff

Geräte von Sonoff

SONOFF ZBMINIL2 Zigbee Smart Schalter (4 Stück)

Nicht auf Lager* Mehr Infos

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

Alle Geräte von Sonoff

SwitchBot

Geräte von SwitchBot

SwitchBot Minisaugroboter K10+ mit Absaugstation

Nicht auf Lager* Mehr Infos

SwitchBot Curtain 3 Vorhangmotor

Nicht auf Lager* Mehr Infos

SwitchBot Hub 2

Nicht auf Lager* Mehr Infos

9,0

SwitchBot Indoor Cam

Nicht auf Lager* Zum Produkttest

Alle Geräte von SwitchBot

Tado

Geräte von Tado

7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%

Nicht auf Lager* Zum Produkttest

tado° Starterset Eigenheim

Nicht auf Lager*

tado° Smarte Klimaanlagen-Steuerung V3+

Nicht auf Lager*

tado° Starterset Fußbodenheizung

-19%

Nicht auf Lager*

Alle Geräte von Tado

Tesvor

Geräte von Tesvor

Tesvor X500

Nicht auf Lager* Mehr Infos

Tesvor S7 Pro Saugroboter mit Wischfunktion und Absaugstation

Nicht auf Lager* Mehr Infos

Tesvor S7 Pro Saugroboter mit Wischfunktion

-33%

Nicht auf Lager* Mehr Infos

8,2

Tesvor V300 Test

Nicht auf Lager* Zum Produkttest

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 Plug Smart

Nicht auf Lager* Zum Produkttest

8,0

Wiser Starter-Kit

Nicht auf Lager* Zum Produkttest

Alle Geräte von Wiser

Xiaomi

Geräte von Xiaomi

Alle Geräte von Xiaomi

469 Anfragen; Gesamtdauer: 218.91593933105 Millisekunden

Query	Dauer (ms)
SELECT * FROM user__session where (session_key = "c17395b0185fdd101ff06ceab41cca14" and session_expires > CURRENT_TIMESTAMP())	1.5270709991455
SELECT * FROM user__session where (session_key = "c17395b0185fdd101ff06ceab41cca14" and session_expires > CURRENT_TIMESTAMP())	0.24914741516113
SELECT * FROM redirect	1.3787746429443
SELECT * FROM tracking_code	1.291036605835
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	4.2951107025146
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	5.8109760284424
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)	4.6219825744629
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.9490718841553
SELECT brand.* FROM brand where permalink in ("amazon");	0.47111511230469
SELECT * FROM brand__meta where brand_id IN (47)	0.19407272338867
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	7.0919990539551
SELECT * FROM product__meta where product_id IN (880, 843, 540)	3.5040378570557
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 880	0.43988227844238
SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 880 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	1.1069774627686
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 880	2.0160675048828
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.63920021057129
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.80108642578125
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 843	0.22506713867188
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 = 843 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.44894218444824
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 843	1.0130405426025
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.32496452331543
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.31590461730957
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 540	0.27894973754883
SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 540 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	0.36191940307617
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540	0.89383125305176
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540	0.3361701965332
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 540 and smarthome_system.status = "publish"))	1.0759830474854
SELECT * FROM product__taxonomy where (status = "publish") order by title ASC	2.9020309448242
SELECT file_path FROM attachment where attachment_id = 1014	1.0619163513184
SELECT file_path FROM attachment where attachment_id = 1013	0.24700164794922
SELECT brand.* FROM brand where permalink in ("aqara");	0.33020973205566
SELECT * FROM brand__meta where brand_id IN (16)	0.26202201843262
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	1.5919208526611
SELECT * FROM product__meta where product_id IN (980)	0.71501731872559
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 980	0.31399726867676
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 = 980 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.41317939758301
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 980	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 = 980	0.25415420532227
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 = 980 and smarthome_system.status = "publish"))	0.30398368835449
SELECT brand.* FROM brand where permalink in ("blink");	0.34189224243164
SELECT * FROM brand__meta where brand_id IN (39)	0.28085708618164
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	1.2869834899902
SELECT brand.* FROM brand where permalink in ("bosch");	0.24986267089844
SELECT * FROM brand__meta where brand_id IN (57)	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 (57)) group by product.product_id order by RAND() limit 4	1.427173614502
SELECT brand.* FROM brand where permalink in ("bresser");	0.22006034851074
SELECT * FROM brand__meta where brand_id IN (27)	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 (27)) group by product.product_id order by RAND() limit 4	0.7171630859375
SELECT brand.* FROM brand where permalink in ("dreame");	0.21600723266602
SELECT * FROM brand__meta where brand_id IN (48)	0.17905235290527
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	2.3679733276367
SELECT * FROM product__meta where product_id IN (1021, 750, 1090, 1020)	1.4450550079346
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1021	0.18692016601562
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 = 1021 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.32591819763184
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1021	0.55408477783203
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1021	0.22411346435547
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 = 1021 and smarthome_system.status = "publish"))	0.26512145996094
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 750	0.15997886657715
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.30016899108887
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 750	0.60415267944336
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.21004676818848
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 750 and smarthome_system.status = "publish"))	0.30112266540527
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1090	0.18501281738281
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.30016899108887
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1090	0.26702880859375
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.21719932556152
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.24104118347168
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1020	0.20599365234375
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 = 1020 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.28896331787109
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1020	0.25582313537598
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1020	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 = 1020 and smarthome_system.status = "publish"))	0.28181076049805
SELECT brand.* FROM brand where permalink in ("ecovacs");	0.2739429473877
SELECT * FROM brand__meta where brand_id IN (20)	0.2741813659668
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	1.5978813171387
SELECT * FROM product__meta where product_id IN (809, 1046, 1095, 1036)	1.8720626831055
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 809	0.23198127746582
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.34594535827637
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 809	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 = 809	0.23984909057617
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.29397010803223
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1046	0.16403198242188
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 = 1046 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.31805038452148
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1046	0.28896331787109
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1046	0.24914741516113
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 = 1046 and smarthome_system.status = "publish"))	0.2741813659668
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1095	0.19097328186035
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.29897689819336
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1095	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 = 1095	0.22697448730469
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.22602081298828
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1036	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 = 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.34689903259277
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1036	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 = 1036	0.2140998840332
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.27799606323242
SELECT brand.* FROM brand where permalink in ("egardia");	0.25701522827148
SELECT * FROM brand__meta where brand_id IN (45)	0.18310546875
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	1.0719299316406
SELECT * FROM product__meta where product_id IN (209)	1.6119480133057
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 209	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 = 209 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.35595893859863
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 209	0.84710121154785
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.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 = 209 and smarthome_system.status = "publish"))	0.28705596923828
SELECT brand.* FROM brand where permalink in ("elgato-eve");	0.24986267089844
SELECT * FROM brand__meta where brand_id IN (9)	0.20313262939453
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.50711631774902
SELECT brand.* FROM brand where permalink in ("eufy");	0.24509429931641
SELECT * FROM brand__meta where brand_id IN (40)	0.26416778564453
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.54407119750977
SELECT brand.* FROM brand where permalink in ("fibaro");	0.25510787963867
SELECT * FROM brand__meta where brand_id IN (44)	0.18310546875
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	1.0159015655518
SELECT brand.* FROM brand where permalink in ("fritz-dect");	0.27799606323242
SELECT * FROM brand__meta where brand_id IN (19)	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 (19)) group by product.product_id order by RAND() limit 4	0.51999092102051
SELECT brand.* FROM brand where permalink in ("gardena");	0.20885467529297
SELECT * FROM brand__meta where brand_id IN (14)	0.17189979553223
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.39792060852051
SELECT brand.* FROM brand where permalink in ("google");	0.21696090698242
SELECT * FROM brand__meta where brand_id IN (49)	0.17881393432617
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.41890144348145
SELECT * FROM product__meta where product_id IN (772, 771, 768)	0.53501129150391
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 772	0.21696090698242
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 = 772 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.69212913513184
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 772	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.20790100097656
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 = 772 and smarthome_system.status = "publish"))	0.23794174194336
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 771	0.18477439880371
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 = 771 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.32711029052734
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 771	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 = 771	0.22792816162109
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 = 771 and smarthome_system.status = "publish"))	0.27799606323242
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 768	0.18501281738281
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 = 768 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.29492378234863
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 768	0.25606155395508
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.2281665802002
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 = 768 and smarthome_system.status = "publish"))	0.2601146697998
SELECT brand.* FROM brand where permalink in ("govee");	0.20909309387207
SELECT * FROM brand__meta where brand_id IN (1)	0.15902519226074
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	2.1679401397705
SELECT * FROM product__meta where product_id IN (1014, 944, 1006, 936)	1.446008682251
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1014	0.23102760314941
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 = 1014 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 = 1014	0.32901763916016
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1014	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 = 1014 and smarthome_system.status = "publish"))	0.23603439331055
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 944	0.17499923706055
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 = 944 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.26798248291016
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 944	0.28300285339355
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 944	0.22292137145996
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 = 944 and smarthome_system.status = "publish"))	0.29897689819336
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1006	0.15807151794434
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 = 1006 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.54097175598145
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1006	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 = 1006	0.24008750915527
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 = 1006 and smarthome_system.status = "publish"))	0.24509429931641
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 936	0.18501281738281
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 = 936 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.54502487182617
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 936	0.3659725189209
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 936	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 = 936 and smarthome_system.status = "publish"))	0.22482872009277
SELECT file_path FROM attachment where attachment_id = 1015	0.23698806762695
SELECT brand.* FROM brand where permalink in ("husqvarna");	0.22697448730469
SELECT * FROM brand__meta where brand_id IN (34)	0.16593933105469
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.46801567077637
SELECT brand.* FROM brand where permalink in ("innr");	0.22292137145996
SELECT * FROM brand__meta where brand_id IN (12)	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 (12)) group by product.product_id order by RAND() limit 4	0.43201446533203
SELECT brand.* FROM brand where permalink in ("irobot");	0.26488304138184
SELECT * FROM brand__meta where brand_id IN (22)	0.20003318786621
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.52118301391602
SELECT * FROM product__meta where product_id IN (870)	0.71811676025391
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 870	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 = 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.32210350036621
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 870	0.30398368835449
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.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 = 870 and smarthome_system.status = "publish"))	0.24986267089844
SELECT brand.* FROM brand where permalink in ("klyqa");	0.23412704467773
SELECT * FROM brand__meta where brand_id IN (60)	0.22101402282715
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.46896934509277
SELECT * FROM product__meta where product_id IN (1012)	0.54192543029785
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1012	0.21886825561523
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.32901763916016
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1012	0.33092498779297
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.29611587524414
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.28085708618164
SELECT brand.* FROM brand where permalink in ("lytmi");	0.25415420532227
SELECT * FROM brand__meta where brand_id IN (64)	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 (64)) group by product.product_id order by RAND() limit 4	0.51999092102051
SELECT * FROM product__meta where product_id IN (1001, 938, 945, 1011)	1.2669563293457
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1001	0.22196769714355
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.31089782714844
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1001	0.38290023803711
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.24199485778809
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.23603439331055
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 938	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 = 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.45299530029297
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 938	0.42605400085449
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.27894973754883
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.2601146697998
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 945	0.18477439880371
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 = 945 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.35595893859863
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945	0.40602684020996
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945	0.27894973754883
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 = 945 and smarthome_system.status = "publish"))	0.29993057250977
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1011	0.41699409484863
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.2748966217041
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1011	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 = 1011	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 = 1011 and smarthome_system.status = "publish"))	0.24795532226562
SELECT brand.* FROM brand where permalink in ("meross");	0.25391578674316
SELECT * FROM brand__meta where brand_id IN (2)	0.19598007202148
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.89716911315918
SELECT * FROM product__meta where product_id IN (293, 531)	1.7669200897217
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 293	0.2598762512207
SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 293 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	0.29993057250977
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293	0.71287155151367
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.23293495178223
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 293 and smarthome_system.status = "publish"))	0.23794174194336
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 531	0.1981258392334
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 = 531 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 = 531	0.3659725189209
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.27894973754883
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 = 531 and smarthome_system.status = "publish"))	0.26512145996094
SELECT file_path FROM attachment where attachment_id = 1018	0.20503997802734
SELECT brand.* FROM brand where permalink in ("miyo");	0.20885467529297
SELECT * FROM brand__meta where brand_id IN (8)	0.17213821411133
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.52309036254883
SELECT * FROM product__meta where product_id IN (210)	1.2359619140625
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 210	0.2288818359375
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 = 210 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 = 210	0.32901763916016
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 210	0.20217895507812
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 = 210 and smarthome_system.status = "publish"))	0.29802322387695
SELECT brand.* FROM brand where permalink in ("netatmo");	0.27203559875488
SELECT * FROM brand__meta where brand_id IN (28)	0.16283988952637
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.64611434936523
SELECT * FROM product__meta where product_id IN (1076, 1044, 992, 1081)	0.87904930114746
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1076	0.22101402282715
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.30207633972168
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1076	0.29516220092773
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.24795532226562
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.22006034851074
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1044	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 = 1044 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	0.26297569274902
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044	0.25391578674316
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.21505355834961
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1044 and smarthome_system.status = "publish"))	0.27704238891602
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 992	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 = 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.2601146697998
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 992	0.23794174194336
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.19001960754395
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 992 and smarthome_system.status = "publish"))	0.2291202545166
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1081	0.1528263092041
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.26416778564453
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1081	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 = 1081	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 = 1081 and smarthome_system.status = "publish"))	0.23603439331055
SELECT file_path FROM attachment where attachment_id = 1025	0.25415420532227
SELECT brand.* FROM brand where permalink in ("nuki");	0.24104118347168
SELECT * FROM brand__meta where brand_id IN (32)	0.16307830810547
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.48685073852539
SELECT * FROM product__meta where product_id IN (990, 988)	0.69689750671387
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 990	0.2131462097168
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 = 990 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.36501884460449
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 990	0.51999092102051
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.24104118347168
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 = 990 and smarthome_system.status = "publish"))	0.32711029052734
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 988	0.16999244689941
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.29206275939941
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 988	0.28800964355469
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.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 = 988 and smarthome_system.status = "publish"))	0.22602081298828
SELECT brand.* FROM brand where permalink in ("osram");	0.23221969604492
SELECT * FROM brand__meta where brand_id IN (38)	0.1828670501709
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.57005882263184
SELECT brand.* FROM brand where permalink in ("philips-hue");	0.26512145996094
SELECT * FROM brand__meta where brand_id IN (5)	0.18310546875
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.65803527832031
SELECT * FROM product__meta where product_id IN (454, 209)	1.6419887542725
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 454	0.22602081298828
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.32281875610352
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 454	0.4570484161377
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.23293495178223
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.23007392883301
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.20885467529297
SELECT brand.* FROM brand where permalink in ("ring");	0.2439022064209
SELECT * FROM brand__meta where brand_id IN (41)	0.18787384033203
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.43702125549316
SELECT brand.* FROM brand where permalink in ("roborock");	0.23317337036133
SELECT * FROM brand__meta where brand_id IN (21)	0.18882751464844
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.53501129150391
SELECT * FROM product__meta where product_id IN (1070, 1071, 1022, 1008)	1.101016998291
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1070	0.2138614654541
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.29397010803223
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1070	0.36787986755371
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.22292137145996
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.26702880859375
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1071	0.15997886657715
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.3359317779541
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1071	0.28395652770996
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.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 = 1071 and smarthome_system.status = "publish"))	0.2601146697998
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1022	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 = 1022 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.34689903259277
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1022	0.26798248291016
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.28681755065918
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 = 1022 and smarthome_system.status = "publish"))	0.26607513427734
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1008	0.17189979553223
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 = 1008 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.25796890258789
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1008	0.26702880859375
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.26988983154297
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.21696090698242
SELECT brand.* FROM brand where permalink in ("rowenta");	0.26202201843262
SELECT * FROM brand__meta where brand_id IN (54)	0.17404556274414
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.4420280456543
SELECT brand.* FROM brand where permalink in ("sainlogic");	0.20813941955566
SELECT * FROM brand__meta where brand_id IN (30)	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 (30)) group by product.product_id order by RAND() limit 4	0.36501884460449
SELECT brand.* FROM brand where permalink in ("samsung");	0.18906593322754
SELECT * FROM brand__meta where brand_id IN (36)	0.15997886657715
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.44107437133789
SELECT * FROM product__meta where product_id IN (862)	0.51212310791016
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 862	0.19717216491699
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.32591819763184
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 862	0.32615661621094
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.26893615722656
SELECT brand.* FROM brand where permalink in ("shelly");	0.31208992004395
SELECT * FROM brand__meta where brand_id IN (4)	0.17786026000977
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	1.05881690979
SELECT * FROM product__meta where product_id IN (590, 301, 292)	2.3939609527588
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 590	0.21505355834961
SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 590 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	0.37980079650879
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590	0.34689903259277
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.27203559875488
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 590 and smarthome_system.status = "publish"))	0.26798248291016
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 301	0.20194053649902
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.27704238891602
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 301	0.51379203796387
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.22697448730469
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.2598762512207
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 292	0.26798248291016
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 = 292 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.34880638122559
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 292	0.33092498779297
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.35595893859863
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 = 292 and smarthome_system.status = "publish"))	0.35309791564941
SELECT file_path FROM attachment where attachment_id = 1019	0.26488304138184
SELECT brand.* FROM brand where permalink in ("sonoff");	0.25701522827148
SELECT * FROM brand__meta where brand_id IN (7)	0.17595291137695
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.85783004760742
SELECT * FROM product__meta where product_id IN (917, 993, 919, 918)	1.0011196136475
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 917	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 = 917 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 = 917	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 = 917	0.22101402282715
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 = 917 and smarthome_system.status = "publish"))	0.26392936706543
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 993	0.16307830810547
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 = 993 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.26798248291016
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 993	0.30016899108887
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.27084350585938
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 = 993 and smarthome_system.status = "publish"))	0.28896331787109
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 919	0.20909309387207
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 = 919 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.31018257141113
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 919	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 = 919	0.27203559875488
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 919 and smarthome_system.status = "publish"))	0.30803680419922
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 918	0.18215179443359
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 = 918 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.33998489379883
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 918	0.28514862060547
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.23293495178223
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 = 918 and smarthome_system.status = "publish"))	0.24700164794922
SELECT brand.* FROM brand where permalink in ("switchbot");	0.29301643371582
SELECT * FROM brand__meta where brand_id IN (15)	0.20694732666016
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.9009838104248
SELECT * FROM product__meta where product_id IN (1038, 996, 762, 14)	1.924991607666
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1038	0.20313262939453
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.38909912109375
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1038	0.40292739868164
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.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 = 1038 and smarthome_system.status = "publish"))	0.3209114074707
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 996	0.23484230041504
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 = 996 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.39815902709961
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 996	0.37097930908203
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 996	0.37980079650879
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 = 996 and smarthome_system.status = "publish"))	0.36191940307617
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 762	0.22006034851074
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.36406517028809
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 762	0.36096572875977
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.30899047851562
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.31399726867676
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 14	0.22602081298828
SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 14 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	0.36311149597168
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14	0.75411796569824
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14	0.30803680419922
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 14 and smarthome_system.status = "publish"))	0.33307075500488
SELECT brand.* FROM brand where permalink in ("tado");	0.3349781036377
SELECT * FROM brand__meta where brand_id IN (3)	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 (3)) group by product.product_id order by RAND() limit 4	0.70309638977051
SELECT * FROM product__meta where product_id IN (933, 72, 258, 76)	4.1160583496094
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 933	0.33402442932129
SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 933 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC	0.49185752868652
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933	0.43106079101562
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.32615661621094
SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 933 and smarthome_system.status = "publish"))	0.37407875061035
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 72	0.22411346435547
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 = 72 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.41484832763672
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 72	0.36907196044922
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 72	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 = 72 and smarthome_system.status = "publish"))	0.33903121948242
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 258	0.22101402282715
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.37503242492676
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 258	0.40292739868164
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.2748966217041
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 AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 76	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 = 76 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.3659725189209
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 76	0.34308433532715
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.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 = 76 and smarthome_system.status = "publish"))	0.36096572875977
SELECT brand.* FROM brand where permalink in ("tesvor");	0.3809928894043
SELECT * FROM brand__meta where brand_id IN (42)	0.24199485778809
SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id 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	1.1551380157471
SELECT * FROM product__meta where product_id IN (240, 1034, 1092, 288)	2.6519298553467
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 240	0.29516220092773
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.36501884460449
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 240	0.39792060852051
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.30303001403809
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.30684471130371
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1034	0.21815299987793
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 = 1034 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.43988227844238
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1034	0.34713745117188
SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1034	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 = 1034 and smarthome_system.status = "publish"))	0.3209114074707
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1092	0.24199485778809
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.3809928894043
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1092	0.42486190795898
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.28300285339355
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.30303001403809
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 288	0.22697448730469
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.3511905670166
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 288	0.44083595275879
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.3819465637207
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.30803680419922
SELECT brand.* FROM brand where permalink in ("tfa-dostmann");	0.33307075500488
SELECT * FROM brand__meta where brand_id IN (29)	0.25701522827148
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.56195259094238
SELECT brand.* FROM brand where permalink in ("tp-link");	0.2899169921875
SELECT * FROM brand__meta where brand_id IN (18)	0.23508071899414
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.55098533630371
SELECT brand.* FROM brand where permalink in ("wiser");	0.32591819763184
SELECT * FROM brand__meta where brand_id IN (10)	0.69499015808105
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	1.0559558868408
SELECT * FROM product__meta where product_id IN (253, 242)	3.47900390625
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 253	0.31614303588867
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 = 253 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 = 253	0.83398818969727
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.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 = 253 and smarthome_system.status = "publish"))	0.29897689819336
SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 242	0.67615509033203
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 = 242 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.39005279541016
SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 242	0.3509521484375
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.3049373626709
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 = 242 and smarthome_system.status = "publish"))	0.2601146697998
SELECT brand.* FROM brand where permalink in ("xiaomi");	0.36287307739258
SELECT * FROM brand__meta where brand_id IN (24)	0.28896331787109
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.51498413085938

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