Komunikat RODO | Metrohouse

2018-04-12

INFORMACJA DLA KLIENTÓW GRUPY METROHOUSE

Szanowny Kliencie,

w Grupie Metrohouse jesteśmy głęboko zaangażowani w budowanie zaufania i poczucia bezpieczeństwa wśród naszych klientów i kooperantów. Nasz model działania został w pełni dostosowany do przepisów Ogólnego Rozporządzenia o Ochronie Danych (RODO).

Administratorami danych osobowych w Grupie Metrohouse są:

• Metrohouse Franchise S.A. z siedzibą w Warszawie przy ul. Żelaznej 28/30, 00-832 Warszawa (dalej zwany: „ADO 1”);

• Metrohouse S.A. z siedzibą w Warszawie przy ul. Żelaznej 28/30, 00-832 Warszawa (dalej zwany: „ADO 2”);

•   Gold Finance Sp. z o. o. z siedzibą w Warszawie przy ul. Żelaznej 28/30, 00-832 Warszawa (dalej zwany „ADO 3”).

W ADO 1, ADO 2 wyznaczono inspektora danych osobowych, z którym można się skontaktować za pomocą maila iod@metrohouse.pl oraz drogą pocztową: ul. Żelazna 28/30, 00-832 Warszawa. Z inspektorem ochrony danych można się kontaktować we wszystkich sprawach dotyczących przetwarzania danych osobowych oraz korzystania z praw związanych z przetwarzaniem danych.

ADO 1 przetwarza dane osobowe w celu przedstawienia ofert sprzedaży nieruchomości, rozpatrzenia reklamacji oraz zapewnienia wykonania umów pośrednictwa w obrocie nieruchomościami na podstawie art. 6 ust. 1 pkt b) RODO (dane przechowywane są przez okres równy okresowi wykonywania umowy pośrednictwa oraz okresowi przedawnienia roszczeń wynikających z umowy pośrednictwa lub równy okresowi przechowywania dokumentacji związanej z wykonaniem umowy pośrednictwa wymaganemu przez powszechnie obowiązujące przepisy prawa – w zależności, który z tych okresów jest dłuższy). Ponadto ADO 1 przetwarza dane osobowe   w celach marketingowych na podstawie art. 6 ust. 1 pkt a) RODO (dane przechowywane są przez okres 3 miesięcy od daty prezentacji lokalu, a jeżeli została zawarta umowa pośrednictwa przez okres trwania tej umowy).

ADO 2 i ADO 3 przetwarzają dane osobowe w celu promocji, polecania oraz pośrednictwa finansowego w sprzedaży produktów hipotecznych banków (np. oferowanie klientom finansowania zakupu nieruchomości, w szczególności oferowanie usługi kredytowania w ramach wykonania Umowy Pośrednictwa) oraz produktów ubezpieczeniowych na podstawie art. 6 ust. 1 pkt b) RODO. Dane przetwarzane są przez okres przechowywania dokumentacji związanej z wykonaniem umowy kredytowej (ubezpieczeniowej) wymaganemu przez powszechnie obowiązujące przepisy prawa lub przez okres dochodzenia wynikających z niej roszczeń lub przez okres wykonywania usługi pośrednictwa finansowego i/lub ubezpieczeniowego i przechowywania dokumentacji związanej z wykonaniem tych usług zgodnie z wymogami powszechnie obowiązujących przepisów prawa – w zależności, który z tych okresów jest dłuższy. Ponadto w celach marketingowych na podstawie art. 6 ust. 1 pkt a) RODO (dane przechowywane są do czasu cofnięcia zgody).

ADO 3 przetwarza dane osobowe w celu wykonania umów pośrednictwa w obrocie nieruchomościami na podstawie art. 6 ust. 1 pkt b) RODO (dane są przechowywane przez okres równy okresowi wykonywania umowy pośrednictwa oraz przedawnienia roszczeń wynikających z umowy pośrednictwa lub równy okresowi przechowywania dokumentacji związanej z wykonaniem umowy pośrednictwa zgodnie z wymogami powszechnie obowiązujących przepisów prawa – w zależności, który z tych okresów jest dłuższy).

Odbiorcami danych osobowych z zachowaniem wszelkich gwarancji zapewniających bezpieczeństwo przekazywanych danych mogą być:

a.   pracownicy ADO upoważnieni do ich przetwarzania na polecenie ADO;
b. podmioty, którym ADO powierzył przetwarzanie danych osobowych, w tym: dostawcom usług technicznych i organizacyjnych umożliwiających świadczenie pośrednictwa finansowego i/lub ubezpieczeniowego;
c.   dostawcy usług prawnych i doradczych w przypadku dochodzenia przez ADO roszczeń związanych z prowadzona działalnością gospodarczą.
d.   inne podmioty działające w ramach sieci franczyzowych Metrohouse/Gold Finance.

Klienci Grupy Metrohouse mają prawo dostępu do treści swoich danych oraz prawo ich sprostowania, usunięcia, ograniczenia przetwarzania, prawo do przenoszenia danych, prawo wniesienia sprzeciwu, prawo do cofnięcia zgody w dowolnym momencie bez wpływu na zgodność z prawem przetwarzania (tylko w odniesieniu do danych, które przetwarzane są na podstawie art. 6 ust. 1 pkt a) RODO), którego dokonano na podstawie zgody przed jej cofnięciem.

Klienci Grupy Metrohouse mają prawo wniesienia skargi do organu nadzorczego – Prezesa Urzędu Ochrony Danych Osobowych w przypadku gdy przy przetwarzaniu moich danych ADO narusza przepisy dotyczące ochrony danych osobowych.

Dane osobowe nie są przekazywane do państw spoza Europejskiego Obszaru Gospodarczego (do krajów innych niż kraje Unii Europejskiej oraz Islandia, Norwegia i Liechtenstein).

Pragniemy zapewnić, że Grupa Metrohouse dokłada wszelkich starań, aby zapewnić wszelkie środki fizycznej, technicznej i organizacyjnej ochrony danych osobowych przed ich przypadkowym czy umyślnym zniszczeniem, przypadkową utratą, zmianą, nieuprawnionym ujawnieniem, wykorzystaniem czy dostępem, zgodnie ze wszystkimi obowiązującymi przepisami prawnymi.

W razie pojawienia się pytań dotyczących naszej Polityki Prywatności, Polityki Cookies czy innych z zakresu ochrony danych osobowych, mogą Państwo skontaktować się z naszym zespołem dedykowanym ochronie danych osobowych, wysyłając e-mail na adres: kontrola@metrohouse.pl. Jesteśmy otwarci na Państwa sugestie odnośnie poprawy bezpieczeństwa danych osobowych.

Dziękujemy za zaufanie.
Grupa Metrohouse

Masz pytania? Skontaktuj się z nami lub odwiedź najbliższe biuro Metrohouse.

+48 22 626 pokaż!

Wypełnij poniższy formularz:

Akceptuję Politykę Prywatności.

Czy ten wpis okazał się przydatny? Udostępnij znajomym

Wyślij wiadomość mailem

Akceptuję Politykę Prywatności.

Czy ten wpis okazał się przydatny?
Wyślij znajomym!

Wyślij wiadomość mailem

Akceptuję Politykę Prywatności.

Nasi klienci powiedzieli

,,Witam Państwa, chciałabym podziękować za bardzo dobrze zorganizowaną transakcję zakupu mieszkania. Szczególnie chciałabym pochwalić pracę Pani Iwony Pszczółkowskiej, która wykazała się ogromnym talentem i wiedzą. Kontakt z Panią Iwoną był dla mnie prawdziwą przyjemnością. Jest ona godnym przedstawicielem Państwa firmy."

— Tamara P., Warszawa

