Query Metrics

7 Database Queries
7 Different statements
20.71 ms Query time
0 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.32 ms
(20.88%)
1
SELECT d0_.id AS id_0, d0_.app_identifier AS app_identifier_1, d0_.date AS date_2, d0_.minutes_used AS minutes_used_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.device_id AS device_id_6 FROM device_app_usage d0_ WHERE d0_.device_id = ? AND d0_.date >= ? ORDER BY d0_.date ASC, d0_.app_identifier ASC
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#1460
    __toString(): "019eac94-cff8-79b3-bfae-65cf0238021a"
  }
  "2026-06-12"
]
3.78 ms
(18.25%)
1
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:
[
  "019eac94-cff8-79b3-bfae-65cf0238021a"
]
3.67 ms
(17.71%)
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:
[
  "019eac94-cff8-79b3-bfae-65cf0238021a"
]
3.33 ms
(16.06%)
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 = ? LIMIT 1
Parameters:
[
  "908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f"
]
2.32 ms
(11.18%)
1
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:
[
  "019eac94-cff8-79b3-bfae-65cf0238021a"
]
2.12 ms
(10.24%)
1
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 > ?)
Parameters:
[
  "2026-06-12 09:48:55"
]
1.18 ms
(5.69%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.is_email_verified AS is_email_verified_5, t0.is_active AS is_active_6, t0.failed_login_attempts AS failed_login_attempts_7, t0.locked_until AS locked_until_8, t0.pending_email AS pending_email_9, t0.pending_email_requested_at AS pending_email_requested_at_10, t0.scheduled_for_deletion_at AS scheduled_for_deletion_at_11, t0.age_verified_at AS age_verified_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  "019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]

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