GET https://demofft.tournoipickleball.fr/joueur/b2e4bec7-342d-11f1-ae32-fa163e19c1c5

Response
200 OK
IP
216.73.217.2
Profiled on
Token
fcd3be

Query Metrics

43 Database Queries
20 Different statements
42.49 ms Query time
0 Invalid entities
93 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
8.91 ms
(20.96%) 		1 
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE UPPER(TRIM(c0_.nom)) = ? AND UPPER(TRIM(c0_.prenom)) = ? ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters: 
[
  "MARCHAND"
  "JEAN-MARIE"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.21 ms
(9.91%) 		8 
SELECT t0.id AS id_1, t0.date_equipe AS date_equipe_2, t0.nom AS nom_3, t0.selection_id AS selection_id_4 FROM equipe t0 WHERE t0.id = ?
Parameters: 
[
  377
]
View formatted query    View runnable query    Explain query    View query backtrace
3.96 ms
(9.32%) 		3 
SELECT u0_.id AS id_0, u0_.public_id AS public_id_1, u0_.email AS email_2, u0_.pseudo AS pseudo_3, u0_.licence AS licence_4, u0_.id_dupr AS id_dupr_5, u0_.genre AS genre_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_de_naissance AS date_de_naissance_9, u0_.ville AS ville_10, u0_.description AS description_11, u0_.telephone AS telephone_12, u0_.instagram AS instagram_13, u0_.linkedin AS linkedin_14, u0_.tiktok AS tiktok_15, u0_.twitter AS twitter_16, u0_.facebook AS facebook_17, u0_.statut AS statut_18, u0_.roles AS roles_19, u0_.password AS password_20, u0_.indicateur AS indicateur_21, u0_.createur AS createur_22, u0_.stripe_account_id AS stripe_account_id_23, u0_.stripe_onboarding_complete AS stripe_onboarding_complete_24, u0_.stripe_account_created_at AS stripe_account_created_at_25, u0_.stripe_account_type AS stripe_account_type_26, u0_.is_admin AS is_admin_27, u0_.commission_defaut AS commission_defaut_28, u0_.dupr_user_token AS dupr_user_token_29, u0_.dupr_refresh_token AS dupr_refresh_token_30, u0_.dupr_token_expires_at AS dupr_token_expires_at_31, u0_.dupr_sso_connected_at AS dupr_sso_connected_at_32, u0_.dupr_rating_singles AS dupr_rating_singles_33, u0_.dupr_rating_doubles AS dupr_rating_doubles_34, u0_.dupr_ratings_updated_at AS dupr_ratings_updated_at_35, u0_.dupr_basic_entitlement AS dupr_basic_entitlement_36, u0_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_37, u0_.newsletter_consent AS newsletter_consent_38, u0_.newsletter_consent_date AS newsletter_consent_date_39, u0_.traitement_limite AS traitement_limite_40, u0_.traitement_limite_date AS traitement_limite_date_41, u0_.traitement_limite_motif AS traitement_limite_motif_42, u0_.pays_id AS pays_id_43, u0_.niveau_simple_id AS niveau_simple_id_44, u0_.niveau_double_id AS niveau_double_id_45, u0_.niveau_mixte_id AS niveau_mixte_id_46 FROM `user` u0_ WHERE u0_.public_id = ?
Parameters: 
[
  "b2e4bec7-342d-11f1-ae32-fa163e19c1c5"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.64 ms
(8.56%) 		3 
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.inscriptions_ouvertes AS inscriptions_ouvertes_41, t28.homologuer_fft AS homologuer_fft_42, t28.demander_id_dupr AS demander_id_dupr_43, t28.require_dupr_plus AS require_dupr_plus_44, t28.require_dupr_verified AS require_dupr_verified_45, t28.inscription_privee AS inscription_privee_46, t28.code_pin_inscription AS code_pin_inscription_47, t28.etat_actuel AS etat_actuel_48, t28.commission_plateforme AS commission_plateforme_49, t28.config_id AS config_id_50, t28.organisateur_id AS organisateur_id_51, t28.style_id AS style_id_52, t28.circuit_id AS circuit_id_53 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query    View query backtrace
3.08 ms
(7.25%) 		5 
SELECT t0.id AS id_1, t0.equipe_id AS equipe_id_2, t0.user_id AS user_id_3, t0.invitation_id AS invitation_id_4, t0.evenement_id AS evenement_id_5, t0.selection_id AS selection_id_6 FROM equipe_user t0 WHERE t0.equipe_id = ?
Parameters: 
[
  377
]
View formatted query    View runnable query    Explain query    View query backtrace
2.30 ms
(5.40%) 		3 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ordre AS ordre_3, t0.type_playoff AS type_playoff_4, t0.active AS active_5, t0.terminee AS terminee_6, t0.assignment_mode AS assignment_mode_7, t0.size AS size_8, t0.position_min AS position_min_9, t0.position_max AS position_max_10, t0.participants_resolved_at AS participants_resolved_at_11, t0.format_match AS format_match_12, t0.selection_id AS selection_id_13, t0.evenement_id AS evenement_id_14 FROM playoff t0 WHERE t0.selection_id = ?
Parameters: 
[
  85
]
View formatted query    View runnable query    Explain query    View query backtrace
2.14 ms
(5.03%) 		3 
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.ordre AS ordre_2, p0_.type_playoff AS type_playoff_3, p0_.active AS active_4, p0_.terminee AS terminee_5, p0_.assignment_mode AS assignment_mode_6, p0_.size AS size_7, p0_.position_min AS position_min_8, p0_.position_max AS position_max_9, p0_.participants_resolved_at AS participants_resolved_at_10, p0_.format_match AS format_match_11, p0_.selection_id AS selection_id_12, p0_.evenement_id AS evenement_id_13 FROM playoff p0_ WHERE p0_.selection_id = ?
Parameters: 
[
  85
]
View formatted query    View runnable query    Explain query    View query backtrace
1.85 ms
(4.35%) 		2 
SELECT t0.id AS id_1, t0.heure_debut AS heure_debut_2, t0.heure_fin AS heure_fin_3, t0.ordre AS ordre_4, t0.score AS score_5, t0.date_modification AS date_modification_6, t0.commentaire AS commentaire_7, t0.termine AS termine_8, t0.match_precedent1 AS match_precedent1_9, t0.match_precedent2 AS match_precedent2_10, t0.position_match_precedent1 AS position_match_precedent1_11, t0.position_match_precedent2 AS position_match_precedent2_12, t0.round_name AS round_name_13, t0.round_number AS round_number_14, t0.bracket_type AS bracket_type_15, t0.playoff_id AS playoff_id_16, t0.equipe1_id AS equipe1_id_17, t0.equipe2_id AS equipe2_id_18, t0.terrain_id AS terrain_id_19 FROM match_eliminatoire t0 WHERE t0.playoff_id = ? ORDER BY t0.ordre ASC
Parameters: 
[
  54
]
View formatted query    View runnable query    Explain query    View query backtrace
1.42 ms
(3.33%) 		1 
SELECT c0_.id AS id_0, c0_.serie AS serie_1, c0_.rang AS rang_2, c0_.nationalite AS nationalite_3, c0_.nom AS nom_4, c0_.prenom AS prenom_5, c0_.licence AS licence_6, c0_.ligue AS ligue_7, c0_.club AS club_8, c0_.nombre_tournois AS nombre_tournois_9, c0_.total_points AS total_points_10, c0_.equivalence_plus50 AS equivalence_plus50_11, c0_.equivalence_autres AS equivalence_autres_12, c0_.import_id AS import_id_13 FROM classement_fft_joueur c0_ INNER JOIN classement_fft_import c1_ ON c0_.import_id = c1_.id WHERE c0_.licence IN (?, ?, ?, ?) ORDER BY c1_.date_import DESC, c0_.total_points DESC
Parameters: 
[
  "507608X"
  "507608 X"
  "507608x"
  "507608 x"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.40 ms
(3.30%) 		1 
SELECT e0_.id AS id_0, e1_.id AS id_1, e1_.date_equipe AS date_equipe_2, e1_.nom AS nom_3, s2_.id AS id_4, s2_.nom AS nom_5, s2_.prix AS prix_6, s2_.metadata AS metadata_7, s2_.jour AS jour_8, e3_.id AS id_9, e3_.ordre_circuit AS ordre_circuit_10, e3_.is_master_final AS is_master_final_11, e3_.sur_invitation AS sur_invitation_12, e3_.points_assiduite AS points_assiduite_13, e3_.titre AS titre_14, e3_.description AS description_15, e3_.creation AS creation_16, e3_.termine AS termine_17, e3_.date_creation AS date_creation_18, e3_.encours AS encours_19, e3_.publier AS publier_20, e3_.inscriptions_ouvertes AS inscriptions_ouvertes_21, e3_.homologuer_fft AS homologuer_fft_22, e3_.demander_id_dupr AS demander_id_dupr_23, e3_.require_dupr_plus AS require_dupr_plus_24, e3_.require_dupr_verified AS require_dupr_verified_25, e3_.inscription_privee AS inscription_privee_26, e3_.code_pin_inscription AS code_pin_inscription_27, e3_.etat_actuel AS etat_actuel_28, e3_.commission_plateforme AS commission_plateforme_29, e0_.equipe_id AS equipe_id_30, e0_.user_id AS user_id_31, e0_.invitation_id AS invitation_id_32, e0_.evenement_id AS evenement_id_33, e0_.selection_id AS selection_id_34, e1_.selection_id AS selection_id_35, s2_.id_epreuve_id AS id_epreuve_id_36, s2_.id_age_id AS id_age_id_37, s2_.id_niveau_id AS id_niveau_id_38, s2_.id_forme_id AS id_forme_id_39, s2_.config_id AS config_id_40, s2_.evenement_id AS evenement_id_41, e3_.config_id AS config_id_42, e3_.organisateur_id AS organisateur_id_43, e3_.style_id AS style_id_44, e3_.circuit_id AS circuit_id_45 FROM equipe_user e0_ INNER JOIN equipe e1_ ON e0_.equipe_id = e1_.id LEFT JOIN selection s2_ ON e1_.selection_id = s2_.id LEFT JOIN evenement e3_ ON s2_.evenement_id = e3_.id WHERE e0_.user_id = ?
Parameters: 
[
  5895
]
View formatted query    View runnable query    Explain query    View query backtrace
1.33 ms
(3.12%) 		1 
SELECT e0_.id AS id_0, u1_.id AS id_1, u1_.public_id AS public_id_2, u1_.email AS email_3, u1_.pseudo AS pseudo_4, u1_.licence AS licence_5, u1_.id_dupr AS id_dupr_6, u1_.genre AS genre_7, u1_.nom AS nom_8, u1_.prenom AS prenom_9, u1_.date_de_naissance AS date_de_naissance_10, u1_.ville AS ville_11, u1_.description AS description_12, u1_.telephone AS telephone_13, u1_.instagram AS instagram_14, u1_.linkedin AS linkedin_15, u1_.tiktok AS tiktok_16, u1_.twitter AS twitter_17, u1_.facebook AS facebook_18, u1_.statut AS statut_19, u1_.roles AS roles_20, u1_.password AS password_21, u1_.indicateur AS indicateur_22, u1_.createur AS createur_23, u1_.stripe_account_id AS stripe_account_id_24, u1_.stripe_onboarding_complete AS stripe_onboarding_complete_25, u1_.stripe_account_created_at AS stripe_account_created_at_26, u1_.stripe_account_type AS stripe_account_type_27, u1_.is_admin AS is_admin_28, u1_.commission_defaut AS commission_defaut_29, u1_.dupr_user_token AS dupr_user_token_30, u1_.dupr_refresh_token AS dupr_refresh_token_31, u1_.dupr_token_expires_at AS dupr_token_expires_at_32, u1_.dupr_sso_connected_at AS dupr_sso_connected_at_33, u1_.dupr_rating_singles AS dupr_rating_singles_34, u1_.dupr_rating_doubles AS dupr_rating_doubles_35, u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_36, u1_.dupr_basic_entitlement AS dupr_basic_entitlement_37, u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_38, u1_.newsletter_consent AS newsletter_consent_39, u1_.newsletter_consent_date AS newsletter_consent_date_40, u1_.traitement_limite AS traitement_limite_41, u1_.traitement_limite_date AS traitement_limite_date_42, u1_.traitement_limite_motif AS traitement_limite_motif_43, e0_.equipe_id AS equipe_id_44, e0_.user_id AS user_id_45, e0_.invitation_id AS invitation_id_46, e0_.evenement_id AS evenement_id_47, e0_.selection_id AS selection_id_48, u1_.pays_id AS pays_id_49, u1_.niveau_simple_id AS niveau_simple_id_50, u1_.niveau_double_id AS niveau_double_id_51, u1_.niveau_mixte_id AS niveau_mixte_id_52 FROM equipe_user e0_ INNER JOIN `user` u1_ ON e0_.user_id = u1_.id WHERE e0_.equipe_id IN (?, ?, ?)
Parameters: 
[
  4
  330
  379
]
View formatted query    View runnable query    Explain query    View query backtrace
1.24 ms
(2.91%) 		2 
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.score_equipe1 AS score_equipe1_3, t0.score_equipe2 AS score_equipe2_4, t0.match_eliminatoire_id AS match_eliminatoire_id_5 FROM set_eliminatoire t0 WHERE t0.match_eliminatoire_id = ? ORDER BY t0.numero ASC
Parameters: 
[
  543
]
View formatted query    View runnable query    Explain query    View query backtrace
1.19 ms
(2.80%) 		2 
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.date_import AS date_import_3, t0.nom_fichier AS nom_fichier_4, t0.chemin_fichier AS chemin_fichier_5, t0.nombre_joueurs AS nombre_joueurs_6, t0.erreurs AS erreurs_7 FROM classement_fft_import t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
1.15 ms
(2.71%) 		2 
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: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
1.09 ms
(2.57%) 		1 
SELECT g0_.id AS id_0, g0_.heure_debut AS heure_debut_1, g0_.heure_fin AS heure_fin_2, g0_.ordre AS ordre_3, g0_.position_terrain AS position_terrain_4, g0_.modifie_manuellement AS modifie_manuellement_5, g0_.date_modification AS date_modification_6, g0_.score AS score_7, g0_.commentaire AS commentaire_8, g0_.poule_id AS poule_id_9, g0_.terrain_id AS terrain_id_10, g0_.equipe1_id AS equipe1_id_11, g0_.equipe2_id AS equipe2_id_12, g0_.etat_id AS etat_id_13, g0_.evenement_id AS evenement_id_14, g0_.selection_id AS selection_id_15 FROM game_match g0_ WHERE (g0_.equipe1_id IN (?, ?, ?) OR g0_.equipe2_id IN (?, ?, ?)) AND g0_.score IS NOT NULL AND g0_.score <> '' ORDER BY g0_.heure_debut ASC
Parameters: 
[
  4
  330
  379
  4
  330
  379
]
View formatted query    View runnable query    Explain query    View query backtrace
0.93 ms
(2.18%) 		1 
SELECT m0_.id AS id_0, m0_.heure_debut AS heure_debut_1, m0_.heure_fin AS heure_fin_2, m0_.ordre AS ordre_3, m0_.score AS score_4, m0_.date_modification AS date_modification_5, m0_.commentaire AS commentaire_6, m0_.termine AS termine_7, m0_.match_precedent1 AS match_precedent1_8, m0_.match_precedent2 AS match_precedent2_9, m0_.position_match_precedent1 AS position_match_precedent1_10, m0_.position_match_precedent2 AS position_match_precedent2_11, m0_.round_name AS round_name_12, m0_.round_number AS round_number_13, m0_.bracket_type AS bracket_type_14, m0_.playoff_id AS playoff_id_15, m0_.equipe1_id AS equipe1_id_16, m0_.equipe2_id AS equipe2_id_17, m0_.terrain_id AS terrain_id_18 FROM match_eliminatoire m0_ WHERE (m0_.equipe1_id IN (?, ?, ?) OR m0_.equipe2_id IN (?, ?, ?)) AND m0_.score IS NOT NULL AND m0_.score <> '' ORDER BY m0_.heure_debut ASC
Parameters: 
[
  4
  330
  379
  4
  330
  379
]
View formatted query    View runnable query    Explain query    View query backtrace
0.90 ms
(2.12%) 		1 
SELECT COUNT(a0_.id) AS sclr_0, AVG(a0_.note_plateforme) AS sclr_1, SUM(CASE WHEN a0_.note_plateforme >= 4 THEN 1 ELSE 0 END) AS sclr_2 FROM avis a0_ WHERE a0_.note_plateforme IS NOT NULL AND a0_.statut_plateforme = ?
Parameters: 
[
  "valide"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(1.46%) 		1 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.40%) 		1 
SELECT COUNT(e0_.id) AS sclr_0 FROM equipe e0_ WHERE e0_.selection_id = ?
Parameters: 
[
  204
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.33%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

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\User 14
App\Entity\EquipeUser 14
App\Entity\Equipe 11
App\Entity\GameMatch 11
App\Entity\Terrain 9
App\Entity\MatchEliminatoire 9
App\Entity\Evenement 3
App\Entity\Selection 3
App\Entity\Config 3
App\Entity\Etat 3
App\Entity\Niveau 2
App\Entity\ClassementFftJoueur 2
App\Entity\ClassementFftImport 2
App\Entity\Poule 2
App\Entity\Playoff 2
App\Entity\Epreuve 1
App\Entity\Age 1
App\Entity\Style 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Pays No errors.
App\Entity\Niveau No errors.
App\Entity\UserSelection No errors.
App\Entity\Payment No errors.
App\Entity\ClassementFftJoueur No errors.
App\Entity\ClassementFftImport No errors.
App\Entity\EquipeUser No errors.
App\Entity\Equipe No errors.
App\Entity\Selection No errors.
App\Entity\Evenement No errors.
App\Entity\Invitation No errors.
App\Entity\Epreuve No errors.
App\Entity\Age No errors.
App\Entity\Forme No errors.
App\Entity\Config No errors.
App\Entity\Style No errors.
App\Entity\Playoff No errors.
App\Entity\Photo No errors.
App\Entity\EvenementInformation No errors.
App\Entity\Avis No errors.
App\Entity\GameMatch No errors.
App\Entity\Poule No errors.
App\Entity\Terrain No errors.
App\Entity\Etat No errors.
App\Entity\MatchEliminatoire No errors.
App\Entity\SetEliminatoire No errors.
App\Entity\Promo No errors.
App\Entity\Contact No errors.
App\Entity\PlayoffParticipant No errors.