Query Metrics
6
Database Queries
5
Different statements
1.43 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.45 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.head_menu AS head_menu_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.sequence AS sequence_7, p0_.created AS created_8, p0_.modified AS modified_9, p0_.published_at AS published_at_10, p0_.archived_at AS archived_at_11, p0_.parent_page_id AS parent_page_id_12, p0_.created_by_id AS created_by_id_13, p0_.modified_by_id AS modified_by_id_14 FROM page p0_ WHERE p0_.head_menu = 1 AND p0_.parent_page_id IS NULL AND p0_.published_at < ? AND (p0_.archived_at > ? OR p0_.archived_at IS NULL) ORDER BY p0_.sequence ASC
Parameters:
[ "2024-12-22 17:07:01" "2024-12-22 17:07:01" ] |
2 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.head_menu AS head_menu_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.sequence AS sequence_8, t0.created AS created_9, t0.modified AS modified_10, t0.published_at AS published_at_11, t0.archived_at AS archived_at_12, t0.parent_page_id AS parent_page_id_13, t0.created_by_id AS created_by_id_14, t0.modified_by_id AS modified_by_id_15 FROM page t0 WHERE t0.parent_page_id IN (?, ?, ?, ?, ?, ?, ?) ORDER BY t0.sequence ASC
Parameters:
[ 1 4 2 7 53 6 46 ] |
3 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.head_menu AS head_menu_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.sequence AS sequence_8, t0.created AS created_9, t0.modified AS modified_10, t0.published_at AS published_at_11, t0.archived_at AS archived_at_12, t0.parent_page_id AS parent_page_id_13, t0.created_by_id AS created_by_id_14, t0.modified_by_id AS modified_by_id_15 FROM page t0 WHERE t0.parent_page_id IN (?, ?, ?) ORDER BY t0.sequence ASC
Parameters:
[ 60 61 62 ] |
4 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.head_menu AS head_menu_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.sequence AS sequence_8, t0.created AS created_9, t0.modified AS modified_10, t0.published_at AS published_at_11, t0.archived_at AS archived_at_12, t0.parent_page_id AS parent_page_id_13, t0.created_by_id AS created_by_id_14, t0.modified_by_id AS modified_by_id_15 FROM page t0 WHERE t0.parent_page_id IN (?, ?, ?) ORDER BY t0.sequence ASC
Parameters:
[ 63 64 66 ] |
5 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.shortcode AS shortcode_4, t0.sequence AS sequence_5, t0.main AS main_6, t0.flag_icon_code AS flag_icon_code_7, t0.published_at AS published_at_8, t0.archived_at AS archived_at_9, t0.created AS created_10, t0.modified AS modified_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13 FROM language t0 WHERE t0.main = ?
Parameters:
[
1
]
|
6 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.shortcode AS shortcode_4, t0.sequence AS sequence_5, t0.main AS main_6, t0.flag_icon_code AS flag_icon_code_7, t0.published_at AS published_at_8, t0.archived_at AS archived_at_9, t0.created AS created_10, t0.modified AS modified_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13 FROM language 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Page | No errors. |
App\Entity\User | No errors. |
App\Entity\PageSjabloonContent | No errors. |
App\Entity\Language | No errors. |