2011-02-09

Wspólne raporty z Szybko.pl i Expanderem

Raport Szybko.pl i Expandera jest cyklicznym opracowaniem dotyczącym sytuacji na rynku kredytów hipotecznych i wtórnym rynku nieruchomości. W przypadku analiz rynku kredytów podstawą do opracowywania raportu są ankiety kolportowane przez analityków firmy Expander wśród 30 banków oferujących produkty hipoteczne. Część dotycząca rynku nieruchomości jest przygotowywana przez specjalistów portalu Szybko.pl w oparciu o dane ofertowe nieruchomości zgłoszonych do portalu przez agencje i osoby prywatne.

- Firma Metrohouse & Partnerzy będzie odpowiedzialna za przygotowanie trzeciej części raportu, która będzie powstawała na podstawie danych transakcyjnych. Bazą do analiz będą transakcje dokonywane przez klientów Metrohouse & Partnerzy oraz klientów firmy Expander, mówi Marcin Jańczuk z Metrohouse & Partnerzy. Początkowo analizą objęto 7 miast. Liczba objętych monitoringiem lokalizacji będzie sukcesywnie wzrastać.

- Dane dotyczące cen transakcyjnych pozwolą na stworzenie kompletnego obrazu wtórnego rynku nieruchomości i umożliwią porównanie oferty dostępnej na rynku z potrzebami kupujących a także pozwolą na zidentyfikowanie przyczyn rozbieżności między cenami ofertowymi i transakcyjnymi - mówi Marta Kosińska, analityk Szybko.pl

- Raport Expandera i Szybko.pl jest od 2007 roku ważnym źródłem informacji o sytuacji i trendach na rynku nieruchomości. Teraz dzięki współpracy z Metrohouse i wykorzystaniu danych o transakcjach dokonywanych za pośrednictwem Expandera chcemy wprowadzić nową jakość w raportowaniu o rynku nieruchomości w Polsce – mówi Paweł Majtkowski, główny analityk Expandera.

Pierwszy wspólny raport dotyczący sytuacji na rynku kredytów i wtórnego rynku mieszkań został opublikowany 10. lutego br.

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

"Chciałabym podziękować Pani Laurze. Jest to przemiła osoba. Czuliśmy się bardzo zaopiekowani, regularnie się kontaktowała, to była rzeczywista współpraca trwająca dłuższy czas. To jedyny pośrednik, który wytrwale i naprawdę szukał nam nieruchomości. Ze swojej strony mogę zagwarantować,że jak najbardziej polecam Metrohouse".

— Anna P.

Q.Time(s)	Aff. Rows	Run	Query
0.00010	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00008	0	Run	SET sql_mode = ''
0.00033	1	getRow	SELECT url, active FROM routes WHERE alias='news-wspolne-raporty-z-szybkopl-i-expanderem' OR alias='/news-wspolne-raporty-z-szybkopl-i-expanderem' LIMIT 0,1
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00030	10	getList	SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"
0.00013	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.00010	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00010	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.00011	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.00016	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00012	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' 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	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.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00013	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00312	766	getArrayAssoc	SELECT alias FROM routes WHERE (url LIKE '%module/news/%' OR url LIKE '%module/news') AND (url LIKE '%site/%' OR url NOT LIKE '%site/%')
0.00023	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.00012	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00015	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00011	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.00009	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.00009	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00009	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.00018	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00010	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.00009	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00009	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00009	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.00009	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.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.00009	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.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.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00009	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.00009	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00009	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.00009	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00009	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00009	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.00005	0	Run	SET sql_mode = ''
0.00039	332	getList	SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00034	332	getArrayAssoc	SELECT * , CONCAT(field,"##",value,"##",language) as id FROM dh_url_parameters
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00017	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.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.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	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.00008	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.00003	0	Run	SET sql_mode = ''
0.00010	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00008	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00011	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00008	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00010	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00011	7	getList	SELECT * FROM languages WHERE active=1 ORDER BY name
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00009	1	getField	SELECT id FROM languages WHERE active=1 AND site="frontend" AND default_lang="1" LIMIT 0,1
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00688	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.00009	1	getRow	SELECT * FROM languages WHERE id = '5' LIMIT 0,1
0.00042	8	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id WHERE true AND menus.position=1 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC
0.00031	4	getArrayAssoc	SELECT menus.languages_id , menus.position, m.id, r.url, r.alias, m.openin, m.link_module, m.link_mode, m.protect, m.parent_id, m.visible, m.name, m.link, m.link_prefix, m.menu_image, m.menu_link, r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC
0.00027	7	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="154" ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "155" AND m.visible=1 ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "105" AND m.visible=1 ORDER BY m.weight ASC
0.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.00020	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "144" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "111" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "156" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "157" AND m.visible=1 ORDER BY m.weight ASC
0.00028	7	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="158" ORDER BY m.weight ASC
0.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 = "160" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "117" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "172" AND m.visible=1 ORDER BY m.weight ASC
0.00020	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "135" AND m.visible=1 ORDER BY m.weight ASC
0.00020	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "136" AND m.visible=1 ORDER BY m.weight ASC
0.00020	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "159" AND m.visible=1 ORDER BY m.weight ASC
0.00018	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "161" AND m.visible=1 ORDER BY m.weight ASC
0.00022	3	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="162" 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 = "107" AND m.visible=1 ORDER BY m.weight ASC
0.00020	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "112" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "163" AND m.visible=1 ORDER BY m.weight ASC
0.00022	3	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="164" ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "165" AND m.visible=1 ORDER BY m.weight ASC
0.00019	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "166" AND m.visible=1 ORDER BY m.weight ASC
0.00018	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "167" AND m.visible=1 ORDER BY m.weight ASC
0.00008	14	getList	SELECT * FROM dynamic_text
0.00019	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.00037	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00008	1	getList	SELECT * FROM module_enabler
0.01073	2051	getList	SELECT * FROM sys_picklist_values_all WHERE language_id="5"
0.00040	1	getRow	SELECT * FROM news WHERE id="164" LIMIT 0,1
0.00034	14	getList	SELECT * FROM dynamic_text

