Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.totp_secret AS totp_secret_4,
  u0_.totp_recovery_codes AS totp_recovery_codes_5,
  u0_.firstname AS firstname_6,
  u0_.lastname AS lastname_7,
  u0_.birthdate AS birthdate_8,
  u0_.engagement_start_date AS engagement_start_date_9,
  u0_.email AS email_10,
  u0_.sdis_email AS sdis_email_11,
  u0_.hierarchical_rank AS hierarchical_rank_12,
  u0_.birth_place AS birth_place_13,
  u0_.address AS address_14,
  u0_.city AS city_15,
  u0_.zip_code AS zip_code_16,
  u0_.civil_status AS civil_status_17,
  u0_.land_line_phone_number AS land_line_phone_number_18,
  u0_.mobile_phone_number AS mobile_phone_number_19,
  u0_.partner_firstname AS partner_firstname_20,
  u0_.partner_lastname AS partner_lastname_21,
  u0_.number_of_children AS number_of_children_22,
  u0_.maiden_name AS maiden_name_23,
  u0_.gender AS gender_24,
  u0_.personnel_number AS personnel_number_25,
  u0_.profile_sheet AS profile_sheet_26,
  u0_.portrait AS portrait_27,
  u0_.is_active AS is_active_28,
  u0_.is_retired AS is_retired_29,
  u0_.latitude AS latitude_30,
  u0_.longitude AS longitude_31,
  u0_.address_geocoded_at AS address_geocoded_at_32,
  u0_.password_changed_at AS password_changed_at_33,
  u0_.temporary_password_expires_at AS temporary_password_expires_at_34,
  u0_.login_count AS login_count_35,
  u0_.last_login_at AS last_login_at_36,
  u0_.last_seen_at AS last_seen_at_37,
  a1_.id AS id_38,
  a1_.label AS label_39,
  a1_.code AS code_40,
  a1_.locked AS locked_41,
  a1_.sort_order AS sort_order_42,
  a1_.pages AS pages_43,
  c2_.id AS id_44,
  c2_.group_key AS group_key_45,
  c2_.label AS label_46,
  c2_.max_holders AS max_holders_47,
  c2_.sort_order AS sort_order_48,
  c2_.managed_by AS managed_by_49,
  u3_.id AS id_50,
  u3_.page_code AS page_code_51,
  u3_.granted AS granted_52,
  o4_.id AS id_53,
  o4_.number AS number_54,
  o4_.logo AS logo_55,
  o4_.color AS color_56,
  u0_.operational_team_id AS operational_team_id_57,
  a1_.center_function_id AS center_function_id_58,
  c2_.parent_id AS parent_id_59,
  u3_.user_id AS user_id_60
FROM
  `user` u0_
  LEFT JOIN access_role_user a5_ ON u0_.id = a5_.user_id
  LEFT JOIN access_role a1_ ON a1_.id = a5_.access_role_id
  LEFT JOIN center_function_user c6_ ON u0_.id = c6_.user_id
  LEFT JOIN center_function c2_ ON c2_.id = c6_.center_function_id
  LEFT JOIN user_page_override u3_ ON u0_.id = u3_.user_id
  LEFT JOIN operational_team o4_ ON u0_.operational_team_id = o4_.id
WHERE
  u0_.username = ?

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.totp_secret AS totp_secret_4, u0_.totp_recovery_codes AS totp_recovery_codes_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7, u0_.birthdate AS birthdate_8, u0_.engagement_start_date AS engagement_start_date_9, u0_.email AS email_10, u0_.sdis_email AS sdis_email_11, u0_.hierarchical_rank AS hierarchical_rank_12, u0_.birth_place AS birth_place_13, u0_.address AS address_14, u0_.city AS city_15, u0_.zip_code AS zip_code_16, u0_.civil_status AS civil_status_17, u0_.land_line_phone_number AS land_line_phone_number_18, u0_.mobile_phone_number AS mobile_phone_number_19, u0_.partner_firstname AS partner_firstname_20, u0_.partner_lastname AS partner_lastname_21, u0_.number_of_children AS number_of_children_22, u0_.maiden_name AS maiden_name_23, u0_.gender AS gender_24, u0_.personnel_number AS personnel_number_25, u0_.profile_sheet AS profile_sheet_26, u0_.portrait AS portrait_27, u0_.is_active AS is_active_28, u0_.is_retired AS is_retired_29, u0_.latitude AS latitude_30, u0_.longitude AS longitude_31, u0_.address_geocoded_at AS address_geocoded_at_32, u0_.password_changed_at AS password_changed_at_33, u0_.temporary_password_expires_at AS temporary_password_expires_at_34, u0_.login_count AS login_count_35, u0_.last_login_at AS last_login_at_36, u0_.last_seen_at AS last_seen_at_37, a1_.id AS id_38, a1_.label AS label_39, a1_.code AS code_40, a1_.locked AS locked_41, a1_.sort_order AS sort_order_42, a1_.pages AS pages_43, c2_.id AS id_44, c2_.group_key AS group_key_45, c2_.label AS label_46, c2_.max_holders AS max_holders_47, c2_.sort_order AS sort_order_48, c2_.managed_by AS managed_by_49, u3_.id AS id_50, u3_.page_code AS page_code_51, u3_.granted AS granted_52, o4_.id AS id_53, o4_.number AS number_54, o4_.logo AS logo_55, o4_.color AS color_56, u0_.operational_team_id AS operational_team_id_57, a1_.center_function_id AS center_function_id_58, c2_.parent_id AS parent_id_59, u3_.user_id AS user_id_60 FROM `user` u0_ LEFT JOIN access_role_user a5_ ON u0_.id = a5_.user_id LEFT JOIN access_role a1_ ON a1_.id = a5_.access_role_id LEFT JOIN center_function_user c6_ ON u0_.id = c6_.user_id LEFT JOIN center_function c2_ ON c2_.id = c6_.center_function_id LEFT JOIN user_page_override u3_ ON u0_.id = u3_.user_id LEFT JOIN operational_team o4_ ON u0_.operational_team_id = o4_.id WHERE u0_.username = 'vguillard';

UPDATE
  `user`
SET
  password = ?
WHERE
  id = ?

UPDATE `user` SET password = '!expired!61e021d089096b358e50ff50bed24cf1' WHERE id = 21;

INSERT INTO login_attempt (
  identifier, success, locked, step,
  ip, created_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO login_attempt (identifier, success, locked, step, ip, created_at, user_id) VALUES ('vguillard', 0, 0, 'mot de passe', '92.184.144.135', '2026-10-23 19:31:19', 21);

"START TRANSACTION"

"START TRANSACTION";