Query Metrics
48
Database Queries
9
Different statements
34.60 ms
Query time
0
Invalid entities
382
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.01 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.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:
[
6093
]
|
||||||||||||||||||||||||||||||
| 2 | 0.95 ms |
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.homologuer_fft AS homologuer_fft_13, t0.demander_id_dupr AS demander_id_dupr_14, t0.etat_actuel AS etat_actuel_15, t0.commission_plateforme AS commission_plateforme_16, t0.config_id AS config_id_17, t0.organisateur_id AS organisateur_id_18, t0.style_id AS style_id_19, t0.circuit_id AS circuit_id_20 FROM evenement t0 WHERE t0.id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||
| 3 | 1.56 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.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.homologuer_fft AS homologuer_fft_41, t28.demander_id_dupr AS demander_id_dupr_42, t28.etat_actuel AS etat_actuel_43, t28.commission_plateforme AS commission_plateforme_44, t28.config_id AS config_id_45, t28.organisateur_id AS organisateur_id_46, t28.style_id AS style_id_47, t28.circuit_id AS circuit_id_48 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||
| 4 | 1.23 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:
[
11
]
|
||||||||||||||||||||||||||||||
| 5 | 0.94 ms |
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 = ?
Parameters:
[
38
]
|
||||||||||||||||||||||||||||||
| 6 | 1.21 ms |
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
]
|
||||||||||||||||||||||||||||||
| 7 | 1.12 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
38
]
|
||||||||||||||||||||||||||||||
| 8 | 0.98 ms |
SELECT t0.id AS id_1, t0.seed_position AS seed_position_2, t0.source_type AS source_type_3, t0.source_pool_rank AS source_pool_rank_4, t0.best_of_position_rank AS best_of_position_rank_5, t0.resolved_at AS resolved_at_6, t0.manually_assigned AS manually_assigned_7, t0.created_at AS created_at_8, t0.playoff_id AS playoff_id_9, t0.source_poule_id AS source_poule_id_10, t0.equipe_id AS equipe_id_11 FROM playoff_participant t0 WHERE t0.playoff_id = ?
Parameters:
[
30
]
|
||||||||||||||||||||||||||||||
| 9 | 0.83 ms |
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:
[
30
]
|
||||||||||||||||||||||||||||||
| 10 | 0.84 ms |
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 = ?
Parameters:
[
39
]
|
||||||||||||||||||||||||||||||
| 11 | 0.71 ms |
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:
[
86
]
|
||||||||||||||||||||||||||||||
| 12 | 0.70 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
39
]
|
||||||||||||||||||||||||||||||
| 13 | 0.56 ms |
SELECT t0.id AS id_1, t0.seed_position AS seed_position_2, t0.source_type AS source_type_3, t0.source_pool_rank AS source_pool_rank_4, t0.best_of_position_rank AS best_of_position_rank_5, t0.resolved_at AS resolved_at_6, t0.manually_assigned AS manually_assigned_7, t0.created_at AS created_at_8, t0.playoff_id AS playoff_id_9, t0.source_poule_id AS source_poule_id_10, t0.equipe_id AS equipe_id_11 FROM playoff_participant t0 WHERE t0.playoff_id = ?
Parameters:
[
31
]
|
||||||||||||||||||||||||||||||
| 14 | 0.66 ms |
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
]
|
||||||||||||||||||||||||||||||
| 15 | 0.62 ms |
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 = ?
Parameters:
[
40
]
|
||||||||||||||||||||||||||||||
| 16 | 0.95 ms |
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:
[
87
]
|
||||||||||||||||||||||||||||||
| 17 | 0.60 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
40
]
|
||||||||||||||||||||||||||||||
| 18 | 0.56 ms |
SELECT t0.id AS id_1, t0.seed_position AS seed_position_2, t0.source_type AS source_type_3, t0.source_pool_rank AS source_pool_rank_4, t0.best_of_position_rank AS best_of_position_rank_5, t0.resolved_at AS resolved_at_6, t0.manually_assigned AS manually_assigned_7, t0.created_at AS created_at_8, t0.playoff_id AS playoff_id_9, t0.source_poule_id AS source_poule_id_10, t0.equipe_id AS equipe_id_11 FROM playoff_participant t0 WHERE t0.playoff_id = ?
Parameters:
[
32
]
|
||||||||||||||||||||||||||||||
| 19 | 0.69 ms |
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:
[
32
]
|
||||||||||||||||||||||||||||||
| 20 | 0.53 ms |
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 = ?
Parameters:
[
44
]
|
||||||||||||||||||||||||||||||
| 21 | 0.59 ms |
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:
[
88
]
|
||||||||||||||||||||||||||||||
| 22 | 0.56 ms |
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:
[
89
]
|
||||||||||||||||||||||||||||||
| 23 | 0.57 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
44
]
|
||||||||||||||||||||||||||||||
| 24 | 0.57 ms |
SELECT t0.id AS id_1, t0.seed_position AS seed_position_2, t0.source_type AS source_type_3, t0.source_pool_rank AS source_pool_rank_4, t0.best_of_position_rank AS best_of_position_rank_5, t0.resolved_at AS resolved_at_6, t0.manually_assigned AS manually_assigned_7, t0.created_at AS created_at_8, t0.playoff_id AS playoff_id_9, t0.source_poule_id AS source_poule_id_10, t0.equipe_id AS equipe_id_11 FROM playoff_participant t0 WHERE t0.playoff_id = ?
Parameters:
[
35
]
|
||||||||||||||||||||||||||||||
| 25 | 0.76 ms |
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:
[
35
]
|
||||||||||||||||||||||||||||||
| 26 | 0.71 ms |
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 = ?
Parameters:
[
45
]
|
||||||||||||||||||||||||||||||
| 27 | 0.75 ms |
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:
[
90
]
|
||||||||||||||||||||||||||||||
| 28 | 0.78 ms |
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:
[
91
]
|
||||||||||||||||||||||||||||||
| 29 | 0.62 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
45
]
|
||||||||||||||||||||||||||||||
| 30 | 0.60 ms |
SELECT t0.id AS id_1, t0.seed_position AS seed_position_2, t0.source_type AS source_type_3, t0.source_pool_rank AS source_pool_rank_4, t0.best_of_position_rank AS best_of_position_rank_5, t0.resolved_at AS resolved_at_6, t0.manually_assigned AS manually_assigned_7, t0.created_at AS created_at_8, t0.playoff_id AS playoff_id_9, t0.source_poule_id AS source_poule_id_10, t0.equipe_id AS equipe_id_11 FROM playoff_participant t0 WHERE t0.playoff_id = ?
Parameters:
[
36
]
|
||||||||||||||||||||||||||||||
| 31 | 0.77 ms |
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:
[
36
]
|
||||||||||||||||||||||||||||||
| 32 | 0.57 ms |
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 = ?
Parameters:
[
46
]
|
||||||||||||||||||||||||||||||
| 33 | 0.98 ms |
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:
[
92
]
|
||||||||||||||||||||||||||||||
| 34 | 0.59 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
46
]
|
||||||||||||||||||||||||||||||
| 35 | 0.47 ms |
SELECT t0.id AS id_1, t0.seed_position AS seed_position_2, t0.source_type AS source_type_3, t0.source_pool_rank AS source_pool_rank_4, t0.best_of_position_rank AS best_of_position_rank_5, t0.resolved_at AS resolved_at_6, t0.manually_assigned AS manually_assigned_7, t0.created_at AS created_at_8, t0.playoff_id AS playoff_id_9, t0.source_poule_id AS source_poule_id_10, t0.equipe_id AS equipe_id_11 FROM playoff_participant t0 WHERE t0.playoff_id = ?
Parameters:
[
37
]
|
||||||||||||||||||||||||||||||
| 36 | 0.56 ms |
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:
[
37
]
|
||||||||||||||||||||||||||||||
| 37 | 0.51 ms |
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 = ?
Parameters:
[
51
]
|
||||||||||||||||||||||||||||||
| 38 | 0.50 ms |
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:
[
93
]
|
||||||||||||||||||||||||||||||
| 39 | 0.49 ms |
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:
[
94
]
|
||||||||||||||||||||||||||||||
| 40 | 0.49 ms |
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:
[
95
]
|
||||||||||||||||||||||||||||||
| 41 | 0.51 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
51
]
|
||||||||||||||||||||||||||||||
| 42 | 1.26 ms |
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 = ?
Parameters:
[
52
]
|
||||||||||||||||||||||||||||||
| 43 | 0.55 ms |
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:
[
96
]
|
||||||||||||||||||||||||||||||
| 44 | 0.54 ms |
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:
[
97
]
|
||||||||||||||||||||||||||||||
| 45 | 0.53 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
52
]
|
||||||||||||||||||||||||||||||
| 46 | 0.46 ms |
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 = ?
Parameters:
[
54
]
|
||||||||||||||||||||||||||||||
| 47 | 0.52 ms |
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:
[
98
]
|
||||||||||||||||||||||||||||||
| 48 | 0.56 ms |
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 = ? ORDER BY p0_.ordre ASC
Parameters:
[
54
]
|
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\MatchEliminatoire | 78 |
| App\Entity\Equipe | 70 |
| App\Entity\PlayoffParticipant | 42 |
| App\Entity\Poule | 14 |
| App\Entity\Selection | 9 |
| App\Entity\Terrain | 8 |
| App\Entity\Playoff | 6 |
| App\Entity\Epreuve | 3 |
| App\Entity\Niveau | 3 |
| App\Entity\Age | 2 |
| App\Entity\User | 1 |
| App\Entity\Evenement | 1 |
| App\Entity\Config | 1 |
| App\Entity\Style | 1 |
| App\Entity\Etat | 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\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 | No errors. |
| App\Entity\Promo | No errors. |
| App\Entity\Selection | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Epreuve | No errors. |
| App\Entity\Age | No errors. |
| App\Entity\Forme | No errors. |
| App\Entity\Poule | No errors. |
| App\Entity\PouleEquipe | No errors. |
| App\Entity\GameMatch | No errors. |
| App\Entity\Terrain | No errors. |
| App\Entity\Equipe | No errors. |
| App\Entity\Etat | No errors. |
| App\Entity\MatchEliminatoire | No errors. |
| App\Entity\PlayoffParticipant | No errors. |
| App\Entity\SetEliminatoire | No errors. |