Query Metrics
25
Database Queries
21
Different statements
52.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.16 ms (9.76%) |
1 |
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' AND tl_image_size_item.tstamp > 0 ORDER BY sorting ASC
Parameters:
[
8
]
|
|
4.40 ms (8.32%) |
1 |
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
"8"
]
|
|
3.94 ms (7.45%) |
1 |
SELECT tl_module.*, j1.`id` AS bs_search_searchpage__id, j1.`pid` AS bs_search_searchpage__pid, j1.`sorting` AS bs_search_searchpage__sorting, j1.`tstamp` AS bs_search_searchpage__tstamp, j1.`title` AS bs_search_searchpage__title, j1.`type` AS bs_search_searchpage__type, j1.`alias` AS bs_search_searchpage__alias, j1.`requireItem` AS bs_search_searchpage__requireItem, j1.`routePriority` AS bs_search_searchpage__routePriority, j1.`pageTitle` AS bs_search_searchpage__pageTitle, j1.`language` AS bs_search_searchpage__language, j1.`robots` AS bs_search_searchpage__robots, j1.`description` AS bs_search_searchpage__description, j1.`redirect` AS bs_search_searchpage__redirect, j1.`alwaysForward` AS bs_search_searchpage__alwaysForward, j1.`jumpTo` AS bs_search_searchpage__jumpTo, j1.`redirectBack` AS bs_search_searchpage__redirectBack, j1.`url` AS bs_search_searchpage__url, j1.`target` AS bs_search_searchpage__target, j1.`dns` AS bs_search_searchpage__dns, j1.`staticFiles` AS bs_search_searchpage__staticFiles, j1.`staticPlugins` AS bs_search_searchpage__staticPlugins, j1.`fallback` AS bs_search_searchpage__fallback, j1.`disableLanguageRedirect` AS bs_search_searchpage__disableLanguageRedirect, j1.`favicon` AS bs_search_searchpage__favicon, j1.`robotsTxt` AS bs_search_searchpage__robotsTxt, j1.`maintenanceMode` AS bs_search_searchpage__maintenanceMode, j1.`mailerTransport` AS bs_search_searchpage__mailerTransport, j1.`enableCanonical` AS bs_search_searchpage__enableCanonical, j1.`canonicalLink` AS bs_search_searchpage__canonicalLink, j1.`canonicalKeepParams` AS bs_search_searchpage__canonicalKeepParams, j1.`adminEmail` AS bs_search_searchpage__adminEmail, j1.`dateFormat` AS bs_search_searchpage__dateFormat, j1.`timeFormat` AS bs_search_searchpage__timeFormat, j1.`datimFormat` AS bs_search_searchpage__datimFormat, j1.`validAliasCharacters` AS bs_search_searchpage__validAliasCharacters, j1.`useFolderUrl` AS bs_search_searchpage__useFolderUrl, j1.`urlPrefix` AS bs_search_searchpage__urlPrefix, j1.`urlSuffix` AS bs_search_searchpage__urlSuffix, j1.`useSSL` AS bs_search_searchpage__useSSL, j1.`autoforward` AS bs_search_searchpage__autoforward, j1.`protected` AS bs_search_searchpage__protected, j1.`groups` AS bs_search_searchpage__groups, j1.`includeLayout` AS bs_search_searchpage__includeLayout, j1.`layout` AS bs_search_searchpage__layout, j1.`subpageLayout` AS bs_search_searchpage__subpageLayout, j1.`includeCache` AS bs_search_searchpage__includeCache, j1.`cache` AS bs_search_searchpage__cache, j1.`alwaysLoadFromCache` AS bs_search_searchpage__alwaysLoadFromCache, j1.`clientCache` AS bs_search_searchpage__clientCache, j1.`includeChmod` AS bs_search_searchpage__includeChmod, j1.`cuser` AS bs_search_searchpage__cuser, j1.`cgroup` AS bs_search_searchpage__cgroup, j1.`chmod` AS bs_search_searchpage__chmod, j1.`noSearch` AS bs_search_searchpage__noSearch, j1.`cssClass` AS bs_search_searchpage__cssClass, j1.`sitemap` AS bs_search_searchpage__sitemap, j1.`hide` AS bs_search_searchpage__hide, j1.`guests` AS bs_search_searchpage__guests, j1.`tabindex` AS bs_search_searchpage__tabindex, j1.`accesskey` AS bs_search_searchpage__accesskey, j1.`published` AS bs_search_searchpage__published, j1.`start` AS bs_search_searchpage__start, j1.`stop` AS bs_search_searchpage__stop, j1.`enforceTwoFactor` AS bs_search_searchpage__enforceTwoFactor, j1.`twoFactorJumpTo` AS bs_search_searchpage__twoFactorJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.`bs_search_searchpage`=j1.id WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
"1"
]
|
|
3.93 ms (7.42%) |
1 |
SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root'
Parameters:
[] |
|
3.90 ms (7.38%) |
1 |
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<=1763722560) AND (tl_content.stop='' OR tl_content.stop>1763722560) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 10 "tl_article" ] |
|
3.87 ms (7.32%) |
1 |
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
1
]
|
|
3.77 ms (7.12%) |
1 |
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
1
]
|
|
3.34 ms (6.32%) |
1 |
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<=1763722560) AND (tl_article.stop='' OR tl_article.stop>1763722560) ORDER BY tl_article.sorting
Parameters:
[ 11 "main" ] |
|
3.34 ms (6.32%) |
2 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
Parameters:
[ "wp-includes/IXR/" "wp-includes/IXR" "wp-includes" ] |
|
2.90 ms (5.48%) |
1 |
SELECT tl_module.*, j1.`id` AS bs_search_searchpage__id, j1.`pid` AS bs_search_searchpage__pid, j1.`sorting` AS bs_search_searchpage__sorting, j1.`tstamp` AS bs_search_searchpage__tstamp, j1.`title` AS bs_search_searchpage__title, j1.`type` AS bs_search_searchpage__type, j1.`alias` AS bs_search_searchpage__alias, j1.`requireItem` AS bs_search_searchpage__requireItem, j1.`routePriority` AS bs_search_searchpage__routePriority, j1.`pageTitle` AS bs_search_searchpage__pageTitle, j1.`language` AS bs_search_searchpage__language, j1.`robots` AS bs_search_searchpage__robots, j1.`description` AS bs_search_searchpage__description, j1.`redirect` AS bs_search_searchpage__redirect, j1.`alwaysForward` AS bs_search_searchpage__alwaysForward, j1.`jumpTo` AS bs_search_searchpage__jumpTo, j1.`redirectBack` AS bs_search_searchpage__redirectBack, j1.`url` AS bs_search_searchpage__url, j1.`target` AS bs_search_searchpage__target, j1.`dns` AS bs_search_searchpage__dns, j1.`staticFiles` AS bs_search_searchpage__staticFiles, j1.`staticPlugins` AS bs_search_searchpage__staticPlugins, j1.`fallback` AS bs_search_searchpage__fallback, j1.`disableLanguageRedirect` AS bs_search_searchpage__disableLanguageRedirect, j1.`favicon` AS bs_search_searchpage__favicon, j1.`robotsTxt` AS bs_search_searchpage__robotsTxt, j1.`maintenanceMode` AS bs_search_searchpage__maintenanceMode, j1.`mailerTransport` AS bs_search_searchpage__mailerTransport, j1.`enableCanonical` AS bs_search_searchpage__enableCanonical, j1.`canonicalLink` AS bs_search_searchpage__canonicalLink, j1.`canonicalKeepParams` AS bs_search_searchpage__canonicalKeepParams, j1.`adminEmail` AS bs_search_searchpage__adminEmail, j1.`dateFormat` AS bs_search_searchpage__dateFormat, j1.`timeFormat` AS bs_search_searchpage__timeFormat, j1.`datimFormat` AS bs_search_searchpage__datimFormat, j1.`validAliasCharacters` AS bs_search_searchpage__validAliasCharacters, j1.`useFolderUrl` AS bs_search_searchpage__useFolderUrl, j1.`urlPrefix` AS bs_search_searchpage__urlPrefix, j1.`urlSuffix` AS bs_search_searchpage__urlSuffix, j1.`useSSL` AS bs_search_searchpage__useSSL, j1.`autoforward` AS bs_search_searchpage__autoforward, j1.`protected` AS bs_search_searchpage__protected, j1.`groups` AS bs_search_searchpage__groups, j1.`includeLayout` AS bs_search_searchpage__includeLayout, j1.`layout` AS bs_search_searchpage__layout, j1.`subpageLayout` AS bs_search_searchpage__subpageLayout, j1.`includeCache` AS bs_search_searchpage__includeCache, j1.`cache` AS bs_search_searchpage__cache, j1.`alwaysLoadFromCache` AS bs_search_searchpage__alwaysLoadFromCache, j1.`clientCache` AS bs_search_searchpage__clientCache, j1.`includeChmod` AS bs_search_searchpage__includeChmod, j1.`cuser` AS bs_search_searchpage__cuser, j1.`cgroup` AS bs_search_searchpage__cgroup, j1.`chmod` AS bs_search_searchpage__chmod, j1.`noSearch` AS bs_search_searchpage__noSearch, j1.`cssClass` AS bs_search_searchpage__cssClass, j1.`sitemap` AS bs_search_searchpage__sitemap, j1.`hide` AS bs_search_searchpage__hide, j1.`guests` AS bs_search_searchpage__guests, j1.`tabindex` AS bs_search_searchpage__tabindex, j1.`accesskey` AS bs_search_searchpage__accesskey, j1.`published` AS bs_search_searchpage__published, j1.`start` AS bs_search_searchpage__start, j1.`stop` AS bs_search_searchpage__stop, j1.`enforceTwoFactor` AS bs_search_searchpage__enforceTwoFactor, j1.`twoFactorJumpTo` AS bs_search_searchpage__twoFactorJumpTo FROM tl_module LEFT JOIN tl_page j1 ON tl_module.`bs_search_searchpage`=j1.id WHERE tl_module.id IN(2,0,4,3) ORDER BY FIND_IN_SET(`tl_module`.`id`, '2,0,4,3')
Parameters:
[] |
|
2.61 ms (4.93%) |
1 |
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<=1763722560) AND (p2.stop='' OR p2.stop>1763722560)) 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<=1763722560) AND (p1.stop='' OR p1.stop>1763722560) ORDER BY p1.sorting
Parameters:
[
1
]
|
|
2.52 ms (4.75%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1f05e197f75c11e9a58c36b6881f99ac'),UNHEX('ed378fd2fd5211e9a58c36b6881f99ac'),UNHEX('ee080405fd5311e9a58c36b6881f99ac')) ORDER BY tl_files.uuid!=UNHEX('1f05e197f75c11e9a58c36b6881f99ac'), tl_files.uuid!=UNHEX('ed378fd2fd5211e9a58c36b6881f99ac'), tl_files.uuid!=UNHEX('ee080405fd5311e9a58c36b6881f99ac')
Parameters:
[
null
]
|
|
2.15 ms (4.06%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1f091a0df75c11e9a58c36b6881f99ac'),UNHEX('670cb9bbfbae11e9a58c36b6881f99ac'),UNHEX('e038c752fd5211e9a58c36b6881f99ac'),UNHEX('e038c4ccfd5211e9a58c36b6881f99ac'),UNHEX('f8cfec0af7dd11e9a58c36b6881f99ac')) ORDER BY tl_files.uuid!=UNHEX('1f091a0df75c11e9a58c36b6881f99ac'), tl_files.uuid!=UNHEX('670cb9bbfbae11e9a58c36b6881f99ac'), tl_files.uuid!=UNHEX('e038c752fd5211e9a58c36b6881f99ac'), tl_files.uuid!=UNHEX('e038c4ccfd5211e9a58c36b6881f99ac'), tl_files.uuid!=UNHEX('f8cfec0af7dd11e9a58c36b6881f99ac')
Parameters:
[
null
]
|
|
1.40 ms (2.65%) |
1 |
SELECT tl_article.* FROM tl_article WHERE tl_article.`id`=?
Parameters:
[
11
]
|
|
0.92 ms (1.73%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('91cc0c416f5611eaa58c36b6881f99ac'),UNHEX('518e05296f5711eaa58c36b6881f99ac'),UNHEX('dfd49bbf6f5611eaa58c36b6881f99ac'),UNHEX('ee3b35626f5611eaa58c36b6881f99ac'),UNHEX('e388e0fc6f5611eaa58c36b6881f99ac')) ORDER BY tl_files.uuid!=UNHEX('91cc0c416f5611eaa58c36b6881f99ac'), tl_files.uuid!=UNHEX('518e05296f5711eaa58c36b6881f99ac'), tl_files.uuid!=UNHEX('dfd49bbf6f5611eaa58c36b6881f99ac'), tl_files.uuid!=UNHEX('ee3b35626f5611eaa58c36b6881f99ac'), tl_files.uuid!=UNHEX('e388e0fc6f5611eaa58c36b6881f99ac')
Parameters:
[
null
]
|
|
0.91 ms (1.72%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.86 ms (1.62%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(2,3,4,5,13) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2,3,4,5,13,6')
Parameters:
[] |
|
0.84 ms (1.60%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
"6"
]
|
|
0.84 ms (1.59%) |
1 |
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
"16"
]
|
|
0.75 ms (1.41%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`type`=?
Parameters:
[
"error_404"
]
|
|
0.57 ms (1.07%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
1
]
|
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.