Query Metrics
80
Database Queries
42
Different statements
56.45 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |