https://www.pano.pdir.dev/frauenstein/panoramazeitreise/

Query Metrics

71 Database Queries
36 Different statements
72.89 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.78 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?)
Parameters:
[
  "frauenstein/panoramazeitreise"
  "frauenstein"
]
2 0.34 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  191
]
3 0.31 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.dns=? AND tl_page.fallback='1' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1778780520) AND (tl_page.stop='' OR tl_page.stop>1778780520) LIMIT 0,1
Parameters:
[
  ""
]
4 0.23 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  199
]
5 0.11 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?)
Parameters:
[
  "frauenstein/panoramazeitreise"
  "frauenstein"
]
6 0.09 ms
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
7 0.76 ms
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
  54
]
8 0.71 ms
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
  15
]
9 1.03 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(364,314,0,0,0,347,366) ORDER BY FIND_IN_SET(`tl_module`.`id`, '364,314,0,0,0,347,366')
Parameters:
[]
10 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  191
]
11 0.29 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(280,281,282,283,206) ORDER BY FIND_IN_SET(`tl_page`.`id`, '199,280,281,282,283,206')
Parameters:
[]
12 0.40 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  199
]
13 0.52 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  280
]
14 0.26 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(360,361,362,363,364) ORDER BY FIND_IN_SET(`tl_page`.`id`, '360,361,362,363,364')
Parameters:
[]
15 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  281
]
16 0.35 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(365,366,367,368) ORDER BY FIND_IN_SET(`tl_page`.`id`, '365,366,367,368')
Parameters:
[]
17 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  282
]
18 0.31 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(286,287) ORDER BY FIND_IN_SET(`tl_page`.`id`, '286,287')
Parameters:
[]
19 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  286
]
20 0.41 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(288,289,290,291,292,294,296) ORDER BY FIND_IN_SET(`tl_page`.`id`, '288,289,290,291,292,294,296')
Parameters:
[]
21 0.32 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1778780520) AND (tl_page.stop='' OR tl_page.stop>1778780520) LIMIT 0,1
Parameters:
[
  179
]
22 0.37 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  138
]
23 0.24 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  92
]
24 0.22 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  160
]
25 0.31 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<=1778780520) AND (tl_article.stop='' OR tl_article.stop>1778780520) ORDER BY tl_article.sorting
Parameters:
[
  380
  "header"
]
26 1.25 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<=1778780520) AND (tl_article.stop='' OR tl_article.stop>1778780520) ORDER BY tl_article.sorting
Parameters:
[
  380
  "main"
]
27 1.64 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<=1778780520) AND (tl_content.stop='' OR tl_content.stop>1778780520) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  439
  "tl_article"
]
28 36.57 ms
SELECT * FROM tl_pano_panorama WHERE BINARY tl_pano_panorama.alias=? LIMIT 0,1
Parameters:
[
  null
]
29 1.60 ms
SELECT * FROM tl_pano_config WHERE tl_pano_config.`id`=? LIMIT 0,1
Parameters:
[
  1
]
30 1.09 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "58b5b28fdf0b11ebb023e0d55e59bff3"
]
31 0.32 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<=1778780520) AND (tl_article.stop='' OR tl_article.stop>1778780520) ORDER BY tl_article.sorting
Parameters:
[
  380
  "footer"
]
32 0.57 ms
SELECT * FROM tl_style_sheet
Parameters:
[]
33 0.86 ms
INSERT INTO
                tl_log
                    (tstamp, source, action, username, text, func, browser)
                VALUES
                    (:tstamp, :source, :action, :username, :text, :func, :browser)
Parameters:
[
  "tstamp" => "1778780575"
  "text" => "Purged the shared cache"
  "source" => "FE"
  "action" => "CRON"
  "username" => "anon."
  "func" => "Contao\Automator::purgePageCache"
  "browser" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
]
34 0.16 ms
INSERT INTO
                tl_log
                    (tstamp, source, action, username, text, func, browser)
                VALUES
                    (:tstamp, :source, :action, :username, :text, :func, :browser)
Parameters:
[
  "tstamp" => "1778780575"
  "text" => "Purged the script cache"
  "source" => "FE"
  "action" => "CRON"
  "username" => "anon."
  "func" => "Contao\Automator::purgeScriptCache"
  "browser" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
]
35 0.28 ms
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')) ORDER BY tl_files.uuid!=UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')
Parameters:
[
  null
]
36 0.23 ms
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')) ORDER BY tl_files.uuid!=UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')
Parameters:
[]
37 0.43 ms
SELECT *, (SELECT tstamp FROM tl_theme WHERE tl_theme.id=tl_style_sheet.pid) AS tstamp3, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.invisible='' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (50) ORDER BY FIND_IN_SET(`id`, '50')
Parameters:
[]
38 0.04 ms
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')) ORDER BY tl_files.uuid!=UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')
Parameters:
[
  null
]
39 0.10 ms
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')) ORDER BY tl_files.uuid!=UNHEX('1a4d550e71d911ebb70ae0d55edd9ad9')
Parameters:
[]
40 1.75 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pdir_th_tag=? AND tl_article.pdir_th_domain=? LIMIT 0,1
Parameters:
[
  "MATE01/04"
  191
]
41 0.49 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.`pdir_th_tag`=? LIMIT 0,1
Parameters:
[
  "MATE01/04"
]
42 1.81 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<=1778780520) AND (tl_content.stop='' OR tl_content.stop>1778780520) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  145
  "tl_article"
]
43 0.39 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "000731366ba711ebb70ae0d55edd9ad9"
]
44 0.55 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pdir_th_tag=? AND tl_article.pdir_th_domain=? LIMIT 0,1
Parameters:
[
  "MATE01/06"
  191
]
45 0.27 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.`pdir_th_tag`=? LIMIT 0,1
Parameters:
[
  "MATE01/06"
]
46 0.91 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<=1778780520) AND (tl_content.stop='' OR tl_content.stop>1778780520) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  225
  "tl_article"
]
47 0.45 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  349
]
48 0.41 ms
SELECT 
                                                                    banner_hideempty,
                                                        	        banner_firstview,
                                                        	        banner_categories,
                                                        	        banner_template,
                                                        	        banner_redirect,
                                                        	        banner_useragent,
                                                                    cssID,
                                                                    headline 
                                                                FROM  
                                                                    tl_module 
                                                                WHERE 
                                                                    id=?
                                                                AND
                                                                    type=?
