Query Metrics
188
Database Queries
4
Different statements
62.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
51.14 ms (81.44%) |
152 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.active AS active_3, t0.created AS created_4, t0.updated AS updated_5, t0.sort AS sort_6, t0.category3_id AS category3_id_7 FROM category t0 WHERE (t0.active = ? AND t0.category3_id = ?) ORDER BY t0.sort ASC
Parameters:
[ 1 1 ] |
|
9.58 ms (15.25%) |
31 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category2_id AS category2_id_5 FROM category3 t0 WHERE t0.category2_id = ? ORDER BY t0.sort ASC
Parameters:
[
1
]
|
|
1.44 ms (2.30%) |
4 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.updated AS updated_3, t0.sort AS sort_4, t0.category1_id AS category1_id_5 FROM category2 t0 WHERE t0.category1_id = ? ORDER BY t0.sort ASC
Parameters:
[
1
]
|
|
0.64 ms (1.01%) |
1 |
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.updated AS updated_2, c0_.sort AS sort_3 FROM category1 c0_ WHERE c0_.sort <> 50 ORDER BY c0_.sort ASC LIMIT 7
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\Category1 | No errors. |
| App\Entity\Category2 | No errors. |
| App\Entity\Category3 | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Family | No errors. |