Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

26.12 ms Query time

1 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.85 ms
(41.54%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.start_at AS start_at_2, c0_.end_at AS end_at_3, c0_.pause_start_at AS pause_start_at_4, c0_.pause_end_at AS pause_end_at_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c1_.id AS id_8, c1_.name AS name_9, c1_.type AS type_10, c0_.challenge_type_id AS challenge_type_id_11 FROM challenges c0_ INNER JOIN challenge_types c1_ ON c0_.challenge_type_id = c1_.id ORDER BY c0_.id ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.start_at AS start_at_2,
  c0_.end_at AS end_at_3,
  c0_.pause_start_at AS pause_start_at_4,
  c0_.pause_end_at AS pause_end_at_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c1_.id AS id_8,
  c1_.name AS name_9,
  c1_.type AS type_10,
  c0_.challenge_type_id AS challenge_type_id_11
FROM
  challenges c0_
  INNER JOIN challenge_types c1_ ON c0_.challenge_type_id = c1_.id
ORDER BY
  c0_.id ASC
LIMIT
  30

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.start_at AS start_at_2, c0_.end_at AS end_at_3, c0_.pause_start_at AS pause_start_at_4, c0_.pause_end_at AS pause_end_at_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c1_.id AS id_8, c1_.name AS name_9, c1_.type AS type_10, c0_.challenge_type_id AS challenge_type_id_11 FROM challenges c0_ INNER JOIN challenge_types c1_ ON c0_.challenge_type_id = c1_.id ORDER BY c0_.id ASC LIMIT 30;

#	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 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 83)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 94)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 6)

9.28 ms
(35.54%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verified_at AS email_verified_at_7, t0.email_verification_token_created_at AS email_verification_token_created_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.newsletter AS newsletter_11, t0.notification AS notification_12, t0.company_id AS company_id_13, t0.service_id AS service_id_14, t0.bike_type_id AS bike_type_id_15, t0.age_range_id AS age_range_id_16, t0.categorie_pc_id AS categorie_pc_id_17, t0.bike_pro_use_id AS bike_pro_use_id_18, t0.bike_weekly_use_id AS bike_weekly_use_id_19 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "sturmel.sebastien@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.email_verification_token AS email_verification_token_6,
  t0.email_verified_at AS email_verified_at_7,
  t0.email_verification_token_created_at AS email_verification_token_created_at_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.newsletter AS newsletter_11,
  t0.notification AS notification_12,
  t0.company_id AS company_id_13,
  t0.service_id AS service_id_14,
  t0.bike_type_id AS bike_type_id_15,
  t0.age_range_id AS age_range_id_16,
  t0.categorie_pc_id AS categorie_pc_id_17,
  t0.bike_pro_use_id AS bike_pro_use_id_18,
  t0.bike_weekly_use_id AS bike_weekly_use_id_19
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.email_verification_token AS email_verification_token_6, t0.email_verified_at AS email_verified_at_7, t0.email_verification_token_created_at AS email_verification_token_created_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.newsletter AS newsletter_11, t0.notification AS notification_12, t0.company_id AS company_id_13, t0.service_id AS service_id_14, t0.bike_type_id AS bike_type_id_15, t0.age_range_id AS age_range_id_16, t0.categorie_pc_id AS categorie_pc_id_17, t0.bike_pro_use_id AS bike_pro_use_id_18, t0.bike_weekly_use_id AS bike_weekly_use_id_19 FROM users t0 WHERE t0.email = 'sturmel.sebastien@gmail.com' LIMIT 1;

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

5.99 ms
(22.93%)

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM challenges c0_ INNER JOIN challenge_types c1_ ON c0_.challenge_type_id = c1_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  challenges c0_
  INNER JOIN challenge_types c1_ ON c0_.challenge_type_id = c1_.id

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM challenges c0_ INNER JOIN challenge_types c1_ ON c0_.challenge_type_id = c1_.id;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 64)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 87)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 53)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 76)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->normalize (line 131)
15	Symfony\Component\Serializer\Serializer->serialize (line 44)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 74)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 51)
18	ApiPlatform\State\Processor\WriteProcessor->process (line 112)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 6)

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\Challenge	2
App\Entity\ChallengeType	2
App\Entity\User	1
App\Entity\BikeType	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	The field App\Entity\Company#users is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#company does not contain the required 'inversedBy: "users"' attribute.
App\Entity\Service	No errors.
App\Entity\BikeType	No errors.
App\Entity\UserAgeRange	No errors.
App\Entity\UserCategoriePc	No errors.
App\Entity\UserBikeProUse	No errors.
App\Entity\UserBikeWeeklyUse	No errors.
App\Entity\UserBadge	No errors.
App\Entity\Challenge	No errors.
App\Entity\ChallengeType	No errors.

Symfony Profiler

GET https://api.abav.lugh-web.online/api/challenges

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping