Nieruchomości biura - Biała Podlaska

Q.Time(s)	Aff. Rows	Run	Query
0.00011	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00008	0	Run	SET sql_mode = ''
0.00029	0	getRow	SELECT url, active FROM routes WHERE alias='biura-nieruchomosc-656010197/listmode-2' OR alias='/biura-nieruchomosc-656010197/listmode-2' LIMIT 0,1
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.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.00008	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00010	0	Run	SET sql_mode = ''
0.00029	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00010	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.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.00009	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.00014	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00008	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.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.00234	0	getArrayAssoc	SELECT alias FROM routes WHERE (url LIKE '%module/properties/lang/5/%' OR url LIKE '%module/properties/lang/5') AND (url LIKE '%site/frontend%' OR url NOT LIKE '%site/%')
0.00010	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.00009	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00008	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.00007	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.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00007	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00007	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00007	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00008	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00009	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.00016	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00012	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00010	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.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.00008	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.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.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.00008	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00033	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.00039	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.00005	0	Run	SET sql_mode = ''
0.00015	81	getList	SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text
0.00010	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00009	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.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.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.00009	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.00011	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.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00012	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00009	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00014	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00011	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.00006	0	Run	SET sql_mode = ''
0.01240	1064	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='properties')) 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.00046	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.00035	4	getArrayAssoc	SELECT menus.languages_id , menus.position, m.id, r.url, r.alias, m.openin, m.link_module, m.link_mode, m.protect, m.parent_id, m.visible, m.name, m.link, m.link_prefix, m.menu_image, m.menu_link, r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.visible=1 AND m.parent_id = 0 ORDER BY m.weight ASC
0.00030	7	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE m.visible = 1 AND m.parent_id="154" ORDER BY m.weight ASC
0.00022	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "155" AND m.visible=1 ORDER BY m.weight ASC
0.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 = "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.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 = "144" 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 = "111" 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 = "156" 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 = "157" AND m.visible=1 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="158" 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 = "160" 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 = "117" 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 = "172" 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 = "135" 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 = "136" 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 = "159" 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 = "161" AND m.visible=1 ORDER BY m.weight ASC
0.00025	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.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 = "107" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "112" AND m.visible=1 ORDER BY m.weight ASC
0.00021	0	getArrayAssoc	SELECT menus.languages_id , menus.position,m.id,r.url,r.alias,m.openin,m.link_module,m.link_mode,m.protect, m.parent_id,m.visible,m.name,m.link,m.link_prefix,r2.alias as article_alias FROM menu_items as m LEFT JOIN routes as r ON r.id = m.route_id LEFT JOIN article as a ON m.article = a.id LEFT JOIN routes as r2 ON r2.id = a.route_id LEFT JOIN menus as menus ON menus.id = m.menu_id WHERE true AND menus.position=2 AND menus.languages_id="5" AND m.parent_id = "163" AND m.visible=1 ORDER BY m.weight ASC
0.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.00010	14	getList	SELECT * FROM dynamic_text
0.00021	10	getArrayAssoc	SELECT * FROM banner WHERE banner_categories_id = '1' AND languages_id='5' AND ((publish_from IS NULL AND publish_till IS NULL) OR (publish_from <= NOW() AND publish_till IS NULL) OR (publish_till >= NOW() AND publish_from IS NULL) OR (NOW() between publish_from and publish_till)) AND published = 1 ORDER BY priority DESC
0.00040	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00009	1	getList	SELECT * FROM module_enabler
0.00078	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="ii15ZwolBHLPY9RbWzXW" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200
0.00052	0	getRow	SELECT * FROM banner WHERE banner_categories_id = '5' 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 LIMIT 0,1
0.00010	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00021	1	getField	SELECT office_name FROM offices WHERE office_id="656010197" LIMIT 0,1
0.00008	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00015	1	getField	SELECT office_name FROM offices WHERE office_id="656010197" LIMIT 0,1
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00006	0	Run	SET sql_mode = ''
0.00010	1	getField	SELECT office_name FROM offices WHERE office_id="656010197" LIMIT 0,1
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00009	1	getField	SELECT office_name FROM offices WHERE office_id="656010197" LIMIT 0,1
0.00133	1	getCount	SELECT COUNT(*) as count FROM properties AS p WHERE true AND status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D') AND IsShow = 1 AND investment_id IS NULL AND office_id = '656010197' AND ((development_id = '') OR (development_id IS NULL))
0.00089	2	getArrayAssoc	SELECT * FROM properties AS p WHERE true AND status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D') AND IsShow = 1 AND investment_id IS NULL AND office_id = '656010197' AND ((development_id = '') OR (development_id IS NULL)) AND only_mh = 1 ORDER BY first_activation_at DESC LIMIT 0,3
0.00093	2	getArrayAssoc	SELECT * FROM properties AS p WHERE true AND status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D') AND IsShow = 1 AND investment_id IS NULL AND office_id = '656010197' AND ((development_id = '') OR (development_id IS NULL)) ORDER BY first_activation_at DESC LIMIT 0,30
0.00229	2	getArrayAssoc	SELECT p.property_id AS property_id, p.record_owner_id AS record_owner_id, u.name AS name, REPLACE(u.PicturePath, '\\', '/') AS image, u.agentRating AS rating, u.agentLevel AS level, u.showStars AS showStars, ad.monthSalesman AS month_salesman, r.alias AS alias FROM properties AS p LEFT JOIN users AS u ON u.user_id = p.record_owner_id LEFT JOIN agent_desc AS ad ON ad.agentId = p.record_owner_id LEFT JOIN routes AS r ON r.url = CONCAT("/module/agents/type/form/id/", u.user_id) WHERE p.property_id IN ('2240041078564','1941068643') GROUP BY p.property_id
0.00850	47	getArrayAssoc	SELECT agentId, clientComment, clientName FROM client_agent_score WHERE rating = 5 AND LENGTH(clientComment) > 1 AND approved = 1 AND agentId IN (7350000000409,7350000000283) ORDER BY createdAt DESC
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00005	0	Run	SET sql_mode = ''
0.00059	1	getList	SELECT g.sys_record_id, coalesce((SELECT gad.original_pic_url FROM gallery_pictures_properties gad WHERE gad.sys_record_id = g.sys_record_id AND (gad.ad_pic = '1' AND gad.allo_kep = 0 AND alaprajz = 0) LIMIT 1 offset 0),(SELECT gad.original_pic_url FROM gallery_pictures_properties gad WHERE gad.sys_record_id = g.sys_record_id AND gad.allo_kep = 0 AND gad.alaprajz = 0 ORDER BY pic_order ASC LIMIT 1 offset 0),(SELECT gad.original_pic_url FROM gallery_pictures_properties gad WHERE gad.sys_record_id = g.sys_record_id AND gad.allo_kep = 0 ORDER BY pic_order ASC LIMIT 1 offset 0),(SELECT gad.original_pic_url FROM gallery_pictures_properties gad WHERE gad.sys_record_id = g.sys_record_id ORDER BY pic_order ASC LIMIT 1 offset 0)) as img_url FROM gallery_pictures_properties AS g WHERE (sys_record_id IN ('2240041078564','1941068643') ) GROUP BY g.sys_record_id

Empty!

POST »
GET »
REQUEST »
COOKIE »
SESSION »
MEMCACHE STATUS »

Name	Time(s)
Total Load	0.37130
Config Load	0.01283
Module Load	0.30895
SQL Execution	0.04793
Generate Tpl	0.04952

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	2,934.3594 kB	2.8656 MB
Include Files	1,222.7969 kB	1.1941 MB
Module Load	974.5938 kB	0.9518 MB
Generate Tpl	736.9688 kB	0.7197 MB

	Report
	Data
	Query
	0.37130 s
	2.8656 MB

Nieruchomości biura - Biała Podlaska

Wyszukiwanie szczegółowe

Mieszkanie na sprzedaż, Warszawska

Dom na sprzedaż