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,
  p2_.id AS id_48,
  p2_.url AS url_49,
  p2_.description AS description_50,
  p2_.created_at AS created_at_51,
  p2_.updated_at AS updated_at_52,
  p2_.nom AS nom_53,
  p2_.extension AS extension_54,
  e0_.config_id AS config_id_55,
  e0_.organisateur_id AS organisateur_id_56,
  e0_.style_id AS style_id_57,
  e0_.circuit_id AS circuit_id_58,
  p2_.evenement_id AS evenement_id_59,
  p2_.joueur_id AS joueur_id_60
FROM
  evenement e0_
  INNER JOIN config c1_ ON e0_.config_id = c1_.id
  INNER JOIN style s3_ ON e0_.style_id = s3_.id
  LEFT JOIN photo p2_ ON e0_.id = p2_.evenement_id
WHERE
  s3_.nom = ?
  AND e0_.publier = ?
ORDER BY
  c1_.date_debut DESC
LIMIT
  6

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, p2_.id AS id_48, p2_.url AS url_49, p2_.description AS description_50, p2_.created_at AS created_at_51, p2_.updated_at AS updated_at_52, p2_.nom AS nom_53, p2_.extension AS extension_54, e0_.config_id AS config_id_55, e0_.organisateur_id AS organisateur_id_56, e0_.style_id AS style_id_57, e0_.circuit_id AS circuit_id_58, p2_.evenement_id AS evenement_id_59, p2_.joueur_id AS joueur_id_60 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s3_ ON e0_.style_id = s3_.id LEFT JOIN photo p2_ ON e0_.id = p2_.evenement_id WHERE s3_.nom = 'Circuit' AND e0_.publier = 1 ORDER BY c1_.date_debut DESC LIMIT 6;

SELECT
  COUNT(DISTINCT e0_.id) AS sclr_0
FROM
  evenement e0_
  INNER JOIN config c1_ ON e0_.config_id = c1_.id
  INNER JOIN style s2_ ON e0_.style_id = s2_.id
WHERE
  s2_.nom = ?
  AND e0_.publier = ?

SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s2_ ON e0_.style_id = s2_.id WHERE s2_.nom = 'Circuit' AND e0_.publier = 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.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.circuit_id = ?
ORDER BY
  t0.ordre_circuit 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.circuit_id = 22 ORDER BY t0.ordre_circuit ASC;

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