Symfony Profiler

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

SELECT
  COALESCE(
    SUM(
      CASE WHEN ep.is_simple = 1 THEN
        1
      ELSE
        0.5
      END
    ),
    0
  ) as total_teams
FROM
  user_selection us
  JOIN selection s ON us.selection_id = s.id
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
  JOIN epreuve ep ON s.id_epreuve_id = ep.id
WHERE
  us.paye = 1
  AND e.id = ?

SELECT COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = 28
        ;

SELECT
  DISTINCT 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,
  e0_.config_id AS config_id_21,
  e0_.organisateur_id AS organisateur_id_22,
  e0_.style_id AS style_id_23,
  e0_.circuit_id AS circuit_id_24
FROM
  evenement e0_
  INNER JOIN config c1_ ON e0_.config_id = c1_.id
  INNER JOIN style s2_ ON e0_.style_id = s2_.id
  LEFT JOIN selection s3_ ON c1_.id = s3_.config_id
WHERE
  e0_.publier = ?
  AND s2_.nom <> ?

SELECT DISTINCT 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, e0_.config_id AS config_id_21, e0_.organisateur_id AS organisateur_id_22, e0_.style_id AS style_id_23, e0_.circuit_id AS circuit_id_24 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s2_ ON e0_.style_id = s2_.id LEFT JOIN selection s3_ ON c1_.id = s3_.config_id WHERE e0_.publier = 1 AND s2_.nom <> 'Circuit';

SELECT
  s.jour,
  COALESCE(
    SUM(
      CASE WHEN ep.is_simple = 1 THEN
        1
      ELSE
        0.5
      END
    ),
    0
  ) as total_teams
FROM
  user_selection us
  JOIN selection s ON us.selection_id = s.id
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
  JOIN epreuve ep ON s.id_epreuve_id = ep.id
WHERE
  us.paye = 1
  AND e.id = ?
  AND s.jour IS NOT NULL
GROUP BY
  s.jour

SELECT s.jour, COALESCE(SUM(
                CASE WHEN ep.is_simple = 1 THEN 1 ELSE 0.5 END
            ), 0) as total_teams
            FROM user_selection us
            JOIN selection s ON us.selection_id = s.id
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            JOIN epreuve ep ON s.id_epreuve_id = ep.id
            WHERE us.paye = 1
            AND e.id = 28
            AND s.jour IS NOT NULL
            GROUP BY s.jour
        ;

SELECT
  DISTINCT s.jour
FROM
  selection s
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
WHERE
  e.id = ?
  AND s.jour IS NOT NULL
ORDER BY
  s.jour ASC

SELECT DISTINCT s.jour
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = 28
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
        ;

SELECT
  COUNT(DISTINCT s.jour) as nb_jours
FROM
  selection s
  JOIN config c ON s.config_id = c.id
  JOIN evenement e ON e.config_id = c.id
WHERE
  e.id = ?
  AND s.jour IS NOT NULL

SELECT COUNT(DISTINCT s.jour) as nb_jours
            FROM selection s
            JOIN config c ON s.config_id = c.id
            JOIN evenement e ON e.config_id = c.id
            WHERE e.id = 28
            AND s.jour IS NOT NULL
        ;

SELECT
  AVG(a0_.note) AS sclr_0
FROM
  avis a0_
WHERE
  a0_.evenement_id = ?
  AND a0_.statut = ?

SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = 28 AND a0_.statut = 'valide';

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  avis a0_
WHERE
  a0_.evenement_id = ?
  AND a0_.statut = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM avis a0_ WHERE a0_.evenement_id = 28 AND a0_.statut = 'valide';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  age t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0;

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
  LEFT JOIN selection s3_ ON c1_.id = s3_.config_id
WHERE
  e0_.encours = 1
  AND e0_.publier = 1
  AND s2_.nom <> ?

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 LEFT JOIN selection s3_ ON c1_.id = s3_.config_id WHERE e0_.encours = 1 AND e0_.publier = 1 AND s2_.nom <> 'Circuit';

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