Query Metrics
3
Database Queries
3
Different statements
0.57 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.28 ms (48.69%) |
1 |
SELECT t0.token AS token_1, t0.expires_at AS expires_at_2, t0.scope AS scope_3, t0.id AS id_4, t0.client_id AS client_id_5, t0.user_id AS user_id_6 FROM access_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
"NWE5MjYzYjk0MDlmMDAxMGQ2MzU4NzRjZjRmNjZkYzQ1YjY3NjYyZDQxZGM2NDFmNjVhNDc5NmJiOWM5MWE1NA"
]
|
0.21 ms (36.50%) |
1 |
SELECT o0_.id AS id_0, o0_.username AS username_1, o0_.email AS email_2, o0_.lastname AS lastname_3, o0_.firstname AS firstname_4, o0_.roles AS roles_5, o0_.a2f_activated AS a2f_activated_6, o0_.code_client AS code_client_7, o0_.data AS data_8 FROM oauth_users o0_ INNER JOIN access_token a1_ ON o0_.id = a1_.user_id WHERE a1_.token = ? AND o0_.id = ?
Parameters:
[ "NWE5MjYzYjk0MDlmMDAxMGQ2MzU4NzRjZjRmNjZkYzQ1YjY3NjYyZDQxZGM2NDFmNjVhNDc5NmJiOWM5MWE1NA" 1 ] |
0.08 ms (14.81%) |
1 |
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.is_active AS is_active_6, t0.roles AS roles_7, t0.auth_code AS auth_code_8, t0.mobile AS mobile_9, t0.trusted AS trusted_10, t0.a2f_activated AS a2f_activated_11, t0.a2f_provider AS a2f_provider_12, t0.lastname AS lastname_13, t0.firstname AS firstname_14, t0.code_client AS code_client_15, t0.reset_token AS reset_token_16, t0.ask_reset_date AS ask_reset_date_17, t0.reset_date AS reset_date_18, t0.last_connection AS last_connection_19, t0.data AS data_20, t0.created_at AS created_at_21, t0.created_locale AS created_locale_22, t0.activated_at AS activated_at_23, t0.not_activated_email_send_at AS not_activated_email_send_at_24, t0.auto_redirect_url AS auto_redirect_url_25 FROM oauth_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 |
---|---|
FOS\OAuthServerBundle\Entity\Client | No errors. |
App\Entity\Client | No errors. |
FOS\OAuthServerBundle\Entity\AccessToken | No errors. |
App\Entity\AccessToken | No errors. |
FOS\OAuthServerBundle\Entity\RefreshToken | No errors. |
App\Entity\RefreshToken | No errors. |
App\Entity\User | No errors. |