Symfony Profiler

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

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 = 11 AND a0_.statut = 'valide' ORDER BY a0_.mis_en_avant DESC, a0_.created_at DESC;

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

SELECT
  a0_.note AS note_0,
  COUNT(a0_.id) AS sclr_1
FROM
  avis a0_
WHERE
  a0_.evenement_id = ?
  AND a0_.statut = ?
GROUP BY
  a0_.note
ORDER BY
  a0_.note DESC

SELECT a0_.note AS note_0, COUNT(a0_.id) AS sclr_1 FROM avis a0_ WHERE a0_.evenement_id = 11 AND a0_.statut = 'valide' GROUP BY a0_.note ORDER BY a0_.note DESC;

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

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