GET https://preprod.tournoipickleball.fr/tournoi/11/tableaux

Query Metrics

48 Database Queries
9 Different statements
34.60 ms Query time
0 Invalid entities
382 Managed entities

Grouped Statements

Show all queries

Time Count Info
9.61 ms
(27.78%)
14
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
]
6.43 ms
(18.59%)
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 = ?
Parameters:
[
  38
]
5.79 ms
(16.75%)
9
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
]
4.27 ms
(12.34%)
6
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
]
3.74 ms
(10.80%)
6
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
]
1.56 ms
(4.52%)
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.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
]
1.23 ms
(3.54%)
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
]
1.01 ms
(2.92%)
1
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
]
0.95 ms
(2.75%)
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.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
]

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.