Query Metrics
37
Database Queries
11
Different statements
16.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.25 ms (30.91%) |
1 |
INSERT INTO http_error_log (`uri`, `code`, `parametersGet`, `parametersPost`, `cookies`, `serverVars`, `date`, `count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "https://35.176.121.236/DVWA/login.php" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:60:{s:4:"PATH";s:352:"/opt/bitnami/apache/bin:/opt/bitnami/common/bin:/opt/bitnami/nami/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/opt/bitnami/apache/bin:/opt/bitnami/apache2/bin:/opt/bitnami/common/bin:/opt/bitnami/gonit/bin:/opt/bitnami/mariadb/bin:/opt/bitnami/mariadb/sbin:/opt/bitnami/php/bin:/opt/bitnami/php/sbin:/opt/bitnami/pimcore/vendor/bin";s:19:"PIMCORE_ENVIRONMENT";s:4:"prod";s:4:"USER";s:6:"daemon";s:4:"HOME";s:9:"/usr/sbin";s:11:"SCRIPT_NAME";s:10:"/index.php";s:11:"REQUEST_URI";s:15:"/DVWA/login.php";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:15:"/DVWA/login.php";s:11:"REMOTE_PORT";s:4:"9270";s:15:"SCRIPT_FILENAME";s:37:"/opt/bitnami/pimcore/public/index.php";s:12:"SERVER_ADMIN";s:15:"you@example.com";s:21:"CONTEXT_DOCUMENT_ROOT";s:27:"/opt/bitnami/pimcore/public";s:14:"CONTEXT_PREFIX";s:0:"";s:14:"REQUEST_SCHEME";s:5:"https";s:13:"DOCUMENT_ROOT";s:27:"/opt/bitnami/pimcore/public";s:11:"REMOTE_ADDR";s:14:"104.248.112.53";s:11:"SERVER_PORT";s:3:"443";s:11:"SERVER_ADDR";s:12:"172.31.9.222";s:11:"SERVER_NAME";s:14:"35.176.121.236";s:15:"SERVER_SOFTWARE";s:35:"Apache/2.4.48 (Unix) OpenSSL/1.1.1n";s:16:"SERVER_SIGNATURE";s:0:"";s:15:"HTTP_CONNECTION";s:5:"close";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:19:"HTTP_ACCEPT_CHARSET";s:5:"utf-8";s:15:"HTTP_USER_AGENT";s:69:"Mozilla/5.0 (ZZ; Linux x86_64; rv:125.0) Gecko/20100101 Firefox/125.0";s:9:"HTTP_HOST";s:14:"35.176.121.236";s:5:"HTTPS";s:2:"on";s:10:"SCRIPT_URI";s:37:"https://35.176.121.236/DVWA/login.php";s:10:"SCRIPT_URL";s:15:"/DVWA/login.php";s:15:"REDIRECT_STATUS";s:3:"200";s:14:"REDIRECT_HTTPS";s:2:"on";s:28:"REDIRECT_PIMCORE_ENVIRONMENT";s:4:"prod";s:19:"REDIRECT_SCRIPT_URI";s:37:"https://35.176.121.236/DVWA/login.php";s:19:"REDIRECT_SCRIPT_URL";s:15:"/DVWA/login.php";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1766158994.538272;s:12:"REQUEST_TIME";i:1766158994;s:7:"APP_ENV";s:3:"dev";s:7:"AWS_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:15:"COGNITO_POOL_ID";s:19:"eu-west-2_s7aWIx1ZD";s:17:"STRIPE_PUBLIC_KEY";s:107:"pk_test_51LdFYfLKNrIbEvGe5y8DQpqWU2jSSpZr99RPW0wdMzNrrxKR95HwEAQ0fn8p9lYl3rdou1ViWc3UliWTJ6r7RP4j001vYlJl1A";s:25:"STRIPE_ADD_MEMBER_PROD_ID";s:19:"prod_NV6Ia9qStr2jMF";s:27:"THUMBNAIL_OSGO_S3_BASE_PATH";s:59:"https://oscare-pimcore.s3.eu-west-2.amazonaws.com/thumbnail";s:24:"ASSETS_OSGO_S3_BASE_PATH";s:56:"https://oscare-pimcore.s3.eu-west-2.amazonaws.com/assets";s:30:"OSCARE_HEADOFFICE_S3_BASE_PATH";s:52:"https://oscare-headoffice.s3.eu-west-2.amazonaws.com";s:25:"GOOGLE_RECAPTCHA_SITE_KEY";s:0:"";s:23:"GOOGLE_RECAPTCHA_SECRET";s:0:"";s:14:"RECAPTCHA3_KEY";s:40:"6LdJhdgkAAAAABmvSwaCUJ5k5MYRqf03WvnWl24a";s:17:"RECAPTCHA3_SECRET";s:40:"6LdJhdgkAAAAAImMc3Q7Z5kpoawZsBXMdDSFkCmv";s:13:"APP_CLIENT_ID";s:25:"92b1t6uf75m3af1k64teov0t5";s:12:"USER_POOL_ID";s:19:"eu-west-2_u17bcGLwU";s:16:"IDENTITY_POOL_ID";s:46:"eu-west-2:e490529c-157f-486d-8abf-2a430e20d697";s:17:"MERLIN_DATASOURCE";s:5:"mbs01";s:10:"MERLIN_URL";s:39:"http://3.8.247.79:8181/merlin.asmx?WSDL";s:19:"SYMFONY_DOTENV_VARS";s:325:"APP_ENV,AWS_ENV,APP_DEBUG,COGNITO_POOL_ID,STRIPE_PUBLIC_KEY,STRIPE_ADD_MEMBER_PROD_ID,THUMBNAIL_OSGO_S3_BASE_PATH,ASSETS_OSGO_S3_BASE_PATH,OSCARE_HEADOFFICE_S3_BASE_PATH,GOOGLE_RECAPTCHA_SITE_KEY,GOOGLE_RECAPTCHA_SECRET,RECAPTCHA3_KEY,RECAPTCHA3_SECRET,APP_CLIENT_ID,USER_POOL_ID,IDENTITY_POOL_ID,MERLIN_DATASOURCE,MERLIN_URL";}" 1766158994 1 ] |
|
5.16 ms (30.37%) |
16 |
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:
[ 1766158994 [ "\x00tags\x00output_66b74223d954c8860aacfffd94d2cb2c_desktop" "output_66b74223d954c8860aacfffd94d2cb2c_desktop" ] ] |
|
1.85 ms (10.91%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "login.php" "path" => "/DVWA/" ] |
|
1.62 ms (9.52%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/DVWA/login.php" ] |
|
0.94 ms (5.53%) |
2 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
0.68 ms (4.02%) |
1 |
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
"https://35.176.121.236/DVWA/login.php"
]
|
|
0.56 ms (3.31%) |
1 |
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" => "/DVWA/login.php" "sourcePathQuery" => "/DVWA/login.php" "sourceEntireUri" => "https://35.176.121.236/DVWA/login.php" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.47 ms (2.77%) |
1 |
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" => "/DVWA/login.php" "sourcePathQuery" => "/DVWA/login.php" "sourceEntireUri" => "https://35.176.121.236/DVWA/login.php" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.21 ms (1.22%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/DVWA/login.php' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.15 ms (0.88%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
198
]
|
|
0.10 ms (0.57%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
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.