Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.identifiant AS identifiant_3,
  t0.adresse AS adresse_4,
  t0.complement AS complement_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.tel AS tel_8,
  t0.email AS email_9,
  t0.fini AS fini_10,
  t0.liste_attente AS liste_attente_11,
  t0.corbeille AS corbeille_12,
  t0.badge_sent AS badge_sent_13,
  t0.commentaire_orga AS commentaire_orga_14,
  t0.paye_le AS paye_le_15,
  t0.paye_par AS paye_par_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.departement_id AS departement_id_19,
  t0.convention_id AS convention_id_20,
  t0.journees_id AS journees_id_21,
  t0.evenement_id AS evenement_id_22,
  t0.tarif_id AS tarif_id_23
FROM
  etablissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.identifiant AS identifiant_3, t0.adresse AS adresse_4, t0.complement AS complement_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.tel AS tel_8, t0.email AS email_9, t0.fini AS fini_10, t0.liste_attente AS liste_attente_11, t0.corbeille AS corbeille_12, t0.badge_sent AS badge_sent_13, t0.commentaire_orga AS commentaire_orga_14, t0.paye_le AS paye_le_15, t0.paye_par AS paye_par_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.departement_id AS departement_id_19, t0.convention_id AS convention_id_20, t0.journees_id AS journees_id_21, t0.evenement_id AS evenement_id_22, t0.tarif_id AS tarif_id_23 FROM etablissement t0 WHERE t0.id = 3960;

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.montant AS montant_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.commentaire AS commentaire_5,
  t0_.min_participant AS min_participant_6,
  t0_.max_participant AS max_participant_7,
  t0_.hide_if_inactif AS hide_if_inactif_8,
  t0_.evenement_id AS evenement_id_9,
  t0_.tarif_parent_id AS tarif_parent_id_10
FROM
  tarif t0_
  INNER JOIN evenement e1_ ON t0_.evenement_id = e1_.id
WHERE
  e1_.id = 22
  AND t0_.tarif_parent_id IS NULL

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.montant AS montant_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.commentaire AS commentaire_5, t0_.min_participant AS min_participant_6, t0_.max_participant AS max_participant_7, t0_.hide_if_inactif AS hide_if_inactif_8, t0_.evenement_id AS evenement_id_9, t0_.tarif_parent_id AS tarif_parent_id_10 FROM tarif t0_ INNER JOIN evenement e1_ ON t0_.evenement_id = e1_.id WHERE e1_.id = 22 AND t0_.tarif_parent_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.complement AS complement_4,
  t0.code_postal AS code_postal_5,
  t0.ville AS ville_6,
  t0.cedex AS cedex_7,
  t0.tel AS tel_8,
  t0.site AS site_9,
  t0.slug AS slug_10,
  t0.email AS email_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  dpo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.complement AS complement_4, t0.code_postal AS code_postal_5, t0.ville AS ville_6, t0.cedex AS cedex_7, t0.tel AS tel_8, t0.site AS site_9, t0.slug AS slug_10, t0.email AS email_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM dpo t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.fonction AS fonction_4,
  t0.email AS email_5,
  t0.nb_heures AS nb_heures_6,
  t0.emargement AS emargement_7,
  t0.commentaire AS commentaire_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.civilite_id AS civilite_id_11,
  t0.etablissement_id AS etablissement_id_12,
  t0.tarif_id AS tarif_id_13
FROM
  personne t0
WHERE
  t0.tarif_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.fonction AS fonction_4, t0.email AS email_5, t0.nb_heures AS nb_heures_6, t0.emargement AS emargement_7, t0.commentaire AS commentaire_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.civilite_id AS civilite_id_11, t0.etablissement_id AS etablissement_id_12, t0.tarif_id AS tarif_id_13 FROM personne t0 WHERE t0.tarif_id = 58;

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.publie AS publie_3,
  t0.nom AS nom_4,
  t0.icon AS icon_5,
  t0.slug AS slug_6,
  t0.contenu AS contenu_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.evenement_id AS evenement_id_10
FROM
  evenement_onglet t0
WHERE
  t0.evenement_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.publie AS publie_3, t0.nom AS nom_4, t0.icon AS icon_5, t0.slug AS slug_6, t0.contenu AS contenu_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.evenement_id AS evenement_id_10 FROM evenement_onglet t0 WHERE t0.evenement_id = 22 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prefixe AS prefixe_3,
  t0.sub_domain AS sub_domain_4,
  t0.adresse AS adresse_5,
  t0.complement AS complement_6,
  t0.code_postal AS code_postal_7,
  t0.ville AS ville_8,
  t0.cedex AS cedex_9,
  t0.agrement_date AS agrement_date_10,
  t0.agrement_code AS agrement_code_11,
  t0.logo_url AS logo_url_12,
  t0.logo_name AS logo_name_13,
  t0.siret AS siret_14,
  t0.ape AS ape_15,
  t0.dom AS dom_16,
  t0.bic AS bic_17,
  t0.iban AS iban_18,
  t0.rib AS rib_19,
  t0.tel AS tel_20,
  t0.site AS site_21,
  t0.slug AS slug_22,
  t0.co_orga_only AS co_orga_only_23,
  t0.masculin AS masculin_24,
  t0.sans_article AS sans_article_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t28.id AS id_29,
  t28.username AS username_30,
  t28.confirmation_token AS confirmation_token_31,
  t28.password_requested_at AS password_requested_at_32,
  t28.roles AS roles_33,
  t28.email AS email_34,
  t28.email_canonical AS email_canonical_35,
  t28.enabled AS enabled_36,
  t28.salt AS salt_37,
  t28.password AS password_38,
  t28.last_login AS last_login_39,
  t28.nom AS nom_40,
  t28.prenom AS prenom_41,
  t28.homme AS homme_42,
  t28.fonction AS fonction_43,
  t28.signature_name AS signature_name_44,
  t28.organisateur_id AS organisateur_id_45,
  t28.dirige_id AS dirige_id_46,
  t28.gere_id AS gere_id_47,
  t28.journee_id AS journee_id_48,
  t28.evenement_id AS evenement_id_49,
  t50.id AS id_51,
  t50.username AS username_52,
  t50.confirmation_token AS confirmation_token_53,
  t50.password_requested_at AS password_requested_at_54,
  t50.roles AS roles_55,
  t50.email AS email_56,
  t50.email_canonical AS email_canonical_57,
  t50.enabled AS enabled_58,
  t50.salt AS salt_59,
  t50.password AS password_60,
  t50.last_login AS last_login_61,
  t50.nom AS nom_62,
  t50.prenom AS prenom_63,
  t50.homme AS homme_64,
  t50.fonction AS fonction_65,
  t50.signature_name AS signature_name_66,
  t50.organisateur_id AS organisateur_id_67,
  t50.dirige_id AS dirige_id_68,
  t50.gere_id AS gere_id_69,
  t50.journee_id AS journee_id_70,
  t50.evenement_id AS evenement_id_71,
  t0.dpo_id AS dpo_id_72
FROM
  organisateur t0
  LEFT JOIN user t28 ON t28.dirige_id = t0.id
  LEFT JOIN user t50 ON t50.gere_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prefixe AS prefixe_3, t0.sub_domain AS sub_domain_4, t0.adresse AS adresse_5, t0.complement AS complement_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.cedex AS cedex_9, t0.agrement_date AS agrement_date_10, t0.agrement_code AS agrement_code_11, t0.logo_url AS logo_url_12, t0.logo_name AS logo_name_13, t0.siret AS siret_14, t0.ape AS ape_15, t0.dom AS dom_16, t0.bic AS bic_17, t0.iban AS iban_18, t0.rib AS rib_19, t0.tel AS tel_20, t0.site AS site_21, t0.slug AS slug_22, t0.co_orga_only AS co_orga_only_23, t0.masculin AS masculin_24, t0.sans_article AS sans_article_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t28.id AS id_29, t28.username AS username_30, t28.confirmation_token AS confirmation_token_31, t28.password_requested_at AS password_requested_at_32, t28.roles AS roles_33, t28.email AS email_34, t28.email_canonical AS email_canonical_35, t28.enabled AS enabled_36, t28.salt AS salt_37, t28.password AS password_38, t28.last_login AS last_login_39, t28.nom AS nom_40, t28.prenom AS prenom_41, t28.homme AS homme_42, t28.fonction AS fonction_43, t28.signature_name AS signature_name_44, t28.organisateur_id AS organisateur_id_45, t28.dirige_id AS dirige_id_46, t28.gere_id AS gere_id_47, t28.journee_id AS journee_id_48, t28.evenement_id AS evenement_id_49, t50.id AS id_51, t50.username AS username_52, t50.confirmation_token AS confirmation_token_53, t50.password_requested_at AS password_requested_at_54, t50.roles AS roles_55, t50.email AS email_56, t50.email_canonical AS email_canonical_57, t50.enabled AS enabled_58, t50.salt AS salt_59, t50.password AS password_60, t50.last_login AS last_login_61, t50.nom AS nom_62, t50.prenom AS prenom_63, t50.homme AS homme_64, t50.fonction AS fonction_65, t50.signature_name AS signature_name_66, t50.organisateur_id AS organisateur_id_67, t50.dirige_id AS dirige_id_68, t50.gere_id AS gere_id_69, t50.journee_id AS journee_id_70, t50.evenement_id AS evenement_id_71, t0.dpo_id AS dpo_id_72 FROM organisateur t0 LEFT JOIN user t28 ON t28.dirige_id = t0.id LEFT JOIN user t50 ON t50.gere_id = t0.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.typage AS typage_3,
  t0.libelle AS libelle_4,
  t0.help AS help_5,
  t0.etablissement AS etablissement_6,
  t0.slug AS slug_7,
  t0.evenement_id AS evenement_id_8
FROM
  variable t0
WHERE
  t0.evenement_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typage AS typage_3, t0.libelle AS libelle_4, t0.help AS help_5, t0.etablissement AS etablissement_6, t0.slug AS slug_7, t0.evenement_id AS evenement_id_8 FROM variable t0 WHERE t0.evenement_id = 22;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.duree_lib AS duree_lib_5,
  t0.lieu_complement AS lieu_complement_6,
  t0.nb_plan_b AS nb_plan_b_7,
  t0.seuil_nb_inscrit AS seuil_nb_inscrit_8,
  t0.pre_titre AS pre_titre_9,
  t0.post_titre AS post_titre_10,
  t0.editorial AS editorial_11,
  t0.programme AS programme_12,
  t0.arrive AS arrive_13,
  t0.has_badge AS has_badge_14,
  t0.minisite AS minisite_15,
  t0.domaine AS domaine_16,
  t0.sub_domaine AS sub_domaine_17,
  t0.icon AS icon_18,
  t0.color AS color_19,
  t0.header_nom AS header_nom_20,
  t0.annulation_possible AS annulation_possible_21,
  t0.commentaire_personne_active AS commentaire_personne_active_22,
  t0.commentaire_personne_help AS commentaire_personne_help_23,
  t0.badge_complement AS badge_complement_24,
  t0.montant_non_remboursable AS montant_non_remboursable_25,
  t0.comment_atelier AS comment_atelier_26,
  t0.participant_fonction_facultative AS participant_fonction_facultative_27,
  t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28,
  t0.nom AS nom_29,
  t0.description AS description_30,
  t0.comment_form AS comment_form_31,
  t0.comment_mail AS comment_mail_32,
  t0.date_limite_annulation AS date_limite_annulation_33,
  t0.date_limite_inscription AS date_limite_inscription_34,
  t0.date_limite_remplacement AS date_limite_remplacement_35,
  t0.specialite AS specialite_36,
  t0.actif AS actif_37,
  t0.nb_heures AS nb_heures_38,
  t0.code_youtube AS code_youtube_39,
  t0.montant_annulation AS montant_annulation_40,
  t0.brochure_nom AS brochure_nom_41,
  t0.image_nom AS image_nom_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t0.lieu_id AS lieu_id_45,
  t0.organisateur_id AS organisateur_id_46,
  t0.created_by_id AS created_by_id_47,
  t0.updated_by_id AS updated_by_id_48
FROM
  evenement t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.duree_lib AS duree_lib_5, t0.lieu_complement AS lieu_complement_6, t0.nb_plan_b AS nb_plan_b_7, t0.seuil_nb_inscrit AS seuil_nb_inscrit_8, t0.pre_titre AS pre_titre_9, t0.post_titre AS post_titre_10, t0.editorial AS editorial_11, t0.programme AS programme_12, t0.arrive AS arrive_13, t0.has_badge AS has_badge_14, t0.minisite AS minisite_15, t0.domaine AS domaine_16, t0.sub_domaine AS sub_domaine_17, t0.icon AS icon_18, t0.color AS color_19, t0.header_nom AS header_nom_20, t0.annulation_possible AS annulation_possible_21, t0.commentaire_personne_active AS commentaire_personne_active_22, t0.commentaire_personne_help AS commentaire_personne_help_23, t0.badge_complement AS badge_complement_24, t0.montant_non_remboursable AS montant_non_remboursable_25, t0.comment_atelier AS comment_atelier_26, t0.participant_fonction_facultative AS participant_fonction_facultative_27, t0.send_email_admin_to_created_by AS send_email_admin_to_created_by_28, t0.nom AS nom_29, t0.description AS description_30, t0.comment_form AS comment_form_31, t0.comment_mail AS comment_mail_32, t0.date_limite_annulation AS date_limite_annulation_33, t0.date_limite_inscription AS date_limite_inscription_34, t0.date_limite_remplacement AS date_limite_remplacement_35, t0.specialite AS specialite_36, t0.actif AS actif_37, t0.nb_heures AS nb_heures_38, t0.code_youtube AS code_youtube_39, t0.montant_annulation AS montant_annulation_40, t0.brochure_nom AS brochure_nom_41, t0.image_nom AS image_nom_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.lieu_id AS lieu_id_45, t0.organisateur_id AS organisateur_id_46, t0.created_by_id AS created_by_id_47, t0.updated_by_id AS updated_by_id_48 FROM evenement t0 WHERE t0.slug = '2026-comment-rendre-effectif-le-droit-a-lautodetermination' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.montant AS montant_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.commentaire AS commentaire_6,
  t0.min_participant AS min_participant_7,
  t0.max_participant AS max_participant_8,
  t0.hide_if_inactif AS hide_if_inactif_9,
  t0.evenement_id AS evenement_id_10,
  t0.tarif_parent_id AS tarif_parent_id_11
FROM
  tarif t0
WHERE
  t0.tarif_parent_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.montant AS montant_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.commentaire AS commentaire_6, t0.min_participant AS min_participant_7, t0.max_participant AS max_participant_8, t0.hide_if_inactif AS hide_if_inactif_9, t0.evenement_id AS evenement_id_10, t0.tarif_parent_id AS tarif_parent_id_11 FROM tarif t0 WHERE t0.tarif_parent_id = 54;

SELECT
  t0_.id AS id_0,
  t0_.nom AS nom_1,
  t0_.montant AS montant_2,
  t0_.date_debut AS date_debut_3,
  t0_.date_fin AS date_fin_4,
  t0_.commentaire AS commentaire_5,
  t0_.min_participant AS min_participant_6,
  t0_.max_participant AS max_participant_7,
  t0_.hide_if_inactif AS hide_if_inactif_8,
  t0_.evenement_id AS evenement_id_9,
  t0_.tarif_parent_id AS tarif_parent_id_10
FROM
  tarif t0_
WHERE
  t0_.evenement_id = ?
  AND t0_.tarif_parent_id IS NULL
  AND (
    t0_.date_debut < CURRENT_DATE
    OR t0_.date_debut IS NULL
  )
  AND (
    t0_.date_fin > CURRENT_DATE
    OR t0_.date_fin IS NULL
  )

SELECT t0_.id AS id_0, t0_.nom AS nom_1, t0_.montant AS montant_2, t0_.date_debut AS date_debut_3, t0_.date_fin AS date_fin_4, t0_.commentaire AS commentaire_5, t0_.min_participant AS min_participant_6, t0_.max_participant AS max_participant_7, t0_.hide_if_inactif AS hide_if_inactif_8, t0_.evenement_id AS evenement_id_9, t0_.tarif_parent_id AS tarif_parent_id_10 FROM tarif t0_ WHERE t0_.evenement_id = 22 AND t0_.tarif_parent_id IS NULL AND (t0_.date_debut < CURRENT_DATE OR t0_.date_debut IS NULL) AND (t0_.date_fin > CURRENT_DATE OR t0_.date_fin IS NULL);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.montant AS montant_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.commentaire AS commentaire_6,
  t0.min_participant AS min_participant_7,
  t0.max_participant AS max_participant_8,
  t0.hide_if_inactif AS hide_if_inactif_9,
  t0.evenement_id AS evenement_id_10,
  t0.tarif_parent_id AS tarif_parent_id_11
FROM
  tarif t0
WHERE
  t0.evenement_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.montant AS montant_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.commentaire AS commentaire_6, t0.min_participant AS min_participant_7, t0.max_participant AS max_participant_8, t0.hide_if_inactif AS hide_if_inactif_9, t0.evenement_id AS evenement_id_10, t0.tarif_parent_id AS tarif_parent_id_11 FROM tarif t0 WHERE t0.evenement_id = 22;

SELECT
  t0.id AS id_1,
  t0.in_convention AS in_convention_2,
  t0.in_footer AS in_footer_3,
  t0.evenement_id AS evenement_id_4,
  t0.coorga_id AS coorga_id_5
FROM
  evenement_coorga t0
WHERE
  t0.evenement_id = ?

SELECT t0.id AS id_1, t0.in_convention AS in_convention_2, t0.in_footer AS in_footer_3, t0.evenement_id AS evenement_id_4, t0.coorga_id AS coorga_id_5 FROM evenement_coorga t0 WHERE t0.evenement_id = 22;