Symfony Profiler

SELECT
  DISTINCT id_21
FROM
  (
    SELECT
      DISTINCT id_21,
      date_0
    FROM
      (
        SELECT
          r0_.date AS date_0,
          r0_.updated_by AS updated_by_1,
          r0_.in_progress AS in_progress_2,
          r0_.violation_natures AS violation_natures_3,
          r0_.origins AS origins_4,
          r0_.cause AS cause_5,
          r0_.concerned_data_nature AS concerned_data_nature_6,
          r0_.concerned_people_categories AS concerned_people_categories_7,
          r0_.nb_affected_rows AS nb_affected_rows_8,
          r0_.nb_affected_persons AS nb_affected_persons_9,
          r0_.potential_impacts_nature AS potential_impacts_nature_10,
          r0_.gravity AS gravity_11,
          r0_.communication AS communication_12,
          r0_.communication_precision AS communication_precision_13,
          r0_.applied_measures_after_violation AS applied_measures_after_violation_14,
          r0_.notification AS notification_15,
          r0_.notification_details AS notification_details_16,
          r0_.comment AS comment_17,
          r0_.created_at AS created_at_18,
          r0_.updated_at AS updated_at_19,
          r0_.deleted_at AS deleted_at_20,
          r0_.id AS id_21,
          u1_.name AS name_22,
          u1_.short_name AS short_name_23,
          u1_.updated_by AS updated_by_24,
          u1_.type AS type_25,
          u1_.siren AS siren_26,
          u1_.active AS active_27,
          u1_.website AS website_28,
          u1_.different_dpo AS different_dpo_29,
          u1_.different_it_manager AS different_it_manager_30,
          u1_.is_services_enabled AS is_services_enabled_31,
          u1_.reporting_block_management_commitment AS reporting_block_management_commitment_32,
          u1_.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_33,
          u1_.has_module_conformite_traitement AS has_module_conformite_traitement_34,
          u1_.has_module_conformite_organisation AS has_module_conformite_organisation_35,
          u1_.has_module_tools AS has_module_tools_36,
          u1_.informations_complementaires AS informations_complementaires_37,
          u1_.finess_geo AS finess_geo_38,
          u1_.population AS population_39,
          u1_.nbr_agents AS nbr_agents_40,
          u1_.nbr_cnil AS nbr_cnil_41,
          u1_.created_at AS created_at_42,
          u1_.updated_at AS updated_at_43,
          u1_.id AS id_44,
          u1_.address_line_one AS address_line_one_45,
          u1_.address_line_two AS address_line_two_46,
          u1_.address_city AS address_city_47,
          u1_.address_zip_code AS address_zip_code_48,
          u1_.address_insee AS address_insee_49,
          u1_.legal_manager_civility AS legal_manager_civility_50,
          u1_.legal_manager_first_name AS legal_manager_first_name_51,
          u1_.legal_manager_last_name AS legal_manager_last_name_52,
          u1_.legal_manager_job AS legal_manager_job_53,
          u1_.legal_manager_mail AS legal_manager_mail_54,
          u1_.legal_manager_phone_number AS legal_manager_phone_number_55,
          u1_.legal_manager_notification AS legal_manager_notification_56,
          u1_.referent_civility AS referent_civility_57,
          u1_.referent_first_name AS referent_first_name_58,
          u1_.referent_last_name AS referent_last_name_59,
          u1_.referent_job AS referent_job_60,
          u1_.referent_mail AS referent_mail_61,
          u1_.referent_phone_number AS referent_phone_number_62,
          u1_.referent_notification AS referent_notification_63,
          u1_.dpo_civility AS dpo_civility_64,
          u1_.dpo_first_name AS dpo_first_name_65,
          u1_.dpo_last_name AS dpo_last_name_66,
          u1_.dpo_job AS dpo_job_67,
          u1_.dpo_mail AS dpo_mail_68,
          u1_.dpo_phone_number AS dpo_phone_number_69,
          u1_.dpo_notification AS dpo_notification_70,
          u1_.it_manager_civility AS it_manager_civility_71,
          u1_.it_manager_first_name AS it_manager_first_name_72,
          u1_.it_manager_last_name AS it_manager_last_name_73,
          u1_.it_manager_job AS it_manager_job_74,
          u1_.it_manager_mail AS it_manager_mail_75,
          u1_.it_manager_phone_number AS it_manager_phone_number_76,
          u1_.it_manager_notification AS it_manager_notification_77
        FROM
          registry_violation r0_
          LEFT JOIN user_collectivity u1_ ON r0_.collectivity_id = u1_.id
        WHERE
          r0_.deleted_at IS NULL
          AND r0_.collectivity_id = ?
      ) dctrn_result_inner
    ORDER BY
      date_0 ASC
  ) dctrn_result
LIMIT
  15

SELECT DISTINCT id_21 FROM (SELECT DISTINCT id_21, date_0 FROM (SELECT r0_.date AS date_0, r0_.updated_by AS updated_by_1, r0_.in_progress AS in_progress_2, r0_.violation_natures AS violation_natures_3, r0_.origins AS origins_4, r0_.cause AS cause_5, r0_.concerned_data_nature AS concerned_data_nature_6, r0_.concerned_people_categories AS concerned_people_categories_7, r0_.nb_affected_rows AS nb_affected_rows_8, r0_.nb_affected_persons AS nb_affected_persons_9, r0_.potential_impacts_nature AS potential_impacts_nature_10, r0_.gravity AS gravity_11, r0_.communication AS communication_12, r0_.communication_precision AS communication_precision_13, r0_.applied_measures_after_violation AS applied_measures_after_violation_14, r0_.notification AS notification_15, r0_.notification_details AS notification_details_16, r0_.comment AS comment_17, r0_.created_at AS created_at_18, r0_.updated_at AS updated_at_19, r0_.deleted_at AS deleted_at_20, r0_.id AS id_21, u1_.name AS name_22, u1_.short_name AS short_name_23, u1_.updated_by AS updated_by_24, u1_.type AS type_25, u1_.siren AS siren_26, u1_.active AS active_27, u1_.website AS website_28, u1_.different_dpo AS different_dpo_29, u1_.different_it_manager AS different_it_manager_30, u1_.is_services_enabled AS is_services_enabled_31, u1_.reporting_block_management_commitment AS reporting_block_management_commitment_32, u1_.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_33, u1_.has_module_conformite_traitement AS has_module_conformite_traitement_34, u1_.has_module_conformite_organisation AS has_module_conformite_organisation_35, u1_.has_module_tools AS has_module_tools_36, u1_.informations_complementaires AS informations_complementaires_37, u1_.finess_geo AS finess_geo_38, u1_.population AS population_39, u1_.nbr_agents AS nbr_agents_40, u1_.nbr_cnil AS nbr_cnil_41, u1_.created_at AS created_at_42, u1_.updated_at AS updated_at_43, u1_.id AS id_44, u1_.address_line_one AS address_line_one_45, u1_.address_line_two AS address_line_two_46, u1_.address_city AS address_city_47, u1_.address_zip_code AS address_zip_code_48, u1_.address_insee AS address_insee_49, u1_.legal_manager_civility AS legal_manager_civility_50, u1_.legal_manager_first_name AS legal_manager_first_name_51, u1_.legal_manager_last_name AS legal_manager_last_name_52, u1_.legal_manager_job AS legal_manager_job_53, u1_.legal_manager_mail AS legal_manager_mail_54, u1_.legal_manager_phone_number AS legal_manager_phone_number_55, u1_.legal_manager_notification AS legal_manager_notification_56, u1_.referent_civility AS referent_civility_57, u1_.referent_first_name AS referent_first_name_58, u1_.referent_last_name AS referent_last_name_59, u1_.referent_job AS referent_job_60, u1_.referent_mail AS referent_mail_61, u1_.referent_phone_number AS referent_phone_number_62, u1_.referent_notification AS referent_notification_63, u1_.dpo_civility AS dpo_civility_64, u1_.dpo_first_name AS dpo_first_name_65, u1_.dpo_last_name AS dpo_last_name_66, u1_.dpo_job AS dpo_job_67, u1_.dpo_mail AS dpo_mail_68, u1_.dpo_phone_number AS dpo_phone_number_69, u1_.dpo_notification AS dpo_notification_70, u1_.it_manager_civility AS it_manager_civility_71, u1_.it_manager_first_name AS it_manager_first_name_72, u1_.it_manager_last_name AS it_manager_last_name_73, u1_.it_manager_job AS it_manager_job_74, u1_.it_manager_mail AS it_manager_mail_75, u1_.it_manager_phone_number AS it_manager_phone_number_76, u1_.it_manager_notification AS it_manager_notification_77 FROM registry_violation r0_ LEFT JOIN user_collectivity u1_ ON r0_.collectivity_id = u1_.id WHERE r0_.deleted_at IS NULL AND r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34') dctrn_result_inner ORDER BY date_0 ASC) dctrn_result LIMIT 15;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_21
    FROM
      (
        SELECT
          r0_.date AS date_0,
          r0_.updated_by AS updated_by_1,
          r0_.in_progress AS in_progress_2,
          r0_.violation_natures AS violation_natures_3,
          r0_.origins AS origins_4,
          r0_.cause AS cause_5,
          r0_.concerned_data_nature AS concerned_data_nature_6,
          r0_.concerned_people_categories AS concerned_people_categories_7,
          r0_.nb_affected_rows AS nb_affected_rows_8,
          r0_.nb_affected_persons AS nb_affected_persons_9,
          r0_.potential_impacts_nature AS potential_impacts_nature_10,
          r0_.gravity AS gravity_11,
          r0_.communication AS communication_12,
          r0_.communication_precision AS communication_precision_13,
          r0_.applied_measures_after_violation AS applied_measures_after_violation_14,
          r0_.notification AS notification_15,
          r0_.notification_details AS notification_details_16,
          r0_.comment AS comment_17,
          r0_.created_at AS created_at_18,
          r0_.updated_at AS updated_at_19,
          r0_.deleted_at AS deleted_at_20,
          r0_.id AS id_21,
          u1_.name AS name_22,
          u1_.short_name AS short_name_23,
          u1_.updated_by AS updated_by_24,
          u1_.type AS type_25,
          u1_.siren AS siren_26,
          u1_.active AS active_27,
          u1_.website AS website_28,
          u1_.different_dpo AS different_dpo_29,
          u1_.different_it_manager AS different_it_manager_30,
          u1_.is_services_enabled AS is_services_enabled_31,
          u1_.reporting_block_management_commitment AS reporting_block_management_commitment_32,
          u1_.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_33,
          u1_.has_module_conformite_traitement AS has_module_conformite_traitement_34,
          u1_.has_module_conformite_organisation AS has_module_conformite_organisation_35,
          u1_.has_module_tools AS has_module_tools_36,
          u1_.informations_complementaires AS informations_complementaires_37,
          u1_.finess_geo AS finess_geo_38,
          u1_.population AS population_39,
          u1_.nbr_agents AS nbr_agents_40,
          u1_.nbr_cnil AS nbr_cnil_41,
          u1_.created_at AS created_at_42,
          u1_.updated_at AS updated_at_43,
          u1_.id AS id_44,
          u1_.address_line_one AS address_line_one_45,
          u1_.address_line_two AS address_line_two_46,
          u1_.address_city AS address_city_47,
          u1_.address_zip_code AS address_zip_code_48,
          u1_.address_insee AS address_insee_49,
          u1_.legal_manager_civility AS legal_manager_civility_50,
          u1_.legal_manager_first_name AS legal_manager_first_name_51,
          u1_.legal_manager_last_name AS legal_manager_last_name_52,
          u1_.legal_manager_job AS legal_manager_job_53,
          u1_.legal_manager_mail AS legal_manager_mail_54,
          u1_.legal_manager_phone_number AS legal_manager_phone_number_55,
          u1_.legal_manager_notification AS legal_manager_notification_56,
          u1_.referent_civility AS referent_civility_57,
          u1_.referent_first_name AS referent_first_name_58,
          u1_.referent_last_name AS referent_last_name_59,
          u1_.referent_job AS referent_job_60,
          u1_.referent_mail AS referent_mail_61,
          u1_.referent_phone_number AS referent_phone_number_62,
          u1_.referent_notification AS referent_notification_63,
          u1_.dpo_civility AS dpo_civility_64,
          u1_.dpo_first_name AS dpo_first_name_65,
          u1_.dpo_last_name AS dpo_last_name_66,
          u1_.dpo_job AS dpo_job_67,
          u1_.dpo_mail AS dpo_mail_68,
          u1_.dpo_phone_number AS dpo_phone_number_69,
          u1_.dpo_notification AS dpo_notification_70,
          u1_.it_manager_civility AS it_manager_civility_71,
          u1_.it_manager_first_name AS it_manager_first_name_72,
          u1_.it_manager_last_name AS it_manager_last_name_73,
          u1_.it_manager_job AS it_manager_job_74,
          u1_.it_manager_mail AS it_manager_mail_75,
          u1_.it_manager_phone_number AS it_manager_phone_number_76,
          u1_.it_manager_notification AS it_manager_notification_77
        FROM
          registry_violation r0_
          LEFT JOIN user_collectivity u1_ ON r0_.collectivity_id = u1_.id
        WHERE
          r0_.deleted_at IS NULL
          AND r0_.collectivity_id = ?
        ORDER BY
          r0_.date ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_21 FROM (SELECT r0_.date AS date_0, r0_.updated_by AS updated_by_1, r0_.in_progress AS in_progress_2, r0_.violation_natures AS violation_natures_3, r0_.origins AS origins_4, r0_.cause AS cause_5, r0_.concerned_data_nature AS concerned_data_nature_6, r0_.concerned_people_categories AS concerned_people_categories_7, r0_.nb_affected_rows AS nb_affected_rows_8, r0_.nb_affected_persons AS nb_affected_persons_9, r0_.potential_impacts_nature AS potential_impacts_nature_10, r0_.gravity AS gravity_11, r0_.communication AS communication_12, r0_.communication_precision AS communication_precision_13, r0_.applied_measures_after_violation AS applied_measures_after_violation_14, r0_.notification AS notification_15, r0_.notification_details AS notification_details_16, r0_.comment AS comment_17, r0_.created_at AS created_at_18, r0_.updated_at AS updated_at_19, r0_.deleted_at AS deleted_at_20, r0_.id AS id_21, u1_.name AS name_22, u1_.short_name AS short_name_23, u1_.updated_by AS updated_by_24, u1_.type AS type_25, u1_.siren AS siren_26, u1_.active AS active_27, u1_.website AS website_28, u1_.different_dpo AS different_dpo_29, u1_.different_it_manager AS different_it_manager_30, u1_.is_services_enabled AS is_services_enabled_31, u1_.reporting_block_management_commitment AS reporting_block_management_commitment_32, u1_.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_33, u1_.has_module_conformite_traitement AS has_module_conformite_traitement_34, u1_.has_module_conformite_organisation AS has_module_conformite_organisation_35, u1_.has_module_tools AS has_module_tools_36, u1_.informations_complementaires AS informations_complementaires_37, u1_.finess_geo AS finess_geo_38, u1_.population AS population_39, u1_.nbr_agents AS nbr_agents_40, u1_.nbr_cnil AS nbr_cnil_41, u1_.created_at AS created_at_42, u1_.updated_at AS updated_at_43, u1_.id AS id_44, u1_.address_line_one AS address_line_one_45, u1_.address_line_two AS address_line_two_46, u1_.address_city AS address_city_47, u1_.address_zip_code AS address_zip_code_48, u1_.address_insee AS address_insee_49, u1_.legal_manager_civility AS legal_manager_civility_50, u1_.legal_manager_first_name AS legal_manager_first_name_51, u1_.legal_manager_last_name AS legal_manager_last_name_52, u1_.legal_manager_job AS legal_manager_job_53, u1_.legal_manager_mail AS legal_manager_mail_54, u1_.legal_manager_phone_number AS legal_manager_phone_number_55, u1_.legal_manager_notification AS legal_manager_notification_56, u1_.referent_civility AS referent_civility_57, u1_.referent_first_name AS referent_first_name_58, u1_.referent_last_name AS referent_last_name_59, u1_.referent_job AS referent_job_60, u1_.referent_mail AS referent_mail_61, u1_.referent_phone_number AS referent_phone_number_62, u1_.referent_notification AS referent_notification_63, u1_.dpo_civility AS dpo_civility_64, u1_.dpo_first_name AS dpo_first_name_65, u1_.dpo_last_name AS dpo_last_name_66, u1_.dpo_job AS dpo_job_67, u1_.dpo_mail AS dpo_mail_68, u1_.dpo_phone_number AS dpo_phone_number_69, u1_.dpo_notification AS dpo_notification_70, u1_.it_manager_civility AS it_manager_civility_71, u1_.it_manager_first_name AS it_manager_first_name_72, u1_.it_manager_last_name AS it_manager_last_name_73, u1_.it_manager_job AS it_manager_job_74, u1_.it_manager_mail AS it_manager_mail_75, u1_.it_manager_phone_number AS it_manager_phone_number_76, u1_.it_manager_notification AS it_manager_notification_77 FROM registry_violation r0_ LEFT JOIN user_collectivity u1_ ON r0_.collectivity_id = u1_.id WHERE r0_.deleted_at IS NULL AND r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' ORDER BY r0_.date ASC) dctrn_result) dctrn_table;

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 = '86fac903-653c-4833-8cf8-186f5c055e59';

SELECT
  r0_.date AS date_0,
  r0_.updated_by AS updated_by_1,
  r0_.in_progress AS in_progress_2,
  r0_.violation_natures AS violation_natures_3,
  r0_.origins AS origins_4,
  r0_.cause AS cause_5,
  r0_.concerned_data_nature AS concerned_data_nature_6,
  r0_.concerned_people_categories AS concerned_people_categories_7,
  r0_.nb_affected_rows AS nb_affected_rows_8,
  r0_.nb_affected_persons AS nb_affected_persons_9,
  r0_.potential_impacts_nature AS potential_impacts_nature_10,
  r0_.gravity AS gravity_11,
  r0_.communication AS communication_12,
  r0_.communication_precision AS communication_precision_13,
  r0_.applied_measures_after_violation AS applied_measures_after_violation_14,
  r0_.notification AS notification_15,
  r0_.notification_details AS notification_details_16,
  r0_.comment AS comment_17,
  r0_.created_at AS created_at_18,
  r0_.updated_at AS updated_at_19,
  r0_.deleted_at AS deleted_at_20,
  r0_.id AS id_21,
  u1_.name AS name_22,
  u1_.short_name AS short_name_23,
  u1_.updated_by AS updated_by_24,
  u1_.type AS type_25,
  u1_.siren AS siren_26,
  u1_.active AS active_27,
  u1_.website AS website_28,
  u1_.different_dpo AS different_dpo_29,
  u1_.different_it_manager AS different_it_manager_30,
  u1_.is_services_enabled AS is_services_enabled_31,
  u1_.reporting_block_management_commitment AS reporting_block_management_commitment_32,
  u1_.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_33,
  u1_.has_module_conformite_traitement AS has_module_conformite_traitement_34,
  u1_.has_module_conformite_organisation AS has_module_conformite_organisation_35,
  u1_.has_module_tools AS has_module_tools_36,
  u1_.informations_complementaires AS informations_complementaires_37,
  u1_.finess_geo AS finess_geo_38,
  u1_.population AS population_39,
  u1_.nbr_agents AS nbr_agents_40,
  u1_.nbr_cnil AS nbr_cnil_41,
  u1_.created_at AS created_at_42,
  u1_.updated_at AS updated_at_43,
  u1_.id AS id_44,
  u1_.address_line_one AS address_line_one_45,
  u1_.address_line_two AS address_line_two_46,
  u1_.address_city AS address_city_47,
  u1_.address_zip_code AS address_zip_code_48,
  u1_.address_insee AS address_insee_49,
  u1_.legal_manager_civility AS legal_manager_civility_50,
  u1_.legal_manager_first_name AS legal_manager_first_name_51,
  u1_.legal_manager_last_name AS legal_manager_last_name_52,
  u1_.legal_manager_job AS legal_manager_job_53,
  u1_.legal_manager_mail AS legal_manager_mail_54,
  u1_.legal_manager_phone_number AS legal_manager_phone_number_55,
  u1_.legal_manager_notification AS legal_manager_notification_56,
  u1_.referent_civility AS referent_civility_57,
  u1_.referent_first_name AS referent_first_name_58,
  u1_.referent_last_name AS referent_last_name_59,
  u1_.referent_job AS referent_job_60,
  u1_.referent_mail AS referent_mail_61,
  u1_.referent_phone_number AS referent_phone_number_62,
  u1_.referent_notification AS referent_notification_63,
  u1_.dpo_civility AS dpo_civility_64,
  u1_.dpo_first_name AS dpo_first_name_65,
  u1_.dpo_last_name AS dpo_last_name_66,
  u1_.dpo_job AS dpo_job_67,
  u1_.dpo_mail AS dpo_mail_68,
  u1_.dpo_phone_number AS dpo_phone_number_69,
  u1_.dpo_notification AS dpo_notification_70,
  u1_.it_manager_civility AS it_manager_civility_71,
  u1_.it_manager_first_name AS it_manager_first_name_72,
  u1_.it_manager_last_name AS it_manager_last_name_73,
  u1_.it_manager_job AS it_manager_job_74,
  u1_.it_manager_mail AS it_manager_mail_75,
  u1_.it_manager_phone_number AS it_manager_phone_number_76,
  u1_.it_manager_notification AS it_manager_notification_77,
  r0_.service_id AS service_id_78,
  r0_.collectivity_id AS collectivity_id_79,
  r0_.creator_id AS creator_id_80
FROM
  registry_violation r0_
  LEFT JOIN user_collectivity u1_ ON r0_.collectivity_id = u1_.id
WHERE
  r0_.deleted_at IS NULL
  AND r0_.collectivity_id = ?
  AND r0_.id IN (?)
ORDER BY
  r0_.date ASC

SELECT r0_.date AS date_0, r0_.updated_by AS updated_by_1, r0_.in_progress AS in_progress_2, r0_.violation_natures AS violation_natures_3, r0_.origins AS origins_4, r0_.cause AS cause_5, r0_.concerned_data_nature AS concerned_data_nature_6, r0_.concerned_people_categories AS concerned_people_categories_7, r0_.nb_affected_rows AS nb_affected_rows_8, r0_.nb_affected_persons AS nb_affected_persons_9, r0_.potential_impacts_nature AS potential_impacts_nature_10, r0_.gravity AS gravity_11, r0_.communication AS communication_12, r0_.communication_precision AS communication_precision_13, r0_.applied_measures_after_violation AS applied_measures_after_violation_14, r0_.notification AS notification_15, r0_.notification_details AS notification_details_16, r0_.comment AS comment_17, r0_.created_at AS created_at_18, r0_.updated_at AS updated_at_19, r0_.deleted_at AS deleted_at_20, r0_.id AS id_21, u1_.name AS name_22, u1_.short_name AS short_name_23, u1_.updated_by AS updated_by_24, u1_.type AS type_25, u1_.siren AS siren_26, u1_.active AS active_27, u1_.website AS website_28, u1_.different_dpo AS different_dpo_29, u1_.different_it_manager AS different_it_manager_30, u1_.is_services_enabled AS is_services_enabled_31, u1_.reporting_block_management_commitment AS reporting_block_management_commitment_32, u1_.reporting_block_continuous_improvement AS reporting_block_continuous_improvement_33, u1_.has_module_conformite_traitement AS has_module_conformite_traitement_34, u1_.has_module_conformite_organisation AS has_module_conformite_organisation_35, u1_.has_module_tools AS has_module_tools_36, u1_.informations_complementaires AS informations_complementaires_37, u1_.finess_geo AS finess_geo_38, u1_.population AS population_39, u1_.nbr_agents AS nbr_agents_40, u1_.nbr_cnil AS nbr_cnil_41, u1_.created_at AS created_at_42, u1_.updated_at AS updated_at_43, u1_.id AS id_44, u1_.address_line_one AS address_line_one_45, u1_.address_line_two AS address_line_two_46, u1_.address_city AS address_city_47, u1_.address_zip_code AS address_zip_code_48, u1_.address_insee AS address_insee_49, u1_.legal_manager_civility AS legal_manager_civility_50, u1_.legal_manager_first_name AS legal_manager_first_name_51, u1_.legal_manager_last_name AS legal_manager_last_name_52, u1_.legal_manager_job AS legal_manager_job_53, u1_.legal_manager_mail AS legal_manager_mail_54, u1_.legal_manager_phone_number AS legal_manager_phone_number_55, u1_.legal_manager_notification AS legal_manager_notification_56, u1_.referent_civility AS referent_civility_57, u1_.referent_first_name AS referent_first_name_58, u1_.referent_last_name AS referent_last_name_59, u1_.referent_job AS referent_job_60, u1_.referent_mail AS referent_mail_61, u1_.referent_phone_number AS referent_phone_number_62, u1_.referent_notification AS referent_notification_63, u1_.dpo_civility AS dpo_civility_64, u1_.dpo_first_name AS dpo_first_name_65, u1_.dpo_last_name AS dpo_last_name_66, u1_.dpo_job AS dpo_job_67, u1_.dpo_mail AS dpo_mail_68, u1_.dpo_phone_number AS dpo_phone_number_69, u1_.dpo_notification AS dpo_notification_70, u1_.it_manager_civility AS it_manager_civility_71, u1_.it_manager_first_name AS it_manager_first_name_72, u1_.it_manager_last_name AS it_manager_last_name_73, u1_.it_manager_job AS it_manager_job_74, u1_.it_manager_mail AS it_manager_mail_75, u1_.it_manager_phone_number AS it_manager_phone_number_76, u1_.it_manager_notification AS it_manager_notification_77, r0_.service_id AS service_id_78, r0_.collectivity_id AS collectivity_id_79, r0_.creator_id AS creator_id_80 FROM registry_violation r0_ LEFT JOIN user_collectivity u1_ ON r0_.collectivity_id = u1_.id WHERE r0_.deleted_at IS NULL AND r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34' AND r0_.id IN ('775d02a8-21e4-4b0b-a570-88f6cb8f1f11') ORDER BY r0_.date ASC;

SELECT
  count(r0_.id) AS sclr_0
FROM
  registry_violation r0_
WHERE
  r0_.deleted_at IS NULL
  AND r0_.collectivity_id = ?

SELECT count(r0_.id) AS sclr_0 FROM registry_violation r0_ WHERE r0_.deleted_at IS NULL AND r0_.collectivity_id = 'a5d81ae2-8425-4fa2-bad0-38e205ee2b34';

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 = '86fac903-653c-4833-8cf8-186f5c055e59';