Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

8.29 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.50 ms
(78.48%)

"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.68 ms
(8.21%)

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

Parameters:

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

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-sendgrid-.env-firewalls\'\"', 'Debug', 100, 'snc_redis', '[]', '[]', '2024-09-27 22:57:13');

#	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.63 ms
(7.62%)

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

Parameters:

[
  "92.184.145.186"
  "/sendgrid/.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":["8c9f176a4c40792e-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:13"
]

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', '/sendgrid/.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\":[\"8c9f176a4c40792e-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:13');

#	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.47 ms
(5.70%)

"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\Access\AccessNotFoundLog	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping