Query Metrics

48 Database Queries
15 Different statements
13.41 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.58 ms
(19.25%)
10
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/"
  "private-customers-special-processes-and-reconditioning"
]
2.44 ms
(18.20%)
1
INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "http://45.132.247.172:85/it/alloggiamento-dell-interruttore/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:"56339";s:11:"REMOTE_ADDR";s:13:"3.128.168.176";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:120:"/it/alloggiamento-dell-interruttore/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:1735000553.541778;s:12:"REQUEST_TIME";i:1735000553;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";}"
  1735000553
  1
]
1.96 ms
(14.65%)
10
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:
[
  1735000553
  "site_domain_5061e09f81735ede2c26d4894faa91ad"
]
1.59 ms
(11.84%)
9
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
1.55 ms
(11.53%)
6
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
0.86 ms
(6.38%)
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/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
  "path"
  "auto_create"
  "/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
  "path_query"
  "http://45.132.247.172:85/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
  "entire_uri"
]
0.49 ms
(3.63%)
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/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
  "path"
  "auto_create"
  "/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
  "path_query"
  "http://45.132.247.172:85/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
  "entire_uri"
]
0.39 ms
(2.92%)
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:
[
  1735000553
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.27 ms
(1.99%)
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:
[
  1735000553
  "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.24 ms
(1.77%)
1
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
  "http://45.132.247.172:85/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
0.22 ms
(1.67%)
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:
[
  1735000553
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
0.22 ms
(1.62%)
1
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
0.21 ms
(1.54%)
1
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
0.20 ms
(1.51%)
1
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
0.20 ms
(1.49%)
1
SELECT * FROM object_url_slugs WHERE slug = '/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]

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