2014-03-20

Ile wynegocjujesz przy kupnie mieszkania?

Każdy lubi się targować, ale nie każdy potrafi.

Negocjacje ceny szczególnie istotne są przy zakupach dóbr takich jak mieszkania, gdzie rekordzistom udaje się obniżyć cenę nawet o więcej niż 10 procent.

W rzeczywistości przeciętne negocjacje mieszkania na rynku wtórnym nie są aż tak spektakularne. Na podstawie kilkuset tegorocznych transakcji przeprowadzonych w największych miastach w Polsce prześledziliśmy, ile można wynegocjować kupując mieszkanie na rynku wtórnym. Wartość negocjacji to wyrażona procentowo różnica pomiędzy ostatnią ceną ofertową a ceną transakcyjną uzgodnioną pomiędzy stronami umowy sprzedaży. Dla uzyskania największej wiarygodności ze zbioru transakcji usunięto najwyższe i najniższe wartości negocjacji.

Uzyskane wyniki w poszczególnych miastach wskazują, że największe procentowo wartości negocjujemy w Krakowie, gdzie średnio udaje się obniżyć cenę ofertową o 3,2 proc. Jeśli weźmiemy pod uwagę, że średnia kwota transakcji w Krakowie to 315 tys. zł to w portfelu nabywcy zostaje średnio 10 080 zł. Podobne procentowo negocjacje dotyczą Gdańska (3,1 proc.) i Łodzi (3 proc.). W miastach tych nabywcom udaje się średnio zaoszczędzić odpowiednio 8990 zł i 5190 zł. W pozostałych analizowanych miastach wartości negocjacji są niższe niż 3 proc. i wynoszą w Poznaniu 2,7 proc., we Wrocławiu 2,3 proc., a w Warszawie zaledwie 2,2 proc. czyli nominalnie 8932 zł.

Jednocześnie tylko w 5 proc. transakcji udało się wynegocjować więcej niż 10 proc. ceny ofertowej. Bez względu na miasto, w którym odbywała się transakcja najwyższe obniżki dotyczyły lokali o największym metrażu. Średni metraż mieszkania, które podlegało największym negocjacjom wynosi aż 99 m kw. Na przykład 130-metrowe mieszkanie z 2012 r. na gdańskiej Morenie wycenione wstępnie na 754 tys. zł sprzedano za 615 tys. zł. Natomiast w Krakowie 100 m kw. w kamienicy na Starym Mieście z ceną ofertową 547 tys. zł udało się kupić za 470 tys. zł.

Jak wynegocjować więcej? O tym już wkrótce na naszym blogu.

Czy znasz naszą nową usługę Negocjatorzy Metrohouse? - kliknij

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

Serdecznie Państwu dziękuję za profesjonalną i merytoryczną pomoc, wielkie zaangażowanie i życzliwość. Z całą pewnością polecę Państwa usługi innym potencjalnym klientom.Szczególne podziękowania składam na ręce Pani Justyny Buczek, która jest osobą niezwykle życzliwą, pomocną i kompetentną, bardzo operatywną, o wysokiej kulturze osobistej oraz niezwykle ujmującej osobowości.

— Violetta D., Gdańsk

Q.Time(s)	Aff. Rows	Run	Query
0.00012	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00009	0	Run	SET sql_mode = ''
0.00040	1	getRow	SELECT url, active FROM routes WHERE alias='blog-negocjatorzy_metrohouse' OR alias='/blog-negocjatorzy_metrohouse' LIMIT 0,1
0.00014	4	getList	SELECT id, code FROM languages WHERE active = '1' AND site = 'frontend' ORDER BY default_lang DESC
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00022	10	getList	SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"
0.00015	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00013	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.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00013	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00011	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00008	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00007	0	Run	SET sql_mode = ''
0.00026	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.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.00012	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.00005	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.00234	358	getArrayAssoc	SELECT alias FROM routes WHERE (url LIKE '%module/blog/%' OR url LIKE '%module/blog') AND (url LIKE '%site/frontend%' OR url NOT LIKE '%site/%')
0.00033	1	getField	SELECT url FROM search_langs WHERE defaultValue='1' LIMIT 0,1
0.00014	2	getArrayAssoc	SELECT id,url,valueName FROM search_elements WHERE status IS NULL ORDER BY 'order' ASC
0.00010	3	getList	SELECT id,url FROM search_langs
0.00013	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00014	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00015	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.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00010	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.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00009	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00010	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00010	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00013	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00011	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00011	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.00011	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.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00011	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	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00009	0	Run	SET sql_mode = ''
0.00055	332	getList	SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters
0.00007	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00045	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.00002	0	Run	SET sql_mode = ''
0.00015	81	getList	SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text
0.00017	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.00012	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.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	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.00014	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' 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.00010	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.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00020	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00012	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' 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	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.00006	0	Run	SET sql_mode = ''
0.00014	7	getList	SELECT * FROM languages WHERE active=1 ORDER BY name
0.00007	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 site="frontend" AND default_lang="1" LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00689	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='blog')) AND li.mode='1' AND li.language_id='5'
0.00025	3	getArrayAssoc	SELECT * FROM languages WHERE active = 1 AND site = 'frontend' AND id != '5' ORDER BY default_lang DESC,name
0.00012	1	getRow	SELECT * FROM languages WHERE id = '5' LIMIT 0,1
0.00047	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.00031	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.00026	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.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 = "105" 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 = "173" AND m.visible=1 ORDER BY m.weight ASC
0.00025	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.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 = "111" AND m.visible=1 ORDER BY m.weight ASC
0.00027	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.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 = "157" AND m.visible=1 ORDER BY m.weight ASC
0.00031	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.00025	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.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 = "172" 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 = "135" AND m.visible=1 ORDER BY m.weight ASC
0.00027	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.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 = "159" 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 = "161" AND m.visible=1 ORDER BY m.weight ASC
0.00028	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.00025	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.00026	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.00027	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.00027	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.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 = "166" 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 = "167" AND m.visible=1 ORDER BY m.weight ASC
0.00011	14	getList	SELECT * FROM dynamic_text
0.00024	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.00042	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00010	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="jVnbABXPCdu93EfNVRws" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200
0.00043	1	getRow	SELECT * FROM blog WHERE id="91" LIMIT 0,1
0.00022	14	getList	SELECT * FROM dynamic_text

Q.Time(s)

Aff. Rows

Run

Query

0.00012

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00009

Run

SET sql_mode = ''

0.00040

getRow

SELECT url, active FROM routes WHERE alias='blog-negocjatorzy_metrohouse' OR alias='/blog-negocjatorzy_metrohouse' LIMIT 0,1

0.00014

getList

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00022

getList

SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"

0.00015

getArrayAssoc

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

0.00013

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

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00013

getField

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

0.00011

getField

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

0.00008

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00007

Run

SET sql_mode = ''

0.00026

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

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

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

358

getArrayAssoc

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

0.00033

getField

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

0.00014

getArrayAssoc

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

0.00010

getList

SELECT id,url FROM search_langs

0.00013

getArrayAssoc

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

0.00014

getArrayAssoc

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

0.00011

getArrayAssoc

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

0.00011

getArrayAssoc

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

0.00015

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

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

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

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00013

getArrayAssoc

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

0.00011

getArrayAssoc

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

0.00011

getArrayAssoc

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

0.00011

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

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

getArrayAssoc

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

0.00011

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

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00009

Run

SET sql_mode = ''

0.00055

332

getList

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

0.00007

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00045

332

getArrayAssoc

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00002

Run

SET sql_mode = ''

0.00015

getList

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

0.00017

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

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

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

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

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

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

getField

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

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00020

getField

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

0.00012

getField

SELECT lang FROM search_element_lang WHERE url='zu-vermieten' 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='de' AND site='frontend' ORDER BY name LIMIT 0,1

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00014

getList

SELECT * FROM languages WHERE active=1 ORDER BY name

0.00007

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 site="frontend" AND default_lang="1" LIMIT 0,1

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00689

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

0.00025

getArrayAssoc

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

0.00012

getRow

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

0.00047

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

0.00025

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.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 = "111" AND m.visible=1 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 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.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 = "157" 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="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.00025

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.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 = "172" 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 = "135" AND m.visible=1 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 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.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 = "159" 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 = "161" 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="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.00025

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

0.00011

getList

SELECT * FROM dynamic_text

0.00024

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

getArrayAssoc

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

0.00010

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

0.00043

getRow

SELECT * FROM blog WHERE id="91" LIMIT 0,1

0.00022

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.39480
Config Load	0.04093
Module Load	0.31485
SQL Execution	0.03055
Generate Tpl	0.03902

Name

Time(s)

Total Load

0.39480

Config Load

0.04093

Module Load

0.31485

SQL Execution

0.03055

Generate Tpl

0.03902

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	9,866.0625 kB	9.6348 MB
Include Files	6,616.5078 kB	6.4614 MB
Module Load	910.5469 kB	0.8892 MB
Generate Tpl	2,339.0078 kB	2.2842 MB

Name

Memory usage (kB)

Memory usage (MB)

Total Memory Usage

9,866.0625 kB

9.6348 MB

Include Files

6,616.5078 kB

6.4614 MB

Module Load

910.5469 kB

0.8892 MB

Generate Tpl

2,339.0078 kB

2.2842 MB

	Report
	Data
	Query
	0.39480 s
	9.6348 MB

Ile wynegocjujesz przy kupnie mieszkania?

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!