Symfony Profiler

Query Metrics

42 Database Queries

6 Different statements

30.98 ms Query time

4 Invalid entities

73 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.24 ms
(42.75%)

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:

[
  5940
]

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 = 5940;

#	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 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\Entity\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\User->__get (line 123)
8	App\Entity\User->getNom (line 60)
9	App\Service\PartnershipRequestService->getTournamentPlayers (line 39)
10	App\Controller\PartnershipRequestController->getTournamentPlayers (line 181)
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)

12.63 ms
(40.77%)

SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = ? AND e0_.selection_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.date_equipe AS date_equipe_1,
  e0_.nom AS nom_2,
  e0_.selection_id AS selection_id_3
FROM
  equipe e0_
  INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id
WHERE
  e1_.user_id = ?
  AND e0_.selection_id = ?
LIMIT
  1

SELECT e0_.id AS id_0, e0_.date_equipe AS date_equipe_1, e0_.nom AS nom_2, e0_.selection_id AS selection_id_3 FROM equipe e0_ INNER JOIN equipe_user e1_ ON e0_.id = e1_.equipe_id WHERE e1_.user_id = 5940 AND e0_.selection_id = 4 LIMIT 1;

#	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 103)
7	App\Service\PartnershipRequestService->getUserTeamForSelection (line 56)
8	App\Service\PartnershipRequestService->getTournamentPlayers (line 39)
9	App\Controller\PartnershipRequestController->getTournamentPlayers (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.32 ms
(7.49%)

SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.equipe_id AS equipe_id_2,
  t0.user_id AS user_id_3,
  t0.invitation_id AS invitation_id_4,
  t0.evenement_id AS evenement_id_5,
  t0.selection_id AS selection_id_6
FROM
  equipe_user t0
WHERE
  t0.equipe_id = ?

SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 111)
8	App\Service\PartnershipRequestService->getUserTeamForSelection (line 56)
9	App\Service\PartnershipRequestService->getTournamentPlayers (line 39)
10	App\Controller\PartnershipRequestController->getTournamentPlayers (line 181)
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)

1.37 ms
(4.41%)

SELECT u0_.id AS id_0, u0_.stripe_session_id AS stripe_session_id_1, u0_.stripe_payment_intent_id AS stripe_payment_intent_id_2, u0_.paye AS paye_3, u0_.date_paiement AS date_paiement_4, u0_.code_promo_utilise AS code_promo_utilise_5, u0_.montant_paye AS montant_paye_6, u0_.joueurs_selectionnes AS joueurs_selectionnes_7, u0_.date_selection_joueurs AS date_selection_joueurs_8, u0_.selection_joueurs_complete AS selection_joueurs_complete_9, u0_.metadata AS metadata_10, u0_.repas AS repas_11, u0_.nb_repas AS nb_repas_12, u0_.user_id AS user_id_13, u0_.selection_id AS selection_id_14, u0_.payment_id AS payment_id_15 FROM user_selection u0_ INNER JOIN `user` u1_ ON u0_.user_id = u1_.id INNER JOIN selection s2_ ON u0_.selection_id = s2_.id WHERE s2_.config_id = ? AND u0_.paye = ? AND s2_.id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.stripe_session_id AS stripe_session_id_1,
  u0_.stripe_payment_intent_id AS stripe_payment_intent_id_2,
  u0_.paye AS paye_3,
  u0_.date_paiement AS date_paiement_4,
  u0_.code_promo_utilise AS code_promo_utilise_5,
  u0_.montant_paye AS montant_paye_6,
  u0_.joueurs_selectionnes AS joueurs_selectionnes_7,
  u0_.date_selection_joueurs AS date_selection_joueurs_8,
  u0_.selection_joueurs_complete AS selection_joueurs_complete_9,
  u0_.metadata AS metadata_10,
  u0_.repas AS repas_11,
  u0_.nb_repas AS nb_repas_12,
  u0_.user_id AS user_id_13,
  u0_.selection_id AS selection_id_14,
  u0_.payment_id AS payment_id_15
FROM
  user_selection u0_
  INNER JOIN `user` u1_ ON u0_.user_id = u1_.id
  INNER JOIN selection s2_ ON u0_.selection_id = s2_.id
WHERE
  s2_.config_id = ?
  AND u0_.paye = ?
  AND s2_.id = ?

SELECT u0_.id AS id_0, u0_.stripe_session_id AS stripe_session_id_1, u0_.stripe_payment_intent_id AS stripe_payment_intent_id_2, u0_.paye AS paye_3, u0_.date_paiement AS date_paiement_4, u0_.code_promo_utilise AS code_promo_utilise_5, u0_.montant_paye AS montant_paye_6, u0_.joueurs_selectionnes AS joueurs_selectionnes_7, u0_.date_selection_joueurs AS date_selection_joueurs_8, u0_.selection_joueurs_complete AS selection_joueurs_complete_9, u0_.metadata AS metadata_10, u0_.repas AS repas_11, u0_.nb_repas AS nb_repas_12, u0_.user_id AS user_id_13, u0_.selection_id AS selection_id_14, u0_.payment_id AS payment_id_15 FROM user_selection u0_ INNER JOIN `user` u1_ ON u0_.user_id = u1_.id INNER JOIN selection s2_ ON u0_.selection_id = s2_.id WHERE s2_.config_id = 3 AND u0_.paye = 1 AND s2_.id = 4;

