Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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

[
  "b99808bae3ddd3f8"
  0
]

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

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 = 'b99808bae3ddd3f8' AND t0.is_revoked = 0 LIMIT 1;

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

[
  "b99808bae3ddd3f8"
  0
]

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

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 = 'b99808bae3ddd3f8' AND t0.is_revoked = 0 LIMIT 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 = ?

[
  "019fa45c-04cd-778a-bdda-69d054e1b783"
]

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 = ?

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 = '019fa45c-04cd-778a-bdda-69d054e1b783';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES (?, ?, ?, ?, ?, ?, ?)

[
  "019fa54a-6424-7494-bf4a-43a2f88c7077"
  "ba8604e20dab4446450b883b72998ef08068cef949f4b73ac4a6985dac7f461f8d1428caf473ad0a"
  null
  "["device:preauth"]"
  "2026-07-27 22:50:43"
  0
  "019fa45c-05bb-71ee-9825-97a045d32034"
]

INSERT INTO oauth_access_token (
  id, identifier, user_identifier, scopes,
  expires_at, is_revoked, client_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO oauth_access_token (id, identifier, user_identifier, scopes, expires_at, is_revoked, client_id) VALUES ('019fa54a-6424-7494-bf4a-43a2f88c7077', 'ba8604e20dab4446450b883b72998ef08068cef949f4b73ac4a6985dac7f461f8d1428caf473ad0a', NULL, '[\"device:preauth\"]', '2026-07-27 22:50:43', 0, '019fa45c-05bb-71ee-9825-97a045d32034');

"COMMIT"

[]

"COMMIT"

"COMMIT";