Query Metrics
10
Database Queries
7
Different statements
20.97 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.86 ms (61.31%) |
2 |
"COMMIT"
Parameters:
[] |
4.67 ms (22.26%) |
1 |
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:
[] |
1.17 ms (5.58%) |
2 |
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"
]
|
0.86 ms (4.12%) |
1 |
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:
[] |
0.56 ms (2.69%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.46 ms (2.21%) |
1 |
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" ] |
0.38 ms (1.83%) |
1 |
UPDATE oauth2_client SET grants = ? WHERE identifier = ?
Parameters:
[ "password refresh_token refresh_with_password support_login" "84ef876b15cdf83b5a7ffb21bbaa1d16" ] |
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. |