Smarte Glühbirne



Produkte jetzt ansehen

Wer in seinem Smarthome durch die richtige Beleuchtung für eine angenehme Atmosphäre sorgen möchte, der kommt um smarte Glühbirnen keinesfalls herum!

Egal ob du Deckenspots, Hängelampen oder deine Nachttisch-Lampe smart machen willst - mit der richtigen Glühbirne ist das kein Problem!

Dank Sprachsteuerung per Alexa, Google Home & Siri lassen sich alle Leuchten im Handumdrehen ganz einfach steuern - natürlich auch per App.

Es gibt eine Vielzahl an unterschiedlichen smarten Lampen, die sich vor allem in der Lampenfassung, der Leuchtkraft und den kompatiblen Systemen unterscheiden.

Welche Smart Home Lampen?

Welche smarten Lampen gibt es denn eigentlich? Die meisten Lampen unterscheiden sich in den folgenden Punkten:

Die unterschiedlichen Lampenfassungen:

 E27  E14  GU10  B22

Zu den gängigsten Systemen zählen:

 WLAN  ZigBee  Hue  HomeKit

Lampen für deinen Sprachassistenten:

 Amazon Alexa  Google Home  Apple Siri

Falls du noch unschlüssig bist, welche smarte Glühbirne die richtige für dich ist, kannst du auch unseren Kaufberater benutzen oder dir die beliebtesten Glühbirnen unserer Community ansehen.

Zum Lampen-Kaufberater  Zu den beliebtesten smarten Lampen 

Einige smarte Glühbirnen habe ich auch schon ausgiebig getestet:

Smarte Glühbirnen im Test 

Arten von smarten Glühbirnen

Im folgenden Abschnitt möchte ich dir die gängigen Arten von Lampen vorstellen. Egal ob E27, E14 oder Deckenspots - für dein Smarthome System und deinen Sprachassistenten gibt es bestimmt die richtige Lampe!

Die meisten smarten Lampen sind dimmbar und einige Modelle können darüber hinaus auch alle möglichen Farben darstellen.

Smarte Glühbirne E27

Lampen mit einer E27-Fassung passen in die meisten handelsüblichen Lampenschirme. Sie besitzen ein Gewinde und werden einfach in den Sockel geschraubt - die Installation ist also unfassbar einfach!

Gledopto E27 Glühbirne

E27-Lampen haben meistens eine rundliche, sogar tropfen-ähnliche Form.

Philips Hue White E27 LED-Starterset

Philips Hue White E27 LED-Starterset

  Nicht auf Lager*
LIFX intelligente Glühbrine dimmbar, RGBW (E27)

LIFX intelligente Glühbrine dimmbar, RGBW (E27)

  Nicht auf Lager*

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager*
Innr E27 Smart LED Lampe

Innr E27 Smart LED Lampe

  Nicht auf Lager*
Innr E27 Smart RGB-LED Lampe

Innr E27 Smart RGB-LED Lampe

  Nicht auf Lager*
Govee Alexa Smarte Glühbirne E27 (4er Set)

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

  Nicht auf Lager*
LIFX Mini WLAN-Lampe dimmbar, RGBW (E27)

LIFX Mini WLAN-Lampe dimmbar, RGBW (E27)

  Nicht auf Lager*

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager*

Smarte Glühbirne E14

E14-Lampen besitzen (genau wie E27-Lampen) ebenfalls ein Gewinde. Dieses ist jedoch deutlich kleiner.

Außerdem sind Lampen im E14-Format häufig kerzenförmig - deswegen sind sie auch als Kerzenlampe bekannt. Im folgenden Bild sind die unterschiedlichen Gewinde-Größen und die Kerzenform der E14-Glühbirne deutlich sichtbar:

E14 E27 Glühbirne Vergleich

Die Linke Lampe ist im E14-Format, während die rechte Lampe für E27-Sockel passt.

WLAN RGBW-Lampe E14

WLAN RGBW-Lampe E14

  Nicht auf Lager*
