Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

5.21 ms Query time

1 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.69 ms
(51.58%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 458)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\EventListener\StatisticCreationListener->onKernelRequest (line 61)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 122)
5	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 115)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 156)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

1.41 ms
(27.05%)

SELECT t0.id AS id_1, t0.pin_code AS pin_code_2, t0.short_slug AS short_slug_3, t0.name AS name_4, t0.mode AS mode_5, t0.assigned_at AS assigned_at_6, t0.image_name AS image_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.owner_id AS owner_id_10, t0.wall_id AS wall_id_11 FROM qrcode t0 WHERE t0.short_slug = ? LIMIT 1

Parameters:

[
  "QTqdAI"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.pin_code AS pin_code_2,
  t0.short_slug AS short_slug_3,
  t0.name AS name_4,
  t0.mode AS mode_5,
  t0.assigned_at AS assigned_at_6,
  t0.image_name AS image_name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.owner_id AS owner_id_10,
  t0.wall_id AS wall_id_11
FROM
  qrcode t0
WHERE
  t0.short_slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.pin_code AS pin_code_2, t0.short_slug AS short_slug_3, t0.name AS name_4, t0.mode AS mode_5, t0.assigned_at AS assigned_at_6, t0.image_name AS image_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.owner_id AS owner_id_10, t0.wall_id AS wall_id_11 FROM qrcode t0 WHERE t0.short_slug = 'QTqdAI' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\EventListener\StatisticCreationListener->onKernelRequest (line 51)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 122)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 115)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 156)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.86 ms
(16.45%)

INSERT INTO statistic (id, ip_address, created_at, qrcode_id) VALUES (?, ?, ?, ?)

Parameters:

[
  b"\x01¡£j×7q|ÁQ¦(µ‰K"
  "216.73.217.35"
  "2026-11-03 21:57:30"
  b"\x01¡‘al\fx¦êÛBä\x04ªr"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO statistic (
  id, ip_address, created_at, qrcode_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO statistic (id, ip_address, created_at, qrcode_id) VALUES (0x01A1A36AD737717CADC151A628B5894B, '216.73.217.35', '2026-11-03 21:57:30', 0x01A191616C0C7881A6EADB42E404AA72);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1144)
4	Doctrine\ORM\UnitOfWork->commit (line 426)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	App\EventListener\StatisticCreationListener->onKernelRequest (line 61)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 115)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
11	Symfony\Component\HttpKernel\Kernel->handle (line 156)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.26 ms
(4.93%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 405)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\EventListener\StatisticCreationListener->onKernelRequest (line 61)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 122)
5	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 115)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 156)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Qrcode	1
App\Entity\User	1
App\Entity\Statistic	1

Entities Mapping

Class	Mapping errors
App\Entity\Qrcode	No errors.
App\Entity\User	The association App\Entity\User#sentMessages refers to the owning side field App\Entity\Message#author which does not exist.
App\Entity\Wall	No errors.
App\Entity\Statistic	No errors.

GET https://yackr.io/qr/QTqdAI

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping