Query Metrics
3
Database Queries
3
Different statements
1.15 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.48 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM page p0_ WHERE p0_.page_type_code = ? AND p0_.parent_id <> 0
Parameters:
[
"NW"
]
|
| 2 | 0.28 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM page p0_ WHERE p0_.page_type_code = ? AND p0_.parent_id <> 0 ORDER BY p0_.id DESC LIMIT 6
Parameters:
[
"NW"
]
|
| 3 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.parent_id AS parent_id_1, p0_.url_title AS url_title_2, p0_.anchor_text AS anchor_text_3, p0_.title AS title_4, p0_.description AS description_5, p0_.body AS body_6, p0_.updated AS updated_7, p0_.updated_by AS updated_by_8, p0_.page_status_code AS page_status_code_9, p0_.page_type_code AS page_type_code_10 FROM page p0_ WHERE p0_.page_type_code = ? AND p0_.parent_id <> 0 AND p0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[ "NW" 55 54 49 48 47 46 ] |
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\PageStatus | No errors. |
| App\Entity\PageType | No errors. |