Symfony Profiler

Query Metrics

35 Database Queries

19 Different statements

48.31 ms Query time

2 Invalid entities

81 Managed entities

Queries


SELECT 1 FROM phpcr_workspaces WHERE name = ?
SELECT prefix, uri FROM phpcr_namespaces
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
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
SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
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
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
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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="pre_header"]) > 0')) AND n0.path LIKE '/cmf/www/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
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_desktop"]) > 0')) AND n0.path LIKE '/cmf/www/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
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_mobile"]) > 0')) AND n0.path LIKE '/cmf/www/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
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_info"]) > 0')) AND n0.path LIKE '/cmf/www/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
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ?) ORDER BY sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_legal"]) > 0')) AND n0.path LIKE '/cmf/www/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
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_explore"]) > 0')) AND n0.path LIKE '/cmf/www/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
SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
SELECT o0_.id AS id_0, o0_.active AS active_1, o0_.pod AS pod_2, o0_.slug AS slug_3, o0_.code AS code_4, o0_.firstName AS firstName_5, o0_.image AS image_6, o0_.banner AS banner_7, o0_.introText AS introText_8, o0_.introTextRaw AS introTextRaw_9, o0_.introTextFormat AS introTextFormat_10, o0_.jobTitle AS jobTitle_11, o0_.lastName AS lastName_12, o0_.areaName AS areaName_13, o0_.metaTitle AS metaTitle_14, o0_.seoTitle AS seoTitle_15, o0_.seoDescription AS seoDescription_16, o0_.telephone AS telephone_17, o0_.uuid AS uuid_18, o0_.redirectTo AS redirectTo_19, o0_.imageMediaId AS imageMediaId_20, o0_.bannerMediaId AS bannerMediaId_21 FROM operator__operator o0_ WHERE o0_.active = ? ORDER BY o0_.areaName ASC
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

#▲	Time	Info
1	0.71 ms	SELECT 1 FROM phpcr_workspaces WHERE name = ? Parameters: [`"www_live"`] View formatted query View runnable query Explain query SELECT 1 FROM phpcr_workspaces WHERE name = ? SELECT 1 FROM phpcr_workspaces WHERE name = 'www_live';
2	0.59 ms	SELECT prefix, uri FROM phpcr_namespaces Parameters: [] View formatted query View runnable query Explain query SELECT prefix, uri FROM phpcr_namespaces SELECT prefix, uri FROM phpcr_namespaces;
3	0.60 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/www/routes/en/windscreen-repairs" "www_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC SELECT * FROM phpcr_nodes WHERE path = '/cmf/www/routes/en/windscreen-repairs' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
4	0.71 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/routes/en/windscreen-repairs" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/routes/en/windscreen-repairs') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
5	0.92 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: [] View formatted query View runnable query Explain query 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 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 ;
6	0.67 ms	SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?) Parameters: [`"www_live" "38be4f71-eac5-4ec1-82f2-c7bd780d4d92"`] View formatted query View runnable query Explain query SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?) SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND identifier IN ('38be4f71-eac5-4ec1-82f2-c7bd780d4d92');
7	0.50 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/windscreen-repair" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents/windscreen-repair') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
8	0.58 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/www/contents" "www_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC SELECT * FROM phpcr_nodes WHERE path = '/cmf/www/contents' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
9	0.67 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
10	1.49 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: [] View formatted query View runnable query Explain query 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 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 ;
11	0.90 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: [] View formatted query View runnable query Explain query 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 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 ;
12	2.76 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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="pre_header"]) > 0')) AND n0.path LIKE '/cmf/www/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: [`"www_live"`] View formatted query View runnable query Explain query 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 ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="pre_header"]) > 0' ) ) AND n0.path LIKE '/cmf/www/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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'www_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="pre_header"]) > 0')) AND n0.path LIKE '/cmf/www/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;
13	0.93 ms	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC Parameters: [`"www_live" "/cmf/www/contents/franchise" "/cmf/www/contents/faqs" "/cmf/www/contents/warranty"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND ( path = ? OR path = ? OR path = ? ) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND (path = '/cmf/www/contents/franchise' OR path = '/cmf/www/contents/faqs' OR path = '/cmf/www/contents/warranty') ORDER BY sort_order ASC;
14	0.59 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/franchise" "/cmf/www/contents/faqs" "/cmf/www/contents/warranty" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents/franchise', '/cmf/www/contents/faqs', '/cmf/www/contents/warranty') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
15	5.08 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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_desktop"]) > 0')) AND n0.path LIKE '/cmf/www/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: [`"www_live"`] View formatted query View runnable query Explain query 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 ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_desktop"]) > 0' ) ) AND n0.path LIKE '/cmf/www/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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'www_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_desktop"]) > 0')) AND n0.path LIKE '/cmf/www/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;
16	1.06 ms	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC Parameters: [`"www_live" "/cmf/www/contents/make-a-payment" "/cmf/www/contents/insurance-details" "/cmf/www/contents/contact-us"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND ( path = ? OR path = ? OR path = ? ) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND (path = '/cmf/www/contents/make-a-payment' OR path = '/cmf/www/contents/insurance-details' OR path = '/cmf/www/contents/contact-us') ORDER BY sort_order ASC;
17	0.76 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/make-a-payment" "/cmf/www/contents/insurance-details" "/cmf/www/contents/contact-us" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents/make-a-payment', '/cmf/www/contents/insurance-details', '/cmf/www/contents/contact-us') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
18	5.18 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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_mobile"]) > 0')) AND n0.path LIKE '/cmf/www/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: [`"www_live"`] View formatted query View runnable query Explain query 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 ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_mobile"]) > 0' ) ) AND n0.path LIKE '/cmf/www/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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'www_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="primary_mobile"]) > 0')) AND n0.path LIKE '/cmf/www/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;
19	1.00 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/www" "www_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC SELECT * FROM phpcr_nodes WHERE path = '/cmf/www' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
20	0.72 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
21	0.60 ms	SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?) Parameters: [`"www_live" "1e483faf-34ca-4fe4-977e-2ec9e8ba42c9"`] View formatted query View runnable query Explain query SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?) SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND identifier IN ('1e483faf-34ca-4fe4-977e-2ec9e8ba42c9');
22	0.58 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/snippets/find_nearest/find-nearest-location" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/find_nearest/find-nearest-location') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
23	0.61 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/snippets/find_nearest" "www_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC SELECT * FROM phpcr_nodes WHERE path = '/cmf/snippets/find_nearest' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
24	0.56 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/snippets/find_nearest" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/find_nearest') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
25	4.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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_info"]) > 0')) AND n0.path LIKE '/cmf/www/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: [`"www_live"`] View formatted query View runnable query Explain query 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 ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_info"]) > 0' ) ) AND n0.path LIKE '/cmf/www/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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'www_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_info"]) > 0')) AND n0.path LIKE '/cmf/www/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;
26	0.84 ms	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ?) ORDER BY sort_order ASC Parameters: [`"www_live" "/cmf/www/contents/tell-us-your-insurer"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ?) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND (path = '/cmf/www/contents/tell-us-your-insurer') ORDER BY sort_order ASC;
27	0.71 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/tell-us-your-insurer" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents/tell-us-your-insurer') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
28	3.40 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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_legal"]) > 0')) AND n0.path LIKE '/cmf/www/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: [`"www_live"`] View formatted query View runnable query Explain query 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 ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_legal"]) > 0' ) ) AND n0.path LIKE '/cmf/www/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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'www_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_legal"]) > 0')) AND n0.path LIKE '/cmf/www/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;
29	1.15 ms	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC Parameters: [`"www_live" "/cmf/www/contents/privacy-policy" "/cmf/www/contents/terms-of-use" "/cmf/www/contents/cookie-policy" "/cmf/www/contents/repair-terms-conditions"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND ( path = ? OR path = ? OR path = ? OR path = ? ) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND (path = '/cmf/www/contents/privacy-policy' OR path = '/cmf/www/contents/terms-of-use' OR path = '/cmf/www/contents/cookie-policy' OR path = '/cmf/www/contents/repair-terms-conditions') ORDER BY sort_order ASC;
30	0.80 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/privacy-policy" "/cmf/www/contents/terms-of-use" "/cmf/www/contents/cookie-policy" "/cmf/www/contents/repair-terms-conditions" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents/privacy-policy', '/cmf/www/contents/terms-of-use', '/cmf/www/contents/cookie-policy', '/cmf/www/contents/repair-terms-conditions') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
31	3.11 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 ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_explore"]) > 0')) AND n0.path LIKE '/cmf/www/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: [`"www_live"`] View formatted query View runnable query Explain query 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 ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_explore"]) > 0' ) ) AND n0.path LIKE '/cmf/www/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 SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'www_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_explore"]) > 0')) AND n0.path LIKE '/cmf/www/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;
32	0.99 ms	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC Parameters: [`"www_live" "/cmf/www/contents/knowledge-advice" "/cmf/www/contents/find-my-nearest-operator" "/cmf/www/contents/become-a-franchisee" "/cmf/www/contents/fleet-services"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND ( path = ? OR path = ? OR path = ? OR path = ? ) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'www_live' AND (path = '/cmf/www/contents/knowledge-advice' OR path = '/cmf/www/contents/find-my-nearest-operator' OR path = '/cmf/www/contents/become-a-franchisee' OR path = '/cmf/www/contents/fleet-services') ORDER BY sort_order ASC;
33	0.73 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/knowledge-advice" "/cmf/www/contents/find-my-nearest-operator" "/cmf/www/contents/become-a-franchisee" "/cmf/www/contents/fleet-services" "www_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/www/contents/knowledge-advice', '/cmf/www/contents/find-my-nearest-operator', '/cmf/www/contents/become-a-franchisee', '/cmf/www/contents/fleet-services') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
34	2.17 ms	SELECT o0_.id AS id_0, o0_.active AS active_1, o0_.pod AS pod_2, o0_.slug AS slug_3, o0_.code AS code_4, o0_.firstName AS firstName_5, o0_.image AS image_6, o0_.banner AS banner_7, o0_.introText AS introText_8, o0_.introTextRaw AS introTextRaw_9, o0_.introTextFormat AS introTextFormat_10, o0_.jobTitle AS jobTitle_11, o0_.lastName AS lastName_12, o0_.areaName AS areaName_13, o0_.metaTitle AS metaTitle_14, o0_.seoTitle AS seoTitle_15, o0_.seoDescription AS seoDescription_16, o0_.telephone AS telephone_17, o0_.uuid AS uuid_18, o0_.redirectTo AS redirectTo_19, o0_.imageMediaId AS imageMediaId_20, o0_.bannerMediaId AS bannerMediaId_21 FROM operator__operator o0_ WHERE o0_.active = ? ORDER BY o0_.areaName ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT o0_.id AS id_0, o0_.active AS active_1, o0_.pod AS pod_2, o0_.slug AS slug_3, o0_.code AS code_4, o0_.firstName AS firstName_5, o0_.image AS image_6, o0_.banner AS banner_7, o0_.introText AS introText_8, o0_.introTextRaw AS introTextRaw_9, o0_.introTextFormat AS introTextFormat_10, o0_.jobTitle AS jobTitle_11, o0_.lastName AS lastName_12, o0_.areaName AS areaName_13, o0_.metaTitle AS metaTitle_14, o0_.seoTitle AS seoTitle_15, o0_.seoDescription AS seoDescription_16, o0_.telephone AS telephone_17, o0_.uuid AS uuid_18, o0_.redirectTo AS redirectTo_19, o0_.imageMediaId AS imageMediaId_20, o0_.bannerMediaId AS bannerMediaId_21 FROM operator__operator o0_ WHERE o0_.active = ? ORDER BY o0_.areaName ASC SELECT o0_.id AS id_0, o0_.active AS active_1, o0_.pod AS pod_2, o0_.slug AS slug_3, o0_.code AS code_4, o0_.firstName AS firstName_5, o0_.image AS image_6, o0_.banner AS banner_7, o0_.introText AS introText_8, o0_.introTextRaw AS introTextRaw_9, o0_.introTextFormat AS introTextFormat_10, o0_.jobTitle AS jobTitle_11, o0_.lastName AS lastName_12, o0_.areaName AS areaName_13, o0_.metaTitle AS metaTitle_14, o0_.seoTitle AS seoTitle_15, o0_.seoDescription AS seoDescription_16, o0_.telephone AS telephone_17, o0_.uuid AS uuid_18, o0_.redirectTo AS redirectTo_19, o0_.imageMediaId AS imageMediaId_20, o0_.bannerMediaId AS bannerMediaId_21 FROM operator__operator o0_ WHERE o0_.active = 1 ORDER BY o0_.areaName ASC;
35	1.28 ms	SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC Parameters: [`"staging.optic-kleer.co.uk" "dev" "www"`] View formatted query View runnable query Explain query SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE ( w0_.all_domains = 1 OR ( w1_.url = ? AND w1_.environment = ? ) ) AND w0_.webspace_key = ? ORDER BY w0_.id ASC SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'staging.optic-kleer.co.uk' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'www' ORDER BY w0_.id ASC;

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Operator\Operator	41
Sulu\Bundle\MediaBundle\Entity\Media	40

Entities Mapping

Class	Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup	No errors.
Sulu\Bundle\SecurityBundle\Entity\Role	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
Sulu\Bundle\MediaBundle\Entity\File	No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType	No errors.
Sulu\Bundle\SecurityBundle\Entity\Permission	No errors.
Sulu\Bundle\SecurityBundle\Entity\RoleSetting	No errors.
Sulu\Bundle\SecurityBundle\Entity\SecurityType	No errors.
App\Entity\Operator\Operator	No errors.
App\Entity\Operator\OperatorStore	No errors.
App\Entity\Location\Address	No errors.
App\Entity\Location\Coords	The field 'App\Entity\Location\Coords#latitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Location\Coords#longitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\Location\Location	The field 'App\Entity\Location\Location#coords.latitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Location\Location#coords.longitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
Sulu\Bundle\ContactBundle\Entity\ContactLocale	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact	No errors.
Sulu\Bundle\ContactBundle\Entity\Url	No errors.
Sulu\Bundle\ContactBundle\Entity\Note	No errors.
Sulu\Bundle\ContactBundle\Entity\Email	No errors.
Sulu\Bundle\ContactBundle\Entity\Phone	No errors.
Sulu\Bundle\ContactBundle\Entity\Fax	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile	No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://staging.optic-kleer.co.uk/windscreen-repairs

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping