Query Metrics
32
Database Queries
11
Different statements
19.14 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.62 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:
[ 1719431558 "site_domain_c1114a657c638166de0c8066ae0059b4" ] |
2 | 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:
[ 1719431558 "system\x01tags\x01" "site\x01tags\x01" ] |
3 | 0.49 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "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:
[ "/" "path" "auto_create" "/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog" "path_query" "http://www.rainbowmilk.com/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog" "entire_uri" ] |
5 | 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:
[ 1719431558 "system_route_redirect" ] |
6 | 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:
[ 1719431558 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
7 | 0.46 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
8 | 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:
[ 1719431558 "output_84f71cafad880c6c0fcbb05a632dd3b6_phone" ] |
9 | 0.60 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:
[ 1719431558 "\x00tags\x00output_84f71cafad880c6c0fcbb05a632dd3b6_phone" ] |
10 | 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:
[ 1719431558 "output_84f71cafad880c6c0fcbb05a632dd3b6" ] |
11 | 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:
[ 1719431558 "\x00tags\x00output_84f71cafad880c6c0fcbb05a632dd3b6" ] |
12 | 0.49 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "reports" "pimcore" ] |
13 | 0.53 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
"/"
""
]
|
14 | 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:
[ 1719431558 "document_1" ] |
15 | 0.45 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:
[ 1719431558 "document_1\x01tags\x01" ] |
16 | 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:
[ 1719431558 "sites_path_mapping" ] |
17 | 0.46 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:
[ 1719431558 "\x00tags\x00sites_path_mapping" ] |
18 | 0.52 ms |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
19 | 0.46 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:
[ 1719431558 "document_properties_1" ] |
20 | 0.52 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:
[ 1719431558 "document_properties\x01tags\x01" "document_1\x01tags\x01" ] |
21 | 0.47 ms |
SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
22 | 0.64 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
23 | 0.53 ms |
SELECT date FROM http_error_log WHERE uri = ?
Parameters:
[
"http://www.rainbowmilk.com/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog"
]
|
24 | 2.78 ms |
INSERT INTO http_error_log (uri, code, parametersGet, parametersPost, cookies, serverVars, date, count) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "http://www.rainbowmilk.com/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog" 500 "a:1:{s:6:"fbclid";s:104:"PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog";}" "a:0:{}" "a:0:{}" "a:87:{s:15:"KUBERNETES_PORT";s:20:"tcp://10.233.0.1:443";s:23:"KUBERNETES_SERVICE_PORT";s:3:"443";s:8:"HOSTNAME";s:47:"rainbowmilk-com-prd-deployment-558d55957c-mdcjq";s:14:"MYSQL_TCP_PORT";s:4:"3306";s:5:"SHLVL";s:1:"1";s:35:"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP";s:21:"tcp://10.233.41.31:80";s:4:"HOME";s:14:"/home/www-data";s:11:"ENVIRONMENT";s:3:"prd";s:3:"CWD";s:16:"/var/www/pimcore";s:6:"DOMAIN";s:19:"www.rainbowmilk.com";s:17:"PHP_MAJOR_VERSION";s:5:"php81";s:9:"MYSQL_PWD";s:25:"38723962257c87c4aeabec602";s:28:"KUBERNETES_PORT_443_TCP_ADDR";s:10:"10.233.0.1";s:14:"CONTAINER_TYPE";s:3:"APP";s:36:"RAINBOWMILK_COM_PRD_SVC_SERVICE_HOST";s:12:"10.233.41.31";s:4:"PATH";s:60:"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin";s:8:"WWW_PATH";s:16:"/var/www/pimcore";s:28:"KUBERNETES_PORT_443_TCP_PORT";s:3:"443";s:18:"S6_OVERLAY_RELEASE";s:96:"https://github.com/just-containers/s6-overlay/releases/download/v2.2.0.3/s6-overlay-amd64.tar.gz";s:29:"KUBERNETES_PORT_443_TCP_PROTO";s:3:"tcp";s:10:"MYSQL_HOST";s:44:"sch-mysql-prd-lb-02.rfc.fc-platform.internal";s:10:"MYSQL_USER";s:15:"ad3258bbf813217";s:28:"RAINBOWMILK_COM_PRD_SVC_PORT";s:21:"tcp://10.233.41.31:80";s:36:"RAINBOWMILK_COM_PRD_SVC_SERVICE_PORT";s:2:"80";s:23:"KUBERNETES_PORT_443_TCP";s:20:"tcp://10.233.0.1:443";s:29:"KUBERNETES_SERVICE_PORT_HTTPS";s:3:"443";s:40:"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP_ADDR";s:12:"10.233.41.31";s:23:"KUBERNETES_SERVICE_HOST";s:10:"10.233.0.1";s:3:"PWD";s:24:"/run/s6/services/php-fpm";s:17:"NEW_RELIC_ENABLED";s:4:"True";s:21:"NEW_RELIC_LICENSE_KEY";s:40:"eu01xx072476a8b4eb62fd03fdbae2faFFFFNRAL";s:18:"NEW_RELIC_APP_NAME";s:19:"prd-rainbowmilk-com";s:14:"MYSQL_DATABASE";s:27:"pimcore-prd-rainbowmilk-com";s:40:"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP_PORT";s:2:"80";s:48:"RAINBOWMILK_COM_PRD_SVC_SERVICE_PORT_PORT_80_TCP";s:2:"80";s:41:"RAINBOWMILK_COM_PRD_SVC_PORT_80_TCP_PROTO";s:3:"tcp";s:4:"USER";s:8:"www-data";s:18:"HTTP_CACHE_CONTROL";s:9:"max-age=0";s:8:"HTTP_VIA";s:79:"1.1 v1-akamaitech.net(ghost) (AkamaiGHost), 1.1 akamai.net(ghost) (AkamaiGHost)";s:22:"HTTP_AKAMAI_ORIGIN_HOP";s:1:"2";s:20:"HTTP_ACCEPT_ENCODING";s:4:"gzip";s:31:"HTTP_X_AKAMAI_CONFIG_LOG_DETAIL";s:4:"true";s:19:"HTTP_TRUE_CLIENT_IP";s:11:"5.193.92.89";s:23:"HTTP_X_AKAMAI_EDGESCAPE";s:156:"georegion=227,country_code=AE,city=DUBAI,lat=25.25,long=55.28,timezone=GMT+4,continent=AS,throughput=vhigh,bw=5000,network=etisalat,asnum=5384,location_id=0";s:12:"HTTP_REFERER";s:24:"https://l.instagram.com/";s:15:"HTTP_USER_AGENT";s:204:"Mozilla/5.0 (iPhone; CPU iPhone OS 17_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/21F90 Instagram 336.1.8.30.85 (iPhone15,3; iOS 17_5_1; en_IN; en; scale=3.00; 1290x2796; 612888060)";s:19:"HTTP_SEC_FETCH_MODE";s:8:"navigate";s:20:"HTTP_ACCEPT_LANGUAGE";s:26:"en-IN,en-GB;q=0.9,en;q=0.8";s:19:"HTTP_SEC_FETCH_DEST";s:8:"document";s:19:"HTTP_SEC_FETCH_SITE";s:10:"cross-site";s:11:"HTTP_ACCEPT";s:63:"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8";s:20:"HTTP_X_AMZN_TRACE_ID";s:40:"Root=1-667c7186-4f9f1beb751341a66c0ac5c2";s:29:"HTTP_X_ORIGINAL_FORWARDED_FOR";s:39:"5.193.92.89, 2.20.249.149, 2.16.110.140";s:13:"HTTP_X_SCHEME";s:4:"http";s:23:"HTTP_X_FORWARDED_SCHEME";s:4:"http";s:22:"HTTP_X_FORWARDED_PROTO";s:4:"http";s:21:"HTTP_X_FORWARDED_PORT";s:2:"80";s:21:"HTTP_X_FORWARDED_HOST";s:19:"www.rainbowmilk.com";s:20:"HTTP_X_FORWARDED_FOR";s:11:"5.193.92.89";s:14:"HTTP_X_REAL_IP";s:11:"5.193.92.89";s:17:"HTTP_X_REQUEST_ID";s:32:"e1a18ee9f3b894a2d3c6a5e6b73d60a7";s:9:"HTTP_HOST";s:19:"www.rainbowmilk.com";s:9:"PATH_INFO";s:0:"";s:15:"REDIRECT_STATUS";s:3:"200";s:11:"SERVER_NAME";s:0:"";s:11:"SERVER_PORT";s:2:"80";s:11:"SERVER_ADDR";s:14:"10.233.103.234";s:11:"REMOTE_PORT";s:5:"40772";s:11:"REMOTE_ADDR";s:13:"10.233.64.178";s:15:"SERVER_SOFTWARE";s:12:"nginx/1.24.0";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:113:"/?fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog";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:111:"fbclid=PAZXh0bgNhZW0CMTEAAaY-XyCwaL6Z6McRzp-l3-2YDJqoyEFhdbF6KOJ_TCWIp-hIl7kch-wiSYo_aem_gncxzoX7QWhokKcYyhzxog";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:1719431558.493528;s:12:"REQUEST_TIME";i:1719431558;s:21:"DOCTRINE_DEPRECATIONS";s:7:"trigger";}" 1719431559 1 ] |
25 | 0.49 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
26 | 0.65 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/" "server-error" ] |
27 | 0.76 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:
[ 1719431559 "document_127" ] |
28 | 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:
[ 1719431559 "document_127\x01tags\x01" ] |
29 | 0.55 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:
[ 1719431559 "document_properties_127" ] |
30 | 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:
[ 1719431559 "document_properties\x01tags\x01" "document_127\x01tags\x01" ] |
31 | 0.47 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
32 | 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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_locale=en_GB&_format=html&_controller=App%5CController%5CContentController%3A%3AdefaultAction" "path_query" "http://www.rainbowmilk.com/_fragment?_path=_locale=en_GB&_format=html&_controller=App%5CController%5CContentController%3A%3AdefaultAction" "entire_uri" ] |
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.