Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.ordre_circuit AS ordre_circuit_1,
  e0_.is_master_final AS is_master_final_2,
  e0_.sur_invitation AS sur_invitation_3,
  e0_.points_assiduite AS points_assiduite_4,
  e0_.titre AS titre_5,
  e0_.description AS description_6,
  e0_.creation AS creation_7,
  e0_.termine AS termine_8,
  e0_.date_creation AS date_creation_9,
  e0_.encours AS encours_10,
  e0_.publier AS publier_11,
  e0_.inscriptions_ouvertes AS inscriptions_ouvertes_12,
  e0_.homologuer_fft AS homologuer_fft_13,
  e0_.demander_id_dupr AS demander_id_dupr_14,
  e0_.require_dupr_plus AS require_dupr_plus_15,
  e0_.require_dupr_verified AS require_dupr_verified_16,
  e0_.inscription_privee AS inscription_privee_17,
  e0_.code_pin_inscription AS code_pin_inscription_18,
  e0_.etat_actuel AS etat_actuel_19,
  e0_.commission_plateforme AS commission_plateforme_20,
  c1_.id AS id_21,
  c1_.date_debut AS date_debut_22,
  c1_.fin_inscription AS fin_inscription_23,
  c1_.nb_joueur AS nb_joueur_24,
  c1_.date_fin AS date_fin_25,
  c1_.adresse AS adresse_26,
  c1_.complement AS complement_27,
  c1_.cp AS cp_28,
  c1_.ville AS ville_29,
  c1_.pays AS pays_30,
  c1_.map AS map_31,
  c1_.nb_joueur_max AS nb_joueur_max_32,
  c1_.nb_equipe_max AS nb_equipe_max_33,
  c1_.terrain_interieur AS terrain_interieur_34,
  c1_.terrain_exterieur AS terrain_exterieur_35,
  c1_.type_balle AS type_balle_36,
  c1_.nb_joueur_par_equipe AS nb_joueur_par_equipe_37,
  c1_.montant_repas AS montant_repas_38,
  c1_.devise AS devise_39,
  c1_.nb_journee_previsionnel AS nb_journee_previsionnel_40,
  c1_.prizepool AS prizepool_41,
  c1_.nb_match_par_rencontre AS nb_match_par_rencontre_42,
  c1_.datas_victoire AS datas_victoire_43,
  c1_.points_victoire AS points_victoire_44,
  c1_.points_defaite AS points_defaite_45,
  c1_.points_nul AS points_nul_46,
  c1_.categorie AS categorie_47,
  e2_.id AS id_48,
  e2_.ordre_circuit AS ordre_circuit_49,
  e2_.is_master_final AS is_master_final_50,
  e2_.sur_invitation AS sur_invitation_51,
  e2_.points_assiduite AS points_assiduite_52,
  e2_.titre AS titre_53,
  e2_.description AS description_54,
  e2_.creation AS creation_55,
  e2_.termine AS termine_56,
  e2_.date_creation AS date_creation_57,
  e2_.encours AS encours_58,
  e2_.publier AS publier_59,
  e2_.inscriptions_ouvertes AS inscriptions_ouvertes_60,
  e2_.homologuer_fft AS homologuer_fft_61,
  e2_.demander_id_dupr AS demander_id_dupr_62,
  e2_.require_dupr_plus AS require_dupr_plus_63,
  e2_.require_dupr_verified AS require_dupr_verified_64,
  e2_.inscription_privee AS inscription_privee_65,
  e2_.code_pin_inscription AS code_pin_inscription_66,
  e2_.etat_actuel AS etat_actuel_67,
  e2_.commission_plateforme AS commission_plateforme_68,
  c3_.id AS id_69,
  c3_.date_debut AS date_debut_70,
  c3_.fin_inscription AS fin_inscription_71,
  c3_.nb_joueur AS nb_joueur_72,
  c3_.date_fin AS date_fin_73,
  c3_.adresse AS adresse_74,
  c3_.complement AS complement_75,
  c3_.cp AS cp_76,
  c3_.ville AS ville_77,
  c3_.pays AS pays_78,
  c3_.map AS map_79,
  c3_.nb_joueur_max AS nb_joueur_max_80,
  c3_.nb_equipe_max AS nb_equipe_max_81,
  c3_.terrain_interieur AS terrain_interieur_82,
  c3_.terrain_exterieur AS terrain_exterieur_83,
  c3_.type_balle AS type_balle_84,
  c3_.nb_joueur_par_equipe AS nb_joueur_par_equipe_85,
  c3_.montant_repas AS montant_repas_86,
  c3_.devise AS devise_87,
  c3_.nb_journee_previsionnel AS nb_journee_previsionnel_88,
  c3_.prizepool AS prizepool_89,
  c3_.nb_match_par_rencontre AS nb_match_par_rencontre_90,
  c3_.datas_victoire AS datas_victoire_91,
  c3_.points_victoire AS points_victoire_92,
  c3_.points_defaite AS points_defaite_93,
  c3_.points_nul AS points_nul_94,
  c3_.categorie AS categorie_95,
  e0_.config_id AS config_id_96,
  e0_.organisateur_id AS organisateur_id_97,
  e0_.style_id AS style_id_98,
  e0_.circuit_id AS circuit_id_99,
  e2_.config_id AS config_id_100,
  e2_.organisateur_id AS organisateur_id_101,
  e2_.style_id AS style_id_102,
  e2_.circuit_id AS circuit_id_103
