Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 25
• Events
• Routing
• Cache
• Translation 75
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 1
• 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 = ?

[
  80
]

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 = 80;

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 = ? ORDER BY u0_.name ASC

[
  "%ROLE_HIDDEN%"
  1
]

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 = ?
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 ORDER BY u0_.name ASC;

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project_note p0_ INNER JOIN project p1_ ON p0_.project_id = p1_.id INNER JOIN customer c2_ ON p1_.customer_id = c2_.id LEFT JOIN user u3_ ON p0_.assigned_user_id = u3_.id WHERE p0_.category IN (?, ?)

[
  "anniversary_1_year"
  "anniversary_2_year"
]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  project_note p0_
  INNER JOIN project p1_ ON p0_.project_id = p1_.id
  INNER JOIN customer c2_ ON p1_.customer_id = c2_.id
  LEFT JOIN user u3_ ON p0_.assigned_user_id = u3_.id
WHERE
  p0_.category IN (?, ?)

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project_note p0_ INNER JOIN project p1_ ON p0_.project_id = p1_.id INNER JOIN customer c2_ ON p1_.customer_id = c2_.id LEFT JOIN user u3_ ON p0_.assigned_user_id = u3_.id WHERE p0_.category IN ('anniversary_1_year', 'anniversary_2_year');

SELECT DISTINCT p0_.id AS id_0, p0_.created_at_timestamp AS created_at_timestamp_1 FROM project_note p0_ INNER JOIN project p1_ ON p0_.project_id = p1_.id INNER JOIN customer c2_ ON p1_.customer_id = c2_.id LEFT JOIN user u3_ ON p0_.assigned_user_id = u3_.id WHERE p0_.category IN (?, ?) ORDER BY p0_.created_at_timestamp DESC LIMIT 5

[
  "anniversary_1_year"
  "anniversary_2_year"
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at_timestamp AS created_at_timestamp_1
FROM
  project_note p0_
  INNER JOIN project p1_ ON p0_.project_id = p1_.id
  INNER JOIN customer c2_ ON p1_.customer_id = c2_.id
  LEFT JOIN user u3_ ON p0_.assigned_user_id = u3_.id
WHERE
  p0_.category IN (?, ?)
ORDER BY
  p0_.created_at_timestamp DESC
LIMIT
  5

SELECT DISTINCT p0_.id AS id_0, p0_.created_at_timestamp AS created_at_timestamp_1 FROM project_note p0_ INNER JOIN project p1_ ON p0_.project_id = p1_.id INNER JOIN customer c2_ ON p1_.customer_id = c2_.id LEFT JOIN user u3_ ON p0_.assigned_user_id = u3_.id WHERE p0_.category IN ('anniversary_1_year', 'anniversary_2_year') ORDER BY p0_.created_at_timestamp DESC LIMIT 5;