Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.is_active AS is_active_6, t0.email_greeting AS email_greeting_7, t0.email_signature AS email_signature_8, t0.email_greeting_en AS email_greeting_en_9, t0.email_signature_en AS email_signature_en_10, t0.last_login_at AS last_login_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM `user` t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.is_active AS is_active_6,
  t0.email_greeting AS email_greeting_7,
  t0.email_signature AS email_signature_8,
  t0.email_greeting_en AS email_greeting_en_9,
  t0.email_signature_en AS email_signature_en_10,
  t0.last_login_at AS last_login_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.is_active AS is_active_6, t0.email_greeting AS email_greeting_7, t0.email_signature AS email_signature_8, t0.email_greeting_en AS email_greeting_en_9, t0.email_signature_en AS email_signature_en_10, t0.last_login_at AS last_login_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM `user` t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.website_url AS website_url_3, t0.exact_id AS exact_id_4, t0.exact_account_guid AS exact_account_guid_5, t0.reserved_support_hours AS reserved_support_hours_6, t0.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_7, t0.hourly_rate AS hourly_rate_8, t0.default_month AS default_month_9, t0.yearly_maintenance_remaining AS yearly_maintenance_remaining_10, t0.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_11, t0.initial_support_carry_over AS initial_support_carry_over_12, t0.use_initial_support_carry_over AS use_initial_support_carry_over_13, t0.email_locale AS email_locale_14, t0.default_invoice_description AS default_invoice_description_15 FROM company t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.website_url AS website_url_3,
  t0.exact_id AS exact_id_4,
  t0.exact_account_guid AS exact_account_guid_5,
  t0.reserved_support_hours AS reserved_support_hours_6,
  t0.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.default_month AS default_month_9,
  t0.yearly_maintenance_remaining AS yearly_maintenance_remaining_10,
  t0.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_11,
  t0.initial_support_carry_over AS initial_support_carry_over_12,
  t0.use_initial_support_carry_over AS use_initial_support_carry_over_13,
  t0.email_locale AS email_locale_14,
  t0.default_invoice_description AS default_invoice_description_15
FROM
  company t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.website_url AS website_url_3, t0.exact_id AS exact_id_4, t0.exact_account_guid AS exact_account_guid_5, t0.reserved_support_hours AS reserved_support_hours_6, t0.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_7, t0.hourly_rate AS hourly_rate_8, t0.default_month AS default_month_9, t0.yearly_maintenance_remaining AS yearly_maintenance_remaining_10, t0.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_11, t0.initial_support_carry_over AS initial_support_carry_over_12, t0.use_initial_support_carry_over AS use_initial_support_carry_over_13, t0.email_locale AS email_locale_14, t0.default_invoice_description AS default_invoice_description_15 FROM company t0 ORDER BY t0.name ASC;

SELECT i0_.id AS id_0, i0_.month AS month_1, i0_.status AS status_2, i0_.total_amount AS total_amount_3, i0_.description AS description_4, i0_.notes AS notes_5, i0_.exact_reference AS exact_reference_6, i0_.exact_error AS exact_error_7, i0_.exact_error_at AS exact_error_at_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.finalized_at AS finalized_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.website_url AS website_url_14, c1_.exact_id AS exact_id_15, c1_.exact_account_guid AS exact_account_guid_16, c1_.reserved_support_hours AS reserved_support_hours_17, c1_.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_18, c1_.hourly_rate AS hourly_rate_19, c1_.default_month AS default_month_20, c1_.yearly_maintenance_remaining AS yearly_maintenance_remaining_21, c1_.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_22, c1_.initial_support_carry_over AS initial_support_carry_over_23, c1_.use_initial_support_carry_over AS use_initial_support_carry_over_24, c1_.email_locale AS email_locale_25, c1_.default_invoice_description AS default_invoice_description_26, i0_.company_id AS company_id_27 FROM invoice i0_ INNER JOIN company c1_ ON i0_.company_id = c1_.id WHERE i0_.month = ? ORDER BY c1_.name ASC

[
  "2026-05-01"
]

SELECT
  i0_.id AS id_0,
  i0_.month AS month_1,
  i0_.status AS status_2,
  i0_.total_amount AS total_amount_3,
  i0_.description AS description_4,
  i0_.notes AS notes_5,
  i0_.exact_reference AS exact_reference_6,
  i0_.exact_error AS exact_error_7,
  i0_.exact_error_at AS exact_error_at_8,
  i0_.created_at AS created_at_9,
  i0_.updated_at AS updated_at_10,
  i0_.finalized_at AS finalized_at_11,
  c1_.id AS id_12,
  c1_.name AS name_13,
  c1_.website_url AS website_url_14,
  c1_.exact_id AS exact_id_15,
  c1_.exact_account_guid AS exact_account_guid_16,
  c1_.reserved_support_hours AS reserved_support_hours_17,
  c1_.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_18,
  c1_.hourly_rate AS hourly_rate_19,
  c1_.default_month AS default_month_20,
  c1_.yearly_maintenance_remaining AS yearly_maintenance_remaining_21,
  c1_.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_22,
  c1_.initial_support_carry_over AS initial_support_carry_over_23,
  c1_.use_initial_support_carry_over AS use_initial_support_carry_over_24,
  c1_.email_locale AS email_locale_25,
  c1_.default_invoice_description AS default_invoice_description_26,
  i0_.company_id AS company_id_27
FROM
  invoice i0_
  INNER JOIN company c1_ ON i0_.company_id = c1_.id
WHERE
  i0_.month = ?
ORDER BY
  c1_.name ASC

SELECT i0_.id AS id_0, i0_.month AS month_1, i0_.status AS status_2, i0_.total_amount AS total_amount_3, i0_.description AS description_4, i0_.notes AS notes_5, i0_.exact_reference AS exact_reference_6, i0_.exact_error AS exact_error_7, i0_.exact_error_at AS exact_error_at_8, i0_.created_at AS created_at_9, i0_.updated_at AS updated_at_10, i0_.finalized_at AS finalized_at_11, c1_.id AS id_12, c1_.name AS name_13, c1_.website_url AS website_url_14, c1_.exact_id AS exact_id_15, c1_.exact_account_guid AS exact_account_guid_16, c1_.reserved_support_hours AS reserved_support_hours_17, c1_.reserved_maintenance_hours_yearly AS reserved_maintenance_hours_yearly_18, c1_.hourly_rate AS hourly_rate_19, c1_.default_month AS default_month_20, c1_.yearly_maintenance_remaining AS yearly_maintenance_remaining_21, c1_.yearly_maintenance_last_initialized_year AS yearly_maintenance_last_initialized_year_22, c1_.initial_support_carry_over AS initial_support_carry_over_23, c1_.use_initial_support_carry_over AS use_initial_support_carry_over_24, c1_.email_locale AS email_locale_25, c1_.default_invoice_description AS default_invoice_description_26, i0_.company_id AS company_id_27 FROM invoice i0_ INNER JOIN company c1_ ON i0_.company_id = c1_.id WHERE i0_.month = '2026-05-01' ORDER BY c1_.name ASC;

SELECT i0_.status AS status_0, COUNT(i0_.id) AS sclr_1, SUM(i0_.total_amount) AS sclr_2 FROM invoice i0_ WHERE i0_.month = ? GROUP BY i0_.status

[
  "2026-05-01"
]

SELECT
  i0_.status AS status_0,
  COUNT(i0_.id) AS sclr_1,
  SUM(i0_.total_amount) AS sclr_2
FROM
  invoice i0_
WHERE
  i0_.month = ?
GROUP BY
  i0_.status

SELECT i0_.status AS status_0, COUNT(i0_.id) AS sclr_1, SUM(i0_.total_amount) AS sclr_2 FROM invoice i0_ WHERE i0_.month = '2026-05-01' GROUP BY i0_.status;

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = 0

[
  1
]

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  n0_.user_id = ?
  AND n0_.is_read = 0

SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = 1 AND n0_.is_read = 0;