Query Metrics
7
Database Queries
5
Different statements
4.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tpl AS tpl_3, t0.slug AS slug_4, t0.content AS content_5, t0.created AS created_6, t0.updated AS updated_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM page t0 WHERE t0.tpl = ? LIMIT 1
Parameters:
[
"sitemap"
]
|
| 2 | 0.50 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.tpl AS tpl_2, p0_.slug AS slug_3, p0_.content AS content_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.lft AS lft_7, p0_.lvl AS lvl_8, p0_.rgt AS rgt_9, p0_.tree_root AS tree_root_10, p0_.parent_id AS parent_id_11 FROM page p0_ WHERE p0_.rgt < 2 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.lft ASC
Parameters:
[
19
]
|
| 3 | 0.60 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.tpl AS tpl_2, p0_.slug AS slug_3, p0_.content AS content_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.lft AS lft_7, p0_.lvl AS lvl_8, p0_.rgt AS rgt_9, p0_.tree_root AS tree_root_10, p0_.parent_id AS parent_id_11 FROM page p0_ ORDER BY p0_.lft ASC
Parameters:
[] |
| 4 | 0.43 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.tpl AS tpl_2, p0_.slug AS slug_3, p0_.content AS content_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.lft AS lft_7, p0_.lvl AS lvl_8, p0_.rgt AS rgt_9, p0_.tree_root AS tree_root_10, p0_.parent_id AS parent_id_11 FROM page p0_ WHERE p0_.parent_id IS NULL AND p0_.tpl <> ?
Parameters:
[
"menu"
]
|
| 5 | 0.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tpl AS tpl_3, t0.slug AS slug_4, t0.content AS content_5, t0.created AS created_6, t0.updated AS updated_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM page t0 WHERE t0.parent_id = ? ORDER BY t0.tree_root ASC
Parameters:
[
1
]
|
| 6 | 0.58 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.tpl AS tpl_2, p0_.slug AS slug_3, p0_.content AS content_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.lft AS lft_7, p0_.lvl AS lvl_8, p0_.rgt AS rgt_9, p0_.tree_root AS tree_root_10, p0_.parent_id AS parent_id_11 FROM page p0_ ORDER BY p0_.lft ASC
Parameters:
[] |
| 7 | 0.63 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.tpl AS tpl_2, p0_.slug AS slug_3, p0_.content AS content_4, p0_.created AS created_5, p0_.updated AS updated_6, p0_.lft AS lft_7, p0_.lvl AS lvl_8, p0_.rgt AS rgt_9, p0_.tree_root AS tree_root_10, p0_.parent_id AS parent_id_11 FROM page p0_ ORDER BY p0_.lft ASC
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 |
|---|---|
| App\Entity\Page | No errors. |
| App\Entity\WallItem | No errors. |
| App\Entity\User | No errors. |