Redirect 301 redirect from GET @cms_page (7c6935)

GET https://kieran-test.4bis-dev.nl/sitemap.xml/

Query Metrics

6 Database Queries
5 Different statements
118.58 ms Query time
0 Invalid entities
3 Managed entities
0 Cache hits
2 Cache misses
4 Cache puts

Queries

Group similar statements

# Time Info
1 22.42 ms
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:
[
  "languages"
]
2 21.51 ms
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_.from AS from_10, c0_.to AS to_11, c0_.pass_parameters AS pass_parameters_12, c0_.match_any_from_start AS match_any_from_start_13, c0_.status_code AS status_code_14, c0_.is_wildcard AS is_wildcard_15 FROM cms_redirect c0_ WHERE (((c0_.match_any_from_start = 1 AND ? LIKE CONCAT(c0_.from, '%')) OR c0_.from = ?) AND c0_.deleted_at IS NULL) AND ((c0_.deleted_at IS NULL OR c0_.deleted_at > CURRENT_TIMESTAMP))
Parameters:
[
  "/sitemap.xml/"
  "/sitemap.xml/"
]
3 15.61 ms
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_.url AS url_10, c0_.locale AS locale_11, c0_.urlable_class AS urlable_class_12, c0_.urlable_uuid AS urlable_uuid_13, c0_.public AS public_14 FROM cms_url c0_ WHERE (c0_.public = 1 AND c0_.url LIKE ? AND c0_.deleted_at IS NULL) AND ((c0_.deleted_at IS NULL OR c0_.deleted_at > CURRENT_TIMESTAMP))
Parameters:
[
  "%/sitemap.xml"
]
4 18.10 ms
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"
]
5 22.97 ms
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"
  "/sitemap.xml"
  1
]
6 17.97 ms
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_.url AS url_10, c0_.locale AS locale_11, c0_.urlable_class AS urlable_class_12, c0_.urlable_uuid AS urlable_uuid_13, c0_.public AS public_14 FROM cms_url c0_ WHERE (c0_.public = 1 AND c0_.url LIKE ? AND c0_.locale = ? AND c0_.deleted_at IS NULL) AND ((c0_.deleted_at IS NULL OR c0_.deleted_at > CURRENT_TIMESTAMP))
Parameters:
[
  "%/"
  "en"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
2 Misses
4 Puts

Number of cache misses

Region Misses
fourbis_cmsbundle_entity_setting 2

Number of cache puts

Region Puts
fourbis_cmsbundle_entity_setting 4

Managed Entities

default entity manager

Class Amount of managed objects
Fourbis\CmsBundle\Entity\Setting 2
Fourbis\CmsBundle\Entity\Url 1