Q.Time(s)	Aff. Rows	Run	Query
0.00011	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00009	0	Run	SET sql_mode = ''
0.00035	1	getRow	SELECT url, active FROM routes WHERE alias='pl/komunikat-rodo' OR alias='/pl/komunikat-rodo' LIMIT 0,1
0.00016	4	getList	SELECT id, code FROM languages WHERE active = '1' AND site = 'frontend' ORDER BY default_lang DESC
0.00009	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00009	0	Run	SET sql_mode = ''
0.00045	10	getList	SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"
0.00014	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00012	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00011	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00011	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00015	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00018	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00012	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00013	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1
0.00011	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00007	0	Run	SET sql_mode = ''
0.00027	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00018	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00014	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00633	1	getArrayAssoc	SELECT routes.alias FROM routes LEFT JOIN article ON routes.url LIKE CONCAT('%module/article/id/', article.id, '/%') OR routes.url LIKE CONCAT('%module/article/id/', article.id) WHERE article.lang_group = (SELECT lang_group FROM article WHERE id = '696') AND (url LIKE '%site/frontend%' OR url NOT LIKE '%site/%')
0.00024	1	getField	SELECT url FROM search_langs WHERE defaultValue='1' LIMIT 0,1
0.00018	2	getArrayAssoc	SELECT id,url,valueName FROM search_elements WHERE status IS NULL ORDER BY 'order' ASC
0.00013	3	getList	SELECT id,url FROM search_langs
0.00014	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00015	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00011	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00014	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00011	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00014	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00012	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00012	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00013	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00010	0	Run	SET sql_mode = ''
0.00063	332	getList	SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00039	332	getArrayAssoc	SELECT * , CONCAT(field,"##",value,"##",language) as id FROM dh_url_parameters
0.00011	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00011	0	Run	SET sql_mode = ''
0.00030	81	getList	SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text
0.00021	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00014	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00010	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00011	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00018	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00014	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00012	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00008	0	Run	SET sql_mode = ''
0.00030	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00021	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1
0.00007	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00015	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00014	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00009	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00010	0	Run	SET sql_mode = ''
0.00025	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00017	7	getList	SELECT * FROM languages WHERE active=1 ORDER BY name
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00012	1	getField	SELECT id FROM languages WHERE active=1 AND site="frontend" AND default_lang="1" LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00663	634	getArrayAssoc	SELECT MD5(TRIM(lw.text)) as md5 , li.word_id, TRIM(li.text) as text FROM _language_items_view as li LEFT JOIN _language_words_view as lw ON lw.word_id=li.word_id AND lw.language_id='2' WHERE ((li.site='' AND li.module='') OR (li.site='frontend' AND li.module='') OR (li.site='frontend' AND li.module='article')) AND li.mode='1' AND li.language_id='5'
0.00021	3	getArrayAssoc	SELECT * FROM languages WHERE active = 1 AND site = 'frontend' AND id != '5' ORDER BY default_lang DESC,name
0.00011	1	getRow	SELECT * FROM languages WHERE id = '5' LIMIT 0,1
0.00042	8	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id WHERE true AND menus.position=1 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC
0.00034	4	getArrayAssoc	SELECT menus.languages_id , menus.position, m.id, r.url, r.alias, m.openin, m.link_module, m.link_mode, m.protect, m.parent_id, m.visible, m.name, m.link, m.link_prefix, m.menu_image, m.menu_link, r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC
0.00030	7	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="154" ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "155" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "105" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "173" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "144" AND m.visible=1 ORDER BY m.weight ASC
0.00023	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "111" AND m.visible=1 ORDER BY m.weight ASC
0.00023	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "156" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "157" AND m.visible=1 ORDER BY m.weight ASC
0.00028	7	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="158" ORDER BY m.weight ASC
0.00024	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "160" AND m.visible=1 ORDER BY m.weight ASC
0.00024	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "117" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "172" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "135" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "136" AND m.visible=1 ORDER BY m.weight ASC
0.00056	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "159" AND m.visible=1 ORDER BY m.weight ASC
0.00023	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "161" AND m.visible=1 ORDER BY m.weight ASC
0.00031	3	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="162" ORDER BY m.weight ASC
0.00024	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "107" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "112" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "163" AND m.visible=1 ORDER BY m.weight ASC
0.00026	3	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="164" ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "165" AND m.visible=1 ORDER BY m.weight ASC
0.00023	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "166" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "167" AND m.visible=1 ORDER BY m.weight ASC
0.00010	14	getList	SELECT * FROM dynamic_text
0.00023	10	getArrayAssoc	SELECT * FROM banner WHERE banner_categories_id = '1' AND languages_id='5' AND ((publish_from IS NULL AND publish_till IS NULL) OR (publish_from <= NOW() AND publish_till IS NULL) OR (publish_till >= NOW() AND publish_from IS NULL) OR (NOW() between publish_from and publish_till)) AND published = 1 ORDER BY priority DESC
0.00041	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00013	1	getList	SELECT * FROM module_enabler
0.00073	0	getArrayAssoc	SELECT fuv.last_view_date, p.* FROM frontend_users_views as fuv INNER JOIN properties as p ON fuv.property_id = p.property_id WHERE fuv.DHU="w3jdCilvGVwiVyQwXOn" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200
0.00029	1	getRow	SELECT * FROM article WHERE id="696" LIMIT 0,1
0.00029	14	getList	SELECT * FROM dynamic_text

Q.Time(s)

Aff. Rows

Run

Query

0.00011

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00009

Run

SET sql_mode = ''

0.00035

getRow

SELECT url, active FROM routes WHERE alias='pl/komunikat-rodo' OR alias='/pl/komunikat-rodo' LIMIT 0,1

0.00016

getList

SELECT id, code FROM languages WHERE active = '1' AND site = 'frontend' ORDER BY default_lang DESC

0.00009

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00009

Run

SET sql_mode = ''

0.00045

getList

SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"

0.00014

getArrayAssoc

SELECT id,url FROM search_element_values WHERE element_id='1'

0.00012

getArrayAssoc

SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'

0.00011

getArrayAssoc

SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'

0.00011

getField

SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00015

getField

SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1

0.00018

getField

SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00012

getField

SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1

0.00013

getField

SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1

0.00011

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00007

Run

SET sql_mode = ''

0.00027

getField

SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1

0.00018

getField

SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00014

getField

SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1

0.00633

getArrayAssoc

SELECT routes.alias FROM routes LEFT JOIN article ON routes.url LIKE CONCAT('%module/article/id/', article.id, '/%') OR routes.url LIKE CONCAT('%module/article/id/', article.id) WHERE article.lang_group = (SELECT lang_group FROM article WHERE id = '696') AND (url LIKE '%site/frontend%' OR url NOT LIKE '%site/%')

0.00024

getField

SELECT url FROM search_langs WHERE defaultValue='1' LIMIT 0,1

0.00018

getArrayAssoc

SELECT id,url,valueName FROM search_elements WHERE status IS NULL ORDER BY 'order' ASC

0.00013

getList

SELECT id,url FROM search_langs

0.00014

getArrayAssoc

SELECT id,url,query_value FROM search_element_values WHERE element_id='1'

0.00015

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'

0.00011

getArrayAssoc

SELECT id,url,query_value FROM search_element_values WHERE element_id='2'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'

0.00014

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'

0.00011

getArrayAssoc

SELECT id,url,query_value FROM search_element_values WHERE element_id='1'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'

0.00014

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'

0.00012

getArrayAssoc

SELECT id,url,query_value FROM search_element_values WHERE element_id='2'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'

0.00012

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'

0.00011

getArrayAssoc

SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'

0.00013

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00010

Run

SET sql_mode = ''

0.00063

332

getList

SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00039

332

getArrayAssoc

SELECT * , CONCAT(field,"##",value,"##",language) as id FROM dh_url_parameters

0.00011

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00011

Run

SET sql_mode = ''

0.00030

getList

SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text

0.00021

getArrayAssoc

SELECT id,url FROM search_element_values WHERE element_id='1'

0.00014

getArrayAssoc

SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'

0.00010

getArrayAssoc

SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'

0.00011

getField

SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00018

getField

SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1

0.00014

getField

SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1

0.00012

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00008

Run

SET sql_mode = ''

0.00030

getField

SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1

0.00021

getField

SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1

0.00007

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00015

getField

SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1

0.00014

getField

SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1

0.00009

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00010

Run

SET sql_mode = ''

0.00025

getField

SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00017

getList

SELECT * FROM languages WHERE active=1 ORDER BY name

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00012

getField

SELECT id FROM languages WHERE active=1 AND site="frontend" AND default_lang="1" LIMIT 0,1

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00663

634

getArrayAssoc

SELECT MD5(TRIM(lw.text)) as md5 , li.word_id, TRIM(li.text) as text FROM _language_items_view as li LEFT JOIN _language_words_view as lw ON lw.word_id=li.word_id AND lw.language_id='2' WHERE ((li.site='' AND li.module='') OR (li.site='frontend' AND li.module='') OR (li.site='frontend' AND li.module='article')) AND li.mode='1' AND li.language_id='5'

0.00021

getArrayAssoc

SELECT * FROM languages WHERE active = 1 AND site = 'frontend' AND id != '5' ORDER BY default_lang DESC,name

0.00011

getRow

SELECT * FROM languages WHERE id = '5' LIMIT 0,1

0.00042

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id WHERE true AND menus.position=1 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC

0.00034

getArrayAssoc

SELECT menus.languages_id , menus.position, m.id, r.url, r.alias, m.openin, m.link_module, m.link_mode, m.protect, m.parent_id, m.visible, m.name, m.link, m.link_prefix, m.menu_image, m.menu_link, r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC

0.00030

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="154" ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "155" AND m.visible=1 ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "105" AND m.visible=1 ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "173" AND m.visible=1 ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "144" AND m.visible=1 ORDER BY m.weight ASC

0.00023

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "111" AND m.visible=1 ORDER BY m.weight ASC

0.00023

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "156" AND m.visible=1 ORDER BY m.weight ASC

0.00021

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "157" AND m.visible=1 ORDER BY m.weight ASC

0.00028

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="158" ORDER BY m.weight ASC

0.00024

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "160" AND m.visible=1 ORDER BY m.weight ASC

0.00024

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "117" AND m.visible=1 ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "172" AND m.visible=1 ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "135" AND m.visible=1 ORDER BY m.weight ASC

0.00021

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "136" AND m.visible=1 ORDER BY m.weight ASC

0.00056

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "159" AND m.visible=1 ORDER BY m.weight ASC

0.00023

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "161" AND m.visible=1 ORDER BY m.weight ASC

0.00031

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="162" ORDER BY m.weight ASC

0.00024

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "107" AND m.visible=1 ORDER BY m.weight ASC

0.00021

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "112" AND m.visible=1 ORDER BY m.weight ASC

0.00021

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "163" AND m.visible=1 ORDER BY m.weight ASC

0.00026

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="164" ORDER BY m.weight ASC

0.00022

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "165" AND m.visible=1 ORDER BY m.weight ASC

0.00023

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "166" AND m.visible=1 ORDER BY m.weight ASC

0.00021

getArrayAssoc

SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "167" AND m.visible=1 ORDER BY m.weight ASC

0.00010

getList

SELECT * FROM dynamic_text

0.00023

getArrayAssoc

SELECT * FROM banner WHERE banner_categories_id = '1' AND languages_id='5' AND ((publish_from IS NULL AND publish_till IS NULL) OR (publish_from <= NOW() AND publish_till IS NULL) OR (publish_till >= NOW() AND publish_from IS NULL) OR (NOW() between publish_from and publish_till)) AND published = 1 ORDER BY priority DESC

0.00041

getArrayAssoc

SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1

0.00013

getList

SELECT * FROM module_enabler

0.00073

getArrayAssoc

SELECT fuv.last_view_date, p.* FROM frontend_users_views as fuv INNER JOIN properties as p ON fuv.property_id = p.property_id WHERE fuv.DHU="w3jdCilvGVwiVyQwXOn" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200

0.00029

getRow

SELECT * FROM article WHERE id="696" LIMIT 0,1

0.00029

getList

SELECT * FROM dynamic_text

Array ( [core_data] => Array ( [config] => Array ( [core_config] => Array ( [version] => 1.0 [less] => 0 [dirs] => Array ( [bigcore] => bigcore ) [email] => Array ( [enable_developer_mode] => 1 [developer_address] => wwwformularze@metrohouse.pl [from_name] => Metrohouse.pl [from_email] => crm@metrohouse.pl ) [database] => Array ( [host] => localhost [user] => metro_production_devuser [pass] => nPsm7cEFGq9fGCb2BYhJSQ5N [database] => mh [charset] => UTF8 [collation] => utf8_general_ci ) [memcached] => Array ( [host] => localhost [port] => 11211 [enable] => 0 [flush] => 1 ) [authantication] => Array ( [bigcore_hash] => 6bb8a2147d1550d56cc24e7cd577b043 ) [default_site] => frontend [loader_load_prefix] => ../../ [error] => Array ( [enable_error_handler] => 1 [show_apache_error_handler] => 0 [error_handler_level] => E_ALL [show_bigcore_error_handler] => 0 ) [devbar] => Array ( [enable_devel_bar] => 1 [show_devel_bar] => 1 ) [log] => Array ( [error_log] => Array ( [enable] => 0 [filename] => files/log/error.log [sizelimit] => 20971520 ) [debug_log] => Array ( [enable] => 0 [filename] => files/log/debug.log [sizelimit] => 20971520 ) [mysql_log] => Array ( [enable] => 0 [onlyerror] => 1 [filename] => files/log/mysql.log [sizelimit] => 20971520 ) [slowquery_log] => Array ( [limit] => 0 [enable] => 1 [filename] => files/log/slow_query.log [sizelimit] => 20971520 ) ) [debug] => Array ( [enable] => 1 ) [form] => Array ( [after_text] => : [radiobox] => Array ( [radiobox_pattern] =>

##input####label##

) [checkbox] => Array ( [checkbox_pattern] =>

##input####label##

Name	Time(s)
Total Load	0.40248
Config Load	0.05335
Module Load	0.30877
SQL Execution	0.036
Generate Tpl	0.04036

Name

Time(s)

Total Load

0.40248

Config Load

0.05335

Module Load

0.30877

SQL Execution

0.036

Generate Tpl

0.04036

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	9,873.1484 kB	9.6417 MB
Include Files	6,611.9844 kB	6.4570 MB
Module Load	906.5938 kB	0.8853 MB
Generate Tpl	2,354.5703 kB	2.2994 MB

Name

Memory usage (kB)

Memory usage (MB)

Total Memory Usage

9,873.1484 kB

9.6417 MB

Include Files

6,611.9844 kB

6.4570 MB

Module Load

906.5938 kB

0.8853 MB

Generate Tpl

2,354.5703 kB

2.2994 MB

	Report
	Data
	Query
	0.40248 s
	9.6417 MB

INFORMACJA DLA KLIENTÓW GRUPY METROHOUSE

Masz pytania? Skontaktuj się z nami lub odwiedź najbliższe biuro Metrohouse.

+48 22 626 pokaż!

Czy ten wpis okazał się przydatny? Udostępnij znajomym

Wyślij wiadomość mailem

Czy ten wpis okazał się przydatny? Wyślij znajomym!

Wyślij wiadomość mailem

Nasi klienci powiedzieli

Czy ten wpis okazał się przydatny?
Wyślij znajomym!