Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 4645
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client 1
• Doctrine
• Messages
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.Email AS Email_2, t0.Password AS Password_3, t0.Role_Id AS Role_Id_4 FROM [User] t0 WHERE t0.Email = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY

[
  "brianf@bulwarkpest.com"
]

SELECT
  t0.id AS id_1,
  t0.Email AS Email_2,
  t0.Password AS Password_3,
  t0.Role_Id AS Role_Id_4
FROM
  [User] t0
WHERE
  t0.Email = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.Email AS Email_2, t0.Password AS Password_3, t0.Role_Id AS Role_Id_4 FROM [User] t0 WHERE t0.Email = 'brianf@bulwarkpest.com' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

SELECT t0_.Id AS Id_0, t0_.Code AS Code_1, t0_.Methods AS Methods_2, t0_.Validation AS Validation_3, t0_.Type AS Type_4, t0_.CreatedOn AS CreatedOn_5 FROM TempestAPIUserRules t0_ WHERE t0_.Code = ? ORDER BY t0_.Id ASC

[
  "3e55a08b-8b2a-401f-8f44-5be422839a0e"
]

SELECT
  t0_.Id AS Id_0,
  t0_.Code AS Code_1,
  t0_.Methods AS Methods_2,
  t0_.Validation AS Validation_3,
  t0_.Type AS Type_4,
  t0_.CreatedOn AS CreatedOn_5
FROM
  TempestAPIUserRules t0_
WHERE
  t0_.Code = ?
ORDER BY
  t0_.Id ASC

SELECT t0_.Id AS Id_0, t0_.Code AS Code_1, t0_.Methods AS Methods_2, t0_.Validation AS Validation_3, t0_.Type AS Type_4, t0_.CreatedOn AS CreatedOn_5 FROM TempestAPIUserRules t0_ WHERE t0_.Code = '3e55a08b-8b2a-401f-8f44-5be422839a0e' ORDER BY t0_.Id ASC;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

DELETE FROM ThirdPartyToken WHERE Vendor = ? AND ToolName = ?

[
  "vanguardapi"
  "TempestVue"
]

DELETE FROM
  ThirdPartyToken
WHERE
  Vendor = ?
  AND ToolName = ?

DELETE FROM ThirdPartyToken WHERE Vendor = 'vanguardapi' AND ToolName = 'TempestVue';

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ThirdPartyToken (RefreshToken, Token, Vendor, Active, ToolName, CreatedOn, UpdatedOn) VALUES (?, ?, ?, ?, ?, ?, ?)

[
  ""
  "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IlFaZ045SHFOa0dORU00R2VLY3pEMDJQY1Z2NCIsImtpZCI6IlFaZ045SHFOa0dORU00R2VLY3pEMDJQY1Z2NCJ9.eyJhdWQiOiJhcGk6Ly85Njg3OTRkNi0yNzYyLTQ4ZDEtYTBiYy1kMjMxNTFiOGYwYWEiLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC9hZjdkNjhlZi00NDIyLTQwMTYtOGViOC1jOWFiNmRiZjg0M2EvIiwiaWF0IjoxNzczNTQ4NzAyLCJuYmYiOjE3NzM1NDg3MDIsImV4cCI6MTc3MzU1MjYwMiwiYWlvIjoiQVNRQTIvOGJBQUFBNGc2Wm00dVZvS1JnVDZqMDFWblRIYmVxUjNkZGRxaUZjZlEydjF6aW9tYz0iLCJhcHBpZCI6ImFjNTYzZWVkLTdlYTktNDEyZC1iMGQzLTY1YjljN2I5ODhhZSIsImFwcGlkYWNyIjoiMSIsImlkcCI6Imh0dHBzOi8vc3RzLndpbmRvd3MubmV0L2FmN2Q2OGVmLTQ0MjItNDAxNi04ZWI4LWM5YWI2ZGJmODQzYS8iLCJvaWQiOiIxYjNjMTNjZi04ZmUxLTQ4NWEtYTlkZS01NzQzZDMzMjgzZDYiLCJyaCI6IjEuQVVZQTcyaDlyeUpFRmtDT3VNbXJiYi1FT3RhVWg1WmlKOUZJb0x6U01WRzQ4S29BQUFCR0FBLiIsInJvbGVzIjpbImFjY2Vzc19hc19hcHBsaWNhdGlvbiJdLCJzdWIiOiIxYjNjMTNjZi04ZmUxLTQ4NWEtYTlkZS01NzQzZDMzMjgzZDYiLCJ0aWQiOiJhZjdkNjhlZi00NDIyLTQwMTYtOGViOC1jOWFiNmRiZjg0M2EiLCJ1dGkiOiJlV09OTG94Rk1reWV6TXhUc0VzSkFBIiwidmVyIjoiMS4wIiwieG1zX2Z0ZCI6IjlzZjVLUURUY05kM1JHMHFoZkdvN0NkWVZ0c3hlcmdrYzZNOHA5R2d5WGdCZFhOemIzVjBhQzFrYzIxeiJ9.dAbjhdqDgUuSkJPbg08nKqo7nt7xh5IyXsKDrv8wO8ehpX9bFBscZ8FOujVIjgil9md8WW9KG0ZIET02WX4wjYnhssSVdKQtkLpbbCCo8meKptaK_NFT0fDeHlg9KxB6ufvwrWzkOp0dgyVQoXLIZ4GREL4woVehMZqeSnZtdkoBcUk8eBeNmti_6zAZcIR_FMIQhtMqajJXXdIxXDRF-ChXaxTy79jbJ2BYHJX-kaxa-4TmUgFrHMKx0bLnAvbEG9oByGJxImkp77lnZxhLXeM3nfBE56f2eGdIPn9O3fgBAz93-zWeJPxgEO5eK2TdKz3SlVMqpeAzx5P-5-aKyQ"
  "vanguardapi"
  1
  "TempestVue"
  "2026-03-14 21:30:02"
  "2026-03-14 21:30:02"
]

