2011-06-27

Zbawienna zamiana mieszkań

Kiedy zamiana mieszkania na mieszkanie opłaca się bardziej niż transakcja kupna-sprzedaży lokalu? W jakich przypadkach może być korzystniejsza?

Michał Kosiedowski, wiceprezes Metrohouse & Partnerzy S.A.: Zamiany mieszkań są korzystnym rozwiązaniem dla kilku grup osób. Pierwsza to klienci, którzy są posiadaczami kredytów we frankach szwajcarskich. Jeżeli przed kilkoma laty kredytobiorca zaciągnął kredyt przy kursie franka w okolicach 2,2 zł, to sprzedaż mieszkania przy dzisiejszym kursie tej waluty (1 CHF = ok. 3,39 zł – red.) wiąże się dla niego z dużymi stratami finansowymi.

Z szacunków wynika, że we frankach zadłużonych jest ok. 700 tys. Polaków, większość z nich zaciągnęła kredyty w latach 2007-2008, kiedy atrakcyjne warunki kredytowania zachęcały do zadłużania się w tej walucie. Teraz wiele z tych rodzin jest zablokowanych – nie mogą zmienić mieszkania na większe, bo to będzie się wiązać ze spłatą kredytu po dzisiejszym kursie.

Z zamiany mogą skorzystać też osoby starsze, którym coraz częściej proponuje się skorzystanie z mechanizmów odwróconej hipoteki. Zamiana jest o tyle atrakcyjniejsza, że osoba ta przeprowadza się do mniejszego mieszkania, otrzymując dopłatę, którą może przeznaczyć na bieżące potrzeby, i nadal ma na własność nieruchomość, którą może np. darować w drodze spadku.

Zamiany mogą też być dobrym rozwiązaniem dla osób będących w różnych, nowych dla nich sytuacjach życiowych, np. w czasie rozwodu.

W jakich sytuacjach zamiana lokalu może się okazać niemożliwa?

Wtedy, gdy istotną stroną zamian mieszkań jest bank, od którego zgody zależy, czy operacja zamiany deklarowana przez strony transakcji jest w praktyce możliwa do przeprowadzenia. Z pewnością nie uda się zamienić np. większego mieszkania obciążonego kredytem hipotecznym na nieruchomość o istotnie niższej wartości. W takim przypadku bank stwierdzi, że przedstawione zabezpieczenie kredytu będzie niewystarczające, i nie zgodzi się na taką transakcję. W niektórych przypadkach może zażądać dodatkowego zabezpieczenia, np. na innej nieruchomości.

Każdy przypadek jest inny, dlatego jeżeli mamy do czynienia z nieruchomościami obciążonymi kredytem hipotecznym, zanim podpiszemy jakiekolwiek porozumienia czy umowy przedwstępne, warto skonsultować się z bankiem, opisać wariant zamiany i uzyskać informację, czy takie rozwiązanie będzie zaakceptowane przez bank.

Czy łatwiej zamienić duże mieszkanie na dwa mniejsze czy odwrotnie? A dom na mieszkanie?

Zamiana jednego mieszkania na inne – większe na mniejsze lub odwrotnie – jest stosunkowo prosta do realizacji. Trudniejsza będzie zamiana dwóch mieszkań na jedno lub odwrotnie. Tu mamy właściwie do czynienia z trzema stronami, z których każda musi zaakceptować proponowane rozwiązanie.

Ofert zamiany domu na mieszkanie jest najmniej i tu raczej będzie najtrudniej przeprowadzić taką operację. Nie wynika to z trudności formalnych, ale raczej z braku świadomości właścicieli nieruchomości o tym, że zamiast sprzedawać, można się zamienić. Dlatego nasi klienci są informowani o takiej formie transakcji i wielu z nich jest skłonnych do przeprowadzenia zamiany.

Cały wywiad znajduje się na stronach Rzeczpospolitej

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

,,Pragnę podkreślić wysoką jakość usługi z jaką się spotkałam. Na szczególne wyróżnienie zasługuje oferta, jaką przygotował dla mnie Pan Jarosław Machoń. Pracownik nie ograniczył się tylko do zaprezentowania ofert sprzedaży mieszkań, ale przedstawił również opis linii komunikacyjnych z poszczególnych miejsc, czas przejazdu i czas dojścia pieszo do przystanku."

— Marzanna P., Gdańsk

