Symfony Profiler

Query Metrics

12 Database Queries

9 Different statements

82.22 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

26.85 ms
(32.65%)

INSERT INTO log_action (user_id, account_id, action, content, created_at) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  3453
  null
  "login_succes"
  "{"userId":3453}"
  "2026-06-02 21:00:05"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO log_action (
  user_id, account_id, action, content,
  created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO log_action (user_id, account_id, action, content, created_at) VALUES (3453, NULL, 'login_succes', '{\"userId\":3453}', '2026-06-02 21:00:05');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 288)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1191)
4	Doctrine\ORM\UnitOfWork->commit (line 451)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Repository\Main\AbstractBaseRepository->save (line 28)
7	App\Repository\Main\LogActionRepository->insertLog (line 42)
8	App\Service\Generic\ActionLogService->insertLog (line 45)
9	App\EventListener\LoginEventListener->onLoginAttempt (line 38)
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 250)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

21.80 ms
(26.51%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Repository\Main\AbstractBaseRepository->save (line 28)
5	App\Repository\Main\UserRepository->setLastLogin (line 146)
6	App\EventListener\LoginEventListener->onLoginAttempt (line 37)
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 250)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

9.77 ms
(11.88%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "api_78376ghd3@ktba.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.active AS active_7,
  t0.last_login AS last_login_8,
  t0.first_name AS first_name_9,
  t0.middle_name AS middle_name_10,
  t0.last_name AS last_name_11,
  t0.phone_number AS phone_number_12,
  t0.newsletter AS newsletter_13,
  t0.token AS token_14,
  t0.token_created AS token_created_15,
  t0.verification_cookie AS verification_cookie_16,
  t0.expiration_date AS expiration_date_17,
  t0.start_date AS start_date_18,
  t0.system_expert AS system_expert_19,
  t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20,
  t0.password_reset_required AS password_reset_required_21,
  t0.soft_delete AS soft_delete_22
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.email = 'api_78376ghd3@ktba.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
4	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
5	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
6	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
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->executeAuthenticator (line 189)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

7.89 ms
(9.60%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.first_name = ? AND t0.last_name = ? LIMIT 1

Parameters:

[
  "API"
  "API"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.active AS active_7,
  t0.last_login AS last_login_8,
  t0.first_name AS first_name_9,
  t0.middle_name AS middle_name_10,
  t0.last_name AS last_name_11,
  t0.phone_number AS phone_number_12,
  t0.newsletter AS newsletter_13,
  t0.token AS token_14,
  t0.token_created AS token_created_15,
  t0.verification_cookie AS verification_cookie_16,
  t0.expiration_date AS expiration_date_17,
  t0.start_date AS start_date_18,
  t0.system_expert AS system_expert_19,
  t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20,
  t0.password_reset_required AS password_reset_required_21,
  t0.soft_delete AS soft_delete_22
FROM
  user t0
WHERE
  t0.first_name = ?
  AND t0.last_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.first_name = 'API' AND t0.last_name = 'API' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Security\AccessTokenHandler->getUserBadgeFrom (line 38)
4	Symfony\Component\Security\Http\Authenticator\AccessTokenAuthenticator->authenticate (line 61)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

5.51 ms
(6.70%)

SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.release_date AS release_date_3, t0.status AS status_4, t0.version AS version_5 FROM published_release t0 WHERE t0.status = ? ORDER BY t0.release_date DESC LIMIT 1

Parameters:

[
  100
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.module_id AS module_id_2,
  t0.release_date AS release_date_3,
  t0.status AS status_4,
  t0.version AS version_5
FROM
  published_release t0
WHERE
  t0.status = ?
ORDER BY
  t0.release_date DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.release_date AS release_date_3, t0.status AS status_4, t0.version AS version_5 FROM published_release t0 WHERE t0.status = 100 ORDER BY t0.release_date DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\EventSubscriber\TwigEventSubscriber->onControllerEvent (line 66)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

3.45 ms
(4.20%)

"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 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Repository\Main\AbstractBaseRepository->save (line 28)
4	App\Repository\Main\UserRepository->setLastLogin (line 146)
5	App\EventListener\LoginEventListener->onLoginAttempt (line 37)
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 250)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

3.23 ms
(3.92%)

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.module_id AS module_id_3, t0.is_demo AS is_demo_4, t0.module_expiration_date AS module_expiration_date_5, t0.start_date AS start_date_6, t0.is_active AS is_active_7, t0.ordered AS ordered_8 FROM account_module t0 WHERE t0.account_id IS NULL AND t0.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.account_id AS account_id_2,
  t0.module_id AS module_id_3,
  t0.is_demo AS is_demo_4,
  t0.module_expiration_date AS module_expiration_date_5,
  t0.start_date AS start_date_6,
  t0.is_active AS is_active_7,
  t0.ordered AS ordered_8
FROM
  account_module t0
WHERE
  t0.account_id IS NULL
  AND t0.is_active = ?

SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.module_id AS module_id_3, t0.is_demo AS is_demo_4, t0.module_expiration_date AS module_expiration_date_5, t0.start_date AS start_date_6, t0.is_active AS is_active_7, t0.ordered AS ordered_8 FROM account_module t0 WHERE t0.account_id IS NULL AND t0.is_active = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Repository\Main\AccountRepository->getAvailableModules (line 103)
4	App\Service\Generic\Menu->getTranslatedMenuStructure (line 223)
5	App\EventSubscriber\TwigEventSubscriber->onControllerEvent (line 61)
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\HttpKernel\HttpKernel->handleRaw (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.57 ms
(3.13%)

UPDATE user SET last_login = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-06-02 21:00:05"
  "2026-06-02 21:00:05"
  3453
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_login = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET last_login = '2026-06-02 21:00:05', updated_at = '2026-06-02 21:00:05' WHERE id = 3453;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 536)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 422)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1283)
4	Doctrine\ORM\UnitOfWork->commit (line 456)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Repository\Main\AbstractBaseRepository->save (line 28)
7	App\Repository\Main\UserRepository->setLastLogin (line 146)
8	App\EventListener\LoginEventListener->onLoginAttempt (line 37)
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 250)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

