Query Metrics
532
Database Queries
25
Different statements
329.71 ms
Query time
0
Invalid entities
744
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
88.03 ms (26.70%) |
103 |
SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.email AS email_3, t0.pseudo AS pseudo_4, t0.licence AS licence_5, t0.id_dupr AS id_dupr_6, t0.genre AS genre_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.date_de_naissance AS date_de_naissance_10, t0.ville AS ville_11, t0.description AS description_12, t0.telephone AS telephone_13, t0.instagram AS instagram_14, t0.linkedin AS linkedin_15, t0.tiktok AS tiktok_16, t0.twitter AS twitter_17, t0.facebook AS facebook_18, t0.statut AS statut_19, t0.roles AS roles_20, t0.password AS password_21, t0.indicateur AS indicateur_22, t0.createur AS createur_23, t0.stripe_account_id AS stripe_account_id_24, t0.stripe_onboarding_complete AS stripe_onboarding_complete_25, t0.stripe_account_created_at AS stripe_account_created_at_26, t0.stripe_account_type AS stripe_account_type_27, t0.is_admin AS is_admin_28, t0.commission_defaut AS commission_defaut_29, t0.dupr_user_token AS dupr_user_token_30, t0.dupr_refresh_token AS dupr_refresh_token_31, t0.dupr_token_expires_at AS dupr_token_expires_at_32, t0.dupr_sso_connected_at AS dupr_sso_connected_at_33, t0.dupr_rating_singles AS dupr_rating_singles_34, t0.dupr_rating_doubles AS dupr_rating_doubles_35, t0.dupr_ratings_updated_at AS dupr_ratings_updated_at_36, t0.dupr_basic_entitlement AS dupr_basic_entitlement_37, t0.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_38, t0.newsletter_consent AS newsletter_consent_39, t0.newsletter_consent_date AS newsletter_consent_date_40, t0.traitement_limite AS traitement_limite_41, t0.traitement_limite_date AS traitement_limite_date_42, t0.traitement_limite_motif AS traitement_limite_motif_43, t0.pays_id AS pays_id_44, t0.niveau_simple_id AS niveau_simple_id_45, t0.niveau_double_id AS niveau_double_id_46, t0.niveau_mixte_id AS niveau_mixte_id_47 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
5910
]
|
||||||||||||||||||||||||||||||||||
|
66.80 ms (20.26%) |
131 |
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:
[
312
]
|
||||||||||||||||||||||||||||||||||
|
38.32 ms (11.62%) |
70 |
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:
[
327
]
|
||||||||||||||||||||||||||||||||||
|
32.66 ms (9.91%) |
70 |
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:
[
327
]
|
||||||||||||||||||||||||||||||||||
|
25.00 ms (7.58%) |
42 |
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.position_terrain AS position_terrain_5, t0.modifie_manuellement AS modifie_manuellement_6, t0.date_modification AS date_modification_7, t0.score AS score_8, t0.commentaire AS commentaire_9, t0.poule_id AS poule_id_10, t0.terrain_id AS terrain_id_11, t0.equipe1_id AS equipe1_id_12, t0.equipe2_id AS equipe2_id_13, t0.etat_id AS etat_id_14, t0.evenement_id AS evenement_id_15, t0.selection_id AS selection_id_16 FROM game_match t0 WHERE t0.poule_id = ?
Parameters:
[
85
]
|
||||||||||||||||||||||||||||||||||
|
16.68 ms (5.06%) |
24 |
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 = ? AND g0_.equipe2_id = ?) OR (g0_.equipe1_id = ? AND g0_.equipe2_id = ?)) AND g0_.score IS NOT NULL AND g0_.evenement_id = ?
Parameters:
[ 311 240 240 311 11 ] |
||||||||||||||||||||||||||||||||||
|
8.21 ms (2.49%) |
14 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nb_equipe AS nb_equipe_3, t0.ordre AS ordre_4, t0.generee AS generee_5, t0.date_generation AS date_generation_6, t0.selection_id AS selection_id_7 FROM poule t0 WHERE t0.id = ?
Parameters:
[
85
]
|
||||||||||||||||||||||||||||||||||
|
7.78 ms (2.36%) |
9 |
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:
[
31
]
|
||||||||||||||||||||||||||||||||||
|
7.70 ms (2.33%) |
9 |
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 = ?
Parameters:
[
31
]
|
||||||||||||||||||||||||||||||||||
|
7.05 ms (2.14%) |
14 |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.tete_de_serie AS tete_de_serie_3, t0.date_ajout AS date_ajout_4, t0.poule_id AS poule_id_5, t0.equipe_id AS equipe_id_6 FROM poule_equipe t0 WHERE t0.poule_id = ?
Parameters:
[
85
]
|
||||||||||||||||||||||||||||||||||
|
6.74 ms (2.04%) |
2 |
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_ INNER JOIN poule p1_ ON g0_.poule_id = p1_.id INNER JOIN selection s2_ ON p1_.selection_id = s2_.id WHERE s2_.config_id = ? AND g0_.heure_debut >= ? AND g0_.heure_debut <= ? ORDER BY g0_.heure_debut ASC
Parameters:
[ 11 "2026-03-28 00:00:00" "2026-03-28 23:59:59" ]
|
||||||||||||||||||||||||||||||||||
|
4.84 ms (1.47%) |
9 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nb_equipe AS nb_equipe_3, t0.ordre AS ordre_4, t0.generee AS generee_5, t0.date_generation AS date_generation_6, t0.selection_id AS selection_id_7 FROM poule t0 WHERE t0.selection_id = ? ORDER BY t0.ordre ASC
Parameters:
[
38
]
|
||||||||||||||||||||||||||||||||||
|
4.66 ms (1.41%) |
9 |
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.id = ?
Parameters:
[
38
]
|
||||||||||||||||||||||||||||||||||
|
3.57 ms (1.08%) |
8 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM terrain t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
1.69 ms (0.51%) |
1 |
SELECT t0.id AS id_1, t0.ordre_circuit AS ordre_circuit_2, t0.is_master_final AS is_master_final_3, t0.sur_invitation AS sur_invitation_4, t0.points_assiduite AS points_assiduite_5, t0.titre AS titre_6, t0.description AS description_7, t0.creation AS creation_8, t0.termine AS termine_9, t0.date_creation AS date_creation_10, t0.encours AS encours_11, t0.publier AS publier_12, t0.inscriptions_ouvertes AS inscriptions_ouvertes_13, t0.homologuer_fft AS homologuer_fft_14, t0.demander_id_dupr AS demander_id_dupr_15, t0.require_dupr_plus AS require_dupr_plus_16, t0.require_dupr_verified AS require_dupr_verified_17, t0.inscription_privee AS inscription_privee_18, t0.code_pin_inscription AS code_pin_inscription_19, t0.etat_actuel AS etat_actuel_20, t0.commission_plateforme AS commission_plateforme_21, t0.config_id AS config_id_22, t0.organisateur_id AS organisateur_id_23, t0.style_id AS style_id_24, t0.circuit_id AS circuit_id_25 FROM evenement t0 WHERE t0.id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||||||
|
1.49 ms (0.45%) |
3 |
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:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
1.36 ms (0.41%) |
3 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM etat t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
1.34 ms (0.41%) |
1 |
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:
[
11
]
|
||||||||||||||||||||||||||||||||||
|
1.30 ms (0.39%) |
3 |
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
]
|
||||||||||||||||||||||||||||||||||
|
0.99 ms (0.30%) |
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"
]
|
||||||||||||||||||||||||||||||||||
|
0.92 ms (0.28%) |
2 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
|
0.89 ms (0.27%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.heure_debut AS heure_debut_3, t0.heure_fin AS heure_fin_4, t0.duree_match AS duree_match_5, t0.pause_entre_matchs AS pause_entre_matchs_6, t0.type AS type_7, t0.planning_genere AS planning_genere_8, t0.date_generation AS date_generation_9, t0.evenement_id AS evenement_id_10 FROM planning_config_jour t0 WHERE t0.evenement_id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||||||
|
0.71 ms (0.22%) |
1 |
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.evenement_id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||||||
|
0.57 ms (0.17%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
|
0.42 ms (0.13%) |
1 |
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:
[
11
]
|
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\GameMatch | 142 |
| App\Entity\EquipeUser | 140 |
| App\Entity\MatchEliminatoire | 131 |
| App\Entity\User | 104 |
| App\Entity\Equipe | 70 |
| App\Entity\PouleEquipe | 70 |
| App\Entity\SetEliminatoire | 23 |
| App\Entity\Poule | 14 |
| App\Entity\Selection | 9 |
| App\Entity\Playoff | 9 |
| App\Entity\Terrain | 8 |
| App\Entity\Epreuve | 7 |
| App\Entity\Niveau | 5 |
| App\Entity\PlanningConfigJour | 4 |
| App\Entity\Etat | 3 |
| App\Entity\Age | 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 | No errors. |
| App\Entity\Avis | No errors. |
| App\Entity\Promo | No errors. |
| App\Entity\Selection | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\PlanningConfigJour | No errors. |
| App\Entity\GameMatch | No errors. |
| App\Entity\Poule | No errors. |
| App\Entity\Terrain | No errors. |
| App\Entity\Equipe | No errors. |
| App\Entity\Etat | No errors. |
| App\Entity\PouleEquipe | No errors. |
| App\Entity\EquipeUser | No errors. |
| App\Entity\Invitation | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Niveau | No errors. |
| App\Entity\UserSelection | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Epreuve | No errors. |
| App\Entity\Age | No errors. |
| App\Entity\Forme | No errors. |
| App\Entity\MatchEliminatoire | No errors. |
| App\Entity\PlayoffParticipant | No errors. |
| App\Entity\SetEliminatoire | No errors. |