Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

5.08 ms Query time

5 Invalid entities

14 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.50 ms
(29.52%)

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

Parameters:

[
  15
]

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

#	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\Information::{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\Information->__get (line 40)
8	App\Entity\Information->getTitre (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 225)
10	__TwigTemplate_3e7867becf43359af440df11b399fb88->block_content (line 446)
11	Twig\Template->yieldBlock (line 94)
12	__TwigTemplate_5612da5f375db5d3796061ee5f52f0be->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_3e7867becf43359af440df11b399fb88->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
23	App\Controller\TournamentController->show (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.13 ms
(22.23%)

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.titre AS titre_30, t28.description AS description_31, t28.creation AS creation_32, t28.termine AS termine_33, t28.date_creation AS date_creation_34, t28.encours AS encours_35, t28.publier AS publier_36, t28.homologuer_fft AS homologuer_fft_37, t28.demander_id_dupr AS demander_id_dupr_38, t28.etat_actuel AS etat_actuel_39, t28.config_id AS config_id_40, t28.organisateur_id AS organisateur_id_41, t28.style_id AS style_id_42 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

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.titre AS titre_30,
  t28.description AS description_31,
  t28.creation AS creation_32,
  t28.termine AS termine_33,
  t28.date_creation AS date_creation_34,
  t28.encours AS encours_35,
  t28.publier AS publier_36,
  t28.homologuer_fft AS homologuer_fft_37,
  t28.demander_id_dupr AS demander_id_dupr_38,
  t28.etat_actuel AS etat_actuel_39,
  t28.config_id AS config_id_40,
  t28.organisateur_id AS organisateur_id_41,
  t28.style_id AS style_id_42
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.titre AS titre_30, t28.description AS description_31, t28.creation AS creation_32, t28.termine AS termine_33, t28.date_creation AS date_creation_34, t28.encours AS encours_35, t28.publier AS publier_36, t28.homologuer_fft AS homologuer_fft_37, t28.demander_id_dupr AS demander_id_dupr_38, t28.etat_actuel AS etat_actuel_39, t28.config_id AS config_id_40, t28.organisateur_id AS organisateur_id_41, t28.style_id AS style_id_42 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = 2;

#	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\Config::{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\Config->__get (line 129)
8	App\Entity\Config->getDateDebut (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 155)
10	__TwigTemplate_3e7867becf43359af440df11b399fb88->block_content (line 446)
11	Twig\Template->yieldBlock (line 94)
12	__TwigTemplate_5612da5f375db5d3796061ee5f52f0be->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_3e7867becf43359af440df11b399fb88->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
23	App\Controller\TournamentController->show (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.88 ms
(17.23%)

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:

[
  2
]

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

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 208)
9	__TwigTemplate_3e7867becf43359af440df11b399fb88->block_content (line 446)
10	Twig\Template->yieldBlock (line 94)
11	__TwigTemplate_5612da5f375db5d3796061ee5f52f0be->doDisplay (line 402)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_3e7867becf43359af440df11b399fb88->doDisplay (line 402)
14	Twig\Template->yield (line 358)
15	Twig\Template->display (line 373)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 333)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
22	App\Controller\TournamentController->show (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.80 ms
(15.73%)

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:

[
  2
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
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 274)
8	__TwigTemplate_3e7867becf43359af440df11b399fb88->block_content (line 446)
9	Twig\Template->yieldBlock (line 94)
10	__TwigTemplate_5612da5f375db5d3796061ee5f52f0be->doDisplay (line 402)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_3e7867becf43359af440df11b399fb88->doDisplay (line 402)
13	Twig\Template->yield (line 358)
14	Twig\Template->display (line 373)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 333)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 62)
21	App\Controller\TournamentController->show (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.78 ms
(15.28%)

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:

[
  2
]

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

#	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 54)
7	App\Controller\TournamentController->show (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)

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\Contact	4
App\Entity\EvenementInformation	3
App\Entity\Information	3
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	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\Promo	The field 'App\Entity\Promo#prix' 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\Contact	The field App\Entity\Contact#configs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Config#contacts does not contain the required 'inversedBy="configs"' attribute.
App\Entity\Information	The field App\Entity\Information#evenementInformations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EvenementInformation#information does not contain the required 'inversedBy="evenementInformations"' attribute.

Symfony Profiler

GET https://tournoipickleball.fr/detail_tournoi/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping