Symfony Profiler

Query Metrics

48 Database Queries

23 Different statements

63.43 ms Query time

2 Invalid entities

94 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 r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target AS target_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target AS target_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target = r1_.id WHERE r0_.path = ? AND r0_.locale = ?
SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.sortPosition AS sortPosition_4, t0.route AS route_5 FROM faq__category t0 WHERE t0.id = ?
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 * 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 f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC
SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC
SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC
SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title 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 = ?) 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 = ? 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 t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
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 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

#▲	Time	Info
1	0.63 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.55 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.61 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/www/routes/en/windscreen-faqs/6" "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-faqs/6' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
4	0.88 ms	SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target AS target_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target AS target_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target = r1_.id WHERE r0_.path = ? AND r0_.locale = ? Parameters: [`"/windscreen-faqs/6" "en"`] View formatted query View runnable query Explain query SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target AS target_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target AS target_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target = r1_.id WHERE r0_.path = ? AND r0_.locale = ? SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target AS target_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target AS target_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target = r1_.id WHERE r0_.path = '/windscreen-faqs/6' AND r0_.locale = 'en';
5	0.87 ms	SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.sortPosition AS sortPosition_4, t0.route AS route_5 FROM faq__category t0 WHERE t0.id = ? Parameters: [`"6"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.sortPosition AS sortPosition_4, t0.route AS route_5 FROM faq__category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.sortPosition AS sortPosition_4, t0.route AS route_5 FROM faq__category t0 WHERE t0.id = '6';
6	1.20 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/www/contents/faqs" "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/faqs' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
7	0.79 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/faqs" "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/faqs') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
8	1.20 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 ;
9	0.65 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;
10	0.74 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;
11	1.24 ms	SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC Parameters: [`1 1 6`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = 1 AND f1_.active = 1 AND f1_.id = 6 ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC;
12	1.12 ms	SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = 1 AND f1_.active = 1 GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC;
13	1.19 ms	SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC Parameters: [`1 1 6`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = 1 AND f1_.active = 1 AND f1_.id = 6 ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC;
14	1.30 ms	SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = 1 AND f1_.active = 1 GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC;
15	1.37 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 ;
16	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 ;
17	4.34 ms	SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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;
18	0.95 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 = ?) ORDER BY sort_order ASC Parameters: [`"www_live" "/cmf/www/contents/franchise" "/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 = ? ) 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/warranty') ORDER BY sort_order ASC;
19	0.97 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/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/warranty') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
20	5.37 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;
21	1.05 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/windscreen-repair" "/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 = ? 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/windscreen-repair' OR 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;
22	0.95 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/www/contents/windscreen-repair" "/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/windscreen-repair', '/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;
23	3.29 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;
24	0.81 ms	SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = 7;
25	0.50 ms	SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = 8;
26	0.54 ms	SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = 9;
27	0.43 ms	SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = 10;
28	0.49 ms	SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ? SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = 11;
29	0.57 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;
30	0.60 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;
31	0.54 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');
32	0.43 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;
33	0.49 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;
34	0.46 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;
35	1.31 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" "ef44260e-90c3-40f2-8abb-6c86aa501ccc"`] 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 ('ef44260e-90c3-40f2-8abb-6c86aa501ccc');
36	0.71 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/snippets/features_list/ok-features" "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/features_list/ok-features') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
37	0.90 ms	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/snippets/features_list" "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/features_list' AND workspace_name = 'www_live' ORDER BY depth, sort_order ASC;
38	0.73 ms	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/snippets/features_list" "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/features_list') AND workspace_name = 'www_live' ORDER BY sort_order ASC;
39	4.95 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;
40	1.12 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;
41	0.66 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;
42	4.32 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;
43	1.27 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;
44	0.79 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;
45	4.66 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;
46	1.21 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;
47	0.83 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;
48	1.95 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;

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
Sulu\Bundle\RouteBundle\Entity\Route	6
App\Entity\Faq\Category	6
App\Entity\Faq\Faq	1

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\RouteBundle\Entity\Route	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
App\Entity\Faq\Category	No errors.
App\Entity\Faq\Faq	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation	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.
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.

Symfony Profiler

GET https://staging.optic-kleer.co.uk/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255COperatorController%253A%253AselectAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping