Symfony Profiler

GET https://beratungimzentrum.a4interactive.ch/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DApp%255CController%255CSnippetController%253A%253Afoote…

Response: 200 OK
IP: 216.73.217.139
Profiled on: Sun, 19 Apr 2026 13:12:50 +0200
Token: 1a7f1a

Query Metrics

64 Database Queries

18 Different statements

11.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
5.99 ms (52.71%)	36	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1776597170 "site_domain_fc87488153f280604507b1c2895d7183"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_fc87488153f280604507b1c2895d7183');
0.63 ms (5.58%)	4	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?) Parameters: [`1776597170 "document_22\x01tags\x01" "asset_34\x01tags\x01" "asset_90\x01tags\x01" "asset_33\x01tags\x01" "asset_98\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_22tags', 'asset_34tags', 'asset_90tags', 'asset_33tags', 'asset_98tags');
0.61 ms (5.40%)	4	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1776597170 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
0.59 ms (5.21%)	2	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/unternehmen/susanne-schuermann" "path" "auto_create" "/unternehmen/susanne-schuermann" "path_query" "https://beratungimzentrum.a4interactive.ch/unternehmen/susanne-schuermann" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/unternehmen/susanne-schuermann' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/unternehmen/susanne-schuermann' AND `type` = 'path_query') OR (source = 'https://beratungimzentrum.a4interactive.ch/unternehmen/susanne-schuermann' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
0.47 ms (4.10%)	3	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1776597170 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
0.45 ms (3.96%)	2	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 22;
0.38 ms (3.36%)	2	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
0.31 ms (2.75%)	1	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [1776597170 "output\x01tags\x01" "navigation\x01tags\x01" "document_12\x01tags\x01" "document_36\x01tags\x01" "document_47\x01tags\x01" "document_29\x01tags\x01" "document_21\x01tags\x01" "document_22\x01tags\x01" "document_41\x01tags\x01" "document_4\x01tags\x01" "document_15\x01tags\x01" "document_23\x01tags\x01" "document_43\x01tags\x01" "document_24\x01tags\x01" "document_5\x01tags\x01" "document_18\x01tags\x01" "document_25\x01tags\x01" "document_26\x01tags\x01" "document_6\x01tags\x01" "document_27\x01tags\x01" "document_7\x01tags\x01" "document_9\x01tags\x01" "document_10\x01tags\x01" "document_11\x01tags\x01" "document_44\x01tags\x01" "document_8\x01tags\x01" "document_2\x01tags\x01"] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_12tags', 'document_36tags', 'document_47tags', 'document_29tags', 'document_21tags', 'document_22tags', 'document_41tags', 'document_4tags', 'document_15tags', 'document_23tags', 'document_43tags', 'document_24tags', 'document_5tags', 'document_18tags', 'document_25tags', 'document_26tags', 'document_6tags', 'document_27tags', 'document_7tags', 'document_9tags', 'document_10tags', 'document_11tags', 'document_44tags', 'document_8tags', 'document_2tags');
0.26 ms (2.29%)	1	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`4`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 4) AND published = 1 ORDER BY `index` ASC ;
0.23 ms (2.06%)	1	SELECT customSettings FROM assets WHERE id = ? Parameters: [`98`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 98;
0.21 ms (1.81%)	1	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/unternehmen/" "susanne-schuermann"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/unternehmen/' AND `key` = BINARY 'susanne-schuermann';
0.20 ms (1.74%)	1	SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;
0.19 ms (1.70%)	1	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
0.18 ms (1.61%)	1	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
0.18 ms (1.56%)	1	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`98`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 98;
0.16 ms (1.43%)	1	SELECT * FROM object_url_slugs WHERE slug = '/unternehmen/susanne-schuermann' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/unternehmen/susanne-schuermann' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/unternehmen/susanne-schuermann' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.16 ms (1.37%)	1	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1776597170 "document_21\x01tags\x01" "asset_34\x01tags\x01" "asset_89\x01tags\x01" "asset_33\x01tags\x01" "asset_92\x01tags\x01" "asset_93\x01tags\x01" "document_29\x01tags\x01" "asset_36\x01tags\x01" "asset_100\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_21tags', 'asset_34tags', 'asset_89tags', 'asset_33tags', 'asset_92tags', 'asset_93tags', 'document_29tags', 'asset_36tags', 'asset_100tags');
0.15 ms (1.35%)	1	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?) Parameters: [`1776597170 "document_12\x01tags\x01" "asset_34\x01tags\x01" "asset_120\x01tags\x01" "asset_33\x01tags\x01" "asset_249\x01tags\x01" "asset_99\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1776597170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12tags', 'asset_34tags', 'asset_120tags', 'asset_33tags', 'asset_249tags', 'asset_99tags');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.