Query Metrics
20
Database Queries
13
Different statements
6.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.08 ms (16.04%) |
2 |
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<=1781462040) AND (tl_page.stop='' OR tl_page.stop>1781462040) LIMIT 0,1
Parameters:
[ "" ] |
|
0.84 ms (12.44%) |
3 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
4
]
|
|
0.82 ms (12.28%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('d3bf3198919411e8bfa398f2b3ecdd82')) ORDER BY tl_files.uuid!=UNHEX('d3bf3198919411e8bfa398f2b3ecdd82')
Parameters:
[
null
]
|
|
0.80 ms (11.96%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?,?)
Parameters:
[ "legal/bundles/contaocookiebar/scripts/cookiebar.min.js" "legal/bundles/contaocookiebar/scripts" "legal/bundles/contaocookiebar" "legal/bundles" "legal" ] |
|
0.52 ms (7.73%) |
2 |
SELECT tl_cookie.* FROM tl_cookie WHERE tl_cookie.pid=? AND tl_cookie.published='1' ORDER BY tl_cookie.sorting
Parameters:
[
1
]
|
|
0.48 ms (7.16%) |
2 |
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<=1781462040) AND (tl_article.stop='' OR tl_article.stop>1781462040) ORDER BY tl_article.sorting
Parameters:
[ 42 "main" ] |
|
0.45 ms (6.75%) |
2 |
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
"9580b62f0ed411f090450261787af5a4"
]
|
|
0.40 ms (5.90%) |
1 |
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
3
]
|
|
0.38 ms (5.70%) |
1 |
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(12,0,19) ORDER BY FIND_IN_SET(`tl_module`.`id`, '12,0,19')
Parameters:
[] |
|
0.25 ms (3.69%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
0.25 ms (3.68%) |
1 |
SELECT tl_cookiebar.* FROM tl_cookiebar WHERE tl_cookiebar.`id`=?
Parameters:
[
"1"
]
|
|
0.24 ms (3.58%) |
1 |
SELECT tl_cookie_group.* FROM tl_cookie_group WHERE tl_cookie_group.pid=? AND tl_cookie_group.published='1' ORDER BY tl_cookie_group.sorting
Parameters:
[
1
]
|
|
0.21 ms (3.10%) |
1 |
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
3
]
|
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.