| 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 = ?
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 = 'active';
|
| 2 |
0.17 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 = ?
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 = 'active';
|
| 3 |
0.14 ms |
SELECT 1 FROM studio_config_entry LIMIT 1
SELECT 1 FROM studio_config_entry LIMIT 1;
|
| 4 |
0.13 ms |
SELECT 1 FROM studio_api_key LIMIT 1
SELECT 1 FROM studio_api_key LIMIT 1;
|
| 5 |
0.12 ms |
SELECT 1 FROM studio_user_account LIMIT 1
SELECT 1 FROM studio_user_account LIMIT 1;
|
| 6 |
0.14 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"security.app_secret_fingerprints"
]
SELECT value FROM studio_config_entry WHERE config_key = 'security.app_secret_fingerprints';
|
| 7 |
0.14 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.default_language"
]
SELECT value FROM studio_config_entry WHERE config_key = 'localization.default_language';
|
| 8 |
0.14 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.default_language"
]
SELECT value FROM studio_config_entry WHERE config_key = 'localization.default_language';
|
| 9 |
0.13 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.route_prefixes_enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = 'localization.route_prefixes_enabled';
|
| 10 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"content.home_path"
]
SELECT value FROM studio_config_entry WHERE config_key = 'content.home_path';
|
| 11 |
0.13 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.route_prefixes_enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = 'localization.route_prefixes_enabled';
|
| 12 |
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.custom_url = ? LIMIT 1
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 = '/home' LIMIT 1;
|
| 13 |
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.slug = ? AND t0.parent_uid = ? LIMIT 1
Parameters: [
"home"
"/"
]
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 = 'home' AND t0.parent_uid = '/' LIMIT 1;
|
| 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
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 = '/home' LIMIT 1;
|
| 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: [
"home"
"/"
]
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 = 'home' AND t0.parent_uid = '/' LIMIT 1;
|
| 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"
]
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 = '20000000-0000-0000-0000-000000000101' AND s0_.language = 'de' AND s0_.variant = 'default' ORDER BY s0_.field_identifier ASC;
|
| 17 |
0.13 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"
]
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 = '20000000-0000-0000-0000-000000000101';
|
| 18 |
0.13 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"
]
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 = '10000000-0000-0000-0000-000000000101';
|
| 19 |
0.18 ms |
SELECT uid FROM studio_site_menu WHERE identifier = ? AND active = 1
SELECT uid FROM studio_site_menu WHERE identifier = 'main' AND active = 1;
|
| 20 |
0.14 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"user.menu.enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = 'user.menu.enabled';
|
| 21 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"user.menu.sort_order"
]
SELECT value FROM studio_config_entry WHERE config_key = 'user.menu.sort_order';
|
| 22 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"user.menu.sort_order"
]
SELECT value FROM studio_config_entry WHERE config_key = 'user.menu.sort_order';
|
| 23 |
0.13 ms |
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters: [
"demo-module"
"demo.route"
]
SELECT value FROM studio_package_setting_entry WHERE package_name = 'demo-module' AND setting_key = 'demo.route';
|
| 24 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.route_prefixes_enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = 'localization.route_prefixes_enabled';
|
| 25 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.route_prefixes_enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = '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"
]
SELECT value FROM studio_package_setting_entry WHERE package_name = 'demo-module' AND setting_key = 'demo.route';
|
| 27 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"localization.route_prefixes_enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = 'localization.route_prefixes_enabled';
|
| 28 |
0.12 ms |
SELECT value FROM studio_package_setting_entry WHERE package_name = ? AND setting_key = ?
Parameters: [
"demo-module"
"demo.route"
]
SELECT value FROM studio_package_setting_entry WHERE package_name = 'demo-module' AND setting_key = 'demo.route';
|
| 29 |
0.13 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"site.footer_copyright"
]
SELECT value FROM studio_config_entry WHERE config_key = 'site.footer_copyright';
|
| 30 |
0.13 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"statistics.enabled"
]
SELECT value FROM studio_config_entry WHERE config_key = 'statistics.enabled';
|
| 31 |
0.12 ms |
SELECT value FROM studio_config_entry WHERE config_key = ?
Parameters: [
"statistics.respect_do_not_track"
]
SELECT value FROM studio_config_entry WHERE config_key = 'statistics.respect_do_not_track';
|
| 32 |
14.21 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: [
"40e46e43-33a0-4e8d-92a6-defe6e9ad3b7"
"2026-09-16 06:50:04"
"4428bc2bb4309827c28d174b938f31ca"
"5006a1b91f443b2ea546e1b8f2987ac15dbd4f11e3694e8658719a6f14913803"
"GET"
"/"
"/"
"content_home"
"content_home"
"public"
200
96
"chromium"
"desktop"
false
false
"84.143.5.144"
"n/a"
"n/a"
"text/html"
12684
"n/a"
"n/a"
"n/a"
"n/a"
"{"query_present":false}"
]
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
(
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)
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 ('40e46e43-33a0-4e8d-92a6-defe6e9ad3b7', '2026-09-16 06:50:04', '4428bc2bb4309827c28d174b938f31ca', '5006a1b91f443b2ea546e1b8f2987ac15dbd4f11e3694e8658719a6f14913803', 'GET', '/', '/', 'content_home', 'content_home', 'public', 200, 96, 'chromium', 'desktop', 0, 0, '84.143.5.144', 'n/a', 'n/a', 'text/html', 12684, 'n/a', 'n/a', 'n/a', 'n/a', '{\"query_present\":false}');
|
| 33 |
0.22 ms |
DELETE FROM studio_access_statistic_event WHERE occurred_at < ?
Parameters: [
"2026-06-16 06:50:04"
]
DELETE FROM studio_access_statistic_event WHERE occurred_at < '2026-06-16 06:50:04';
|