Остались вопросы? Задайте свой вопрос нашим врачам!
Мы будем рады набрать вас и ответить на все ваши вопросы!
Общее выполнеия сценариев: 0.025336
Время выполнения запроса: SELECT t.*
FROM ( (SELECT n1.id,
n1.genmod,
n1.url,
n1.name as name,
m1.parent_id,
"node_sites" as curTab,
SUBSTRING( 'news/' from length(n1.url)+1 ) trail
FROM node_sites n1, main m1
WHERE 'news/' 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( 'news/' from length(n2.url)+1 ) trail
FROM mnews n2, main m2
WHERE 'news/' 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( 'news/' from length(n3.url)+1 ) trail
FROM persons n3, main m3
WHERE 'news/' 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( 'news/' from length(n4.url)+1 ) trail
FROM docs n4, main m4
WHERE 'news/' 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( 'news/' from length(n5.url)+1 ) trail
FROM team n5, main m5
WHERE 'news/' 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( 'news/' from length(n6.url)+1 ) trail
FROM services n6, main m6
WHERE 'news/' 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( 'news/' from length(n7.url)+1 ) trail
FROM service_sets n7, main m7
WHERE 'news/' 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( 'news/' from length(n8.url)+1 ) trail
FROM specpage n8, main m8
WHERE 'news/' 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( 'news/' from length(n9.url)+1 ) trail
FROM oms_node n9, main m9
WHERE 'news/' LIKE CONCAT(n9.url,"%")
AND m9.visible = 1
AND n9.id=m9.id) ) t
ORDER BY length(SUBSTRING('news/' from length(t.url)+1 ))
Limit 1 параметры: :curl=>news/ тип: 2 составило 0.002583
Время выполнения CMSCore
Время выполнения News 1.7E-5
Время выполнения запроса: SELECT * FROM mnews where id = '375' параметры: :id=>375 тип: 2 составило 0.000257
Время выполнения News 0.018575
Время выполнения SeoModule 0.00953
Время выполнения запроса: insert into sys_visits(session_id,visit_time,http_referer,user_agent,remote_address,query_string,referal_phrase) values ('q2brj51gte21njome4promsjjf','2020-07-09 07:24:48 (MSK)', NULL,'CCBot/2.0 (https://commoncrawl.org/faq/)','34.204.187.106','', NULL) параметры: :session_id=>q2brj51gte21njome4promsjjf тип: 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.002116
Время выполнения Widgets 0.000944
Время выполнения запроса: SELECT * FROM config cfg LIMIT 0,1 составило 0.000363
Время выполнения Widgets 0.000267
Время выполнения запроса: SELECT count(t.id) as count from news t, main m WHERE (t.id = m.id AND m.visible = 1) AND t.parent_id='375' параметры: :pid=>375 тип: 2 составило 0.001406
Время выполнения запроса: 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,9 параметры: :pid=>375 тип: 2 составило 0.000959