Query Metrics

25 Database Queries
20 Different statements
37.10 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.23 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 0.82 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[
  "index"
  "/"
]
3 0.62 ms
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
4 2.24 ms
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
  1
]
5 0.49 ms
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
  1
]
6 3.95 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 1.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<=1763717340) AND (tl_article.stop='' OR tl_article.stop>1763717340) ORDER BY tl_article.sorting
Parameters:
[
  2
  "main"
]
8 7.06 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<=1763717340) AND (tl_content.stop='' OR tl_content.stop>1763717340) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  1
  "tl_article"
]
9 2.09 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "67fe5500f80811e9a58c36b6881f99ac"
]
10 1.68 ms
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
  "9"
]
11 1.58 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 1.23 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 1.53 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.07 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 0.58 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "6"
]
17 1.26 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.03 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<=1763717340) AND (p2.stop='' OR p2.stop>1763717340)) 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<=1763717340) AND (p1.stop='' OR p1.stop>1763717340) ORDER BY p1.sorting
Parameters:
[
  1
]
19 0.65 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 0.79 ms
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
  "16"
]
21 0.15 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 1.04 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.50 ms
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
  "8"
]
24 0.50 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 0.55 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.