GET https://www.dnaklik.nl/sitemap.xml

Query Metrics

38 Database Queries
9 Different statements
10.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.