Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.23 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.23 ms

"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 32)
4	Avirto\FilesnapBundle\Repository\UserTrackingRepository->add (line 171)
5	Avirto\FilesnapBundle\Subscriber\KernelSubscriber->trackUserRequest (line 60)
6	Avirto\FilesnapBundle\Subscriber\KernelSubscriber->onKernelController (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.07 ms

INSERT INTO user_tracking (request_started_at, controller, request_uri, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-04-30 01:33:45"
  "Avirto\FilesnapBundle\Controller\SecurityController::login"
  "/login"
  "2026-04-30 03:33:45"
  "2026-04-30 03:33:45"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO user_tracking (
  request_started_at, controller, request_uri,
  created_at, updated_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO user_tracking (request_started_at, controller, request_uri, created_at, updated_at, user_id) VALUES ('2026-04-30 01:33:45', 'Avirto\\FilesnapBundle\\Controller\\SecurityController::login', '/login', '2026-04-30 03:33:45', '2026-04-30 03:33:45', NULL);

#	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 32)
7	Avirto\FilesnapBundle\Repository\UserTrackingRepository->add (line 171)
8	Avirto\FilesnapBundle\Subscriber\KernelSubscriber->trackUserRequest (line 60)
9	Avirto\FilesnapBundle\Subscriber\KernelSubscriber->onKernelController (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.93 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 32)
5	Avirto\FilesnapBundle\Repository\UserTrackingRepository->add (line 171)
6	Avirto\FilesnapBundle\Subscriber\KernelSubscriber->trackUserRequest (line 60)
7	Avirto\FilesnapBundle\Subscriber\KernelSubscriber->onKernelController (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
import	doctrine.dbal.import_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
Avirto\FilesnapBundle\Entity\UserTracking	No errors.
Avirto\FilesnapBundle\Entity\MappedSuperclass\AbstractBaseEntity	No errors.
Avirto\FilesnapBundle\Entity\User	No errors.

Symfony Profiler

GET https://fla-ait.sp007.de/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping