Symfony Profiler

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

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

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

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 = 11
            AND s.jour IS NOT NULL
            GROUP BY s.jour
        ;

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 = 11
            AND s.jour IS NOT NULL
        ;

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 = 11
            AND s.jour IS NOT NULL
            ORDER BY s.jour ASC
        ;

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_.homologuer_fft AS homologuer_fft_12,
  e0_.demander_id_dupr AS demander_id_dupr_13,
  e0_.etat_actuel AS etat_actuel_14,
  e0_.commission_plateforme AS commission_plateforme_15,
  e0_.config_id AS config_id_16,
  e0_.organisateur_id AS organisateur_id_17,
  e0_.style_id AS style_id_18,
  e0_.circuit_id AS circuit_id_19
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_.homologuer_fft AS homologuer_fft_12, e0_.demander_id_dupr AS demander_id_dupr_13, e0_.etat_actuel AS etat_actuel_14, e0_.commission_plateforme AS commission_plateforme_15, e0_.config_id AS config_id_16, e0_.organisateur_id AS organisateur_id_17, e0_.style_id AS style_id_18, e0_.circuit_id AS circuit_id_19 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
  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.nom AS nom_2
FROM
  age t0

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