Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 48
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 6
• Migrations 5
• Debug
• Emails
• Notifications
• Elastica
• Mercure
• Configuration

Query Metrics

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.login AS login_5, t0.password AS password_6, t0.keycloak_id AS keycloak_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.last_login AS last_login_10, t0.timezone AS timezone_11, t0.enabled AS enabled_12, t0.roles AS roles_13, t0.menu AS menu_14, t0.deleted_at AS deleted_at_15, t0.hidden AS hidden_16, t0.sf_core_language_id AS sf_core_language_id_17, t0.sf_core_user_settings_id AS sf_core_user_settings_id_18 FROM sf_core_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

[
  "94"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.login AS login_5,
  t0.password AS password_6,
  t0.keycloak_id AS keycloak_id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.last_login AS last_login_10,
  t0.timezone AS timezone_11,
  t0.enabled AS enabled_12,
  t0.roles AS roles_13,
  t0.menu AS menu_14,
  t0.deleted_at AS deleted_at_15,
  t0.hidden AS hidden_16,
  t0.sf_core_language_id AS sf_core_language_id_17,
  t0.sf_core_user_settings_id AS sf_core_user_settings_id_18
FROM
  sf_core_user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.login AS login_5, t0.password AS password_6, t0.keycloak_id AS keycloak_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.last_login AS last_login_10, t0.timezone AS timezone_11, t0.enabled AS enabled_12, t0.roles AS roles_13, t0.menu AS menu_14, t0.deleted_at AS deleted_at_15, t0.hidden AS hidden_16, t0.sf_core_language_id AS sf_core_language_id_17, t0.sf_core_user_settings_id AS sf_core_user_settings_id_18 FROM sf_core_user t0 WHERE t0.id = '94' AND ((t0.deleted_at IS NULL));

SELECT sfcnsfcnt.sf_core_notification_id, sfcnt.name FROM sf_core_notification_sf_core_notification_topic sfcnsfcnt INNER JOIN sf_core_notification_topic sfcnt ON sfcnsfcnt.sf_core_notification_topic_id = sfcnt.id;

[]

SELECT
  sfcnsfcnt.sf_core_notification_id,
  sfcnt.name
FROM
  sf_core_notification_sf_core_notification_topic sfcnsfcnt
  INNER JOIN sf_core_notification_topic sfcnt ON sfcnsfcnt.sf_core_notification_topic_id = sfcnt.id;

SELECT sfcnsfcnt.sf_core_notification_id, sfcnt.name FROM sf_core_notification_sf_core_notification_topic sfcnsfcnt INNER JOIN sf_core_notification_topic sfcnt ON sfcnsfcnt.sf_core_notification_topic_id = sfcnt.id;;

SELECT sfcn.*, sfcu.first_name AS user_firstname, sfcu.last_name AS user_lastname FROM sf_core_notification sfcn INNER JOIN sf_core_notification_sf_core_notification_topic sfcnsfcnt ON sfcn.id = sfcnsfcnt.sf_core_notification_id LEFT JOIN sf_core_user sfcu ON sfcu.id = sfcn.emitter_id WHERE (sfcn.private = false AND sfcn.created_at >= ?) ORDER BY sfcn.created_at DESC;

[
  "2025-01-06 13:00:53"
]

SELECT
  sfcn.*,
  sfcu.first_name AS user_firstname,
  sfcu.last_name AS user_lastname
FROM
  sf_core_notification sfcn
  INNER JOIN sf_core_notification_sf_core_notification_topic sfcnsfcnt ON sfcn.id = sfcnsfcnt.sf_core_notification_id
  LEFT JOIN sf_core_user sfcu ON sfcu.id = sfcn.emitter_id
WHERE
  (
    sfcn.private = false
    AND sfcn.created_at >= ?
  )
ORDER BY
  sfcn.created_at DESC;

SELECT sfcn.*, sfcu.first_name AS user_firstname, sfcu.last_name AS user_lastname FROM sf_core_notification sfcn INNER JOIN sf_core_notification_sf_core_notification_topic sfcnsfcnt ON sfcn.id = sfcnsfcnt.sf_core_notification_id LEFT JOIN sf_core_user sfcu ON sfcu.id = sfcn.emitter_id WHERE (sfcn.private = false AND sfcn.created_at >= '2025-01-06 13:00:53') ORDER BY sfcn.created_at DESC;;

SELECT sfcp.id, sfcp.route FROM sf_core_permission sfcp WHERE sfcp.deleted_at IS NULL;

[]

SELECT
  sfcp.id,
  sfcp.route
FROM
  sf_core_permission sfcp
WHERE
  sfcp.deleted_at IS NULL;

SELECT sfcp.id, sfcp.route FROM sf_core_permission sfcp WHERE sfcp.deleted_at IS NULL;;

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.enabled AS enabled_6, t0.level AS level_7, t0.deleted_at AS deleted_at_8, t0.hidden AS hidden_9 FROM sf_core_role t0 INNER JOIN sf_core_user_sf_core_role ON t0.id = sf_core_user_sf_core_role.sf_core_role_id WHERE sf_core_user_sf_core_role.sf_core_user_id = ? AND ((t0.deleted_at IS NULL))

[
  "94"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.enabled AS enabled_6,
  t0.level AS level_7,
  t0.deleted_at AS deleted_at_8,
  t0.hidden AS hidden_9
FROM
  sf_core_role t0
  INNER JOIN sf_core_user_sf_core_role ON t0.id = sf_core_user_sf_core_role.sf_core_role_id
WHERE
  sf_core_user_sf_core_role.sf_core_user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.enabled AS enabled_6, t0.level AS level_7, t0.deleted_at AS deleted_at_8, t0.hidden AS hidden_9 FROM sf_core_role t0 INNER JOIN sf_core_user_sf_core_role ON t0.id = sf_core_user_sf_core_role.sf_core_role_id WHERE sf_core_user_sf_core_role.sf_core_user_id = '94' AND ((t0.deleted_at IS NULL));

SELECT DISTINCT sfcusfcn.sf_core_notification_id FROM sf_core_user_sf_core_notification sfcusfcn WHERE sfcusfcn.sf_core_user_id = ?

[
  94
]

SELECT
  DISTINCT sfcusfcn.sf_core_notification_id
FROM
  sf_core_user_sf_core_notification sfcusfcn
WHERE
  sfcusfcn.sf_core_user_id = ?

SELECT DISTINCT sfcusfcn.sf_core_notification_id FROM sf_core_user_sf_core_notification sfcusfcn WHERE sfcusfcn.sf_core_user_id = 94;

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_user_sf_core_notification_topic ON t0.id = sf_core_user_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_user_sf_core_notification_topic.sf_core_user_id = ? AND ((t0.deleted_at IS NULL))

[
  "94"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.deleted_at AS deleted_at_6,
  t0.hidden AS hidden_7
FROM
  sf_core_notification_topic t0
  INNER JOIN sf_core_user_sf_core_notification_topic ON t0.id = sf_core_user_sf_core_notification_topic.sf_core_notification_topic_id
WHERE
  sf_core_user_sf_core_notification_topic.sf_core_user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_user_sf_core_notification_topic ON t0.id = sf_core_user_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_user_sf_core_notification_topic.sf_core_user_id = '94' AND ((t0.deleted_at IS NULL));

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_role_sf_core_notification_topic ON t0.id = sf_core_role_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_role_sf_core_notification_topic.sf_core_role_id = ? AND ((t0.deleted_at IS NULL))

[
  "3"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.deleted_at AS deleted_at_6,
  t0.hidden AS hidden_7
FROM
  sf_core_notification_topic t0
  INNER JOIN sf_core_role_sf_core_notification_topic ON t0.id = sf_core_role_sf_core_notification_topic.sf_core_notification_topic_id
WHERE
  sf_core_role_sf_core_notification_topic.sf_core_role_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_role_sf_core_notification_topic ON t0.id = sf_core_role_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_role_sf_core_notification_topic.sf_core_role_id = '3' AND ((t0.deleted_at IS NULL));