Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM laboratory t0

[]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3
FROM
  laboratory t0

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM laboratory t0;

SELECT t0.id AS id_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.password AS password_8, t0.status AS status_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.type, t1.identity_code AS identity_code_13, t1.address AS address_14, t1.phone_number AS phone_number_15, t1.city AS city_16, t1.zip_code AS zip_code_17, t3.phone_number AS phone_number_18 FROM account t0 LEFT JOIN practician t1 ON t0.id = t1.id LEFT JOIN administrator t2 ON t0.id = t2.id LEFT JOIN supervisor t3 ON t0.id = t3.id WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.status AS status_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.type,
  t1.identity_code AS identity_code_13,
  t1.address AS address_14,
  t1.phone_number AS phone_number_15,
  t1.city AS city_16,
  t1.zip_code AS zip_code_17,
  t3.phone_number AS phone_number_18
FROM
  account t0
  LEFT JOIN practician t1 ON t0.id = t1.id
  LEFT JOIN administrator t2 ON t0.id = t2.id
  LEFT JOIN supervisor t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.password AS password_8, t0.status AS status_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.type, t1.identity_code AS identity_code_13, t1.address AS address_14, t1.phone_number AS phone_number_15, t1.city AS city_16, t1.zip_code AS zip_code_17, t3.phone_number AS phone_number_18 FROM account t0 LEFT JOIN practician t1 ON t0.id = t1.id LEFT JOIN administrator t2 ON t0.id = t2.id LEFT JOIN supervisor t3 ON t0.id = t3.id WHERE t0.id = 1;

SELECT o0_.status AS status_0, count(o0_.id) AS sclr_1 FROM `order` o0_ WHERE o0_.status IN (?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY o0_.status

[
  "pending"
  "invalid"
  "valid"
  "inProcess"
  "inProgress"
  "inDelivery"
  "completed"
  "invoiced"
  "cancelled"
]

SELECT
  o0_.status AS status_0,
  count(o0_.id) AS sclr_1
FROM
  `order` o0_
WHERE
  o0_.status IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  o0_.status

SELECT o0_.status AS status_0, count(o0_.id) AS sclr_1 FROM `order` o0_ WHERE o0_.status IN ('pending', 'invalid', 'valid', 'inProcess', 'inProgress', 'inDelivery', 'completed', 'invoiced', 'cancelled') GROUP BY o0_.status;