Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 25
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Migrations
• Debug
• Messages
• Emails
• Workflow
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = ?

[
  87
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.mobile_number AS mobile_number_7,
  t0.manage_quote AS manage_quote_8,
  t0.manage_file_deletion AS manage_file_deletion_9,
  t0.manage_export AS manage_export_10,
  t0.manage_export_limited AS manage_export_limited_11,
  t0.sales_department AS sales_department_12,
  t0.last_activity_timestamp AS last_activity_timestamp_13,
  t0.password_reset_token AS password_reset_token_14,
  t0.hex_colour AS hex_colour_15
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.name AS name_5, t0.status AS status_6, t0.mobile_number AS mobile_number_7, t0.manage_quote AS manage_quote_8, t0.manage_file_deletion AS manage_file_deletion_9, t0.manage_export AS manage_export_10, t0.manage_export_limited AS manage_export_limited_11, t0.sales_department AS sales_department_12, t0.last_activity_timestamp AS last_activity_timestamp_13, t0.password_reset_token AS password_reset_token_14, t0.hex_colour AS hex_colour_15 FROM user t0 WHERE t0.id = 87;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE user SET last_activity_timestamp = ? WHERE id = ?

[
  1781043282
  87
]

UPDATE
  user
SET
  last_activity_timestamp = ?
WHERE
  id = ?

UPDATE user SET last_activity_timestamp = 1781043282 WHERE id = 87;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles NOT LIKE ? AND u0_.status = ? AND u0_.roles NOT LIKE ?

[
  "%ROLE_HIDDEN%"
  1
  "%ROLE_SUPER_ADMIN%"
]

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.roles NOT LIKE ?
  AND u0_.status = ?
  AND u0_.roles NOT LIKE ?

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 AND u0_.roles NOT LIKE '%ROLE_SUPER_ADMIN%';

SELECT DISTINCT u0_.id AS id_0, u0_.name AS name_1 FROM user u0_ WHERE u0_.roles NOT LIKE ? AND u0_.status = ? AND u0_.roles NOT LIKE ? ORDER BY u0_.name ASC LIMIT 20

[
  "%ROLE_HIDDEN%"
  1
  "%ROLE_SUPER_ADMIN%"
]

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.name AS name_1
FROM
  user u0_
WHERE
  u0_.roles NOT LIKE ?
  AND u0_.status = ?
  AND u0_.roles NOT LIKE ?
ORDER BY
  u0_.name ASC
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0, u0_.name AS name_1 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 AND u0_.roles NOT LIKE '%ROLE_SUPER_ADMIN%' ORDER BY u0_.name ASC LIMIT 20;

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.status AS status_5, u0_.mobile_number AS mobile_number_6, u0_.manage_quote AS manage_quote_7, u0_.manage_file_deletion AS manage_file_deletion_8, u0_.manage_export AS manage_export_9, u0_.manage_export_limited AS manage_export_limited_10, u0_.sales_department AS sales_department_11, u0_.last_activity_timestamp AS last_activity_timestamp_12, u0_.password_reset_token AS password_reset_token_13, u0_.hex_colour AS hex_colour_14 FROM user u0_ WHERE u0_.roles NOT LIKE ? AND u0_.status = ? AND u0_.roles NOT LIKE ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.name ASC

[
  "%ROLE_HIDDEN%"
  1
  "%ROLE_SUPER_ADMIN%"
  18
  8
  11
  67
  59
  31
  10
  32
  49
  46
  58
  72
  79
  51
  16
  21
  35
  63
  69
  37
]

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.name AS name_4,
  u0_.status AS status_5,
  u0_.mobile_number AS mobile_number_6,
  u0_.manage_quote AS manage_quote_7,
  u0_.manage_file_deletion AS manage_file_deletion_8,
  u0_.manage_export AS manage_export_9,
  u0_.manage_export_limited AS manage_export_limited_10,
  u0_.sales_department AS sales_department_11,
  u0_.last_activity_timestamp AS last_activity_timestamp_12,
  u0_.password_reset_token AS password_reset_token_13,
  u0_.hex_colour AS hex_colour_14
FROM
  user u0_
WHERE
  u0_.roles NOT LIKE ?
  AND u0_.status = ?
  AND u0_.roles NOT LIKE ?
  AND u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.status AS status_5, u0_.mobile_number AS mobile_number_6, u0_.manage_quote AS manage_quote_7, u0_.manage_file_deletion AS manage_file_deletion_8, u0_.manage_export AS manage_export_9, u0_.manage_export_limited AS manage_export_limited_10, u0_.sales_department AS sales_department_11, u0_.last_activity_timestamp AS last_activity_timestamp_12, u0_.password_reset_token AS password_reset_token_13, u0_.hex_colour AS hex_colour_14 FROM user u0_ WHERE u0_.roles NOT LIKE '%ROLE_HIDDEN%' AND u0_.status = 1 AND u0_.roles NOT LIKE '%ROLE_SUPER_ADMIN%' AND u0_.id IN (18, 8, 11, 67, 59, 31, 10, 32, 49, 46, 58, 72, 79, 51, 16, 21, 35, 63, 69, 37) ORDER BY u0_.name ASC;