Город-парк Новые Горки

Отдел продаж
8 (843) 2-677-677
Заказать звонок

МЕНЮ

1
ком 2
ком 3
ком

КВАРТИРЫ

ОФИСЫ

Общее выполнеия сценариев:
0.046707
Время выполнения запроса: SELECT t.* FROM ( (SELECT n1.id, n1.genmod, n1.url, content as content, 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, null as content, n2.name as name, m2.parent_id, 'complex' as curTab, SUBSTRING( 'genplan/' from length(n2.url)+1 ) trail FROM complex 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, null as content, 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, null as content, n4.name as name, m4.parent_id, 'mactions' as curTab, SUBSTRING( 'genplan/' from length(n4.url)+1 ) trail FROM mactions 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, null as content, n5.name as name, m5.parent_id, 'genplan' as curTab, SUBSTRING( 'genplan/' from length(n5.url)+1 ) trail FROM genplan 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, null as content, 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.001642
Время выполнения CMSCore
Время выполнения запроса: SELECT name as name, keywords as keywords, description as description FROM specpage where id = '340' Limit 0,1
параметры:
:id=>340 тип: 2
составило
0.000145
Время выполнения Menu
0.000878
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило
0.000391
Время выполнения SelectFlat
9.3E-5
Время выполнения SelectFlat
0.030534
Время выполнения запроса: SELECT DISTINCT h.*, GROUP_CONCAT(DISTINCT ap.`rooms`) AS rooms FROM `house` h INNER JOIN main m ON (h.id = m.id and m.visible = 1) LEFT JOIN `section` s ON (s.`parent_id` = h.`id`) LEFT JOIN `floor` f ON (f.`parent_id` = s.`id` ) LEFT JOIN section_plan sp ON (sp.parent_id = f.id) LEFT JOIN `apartment_plan` ap ON (sp.`plan_type` = ap.id) WHERE h.parent_id = '340' AND h.house_type='a' group by h.id order by m.sortorder
параметры:
:nodeId=>340 тип: 2

:houseType=>a тип: 2
составило
0.020332
Время выполнения запроса: SELECT DISTINCT h.* FROM house h INNER JOIN main m ON (h.id = m.id and m.visible = 1) WHERE h.parent_id = '340' AND h.house_type='c' order by m.sortorder
параметры:
:nodeId=>340 тип: 2

:houseType=>c тип: 2
составило
0.000641
Время выполнения запроса: SELECT n.*, m.sortorder, mi.icon, mi.icon_hover, mi.name as mark_name, mi.group_code FROM map_marker n INNER JOIN main m ON m.id=n.id AND m.visible=1 LEFT JOIN mark_icons mi ON n.icon_type = mi.id WHERE n.parent_id='1639' ORDER BY n.icon_type
параметры:
:pid=>1639 тип: 2
составило
0.000606