Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

5.14 ms Query time

0 Invalid entities

332 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.85 ms
(36.09%)

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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0

Parameters:

[]

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.stripe_account_id AS stripe_account_id_23,
  t0.stripe_onboarding_complete AS stripe_onboarding_complete_24,
  t0.stripe_account_created_at AS stripe_account_created_at_25,
  t0.is_admin AS is_admin_26,
  t0.commission_defaut AS commission_defaut_27,
  t0.newsletter_consent AS newsletter_consent_28,
  t0.newsletter_consent_date AS newsletter_consent_date_29,
  t0.pays_id AS pays_id_30,
  t0.niveau_simple_id AS niveau_simple_id_31,
  t0.niveau_double_id AS niveau_double_id_32,
  t0.niveau_mixte_id AS niveau_mixte_id_33
FROM
  `user` t0

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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\AdminController->dashboard (line 45)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.28 ms
(24.85%)

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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0 WHERE t0.createur = ?

Parameters:

[
  1
]

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.stripe_account_id AS stripe_account_id_23,
  t0.stripe_onboarding_complete AS stripe_onboarding_complete_24,
  t0.stripe_account_created_at AS stripe_account_created_at_25,
  t0.is_admin AS is_admin_26,
  t0.commission_defaut AS commission_defaut_27,
  t0.newsletter_consent AS newsletter_consent_28,
  t0.newsletter_consent_date AS newsletter_consent_date_29,
  t0.pays_id AS pays_id_30,
  t0.niveau_simple_id AS niveau_simple_id_31,
  t0.niveau_double_id AS niveau_double_id_32,
  t0.niveau_mixte_id AS niveau_mixte_id_33
FROM
  `user` t0
WHERE
  t0.createur = ?

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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0 WHERE t0.createur = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\AdminController->dashboard (line 46)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.89 ms
(17.39%)

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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.stripe_account_id AS stripe_account_id_23,
  t0.stripe_onboarding_complete AS stripe_onboarding_complete_24,
  t0.stripe_account_created_at AS stripe_account_created_at_25,
  t0.is_admin AS is_admin_26,
  t0.commission_defaut AS commission_defaut_27,
  t0.newsletter_consent AS newsletter_consent_28,
  t0.newsletter_consent_date AS newsletter_consent_date_29,
  t0.pays_id AS pays_id_30,
  t0.niveau_simple_id AS niveau_simple_id_31,
  t0.niveau_double_id AS niveau_double_id_32,
  t0.niveau_mixte_id AS niveau_mixte_id_33
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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.62 ms
(12.06%)

SELECT t0.id AS id_1, t0.ordre_circuit AS ordre_circuit_2, t0.is_master_final AS is_master_final_3, t0.sur_invitation AS sur_invitation_4, t0.points_assiduite AS points_assiduite_5, t0.titre AS titre_6, t0.description AS description_7, t0.creation AS creation_8, t0.termine AS termine_9, t0.date_creation AS date_creation_10, t0.encours AS encours_11, t0.publier AS publier_12, t0.homologuer_fft AS homologuer_fft_13, t0.demander_id_dupr AS demander_id_dupr_14, t0.etat_actuel AS etat_actuel_15, t0.commission_plateforme AS commission_plateforme_16, t0.config_id AS config_id_17, t0.organisateur_id AS organisateur_id_18, t0.style_id AS style_id_19, t0.circuit_id AS circuit_id_20 FROM evenement t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ordre_circuit AS ordre_circuit_2,
  t0.is_master_final AS is_master_final_3,
  t0.sur_invitation AS sur_invitation_4,
  t0.points_assiduite AS points_assiduite_5,
  t0.titre AS titre_6,
  t0.description AS description_7,
  t0.creation AS creation_8,
  t0.termine AS termine_9,
  t0.date_creation AS date_creation_10,
  t0.encours AS encours_11,
  t0.publier AS publier_12,
  t0.homologuer_fft AS homologuer_fft_13,
  t0.demander_id_dupr AS demander_id_dupr_14,
  t0.etat_actuel AS etat_actuel_15,
  t0.commission_plateforme AS commission_plateforme_16,
  t0.config_id AS config_id_17,
  t0.organisateur_id AS organisateur_id_18,
  t0.style_id AS style_id_19,
  t0.circuit_id AS circuit_id_20
FROM
  evenement t0

SELECT t0.id AS id_1, t0.ordre_circuit AS ordre_circuit_2, t0.is_master_final AS is_master_final_3, t0.sur_invitation AS sur_invitation_4, t0.points_assiduite AS points_assiduite_5, t0.titre AS titre_6, t0.description AS description_7, t0.creation AS creation_8, t0.termine AS termine_9, t0.date_creation AS date_creation_10, t0.encours AS encours_11, t0.publier AS publier_12, t0.homologuer_fft AS homologuer_fft_13, t0.demander_id_dupr AS demander_id_dupr_14, t0.etat_actuel AS etat_actuel_15, t0.commission_plateforme AS commission_plateforme_16, t0.config_id AS config_id_17, t0.organisateur_id AS organisateur_id_18, t0.style_id AS style_id_19, t0.circuit_id AS circuit_id_20 FROM evenement t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\AdminController->dashboard (line 47)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.49 ms
(9.62%)

SELECT COUNT(d0_.id) AS sclr_0 FROM demande_createur d0_ WHERE d0_.statut = ?

Parameters:

[
  "en_attente"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  demande_createur d0_
WHERE
  d0_.statut = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM demande_createur d0_ WHERE d0_.statut = 'en_attente';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\DemandeCreateurRepository->countEnAttente (line 57)
8	App\Controller\AdminController->dashboard (line 48)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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	303
App\Entity\Evenement	11
App\Entity\Config	11
App\Entity\Niveau	5
App\Entity\Style	2

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Pays	No errors.
App\Entity\Niveau	No errors.
App\Entity\UserSelection	No errors.
App\Entity\Payment	No errors.
App\Entity\Evenement	No errors.
App\Entity\Config	No errors.
App\Entity\Style	No errors.
App\Entity\Photo	No errors.
App\Entity\EvenementInformation	No errors.
App\Entity\Playoff	No errors.
App\Entity\DemandeCreateur	No errors.

Symfony Profiler

GET https://preprod.tournoipickleball.fr/admin

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping