Query Metrics
25
Database Queries
20
Different statements
45.88 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.04 ms |
SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns=? OR tl_page.dns=''))
Parameters:
[
"www.teilehandel-stadler.at"
]
|
| 2 | 1.24 ms |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[ "index" "/" ] |
| 3 | 1.29 ms |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
| 4 | 15.81 ms |
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
1
]
|
| 5 | 0.41 ms |
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
1
]
|
| 6 | 1.29 ms |
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:
[] |
| 7 | 0.81 ms |
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<=1763723700) AND (tl_article.stop='' OR tl_article.stop>1763723700) ORDER BY tl_article.sorting
Parameters:
[ 2 "main" ] |
| 8 | 1.03 ms |
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<=1763723700) AND (tl_content.stop='' OR tl_content.stop>1763723700) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 1 "tl_article" ] |
| 9 | 0.97 ms |
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
"67fe5500f80811e9a58c36b6881f99ac"
]
|
| 10 | 0.63 ms |
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
"9"
]
|
| 11 | 0.69 ms |
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:
[
9
]
|
| 12 | 0.39 ms |
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
]
|
| 13 | 0.64 ms |
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:
[] |
| 14 | 0.06 ms |
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
]
|
| 15 | 0.64 ms |
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:
[] |
| 16 | 3.55 ms |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
"6"
]
|
| 17 | 1.29 ms |
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"
]
|
| 18 | 1.07 ms |
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<=1763723700) AND (p2.stop='' OR p2.stop>1763723700)) 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<=1763723700) AND (p1.stop='' OR p1.stop>1763723700) ORDER BY p1.sorting
Parameters:
[
1
]
|
| 19 | 0.64 ms |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(3,4,5,13) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2,3,4,5,13,6')
Parameters:
[] |
| 20 | 2.14 ms |
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
"16"
]
|
| 21 | 0.06 ms |
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
]
|
| 22 | 4.39 ms |
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:
[] |
| 23 | 0.90 ms |
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
"8"
]
|
| 24 | 1.26 ms |
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
]
|
| 25 | 1.63 ms |
SELECT tl_article.* FROM tl_article WHERE tl_article.`id`=?
Parameters:
[
11
]
|
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.