В данном разделе мы будем рассказывать о методиках, которые применяются в нашем центре.
Остались вопросы? Задайте свой вопрос нашим врачам!
Мы будем рады набрать вас и ответить на все ваши вопросы!
Общее выполнеия сценариев: 0.026055
Время выполнения запроса: SELECT t.*
FROM ( (SELECT n1.id,
n1.genmod,
n1.url,
n1.name as name,
m1.parent_id,
"node_sites" as curTab,
SUBSTRING( 'methods/' from length(n1.url)+1 ) trail
FROM node_sites n1, main m1
WHERE 'methods/' 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( 'methods/' from length(n2.url)+1 ) trail
FROM mnews n2, main m2
WHERE 'methods/' 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,
"persons" as curTab,
SUBSTRING( 'methods/' from length(n3.url)+1 ) trail
FROM persons n3, main m3
WHERE 'methods/' 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,
"docs" as curTab,
SUBSTRING( 'methods/' from length(n4.url)+1 ) trail
FROM docs n4, main m4
WHERE 'methods/' 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,
"team" as curTab,
SUBSTRING( 'methods/' from length(n5.url)+1 ) trail
FROM team n5, main m5
WHERE 'methods/' 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,
"services" as curTab,
SUBSTRING( 'methods/' from length(n6.url)+1 ) trail
FROM services n6, main m6
WHERE 'methods/' 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,
"service_sets" as curTab,
SUBSTRING( 'methods/' from length(n7.url)+1 ) trail
FROM service_sets n7, main m7
WHERE 'methods/' LIKE CONCAT(n7.url,"%")
AND m7.visible = 1
AND n7.id=m7.id) UNION ALL (SELECT n8.id,
n8.genmod,
n8.url,
n8.name as name,
m8.parent_id,
"specpage" as curTab,
SUBSTRING( 'methods/' from length(n8.url)+1 ) trail
FROM specpage n8, main m8
WHERE 'methods/' LIKE CONCAT(n8.url,"%")
AND m8.visible = 1
AND n8.id=m8.id) UNION ALL (SELECT n9.id,
n9.genmod,
n9.url,
n9.name as name,
m9.parent_id,
"oms_node" as curTab,
SUBSTRING( 'methods/' from length(n9.url)+1 ) trail
FROM oms_node n9, main m9
WHERE 'methods/' LIKE CONCAT(n9.url,"%")
AND m9.visible = 1
AND n9.id=m9.id) ) t
ORDER BY length(SUBSTRING('methods/' from length(t.url)+1 ))
Limit 1 параметры: :curl=>methods/ тип: 2 составило 0.003107
Время выполнения запроса: SELECT * FROM node_sites WHERE id='2090' параметры: :id=>2090 тип: 2 составило 0.000464
Время выполнения CMSCore
Время выполнения DefaultNode 2.9E-5
Время выполнения запроса: SELECT * FROM node_sites where id = '2090' параметры: :id=>2090 тип: 2 составило 0.000322
Время выполнения DefaultNode 0.018723
Время выполнения SeoModule 0.009462
Время выполнения запроса: insert into sys_visits(session_id,visit_time,http_referer,user_agent,remote_address,query_string,referal_phrase) values ('a3hcll6j3nglnn2ufooavr6jmh','2020-07-09 06:53:16 (MSK)', NULL,'CCBot/2.0 (https://commoncrawl.org/faq/)','34.204.187.106','', NULL) параметры: :session_id=>a3hcll6j3nglnn2ufooavr6jmh тип: 2
Время выполнения запроса: 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 and n1.parent_id = 2) 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 mnews n2, main m2
WHERE m2.id = n2.id
AND m2.visible = 1
AND n2.in_menu = 1 and n2.parent_id = 2) 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 team n3, main m3
WHERE m3.id = n3.id
AND m3.visible = 1
AND n3.in_menu = 1 and n3.parent_id = 2) 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 services n4, main m4
WHERE m4.id = n4.id
AND m4.visible = 1
AND n4.in_menu = 1 and n4.parent_id = 2)) as t
order by t.SORTORDER составило 0.001322
Время выполнения Widgets 0.000519
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило 0.00017
Время выполнения Widgets 0.0002
Время выполнения SubMenu 0.002439
Время выполнения запроса: SELECT DISTINCT t.*
FROM ( (SELECT DISTINCT m0.id,
IFNULL(m0.parent_id,0) as parent_id,
n0.name as name,
n0.URL as url,
m0.sortorder
FROM node_sites n0, main m0
WHERE m0.id = n0.id
AND m0.visible = 1
AND n0.parent_id = 2090) UNION ALL (SELECT DISTINCT m1.id,
IFNULL(m1.parent_id,0) as parent_id,
n1.name as name,
n1.URL as url,
m1.sortorder
FROM mnews n1, main m1
WHERE m1.id = n1.id
AND m1.visible = 1
AND n1.parent_id = 2090) 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 persons n2, main m2
WHERE m2.id = n2.id
AND m2.visible = 1
AND n2.parent_id = 2090) 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 docs n3, main m3
WHERE m3.id = n3.id
AND m3.visible = 1
AND n3.parent_id = 2090) 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 team n4, main m4
WHERE m4.id = n4.id
AND m4.visible = 1
AND n4.parent_id = 2090) 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 services n5, main m5
WHERE m5.id = n5.id
AND m5.visible = 1
AND n5.parent_id = 2090) 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 service_sets n6, main m6
WHERE m6.id = n6.id
AND m6.visible = 1
AND n6.parent_id = 2090) 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 specpage n7, main m7
WHERE m7.id = n7.id
AND m7.visible = 1
AND n7.parent_id = 2090) UNION ALL (SELECT DISTINCT m8.id,
IFNULL(m8.parent_id,0) as parent_id,
n8.name as name,
n8.URL as url,
m8.sortorder
FROM oms_node n8, main m8
WHERE m8.id = n8.id
AND m8.visible = 1
AND n8.parent_id = 2090)) as t
order by t.sortorder составило 0.0022
Время выполнения запроса: SELECT t.* from node_sites t, main m WHERE t.id = m.id AND m.visible = 1 AND t.id = '2090' LIMIT 0,1 параметры: :id=>2090 тип: 2 составило 0.000363
Время выполнения запроса: UPDATE `node_sites` SET show_count = IFNULL(show_count,0) + 1
WHERE `id` = '2090' параметры: :id=>2090 тип: 2 составило 0.000369
Время выполнения News 0.000554
Время выполнения запроса: SELECT n.*,
m.sortorder
FROM news n
INNER JOIN main m
ON m.id=n.id
AND m.visible=1
INNER JOIN mnews dd
ON dd.id=n.parent_id
AND n.parent_id = '375'
INNER JOIN main m2
ON m2.id=n.id
AND m2.visible=1
ORDER BY n.date desc LIMIT 0,3 параметры: :pid=>375 тип: 2 составило 0.000163