Query Metrics
450
Database Queries
27
Different statements
139.51 ms
Query time
0
Invalid entities
Grouped Statements
| 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. |