Query Metrics
4
Database Queries
4
Different statements
2.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.16 ms (52.08%) |
1 |
SELECT c0_.deleted_at AS deleted_at_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.id AS id_3, c0_.entry_date AS entry_date_4, c0_.title AS title_5, c0_.enable AS enable_6, c0_.content AS content_7, c0_.description AS description_8, c0_.link_url AS link_url_9, c0_.link_new_tab AS link_new_tab_10, c0_.publish_date AS publish_date_11, c0_.close_date AS close_date_12, c0_.category_id AS category_id_13 FROM cms_news_entry c0_ WHERE (c0_.enable = 1 AND (c0_.publish_date IS NULL OR c0_.publish_date <= ?) AND (c0_.close_date IS NULL OR c0_.close_date >= ?) AND c0_.id = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.entry_date DESC, c0_.id DESC
Parameters:
[ "2025-11-29 02:41:55" "2025-11-29 02:41:55" 4 ] |
|
0.69 ms (30.76%) |
1 |
SELECT t0.deleted_at AS deleted_at_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.sort AS sort_5, t0.headline AS headline_6, t0.image AS image_7, t0.image_width AS image_width_8, t0.image_height AS image_height_9, t0.content AS content_10, t0.youtube_id AS youtube_id_11, t0.entry_id AS entry_id_12 FROM cms_news_child t0 WHERE t0.entry_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.sort ASC, t0.id DESC
Parameters:
[
4
]
|
|
0.32 ms (14.26%) |
1 |
SELECT c0_.deleted_at AS deleted_at_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.id AS id_3, c0_.entry_date AS entry_date_4, c0_.title AS title_5, c0_.enable AS enable_6, c0_.content AS content_7, c0_.description AS description_8, c0_.link_url AS link_url_9, c0_.link_new_tab AS link_new_tab_10, c0_.publish_date AS publish_date_11, c0_.close_date AS close_date_12, c0_.category_id AS category_id_13 FROM cms_news_entry c0_ WHERE (c0_.enable = 1 AND (c0_.publish_date IS NULL OR c0_.publish_date <= ?) AND (c0_.close_date IS NULL OR c0_.close_date >= ?)) AND (c0_.deleted_at IS NULL) ORDER BY c0_.entry_date DESC, c0_.id DESC
Parameters:
[ "2025-11-29 02:41:55" "2025-11-29 02:41:55" ] |
|
0.06 ms (2.90%) |
1 |
SELECT t0.deleted_at AS deleted_at_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.enable AS enable_6, t0.sort AS sort_7 FROM cms_news_category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
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\News\Entry | No errors. |
| App\Entity\News\Category | No errors. |
| App\Entity\News\Child | No errors. |