Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.72 ms Query time

3 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.87 ms
(50.46%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  5748
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.pseudo AS pseudo_3,
  t0.licence AS licence_4,
  t0.id_dupr AS id_dupr_5,
  t0.genre AS genre_6,
  t0.nom AS nom_7,
  t0.prenom AS prenom_8,
  t0.date_de_naissance AS date_de_naissance_9,
  t0.ville AS ville_10,
  t0.description AS description_11,
  t0.telephone AS telephone_12,
  t0.instagram AS instagram_13,
  t0.linkedin AS linkedin_14,
  t0.tiktok AS tiktok_15,
  t0.twitter AS twitter_16,
  t0.facebook AS facebook_17,
  t0.statut AS statut_18,
  t0.roles AS roles_19,
  t0.password AS password_20,
  t0.indicateur AS indicateur_21,
  t0.createur AS createur_22,
  t0.pays_id AS pays_id_23,
  t0.niveau_simple_id AS niveau_simple_id_24,
  t0.niveau_double_id AS niveau_double_id_25,
  t0.niveau_mixte_id AS niveau_mixte_id_26
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.licence AS licence_4, t0.id_dupr AS id_dupr_5, t0.genre AS genre_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.date_de_naissance AS date_de_naissance_9, t0.ville AS ville_10, t0.description AS description_11, t0.telephone AS telephone_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.statut AS statut_18, t0.roles AS roles_19, t0.password AS password_20, t0.indicateur AS indicateur_21, t0.createur AS createur_22, t0.pays_id AS pays_id_23, t0.niveau_simple_id AS niveau_simple_id_24, t0.niveau_double_id AS niveau_double_id_25, t0.niveau_mixte_id AS niveau_mixte_id_26 FROM `user` t0 WHERE t0.id = 5748;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::__invoke():70} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 364)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 101)
15	App\Controller\PartnershipRequestController->getMyRequests (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.85 ms
(49.54%)

SELECT p0_.id AS id_0, p0_.date_demande AS date_demande_1, p0_.status AS status_2, p0_.message AS message_3, p0_.date_reponse AS date_reponse_4, p0_.demandeur_id AS demandeur_id_5, p0_.receveur_id AS receveur_id_6, p0_.evenement_id AS evenement_id_7, p0_.selection_id AS selection_id_8 FROM partnership_requests p0_ INNER JOIN `user` u1_ ON p0_.receveur_id = u1_.id INNER JOIN selection s2_ ON p0_.selection_id = s2_.id INNER JOIN evenement e3_ ON p0_.evenement_id = e3_.id WHERE p0_.demandeur_id = ? ORDER BY p0_.date_demande DESC

Parameters:

[
  5748
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.date_demande AS date_demande_1,
  p0_.status AS status_2,
  p0_.message AS message_3,
  p0_.date_reponse AS date_reponse_4,
  p0_.demandeur_id AS demandeur_id_5,
  p0_.receveur_id AS receveur_id_6,
  p0_.evenement_id AS evenement_id_7,
  p0_.selection_id AS selection_id_8
FROM
  partnership_requests p0_
  INNER JOIN `user` u1_ ON p0_.receveur_id = u1_.id
  INNER JOIN selection s2_ ON p0_.selection_id = s2_.id
  INNER JOIN evenement e3_ ON p0_.evenement_id = e3_.id
WHERE
  p0_.demandeur_id = ?
ORDER BY
  p0_.date_demande DESC

SELECT p0_.id AS id_0, p0_.date_demande AS date_demande_1, p0_.status AS status_2, p0_.message AS message_3, p0_.date_reponse AS date_reponse_4, p0_.demandeur_id AS demandeur_id_5, p0_.receveur_id AS receveur_id_6, p0_.evenement_id AS evenement_id_7, p0_.selection_id AS selection_id_8 FROM partnership_requests p0_ INNER JOIN `user` u1_ ON p0_.receveur_id = u1_.id INNER JOIN selection s2_ ON p0_.selection_id = s2_.id INNER JOIN evenement e3_ ON p0_.evenement_id = e3_.id WHERE p0_.demandeur_id = 5748 ORDER BY p0_.date_demande DESC;

#	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 430)
7	App\Service\PartnershipRequestService->getUserRequests (line 105)
8	App\Controller\PartnershipRequestController->getMyRequests (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Niveau	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Pays	No errors.
App\Entity\Niveau	No errors.
App\Entity\UserSelection	The field 'App\Entity\UserSelection#montantPaye' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Payment	The field 'App\Entity\Payment#montantTotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Payment#montantEpreuves' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Payment#montantRepas' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Payment#montantReduction' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PartnershipRequest	No errors.
App\Entity\Selection	The field 'App\Entity\Selection#prix' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Evenement	No errors.

Symfony Profiler

GET https://preprod.tournoipickleball.fr/partnership-request/my-requests

Configuration Settings

Theme

Page Width