https://api.dev.talloverde.com/api/users/49020/notifications?q=%2Fapi%2Fusers%2F49020%2Fnotifications

Query Metrics

7 Database Queries
3 Different statements
38.74 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 27.19 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.salt AS salt_3, u0_.email AS email_4, u0_.name AS name_5, u0_.roles AS roles_6, u0_.verification_code AS verification_code_7, u0_.is_verified AS is_verified_8, u0_.is_active AS is_active_9 FROM users u0_ WHERE u0_.username = ? OR u0_.email = ?
Parameters:
[
  "manu.tarra+1@gmail.com"
  "manu.tarra+1@gmail.com"
]
2 9.27 ms
SELECT t0.id AS id_1, t0.message AS message_2, t0.details AS details_3, t0.is_read AS is_read_4, t0.resource AS resource_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM notification t0 WHERE t0.user_id = ? ORDER BY t0.created_at DESC LIMIT 20
Parameters:
[
  49020
]
3 0.68 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.name AS name_6, t0.roles AS roles_7, t0.verification_code AS verification_code_8, t0.is_verified AS is_verified_9, t0.is_active AS is_active_10 FROM users t0 WHERE t0.id = ?
Parameters:
[
  26179
]
4 0.45 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.name AS name_6, t0.roles AS roles_7, t0.verification_code AS verification_code_8, t0.is_verified AS is_verified_9, t0.is_active AS is_active_10 FROM users t0 WHERE t0.id = ?
Parameters:
[
  6951
]
5 0.45 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.name AS name_6, t0.roles AS roles_7, t0.verification_code AS verification_code_8, t0.is_verified AS is_verified_9, t0.is_active AS is_active_10 FROM users t0 WHERE t0.id = ?
Parameters:
[
  132
]
6 0.39 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.name AS name_6, t0.roles AS roles_7, t0.verification_code AS verification_code_8, t0.is_verified AS is_verified_9, t0.is_active AS is_active_10 FROM users t0 WHERE t0.id = ?
Parameters:
[
  44339
]
7 0.31 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.name AS name_6, t0.roles AS roles_7, t0.verification_code AS verification_code_8, t0.is_verified AS is_verified_9, t0.is_active AS is_active_10 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Authentication\Entity\User No errors.
App\Notification\Entity\Notification No errors.