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

Query Metrics

25 Database Queries
7 Different statements
18.17 ms Query time
0 Invalid entities
26 Managed entities

Queries

Group similar statements

# Time Info
1 1.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"
  9
]
2 0.77 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
]
3 0.84 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
]
4 1.07 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"
]
5 0.89 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:
[
  4
]
6 0.93 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
]
7 1.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:
[
  5
]
8 0.68 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
]
9 0.71 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
]
10 0.77 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
]
11 0.59 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:
[
  2
]
12 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:
[
  1
]
13 0.48 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
]
14 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:
[
  3
]
15 0.43 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
]
16 0.42 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
]
17 0.37 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
]
18 0.51 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
]
19 0.46 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
]
20 0.78 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
]
21 0.38 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
]
22 1.04 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"
  9
]
23 0.89 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
]
24 0.66 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
]
25 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:
[
  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 11
Cms\CmsBundle\Entity\ContentEntry 9
Cms\CmsBundle\Entity\Upload 3
Cms\CmsBundle\Entity\Admin 2
Cms\CmsBundle\Entity\ContentEntryRevisionTranslation 1