Query Metrics
23
Database Queries
4
Different statements
6.50 ms
Query time
0
Invalid entities
24
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.19 ms (79.86%) |
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.auto_register AS auto_register_9, t0.logo_url AS logo_url_10, t0.help_text AS help_text_11, t0.terms_url AS terms_url_12, t0.privacy_policy_url AS privacy_policy_url_13, t0.created_at AS created_at_14 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:
[
"b3a39076-9606-40a6-a5f9-5b719c96bcf8"
]
|
||||||||||||||||||||||||||||||||
|
0.53 ms (8.13%) |
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, u0_.reset_token AS reset_token_13, u0_.reset_token_expires_at AS reset_token_expires_at_14 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC, u0_.created_at DESC
Parameters:
[ "b3a39076-9606-40a6-a5f9-5b719c96bcf8" "b2c601a4-109f-59ab-977b-df01d09d6c9b" "b1d2753f-0283-54af-b645-d505678657dd" "b004d04d-a75b-5ab7-a682-fb09a6fda9f0" "afe081d9-7ce9-5127-bcbb-97a662e79a35" "ab210ab4-64ab-566e-a2f7-5e06bb738a47" "aaf9b1b8-8ff2-57fc-ba65-b043f9274431" "aa33e56a-72b3-44c1-a98b-3a68b84ffac8" "a872af1d-318c-5487-9996-323c647decae" "a7b78323-db38-5174-b8c7-290d6784fcb8" "a77b0a59-ab6f-5f41-9845-311c31d1bad3" "a705e071-7c95-4839-ae29-cc2f9ebce3f7" "a69bbd62-a045-5fab-b587-a5edbd91045e" "a64985c1-15ca-44c5-b66d-6c486c3c5c19" "a6443d57-91eb-4a7a-b9ab-b986fa483375" "a4240dba-08f0-5092-8023-73ca2ee25e98" "a1c6bb8b-27fb-4b5d-b2d7-347ab7e9839b" "a18c1f61-1254-555b-9c0a-6ed90412e687" "9e898906-48b8-5570-b4f2-a5e90cd00223" "9dd6abb9-aff5-4ebe-a124-699026311b68" ]
|
||||||||||||||||||||||||||||||||
|
0.52 ms (8.04%) |
1 |
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1, u0_.created_at AS created_at_2 FROM `user` u0_ ORDER BY u0_.id DESC, u0_.created_at DESC LIMIT 20 OFFSET 80
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.26 ms (3.97%) |
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 | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\OAuthClient | No errors. |