Symfony Profiler

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

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 = 18 AND g0_.heure_debut >= '2026-04-12 00:00:00' AND g0_.heure_debut <= '2026-04-12 23:59:59' ORDER BY g0_.heure_debut ASC;

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

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 = 207 ORDER BY t0.ordre ASC;

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 = ?

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 = 18;

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 = ?

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 = 18;

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 = ?

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 = 'valide';

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 = ?

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 = 18;

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 = ?

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 = 18;

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 = ?

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 = 18;

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

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;