GET https://kspd.z2d.nl/en/duurzaamheid

Query Metrics

25 Database Queries
8 Different statements
12.43 ms Query time
0 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 1.42 ms
SELECT c0_.id AS id_0, c1_.page_layout AS page_layout_1, c1_.meta_description AS meta_description_2, c1_.meta_author AS meta_author_3, c1_.primary_image AS primary_image_4 FROM cms_page c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (?)
Parameters:
[
  127
]
2 0.65 ms
SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = ?
Parameters:
[
  5
]
3 0.58 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  6
]
4 0.62 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  89
]
5 0.92 ms
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.name AS name_2, c0_.permalink AS permalink_3, c0_.search_text AS search_text_4, c1_.id AS id_5, c2_.id AS id_6, c0_.content_entry_revision_id AS content_entry_revision_id_7 FROM cms_content_entry_revision_translation c0_ LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id WHERE c0_.content_entry_revision_id IN (?) AND c0_.locale = ?
Parameters:
[
  89
  "en"
]
6 0.59 ms
SELECT c0_.id AS id_0, c1_.`values` AS values_1 FROM cms_custom_content_entry_revision c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (?)
Parameters:
[
  89
]
7 0.58 ms
SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  2
  1
  3
  4
  5
  6
]
8 0.54 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  5
]
9 0.29 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  87
]
10 0.34 ms
SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = ?
Parameters:
[
  18
]
11 0.30 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  127
]
12 0.36 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  4
]
13 0.32 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.30 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  134
]
15 0.41 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 0.42 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  112
]
17 0.40 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  11
]
18 0.32 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  125
]
19 0.33 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  12
]
20 0.23 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  128
]
21 0.56 ms
SELECT c0_.permalink AS permalink_0, c1_.type AS type_1 FROM cms_content_entry c1_ LEFT JOIN cms_content_entry_revision c2_ ON c1_.published_revision_id = c2_.id LEFT JOIN cms_content_entry_revision_translation c0_ ON c2_.id = c0_.content_entry_revision_id WHERE c0_.locale = ? AND c1_.id = ?
Parameters:
[
  "en"
  12
]
22 0.72 ms
SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = ?
Parameters:
[
  17
]
23 0.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.depth AS depth_4, t0.`left` AS left_5, t0.`right` AS right_6, t0.is_deleted AS is_deleted_7, t0.restrict_sites AS restrict_sites_8, t0.time_created AS time_created_9, t0.time_published AS time_published_10, t0.time_deleted AS time_deleted_11, t0.published_revision_id AS published_revision_id_12, t0.draft_revision_id AS draft_revision_id_13, t0.parent_id AS parent_id_14 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  14
]
24 0.30 ms
SELECT t0.id AS id_1, t0.is_published_revision AS is_published_revision_2, t0.time_created AS time_created_3, t0.autosave AS autosave_4, t0.content_entry_id AS content_entry_id_5, t0.author_id AS author_id_6 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  129
]
25 0.43 ms
SELECT c0_.permalink AS permalink_0, c1_.type AS type_1 FROM cms_content_entry c1_ LEFT JOIN cms_content_entry_revision c2_ ON c1_.published_revision_id = c2_.id LEFT JOIN cms_content_entry_revision_translation c0_ ON c2_.id = c0_.content_entry_revision_id WHERE c0_.locale = ? AND c1_.id = ?
Parameters:
[
  "en"
  14
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Cms\CmsBundle\Entity\ContentEntryRevision 11
Cms\CmsBundle\Entity\ContentEntry 8
Cms\CmsBundle\Entity\Upload 8
Cms\CmsBundle\Entity\Admin 2
Cms\CmsBundle\Entity\ContentEntryRevisionTranslation 1