Query Metrics
1
Database Queries
1
Different statements
1.07 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.07 ms (100.00%) |
1 |
SELECT c0_.add_life AS add_life_0, c0_.add_top AS add_top_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.deleted_at AS deleted_at_4, c0_.id AS id_5, c0_.entry_date AS entry_date_6, c0_.title AS title_7, c0_.title_en AS title_en_8, c0_.title_cn AS title_cn_9, c0_.title_tw AS title_tw_10, c0_.enable AS enable_11, c0_.pub_date AS pub_date_12, c0_.close_date AS close_date_13, c0_.main_img AS main_img_14, c0_.main_img_width AS main_img_width_15, c0_.main_img_height AS main_img_height_16, c0_.thumbnail AS thumbnail_17, c0_.description AS description_18, c0_.link_url AS link_url_19, c0_.link_newtab AS link_newtab_20, c0_.content AS content_21, c0_.content_en AS content_en_22, c0_.content_cn AS content_cn_23, c0_.content_tw AS content_tw_24, c0_.category_id AS category_id_25 FROM cms_news_entry c0_ LEFT JOIN cms_news_category c1_ ON (c0_.category_id = c1_.id) AND (c1_.deleted_at IS NULL) LEFT JOIN cms_news_category c2_ ON (c0_.category_id = c2_.id) AND (c2_.deleted_at IS NULL) WHERE (c1_.is_topics = 1 AND c0_.enable = ? AND (c0_.pub_date IS NULL OR c0_.pub_date <= ?) AND (c0_.close_date IS NULL OR c0_.close_date >= ?) AND c2_.enable = ?) AND (c0_.deleted_at IS NULL) ORDER BY c0_.add_top DESC, c0_.entry_date DESC, c0_.id DESC LIMIT 4
Parameters:
[ 1 "2026-01-03 04:05:32" "2026-01-03 04:05:32" 1 ] |
aws connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| aws | doctrine.dbal.aws_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\Account\ApiToken | No errors. |
| App\Entity\News\Entry | No errors. |
| App\Entity\News\Category | No errors. |
| App\Entity\News\Child | No errors. |