Query Metrics
23
Database Queries
4
Different statements
11.64 ms
Query time
0
Invalid entities
25
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
8.92 ms (76.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:
[
"d8e3b045-9512-50cd-86e6-35f29e37b5d3"
]
|
||||||||||||||||||||||||||||||||
|
1.38 ms (11.86%) |
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 ASC, u0_.created_at DESC LIMIT 20 OFFSET 140
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.87 ms (7.46%) |
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 ASC, u0_.created_at DESC
Parameters:
[ "d8e3b045-9512-50cd-86e6-35f29e37b5d3" "c876e0b6-af09-5c41-ab53-e31f75a6f99c" "2f07bd72-e283-586c-ab72-a4ad8c659f12" "69aa0dba-8268-557c-8a42-2ac9c8528ecb" "9e898906-48b8-5570-b4f2-a5e90cd00223" "3ad51989-d863-5ba4-9a41-69c5a30f1d68" "65c5c65e-67d5-5959-8d1b-2e286d83d024" "8b27b018-558f-581d-8691-9d1a5b4bc3c0" "a872af1d-318c-5487-9996-323c647decae" "b4eae615-59dd-5e5b-9fcb-1ffd0d0051ba" "c590a912-043f-5807-9a81-4e131b93b10d" "cf142e9b-a6bf-5fe4-91b6-edfdbf49a9f1" "d321f68d-fcd1-5dbe-ae07-f9f5537f6014" "3e6612a4-0a83-5b45-a1ca-e933f4651fa0" "4d21495c-6c2d-529b-9f9c-e0227f9286ee" "73881920-956a-5249-b8c7-99f7257c0c55" "85c53ab2-34a0-5b5c-ae3b-850eca01baff" "993ec639-687b-5208-bec0-aad285d36624" "a7b78323-db38-5174-b8c7-290d6784fcb8" "ab210ab4-64ab-566e-a2f7-5e06bb738a47" ]
|
||||||||||||||||||||||||||||||||
|
0.47 ms (4.03%) |
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. |