Query Metrics
7
Database Queries
3
Different statements
38.69 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 27.64 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 | 8.23 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.54 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.52 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.60 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.47 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. |