Query Metrics
9
Database Queries
6
Different statements
12.19 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.54 ms (45.45%) |
2 |
"COMMIT"
Parameters:
[] |
4.20 ms (34.44%) |
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.02 ms (8.38%) |
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.55 ms (4.53%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.47 ms (3.82%) |
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.41 ms (3.37%) |
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. |
League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
League\Bundle\OAuth2ServerBundle\Model\Client | No errors. |