GET https://device-a3d49790-99d3-4482-ba0f-fdd785efe3dc.remotewd.com/

Query Metrics

33 Database Queries
14 Different statements
25.00 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.16 ms
SELECT t0.uid AS uid_1, t0.package_scopes AS package_scopes_2, t0.package_name AS package_name_3, t0.path AS path_4, t0.manifest_version AS manifest_version_5, t0.installed_version AS installed_version_6, t0.available_version AS available_version_7, t0.status AS status_8, t0.metadata AS metadata_9, t0.modified_at AS modified_at_10 FROM studio_extension_package t0 WHERE t0.status = ?
Parameters:
[
  "active"
]
2 0.16 ms
SELECT t0.uid AS uid_1, t0.package_scopes AS package_scopes_2, t0.package_name AS package_name_3, t0.path AS path_4, t0.manifest_version AS manifest_version_5, t0.installed_version AS installed_version_6, t0.available_version AS available_version_7, t0.status AS status_8, t0.metadata AS metadata_9, t0.modified_at AS modified_at_10 FROM studio_extension_package t0 WHERE t0.status = ?
Parameters:
[
  "active"
]
3 0.14 ms
SELECT 1 FROM studio_config_entry LIMIT 1
Parameters:
[]
4 0.13 ms
SELECT 1 FROM studio_api_key LIMIT 1
Parameters:
[]
5 0.13 ms
SELECT 1 FROM studio_user_account LIMIT 1
Parameters:
[]
6 0.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "security.app_secret_fingerprints"
]
7 0.14 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.default_language"
]
8 0.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.default_language"
]
9 0.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
10 0.14 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "content.home_path"
]
11 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
12 0.14 ms
SELECT t0.uid AS uid_1, t0.slug AS slug_2, t0.status AS status_3, t0.parent_uid AS parent_uid_4, t0.sort_order AS sort_order_5, t0.custom_url AS custom_url_6, t0.redirect_target AS redirect_target_7, t0.schema_version AS schema_version_8, t0.version AS version_9, t0.available_languages AS available_languages_10, t0.available_variants AS available_variants_11, t0.visibility AS visibility_12, t0.acl_restrictions AS acl_restrictions_13, t0.view_min_level AS view_min_level_14, t0.view_group_identifiers AS view_group_identifiers_15, t0.edit_min_level AS edit_min_level_16, t0.edit_group_identifiers AS edit_group_identifiers_17, t0.manage_min_level AS manage_min_level_18, t0.manage_group_identifiers AS manage_group_identifiers_19, t0.metadata AS metadata_20, t0.schema_uid AS schema_uid_21, t0.active_revision_uid AS active_revision_uid_22 FROM studio_content_item t0 WHERE t0.custom_url = ? LIMIT 1
Parameters:
[
  "/home"
]
13 0.15 ms
SELECT t0.uid AS uid_1, t0.slug AS slug_2, t0.status AS status_3, t0.parent_uid AS parent_uid_4, t0.sort_order AS sort_order_5, t0.custom_url AS custom_url_6, t0.redirect_target AS redirect_target_7, t0.schema_version AS schema_version_8, t0.version AS version_9, t0.available_languages AS available_languages_10, t0.available_variants AS available_variants_11, t0.visibility AS visibility_12, t0.acl_restrictions AS acl_restrictions_13, t0.view_min_level AS view_min_level_14, t0.view_group_identifiers AS view_group_identifiers_15, t0.edit_min_level AS edit_min_level_16, t0.edit_group_identifiers AS edit_group_identifiers_17, t0.manage_min_level AS manage_min_level_18, t0.manage_group_identifiers AS manage_group_identifiers_19, t0.metadata AS metadata_20, t0.schema_uid AS schema_uid_21, t0.active_revision_uid AS active_revision_uid_22 FROM studio_content_item t0 WHERE t0.slug = ? AND t0.parent_uid = ? LIMIT 1
Parameters:
[
  "home"
  "/"
]
14 0.14 ms
SELECT t0.uid AS uid_1, t0.slug AS slug_2, t0.status AS status_3, t0.parent_uid AS parent_uid_4, t0.sort_order AS sort_order_5, t0.custom_url AS custom_url_6, t0.redirect_target AS redirect_target_7, t0.schema_version AS schema_version_8, t0.version AS version_9, t0.available_languages AS available_languages_10, t0.available_variants AS available_variants_11, t0.visibility AS visibility_12, t0.acl_restrictions AS acl_restrictions_13, t0.view_min_level AS view_min_level_14, t0.view_group_identifiers AS view_group_identifiers_15, t0.edit_min_level AS edit_min_level_16, t0.edit_group_identifiers AS edit_group_identifiers_17, t0.manage_min_level AS manage_min_level_18, t0.manage_group_identifiers AS manage_group_identifiers_19, t0.metadata AS metadata_20, t0.schema_uid AS schema_uid_21, t0.active_revision_uid AS active_revision_uid_22 FROM studio_content_item t0 WHERE t0.custom_url = ? LIMIT 1
Parameters:
[
  "/home"
]
15 0.15 ms
SELECT t0.uid AS uid_1, t0.slug AS slug_2, t0.status AS status_3, t0.parent_uid AS parent_uid_4, t0.sort_order AS sort_order_5, t0.custom_url AS custom_url_6, t0.redirect_target AS redirect_target_7, t0.schema_version AS schema_version_8, t0.version AS version_9, t0.available_languages AS available_languages_10, t0.available_variants AS available_variants_11, t0.visibility AS visibility_12, t0.acl_restrictions AS acl_restrictions_13, t0.view_min_level AS view_min_level_14, t0.view_group_identifiers AS view_group_identifiers_15, t0.edit_min_level AS edit_min_level_16, t0.edit_group_identifiers AS edit_group_identifiers_17, t0.manage_min_level AS manage_min_level_18, t0.manage_group_identifiers AS manage_group_identifiers_19, t0.metadata AS metadata_20, t0.schema_uid AS schema_uid_21, t0.active_revision_uid AS active_revision_uid_22 FROM studio_content_item t0 WHERE t0.slug = ? AND t0.parent_uid = ? LIMIT 1
Parameters:
[
  "home"
  "/"
]
16 0.15 ms
SELECT s0_.uid AS uid_0, s0_.language AS language_1, s0_.variant AS variant_2, s0_.field_identifier AS field_identifier_3, s0_.field_content AS field_content_4, s0_.revision_uid AS revision_uid_5 FROM studio_content_field_value s0_ WHERE s0_.revision_uid = ? AND s0_.language = ? AND s0_.variant = ? ORDER BY s0_.field_identifier ASC
Parameters:
[
  "20000000-0000-0000-0000-000000000101"
  "de"
  "default"
]
17 0.14 ms
SELECT t0.uid AS uid_1, t0.version AS version_2, t0.change_summary AS change_summary_3, t0.metadata AS metadata_4, t0.content_uid AS content_uid_5, t0.schema_uid AS schema_uid_6, t0.schema_version_uid AS schema_version_uid_7 FROM studio_content_revision t0 WHERE t0.uid = ?
Parameters:
[
  "20000000-0000-0000-0000-000000000101"
]
18 0.14 ms
SELECT t0.uid AS uid_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.definition AS definition_5, t0.custom_twig AS custom_twig_6, t0.definition_hash AS definition_hash_7, t0.use_min_level AS use_min_level_8, t0.use_group_identifiers AS use_group_identifiers_9, t0.edit_min_level AS edit_min_level_10, t0.edit_group_identifiers AS edit_group_identifiers_11, t0.manage_min_level AS manage_min_level_12, t0.manage_group_identifiers AS manage_group_identifiers_13, t0.metadata AS metadata_14, t0.schema_uid AS schema_uid_15 FROM studio_content_schema_version t0 WHERE t0.uid = ?
Parameters:
[
  "10000000-0000-0000-0000-000000000101"
]
19 0.19 ms
SELECT uid FROM studio_site_menu WHERE identifier = ? AND active = 1
Parameters:
[
  "main"
]
20 0.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "user.menu.enabled"
]
21 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "user.menu.sort_order"
]
22 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "user.menu.sort_order"
]
23 0.14 ms
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
24 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
25 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
26 0.12 ms
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
27 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
28 0.13 ms
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
29 0.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "site.footer_copyright"
]
30 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "statistics.enabled"
]
31 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "statistics.respect_do_not_track"
]
32 13.56 ms
INSERT INTO studio_access_statistic_event (uid, occurred_at, request_id, visitor_id, method, path, requested_path, route, resolved_route, surface, http_status, duration_ms, browser_family, device_type, is_bot, do_not_track, referrer_host, preferred_language, request_content_type, response_content_type, response_size, city, state, country, continent, metadata) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "e67e77b2-9626-4453-ab24-48565ce59a50"
  "2026-09-16 16:06:32"
  "e492283373bcb4eb68937408154c634b"
  "acf5ce49260fd50fd9123c3e56b54cb32adf39d16d03172b1661eefb9d815ef4"
  "GET"
  "/"
  "/"
  "content_home"
  "content_home"
  "public"
  200
  97
  "chromium"
  "desktop"
  false
  false
  "n/a"
  "en-us"
  "n/a"
  "text/html"
  12684
  "n/a"
  "n/a"
  "n/a"
  "n/a"
  "{"query_present":false}"
]
33 7.22 ms
DELETE FROM studio_access_statistic_event WHERE occurred_at < ?
Parameters:
[
  "2026-06-16 16:06:32"
]

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\ContentFieldValue 4
App\Entity\ExtensionPackage 1
App\Entity\ContentItem 1
App\Entity\ContentSchema 1
App\Entity\ContentRevision 1
App\Entity\ContentSchemaVersion 1

Entities Mapping