Query Metrics

3 Database Queries
3 Different statements
0.57 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.28 ms
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"
]
2 0.08 ms
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
]
3 0.21 ms
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
]

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.