1
0.15 ms
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters :
[
"default_live "
]
SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live' ; Copy
2
0.11 ms
SELECT prefix , uri FROM phpcr_namespaces
SELECT prefix , uri FROM phpcr_namespaces ; Copy
3
0.45 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/montcaud/routes/de/newsletter "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/montcaud/routes/de/newsletter'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
4
0.36 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/montcaud/routes/de/newsletter "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/routes/de/newsletter' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
5
0.15 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
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
; Copy
6
0.29 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 :
[
"default_live "
"8cfdc2ce-302b-4143-90fc-91557506c129 "
]
SELECT id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('8cfdc2ce-302b-4143-90fc-91557506c129' ); Copy
7
0.32 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/montcaud/contents/newsletter "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/contents/newsletter' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
8
0.18 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/montcaud/contents "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/montcaud/contents'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
9
0.15 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/montcaud/contents "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/contents' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
10
0.62 ms
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters :
[
"6f3a60d3-71bf-4c67-9bf3-b97d3041846e "
"default_live "
]
SELECT * FROM phpcr_nodes WHERE identifier = '6f3a60d3-71bf-4c67-9bf3-b97d3041846e' AND workspace_name = 'default_live' ; Copy
11
0.41 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/form/newsletter "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/form/newsletter' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
12
0.27 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/snippets/form "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/snippets/form'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
13
0.35 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/form "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/form' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
14
0.13 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/montcaud "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/montcaud'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
15
0.09 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/montcaud "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
16
0.12 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 :
[
"default_live "
"13b1fb30-50a0-43d5-b859-d7d5bb2f3c88 "
]
SELECT id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('13b1fb30-50a0-43d5-b859-d7d5bb2f3c88' ); Copy
17
0.11 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/settings/settings "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/settings/settings' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
18
0.10 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/snippets/settings "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/snippets/settings'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
19
0.08 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/settings "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/settings' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
20
0.13 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 :
[
"default_live "
"734d94fe-0318-460d-94a6-c3e57e94bae3 "
]
SELECT id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('734d94fe-0318-460d-94a6-c3e57e94bae3' ); Copy
21
0.12 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/switcherLanguage/switcherlanguage "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/switcherLanguage/switcherlanguage' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
22
0.10 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/snippets/switcherLanguage "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/snippets/switcherLanguage'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
23
0.08 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/switcherLanguage "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/switcherLanguage' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
24
0.18 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
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
; Copy
25
0.13 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
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
; Copy
26
0.19 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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="burgerNav"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/contents/%' )) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
SELECT n0 . path AS n0_path , n0 . identifier AS n0_identifier , n0 . props AS n0_props FROM phpcr_nodes n0 WHERE n0 . workspace_name = 'default_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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="burgerNav"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/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 ; Copy
27
0.20 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 :
[
"default_live "
"/cmf/montcaud/contents/park "
"/cmf/montcaud/contents/contact "
]
SELECT path AS arraykey , id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/montcaud/contents/park' OR path = '/cmf/montcaud/contents/contact' ) ORDER BY sort_order ASC ; Copy
28
0.13 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? , ? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/montcaud/contents/park "
"/cmf/montcaud/contents/contact "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/contents/park' , '/cmf/montcaud/contents/contact' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
29
0.21 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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="topNav"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/contents/%' )) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
SELECT n0 . path AS n0_path , n0 . identifier AS n0_identifier , n0 . props AS n0_props FROM phpcr_nodes n0 WHERE n0 . workspace_name = 'default_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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="topNav"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/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 ; Copy
30
0.14 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 :
[
"default_live "
"/cmf/montcaud/contents/gallery "
]
SELECT path AS arraykey , id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/montcaud/contents/gallery' ) ORDER BY sort_order ASC ; Copy
31
0.10 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/montcaud/contents/gallery "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/montcaud/contents/gallery' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
32
0.22 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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterLeft"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/contents/%' )) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
SELECT n0 . path AS n0_path , n0 . identifier AS n0_identifier , n0 . props AS n0_props FROM phpcr_nodes n0 WHERE n0 . workspace_name = 'default_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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterLeft"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/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 ; Copy
33
0.25 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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterRight"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/contents/%' )) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
SELECT n0 . path AS n0_path , n0 . identifier AS n0_identifier , n0 . props AS n0_props FROM phpcr_nodes n0 WHERE n0 . workspace_name = 'default_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:de-state"]/sv:value' ), ' ' , ',' )) OR EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="mainFooterRight"]) > 0' )) AND n0 . path LIKE '/cmf/montcaud/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 ; Copy
34
0.22 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 :
[
"chateau-de-montcaud.ewm.dev/{localization} "
"dev "
"montcaud "
]
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 = 'chateau-de-montcaud.ewm.dev/{localization}' AND w1_ . environment = 'dev' )) AND w0_ . webspace_key = 'montcaud' ORDER BY w0_ . id ASC ; Copy