Query Metrics
23
Database Queries
4
Different statements
6.32 ms
Query time
0
Invalid entities
25
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4.91 ms (77.65%) |
20 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret AS secret_3, t0.name AS name_4, t0.redirect_uris AS redirect_uris_5, t0.grant_types AS grant_types_6, t0.scopes AS scopes_7, t0.is_confidential AS is_confidential_8, t0.logo_url AS logo_url_9, t0.help_text AS help_text_10, t0.terms_url AS terms_url_11, t0.privacy_policy_url AS privacy_policy_url_12, t0.created_at AS created_at_13 FROM oauth_client t0 INNER JOIN user_oauth_client_access ON t0.id = user_oauth_client_access.oauth_client_id WHERE user_oauth_client_access.user_id = ?
Parameters:
[
"c590a912-043f-5807-9a81-4e131b93b10d"
]
|
||||||||||||||||||||||||||||||||
|
0.74 ms (11.71%) |
1 |
SELECT DISTINCT u0_.id AS id_0, u0_.roles AS roles_1, u0_.created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_.roles DESC, u0_.created_at DESC LIMIT 20 OFFSET 20
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.49 ms (7.75%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.is_active AS is_active_6, u0_.created_at AS created_at_7, u0_.type_person AS type_person_8, u0_.nif AS nif_9, u0_.company_name AS company_name_10, u0_.alias AS alias_11, u0_.logo AS logo_12 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.roles DESC, u0_.created_at DESC
Parameters:
[ "c590a912-043f-5807-9a81-4e131b93b10d" "cf142e9b-a6bf-5fe4-91b6-edfdbf49a9f1" "d321f68d-fcd1-5dbe-ae07-f9f5537f6014" "3ad51989-d863-5ba4-9a41-69c5a30f1d68" "65c5c65e-67d5-5959-8d1b-2e286d83d024" "8b27b018-558f-581d-8691-9d1a5b4bc3c0" "a872af1d-318c-5487-9996-323c647decae" "69aa0dba-8268-557c-8a42-2ac9c8528ecb" "9e898906-48b8-5570-b4f2-a5e90cd00223" "2f07bd72-e283-586c-ab72-a4ad8c659f12" "c876e0b6-af09-5c41-ab53-e31f75a6f99c" "5ad5cc22-3d5c-511b-a7ab-644f3095da3b" "792b67cd-5e60-532f-bd75-5e02522f8393" "a69bbd62-a045-5fab-b587-a5edbd91045e" "d8e3b045-9512-50cd-86e6-35f29e37b5d3" "38f05396-8c09-5fbf-84ff-7c13a4a89ea2" "b44a8edc-4500-591b-a8f7-17578feb2da3" "04134f8b-98a7-54ae-bbd8-4a231cd92a0f" "0472a622-93d2-577c-a0fb-fba57a6a7076" "0554be3d-3e57-5179-a3fe-16f13a13e46f" ]
|
||||||||||||||||||||||||||||||||
|
0.18 ms (2.88%) |
1 |
SELECT count(*) AS sclr_0 FROM `user` u0_
Parameters:
[]
|
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\User | 20 |
| App\Entity\OAuthClient | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\OAuthClient | No errors. |