Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.49 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.55 ms

SELECT t0.sess_id AS sess_id_1, t0.sess_data AS sess_data_2, t0.sess_lifetime AS sess_lifetime_3, t0.sess_time AS sess_time_4, t0.ip_address AS ip_address_5, t0.user_id AS user_id_6 FROM session t0 WHERE t0.sess_id = ?

Parameters:

[
  "2a5513888922e939af8f91cecda128d5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.sess_id AS sess_id_1,
  t0.sess_data AS sess_data_2,
  t0.sess_lifetime AS sess_lifetime_3,
  t0.sess_time AS sess_time_4,
  t0.ip_address AS ip_address_5,
  t0.user_id AS user_id_6
FROM
  session t0
WHERE
  t0.sess_id = ?

SELECT t0.sess_id AS sess_id_1, t0.sess_data AS sess_data_2, t0.sess_lifetime AS sess_lifetime_3, t0.sess_time AS sess_time_4, t0.ip_address AS ip_address_5, t0.user_id AS user_id_6 FROM session t0 WHERE t0.sess_id = '2a5513888922e939af8f91cecda128d5';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Custom\DoctrineSessionHandler->doRead (line 35)
7	Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler->read (line 69)
8	Symfony\Component\HttpFoundation\Session\Storage\Handler\AbstractSessionHandler->validateId (line 49)
9	Symfony\Component\HttpFoundation\Session\Storage\Proxy\SessionHandlerProxy->validateId (line 67)
10	session_start (line 158)
11	Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage::start (line 158)
12	Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage->getBag (line 282)
13	Symfony\Component\HttpFoundation\Session\Session->getBag (line 201)
14	Symfony\Component\HttpFoundation\Session\Session->getAttributeBag (line 221)
15	Symfony\Component\HttpFoundation\Session\Session->has (line 64)
16	Symfony\Component\Security\Http\Authentication\AuthenticationUtils->getLastAuthenticationError (line 38)
17	App\Controller\SecurityController->login (line 16)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.94 ms

DELETE FROM session WHERE sess_lifetime < ?

Parameters:

[
  1766883106
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  session
WHERE
  sess_lifetime < ?

DELETE FROM session WHERE sess_lifetime < 1766883106;

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 38)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	App\Custom\DoctrineSessionHandler->gc (line 96)
6	Symfony\Component\HttpFoundation\Session\Storage\Proxy\SessionHandlerProxy->gc (line 62)
7	session_start (line 158)
8	Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage::start (line 158)
9	Symfony\Component\HttpFoundation\Session\Storage\NativeSessionStorage->getBag (line 282)
10	Symfony\Component\HttpFoundation\Session\Session->getBag (line 201)
11	Symfony\Component\HttpFoundation\Session\Session->getAttributeBag (line 221)
12	Symfony\Component\HttpFoundation\Session\Session->has (line 64)
13	Symfony\Component\Security\Http\Authentication\AuthenticationUtils->getLastAuthenticationError (line 38)
14	App\Controller\SecurityController->login (line 16)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	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\User\Session	1

Entities Mapping

Class	Mapping errors
App\Entity\User\Session	No errors.
App\Entity\User\User	No errors.

Symfony Profiler

GET https://cp-test.gravurfix.de/login

Configuration Settings

Theme

Page Width