Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

31 Database Queries

11 Different statements

8.40 ms Query time

0 Invalid entities

Queries

Group similar statements


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 redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL 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 settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
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 = '/promemoria/api/get-folder-thumbnail' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
SELECT date FROM http_error_log WHERE uri = ?
INSERT INTO http_error_log (`uri`, `code`, `parametersGet`, `parametersPost`, `cookies`, `serverVars`, `date`, `count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

#▲	Time	Info
1	0.45 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: [`1789815303 [ "\x00tags\x00output_3d553e172aa3c41ad845af4207dbe9dd_desktop" "output_3d553e172aa3c41ad845af4207dbe9dd_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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_3d553e172aa3c41ad845af4207dbe9dd_desktop', 'output_3d553e172aa3c41ad845af4207dbe9dd_desktop');
2	0.28 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: [`1789815303 [ "\x00tags\x00output_3d553e172aa3c41ad845af4207dbe9dd" "output_3d553e172aa3c41ad845af4207dbe9dd" ]`] 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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_3d553e172aa3c41ad845af4207dbe9dd', 'output_3d553e172aa3c41ad845af4207dbe9dd');
3	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: [`1789815303 [ "\x00tags\x00site_domain_feac227a90a24d5dcea0c48f589c0b16" "site_domain_feac227a90a24d5dcea0c48f589c0b16" ]`] 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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_feac227a90a24d5dcea0c48f589c0b16', 'site_domain_feac227a90a24d5dcea0c48f589c0b16');
4	0.25 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: [`1789815303 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_feac227a90a24d5dcea0c48f589c0b16\x00tags\x00" ]`] 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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_feac227a90a24d5dcea0c48f589c0b16\0tags\0');
5	0.43 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/promemoria/api/get-folder-thumbnail" "sourcePathQuery" => "/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail" "sourceEntireUri" => "http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/promemoria/api/get-folder-thumbnail' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail' AND `type` = 'path_query') OR (source = 'http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
6	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: [`1789815303 [ "\x00tags\x00system_route_redirect" "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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
7	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: [`1789815303 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ]`] 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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
8	0.22 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.28 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "get-folder-thumbnail" "path" => "/promemoria/api/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/promemoria/api/' AND `key` = BINARY 'get-folder-thumbnail';
10	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria/api/get-folder-thumbnail"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria/api/get-folder-thumbnail';
11	0.23 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "get-folder-thumbnail" "path" => "/promemoria/api/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/promemoria/api/' AND `key` = BINARY 'get-folder-thumbnail';
12	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria/api/get-folder-thumbnail"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria/api/get-folder-thumbnail';
13	0.20 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "api" "path" => "/promemoria/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/promemoria/' AND `key` = BINARY 'api';
14	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria/api"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria/api';
15	0.21 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "promemoria" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'promemoria';
16	0.16 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria';
17	0.20 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY '';
18	0.25 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: [`1789815303 [ "\x00tags\x00document_1" "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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', '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: [`1789815303 [ "document_1\x00tags\x00" ]`] 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 > 1789815303 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
20	0.19 ms	SELECT * FROM object_url_slugs WHERE slug = '/promemoria/api/get-folder-thumbnail' 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 = '/promemoria/api/get-folder-thumbnail' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/promemoria/api/get-folder-thumbnail' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
21	0.23 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.40 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/promemoria/api/get-folder-thumbnail" "sourcePathQuery" => "/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail" "sourceEntireUri" => "http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/promemoria/api/get-folder-thumbnail' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail' AND `type` = 'path_query') OR (source = 'http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL ORDER BY `priority` DESC;
23	0.27 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "get-folder-thumbnail" "path" => "/promemoria/api/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/promemoria/api/' AND `key` = BINARY 'get-folder-thumbnail';
24	0.20 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria/api/get-folder-thumbnail"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria/api/get-folder-thumbnail';
25	0.20 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "api" "path" => "/promemoria/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/promemoria/' AND `key` = BINARY 'api';
26	0.16 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria/api"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria/api';
27	0.19 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "promemoria" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'promemoria';
28	0.17 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/promemoria"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/promemoria';
29	0.24 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 ;
30	0.20 ms	SELECT date FROM http_error_log WHERE uri = ? Parameters: [`"http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail"`] 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://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail';
31	1.28 ms	INSERT INTO http_error_log (`uri`, `code`, `parametersGet`, `parametersPost`, `cookies`, `serverVars`, `date`, `count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail" 404 "a:2:{s:2:"id";s:14:"13667-e6969c7e";s:7:"version";s:9:"thumbnail";}" "a:0:{}" "a:0:{}" """ a:78:{s:15:"REDIRECT_STATUS";s:3:"200";s:9:"HTTP_HOST";s:23:"ccrvenaria.archivio.com";s:15:"HTTP_USER_AGENT";s:33:"Mozilla/5.0 (compatible; crawler)";s:11:"HTTP_ACCEPT";s:3:"/";s:20:"HTTP_ACCEPT_ENCODING";s:13:"gzip, deflate";s:20:"HTTP_ACCEPT_LANGUAGE";s:5:"en-US";s:20:"HTTP_X_FORWARDED_FOR";s:14:"23.230.193.156";s:21:"HTTP_X_FORWARDED_HOST";s:23:"ccrvenaria.archivio.com";s:21:"HTTP_X_FORWARDED_PORT";s:3:"443";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:23:"HTTP_X_FORWARDED_SERVER";s:12:"7996f386c333";s:14:"HTTP_X_REAL_IP";s:14:"23.230.193.156";s:4:"PATH";s:72:"/gocode/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:16:"SERVER_SIGNATURE";s:84:"<address>Apache/2.4.38 (Debian) Server at ccrvenaria.archivio.com Port 80</address>\n ";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.38 (Debian)";s:11:"SERVER_NAME";s:23:"ccrvenaria.archivio.com";s:11:"SERVER_ADDR";s:10:"172.18.0.3";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:10:"172.18.0.2";s:13:"DOCUMENT_ROOT";s:20:"/var/www/html/public";s:14:"REQUEST_SCHEME";s:4:"http";s:14:"CONTEXT_PREFIX";s:0:"";s:21:"CONTEXT_DOCUMENT_ROOT";s:20:"/var/www/html/public";s:12:"SERVER_ADMIN";s:19:"webmaster@localhost";s:15:"SCRIPT_FILENAME";s:30:"/var/www/html/public/index.php";s:11:"REMOTE_PORT";s:5:"32836";s:12:"REDIRECT_URL";s:36:"/promemoria/api/get-folder-thumbnail";s:21:"REDIRECT_QUERY_STRING";s:35:"id=13667-e6969c7e&version=thumbnail";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:35:"id=13667-e6969c7e&version=thumbnail";s:11:"REQUEST_URI";s:72:"/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail";s:11:"SCRIPT_NAME";s:10:"/index.php";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1789815303.490736;s:12:"REQUEST_TIME";i:1789815303;s:4:"argv";a:1:{i:0;s:35:"id=13667-e6969c7e&version=thumbnail";}s:4:"argc";i:1;s:7:"APP_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:16:"PIMCORE_DEV_MODE";s:5:"false";s:19:"SYMFONY_DOTENV_VARS";s:34:"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE";s:19:"MAGICK_THREAD_LIMIT";s:1:"1";s:8:"HOSTNAME";s:12:"1f7cf3b2f71b";s:8:"LANGUAGE";s:8:"it_IT:it";s:11:"PHP_VERSION";s:6:"8.0.10";s:14:"APACHE_CONFDIR";s:12:"/etc/apache2";s:11:"PHP_INI_DIR";s:18:"/usr/local/etc/php";s:8:"GPG_KEYS";s:81:"1729F83938DA44E27BA0F4D3DBDB397470D12172 BFDDD28642824F8118EF77909B67A5C12229118F";s:11:"PHP_LDFLAGS";s:12:"-Wl,-O1 -pie";s:3:"PWD";s:13:"/var/www/html";s:20:"APACHE_DOCUMENT_ROOT";s:20:"/var/www/html/public";s:14:"APACHE_LOG_DIR";s:16:"/var/log/apache2";s:16:"MAGICK_MAP_LIMIT";s:3:"2GB";s:4:"LANG";s:11:"it_IT.UTF-8";s:10:"PHP_SHA256";s:64:"66dc4d1bc86d9c1bc255b51b79d337ed1a7a035cf71230daabbf9a4ca35795eb";s:15:"APACHE_PID_FILE";s:28:"/var/run/apache2/apache2.pid";s:19:"PIMCORE_ENVIRONMENT";s:4:"prod";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:7:"PHP_URL";s:51:"https://www.php.net/distributions/php-8.0.10.tar.xz";s:16:"APACHE_RUN_GROUP";s:8:"www-data";s:15:"APACHE_LOCK_DIR";s:17:"/var/lock/apache2";s:24:"PHP_EXTRA_CONFIGURE_ARGS";s:26:"--with-apxs2 --disable-cgi";s:5:"SHLVL";s:1:"0";s:24:"COMPOSER_ALLOW_SUPERUSER";s:1:"1";s:10:"PHP_CFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:21:"COMPOSER_MEMORY_LIMIT";s:2:"-1";s:14:"APACHE_RUN_DIR";s:16:"/var/run/apache2";s:14:"APACHE_ENVVARS";s:20:"/etc/apache2/envvars";s:13:"dotenv_suffix";s:10:"ccrvenaria";s:6:"LC_ALL";s:11:"it_IT.UTF-8";s:15:"APACHE_RUN_USER";s:8:"www-data";s:20:"PHP_EXTRA_BUILD_DEPS";s:11:"apache2-dev";s:19:"MAGICK_MEMORY_LIMIT";s:3:"2GB";s:11:"PHP_ASC_URL";s:55:"https://www.php.net/distributions/php-8.0.10.tar.xz.asc";s:12:"PHP_CPPFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:6:"GOPATH";s:7:"/gocode";} """ 1789815303 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://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail', 404, 'a:2:{s:2:\"id\";s:14:\"13667-e6969c7e\";s:7:\"version\";s:9:\"thumbnail\";}', 'a:0:{}', 'a:0:{}', 'a:78:{s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:9:\"HTTP_HOST\";s:23:\"ccrvenaria.archivio.com\";s:15:\"HTTP_USER_AGENT\";s:33:\"Mozilla/5.0 (compatible; crawler)\";s:11:\"HTTP_ACCEPT\";s:3:\"/\";s:20:\"HTTP_ACCEPT_ENCODING\";s:13:\"gzip, deflate\";s:20:\"HTTP_ACCEPT_LANGUAGE\";s:5:\"en-US\";s:20:\"HTTP_X_FORWARDED_FOR\";s:14:\"23.230.193.156\";s:21:\"HTTP_X_FORWARDED_HOST\";s:23:\"ccrvenaria.archivio.com\";s:21:\"HTTP_X_FORWARDED_PORT\";s:3:\"443\";s:22:\"HTTP_X_FORWARDED_PROTO\";s:5:\"https\";s:23:\"HTTP_X_FORWARDED_SERVER\";s:12:\"7996f386c333\";s:14:\"HTTP_X_REAL_IP\";s:14:\"23.230.193.156\";s:4:\"PATH\";s:72:\"/gocode/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\";s:16:\"SERVER_SIGNATURE\";s:84:\"<address>Apache/2.4.38 (Debian) Server at ccrvenaria.archivio.com Port 80</address> \";s:15:\"SERVER_SOFTWARE\";s:22:\"Apache/2.4.38 (Debian)\";s:11:\"SERVER_NAME\";s:23:\"ccrvenaria.archivio.com\";s:11:\"SERVER_ADDR\";s:10:\"172.18.0.3\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"REMOTE_ADDR\";s:10:\"172.18.0.2\";s:13:\"DOCUMENT_ROOT\";s:20:\"/var/www/html/public\";s:14:\"REQUEST_SCHEME\";s:4:\"http\";s:14:\"CONTEXT_PREFIX\";s:0:\"\";s:21:\"CONTEXT_DOCUMENT_ROOT\";s:20:\"/var/www/html/public\";s:12:\"SERVER_ADMIN\";s:19:\"webmaster@localhost\";s:15:\"SCRIPT_FILENAME\";s:30:\"/var/www/html/public/index.php\";s:11:\"REMOTE_PORT\";s:5:\"32836\";s:12:\"REDIRECT_URL\";s:36:\"/promemoria/api/get-folder-thumbnail\";s:21:\"REDIRECT_QUERY_STRING\";s:35:\"id=13667-e6969c7e&version=thumbnail\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:12:\"QUERY_STRING\";s:35:\"id=13667-e6969c7e&version=thumbnail\";s:11:\"REQUEST_URI\";s:72:\"/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:18:\"REQUEST_TIME_FLOAT\";d:1789815303.490736;s:12:\"REQUEST_TIME\";i:1789815303;s:4:\"argv\";a:1:{i:0;s:35:\"id=13667-e6969c7e&version=thumbnail\";}s:4:\"argc\";i:1;s:7:\"APP_ENV\";s:3:\"dev\";s:9:\"APP_DEBUG\";s:1:\"0\";s:16:\"PIMCORE_DEV_MODE\";s:5:\"false\";s:19:\"SYMFONY_DOTENV_VARS\";s:34:\"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE\";s:19:\"MAGICK_THREAD_LIMIT\";s:1:\"1\";s:8:\"HOSTNAME\";s:12:\"1f7cf3b2f71b\";s:8:\"LANGUAGE\";s:8:\"it_IT:it\";s:11:\"PHP_VERSION\";s:6:\"8.0.10\";s:14:\"APACHE_CONFDIR\";s:12:\"/etc/apache2\";s:11:\"PHP_INI_DIR\";s:18:\"/usr/local/etc/php\";s:8:\"GPG_KEYS\";s:81:\"1729F83938DA44E27BA0F4D3DBDB397470D12172 BFDDD28642824F8118EF77909B67A5C12229118F\";s:11:\"PHP_LDFLAGS\";s:12:\"-Wl,-O1 -pie\";s:3:\"PWD\";s:13:\"/var/www/html\";s:20:\"APACHE_DOCUMENT_ROOT\";s:20:\"/var/www/html/public\";s:14:\"APACHE_LOG_DIR\";s:16:\"/var/log/apache2\";s:16:\"MAGICK_MAP_LIMIT\";s:3:\"2GB\";s:4:\"LANG\";s:11:\"it_IT.UTF-8\";s:10:\"PHP_SHA256\";s:64:\"66dc4d1bc86d9c1bc255b51b79d337ed1a7a035cf71230daabbf9a4ca35795eb\";s:15:\"APACHE_PID_FILE\";s:28:\"/var/run/apache2/apache2.pid\";s:19:\"PIMCORE_ENVIRONMENT\";s:4:\"prod\";s:11:\"PHPIZE_DEPS\";s:76:\"autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c\";s:7:\"PHP_URL\";s:51:\"https://www.php.net/distributions/php-8.0.10.tar.xz\";s:16:\"APACHE_RUN_GROUP\";s:8:\"www-data\";s:15:\"APACHE_LOCK_DIR\";s:17:\"/var/lock/apache2\";s:24:\"PHP_EXTRA_CONFIGURE_ARGS\";s:26:\"--with-apxs2 --disable-cgi\";s:5:\"SHLVL\";s:1:\"0\";s:24:\"COMPOSER_ALLOW_SUPERUSER\";s:1:\"1\";s:10:\"PHP_CFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:21:\"COMPOSER_MEMORY_LIMIT\";s:2:\"-1\";s:14:\"APACHE_RUN_DIR\";s:16:\"/var/run/apache2\";s:14:\"APACHE_ENVVARS\";s:20:\"/etc/apache2/envvars\";s:13:\"dotenv_suffix\";s:10:\"ccrvenaria\";s:6:\"LC_ALL\";s:11:\"it_IT.UTF-8\";s:15:\"APACHE_RUN_USER\";s:8:\"www-data\";s:20:\"PHP_EXTRA_BUILD_DEPS\";s:11:\"apache2-dev\";s:19:\"MAGICK_MEMORY_LIMIT\";s:3:\"2GB\";s:11:\"PHP_ASC_URL\";s:55:\"https://www.php.net/distributions/php-8.0.10.tar.xz.asc\";s:12:\"PHP_CPPFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:6:\"GOPATH\";s:7:\"/gocode\";}', 1789815303, 1);

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

http://ccrvenaria.archivio.com/promemoria/api/get-folder-thumbnail?id=13667-e6969c7e&version=thumbnail

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache