https://share.pano.pdir.dev/sitemap.xml

Query Metrics

450 Database Queries
27 Different statements
139.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
71.36 ms
(51.15%)
240
SELECT tl_page.* FROM tl_page WHERE tl_page.`pid`=? ORDER BY sorting
Parameters:
[
  90
]
54.85 ms
(39.32%)
180
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<=1775550660) AND (tl_article.stop='' OR tl_article.stop>1775550660) ORDER BY tl_article.sorting
Parameters:
[
  159
]
5.54 ms
(3.97%)
1
SELECT tl_news.* FROM tl_news WHERE tl_news.pid=? AND tl_news.source='default' AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<=1775550660) AND (tl_news.stop='' OR tl_news.stop>1775550660) ORDER BY tl_news.date DESC
Parameters:
[
  1
]
2.35 ms
(1.68%)
2
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<=1775550660) AND (tl_page.stop='' OR tl_page.stop>1775550660)
Parameters:
[
  "share.pano.pdir.dev"
]
1.01 ms
(0.72%)
5
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.`protected`=?
Parameters:
[
  ""
]
0.43 ms
(0.31%)
1
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
0.36 ms
(0.26%)
1
SELECT id, pid FROM tl_page WHERE pid IN(129,130,133,138,147,113,114,115,116,125,126,127,128,149,120,121,122,124,174,315,316,317,318,319,320,321,322,323,324,325,223,224,236,237,238,239,240,241,242,243,244,245,252,253,254,255,256,257,258,259,225,229,230,231,232,233,234,235,246,247,248,249,250,251,271,272,273,274,275,276,277,278,279,262,263,264,265,266,267,268,269,270,327,329,335,338)
Parameters:
[]
0.28 ms
(0.20%)
1
SELECT id, pid FROM tl_page WHERE pid IN(380,360,361,362,363,364,365,366,367,368,286,287)
Parameters:
[]
0.26 ms
(0.19%)
1
SELECT id, pid FROM tl_page WHERE pid IN(90)
Parameters:
[]
0.26 ms
(0.19%)
1
SELECT id, pid FROM tl_page WHERE pid IN(356,357)
Parameters:
[]
0.26 ms
(0.18%)
1
SELECT id, pid FROM tl_page WHERE pid IN(106,107,123,135,92,101,118,166,167,208,384,169,170,181,326,328,330,331,332,333,183,334,337,184,185,186,216,217,218,219,220,222,261,176,207,381,382,383,188,189)
Parameters:
[]
0.20 ms
(0.14%)
1
SELECT id, pid FROM tl_page WHERE pid IN(140,105,187,190,143,161,91,134,139,159,160,162,163,164,165,171,172,173,175,179,180)
Parameters:
[]
0.19 ms
(0.14%)
1
SELECT id, pid FROM tl_page WHERE pid IN(205,200,194,297,298)
Parameters:
[]
0.19 ms
(0.13%)
1
SELECT id, pid FROM tl_page WHERE pid IN(204,201,196,300,301,302,304)
Parameters:
[]
0.17 ms
(0.13%)
1
SELECT id, pid FROM tl_page WHERE pid IN(206,199,192,280,281,282,283)
Parameters:
[]
0.17 ms
(0.12%)
1
SELECT id, pid FROM tl_page WHERE pid IN(195)
Parameters:
[]
0.17 ms
(0.12%)
1
SELECT id, pid FROM tl_page WHERE pid IN(191)
Parameters:
[]
0.17 ms
(0.12%)
1
SELECT id, pid FROM tl_page WHERE pid IN(203,202,198,309,310,345,347)
Parameters:
[]
0.16 ms
(0.12%)
1
SELECT id, pid FROM tl_page WHERE pid IN(379,299)
Parameters:
[]
0.16 ms
(0.11%)
1
SELECT id, pid FROM tl_page WHERE pid IN(288,289,290,291,292,294,296)
Parameters:
[]
0.16 ms
(0.11%)
1
SELECT id, pid FROM tl_page WHERE pid IN(359,348,349,350,351,352,353,354,311,346,355,358)
Parameters:
[]
0.15 ms
(0.11%)
1
SELECT id, pid FROM tl_page WHERE pid IN(193)
Parameters:
[]
0.15 ms
(0.11%)
1
SELECT id, pid FROM tl_page WHERE pid IN(197)
Parameters:
[]
0.15 ms
(0.11%)
1
SELECT id, pid FROM tl_page WHERE pid IN(378,369,370,371,374,375,376,377,305,307)
Parameters:
[]
0.13 ms
(0.10%)
1
SELECT id, pid FROM tl_page WHERE pid IN(155,156,152,153,154,336,339)
Parameters:
[]
0.13 ms
(0.09%)
1
SELECT id, pid FROM tl_page WHERE pid IN(182,340,341,342,343,344)
Parameters:
[]
0.11 ms
(0.08%)
1
SELECT id, pid FROM tl_page WHERE pid IN(306,308,372,373)
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.

Entities Mapping

Class Mapping errors
Contao\CoreBundle\Entity\RememberMe No errors.