Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.linkedAt AS linkedAt_1,
  o0_.lastLoginAt AS lastLoginAt_2,
  o0_.providerCode AS providerCode_3,
  o0_.subject AS subject_4,
  o1_.id AS id_5,
  o1_.email AS email_6,
  o1_.enabled AS enabled_7,
  o1_.salt AS salt_8,
  o1_.password AS password_9,
  o1_.last_login AS last_login_10,
  o1_.confirmation_token AS confirmation_token_11,
  o1_.password_requested_at AS password_requested_at_12,
  o1_.roles AS roles_13,
  o1_.username AS username_14,
  o1_.nom AS nom_15,
  o1_.prenom AS prenom_16,
  o1_.fonction AS fonction_17,
  o1_.tel AS tel_18,
  o1_.mobile AS mobile_19,
  o1_.activation AS activation_20,
  o1_.createdAt AS createdAt_21,
  o1_.updatedAt AS updatedAt_22,
  o1_.optin AS optin_23,
  o1_.dateActivation AS dateActivation_24,
  o1_.emailValidatedDateTime AS emailValidatedDateTime_25,
  o1_.emailCreatedDateTime AS emailCreatedDateTime_26,
  o1_.mobileCreatedDatetime AS mobileCreatedDatetime_27,
  o1_.sendEmail AS sendEmail_28,
  o1_.scope AS scope_29,
  o1_.isArchived AS isArchived_30,
  o1_.import AS import_31,
  o1_.neoSpaceEnabled AS neoSpaceEnabled_32,
  o1_.email_canonical AS email_canonical_33,
  o1_.username_canonical AS username_canonical_34,
  o0_.oblige_user_id AS oblige_user_id_35,
  o1_.oblige_id AS oblige_id_36
FROM
  ObligeUserSsoIdentity o0_
  INNER JOIN ObligeUser o1_ ON o0_.oblige_user_id = o1_.id
WHERE
  o0_.providerCode = ?
  AND o0_.subject = ?

SELECT o0_.id AS id_0, o0_.linkedAt AS linkedAt_1, o0_.lastLoginAt AS lastLoginAt_2, o0_.providerCode AS providerCode_3, o0_.subject AS subject_4, o1_.id AS id_5, o1_.email AS email_6, o1_.enabled AS enabled_7, o1_.salt AS salt_8, o1_.password AS password_9, o1_.last_login AS last_login_10, o1_.confirmation_token AS confirmation_token_11, o1_.password_requested_at AS password_requested_at_12, o1_.roles AS roles_13, o1_.username AS username_14, o1_.nom AS nom_15, o1_.prenom AS prenom_16, o1_.fonction AS fonction_17, o1_.tel AS tel_18, o1_.mobile AS mobile_19, o1_.activation AS activation_20, o1_.createdAt AS createdAt_21, o1_.updatedAt AS updatedAt_22, o1_.optin AS optin_23, o1_.dateActivation AS dateActivation_24, o1_.emailValidatedDateTime AS emailValidatedDateTime_25, o1_.emailCreatedDateTime AS emailCreatedDateTime_26, o1_.mobileCreatedDatetime AS mobileCreatedDatetime_27, o1_.sendEmail AS sendEmail_28, o1_.scope AS scope_29, o1_.isArchived AS isArchived_30, o1_.import AS import_31, o1_.neoSpaceEnabled AS neoSpaceEnabled_32, o1_.email_canonical AS email_canonical_33, o1_.username_canonical AS username_canonical_34, o0_.oblige_user_id AS oblige_user_id_35, o1_.oblige_id AS oblige_id_36 FROM ObligeUserSsoIdentity o0_ INNER JOIN ObligeUser o1_ ON o0_.oblige_user_id = o1_.id WHERE o0_.providerCode = 'consoneo' AND o0_.subject = '3cb8e1c9-bd51-4c67-831d-7af79865f528';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.enabled AS enabled_3,
  t0.salt AS salt_4,
  t0.password AS password_5,
  t0.last_login AS last_login_6,
  t0.confirmation_token AS confirmation_token_7,
  t0.password_requested_at AS password_requested_at_8,
  t0.roles AS roles_9,
  t0.username AS username_10,
  t0.nom AS nom_11,
  t0.prenom AS prenom_12,
  t0.fonction AS fonction_13,
  t0.tel AS tel_14,
  t0.mobile AS mobile_15,
  t0.activation AS activation_16,
  t0.createdAt AS createdAt_17,
  t0.updatedAt AS updatedAt_18,
  t0.optin AS optin_19,
  t0.dateActivation AS dateActivation_20,
  t0.emailValidatedDateTime AS emailValidatedDateTime_21,
  t0.emailCreatedDateTime AS emailCreatedDateTime_22,
  t0.mobileCreatedDatetime AS mobileCreatedDatetime_23,
  t0.sendEmail AS sendEmail_24,
  t0.scope AS scope_25,
  t0.isArchived AS isArchived_26,
  t0.import AS import_27,
  t0.neoSpaceEnabled AS neoSpaceEnabled_28,
  t0.email_canonical AS email_canonical_29,
  t0.username_canonical AS username_canonical_30,
  t0.oblige_id AS oblige_id_31
FROM
  ObligeUser t0
WHERE
  t0.email_canonical = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.roles AS roles_9, t0.username AS username_10, t0.nom AS nom_11, t0.prenom AS prenom_12, t0.fonction AS fonction_13, t0.tel AS tel_14, t0.mobile AS mobile_15, t0.activation AS activation_16, t0.createdAt AS createdAt_17, t0.updatedAt AS updatedAt_18, t0.optin AS optin_19, t0.dateActivation AS dateActivation_20, t0.emailValidatedDateTime AS emailValidatedDateTime_21, t0.emailCreatedDateTime AS emailCreatedDateTime_22, t0.mobileCreatedDatetime AS mobileCreatedDatetime_23, t0.sendEmail AS sendEmail_24, t0.scope AS scope_25, t0.isArchived AS isArchived_26, t0.import AS import_27, t0.neoSpaceEnabled AS neoSpaceEnabled_28, t0.email_canonical AS email_canonical_29, t0.username_canonical AS username_canonical_30, t0.oblige_id AS oblige_id_31 FROM ObligeUser t0 WHERE t0.email_canonical = '[email protected]';

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.providerCode AS providerCode_3,
  t0.mode AS mode_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t0.oblige_id AS oblige_id_7
FROM
  SsoObligeConfig t0
WHERE
  t0.oblige_id = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.providerCode AS providerCode_3, t0.mode AS mode_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.oblige_id AS oblige_id_7 FROM SsoObligeConfig t0 WHERE t0.oblige_id = 2 AND t0.enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.providerCode AS providerCode_3,
  t0.mode AS mode_4,
  t0.createdAt AS createdAt_5,
  t0.updatedAt AS updatedAt_6,
  t0.oblige_id AS oblige_id_7
FROM
  SsoObligeConfig t0
WHERE
  t0.oblige_id = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.providerCode AS providerCode_3, t0.mode AS mode_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.oblige_id AS oblige_id_7 FROM SsoObligeConfig t0 WHERE t0.oblige_id = 2 AND t0.enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.linkedAt AS linkedAt_2,
  t0.lastLoginAt AS lastLoginAt_3,
  t0.providerCode AS providerCode_4,
  t0.subject AS subject_5,
  t0.oblige_user_id AS oblige_user_id_6
FROM
  ObligeUserSsoIdentity t0
WHERE
  t0.oblige_user_id = ?
  AND t0.providerCode = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.linkedAt AS linkedAt_2, t0.lastLoginAt AS lastLoginAt_3, t0.providerCode AS providerCode_4, t0.subject AS subject_5, t0.oblige_user_id AS oblige_user_id_6 FROM ObligeUserSsoIdentity t0 WHERE t0.oblige_user_id = 1845 AND t0.providerCode = 'consoneo' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ObligeUserSsoIdentity (
  linkedAt, lastLoginAt, providerCode,
  subject, oblige_user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO ObligeUserSsoIdentity (linkedAt, lastLoginAt, providerCode, subject, oblige_user_id) VALUES ('2026-10-09 17:28:50', '2026-10-09 17:28:50', 'consoneo', '3cb8e1c9-bd51-4c67-831d-7af79865f528', 1845);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.obligeRole_id AS obligeRole_id_3,
  t4.id AS id_5,
  t4.role AS role_6,
  t4.title AS title_7,
  t4.scope AS scope_8,
  t4.position AS position_9,
  t4.definition AS definition_10,
  t4.cycle AS cycle_11,
  t4.only_consoneo_update AS only_consoneo_update_12,
  t0.teteReseau_id AS teteReseau_id_13
FROM
  RegleRole t0
  LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id
  INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId
WHERE
  RegleRole_ObligeUser.userId = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.obligeRole_id AS obligeRole_id_3, t4.id AS id_5, t4.role AS role_6, t4.title AS title_7, t4.scope AS scope_8, t4.position AS position_9, t4.definition AS definition_10, t4.cycle AS cycle_11, t4.only_consoneo_update AS only_consoneo_update_12, t0.teteReseau_id AS teteReseau_id_13 FROM RegleRole t0 LEFT JOIN ObligeRole t4 ON t0.obligeRole_id = t4.id INNER JOIN RegleRole_ObligeUser ON t0.id = RegleRole_ObligeUser.regleRoleId WHERE RegleRole_ObligeUser.userId = 1845;