Symfony Profiler

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

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

SELECT
  t0.id AS id_1,
  t0.public_id AS public_id_2,
  t0.email AS email_3,
  t0.pseudo AS pseudo_4,
  t0.licence AS licence_5,
  t0.id_dupr AS id_dupr_6,
  t0.genre AS genre_7,
  t0.nom AS nom_8,
  t0.prenom AS prenom_9,
  t0.date_de_naissance AS date_de_naissance_10,
  t0.ville AS ville_11,
  t0.description AS description_12,
  t0.telephone AS telephone_13,
  t0.instagram AS instagram_14,
  t0.linkedin AS linkedin_15,
  t0.tiktok AS tiktok_16,
  t0.twitter AS twitter_17,
  t0.facebook AS facebook_18,
  t0.statut AS statut_19,
  t0.roles AS roles_20,
  t0.password AS password_21,
  t0.indicateur AS indicateur_22,
  t0.createur AS createur_23,
  t0.stripe_account_id AS stripe_account_id_24,
  t0.stripe_onboarding_complete AS stripe_onboarding_complete_25,
  t0.stripe_account_created_at AS stripe_account_created_at_26,
  t0.stripe_account_type AS stripe_account_type_27,
  t0.is_admin AS is_admin_28,
  t0.commission_defaut AS commission_defaut_29,
  t0.dupr_user_token AS dupr_user_token_30,
  t0.dupr_refresh_token AS dupr_refresh_token_31,
  t0.dupr_token_expires_at AS dupr_token_expires_at_32,
  t0.dupr_sso_connected_at AS dupr_sso_connected_at_33,
  t0.dupr_rating_singles AS dupr_rating_singles_34,
  t0.dupr_rating_doubles AS dupr_rating_doubles_35,
  t0.dupr_ratings_updated_at AS dupr_ratings_updated_at_36,
  t0.dupr_basic_entitlement AS dupr_basic_entitlement_37,
  t0.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_38,
  t0.newsletter_consent AS newsletter_consent_39,
  t0.newsletter_consent_date AS newsletter_consent_date_40,
  t0.traitement_limite AS traitement_limite_41,
  t0.traitement_limite_date AS traitement_limite_date_42,
  t0.traitement_limite_motif AS traitement_limite_motif_43,
  t0.pays_id AS pays_id_44,
  t0.niveau_simple_id AS niveau_simple_id_45,
  t0.niveau_double_id AS niveau_double_id_46,
  t0.niveau_mixte_id AS niveau_mixte_id_47
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.public_id AS public_id_2, t0.email AS email_3, t0.pseudo AS pseudo_4, t0.licence AS licence_5, t0.id_dupr AS id_dupr_6, t0.genre AS genre_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.date_de_naissance AS date_de_naissance_10, t0.ville AS ville_11, t0.description AS description_12, t0.telephone AS telephone_13, t0.instagram AS instagram_14, t0.linkedin AS linkedin_15, t0.tiktok AS tiktok_16, t0.twitter AS twitter_17, t0.facebook AS facebook_18, t0.statut AS statut_19, t0.roles AS roles_20, t0.password AS password_21, t0.indicateur AS indicateur_22, t0.createur AS createur_23, t0.stripe_account_id AS stripe_account_id_24, t0.stripe_onboarding_complete AS stripe_onboarding_complete_25, t0.stripe_account_created_at AS stripe_account_created_at_26, t0.stripe_account_type AS stripe_account_type_27, t0.is_admin AS is_admin_28, t0.commission_defaut AS commission_defaut_29, t0.dupr_user_token AS dupr_user_token_30, t0.dupr_refresh_token AS dupr_refresh_token_31, t0.dupr_token_expires_at AS dupr_token_expires_at_32, t0.dupr_sso_connected_at AS dupr_sso_connected_at_33, t0.dupr_rating_singles AS dupr_rating_singles_34, t0.dupr_rating_doubles AS dupr_rating_doubles_35, t0.dupr_ratings_updated_at AS dupr_ratings_updated_at_36, t0.dupr_basic_entitlement AS dupr_basic_entitlement_37, t0.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_38, t0.newsletter_consent AS newsletter_consent_39, t0.newsletter_consent_date AS newsletter_consent_date_40, t0.traitement_limite AS traitement_limite_41, t0.traitement_limite_date AS traitement_limite_date_42, t0.traitement_limite_motif AS traitement_limite_motif_43, t0.pays_id AS pays_id_44, t0.niveau_simple_id AS niveau_simple_id_45, t0.niveau_double_id AS niveau_double_id_46, t0.niveau_mixte_id AS niveau_mixte_id_47 FROM `user` t0 WHERE t0.id = 1;

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

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 = 23 AND a0_.statut = 'valide';

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

SELECT
  a0_.id AS id_0,
  a0_.note AS note_1,
  a0_.commentaire AS commentaire_2,
  a0_.categories AS categories_3,
  a0_.note_plateforme AS note_plateforme_4,
  a0_.commentaire_plateforme AS commentaire_plateforme_5,
  a0_.categories_plateforme AS categories_plateforme_6,
  a0_.consentement_marketing AS consentement_marketing_7,
  a0_.consentement_marketing_date AS consentement_marketing_date_8,
  a0_.statut AS statut_9,
  a0_.statut_plateforme AS statut_plateforme_10,
  a0_.mis_en_avant AS mis_en_avant_11,
  a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12,
  a0_.date_moderation AS date_moderation_13,
  a0_.reponse_organisateur AS reponse_organisateur_14,
  a0_.date_reponse AS date_reponse_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17,
  a0_.auteur_id AS auteur_id_18,
  a0_.evenement_id AS evenement_id_19,
  a0_.modere_par_id AS modere_par_id_20
FROM
  avis a0_
WHERE
  a0_.evenement_id = ?
  AND a0_.statut = ?
ORDER BY
  a0_.mis_en_avant DESC,
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.note AS note_1, a0_.commentaire AS commentaire_2, a0_.categories AS categories_3, a0_.note_plateforme AS note_plateforme_4, a0_.commentaire_plateforme AS commentaire_plateforme_5, a0_.categories_plateforme AS categories_plateforme_6, a0_.consentement_marketing AS consentement_marketing_7, a0_.consentement_marketing_date AS consentement_marketing_date_8, a0_.statut AS statut_9, a0_.statut_plateforme AS statut_plateforme_10, a0_.mis_en_avant AS mis_en_avant_11, a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12, a0_.date_moderation AS date_moderation_13, a0_.reponse_organisateur AS reponse_organisateur_14, a0_.date_reponse AS date_reponse_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.auteur_id AS auteur_id_18, a0_.evenement_id AS evenement_id_19, a0_.modere_par_id AS modere_par_id_20 FROM avis a0_ WHERE a0_.evenement_id = 23 AND a0_.statut = 'valide' ORDER BY a0_.mis_en_avant DESC, a0_.created_at DESC;

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
  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 = 23 AND a0_.statut = 'valide';

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