Q.Time(s)

Aff. Rows

Run

Query

0.00010

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00008

Run

SET sql_mode = ''

0.00033

getRow

SELECT url, active FROM routes WHERE alias='news-wspolne-raporty-z-szybkopl-i-expanderem' OR alias='/news-wspolne-raporty-z-szybkopl-i-expanderem' LIMIT 0,1

0.00006

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00005

Run

SET sql_mode = ''

0.00030

getList

SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"

0.00013

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

getArrayAssoc

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

0.00010

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

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

getField

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

0.00012

getField

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

0.00312

766

getArrayAssoc

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

0.00023

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

getArrayAssoc

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

0.00015

getArrayAssoc

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

0.00012

getArrayAssoc

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

0.00011

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

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

getArrayAssoc

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

0.00009

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

getArrayAssoc

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

0.00010

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

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00009

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

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

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

getArrayAssoc

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

0.00009

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

getArrayAssoc

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

0.00009

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

getArrayAssoc

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

0.00009

getArrayAssoc

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

0.00009

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

Run

SET sql_mode = ''

0.00039

332

getList

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00034

332

getArrayAssoc

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00017

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

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

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

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

Run

SET sql_mode = ''

0.00010

getField

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

0.00008

getField

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

0.00004

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00011

getField

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

0.00008

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00010

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00011

getList

SELECT * FROM languages WHERE active=1 ORDER BY name

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00004

Run

SET sql_mode = ''

0.00009

getField

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

0.00003

Run

SET NAMES UTF8 COLLATE utf8_general_ci

0.00003

Run

SET sql_mode = ''

0.00688

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

getRow

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

0.00042

getArrayAssoc

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

0.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, m.menu_image, m.menu_link, r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC

0.00027

getArrayAssoc

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

0.00022

getArrayAssoc

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

0.00022

getArrayAssoc

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

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

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00028

getArrayAssoc

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

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

0.00019

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00020

getArrayAssoc

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

0.00020

getArrayAssoc

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

0.00020

getArrayAssoc

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

0.00018

getArrayAssoc

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

0.00022

getArrayAssoc

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

0.00020

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00022

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00019

getArrayAssoc

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

0.00018

getArrayAssoc

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

0.00008

getList

SELECT * FROM dynamic_text

0.00019

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

getArrayAssoc

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

0.00008

getList

SELECT * FROM module_enabler

0.01073

2051

getList

SELECT * FROM sys_picklist_values_all WHERE language_id="5"

0.00040

getRow

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

0.00034

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	1.01323
Config Load	0.04983
Module Load	0.92433
SQL Execution	0.03823
Generate Tpl	0.03907

Name

Time(s)

Total Load

1.01323

Config Load

0.04983

Module Load

0.92433

SQL Execution

0.03823

Generate Tpl

0.03907

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	9,738.7578 kB	9.5105 MB
Include Files	6,141.5469 kB	5.9976 MB
Module Load	1,251.5391 kB	1.2222 MB
Generate Tpl	2,345.6719 kB	2.2907 MB

Name

Memory usage (kB)

Memory usage (MB)

Total Memory Usage

9,738.7578 kB

9.5105 MB

Include Files

6,141.5469 kB

5.9976 MB

Module Load

1,251.5391 kB

1.2222 MB

Generate Tpl

2,345.6719 kB

2.2907 MB

	Report
	Data
	Query
	1.01323 s
	9.5105 MB

Wspólne raporty z Szybko.pl i Expanderem

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!