POST https://nw-flow.cloud/oauth/token

Query Metrics

6 Database Queries
5 Different statements
14.67 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.44 ms
(37.08%)
2
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret_hash AS secret_hash_3, t0.name AS name_4, t0.grant_types AS grant_types_5, t0.allowed_scopes AS allowed_scopes_6, t0.redirect_uris AS redirect_uris_7, t0.is_confidential AS is_confidential_8, t0.is_revoked AS is_revoked_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.device_id AS device_id_12 FROM oauth_client t0 WHERE t0.identifier = ? AND t0.is_revoked = ? LIMIT 1
Parameters:
[
  "59d9fe08dddbc916"
  0
]
4.27 ms
(29.11%)
1
SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.avatar_name AS avatar_name_4, t0.status AS status_5, t0.paired_at AS paired_at_6, t0.geolocation_enabled AS geolocation_enabled_7, t0.is_enabled AS is_enabled_8, t0.internet_enabled AS internet_enabled_9, t0.curfew_start AS curfew_start_10, t0.curfew_end AS curfew_end_11, t0.config_version AS config_version_12, t0.installed_config_version AS installed_config_version_13, t0.last_seen_at AS last_seen_at_14, t0.fcm_token AS fcm_token_15, t0.fcm_token_updated_at AS fcm_token_updated_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.parent_id AS parent_id_19, t0.dns_provider_id AS dns_provider_id_20, t21.id AS id_22, t21.operator AS operator_23, t21.service_name AS service_name_24, t21.descriptions AS descriptions_25, t21.primary_address AS primary_address_26, t21.secondary_address AS secondary_address_27, t21.information_url AS information_url_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30 FROM device t0 LEFT JOIN dns_provider t21 ON t0.dns_provider_id = t21.id WHERE t0.id = ?
Parameters:
[
  "019fb7de-9fa8-7912-a9af-bb0ca572e0c1"
]
2.86 ms
(19.48%)
1
INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "01a08de1-056b-772b-876d-145d57c0a368"
  "d66ab73c401a9e3775b5420ec8002335b861165204c9d5f2b3bf444cfab19b696927ecfe70721ad9"
  null
  "["device:runtime"]"
  "2026-09-11 02:47:09"
  0
  "019fb7de-a07d-77b8-82ae-79094c83a5b0"
]
1.84 ms
(12.56%)
1
"COMMIT"
Parameters:
[]
0.26 ms
(1.77%)
1
"START TRANSACTION"
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\OAuth\Entity\OAuthClient 1
App\Entity\Device 1
App\Entity\User 1
App\Entity\DnsProvider 1
App\OAuth\Entity\OAuthAccessToken 1