Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.ip_or_cidr AS ip_or_cidr_1,
  r0_.label AS label_2,
  r0_.is_active AS is_active_3,
  r0_.expires_at AS expires_at_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6,
  r0_.created_by_id AS created_by_id_7
FROM
  rate_limit_whitelist r0_
WHERE
  r0_.is_active = true
  AND (
    r0_.expires_at IS NULL
    OR r0_.expires_at > ?
  )

SELECT r0_.id AS id_0, r0_.ip_or_cidr AS ip_or_cidr_1, r0_.label AS label_2, r0_.is_active AS is_active_3, r0_.expires_at AS expires_at_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by_id AS created_by_id_7 FROM rate_limit_whitelist r0_ WHERE r0_.is_active = true AND (r0_.expires_at IS NULL OR r0_.expires_at > '2026-09-11 02:47:03');

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

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 = 'd66ab73c401a9e3775b5420ec8002335b861165204c9d5f2b3bf444cfab19b696927ecfe70721ad9' 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

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 = '59d9fe08dddbc916' 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 = ?

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 = '019fb7de-9fa8-7912-a9af-bb0ca572e0c1';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  device
SET
  last_seen_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE device SET last_seen_at = '2026-09-11 02:47:03', updated_at = '2026-09-11 02:47:03' WHERE id = '019fb7de-9fa8-7912-a9af-bb0ca572e0c1';

"COMMIT"

"COMMIT";

SELECT
  d0_.id AS id_0,
  d0_.list_type AS list_type_1,
  d0_.daily_limit_minutes AS daily_limit_minutes_2,
  d0_.created_at AS created_at_3,
  d0_.updated_at AS updated_at_4,
  a1_.id AS id_5,
  a1_.app_identifier AS app_identifier_6,
  a1_.app_name AS app_name_7,
  a1_.app_icon AS app_icon_8,
  a1_.category AS category_9,
  a1_.play_store_url AS play_store_url_10,
  a1_.descriptions AS descriptions_11,
  a1_.fetched_at AS fetched_at_12,
  a1_.created_at AS created_at_13,
  a1_.updated_at AS updated_at_14,
  d0_.app_id AS app_id_15
FROM
  default_app_permission d0_
  INNER JOIN app_catalog_cache a1_ ON d0_.app_id = a1_.id
ORDER BY
  a1_.app_name ASC

SELECT d0_.id AS id_0, d0_.list_type AS list_type_1, d0_.daily_limit_minutes AS daily_limit_minutes_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, a1_.id AS id_5, a1_.app_identifier AS app_identifier_6, a1_.app_name AS app_name_7, a1_.app_icon AS app_icon_8, a1_.category AS category_9, a1_.play_store_url AS play_store_url_10, a1_.descriptions AS descriptions_11, a1_.fetched_at AS fetched_at_12, a1_.created_at AS created_at_13, a1_.updated_at AS updated_at_14, d0_.app_id AS app_id_15 FROM default_app_permission d0_ INNER JOIN app_catalog_cache a1_ ON d0_.app_id = a1_.id ORDER BY a1_.app_name ASC;

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

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 = '019fb7de-9fa8-7912-a9af-bb0ca572e0c1';

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

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 = '019fb7de-9fa8-7912-a9af-bb0ca572e0c1';

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

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 = '019fb7de-9fa8-7912-a9af-bb0ca572e0c1';