УНИСТРОЙ. ЦАРЕВО Village

Фильтр Квартир

Параметры поиска

На генплане Список Планировки

очистить параметры

Инфраструктура

Общее выполнеия сценариев:
0.286211
Время выполнения запроса: SELECT t.* FROM ( (SELECT n1.id, n1.genmod, n1.url, n1.name as name, m1.parent_id, "node_sites" as curTab, SUBSTRING( 'genplan/' from length(n1.url)+1 ) trail FROM node_sites n1, main m1 WHERE 'genplan/' LIKE CONCAT(n1.url,"%") AND m1.visible = 1 AND n1.id=m1.id) UNION ALL (SELECT n2.id, n2.genmod, n2.url, n2.name as name, m2.parent_id, "district" as curTab, SUBSTRING( 'genplan/' from length(n2.url)+1 ) trail FROM district n2, main m2 WHERE 'genplan/' LIKE CONCAT(n2.url,"%") AND m2.visible = 1 AND n2.id=m2.id) UNION ALL (SELECT n3.id, n3.genmod, n3.url, n3.name as name, m3.parent_id, "mnews" as curTab, SUBSTRING( 'genplan/' from length(n3.url)+1 ) trail FROM mnews n3, main m3 WHERE 'genplan/' LIKE CONCAT(n3.url,"%") AND m3.visible = 1 AND n3.id=m3.id) UNION ALL (SELECT n4.id, n4.genmod, n4.url, n4.name as name, m4.parent_id, "actions" as curTab, SUBSTRING( 'genplan/' from length(n4.url)+1 ) trail FROM actions n4, main m4 WHERE 'genplan/' LIKE CONCAT(n4.url,"%") AND m4.visible = 1 AND n4.id=m4.id) UNION ALL (SELECT n5.id, n5.genmod, n5.url, n5.name as name, m5.parent_id, "ipoteka" as curTab, SUBSTRING( 'genplan/' from length(n5.url)+1 ) trail FROM ipoteka n5, main m5 WHERE 'genplan/' LIKE CONCAT(n5.url,"%") AND m5.visible = 1 AND n5.id=m5.id) UNION ALL (SELECT n6.id, n6.genmod, n6.url, n6.name as name, m6.parent_id, "specpage" as curTab, SUBSTRING( 'genplan/' from length(n6.url)+1 ) trail FROM specpage n6, main m6 WHERE 'genplan/' LIKE CONCAT(n6.url,"%") AND m6.visible = 1 AND n6.id=m6.id) ) t ORDER BY length(SUBSTRING('genplan/' from length(t.url)+1 )) Limit 1
параметры:
:curl=>genplan/ тип: 2
составило
0.001059
Время выполнения CMSCore
Время выполнения запроса: SELECT name as name, keywords as keywords, description as description FROM district where id = '7063'
параметры:
:id=>7063 тип: 2
составило
0.000295
Время выполнения MenuNav
0.000178
Время выполнения MenuNav
0.000136
Время выполнения MainPlan
0.223089
Время выполнения MenuNav
4.8E-5
Время выполнения запроса: SELECT DISTINCT t.* FROM ( (SELECT DISTINCT m1.id, IFNULL(m1.parent_id,0) as parent_id, n1.name as name, n1.URL as url, m1.SORTORDER FROM node_sites n1, main m1 WHERE m1.id = n1.id AND m1.visible = 1 /*AND n1.in_menu = 1*/) UNION ALL (SELECT DISTINCT m2.id, IFNULL(m2.parent_id,0) as parent_id, n2.name as name, n2.URL as url, m2.SORTORDER FROM district n2, main m2 WHERE m2.id = n2.id AND m2.visible = 1 /*AND n2.in_menu = 1*/) UNION ALL (SELECT DISTINCT m3.id, IFNULL(m3.parent_id,0) as parent_id, n3.name as name, n3.URL as url, m3.SORTORDER FROM mnews n3, main m3 WHERE m3.id = n3.id AND m3.visible = 1 /*AND n3.in_menu = 1*/) UNION ALL (SELECT DISTINCT m4.id, IFNULL(m4.parent_id,0) as parent_id, n4.name as name, n4.URL as url, m4.SORTORDER FROM actions n4, main m4 WHERE m4.id = n4.id AND m4.visible = 1 /*AND n4.in_menu = 1*/) UNION ALL (SELECT DISTINCT m5.id, IFNULL(m5.parent_id,0) as parent_id, n5.name as name, n5.URL as url, m5.SORTORDER FROM ipoteka n5, main m5 WHERE m5.id = n5.id AND m5.visible = 1 /*AND n5.in_menu = 1*/) UNION ALL (SELECT DISTINCT m6.id, IFNULL(m6.parent_id,0) as parent_id, n6.name as name, n6.URL as url, m6.SORTORDER FROM specpage n6, main m6 WHERE m6.id = n6.id AND m6.visible = 1 /*AND n6.in_menu = 1*/)) as t order by t.SORTORDER составило
0.001711
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило
0.000254