Nieruchomość na wynajem, Mieszkania Bytom - Mieszkanie

Q.Time(s)	Aff. Rows	Run	Query
0.00005	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00004	0	Run	SET sql_mode = ''
0.00026	0	getRow	SELECT url, active FROM routes WHERE alias='do-wynajecia/mieszkanie/bytom' OR alias='/do-wynajecia/mieszkanie/bytom' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00015	10	getList	SELECT * FROM dh_url_parameters WHERE field="sale_or_rent"
0.00008	1	getField	SELECT location_id FROM search_small_cities WHERE city_translit = 'bytom' LIMIT 0,1
0.00005	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00007	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00003	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00003	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00010	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00005	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00007	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.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00006	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00004	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-vermieten' AND type='value' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00001	0	Run	SET sql_mode = ''
0.00004	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00004	1	getField	SELECT url FROM search_langs WHERE defaultValue='1' LIMIT 0,1
0.00004	2	getArrayAssoc	SELECT id,url,valueName FROM search_elements WHERE status IS NULL ORDER BY 'order' ASC
0.00002	3	getList	SELECT id,url FROM search_langs
0.00003	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00004	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00003	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00002	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00002	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00002	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00002	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00002	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00002	2	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='1'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='en'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='1' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='en'
0.00002	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='2' AND lang='de'
0.00002	7	getArrayAssoc	SELECT id,url,query_value FROM search_element_values WHERE element_id='2'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='en'
0.00002	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='3' AND lang='de'
0.00002	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='4' AND lang='en'
0.00002	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.00004	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='5' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='6' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='7' AND lang='de'
0.00003	1	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='8' AND lang='de'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='en'
0.00003	0	getArrayAssoc	SELECT id,lang,url FROM search_element_lang WHERE type='value' AND element_id='9' AND lang='de'
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00020	332	getList	SELECT CONCAT(field,"##",value,"##",language) as id , url FROM dh_url_parameters
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00001	0	Run	SET sql_mode = ''
0.00020	332	getArrayAssoc	SELECT * , CONCAT(field,"##",value,"##",language) as id FROM dh_url_parameters
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00011	81	getList	SELECT CONCAT(compliler,"##",other_param,"##",language) as id , search_text FROM dh_url_search_text
0.00005	2	getArrayAssoc	SELECT id,url FROM search_element_values WHERE element_id='1'
0.00003	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='1' AND type='value'
0.00002	2	getArrayAssoc	SELECT url FROM search_element_lang WHERE element_id='2' AND type='value'
0.00002	1	getField	SELECT lang FROM search_element_lang WHERE url='for-sale' AND type='value' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00010	1	getField	SELECT id FROM languages WHERE active=1 AND code='en' AND site='frontend' ORDER BY name LIMIT 0,1
0.00002	1	getField	SELECT lang FROM search_element_lang WHERE url='zu-verkaufen' AND type='value' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00007	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00002	1	getField	SELECT lang FROM search_element_lang WHERE url='for-rent' AND type='value' LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00008	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.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00001	0	Run	SET sql_mode = ''
0.00005	0	getField	SELECT id FROM languages WHERE active=1 AND code='de' AND site='frontend' ORDER BY name LIMIT 0,1
0.00001	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00001	0	Run	SET sql_mode = ''
0.00006	7	getList	SELECT * FROM languages WHERE active=1 ORDER BY name
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00006	1	getField	SELECT id FROM languages WHERE active=1 AND site="frontend" AND default_lang="1" LIMIT 0,1
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00719	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.00024	3	getArrayAssoc	SELECT * FROM languages WHERE active = 1 AND site = 'frontend' AND id != '5' ORDER BY default_lang DESC,name
0.00006	1	getRow	SELECT * FROM languages WHERE id = '5' LIMIT 0,1
0.00028	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.00020	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.00017	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.00011	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.00010	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.00008	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.00006	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.00006	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.00010	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.00007	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.00010	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.00006	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.00006	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.00006	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.00005	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.00005	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.00005	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.00005	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.00007	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.00006	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.00006	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.00005	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.00007	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.00006	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.00005	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.00007	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.00005	14	getList	SELECT * FROM dynamic_text
0.00015	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.00027	1	getArrayAssoc	SELECT * FROM velemenyek WHERE visible = 1 AND language='5' AND tipus=1 ORDER BY rand() LIMIT 0,1
0.00004	1	getList	SELECT * FROM module_enabler
0.00045	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="JJk977iSxSyu2IExsC3a" AND p.status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D' ) GROUP BY fuv.property_id ORDER BY fuv.last_view_date DESC LIMIT 200
0.00039	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.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00008	19	getList	SELECT single,plural FROM words_plurals
0.00004	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00009	0	getArrayAssoc	SELECT * FROM street_locations WHERE IsDeleted != 1 AND street_locations_id IN (63627)
0.00003	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00007	0	getArrayAssoc	SELECT * FROM street_locations WHERE IsDeleted != 1 AND street_locations_id IN (63627)
0.00006	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00003	0	Run	SET sql_mode = ''
0.00016	0	getArrayAssoc	SELECT * FROM street_locations WHERE IsDeleted != 1 AND street_locations_id IN (63627)
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00004	0	getArrayAssoc	SELECT * FROM street_locations WHERE IsDeleted != 1 AND street_locations_id IN (63627)
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00004	0	getArrayAssoc	SELECT * FROM street_locations WHERE IsDeleted != 1 AND street_locations_id IN (63627)
0.00032	1	getCount	SELECT COUNT(*) as count FROM properties AS p WHERE true AND status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D') AND IsShow = 1 AND sale_or_rent='SPV00000000010K' AND investment_id IS NULL AND property_type IN ('SPV0000000000Y6') AND (city IN ('3130000004273') OR district IN ('3130000004273') OR county IN ('3130000004273')) AND ((development_id = '') OR (development_id IS NULL))
0.00029	1	getArrayAssoc	SELECT * FROM properties AS p WHERE true AND status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D') AND IsShow = 1 AND sale_or_rent='SPV00000000010K' AND investment_id IS NULL AND property_type IN ('SPV0000000000Y6') AND (city IN ('3130000004273') OR district IN ('3130000004273') OR county IN ('3130000004273')) AND ((development_id = '') OR (development_id IS NULL)) AND only_mh = 1 ORDER BY first_activation_at DESC LIMIT 0,3
0.00024	1	getArrayAssoc	SELECT * FROM properties AS p WHERE true AND status IN ('SPV00000000011F', 'SPV000000000582', 'SPV00000000011D') AND IsShow = 1 AND sale_or_rent='SPV00000000010K' AND investment_id IS NULL AND property_type IN ('SPV0000000000Y6') AND (city IN ('3130000004273') OR district IN ('3130000004273') OR county IN ('3130000004273')) AND ((development_id = '') OR (development_id IS NULL)) ORDER BY first_activation_at DESC LIMIT 0,30
0.00067	1	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 ('2240041098479') GROUP BY p.property_id
0.00317	0	getArrayAssoc	SELECT agentId, clientComment, clientName FROM client_agent_score WHERE rating = 5 AND LENGTH(clientComment) > 1 AND approved = 1 AND agentId IN (7350000000485) ORDER BY createdAt DESC
0.00002	0	Run	SET NAMES UTF8 COLLATE utf8_general_ci
0.00002	0	Run	SET sql_mode = ''
0.00028	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 ('2240041098479') ) GROUP BY g.sys_record_id

Empty!

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

Name	Time(s)
Total Load	0.15806
Config Load	0.00582
Module Load	0.12714
SQL Execution	0.02106
Generate Tpl	0.02510

Name	Memory usage (kB)	Memory usage (MB)
Total Memory Usage	3,030.8750 kB	2.9598 MB
Include Files	1,211.2734 kB	1.1829 MB
Module Load	960.1250 kB	0.9376 MB
Generate Tpl	859.4766 kB	0.8393 MB

	Report
	Data
	Query
	0.15806 s
	2.9598 MB

Nieruchomość na wynajem, Mieszkania Bytom - Mieszkanie

Wyszukiwanie szczegółowe

Mieszkanie na wynajem, Mickiewicza

Eliza Kozielska