GET https://hostozo.cwd-mm.com/api/notifications?readLimit=0

Query Metrics

7 Database Queries
7 Different statements
3.43 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT t0.email AS email_1, t0.password AS password_2, t0.name AS name_3, t0.roles AS roles_4, t0.status AS status_5, t0.last_active_at AS last_active_at_6, t0.password_reset_token AS password_reset_token_7, t0.password_reset_expires_at AS password_reset_expires_at_8, t0.id AS id_9, t0.uuid AS uuid_10, t0.created AS created_11, t0.updated AS updated_12, t0.active_organisation_id AS active_organisation_id_13 FROM users_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.22 ms
"START TRANSACTION"
Parameters:
[]
3 0.41 ms
UPDATE users_user SET last_active_at = ? WHERE id = ?
Parameters:
[
  "2026-02-15 22:19:19"
  1
]
4 0.21 ms
"COMMIT"
Parameters:
[]
5 1.12 ms
SELECT n0_.read_at AS read_at_0, n0_.id AS id_1, n0_.uuid AS uuid_2, n0_.created AS created_3, n0_.updated AS updated_4, n1_.type AS type_5, n1_.category AS category_6, n1_.status AS status_7, n1_.title AS title_8, n1_.message AS message_9, n1_.actions AS actions_10, n1_.id AS id_11, n1_.uuid AS uuid_12, n1_.created AS created_13, n1_.updated AS updated_14, n0_.notification_id AS notification_id_15, n0_.user_id AS user_id_16, n1_.organisation_id AS organisation_id_17 FROM notifications_notification_recipient n0_ INNER JOIN notifications_notification n1_ ON n0_.notification_id = n1_.id WHERE n0_.user_id = ? AND n1_.organisation_id = ? AND n0_.read_at IS NULL AND n1_.status = ? ORDER BY n1_.created DESC
Parameters:
[
  1
  1
  "active"
]
6 0.57 ms
SELECT n0_.read_at AS read_at_0, n0_.id AS id_1, n0_.uuid AS uuid_2, n0_.created AS created_3, n0_.updated AS updated_4, n1_.type AS type_5, n1_.category AS category_6, n1_.status AS status_7, n1_.title AS title_8, n1_.message AS message_9, n1_.actions AS actions_10, n1_.id AS id_11, n1_.uuid AS uuid_12, n1_.created AS created_13, n1_.updated AS updated_14, n0_.notification_id AS notification_id_15, n0_.user_id AS user_id_16, n1_.organisation_id AS organisation_id_17 FROM notifications_notification_recipient n0_ INNER JOIN notifications_notification n1_ ON n0_.notification_id = n1_.id WHERE n0_.user_id = ? AND n1_.organisation_id = ? AND (n0_.read_at IS NOT NULL OR n1_.status = ?) ORDER BY n0_.read_at DESC LIMIT 1
Parameters:
[
  1
  1
  "completed"
]
7 0.40 ms
SELECT COUNT(n0_.id) AS sclr_0 FROM notifications_notification_recipient n0_ INNER JOIN notifications_notification n1_ ON n0_.notification_id = n1_.id WHERE n0_.user_id = ? AND n1_.organisation_id = ? AND n0_.read_at IS NULL AND n1_.status = ?
Parameters:
[
  1
  1
  "active"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Users\User 1
App\Entity\Organisations\Organisation 1