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
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 = '019eac94-cff8-79b3-bfae-65cf0238021a' AND d0_.date >= '2026-06-12' ORDER BY d0_.date ASC, d0_.app_identifier ASC;
|
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"
]
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 = '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"
]
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 = '019eac94-cff8-79b3-bfae-65cf0238021a';
|
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"
]
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 = '019e1fdf-3da9-71cb-b195-c6c4c6513e7f';
|