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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.62 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<='1776432360') AND (tl_page.stop='' OR tl_page.stop>'1776432360')
Parameters:
[
  -1 => "staging.naumann-bueroausstattung.de"
]
3 0.34 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<='1776432360') AND (tl_page.stop='' OR tl_page.stop>'1776432360')
Parameters:
[
  -1 => ""
]
4 0.36 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 1
]
5 0.24 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.17 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.21 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.40 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<='1776432360') AND (tl_article.stop='' OR tl_article.stop>'1776432360') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 2
]
9 0.23 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 2
]
10 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 => 3
]
11 0.16 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.16 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.23 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<='1776432360') AND (tl_article.stop='' OR tl_article.stop>'1776432360') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 3
]
14 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 3
]
15 0.17 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.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 => 4
]
17 0.15 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.23 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<='1776432360') AND (tl_article.stop='' OR tl_article.stop>'1776432360') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 4
]
19 0.22 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 4
]
20 0.16 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.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 => 5
]
22 0.15 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.24 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<='1776432360') AND (tl_article.stop='' OR tl_article.stop>'1776432360') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 5
]
24 0.26 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 5
]
25 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 16
]
26 0.16 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.16 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.15 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.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<='1776432360') AND (tl_article.stop='' OR tl_article.stop>'1776432360') ORDER BY tl_article.sorting
Parameters:
[
  -1 => 6
]
30 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 6
]
31 0.25 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 9
]
32 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 13
]
33 0.23 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 14
]
34 0.22 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 15
]
35 0.23 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 10
]
36 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 11
]
37 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 12
]
38 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 7
]
39 0.26 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  -1 => 8
]
40 0.16 ms
SELECT id, pid FROM tl_page WHERE pid IN(1)
Parameters:
[]
41 0.15 ms
SELECT id, pid FROM tl_page WHERE pid IN(7,9,10,2,3,4,5,6)
Parameters:
[]
42 0.15 ms
SELECT id, pid FROM tl_page WHERE pid IN(16,8,15,13,14,11,12)
Parameters:
[]
43 0.18 ms
SELECT tl_faq_category.* FROM tl_faq_category
Parameters:
[]
44 0.17 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.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 => 16
]
46 0.35 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.