GET https://10.2.1.246:1000/health

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

Group similar statements

# 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