http://kemon-test.sintrasviluppo.it/login/

Query Metrics

22 Database Queries
10 Different statements
7.14 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.37 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:
[
  1731646924
  [
    "\x00tags\x00site_domain_3729da8ab706ede0b71f76d76cb6d444"
    "site_domain_3729da8ab706ede0b71f76d76cb6d444"
  ]
]
2 0.40 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:
[
  1731646924
  [
    "system\x00tags\x00"
    "site\x00tags\x00"
    "site_domain_3729da8ab706ede0b71f76d76cb6d444\x00tags\x00"
  ]
]
3 0.51 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" => "/login/"
  "sourcePathQuery" => "/login/"
  "sourceEntireUri" => "http://kemon-test.sintrasviluppo.it/login/"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
4 0.36 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:
[
  1731646924
  [
    "\x00tags\x00system_route_redirect"
    "system_route_redirect"
  ]
]
5 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:
[
  1731646924
  [
    "system\x00tags\x00"
    "redirect\x00tags\x00"
    "route\x00tags\x00"
    "system_route_redirect\x00tags\x00"
  ]
]
6 0.15 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
7 0.31 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "login"
  "path" => "/"
]
8 1.23 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/login"
]
9 0.17 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "login"
  "path" => "/"
]
10 0.18 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/login"
]
11 0.20 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
12 0.15 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1731646924
  [
    "\x00tags\x00document_1"
    "document_1"
  ]
]
13 0.36 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:
[
  1731646924
  [
    "document_1\x00tags\x00"
    "asset_15\x00tags\x00"
    "asset_39\x00tags\x00"
    "asset_36\x00tags\x00"
    "asset_123\x00tags\x00"
    "asset_122\x00tags\x00"
  ]
]
14 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:
[
  1731646924
  [
    "\x00tags\x00document_properties_1"
    "document_properties_1"
  ]
]
15 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:
[
  1731646924
  [
    "document_properties\x00tags\x00"
    "document_1\x00tags\x00"
    "document_properties_1\x00tags\x00"
  ]
]
16 0.17 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
17 0.15 ms
SELECT id FROM targeting_rules WHERE active = 1  ORDER BY `prio` ASC
Parameters:
[]
18 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1731646924
  [
    "\x00tags\x00document_target_groups_1"
    "document_target_groups_1"
  ]
]
19 0.15 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1731646924
  [
    "document_1\x00tags\x00"
    "target_groups\x00tags\x00"
    "document_target_groups_1\x00tags\x00"
  ]
]
20 0.32 ms
SELECT id FROM assets WHERE path = :path AND `filename` = :key
Parameters:
[
  "key" => "login"
  "path" => "/"
]
21 0.43 ms
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
  "http://kemon-test.sintrasviluppo.it/login/"
]
22 0.67 ms
INSERT INTO http_error_log (`uri`, `code`, `parametersGet`, `parametersPost`, `cookies`, `serverVars`, `date`, `count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "http://kemon-test.sintrasviluppo.it/login/"
  403
  "a:0:{}"
  "a:0:{}"
  "a:0:{}"
  """
    a:81:{s:15:"REDIRECT_STATUS";s:3:"200";s:9:"HTTP_HOST";s:28:"kemon-test.sintrasviluppo.it";s:14:"HTTP_X_REAL_IP";s:11:"34.16.82.73";s:20:"HTTP_X_FORWARDED_FOR";s:11:"34.16.82.73";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:15:"HTTP_CONNECTION";s:5:"close";s:11:"HTTP_ACCEPT";s:135:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7";s:15:"HTTP_USER_AGENT";s:117:"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36";s:20:"HTTP_ACCEPT_LANGUAGE";s:14:"en-US,en;q=0.9";s:18:"HTTP_CACHE_CONTROL";s:8:"no-cache";s:11:"HTTP_PRAGMA";s:8:"no-cache";s:13:"HTTP_PRIORITY";s:6:"u=0, i";s:14:"HTTP_SEC_CH_UA";s:65:""Not)A;Brand";v="99", "Google Chrome";v="127", "Chromium";v="127"";s:21:"HTTP_SEC_CH_UA_MOBILE";s:2:"?0";s:23:"HTTP_SEC_CH_UA_PLATFORM";s:7:""macOS"";s:19:"HTTP_SEC_FETCH_DEST";s:7:""macOS"";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:19:"HTTP_SEC_FETCH_SITE";s:4:"none";s:19:"HTTP_SEC_FETCH_USER";s:2:"?1";s:30:"HTTP_UPGRADE_INSECURE_REQUESTS";s:1:"1";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, br, zstd, deflate";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:16:"SERVER_SIGNATURE";s:89:"<address>Apache/2.4.38 (Debian) Server at kemon-test.sintrasviluppo.it Port 80</address>\n
    ";s:15:"SERVER_SOFTWARE";s:22:"Apache/2.4.38 (Debian)";s:11:"SERVER_NAME";s:28:"kemon-test.sintrasviluppo.it";s:11:"SERVER_ADDR";s:10:"172.30.0.6";s:11:"SERVER_PORT";s:2:"80";s:11:"REMOTE_ADDR";s:10:"172.30.0.1";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:"54098";s:12:"REDIRECT_URL";s:7:"/login/";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.0";s:14:"REQUEST_METHOD";s:3:"GET";s:12:"QUERY_STRING";s:0:"";s:11:"REQUEST_URI";s:7:"/login/";s:11:"SCRIPT_NAME";s:10:"/index.php";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1731646924.377547;s:12:"REQUEST_TIME";i:1731646924;s:4:"argv";a:0:{}s:4:"argc";i:0;s:8:"HOSTNAME";s:12:"80cbca60f427";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:10:"AWS_REGION";s:12:"eu-central-1";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:4:"LANG";s:1:"C";s:7:"APP_ENV";s:3:"dev";s:9:"APP_DEBUG";s:1:"0";s:10:"PHP_SHA256";s:64:"66dc4d1bc86d9c1bc255b51b79d337ed1a7a035cf71230daabbf9a4ca35795eb";s:15:"APACHE_PID_FILE";s:28:"/var/run/apache2/apache2.pid";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:"PIMCORE_DEV_MODE";s:4:""no"";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:17:"AWS_ACCESS_KEY_ID";s:20:"AKIAWEGQCNQWMUQOPZXL";s:10:"PHP_CFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:10:"AWS_BUCKET";s:17:"kemon-test-bucket";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:15:"APACHE_RUN_USER";s:8:"www-data";s:20:"PHP_EXTRA_BUILD_DEPS";s:11:"apache2-dev";s:17:"AWS_ACCESS_SECRET";s:40:"lZ92NXyBjfd+Gdx7OY2x8on/HsAADF/J2xTbJpDf";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";}
    """
  1731646924
  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.