Query Metrics
23
Database Queries
4
Different statements
6.45 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.20 ms (80.59%) |
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:
[
"8d6dea79-ef87-5419-b201-5a07684bc008"
]
|
||||||||||||||||||||||||||||||||
|
0.54 ms (8.43%) |
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 ASC, u0_.created_at DESC LIMIT 20 OFFSET 100
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.49 ms (7.66%) |
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 ASC, u0_.created_at DESC
Parameters:
[ "8d6dea79-ef87-5419-b201-5a07684bc008" "8fdd5a05-3d76-55ea-b2d4-8235a95c3398" "911ae7da-6354-429b-b803-7fba990befd9" "9364c5dd-d94b-4cea-b4fa-902cab149f6f" "936c3abc-6f34-5946-a947-9572009f77cd" "9611f400-2dce-40a6-b42a-b27b8903d4fc" "96fa030e-85be-5210-8929-9ee7cb7fd043" "98650093-e398-582e-b0a2-5f04dc5b779d" "9887cff4-3028-5c2d-8c3c-18533cf43a5a" "993ec639-687b-5208-bec0-aad285d36624" "9dd6abb9-aff5-4ebe-a124-699026311b68" "9e898906-48b8-5570-b4f2-a5e90cd00223" "a18c1f61-1254-555b-9c0a-6ed90412e687" "a1c6bb8b-27fb-4b5d-b2d7-347ab7e9839b" "a4240dba-08f0-5092-8023-73ca2ee25e98" "a6443d57-91eb-4a7a-b9ab-b986fa483375" "a64985c1-15ca-44c5-b66d-6c486c3c5c19" "a69bbd62-a045-5fab-b587-a5edbd91045e" "a705e071-7c95-4839-ae29-cc2f9ebce3f7" "a77b0a59-ab6f-5f41-9845-311c31d1bad3" ]
|
||||||||||||||||||||||||||||||||
|
0.21 ms (3.32%) |
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 | 6 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\OAuthClient | No errors. |