Symfony Profiler

Query Metrics

19 Database Queries

5 Different statements

15.96 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.10 ms
(57.01%)

INSERT INTO log (message, level_name, LEVEL, channel, extra, context, created_at) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "Executing command "GET 'dev-.env-firewalls'""
  "Debug"
  100
  "snc_redis"
  "[]"
  "[]"
  "2024-09-27 22:57:08"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO log (
  message, level_name, LEVEL, channel,
  extra, context, created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (message, level_name, LEVEL, channel, extra, context, created_at) VALUES ('Executing command \"GET \'dev-.env-firewalls\'\"', 'Debug', 100, 'snc_redis', '[]', '[]', '2024-09-27 22:57:08');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 285)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 41)
7	App\Repository\Access\AccessNotFoundLogRepository->flush (line 32)
8	App\Service\Access\SuspiciousNoRouteFoundService->log (line 31)
9	App\EventSubscriber\Access\SuspiciousNoRouteFoundListener->onKernelException (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 236)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

4.77 ms
(29.90%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 41)
5	App\Repository\Access\AccessNotFoundLogRepository->flush (line 32)
6	App\Service\Access\SuspiciousNoRouteFoundService->log (line 31)
7	App\EventSubscriber\Access\SuspiciousNoRouteFoundListener->onKernelException (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 236)
12	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.86 ms
(5.37%)

SELECT t0.id AS id_1, t0.host AS host_2, t0.alias AS alias_3, t0.title AS title_4, t0.dark_small_logo AS dark_small_logo_5, t0.white_small_logo AS white_small_logo_6, t0.favicon AS favicon_7, t0.status AS status_8, t0.white_logo AS white_logo_9, t0.dark_logo AS dark_logo_10, t0.created_at AS created_at_11, t0.description AS description_12, t0.cover AS cover_13, t0.labels AS labels_14, t0.public AS public_15, t0.page_id AS page_id_16 FROM community t0 WHERE t0.alias = ? LIMIT 1

Parameters:

[
  ".env"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.host AS host_2,
  t0.alias AS alias_3,
  t0.title AS title_4,
  t0.dark_small_logo AS dark_small_logo_5,
  t0.white_small_logo AS white_small_logo_6,
  t0.favicon AS favicon_7,
  t0.status AS status_8,
  t0.white_logo AS white_logo_9,
  t0.dark_logo AS dark_logo_10,
  t0.created_at AS created_at_11,
  t0.description AS description_12,
  t0.cover AS cover_13,
  t0.labels AS labels_14,
  t0.public AS public_15,
  t0.page_id AS page_id_16
FROM
  community t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.host AS host_2, t0.alias AS alias_3, t0.title AS title_4, t0.dark_small_logo AS dark_small_logo_5, t0.white_small_logo AS white_small_logo_6, t0.favicon AS favicon_7, t0.status AS status_8, t0.white_logo AS white_logo_9, t0.dark_logo AS dark_logo_10, t0.created_at AS created_at_11, t0.description AS description_12, t0.cover AS cover_13, t0.labels AS labels_14, t0.public AS public_15, t0.page_id AS page_id_16 FROM community t0 WHERE t0.alias = '.env' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 31)
4	App\Controller\Web\Community\CommunityWebController->index (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.69 ms
(4.32%)

INSERT INTO access_not_found_log (ip, path, context, created_at) VALUES (?, ?, ?, ?)

Parameters:

[
  "92.184.145.186"
  "/.env"
  "{"headers":{"cf-connecting-ip":["92.184.145.186"],"accept":["*\/*"],"user-agent":["Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/81.0.4044.129 Safari\/537.36"],"cf-visitor":["{\"scheme\":\"https\"}"],"x-forwarded-proto":["https"],"cf-ray":["8c9f174d69cc2a6b-CDG"],"x-forwarded-for":["92.184.145.186"],"accept-encoding":["gzip, br"],"cf-ipcountry":["FR"],"cdn-loop":["cloudflare; loops=1"],"host":["stage.dicehub.org.ua"],"x-php-ob-level":["1"]},"cookies":[],"query":[],"post":[],"locale":"uk","clientIps":["92.184.145.186"]}"
  "2024-09-27 22:57:08"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO access_not_found_log (ip, path, context, created_at)
VALUES
  (?, ?, ?, ?)

INSERT INTO access_not_found_log (ip, path, context, created_at) VALUES ('92.184.145.186', '/.env', '{\"headers\":{\"cf-connecting-ip\":[\"92.184.145.186\"],\"accept\":[\"*\\/*\"],\"user-agent\":[\"Mozilla\\/5.0 (X11; Linux x86_64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/81.0.4044.129 Safari\\/537.36\"],\"cf-visitor\":[\"{\\\"scheme\\\":\\\"https\\\"}\"],\"x-forwarded-proto\":[\"https\"],\"cf-ray\":[\"8c9f174d69cc2a6b-CDG\"],\"x-forwarded-for\":[\"92.184.145.186\"],\"accept-encoding\":[\"gzip, br\"],\"cf-ipcountry\":[\"FR\"],\"cdn-loop\":[\"cloudflare; loops=1\"],\"host\":[\"stage.dicehub.org.ua\"],\"x-php-ob-level\":[\"1\"]},\"cookies\":[],\"query\":[],\"post\":[],\"locale\":\"uk\",\"clientIps\":[\"92.184.145.186\"]}', '2024-09-27 22:57:08');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 285)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 41)
7	App\Repository\Access\AccessNotFoundLogRepository->flush (line 32)
8	App\Service\Access\SuspiciousNoRouteFoundService->log (line 31)
9	App\EventSubscriber\Access\SuspiciousNoRouteFoundListener->onKernelException (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 236)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.54 ms
(3.40%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 428)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 41)
4	App\Repository\Access\AccessNotFoundLogRepository->flush (line 32)
5	App\Service\Access\SuspiciousNoRouteFoundService->log (line 31)
6	App\EventSubscriber\Access\SuspiciousNoRouteFoundListener->onKernelException (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 236)
11	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Log\Log	No errors.
App\Entity\Community\Community	No errors.
App\Entity\Page\Page	No errors.
App\Entity\Access\AccessNotFoundLog	No errors.
App\Entity\Community\CommunityConfig	No errors.
App\Entity\Community\CommunityEvent	No errors.
App\Entity\Community\CommunityAdmin	No errors.
App\Entity\Community\CommunityMember	No errors.
App\Entity\Access\AccessCommunity	No errors.
App\Entity\Community\CommunityActivity	No errors.
App\Entity\Page\PageTemplate	No errors.
App\Entity\Page\PageBlock	No errors.
App\Entity\Event\Event	No errors.

Symfony Profiler

GET https://stage.dicehub.org.ua/.env

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping