Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar AS avatar_7,
  t0.job_position AS job_position_8,
  t0.mailbox_view_mode AS mailbox_view_mode_9,
  t0.timezone AS timezone_10,
  t0.created_at AS created_at_11,
  t0.activation_token AS activation_token_12,
  t0.activation_token_expires_at AS activation_token_expires_at_13,
  t0.reset_token AS reset_token_14,
  t0.reset_token_expires_at AS reset_token_expires_at_15,
  t0.is_active AS is_active_16,
  t0.employment_end_date AS employment_end_date_17,
  t0.deactivated_at AS deactivated_at_18,
  t0.notifications_read_at AS notifications_read_at_19,
  t0.dashboard_layout AS dashboard_layout_20,
  t0.last_seen_at AS last_seen_at_21,
  t0.totp_secret AS totp_secret_22,
  t0.totp_enabled AS totp_enabled_23,
  t0.totp_enabled_at AS totp_enabled_at_24,
  t0.sip_extension AS sip_extension_25,
  t0.voip_enabled AS voip_enabled_26,
  t0.can_call_external AS can_call_external_27,
  t0.sip_secret_encrypted AS sip_secret_encrypted_28,
  t0.mailbox_limit AS mailbox_limit_29,
  t0.mail_storage_quota_mb AS mail_storage_quota_mb_30,
  t0.quota_suspended_at AS quota_suspended_at_31,
  t0.quota_locked AS quota_locked_32,
  t0.company_id AS company_id_33
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar AS avatar_7, t0.job_position AS job_position_8, t0.mailbox_view_mode AS mailbox_view_mode_9, t0.timezone AS timezone_10, t0.created_at AS created_at_11, t0.activation_token AS activation_token_12, t0.activation_token_expires_at AS activation_token_expires_at_13, t0.reset_token AS reset_token_14, t0.reset_token_expires_at AS reset_token_expires_at_15, t0.is_active AS is_active_16, t0.employment_end_date AS employment_end_date_17, t0.deactivated_at AS deactivated_at_18, t0.notifications_read_at AS notifications_read_at_19, t0.dashboard_layout AS dashboard_layout_20, t0.last_seen_at AS last_seen_at_21, t0.totp_secret AS totp_secret_22, t0.totp_enabled AS totp_enabled_23, t0.totp_enabled_at AS totp_enabled_at_24, t0.sip_extension AS sip_extension_25, t0.voip_enabled AS voip_enabled_26, t0.can_call_external AS can_call_external_27, t0.sip_secret_encrypted AS sip_secret_encrypted_28, t0.mailbox_limit AS mailbox_limit_29, t0.mail_storage_quota_mb AS mail_storage_quota_mb_30, t0.quota_suspended_at AS quota_suspended_at_31, t0.quota_locked AS quota_locked_32, t0.company_id AS company_id_33 FROM `user` t0 WHERE t0.id = 9;

SELECT
  u0_.id AS id_0,
  u0_.is_default AS is_default_1,
  u0_.platform_role AS platform_role_2,
  u0_.permission_overrides AS permission_overrides_3,
  u0_.created_at AS created_at_4,
  t1_.id AS id_5,
  t1_.name AS name_6,
  t1_.slug AS slug_7,
  t1_.is_active AS is_active_8,
  t1_.is_platform AS is_platform_9,
  t1_.created_at AS created_at_10,
  t1_.user_slots_pool AS user_slots_pool_11,
  t1_.mailbox_slots_pool AS mailbox_slots_pool_12,
  t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13,
  t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14,
  t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15,
  t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16,
  t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17,
  u0_.user_id AS user_id_18,
  u0_.tenant_id AS tenant_id_19
FROM
  user_tenant u0_
  INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id
WHERE
  u0_.user_id = ?
  AND t1_.is_active = 1
ORDER BY
  u0_.is_default DESC,
  t1_.name ASC

SELECT u0_.id AS id_0, u0_.is_default AS is_default_1, u0_.platform_role AS platform_role_2, u0_.permission_overrides AS permission_overrides_3, u0_.created_at AS created_at_4, t1_.id AS id_5, t1_.name AS name_6, t1_.slug AS slug_7, t1_.is_active AS is_active_8, t1_.is_platform AS is_platform_9, t1_.created_at AS created_at_10, t1_.user_slots_pool AS user_slots_pool_11, t1_.mailbox_slots_pool AS mailbox_slots_pool_12, t1_.microsoft_oauth_enabled AS microsoft_oauth_enabled_13, t1_.microsoft_oauth_tenant_id AS microsoft_oauth_tenant_id_14, t1_.microsoft_oauth_client_id AS microsoft_oauth_client_id_15, t1_.microsoft_oauth_client_secret AS microsoft_oauth_client_secret_16, t1_.microsoft_oauth_redirect_uri AS microsoft_oauth_redirect_uri_17, u0_.user_id AS user_id_18, u0_.tenant_id AS tenant_id_19 FROM user_tenant u0_ INNER JOIN tenant t1_ ON u0_.tenant_id = t1_.id WHERE u0_.user_id = 9 AND t1_.is_active = 1 ORDER BY u0_.is_default DESC, t1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_default AS is_default_2,
  t0.platform_role AS platform_role_3,
  t0.permission_overrides AS permission_overrides_4,
  t0.created_at AS created_at_5,
  t0.user_id AS user_id_6,
  t0.tenant_id AS tenant_id_7
FROM
  user_tenant t0
WHERE
  t0.user_id = ?
  AND t0.tenant_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.platform_role AS platform_role_3, t0.permission_overrides AS permission_overrides_4, t0.created_at AS created_at_5, t0.user_id AS user_id_6, t0.tenant_id AS tenant_id_7 FROM user_tenant t0 WHERE t0.user_id = 9 AND t0.tenant_id = 3 LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.avatar AS avatar_6,
  u0_.job_position AS job_position_7,
  u0_.mailbox_view_mode AS mailbox_view_mode_8,
  u0_.timezone AS timezone_9,
  u0_.created_at AS created_at_10,
  u0_.activation_token AS activation_token_11,
  u0_.activation_token_expires_at AS activation_token_expires_at_12,
  u0_.reset_token AS reset_token_13,
  u0_.reset_token_expires_at AS reset_token_expires_at_14,
  u0_.is_active AS is_active_15,
  u0_.employment_end_date AS employment_end_date_16,
  u0_.deactivated_at AS deactivated_at_17,
  u0_.notifications_read_at AS notifications_read_at_18,
  u0_.dashboard_layout AS dashboard_layout_19,
  u0_.last_seen_at AS last_seen_at_20,
  u0_.totp_secret AS totp_secret_21,
  u0_.totp_enabled AS totp_enabled_22,
  u0_.totp_enabled_at AS totp_enabled_at_23,
  u0_.sip_extension AS sip_extension_24,
  u0_.voip_enabled AS voip_enabled_25,
  u0_.can_call_external AS can_call_external_26,
  u0_.sip_secret_encrypted AS sip_secret_encrypted_27,
  u0_.mailbox_limit AS mailbox_limit_28,
  u0_.mail_storage_quota_mb AS mail_storage_quota_mb_29,
  u0_.quota_suspended_at AS quota_suspended_at_30,
  u0_.quota_locked AS quota_locked_31,
  s1_.id AS id_32,
  s1_.name AS name_33,
  s1_.position AS position_34,
  s1_.is_helpdesk AS is_helpdesk_35,
  s1_.is_active AS is_active_36,
  c2_.id AS id_37,
  c2_.name AS name_38,
  c2_.vat_number AS vat_number_39,
  c2_.tax_code AS tax_code_40,
  c2_.address AS address_41,
  c2_.city AS city_42,
  c2_.province AS province_43,
  c2_.postal_code AS postal_code_44,
  c2_.country AS country_45,
  c2_.phone AS phone_46,
  c2_.email AS email_47,
  c2_.pec AS pec_48,
  c2_.website AS website_49,
  c2_.notes AS notes_50,
  c2_.color AS color_51,
  c2_.email_domains AS email_domains_52,
  c2_.is_active AS is_active_53,
  c2_.kind AS kind_54,
  c2_.created_at AS created_at_55,
  c2_.updated_at AS updated_at_56,
  c3_.id AS id_57,
  c3_.name AS name_58,
  c3_.vat_number AS vat_number_59,
  c3_.tax_code AS tax_code_60,
  c3_.address AS address_61,
  c3_.city AS city_62,
  c3_.province AS province_63,
  c3_.postal_code AS postal_code_64,
  c3_.country AS country_65,
  c3_.phone AS phone_66,
  c3_.email AS email_67,
  c3_.pec AS pec_68,
  c3_.website AS website_69,
  c3_.notes AS notes_70,
  c3_.color AS color_71,
  c3_.email_domains AS email_domains_72,
  c3_.is_active AS is_active_73,
  c3_.kind AS kind_74,
  c3_.created_at AS created_at_75,
  c3_.updated_at AS updated_at_76,
  c4_.id AS id_77,
  c4_.name AS name_78,
  c4_.vat_number AS vat_number_79,
  c4_.tax_code AS tax_code_80,
  c4_.address AS address_81,
  c4_.city AS city_82,
  c4_.province AS province_83,
  c4_.postal_code AS postal_code_84,
  c4_.country AS country_85,
  c4_.phone AS phone_86,
  c4_.email AS email_87,
  c4_.pec AS pec_88,
  c4_.website AS website_89,
  c4_.notes AS notes_90,
  c4_.color AS color_91,
  c4_.email_domains AS email_domains_92,
  c4_.is_active AS is_active_93,
  c4_.kind AS kind_94,
  c4_.created_at AS created_at_95,
  c4_.updated_at AS updated_at_96,
  u0_.company_id AS company_id_97,
  s1_.company_id AS company_id_98,
  c2_.tenant_id AS tenant_id_99,
  c3_.tenant_id AS tenant_id_100,
  c4_.tenant_id AS tenant_id_101
FROM
  `user` u0_
  LEFT JOIN user_support_level u5_ ON u0_.id = u5_.user_id
  LEFT JOIN support_level s1_ ON s1_.id = u5_.support_level_id
  LEFT JOIN company c2_ ON s1_.company_id = c2_.id
  LEFT JOIN company c3_ ON u0_.company_id = c3_.id
  LEFT JOIN user_company u6_ ON u0_.id = u6_.user_id
  LEFT JOIN company c4_ ON c4_.id = u6_.company_id
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.avatar AS avatar_6, u0_.job_position AS job_position_7, u0_.mailbox_view_mode AS mailbox_view_mode_8, u0_.timezone AS timezone_9, u0_.created_at AS created_at_10, u0_.activation_token AS activation_token_11, u0_.activation_token_expires_at AS activation_token_expires_at_12, u0_.reset_token AS reset_token_13, u0_.reset_token_expires_at AS reset_token_expires_at_14, u0_.is_active AS is_active_15, u0_.employment_end_date AS employment_end_date_16, u0_.deactivated_at AS deactivated_at_17, u0_.notifications_read_at AS notifications_read_at_18, u0_.dashboard_layout AS dashboard_layout_19, u0_.last_seen_at AS last_seen_at_20, u0_.totp_secret AS totp_secret_21, u0_.totp_enabled AS totp_enabled_22, u0_.totp_enabled_at AS totp_enabled_at_23, u0_.sip_extension AS sip_extension_24, u0_.voip_enabled AS voip_enabled_25, u0_.can_call_external AS can_call_external_26, u0_.sip_secret_encrypted AS sip_secret_encrypted_27, u0_.mailbox_limit AS mailbox_limit_28, u0_.mail_storage_quota_mb AS mail_storage_quota_mb_29, u0_.quota_suspended_at AS quota_suspended_at_30, u0_.quota_locked AS quota_locked_31, s1_.id AS id_32, s1_.name AS name_33, s1_.position AS position_34, s1_.is_helpdesk AS is_helpdesk_35, s1_.is_active AS is_active_36, c2_.id AS id_37, c2_.name AS name_38, c2_.vat_number AS vat_number_39, c2_.tax_code AS tax_code_40, c2_.address AS address_41, c2_.city AS city_42, c2_.province AS province_43, c2_.postal_code AS postal_code_44, c2_.country AS country_45, c2_.phone AS phone_46, c2_.email AS email_47, c2_.pec AS pec_48, c2_.website AS website_49, c2_.notes AS notes_50, c2_.color AS color_51, c2_.email_domains AS email_domains_52, c2_.is_active AS is_active_53, c2_.kind AS kind_54, c2_.created_at AS created_at_55, c2_.updated_at AS updated_at_56, c3_.id AS id_57, c3_.name AS name_58, c3_.vat_number AS vat_number_59, c3_.tax_code AS tax_code_60, c3_.address AS address_61, c3_.city AS city_62, c3_.province AS province_63, c3_.postal_code AS postal_code_64, c3_.country AS country_65, c3_.phone AS phone_66, c3_.email AS email_67, c3_.pec AS pec_68, c3_.website AS website_69, c3_.notes AS notes_70, c3_.color AS color_71, c3_.email_domains AS email_domains_72, c3_.is_active AS is_active_73, c3_.kind AS kind_74, c3_.created_at AS created_at_75, c3_.updated_at AS updated_at_76, c4_.id AS id_77, c4_.name AS name_78, c4_.vat_number AS vat_number_79, c4_.tax_code AS tax_code_80, c4_.address AS address_81, c4_.city AS city_82, c4_.province AS province_83, c4_.postal_code AS postal_code_84, c4_.country AS country_85, c4_.phone AS phone_86, c4_.email AS email_87, c4_.pec AS pec_88, c4_.website AS website_89, c4_.notes AS notes_90, c4_.color AS color_91, c4_.email_domains AS email_domains_92, c4_.is_active AS is_active_93, c4_.kind AS kind_94, c4_.created_at AS created_at_95, c4_.updated_at AS updated_at_96, u0_.company_id AS company_id_97, s1_.company_id AS company_id_98, c2_.tenant_id AS tenant_id_99, c3_.tenant_id AS tenant_id_100, c4_.tenant_id AS tenant_id_101 FROM `user` u0_ LEFT JOIN user_support_level u5_ ON u0_.id = u5_.user_id LEFT JOIN support_level s1_ ON s1_.id = u5_.support_level_id LEFT JOIN company c2_ ON s1_.company_id = c2_.id LEFT JOIN company c3_ ON u0_.company_id = c3_.id LEFT JOIN user_company u6_ ON u0_.id = u6_.user_id LEFT JOIN company c4_ ON c4_.id = u6_.company_id WHERE u0_.id = 9;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE `user` SET last_seen_at = '2026-09-15 20:44:38' WHERE id = 9;

"COMMIT"

"COMMIT";