Query Metrics
6
Database Queries
5
Different statements
3.04 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.19 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
]
|
2 | 0.38 ms |
SELECT t0.random_id AS random_id_1, t0.redirect_uris AS redirect_uris_2, t0.secret AS secret_3, t0.allowed_grant_types AS allowed_grant_types_4, t0.id AS id_5 FROM client t0 WHERE t0.id = ? AND t0.random_id = ? LIMIT 1
Parameters:
[ "1" "3izavita75uscggc48cow448g4og4ow0cosggogwksos4ockgo" ] |
3 | 1.12 ms |
SELECT t0.random_id AS random_id_1, t0.redirect_uris AS redirect_uris_2, t0.secret AS secret_3, t0.allowed_grant_types AS allowed_grant_types_4, t0.id AS id_5 FROM client t0 WHERE t0.id = ? AND t0.random_id = ? LIMIT 1
Parameters:
[ "1" "3izavita75uscggc48cow448g4og4ow0cosggogwksos4ockgo" ] |
4 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
5 | 1.12 ms |
INSERT INTO auth_code (token, redirect_uri, expires_at, scope, client_id, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "MDk5NDg0ZjgxYWNlNzU2ZGJhY2UzMTYwZWI4ZGZmOGRjMzgyNGJmYjVhNTI0N2E5ZmU3OTc4OGUwNTY3YjgwOQ" 2 => "http://127.0.0.1:8283/login_check" 3 => 1751273360 4 => null 5 => 1 6 => 1 ] |
6 | 0.12 ms |
"COMMIT"
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
FOS\OAuthServerBundle\Entity\AccessToken | No errors. |
App\Entity\AccessToken | No errors. |
FOS\OAuthServerBundle\Entity\Client | No errors. |
App\Entity\Client | No errors. |
FOS\OAuthServerBundle\Entity\RefreshToken | No errors. |
App\Entity\RefreshToken | No errors. |
FOS\OAuthServerBundle\Entity\AuthCode | No errors. |
App\Entity\AuthCode | No errors. |