GET https://staging.physiotherapiebabelsberg.de/sitemap.xml

Query Metrics

104 Database Queries
22 Different statements
51.38 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
2 0.50 ms
SELECT t0_.id AS id_0, t0_.tstamp AS tstamp_1, t0_.alias AS alias_2, t0_.name AS name_3, t0_.target AS target_4, t0_.published AS published_5, t0_.dateAdded AS dateAdded_6 FROM tl_terminal42_shortlink t0_ WHERE (LOWER(t0_.alias) = ? OR (t0_.alias = '' AND t0_.id = ?)) AND t0_.published = '1'
Parameters:
[
  ""
  0
]
3 1.01 ms
SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns=? OR tl_page.dns=''))
Parameters:
[
  "staging.physiotherapiebabelsberg.de"
]
4 0.11 ms
SELECT DATABASE()
Parameters:
[]
5 19.94 ms
SELECT c.TABLE_NAME,       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION
Parameters:
[
  "db_physbabe_de"
  "db_physbabe_de"
]
6 2.00 ms
SELECT TABLE_NAME,        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "db_physbabe_de"
]
7 0.68 ms
SELECT DISTINCT k.TABLE_NAME,            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "db_physbabe_de"
]
8 2.77 ms
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "db_physbabe_de"
]
9 0.14 ms
SELECT DATABASE()
Parameters:
[]
10 0.49 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[
  "index"
  "/"
]
11 0.38 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.hofff_root_page_id
  WHERE	p.id = ?
