Query Metrics
53
Database Queries
16
Different statements
14.90 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.14 ms (21.08%) |
12 |
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:
[ 1735043654 "site_domain_5061e09f81735ede2c26d4894faa91ad" ] |
2.97 ms (19.92%) |
1 |
INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "http://45.132.247.172:85/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" 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:"41217";s:11:"REMOTE_ADDR";s:12:"13.58.103.70";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:102:"/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning";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:1735043654.138121;s:12:"REQUEST_TIME";i:1735043654;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";}" 1735043654 1 ] |
2.41 ms (16.16%) |
10 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/safety-fences/t/trattamento-delle-superfici/" "private-customers-special-processes-and-reconditioning" ] |
1.44 ms (9.65%) |
9 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
|
1.04 ms (6.95%) |
6 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
0.90 ms (6.02%) |
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:
[ "/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" "path" "auto_create" "/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" "path_query" "http://45.132.247.172:85/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" "entire_uri" ] |
0.54 ms (3.64%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
0.51 ms (3.39%) |
1 |
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:
[ "/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" "path" "auto_create" "/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" "path_query" "http://45.132.247.172:85/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning" "entire_uri" ] |
0.43 ms (2.90%) |
2 |
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:
[ 1735043654 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
0.37 ms (2.50%) |
2 |
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:
[ 1735043654 "system\x01tags\x01" "site\x01tags\x01" ] |
0.22 ms (1.50%) |
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:
[ 1735043654 "document_1475\x01tags\x01" "asset_5384\x01tags\x01" "asset_5386\x01tags\x01" "asset_5385\x01tags\x01" "document_1499\x01tags\x01" "document_1498\x01tags\x01" "asset_7977\x01tags\x01" ] |
0.20 ms (1.35%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
0.19 ms (1.28%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.19 ms (1.27%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.18 ms (1.21%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
0.17 ms (1.17%) |
1 |
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
"http://45.132.247.172:85/it/safety-fences/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
|
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. |