ЖК Соловьиная роща

Общее выполнеия сценариев:
0.024959
Время выполнения запроса: 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, "anket" as curTab, SUBSTRING( 'genplan/' from length(n2.url)+1 ) trail FROM anket 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, "faq" as curTab, SUBSTRING( 'genplan/' from length(n4.url)+1 ) trail FROM faq 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, "actions" as curTab, SUBSTRING( 'genplan/' from length(n5.url)+1 ) trail FROM actions 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, "genplan" as curTab, SUBSTRING( 'genplan/' from length(n6.url)+1 ) trail FROM genplan n6, main m6 WHERE 'genplan/' LIKE CONCAT(n6.url,"%") AND m6.visible = 1 AND n6.id=m6.id) UNION ALL (SELECT n7.id, n7.genmod, n7.url, n7.name as name, m7.parent_id, "specpage" as curTab, SUBSTRING( 'genplan/' from length(n7.url)+1 ) trail FROM specpage n7, main m7 WHERE 'genplan/' LIKE CONCAT(n7.url,"%") AND m7.visible = 1 AND n7.id=m7.id) ) t ORDER BY length(SUBSTRING('genplan/' from length(t.url)+1 )) Limit 1
параметры:
:curl=>genplan/ тип: 2
составило
0.000802
Время выполнения CMSCore
Время выполнения запроса: SELECT name as name, keywords as keywords, description as description FROM genplan where id = '1011'
параметры:
:id=>1011 тип: 2
составило
9.7E-5
Время выполнения CallMe
0.002701
Время выполнения Form
0.001644
Время выполнения CallMe2
0.001289
Время выполнения Form
0.000718
Время выполнения GenPlan
0.006549
Время выполнения ReservFlat
0.00326
Время выполнения Form
0.001174
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило
0.000139
Время выполнения MenuNav
0.001102
Время выполнения запроса: 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 actions n5, main m5 WHERE m5.id = n5.id AND m5.visible = 1 AND n5.in_menu = 1)) as t order by t.SORTORDER составило
0.000734

Квартира номер 1

Хочу купить