Symfony Profiler

Query Metrics

11 Database Queries

10 Different statements

12.00 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.63 ms
(21.90%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	DH\Auditor\Provider\Doctrine\Auditing\DBAL\Middleware\AuditorConnection->commit (line 29)
2	Doctrine\DBAL\Connection->commit (line 1083)
3	Doctrine\ORM\UnitOfWork->commit (line 433)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
6	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
7	App\EventListener\LoginEventListener->__invoke (line 28)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.11 ms
(17.61%)

SELECT t0.id AS id_1, t0.imes_id AS imes_id_2, t0.name AS name_3, t0.surname AS surname_4, t0.username AS username_5, t0.email AS email_6, t0.active AS active_7, t0.imes_token AS imes_token_8, t0.imes_refresh_token AS imes_refresh_token_9, t0.imes_token_expires_timestamp AS imes_token_expires_timestamp_10, t0.preferred_pickup_time AS preferred_pickup_time_11, t0.christmas_mode AS christmas_mode_12, t0.fun_mode AS fun_mode_13, t0.lunch_notification AS lunch_notification_14, t0.login_link AS login_link_15, t0.ms_uid AS ms_uid_16, t0.preferred_company_id AS preferred_company_id_17 FROM imes_user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "marketa-braunova"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.imes_id AS imes_id_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.username AS username_5,
  t0.email AS email_6,
  t0.active AS active_7,
  t0.imes_token AS imes_token_8,
  t0.imes_refresh_token AS imes_refresh_token_9,
  t0.imes_token_expires_timestamp AS imes_token_expires_timestamp_10,
  t0.preferred_pickup_time AS preferred_pickup_time_11,
  t0.christmas_mode AS christmas_mode_12,
  t0.fun_mode AS fun_mode_13,
  t0.lunch_notification AS lunch_notification_14,
  t0.login_link AS login_link_15,
  t0.ms_uid AS ms_uid_16,
  t0.preferred_company_id AS preferred_company_id_17
FROM
  imes_user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.imes_id AS imes_id_2, t0.name AS name_3, t0.surname AS surname_4, t0.username AS username_5, t0.email AS email_6, t0.active AS active_7, t0.imes_token AS imes_token_8, t0.imes_refresh_token AS imes_refresh_token_9, t0.imes_token_expires_timestamp AS imes_token_expires_timestamp_10, t0.preferred_pickup_time AS preferred_pickup_time_11, t0.christmas_mode AS christmas_mode_12, t0.fun_mode AS fun_mode_13, t0.lunch_notification AS lunch_notification_14, t0.login_link AS login_link_15, t0.ms_uid AS ms_uid_16, t0.preferred_company_id AS preferred_company_id_17 FROM imes_user t0 WHERE t0.username = 'marketa-braunova' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 28)
5	App\EventListener\LoginEventListener->__invoke (line 28)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

1.48 ms
(12.37%)

SELECT NEXTVAL('ldap_role_id_seq')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('ldap_role_id_seq')

SELECT NEXTVAL('ldap_role_id_seq');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 804)
2	Doctrine\DBAL\Connection->fetchOne (line 332)
3	Doctrine\ORM\Id\SequenceGenerator->generateId (line 46)
4	Doctrine\ORM\UnitOfWork->persistNew (line 921)
5	Doctrine\ORM\UnitOfWork->computeAssociationChanges (line 869)
6	Doctrine\ORM\UnitOfWork->computeChangeSet (line 755)
7	Doctrine\ORM\UnitOfWork->computeChangeSets (line 805)
8	Doctrine\ORM\UnitOfWork->commit (line 353)
9	Doctrine\ORM\EntityManager->flush (line 268)
10	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
11	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
12	App\EventListener\LoginEventListener->__invoke (line 28)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
21	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
22	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
23	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
24	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 191)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

1.14 ms
(9.53%)

DELETE FROM imes_user_ldap_role WHERE imes_user_id = ?

Parameters:

[
  342
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  imes_user_ldap_role
WHERE
  imes_user_id = ?

DELETE FROM imes_user_ldap_role WHERE imes_user_id = 342;

#	File/Call
1	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->delete (line 53)
2	Doctrine\ORM\UnitOfWork->commit (line 393)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
5	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
6	App\EventListener\LoginEventListener->__invoke (line 28)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.07 ms
(8.88%)

INSERT INTO imes_user_ldap_role (imes_user_id, ldap_role_id) VALUES (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

INSERT INTO imes_user_ldap_role (imes_user_id, ldap_role_id)
VALUES
  (?, ?)

INSERT INTO imes_user_ldap_role (imes_user_id, ldap_role_id) VALUES (342, 2);

#	File/Call
1	Doctrine\ORM\Persisters\Collection\ManyToManyPersister->update (line 76)
2	Doctrine\ORM\UnitOfWork->commit (line 422)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
5	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
6	App\EventListener\LoginEventListener->__invoke (line 28)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.96 ms
(7.99%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM ldap_role t0 INNER JOIN imes_user_ldap_role ON t0.id = imes_user_ldap_role.ldap_role_id WHERE imes_user_ldap_role.imes_user_id = ?

Parameters:

[
  342
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  ldap_role t0
  INNER JOIN imes_user_ldap_role ON t0.id = imes_user_ldap_role.ldap_role_id
WHERE
  imes_user_ldap_role.imes_user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM ldap_role t0 INNER JOIN imes_user_ldap_role ON t0.id = imes_user_ldap_role.ldap_role_id WHERE imes_user_ldap_role.imes_user_id = 342;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->offsetGet (line 425)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->prepareUpdateData (line 613)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 363)
11	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
12	Doctrine\ORM\UnitOfWork->commit (line 408)
13	Doctrine\ORM\EntityManager->flush (line 268)
14	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
15	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
16	App\EventListener\LoginEventListener->__invoke (line 28)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
21	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
22	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
23	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
24	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
25	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
26	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
27	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
28	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
29	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
30	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 191)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 32)
40	require_once (line 5)

0.80 ms
(6.68%)

UPDATE imes_user SET email = ? WHERE id = ?

Parameters:

[
  "braunova@ebrana.cz"
  342
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  imes_user
SET
  email = ?
WHERE
  id = ?

UPDATE imes_user SET email = 'braunova@ebrana.cz' WHERE id = 342;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
7	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
8	App\EventListener\LoginEventListener->__invoke (line 28)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.61 ms
(5.08%)

"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 1058)
2	Doctrine\ORM\UnitOfWork->commit (line 382)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
5	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
6	App\EventListener\LoginEventListener->__invoke (line 28)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.61 ms
(5.05%)

INSERT INTO ldap_role (id, name) VALUES (?, ?)

Parameters:

[
  2
  "ROLE_ADM_ADMIN"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ldap_role (id, name)
VALUES
  (?, ?)

INSERT INTO ldap_role (id, name) VALUES (2, 'ROLE_ADM_ADMIN');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\Manager\AbstractEntityManager->saveEntity (line 31)
7	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 36)
8	App\EventListener\LoginEventListener->__invoke (line 28)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.59 ms
(4.93%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM ldap_role t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  ldap_role t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM ldap_role t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 804)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
3	Doctrine\ORM\EntityRepository->findBy (line 110)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
5	Doctrine\ORM\EntityRepository->findAll (line 96)
6	App\Service\Resolver\ImesUser\LdapRoleResolver->resolveRoles (line 42)
7	App\Service\Facade\ImesUserFacade->updateRoles (line 51)
8	App\Service\Facade\ImesUserFacade->processImesUserFromLdap (line 35)
9	App\EventListener\LoginEventListener->__invoke (line 28)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 233)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 213)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
21	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 191)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	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\ImesUser\LdapRole	2
App\Entity\ImesUser	1

Entities Mapping

Class	Mapping errors
App\Entity\ImesUser	No errors.
App\Entity\Administration\Ordering\Food\OrderDispatchConfig	No errors.
App\Entity\Administration\Ordering\Food\Company	No errors.
App\Entity\ImesUser\Position	No errors.
App\Entity\ImesUser\LdapRole	No errors.
App\Entity\Administration\Ordering\Food\FoodOffer	No errors.
App\Entity\Administration\Ordering\Food\Meal	No errors.
App\Entity\Administration\Ordering\Food\Report\Company\Monthly\EconomyItem	No errors.
App\Entity\Administration\Ordering\Food\Report\Company\EconomyMonthlyReport	No errors.
App\Entity\Administration\Ordering\Food\MonthlyOrder	No errors.
App\Entity\Administration\Ordering\Food\OrderItem	No errors.
App\Entity\Administration\Ordering\Food\MonthlyCompanyOrder	No errors.
App\Entity\TimePeriod	No errors.
App\Entity\HumanResources\TrainingCourse\CourseCategory	No errors.
App\Entity\HumanResources\TrainingCourse\Feedback	No errors.
App\Entity\HumanResources\TrainingCourse\Department	No errors.
App\Entity\HumanResources\TrainingCourse	No errors.
App\Entity\Production\Phoenix\Implementation	No errors.
App\Entity\Production\Phoenix\Implementation\UpdateLog	No errors.
Zenstruck\Messenger\Monitor\History\Model\ProcessedMessage	No errors.
App\Entity\ProcessedMessage	No errors.
App\Entity\Log\Notification\DailyLunchNotification	No errors.
App\Entity\InternetMarketing\Project\ProjectSettings	No errors.
App\Entity\InternetMarketing\Project	No errors.
App\Entity\InternetMarketing\Evaluation	No errors.
App\Entity\InternetMarketing\ProductComparatorStatistics	No errors.
App\Entity\InternetMarketing\ProductComparatorStatistics\Api\LastEndpointRequest	No errors.
App\Entity\InternetMarketing\ProductComparatorStatistics\ZboziProductComparatorStatistics	No errors.
App\Entity\InternetMarketing\ProductComparatorStatistics\HeurekaProductComparatorStatistics	No errors.
App\Entity\ImesUser\FoodVoucher	No errors.
App\Entity\ImesUser\FoodVoucherView	No errors.

Symfony Profiler

POST https://feature-d020588-auto-reindex.it.edevel.cz/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping