GET https://www.kspd.z2d.nl/

Query Metrics

43 Database Queries
9 Different statements
17.19 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

# Time Info
1 1.17 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:
[
  134
]
2 1.11 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:
[
  1
  2
  3
]
3 0.73 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:
[
  10
]
4 0.71 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:
[
  78
]
5 0.81 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:
[
  78
  "nl"
]
6 0.53 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:
[
  78
]
7 0.50 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:
[
  5
]
8 0.49 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
]
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:
[
  89
]
10 0.26 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:
[
  7
]
11 0.26 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:
[
  76
]
12 0.27 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:
[
  9
]
13 0.26 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:
[
  77
]
14 0.28 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
]
15 0.24 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
]
16 0.43 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
  "nl"
]
17 0.29 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
]
18 0.39 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
]
19 0.50 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:
[
  76
  "nl"
]
20 0.25 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:
[
  76
]
21 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 IN (?)
Parameters:
[
  3
]
22 0.39 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:
[
  77
  "nl"
]
23 0.24 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:
[
  77
]
24 0.29 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:
[
  4
]
25 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 IN (?)
Parameters:
[
  5
]
26 0.44 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
]
27 0.31 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:
[
  3
]
28 0.28 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:
[
  4
]
29 0.33 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:
[
  5
]
30 0.30 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
]
31 0.28 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
]
32 0.40 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
]
33 0.27 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
]
34 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
]
35 0.31 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
]
36 0.26 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
]
37 0.30 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
]
38 0.24 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
]
39 0.34 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
]
40 0.26 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
]
41 0.54 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
]
42 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:
[
  14
]
43 0.25 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
]

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 14
Cms\CmsBundle\Entity\ContentEntry 11
Cms\CmsBundle\Entity\Upload 8
Cms\CmsBundle\Entity\ContentEntryRevisionTranslation 4
Cms\CmsBundle\Entity\Admin 2