Symfony Profiler

Query Metrics

35 Database Queries

15 Different statements

11.23 ms Query time

0 Invalid entities

Queries


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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT * FROM tmp_store WHERE id = ?
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 > ? 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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
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 > ? 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 > ? 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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
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 > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM object_url_slugs WHERE slug = '/de/Schutzzaeune-alt' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT date FROM http_error_log WHERE uri = ?
INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 ORDER BY `priority` DESC
SELECT * FROM settings_store WHERE id = ? AND scope = ?
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 translations_messages LIMIT 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 (?)
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 * FROM translations_messages LIMIT 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 (?)

#▲	Time	Info
1	0.31 ms	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: [`1735042254 "site_domain_5061e09f81735ede2c26d4894faa91ad"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_5061e09f81735ede2c26d4894faa91ad');
2	0.21 ms	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: [`1735042254 "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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.21 ms	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';
4	0.40 ms	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: [`"/de/Schutzzaeune-alt" "path" "auto_create" "/de/Schutzzaeune-alt" "path_query" "http://45.132.247.172:85/de/Schutzzaeune-alt" "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 = '/de/Schutzzaeune-alt' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Schutzzaeune-alt' AND `type` = 'path_query') OR (source = 'http://45.132.247.172:85/de/Schutzzaeune-alt' 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;
5	0.18 ms	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: [`1735042254 "system_route_redirect"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.16 ms	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: [`1735042254 "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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.16 ms	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';
8	0.14 ms	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: [`1735042254 "output_af65fc9f619722414654d389b196ec1a_desktop"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_af65fc9f619722414654d389b196ec1a_desktop');
9	0.13 ms	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: [`1735042254 "\x00tags\x00output_af65fc9f619722414654d389b196ec1a_desktop"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_af65fc9f619722414654d389b196ec1a_desktop');
10	0.23 ms	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: [`1735042254 "output_af65fc9f619722414654d389b196ec1a"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_af65fc9f619722414654d389b196ec1a');
11	0.14 ms	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: [`1735042254 "\x00tags\x00output_af65fc9f619722414654d389b196ec1a"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_af65fc9f619722414654d389b196ec1a');
12	0.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
13	0.38 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/de/" "Schutzzaeune-alt"`] 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 '/de/' AND `key` = BINARY 'Schutzzaeune-alt';
14	0.19 ms	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: [`1735042254 "document_1899"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1899');
15	0.21 ms	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: [`1735042254 "document_1899\x01tags\x01" "asset_9177\x01tags\x01" "asset_9178\x01tags\x01" "asset_9179\x01tags\x01" "asset_9176\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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1899tags', 'asset_9177tags', 'asset_9178tags', 'asset_9179tags', 'asset_9176tags');
16	0.17 ms	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: [`1735042254 "sites_path_mapping"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
17	0.16 ms	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: [`1735042254 "\x00tags\x00sites_path_mapping"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');
18	0.20 ms	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 ;
19	0.24 ms	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: [`1735042254 "document_properties_1899"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_1899');
20	0.23 ms	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: [`1735042254 "document_properties\x01tags\x01" "document_1899\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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_1899tags');
21	0.24 ms	SELECT * FROM object_url_slugs WHERE slug = '/de/Schutzzaeune-alt' 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 = '/de/Schutzzaeune-alt' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/de/Schutzzaeune-alt' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
22	0.20 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
23	0.17 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"1" "pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = '1' AND scope = 'pimcore_staticroutes';
24	0.23 ms	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';
25	0.21 ms	SELECT date FROM http_error_log WHERE uri = ? Parameters: [`"http://45.132.247.172:85/de/Schutzzaeune-alt"`] View formatted query View runnable query Explain query SELECT date FROM http_error_log WHERE uri = ? SELECT date FROM http_error_log WHERE uri = 'http://45.132.247.172:85/de/Schutzzaeune-alt';
26	2.73 ms	INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["http://45.132.247.172:85/de/Schutzzaeune-alt" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:63:{s:8:"HOSTNAME";s:12:"62a73504f967";s:11:"PHP_INI_DIR";s:18:"/usr/local/etc/php";s:21:"COMPOSER_MEMORY_LIMIT";s:2:"-1";s:17:"WEB_DOCUMENT_ROOT";s:14:"/var/www/html/";s:4:"HOME";s:8:"/var/www";s:11:"PHP_LDFLAGS";s:12:"-Wl,-O1 -pie";s:10:"PHP_CFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:11:"PHP_VERSION";s:5:"8.2.5";s:13:"COMPOSER_HOME";s:10:"/.composer";s:8:"GPG_KEYS";s:122:"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC";s:12:"PHP_CPPFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:11:"PHP_ASC_URL";s:54:"https://www.php.net/distributions/php-8.2.5.tar.xz.asc";s:24:"COMPOSER_ALLOW_SUPERUSER";s:1:"1";s:7:"PHP_URL";s:50:"https://www.php.net/distributions/php-8.2.5.tar.xz";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:11:"PHPIZE_DEPS";s:76:"autoconf \t\tdpkg-dev \t\tfile \t\tg++ \t\tgcc \t\tlibc-dev \t\tmake \t\tpkg-config \t\tre2c";s:3:"PWD";s:13:"/var/www/html";s:10:"PHP_SHA256";s:64:"800738c359b7f1e67e40c22713d2d90276bc85ba1c21b43d99edd43c254c5f76";s:4:"USER";s:8:"www-data";s:9:"HTTP_HOST";s:17:"45.132.247.172:85";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, br, zstd, deflate";s:15:"HTTP_USER_AGENT";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:11:"HTTP_ACCEPT";s:3:"/";s:15:"SCRIPT_FILENAME";s:30:"/var/www/html/public/index.php";s:9:"PATH_INFO";s:0:"";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"SERVER_NAME";s:0:"";s:11:"SERVER_PORT";s:2:"80";s:11:"SERVER_ADDR";s:10:"172.24.0.7";s:11:"REMOTE_PORT";s:5:"14660";s:11:"REMOTE_ADDR";s:12:"3.145.92.213";s:15:"SERVER_SOFTWARE";s:12:"nginx/1.24.0";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:14:"REQUEST_SCHEME";s:4:"http";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:13:"DOCUMENT_ROOT";s:20:"/var/www/html/public";s:12:"DOCUMENT_URI";s:10:"/index.php";s:11:"REQUEST_URI";s:20:"/de/Schutzzaeune-alt";s:11:"SCRIPT_NAME";s:10:"/index.php";s:14:"CONTENT_LENGTH";s:0:"";s:12:"CONTENT_TYPE";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1735042254.261523;s:12:"REQUEST_TIME";i:1735042254;s:4:"argv";a:0:{}s:4:"argc";i:0;s:7:"APP_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:16:"PIMCORE_DEV_MODE";s:5:"false";s:10:"APP_SECRET";s:32:"SLZYfFJ3GeFS9ZQEKVJn3UKPc8ouYMAm";s:15:"PROJECT_DB_USER";s:7:"pimcore";s:15:"PROJECT_DB_PASS";s:7:"pimcore";s:10:"PROJECT_DB";s:7:"pimcore";s:7:"DB_HOST";s:2:"db";s:25:"PROJECT_DB_SERVER_VERSION";s:6:"8.0.30";s:10:"MAILER_DSN";s:98:"smtp://rohdesendenhomepage%40itservice-kassel.de:DsAlafXyMwiogCz0CrA6@mail.itservice-kassel.de:465";s:14:"ELASTIC_HOST_1";s:25:"http://elasticsearch:9200";s:23:"ELASTIC_LOGGING_ENABLED";s:4:"true";s:19:"SYMFONY_DOTENV_VARS";s:172:"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,APP_SECRET,PROJECT_DB_USER,PROJECT_DB_PASS,PROJECT_DB,DB_HOST,PROJECT_DB_SERVER_VERSION,MAILER_DSN,ELASTIC_HOST_1,ELASTIC_LOGGING_ENABLED";s:21:"DOCTRINE_DEPRECATIONS";s:7:"trigger";}" 1735042254 1] View formatted query View runnable query Explain query INSERT INTO http_error_log ( uri, code, parametersGet, parametersPost, cookies, serverVars, date, count ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES ('http://45.132.247.172:85/de/Schutzzaeune-alt', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:63:{s:8:\"HOSTNAME\";s:12:\"62a73504f967\";s:11:\"PHP_INI_DIR\";s:18:\"/usr/local/etc/php\";s:21:\"COMPOSER_MEMORY_LIMIT\";s:2:\"-1\";s:17:\"WEB_DOCUMENT_ROOT\";s:14:\"/var/www/html/\";s:4:\"HOME\";s:8:\"/var/www\";s:11:\"PHP_LDFLAGS\";s:12:\"-Wl,-O1 -pie\";s:10:\"PHP_CFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:11:\"PHP_VERSION\";s:5:\"8.2.5\";s:13:\"COMPOSER_HOME\";s:10:\"/.composer\";s:8:\"GPG_KEYS\";s:122:\"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC\";s:12:\"PHP_CPPFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:11:\"PHP_ASC_URL\";s:54:\"https://www.php.net/distributions/php-8.2.5.tar.xz.asc\";s:24:\"COMPOSER_ALLOW_SUPERUSER\";s:1:\"1\";s:7:\"PHP_URL\";s:50:\"https://www.php.net/distributions/php-8.2.5.tar.xz\";s:4:\"PATH\";s:60:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\";s:11:\"PHPIZE_DEPS\";s:76:\"autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c\";s:3:\"PWD\";s:13:\"/var/www/html\";s:10:\"PHP_SHA256\";s:64:\"800738c359b7f1e67e40c22713d2d90276bc85ba1c21b43d99edd43c254c5f76\";s:4:\"USER\";s:8:\"www-data\";s:9:\"HTTP_HOST\";s:17:\"45.132.247.172:85\";s:20:\"HTTP_ACCEPT_ENCODING\";s:23:\"gzip, br, zstd, deflate\";s:15:\"HTTP_USER_AGENT\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:11:\"HTTP_ACCEPT\";s:3:\"/\";s:15:\"SCRIPT_FILENAME\";s:30:\"/var/www/html/public/index.php\";s:9:\"PATH_INFO\";s:0:\"\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:11:\"SERVER_NAME\";s:0:\"\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"SERVER_ADDR\";s:10:\"172.24.0.7\";s:11:\"REMOTE_PORT\";s:5:\"14660\";s:11:\"REMOTE_ADDR\";s:12:\"3.145.92.213\";s:15:\"SERVER_SOFTWARE\";s:12:\"nginx/1.24.0\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:14:\"REQUEST_SCHEME\";s:4:\"http\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:13:\"DOCUMENT_ROOT\";s:20:\"/var/www/html/public\";s:12:\"DOCUMENT_URI\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:20:\"/de/Schutzzaeune-alt\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:14:\"CONTENT_LENGTH\";s:0:\"\";s:12:\"CONTENT_TYPE\";s:0:\"\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:12:\"QUERY_STRING\";s:0:\"\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:18:\"REQUEST_TIME_FLOAT\";d:1735042254.261523;s:12:\"REQUEST_TIME\";i:1735042254;s:4:\"argv\";a:0:{}s:4:\"argc\";i:0;s:7:\"APP_ENV\";s:3:\"dev\";s:9:\"APP_DEBUG\";s:1:\"0\";s:16:\"PIMCORE_DEV_MODE\";s:5:\"false\";s:10:\"APP_SECRET\";s:32:\"SLZYfFJ3GeFS9ZQEKVJn3UKPc8ouYMAm\";s:15:\"PROJECT_DB_USER\";s:7:\"pimcore\";s:15:\"PROJECT_DB_PASS\";s:7:\"pimcore\";s:10:\"PROJECT_DB\";s:7:\"pimcore\";s:7:\"DB_HOST\";s:2:\"db\";s:25:\"PROJECT_DB_SERVER_VERSION\";s:6:\"8.0.30\";s:10:\"MAILER_DSN\";s:98:\"smtp://rohdesendenhomepage%40itservice-kassel.de:DsAlafXyMwiogCz0CrA6@mail.itservice-kassel.de:465\";s:14:\"ELASTIC_HOST_1\";s:25:\"http://elasticsearch:9200\";s:23:\"ELASTIC_LOGGING_ENABLED\";s:4:\"true\";s:19:\"SYMFONY_DOTENV_VARS\";s:172:\"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,APP_SECRET,PROJECT_DB_USER,PROJECT_DB_PASS,PROJECT_DB,DB_HOST,PROJECT_DB_SERVER_VERSION,MAILER_DSN,ELASTIC_HOST_1,ELASTIC_LOGGING_ENABLED\";s:21:\"DOCTRINE_DEPRECATIONS\";s:7:\"trigger\";}', 1735042254, 1);
27	0.20 ms	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';
28	0.44 ms	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 ORDER BY `priority` DESC Parameters: [`"/de/Schutzzaeune-alt" "path" "auto_create" "/de/Schutzzaeune-alt" "path_query" "http://45.132.247.172:85/de/Schutzzaeune-alt" "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 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/de/Schutzzaeune-alt' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Schutzzaeune-alt' AND `type` = 'path_query') OR (source = 'http://45.132.247.172:85/de/Schutzzaeune-alt' 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 ORDER BY `priority` DESC;
29	0.35 ms	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';
30	0.40 ms	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: [`"/de/Schutzzaeune-alt" "path" "auto_create" "/de/Schutzzaeune-alt" "path_query" "http://45.132.247.172:85/de/Schutzzaeune-alt" "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 = '/de/Schutzzaeune-alt' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/de/Schutzzaeune-alt' AND `type` = 'path_query') OR (source = 'http://45.132.247.172:85/de/Schutzzaeune-alt' 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;
31	0.28 ms	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;;
32	0.61 ms	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: [`1735042254 "translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_01e5f00fbf5874160f42c8fe5f4fa4ea');
33	0.29 ms	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: [`1735042254 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');
34	0.20 ms	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;;
35	0.49 ms	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: [`1735042254 "translation_data_1d19e47125946f5a6366d64de93b5d4f"`] 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 > 1735042254 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_1d19e47125946f5a6366d64de93b5d4f');

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.

Entities Mapping

Class	Mapping errors
FormBuilderBundle\Model\OutputWorkflow	No errors.
FormBuilderBundle\Model\FormDefinition	No errors.
FormBuilderBundle\Model\OutputWorkflowChannel	No errors.

Symfony Profiler

GET http://45.132.247.172:85/de/Schutzzaeune-alt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping