Query Metrics
130
Database Queries
51
Different statements
83.31 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
61.59 ms (73.93%) |
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.path LIKE '/cmf/plan-d-berechtigungen/contents/%' OR n0.path = '/cmf/plan-d-berechtigungen/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"
]
|
10.94 ms (13.13%) |
63 |
SELECT DATABASE()
Parameters:
[] |
1.04 ms (1.25%) |
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/plan-d-berechtigungen/contents/leistungen/daten-und-ki-einsetzen-prozesse-automatisieren' LIMIT 1
Parameters:
[
"default_live"
]
|
0.84 ms (1.01%) |
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/plan-d-berechtigungen/contents/ueber-uns' LIMIT 1
Parameters:
[
"default_live"
]
|
0.47 ms (0.57%) |
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/plan-d-berechtigungen/contents/leistungen/business-skalieren-mindset-etablieren' LIMIT 1
Parameters:
[
"default_live"
]
|
0.33 ms (0.40%) |
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/plan-d-berechtigungen/contents' LIMIT 1
Parameters:
[
"default_live"
]
|
0.31 ms (0.38%) |
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/plan-d-berechtigungen/contents/leistungen' LIMIT 1
Parameters:
[
"default_live"
]
|
0.31 ms (0.37%) |
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:
[] |
0.31 ms (0.37%) |
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/plan-d-berechtigungen/contents/stories' LIMIT 1
Parameters:
[
"default_live"
]
|
0.29 ms (0.35%) |
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/plan-d-berechtigungen/contents/leistungen/einstiegsformate' LIMIT 1
Parameters:
[
"default_live"
]
|
0.27 ms (0.33%) |
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/plan-d-berechtigungen/contents/leistungen/strategie-und-innovation/ki-ideenwerkstatt' LIMIT 1
Parameters:
[
"default_live"
]
|
0.27 ms (0.32%) |
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/plan-d-berechtigungen/contents/stories/the-t-a-ime-is-now-digital-solutions-for-real-problems' LIMIT 1
Parameters:
[
"default_live"
]
|
0.27 ms (0.32%) |
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/plan-d-berechtigungen/contents/privacy-policy' LIMIT 1
Parameters:
[
"default_live"
]
|
0.27 ms (0.32%) |
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/plan-d-berechtigungen/contents/stories/ai-and-you-where-to-begin' LIMIT 1
Parameters:
[
"default_live"
]
|
0.27 ms (0.32%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
0.27 ms (0.32%) |
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/plan-d-berechtigungen/contents/contact' LIMIT 1
Parameters:
[
"default_live"
]
|
0.27 ms (0.32%) |
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/plan-d-berechtigungen/contents/imprint' LIMIT 1
Parameters:
[
"default_live"
]
|
0.26 ms (0.32%) |
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/plan-d-berechtigungen/contents/agenda-herunterladen' LIMIT 1
Parameters:
[
"default_live"
]
|
0.26 ms (0.31%) |
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/plan-d-berechtigungen/contents/career' LIMIT 1
Parameters:
[
"default_live"
]
|
0.24 ms (0.29%) |
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/plan-d-berechtigungen/contents/leistungen/strategie-und-innovation' LIMIT 1
Parameters:
[
"default_live"
]
|
0.19 ms (0.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/plan-d-berechtigungen/contents/cases' LIMIT 1
Parameters:
[
"default_live"
]
|
0.15 ms (0.18%) |
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/plan-d-berechtigungen/contents/leistungen/business-skalieren-mindset-etablieren/ki-trainings' LIMIT 1
Parameters:
[
"default_live"
]
|
0.15 ms (0.18%) |
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/plan-d-berechtigungen/contents/branchen/versicherung' LIMIT 1
Parameters:
[
"default_live"
]
|
0.15 ms (0.18%) |
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/plan-d-berechtigungen/contents/branchen' LIMIT 1
Parameters:
[
"default_live"
]
|
0.14 ms (0.17%) |
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/plan-d-berechtigungen/contents/cases/omnikanal-im-versicherungs-vertrieb' LIMIT 1
Parameters:
[
"default_live"
]
|
0.14 ms (0.17%) |
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/plan-d-berechtigungen/contents/stories/2023-01-25-meinungen-zum-ai-act' LIMIT 1
Parameters:
[
"default_live"
]
|
0.14 ms (0.17%) |
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/plan-d-berechtigungen/contents/branchen/versicherung-der-zukunft' LIMIT 1
Parameters:
[
"default_live"
]
|
0.14 ms (0.17%) |
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/plan-d-berechtigungen/contents/leistungen/strategie-und-innovation/ki-management-crashkurs' LIMIT 1
Parameters:
[
"default_live"
]
|
0.14 ms (0.17%) |
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/plan-d-berechtigungen/contents/leistungen/daten-und-ki-einsetzen-prozesse-automatisieren/100-tage-mvp' LIMIT 1
Parameters:
[
"default_live"
]
|
0.14 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/ki-basierte-prognose-von-reparaturkosten' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/leistungen/daten-und-ki-einsetzen-prozesse-automatisieren/daten-analyse-sprint' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/360-kundensicht-mit-daten-und-ki' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/2022-05-01-von-audi-zu-plan-d-hallo-haiko' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/2022-03-01-onsite-offsite-any-site' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/2023-06-09-werkstattblick-nlp-und-chatgpt-im-customer-support-richtig-nutzen' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/entwicklung-einer-datenstrategie' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/digitalisierung-im-oeffentlichen-sektor' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/mit-daten-den-besten-ki-dienstleister-finden' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/mit-daten-leben-retten' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/2023-02-20-data-act-chance-fuer-den-mittelstand' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/ai-and-you-where-to-begin-1' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/2023-04-13-ki-welche-jobs-sind-noch-zukunftssicher' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/stories/2023-05-13-rust-oder-python-am-besten-beides' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/ki-im-customer-support' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.16%) |
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/plan-d-berechtigungen/contents/cases/strategie-ausnahmewetter' LIMIT 1
Parameters:
[
"default_live"
]
|
0.13 ms (0.15%) |
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/plan-d-berechtigungen/contents/stories/2022-11-14-sollte-jedes-kind-in-der-schule-programmieren-lernen' LIMIT 1
Parameters:
[
"default_live"
]
|
0.12 ms (0.15%) |
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/plan-d-berechtigungen/contents/cases/kosteneffizienz-durch-datenanalyse-und-ki' LIMIT 1
Parameters:
[
"default_live"
]
|
0.12 ms (0.15%) |
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/plan-d-berechtigungen/contents/cases/digitalstrategie-im-dynamischen-umfeld' LIMIT 1
Parameters:
[
"default_live"
]
|
0.12 ms (0.15%) |
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/plan-d-berechtigungen/contents/presse' LIMIT 1
Parameters:
[
"default_live"
]
|
0.12 ms (0.15%) |
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/plan-d-berechtigungen/contents/cases/mit-anywhere-operations-co2-einsparen' 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\MediaBundle\Entity\Collection | No errors. |
Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |