Query Metrics
3
Database Queries
3
Different statements
5.00 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.22 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (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_.main_image AS main_image_9, c0_.main_image_width AS main_image_width_10, c0_.main_image_height AS main_image_height_11, c0_.thumbnail AS thumbnail_12, c0_.link_url AS link_url_13, c0_.link_new_tab AS link_new_tab_14, c0_.publish_date AS publish_date_15, c0_.close_date AS close_date_16 FROM column_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) dctrn_result) dctrn_table
Parameters:
[ "2025-12-15 06:26:02" "2025-12-15 06:26:02" ] |
| 2 | 0.38 ms |
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, entry_date_4 FROM (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_.main_image AS main_image_9, c0_.main_image_width AS main_image_width_10, c0_.main_image_height AS main_image_height_11, c0_.thumbnail AS thumbnail_12, c0_.link_url AS link_url_13, c0_.link_new_tab AS link_new_tab_14, c0_.publish_date AS publish_date_15, c0_.close_date AS close_date_16 FROM column_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)) dctrn_result_inner ORDER BY entry_date_4 DESC, id_3 DESC) dctrn_result LIMIT 12
Parameters:
[ "2025-12-15 06:26:02" "2025-12-15 06:26:02" ] |
| 3 | 0.41 ms |
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_.main_image AS main_image_9, c0_.main_image_width AS main_image_width_10, c0_.main_image_height AS main_image_height_11, c0_.thumbnail AS thumbnail_12, c0_.link_url AS link_url_13, c0_.link_new_tab AS link_new_tab_14, c0_.publish_date AS publish_date_15, c0_.close_date AS close_date_16 FROM column_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 IN (?, ?, ?, ?, ?, ?, ?, ?)) AND (c0_.deleted_at IS NULL) ORDER BY c0_.entry_date DESC, c0_.id DESC
Parameters:
[ "2025-12-15 06:26:02" "2025-12-15 06:26:02" 8 7 13 4 6 5 3 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\Column\Entry | No errors. |
| App\Entity\Column\Child | No errors. |