Symfony Profiler

Query Metrics

11 Database Queries

5 Different statements

6.88 ms Query time

0 Invalid entities

22 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.42 ms
(49.65%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3 FROM information t0 WHERE t0.id = ?

Parameters:

[
  107
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.paragraphe AS paragraphe_3
FROM
  information t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3 FROM information t0 WHERE t0.id = 107;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1795)
5	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a::block_content (line 789)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_f7fbd913ed2a6c6b9fdeea92b8ed5fc0->doDisplay (line 201)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a->doDisplay (line 64)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\TournamentController->show (line 83)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

1.15 ms
(16.68%)

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.homologuer_fft AS homologuer_fft_41, t28.demander_id_dupr AS demander_id_dupr_42, t28.etat_actuel AS etat_actuel_43, t28.commission_plateforme AS commission_plateforme_44, t28.config_id AS config_id_45, t28.organisateur_id AS organisateur_id_46, t28.style_id AS style_id_47, t28.circuit_id AS circuit_id_48 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.fin_inscription AS fin_inscription_3,
  t0.nb_joueur AS nb_joueur_4,
  t0.date_fin AS date_fin_5,
  t0.adresse AS adresse_6,
  t0.complement AS complement_7,
  t0.cp AS cp_8,
  t0.ville AS ville_9,
  t0.pays AS pays_10,
  t0.map AS map_11,
  t0.nb_joueur_max AS nb_joueur_max_12,
  t0.nb_equipe_max AS nb_equipe_max_13,
  t0.terrain_interieur AS terrain_interieur_14,
  t0.terrain_exterieur AS terrain_exterieur_15,
  t0.type_balle AS type_balle_16,
  t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17,
  t0.montant_repas AS montant_repas_18,
  t0.devise AS devise_19,
  t0.nb_journee_previsionnel AS nb_journee_previsionnel_20,
  t0.prizepool AS prizepool_21,
  t0.nb_match_par_rencontre AS nb_match_par_rencontre_22,
  t0.datas_victoire AS datas_victoire_23,
  t0.points_victoire AS points_victoire_24,
  t0.points_defaite AS points_defaite_25,
  t0.points_nul AS points_nul_26,
  t0.categorie AS categorie_27,
  t28.id AS id_29,
  t28.ordre_circuit AS ordre_circuit_30,
  t28.is_master_final AS is_master_final_31,
  t28.sur_invitation AS sur_invitation_32,
  t28.points_assiduite AS points_assiduite_33,
  t28.titre AS titre_34,
  t28.description AS description_35,
  t28.creation AS creation_36,
  t28.termine AS termine_37,
  t28.date_creation AS date_creation_38,
  t28.encours AS encours_39,
  t28.publier AS publier_40,
  t28.homologuer_fft AS homologuer_fft_41,
  t28.demander_id_dupr AS demander_id_dupr_42,
  t28.etat_actuel AS etat_actuel_43,
  t28.commission_plateforme AS commission_plateforme_44,
  t28.config_id AS config_id_45,
  t28.organisateur_id AS organisateur_id_46,
  t28.style_id AS style_id_47,
  t28.circuit_id AS circuit_id_48
FROM
  config t0
  LEFT JOIN evenement t28 ON t28.config_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.ordre_circuit AS ordre_circuit_30, t28.is_master_final AS is_master_final_31, t28.sur_invitation AS sur_invitation_32, t28.points_assiduite AS points_assiduite_33, t28.titre AS titre_34, t28.description AS description_35, t28.creation AS creation_36, t28.termine AS termine_37, t28.date_creation AS date_creation_38, t28.encours AS encours_39, t28.publier AS publier_40, t28.homologuer_fft AS homologuer_fft_41, t28.demander_id_dupr AS demander_id_dupr_42, t28.etat_actuel AS etat_actuel_43, t28.commission_plateforme AS commission_plateforme_44, t28.config_id AS config_id_45, t28.organisateur_id AS organisateur_id_46, t28.style_id AS style_id_47, t28.circuit_id AS circuit_id_48 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1795)
5	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a::block_title (line 87)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_f7fbd913ed2a6c6b9fdeea92b8ed5fc0->doDisplay (line 75)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a->doDisplay (line 64)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\TournamentController->show (line 83)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.91 ms
(13.20%)

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 WHERE t0.id = ?

Parameters:

[
  11
]

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
WHERE
  t0.id = ?

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 WHERE t0.id = 11;

#	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	App\Controller\TournamentController->show (line 63)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.79 ms
(11.51%)

SELECT t0.id AS id_1, t0.information_id AS information_id_2, t0.evenement_id AS evenement_id_3 FROM evenement_information t0 WHERE t0.evenement_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.information_id AS information_id_2,
  t0.evenement_id AS evenement_id_3
FROM
  evenement_information t0
WHERE
  t0.evenement_id = ?

SELECT t0.id AS id_1, t0.information_id AS information_id_2, t0.evenement_id AS evenement_id_3 FROM evenement_information t0 WHERE t0.evenement_id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a->block_content (line 772)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_f7fbd913ed2a6c6b9fdeea92b8ed5fc0->doDisplay (line 201)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a->doDisplay (line 64)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\TournamentController->show (line 83)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.62 ms
(8.96%)

SELECT t0.id AS id_1, t0.licence AS licence_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.fonction AS fonction_5 FROM contact t0 INNER JOIN contact_config ON t0.id = contact_config.contact_id WHERE contact_config.config_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.licence AS licence_2,
  t0.email AS email_3,
  t0.telephone AS telephone_4,
  t0.fonction AS fonction_5
FROM
  contact t0
  INNER JOIN contact_config ON t0.id = contact_config.contact_id
WHERE
  contact_config.config_id = ?

SELECT t0.id AS id_1, t0.licence AS licence_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.fonction AS fonction_5 FROM contact t0 INNER JOIN contact_config ON t0.id = contact_config.contact_id WHERE contact_config.config_id = 11;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a->block_content (line 844)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_f7fbd913ed2a6c6b9fdeea92b8ed5fc0->doDisplay (line 201)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_859f5db8a7bfc1d420566376dc78b38a->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\TournamentController->show (line 83)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	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\EvenementInformation	7
App\Entity\Information	7
App\Entity\Contact	4
App\Entity\Evenement	1
App\Entity\Config	1
App\Entity\User	1
App\Entity\Style	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	No errors.
App\Entity\Promo	No errors.
App\Entity\Selection	No errors.
App\Entity\Contact	No errors.
App\Entity\Information	No errors.

Symfony Profiler

GET https://preprod.tournoipickleball.fr/detail_tournoi/11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping