Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

49.61 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

34.17 ms
(68.88%)

DELETE FROM linkbridge WHERE registered_at <= ?

Parameters:

[
  "2025-07-05 10:20:32"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  linkbridge
WHERE
  registered_at <= ?

DELETE FROM linkbridge WHERE registered_at <= '2025-07-05 10:20:32';

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 38)
2	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 56)
6	App\Repository\LinkBridgeRepository->cleanupOldSessions (line 32)
7	App\Controller\HomeController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

15.27 ms
(30.78%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 431)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 88)
4	App\Repository\LinkBridgeRepository->registerNewRecipient (line 47)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.11 ms
(0.22%)

INSERT INTO linkbridge (session_id, registered_at, pin, url) VALUES (?, ?, ?, ?)

Parameters:

[
  "7cjmef95di73i3uur7h6f8adcf"
  "2025-07-05 10:25:32"
  "901373"
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO linkbridge (
  session_id, registered_at, pin, url
)
VALUES
  (?, ?, ?, ?)

INSERT INTO linkbridge (session_id, registered_at, pin, url) VALUES ('7cjmef95di73i3uur7h6f8adcf', '2025-07-05 10:25:32', '901373', NULL);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 133)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1052)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 401)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 88)
7	App\Repository\LinkBridgeRepository->registerNewRecipient (line 47)
8	App\Controller\HomeController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.04 ms
(0.08%)

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.registered_at AS registered_at_3, t0.pin AS pin_4, t0.url AS url_5 FROM linkbridge t0 WHERE t0.session_id = ? LIMIT 1

Parameters:

[
  "7cjmef95di73i3uur7h6f8adcf"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.registered_at AS registered_at_3,
  t0.pin AS pin_4,
  t0.url AS url_5
FROM
  linkbridge t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.registered_at AS registered_at_3, t0.pin AS pin_4, t0.url AS url_5 FROM linkbridge t0 WHERE t0.session_id = '7cjmef95di73i3uur7h6f8adcf' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 38)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.02 ms
(0.04%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 88)
4	App\Repository\LinkBridgeRepository->registerNewRecipient (line 47)
5	App\Controller\HomeController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\LinkBridge	1

Entities Mapping

Class	Mapping errors
App\Entity\LinkBridge	No errors.

Symfony Profiler

GET https://dev.linkbridge.ru/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping