Query Metrics
30
Database Queries
15
Different statements
37.14 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.95 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:
[ 1782479325 [ "\x00tags\x00output_466021a78a73b1fdb4a23943e92882f9_phone" "output_466021a78a73b1fdb4a23943e92882f9_phone" ] ] |
| 2 | 3.09 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:
[ 1782479325 [ "\x00tags\x00output_466021a78a73b1fdb4a23943e92882f9" "output_466021a78a73b1fdb4a23943e92882f9" ] ] |
| 3 | 0.91 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:
[ 1782479325 [ "output\x00tags\x00" "output_466021a78a73b1fdb4a23943e92882f9\x00tags\x00" ] ] |
| 4 | 0.85 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:
[ 1782479325 [ "\x00tags\x00site_domain_3b9ca570b36661f625a88e77a18f0501" "site_domain_3b9ca570b36661f625a88e77a18f0501" ] ] |
| 5 | 0.82 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:
[ 1782479325 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_3b9ca570b36661f625a88e77a18f0501\x00tags\x00" ] ] |
| 6 | 1.20 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" => "/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "sourcePathQuery" => "/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "sourceEntireUri" => "http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
| 7 | 0.93 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:
[ 1782479325 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ] ] |
| 8 | 0.88 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:
[ 1782479325 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ] ] |
| 9 | 0.81 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
| 10 | 0.87 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "path" => "/iera/" ] |
| 11 | 0.82 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" ] |
| 12 | 0.86 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "iera" "path" => "/" ] |
| 13 | 0.74 ms |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/iera" ] |
| 14 | 0.78 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "" "path" => "/" ] |
| 15 | 1.08 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:
[ 1782479325 [ "\x00tags\x00document_1" "document_1" ] ] |
| 16 | 0.92 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:
[ 1782479325 [ "document_1\x00tags\x00" "asset_431\x00tags\x00" "asset_524\x00tags\x00" "asset_528\x00tags\x00" "asset_532\x00tags\x00" "asset_535\x00tags\x00" "asset_539\x00tags\x00" "asset_542\x00tags\x00" "asset_564\x00tags\x00" "asset_565\x00tags\x00" "asset_573\x00tags\x00" "asset_585\x00tags\x00" "asset_136\x00tags\x00" "asset_130\x00tags\x00" "asset_120\x00tags\x00" "asset_7\x00tags\x00" ] ] |
| 17 | 0.91 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:
[ 1782479325 [ "\x00tags\x00document_properties_1" "document_properties_1" ] ] |
| 18 | 0.89 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:
[ 1782479325 [ "document_properties\x00tags\x00" "document_1\x00tags\x00" "document_properties_1\x00tags\x00" ] ] |
| 19 | 0.89 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
| 20 | 1.26 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:
[ 1782479325 [ "\x00tags\x00object_7820" "object_7820" ] ] |
| 21 | 0.91 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:
[ 1782479325 [ "object_7820\x00tags\x00" "class_1\x00tags\x00" ] ] |
| 22 | 0.82 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
7820
]
|
| 23 | 1.15 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
7820
]
|
| 24 | 1.03 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"1"
]
|
| 25 | 2.39 ms |
SELECT * FROM object_store_1 WHERE oo_id = ?
Parameters:
[
7820
]
|
| 26 | 0.83 ms |
SELECT * FROM object_relations_1 WHERE src_id = ?
Parameters:
[
7820
]
|
| 27 | 1.34 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" => "/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "sourcePathQuery" => "/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "sourceEntireUri" => "http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
| 28 | 1.45 ms |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
| 29 | 1.02 ms |
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
"http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820"
]
|
| 30 | 5.73 ms |
INSERT INTO http_error_log (`uri`, `code`, `parametersGet`, `parametersPost`, `cookies`, `serverVars`, `date`, `count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "http://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820" 404 "a:0:{}" "a:0:{}" "a:0:{}" "a:121:{s:8:"smtppass";s:44:"QPzH1zWgdVpjzlt3fIrDqs8GNc0stn+KinWq2seYNf5O";s:15:"KUBERNETES_PORT";s:20:"tcp://172.20.0.1:443";s:23:"KUBERNETES_SERVICE_PORT";s:3:"443";s:33:"PIMCORE_INSTALL_MYSQL_HOST_SOCKET";s:58:"cms-prod-restored.cjveix7s4jyo.eu-west-1.rds.amazonaws.com";s:4:"test";s:5:"test1";s:9:"APP_DEBUG";s:1:"0";s:28:"CORPORATE_NGINX_SERVICE_HOST";s:13:"172.20.52.149";s:8:"HOSTNAME";s:34:"corporate-pimcore-64bb77899d-lfbcr";s:11:"PHP_INI_DIR";s:18:"/usr/local/etc/php";s:21:"COMPOSER_MEMORY_LIMIT";s:2:"-1";s:7:"DB_PORT";s:4:"3306";s:4:"host";s:58:"cms-prod-restored.cjveix7s4jyo.eu-west-1.rds.amazonaws.com";s:18:"ERECRUITER_XML_URL";s:194:"https://offers.erecruiter.pl/skk/company/20133278/offers.xml?hash=ADB0264E2BCC43B70FF5208473AB3E01888E8DF21D301AF2ED73AF7DF8AA7955456D9B496211E46DFB25DE6F996EC40769FAC4A1DF31C74D3C94DF97C48BFC30";s:5:"SHLVL";s:1:"1";s:8:"username";s:7:"pimcore";s:4:"HOME";s:14:"/home/www-data";s:7:"DB_NAME";s:7:"pimcore";s:8:"smtphost";s:18:"smtp.office365.com";s:24:"GOOGLE_GEOCODING_API_KEY";s:39:"AIzaSyDtkhPiFQHxJNDOuMCS-Uvf-WYw_G9omMw";s:8:"smtpuser";s:28:"stronakorporacyjna@gemini.pl";s:10:"MAILER_DSN";s:85:"smtp://stronakorporacyjna%40gemini.pl:Cq%2F7WLK%28A6%21s%3FXg6@smtp.office365.com:587";s:11:"PHP_LDFLAGS";s:12:"-Wl,-O1 -pie";s:11:"DB_DATABASE";s:7:"pimcore";s:28:"CORPORATE_NGINX_SERVICE_PORT";s:2:"80";s:20:"CORPORATE_NGINX_PORT";s:22:"tcp://172.20.52.149:80";s:10:"PHP_CFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:17:"PARAMETERS_SECRET";s:32:"1MvBBuu48%p3Ji$78lhuWa1cHt&Q5^LM";s:11:"PHP_VERSION";s:6:"8.1.28";s:8:"GPG_KEYS";s:122:"528995BFEDFBA7191D46839EF9BA0ADA31CBD89E 39B641343D8C104B2B146DC3F9C39DC0B9698544 F1F692238FBC1666E5A5CCD4199F9DFEF6FFBAFD";s:17:"RECAPTCHA_ENABLED";s:4:"true";s:12:"PHP_CPPFLAGS";s:83:"-fstack-protector-strong -fpic -fpie -O2 -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64";s:11:"PHP_ASC_URL";s:55:"https://www.php.net/distributions/php-8.1.28.tar.xz.asc";s:24:"COMPOSER_ALLOW_SUPERUSER";s:1:"1";s:9:"adminpass";s:12:"Mm5hc2QzbmRh";s:32:"CORPORATE_NGINX_PORT_80_TCP_ADDR";s:13:"172.20.52.149";s:38:"CORPORATE_PIMCORE_SERVICE_PORT_FASTCGI";s:4:"9000";s:7:"PHP_URL";s:51:"https://www.php.net/distributions/php-8.1.28.tar.xz";s:25:"GOOGLE_RECAPTCHA_SITE_KEY";s:40:"6LfcjVAsAAAAAGeHwMwDzwpoSdBobgwcqyzGZu7a";s:16:"PIMCORE_DEV_MODE";s:5:"false";s:36:"CORPORATE_PIMCORE_PORT_9000_TCP_ADDR";s:13:"172.20.152.28";s:32:"CORPORATE_NGINX_PORT_80_TCP_PORT";s:2:"80";s:28:"KUBERNETES_PORT_443_TCP_ADDR";s:10:"172.20.0.1";s:33:"CORPORATE_NGINX_PORT_80_TCP_PROTO";s:3:"tcp";s:4:"PATH";s:87:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/root/.composer/vendor/bin";s:10:"MAX_UPLOAD";s:3:"50M";s:36:"CORPORATE_PIMCORE_PORT_9000_TCP_PORT";s:4:"9000";s:4:"port";s:4:"3306";s:28:"KUBERNETES_PORT_443_TCP_PORT";s:3:"443";s:37:"CORPORATE_PIMCORE_PORT_9000_TCP_PROTO";s:3:"tcp";s:16:"PHP_MEMORY_LIMIT";s:4:"256M";s:8:"password";s:12:"aDIzc2FzZGFz";s:6:"engine";s:5:"mysql";s:29:"KUBERNETES_PORT_443_TCP_PROTO";s:3:"tcp";s:19:"PIMCORE_ENVIRONMENT";s:4:"prod";s:30:"CORPORATE_PIMCORE_SERVICE_HOST";s:13:"172.20.152.28";s:7:"API_KEY";s:30:"KLcrkN^Fb2HZDXZq%Q4yxmndJBPPu2";s:30:"PIMCORE_INSTALL_ADMIN_PASSWORD";s:12:"Mm5hc2QzbmRh";s:27:"CORPORATE_NGINX_PORT_80_TCP";s:22:"tcp://172.20.52.149:80";s:23:"GOOGLE_RECAPTCHA_SECRET";s:40:"6LfcjVAsAAAAAOwlqjNy340thc8BXLXCeIgKwa6y";s:9:"SMTP_PASS";s:16:"Cq/7WLK(A6!s?Xg6";s:31:"CORPORATE_PIMCORE_PORT_9000_TCP";s:24:"tcp://172.20.152.28:9000";s:10:"SENTRY_DSN";s:85:"https://e68b4c6349be5f297051adcfd59ea85c@o338873.ingest.us.sentry.io/4510107331264512";s:18:"SENTRY_ENVIRONMENT";s:4:"prod";s:6:"dbname";s:7:"pimcore";s:29:"KUBERNETES_SERVICE_PORT_HTTPS";s:3:"443";s:23:"KUBERNETES_PORT_443_TCP";s:20:"tcp://172.20.0.1:443";s:30:"CORPORATE_PIMCORE_SERVICE_PORT";s:4:"9000";s:22:"CORPORATE_PIMCORE_PORT";s:24:"tcp://172.20.152.28:9000";s:11:"PHPIZE_DEPS";s:78:"autoconf \t\tdpkg-dev dpkg \t\tfile \t\tg++ \t\tgcc \t\tlibc-dev \t\tmake \t\tpkgconf \t\tre2c";s:11:"DB_PASSWORD";s:12:"aDIzc2FzZGFz";s:23:"KUBERNETES_SERVICE_HOST";s:10:"172.20.0.1";s:3:"PWD";s:16:"/var/www/pimcore";s:10:"PHP_SHA256";s:64:"95d0b2e9466108fd750dab5c30a09e5c67f5ad2cb3b1ffb3625a038a755ad080";s:12:"PHP_MAX_POST";s:3:"60M";s:33:"CORPORATE_NGINX_SERVICE_PORT_HTTP";s:2:"80";s:7:"DB_HOST";s:58:"cms-prod-restored.cjveix7s4jyo.eu-west-1.rds.amazonaws.com";s:9:"SMTP_HOST";s:18:"smtp.office365.com";s:7:"DB_USER";s:7:"pimcore";s:19:"PHP_MAX_FILE_UPLOAD";s:3:"200";s:9:"SMTP_USER";s:28:"stronakorporacyjna@gemini.pl";s:4:"USER";s:8:"www-data";s:12:"HTTP_REFERER";s:105:"https://geminipolska.com.pl/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820";s:20:"HTTP_ACCEPT_LANGUAGE";s:11:"pl,en;q=0.8";s:20:"HTTP_ACCEPT_ENCODING";s:23:"gzip, deflate, br, zstd";s:11:"HTTP_ACCEPT";s:85:"text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8";s:15:"HTTP_USER_AGENT";s:164:"Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (HTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)";s:20:"HTTP_X_AMZN_TRACE_ID";s:40:"Root=1-6a3e79dd-09de0257232b444d65f2f4c5";s:21:"HTTP_X_FORWARDED_PORT";s:3:"443";s:22:"HTTP_X_FORWARDED_PROTO";s:5:"https";s:20:"HTTP_X_FORWARDED_FOR";s:15:"114.119.145.212";s:9:"HTTP_HOST";s:19:"geminipolska.com.pl";s:9:"PATH_INFO";s:0:"";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"SERVER_NAME";s:1:"_";s:11:"SERVER_PORT";s:2:"80";s:11:"SERVER_ADDR";s:12:"10.146.9.127";s:11:"REMOTE_PORT";s:0:"";s:11:"REMOTE_ADDR";s:15:"114.119.145.212";s:15:"SERVER_SOFTWARE";s:12:"nginx/1.30.3";s:17:"GATEWAY_INTERFACE";s:7:"CGI/1.1";s:14:"REQUEST_SCHEME";s:4:"http";s:15:"SERVER_PROTOCOL";s:8:"HTTP/1.1";s:13:"DOCUMENT_ROOT";s:23:"/var/www/pimcore/public";s:12:"DOCUMENT_URI";s:10:"/index.php";s:11:"REQUEST_URI";s:78:"/iera/Technik-Farmaceutyczny-StazystaTechniczka-Farmaceutyczna-Stazystka~o7820";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:15:"SCRIPT_FILENAME";s:33:"/var/www/pimcore/public/index.php";s:9:"FCGI_ROLE";s:9:"RESPONDER";s:8:"PHP_SELF";s:10:"/index.php";s:18:"REQUEST_TIME_FLOAT";d:1782479325.477962;s:12:"REQUEST_TIME";i:1782479325;s:7:"APP_ENV";s:3:"dev";s:10:"APP_SECRET";s:40:"PUT_RANDOM_STRING_HERE_32CHARACTERS_LONG";s:16:"DB_ROOT_PASSWORD";s:4:"ROOT";s:9:"DB_ENGINE";s:5:"mysql";s:16:"RECAPTCHA_SECRET";s:0:"";s:19:"SYMFONY_DOTENV_VARS";s:62:"APP_ENV,APP_SECRET,DB_ROOT_PASSWORD,DB_ENGINE,RECAPTCHA_SECRET";}" 1782479325 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.