Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.22 ms Query time

4 Invalid entities

44 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.34 ms

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:

[
  1
]

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

0.99 ms

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:

[
  1
]

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

#	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->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Config::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Config->__get (line 184)
7	App\Entity\Config->getSelections (line 485)
8	App\Controller\TournamentController->register (line 88)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.88 ms

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 FROM selection t0 WHERE t0.config_id = ?

Parameters:

[
  1
]

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
FROM
  selection t0
WHERE
  t0.config_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 FROM selection t0 WHERE t0.config_id = 1;

#	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 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	App\Controller\TournamentController->register (line 89)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (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\Selection	30
App\Entity\Epreuve	5
App\Entity\Niveau	3
App\Entity\Age	2
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	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\Epreuve	No errors.
App\Entity\Age	No errors.
App\Entity\Niveau	No errors.
App\Entity\Forme	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.

Symfony Profiler

GET https://preprod.tournoispickleball.fr/inscription_tournoi/1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping