Symfony Profiler

Query Metrics

35 Database Queries

13 Different statements

24.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 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 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 = '/aws/credentials' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
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 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.72 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: [`1777943784 "site_domain_18890012c2a8db47e48c07bcb54781d8"`] 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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_18890012c2a8db47e48c07bcb54781d8');
2	0.56 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: [`1777943784 "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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.49 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.69 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: [`"/aws/credentials" "path" "auto_create" "/aws/credentials" "path_query" "https://staging.housmaninstitute.com/aws/credentials" "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 = '/aws/credentials' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/aws/credentials' AND `type` = 'path_query') OR (source = 'https://staging.housmaninstitute.com/aws/credentials' 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.47 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: [`1777943784 "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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.56 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: [`1777943784 "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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.52 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.49 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: [`1777943784 "output_9dd6ec201554e91ed0e5311d1430b1a2_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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_9dd6ec201554e91ed0e5311d1430b1a2_desktop');
9	0.48 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: [`1777943784 "\x00tags\x00output_9dd6ec201554e91ed0e5311d1430b1a2_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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_9dd6ec201554e91ed0e5311d1430b1a2_desktop');
10	0.54 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: [`1777943784 "output_9dd6ec201554e91ed0e5311d1430b1a2"`] 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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_9dd6ec201554e91ed0e5311d1430b1a2');
11	0.49 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: [`1777943784 "\x00tags\x00output_9dd6ec201554e91ed0e5311d1430b1a2"`] 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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_9dd6ec201554e91ed0e5311d1430b1a2');
12	0.53 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/aws/" "credentials"`] 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 '/aws/' AND `key` = BINARY 'credentials';
13	0.53 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/aws/credentials"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/aws/credentials';
14	0.57 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/aws/" "credentials"`] 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 '/aws/' AND `key` = BINARY 'credentials';
15	0.49 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/aws/credentials"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/aws/credentials';
16	0.45 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "aws"`] 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 'aws';
17	0.46 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/aws"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/aws';
18	0.47 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 '';
19	0.51 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: [`1777943784 "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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
20	0.57 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: [`1777943784 "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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
21	0.52 ms	SELECT * FROM object_url_slugs WHERE slug = '/aws/credentials' 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 = '/aws/credentials' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/aws/credentials' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
22	0.68 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';
23	0.51 ms	SELECT date FROM http_error_log WHERE uri = ? Parameters: [`"https://staging.housmaninstitute.com/aws/credentials"`] View formatted query View runnable query Explain query SELECT date FROM http_error_log WHERE uri = ? SELECT date FROM http_error_log WHERE uri = 'https://staging.housmaninstitute.com/aws/credentials';
24	6.28 ms	INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["https://staging.housmaninstitute.com/aws/credentials" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:86:{s:23:"PHP_UPLOAD_MAX_FILESIZE";s:4:"100M";s:33:"PIMCORE_INSTALL_MYSQL_HOST_SOCKET";s:51:"database-1.cm1dqhjex60a.us-east-2.rds.amazonaws.com";s:8:"HOSTNAME";s:12:"89659932e331";s:11:"PHP_INI_DIR";s:18:"/usr/local/etc/php";s:21:"COMPOSER_MEMORY_LIMIT";s:2:"-1";s:26:"PIMCORE_INSTALL_MYSQL_PORT";s:4:"3306";s:5:"SHLVL";s:1:"0";s:4:"HOME";s:8:"/var/www";s:30:"PIMCORE_INSTALL_MYSQL_DATABASE";s:3:"dam";s:23:"PHP_FPM_PM_MAX_CHILDREN";s:1:"5";s:11:"PHP_LDFLAGS";s:12:"-Wl,-O1 -pie";s:14:"PHP_IDE_CONFIG";s:20:"serverName=localhost";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:6:"8.2.19";s:26:"OPCACHE_MEMORY_CONSUMPTION";s:3:"128";s:13:"COMPOSER_HOME";s:13:"/var/www/html";s:8:"GPG_KEYS";s:122:"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC";s:30:"PIMCORE_INSTALL_MYSQL_USERNAME";s:3:"dam";s:24:"COMPOSER_ALLOW_SUPERUSER";s:1:"1";s:11:"PHP_ASC_URL";s:55:"https://www.php.net/distributions/php-8.2.19.tar.xz.asc";s:12:"PHP_CPPFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:17:"PHP_POST_MAX_SIZE";s:4:"100M";s:26:"PHP_DISPLAY_STARTUP_ERRORS";s:1:"1";s:7:"PHP_URL";s:51:"https://www.php.net/distributions/php-8.2.19.tar.xz";s:18:"OPCACHE_ENABLE_CLI";s:1:"0";s:22:"PHP_MAX_EXECUTION_TIME";s:2:"30";s:14:"OPCACHE_ENABLE";s:1:"1";s:10:"PHP_FPM_PM";s:7:"dynamic";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:28:"PHP_FPM_PM_MIN_SPARE_SERVERS";s:1:"1";s:23:"PHP_FPM_PM_MAX_REQUESTS";s:5:"10000";s:16:"PHP_MEMORY_LIMIT";s:4:"256M";s:28:"PHP_FPM_PM_MAX_SPARE_SERVERS";s:1:"3";s:19:"PHP_ERROR_REPORTING";s:5:"E_ALL";s:24:"PHP_FPM_PM_START_SERVERS";s:1:"2";s:3:"PWD";s:13:"/var/www/html";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:30:"PIMCORE_INSTALL_MYSQL_PASSWORD";s:16:"KNZyivpEef5Uo9vN";s:10:"PHP_SHA256";s:64:"aecd63f3ebea6768997f5c4fccd98acbf897762ed5fc25300e846197a9485c13";s:29:"OPCACHE_MAX_ACCELERATED_FILES";s:5:"10000";s:27:"OPCACHE_VALIDATE_TIMESTAMPS";s:1:"1";s:26:"OPCACHE_CONSISTENCY_CHECKS";s:1:"0";s:4:"USER";s:8:"www-data";s:9:"HTTP_HOST";s:28:"staging.housmaninstitute.com";s:20:"HTTP_ACCEPT_ENCODING";s:8:"gzip, br";s:20:"HTTP_X_FORWARDED_FOR";s:14:"195.178.110.34";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:15:"HTTP_CF_VISITOR";s:18:"{"scheme":"https"}";s:17:"HTTP_CF_IPCOUNTRY";s:2:"NL";s:21:"HTTP_CF_CONNECTING_IP";s:14:"195.178.110.34";s:13:"HTTP_CDN_LOOP";s:19:"cloudflare; loops=1";s:11:"HTTP_CF_RAY";s:20:"9f6be64ececd665e-AMS";s:15:"HTTP_USER_AGENT";s:77:"Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0";s:15:"HTTP_CONNECTION";s:10:"Keep-Alive";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:24:"dam.housmaninstitute.com";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:10:"172.26.0.4";s:11:"REMOTE_PORT";s:5:"11905";s:11:"REMOTE_ADDR";s:14:"172.71.103.226";s:15:"SERVER_SOFTWARE";s:12:"nginx/1.26.0";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:5:"HTTPS";s:2:"on";s:14:"REQUEST_SCHEME";s:5:"https";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:16:"/aws/credentials";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:1777943784.854942;s:12:"REQUEST_TIME";i:1777943784;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:19:"SYMFONY_DOTENV_VARS";s:34:"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE";s:21:"DOCTRINE_DEPRECATIONS";s:7:"trigger";}" 1777943784 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 ('https://staging.housmaninstitute.com/aws/credentials', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:86:{s:23:\"PHP_UPLOAD_MAX_FILESIZE\";s:4:\"100M\";s:33:\"PIMCORE_INSTALL_MYSQL_HOST_SOCKET\";s:51:\"database-1.cm1dqhjex60a.us-east-2.rds.amazonaws.com\";s:8:\"HOSTNAME\";s:12:\"89659932e331\";s:11:\"PHP_INI_DIR\";s:18:\"/usr/local/etc/php\";s:21:\"COMPOSER_MEMORY_LIMIT\";s:2:\"-1\";s:26:\"PIMCORE_INSTALL_MYSQL_PORT\";s:4:\"3306\";s:5:\"SHLVL\";s:1:\"0\";s:4:\"HOME\";s:8:\"/var/www\";s:30:\"PIMCORE_INSTALL_MYSQL_DATABASE\";s:3:\"dam\";s:23:\"PHP_FPM_PM_MAX_CHILDREN\";s:1:\"5\";s:11:\"PHP_LDFLAGS\";s:12:\"-Wl,-O1 -pie\";s:14:\"PHP_IDE_CONFIG\";s:20:\"serverName=localhost\";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:6:\"8.2.19\";s:26:\"OPCACHE_MEMORY_CONSUMPTION\";s:3:\"128\";s:13:\"COMPOSER_HOME\";s:13:\"/var/www/html\";s:8:\"GPG_KEYS\";s:122:\"39B641343D8C104B2B146DC3F9C39DC0B9698544 E60913E4DF209907D8E30D96659A97C9CF2A795A 1198C0117593497A5EC5C199286AF1F9897469DC\";s:30:\"PIMCORE_INSTALL_MYSQL_USERNAME\";s:3:\"dam\";s:24:\"COMPOSER_ALLOW_SUPERUSER\";s:1:\"1\";s:11:\"PHP_ASC_URL\";s:55:\"https://www.php.net/distributions/php-8.2.19.tar.xz.asc\";s:12:\"PHP_CPPFLAGS\";s:83:\"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64\";s:17:\"PHP_POST_MAX_SIZE\";s:4:\"100M\";s:26:\"PHP_DISPLAY_STARTUP_ERRORS\";s:1:\"1\";s:7:\"PHP_URL\";s:51:\"https://www.php.net/distributions/php-8.2.19.tar.xz\";s:18:\"OPCACHE_ENABLE_CLI\";s:1:\"0\";s:22:\"PHP_MAX_EXECUTION_TIME\";s:2:\"30\";s:14:\"OPCACHE_ENABLE\";s:1:\"1\";s:10:\"PHP_FPM_PM\";s:7:\"dynamic\";s:4:\"PATH\";s:60:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\";s:28:\"PHP_FPM_PM_MIN_SPARE_SERVERS\";s:1:\"1\";s:23:\"PHP_FPM_PM_MAX_REQUESTS\";s:5:\"10000\";s:16:\"PHP_MEMORY_LIMIT\";s:4:\"256M\";s:28:\"PHP_FPM_PM_MAX_SPARE_SERVERS\";s:1:\"3\";s:19:\"PHP_ERROR_REPORTING\";s:5:\"E_ALL\";s:24:\"PHP_FPM_PM_START_SERVERS\";s:1:\"2\";s:3:\"PWD\";s:13:\"/var/www/html\";s:11:\"PHPIZE_DEPS\";s:76:\"autoconf dpkg-dev file g++ gcc libc-dev make pkg-config re2c\";s:30:\"PIMCORE_INSTALL_MYSQL_PASSWORD\";s:16:\"KNZyivpEef5Uo9vN\";s:10:\"PHP_SHA256\";s:64:\"aecd63f3ebea6768997f5c4fccd98acbf897762ed5fc25300e846197a9485c13\";s:29:\"OPCACHE_MAX_ACCELERATED_FILES\";s:5:\"10000\";s:27:\"OPCACHE_VALIDATE_TIMESTAMPS\";s:1:\"1\";s:26:\"OPCACHE_CONSISTENCY_CHECKS\";s:1:\"0\";s:4:\"USER\";s:8:\"www-data\";s:9:\"HTTP_HOST\";s:28:\"staging.housmaninstitute.com\";s:20:\"HTTP_ACCEPT_ENCODING\";s:8:\"gzip, br\";s:20:\"HTTP_X_FORWARDED_FOR\";s:14:\"195.178.110.34\";s:22:\"HTTP_X_FORWARDED_PROTO\";s:5:\"https\";s:15:\"HTTP_CF_VISITOR\";s:18:\"{\"scheme\":\"https\"}\";s:17:\"HTTP_CF_IPCOUNTRY\";s:2:\"NL\";s:21:\"HTTP_CF_CONNECTING_IP\";s:14:\"195.178.110.34\";s:13:\"HTTP_CDN_LOOP\";s:19:\"cloudflare; loops=1\";s:11:\"HTTP_CF_RAY\";s:20:\"9f6be64ececd665e-AMS\";s:15:\"HTTP_USER_AGENT\";s:77:\"Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0\";s:15:\"HTTP_CONNECTION\";s:10:\"Keep-Alive\";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:24:\"dam.housmaninstitute.com\";s:11:\"SERVER_PORT\";s:3:\"443\";s:11:\"SERVER_ADDR\";s:10:\"172.26.0.4\";s:11:\"REMOTE_PORT\";s:5:\"11905\";s:11:\"REMOTE_ADDR\";s:14:\"172.71.103.226\";s:15:\"SERVER_SOFTWARE\";s:12:\"nginx/1.26.0\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:5:\"HTTPS\";s:2:\"on\";s:14:\"REQUEST_SCHEME\";s:5:\"https\";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:16:\"/aws/credentials\";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:1777943784.854942;s:12:\"REQUEST_TIME\";i:1777943784;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:19:\"SYMFONY_DOTENV_VARS\";s:34:\"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE\";s:21:\"DOCTRINE_DEPRECATIONS\";s:7:\"trigger\";}', 1777943784, 1);
25	0.66 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';
26	0.76 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: [`"/aws/credentials" "path" "auto_create" "/aws/credentials" "path_query" "https://staging.housmaninstitute.com/aws/credentials" "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 = '/aws/credentials' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/aws/credentials' AND `type` = 'path_query') OR (source = 'https://staging.housmaninstitute.com/aws/credentials' 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;
27	0.67 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/aws/" "credentials"`] 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 '/aws/' AND `key` = BINARY 'credentials';
28	0.52 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/aws/credentials"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/aws/credentials';
29	0.65 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "aws"`] 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 'aws';
30	0.47 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/aws"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/aws';
31	0.50 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: [`1777943784 "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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
32	0.47 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: [`1777943784 "\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 > 1777943784 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');
33	0.52 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 ;
34	0.48 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';
35	0.65 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: [`"/aws/credentials" "path" "auto_create" "/aws/credentials" "path_query" "https://staging.housmaninstitute.com/aws/credentials" "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 = '/aws/credentials' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/aws/credentials' AND `type` = 'path_query') OR (source = 'https://staging.housmaninstitute.com/aws/credentials' 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

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://staging.housmaninstitute.com/aws/credentials

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping