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

Query Metrics

8 Database Queries
6 Different statements
8.33 ms Query time
7 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 1.12 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:
[
  2
]
2 1.19 ms
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:
[
  1
]
3 1.60 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:
[
  2
]
4 1.28 ms
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
]
5 0.98 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3 FROM information t0 WHERE t0.id = ?
Parameters:
[
  18
]
6 0.72 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3 FROM information t0 WHERE t0.id = ?
Parameters:
[
  19
]
7 0.53 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3 FROM information t0 WHERE t0.id = ?
Parameters:
[
  20
]
8 0.92 ms
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
]

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\User 2
App\Entity\Niveau 2
App\Entity\Evenement 1
App\Entity\Config 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\Pays No errors.
App\Entity\Niveau 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.
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\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.