https://dev.hebammen-azh.de/sitemap.xml

Query Metrics

80 Database Queries
42 Different statements
56.45 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
  "default_live"
]
2 0.39 ms
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[]
3 0.27 ms
SELECT DATABASE()
Parameters:
[]
4 0.77 ms
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:
[]
5 0.59 ms
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:
[]
6 19.72 ms
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/hebammen-azh/contents/%' OR n0.path = '/cmf/hebammen-azh/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"
]
7 0.58 ms
SELECT DATABASE()
Parameters:
[]
8 0.64 ms
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/hebammen-azh/contents/ueber-uns' LIMIT 1
Parameters:
[
  "default_live"
]
9 0.29 ms
SELECT DATABASE()
Parameters:
[]
10 0.45 ms
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/hebammen-azh/contents/leistungen/hebamme/mein-hebammen-azh' LIMIT 1
Parameters:
[
  "default_live"
]
11 0.23 ms
SELECT DATABASE()
Parameters:
[]
12 0.57 ms
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/hebammen-azh/contents/leistungen/hebammenteam/abrechnung' LIMIT 1
Parameters:
[
  "default_live"
]
13 0.26 ms
SELECT DATABASE()
Parameters:
[]
14 0.43 ms
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/hebammen-azh/contents' LIMIT 1
Parameters:
[
  "default_live"
]
15 0.37 ms
SELECT DATABASE()
Parameters:
[]
16 0.44 ms
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/hebammen-azh/contents/leistungen/hebamme/abrechnung' LIMIT 1
Parameters:
[
  "default_live"
]
17 0.28 ms
SELECT DATABASE()
Parameters:
[]
18 0.49 ms
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/hebammen-azh/contents/leistungen/hebammenteam/beratung' LIMIT 1
Parameters:
[
  "default_live"
]
19 0.39 ms
SELECT DATABASE()
Parameters:
[]
20 0.49 ms
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/hebammen-azh/contents/newsticker/heboffice' LIMIT 1
Parameters:
[
  "default_live"
]
21 0.30 ms
SELECT DATABASE()
Parameters:
[]
22 0.72 ms
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/hebammen-azh/contents/leistungen' LIMIT 1
Parameters:
[
  "default_live"
]
23 0.42 ms
SELECT DATABASE()
Parameters:
[]
24 0.54 ms
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/hebammen-azh/contents/termine' LIMIT 1
Parameters:
[
  "default_live"
]
25 0.30 ms
SELECT DATABASE()
Parameters:
[]
26 0.47 ms
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/hebammen-azh/contents/leistungen/hebamme/doku' LIMIT 1
Parameters:
[
  "default_live"
]
27 0.24 ms
SELECT DATABASE()
Parameters:
[]
28 0.44 ms
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/hebammen-azh/contents/leistungen/hebammenteam/mein-hebammen-azh' LIMIT 1
Parameters:
[
  "default_live"
]
29 0.71 ms
SELECT DATABASE()
Parameters:
[]
30 0.49 ms
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/hebammen-azh/contents/newsticker/onlinepro' LIMIT 1
Parameters:
[
  "default_live"
]
31 0.29 ms
SELECT DATABASE()
Parameters:
[]
32 1.15 ms
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/hebammen-azh/contents/leistungen/hebamme/qm' LIMIT 1
Parameters:
[
  "default_live"
]
33 0.29 ms
SELECT DATABASE()
Parameters:
[]
34 0.46 ms
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/hebammen-azh/contents/leistungen/hebammenteam/doku' LIMIT 1
Parameters:
[
  "default_live"
]
35 0.34 ms
SELECT DATABASE()
Parameters:
[]
36 0.70 ms
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/hebammen-azh/contents/karriere' LIMIT 1
Parameters:
[
  "default_live"
]
37 0.31 ms
SELECT DATABASE()
Parameters:
[]
38 0.67 ms
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/hebammen-azh/contents/kontakt' LIMIT 1
Parameters:
[
  "default_live"
]
39 0.32 ms
SELECT DATABASE()
Parameters:
[]
40 0.42 ms
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/hebammen-azh/contents/leistungen/hebamme/fortbildung' LIMIT 1
Parameters:
[
  "default_live"
]
41 0.28 ms
SELECT DATABASE()
Parameters:
[]
42 0.44 ms
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/hebammen-azh/contents/leistungen/hebammenteam/qm' LIMIT 1
Parameters:
[
  "default_live"
]
43 0.24 ms
SELECT DATABASE()
Parameters:
[]
44 0.41 ms
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/hebammen-azh/contents/leistungen/hebamme/beratung' LIMIT 1
Parameters:
[
  "default_live"
]
45 0.25 ms
SELECT DATABASE()
Parameters:
[]
46 0.43 ms
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/hebammen-azh/contents/leistungen/hebammenteam/fortbildung' LIMIT 1
Parameters:
[
  "default_live"
]
47 0.23 ms
SELECT DATABASE()
Parameters:
[]
48 0.38 ms
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/hebammen-azh/contents/shop' LIMIT 1
Parameters:
[
  "default_live"
]
49 0.21 ms
SELECT DATABASE()
Parameters:
[]
50 0.34 ms
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/hebammen-azh/contents/mein-hebammen-azh-de' LIMIT 1
Parameters:
[
  "default_live"
]
51 0.22 ms
SELECT DATABASE()
Parameters:
[]
52 2.98 ms
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/hebammen-azh/contents/leistungen/hebamme' LIMIT 1
Parameters:
[
  "default_live"
]
53 0.64 ms
SELECT DATABASE()
Parameters:
[]
54 0.81 ms
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/hebammen-azh/contents/leistungen/hebamme/telematikinfrastruktur' LIMIT 1
Parameters:
[
  "default_live"
]
55 0.43 ms
SELECT DATABASE()
Parameters:
[]
56 0.49 ms
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/hebammen-azh/contents/leistungen/hebammenteam/telematikinfrastruktur' LIMIT 1
Parameters:
[
  "default_live"
]
57 0.27 ms
SELECT DATABASE()
Parameters:
[]
58 0.46 ms
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/hebammen-azh/contents/test' LIMIT 1
Parameters:
[
  "default_live"
]
59 0.25 ms
SELECT DATABASE()
Parameters:
[]
60 0.39 ms
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/hebammen-azh/contents/janina' LIMIT 1
Parameters:
[
  "default_live"
]
61 0.30 ms
SELECT DATABASE()
Parameters:
[]
62 0.39 ms
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/hebammen-azh/contents/bio' LIMIT 1
Parameters:
[
  "default_live"
]
63 0.25 ms
SELECT DATABASE()
Parameters:
[]
64 0.42 ms
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/hebammen-azh/contents/agb' LIMIT 1
Parameters:
[
  "default_live"
]
65 0.21 ms
SELECT DATABASE()
Parameters:
[]
66 0.65 ms
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/hebammen-azh/contents/leistungen/hebammenteam' LIMIT 1
Parameters:
[
  "default_live"
]
67 0.39 ms
SELECT DATABASE()
Parameters:
[]
68 0.50 ms
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/hebammen-azh/contents/newsticker' LIMIT 1
Parameters:
[
  "default_live"
]
69 1.09 ms
SELECT DATABASE()
Parameters:
[]
70 0.72 ms
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/hebammen-azh/contents/leistungen/wehe' LIMIT 1
Parameters:
[
  "default_live"
]
71 0.35 ms
SELECT DATABASE()
Parameters:
[]
72 0.53 ms
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/hebammen-azh/contents/leistungen/wehe/mein-hebammen-azh' LIMIT 1
Parameters:
[
  "default_live"
]
73 0.30 ms
SELECT DATABASE()
Parameters:
[]
74 0.41 ms
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/hebammen-azh/contents/leistungen/wehe/fortbildung' LIMIT 1
Parameters:
[
  "default_live"
]
75 0.25 ms
SELECT DATABASE()
Parameters:
[]
76 0.41 ms
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/hebammen-azh/contents/leistungen/wehe/beratung' LIMIT 1
Parameters:
[
  "default_live"
]
77 0.23 ms
SELECT DATABASE()
Parameters:
[]
78 0.43 ms
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/hebammen-azh/contents/impressum' LIMIT 1
Parameters:
[
  "default_live"
]
79 0.25 ms
SELECT DATABASE()
Parameters:
[]
80 0.36 ms
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/hebammen-azh/contents/datenschutz' 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\FormBundle\Entity\Form No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.