GET https://dev.aavion.media/

Query Metrics

32 Database Queries
14 Different statements
19.24 ms Query time
0 Invalid entities
9 Managed entities

Grouped Statements

Show all queries

Time Count Info
14.81 ms
(76.96%)
1
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:
[
  "a0ce7277-211e-476d-b1a5-5c7d0fb8a553"
  "2026-09-16 06:08:43"
  "30ee48cdf4508fdd4da014786ba21406"
  "f3c890230da56fa084222967d05ff64d4200bc6226ed398b9868ca8779b42f32"
  "GET"
  "/"
  "/"
  "content_home"
  "content_home"
  "public"
  200
  90
  "bot"
  "bot"
  true
  false
  "n/a"
  "n/a"
  "n/a"
  "text/html"
  12684
  "n/a"
  "n/a"
  "n/a"
  "n/a"
  "{"query_present":false}"
]
1.77 ms
(9.18%)
14
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters:
[
  "security.app_secret_fingerprints"
]
0.39 ms
(2.02%)
3
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters:
[
  "demo-module"
  "demo.route"
]
0.32 ms
(1.68%)
2
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"
]
0.31 ms
(1.62%)
2
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"
]
0.29 ms
(1.53%)
1
DELETE FROM studio_access_statistic_event WHERE occurred_at < ?
Parameters:
[
  "2026-06-16 06:08:43"
]
0.29 ms
(1.51%)
2
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"
  "/"
]
0.21 ms
(1.11%)
1
SELECT uid FROM studio_site_menu WHERE identifier = ? AND active = 1
Parameters:
[
  "main"
]
0.15 ms
(0.77%)
1
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"
]
0.14 ms
(0.74%)
1
SELECT 1 FROM studio_config_entry LIMIT 1
Parameters:
[]
0.14 ms
(0.73%)
1
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"
]
0.14 ms
(0.72%)
1
SELECT 1 FROM studio_api_key LIMIT 1
Parameters:
[]
0.14 ms
(0.72%)
1
SELECT 1 FROM studio_user_account LIMIT 1
Parameters:
[]
0.14 ms
(0.71%)
1
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"
]

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