1.15 ms
(1.40%)

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.account_id AS account_id_3 FROM account_user t0 WHERE t0.user_id = ? AND t0.account_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.account_id AS account_id_3
FROM
  account_user t0
WHERE
  t0.user_id = ?
  AND t0.account_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.account_id AS account_id_3 FROM account_user t0 WHERE t0.user_id = 3453 AND t0.account_id = 302 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Repository\Main\UserRepository->hasBoAccess (line 277)
4	App\Service\Generic\Menu->__construct (line 206)
5	ContainerJxbxD6d\App_KernelDevDebugContainer->getMenuService (line 1506)
6	ContainerJxbxD6d\App_KernelDevDebugContainer::getTwigEventSubscriberService (line 1450)
7	ContainerJxbxD6d\App_KernelDevDebugContainer::{closure:ContainerJxbxD6d\App_KernelDevDebugContainer::getEventDispatcherService():1126} (line 1126)
8	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
9	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
legacy	doctrine.dbal.legacy_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
legacy	doctrine.orm.legacy_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Main\User	1
App\Entity\Main\LogAction	1
App\Entity\Main\AccountUser	1
App\Entity\Main\PublishedRelease	1

legacy entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Main\AbstractBaseEntity	No errors.
App\Entity\Main\User	No errors.
App\Entity\Main\Permission	No errors.
App\Entity\Main\LogAction	No errors.
App\Entity\Main\AccountUser	No errors.
App\Entity\Main\Account	No errors.
App\Entity\Main\AccountModule	No errors.
App\Entity\Main\PublishedRelease	No errors.

legacy entity manager

No loaded entities.

Symfony Profiler

GET https://quin.riskplaza.nl/api/public/audit_plus_accounts/get/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

legacy entity manager

Entities Mapping

default entity manager

legacy entity manager