Query Metrics
3
Database Queries
3
Different statements
1.27 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.85 ms |
SELECT c0_.to_corporate AS to_corporate_0, c0_.to_home AS to_home_1, c0_.to_style AS to_style_2, c0_.canonical AS canonical_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.deleted_at AS deleted_at_6, c0_.id AS id_7, c0_.entry_date AS entry_date_8, c0_.title AS title_9, c0_.enable AS enable_10, c0_.pub_date AS pub_date_11, c0_.close_date AS close_date_12, c0_.main_img AS main_img_13, c0_.main_img_width AS main_img_width_14, c0_.main_img_height AS main_img_height_15, c0_.thumbnail AS thumbnail_16, c0_.description AS description_17, c0_.link_url AS link_url_18, c0_.link_newtab AS link_newtab_19, c0_.content AS content_20, c0_.category_id AS category_id_21 FROM cms_news_entry c0_ LEFT JOIN cms_news_category c1_ ON (c0_.category_id = c1_.id) WHERE c0_.id = ? AND c0_.enable = ? AND (c0_.pub_date IS NULL OR c0_.pub_date <= ?) AND (c0_.close_date IS NULL OR c0_.close_date >= ?) AND c1_.enable = ?
Parameters:
|
2 | 0.09 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_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 = ?
Parameters:
|
3 | 0.33 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.headline AS headline_5, t0.image AS image_6, t0.image_width AS image_width_7, t0.image_height AS image_height_8, t0.content AS content_9, t0.sort AS sort_10, t0.image_alt AS image_alt_11, t0.entry_id AS entry_id_12 FROM cms_news_child t0 WHERE t0.entry_id = ? ORDER BY t0.sort ASC
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.
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. |