Symfony Profiler

SELECT
  t0.first_name AS first_name_1,
  t0.last_name AS last_name_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.moreInfos AS moreInfos_6,
  t0.enabled AS enabled_7,
  t0.forget_password_token AS forget_password_token_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.last_login AS last_login_12,
  t0.api_authorized AS api_authorized_13,
  t0.document_view AS document_view_14,
  t0.not_generates_notifications AS not_generates_notifications_15,
  t0.sso_key AS sso_key_16,
  t0.id AS id_17,
  t0.email_notification_preference_id AS email_notification_preference_id_18,
  t0.collectivity_id AS collectivity_id_19,
  t20.name AS name_21,
  t20.short_name AS short_name_22,
  t20.updated_by AS updated_by_23,
  t20.type AS type_24,
  t20.siren AS siren_25,
  t20.active AS active_26,
  t20.website AS website_27,
  t20.different_dpo AS different_dpo_28,
  t20.different_it_manager AS different_it_manager_29,
  t20.is_services_enabled AS is_services_enabled_30,
  t20.reporting_block_management_commitment AS reporting_block_management_commitment_31,
  t20.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_32,
  t20.has_module_conformite_traitement AS has_module_conformite_traitement_33,
  t20.has_module_conformite_organisation AS has_module_conformite_organisation_34,
  t20.has_module_tools AS has_module_tools_35,
  t20.informations_complementaires AS informations_complementaires_36,
  t20.finess_geo AS finess_geo_37,
  t20.population AS population_38,
  t20.nbr_agents AS nbr_agents_39,
  t20.nbr_cnil AS nbr_cnil_40,
  t20.created_at AS created_at_41,
  t20.updated_at AS updated_at_42,
  t20.id AS id_43,
  t20.address_line_one AS address_line_one_44,
  t20.address_line_two AS address_line_two_45,
  t20.address_city AS address_city_46,
  t20.address_zip_code AS address_zip_code_47,
  t20.address_insee AS address_insee_48,
  t20.legal_manager_civility AS legal_manager_civility_49,
  t20.legal_manager_first_name AS legal_manager_first_name_50,
  t20.legal_manager_last_name AS legal_manager_last_name_51,
  t20.legal_manager_job AS legal_manager_job_52,
  t20.legal_manager_mail AS legal_manager_mail_53,
  t20.legal_manager_phone_number AS legal_manager_phone_number_54,
  t20.legal_manager_notification AS legal_manager_notification_55,
  t20.referent_civility AS referent_civility_56,
  t20.referent_first_name AS referent_first_name_57,
  t20.referent_last_name AS referent_last_name_58,
  t20.referent_job AS referent_job_59,
  t20.referent_mail AS referent_mail_60,
  t20.referent_phone_number AS referent_phone_number_61,
  t20.referent_notification AS referent_notification_62,
  t20.dpo_civility AS dpo_civility_63,
  t20.dpo_first_name AS dpo_first_name_64,
  t20.dpo_last_name AS dpo_last_name_65,
  t20.dpo_job AS dpo_job_66,
  t20.dpo_mail AS dpo_mail_67,
  t20.dpo_phone_number AS dpo_phone_number_68,
  t20.dpo_notification AS dpo_notification_69,
  t20.it_manager_civility AS it_manager_civility_70,
  t20.it_manager_first_name AS it_manager_first_name_71,
  t20.it_manager_last_name AS it_manager_last_name_72,
  t20.it_manager_job AS it_manager_job_73,
  t20.it_manager_mail AS it_manager_mail_74,
  t20.it_manager_phone_number AS it_manager_phone_number_75,
  t20.it_manager_notification AS it_manager_notification_76
FROM
  user_user t0
  LEFT JOIN user_collectivity t20 ON t0.collectivity_id = t20.id
WHERE
  t0.id = ?

SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.moreInfos AS moreInfos_6, t0.enabled AS enabled_7, t0.forget_password_token AS forget_password_token_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.last_login AS last_login_12, t0.api_authorized AS api_authorized_13, t0.document_view AS document_view_14, t0.not_generates_notifications AS not_generates_notifications_15, t0.sso_key AS sso_key_16, t0.id AS id_17, t0.email_notification_preference_id AS email_notification_preference_id_18, t0.collectivity_id AS collectivity_id_19, t20.name AS name_21, t20.short_name AS short_name_22, t20.updated_by AS updated_by_23, t20.type AS type_24, t20.siren AS siren_25, t20.active AS active_26, t20.website AS website_27, t20.different_dpo AS different_dpo_28, t20.different_it_manager AS different_it_manager_29, t20.is_services_enabled AS is_services_enabled_30, t20.reporting_block_management_commitment AS reporting_block_management_commitment_31, t20.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_32, t20.has_module_conformite_traitement AS has_module_conformite_traitement_33, t20.has_module_conformite_organisation AS has_module_conformite_organisation_34, t20.has_module_tools AS has_module_tools_35, t20.informations_complementaires AS informations_complementaires_36, t20.finess_geo AS finess_geo_37, t20.population AS population_38, t20.nbr_agents AS nbr_agents_39, t20.nbr_cnil AS nbr_cnil_40, t20.created_at AS created_at_41, t20.updated_at AS updated_at_42, t20.id AS id_43, t20.address_line_one AS address_line_one_44, t20.address_line_two AS address_line_two_45, t20.address_city AS address_city_46, t20.address_zip_code AS address_zip_code_47, t20.address_insee AS address_insee_48, t20.legal_manager_civility AS legal_manager_civility_49, t20.legal_manager_first_name AS legal_manager_first_name_50, t20.legal_manager_last_name AS legal_manager_last_name_51, t20.legal_manager_job AS legal_manager_job_52, t20.legal_manager_mail AS legal_manager_mail_53, t20.legal_manager_phone_number AS legal_manager_phone_number_54, t20.legal_manager_notification AS legal_manager_notification_55, t20.referent_civility AS referent_civility_56, t20.referent_first_name AS referent_first_name_57, t20.referent_last_name AS referent_last_name_58, t20.referent_job AS referent_job_59, t20.referent_mail AS referent_mail_60, t20.referent_phone_number AS referent_phone_number_61, t20.referent_notification AS referent_notification_62, t20.dpo_civility AS dpo_civility_63, t20.dpo_first_name AS dpo_first_name_64, t20.dpo_last_name AS dpo_last_name_65, t20.dpo_job AS dpo_job_66, t20.dpo_mail AS dpo_mail_67, t20.dpo_phone_number AS dpo_phone_number_68, t20.dpo_notification AS dpo_notification_69, t20.it_manager_civility AS it_manager_civility_70, t20.it_manager_first_name AS it_manager_first_name_71, t20.it_manager_last_name AS it_manager_last_name_72, t20.it_manager_job AS it_manager_job_73, t20.it_manager_mail AS it_manager_mail_74, t20.it_manager_phone_number AS it_manager_phone_number_75, t20.it_manager_notification AS it_manager_notification_76 FROM user_user t0 LEFT JOIN user_collectivity t20 ON t0.collectivity_id = t20.id WHERE t0.id = '448482b8-d328-485e-9c64-a7e5c3027eb9';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.size AS size_4,
  t0.file AS file_5,
  t0.thumb_url AS thumb_url_6,
  t0.pinned AS pinned_7,
  t0.is_link AS is_link_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.creator_id AS creator_id_11
FROM
  document t0
  INNER JOIN user_favorite_documents ON t0.id = user_favorite_documents.document_id
WHERE
  user_favorite_documents.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.size AS size_4, t0.file AS file_5, t0.thumb_url AS thumb_url_6, t0.pinned AS pinned_7, t0.is_link AS is_link_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.creator_id AS creator_id_11 FROM document t0 INNER JOIN user_favorite_documents ON t0.id = user_favorite_documents.document_id WHERE user_favorite_documents.user_id = '448482b8-d328-485e-9c64-a7e5c3027eb9';

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.authorized_collectivity_types AS authorized_collectivity_types_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6
FROM
  maturity_referentiel t0

SELECT t0.name AS name_1, t0.description AS description_2, t0.authorized_collectivity_types AS authorized_collectivity_types_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM maturity_referentiel t0;

SELECT
  r0_.name AS name_0,
  r0_.type AS type_1,
  r0_.description AS description_2,
  r0_.cost AS cost_3,
  r0_.charge AS charge_4,
  r0_.status AS status_5,
  r0_.planification_date AS planification_date_6,
  r0_.comment AS comment_7,
  r0_.priority AS priority_8,
  r0_.manager AS manager_9,
  r0_.updated_by AS updated_by_10,
  r0_.created_at AS created_at_11,
  r0_.updated_at AS updated_at_12,
  r0_.id AS id_13,
  r0_.cloned_from_id AS cloned_from_id_14,
  r0_.collectivity_id AS collectivity_id_15,
  r0_.creator_id AS creator_id_16
FROM
  registry_mesurement r0_
WHERE
  r0_.status = ?
  AND r0_.planification_date IS NOT NULL
  AND r0_.collectivity_id = ?
GROUP BY
  r0_.id
ORDER BY
  r0_.planification_date DESC
LIMIT
  10

SELECT r0_.name AS name_0, r0_.type AS type_1, r0_.description AS description_2, r0_.cost AS cost_3, r0_.charge AS charge_4, r0_.status AS status_5, r0_.planification_date AS planification_date_6, r0_.comment AS comment_7, r0_.priority AS priority_8, r0_.manager AS manager_9, r0_.updated_by AS updated_by_10, r0_.created_at AS created_at_11, r0_.updated_at AS updated_at_12, r0_.id AS id_13, r0_.cloned_from_id AS cloned_from_id_14, r0_.collectivity_id AS collectivity_id_15, r0_.creator_id AS creator_id_16 FROM registry_mesurement r0_ WHERE r0_.status = 'not-applied' AND r0_.planification_date IS NOT NULL AND r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' GROUP BY r0_.id ORDER BY r0_.planification_date DESC LIMIT 10;

SELECT
  m0_.score AS score_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.id AS id_3,
  m0_.referentiel_id AS referentiel_id_4,
  m0_.collectivity_id AS collectivity_id_5,
  m0_.creator_id AS creator_id_6
FROM
  maturity_survey m0_
WHERE
  m0_.collectivity_id = ?
ORDER BY
  m0_.created_at DESC

SELECT m0_.score AS score_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.id AS id_3, m0_.referentiel_id AS referentiel_id_4, m0_.collectivity_id AS collectivity_id_5, m0_.creator_id AS creator_id_6 FROM maturity_survey m0_ WHERE m0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' ORDER BY m0_.created_at DESC;

SELECT
  r0_.date AS date_0,
  r0_.draft AS draft_1,
  r0_.created_at AS created_at_2,
  r0_.updated_at AS updated_at_3,
  r0_.id AS id_4,
  r1_.conformite AS conformite_5,
  r1_.pilote AS pilote_6,
  r1_.id AS id_7,
  r2_.nom AS nom_8,
  r2_.couleur AS couleur_9,
  r2_.description AS description_10,
  r2_.position AS position_11,
  r2_.id AS id_12,
  r3_.reponse AS reponse_13,
  r3_.reponse_raison AS reponse_raison_14,
  r3_.id AS id_15,
  r4_.name AS name_16,
  r4_.type AS type_17,
  r4_.description AS description_18,
  r4_.cost AS cost_19,
  r4_.charge AS charge_20,
  r4_.status AS status_21,
  r4_.planification_date AS planification_date_22,
  r4_.comment AS comment_23,
  r4_.priority AS priority_24,
  r4_.manager AS manager_25,
  r4_.updated_by AS updated_by_26,
  r4_.created_at AS created_at_27,
  r4_.updated_at AS updated_at_28,
  r4_.id AS id_29,
  r5_.nom AS nom_30,
  r5_.position AS position_31,
  r5_.id AS id_32,
  r0_.collectivity_id AS collectivity_id_33,
  r1_.processus_id AS processus_id_34,
  r1_.evaluation_id AS evaluation_id_35,
  r3_.question_id AS question_id_36,
  r3_.conformite_id AS conformite_id_37,
  r4_.cloned_from_id AS cloned_from_id_38,
  r4_.collectivity_id AS collectivity_id_39,
  r4_.creator_id AS creator_id_40,
  r5_.processus_id AS processus_id_41
FROM
  registry_conformite_organisation_evaluation r0_
  LEFT JOIN registry_conformite_organisation_conformite r1_ ON r0_.id = r1_.evaluation_id
  LEFT JOIN registry_conformite_organisation_processus r2_ ON r1_.processus_id = r2_.id
  LEFT JOIN registry_conformite_organisation_reponse r3_ ON r1_.id = r3_.conformite_id
  LEFT JOIN conformite_organisation_conformite_action_protection c6_ ON r1_.id = c6_.conformite_id
  LEFT JOIN registry_mesurement r4_ ON r4_.id = c6_.mesurement_id
  LEFT JOIN registry_conformite_organisation_question r5_ ON r2_.id = r5_.processus_id
WHERE
  r0_.collectivity_id = ?
  AND r0_.draft = 0
ORDER BY
  r0_.date DESC,
  r0_.created_at DESC,
  r1_.id ASC,
  r3_.id ASC

SELECT r0_.date AS date_0, r0_.draft AS draft_1, r0_.created_at AS created_at_2, r0_.updated_at AS updated_at_3, r0_.id AS id_4, r1_.conformite AS conformite_5, r1_.pilote AS pilote_6, r1_.id AS id_7, r2_.nom AS nom_8, r2_.couleur AS couleur_9, r2_.description AS description_10, r2_.position AS position_11, r2_.id AS id_12, r3_.reponse AS reponse_13, r3_.reponse_raison AS reponse_raison_14, r3_.id AS id_15, r4_.name AS name_16, r4_.type AS type_17, r4_.description AS description_18, r4_.cost AS cost_19, r4_.charge AS charge_20, r4_.status AS status_21, r4_.planification_date AS planification_date_22, r4_.comment AS comment_23, r4_.priority AS priority_24, r4_.manager AS manager_25, r4_.updated_by AS updated_by_26, r4_.created_at AS created_at_27, r4_.updated_at AS updated_at_28, r4_.id AS id_29, r5_.nom AS nom_30, r5_.position AS position_31, r5_.id AS id_32, r0_.collectivity_id AS collectivity_id_33, r1_.processus_id AS processus_id_34, r1_.evaluation_id AS evaluation_id_35, r3_.question_id AS question_id_36, r3_.conformite_id AS conformite_id_37, r4_.cloned_from_id AS cloned_from_id_38, r4_.collectivity_id AS collectivity_id_39, r4_.creator_id AS creator_id_40, r5_.processus_id AS processus_id_41 FROM registry_conformite_organisation_evaluation r0_ LEFT JOIN registry_conformite_organisation_conformite r1_ ON r0_.id = r1_.evaluation_id LEFT JOIN registry_conformite_organisation_processus r2_ ON r1_.processus_id = r2_.id LEFT JOIN registry_conformite_organisation_reponse r3_ ON r1_.id = r3_.conformite_id LEFT JOIN conformite_organisation_conformite_action_protection c6_ ON r1_.id = c6_.conformite_id LEFT JOIN registry_mesurement r4_ ON r4_.id = c6_.mesurement_id LEFT JOIN registry_conformite_organisation_question r5_ ON r2_.id = r5_.processus_id WHERE r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' AND r0_.draft = 0 ORDER BY r0_.date DESC, r0_.created_at DESC, r1_.id ASC, r3_.id ASC;

SELECT
  t0.name AS name_1,
  t0.referent AS referent_2,
  t0.contractual_clauses_verified AS contractual_clauses_verified_3,
  t0.other_informations AS other_informations_4,
  t0.adopted_security_features AS adopted_security_features_5,
  t0.maintains_treatment_register AS maintains_treatment_register_6,
  t0.sending_data_outside_eu AS sending_data_outside_eu_7,
  t0.has_dpo AS has_dpo_8,
  t0.updated_by AS updated_by_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.id AS id_12,
  t0.address_line_one AS address_line_one_13,
  t0.address_line_two AS address_line_two_14,
  t0.address_city AS address_city_15,
  t0.address_zip_code AS address_zip_code_16,
  t0.address_mail AS address_mail_17,
  t0.address_phone_number AS address_phone_number_18,
  t0.address_country AS address_country_19,
  t0.dpo_civility AS dpo_civility_20,
  t0.dpo_first_name AS dpo_first_name_21,
  t0.dpo_last_name AS dpo_last_name_22,
  t0.dpo_job AS dpo_job_23,
  t0.dpo_mail AS dpo_mail_24,
  t0.dpo_phone_number AS dpo_phone_number_25,
  t0.dpo_notification AS dpo_notification_26,
  t0.legal_manager_civility AS legal_manager_civility_27,
  t0.legal_manager_first_name AS legal_manager_first_name_28,
  t0.legal_manager_last_name AS legal_manager_last_name_29,
  t0.legal_manager_job AS legal_manager_job_30,
  t0.legal_manager_mail AS legal_manager_mail_31,
  t0.legal_manager_phone_number AS legal_manager_phone_number_32,
  t0.legal_manager_notification AS legal_manager_notification_33,
  t0.cloned_from_id AS cloned_from_id_34,
  t0.service_id AS service_id_35,
  t0.collectivity_id AS collectivity_id_36,
  t0.creator_id AS creator_id_37
FROM
  registry_contractor t0
WHERE
  t0.collectivity_id = ?

SELECT t0.name AS name_1, t0.referent AS referent_2, t0.contractual_clauses_verified AS contractual_clauses_verified_3, t0.other_informations AS other_informations_4, t0.adopted_security_features AS adopted_security_features_5, t0.maintains_treatment_register AS maintains_treatment_register_6, t0.sending_data_outside_eu AS sending_data_outside_eu_7, t0.has_dpo AS has_dpo_8, t0.updated_by AS updated_by_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.id AS id_12, t0.address_line_one AS address_line_one_13, t0.address_line_two AS address_line_two_14, t0.address_city AS address_city_15, t0.address_zip_code AS address_zip_code_16, t0.address_mail AS address_mail_17, t0.address_phone_number AS address_phone_number_18, t0.address_country AS address_country_19, t0.dpo_civility AS dpo_civility_20, t0.dpo_first_name AS dpo_first_name_21, t0.dpo_last_name AS dpo_last_name_22, t0.dpo_job AS dpo_job_23, t0.dpo_mail AS dpo_mail_24, t0.dpo_phone_number AS dpo_phone_number_25, t0.dpo_notification AS dpo_notification_26, t0.legal_manager_civility AS legal_manager_civility_27, t0.legal_manager_first_name AS legal_manager_first_name_28, t0.legal_manager_last_name AS legal_manager_last_name_29, t0.legal_manager_job AS legal_manager_job_30, t0.legal_manager_mail AS legal_manager_mail_31, t0.legal_manager_phone_number AS legal_manager_phone_number_32, t0.legal_manager_notification AS legal_manager_notification_33, t0.cloned_from_id AS cloned_from_id_34, t0.service_id AS service_id_35, t0.collectivity_id AS collectivity_id_36, t0.creator_id AS creator_id_37 FROM registry_contractor t0 WHERE t0.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34';

SELECT
  r0_.date AS date_0,
  r0_.action AS action_1,
  r0_.user_full_name AS user_full_name_2,
  r0_.user_email AS user_email_3,
  r0_.subject_type AS subject_type_4,
  r0_.subject_id AS subject_id_5,
  r0_.subject_name AS subject_name_6,
  r0_.is_deleted AS is_deleted_7,
  r0_.id AS id_8,
  r0_.collectivity_id AS collectivity_id_9
FROM
  reporting_log_journal r0_
WHERE
  r0_.collectivity_id = ?
  AND r0_.subject_type NOT IN (?)
ORDER BY
  r0_.date DESC
LIMIT
  15

SELECT r0_.date AS date_0, r0_.action AS action_1, r0_.user_full_name AS user_full_name_2, r0_.user_email AS user_email_3, r0_.subject_type AS subject_type_4, r0_.subject_id AS subject_id_5, r0_.subject_name AS subject_name_6, r0_.is_deleted AS is_deleted_7, r0_.id AS id_8, r0_.collectivity_id AS collectivity_id_9 FROM reporting_log_journal r0_ WHERE r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' AND r0_.subject_type NOT IN ('user_collectivity', 'user_email', 'user_firstname', 'user_lastname', 'user_password', 'user_user', 'admin_duplication') ORDER BY r0_.date DESC LIMIT 15;

SELECT
  m0_.score AS score_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.id AS id_3,
  m0_.referentiel_id AS referentiel_id_4,
  m0_.collectivity_id AS collectivity_id_5,
  m0_.creator_id AS creator_id_6
FROM
  maturity_survey m0_
WHERE
  m0_.referentiel_id = ?
  AND m0_.collectivity_id = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  2

SELECT m0_.score AS score_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.id AS id_3, m0_.referentiel_id AS referentiel_id_4, m0_.collectivity_id AS collectivity_id_5, m0_.creator_id AS creator_id_6 FROM maturity_survey m0_ WHERE m0_.referentiel_id = '98ba36d4-a73c-405b-b633-aa71bb2892b9' AND m0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' ORDER BY m0_.created_at DESC LIMIT 2;

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.description AS description_3,
  t0.cost AS cost_4,
  t0.charge AS charge_5,
  t0.status AS status_6,
  t0.planification_date AS planification_date_7,
  t0.comment AS comment_8,
  t0.priority AS priority_9,
  t0.manager AS manager_10,
  t0.updated_by AS updated_by_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.id AS id_14,
  t0.cloned_from_id AS cloned_from_id_15,
  t0.collectivity_id AS collectivity_id_16,
  t0.creator_id AS creator_id_17
FROM
  registry_mesurement t0
WHERE
  t0.collectivity_id = ?

SELECT t0.name AS name_1, t0.type AS type_2, t0.description AS description_3, t0.cost AS cost_4, t0.charge AS charge_5, t0.status AS status_6, t0.planification_date AS planification_date_7, t0.comment AS comment_8, t0.priority AS priority_9, t0.manager AS manager_10, t0.updated_by AS updated_by_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.id AS id_14, t0.cloned_from_id AS cloned_from_id_15, t0.collectivity_id AS collectivity_id_16, t0.creator_id AS creator_id_17 FROM registry_mesurement t0 WHERE t0.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34';

SELECT
  r0_.object AS object_0,
  r0_.other_object AS other_object_1,
  r0_.date AS date_2,
  r0_.reason AS reason_3,
  r0_.updated_by AS updated_by_4,
  r0_.complete AS complete_5,
  r0_.legitimate_applicant AS legitimate_applicant_6,
  r0_.legitimate_request AS legitimate_request_7,
  r0_.state AS state_8,
  r0_.state_rejection_reason AS state_rejection_reason_9,
  r0_.created_at AS created_at_10,
  r0_.updated_at AS updated_at_11,
  r0_.deleted_at AS deleted_at_12,
  r0_.id AS id_13,
  r0_.applicant_civility AS applicant_civility_14,
  r0_.applicant_first_name AS applicant_first_name_15,
  r0_.applicant_last_name AS applicant_last_name_16,
  r0_.applicant_address AS applicant_address_17,
  r0_.applicant_mail AS applicant_mail_18,
  r0_.applicant_phone_number AS applicant_phone_number_19,
  r0_.applicant_concerned_people AS applicant_concerned_people_20,
  r0_.concerned_civility AS concerned_civility_21,
  r0_.concerned_first_name AS concerned_first_name_22,
  r0_.concerned_last_name AS concerned_last_name_23,
  r0_.concerned_address AS concerned_address_24,
  r0_.concerned_mail AS concerned_mail_25,
  r0_.concerned_phone_number AS concerned_phone_number_26,
  r0_.concerned_link_with_applicant AS concerned_link_with_applicant_27,
  r0_.answer_response AS answer_response_28,
  r0_.answer_date AS answer_date_29,
  r0_.answer_type AS answer_type_30,
  r0_.service_id AS service_id_31,
  r0_.collectivity_id AS collectivity_id_32,
  r0_.creator_id AS creator_id_33
FROM
  registry_request r0_
WHERE
  r0_.collectivity_id = ?
  AND r0_.deleted_at IS NULL

SELECT r0_.object AS object_0, r0_.other_object AS other_object_1, r0_.date AS date_2, r0_.reason AS reason_3, r0_.updated_by AS updated_by_4, r0_.complete AS complete_5, r0_.legitimate_applicant AS legitimate_applicant_6, r0_.legitimate_request AS legitimate_request_7, r0_.state AS state_8, r0_.state_rejection_reason AS state_rejection_reason_9, r0_.created_at AS created_at_10, r0_.updated_at AS updated_at_11, r0_.deleted_at AS deleted_at_12, r0_.id AS id_13, r0_.applicant_civility AS applicant_civility_14, r0_.applicant_first_name AS applicant_first_name_15, r0_.applicant_last_name AS applicant_last_name_16, r0_.applicant_address AS applicant_address_17, r0_.applicant_mail AS applicant_mail_18, r0_.applicant_phone_number AS applicant_phone_number_19, r0_.applicant_concerned_people AS applicant_concerned_people_20, r0_.concerned_civility AS concerned_civility_21, r0_.concerned_first_name AS concerned_first_name_22, r0_.concerned_last_name AS concerned_last_name_23, r0_.concerned_address AS concerned_address_24, r0_.concerned_mail AS concerned_mail_25, r0_.concerned_phone_number AS concerned_phone_number_26, r0_.concerned_link_with_applicant AS concerned_link_with_applicant_27, r0_.answer_response AS answer_response_28, r0_.answer_date AS answer_date_29, r0_.answer_type AS answer_type_30, r0_.service_id AS service_id_31, r0_.collectivity_id AS collectivity_id_32, r0_.creator_id AS creator_id_33 FROM registry_request r0_ WHERE r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' AND r0_.deleted_at IS NULL;

SELECT
  t0.name AS name_1,
  t0.public AS public_2,
  t0.exempt_AIPD AS exempt_AIPD_3,
  t0.statut AS statut_4,
  t0.goal AS goal_5,
  t0.updated_by AS updated_by_6,
  t0.manager AS manager_7,
  t0.paper_processing AS paper_processing_8,
  t0.legal_basis AS legal_basis_9,
  t0.legal_basis_justification AS legal_basis_justification_10,
  t0.observation AS observation_11,
  t0.data_category_other AS data_category_other_12,
  t0.data_origin AS data_origin_13,
  t0.recipient_category AS recipient_category_14,
  t0.systematic_monitoring AS systematic_monitoring_15,
  t0.large_scale_collection AS large_scale_collection_16,
  t0.vulnerable_people AS vulnerable_people_17,
  t0.data_crossing AS data_crossing_18,
  t0.evaluation_or_rating AS evaluation_or_rating_19,
  t0.automated_decisions_with_legal_effect AS automated_decisions_with_legal_effect_20,
  t0.automatic_exclusion_service AS automatic_exclusion_service_21,
  t0.innovative_use AS innovative_use_22,
  t0.active AS active_23,
  t0.completion AS completion_24,
  t0.template AS template_25,
  t0.template_identifier AS template_identifier_26,
  t0.security_entitled_persons AS security_entitled_persons_27,
  t0.security_open_accounts AS security_open_accounts_28,
  t0.security_specificities_delivered AS security_specificities_delivered_29,
  t0.author AS author_30,
  t0.software AS software_31,
  t0.coordonnees_responsable_traitement AS coordonnees_responsable_traitement_32,
  t0.collecting_method AS collecting_method_33,
  t0.estimated_concerned_people AS estimated_concerned_people_34,
  t0.dpo_message AS dpo_message_35,
  t0.other_collecting_method AS other_collecting_method_36,
  t0.legal_mentions AS legal_mentions_37,
  t0.consent_request AS consent_request_38,
  t0.consent_request_format AS consent_request_format_39,
  t0.created_at AS created_at_40,
  t0.updated_at AS updated_at_41,
  t0.id AS id_42,
  t0.security_access_control_check AS security_access_control_check_43,
  t0.security_access_control_comment AS security_access_control_comment_44,
  t0.security_tracability_check AS security_tracability_check_45,
  t0.security_tracability_comment AS security_tracability_comment_46,
  t0.security_saving_check AS security_saving_check_47,
  t0.security_saving_comment AS security_saving_comment_48,
  t0.security_update_check AS security_update_check_49,
  t0.security_update_comment AS security_update_comment_50,
  t0.security_other_check AS security_other_check_51,
  t0.security_other_comment AS security_other_comment_52,
  t0.concerned_people_particular_check AS concerned_people_particular_check_53,
  t0.concerned_people_particular_comment AS concerned_people_particular_comment_54,
  t0.concerned_people_user_check AS concerned_people_user_check_55,
  t0.concerned_people_user_comment AS concerned_people_user_comment_56,
  t0.concerned_people_agent_check AS concerned_people_agent_check_57,
  t0.concerned_people_agent_comment AS concerned_people_agent_comment_58,
  t0.concerned_people_elected_check AS concerned_people_elected_check_59,
  t0.concerned_people_elected_comment AS concerned_people_elected_comment_60,
  t0.concerned_people_company_check AS concerned_people_company_check_61,
  t0.concerned_people_company_comment AS concerned_people_company_comment_62,
  t0.concerned_people_partner_check AS concerned_people_partner_check_63,
  t0.concerned_people_partner_comment AS concerned_people_partner_comment_64,
  t0.concerned_people_usager_check AS concerned_people_usager_check_65,
  t0.concerned_people_usager_comment AS concerned_people_usager_comment_66,
  t0.concerned_people_other_check AS concerned_people_other_check_67,
  t0.concerned_people_other_comment AS concerned_people_other_comment_68,
  t69.nb_conformes AS nb_conformes_70,
  t69.nb_non_conformes_mineures AS nb_non_conformes_mineures_71,
  t69.nb_non_conformes_majeures AS nb_non_conformes_majeures_72,
  t69.created_at AS created_at_73,
  t69.updated_at AS updated_at_74,
  t69.id AS id_75,
  t69.traitement_id AS traitement_id_76,
  t69.creator_id AS creator_id_77,
  t0.cloned_from_id AS cloned_from_id_78,
  t0.service_id AS service_id_79,
  t0.collectivity_id AS collectivity_id_80,
  t0.creator_id AS creator_id_81
FROM
  registry_treatment t0
  LEFT JOIN conformite_traitement t69 ON t69.traitement_id = t0.id
WHERE
  t0.collectivity_id = ?

SELECT t0.name AS name_1, t0.public AS public_2, t0.exempt_AIPD AS exempt_AIPD_3, t0.statut AS statut_4, t0.goal AS goal_5, t0.updated_by AS updated_by_6, t0.manager AS manager_7, t0.paper_processing AS paper_processing_8, t0.legal_basis AS legal_basis_9, t0.legal_basis_justification AS legal_basis_justification_10, t0.observation AS observation_11, t0.data_category_other AS data_category_other_12, t0.data_origin AS data_origin_13, t0.recipient_category AS recipient_category_14, t0.systematic_monitoring AS systematic_monitoring_15, t0.large_scale_collection AS large_scale_collection_16, t0.vulnerable_people AS vulnerable_people_17, t0.data_crossing AS data_crossing_18, t0.evaluation_or_rating AS evaluation_or_rating_19, t0.automated_decisions_with_legal_effect AS automated_decisions_with_legal_effect_20, t0.automatic_exclusion_service AS automatic_exclusion_service_21, t0.innovative_use AS innovative_use_22, t0.active AS active_23, t0.completion AS completion_24, t0.template AS template_25, t0.template_identifier AS template_identifier_26, t0.security_entitled_persons AS security_entitled_persons_27, t0.security_open_accounts AS security_open_accounts_28, t0.security_specificities_delivered AS security_specificities_delivered_29, t0.author AS author_30, t0.software AS software_31, t0.coordonnees_responsable_traitement AS coordonnees_responsable_traitement_32, t0.collecting_method AS collecting_method_33, t0.estimated_concerned_people AS estimated_concerned_people_34, t0.dpo_message AS dpo_message_35, t0.other_collecting_method AS other_collecting_method_36, t0.legal_mentions AS legal_mentions_37, t0.consent_request AS consent_request_38, t0.consent_request_format AS consent_request_format_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41, t0.id AS id_42, t0.security_access_control_check AS security_access_control_check_43, t0.security_access_control_comment AS security_access_control_comment_44, t0.security_tracability_check AS security_tracability_check_45, t0.security_tracability_comment AS security_tracability_comment_46, t0.security_saving_check AS security_saving_check_47, t0.security_saving_comment AS security_saving_comment_48, t0.security_update_check AS security_update_check_49, t0.security_update_comment AS security_update_comment_50, t0.security_other_check AS security_other_check_51, t0.security_other_comment AS security_other_comment_52, t0.concerned_people_particular_check AS concerned_people_particular_check_53, t0.concerned_people_particular_comment AS concerned_people_particular_comment_54, t0.concerned_people_user_check AS concerned_people_user_check_55, t0.concerned_people_user_comment AS concerned_people_user_comment_56, t0.concerned_people_agent_check AS concerned_people_agent_check_57, t0.concerned_people_agent_comment AS concerned_people_agent_comment_58, t0.concerned_people_elected_check AS concerned_people_elected_check_59, t0.concerned_people_elected_comment AS concerned_people_elected_comment_60, t0.concerned_people_company_check AS concerned_people_company_check_61, t0.concerned_people_company_comment AS concerned_people_company_comment_62, t0.concerned_people_partner_check AS concerned_people_partner_check_63, t0.concerned_people_partner_comment AS concerned_people_partner_comment_64, t0.concerned_people_usager_check AS concerned_people_usager_check_65, t0.concerned_people_usager_comment AS concerned_people_usager_comment_66, t0.concerned_people_other_check AS concerned_people_other_check_67, t0.concerned_people_other_comment AS concerned_people_other_comment_68, t69.nb_conformes AS nb_conformes_70, t69.nb_non_conformes_mineures AS nb_non_conformes_mineures_71, t69.nb_non_conformes_majeures AS nb_non_conformes_majeures_72, t69.created_at AS created_at_73, t69.updated_at AS updated_at_74, t69.id AS id_75, t69.traitement_id AS traitement_id_76, t69.creator_id AS creator_id_77, t0.cloned_from_id AS cloned_from_id_78, t0.service_id AS service_id_79, t0.collectivity_id AS collectivity_id_80, t0.creator_id AS creator_id_81 FROM registry_treatment t0 LEFT JOIN conformite_traitement t69 ON t69.traitement_id = t0.id WHERE t0.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34';

SELECT
  t0.name AS name_1,
  t0.duration AS duration_2,
  t0.ultimate_fate AS ultimate_fate_3,
  t0.id AS id_4,
  t0.treatment_id AS treatment_id_5
FROM
  registry_treatment_shelf_life t0
WHERE
  t0.treatment_id IN (?)

SELECT t0.name AS name_1, t0.duration AS duration_2, t0.ultimate_fate AS ultimate_fate_3, t0.id AS id_4, t0.treatment_id AS treatment_id_5 FROM registry_treatment_shelf_life t0 WHERE t0.treatment_id IN ('04162185-6fa6-4cb8-a6df-8b3f2fb75d2c', '0a0c6eac-550f-4551-80e1-3a5a89168cb6', '20b59230-d0cc-42ef-873a-e695c9ea827e', '2ad5da4b-4881-40ed-8e61-84bdf339c758', '34645510-4aee-40e3-b4e5-d4e58e09d5cd', '5bcb637d-90f1-4303-92b5-79907e940af0', '65a14023-a748-4698-b486-6cf00efe0ecd', '734d8346-51df-4331-b8b7-df9c331e9f1b', '7d697ec4-8f78-4a07-a220-b53ad1121e37', '80d021b6-5638-489c-95a9-e36576bffe25', '8baf6081-3630-4bb3-84c1-7a472ef7c19d', '8c5000b6-0eb9-46e0-9bda-5e1ed4913e8c');