Q.Time(s)	Aff. Rows	Run	Query
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00020	1	getRow	SELECT url, active FROM routes WHERE alias='news-zbawienna-zamiana-mieszkan' OR alias='/news-zbawienna-zamiana-mieszkan' LIMIT 0,1
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00007	0	Run	SET sql_mode = ''
0.00023	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.00010	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00008	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00008	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.00012	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.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00012	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00010	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.00005	0	Run	SET sql_mode = ''
0.00023	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00014	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00016	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00274	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.00016	1	getField	SELECT url FROM search_langs WHERE defaultValue='1' LIMIT 0,1
0.00011	2	getArrayAssoc	SELECT id,url,valueName FROM search_elements WHERE status IS NULL ORDER BY 'order' ASC
0.00008	3	getList	SELECT id,url FROM search_langs
0.00012	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.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00008	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00008	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.00008	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.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00008	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.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00015	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.00010	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00010	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00011	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00008	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00008	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.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00009	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00008	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.00007	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00040	332	getList	SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00042	332	getArrayAssoc	SELECT * , CONCAT(field,"##",value,"##",language) as id FROM dh_url_parameters
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00016	81	getList	SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text
0.00013	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00010	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00009	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00009	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00018	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00009	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	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.00009	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.00005	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-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.00012	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00013	7	getList	SELECT * FROM languages WHERE active=1 ORDER BY name
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00010	1	getField	SELECT id FROM languages WHERE active=1 AND site="frontend" AND default_lang="1" LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00687	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.00021	3	getArrayAssoc	SELECT * FROM languages WHERE active = 1 AND site = 'frontend' AND id != '5' ORDER BY default_lang DESC,name
0.00011	1	getRow	SELECT * FROM languages WHERE id = '5' LIMIT 0,1
0.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.00037	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.00053	7	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="154" ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "155" AND m.visible=1 ORDER BY m.weight ASC
0.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 = "105" 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 = "173" 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 = "144" 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 = "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.00046	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.00035	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.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 = "117" 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 = "172" 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 = "135" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "136" AND m.visible=1 ORDER BY m.weight ASC
0.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 = "159" AND m.visible=1 ORDER BY m.weight ASC
0.00023	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "161" AND m.visible=1 ORDER BY m.weight ASC
0.00030	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.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 = "107" 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 = "112" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "163" AND m.visible=1 ORDER BY m.weight ASC
0.00024	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.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 = "165" 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 = "166" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "167" AND m.visible=1 ORDER BY m.weight ASC
0.00009	14	getList	SELECT * FROM dynamic_text
0.00022	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.00035	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00009	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="vBbxWykdzMsbQKlEVARu" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200
0.00041	1	getRow	SELECT * FROM news WHERE id="202" LIMIT 0,1
0.00020	14	getList	SELECT * FROM dynamic_text

Q.Time(s)

Aff. Rows

Run

Query

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00020

getRow

SELECT url, active FROM routes WHERE alias='news-zbawienna-zamiana-mieszkan' OR alias='/news-zbawienna-zamiana-mieszkan' LIMIT 0,1

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00007

Run

SET sql_mode = ''

0.00023

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

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

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

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

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00012

getField

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

0.00010

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

Run

SET sql_mode = ''

0.00023

getField

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

0.00014

getField

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

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00016

getField

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

0.00274

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

getField

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

0.00011

getArrayAssoc

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

0.00008

getList

SELECT id,url FROM search_langs

0.00012

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

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

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

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

getArrayAssoc

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

0.00008

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

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00015

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

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00011

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

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

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00008

getArrayAssoc

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

0.00008

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

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00040

332

getList

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00042

332

getArrayAssoc

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00016

getList

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

0.00013

getArrayAssoc

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

0.00010

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00009

getField

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

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00018

getField

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

0.00009

getField

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

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

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

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

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-vermieten' AND type='value' LIMIT 0,1

0.00005

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00012

getField

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

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00006

Run

SET sql_mode = ''

0.00013

getList

SELECT * FROM languages WHERE active=1 ORDER BY name

0.00004

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00687

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

getArrayAssoc

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

0.00011

getRow

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

0.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.00037

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

getArrayAssoc

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

0.00022

getArrayAssoc

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

0.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 = "105" 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 = "173" 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 = "144" 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 = "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.00046

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

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

0.00021

getArrayAssoc

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

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

0.00023

getArrayAssoc

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

0.00030

getArrayAssoc

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

0.00022

getArrayAssoc

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

0.00021

getArrayAssoc

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

0.00009

getList

SELECT * FROM dynamic_text

0.00022

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

getArrayAssoc

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

0.00009

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

0.00041

getRow

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

0.00020

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.40504
Config Load	0.04613
Module Load	0.31675
SQL Execution	0.02889
Generate Tpl	0.04217

Name

Time(s)

Total Load

0.40504

Config Load

0.04613

Module Load

0.31675

SQL Execution

0.02889

Generate Tpl

0.04217

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	9,839.3594 kB	9.6087 MB
Include Files	6,581.8906 kB	6.4276 MB
Module Load	911.7969 kB	0.8904 MB
Generate Tpl	2,345.6719 kB	2.2907 MB

Name

Memory usage (kB)

Memory usage (MB)

Total Memory Usage

9,839.3594 kB

9.6087 MB

Include Files

6,581.8906 kB

6.4276 MB

Module Load

911.7969 kB

0.8904 MB

Generate Tpl

2,345.6719 kB

2.2907 MB

	Report
	Data
	Query
	0.40504 s
	9.6087 MB

Zbawienna zamiana mieszkań

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!