Query Metrics
9
Database Queries
4
Different statements
6.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.94 ms (46.50%) |
5 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.tree_root AS tree_root_11, t0.parent_id AS parent_id_12 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
|
1.71 ms (27.04%) |
2 |
SELECT COUNT(n0_.id) AS sclr_0 FROM navigation n0_ WHERE n0_.position = ?
Parameters:
[
"HEADER"
]
|
|
1.27 ms (20.04%) |
1 |
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.deleted AS deleted_3, t0.navigation_id AS navigation_id_4, t5.id AS id_6, t5.position AS position_7, t5.title AS title_8, t5.active AS active_9, t5.deleted AS deleted_10, t0.category_id AS category_id_11, t12.id AS id_13, t12.title AS title_14, t12.description AS description_15, t12.lft AS lft_16, t12.lvl AS lvl_17, t12.rgt AS rgt_18, t12.og_title AS og_title_19, t12.og_description AS og_description_20, t12.active AS active_21, t12.deleted AS deleted_22, t12.tree_root AS tree_root_23, t12.parent_id AS parent_id_24 FROM navigation_category t0 INNER JOIN navigation t5 ON t0.navigation_id = t5.id INNER JOIN category t12 ON t0.category_id = t12.id WHERE t0.navigation_id IN (?)
Parameters:
[
1
]
|
|
0.41 ms (6.42%) |
1 |
SELECT n0_.id AS id_0, n0_.position AS position_1, n0_.title AS title_2, n0_.active AS active_3, n0_.deleted AS deleted_4 FROM navigation n0_ WHERE n0_.position = ?
Parameters:
[
"TOP"
]
|
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\Navigation\Navigation | No errors. |
| App\Entity\Navigation\NavigationCategory | No errors. |
| App\Entity\Category\Category | No errors. |
| App\Entity\Category\CategoryProduct | No errors. |