Query Metrics
73
Database Queries
5
Different statements
70.68 ms
Query time
0
Invalid entities
178
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
44.66 ms (63.19%) |
47 |
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.stripe_account_id AS stripe_account_id_23, t0.stripe_onboarding_complete AS stripe_onboarding_complete_24, t0.stripe_account_created_at AS stripe_account_created_at_25, t0.is_admin AS is_admin_26, t0.commission_defaut AS commission_defaut_27, t0.newsletter_consent AS newsletter_consent_28, t0.newsletter_consent_date AS newsletter_consent_date_29, t0.pays_id AS pays_id_30, t0.niveau_simple_id AS niveau_simple_id_31, t0.niveau_double_id AS niveau_double_id_32, t0.niveau_mixte_id AS niveau_mixte_id_33 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
6534
]
|
||||||||||||||||||||||||||||||||||
|
17.24 ms (24.39%) |
23 |
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:
[
375
]
|
||||||||||||||||||||||||||||||||||
|
4.64 ms (6.56%) |
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, p1_.id AS id_9, p1_.nom AS nom_10, p1_.nb_equipe AS nb_equipe_11, p1_.ordre AS ordre_12, p1_.generee AS generee_13, p1_.date_generation AS date_generation_14, s2_.id AS id_15, s2_.nom AS nom_16, s2_.prix AS prix_17, s2_.metadata AS metadata_18, s2_.jour AS jour_19, e3_.id AS id_20, e3_.nom AS nom_21, e3_.is_simple AS is_simple_22, e3_.genre AS genre_23, n4_.id AS id_24, n4_.nom AS nom_25, n4_.homologuer_fft AS homologuer_fft_26, a5_.id AS id_27, a5_.nom AS nom_28, e6_.id AS id_29, e6_.date_equipe AS date_equipe_30, e6_.nom AS nom_31, e7_.id AS id_32, e7_.date_equipe AS date_equipe_33, e7_.nom AS nom_34, t8_.id AS id_35, t8_.nom AS nom_36, e9_.id AS id_37, e9_.nom AS nom_38, g0_.poule_id AS poule_id_39, g0_.terrain_id AS terrain_id_40, g0_.equipe1_id AS equipe1_id_41, g0_.equipe2_id AS equipe2_id_42, g0_.etat_id AS etat_id_43, g0_.evenement_id AS evenement_id_44, g0_.selection_id AS selection_id_45, p1_.selection_id AS selection_id_46, s2_.id_epreuve_id AS id_epreuve_id_47, s2_.id_age_id AS id_age_id_48, s2_.id_niveau_id AS id_niveau_id_49, s2_.id_forme_id AS id_forme_id_50, s2_.config_id AS config_id_51, s2_.evenement_id AS evenement_id_52, e6_.selection_id AS selection_id_53, e7_.selection_id AS selection_id_54 FROM game_match g0_ LEFT JOIN poule p1_ ON g0_.poule_id = p1_.id LEFT JOIN selection s2_ ON p1_.selection_id = s2_.id LEFT JOIN epreuve e3_ ON s2_.id_epreuve_id = e3_.id LEFT JOIN niveau n4_ ON s2_.id_niveau_id = n4_.id LEFT JOIN age a5_ ON s2_.id_age_id = a5_.id LEFT JOIN equipe e6_ ON g0_.equipe1_id = e6_.id LEFT JOIN equipe e7_ ON g0_.equipe2_id = e7_.id LEFT JOIN terrain t8_ ON g0_.terrain_id = t8_.id LEFT JOIN etat e9_ ON g0_.etat_id = e9_.id WHERE g0_.evenement_id = ? AND t8_.id IN (?, ?, ?, ?) AND (g0_.heure_debut BETWEEN ? AND ?) ORDER BY g0_.heure_debut ASC
Parameters:
[ 16 1 2 3 4 "2026-04-25 00:00:00" "2026-04-25 23:59:59" ]
|
||||||||||||||||||||||||||||||||||
|
2.99 ms (4.23%) |
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, p1_.id AS id_15, p1_.nom AS nom_16, p1_.ordre AS ordre_17, p1_.type_playoff AS type_playoff_18, p1_.active AS active_19, p1_.terminee AS terminee_20, p1_.assignment_mode AS assignment_mode_21, p1_.size AS size_22, p1_.position_min AS position_min_23, p1_.position_max AS position_max_24, p1_.participants_resolved_at AS participants_resolved_at_25, p1_.format_match AS format_match_26, s2_.id AS id_27, s2_.nom AS nom_28, s2_.prix AS prix_29, s2_.metadata AS metadata_30, s2_.jour AS jour_31, e3_.id AS id_32, e3_.nom AS nom_33, e3_.is_simple AS is_simple_34, e3_.genre AS genre_35, n4_.id AS id_36, n4_.nom AS nom_37, n4_.homologuer_fft AS homologuer_fft_38, a5_.id AS id_39, a5_.nom AS nom_40, e6_.id AS id_41, e6_.date_equipe AS date_equipe_42, e6_.nom AS nom_43, e7_.id AS id_44, e7_.date_equipe AS date_equipe_45, e7_.nom AS nom_46, t8_.id AS id_47, t8_.nom AS nom_48, m0_.playoff_id AS playoff_id_49, m0_.equipe1_id AS equipe1_id_50, m0_.equipe2_id AS equipe2_id_51, m0_.terrain_id AS terrain_id_52, p1_.selection_id AS selection_id_53, p1_.evenement_id AS evenement_id_54, s2_.id_epreuve_id AS id_epreuve_id_55, s2_.id_age_id AS id_age_id_56, s2_.id_niveau_id AS id_niveau_id_57, s2_.id_forme_id AS id_forme_id_58, s2_.config_id AS config_id_59, s2_.evenement_id AS evenement_id_60, e6_.selection_id AS selection_id_61, e7_.selection_id AS selection_id_62 FROM match_eliminatoire m0_ LEFT JOIN playoff p1_ ON m0_.playoff_id = p1_.id LEFT JOIN selection s2_ ON p1_.selection_id = s2_.id LEFT JOIN epreuve e3_ ON s2_.id_epreuve_id = e3_.id LEFT JOIN niveau n4_ ON s2_.id_niveau_id = n4_.id LEFT JOIN age a5_ ON s2_.id_age_id = a5_.id LEFT JOIN equipe e6_ ON m0_.equipe1_id = e6_.id LEFT JOIN equipe e7_ ON m0_.equipe2_id = e7_.id LEFT JOIN terrain t8_ ON m0_.terrain_id = t8_.id WHERE p1_.evenement_id = ? AND t8_.id IN (?, ?, ?, ?) AND (m0_.heure_debut BETWEEN ? AND ?) ORDER BY m0_.heure_debut ASC
Parameters:
[ 16 1 2 3 4 "2026-04-25 00:00:00" "2026-04-25 23:59:59" ]
|
||||||||||||||||||||||||||||||||||
|
1.16 ms (1.64%) |
1 |
SELECT t0.id AS id_1, t0.token AS token_2, t0.nom_superviseur AS nom_superviseur_3, t0.pin_hash AS pin_hash_4, t0.created_at AS created_at_5, t0.expires_at AS expires_at_6, t0.enabled AS enabled_7, t0.last_used_at AS last_used_at_8, t0.failed_attempts AS failed_attempts_9, t0.locked_until AS locked_until_10, t0.terrain_ids AS terrain_ids_11, t0.selection_ids AS selection_ids_12, t0.jour AS jour_13, t0.evenement_id AS evenement_id_14 FROM superviseur_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"3fd885f70a73e3709f2bee267a92dc1bbe15f164844df2f4d55aab94431d9134"
]
|
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 | 47 |
| App\Entity\EquipeUser | 46 |
| App\Entity\GameMatch | 39 |
| App\Entity\Equipe | 23 |
| App\Entity\Poule | 5 |
| App\Entity\Terrain | 4 |
| App\Entity\Selection | 3 |
| App\Entity\Niveau | 3 |
| App\Entity\Epreuve | 2 |
| App\Entity\Etat | 2 |
| App\Entity\SuperviseurToken | 1 |
| App\Entity\Evenement | 1 |
| App\Entity\Config | 1 |
| App\Entity\Age | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SuperviseurToken | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\SuperviseurLog | No errors. |
| App\Entity\GameMatch | No errors. |
| App\Entity\Poule | No errors. |
| App\Entity\Selection | No errors. |
| App\Entity\Epreuve | No errors. |
| App\Entity\Niveau | No errors. |
| App\Entity\Age | No errors. |
| App\Entity\Equipe | No errors. |
| App\Entity\Terrain | No errors. |
| App\Entity\Etat | No errors. |
| App\Entity\Forme | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\PouleEquipe | No errors. |
| App\Entity\UserSelection | No errors. |
| App\Entity\Playoff | No errors. |
| App\Entity\EquipeUser | No errors. |
| App\Entity\MatchEliminatoire | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Invitation | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Payment | No errors. |