Parameters:
[
  "349"
  "banner"
]
49 0.16 ms
SELECT
                                    banner_expert_debug_all
                                FROM
                                    tl_banner_category
                                WHERE
                                    id=? LIMIT 0,1
Parameters:
[
  "1"
]
50 0.20 ms
SELECT 
                                                                    * 
                                                                FROM  
                                                                    tl_banner_category 
                                                                WHERE 
                                                                    id=?
Parameters:
[
  "1"
]
51 0.18 ms
SELECT * FROM tl_files WHERE tl_files.`id`=? LIMIT 0,1
Parameters:
[
  null
]
52 0.60 ms
SELECT 
                                        TLB.`id`, TLB.`banner_weighting`
                                   FROM 
                                        tl_banner AS TLB 
                                   LEFT JOIN 
                                        tl_banner_category ON tl_banner_category.id=TLB.pid
                                   LEFT OUTER JOIN 
                                        tl_banner_stat AS TLS ON TLB.id=TLS.id
                                   WHERE 
                                        pid=?
                                   AND (
                                           (TLB.banner_until=?) 
		                                OR (TLB.banner_until=1 AND TLB.banner_views_until>TLS.banner_views)   
                                        OR (TLB.banner_until=1 AND TLB.banner_views_until=?)  
                                        OR (TLB.banner_until=1 AND TLS.banner_views is NULL)
                                       )
                                   AND (
                                           (TLB.banner_until=?) 
                                        OR (TLB.banner_until=1 AND TLB.banner_clicks_until>TLS.banner_clicks) 
                                        OR (TLB.banner_until=1 AND TLB.banner_clicks_until=?) 
                                        OR (TLB.banner_until=1 AND TLS.banner_clicks is NULL)
                                       )
                                   AND 
                                        TLB.banner_published =?
                                   AND 
                                       (TLB.banner_start=? OR TLB.banner_start<=?) 
                                   AND 
                                       (TLB.banner_stop=? OR TLB.banner_stop>=?)
                                   AND 
                                       (TLB.banner_domain=? OR RIGHT(?, CHAR_LENGTH(TLB.banner_domain)) = TLB.banner_domain)
                                   ORDER BY TLB.`sorting`
Parameters:
[
  "1"
  ""
  ""
  ""
  ""
  1
  ""
  1778780575
  ""
  1778780575
  ""
  "www.pano.pdir.dev"
]
53 0.29 ms
SELECT
                            	            TLB.*
                                       FROM
                            	            tl_banner AS TLB
                                       WHERE
                                            TLB.`id`=? LIMIT 0,1
Parameters:
[
  2
]
54 0.24 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "04d90d3a6ba711ebb70ae0d55edd9ad9"
]
55 0.34 ms
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
  19
]
56 0.98 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:
[
  19
]
57 0.59 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  "352"
]
58 0.42 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "193"
]
59 0.32 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "195"
]
60 0.31 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "197"
]
61 0.47 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  "331"
]
62 0.08 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(179,172,139,134,180) 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<=1778780520) AND (tl_page.stop='' OR tl_page.stop>1778780520) ORDER BY FIND_IN_SET(`tl_page`.`id`, '179,172,139,134,180')
Parameters:
[
  null
]
63 0.64 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(179,172,139,134,180) 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<=1778780520) AND (tl_page.stop='' OR tl_page.stop>1778780520) ORDER BY FIND_IN_SET(`tl_page`.`id`, '179,172,139,134,180')
Parameters:
[]
64 0.63 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  "359"
]
65 0.14 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<=1778780520) AND (p2.stop='' OR p2.stop>1778780520)) 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<=1778780520) AND (p1.stop='' OR p1.stop>1778780520) ORDER BY p1.sorting
Parameters:
[
  191
]
66 0.11 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1778780520) AND (tl_page.stop='' OR tl_page.stop>1778780520) LIMIT 0,1
Parameters:
[
  179
]
67 0.72 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.pdir_th_tag=? AND tl_article.pdir_th_domain=? LIMIT 0,1
Parameters:
[
  "MATE05/05"
  191
]
68 0.21 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.`pdir_th_tag`=? LIMIT 0,1
Parameters:
[
  "MATE05/05"
]
69 0.69 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<=1778780520) AND (tl_content.stop='' OR tl_content.stop>1778780520) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  140
  "tl_article"
]
70 0.42 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "171"
]
71 0.37 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
  "173"
]

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.