Завод ЖБИ №3 | Избранные

Сравнение квартир

избранных квартир:0

Объект
Комнат
Площадь
Дом
Подъезд
Этаж
Квартира
100% оплата/ипотека 11-12%
Рассрочка
Ипотека 7.7-8.95%

Общее выполнеия сценариев:
0.019292
Время выполнения запроса: 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( 'fav/' from length(n1.url)+1 ) trail FROM node_sites n1, main m1 WHERE 'fav/' 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( 'fav/' from length(n2.url)+1 ) trail FROM complex n2, main m2 WHERE 'fav/' 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( 'fav/' from length(n3.url)+1 ) trail FROM mnews n3, main m3 WHERE 'fav/' 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, 'genplan' as curTab, SUBSTRING( 'fav/' from length(n4.url)+1 ) trail FROM genplan n4, main m4 WHERE 'fav/' 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, 'specpage' as curTab, SUBSTRING( 'fav/' from length(n5.url)+1 ) trail FROM specpage n5, main m5 WHERE 'fav/' LIKE CONCAT(n5.url,'%') AND m5.visible = 1 AND n5.id=m5.id) ) t ORDER BY length(SUBSTRING('fav/' FROM length(t.url)+1 )) LIMIT 1
параметры:
:curl=>fav/ тип: 2
составило
0.003632
Время выполнения CMSCore
Время выполнения запроса: SELECT name as name, keywords as keywords, description as description FROM specpage where id = '1301' Limit 0,1
параметры:
:id=>1301 тип: 2
составило
0.000333
Время выполнения Menu
0.00112
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило
0.000462
Время выполнения PopupBanners
0.001011
Время выполнения запроса: SELECT t.* from banner t, main m WHERE t.id = m.id AND m.visible = 1 AND now() between IFNULL(t.start_date,"2000-01-01") and IFNULL(t.last_date,"2038-01-01") order by m.sortorder asc составило
0.000634
Время выполнения запроса: SELECT a.apartment_ui, a.house, a.section, a.floor_ap_number, a.floor, a.complex, a.apart_number, a.apart_square, a.cost,a.cost2,a.`cost3`, a.sold_status, ELT(a.sold_status+1,"В продаже","Продана","Бронь","Скоро в продаже") AS status_name, h.floors_count, h.sections_count, sp.plan_type, h.address, h.house_no, h.id AS house_id, h.deadline, f.floor_plan, sp.`path_appartment`, a.rooms_count, ap.`render`, ap.`scheme`, se.`id` AS section_id FROM apartments a INNER JOIN section_plan sp ON (sp.`app_plan_no` = a.`floor_ap_number`) INNER JOIN `floor` f -- необходимо учитывать этаж, иначе 2 записи выводятся ON (sp.parent_id = f.id AND FIND_IN_SET(a.floor,f.floor_numbers)) INNER JOIN `section` se ON (f.parent_id = se.id AND se.`section_no` = a.`section`) INNER JOIN house h ON (h.id = se.parent_id AND h.house_no = a.house AND h.`house_ui` = CONCAT_WS("-",a.complex,LPAD(a.house,4,0))) LEFT JOIN apartment_plan ap ON (ap.`id` = sp.`plan_type`) WHERE a.apartment_ui = '' and 'rodina' = 'rodina' Limit 0,1
параметры:
:uid=> тип: 2

:complex=>rodina тип: 2
составило
0.006729