Query Metrics
46
Database Queries
11
Different statements
10.44 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |