Query Metrics
10
Database Queries
7
Different statements
30.03 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 7.37 ms |
SELECT t0_.id AS id_0, t0_.`content` AS content_1, t0_.lastTranslationUpdate AS lastTranslationUpdate_2, t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3, t0_.lastTranslationPageToken AS lastTranslationPageToken_4, t0_.firstTranslationUpdate AS firstTranslationUpdate_5 FROM `TranslationFile` t0_ ORDER BY t0_.id DESC LIMIT 1
Parameters:
[] |
2 | 1.77 ms |
SELECT u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.type AS type_13, u0_.country_id AS country_id_14, u0_.onBoarding_status AS onBoarding_status_15 FROM `User` u0_ WHERE u0_.type IN ('ROLE_SUPPORT_GUY') LIMIT 1
Parameters:
[] |
3 | 0.84 ms |
SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8 FROM oauth2_client t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
"3134d4630a4004967880d867de562394"
]
|
4 | 0.54 ms |
"START TRANSACTION"
Parameters:
[] |
5 | 0.69 ms |
UPDATE oauth2_client SET redirect_uris = ?, grants = ? WHERE identifier = ?
Parameters:
[ "constellation://client https://develop.constellationdelours.com/client https://constellation.constellation.cool/client https://constellation.nanomonx.com/client https://www.constellationdelours.com/client https://www.borealtales.com/client" "password refresh_token refresh_with_password authorization_code" "3134d4630a4004967880d867de562394" ] |
6 | 9.80 ms |
"COMMIT"
Parameters:
[] |
7 | 0.75 ms |
SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8 FROM oauth2_client t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
"84ef876b15cdf83b5a7ffb21bbaa1d16"
]
|
8 | 0.69 ms |
"START TRANSACTION"
Parameters:
[] |
9 | 0.72 ms |
UPDATE oauth2_client SET grants = ? WHERE identifier = ?
Parameters:
[ "password refresh_token refresh_with_password support_login" "84ef876b15cdf83b5a7ffb21bbaa1d16" ] |
10 | 6.85 ms |
"COMMIT"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
NanomonxManager | doctrine.orm.NanomonxManager_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\TranslationFile | No errors. |
App\Entity\Troubadour\Challenge | No errors. |
App\Entity\BaseUser | No errors. |
App\Entity\SupportUser | No errors. |
App\Entity\Country | No errors. |
App\Entity\OnBoardingStatus | No errors. |
League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
League\Bundle\OAuth2ServerBundle\Model\Client | No errors. |