Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Migrations
• Messages
• Emails
• Notifications
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.upload AS upload_4,
  t0.description AS description_5
FROM
  environment_parameter t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.upload AS upload_4, t0.description AS description_5 FROM environment_parameter t0;

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.email AS email_7,
  t0.mobile AS mobile_8,
  t0.phone AS phone_9,
  t0.profile_picture AS profile_picture_10,
  t0.shiftbase_identification AS shiftbase_identification_11,
  t0.default_office_calendar AS default_office_calendar_12,
  t0.default_office_category AS default_office_category_13,
  t0.counter_display_mode AS counter_display_mode_14,
  t0.create_date AS create_date_15,
  t0.modify_date AS modify_date_16,
  t0.is_deleted AS is_deleted_17,
  t0.enable_call_notifications AS enable_call_notifications_18,
  t0.enable_call_end_notifications AS enable_call_end_notifications_19,
  t0.is_api_user AS is_api_user_20,
  t0.allowed_ip_addresses AS allowed_ip_addresses_21,
  t0.created_by_user_id AS created_by_user_id_22,
  t0.modified_by_user_id AS modified_by_user_id_23
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.mobile AS mobile_8, t0.phone AS phone_9, t0.profile_picture AS profile_picture_10, t0.shiftbase_identification AS shiftbase_identification_11, t0.default_office_calendar AS default_office_calendar_12, t0.default_office_category AS default_office_category_13, t0.counter_display_mode AS counter_display_mode_14, t0.create_date AS create_date_15, t0.modify_date AS modify_date_16, t0.is_deleted AS is_deleted_17, t0.enable_call_notifications AS enable_call_notifications_18, t0.enable_call_end_notifications AS enable_call_end_notifications_19, t0.is_api_user AS is_api_user_20, t0.allowed_ip_addresses AS allowed_ip_addresses_21, t0.created_by_user_id AS created_by_user_id_22, t0.modified_by_user_id AS modified_by_user_id_23 FROM user t0 WHERE t0.id = 1;

SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.is_deleted = 0 AND n0_.is_read = 0 AND n0_.to_user_id = ? ORDER BY n0_.create_date DESC

[
  1
]

SELECT
  count(n0_.id) AS sclr_0
FROM
  notification n0_
WHERE
  n0_.is_deleted = 0
  AND n0_.is_read = 0
  AND n0_.to_user_id = ?
ORDER BY
  n0_.create_date DESC

SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.is_deleted = 0 AND n0_.is_read = 0 AND n0_.to_user_id = 1 ORDER BY n0_.create_date DESC;

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.icon AS icon_3, n0_.initiated_by AS initiated_by_4, n0_.is_read AS is_read_5, n0_.create_date AS create_date_6, n0_.modify_date AS modify_date_7, n0_.is_deleted AS is_deleted_8, n0_.url AS url_9, n0_.url_mobile AS url_mobile_10, n0_.to_user_id AS to_user_id_11, n0_.created_by_user_id AS created_by_user_id_12, n0_.modified_by_user_id AS modified_by_user_id_13 FROM notification n0_ WHERE n0_.is_deleted = 0 AND n0_.is_read = 0 AND n0_.to_user_id = ? ORDER BY n0_.create_date DESC LIMIT 5

[
  1
]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.description AS description_2,
  n0_.icon AS icon_3,
  n0_.initiated_by AS initiated_by_4,
  n0_.is_read AS is_read_5,
  n0_.create_date AS create_date_6,
  n0_.modify_date AS modify_date_7,
  n0_.is_deleted AS is_deleted_8,
  n0_.url AS url_9,
  n0_.url_mobile AS url_mobile_10,
  n0_.to_user_id AS to_user_id_11,
  n0_.created_by_user_id AS created_by_user_id_12,
  n0_.modified_by_user_id AS modified_by_user_id_13
FROM
  notification n0_
WHERE
  n0_.is_deleted = 0
  AND n0_.is_read = 0
  AND n0_.to_user_id = ?
ORDER BY
  n0_.create_date DESC
LIMIT
  5

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.icon AS icon_3, n0_.initiated_by AS initiated_by_4, n0_.is_read AS is_read_5, n0_.create_date AS create_date_6, n0_.modify_date AS modify_date_7, n0_.is_deleted AS is_deleted_8, n0_.url AS url_9, n0_.url_mobile AS url_mobile_10, n0_.to_user_id AS to_user_id_11, n0_.created_by_user_id AS created_by_user_id_12, n0_.modified_by_user_id AS modified_by_user_id_13 FROM notification n0_ WHERE n0_.is_deleted = 0 AND n0_.is_read = 0 AND n0_.to_user_id = 1 ORDER BY n0_.create_date DESC LIMIT 5;