Query Metrics
139
Database Queries
47
Different statements
55.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.84 ms (15.87%) |
15 |
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<=1766093460) AND (p2.stop='' OR p2.stop>1766093460)) 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<=1766093460) AND (p1.stop='' OR p1.stop>1766093460) ORDER BY p1.sorting
Parameters:
[
2604
]
|
|
4.71 ms (8.46%) |
10 |
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<=1766093460) AND (tl_content.stop='' OR tl_content.stop>1766093460) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 13790 "tl_article" ] |
|
3.87 ms (6.94%) |
10 |
SELECT tl_article.* FROM tl_article WHERE BINARY tl_article.alias=? LIMIT 0,1
Parameters:
[
"offcanvas-col1"
]
|
|
3.63 ms (6.51%) |
12 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
2690
]
|
|
3.51 ms (6.30%) |
1 |
SELECT * FROM tl_pct_customelement_attribute WHERE tstamp > 0 AND pid IN(2,4,5,6,7,8,9,10,17,18,19,20,21,24,27,28,29,30,31,32,33,37,38,39,40,44,45,46,52,53,56,66,67,68,69,70,71,73,76,77,78,79,81,82,83,84,85,86,88,89,97,100,101,102,103,104,106,107,125,126,127,128,130,131,134,135,137,138,139,142,143,144,149,154,155,156,157,158,159,160,161,162,168,169,170,171,172,173,179,180,181,182,189,190,191,231,235,236,237,238,245,247,252,256,257,258,259,262,267,268,273,274,275,292,293,294,295,297,300,301,303,308,310,312,313,316,317,321,322,324,325,326,327,328,329,330,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,426,427,428,429,430,431)
Parameters:
[] |
|
3.05 ms (5.48%) |
15 |
SELECT pct_customelement FROM tl_content WHERE id=? LIMIT 0,1
Parameters:
[
113247
]
|
|
1.95 ms (3.50%) |
3 |
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND ( tl_page.dns=? OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND id = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot = ( SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) ) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1766093460) AND (tl_page.stop='' OR tl_page.stop>1766093520) ORDER BY sorting
Parameters:
[ "" "" "" "" ] |
|
1.89 ms (3.39%) |
8 |
SELECT tl_pct_customelement_group.* FROM tl_pct_customelement_group WHERE tl_pct_customelement_group.alias=? AND tl_pct_customelement_group.pid=? LIMIT 0,1
Parameters:
[ "margins" 21 ] |
|
1.74 ms (3.13%) |
1 |
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1766093460) AND (tl_content.stop='' OR tl_content.stop>1766093460) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 981 "tl_news" ] |
|
1.37 ms (2.47%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"grace_accelerator_db"
]
|
|
1.33 ms (2.39%) |
6 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
"2623"
]
|
|
1.12 ms (2.02%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND ( tl_page.dns=? OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND id = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot = ( SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) ) ORDER BY sorting
Parameters:
[ "" "" "" "" ] |
|
1.12 ms (2.01%) |
4 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1766093460) AND (tl_page.stop='' OR tl_page.stop>1766093460) LIMIT 0,1
Parameters:
[
2682
]
|
|
1.09 ms (1.95%) |
2 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
Parameters:
[ "alumnae/alumnareader/emilia-von-keyserlingk-pepper" "alumnae/alumnareader" "alumnae" ] |
|
1.04 ms (1.87%) |
3 |
SELECT tl_page.* FROM tl_page WHERE (tl_page.id=? OR tl_page.languageMain=?) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1766093460) AND (tl_page.stop='' OR tl_page.stop>1766093520)
Parameters:
[ 2683 2683 ] |
|
1.01 ms (1.81%) |
1 |
SHOW FULL COLUMNS FROM tl_content
Parameters:
[] |
|
1.00 ms (1.80%) |
3 |
SELECT tl_news.* FROM tl_news WHERE BINARY tl_news.alias=? AND tl_news.pid IN(67) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<=1766093460) AND (tl_news.stop='' OR tl_news.stop>1766093460) LIMIT 0,1
Parameters:
[
"emilia-von-keyserlingk-pepper"
]
|
|
0.95 ms (1.70%) |
3 |
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<=1766093460) AND (tl_article.stop='' OR tl_article.stop>1766093460) ORDER BY tl_article.sorting
Parameters:
[ 2683 "main" ] |
|
0.87 ms (1.57%) |
1 |
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147) ORDER BY FIND_IN_SET(`tl_module`.`id`, '32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147')
Parameters:
[] |
|
0.87 ms (1.57%) |
1 |
SELECT * FROM tl_pct_customelement_group WHERE tstamp > 0 AND pid IN(90,80,119,53,28,19,71,9,107,67,140,116,137,99,82,141,78,5,113,112,111,44,47,46,15,13,52,51,64,61,65,66,4,108,134,88,77,109,45,127,126,125,27,29,33,94,54,144,100,7,106,105,32,83,70,93,6,23,86,121,98,97,39,38,40,2,11,3,95,49,151,68,43,21,117,42,136,20,145,146,142,114,148,147,41,124,122,123)
Parameters:
[] |
|
0.82 ms (1.48%) |
3 |
SELECT * FROM tl_pct_themedesigner WHERE tl_pct_themedesigner.active=? AND tl_pct_themedesigner.theme=?
Parameters:
[ 1 "eclipse_design" ] |
|
0.68 ms (1.21%) |
2 |
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
638
]
|
|
0.66 ms (1.19%) |
1 |
SELECT * FROM tl_pct_customelement WHERE alias!='' AND tstamp > 0 ORDER BY title
Parameters:
[] |
|
0.62 ms (1.11%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('92e02e18549511eab3d3001a4a050158'),UNHEX('f6366fa8548d11eab3d3001a4a050158')) ORDER BY tl_files.uuid!=UNHEX('92e02e18549511eab3d3001a4a050158'), tl_files.uuid!=UNHEX('f6366fa8548d11eab3d3001a4a050158')
Parameters:
[
null
]
|
|
0.62 ms (1.11%) |
1 |
SHOW FULL COLUMNS FROM tl_user
Parameters:
[] |
|
0.59 ms (1.06%) |
3 |
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
"files/cto_layout/img/flags/de.svg"
]
|
|
0.58 ms (1.05%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.46 ms (0.82%) |
1 |
SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root'
Parameters:
[] |
|
0.45 ms (0.81%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
"8080d90f58e711ec8137001a4a0500bc"
]
|
|
0.45 ms (0.81%) |
2 |
SELECT tl_calendar.* FROM tl_calendar WHERE tl_calendar.`jumpTo`=?
Parameters:
[
2683
]
|
|
0.44 ms (0.80%) |
1 |
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
30
]
|
|
0.41 ms (0.74%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(2705,2646,2663,2689,2643,2672,2620,2619) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2705,2646,2663,2689,2643,2672,2620,2619')
Parameters:
[] |
|
0.40 ms (0.71%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(2605,2606,2622,2607) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2605,2606,2690,2622,2607')
Parameters:
[] |
|
0.37 ms (0.66%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.pid=? AND tl_page.type='regular' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1766093460) AND (tl_page.stop='' OR tl_page.stop>1766093460) ORDER BY tl_page.sorting LIMIT 0,1
Parameters:
[
2709
]
|
|
0.34 ms (0.61%) |
2 |
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.`jumpTo`=?
Parameters:
[
2683
]
|
|
0.31 ms (0.56%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(218,219,220) ORDER BY FIND_IN_SET(`tl_page`.`id`, '218,219,220')
Parameters:
[] |
|
0.31 ms (0.56%) |
1 |
SELECT * FROM tl_theme ORDER BY name
Parameters:
[] |
|
0.31 ms (0.55%) |
2 |
SELECT tl_faq_category.* FROM tl_faq_category WHERE tl_faq_category.`jumpTo`=?
Parameters:
[
2683
]
|
|
0.30 ms (0.55%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(2615,2628,2627,2635) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2615,2628,2627,2635')
Parameters:
[] |
|
0.29 ms (0.53%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(221,222,223) ORDER BY FIND_IN_SET(`tl_page`.`id`, '221,222,223')
Parameters:
[] |
|
0.27 ms (0.49%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(2616) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2682,2616')
Parameters:
[] |
|
0.24 ms (0.43%) |
1 |
SELECT tl_news.* FROM tl_news WHERE (tl_news.id=? OR tl_news.languageMain=?) AND tl_news.pid=(SELECT id FROM tl_news_archive WHERE (id=? OR master=?) AND jumpTo=?) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1766093460') AND (tl_news.stop='' OR tl_news.stop>'1766093520') LIMIT 0,1
Parameters:
[ 981 981 67 67 2709 ] |
|
0.19 ms (0.34%) |
1 |
SHOW INDEXES FROM `tl_content`
Parameters:
[] |
|
0.17 ms (0.30%) |
1 |
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
4
]
|
|
0.17 ms (0.30%) |
1 |
SHOW INDEXES FROM `tl_user`
Parameters:
[] |
|
0.15 ms (0.27%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.12 ms (0.21%) |
1 |
SELECT * FROM tl_files WHERE tl_files.`id`=? LIMIT 0,1
Parameters:
[
null
]
|
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
No loaded entities.