Startersets



Produkte jetzt ansehen

Du interessierst ich für das Thema Smarthome? Du möchtest unbedingt in die intelligente Haussteuerung einsteigen, aber du weißt nicht so recht wo du anfangen sollst und welche Produkte du dazu brauchst? Dann bist du hier genau richtig! Egal, ob du nach einem leichten Einstieg zur Steuerung deiner Beleuchtung oder ein Starterkit zur Heizungssteuerung suchst - hier findest du es! Auch Startersets zur Videoüberwachung, mit denen du dein Zuhause immer im Blick haben kannst, gibt es.   Mit Rauchmeldern und Türkontakten kannst du dich außerdem von deinem Smarthome benachrichtigen lassen, wenn jemand unerlaubterweise eine Tür oder ein Fenster öffnet oder wenn ein Feuer ausbricht und niemand zuhause ist.
Das Starterset der Smarthome Heizung kommt mit 2 Thermostaten.

Zum Testbericht 

Falls du dich langsam ans Thema Smarthome wagen möchtest und am Anfang nur ein begrenztes Budget zur Verfügung hast, sind die reduzierten Smarthome Startersets immer eine gute Wahl.

Heizungssteuerung  Sicherheit  Lichtsteuerung  Im Angebot 



Startersets zur Heizungssteuerung

Für viele war der Einstieg ins Thema "Smarthome" das Bedürfnis, die Raumtemperaturen automatisiert und von überall auf der Welt aus steuern zu können. Mit diesen Startersets erhältst du alles, was du anfangs benötigst. Die meisten Smarthome Startersets zur Heizungssteuerung kommen mit einem Smarthome Hub und einem oder mehreren Heizkörperthermostaten, damit du sofort loslegen kannst.
tado° Smartes Thermostat

tado° Smartes Thermostat

-44%
  Nicht auf Lager*

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager*

 8,8

Meross Smart WLAN Heizkörperthermostat Test

Meross Smart WLAN Heizkörperthermostat Test

  Nicht auf Lager*

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager*

Sicherheits-Startersets

Du möchtest deine eigenen vier Wände ein wenig sicherer machen aber weißt nicht so richtig, wo du anfangen sollst und was du genau benötigst? Dann ist ein Starterset zum Thema "Sicherheit" möglicherweise das richtige für dich! Egal, ob du dich eher für Videoüberwachung, Feuermelder oder Türkontakte interessierst, die das unerwünschte Öffnen einer Tür oder eines Fensters melden - hier wirst du fündig!
Netgear Arlo VMS3230-100EUS

Netgear Arlo VMS3230-100EUS

  Nicht auf Lager*
Homematic IP Starter Set Rauchwarnmelder

Homematic IP Starter Set Rauchwarnmelder

  Nicht auf Lager*

Starterkits zur Steuerung der Lichter

Wenn du in deinem Haus oder deiner Wohnung die Lichter mit smarten Lampen ersetzen möchtest, solltest du dir diese Starterkits zur Lichtsteuerung ansehen, mit denen du günstig an mehrere Lampen und meistens einen Smarthome Hub kommst.
Philips Hue White E27 LED-Starterset

Philips Hue White E27 LED-Starterset

  Nicht auf Lager*

Reduzierte Smarthome Starterkits

Der Einstieg ins Thema Smarthome muss nicht immer teuer sein. Vor allem mit verschiedenen Startersets gibt es immer die Möglichkeit, ordentlich zu sparen! Wenn du hier nicht fündig wirst, kannst du dir auch einfach alle reduzierten Startersets ansehen.

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager*

Alle Angebote ansehen 

Alle Produkte dieser Kategorie


Filtern
tado° Starterset Eigenheim

tado° Starterset Eigenheim

  Nicht auf Lager*
tado° Starterset Fußbodenheizung

tado° Starterset Fußbodenheizung

-19%
  Nicht auf Lager*

 9,0

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

Egardia Philips Hue Alarmanlage (EGHUE-03) im Test

  Nicht auf Lager* Zum Produkttest 

 8,5

MIYO smarte Bewässerung Starterset

MIYO smarte Bewässerung Starterset

  Nicht auf Lager* Zum Produkttest 

 8,0

Wiser Starter-Kit

Wiser Starter-Kit

  Nicht auf Lager* Zum Produkttest 

 8,8

Meross Smart WLAN Heizkörperthermostat Test

Meross Smart WLAN Heizkörperthermostat Test

  Nicht auf Lager* Zum Produkttest 

 7,0

tado Starter Kit (inkl. 5 Heizkörperthermostate)

tado Starter Kit (inkl. 5 Heizkörperthermostate)

-14%
  Nicht auf Lager* Zum Produkttest 

  • 72 Anfragen; Gesamtdauer: 81.245183944702 Millisekunden

  • Query Dauer (ms)
    SELECT * FROM user__session where (session_key = "9b74d36c3aba777a7ac718ae5505a068" and session_expires > CURRENT_TIMESTAMP()) 0.56600570678711
    SELECT * FROM user__session where (session_key = "9b74d36c3aba777a7ac718ae5505a068" and session_expires > CURRENT_TIMESTAMP()) 0.30303001403809
    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 = "startersets" LIMIT 1 0.62894821166992
    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 = "startersets" LIMIT 1 0.45204162597656
    SELECT product__taxonomy.* FROM product__taxonomy where permalink = "startersets"; 0.55694580078125
    SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 0.36096572875977
    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 (11) or product__taxonomy_virtual_mapping.taxonomy_id in (11))) group by product.product_id 8.9669227600098
    SELECT * FROM product__meta where product_id IN (72, 76, 209, 210, 242, 293, 933) 10.823011398315
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 72 0.5650520324707
    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.48398971557617
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 72 0.3819465637207
    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.31518936157227
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 76 0.25796890258789
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 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.54311752319336
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 76 0.34499168395996
    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.2601146697998
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 209 0.20503997802734
    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.38385391235352
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 209 0.54812431335449
    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.28491020202637
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 210 0.32281875610352
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 242 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 = 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.40984153747559
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 242 0.50997734069824
    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.34213066101074
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 293 0.27298927307129
    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.55789947509766
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 0.43606758117676
    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.33092498779297
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 933 0.31304359436035
    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.49304962158203
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 0.47612190246582
    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.41794776916504
    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 = 11 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) group by brand.brand_id order by brand.title asc 5.1219463348389
    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 = 11 and (product__link.reduced_price > 0 or product__link.reduced_price is null)) 1.4700889587402
    SELECT * FROM product__taxonomy where product__taxonomy_id = 11 0.50187110900879
    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 (11)) order by group_name ASC 0.44584274291992
    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 ("startersets", "smarte-heizungssteuerung") ) group by product__taxonomy_mapping.product_id HAVING COUNT(*) >= 2) ORDER BY RAND() LIMIT 4 6.4809322357178
    SELECT * FROM product__meta where product_id IN (75, 933, 293, 933) 2.3269653320312
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 75 0.96487998962402
    SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 75 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC 0.74386596679688
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 0.68402290344238
    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.46896934509277
    SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 75 and smarthome_system.status = "publish")) 0.6248950958252
    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.48184394836426
    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.51093101501465
    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.51593780517578
    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.46300888061523
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 0.36406517028809
    SELECT * FROM product where status = "publish" and product_id_old IN (1659, 1666, 1640, 1637) 2.0270347595215
    SELECT * FROM product__meta where product_id IN (134, 140) 3.7190914154053
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 134 0.54001808166504
    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 = 134 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.0898113250732
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 134 0.63705444335938
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 134 1.0890960693359
    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 = 134 and smarthome_system.status = "publish")) 0.42605400085449
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 140 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 = 140 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.61583518981934
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 140 0.44608116149902
    SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 140 0.50592422485352
    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 = 140 and smarthome_system.status = "publish")) 0.57005882263184
    SELECT * FROM product where status = "publish" and product_id_old IN (1466, 693, 1917, 1786) 3.4830570220947
    SELECT * FROM product__meta where product_id IN (71) 1.9228458404541
    SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 71 0.51188468933105
    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.81110000610352
    SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 71 1.086950302124
    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.87690353393555
    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")) 1.1601448059082
    SELECT product__taxonomy.* FROM product__taxonomy where permalink in ("startersets"); 0.59914588928223
    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 (11) or product__taxonomy_virtual_mapping.taxonomy_id in (11)) and ( ( product__link.price is not null and product__link.price > 0 and product__link.reduced_price is not null and product__link.reduced_price > 0 ) and (product__link.reduced_price < product__link.price) and (1 - (product__link.reduced_price / product__link.price)) > 0.1 and (1 - (product__link.reduced_price / product__link.price)) < 0.5 )) group by product.product_id order by RAND() limit 4 3.309965133667
    SELECT * FROM product__meta where product_id IN (933) 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 = 933 0.43797492980957