Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 21
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• VichUploader
• Configuration

Query Metrics

SELECT COUNT(o0_.id) AS sclr_0 FROM orphan o0_ WHERE o0_.status = ?

[
  "ACTIVE"
]

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  orphan o0_
WHERE
  o0_.status = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM orphan o0_ WHERE o0_.status = 'ACTIVE';

SELECT COUNT(*) FROM family t0

[]

SELECT
  COUNT(*)
FROM
  family t0

SELECT COUNT(*) FROM family t0;

SELECT COUNT(*) FROM sponsor t0

[]

SELECT
  COUNT(*)
FROM
  sponsor t0

SELECT COUNT(*) FROM sponsor t0;

SELECT COUNT(s0_.id) AS sclr_0 FROM sponsorship s0_ WHERE s0_.status = ?

[
  "active"
]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sponsorship s0_
WHERE
  s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM sponsorship s0_ WHERE s0_.status = 'active';

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.description AS description_3, d0_.icon AS icon_4, d0_.color AS color_5, d0_.display_order AS display_order_6, d0_.created_at AS created_at_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.full_name AS full_name_12, u1_.created_at AS created_at_13, m2_.id AS id_14, m2_.first_name AS first_name_15, m2_.last_name AS last_name_16, m2_.cin_number AS cin_number_17, m2_.email AS email_18, m2_.phone AS phone_19, m2_.city AS city_20, m2_.address AS address_21, m2_.profession AS profession_22, m2_.membership_type AS membership_type_23, m2_.status AS status_24, m2_.skills AS skills_25, m2_.joined_at AS joined_at_26, m2_.role_in_department AS role_in_department_27, m2_.created_at AS created_at_28, d0_.manager_id AS manager_id_29, m2_.user_id AS user_id_30, m2_.department_id AS department_id_31 FROM department d0_ LEFT JOIN "user" u1_ ON d0_.manager_id = u1_.id LEFT JOIN member m2_ ON d0_.id = m2_.department_id ORDER BY d0_.display_order ASC

[]

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.code AS code_2,
  d0_.description AS description_3,
  d0_.icon AS icon_4,
  d0_.color AS color_5,
  d0_.display_order AS display_order_6,
  d0_.created_at AS created_at_7,
  u1_.id AS id_8,
  u1_.email AS email_9,
  u1_.roles AS roles_10,
  u1_.password AS password_11,
  u1_.full_name AS full_name_12,
  u1_.created_at AS created_at_13,
  m2_.id AS id_14,
  m2_.first_name AS first_name_15,
  m2_.last_name AS last_name_16,
  m2_.cin_number AS cin_number_17,
  m2_.email AS email_18,
  m2_.phone AS phone_19,
  m2_.city AS city_20,
  m2_.address AS address_21,
  m2_.profession AS profession_22,
  m2_.membership_type AS membership_type_23,
  m2_.status AS status_24,
  m2_.skills AS skills_25,
  m2_.joined_at AS joined_at_26,
  m2_.role_in_department AS role_in_department_27,
  m2_.created_at AS created_at_28,
  d0_.manager_id AS manager_id_29,
  m2_.user_id AS user_id_30,
  m2_.department_id AS department_id_31
FROM
  department d0_
  LEFT JOIN "user" u1_ ON d0_.manager_id = u1_.id
  LEFT JOIN member m2_ ON d0_.id = m2_.department_id
ORDER BY
  d0_.display_order ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.code AS code_2, d0_.description AS description_3, d0_.icon AS icon_4, d0_.color AS color_5, d0_.display_order AS display_order_6, d0_.created_at AS created_at_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.full_name AS full_name_12, u1_.created_at AS created_at_13, m2_.id AS id_14, m2_.first_name AS first_name_15, m2_.last_name AS last_name_16, m2_.cin_number AS cin_number_17, m2_.email AS email_18, m2_.phone AS phone_19, m2_.city AS city_20, m2_.address AS address_21, m2_.profession AS profession_22, m2_.membership_type AS membership_type_23, m2_.status AS status_24, m2_.skills AS skills_25, m2_.joined_at AS joined_at_26, m2_.role_in_department AS role_in_department_27, m2_.created_at AS created_at_28, d0_.manager_id AS manager_id_29, m2_.user_id AS user_id_30, m2_.department_id AS department_id_31 FROM department d0_ LEFT JOIN "user" u1_ ON d0_.manager_id = u1_.id LEFT JOIN member m2_ ON d0_.id = m2_.department_id ORDER BY d0_.display_order ASC;