Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• Configuration

Query Metrics

SELECT COUNT(*) FROM microsoft_tenants t0

[]

SELECT
  COUNT(*)
FROM
  microsoft_tenants t0

SELECT COUNT(*) FROM microsoft_tenants t0;

SELECT COUNT(*) FROM microsoft_tenants t0 WHERE t0.tenant_id = ? AND t0.active = ?

[
  "eb98839e-7261-4f8e-8176-07e6adb5dbe4"
  1
]

SELECT
  COUNT(*)
FROM
  microsoft_tenants t0
WHERE
  t0.tenant_id = ?
  AND t0.active = ?

SELECT COUNT(*) FROM microsoft_tenants t0 WHERE t0.tenant_id = 'eb98839e-7261-4f8e-8176-07e6adb5dbe4' AND t0.active = 1;

SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.email AS email_4, t0.password AS password_5, t0.microsoft_id AS microsoft_id_6, t0.require_password_reset AS require_password_reset_7, t0.active AS active_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10 FROM users t0 WHERE t0.microsoft_id = ? LIMIT 1

[
  "d92a38e2-2e1c-48e0-99b9-fff5cd370374"
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.name AS name_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.microsoft_id AS microsoft_id_6,
  t0.require_password_reset AS require_password_reset_7,
  t0.active AS active_8,
  t0.last_login_at AS last_login_at_9,
  t0.created_at AS created_at_10
FROM
  users t0
WHERE
  t0.microsoft_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.email AS email_4, t0.password AS password_5, t0.microsoft_id AS microsoft_id_6, t0.require_password_reset AS require_password_reset_7, t0.active AS active_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10 FROM users t0 WHERE t0.microsoft_id = 'd92a38e2-2e1c-48e0-99b9-fff5cd370374' LIMIT 1;

SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.location_id AS location_id_4 FROM user_roles t0 WHERE t0.user_id = ?

[
  32
]

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.user_id AS user_id_3,
  t0.location_id AS location_id_4
FROM
  user_roles t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.location_id AS location_id_4 FROM user_roles t0 WHERE t0.user_id = 32;

SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM system_config t0 WHERE t0.config_key = ?

[
  "session_lifetime_minutes"
]

SELECT
  t0.config_key AS config_key_1,
  t0.config_value AS config_value_2
FROM
  system_config t0
WHERE
  t0.config_key = ?

SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM system_config t0 WHERE t0.config_key = 'session_lifetime_minutes';

SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM system_config t0 WHERE t0.config_key = ?

[
  "max_concurrent_sessions"
]

SELECT
  t0.config_key AS config_key_1,
  t0.config_value AS config_value_2
FROM
  system_config t0
WHERE
  t0.config_key = ?

SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM system_config t0 WHERE t0.config_key = 'max_concurrent_sessions';

SELECT COUNT(u0_.id) AS sclr_0 FROM user_sessions u0_ WHERE u0_.user_id = ? AND u0_.expires_at > ?

[
  32
  "2026-05-27 14:11:45"
]

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user_sessions u0_
WHERE
  u0_.user_id = ?
  AND u0_.expires_at > ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user_sessions u0_ WHERE u0_.user_id = 32 AND u0_.expires_at > '2026-05-27 14:11:45';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_sessions (selector, hashed_verifier, ip_address, user_agent, auth_method, created_at, last_active_at, expires_at, last_secure_op_at, remembered, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "dbe09210cc0728cb2cddc18e"
  "217158facc749352825bc95c197c88a73558eebb14bcbf7d7368201d16d67814"
  "65.140.238.194"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0"
  "microsoft"
  "2026-05-27 14:11:45"
  "2026-05-27 14:11:45"
  "2026-05-27 22:11:45"
  null
  0
  32
]

INSERT INTO user_sessions (
  selector, hashed_verifier, ip_address,
  user_agent, auth_method, created_at,
  last_active_at, expires_at, last_secure_op_at,
  remembered, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_sessions (selector, hashed_verifier, ip_address, user_agent, auth_method, created_at, last_active_at, expires_at, last_secure_op_at, remembered, user_id) VALUES ('dbe09210cc0728cb2cddc18e', '217158facc749352825bc95c197c88a73558eebb14bcbf7d7368201d16d67814', '65.140.238.194', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:150.0) Gecko/20100101 Firefox/150.0', 'microsoft', '2026-05-27 14:11:45', '2026-05-27 14:11:45', '2026-05-27 22:11:45', NULL, 0, 32);

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE users SET last_login_at = ? WHERE id = ?

[
  "2026-05-27 14:11:45"
  32
]

UPDATE
  users
SET
  last_login_at = ?
WHERE
  id = ?

UPDATE users SET last_login_at = '2026-05-27 14:11:45' WHERE id = 32;

"COMMIT"

[]

"COMMIT"

"COMMIT";