Symfony Profiler

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

Query Metrics

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.date_of_birth AS date_of_birth_5, u0_.is_active AS is_active_6, u0_.confirmation_token AS confirmation_token_7, u0_.password_reset_token AS password_reset_token_8, u0_.last_login_at AS last_login_at_9, u0_.phone_number AS phone_number_10, u0_.fonction AS fonction_11, u0_.sex AS sex_12, u0_.avatar AS avatar_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.id AS id_17, u0_.email AS email_18, u0_.password AS password_19, u0_.first_name AS first_name_20, u0_.last_name AS last_name_21, u0_.date_of_birth AS date_of_birth_22, u0_.is_active AS is_active_23, u0_.confirmation_token AS confirmation_token_24, u0_.password_reset_token AS password_reset_token_25, u0_.last_login_at AS last_login_at_26, u0_.phone_number AS phone_number_27, u0_.fonction AS fonction_28, u0_.sex AS sex_29, u0_.avatar AS avatar_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.deleted_at AS deleted_at_33, r1_.id AS id_34, r1_.code AS code_35, r1_.name AS name_36, r1_.description AS description_37, r1_.is_default AS is_default_38, r1_.created_at AS created_at_39, r1_.updated_at AS updated_at_40, r1_.deleted_at AS deleted_at_41, p2_.id AS id_42, p2_.code AS code_43, p2_.name AS name_44, p2_.description AS description_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.deleted_at AS deleted_at_48, u0_.user_preference_id AS user_preference_id_49, u0_.department_id AS department_id_50, u0_.organization_id AS organization_id_51, r1_.department_id AS department_id_52, r1_.organization_id AS organization_id_53, p2_.permission_group_id AS permission_group_id_54 FROM user u0_ LEFT JOIN user_role u3_ ON u0_.id = u3_.user_id LEFT JOIN role r1_ ON r1_.id = u3_.role_id AND (r1_.deleted_at IS NULL) LEFT JOIN role_permission r4_ ON r1_.id = r4_.role_id LEFT JOIN permission p2_ ON p2_.id = r4_.permission_id AND (p2_.deleted_at IS NULL) WHERE (u0_.id = ?) AND (u0_.deleted_at IS NULL)

[
  2
]

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.date_of_birth AS date_of_birth_5,
  u0_.is_active AS is_active_6,
  u0_.confirmation_token AS confirmation_token_7,
  u0_.password_reset_token AS password_reset_token_8,
  u0_.last_login_at AS last_login_at_9,
  u0_.phone_number AS phone_number_10,
  u0_.fonction AS fonction_11,
  u0_.sex AS sex_12,
  u0_.avatar AS avatar_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.deleted_at AS deleted_at_16,
  u0_.id AS id_17,
  u0_.email AS email_18,
  u0_.password AS password_19,
  u0_.first_name AS first_name_20,
  u0_.last_name AS last_name_21,
  u0_.date_of_birth AS date_of_birth_22,
  u0_.is_active AS is_active_23,
  u0_.confirmation_token AS confirmation_token_24,
  u0_.password_reset_token AS password_reset_token_25,
  u0_.last_login_at AS last_login_at_26,
  u0_.phone_number AS phone_number_27,
  u0_.fonction AS fonction_28,
  u0_.sex AS sex_29,
  u0_.avatar AS avatar_30,
  u0_.created_at AS created_at_31,
  u0_.updated_at AS updated_at_32,
  u0_.deleted_at AS deleted_at_33,
  r1_.id AS id_34,
  r1_.code AS code_35,
  r1_.name AS name_36,
  r1_.description AS description_37,
  r1_.is_default AS is_default_38,
  r1_.created_at AS created_at_39,
  r1_.updated_at AS updated_at_40,
  r1_.deleted_at AS deleted_at_41,
  p2_.id AS id_42,
  p2_.code AS code_43,
  p2_.name AS name_44,
  p2_.description AS description_45,
  p2_.created_at AS created_at_46,
  p2_.updated_at AS updated_at_47,
  p2_.deleted_at AS deleted_at_48,
  u0_.user_preference_id AS user_preference_id_49,
  u0_.department_id AS department_id_50,
  u0_.organization_id AS organization_id_51,
  r1_.department_id AS department_id_52,
  r1_.organization_id AS organization_id_53,
  p2_.permission_group_id AS permission_group_id_54
FROM
  user u0_
  LEFT JOIN user_role u3_ ON u0_.id = u3_.user_id
  LEFT JOIN role r1_ ON r1_.id = u3_.role_id
  AND (r1_.deleted_at IS NULL)
  LEFT JOIN role_permission r4_ ON r1_.id = r4_.role_id
  LEFT JOIN permission p2_ ON p2_.id = r4_.permission_id
  AND (p2_.deleted_at IS NULL)
WHERE
  (u0_.id = ?)
  AND (u0_.deleted_at IS NULL)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.date_of_birth AS date_of_birth_5, u0_.is_active AS is_active_6, u0_.confirmation_token AS confirmation_token_7, u0_.password_reset_token AS password_reset_token_8, u0_.last_login_at AS last_login_at_9, u0_.phone_number AS phone_number_10, u0_.fonction AS fonction_11, u0_.sex AS sex_12, u0_.avatar AS avatar_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.id AS id_17, u0_.email AS email_18, u0_.password AS password_19, u0_.first_name AS first_name_20, u0_.last_name AS last_name_21, u0_.date_of_birth AS date_of_birth_22, u0_.is_active AS is_active_23, u0_.confirmation_token AS confirmation_token_24, u0_.password_reset_token AS password_reset_token_25, u0_.last_login_at AS last_login_at_26, u0_.phone_number AS phone_number_27, u0_.fonction AS fonction_28, u0_.sex AS sex_29, u0_.avatar AS avatar_30, u0_.created_at AS created_at_31, u0_.updated_at AS updated_at_32, u0_.deleted_at AS deleted_at_33, r1_.id AS id_34, r1_.code AS code_35, r1_.name AS name_36, r1_.description AS description_37, r1_.is_default AS is_default_38, r1_.created_at AS created_at_39, r1_.updated_at AS updated_at_40, r1_.deleted_at AS deleted_at_41, p2_.id AS id_42, p2_.code AS code_43, p2_.name AS name_44, p2_.description AS description_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.deleted_at AS deleted_at_48, u0_.user_preference_id AS user_preference_id_49, u0_.department_id AS department_id_50, u0_.organization_id AS organization_id_51, r1_.department_id AS department_id_52, r1_.organization_id AS organization_id_53, p2_.permission_group_id AS permission_group_id_54 FROM user u0_ LEFT JOIN user_role u3_ ON u0_.id = u3_.user_id LEFT JOIN role r1_ ON r1_.id = u3_.role_id AND (r1_.deleted_at IS NULL) LEFT JOIN role_permission r4_ ON r1_.id = r4_.role_id LEFT JOIN permission p2_ ON p2_.id = r4_.permission_id AND (p2_.deleted_at IS NULL) WHERE (u0_.id = 2) AND (u0_.deleted_at IS NULL);

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.organization_id AS organization_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM department t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

[
  19
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.lft AS lft_4,
  t0.lvl AS lvl_5,
  t0.rgt AS rgt_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.organization_id AS organization_id_10,
  t0.tree_root AS tree_root_11,
  t0.parent_id AS parent_id_12
FROM
  department t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.organization_id AS organization_id_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM department t0 WHERE t0.id = 19 AND ((t0.deleted_at IS NULL));

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.label AS label_2, d0_.value AS value_3, d0_.updated_at AS updated_at_4, d0_.created_at AS created_at_5, d0_.period_month AS period_month_6, d0_.period_year AS period_year_7, d0_.scope AS scope_8, d0_.metadata AS metadata_9, d0_.department_id AS department_id_10, d0_.organization_id AS organization_id_11 FROM dashboard_kpi d0_ WHERE (d0_.period_month = ? AND d0_.period_year = ?) AND d0_.organization_id = ? AND d0_.scope = ? AND d0_.department_id IS NULL

[
  "9"
  "2025"
  1
  "ORGANIZATION"
]

SELECT
  d0_.id AS id_0,
  d0_.code AS code_1,
  d0_.label AS label_2,
  d0_.value AS value_3,
  d0_.updated_at AS updated_at_4,
  d0_.created_at AS created_at_5,
  d0_.period_month AS period_month_6,
  d0_.period_year AS period_year_7,
  d0_.scope AS scope_8,
  d0_.metadata AS metadata_9,
  d0_.department_id AS department_id_10,
  d0_.organization_id AS organization_id_11
FROM
  dashboard_kpi d0_
WHERE
  (
    d0_.period_month = ?
    AND d0_.period_year = ?
  )
  AND d0_.organization_id = ?
  AND d0_.scope = ?
  AND d0_.department_id IS NULL

SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.label AS label_2, d0_.value AS value_3, d0_.updated_at AS updated_at_4, d0_.created_at AS created_at_5, d0_.period_month AS period_month_6, d0_.period_year AS period_year_7, d0_.scope AS scope_8, d0_.metadata AS metadata_9, d0_.department_id AS department_id_10, d0_.organization_id AS organization_id_11 FROM dashboard_kpi d0_ WHERE (d0_.period_month = '9' AND d0_.period_year = '2025') AND d0_.organization_id = 1 AND d0_.scope = 'ORGANIZATION' AND d0_.department_id IS NULL;