Query Metrics
3
Database Queries
3
Different statements
1.64 ms
Query time
0
Invalid entities
17
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.84 ms |
SELECT p.path FROM `page_revision` pr JOIN `page` p on p.id = pr.page_id WHERE p.published IS NOT NULL AND p.published < UTC_TIMESTAMP() AND p.dynamic = 1 AND (p.homepage IS NULL OR p.homepage = 0) AND ( SELECT pr_sub.id FROM `page_revision` pr_sub WHERE pr_sub.page_id = p.id AND pr_sub.published = 1 ORDER BY pr_sub.updated_at DESC LIMIT 1 ) = pr.id AND pr.template = ?
Parameters:
[
"App\Form\Page\NewsPage"
]
|
||||||||||||||||||||||||||
| 2 | 0.53 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.author AS author_2, a0_.snippet AS snippet_3, a0_.content AS content_4, a0_.published_at AS published_at_5, a0_.created_at AS created_at_6, a0_.created_by AS created_by_7, a0_.updated_at AS updated_at_8, a0_.updated_by AS updated_by_9, a0_.slug AS slug_10, a0_.image_id AS image_id_11 FROM article a0_ WHERE a0_.published_at IS NOT NULL AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 24
Parameters:
[
"2025-12-06 05:23:48"
]
|
||||||||||||||||||||||||||
| 3 | 0.27 ms |
SELECT t0.id AS id_1, t0.value AS value_2 FROM setting t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| OHMedia\SettingsBundle\Entity\Setting | 7 |
| OHMedia\NewsBundle\Entity\Article | 5 |
| OHMedia\FileBundle\Entity\File | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| OHMedia\NewsBundle\Entity\Article | No errors. |
| OHMedia\FileBundle\Entity\File | No errors. |
| OHMedia\NewsBundle\Entity\ArticleTag | No errors. |
| OHMedia\SettingsBundle\Entity\Setting | No errors. |