INSERT INTO ThirdPartyToken (
  RefreshToken, Token, Vendor, Active,
  ToolName, CreatedOn, UpdatedOn
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO ThirdPartyToken (RefreshToken, Token, Vendor, Active, ToolName, CreatedOn, UpdatedOn) VALUES ('', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IlFaZ045SHFOa0dORU00R2VLY3pEMDJQY1Z2NCIsImtpZCI6IlFaZ045SHFOa0dORU00R2VLY3pEMDJQY1Z2NCJ9.eyJhdWQiOiJhcGk6Ly85Njg3OTRkNi0yNzYyLTQ4ZDEtYTBiYy1kMjMxNTFiOGYwYWEiLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC9hZjdkNjhlZi00NDIyLTQwMTYtOGViOC1jOWFiNmRiZjg0M2EvIiwiaWF0IjoxNzczNTQ4NzAyLCJuYmYiOjE3NzM1NDg3MDIsImV4cCI6MTc3MzU1MjYwMiwiYWlvIjoiQVNRQTIvOGJBQUFBNGc2Wm00dVZvS1JnVDZqMDFWblRIYmVxUjNkZGRxaUZjZlEydjF6aW9tYz0iLCJhcHBpZCI6ImFjNTYzZWVkLTdlYTktNDEyZC1iMGQzLTY1YjljN2I5ODhhZSIsImFwcGlkYWNyIjoiMSIsImlkcCI6Imh0dHBzOi8vc3RzLndpbmRvd3MubmV0L2FmN2Q2OGVmLTQ0MjItNDAxNi04ZWI4LWM5YWI2ZGJmODQzYS8iLCJvaWQiOiIxYjNjMTNjZi04ZmUxLTQ4NWEtYTlkZS01NzQzZDMzMjgzZDYiLCJyaCI6IjEuQVVZQTcyaDlyeUpFRmtDT3VNbXJiYi1FT3RhVWg1WmlKOUZJb0x6U01WRzQ4S29BQUFCR0FBLiIsInJvbGVzIjpbImFjY2Vzc19hc19hcHBsaWNhdGlvbiJdLCJzdWIiOiIxYjNjMTNjZi04ZmUxLTQ4NWEtYTlkZS01NzQzZDMzMjgzZDYiLCJ0aWQiOiJhZjdkNjhlZi00NDIyLTQwMTYtOGViOC1jOWFiNmRiZjg0M2EiLCJ1dGkiOiJlV09OTG94Rk1reWV6TXhUc0VzSkFBIiwidmVyIjoiMS4wIiwieG1zX2Z0ZCI6IjlzZjVLUURUY05kM1JHMHFoZkdvN0NkWVZ0c3hlcmdrYzZNOHA5R2d5WGdCZFhOemIzVjBhQzFrYzIxeiJ9.dAbjhdqDgUuSkJPbg08nKqo7nt7xh5IyXsKDrv8wO8ehpX9bFBscZ8FOujVIjgil9md8WW9KG0ZIET02WX4wjYnhssSVdKQtkLpbbCCo8meKptaK_NFT0fDeHlg9KxB6ufvwrWzkOp0dgyVQoXLIZ4GREL4woVehMZqeSnZtdkoBcUk8eBeNmti_6zAZcIR_FMIQhtMqajJXXdIxXDRF-ChXaxTy79jbJ2BYHJX-kaxa-4TmUgFrHMKx0bLnAvbEG9oByGJxImkp77lnZxhLXeM3nfBE56f2eGdIPn9O3fgBAz93-zWeJPxgEO5eK2TdKz3SlVMqpeAzx5P-5-aKyQ', 'vanguardapi', 1, 'TempestVue', '2026-03-14 21:30:02', '2026-03-14 21:30:02');

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT t0.id AS id_1, t0.Name AS Name_2, t0.vg_id AS vg_id_3, t0.Extension AS Extension_4, t0.hr_emp_id AS hr_emp_id_5, t0.lastCCC_id AS lastCCC_id_6, t0.department AS department_7, t0.email AS email_8, t0.Password AS Password_9, t0.phone_number AS phone_number_10, t0.active AS active_11, t0.ImprovementNote AS ImprovementNote_12 FROM [SalesMan] t0 WHERE t0.active = ? AND t0.email = ? ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY

[
  1
  "brianf@bulwarkpest.com"
]

SELECT
  t0.id AS id_1,
  t0.Name AS Name_2,
  t0.vg_id AS vg_id_3,
  t0.Extension AS Extension_4,
  t0.hr_emp_id AS hr_emp_id_5,
  t0.lastCCC_id AS lastCCC_id_6,
  t0.department AS department_7,
  t0.email AS email_8,
  t0.Password AS Password_9,
  t0.phone_number AS phone_number_10,
  t0.active AS active_11,
  t0.ImprovementNote AS ImprovementNote_12
FROM
  [SalesMan] t0
WHERE
  t0.active = ?
  AND t0.email = ?
ORDER BY
  (
    SELECT
      0
  )
OFFSET
  0
ROWS
FETCH
  NEXT 1
ROWS
  ONLY

SELECT t0.id AS id_1, t0.Name AS Name_2, t0.vg_id AS vg_id_3, t0.Extension AS Extension_4, t0.hr_emp_id AS hr_emp_id_5, t0.lastCCC_id AS lastCCC_id_6, t0.department AS department_7, t0.email AS email_8, t0.Password AS Password_9, t0.phone_number AS phone_number_10, t0.active AS active_11, t0.ImprovementNote AS ImprovementNote_12 FROM [SalesMan] t0 WHERE t0.active = 1 AND t0.email = 'brianf@bulwarkpest.com' ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;