GET https://kieran-test.4bis-dev.nl/en/blog

Query Metrics

66 Database Queries
14 Different statements
1510.53 ms Query time
0 Invalid entities
161 Managed entities
34 Cache hits
66 Cache misses
100 Cache puts

Grouped Statements

Show all queries

Time Count Info
335.14 ms
(22.19%)
14
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.disable_page AS disable_page_11, t0.title AS title_12, t0.excerpt AS excerpt_13, t0.content AS content_14, t0.description AS description_15, t0.author AS author_16, t0.seo_title AS seo_title_17, t0.field_values AS field_values_18, t0.url AS url_19, t0.full_url AS full_url_20, t0.public AS public_21, t0.locale AS locale_22, t0.lookup_url_id AS lookup_url_id_23, t0.translatable_id AS translatable_id_24 FROM cms_post_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
  33
]
290.28 ms
(19.22%)
13
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.extension AS extension_13, t0.webdav_path AS webdav_path_14, t0.public_url AS public_url_15, t0.public_path AS public_path_16, t0.size AS size_17, t0.file_name AS file_name_18, t0.public AS public_19, t0.alt AS alt_20 FROM cms_media t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
  60
]
233.66 ms
(15.47%)
7
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.content AS content_11, t0.description AS description_12, t0.title AS title_13, t0.seo_title AS seo_title_14, t0.url AS url_15, t0.full_url AS full_url_16, t0.public AS public_17, t0.locale AS locale_18, t0.lookup_url_id AS lookup_url_id_19, t0.translatable_id AS translatable_id_20 FROM cms_page_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
  6
]
154.30 ms
(10.22%)
7
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.private AS private_13, t0.parent_page_id AS parent_page_id_14 FROM cms_page t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "home"
]
136.56 ms
(9.04%)
6
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12 FROM cms_block t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "head-javascripts"
]
107.21 ms
(7.10%)
6
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.content AS content_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM cms_block_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
  37
]
74.22 ms
(4.91%)
4
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.value AS value_13, t0.default_setting_id AS default_setting_id_14, t0.description AS description_15 FROM cms_setting t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "primarylanguage"
]
42.95 ms
(2.84%)
2
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.private AS private_13, t0.parent_page_id AS parent_page_id_14 FROM cms_page t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
  6
]
40.09 ms
(2.65%)
2
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.extension AS extension_13, t0.webdav_path AS webdav_path_14, t0.public_url AS public_url_15, t0.public_path AS public_path_16, t0.size AS size_17, t0.file_name AS file_name_18, t0.public AS public_19, t0.alt AS alt_20 FROM cms_media t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "favicon"
]
22.52 ms
(1.49%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.content AS content_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM cms_post_excerpt_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
  4
]
19.06 ms
(1.26%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.content AS content_11, t0.description AS description_12, t0.title AS title_13, t0.seo_title AS seo_title_14, t0.url AS url_15, t0.full_url AS full_url_16, t0.public AS public_17, t0.locale AS locale_18, t0.lookup_url_id AS lookup_url_id_19, t0.translatable_id AS translatable_id_20 FROM cms_page_translation t0 WHERE t0.uuid = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "6d29c9c1-f50f-11eb-a902-f615c056d74b"
]
18.94 ms
(1.25%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.post_type_id AS post_type_id_13 FROM cms_post_excerpt t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "post-format"
]
18.17 ms
(1.20%)
1
SELECT c0_.id AS id_0, c0_.active AS active_1, c0_.deleted_at AS deleted_at_2, c0_.uuid AS uuid_3, c0_.created_by AS created_by_4, c0_.updated_by AS updated_by_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.version AS version_8, c0_.data AS data_9, c0_.slug AS slug_10, c0_.name AS name_11, c0_.published_at AS published_at_12, c0_.post_type_id AS post_type_id_13, c0_.category_gallery_id AS category_gallery_id_14, c0_.primary_category_id AS primary_category_id_15, c0_.featured_media_id AS featured_media_id_16 FROM cms_post c0_ WHERE (c0_.deleted_at IS NULL AND c0_.published_at < ? AND c0_.deleted_at IS NULL) AND ((c0_.deleted_at IS NULL OR c0_.deleted_at > CURRENT_TIMESTAMP)) ORDER BY c0_.published_at DESC
Parameters:
[
  "2026-06-23 03:04:31"
]
17.45 ms
(1.16%)
1
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.url AS url_11, t0.locale AS locale_12, t0.urlable_class AS urlable_class_13, t0.urlable_uuid AS urlable_uuid_14, t0.public AS public_15 FROM cms_url t0 WHERE t0.locale = ? AND t0.url = ? AND t0.deleted_at IS NULL AND t0.public = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
  "en"
  "/blog"
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

34 Hits
66 Misses
100 Puts

Number of cache hits

Region Hits
fourbis_cmsbundle_entity_post_postexcerpt 26
fourbis_cmsbundle_entity_page 8

Number of cache misses

Region Misses
fourbis_cmsbundle_entity_setting 4
fourbis_cmsbundle_entity_url 1
fourbis_cmsbundle_entity_pagetranslation 1
fourbis_cmsbundle_entity_page 9
fourbis_cmsbundle_entity_page__translations 7
fourbis_cmsbundle_entity_media 15
fourbis_cmsbundle_entity_block 6
fourbis_cmsbundle_entity_block__translations 6
query_cache_region 1
fourbis_cmsbundle_entity_post_postexcerpt 1
fourbis_cmsbundle_entity_post_post__translations 14
fourbis_cmsbundle_entity_post_postexcerpt__translations 1

Number of cache puts

Region Puts
fourbis_cmsbundle_entity_setting 8
fourbis_cmsbundle_entity_url 2
fourbis_cmsbundle_entity_pagetranslation 2
fourbis_cmsbundle_entity_page 14
fourbis_cmsbundle_entity_page__translations 7
fourbis_cmsbundle_entity_media 17
fourbis_cmsbundle_entity_block 12
fourbis_cmsbundle_entity_block__translations 6
fourbis_cmsbundle_entity_post_post 14
query_cache_region 1
fourbis_cmsbundle_entity_post_postexcerpt 2
fourbis_cmsbundle_entity_post_post__translations 14
fourbis_cmsbundle_entity_post_postexcerpt__translations 1

Managed Entities

default entity manager

Class Amount of managed objects
Fourbis\CmsBundle\Entity\Url 42
Fourbis\CmsBundle\Entity\Post\PostTranslation 28
Fourbis\CmsBundle\Entity\Media 15
Fourbis\CmsBundle\Entity\PageTranslation 14
Fourbis\CmsBundle\Entity\Post\Post 14
Fourbis\CmsBundle\Entity\Post\PostCategoryGallery 14
Fourbis\CmsBundle\Entity\BlockTranslation 12
Fourbis\CmsBundle\Entity\Page 7
Fourbis\CmsBundle\Entity\Block 6
Fourbis\CmsBundle\Entity\Setting 4
Fourbis\CmsBundle\Entity\Post\PostType 2
Fourbis\CmsBundle\Entity\Post\PostExcerptTranslation 2
Fourbis\CmsBundle\Entity\Post\PostExcerpt 1