GET https://dev.aavion.media/demo/backend

Query Metrics

22 Database Queries
10 Different statements
16.32 ms Query time
0 Invalid entities
1 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.15 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.14 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "security.app_secret_fingerprints"
]
7 0.15 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.default_language"
]
8 0.14 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.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
11 0.12 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "localization.route_prefixes_enabled"
]
12 0.16 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:
[
  "/demo/backend"
]
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:
[
  "demo"
  "/"
]
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:
[
  "/demo/backend"
]
15 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.slug = ? AND t0.parent_uid = ? LIMIT 1
Parameters:
[
  "demo"
  "/"
]
16 0.13 ms
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
17 0.18 ms
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
18 0.15 ms
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
19 0.15 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "statistics.enabled"
]
20 0.13 ms
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "statistics.respect_do_not_track"
]
21 13.28 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:
[
  "ff0a3171-3b23-485a-9bcc-5b2691127fb1"
  "2026-09-16 07:03:16"
  "29473582ec7655c57b699c323340b127"
  "f3c890230da56fa084222967d05ff64d4200bc6226ed398b9868ca8779b42f32"
  "GET"
  "/demo/backend"
  "/demo/backend"
  "content_show"
  "content_show"
  "public"
  200
  79
  "bot"
  "bot"
  true
  false
  "n/a"
  "n/a"
  "n/a"
  "text/html"
  24772
  "n/a"
  "n/a"
  "n/a"
  "n/a"
  "{"query_present":false}"
]
22 0.21 ms
DELETE FROM studio_access_statistic_event WHERE occurred_at < ?
Parameters:
[
  "2026-06-16 07:03:16"
]

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\ExtensionPackage 1

Entities Mapping

Class Mapping errors
App\Entity\ExtensionPackage No errors.
App\Entity\ContentItem No errors.
App\Entity\ContentSchema No errors.
App\Entity\ContentRevision No errors.