Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

21.04 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.59 ms
(55.09%)

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.username AS username_8 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "b.pereira@lightbulb.lu"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.avatar AS avatar_2,
  t0.updated_at AS updated_at_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.is_verified AS is_verified_7,
  t0.username AS username_8
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.avatar AS avatar_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.username AS username_8 FROM user t0 WHERE t0.email = 'b.pereira@lightbulb.lu' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 774)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

7.82 ms
(37.15%)

SELECT t0.id AS id_1, t0.process_id AS process_id_2, t0.new AS new_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.bank_account_name AS bank_account_name_6, t0.address AS address_7, t0.post_code AS post_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.email AS email_11, t0.permanent AS permanent_12, t0.donor_rank AS donor_rank_13, t0.active AS active_14, t0.source_id AS source_id_15, t0.title_id AS title_id_16, t0.migrated_to_id AS migrated_to_id_17 FROM donor t0 INNER JOIN donor_donor_role ON t0.id = donor_donor_role.donor_id WHERE donor_donor_role.donor_role_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.process_id AS process_id_2,
  t0.new AS new_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.bank_account_name AS bank_account_name_6,
  t0.address AS address_7,
  t0.post_code AS post_code_8,
  t0.city AS city_9,
  t0.phone AS phone_10,
  t0.email AS email_11,
  t0.permanent AS permanent_12,
  t0.donor_rank AS donor_rank_13,
  t0.active AS active_14,
  t0.source_id AS source_id_15,
  t0.title_id AS title_id_16,
  t0.migrated_to_id AS migrated_to_id_17
FROM
  donor t0
  INNER JOIN donor_donor_role ON t0.id = donor_donor_role.donor_id
WHERE
  donor_donor_role.donor_role_id = ?

SELECT t0.id AS id_1, t0.process_id AS process_id_2, t0.new AS new_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.bank_account_name AS bank_account_name_6, t0.address AS address_7, t0.post_code AS post_code_8, t0.city AS city_9, t0.phone AS phone_10, t0.email AS email_11, t0.permanent AS permanent_12, t0.donor_rank AS donor_rank_13, t0.active AS active_14, t0.source_id AS source_id_15, t0.title_id AS title_id_16, t0.migrated_to_id AS migrated_to_id_17 FROM donor t0 INNER JOIN donor_donor_role ON t0.id = donor_donor_role.donor_id WHERE donor_donor_role.donor_role_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1090)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1012)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 811)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 708)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 194)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 174)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 136)
12	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 91)
15	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
16	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
17	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
18	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
19	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
20	Symfony\Component\Serializer\Serializer->normalize (line 129)
21	Symfony\Component\Serializer\Serializer->serialize (line 43)
22	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
23	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
24	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 115)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

1.63 ms
(7.76%)

SELECT d0_.id AS id_0, d0_.role AS role_1 FROM donor_role d0_ ORDER BY d0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.role AS role_1
FROM
  donor_role d0_
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.role AS role_1 FROM donor_role d0_ ORDER BY d0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 81)
7	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 76)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 87)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 95)
14	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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.

Entities Mapping

Class	Mapping errors
App\Entity\DonorRole	No errors.
App\Entity\User	No errors.
App\Entity\BankStatement	No errors.
App\Entity\Donor	No errors.
App\Entity\DonorSource	No errors.
App\Entity\DonorTitle	No errors.
App\Entity\BankAccount	No errors.
App\Entity\Letter	No errors.
App\Entity\Donation	No errors.
App\Entity\Transaction	No errors.

Symfony Profiler

GET https://flbdon-back.dev.lightbulb.lu/api/donor_roles

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping