Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

21.09 ms Query time

0 Invalid entities

2 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

8.71 ms
(41.31%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.uuid AS uuid_4, u0_.data AS data_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.active AS active_8, u0_.middle_name AS middle_name_9, u0_.avatar AS avatar_10, u0_.changed AS changed_11, u0_.guardian AS guardian_12, u0_.logged_in_at AS logged_in_at_13, u0_.first_login_at AS first_login_at_14, u0_.username AS username_15, u0_.birthdate AS birthdate_16, u0_.student_password_is_set AS student_password_is_set_17, u0_.internal_registration AS internal_registration_18, u0_.organisations AS organisations_19, u0_.cookies_compliance AS cookies_compliance_20, u0_.full_time_access AS full_time_access_21, u0_.created_at AS created_at_22, u0_.login_token AS login_token_23 FROM user_entity_table u0_ WHERE LOWER(u0_.email) = LOWER(?)

Parameters:

[
  "marta.krvavac@skole.hr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.uuid AS uuid_4,
  u0_.data AS data_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.active AS active_8,
  u0_.middle_name AS middle_name_9,
  u0_.avatar AS avatar_10,
  u0_.changed AS changed_11,
  u0_.guardian AS guardian_12,
  u0_.logged_in_at AS logged_in_at_13,
  u0_.first_login_at AS first_login_at_14,
  u0_.username AS username_15,
  u0_.birthdate AS birthdate_16,
  u0_.student_password_is_set AS student_password_is_set_17,
  u0_.internal_registration AS internal_registration_18,
  u0_.organisations AS organisations_19,
  u0_.cookies_compliance AS cookies_compliance_20,
  u0_.full_time_access AS full_time_access_21,
  u0_.created_at AS created_at_22,
  u0_.login_token AS login_token_23
FROM
  user_entity_table u0_
WHERE
  LOWER(u0_.email) = LOWER(?)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.uuid AS uuid_4, u0_.data AS data_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.active AS active_8, u0_.middle_name AS middle_name_9, u0_.avatar AS avatar_10, u0_.changed AS changed_11, u0_.guardian AS guardian_12, u0_.logged_in_at AS logged_in_at_13, u0_.first_login_at AS first_login_at_14, u0_.username AS username_15, u0_.birthdate AS birthdate_16, u0_.student_password_is_set AS student_password_is_set_17, u0_.internal_registration AS internal_registration_18, u0_.organisations AS organisations_19, u0_.cookies_compliance AS cookies_compliance_20, u0_.full_time_access AS full_time_access_21, u0_.created_at AS created_at_22, u0_.login_token AS login_token_23 FROM user_entity_table u0_ WHERE LOWER(u0_.email) = LOWER('marta.krvavac@skole.hr');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 29)
7	App\Repository\UserRepository->findOneByEmail (line 52)
8	App\Service\Authapi->findUser (line 79)
9	App\Service\Authapi->getUser (line 66)
10	App\Security\AuthapiLoginAuthenticator->authenticate (line 70)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

5.40 ms
(25.61%)

SELECT l0_.id AS id_0, l0_.mail AS mail_1, l0_.created_at AS created_at_2, l0_.is_successful AS is_successful_3 FROM login_flood l0_ WHERE l0_.mail = ? AND l0_.created_at > ? AND l0_.is_successful = false ORDER BY l0_.created_at ASC

Parameters:

[
  "marta.krvavac@skole.hr"
  "2026-04-01 12:31:29"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.mail AS mail_1,
  l0_.created_at AS created_at_2,
  l0_.is_successful AS is_successful_3
FROM
  login_flood l0_
WHERE
  l0_.mail = ?
  AND l0_.created_at > ?
  AND l0_.is_successful = false
ORDER BY
  l0_.created_at ASC

SELECT l0_.id AS id_0, l0_.mail AS mail_1, l0_.created_at AS created_at_2, l0_.is_successful AS is_successful_3 FROM login_flood l0_ WHERE l0_.mail = 'marta.krvavac@skole.hr' AND l0_.created_at > '2026-04-01 12:31:29' AND l0_.is_successful = false ORDER BY l0_.created_at ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 65)
7	App\Repository\LoginFloodRepository->findUnsuccessfulLoginByMailAndMinutes (line 27)
8	App\Service\LoginAttempt->isAllowedToLogin (line 56)
9	App\Security\AuthapiLoginAuthenticator->authenticate (line 70)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
17	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.40 ms
(11.37%)

SELECT NEXTVAL('login_flood_id_seq')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('login_flood_id_seq')

SELECT NEXTVAL('login_flood_id_seq');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 46)
3	Doctrine\ORM\Id\SequenceGenerator->generateId (line 918)
4	Doctrine\ORM\UnitOfWork->persistNew (line 1805)
5	Doctrine\ORM\UnitOfWork->doPersist (line 1763)
6	Doctrine\ORM\UnitOfWork->persist (line 439)
7	Doctrine\ORM\EntityManager->persist (line 56)
8	App\Service\LoginAttempt->logAttempt (line 63)
9	App\Security\AuthapiLoginAuthenticator->authenticate (line 70)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
17	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.26 ms
(10.73%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 57)
5	App\Service\LoginAttempt->logAttempt (line 63)
6	App\Security\AuthapiLoginAuthenticator->authenticate (line 70)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
11	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
14	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.03 ms
(4.87%)

INSERT INTO login_flood (id, mail, created_at, is_successful) VALUES (?, ?, ?, ?)

Parameters:

[
  1219
  "marta.krvavac@skole.hr"
  "2026-04-01 12:36:29"
  0
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO login_flood (
  id, mail, created_at, is_successful
)
VALUES
  (?, ?, ?, ?)

INSERT INTO login_flood (id, mail, created_at, is_successful) VALUES (1219, 'marta.krvavac@skole.hr', '2026-04-01 12:36:29', 0);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 57)
7	App\Service\LoginAttempt->logAttempt (line 63)
8	App\Security\AuthapiLoginAuthenticator->authenticate (line 70)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
16	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.69 ms
(3.27%)

SET search_path TO bws_dev_hr

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  search_path TO bws_dev_hr

SET search_path TO bws_dev_hr;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 216)
3	App\Service\WorkspaceSwitch->switchPGSQLSchema (line 200)
4	App\Service\WorkspaceSwitch->switchWorkspace (line 96)
5	App\Service\WorkspaceSwitch->switch (line 88)
6	App\EventListener\WorkspaceListener->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.60 ms
(2.84%)

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 57)
4	App\Service\LoginAttempt->logAttempt (line 63)
5	App\Security\AuthapiLoginAuthenticator->authenticate (line 70)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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

2 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
app_entity_workspace	2

Entities Mapping

Class	Mapping errors
App\Entity\Workspace	No errors.
App\Entity\LoginFlood	No errors.
App\Entity\User	No errors.

Symfony Profiler

POST https://dev-bizzi-api.izzi.digital/authapi/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Entities Mapping