Query Metrics
48
Database Queries
15
Different statements
13.41 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.41 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:
[ 1735000553 "site_domain_5061e09f81735ede2c26d4894faa91ad" ] |
2 | 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:
[ 1735000553 "system\x01tags\x01" "site\x01tags\x01" ] |
3 | 0.24 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
4 | 0.48 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:
[ "/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" ] |
5 | 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:
[ 1735000553 "system_route_redirect" ] |
6 | 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:
[ 1735000553 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
7 | 0.20 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
8 | 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:
[ 1735000553 "output_e2ab54cf996838fe8d21b8e4e5067353_desktop" ] |
9 | 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:
[ 1735000553 "\x00tags\x00output_e2ab54cf996838fe8d21b8e4e5067353_desktop" ] |
10 | 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:
[ 1735000553 "output_e2ab54cf996838fe8d21b8e4e5067353" ] |
11 | 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:
[ 1735000553 "\x00tags\x00output_e2ab54cf996838fe8d21b8e4e5067353" ] |
12 | 0.17 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "reports" "pimcore" ] |
13 | 0.42 ms |
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" ] |
14 | 0.21 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
|
15 | 0.23 ms |
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" ] |
16 | 0.17 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
|
17 | 0.23 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/alloggiamento-dell-interruttore/t/" "trattamento-delle-superfici" ] |
18 | 0.23 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici"
]
|
19 | 0.20 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/alloggiamento-dell-interruttore/" "t" ] |
20 | 0.15 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t"
]
|
21 | 0.20 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/" "alloggiamento-dell-interruttore" ] |
22 | 0.20 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore"
]
|
23 | 0.20 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/" "it" ] |
24 | 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:
[ 1735000553 "document_1475" ] |
25 | 0.27 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:
[ 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" ] |
26 | 0.20 ms |
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:
[] |
27 | 0.22 ms |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
28 | 0.18 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "1" "pimcore_staticroutes" ] |
29 | 0.55 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
30 | 0.24 ms |
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"
]
|
31 | 2.44 ms |
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 ] |
32 | 0.22 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
33 | 0.49 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:
[ "/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" ] |
34 | 0.58 ms |
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" ] |
35 | 0.22 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici/private-customers-special-processes-and-reconditioning"
]
|
36 | 0.19 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/alloggiamento-dell-interruttore/t/" "trattamento-delle-superfici" ] |
37 | 0.15 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t/trattamento-delle-superfici"
]
|
38 | 0.17 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/alloggiamento-dell-interruttore/" "t" ] |
39 | 0.13 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore/t"
]
|
40 | 0.17 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/it/" "alloggiamento-dell-interruttore" ] |
41 | 0.12 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/it/alloggiamento-dell-interruttore"
]
|
42 | 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:
[ 1735000553 "sites_path_mapping" ] |
43 | 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:
[ 1735000553 "\x00tags\x00sites_path_mapping" ] |
44 | 0.21 ms |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
45 | 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:
[ 1735000553 "document_properties_1475" ] |
46 | 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:
[ 1735000553 "document_properties\x01tags\x01" "document_1475\x01tags\x01" ] |
47 | 0.20 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
48 | 0.37 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:
[ "/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" ] |
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. |