Query Metrics

25 Database Queries
21 Different statements
52.92 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.10 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
Parameters:
[
  "wp-includes/IXR/"
  "wp-includes/IXR"
  "wp-includes"
]
2 0.75 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`type`=?
Parameters:
[
  "error_404"
]
3 0.57 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  1
]
4 3.93 ms
SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root'
Parameters:
[]
5 2.24 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
Parameters:
[
  "wp-includes/IXR/"
  "wp-includes/IXR"
  "wp-includes"
]
6 0.91 ms
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
7 3.77 ms
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
  1
]
8 3.87 ms
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
  1
]
9 2.90 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:
[]
10 3.34 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<=1763722560) AND (tl_article.stop='' OR tl_article.stop>1763722560) ORDER BY tl_article.sorting
Parameters:
[
  11
  "main"
]
11 3.90 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<=1763722560) AND (tl_content.stop='' OR tl_content.stop>1763722560) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  10
  "tl_article"
]
12 0.71 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.81 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.05 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 2.10 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.84 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "6"
]
17 3.94 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 2.61 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<=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
]
19 0.86 ms
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:
[]
20 0.84 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 0.85 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 4.40 ms
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
  "8"
]
24 5.16 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.40 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.