GET https://nw-flow.cloud/api/config

Query Metrics

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

Queries

Group similar statements

# Time Info
1 5.63 ms
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.expires_at AS expires_at_5, t0.is_revoked AS is_revoked_6, t0.client_id AS client_id_7 FROM oauth_access_token t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "b77bb356939e51b9a8f85d455f3719d496776dc874c3b224e190f2a82baca82d520076d7e98692c3"
]
2 2.01 ms
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:
[
  "d3b59237a7aed3b6"
  0
]
3 7.19 ms
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:
[
  "019f6f2e-51bc-70d5-bcea-4d26df597272"
]
4 2.36 ms
SELECT t0.id AS id_1, t0.app_identifier AS app_identifier_2, t0.app_name AS app_name_3, t0.app_icon AS app_icon_4, t0.category AS category_5, t0.play_store_url AS play_store_url_6, t0.list_type AS list_type_7, t0.daily_limit_minutes AS daily_limit_minutes_8, t0.extra_time_minutes AS extra_time_minutes_9, t0.extra_time_date AS extra_time_date_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.device_id AS device_id_13 FROM device_app_permission_override t0 WHERE t0.device_id = ?
Parameters:
[
  "019f6f2e-51bc-70d5-bcea-4d26df597272"
]
5 2.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone_number AS phone_number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.device_id AS device_id_6 FROM contact t0 WHERE t0.device_id = ?
Parameters:
[
  "019f6f2e-51bc-70d5-bcea-4d26df597272"
]
6 1.16 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_limit_minutes AS daily_limit_minutes_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.device_id AS device_id_6 FROM device_app_category_limit t0 WHERE t0.device_id = ?
Parameters:
[
  "019f6f2e-51bc-70d5-bcea-4d26df597272"
]

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\Entity\DeviceAppPermissionOverride 2
App\OAuth\Entity\OAuthAccessToken 1
App\OAuth\Entity\OAuthClient 1
App\Entity\Device 1
App\Entity\User 1