GET https://gors.boldrdev.nl/diensten/dagbesteding

Query Metrics

68 Database Queries
9 Different statements
28.03 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.03 ms
(25.09%)
28
SELECT t0.id AS id_1, t0.type AS type_2, t0.sort_order AS sort_order_3, t0.is_deleted AS is_deleted_4, t0.restrict_sites AS restrict_sites_5, t0.time_created AS time_created_6, t0.time_published AS time_published_7, t0.time_deleted AS time_deleted_8, t0.published_revision_id AS published_revision_id_9, t0.draft_revision_id AS draft_revision_id_10 FROM cms_content_entry t0 WHERE t0.id = ?
Parameters:
[
  4
]
6.28 ms
(22.41%)
28
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.parent_id AS parent_id_6, t0.author_id AS author_id_7 FROM cms_content_entry_revision t0 WHERE t0.id = ?
Parameters:
[
  1107
]
4.38 ms
(15.64%)
1
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:
[
  854
  740
  741
  742
  743
]
3.59 ms
(12.82%)
6
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.public_storage AS public_storage_8, t0.public_storage_identifier AS public_storage_identifier_9, t0.width AS width_10, t0.height AS height_11, t0.derivatives AS derivatives_12, t0.enqueued_derivatives AS enqueued_derivatives_13, t0.folder_id AS folder_id_14 FROM cms_upload t0 WHERE t0.id = ?
Parameters:
[
  195
]
3.47 ms
(12.39%)
1
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cms_content_entry_revision c0_ LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id WHERE c0_.is_published_revision = 1 AND c1_.type = ? AND c2_.locale = ? AND c0_.parent_id = ?
Parameters:
[
  "gors.service_sub"
  "nl"
  5
]
1.11 ms
(3.95%)
1
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:
[
  1107
]
0.88 ms
(3.14%)
1
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:
[
  854
  740
  741
  742
  743
  "nl"
]
0.85 ms
(3.04%)
1
SELECT c0_.id AS id_0, c0_.is_published_revision AS is_published_revision_1, c0_.time_created AS time_created_2, c0_.autosave AS autosave_3, c1_.id AS id_4, c1_.type AS type_5, c1_.sort_order AS sort_order_6, c1_.is_deleted AS is_deleted_7, c1_.restrict_sites AS restrict_sites_8, c1_.time_created AS time_created_9, c1_.time_published AS time_published_10, c1_.time_deleted AS time_deleted_11, c0_.content_entry_id AS content_entry_id_12, c0_.parent_id AS parent_id_13, c0_.author_id AS author_id_14, c1_.published_revision_id AS published_revision_id_15, c1_.draft_revision_id AS draft_revision_id_16 FROM cms_content_entry_revision c0_ LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id WHERE c0_.is_published_revision = 1 AND c1_.type = ? AND c2_.locale = ? AND c0_.parent_id = ? ORDER BY c1_.sort_order ASC
Parameters:
[
  "gors.service_sub"
  "nl"
  5
]
0.43 ms
(1.53%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.published AS published_5, t0.deleted AS deleted_6, t0.image_id AS image_id_7 FROM quality_report t0 WHERE t0.id = ?
Parameters:
[
  "6"
]

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.