Query Metrics
38
Database Queries
9
Different statements
10.00 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.61 ms (36.11%) |
20 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_url AS page_url_3, t0.created AS created_4, t0.modified AS modified_5, t0.sjabloon_id AS sjabloon_id_6, t7.id AS id_8, t7.name AS name_9, t7.uitleg AS uitleg_10, t7.code AS code_11, t7.sequence AS sequence_12, t7.access AS access_13, t7.created AS created_14, t7.modified AS modified_15, t7.modified_by_id AS modified_by_id_16, t7.created_by_id AS created_by_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM sjabloon_content t0 LEFT JOIN sjabloon t7 ON t0.sjabloon_id = t7.id WHERE t0.id = ?
Parameters:
[
2
]
|
2.77 ms (27.68%) |
2 |
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.archived_at IS NULL OR t0.archived_at > ?) AND t0.head_menu = ?) AND t0.published_at < ?)
Parameters:
[ "2024-12-25 01:04:21" 1 "2024-12-25 01:04:21" ] |
1.65 ms (16.48%) |
7 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.access AS access_3, t0.page_id AS page_id_4, t5.id AS id_6, t5.name AS name_7, t5.slug AS slug_8, t5.head_menu AS head_menu_9, t5.meta_title AS meta_title_10, t5.meta_description AS meta_description_11, t5.meta_keywords AS meta_keywords_12, t5.sequence AS sequence_13, t5.created AS created_14, t5.modified AS modified_15, t5.published_at AS published_at_16, t5.archived_at AS archived_at_17, t5.parent_page_id AS parent_page_id_18, t5.created_by_id AS created_by_id_19, t5.modified_by_id AS modified_by_id_20, t0.sjabloon_content_id AS sjabloon_content_id_21 FROM page_sjabloon_content t0 INNER JOIN page t5 ON t0.page_id = t5.id WHERE t0.page_id = ? ORDER BY t0.sequence ASC
Parameters:
[
1
]
|
0.53 ms (5.28%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url_name AS url_name_3, t0.img_teaser AS img_teaser_4, t0.teaser AS teaser_5, t0.content AS content_6, t0.img_header AS img_header_7, t0.sequence AS sequence_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.meta_keywords AS meta_keywords_11, t0.published_at AS published_at_12, t0.archived_at AS archived_at_13, t0.created AS created_14, t0.modified AS modified_15, t0.article_category_id AS article_category_id_16, t0.created_by_id AS created_by_id_17, t0.modified_by_id AS modified_by_id_18 FROM article t0 WHERE t0.article_category_id = ? ORDER BY t0.sequence ASC
Parameters:
[
1
]
|
0.40 ms (3.96%) |
2 |
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 ] |
0.32 ms (3.23%) |
1 |
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
]
|
0.31 ms (3.07%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM article_category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Producten"
]
|
0.24 ms (2.40%) |
1 |
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 2 4 6 7 46 53 ] |
0.18 ms (1.80%) |
1 |
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:
[ 8 51 ] |
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\Language | No errors. |
App\Entity\User | No errors. |
App\Entity\Page | No errors. |
App\Entity\PageSjabloonContent | No errors. |
App\Entity\SjabloonContent | No errors. |
App\Entity\Sjabloon | No errors. |
App\Entity\SjabloonContentValue | No errors. |
App\Entity\SjabloonField | No errors. |
App\Entity\Source | No errors. |
App\Entity\ArticleCategory | No errors. |
App\Entity\Article | No errors. |
App\Entity\UserProfile | No errors. |
App\Entity\SjabloonFieldValueParent | No errors. |
App\Entity\SjabloonFieldValueTiny | No errors. |
App\Entity\SjabloonFieldValueString | No errors. |
App\Entity\SjabloonFieldValueImage | No errors. |
App\Entity\SjabloonFieldValueFile | No errors. |
App\Entity\SjabloonFieldValueText | No errors. |
App\Entity\SjabloonFieldValueNum | No errors. |
App\Entity\SjabloonFieldValueSjabloonContent | No errors. |
App\Entity\SjabloonFieldValueModule | No errors. |
App\Entity\SjabloonFieldValueCollection | No errors. |
App\Entity\SjabloonFieldSpecification | No errors. |