https://www.pano.pdir.dev/dresden/umgebung/

Method
GET
HTTP Status
200
IP
40.77.167.12
Profiled on
Token
e2115d

Query Metrics

119 Database Queries
49 Different statements
99.24 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.02 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?)
Parameters: 
[
  "dresden/umgebung"
  "dresden"
]
View formatted query    View runnable query    Explain query
2 0.51 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters: 
[
  90
]
View formatted query    View runnable query    Explain query
3 0.13 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?)
Parameters: 
[
  "dresden/umgebung"
  "dresden"
]
View formatted query    View runnable query    Explain query
4 0.12 ms 
SELECT templates FROM tl_theme WHERE templates != ''
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 0.33 ms 
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters: 
[
  50
]
View formatted query    View runnable query    Explain query
6 0.35 ms 
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
7 0.78 ms 
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(358,314,330,365,0,0,0,271) ORDER BY FIND_IN_SET(`tl_module`.`id`, '358,314,330,365,0,0,0,271')
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 1.04 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  90
]
View formatted query    View runnable query    Explain query
9 0.44 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(161,162,163,164,179) ORDER BY FIND_IN_SET(`tl_page`.`id`, '161,162,163,164,165,179')
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 0.65 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  161
]
View formatted query    View runnable query    Explain query
11 0.38 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(384,166,208,167) ORDER BY FIND_IN_SET(`tl_page`.`id`, '384,166,208,167')
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 0.68 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  162
]
View formatted query    View runnable query    Explain query
13 0.37 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(170,169,326,328,330,331,332,181,333) ORDER BY FIND_IN_SET(`tl_page`.`id`, '170,169,326,328,330,331,332,181,333')
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 0.87 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  169
]
View formatted query    View runnable query    Explain query
15 0.56 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(174,315,316,317,318,319,320,321,322,323,324,325) ORDER BY FIND_IN_SET(`tl_page`.`id`, '174,315,316,317,318,319,320,321,322,323,324,325')
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.83 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  326
]
View formatted query    View runnable query    Explain query
17 0.28 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(327) ORDER BY FIND_IN_SET(`tl_page`.`id`, '327')
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 0.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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  163
]
View formatted query    View runnable query    Explain query
19 0.26 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(334,337,183) ORDER BY FIND_IN_SET(`tl_page`.`id`, '334,337,183')
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 0.46 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  334
]
View formatted query    View runnable query    Explain query
21 0.22 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(335) ORDER BY FIND_IN_SET(`tl_page`.`id`, '335')
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 0.41 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  335
]
View formatted query    View runnable query    Explain query
23 0.27 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(336) ORDER BY FIND_IN_SET(`tl_page`.`id`, '336')
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 0.59 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  336
]
View formatted query    View runnable query    Explain query
25 0.30 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(182) ORDER BY FIND_IN_SET(`tl_page`.`id`, '182')
Parameters: 
[]
View formatted query    View runnable query    Explain query
26 0.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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  337
]
View formatted query    View runnable query    Explain query
27 0.26 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(338) ORDER BY FIND_IN_SET(`tl_page`.`id`, '338')
Parameters: 
[]
View formatted query    View runnable query    Explain query
28 0.47 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  338
]
View formatted query    View runnable query    Explain query
29 0.22 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(339) ORDER BY FIND_IN_SET(`tl_page`.`id`, '339')
Parameters: 
[]
View formatted query    View runnable query    Explain query
30 0.44 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  339
]
View formatted query    View runnable query    Explain query
31 0.36 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(340,341,342,343,344) ORDER BY FIND_IN_SET(`tl_page`.`id`, '340,341,342,343,344')
Parameters: 
[]
View formatted query    View runnable query    Explain query
32 0.78 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  164
]
View formatted query    View runnable query    Explain query
33 0.37 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(184,216,217,218,185,219,186,261,220,222) ORDER BY FIND_IN_SET(`tl_page`.`id`, '184,216,217,218,185,219,186,261,220,222')
Parameters: 
[]
View formatted query    View runnable query    Explain query
34 0.63 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  184
]
View formatted query    View runnable query    Explain query
35 0.36 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(223,224) ORDER BY FIND_IN_SET(`tl_page`.`id`, '223,224')
Parameters: 
[]
View formatted query    View runnable query    Explain query
36 0.53 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  216
]
View formatted query    View runnable query    Explain query
37 0.24 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(225) ORDER BY FIND_IN_SET(`tl_page`.`id`, '225')
Parameters: 
[]
View formatted query    View runnable query    Explain query
38 0.47 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  217
]
View formatted query    View runnable query    Explain query
39 0.26 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(229,230,231) ORDER BY FIND_IN_SET(`tl_page`.`id`, '229,230,231')
Parameters: 
[]
View formatted query    View runnable query    Explain query
40 0.55 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  218
]
View formatted query    View runnable query    Explain query
41 0.24 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(232,233,234,235) ORDER BY FIND_IN_SET(`tl_page`.`id`, '232,233,234,235')
Parameters: 
[]
View formatted query    View runnable query    Explain query
42 0.56 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  185
]
View formatted query    View runnable query    Explain query
43 0.29 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(236,237,238,239,240,241,242,243,244,245) ORDER BY FIND_IN_SET(`tl_page`.`id`, '236,237,238,239,240,241,242,243,244,245')
Parameters: 
[]
View formatted query    View runnable query    Explain query
44 0.80 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  219
]
View formatted query    View runnable query    Explain query
45 0.41 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(246,247,248,249,250,251) ORDER BY FIND_IN_SET(`tl_page`.`id`, '246,247,248,249,250,251')
Parameters: 
[]
View formatted query    View runnable query    Explain query
46 3.20 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  186
]
View formatted query    View runnable query    Explain query
47 1.44 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(252,253,254,255,256,257,258,259) ORDER BY FIND_IN_SET(`tl_page`.`id`, '252,253,254,255,256,257,258,259')
Parameters: 
[]
View formatted query    View runnable query    Explain query
48 0.86 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  261
]
View formatted query    View runnable query    Explain query
49 0.48 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(262,263,264,265,266,267,268,269,270) ORDER BY FIND_IN_SET(`tl_page`.`id`, '262,263,264,265,266,267,268,269,270')
Parameters: 
[]
View formatted query    View runnable query    Explain query
50 0.64 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  220
]
View formatted query    View runnable query    Explain query
51 0.30 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(271,272,273,274,275,276,277) ORDER BY FIND_IN_SET(`tl_page`.`id`, '271,272,273,274,275,276,277')
Parameters: 
[]
View formatted query    View runnable query    Explain query
52 0.70 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  222
]
View formatted query    View runnable query    Explain query
53 0.29 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(278,279) ORDER BY FIND_IN_SET(`tl_page`.`id`, '278,279')
Parameters: 
[]
View formatted query    View runnable query    Explain query
54 0.76 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<=1771646460) AND (p2.stop='' OR p2.stop>1771646460)) 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<=1771646460) AND (p1.stop='' OR p1.stop>1771646460) ORDER BY p1.sorting
Parameters: 
[
  179
]
View formatted query    View runnable query    Explain query
55 0.42 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(381,382,383) ORDER BY FIND_IN_SET(`tl_page`.`id`, '381,382,383')
Parameters: 
[]
View formatted query    View runnable query    Explain query
56 0.41 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters: 
[
  138
]
View formatted query    View runnable query    Explain query
57 0.28 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters: 
[
  92
]
View formatted query    View runnable query    Explain query
58 0.26 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters: 
[
  160
]
View formatted query    View runnable query    Explain query
59 0.68 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.pid=? AND tl_page.type!='root' AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1771646460) AND (tl_page.stop='' OR tl_page.stop>1771646460) ORDER BY tl_page.sorting LIMIT 0,1
Parameters: 
[
  90
]
View formatted query    View runnable query    Explain query
60 0.64 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<=1771646460) AND (tl_article.stop='' OR tl_article.stop>1771646460) ORDER BY tl_article.sorting
Parameters: 
[
  165
  "header"
]
View formatted query    View runnable query    Explain query
61 0.89 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<=1771646460) AND (tl_article.stop='' OR tl_article.stop>1771646460) ORDER BY tl_article.sorting
Parameters: 
[
  165
  "main"
]
View formatted query    View runnable query    Explain query
62 3.43 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<=1771646460) AND (tl_content.stop='' OR tl_content.stop>1771646460) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters: 
[
  400
  "tl_article"
]
View formatted query    View runnable query    Explain query
63 0.17 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
64 0.92 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "d03a5cf4"
]
View formatted query    View runnable query    Explain query
65 0.29 ms 
SELECT * FROM tl_theme
Parameters: 
[]
View formatted query    View runnable query    Explain query
66 0.10 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
67 0.76 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "d03a5cf4"
]
View formatted query    View runnable query    Explain query
68 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
69 2.34 ms 
SELECT       c.COLUMN_NAME        AS field,
       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' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "d03a5cf4"
  "d03a5cf4"
  "tl_bs_grid"
]
View formatted query    View runnable query    Explain query
70 0.29 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
71 1.03 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "d03a5cf4"
]
View formatted query    View runnable query    Explain query
72 0.16 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
73 4.12 ms 
SELECT       c.COLUMN_NAME        AS field,
       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' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "d03a5cf4"
  "d03a5cf4"
  "tl_bs_grid"
]
View formatted query    View runnable query    Explain query
74 0.18 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
75 0.88 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "d03a5cf4"
]
View formatted query    View runnable query    Explain query
76 0.12 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
77 1.78 ms 
SELECT       c.COLUMN_NAME        AS field,
       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' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "d03a5cf4"
  "d03a5cf4"
  "tl_bs_grid"
]
View formatted query    View runnable query    Explain query
78 0.16 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
79 0.85 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "d03a5cf4"
]
View formatted query    View runnable query    Explain query
80 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
81 1.77 ms 
SELECT       c.COLUMN_NAME        AS field,
       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' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "d03a5cf4"
  "d03a5cf4"
  "tl_bs_grid"
]
View formatted query    View runnable query    Explain query
82 0.17 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
83 0.80 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "d03a5cf4"
]
View formatted query    View runnable query    Explain query
84 0.13 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
85 1.82 ms 
SELECT       c.COLUMN_NAME        AS field,
       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' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "d03a5cf4"
  "d03a5cf4"
  "tl_bs_grid"
]
View formatted query    View runnable query    Explain query
86 0.39 ms 
SELECT tl_bs_grid.* FROM tl_bs_grid WHERE tl_bs_grid.`id`=? LIMIT 0,1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
87 0.40 ms 
SELECT tl_bs_grid.* FROM tl_bs_grid WHERE tl_bs_grid.`id`=? LIMIT 0,1
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
88 0.49 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "ad36541a6da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
89 0.37 ms 
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters: 
[
  "10"
]
View formatted query    View runnable query    Explain query
90 0.63 ms 
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
91 1.74 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "ad3c167a6da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
92 0.37 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "ad3654066da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
93 0.33 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "ad3a24466da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
94 0.33 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "acea1b136da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
95 0.39 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "acea1b0e6da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
96 0.35 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "acecc6356da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
97 0.37 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "acecc62d6da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
98 0.42 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "8734227e6da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
99 0.38 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "873423816da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
100 0.31 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "87309c816da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
101 0.45 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "8737dc846da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
102 2.12 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "873422fc6da511ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
103 2.67 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<=1771646460) AND (tl_content.stop='' OR tl_content.stop>1771646460) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters: 
[
  212
  "tl_article"
]
View formatted query    View runnable query    Explain query
104 2.03 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "6fc7e63374ec11ebb70ae0d55edd9ad9"
]
View formatted query    View runnable query    Explain query
105 0.68 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters: 
[
  "172"
]
View formatted query    View runnable query    Explain query
106 0.49 ms 
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters: 
[
  324
]
View formatted query    View runnable query    Explain query
107 1.70 ms 
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(1) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '1')
Parameters: 
[]
View formatted query    View runnable query    Explain query
108 3.44 ms 
SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(1) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<=1771646460) AND (tl_news.stop='' OR tl_news.stop>1771646460)
Parameters: 
[]
View formatted query    View runnable query    Explain query
109 0.39 ms 
SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<=1771646460) AND (tl_news.stop='' OR tl_news.stop>1771646460) ORDER BY tl_news.date DESC LIMIT 0,2
Parameters: 
[
  null
]
View formatted query    View runnable query    Explain query
110 10.35 ms 
SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<=1771646460) AND (tl_news.stop='' OR tl_news.stop>1771646460) ORDER BY tl_news.date DESC LIMIT 0,2
Parameters: 
[]
View formatted query    View runnable query    Explain query
111 0.07 ms 
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ad01aaa86dd711ebb70ae0d55edd9ad9'),UNHEX('ac41a04e6dd711ebb70ae0d55edd9ad9')) ORDER BY tl_files.uuid!=UNHEX('ad01aaa86dd711ebb70ae0d55edd9ad9'), tl_files.uuid!=UNHEX('ac41a04e6dd711ebb70ae0d55edd9ad9')
Parameters: 
[
  null
]
View formatted query    View runnable query    Explain query
112 2.90 ms 
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ad01aaa86dd711ebb70ae0d55edd9ad9'),UNHEX('ac41a04e6dd711ebb70ae0d55edd9ad9')) ORDER BY tl_files.uuid!=UNHEX('ad01aaa86dd711ebb70ae0d55edd9ad9'), tl_files.uuid!=UNHEX('ac41a04e6dd711ebb70ae0d55edd9ad9')
Parameters: 
[]
View formatted query    View runnable query    Explain query
113 0.54 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters: 
[
  176
]
View formatted query    View runnable query    Explain query
114 0.57 ms 
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters: 
[
  175
]
View formatted query    View runnable query    Explain query
115 0.57 ms 
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters: 
[
  "21"
]
View formatted query    View runnable query    Explain query
116 1.65 ms 
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' ORDER BY sorting ASC
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
117 2.38 ms 
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1771646460) AND (tl_content.stop='' OR tl_content.stop>1771646460) AND tl_content.tstamp!=0
Parameters: 
[
  224
  "tl_news"
]
View formatted query    View runnable query    Explain query
118 0.98 ms 
SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1771646460) AND (tl_content.stop='' OR tl_content.stop>1771646460) AND tl_content.tstamp!=0
Parameters: 
[
  223
  "tl_news"
]
View formatted query    View runnable query    Explain query
119 1.92 ms 
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters: 
[
  "c5f16ba9837411ec9ca300ce0ac8cca6"
]
View formatted query    View runnable query    Explain query

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.