Innr E14 Smart LED Kerze

Innr E14 Smart LED Kerze

  Nicht auf Lager*
MoKo WLAN Smart Led Lampe E14

MoKo WLAN Smart Led Lampe E14

  Nicht auf Lager*

 8,0

Gledopto LED E14 RGB CCT-Lampe

Gledopto LED E14 RGB CCT-Lampe

  Nicht auf Lager*
LE 4.5W Smart E14 LED Lampe

LE 4.5W Smart E14 LED Lampe

  Nicht auf Lager*

 8,0

LED-Farbwechsel-Lampe mit Fernbedienung (E14)

LED-Farbwechsel-Lampe mit Fernbedienung (E14)

  Nicht auf Lager*
LED-Leuchtmittel (E14) - weiß

LED-Leuchtmittel (E14) - weiß

  Nicht auf Lager*

 9,5

WLAN Lampe (LED, RGB, Dimmbar) (E14)

WLAN Lampe (LED, RGB, Dimmbar) (E14)

  Nicht auf Lager*

Smarte Deckenspots

Lampen, die in die Decke integriert sind - sogenannte Deckenspots - gibt es im Format GU10 und B22. GU10 ist jedoch deutlich weiter verbreitet.

Anders als E27- & E14-Lampen werden Spots nicht in den Sockel geschraubt, sondern lediglich hineingesteckt und kurz gedreht, bis sie einrasten.

 Zu den GU10-Lampen
 Zu den B22-Lampen

Smarte Glühbirne GU10

Im Gegensatz zu den Leuchtmitteln mit Gewinden besitzen GU10-Lampen zwei Stecker, die in die Lampenfassung gesteckt und bis zum Einrasten gedreht werden.

Gledopto GU10 Glühbirne

GU10-Deckenspots sind häufig kegel-ähnlich geformt.

Smart WLAN Lampen GU10 (4er-Pack)

Smart WLAN Lampen GU10 (4er-Pack)

  Nicht auf Lager*
Innr GU10 Smart LED Spots (4er-Pack)

Innr GU10 Smart LED Spots (4er-Pack)

  Nicht auf Lager*
Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

  Nicht auf Lager*
Hama GU10 Wi-Fi LED-Lampe

Hama GU10 Wi-Fi LED-Lampe

-11%
  Nicht auf Lager*
GU10 LED Lampen (2er-Pack)

GU10 LED Lampen (2er-Pack)

  Nicht auf Lager*

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*
LOHAS Smart LED Lampe (2er-Pack)

LOHAS Smart LED Lampe (2er-Pack)

  Nicht auf Lager*
Innr GU10 Smart LED Spot Color

Innr GU10 Smart LED Spot Color

  Nicht auf Lager*

Smarte Glühbirne B22

MoKo WLAN Smart Led Lampe (B22)

MoKo WLAN Smart Led Lampe (B22)

  Nicht auf Lager*
LIFX Mini WLAN-Lampe dimmbar, RGBW (B22)

LIFX Mini WLAN-Lampe dimmbar, RGBW (B22)

-16%
  Nicht auf Lager*
WLAN Smart Alexa Lampe 12W B22 RGB (2er-Pack)

WLAN Smart Alexa Lampe 12W B22 RGB (2er-Pack)

  Nicht auf Lager*
Bomcosy Smart WLAN LED Glühbirne RGB (B22)

Bomcosy Smart WLAN LED Glühbirne RGB (B22)

  Nicht auf Lager*

Wie funktioniert eine smarte Glühbirne?

Eine smarte Glühbirne - egal ob WLAN, ZigBee oder Hue - funktioniert grundsätzlich ähnlich wie eine herkömmliche Lampe.

Anders als bei einer normalen Lampe steckt aber in den meisten smarten Lampen noch ein Microchip und ein Funkmodul. Damit kann die Lampe mit deinem Smarthome-System kommunizieren und Schaltbefehle entgegen nehmen, damit beispielsweise Farbe und Helligkeit eingestellt werden können.



Smarte Beleuchtung

Neben Glühbirnen gibt es selbstverständlich noch eine Vielzahl weiterer smarter Leuchtmittel, mit denen du in deinem Haus oder deiner Wohnung für eine angenehme Stimmung sorgen kannst.

Alle smarten Leuchtmittel 

WLAN Glühbirnen für dein Smarthome

WLAN kompatible Lampen besitzen den Vorteil, dass keine Bridge benötigt wird, um sie ins Smarthome zu integrieren.

Die Lampen werden per App in dein WLAN-Netzwerk eingebunden und lassen sich dann ganz bequem fernsteuern - auch mit einem Sprachassistenten wie Alexa oder Google Home.

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

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

  Nicht auf Lager*
Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

  Nicht auf Lager*

 9,5

WLAN Lampe (LED, RGB, Dimmbar) (E14)

WLAN Lampe (LED, RGB, Dimmbar) (E14)

  Nicht auf Lager*

ZigBee kompatible Glühbirnen

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*

 8,0

Gledopto LED E14 RGB CCT-Lampe

Gledopto LED E14 RGB CCT-Lampe

  Nicht auf Lager*

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager*

 9,5

Gledopto 12W E27 RGB CCT-Lampe

Gledopto 12W E27 RGB CCT-Lampe

  Nicht auf Lager*

Philips Hue Glühbirnen

Philips Hue ist Marktführer der smarten Beleuchtung - und das nicht ohne Grund! Dank Hue Sync, Spotify Synchronisierung und zahlreichen weiteren Funktionen kannst du Hue Lampen unglaublich flexibel in deinem Smarthome einsetzen.

 9,5

Gledopto 12W E27 RGB CCT-Lampe

Gledopto 12W E27 RGB CCT-Lampe

  Nicht auf Lager*

 8,0

Gledopto LED E14 RGB CCT-Lampe

Gledopto LED E14 RGB CCT-Lampe

  Nicht auf Lager*

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager*

Smarte Glühbirnen für Apple HomeKit

Welche Glühbirne für Alexa?

Wenn du einen Amazon Echo zuhause hast, dann könnten diese Alexa kompatiblen Lampen interessant für dich sein. Sie können ganz bequem per Sprachbefehl oder der Alexa-App gesteuert werden.

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager*
Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

  Nicht auf Lager*
tado° Smartes Heizkörper-Thermostat

tado° Smartes Heizkörper-Thermostat

-21%
  Nicht auf Lager*
tado° Smarte Klimaanlagen-Steuerung V3+

tado° Smarte Klimaanlagen-Steuerung V3+

  Nicht auf Lager*

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*

 9,5

WLAN Lampe (LED, RGB, Dimmbar) (E14)

WLAN Lampe (LED, RGB, Dimmbar) (E14)

  Nicht auf Lager*
Govee Alexa Smarte Glühbirne E27 (4er Set)

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

  Nicht auf Lager*

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager*

Google Home kompatible Lampen

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

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

  Nicht auf Lager*
tado° Smartes Thermostat

tado° Smartes Thermostat

-44%
  Nicht auf Lager*

 9,0

LIDL Silvercrest Monsieur Cuisine Smart SKMS 1200 A1

LIDL Silvercrest Monsieur Cuisine Smart SKMS 1200 A1

  Nicht auf Lager*
Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

  Nicht auf Lager*

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager*

 9,5

WLAN Lampe (LED, RGB, Dimmbar) (E14)

WLAN Lampe (LED, RGB, Dimmbar) (E14)

  Nicht auf Lager*
tado° Smarte Klimaanlagen-Steuerung V3+

tado° Smarte Klimaanlagen-Steuerung V3+

  Nicht auf Lager*

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager*

Smarte Glühbirnen für Siri

Du besitzt ein iPhone oder einen Homepod? Dann sind diese smarten Lampen auf jeden Fall das richtige für dich!

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager*

 9,5

Gledopto 12W E27 RGB CCT-Lampe

Gledopto 12W E27 RGB CCT-Lampe

  Nicht auf Lager*

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager*
tado° Smarte Klimaanlagen-Steuerung V3+

tado° Smarte Klimaanlagen-Steuerung V3+

  Nicht auf Lager*

 8,0

Gledopto LED E14 RGB CCT-Lampe

Gledopto LED E14 RGB CCT-Lampe

  Nicht auf Lager*

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*

Die TOP 3 der beliebtesten smarten Glühbirnen!

 9,5

WLAN Lampe (LED, RGB, Dimmbar) (E14)

WLAN Lampe (LED, RGB, Dimmbar) (E14)

  Nicht auf Lager*

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*

 9,5

Gledopto 12W E27 RGB CCT-Lampe

Gledopto 12W E27 RGB CCT-Lampe

  Nicht auf Lager*

Smarte Glühbirnen im Test

Für Smarthome Blogger habe ich schon einige Geräte auf Herz und Nieren getestet und dir meine Ergebnisse und Erfahrungen beschrieben.

Bisher habe ich bereits die folgenden Glühbirnen für dein Smarthome getestet - und es waren auch einige Überraschungen dabei!

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager*

 8,0

WeLock Fingerabdruck Türöffner SECBN51

WeLock Fingerabdruck Türöffner SECBN51

Bei WeLock kaufen*

 9,5

Gledopto 12W E27 RGB CCT-Lampe

Gledopto 12W E27 RGB CCT-Lampe

  Nicht auf Lager*

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager*

 8,0

LED-Farbwechsel-Lampe mit Fernbedienung (E14)

LED-Farbwechsel-Lampe mit Fernbedienung (E14)

  Nicht auf Lager*

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager*

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager*

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager*

 8,0

Gledopto LED E14 RGB CCT-Lampe

Gledopto LED E14 RGB CCT-Lampe

  Nicht auf Lager*

 9,0

LIDL Silvercrest Monsieur Cuisine Smart SKMS 1200 A1

LIDL Silvercrest Monsieur Cuisine Smart SKMS 1200 A1

  Nicht auf Lager*

 9,0

LIDL Silvercrest Monsieur Cuisine Smart SKMS 1200 A1

LIDL Silvercrest Monsieur Cuisine Smart SKMS 1200 A1

  Nicht auf Lager*

 8,0

WeLock Fingerabdruck Türöffner SECBN51

WeLock Fingerabdruck Türöffner SECBN51

Bei WeLock kaufen*

Alle Produkttests ansehen 

Alle Produkte dieser Kategorie


Filtern

 8,0

LED-Farbwechsel-Lampe mit Fernbedienung (E14)

LED-Farbwechsel-Lampe mit Fernbedienung (E14)

  Nicht auf Lager* Zum Produkttest 

 9,5

WLAN Lampe (LED, RGB, Dimmbar) (E14)

WLAN Lampe (LED, RGB, Dimmbar) (E14)

  Nicht auf Lager* Zum Produkttest 

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager* Zum Produkttest 

 9,5

Gledopto 12W E27 RGB CCT-Lampe

Gledopto 12W E27 RGB CCT-Lampe

  Nicht auf Lager* Zum Produkttest 

 8,0

Gledopto LED E14 RGB CCT-Lampe

Gledopto LED E14 RGB CCT-Lampe

  Nicht auf Lager* Zum Produkttest 

 6,0

Gledopto GU10 RGB CCT-Lampe

Gledopto GU10 RGB CCT-Lampe

  Nicht auf Lager* Zum Produkttest 

 9,0

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

Gledopto LED E27 RGB CCT-Lampe (6 Watt)

  Nicht auf Lager* Zum Produkttest 
Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

Klyqa GU10 Color mit Farben, Kalt- & Warmweiß

  Nicht auf Lager*  Mehr Infos
Govee Alexa Smarte Glühbirne E27 (4er Set)

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

  Nicht auf Lager*  Mehr Infos

  • 213 Anfragen; Gesamtdauer: 136.22450828552 Millisekunden

  • Query Dauer (ms)
    SELECT * FROM user__session where (session_key = "f40af2aaa69a68a902696df4767a4804" and session_expires > CURRENT_TIMESTAMP()) 0.64897537231445
    SELECT * FROM user__session where (session_key = "f40af2aaa69a68a902696df4767a4804" and session_expires > CURRENT_TIMESTAMP()) 0.28204917907715
    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 = "smarte-gluehbirne" LIMIT 1 0.41103363037109
    SELECT *, (product_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(product_date, "%d.%m.%Y") as formatted_date FROM product where permalink = "smarte-gluehbirne" LIMIT 1 0.33402442932129
    SELECT product__taxonomy.* FROM product__taxonomy where permalink = "smarte-gluehbirne"; 0.28705596923828
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.19717216491699
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53))) group by product.product_id 4.9779415130615
    SELECT * FROM product__meta where product_id IN (79, 90, 209, 248, 249, 251, 252, 1012, 1015) 2.2578239440918
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 79 0.3969669342041
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 0.36001205444336
    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.38599967956543
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.30303001403809
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 249 0.20813941955566
    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 = 249 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.47206878662109
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.42104721069336
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.2598762512207
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.21696090698242
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.27990341186523
    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.21195411682129
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015 0.26702880859375
    SELECT brand.* FROM brand join brand__product_mapping on brand__product_mapping.brand_id = brand.brand_id join product on product.product_id = brand__product_mapping.product_id join product__link on product.product_id = product__link.product_id join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id where (brand.status = "publish" and brand.show_in_filter = true and ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product__taxonomy_mapping.taxonomy_id = 53 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) group by brand.brand_id order by brand.title asc 1.9140243530273
    SELECT LEAST(min(product__link.reduced_price), min(product__link.price)) as min_price, GREATEST(max(product__link.reduced_price), max(product__link.price)) as max_price FROM product__link join product on product.product_id = product__link.product_id join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product__taxonomy_mapping.taxonomy_id = 53 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 0.59103965759277
    SELECT * FROM product__taxonomy where product__taxonomy_id = 53 0.29611587524414
    SELECT product__data_field_group.*, product__taxonomy.title as taxonomy_name FROM product__data_field_group LEFT join product__taxonomy on product__data_field_group.product__taxonomy_id = product__taxonomy.product__taxonomy_id where (product__data_field_group.product__taxonomy_id IN (53)) order by group_name ASC 0.2899169921875
    SELECT product__data_field.*, product__data_field_group.group_name FROM product__data_field LEFT JOIN product__data_field_group on product__data_field.group_id = product__data_field_group.product__data_field_group_id where group_id = 14 0.24890899658203
    SELECT * FROM stock_attachment where stock_attachment_id = 20 0.2589225769043
    SELECT product.* FROM product JOIN product__taxonomy_mapping ON product__taxonomy_mapping.product_id = product.product_id JOIN product__taxonomy ON product__taxonomy.product__taxonomy_id = product__taxonomy_mapping.taxonomy_id where product.status = "publish" and product.hide_in_search = 0 and product__taxonomy.permalink = "smarte-gluehbirne" and product.product_id IN (select product_id from product__data JOIN product__data_field ON product__data.product__data_field_id = product__data_field.product__data_field_id where product__data_field.field_key = "lampenfassung" and product__data.value = "E27") ORDER BY RAND() LIMIT 8 2.7508735656738
    SELECT * FROM product__meta where product_id IN (71, 100, 252, 279, 282, 1015, 101, 209) 9.3569755554199
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 71 0.57005882263184
    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 = 71 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.52881240844727
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 71 0.53906440734863
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 71 0.34403800964355
    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 = 71 and smarthome_system.status = "publish")) 0.40292739868164
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 100 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 = 100 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.36382675170898
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 100 0.33879280090332
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 100 0.26106834411621
    SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 100 and smarthome_system.status = "publish")) 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 = 252 0.21910667419434
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 279 0.20694732666016
    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 = 279 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 = 279 0.30088424682617
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 279 0.23388862609863
    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 = 279 and smarthome_system.status = "publish")) 0.28800964355469
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 282 0.17213821411133
    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 = 282 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC 0.36811828613281
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 282 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 = 282 0.2591609954834
    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 = 282 and smarthome_system.status = "publish")) 0.27298927307129
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015 0.29110908508301
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 101 0.26202201843262
    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 = 101 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 = 101 0.26297569274902
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 101 0.26607513427734
    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 = 101 and smarthome_system.status = "publish")) 0.24890899658203
    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.2748966217041
    SELECT product.* FROM product JOIN product__taxonomy_mapping ON product__taxonomy_mapping.product_id = product.product_id JOIN product__taxonomy ON product__taxonomy.product__taxonomy_id = product__taxonomy_mapping.taxonomy_id where product.status = "publish" and product.hide_in_search = 0 and product__taxonomy.permalink = "smarte-gluehbirne" and product.product_id IN (select product_id from product__data JOIN product__data_field ON product__data.product__data_field_id = product__data_field.product__data_field_id where product__data_field.field_key = "lampenfassung" and product__data.value = "E14") ORDER BY RAND() LIMIT 8 1.1579990386963
    SELECT * FROM product__meta where product_id IN (357, 284, 358, 249, 359, 79, 84, 90) 5.8481693267822
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 357 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 = 357 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.41604042053223
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 357 0.4122257232666
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 357 0.29587745666504
    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 = 357 and smarthome_system.status = "publish")) 0.27108192443848
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 284 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 = 284 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.3049373626709
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 284 0.34117698669434
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 284 0.25486946105957
    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 = 284 and smarthome_system.status = "publish")) 0.24986267089844
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 358 0.26702880859375
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 358 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.2739429473877
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 358 0.29587745666504
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 358 0.23198127746582
    SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 358 and smarthome_system.status = "publish")) 0.22792816162109
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.27585029602051
    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 = 249 and smarthome_system.status = "publish")) 0.2291202545166
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 359 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 = 359 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.29802322387695
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 359 0.31518936157227
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 359 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 = 359 and smarthome_system.status = "publish")) 0.22482872009277
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 79 0.28300285339355
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 84 0.29897689819336
    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 = 84 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 = 84 0.26607513427734
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 84 0.27990341186523
    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 = 84 and smarthome_system.status = "publish")) 0.27894973754883
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 0.26798248291016
    SELECT product.* FROM product JOIN product__taxonomy_mapping ON product__taxonomy_mapping.product_id = product.product_id JOIN product__taxonomy ON product__taxonomy.product__taxonomy_id = product__taxonomy_mapping.taxonomy_id where product.status = "publish" and product.hide_in_search = 0 and product__taxonomy.permalink = "smarte-gluehbirne" and product.product_id IN (select product_id from product__data JOIN product__data_field ON product__data.product__data_field_id = product__data_field.product__data_field_id where product__data_field.field_key = "lampenfassung" and product__data.value = "GU10") ORDER BY RAND() LIMIT 8 1.0139942169189
    SELECT * FROM product__meta where product_id IN (355, 280, 1012, 353, 356, 251, 354, 281) 4.1961669921875
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 355 0.35405158996582
    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 = 355 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.47397613525391
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 355 0.59986114501953
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 355 0.42581558227539
    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 = 355 and smarthome_system.status = "publish")) 0.5030632019043
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 280 0.34809112548828
    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 = 280 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.49805641174316
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 280 0.41508674621582
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 280 0.32901763916016
    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 = 280 and smarthome_system.status = "publish")) 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 = 1012 0.33092498779297
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 353 0.24700164794922
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 353 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.44012069702148
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 353 0.39982795715332
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 353 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 = 353 and smarthome_system.status = "publish")) 0.35715103149414
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 356 0.26202201843262
    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 = 356 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.37312507629395
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 356 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 = 356 0.31018257141113
    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 = 356 and smarthome_system.status = "publish")) 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 = 251 0.27203559875488
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 354 0.18715858459473
    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 = 354 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.35810470581055
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 354 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 = 354 0.25200843811035
    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 = 354 and smarthome_system.status = "publish")) 0.23102760314941
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 281 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 = 281 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.30779838562012
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 281 0.31709671020508
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 281 0.32591819763184
    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 = 281 and smarthome_system.status = "publish")) 0.27799606323242
    SELECT product.* FROM product JOIN product__taxonomy_mapping ON product__taxonomy_mapping.product_id = product.product_id JOIN product__taxonomy ON product__taxonomy.product__taxonomy_id = product__taxonomy_mapping.taxonomy_id where product.status = "publish" and product.hide_in_search = 0 and product__taxonomy.permalink = "smarte-gluehbirne" and product.product_id IN (select product_id from product__data JOIN product__data_field ON product__data.product__data_field_id = product__data_field.product__data_field_id where product__data_field.field_key = "lampenfassung" and product__data.value = "B22") ORDER BY RAND() LIMIT 8 0.94318389892578
    SELECT * FROM product__meta where product_id IN (361, 102, 362, 363) 2.0630359649658
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 361 0.30803680419922
    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 = 361 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.45013427734375
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 361 0.45514106750488
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 361 0.3199577331543
    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 = 361 and smarthome_system.status = "publish")) 0.34022331237793
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 102 0.20003318786621
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 102 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.3349781036377
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 102 0.30303001403809
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 102 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 = 102 and smarthome_system.status = "publish")) 0.27108192443848
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 362 0.21195411682129
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 362 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.31900405883789
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 362 0.27012825012207
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 362 0.25510787963867
    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 = 362 and smarthome_system.status = "publish")) 0.3960132598877
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 363 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 = 363 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.2751350402832
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 363 1.1441707611084
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 363 0.37717819213867
    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 = 363 and smarthome_system.status = "publish")) 0.36787986755371
    SELECT product__taxonomy.* FROM product__taxonomy where permalink in ("smarte-gluehbirne"); 0.36787986755371
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id join smarthome_system__product_mapping on smarthome_system__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 (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53)) and smarthome_system__product_mapping.smarthome_system_id in (6)) group by product.product_id order by RAND() limit 4 4.5950412750244
    SELECT * FROM product__meta where product_id IN (1015, 1012, 90) 0.69594383239746
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015 0.31614303588867
    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.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 = 90 0.24104118347168
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id join smarthome_system__product_mapping on smarthome_system__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 (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53)) and smarthome_system__product_mapping.smarthome_system_id in (2)) group by product.product_id order by RAND() limit 4 1.0280609130859
    SELECT * FROM product__meta where product_id IN (251, 249, 252, 248) 1.6849040985107
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.35715103149414
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.28014183044434
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.34403800964355
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.29897689819336
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id join smarthome_system__product_mapping on smarthome_system__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 (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53)) and smarthome_system__product_mapping.smarthome_system_id in (10)) group by product.product_id order by RAND() limit 4 0.90789794921875
    SELECT * FROM product__meta where product_id IN (248, 249, 251, 209) 1.3868808746338
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.36191940307617
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.35309791564941
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.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 = 209 0.29206275939941
    SELECT * FROM smarthome_system__meta where smarthome_system_id IN (20) 0.55408477783203
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id join smarthome_system__product_mapping on smarthome_system__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 (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53)) and smarthome_system__product_mapping.smarthome_system_id in (20)) group by product.product_id order by RAND() limit 8 0.86784362792969
    SELECT product.* FROM product JOIN product__link ON product__link.product_id = product.product_id where ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id IN (select distinct(product.product_id) from product INNER JOIN product__taxonomy_mapping ON product.product_id = product__taxonomy_mapping.product_id JOIN product__link ON product__link.product_id = product.product_id where product__taxonomy_mapping.taxonomy_id IN ( SELECT product__taxonomy.product__taxonomy_id FROM product__taxonomy where permalink IN ("smarte-gluehbirne", "amazon-alexa-zubehoer") ) group by product__taxonomy_mapping.product_id HAVING COUNT(*) >= 2) ORDER BY RAND() LIMIT 8 6.2980651855469
    SELECT * FROM product__meta where product_id IN (252, 1012, 74, 258, 251, 90, 1015, 933) 2.4621486663818
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.45108795166016
    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.28204917907715
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 74 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 = 258 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 = 251 0.23913383483887
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 0.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 = 1015 0.23913383483887
    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.23293495178223
    SELECT product.* FROM product JOIN product__link ON product__link.product_id = product.product_id where ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id IN (select distinct(product.product_id) from product INNER JOIN product__taxonomy_mapping ON product.product_id = product__taxonomy_mapping.product_id JOIN product__link ON product__link.product_id = product.product_id where product__taxonomy_mapping.taxonomy_id IN ( SELECT product__taxonomy.product__taxonomy_id FROM product__taxonomy where permalink IN ("smarte-gluehbirne", "google-home-zubehoer") ) group by product__taxonomy_mapping.product_id HAVING COUNT(*) >= 2) ORDER BY RAND() LIMIT 8 3.7989616394043
    SELECT * FROM product__meta where product_id IN (1015, 75, 652, 1012, 252, 90, 258, 209) 1.460075378418
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015 0.34213066101074
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 0.2739429473877
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 652 0.29206275939941
    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 = 652 and smarthome_system.status = "publish")) 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 = 1012 0.24795532226562
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.23889541625977
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 0.24795532226562
    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.26488304138184
    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.2739429473877
    SELECT product.* FROM product JOIN product__link ON product__link.product_id = product.product_id where ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id IN (select distinct(product.product_id) from product INNER JOIN product__taxonomy_mapping ON product.product_id = product__taxonomy_mapping.product_id JOIN product__link ON product__link.product_id = product.product_id where product__taxonomy_mapping.taxonomy_id IN ( SELECT product__taxonomy.product__taxonomy_id FROM product__taxonomy where permalink IN ("smarte-gluehbirne", "siri-zubehoer") ) group by product__taxonomy_mapping.product_id HAVING COUNT(*) >= 2) ORDER BY RAND() LIMIT 8 2.979040145874
    SELECT * FROM product__meta where product_id IN (252, 248, 209, 258, 249, 251) 1.7478466033936
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.35810470581055
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.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 = 209 0.26416778564453
    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.2892017364502
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 0.2288818359375
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.27704238891602
    SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53))) group by product.product_id order by -amazon_sales_rank ASC limit 3 4.5759677886963
    SELECT * FROM product__meta where product_id IN (90, 251, 248) 1.011848449707
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 0.34785270690918
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.31614303588867
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 0.28681755065918
    SELECT product.* FROM product JOIN product__link ON product__link.product_id = product.product_id where ( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id IN (select distinct(product.product_id) from product INNER JOIN product__taxonomy_mapping ON product.product_id = product__taxonomy_mapping.product_id JOIN product__link ON product__link.product_id = product.product_id where product__taxonomy_mapping.taxonomy_id IN ( SELECT product__taxonomy.product__taxonomy_id FROM product__taxonomy where permalink IN ("smarte-gluehbirne", "produkttests") ) group by product__taxonomy_mapping.product_id HAVING COUNT(*) >= 2) ORDER BY RAND() LIMIT 12 3.3960342407227
    SELECT * FROM product__meta where product_id IN (209, 961, 248, 933, 79, 251, 252, 933, 249, 652, 652, 961) 1.7490386962891
    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.47802925109863
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 0.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 = 248 0.45013427734375
    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.3199577331543
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 79 0.3359317779541
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 0.37288665771484
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 0.32711029052734
    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.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 = 249 0.29706954956055
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 652 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 = 652 and smarthome_system.status = "publish")) 0.32305717468262
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 652 0.3509521484375
    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 = 652 and smarthome_system.status = "publish")) 0.2739429473877
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 0.25081634521484