Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 19
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.admin_id AS admin_id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.main_admin AS main_admin_7, t0.super_admin AS super_admin_8, t0.is_active AS is_active_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.user_group_id AS user_group_id_14, t0.user_type AS user_type_15, t0.deleted_by AS deleted_by_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.admin_id AS admin_id_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.is_verified AS is_verified_6,
  t0.main_admin AS main_admin_7,
  t0.super_admin AS super_admin_8,
  t0.is_active AS is_active_9,
  t0.is_deleted AS is_deleted_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.user_group_id AS user_group_id_14,
  t0.user_type AS user_type_15,
  t0.deleted_by AS deleted_by_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.admin_id AS admin_id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.main_admin AS main_admin_7, t0.super_admin AS super_admin_8, t0.is_active AS is_active_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.user_group_id AS user_group_id_14, t0.user_type AS user_type_15, t0.deleted_by AS deleted_by_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM user t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.tl_dashboard AS tl_dashboard_2, t0.kpi_dashboard AS kpi_dashboard_3, t0.one_minute_manager AS one_minute_manager_4, t0.score_card AS score_card_5, t0.pref_created_at AS pref_created_at_6, t0.pref_updated_at AS pref_updated_at_7, t0.quad_chart AS quad_chart_8, t0.user_id AS user_id_9, t0.pref_created_by AS pref_created_by_10, t0.pref_updated_by AS pref_updated_by_11 FROM dp_preferences t0 WHERE t0.user_id = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.tl_dashboard AS tl_dashboard_2,
  t0.kpi_dashboard AS kpi_dashboard_3,
  t0.one_minute_manager AS one_minute_manager_4,
  t0.score_card AS score_card_5,
  t0.pref_created_at AS pref_created_at_6,
  t0.pref_updated_at AS pref_updated_at_7,
  t0.quad_chart AS quad_chart_8,
  t0.user_id AS user_id_9,
  t0.pref_created_by AS pref_created_by_10,
  t0.pref_updated_by AS pref_updated_by_11
FROM
  dp_preferences t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tl_dashboard AS tl_dashboard_2, t0.kpi_dashboard AS kpi_dashboard_3, t0.one_minute_manager AS one_minute_manager_4, t0.score_card AS score_card_5, t0.pref_created_at AS pref_created_at_6, t0.pref_updated_at AS pref_updated_at_7, t0.quad_chart AS quad_chart_8, t0.user_id AS user_id_9, t0.pref_created_by AS pref_created_by_10, t0.pref_updated_by AS pref_updated_by_11 FROM dp_preferences t0 WHERE t0.user_id = 1 LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE dp_preferences SET tl_dashboard = ?, pref_updated_at = ? WHERE id = ?

[
  "{"cat_1":{"day":{"defaultKpi":11},"week":{"defaultKpi":10}},"cat_2":{"day":{"defaultKpi":18},"week":{"defaultKpi":20}},"cat_3":{"day":{"defaultKpi":19},"week":{"defaultKpi":0}},"cat_4":{"day":{"defaultKpi":22},"week":{"defaultKpi":0}},"cat_5":{"day":{"defaultKpi":21},"week":{"defaultKpi":0}}}"
  "2025-01-09 04:51:12"
  2
]

UPDATE
  dp_preferences
SET
  tl_dashboard = ?,
  pref_updated_at = ?
WHERE
  id = ?

UPDATE dp_preferences SET tl_dashboard = '{\"cat_1\":{\"day\":{\"defaultKpi\":11},\"week\":{\"defaultKpi\":10}},\"cat_2\":{\"day\":{\"defaultKpi\":18},\"week\":{\"defaultKpi\":20}},\"cat_3\":{\"day\":{\"defaultKpi\":19},\"week\":{\"defaultKpi\":0}},\"cat_4\":{\"day\":{\"defaultKpi\":22},\"week\":{\"defaultKpi\":0}},\"cat_5\":{\"day\":{\"defaultKpi\":21},\"week\":{\"defaultKpi\":0}}}', pref_updated_at = '2025-01-09 04:51:12' WHERE id = 2;

"COMMIT"

[]

"COMMIT"

"COMMIT";