Query Metrics
188
Database Queries
44
Different statements
62.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.94 ms (22.41%) |
18 |
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1766072580) AND (tl_content.stop='' OR tl_content.stop>1766072580) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 14020 "tl_article" ] |
|
4.80 ms (7.72%) |
33 |
SELECT pct_customelement FROM tl_content WHERE id=? LIMIT 0,1
Parameters:
[
117841
]
|
|
4.36 ms (7.00%) |
8 |
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1766072580) AND (tl_content.stop='' OR tl_content.stop>1766072580) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 8 "tl_revolutionslider_slides" ] |
|
3.48 ms (5.60%) |
13 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
"2606"
]
|
|
3.13 ms (5.03%) |
9 |
SELECT tl_article.* FROM tl_article WHERE BINARY tl_article.alias=? LIMIT 0,1
Parameters:
[
"offcanvas-col1"
]
|
|
3.02 ms (4.85%) |
1 |
SELECT * FROM tl_pct_customelement_attribute WHERE tstamp > 0 AND pid IN(2,4,5,6,7,8,9,10,17,18,19,20,21,24,27,28,29,30,31,32,33,37,38,39,40,44,45,46,52,53,56,66,67,68,69,70,71,73,76,77,78,79,81,82,83,84,85,86,88,89,97,100,101,102,103,104,106,107,125,126,127,128,130,131,134,135,137,138,139,142,143,144,149,154,155,156,157,158,159,160,161,162,168,169,170,171,172,173,179,180,181,182,189,190,191,231,235,236,237,238,245,247,252,256,257,258,259,262,267,268,273,274,275,292,293,294,295,297,300,301,303,308,310,312,313,316,317,321,322,324,325,326,327,328,329,330,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,426,427,428,429,430,431)
Parameters:
[] |
|
3.00 ms (4.83%) |
13 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
2604
]
|
|
2.50 ms (4.02%) |
6 |
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1766072580) AND (p2.stop='' OR p2.stop>1766072580)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1766072580) AND (p1.stop='' OR p1.stop>1766072580) ORDER BY p1.sorting
Parameters:
[
2709
]
|
|
2.49 ms (4.01%) |
16 |
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
"fde4f7ed56f211eab3d3001a4a050158"
]
|
|
1.78 ms (2.87%) |
2 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
Parameters:
[ "en/home" "en" "home" ] |
|
1.56 ms (2.50%) |
11 |
SELECT * FROM tl_files WHERE tl_files.`id`=? LIMIT 0,1
Parameters:
[
null
]
|
|
1.37 ms (2.20%) |
8 |
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC
Parameters:
[
5
]
|
|
1.35 ms (2.17%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"grace_accelerator_db"
]
|
|
1.32 ms (2.12%) |
7 |
SELECT tl_pct_customelement_group.* FROM tl_pct_customelement_group WHERE tl_pct_customelement_group.alias=? AND tl_pct_customelement_group.pid=? LIMIT 0,1
Parameters:
[ "margins" 68 ] |
|
1.10 ms (1.77%) |
3 |
SELECT tl_form.*, j1.`ribbon` AS leadOptInTarget__ribbon, j1.`addImage` AS leadOptInTarget__addImage, j1.`singleSRC` AS leadOptInTarget__singleSRC, j1.`style_css` AS leadOptInTarget__style_css, j1.`height_css` AS leadOptInTarget__height_css, j1.`imgHeadline` AS leadOptInTarget__imgHeadline, j1.`imgSubheadline` AS leadOptInTarget__imgSubheadline, j1.`addArticle` AS leadOptInTarget__addArticle, j1.`article` AS leadOptInTarget__article, j1.`visibility_css` AS leadOptInTarget__visibility_css, j1.`analytics_google` AS leadOptInTarget__analytics_google, j1.`analytics_matomo` AS leadOptInTarget__analytics_matomo, j1.`google_maps` AS leadOptInTarget__google_maps, j1.`id` AS leadOptInTarget__id, j1.`pid` AS leadOptInTarget__pid, j1.`sorting` AS leadOptInTarget__sorting, j1.`tstamp` AS leadOptInTarget__tstamp, j1.`title` AS leadOptInTarget__title, j1.`type` AS leadOptInTarget__type, j1.`alias` AS leadOptInTarget__alias, j1.`requireItem` AS leadOptInTarget__requireItem, j1.`routePriority` AS leadOptInTarget__routePriority, j1.`pageTitle` AS leadOptInTarget__pageTitle, j1.`language` AS leadOptInTarget__language, j1.`robots` AS leadOptInTarget__robots, j1.`description` AS leadOptInTarget__description, j1.`redirect` AS leadOptInTarget__redirect, j1.`jumpTo` AS leadOptInTarget__jumpTo, j1.`redirectBack` AS leadOptInTarget__redirectBack, j1.`url` AS leadOptInTarget__url, j1.`target` AS leadOptInTarget__target, j1.`dns` AS leadOptInTarget__dns, j1.`staticFiles` AS leadOptInTarget__staticFiles, j1.`staticPlugins` AS leadOptInTarget__staticPlugins, j1.`fallback` AS leadOptInTarget__fallback, j1.`disableLanguageRedirect` AS leadOptInTarget__disableLanguageRedirect, j1.`favicon` AS leadOptInTarget__favicon, j1.`robotsTxt` AS leadOptInTarget__robotsTxt, j1.`maintenanceMode` AS leadOptInTarget__maintenanceMode, j1.`mailerTransport` AS leadOptInTarget__mailerTransport, j1.`enableCanonical` AS leadOptInTarget__enableCanonical, j1.`canonicalLink` AS leadOptInTarget__canonicalLink, j1.`canonicalKeepParams` AS leadOptInTarget__canonicalKeepParams, j1.`adminEmail` AS leadOptInTarget__adminEmail, j1.`dateFormat` AS leadOptInTarget__dateFormat, j1.`timeFormat` AS leadOptInTarget__timeFormat, j1.`datimFormat` AS leadOptInTarget__datimFormat, j1.`validAliasCharacters` AS leadOptInTarget__validAliasCharacters, j1.`useFolderUrl` AS leadOptInTarget__useFolderUrl, j1.`urlPrefix` AS leadOptInTarget__urlPrefix, j1.`urlSuffix` AS leadOptInTarget__urlSuffix, j1.`useSSL` AS leadOptInTarget__useSSL, j1.`autoforward` AS leadOptInTarget__autoforward, j1.`protected` AS leadOptInTarget__protected, j1.`groups` AS leadOptInTarget__groups, j1.`includeLayout` AS leadOptInTarget__includeLayout, j1.`layout` AS leadOptInTarget__layout, j1.`subpageLayout` AS leadOptInTarget__subpageLayout, j1.`includeCache` AS leadOptInTarget__includeCache, j1.`cache` AS leadOptInTarget__cache, j1.`alwaysLoadFromCache` AS leadOptInTarget__alwaysLoadFromCache, j1.`clientCache` AS leadOptInTarget__clientCache, j1.`includeChmod` AS leadOptInTarget__includeChmod, j1.`cuser` AS leadOptInTarget__cuser, j1.`cgroup` AS leadOptInTarget__cgroup, j1.`chmod` AS leadOptInTarget__chmod, j1.`noSearch` AS leadOptInTarget__noSearch, j1.`cssClass` AS leadOptInTarget__cssClass, j1.`sitemap` AS leadOptInTarget__sitemap, j1.`hide` AS leadOptInTarget__hide, j1.`guests` AS leadOptInTarget__guests, j1.`tabindex` AS leadOptInTarget__tabindex, j1.`accesskey` AS leadOptInTarget__accesskey, j1.`published` AS leadOptInTarget__published, j1.`start` AS leadOptInTarget__start, j1.`stop` AS leadOptInTarget__stop, j1.`enforceTwoFactor` AS leadOptInTarget__enforceTwoFactor, j1.`twoFactorJumpTo` AS leadOptInTarget__twoFactorJumpTo, j1.`pct_structured_data` AS leadOptInTarget__pct_structured_data, j1.`pdftemplate` AS leadOptInTarget__pdftemplate, j1.`pdfTplSRC` AS leadOptInTarget__pdfTplSRC, j1.`pdfMargin` AS leadOptInTarget__pdfMargin, j1.`pdfIgnoreCSS` AS leadOptInTarget__pdfIgnoreCSS, j1.`pct_theme` AS leadOptInTarget__pct_theme, j1.`pct_theme_import` AS leadOptInTarget__pct_theme_import, j1.`pct_theme_cto` AS leadOptInTarget__pct_theme_cto, j1.`languageMain` AS leadOptInTarget__languageMain, j1.`languageRoot` AS leadOptInTarget__languageRoot, j1.`languageQuery` AS leadOptInTarget__languageQuery, j1.`addFontIcon` AS leadOptInTarget__addFontIcon, j1.`fontIcon` AS leadOptInTarget__fontIcon FROM tl_form LEFT JOIN tl_page j1 ON tl_form.`leadOptInTarget`=j1.id WHERE tl_form.`id`=? LIMIT 0,1
Parameters:
[
0
]
|
|
1.00 ms (1.61%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND ( tl_page.dns=? OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND id = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot = ( SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) ) ORDER BY sorting
Parameters:
[ "" "" "" "" ] |
|
0.87 ms (1.40%) |
3 |
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.inColumn=? AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1766072580) AND (tl_article.stop='' OR tl_article.stop>1766072580) ORDER BY tl_article.sorting
Parameters:
[ 2710 "main" ] |
|
0.86 ms (1.38%) |
3 |
SELECT * FROM tl_pct_themedesigner WHERE tl_pct_themedesigner.active=? AND tl_pct_themedesigner.theme=?
Parameters:
[ 1 "eclipse_default" ] |
|
0.81 ms (1.30%) |
1 |
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147) ORDER BY FIND_IN_SET(`tl_module`.`id`, '32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147')
Parameters:
[] |
|
0.76 ms (1.22%) |
1 |
SHOW FULL COLUMNS FROM tl_content
Parameters:
[] |
|
0.69 ms (1.11%) |
1 |
SELECT * FROM tl_pct_customelement_group WHERE tstamp > 0 AND pid IN(90,80,119,53,28,19,71,9,107,67,140,116,137,99,82,141,78,5,113,112,111,44,47,46,15,13,52,51,64,61,65,66,4,108,134,88,77,109,45,127,126,125,27,29,33,94,54,144,100,7,106,105,32,83,70,93,6,23,86,121,98,97,39,38,40,2,11,3,95,49,151,68,43,21,117,42,136,20,145,146,142,114,148,147,41,124,122,123)
Parameters:
[] |
|
0.67 ms (1.08%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('e20dcf6b559e11eb88f1001a4a0500bc'),UNHEX('14fa823f5e2611eab3d3001a4a050158'),UNHEX('1549302b5e2611eab3d3001a4a050158'),UNHEX('9aec39ad0e2c11ebbfd3001a4a150158'),UNHEX('159c79035e2611eab3d3001a4a050158'),UNHEX('9a490042acd211eb88f1001a4a0500bc'),UNHEX('453a1994d01511ebb7c1001a4a15061e'),UNHEX('266b1276e97811eb8089001a4a0500bc'),UNHEX('1480e8d25e2611eab3d3001a4a050158'),UNHEX('8183b4f7880a11eca992001a4a15061e'),UNHEX('71eac90d5e3911eab3d3001a4a050158'),UNHEX('fc26611617c611eda288001a4a0500bc'),UNHEX('cb141ce5a3a411edb9e6001a4a0500bc'),UNHEX('a23e65c4c4d611ed9b22001a4a0500bc')) ORDER BY tl_files.uuid!=UNHEX('e20dcf6b559e11eb88f1001a4a0500bc'), tl_files.uuid!=UNHEX('14fa823f5e2611eab3d3001a4a050158'), tl_files.uuid!=UNHEX('1549302b5e2611eab3d3001a4a050158'), tl_files.uuid!=UNHEX('9aec39ad0e2c11ebbfd3001a4a150158'), tl_files.uuid!=UNHEX('159c79035e2611eab3d3001a4a050158'), tl_files.uuid!=UNHEX('9a490042acd211eb88f1001a4a0500bc'), tl_files.uuid!=UNHEX('453a1994d01511ebb7c1001a4a15061e'), tl_files.uuid!=UNHEX('266b1276e97811eb8089001a4a0500bc'), tl_files.uuid!=UNHEX('1480e8d25e2611eab3d3001a4a050158'), tl_files.uuid!=UNHEX('8183b4f7880a11eca992001a4a15061e'), tl_files.uuid!=UNHEX('71eac90d5e3911eab3d3001a4a050158'), tl_files.uuid!=UNHEX('fc26611617c611eda288001a4a0500bc'), tl_files.uuid!=UNHEX('cb141ce5a3a411edb9e6001a4a0500bc'), tl_files.uuid!=UNHEX('a23e65c4c4d611ed9b22001a4a0500bc')
Parameters:
[
null
]
|
|
0.57 ms (0.92%) |
1 |
SHOW FULL COLUMNS FROM tl_user
Parameters:
[] |
|
0.57 ms (0.92%) |
1 |
SELECT * FROM tl_pct_customelement WHERE alias!='' AND tstamp > 0 ORDER BY title
Parameters:
[] |
|
0.54 ms (0.86%) |
3 |
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
"files/cto_layout/img/flags/gb.svg"
]
|
|
0.52 ms (0.83%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.49 ms (0.78%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('6a3360557cfd11eb8832001a4a15061e'),UNHEX('552a2eff1fbc11ee9b22001a4a0500bc'),UNHEX('5b6934801fbc11ee9b22001a4a0500bc')) ORDER BY tl_files.uuid!=UNHEX('6a3360557cfd11eb8832001a4a15061e'), tl_files.uuid!=UNHEX('552a2eff1fbc11ee9b22001a4a0500bc'), tl_files.uuid!=UNHEX('5b6934801fbc11ee9b22001a4a0500bc')
Parameters:
[
null
]
|
|
0.48 ms (0.78%) |
1 |
SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root'
Parameters:
[] |
|
0.46 ms (0.74%) |
1 |
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
30
]
|
|
0.38 ms (0.61%) |
1 |
SELECT tl_page.* FROM tl_page WHERE (tl_page.id=? OR tl_page.languageMain=?) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1766072580) AND (tl_page.stop='' OR tl_page.stop>1766072640)
Parameters:
[ 2605 2605 ] |
|
0.34 ms (0.54%) |
1 |
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
4
]
|
|
0.33 ms (0.53%) |
1 |
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
42
]
|
|
0.28 ms (0.45%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(218,219,220) ORDER BY FIND_IN_SET(`tl_page`.`id`, '218,219,220')
Parameters:
[] |
|
0.28 ms (0.44%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(221,222,223) ORDER BY FIND_IN_SET(`tl_page`.`id`, '221,222,223')
Parameters:
[] |
|
0.27 ms (0.44%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('92e02e18549511eab3d3001a4a050158'),UNHEX('f6366fa8548d11eab3d3001a4a050158')) ORDER BY tl_files.uuid!=UNHEX('92e02e18549511eab3d3001a4a050158'), tl_files.uuid!=UNHEX('f6366fa8548d11eab3d3001a4a050158')
Parameters:
[
null
]
|
|
0.27 ms (0.44%) |
1 |
SELECT * FROM tl_revolutionslider_slides WHERE pid=? AND published=? ORDER BY sorting
Parameters:
[ 4 1 ] |
|
0.26 ms (0.42%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1766072580) AND (tl_page.stop='' OR tl_page.stop>1766072580) LIMIT 0,1
Parameters:
[
233
]
|
|
0.25 ms (0.40%) |
1 |
SELECT * FROM tl_theme ORDER BY name
Parameters:
[] |
|
0.23 ms (0.37%) |
1 |
SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=? AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting
Parameters:
[
null
]
|
|
0.23 ms (0.37%) |
1 |
SELECT * FROM tl_revolutionslider WHERE tl_revolutionslider.`id`=? LIMIT 0,1
Parameters:
[
4
]
|
|
0.16 ms (0.26%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.15 ms (0.25%) |
1 |
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
5
]
|
|
0.15 ms (0.24%) |
1 |
SHOW INDEXES FROM `tl_content`
Parameters:
[] |
|
0.15 ms (0.24%) |
1 |
SHOW INDEXES FROM `tl_user`
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.