Symfony Profiler

Query Metrics

35 Database Queries

14 Different statements

9.37 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 = '/.well-known/ucp' 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.69 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: [`1794436316 "site_domain_1ea429556477a461bccd9f968ab25786"`] 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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_1ea429556477a461bccd9f968ab25786');
2	0.31 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: [`1794436316 "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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.42 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.61 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: [`"/.well-known/ucp" "path" "auto_create" "/.well-known/ucp" "path_query" "https://test.deleeuwmotoren.nl/.well-known/ucp" "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 = '/.well-known/ucp' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/.well-known/ucp' AND `type` = 'path_query') OR (source = 'https://test.deleeuwmotoren.nl/.well-known/ucp' 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.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: [`1794436316 "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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('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: [`1794436316 "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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.30 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.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: [`1794436316 "output_b43832cc67932524cad3b5ecdf34528a_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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_b43832cc67932524cad3b5ecdf34528a_desktop');
9	0.14 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: [`1794436316 "\x00tags\x00output_b43832cc67932524cad3b5ecdf34528a_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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_b43832cc67932524cad3b5ecdf34528a_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: [`1794436316 "output_b43832cc67932524cad3b5ecdf34528a"`] 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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output_b43832cc67932524cad3b5ecdf34528a');
11	0.11 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: [`1794436316 "\x00tags\x00output_b43832cc67932524cad3b5ecdf34528a"`] 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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0output_b43832cc67932524cad3b5ecdf34528a');
12	0.39 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/.well-known/" "ucp"`] 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 '/.well-known/' AND `key` = BINARY 'ucp';
13	0.21 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/.well-known/ucp"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/.well-known/ucp';
14	0.13 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/.well-known/" "ucp"`] 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 '/.well-known/' AND `key` = BINARY 'ucp';
15	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/.well-known/ucp"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/.well-known/ucp';
16	0.12 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ".well-known"`] 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 '.well-known';
17	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/.well-known"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/.well-known';
18	0.12 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.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: [`1794436316 "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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
20	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: [`1794436316 "document_1\x01tags\x01" "asset_894\x01tags\x01" "asset_896\x01tags\x01" "asset_893\x01tags\x01" "asset_895\x01tags\x01" "asset_841\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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_894tags', 'asset_896tags', 'asset_893tags', 'asset_895tags', 'asset_841tags');
21	0.26 ms	SELECT * FROM object_url_slugs WHERE slug = '/.well-known/ucp' 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 = '/.well-known/ucp' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/.well-known/ucp' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
22	0.17 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.18 ms	SELECT date FROM http_error_log WHERE uri = ? Parameters: [`"https://test.deleeuwmotoren.nl/.well-known/ucp"`] 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://test.deleeuwmotoren.nl/.well-known/ucp';
24	0.97 ms	INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["https://test.deleeuwmotoren.nl/.well-known/ucp" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:55:{s:4:"USER";s:5:"loran";s:4:"HOME";s:11:"/home/loran";s:11:"SCRIPT_NAME";s:10:"/index.php";s:11:"REQUEST_URI";s:16:"/.well-known/ucp";s:12:"QUERY_STRING";s:0:"";s:14:"REQUEST_METHOD";s:3:"GET";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:12:"REDIRECT_URL";s:16:"/.well-known/ucp";s:11:"REMOTE_PORT";s:5:"47878";s:15:"SCRIPT_FILENAME";s:64:"/home/loran/domains/test.deleeuwmotoren.nl/public_html/index.php";s:12:"SERVER_ADMIN";s:32:"webmaster@test.deleeuwmotoren.nl";s:21:"CONTEXT_DOCUMENT_ROOT";s:54:"/home/loran/domains/test.deleeuwmotoren.nl/public_html";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:54:"/home/loran/domains/test.deleeuwmotoren.nl/public_html";s:11:"REMOTE_ADDR";s:15:"131.222.130.244";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:14:"136.144.170.41";s:11:"SERVER_NAME";s:22:"test.deleeuwmotoren.nl";s:15:"SERVER_SOFTWARE";s:8:"Apache/2";s:16:"SERVER_SIGNATURE";s:0:"";s:4:"PATH";s:49:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin";s:20:"HTTP_ACCEPT_ENCODING";s:17:"gzip, deflate, br";s:11:"HTTP_ACCEPT";s:3:"/";s:15:"HTTP_USER_AGENT";s:56:"RoasanBot/1.0 (+https://roasan.com/bot; bots@roasan.com)";s:15:"HTTP_CONNECTION";s:10:"keep-alive";s:9:"HTTP_HOST";s:22:"test.deleeuwmotoren.nl";s:17:"proxy-nokeepalive";s:1:"1";s:11:"SSL_TLS_SNI";s:22:"test.deleeuwmotoren.nl";s:5:"HTTPS";s:2:"on";s:15:"STATIC_PAGE_URI";s:6:"/%home";s:9:"UNIQUE_ID";s:27:"avTs3FZ-zxnQxz20zR1AagAAASg";s:15:"REDIRECT_STATUS";s:3:"200";s:20:"REDIRECT_SSL_TLS_SNI";s:22:"test.deleeuwmotoren.nl";s:14:"REDIRECT_HTTPS";s:2:"on";s:24:"REDIRECT_STATIC_PAGE_URI";s:6:"/%home";s:18:"REDIRECT_UNIQUE_ID";s:27:"avTs3FZ-zxnQxz20zR1AagAAASg";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1794436316.181968;s:12:"REQUEST_TIME";i:1794436316;s:7:"APP_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:16:"PIMCORE_DEV_MODE";s:5:"false";s:7:"DB_HOST";s:9:"localhost";s:7:"DB_NAME";s:10:"loran_test";s:7:"DB_USER";s:10:"loran_test";s:7:"DB_PASS";s:20:"rJeQpzRRHYT6PWcZgLsB";s:10:"DB_VERSION";s:15:"10.6.21-MariaDB";s:8:"BASE_URL";s:32:"https://loran.localhost.nl:8443/";s:18:"RECAPTCHA_SITE_KEY";s:40:"6LcSOBktAAAAAAJSlOrlE9IUSmvt7Egz81-NQ42L";s:20:"RECAPTCHA_SECRET_KEY";s:40:"6LcSOBktAAAAAFHap8MYBHd8j1KxrihTtS84mg7p";s:19:"SYMFONY_DOTENV_VARS";s:126:"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,DB_HOST,DB_NAME,DB_USER,DB_PASS,DB_VERSION,BASE_URL,RECAPTCHA_SITE_KEY,RECAPTCHA_SECRET_KEY";s:21:"DOCTRINE_DEPRECATIONS";s:7:"trigger";}" 1794436316 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://test.deleeuwmotoren.nl/.well-known/ucp', 404, 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:55:{s:4:\"USER\";s:5:\"loran\";s:4:\"HOME\";s:11:\"/home/loran\";s:11:\"SCRIPT_NAME\";s:10:\"/index.php\";s:11:\"REQUEST_URI\";s:16:\"/.well-known/ucp\";s:12:\"QUERY_STRING\";s:0:\"\";s:14:\"REQUEST_METHOD\";s:3:\"GET\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.1\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:12:\"REDIRECT_URL\";s:16:\"/.well-known/ucp\";s:11:\"REMOTE_PORT\";s:5:\"47878\";s:15:\"SCRIPT_FILENAME\";s:64:\"/home/loran/domains/test.deleeuwmotoren.nl/public_html/index.php\";s:12:\"SERVER_ADMIN\";s:32:\"webmaster@test.deleeuwmotoren.nl\";s:21:\"CONTEXT_DOCUMENT_ROOT\";s:54:\"/home/loran/domains/test.deleeuwmotoren.nl/public_html\";s:14:\"CONTEXT_PREFIX\";s:0:\"\";s:14:\"REQUEST_SCHEME\";s:5:\"https\";s:13:\"DOCUMENT_ROOT\";s:54:\"/home/loran/domains/test.deleeuwmotoren.nl/public_html\";s:11:\"REMOTE_ADDR\";s:15:\"131.222.130.244\";s:11:\"SERVER_PORT\";s:3:\"443\";s:11:\"SERVER_ADDR\";s:14:\"136.144.170.41\";s:11:\"SERVER_NAME\";s:22:\"test.deleeuwmotoren.nl\";s:15:\"SERVER_SOFTWARE\";s:8:\"Apache/2\";s:16:\"SERVER_SIGNATURE\";s:0:\"\";s:4:\"PATH\";s:49:\"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin\";s:20:\"HTTP_ACCEPT_ENCODING\";s:17:\"gzip, deflate, br\";s:11:\"HTTP_ACCEPT\";s:3:\"/\";s:15:\"HTTP_USER_AGENT\";s:56:\"RoasanBot/1.0 (+https://roasan.com/bot; bots@roasan.com)\";s:15:\"HTTP_CONNECTION\";s:10:\"keep-alive\";s:9:\"HTTP_HOST\";s:22:\"test.deleeuwmotoren.nl\";s:17:\"proxy-nokeepalive\";s:1:\"1\";s:11:\"SSL_TLS_SNI\";s:22:\"test.deleeuwmotoren.nl\";s:5:\"HTTPS\";s:2:\"on\";s:15:\"STATIC_PAGE_URI\";s:6:\"/%home\";s:9:\"UNIQUE_ID\";s:27:\"avTs3FZ-zxnQxz20zR1AagAAASg\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:20:\"REDIRECT_SSL_TLS_SNI\";s:22:\"test.deleeuwmotoren.nl\";s:14:\"REDIRECT_HTTPS\";s:2:\"on\";s:24:\"REDIRECT_STATIC_PAGE_URI\";s:6:\"/%home\";s:18:\"REDIRECT_UNIQUE_ID\";s:27:\"avTs3FZ-zxnQxz20zR1AagAAASg\";s:9:\"FCGI_ROLE\";s:9:\"RESPONDER\";s:8:\"PHP_SELF\";s:10:\"/index.php\";s:18:\"REQUEST_TIME_FLOAT\";d:1794436316.181968;s:12:\"REQUEST_TIME\";i:1794436316;s:7:\"APP_ENV\";s:3:\"dev\";s:9:\"APP_DEBUG\";s:1:\"0\";s:16:\"PIMCORE_DEV_MODE\";s:5:\"false\";s:7:\"DB_HOST\";s:9:\"localhost\";s:7:\"DB_NAME\";s:10:\"loran_test\";s:7:\"DB_USER\";s:10:\"loran_test\";s:7:\"DB_PASS\";s:20:\"rJeQpzRRHYT6PWcZgLsB\";s:10:\"DB_VERSION\";s:15:\"10.6.21-MariaDB\";s:8:\"BASE_URL\";s:32:\"https://loran.localhost.nl:8443/\";s:18:\"RECAPTCHA_SITE_KEY\";s:40:\"6LcSOBktAAAAAAJSlOrlE9IUSmvt7Egz81-NQ42L\";s:20:\"RECAPTCHA_SECRET_KEY\";s:40:\"6LcSOBktAAAAAFHap8MYBHd8j1KxrihTtS84mg7p\";s:19:\"SYMFONY_DOTENV_VARS\";s:126:\"APP_ENV,APP_DEBUG,PIMCORE_DEV_MODE,DB_HOST,DB_NAME,DB_USER,DB_PASS,DB_VERSION,BASE_URL,RECAPTCHA_SITE_KEY,RECAPTCHA_SECRET_KEY\";s:21:\"DOCTRINE_DEPRECATIONS\";s:7:\"trigger\";}', 1794436316, 1);
25	0.15 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.34 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: [`"/.well-known/ucp" "path" "auto_create" "/.well-known/ucp" "path_query" "https://test.deleeuwmotoren.nl/.well-known/ucp" "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 = '/.well-known/ucp' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/.well-known/ucp' AND `type` = 'path_query') OR (source = 'https://test.deleeuwmotoren.nl/.well-known/ucp' 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.44 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/.well-known/" "ucp"`] 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 '/.well-known/' AND `key` = BINARY 'ucp';
28	0.23 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/.well-known/ucp"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/.well-known/ucp';
29	0.13 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ".well-known"`] 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 '.well-known';
30	0.11 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/.well-known"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/.well-known';
31	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: [`1794436316 "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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
32	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: [`1794436316 "\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 > 1794436316 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');
33	0.28 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.22 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.38 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: [`"/.well-known/ucp" "path" "auto_create" "/.well-known/ucp" "path_query" "https://test.deleeuwmotoren.nl/.well-known/ucp" "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 = '/.well-known/ucp' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/.well-known/ucp' AND `type` = 'path_query') OR (source = 'https://test.deleeuwmotoren.nl/.well-known/ucp' 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://test.deleeuwmotoren.nl/.well-known/ucp

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping