Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• 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.organisation_imalize_id AS organisation_imalize_id_6, t0.organisation_fournisseur_id AS organisation_fournisseur_id_7 FROM `user` t0 WHERE t0.id = ?

[
  14
]

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.organisation_imalize_id AS organisation_imalize_id_6,
  t0.organisation_fournisseur_id AS organisation_fournisseur_id_7
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.organisation_imalize_id AS organisation_imalize_id_6, t0.organisation_fournisseur_id AS organisation_fournisseur_id_7 FROM `user` t0 WHERE t0.id = 14;

SELECT m0_.assigned_to_id AS assigned_to_id_0, COUNT(m0_.id) AS sclr_1 FROM mail_task m0_ WHERE m0_.assigned_to_id IS NOT NULL AND m0_.relevant = 1 AND m0_.exported_at IS NULL AND (m0_.status <> ? OR m0_.status IS NULL) GROUP BY m0_.assigned_to_id

[
  "termine"
]

SELECT
  m0_.assigned_to_id AS assigned_to_id_0,
  COUNT(m0_.id) AS sclr_1
FROM
  mail_task m0_
WHERE
  m0_.assigned_to_id IS NOT NULL
  AND m0_.relevant = 1
  AND m0_.exported_at IS NULL
  AND (
    m0_.status <> ?
    OR m0_.status IS NULL
  )
GROUP BY
  m0_.assigned_to_id

SELECT m0_.assigned_to_id AS assigned_to_id_0, COUNT(m0_.id) AS sclr_1 FROM mail_task m0_ WHERE m0_.assigned_to_id IS NOT NULL AND m0_.relevant = 1 AND m0_.exported_at IS NULL AND (m0_.status <> 'termine' OR m0_.status IS NULL) GROUP BY m0_.assigned_to_id;

SELECT COUNT(m0_.id) AS sclr_0 FROM mail_task m0_ WHERE m0_.assigned_to_id IS NULL AND m0_.relevant = 1 AND m0_.exported_at IS NULL AND (m0_.status <> ? OR m0_.status IS NULL)

[
  "termine"
]

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mail_task m0_
WHERE
  m0_.assigned_to_id IS NULL
  AND m0_.relevant = 1
  AND m0_.exported_at IS NULL
  AND (
    m0_.status <> ?
    OR m0_.status IS NULL
  )

SELECT COUNT(m0_.id) AS sclr_0 FROM mail_task m0_ WHERE m0_.assigned_to_id IS NULL AND m0_.relevant = 1 AND m0_.exported_at IS NULL AND (m0_.status <> 'termine' OR m0_.status IS NULL);

SELECT COALESCE(created_at, received_at) AS ref_date
             FROM mail_task
             WHERE relevant = 1 AND exported_at IS NULL

[]

SELECT
  COALESCE(created_at, received_at) AS ref_date
FROM
  mail_task
WHERE
  relevant = 1
  AND exported_at IS NULL

SELECT COALESCE(created_at, received_at) AS ref_date
             FROM mail_task
             WHERE relevant = 1 AND exported_at IS NULL;