#	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 44)
7	App\Service\PartnershipRequestService->getTournamentPlayers (line 39)
8	App\Controller\PartnershipRequestController->getTournamentPlayers (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)

0.88 ms
(2.85%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.creation AS creation_4, t0.termine AS termine_5, t0.date_creation AS date_creation_6, t0.encours AS encours_7, t0.publier AS publier_8, t0.homologuer_fft AS homologuer_fft_9, t0.demander_id_dupr AS demander_id_dupr_10, t0.etat_actuel AS etat_actuel_11, t0.config_id AS config_id_12, t0.organisateur_id AS organisateur_id_13, t0.style_id AS style_id_14 FROM evenement t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.creation AS creation_4,
  t0.termine AS termine_5,
  t0.date_creation AS date_creation_6,
  t0.encours AS encours_7,
  t0.publier AS publier_8,
  t0.homologuer_fft AS homologuer_fft_9,
  t0.demander_id_dupr AS demander_id_dupr_10,
  t0.etat_actuel AS etat_actuel_11,
  t0.config_id AS config_id_12,
  t0.organisateur_id AS organisateur_id_13,
  t0.style_id AS style_id_14
FROM
  evenement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.creation AS creation_4, t0.termine AS termine_5, t0.date_creation AS date_creation_6, t0.encours AS encours_7, t0.publier AS publier_8, t0.homologuer_fft AS homologuer_fft_9, t0.demander_id_dupr AS demander_id_dupr_10, t0.etat_actuel AS etat_actuel_11, t0.config_id AS config_id_12, t0.organisateur_id AS organisateur_id_13, t0.style_id AS style_id_14 FROM evenement t0 WHERE t0.id = 3;

#	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 31)
7	App\Controller\PartnershipRequestController->getTournamentPlayers (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.54 ms
(1.73%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.metadata AS metadata_4, t0.jour AS jour_5, t0.id_epreuve_id AS id_epreuve_id_6, t0.id_age_id AS id_age_id_7, t0.id_niveau_id AS id_niveau_id_8, t0.id_forme_id AS id_forme_id_9, t0.config_id AS config_id_10, t0.evenement_id AS evenement_id_11 FROM selection t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prix AS prix_3,
  t0.metadata AS metadata_4,
  t0.jour AS jour_5,
  t0.id_epreuve_id AS id_epreuve_id_6,
  t0.id_age_id AS id_age_id_7,
  t0.id_niveau_id AS id_niveau_id_8,
  t0.id_forme_id AS id_forme_id_9,
  t0.config_id AS config_id_10,
  t0.evenement_id AS evenement_id_11
FROM
  selection t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.metadata AS metadata_4, t0.jour AS jour_5, t0.id_epreuve_id AS id_epreuve_id_6, t0.id_age_id AS id_age_id_7, t0.id_niveau_id AS id_niveau_id_8, t0.id_forme_id AS id_forme_id_9, t0.config_id AS config_id_10, t0.evenement_id AS evenement_id_11 FROM selection t0 WHERE t0.id = 4;

#	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 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\Entity\Selection::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Selection->__get (line 71)
8	App\Entity\Selection->getNom (line 77)
9	App\Service\PartnershipRequestService->getTournamentPlayers (line 39)
10	App\Controller\PartnershipRequestController->getTournamentPlayers (line 181)
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)

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\User	18
App\Entity\UserSelection	17
App\Entity\Payment	17
App\Entity\EquipeUser	8
App\Entity\Equipe	4
App\Entity\Niveau	3
App\Entity\Evenement	1
App\Entity\Config	1
App\Entity\Style	1
App\Entity\Selection	1
App\Entity\Epreuve	1
App\Entity\Age	1

Entities Mapping

Class	Mapping errors
App\Entity\Evenement	No errors.
App\Entity\Config	No errors.
App\Entity\User	No errors.
App\Entity\Style	No errors.
App\Entity\Photo	No errors.
App\Entity\EvenementInformation	No errors.
App\Entity\Playoff	The field App\Entity\Playoff#participants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PlayoffParticipant#playoff does not contain the required 'inversedBy="participants"' attribute.
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\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\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\Equipe	No errors.
App\Entity\EquipeUser	No errors.
App\Entity\Pays	No errors.
App\Entity\Niveau	No errors.
App\Entity\Epreuve	No errors.
App\Entity\Age	No errors.
App\Entity\Forme	No errors.
App\Entity\Invitation	No errors.

Symfony Profiler

GET https://preprod.tournoipickleball.fr/partnership-request/tournament/3/players?category=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping