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.email = ?
LIMIT
  1

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.email = 'ldecavel+efficience@dpo-partage.fr' LIMIT 1;

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 = '53ce2119-cf0d-4f5f-84d2-6f1b99492e50';

SELECT
  l0_.attempts AS attempts_0,
  l0_.email AS email_1,
  l0_.ip AS ip_2,
  l0_.id AS id_3
FROM
  login_attempt l0_
WHERE
  l0_.ip = ?
  AND l0_.email = ?

SELECT l0_.attempts AS attempts_0, l0_.email AS email_1, l0_.ip AS ip_2, l0_.id AS id_3 FROM login_attempt l0_ WHERE l0_.ip = '88.169.2.72' AND l0_.email = 'ldecavel+efficience@dpo-partage.fr';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  login_attempt
SET
  attempts = ?
WHERE
  id = ?

UPDATE login_attempt SET attempts = 0 WHERE id = 'e080c394-92cc-45e5-8715-0ddce32860eb';

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO reporting_log_journal (
  date, action, user_full_name, user_email,
  subject_type, subject_id, subject_name,
  is_deleted, id, collectivity_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO reporting_log_journal (date, action, user_full_name, user_email, subject_type, subject_id, subject_name, is_deleted, id, collectivity_id) VALUES ('2024-03-20 13:28:52', 'login', 'Laurent DE CAVEL', 'ldecavel+efficience@dpo-partage.fr', 'user_user', '53ce2119-cf0d-4f5f-84d2-6f1b99492e50', 'Laurent DE CAVEL', 0, 'ebeb0e50-b438-4bec-94f8-3a92f2213659', '274f047b-6454-466a-bf9b-ee238c29ed00');

UPDATE
  user_user
SET
  last_login = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user_user SET last_login = '2024-03-20 13:28:52', updated_at = '2024-03-20 13:28:52' WHERE id = '53ce2119-cf0d-4f5f-84d2-6f1b99492e50';

"COMMIT"

"COMMIT";