Symfony Profiler

Query Metrics

13 Database Queries

3 Different statements

11.82 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.23 ms
(44.30%)

SELECT t0.id AS id_1, t0.closed AS closed_2, t0.name AS name_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.objective AS objective_6, t0.concerned_person AS concerned_person_7, t0.accounting_account AS accounting_account_8, t0.type_id AS type_id_9, t0.contact_person_id AS contact_person_id_10 FROM campaign t0 WHERE t0.type_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.closed AS closed_2,
  t0.name AS name_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.objective AS objective_6,
  t0.concerned_person AS concerned_person_7,
  t0.accounting_account AS accounting_account_8,
  t0.type_id AS type_id_9,
  t0.contact_person_id AS contact_person_id_10
FROM
  campaign t0
WHERE
  t0.type_id = ?

SELECT t0.id AS id_1, t0.closed AS closed_2, t0.name AS name_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.objective AS objective_6, t0.concerned_person AS concerned_person_7, t0.accounting_account AS accounting_account_8, t0.type_id AS type_id_9, t0.contact_person_id AS contact_person_id_10 FROM campaign t0 WHERE t0.type_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
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)

3.48 ms
(29.49%)

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)

3.10 ms
(26.21%)

SELECT c0_.id AS id_0, c0_.label AS label_1 FROM campaign_type c0_ ORDER BY c0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.label AS label_1
FROM
  campaign_type c0_
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.label AS label_1 FROM campaign_type c0_ ORDER BY c0_.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\User	No errors.
App\Entity\BankStatement	No errors.
App\Entity\CampaignType	No errors.
App\Entity\Campaign	No errors.
App\Entity\ContactPerson	No errors.
App\Entity\Donation	No errors.
App\Entity\Transaction	No errors.
App\Entity\Fundraising	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping