GET https://nd-haefen.jaf-systems.de/sitemap.xml

Query Metrics

98 Database Queries
50 Different statements
53.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.40 ms
(25.00%)
47
SELECT DATABASE()
Parameters:
[]
11.99 ms
(22.38%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.path LIKE '/cmf/nd-haefen/contents/%' OR n0.path = '/cmf/nd-haefen/contents') ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
2.84 ms
(5.30%)
2
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[]
1.40 ms
(2.61%)
1
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
  "default_live"
]
1.38 ms
(2.58%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/kontakte/ansprechpartner' LIMIT 1
Parameters:
[
  "default_live"
]
1.20 ms
(2.23%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/hafenbetrieb' LIMIT 1
Parameters:
[
  "default_live"
]
1.05 ms
(1.96%)
2
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/kontakte/anfahrt' LIMIT 1
Parameters:
[
  "default_live"
]
0.82 ms
(1.53%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/datenschutz' LIMIT 1
Parameters:
[
  "default_live"
]
0.82 ms
(1.52%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.identifier = '606ccc7f-eebb-40e1-b8d9-24d9de569571' ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
  "default_live"
]
0.72 ms
(1.35%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/news-presse' LIMIT 1
Parameters:
[
  "default_live"
]
0.72 ms
(1.34%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/unsere-beteiligungen/rheincargo-die-clevere-kombination' LIMIT 1
Parameters:
[
  "default_live"
]
0.71 ms
(1.32%)
1
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[]
0.69 ms
(1.28%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/service/angelschein' LIMIT 1
Parameters:
[
  "default_live"
]
0.56 ms
(1.04%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/kontakte' LIMIT 1
Parameters:
[
  "default_live"
]
0.55 ms
(1.03%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/immobilien' LIMIT 1
Parameters:
[
  "default_live"
]
0.53 ms
(0.98%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents' LIMIT 1
Parameters:
[
  "default_live"
]
0.52 ms
(0.96%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen' LIMIT 1
Parameters:
[
  "default_live"
]
0.51 ms
(0.95%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/mitarbeiter-portraits/marius-klann' LIMIT 1
Parameters:
[
  "default_live"
]
0.50 ms
(0.93%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/ausbildung-im-hafen' LIMIT 1
Parameters:
[
  "default_live"
]
0.49 ms
(0.91%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/unsere-beteiligungen/hafen-duesseldorf-reisholz-anschluss-fuer-den-duesseldorfer-sueden' LIMIT 1
Parameters:
[
  "default_live"
]
0.49 ms
(0.91%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/bahnbetrieb' LIMIT 1
Parameters:
[
  "default_live"
]
0.48 ms
(0.89%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/anfahrt' LIMIT 1
Parameters:
[
  "default_live"
]
0.47 ms
(0.88%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/service' LIMIT 1
Parameters:
[
  "default_live"
]
0.47 ms
(0.87%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/unsere-beteiligungen' LIMIT 1
Parameters:
[
  "default_live"
]
0.47 ms
(0.87%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/mitarbeiter-portraits' LIMIT 1
Parameters:
[
  "default_live"
]
0.47 ms
(0.87%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/mitarbeiter-portraits/nicole-faustmann' LIMIT 1
Parameters:
[
  "default_live"
]
0.46 ms
(0.87%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere' LIMIT 1
Parameters:
[
  "default_live"
]
0.46 ms
(0.85%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/ueber-uns/management' LIMIT 1
Parameters:
[
  "default_live"
]
0.45 ms
(0.85%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/kontakte/kontaktformular' LIMIT 1
Parameters:
[
  "default_live"
]
0.45 ms
(0.84%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen' LIMIT 1
Parameters:
[
  "default_live"
]
0.44 ms
(0.82%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/technik' LIMIT 1
Parameters:
[
  "default_live"
]
0.44 ms
(0.81%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/service/winterdienst' LIMIT 1
Parameters:
[
  "default_live"
]
0.43 ms
(0.81%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/historie' LIMIT 1
Parameters:
[
  "default_live"
]
0.43 ms
(0.81%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/impressum' LIMIT 1
Parameters:
[
  "default_live"
]
0.43 ms
(0.80%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/nachhaltigkeit' LIMIT 1
Parameters:
[
  "default_live"
]
0.40 ms
(0.75%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/bahnbetrieb/schienenfahrzeuge' LIMIT 1
Parameters:
[
  "default_live"
]
0.39 ms
(0.73%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/mitarbeiter-portraits/dimitri-gaivoronski' LIMIT 1
Parameters:
[
  "default_live"
]
0.39 ms
(0.73%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/service/pegelstand' LIMIT 1
Parameters:
[
  "default_live"
]
0.39 ms
(0.73%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/stellenanzeigen' LIMIT 1
Parameters:
[
  "default_live"
]
0.38 ms
(0.71%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/karriere/mitarbeiter-portraits/christian-schouw' LIMIT 1
Parameters:
[
  "default_live"
]
0.38 ms
(0.71%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/service/zertifikate' LIMIT 1
Parameters:
[
  "default_live"
]
0.37 ms
(0.69%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/ueber-uns' LIMIT 1
Parameters:
[
  "default_live"
]
0.37 ms
(0.69%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/bahnbetrieb/eiu' LIMIT 1
Parameters:
[
  "default_live"
]
0.36 ms
(0.68%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/technik/umschlaganlagen' LIMIT 1
Parameters:
[
  "default_live"
]
0.36 ms
(0.67%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/news-presse/presse-veroeffentlichungen-1' LIMIT 1
Parameters:
[
  "default_live"
]
0.35 ms
(0.65%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/news-presse/foto-archiv' LIMIT 1
Parameters:
[
  "default_live"
]
0.34 ms
(0.64%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/news-presse/presse-veroeffentlichungen' LIMIT 1
Parameters:
[
  "default_live"
]
0.31 ms
(0.57%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/unternehmen/unsere-beteiligungen/rheinhafen-krefeld-ein-standort-mit-klaren-vorteilen' LIMIT 1
Parameters:
[
  "default_live"
]
0.29 ms
(0.55%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/service/downloads' LIMIT 1
Parameters:
[
  "default_live"
]
0.28 ms
(0.53%)
1
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/nd-haefen/contents/leistungen/technik/bautechnik' LIMIT 1
Parameters:
[
  "default_live"
]

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.

Entities Mapping

Class Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.