Query Metrics
1
Database Queries
1
Different statements
1.89 ms
Query time
0
Invalid entities
4
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.89 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.featured_image AS featured_image_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.post_at AS post_at_6, p0_.is_published AS is_published_7, c1_.id AS id_8, c1_.content AS content_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c1_.is_approved AS is_approved_12, p0_.author_id AS author_id_13, p0_.updated_by_id AS updated_by_id_14, c1_.author_id AS author_id_15, c1_.post_id AS post_id_16, c1_.updated_by_id AS updated_by_id_17 FROM post p0_ LEFT JOIN comment c1_ ON p0_.id = c1_.post_id AND (c1_.is_approved = 1) WHERE p0_.is_published = ? AND p0_.post_at <= ? ORDER BY p0_.post_at DESC LIMIT 3
Parameters:
[ 1 "2026-01-09 16:15:35" ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Post | 3 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Post | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\User | No errors. |