Query Metrics
98
Database Queries
50
Different statements
53.60 ms
Query time
0
Invalid entities
Grouped Statements
| 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. |