Symfony Profiler

SELECT
  t0.place AS place_1,
  t0.max_places AS max_places_2,
  t0.date AS date_3,
  t0.moment AS moment_4,
  t0.address AS address_5,
  t0.multi_origin AS multi_origin_6,
  t0.splitted_max_places AS splitted_max_places_7,
  t0.created_by_admin AS created_by_admin_8,
  t0.id AS id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  formation_date t0
WHERE
  t0.id = ?

SELECT t0.place AS place_1, t0.max_places AS max_places_2, t0.date AS date_3, t0.moment AS moment_4, t0.address AS address_5, t0.multi_origin AS multi_origin_6, t0.splitted_max_places AS splitted_max_places_7, t0.created_by_admin AS created_by_admin_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM formation_date t0 WHERE t0.id = 0x0195B86E37958736B603244BDC213FCF;

SELECT
  t0.resource_type AS resource_type_1,
  t0.resource_origin AS resource_origin_2,
  t0.will_be_deleted AS will_be_deleted_3,
  t0.sync AS sync_4,
  t0.duration_ratio AS duration_ratio_5,
  t0.approach_type AS approach_type_6,
  t0.precision_name AS precision_name_7,
  t0.created_by_admin AS created_by_admin_8,
  t0.error_body AS error_body_9,
  t0.eni_id AS eni_id_10,
  t0.logged AS logged_11,
  t0.name AS name_12,
  t0.objective AS objective_13,
  t0.id AS id_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.course_id AS course_id_17,
  t0.resource_domain_id AS resource_domain_id_18,
  t0.application_id AS application_id_19,
  t0.parent_eni_resource_id AS parent_eni_resource_id_20,
  t0.parent_office_resource_id AS parent_office_resource_id_21,
  t0.entreprise_id AS entreprise_id_22,
  t0.parent_draft_eni_resource_id AS parent_draft_eni_resource_id_23
FROM
  journey t0
WHERE
  t0.course_id = ?

SELECT t0.resource_type AS resource_type_1, t0.resource_origin AS resource_origin_2, t0.will_be_deleted AS will_be_deleted_3, t0.sync AS sync_4, t0.duration_ratio AS duration_ratio_5, t0.approach_type AS approach_type_6, t0.precision_name AS precision_name_7, t0.created_by_admin AS created_by_admin_8, t0.error_body AS error_body_9, t0.eni_id AS eni_id_10, t0.logged AS logged_11, t0.name AS name_12, t0.objective AS objective_13, t0.id AS id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.course_id AS course_id_17, t0.resource_domain_id AS resource_domain_id_18, t0.application_id AS application_id_19, t0.parent_eni_resource_id AS parent_eni_resource_id_20, t0.parent_office_resource_id AS parent_office_resource_id_21, t0.entreprise_id AS entreprise_id_22, t0.parent_draft_eni_resource_id AS parent_draft_eni_resource_id_23 FROM journey t0 WHERE t0.course_id = 0x0195B87DEA8D52FAFEA50DCC3C43976C;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.user_id AS user_id_3,
  t0.formation_date_id AS formation_date_id_4,
  t0.course_id AS course_id_5
FROM
  formation_date_presence t0
WHERE
  t0.course_id = ?

SELECT t0.status AS status_1, t0.id AS id_2, t0.user_id AS user_id_3, t0.formation_date_id AS formation_date_id_4, t0.course_id AS course_id_5 FROM formation_date_presence t0 WHERE t0.course_id = 0x0195B87DEA8D52FAFEA50DCC3C43976C;

SELECT
  t0.max_places AS max_places_1,
  t0.id AS id_2,
  t0.origin_id AS origin_id_3,
  t0.formation_date_id AS formation_date_id_4
FROM
  formation_date_origin t0
  INNER JOIN course_formation_date_origin ON t0.id = course_formation_date_origin.formation_date_origin_id
WHERE
  course_formation_date_origin.course_id = ?

SELECT t0.max_places AS max_places_1, t0.id AS id_2, t0.origin_id AS origin_id_3, t0.formation_date_id AS formation_date_id_4 FROM formation_date_origin t0 INNER JOIN course_formation_date_origin ON t0.id = course_formation_date_origin.formation_date_origin_id WHERE course_formation_date_origin.course_id = 0x0195B87DEA8D52FAFEA50DCC3C43976C;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  software t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM software t0 WHERE t0.id = 0x0195B7EDD87E98C78C2B31430E820299;

SELECT
  t0.created_at AS created_at_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.slug AS slug_7,
  t0.locale AS locale_8,
  t0.totpSecret AS totpSecret_9,
  t0.is_totp_enabled AS is_totp_enabled_10,
  t0.phone AS phone_11,
  t0.type AS type_12,
  t0.gender AS gender_13,
  t0.reference AS reference_14,
  t0.external_reference AS external_reference_15,
  t0.enabled AS enabled_16,
  t0.eni_id AS eni_id_17,
  t0.id AS id_18,
  t0.verified AS verified_19,
  t0.avatar_id AS avatar_id_20,
  t21.size AS size_22,
  t21.mime_type AS mime_type_23,
  t21.original_name AS original_name_24,
  t21.file_name AS file_name_25,
  t21.created_at AS created_at_26,
  t21.id AS id_27,
  t21.updated_at AS updated_at_28,
  t0.entreprise_id AS entreprise_id_29,
  t0.origin_id AS origin_id_30
FROM
  `user` t0
  LEFT JOIN media t21 ON t0.avatar_id = t21.id
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.totpSecret AS totpSecret_9, t0.is_totp_enabled AS is_totp_enabled_10, t0.phone AS phone_11, t0.type AS type_12, t0.gender AS gender_13, t0.reference AS reference_14, t0.external_reference AS external_reference_15, t0.enabled AS enabled_16, t0.eni_id AS eni_id_17, t0.id AS id_18, t0.verified AS verified_19, t0.avatar_id AS avatar_id_20, t21.size AS size_22, t21.mime_type AS mime_type_23, t21.original_name AS original_name_24, t21.file_name AS file_name_25, t21.created_at AS created_at_26, t21.id AS id_27, t21.updated_at AS updated_at_28, t0.entreprise_id AS entreprise_id_29, t0.origin_id AS origin_id_30 FROM `user` t0 LEFT JOIN media t21 ON t0.avatar_id = t21.id WHERE t0.id = 0x0195B87C40F51C833267C730E0344064;

SELECT
  t0.name AS name_1,
  t0.learning_language AS learning_language_2,
  t0.software_language AS software_language_3,
  t0.eni_id AS eni_id_4,
  t0.logged AS logged_5,
  t0.id AS id_6,
  t0.version_id AS version_id_7,
  t0.software_id AS software_id_8
FROM
  application t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.learning_language AS learning_language_2, t0.software_language AS software_language_3, t0.eni_id AS eni_id_4, t0.logged AS logged_5, t0.id AS id_6, t0.version_id AS version_id_7, t0.software_id AS software_id_8 FROM application t0 WHERE t0.id = 0x0195B7EDD9298E57A13D93843883A35E;

SELECT
  t0.summary AS summary_1,
  t0.status AS status_2,
  t0.response AS response_3,
  t0.reason AS reason_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.course_id AS course_id_8
FROM
  course_asking_dates_update t0
WHERE
  t0.course_id = ?

SELECT t0.summary AS summary_1, t0.status AS status_2, t0.response AS response_3, t0.reason AS reason_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.course_id AS course_id_8 FROM course_asking_dates_update t0 WHERE t0.course_id = 0x0195B87DEA8D52FAFEA50DCC3C43976C;

SELECT
  DISTINCT c0_.description AS description_0,
  c0_.reference AS reference_1,
  c0_.sent_to_administration AS sent_to_administration_2,
  c0_.validated AS validated_3,
  c0_.started_typing_dates_at AS started_typing_dates_at_4,
  c0_.reject_reason AS reject_reason_5,
  c0_.sent_at AS sent_at_6,
  c0_.use_easy_pro_catalogue AS use_easy_pro_catalogue_7,
  c0_.sync AS sync_8,
  c0_.user_email_notified_validation AS user_email_notified_validation_9,
  c0_.eni_id AS eni_id_10,
  c0_.logged AS logged_11,
  c0_.name AS name_12,
  c0_.id AS id_13,
  c0_.created_at AS created_at_14,
  c0_.updated_at AS updated_at_15,
  c0_.user_id AS user_id_16,
  c0_.resource_domain_id AS resource_domain_id_17,
  c0_.parent_course_id AS parent_course_id_18
FROM
  course c0_
  INNER JOIN `user` u1_ ON c0_.user_id = u1_.id
  INNER JOIN user_origin u2_ ON u1_.origin_id = u2_.id
  INNER JOIN entreprise e3_ ON u2_.id = e3_.origin_id
  INNER JOIN course_formation_date_origin c5_ ON c0_.id = c5_.course_id
  INNER JOIN formation_date_origin f4_ ON f4_.id = c5_.formation_date_origin_id
  INNER JOIN formation_date f6_ ON f4_.formation_date_id = f6_.id
WHERE
  e3_.id = ?
  AND c0_.validated = ?
  AND f6_.date >= ?
  AND f6_.date <= ?

SELECT DISTINCT c0_.description AS description_0, c0_.reference AS reference_1, c0_.sent_to_administration AS sent_to_administration_2, c0_.validated AS validated_3, c0_.started_typing_dates_at AS started_typing_dates_at_4, c0_.reject_reason AS reject_reason_5, c0_.sent_at AS sent_at_6, c0_.use_easy_pro_catalogue AS use_easy_pro_catalogue_7, c0_.sync AS sync_8, c0_.user_email_notified_validation AS user_email_notified_validation_9, c0_.eni_id AS eni_id_10, c0_.logged AS logged_11, c0_.name AS name_12, c0_.id AS id_13, c0_.created_at AS created_at_14, c0_.updated_at AS updated_at_15, c0_.user_id AS user_id_16, c0_.resource_domain_id AS resource_domain_id_17, c0_.parent_course_id AS parent_course_id_18 FROM course c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN user_origin u2_ ON u1_.origin_id = u2_.id INNER JOIN entreprise e3_ ON u2_.id = e3_.origin_id INNER JOIN course_formation_date_origin c5_ ON c0_.id = c5_.course_id INNER JOIN formation_date_origin f4_ ON f4_.id = c5_.formation_date_origin_id INNER JOIN formation_date f6_ ON f4_.formation_date_id = f6_.id WHERE e3_.id = 0x0195B86A5C72D5C271FFF6182254EB20 AND c0_.validated = 1 AND f6_.date >= '2025-01-01 00:00:00' AND f6_.date <= '2026-12-31 00:00:00';

SELECT
  t0.name AS name_1,
  t0.id AS id_2
FROM
  version_software t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.id AS id_2 FROM version_software t0 WHERE t0.id = 0x0195B7EDC79880DA4AD8F8BE9DF504E5;

SELECT
  t0.created_at AS created_at_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.slug AS slug_7,
  t0.locale AS locale_8,
  t0.totpSecret AS totpSecret_9,
  t0.is_totp_enabled AS is_totp_enabled_10,
  t0.phone AS phone_11,
  t0.type AS type_12,
  t0.gender AS gender_13,
  t0.reference AS reference_14,
  t0.external_reference AS external_reference_15,
  t0.enabled AS enabled_16,
  t0.eni_id AS eni_id_17,
  t0.id AS id_18,
  t0.verified AS verified_19,
  t0.avatar_id AS avatar_id_20,
  t21.size AS size_22,
  t21.mime_type AS mime_type_23,
  t21.original_name AS original_name_24,
  t21.file_name AS file_name_25,
  t21.created_at AS created_at_26,
  t21.id AS id_27,
  t21.updated_at AS updated_at_28,
  t0.entreprise_id AS entreprise_id_29,
  t0.origin_id AS origin_id_30
FROM
  `user` t0
  LEFT JOIN media t21 ON t0.avatar_id = t21.id
WHERE
  t0.entreprise_id = ?

SELECT t0.created_at AS created_at_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.slug AS slug_7, t0.locale AS locale_8, t0.totpSecret AS totpSecret_9, t0.is_totp_enabled AS is_totp_enabled_10, t0.phone AS phone_11, t0.type AS type_12, t0.gender AS gender_13, t0.reference AS reference_14, t0.external_reference AS external_reference_15, t0.enabled AS enabled_16, t0.eni_id AS eni_id_17, t0.id AS id_18, t0.verified AS verified_19, t0.avatar_id AS avatar_id_20, t21.size AS size_22, t21.mime_type AS mime_type_23, t21.original_name AS original_name_24, t21.file_name AS file_name_25, t21.created_at AS created_at_26, t21.id AS id_27, t21.updated_at AS updated_at_28, t0.entreprise_id AS entreprise_id_29, t0.origin_id AS origin_id_30 FROM `user` t0 LEFT JOIN media t21 ON t0.avatar_id = t21.id WHERE t0.entreprise_id = 0x0195B86A5C72D5C271FFF6182254EB20;

SELECT
  t0.can_manage_dates AS can_manage_dates_1,
  t0.api_key AS api_key_2,
  t0.webhook_url AS webhook_url_3,
  t0.webhook_secret AS webhook_secret_4,
  t0.subscribed_webhook_events AS subscribed_webhook_events_5,
  t0.created_at AS created_at_6,
  t0.name AS name_7,
  t0.id AS id_8,
  t0.origin_id AS origin_id_9
FROM
  entreprise t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.can_manage_dates AS can_manage_dates_1, t0.api_key AS api_key_2, t0.webhook_url AS webhook_url_3, t0.webhook_secret AS webhook_secret_4, t0.subscribed_webhook_events AS subscribed_webhook_events_5, t0.created_at AS created_at_6, t0.name AS name_7, t0.id AS id_8, t0.origin_id AS origin_id_9 FROM entreprise t0 WHERE t0.api_key = '47f10384b96c22c13c80faf042a7d4fe' LIMIT 1;

SELECT
  s0_.send_emails_to AS send_emails_to_0,
  s0_.scheduled_maintenance AS scheduled_maintenance_1,
  s0_.maintenance_message AS maintenance_message_2,
  s0_.maintenance_from AS maintenance_from_3,
  s0_.maintenance_to AS maintenance_to_4,
  s0_.automatic_maintenance AS automatic_maintenance_5,
  s0_.id AS id_6,
  s0_.autotrad AS autotrad_7
FROM
  super_admin_settings s0_
LIMIT
  1

SELECT s0_.send_emails_to AS send_emails_to_0, s0_.scheduled_maintenance AS scheduled_maintenance_1, s0_.maintenance_message AS maintenance_message_2, s0_.maintenance_from AS maintenance_from_3, s0_.maintenance_to AS maintenance_to_4, s0_.automatic_maintenance AS automatic_maintenance_5, s0_.id AS id_6, s0_.autotrad AS autotrad_7 FROM super_admin_settings s0_ LIMIT 1;