Parameters:
[
  1
]
12 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:
[
  2
]
13 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published=1 AND (tl_page.start='' OR tl_page.start<=1786894260) AND (tl_page.stop='' OR tl_page.stop>1786894260) LIMIT 0,1
Parameters:
[
  1
]
14 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<=1786894260) AND (tl_page.stop='' OR tl_page.stop>1786894260)
Parameters:
[
  "staging.physiotherapiebabelsberg.de"
]
15 0.38 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  1
]
16 0.35 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  2
]
17 0.28 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  2
]
18 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:
[
  3
]
19 0.27 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  3
]
20 0.28 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  3
]
21 0.22 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:
[
  31
]
22 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  31
]
23 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:
[
  28
]
24 0.26 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  28
]
25 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  28
]
26 0.20 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:
[
  45
]
27 0.25 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  45
]
28 0.28 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  45
]
29 0.23 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:
[
  4
]
30 0.37 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  4
]
31 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:
[
  9
]
32 0.26 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  9
]
33 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  9
]
34 0.20 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:
[
  10
]
35 0.25 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  10
]
36 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  10
]
37 0.19 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:
[
  34
]
38 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  34
]
39 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:
[
  24
]
40 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  24
]
41 0.39 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  24
]
42 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:
[
  35
]
43 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  35
]
44 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:
[
  36
]
45 0.26 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  36
]
46 0.20 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:
[
  37
]
47 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  37
]
48 0.20 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:
[
  38
]
49 0.30 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  38
]
50 0.23 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:
[
  39
]
51 0.30 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  39
]
52 0.20 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:
[
  40
]
53 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  40
]
54 0.19 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:
[
  41
]
55 0.26 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  41
]
56 0.20 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:
[
  42
]
57 0.25 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  42
]
58 0.19 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:
[
  43
]
59 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  43
]
60 0.19 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:
[
  44
]
61 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  44
]
62 0.20 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:
[
  27
]
63 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  27
]
64 0.27 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  27
]
65 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:
[
  6
]
66 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  6
]
67 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  6
]
68 0.20 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:
[
  21
]
69 0.34 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<=1786894260) AND (tl_article.stop='' OR tl_article.stop>1786894260) ORDER BY tl_article.sorting
Parameters:
[
  21
]
70 0.22 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  21
]
71 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:
[
  8
]
72 0.23 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  8
]
73 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:
[
  7
]
74 0.14 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:
[
  8
]
75 0.22 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  7
]
76 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:
[
  25
]
77 0.13 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:
[
  8
]
78 0.20 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  25
]
79 0.14 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:
[
  16
]
80 0.32 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  16
]
81 0.19 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:
[
  17
]
82 0.13 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:
[
  16
]
83 0.23 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  17
]
84 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:
[
  18
]
85 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:
[
  16
]
86 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  18
]
87 0.14 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:
[
  19
]
88 0.13 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:
[
  16
]
89 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  19
]
90 0.13 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:
[
  14
]
91 0.26 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  14
]
92 0.18 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:
[
  15
]
93 0.13 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:
[
  14
]
94 0.20 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  15
]
95 0.81 ms
SHOW FULL COLUMNS FROM tl_page
Parameters:
[]
96 0.20 ms
SHOW INDEXES FROM `tl_page`
Parameters:
[]
97 0.22 ms
SELECT id, pid FROM tl_page WHERE pid IN(1)
Parameters:
[]
98 0.21 ms
SELECT id, pid FROM tl_page WHERE pid IN(8,14,16,4,31,2,3,6,24,28)
Parameters:
[]
99 0.22 ms
SELECT id, pid FROM tl_page WHERE pid IN(34,9,10,21,7,25,15,18,19,17,35,36,37,38,39,40,41,42,43,44,27,45)
Parameters:
[]
100 0.74 ms
SELECT tl_recommendation_archive.*, j1.`id` AS jumpTo__id, j1.`pid` AS jumpTo__pid, j1.`sorting` AS jumpTo__sorting, j1.`tstamp` AS jumpTo__tstamp, j1.`title` AS jumpTo__title, j1.`type` AS jumpTo__type, j1.`alias` AS jumpTo__alias, j1.`requireItem` AS jumpTo__requireItem, j1.`routePriority` AS jumpTo__routePriority, j1.`pageTitle` AS jumpTo__pageTitle, j1.`language` AS jumpTo__language, j1.`robots` AS jumpTo__robots, j1.`description` AS jumpTo__description, j1.`redirect` AS jumpTo__redirect, j1.`alwaysForward` AS jumpTo__alwaysForward, j1.`jumpTo` AS jumpTo__jumpTo, j1.`redirectBack` AS jumpTo__redirectBack, j1.`url` AS jumpTo__url, j1.`target` AS jumpTo__target, j1.`dns` AS jumpTo__dns, j1.`staticFiles` AS jumpTo__staticFiles, j1.`staticPlugins` AS jumpTo__staticPlugins, j1.`fallback` AS jumpTo__fallback, j1.`disableLanguageRedirect` AS jumpTo__disableLanguageRedirect, j1.`favicon` AS jumpTo__favicon, j1.`robotsTxt` AS jumpTo__robotsTxt, j1.`maintenanceMode` AS jumpTo__maintenanceMode, j1.`mailerTransport` AS jumpTo__mailerTransport, j1.`enableCanonical` AS jumpTo__enableCanonical, j1.`canonicalLink` AS jumpTo__canonicalLink, j1.`canonicalKeepParams` AS jumpTo__canonicalKeepParams, j1.`adminEmail` AS jumpTo__adminEmail, j1.`dateFormat` AS jumpTo__dateFormat, j1.`timeFormat` AS jumpTo__timeFormat, j1.`datimFormat` AS jumpTo__datimFormat, j1.`validAliasCharacters` AS jumpTo__validAliasCharacters, j1.`useFolderUrl` AS jumpTo__useFolderUrl, j1.`urlPrefix` AS jumpTo__urlPrefix, j1.`urlSuffix` AS jumpTo__urlSuffix, j1.`useSSL` AS jumpTo__useSSL, j1.`autoforward` AS jumpTo__autoforward, j1.`protected` AS jumpTo__protected, j1.`groups` AS jumpTo__groups, j1.`includeLayout` AS jumpTo__includeLayout, j1.`layout` AS jumpTo__layout, j1.`subpageLayout` AS jumpTo__subpageLayout, j1.`includeCache` AS jumpTo__includeCache, j1.`cache` AS jumpTo__cache, j1.`alwaysLoadFromCache` AS jumpTo__alwaysLoadFromCache, j1.`clientCache` AS jumpTo__clientCache, j1.`includeChmod` AS jumpTo__includeChmod, j1.`cuser` AS jumpTo__cuser, j1.`cgroup` AS jumpTo__cgroup, j1.`chmod` AS jumpTo__chmod, j1.`noSearch` AS jumpTo__noSearch, j1.`cssClass` AS jumpTo__cssClass, j1.`sitemap` AS jumpTo__sitemap, j1.`hide` AS jumpTo__hide, j1.`guests` AS jumpTo__guests, j1.`accesskey` AS jumpTo__accesskey, j1.`published` AS jumpTo__published, j1.`start` AS jumpTo__start, j1.`stop` AS jumpTo__stop, j1.`enforceTwoFactor` AS jumpTo__enforceTwoFactor, j1.`twoFactorJumpTo` AS jumpTo__twoFactorJumpTo, j1.`enableCsp` AS jumpTo__enableCsp, j1.`csp` AS jumpTo__csp, j1.`cspReportOnly` AS jumpTo__cspReportOnly, j1.`cspReportLog` AS jumpTo__cspReportLog, j1.`hofff_root_page_id` AS jumpTo__hofff_root_page_id, j1.`hofff_consent_bridge_consent_tool` AS jumpTo__hofff_consent_bridge_consent_tool, j1.`bbit_turl_defaultInherit` AS jumpTo__bbit_turl_defaultInherit, j1.`bbit_turl_inherit` AS jumpTo__bbit_turl_inherit, j1.`bbit_turl_transparent` AS jumpTo__bbit_turl_transparent, j1.`bbit_turl_ignoreRoot` AS jumpTo__bbit_turl_ignoreRoot, j1.`bbit_turl_fragment` AS jumpTo__bbit_turl_fragment, j1.`bbit_turl_rootInherit` AS jumpTo__bbit_turl_rootInherit, j1.`newsArchives` AS jumpTo__newsArchives, j1.`feedFormat` AS jumpTo__feedFormat, j1.`feedSource` AS jumpTo__feedSource, j1.`maxFeedItems` AS jumpTo__maxFeedItems, j1.`feedFeatured` AS jumpTo__feedFeatured, j1.`feedDescription` AS jumpTo__feedDescription, j1.`imgSize` AS jumpTo__imgSize, j1.`hofff_consent_disable` AS jumpTo__hofff_consent_disable, j1.`hofff_consent_tag` AS jumpTo__hofff_consent_tag, j1.`hofff_consent_privacyPage` AS jumpTo__hofff_consent_privacyPage, j1.`hofff_consent_jumpTo` AS jumpTo__hofff_consent_jumpTo, j1.`hofff_consent_module` AS jumpTo__hofff_consent_module, j1.`hofff_consent_bannerTemplate` AS jumpTo__hofff_consent_bannerTemplate, j1.`styleManager` AS jumpTo__styleManager, j1.`hofff_st` AS jumpTo__hofff_st, j1.`hofff_st_og_type` AS jumpTo__hofff_st_og_type, j1.`hofff_st_og_title` AS jumpTo__hofff_st_og_title, j1.`hofff_st_og_site` AS jumpTo__hofff_st_og_site, j1.`hofff_st_og_url` AS jumpTo__hofff_st_og_url, j1.`hofff_st_og_image` AS jumpTo__hofff_st_og_image, j1.`hofff_st_og_description` AS jumpTo__hofff_st_og_description, j1.`hofff_st_twitter_type` AS jumpTo__hofff_st_twitter_type, j1.`hofff_st_twitter_title` AS jumpTo__hofff_st_twitter_title, j1.`hofff_st_twitter_description` AS jumpTo__hofff_st_twitter_description, j1.`hofff_st_twitter_site` AS jumpTo__hofff_st_twitter_site, j1.`hofff_st_twitter_creator` AS jumpTo__hofff_st_twitter_creator, j1.`hofff_st_twitter_image` AS jumpTo__hofff_st_twitter_image FROM tl_recommendation_archive LEFT JOIN tl_page j1 ON tl_recommendation_archive.`jumpTo`=j1.id WHERE tl_recommendation_archive.`protected`=?
Parameters:
[
  ""
]
101 0.20 ms
SELECT id, pid FROM tl_page WHERE pid IN(1)
Parameters:
[]
102 0.19 ms
SELECT id, pid FROM tl_page WHERE pid IN(8,14,16,4,31,2,3,6,24,28)
Parameters:
[]
103 0.18 ms
SELECT id, pid FROM tl_page WHERE pid IN(34,9,10,21,7,25,15,18,19,17,35,36,37,38,39,40,41,42,43,44,27,45)
Parameters:
[]
104 0.82 ms
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.`protected`=?
Parameters:
[
  ""
]

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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
Terminal42\ShortlinkBundle\Entity\Shortlink No errors.