https://staging.naumann-bueroausstattung.de/sitemap.xml

Query Metrics

46 Database Queries
11 Different statements
9.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.58 ms
SELECT templates FROM tl_theme
Parameters:
[]
2 0.52 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.dns=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1776425520') AND (tl_page.stop='' OR tl_page.stop>'1776425520')
Parameters:
[
  -1 => "staging.naumann-bueroausstattung.de"
]
3 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.dns=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1776425520') AND (tl_page.stop='' OR tl_page.stop>'1776425520')
Parameters:
[
  -1 => ""
]
4 0.31 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 1
]
5 0.20 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 2
]
6 0.15 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 2
]
7 0.17 ms
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
FROM	tl_page AS p1
JOIN	tl_page AS p2 ON p2.id = p1.pid
WHERE	p1.id = ?
AND		p2.type != 'root'
Parameters:
[
  -1 => 2
]
8 0.30 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.showTeaser=1 AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1776425520') AND (tl_article.stop='' OR tl_article.stop>'1776425520') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 2
]
9 0.24 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 2
]
10 0.23 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 3
]
11 0.12 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 3
]
12 0.12 ms
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
FROM	tl_page AS p1
JOIN	tl_page AS p2 ON p2.id = p1.pid
WHERE	p1.id = ?
AND		p2.type != 'root'
Parameters:
[
  -1 => 3
]
13 0.21 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.showTeaser=1 AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1776425520') AND (tl_article.stop='' OR tl_article.stop>'1776425520') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 3
]
14 0.19 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 3
]
15 0.13 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 4
]
16 0.12 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 4
]
17 0.12 ms
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
FROM	tl_page AS p1
JOIN	tl_page AS p2 ON p2.id = p1.pid
WHERE	p1.id = ?
AND		p2.type != 'root'
Parameters:
[
  -1 => 4
]
18 0.20 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.showTeaser=1 AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1776425520') AND (tl_article.stop='' OR tl_article.stop>'1776425520') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 4
]
19 0.19 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 4
]
20 0.13 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 5
]
21 0.11 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 5
]
22 0.12 ms
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
FROM	tl_page AS p1
JOIN	tl_page AS p2 ON p2.id = p1.pid
WHERE	p1.id = ?
AND		p2.type != 'root'
Parameters:
[
  -1 => 5
]
23 0.22 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.showTeaser=1 AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1776425520') AND (tl_article.stop='' OR tl_article.stop>'1776425520') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 5
]
24 0.20 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 5
]
25 0.18 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 16
]
26 0.13 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 6
]
27 0.13 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 6
]
28 0.12 ms
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
FROM	tl_page AS p1
JOIN	tl_page AS p2 ON p2.id = p1.pid
WHERE	p1.id = ?
AND		p2.type != 'root'
Parameters:
[
  -1 => 6
]
29 0.19 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pid=? AND tl_article.showTeaser=1 AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1776425520') AND (tl_article.stop='' OR tl_article.stop>'1776425520') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 6
]
30 0.19 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 6
]
31 0.22 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 9
]
32 0.18 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 13
]
33 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 14
]
34 0.18 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 15
]
35 0.20 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 10
]
36 0.19 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 11
]
37 0.17 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 12
]
38 0.19 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 7
]
39 0.20 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 8
]
40 0.14 ms
SELECT id, pid FROM tl_page WHERE pid IN(1)
Parameters:
[]
41 0.14 ms
SELECT id, pid FROM tl_page WHERE pid IN(7,9,10,2,3,4,5,6)
Parameters:
[]
42 0.13 ms
SELECT id, pid FROM tl_page WHERE pid IN(16,8,15,13,14,11,12)
Parameters:
[]
43 0.15 ms
SELECT tl_faq_category.* FROM tl_faq_category
Parameters:
[]
44 0.15 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 16
]
45 0.12 ms
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
FROM	tl_page AS p
JOIN	tl_page AS rt ON rt.id = p.bbit_turl_root
WHERE	p.id = ?
Parameters:
[
  -1 => 16
]
46 0.25 ms
SELECT tl_faq.* FROM tl_faq WHERE tl_faq.pid=? AND tl_faq.published='1' ORDER BY tl_faq.sorting
Parameters:
[
  -1 => 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

Class Mapping errors
Contao\CoreBundle\Entity\RememberMe No errors.