Query Metrics
5
Database Queries
4
Different statements
2.77 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3 FROM page_template t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"page/news_page.html.twig"
]
|
2 | 0.64 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.title AS title_1, p0_.uri AS uri_2, p0_.data AS data_3, p0_.updated AS updated_4, p0_.published AS published_5, p0_.created AS created_6, p0_.published_date AS published_date_7, p0_.meta AS meta_8, p0_.menu_title AS menu_title_9, p0_.menu_position AS menu_position_10, p0_.extra_fields AS extra_fields_11, p0_.template_id AS template_id_12 FROM PAGE p0_ WHERE p0_.template_id = ? AND p0_.published = ? ORDER BY p0_.published_date DESC LIMIT 3
Parameters:
[ 2 1 ] |
3 | 0.42 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM PAGE p0_ WHERE p0_.template_id = ? AND p0_.published = ?
Parameters:
[ 2 1 ] |
4 | 0.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.path AS path_3 FROM page_template t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"page/static_page.html.twig"
]
|
5 | 0.44 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.uri AS uri_3, t0.data AS data_4, t0.updated AS updated_5, t0.published AS published_6, t0.created AS created_7, t0.published_date AS published_date_8, t0.meta AS meta_9, t0.menu_title AS menu_title_10, t0.menu_position AS menu_position_11, t0.extra_fields AS extra_fields_12, t0.template_id AS template_id_13 FROM PAGE t0 WHERE t0.template_id = ? AND t0.published = ? ORDER BY t0.menu_position ASC
Parameters:
[ 1 1 ] |
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 |
---|---|
App\Entity\PageTemplate | No errors. |
App\Entity\Page | No errors. |