2018-09-27

Raport Metrohouse i Expandera Wrzesień 2018

Spośród największych polskich miast tylko w dwóch wzrosty cen na rynku wtórnym zostały nieco zahamowane. Tymczasem we Wrocławiu, Krakowie, Poznaniu i Gdańsku ceny w transakcjach są najwyższe od 2011 r. Nabywcy mieszkań, poza wzrostem cen lokali, muszą się liczyć z galopującymi podwyżkami cen materiałów budowlanych oraz robocizny. Jednocześnie nie ustaje boom na rynku kredytów hipotecznych ale, w przeciwieństwie do mieszkań, kredyty staniały.

Dylematy kupujących

Kwestia coraz wyższych cen w budowlance spędza sen z oczu deweloperom, ale dla indywidualnego nabywcy ma także niebagatelne znaczenie, tym bardziej, że oddawane do użytku mieszkania wymagają znacznych nakładów remontowych. Coraz więcej kupujących zaczyna kalkulować opłacalność zakupu mieszkania – porównując rynek wtórny i pierwotny. Atutem zakupu mieszkania z drugiej ręki jest możliwość w miarę szybkiego wprowadzenia się do takiego lokalu i rozłożenia w czasie ewentualnych prac remontowych. Oferty, zwłaszcza z ostatniej dekady, charakteryzują się dobrym standardem, a ich stan umożliwia wprowadzenie się po nieznacznym odświeżeniu. Takie mieszkania znajdują się na wysokich miejscach list poszukiwań. – Podwyżki cen w budowlance nie wpływają jeszcze znacząco na osłabienie popytu na mieszkania z rynku pierwotnego, choć przy obecnym tempie wzrostów cen nie jest wykluczone, że może to stanowić ważny czynnik przy zakupie mieszkania, komentuje Marcin Jańczuk z sieci biur nieruchomości Metrohouse.

Coraz droższe mieszkania

W porównaniu do sytuacji sprzed miesiąca tylko w dwóch miastach ceny nie uległy wzrostom. Pierwsze z nich to Łódź, gdzie nabywcy wybierali mieszkania tańsze średnio o 4 proc. i Warszawa, gdzie w porównaniu do poprzedniego miesiąca nie odnotowujemy zmian. – W innych dużych miastach ceny wzrosły. W Gdańsku w ostatnich transakcjach cena m kw. przekroczyła poziom 6500 zł. Jest to o prawie 1000 zł więcej niż w analogicznym okresie zeszłego roku. Od wielu miesięcy rosną też ceny w Krakowie. Po raz pierwszy w historii naszego raportu przekroczyły poziom 7000 zł za m kw. (dokładnie 7066 zł), komentuje Marcin Jańczuk z Metrohouse.

Na rynku boom, a kredyty tanieją

Jeśli chodzi o zainteresowanie kredytami mieszkaniowymi, to wygląda na to, że możemy już mówić o prawdziwym boomie. Według BIK wartość złożonych w sierpniu wniosków była aż o 28,5% wyższa niż przed rokiem. - W przeciwieństwie do mieszkań, kredyty na szczęście nie drożeją. Są wręcz tańsze niż przed rokiem. Dla przykładu średnie oprocentowanie w przypadku kredytów dla posiadaczy wysokiego (25%) wkładu własnego wynosi teraz 3,79%, podczas gdy przed rokiem było to 3,90%, komentuje Jarosław Sadowski, ekspert Expandera.

Oprocentowanie spadło, a raty wzrosły o 12%

Mimo, że oprocentowanie spadło, to w minionym roku aż o 12% wzrosła rata przeciętnego kredytu. – Dzieje się tak ponieważ zadłużamy się na coraz większe kwoty, co wymuszają na nas coraz wyższe ceny mieszkań. Według BIK średnio chcemy pożyczyć 254 tys. zł, podczas gdy przed rokiem było to ok. 225 tys. Ten wzrost niweluje efekt spadku oprocentowania i powoduje, że raty nowo udzielanych kredytów są coraz wyższe, dodaje Jarosław Sadowski z Expandera.

Raport Metrohouse i Expandera Wrzesień 2018 from 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.00007	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00032	1	getRow	SELECT url, active FROM routes WHERE alias='news-raport-metrohouse-i-expandera-wrzesien-2018' OR alias='/news-raport-metrohouse-i-expandera-wrzesien-2018' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00021	10	getList	SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"
0.00012	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00008	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00007	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00007	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00012	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00015	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00015	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00011	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00010	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00008	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00010	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00213	765	getArrayAssoc	SELECT alias FROM routes WHERE (url LIKE '%module/news/%' OR url LIKE '%module/news') AND (url LIKE '%site/frontend%' OR url NOT LIKE '%site/%')
0.00013	1	getField	SELECT url FROM search_langs WHERE defaultValue='1' LIMIT 0,1
0.00010	2	getArrayAssoc	SELECT id,url,valueName FROM search_elements WHERE status IS NULL ORDER BY 'order' ASC
0.00007	3	getList	SELECT id,url FROM search_langs
0.00008	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00006	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00006	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00006	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00006	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00006	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00006	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00006	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00031	332	getList	SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00036	332	getArrayAssoc	SELECT * , CONCAT(field,"##",value,"##",language) as id FROM dh_url_parameters
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00013	81	getList	SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text
0.00010	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00008	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00007	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00007	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00012	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00010	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00010	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00008	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00014	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00008	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00010	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00012	7	getList	SELECT * FROM languages WHERE active=1 ORDER BY name
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00009	1	getField	SELECT id FROM languages WHERE active=1 AND site="frontend" AND default_lang="1" LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00641	617	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='news')) AND li.mode='1' AND li.language_id='5'
0.00016	3	getArrayAssoc	SELECT * FROM languages WHERE active = 1 AND site = 'frontend' AND id != '5' ORDER BY default_lang DESC,name
0.00008	1	getRow	SELECT * FROM languages WHERE id = '5' LIMIT 0,1
0.00040	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.00030	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.00027	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.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 = "155" AND m.visible=1 ORDER BY m.weight ASC
0.00020	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.00019	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.00019	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.00019	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.00019	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.00026	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.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 = "160" AND m.visible=1 ORDER BY m.weight ASC
0.00020	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.00019	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.00019	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.00019	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.00018	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.00018	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.00021	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.00019	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.00018	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.00018	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.00022	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.00019	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.00018	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.00018	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.00008	14	getList	SELECT * FROM dynamic_text
0.00017	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.00040	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00008	1	getList	SELECT * FROM module_enabler
0.00066	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="TikA2diHIWccMKHgAYU9" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200
0.00038	1	getRow	SELECT * FROM news WHERE id="607" LIMIT 0,1
0.00031	14	getList	SELECT * FROM dynamic_text

Q.Time(s)

Aff. Rows

Run

Query

0.00007

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00032

getRow

SELECT url, active FROM routes WHERE alias='news-raport-metrohouse-i-expandera-wrzesien-2018' OR alias='/news-raport-metrohouse-i-expandera-wrzesien-2018' LIMIT 0,1

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00021

getList

SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"

0.00012

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00012

getField

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

0.00015

getField

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

0.00004

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='de' AND site='frontend' ORDER BY name LIMIT 0,1

0.00011

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00010

getField

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

0.00008

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00010

getField

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

0.00213

765

getArrayAssoc

SELECT alias FROM routes WHERE (url LIKE '%module/news/%' OR url LIKE '%module/news') AND (url LIKE '%site/frontend%' OR url NOT LIKE '%site/%')

0.00013

getField

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

0.00010

getArrayAssoc

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

0.00007

getList

SELECT id,url FROM search_langs

0.00008

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00006

getArrayAssoc

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00031

332

getList

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00036

332

getArrayAssoc

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00013

getList

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

0.00010

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00007

getArrayAssoc

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

0.00007

getField

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

0.00003

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='en' AND site='frontend' ORDER BY name LIMIT 0,1

0.00010

getField

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00010

getField

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

0.00008

getField

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00014

getField

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

0.00008

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00010

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00012

getList

SELECT * FROM languages WHERE active=1 ORDER BY name

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00009

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00641

617

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='news')) AND li.mode='1' AND li.language_id='5'

0.00016

getArrayAssoc

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

0.00008

getRow

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

0.00040

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.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, 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.00027

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.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 = "155" AND m.visible=1 ORDER BY m.weight ASC

0.00020

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.00019

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.00019

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.00019

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.00019

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.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="158" 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 = "160" AND m.visible=1 ORDER BY m.weight ASC

0.00020

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.00019

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.00019

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.00019

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.00018

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.00018

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.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 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.00019

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.00018

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.00018

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.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 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.00019

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.00018

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.00018

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.00008

getList

SELECT * FROM dynamic_text

0.00017

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.00040

getArrayAssoc

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

0.00008

getList

SELECT * FROM module_enabler

0.00066

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="TikA2diHIWccMKHgAYU9" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200

0.00038

getRow

SELECT * FROM news WHERE id="607" LIMIT 0,1

0.00031

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.39003
Config Load	0.03582
Module Load	0.31443
SQL Execution	0.02428
Generate Tpl	0.03977

Name

Time(s)

Total Load

0.39003

Config Load

0.03582

Module Load

0.31443

SQL Execution

0.02428

Generate Tpl

0.03977

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	9,875.7500 kB	9.6443 MB
Include Files	6,614.5547 kB	6.4595 MB
Module Load	915.5313 kB	0.8941 MB
Generate Tpl	2,345.6641 kB	2.2907 MB

Name

Memory usage (kB)

Memory usage (MB)

Total Memory Usage

9,875.7500 kB

9.6443 MB

Include Files

6,614.5547 kB

6.4595 MB

Module Load

915.5313 kB

0.8941 MB

Generate Tpl

2,345.6641 kB

2.2907 MB

	Report
	Data
	Query
	0.39003 s
	9.6443 MB

Raport Metrohouse i Expandera Wrzesień 2018

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!