ЖК Весна | Генплан

Движение
солнца

Генплан
II очереди

подбор квартиры по параметрам

Подземная
парковка

ипотека
рассрочка

Экскурсия

ЧИСТОВАЯ
ОТДЕЛКА

Наша компания является одним из ведущих лидеров регионального рынка недвижимости. Мы создаем комфортное и доступное жилье. Предложение не является публичной офертой.
ООО Специализированный застройщик «СК «Унистройдом»

+7 (843) 295-53-83 заказать звонок

Избранные квартиры

Общее выполнеия сценариев:
0.041696
Время выполнения запроса: SELECT t.* FROM ( (SELECT n1.id, n1.genmod, n1.url, n1.name as name, m1.parent_id, "node_sites" as curTab, SUBSTRING( 'index/' from length(n1.url)+1 ) trail FROM node_sites n1, main m1 WHERE 'index/' 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, "mnews" as curTab, SUBSTRING( 'index/' from length(n2.url)+1 ) trail FROM mnews n2, main m2 WHERE 'index/' 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, "ipoteka" as curTab, SUBSTRING( 'index/' from length(n3.url)+1 ) trail FROM ipoteka n3, main m3 WHERE 'index/' 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, "genplan" as curTab, SUBSTRING( 'index/' from length(n4.url)+1 ) trail FROM genplan n4, main m4 WHERE 'index/' 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, "specpage" as curTab, SUBSTRING( 'index/' from length(n5.url)+1 ) trail FROM specpage n5, main m5 WHERE 'index/' LIKE CONCAT(n5.url,"%") AND m5.visible = 1 AND n5.id=m5.id) ) t ORDER BY length(SUBSTRING('index/' from length(t.url)+1 )) Limit 1
параметры:
:curl=>index/ тип: 2
составило
0.000264
Время выполнения CMSCore
Время выполнения CallMe2
0.001279
Время выполнения Form
0.000732
Время выполнения CallMe2
0.001078
Время выполнения Form
0.000761
Время выполнения запроса: SELECT name as name, keywords as keywords, description as description FROM genplan where id = '1011'
параметры:
:id=>1011 тип: 2
составило
0.000143
Время выполнения Form
0.000438
Время выполнения GenPlan
0.027085
Время выполнения запроса: SELECT DISTINCT h.id, h.name AS house_name, h.address AS house_address, h.house_status, h.floors_count, h.apparts_count, h.maping_area, h.top, h.left, h.house_no, h.floors_count, h.sections_count, h.deadline, h.data_viewbox, h.can_buy, h.link_parking, h.link_stores, h.temporary_url, (SELECT count(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND (a1.sold_status in (0,2,4,5)) ) AS apparts_free_count, (SELECT count(a2.apartment_ui) FROM apartments a2 WHERE a2.house = h.house_no ) AS apparts_count, (SELECT min(a3.apart_square) FROM apartments a3 WHERE a3.house = h.house_no ) AS min_area, (SELECT max(a4.apart_square) FROM apartments a4 WHERE a4.house = h.house_no ) AS max_area FROM house h LEFT JOIN apartments a ON h.house_no = a.house WHERE h.can_buy = 1 AND h.parent_id = '1011'
параметры:
:planId=>1011 тип: 2
составило
0.000587
Время выполнения запроса: SELECT t.*, m.picture as mark_pic from infrastruktura_item t INNER JOIN marks m ON m.id = t.mark INNER JOIN main n ON n.id = t.id and n.visible=1 where t.parent_id = '1186'
параметры:
:pid=>1186 тип: 2
составило
0.000333
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '2660' GROUP BY s.id
параметры:
:houseId=>2660 тип: 2
составило
0.000317
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '7729' GROUP BY s.id
параметры:
:houseId=>7729 тип: 2
составило
0.000141
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '8655' GROUP BY s.id
параметры:
:houseId=>8655 тип: 2
составило
0.000129
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '9393' GROUP BY s.id
параметры:
:houseId=>9393 тип: 2
составило
0.000279
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '10399' GROUP BY s.id
параметры:
:houseId=>10399 тип: 2
составило
0.000371
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '11109' GROUP BY s.id
параметры:
:houseId=>11109 тип: 2
составило
0.000179
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '11812' GROUP BY s.id
параметры:
:houseId=>11812 тип: 2
составило
0.00033
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '12932' GROUP BY s.id
параметры:
:houseId=>12932 тип: 2
составило
0.000181
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '14261' GROUP BY s.id
параметры:
:houseId=>14261 тип: 2
составило
0.000136
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '14296' GROUP BY s.id
параметры:
:houseId=>14296 тип: 2
составило
0.000318
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '14884' GROUP BY s.id
параметры:
:houseId=>14884 тип: 2
составило
0.000195
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '15463' GROUP BY s.id
параметры:
:houseId=>15463 тип: 2
составило
0.000209
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '15668' GROUP BY s.id
параметры:
:houseId=>15668 тип: 2
составило
0.000147
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '16110' GROUP BY s.id
параметры:
:houseId=>16110 тип: 2
составило
0.000123
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '16111' GROUP BY s.id
параметры:
:houseId=>16111 тип: 2
составило
0.000138
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '17391' GROUP BY s.id
параметры:
:houseId=>17391 тип: 2
составило
0.000175
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '17505' GROUP BY s.id
параметры:
:houseId=>17505 тип: 2
составило
0.000288
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '18292' GROUP BY s.id
параметры:
:houseId=>18292 тип: 2
составило
0.000295
Время выполнения запроса: SELECT s.*, (SELECT COUNT(a1.apartment_ui) FROM apartments a1 WHERE a1.house = h.house_no AND a1.section = s.section_no AND a1.sold_status in (0,4,2,5) ) AS free_flat_cnt, 0 future_flat_cnt FROM section s INNER JOIN main m on m.id = s.id and m.visible = 1 INNER JOIN house h on h.id = s.parent_id WHERE s.parent_id = '18952' GROUP BY s.id
параметры:
:houseId=>18952 тип: 2
составило
0.000155
Время выполнения MenuNav
0.00079
Время выполнения запроса: 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 genplan 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 faq 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 mnews 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 specpage 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 actions n6, main m6 WHERE m6.id = n6.id AND m6.visible = 1 AND n6.in_menu = 1) UNION ALL (SELECT DISTINCT m7.id, IFNULL(m7.parent_id,0) as parent_id, n7.name as name, n7.URL as url, m7.SORTORDER FROM promo n7, main m7 WHERE m7.id = n7.id AND m7.visible = 1 AND n7.in_menu = 1)) as t order by t.SORTORDER составило
0.000196
Время выполнения MainBanners
0.001235
Время выполнения запроса: SELECT t.* from banner t, main m WHERE t.id = m.id AND m.visible = 1 AND now() between t.start_date and t.last_date order by m.id limit 0,1 составило
0.000823
Время выполнения SubMenu
6.8E-5
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило
0.000223