Query Metrics
3
Database Queries
3
Different statements
1.35 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.82 ms (61.04%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15 FROM p_category t0 WHERE t0.id = ?
Parameters:
[
"34"
]
|
0.29 ms (21.55%) |
1 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.submitted AS submitted_4, t0.is_admin AS is_admin_5, t0.client_id AS client_id_6, t0.category_id AS category_id_7, t0.comment_id AS comment_id_8 FROM comment t0 WHERE t0.category_id = ? AND t0.comment_id IS NULL ORDER BY t0.submitted DESC
Parameters:
[
34
]
|
0.23 ms (17.41%) |
1 |
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.title AS title_2, c0_.submitted AS submitted_3, c0_.is_admin AS is_admin_4, c0_.client_id AS client_id_5, c0_.category_id AS category_id_6, c0_.comment_id AS comment_id_7 FROM comment c0_ WHERE c0_.category_id = ? AND c0_.comment_id IS NOT NULL ORDER BY c0_.submitted ASC
Parameters:
[
34
]
|
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\Web\Category | No errors. |
App\Entity\Web\Label | No errors. |
App\Entity\Web\CategoryFile |
|
App\Entity\Web\CategoryCategory | No errors. |
App\Entity\Web\Comment |
|
App\Entity\Client | No errors. |