Symfony Profiler

Query Metrics

34 Database Queries

14 Different statements

10.93 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 id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
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 * FROM object_url_slugs WHERE slug = '/_fragment' 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 id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
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 * 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

#▲	Time	Info
1	0.38 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: [`1734922009 "site_domain_edeba2033b891e73733d3bc86fb4ce51"`] 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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_edeba2033b891e73733d3bc86fb4ce51');
2	0.22 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: [`1734922009 "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 > 1734922009 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.47 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: [`"/_fragment" "path" "auto_create" "/_fragment" "path_query" "http://stage.rohde-technics.com/_fragment" "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 = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment' AND `type` = 'path_query') OR (source = 'http://stage.rohde-technics.com/_fragment' 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.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: [`1734922009 "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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	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: [`1734922009 "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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.20 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.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: [`1734922009 "output_7fb23e66f937c7aa3d677ccf5636b66f_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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_7fb23e66f937c7aa3d677ccf5636b66f_desktop');
9	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: [`1734922009 "\x00tags\x00output_7fb23e66f937c7aa3d677ccf5636b66f_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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_7fb23e66f937c7aa3d677ccf5636b66f_desktop');
10	0.15 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: [`1734922009 "output_7fb23e66f937c7aa3d677ccf5636b66f"`] 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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_7fb23e66f937c7aa3d677ccf5636b66f');
11	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: [`1734922009 "\x00tags\x00output_7fb23e66f937c7aa3d677ccf5636b66f"`] 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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_7fb23e66f937c7aa3d677ccf5636b66f');
12	0.16 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.46 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "_fragment"`] 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 '/' AND `key` = BINARY '_fragment';
14	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/_fragment"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/_fragment';
15	0.23 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "_fragment"`] 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 '/' AND `key` = BINARY '_fragment';
16	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/_fragment"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/_fragment';
17	0.23 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] 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 '/' AND `key` = BINARY '';
18	0.20 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: [`1734922009 "document_1"`] 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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
19	0.20 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: [`1734922009 "document_1\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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
20	0.23 ms	SELECT * FROM object_url_slugs WHERE slug = '/_fragment' 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 = '/_fragment' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/_fragment' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
21	0.22 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';
22	0.18 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';
23	0.18 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';
24	0.32 ms	SELECT date FROM http_error_log WHERE uri = ? Parameters: [`"http://stage.rohde-technics.com/_fragment"`] 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://stage.rohde-technics.com/_fragment';
25	2.86 ms	INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["http://stage.rohde-technics.com/_fragment" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:69:{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:12:"HTTP_REFERER";s:41:"http://stage.rohde-technics.com/_fragment";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:20:"HTTP_X_FRAME_OPTIONS";s:10:"SAMEORIGIN";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:20:"HTTP_X_FORWARDED_FOR";s:14:"18.221.221.171";s:14:"HTTP_X_REAL_IP";s:14:"18.221.221.171";s:9:"HTTP_HOST";s:24:"stage.rohde-technics.com";s:15:"HTTP_CONNECTION";s:7:"upgrade";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:"57694";s:11:"REMOTE_ADDR";s:10:"172.24.0.1";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.0";s:13:"DOCUMENT_ROOT";s:20:"/var/www/html/public";s:12:"DOCUMENT_URI";s:10:"/index.php";s:11:"REQUEST_URI";s:10:"/_fragment";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:1734922009.669103;s:12:"REQUEST_TIME";i:1734922009;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";}" 1734922009 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://stage.rohde-technics.com/_fragment', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:69:{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:12:\"HTTP_REFERER\";s:41:\"http://stage.rohde-technics.com/_fragment\";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:20:\"HTTP_X_FRAME_OPTIONS\";s:10:\"SAMEORIGIN\";s:22:\"HTTP_X_FORWARDED_PROTO\";s:5:\"https\";s:20:\"HTTP_X_FORWARDED_FOR\";s:14:\"18.221.221.171\";s:14:\"HTTP_X_REAL_IP\";s:14:\"18.221.221.171\";s:9:\"HTTP_HOST\";s:24:\"stage.rohde-technics.com\";s:15:\"HTTP_CONNECTION\";s:7:\"upgrade\";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:\"57694\";s:11:\"REMOTE_ADDR\";s:10:\"172.24.0.1\";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.0\";s:13:\"DOCUMENT_ROOT\";s:20:\"/var/www/html/public\";s:12:\"DOCUMENT_URI\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:10:\"/_fragment\";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:1734922009.669103;s:12:\"REQUEST_TIME\";i:1734922009;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\";}', 1734922009, 1);
26	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';
27	0.55 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: [`"/_fragment" "path" "auto_create" "/_fragment" "path_query" "http://stage.rohde-technics.com/_fragment" "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 = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment' AND `type` = 'path_query') OR (source = 'http://stage.rohde-technics.com/_fragment' 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;
28	0.41 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "_fragment"`] 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 '/' AND `key` = BINARY '_fragment';
29	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/_fragment"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/_fragment';
30	0.20 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: [`1734922009 "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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
31	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: [`1734922009 "\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 > 1734922009 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');
32	0.22 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 ;
33	0.22 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';
34	0.38 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: [`"/_fragment" "path" "auto_create" "/_fragment" "path_query" "http://stage.rohde-technics.com/_fragment" "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 = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment' AND `type` = 'path_query') OR (source = 'http://stage.rohde-technics.com/_fragment' 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;

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.

Symfony Profiler

GET http://stage.rohde-technics.com/_fragment

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping