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

Query Metrics

9 Database Queries
8 Different statements
9.47 ms Query time
6 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 1.27 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:
[
  5748
]
2 1.15 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
]
3 1.45 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.18 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, t0.evenement_id AS evenement_id_11 FROM selection t0 WHERE t0.config_id = ?
Parameters:
[
  2
]
5 0.83 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_simple AS is_simple_3, t0.genre AS genre_4 FROM epreuve t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.63 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_simple AS is_simple_3, t0.genre AS genre_4 FROM epreuve t0 WHERE t0.id = ?
Parameters:
[
  4
]
7 0.76 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 1.07 ms
SELECT t0.id AS id_1, t0.stripe_session_id AS stripe_session_id_2, t0.stripe_payment_intent_id AS stripe_payment_intent_id_3, t0.montant_total AS montant_total_4, t0.montant_epreuves AS montant_epreuves_5, t0.montant_repas AS montant_repas_6, t0.nb_repas AS nb_repas_7, t0.code_promo AS code_promo_8, t0.montant_reduction AS montant_reduction_9, t0.date_paiement AS date_paiement_10, t0.status AS status_11, t0.metadata AS metadata_12, t0.user_id AS user_id_13, t0.evenement_id AS evenement_id_14 FROM payment t0 WHERE t0.user_id = ? AND t0.evenement_id = ? AND t0.status = ?
Parameters:
[
  5748
  2
  "completed"
]
9 1.12 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.homologuer_fft AS homologuer_fft_3 FROM niveau t0 WHERE t0.id = ?
Parameters:
[
  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 2
App\Entity\Epreuve 2
App\Entity\User 1
App\Entity\Evenement 1
App\Entity\Config 1
App\Entity\Style 1
App\Entity\Age 1
App\Entity\Niveau 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
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\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
  • 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\Epreuve No errors.
App\Entity\Age No errors.
App\Entity\Forme No errors.