FROM
  evenement e0_
  LEFT JOIN config c1_ ON e0_.config_id = c1_.id
  LEFT JOIN evenement e2_ ON e0_.id = e2_.circuit_id
  LEFT JOIN config c3_ ON e2_.config_id = c3_.id
WHERE
  e0_.id = ?
ORDER BY
  e2_.ordre_circuit ASC

SELECT e0_.id AS id_0, e0_.ordre_circuit AS ordre_circuit_1, e0_.is_master_final AS is_master_final_2, e0_.sur_invitation AS sur_invitation_3, e0_.points_assiduite AS points_assiduite_4, e0_.titre AS titre_5, e0_.description AS description_6, e0_.creation AS creation_7, e0_.termine AS termine_8, e0_.date_creation AS date_creation_9, e0_.encours AS encours_10, e0_.publier AS publier_11, e0_.inscriptions_ouvertes AS inscriptions_ouvertes_12, e0_.homologuer_fft AS homologuer_fft_13, e0_.demander_id_dupr AS demander_id_dupr_14, e0_.require_dupr_plus AS require_dupr_plus_15, e0_.require_dupr_verified AS require_dupr_verified_16, e0_.inscription_privee AS inscription_privee_17, e0_.code_pin_inscription AS code_pin_inscription_18, e0_.etat_actuel AS etat_actuel_19, e0_.commission_plateforme AS commission_plateforme_20, c1_.id AS id_21, c1_.date_debut AS date_debut_22, c1_.fin_inscription AS fin_inscription_23, c1_.nb_joueur AS nb_joueur_24, c1_.date_fin AS date_fin_25, c1_.adresse AS adresse_26, c1_.complement AS complement_27, c1_.cp AS cp_28, c1_.ville AS ville_29, c1_.pays AS pays_30, c1_.map AS map_31, c1_.nb_joueur_max AS nb_joueur_max_32, c1_.nb_equipe_max AS nb_equipe_max_33, c1_.terrain_interieur AS terrain_interieur_34, c1_.terrain_exterieur AS terrain_exterieur_35, c1_.type_balle AS type_balle_36, c1_.nb_joueur_par_equipe AS nb_joueur_par_equipe_37, c1_.montant_repas AS montant_repas_38, c1_.devise AS devise_39, c1_.nb_journee_previsionnel AS nb_journee_previsionnel_40, c1_.prizepool AS prizepool_41, c1_.nb_match_par_rencontre AS nb_match_par_rencontre_42, c1_.datas_victoire AS datas_victoire_43, c1_.points_victoire AS points_victoire_44, c1_.points_defaite AS points_defaite_45, c1_.points_nul AS points_nul_46, c1_.categorie AS categorie_47, e2_.id AS id_48, e2_.ordre_circuit AS ordre_circuit_49, e2_.is_master_final AS is_master_final_50, e2_.sur_invitation AS sur_invitation_51, e2_.points_assiduite AS points_assiduite_52, e2_.titre AS titre_53, e2_.description AS description_54, e2_.creation AS creation_55, e2_.termine AS termine_56, e2_.date_creation AS date_creation_57, e2_.encours AS encours_58, e2_.publier AS publier_59, e2_.inscriptions_ouvertes AS inscriptions_ouvertes_60, e2_.homologuer_fft AS homologuer_fft_61, e2_.demander_id_dupr AS demander_id_dupr_62, e2_.require_dupr_plus AS require_dupr_plus_63, e2_.require_dupr_verified AS require_dupr_verified_64, e2_.inscription_privee AS inscription_privee_65, e2_.code_pin_inscription AS code_pin_inscription_66, e2_.etat_actuel AS etat_actuel_67, e2_.commission_plateforme AS commission_plateforme_68, c3_.id AS id_69, c3_.date_debut AS date_debut_70, c3_.fin_inscription AS fin_inscription_71, c3_.nb_joueur AS nb_joueur_72, c3_.date_fin AS date_fin_73, c3_.adresse AS adresse_74, c3_.complement AS complement_75, c3_.cp AS cp_76, c3_.ville AS ville_77, c3_.pays AS pays_78, c3_.map AS map_79, c3_.nb_joueur_max AS nb_joueur_max_80, c3_.nb_equipe_max AS nb_equipe_max_81, c3_.terrain_interieur AS terrain_interieur_82, c3_.terrain_exterieur AS terrain_exterieur_83, c3_.type_balle AS type_balle_84, c3_.nb_joueur_par_equipe AS nb_joueur_par_equipe_85, c3_.montant_repas AS montant_repas_86, c3_.devise AS devise_87, c3_.nb_journee_previsionnel AS nb_journee_previsionnel_88, c3_.prizepool AS prizepool_89, c3_.nb_match_par_rencontre AS nb_match_par_rencontre_90, c3_.datas_victoire AS datas_victoire_91, c3_.points_victoire AS points_victoire_92, c3_.points_defaite AS points_defaite_93, c3_.points_nul AS points_nul_94, c3_.categorie AS categorie_95, e0_.config_id AS config_id_96, e0_.organisateur_id AS organisateur_id_97, e0_.style_id AS style_id_98, e0_.circuit_id AS circuit_id_99, e2_.config_id AS config_id_100, e2_.organisateur_id AS organisateur_id_101, e2_.style_id AS style_id_102, e2_.circuit_id AS circuit_id_103 FROM evenement e0_ LEFT JOIN config c1_ ON e0_.config_id = c1_.id LEFT JOIN evenement e2_ ON e0_.id = e2_.circuit_id LEFT JOIN config c3_ ON e2_.config_id = c3_.id WHERE e0_.id = 22 ORDER BY e2_.ordre_circuit ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  style t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM style t0 WHERE t0.id = 16;

