Configuration Logs Profiling Database Events Mail Timeline Dump Router Request User Asset Bundles

Prev Next

All Latest

680d24dda6f45: GET http://37.27.117.109/actuator/gateway/routes at 2025-04-26 09:24:29 pm by 172.18.0.9

Database

12 duplicated queries found.

Queries
Callers

Database Queries

Total 15 elementos.

Time	Duration	Type	Duplicated	Query

21:24:29.689	0.2 ms	SELECT	1	SELECT MAX(updated_at) FROM section /var/www/html/common/models/Section.php:347 /var/www/html/common/models/Section.php:346 /var/www/html/common/components/LangUrlManager.php:76 [+] Explain
21:24:29.691	0.2 ms	SELECT	1	SELECT * FROM `lang` WHERE (url = 'actuator') AND (`active`=1) /var/www/html/common/components/LangComponent.php:82 /var/www/html/common/components/LangComponent.php:78 /var/www/html/common/components/LangComponent.php:64 [+] Explain
21:24:29.721	0.3 ms	SELECT	1	SELECT MAX(update_cache) FROM posts WHERE `type` = "content" /var/www/html/common/models/Posts.php:469 /var/www/html/common/models/Posts.php:465 /var/www/html/common/components/UrlRules.php:211 [+] Explain
21:24:29.729	0.2 ms	SELECT	2	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=1) ORDER BY `num` /var/www/html/frontend/widgets/MenuWidgets.php:31 /var/www/html/frontend/widgets/MenuWidgets.php:22 /var/www/html/frontend/views/layouts/header.php:88 [+] Explain
21:24:29.729	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.730	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.730	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.730	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.730	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.731	0.1 ms	SELECT	2	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=1) ORDER BY `num` /var/www/html/frontend/widgets/MenuWidgets.php:31 /var/www/html/frontend/widgets/MenuWidgets.php:22 /var/www/html/frontend/views/layouts/header.php:102 [+] Explain
21:24:29.731	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.731	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.732	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.732	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain
21:24:29.732	0.1 ms	SELECT	2	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua') /var/www/html/frontend/widgets/MenuWidgets.php:69 /var/www/html/frontend/widgets/MenuWidgets.php:88 /var/www/html/frontend/widgets/MenuWidgets.php:22 [+] Explain

[+] Explain all

Database Callers

Total 6 elementos.

Caller

Queries

10

0.9 ms

Time	Duration	Queries
21:24:29.729	0.1 ms	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua') [+] Explain
21:24:29.730	0.1 ms	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua') [+] Explain
21:24:29.730	0.1 ms	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua') [+] Explain
21:24:29.730	0.1 ms	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua') [+] Explain
21:24:29.730	0.1 ms	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua') [+] Explain
21:24:29.731	0.1 ms	SELECT * FROM `types` WHERE (`type`='statements') AND (`lang`='ua') [+] Explain
21:24:29.731	0.1 ms	SELECT * FROM `types` WHERE (`type`='research') AND (`lang`='ua') [+] Explain
21:24:29.732	0.1 ms	SELECT * FROM `types` WHERE (`type`='announcements') AND (`lang`='ua') [+] Explain
21:24:29.732	0.1 ms	SELECT * FROM `types` WHERE (`type`='news') AND (`lang`='ua') [+] Explain
21:24:29.732	0.1 ms	SELECT * FROM `types` WHERE (`type`='media-about-us') AND (`lang`='ua') [+] Explain

1

0.2 ms

Time	Duration	Queries
21:24:29.689	0.2 ms	SELECT MAX(updated_at) FROM section [+] Explain

1

0.2 ms

Time	Duration	Queries
21:24:29.691	0.2 ms	SELECT * FROM `lang` WHERE (url = 'actuator') AND (`active`=1) [+] Explain

1

0.3 ms

Time	Duration	Queries
21:24:29.721	0.3 ms	SELECT MAX(update_cache) FROM posts WHERE `type` = "content" [+] Explain

1

0.2 ms

Time	Duration	Queries
21:24:29.729	0.2 ms	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=1) ORDER BY `num` [+] Explain

1

0.1 ms

Time	Duration	Queries
21:24:29.731	0.1 ms	SELECT * FROM `menu` WHERE (`lang`='ua') AND (`menu_type`=1) ORDER BY `num` [+] Explain

[+] Explain all