SELECT
  c0_.id AS id_0,
  c0_.points_total AS points_total_1,
  c0_.points_resultats AS points_resultats_2,
  c0_.bonus_fidelite AS bonus_fidelite_3,
  c0_.tournois_participes AS tournois_participes_4,
  c0_.rang AS rang_5,
  c0_.detail_tournois AS detail_tournois_6,
  c0_.date_modification AS date_modification_7,
  c0_.circuit_id AS circuit_id_8,
  c0_.user_id AS user_id_9
FROM
  circuit_classement c0_
WHERE
  c0_.circuit_id = ?
ORDER BY
  c0_.points_total DESC,
  c0_.points_resultats DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.points_total AS points_total_1, c0_.points_resultats AS points_resultats_2, c0_.bonus_fidelite AS bonus_fidelite_3, c0_.tournois_participes AS tournois_participes_4, c0_.rang AS rang_5, c0_.detail_tournois AS detail_tournois_6, c0_.date_modification AS date_modification_7, c0_.circuit_id AS circuit_id_8, c0_.user_id AS user_id_9 FROM circuit_classement c0_ WHERE c0_.circuit_id = 22 ORDER BY c0_.points_total DESC, c0_.points_resultats DESC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.rang AS rang_1,
  c0_.points AS points_2,
  n1_.id AS id_3,
  n1_.nom AS nom_4,
  n1_.homologuer_fft AS homologuer_fft_5,
  c0_.circuit_id AS circuit_id_6,
  c0_.niveau_id AS niveau_id_7,
  c0_.epreuve_id AS epreuve_id_8,
  c0_.age_id AS age_id_9
FROM
  circuit_points_config c0_
  LEFT JOIN niveau n1_ ON c0_.niveau_id = n1_.id
WHERE
  c0_.circuit_id = ?
ORDER BY
  n1_.nom DESC,
  c0_.rang ASC

SELECT c0_.id AS id_0, c0_.rang AS rang_1, c0_.points AS points_2, n1_.id AS id_3, n1_.nom AS nom_4, n1_.homologuer_fft AS homologuer_fft_5, c0_.circuit_id AS circuit_id_6, c0_.niveau_id AS niveau_id_7, c0_.epreuve_id AS epreuve_id_8, c0_.age_id AS age_id_9 FROM circuit_points_config c0_ LEFT JOIN niveau n1_ ON c0_.niveau_id = n1_.id WHERE c0_.circuit_id = 22 ORDER BY n1_.nom DESC, c0_.rang ASC;

SELECT
  t0.id AS id_1,
  t0.information_id AS information_id_2,
  t0.evenement_id AS evenement_id_3
FROM
  evenement_information t0
WHERE
  t0.evenement_id = ?

SELECT t0.id AS id_1, t0.information_id AS information_id_2, t0.evenement_id AS evenement_id_3 FROM evenement_information t0 WHERE t0.evenement_id = 22;

SELECT
  t0.id AS id_1,
  t0.licence AS licence_2,
  t0.email AS email_3,
  t0.telephone AS telephone_4,
  t0.fonction AS fonction_5,
  t0.afficher_email AS afficher_email_6,
  t0.afficher_telephone AS afficher_telephone_7
FROM
  contact t0
  INNER JOIN contact_config ON t0.id = contact_config.contact_id
WHERE
  contact_config.config_id = ?

SELECT t0.id AS id_1, t0.licence AS licence_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.fonction AS fonction_5, t0.afficher_email AS afficher_email_6, t0.afficher_telephone AS afficher_telephone_7 FROM contact t0 INNER JOIN contact_config ON t0.id = contact_config.contact_id WHERE contact_config.config_id = 22;

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