Query Metrics
100
Database Queries
50
Different statements
965.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
44.41 ms (4.60%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'd5ee3fa6-8501-4ead-9f2d-97667db45339'))) 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"
]
|
|
43.11 ms (4.46%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '48cab57c-d828-4363-a0e8-8de7155c3638'))) 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"
]
|
|
42.27 ms (4.38%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '4a72dc76-7505-4c34-9f01-b7b18086a4fb'))) 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"
]
|
|
42.06 ms (4.36%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'ea18eaf2-0165-47aa-a9ea-f32436081571'))) 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"
]
|
|
41.65 ms (4.31%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '44b9a23c-2a94-4273-8524-c192c4cb8159'))) 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"
]
|
|
41.54 ms (4.30%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '87f00fba-d2f2-4341-a558-7b660ca3876e'))) 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"
]
|
|
41.24 ms (4.27%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '80787cdb-307b-4cd3-a17d-183c805229e6'))) 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"
]
|
|
40.86 ms (4.23%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'a726aeb6-0be0-4f50-bc82-e180913cbdd9'))) 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"
]
|
|
40.84 ms (4.23%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '47bbcd4c-e3f7-4612-adf2-bc78651a6d42'))) 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"
]
|
|
40.83 ms (4.23%) |
28 |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, m5_.crop_x AS crop_x_31, m5_.crop_y AS crop_y_32, m5_.crop_width AS crop_width_33, m5_.crop_height AS crop_height_34, m5_.format_key AS format_key_35, m6_.title AS title_36, m6_.description AS description_37, m6_.copyright AS copyright_38, m6_.credits AS credits_39, m6_.locale AS locale_40, m6_.id AS id_41, m7_.title AS title_42, m7_.description AS description_43, m7_.copyright AS copyright_44, m7_.credits AS credits_45, m7_.locale AS locale_46, m7_.id AS id_47, m8_.locale AS locale_48, m8_.id AS id_49, m9_.locale AS locale_50, m9_.id AS id_51, s10_.username AS username_52, s10_.password AS password_53, s10_.locale AS locale_54, s10_.salt AS salt_55, s10_.locked AS locked_56, s10_.enabled AS enabled_57, s10_.lastLogin AS lastLogin_58, s10_.confirmationKey AS confirmationKey_59, s10_.passwordResetToken AS passwordResetToken_60, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_61, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_62, s10_.privateKey AS privateKey_63, s10_.apiKey AS apiKey_64, s10_.email AS email_65, s10_.id AS id_66, s10_.created AS created_67, s10_.changed AS changed_68, c11_.firstName AS firstName_69, c11_.middleName AS middleName_70, c11_.lastName AS lastName_71, c11_.birthday AS birthday_72, c11_.salutation AS salutation_73, c11_.formOfAddress AS formOfAddress_74, c11_.newsletter AS newsletter_75, c11_.gender AS gender_76, c11_.note AS note_77, c11_.mainEmail AS mainEmail_78, c11_.mainPhone AS mainPhone_79, c11_.mainFax AS mainFax_80, c11_.mainUrl AS mainUrl_81, c11_.id AS id_82, c11_.created AS created_83, c11_.changed AS changed_84, s12_.username AS username_85, s12_.password AS password_86, s12_.locale AS locale_87, s12_.salt AS salt_88, s12_.locked AS locked_89, s12_.enabled AS enabled_90, s12_.lastLogin AS lastLogin_91, s12_.confirmationKey AS confirmationKey_92, s12_.passwordResetToken AS passwordResetToken_93, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95, s12_.privateKey AS privateKey_96, s12_.apiKey AS apiKey_97, s12_.email AS email_98, s12_.id AS id_99, s12_.created AS created_100, s12_.changed AS changed_101, c13_.firstName AS firstName_102, c13_.middleName AS middleName_103, c13_.lastName AS lastName_104, c13_.birthday AS birthday_105, c13_.salutation AS salutation_106, c13_.formOfAddress AS formOfAddress_107, c13_.newsletter AS newsletter_108, c13_.gender AS gender_109, c13_.note AS note_110, c13_.mainEmail AS mainEmail_111, c13_.mainPhone AS mainPhone_112, c13_.mainFax AS mainFax_113, c13_.mainUrl AS mainUrl_114, c13_.id AS id_115, c13_.created AS created_116, c13_.changed AS changed_117, m14_.id AS id_118, m14_.created AS created_119, m14_.changed AS changed_120, m0_.idMediaTypes AS idMediaTypes_121, m0_.idPreviewImage AS idPreviewImage_122, m0_.idCollections AS idCollections_123, m0_.idUsersCreator AS idUsersCreator_124, m0_.idUsersChanger AS idUsersChanger_125, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_126, m2_.idCollectionTypes AS idCollectionTypes_127, m2_.idCollectionsParent AS idCollectionsParent_128, m2_.idUsersCreator AS idUsersCreator_129, m2_.idUsersChanger AS idUsersChanger_130, m3_.idMedia AS idMedia_131, m3_.idUsersCreator AS idUsersCreator_132, m3_.idUsersChanger AS idUsersChanger_133, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134, m4_.idFiles AS idFiles_135, m4_.idUsersCreator AS idUsersCreator_136, m4_.idUsersChanger AS idUsersChanger_137, m5_.fileVersion AS fileVersion_138, m6_.idFileVersions AS idFileVersions_139, m7_.idFileVersions AS idFileVersions_140, m8_.idFileVersions AS idFileVersions_141, m9_.idFileVersions AS idFileVersions_142, s10_.idContacts AS idContacts_143, s10_.idUsersCreator AS idUsersCreator_144, s10_.idUsersChanger AS idUsersChanger_145, c11_.idTitles AS idTitles_146, c11_.avatar AS avatar_147, c11_.idUsersCreator AS idUsersCreator_148, c11_.idUsersChanger AS idUsersChanger_149, s12_.idContacts AS idContacts_150, s12_.idUsersCreator AS idUsersCreator_151, s12_.idUsersChanger AS idUsersChanger_152, c13_.idTitles AS idTitles_153, c13_.avatar AS avatar_154, c13_.idUsersCreator AS idUsersCreator_155, c13_.idUsersChanger AS idUsersChanger_156, m14_.idMediaTypes AS idMediaTypes_157, m14_.idPreviewImage AS idPreviewImage_158, m14_.idCollections AS idCollections_159, m14_.idUsersCreator AS idUsersCreator_160, m14_.idUsersChanger AS idUsersChanger_161 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_format_options m5_ ON m4_.id = m5_.fileVersion LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id LEFT JOIN me_media m14_ ON m0_.idPreviewImage = m14_.id WHERE m0_.id = ?
Parameters:
[
27
]
|
|
40.73 ms (4.22%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '01ebcf3c-2d09-4c55-83c4-7fcb506c5f7f'))) 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"
]
|
|
40.66 ms (4.21%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'f1f90095-b52e-4e3b-9157-0b4eab51b891'))) 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"
]
|
|
40.08 ms (4.15%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '35fe86b2-49f0-4705-b03d-16cfc23ef31a'))) 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"
]
|
|
39.78 ms (4.12%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '5fddce57-01e8-441a-8a14-8a3babf30c1d'))) 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"
]
|
|
39.73 ms (4.11%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'a6f6856f-7675-429d-a983-50d7ed40bd75'))) 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"
]
|
|
39.66 ms (4.11%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '6a511856-cde1-4fcd-b208-c165f697b05a'))) 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"
]
|
|
39.62 ms (4.10%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '41681a9f-be43-40d5-927a-9b6f7d5db1c8'))) 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"
]
|
|
39.55 ms (4.10%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'a883ca94-615e-4f08-8d06-96c37dd1f97b'))) 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"
]
|
|
39.53 ms (4.09%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = 'bf4c0355-171e-4af8-ac78-3c2ab8ff6c97'))) 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"
]
|
|
38.48 ms (3.99%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((((((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="buy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="contact"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="dataMarket"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="login"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="profileSetting"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="resetPassword"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="serviceProvider"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="register"]) > 0'))) AND NOT (n0.identifier = '0583c16b-da1c-4e2b-b562-8cbfd4ab52de'))) 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"
]
|
|
28.40 ms (2.94%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0'))) AND NOT (n0.identifier = '65b62463-73b7-4905-b331-7e04f7b4be61'))) 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"
]
|
|
27.71 ms (2.87%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0'))) AND NOT (n0.identifier = '89e44556-5faa-4df9-8b4a-3694d90ba363'))) 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"
]
|
|
27.32 ms (2.83%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0'))) AND NOT (n0.identifier = '10a73ab8-ff36-4802-b393-758b433d3063'))) 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"
]
|
|
27.13 ms (2.81%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0'))) AND NOT (n0.identifier = 'fc49f2cd-25c4-4c92-9b07-60ee3cda3e26'))) 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"
]
|
|
26.90 ms (2.79%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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 n0.parent = '/cmf/storm/contents/actualites') AND (((((((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="about"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="default"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="homepage"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="news"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="privacyPolicy"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="rent"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="service"]) > 0')) OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-template"]/sv:value[text()="singleNews"]) > 0'))) AND NOT (n0.identifier = '8a47966b-55fa-4533-b287-b2e2a74e240e'))) 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"
]
|
|
1.83 ms (0.19%) |
10 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/storm/routes/en/news/logistics-real-estate-2025-the-new-frontiers-of-the-french-supply-chain" "default_live" ] |
|
1.60 ms (0.17%) |
1 |
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 = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
Parameters:
[ "default_live" "/cmf/storm/contents/actualites/ai-revolution-in-logistics-real-estate-smart-warehouses-redefining-the-game" "/cmf/storm/contents/actualites/ai-in-real-estate-beyond-the-hype-a-strategic-revolution" "/cmf/storm/contents/actualites/european-logistics-real-estate-anatomy-of-a-meteoric-rise" "/cmf/storm/contents/actualites/gafalogistics-how-tech-titans-are-disrupting-the-global-supply-chain-chessboard" "/cmf/storm/contents/actualites/energy-revolution-how-warehouses-are-becoming-power-plants" "/cmf/storm/contents/actualites/the-talent-war-robotization-as-a-strategic-weapon-in-logistics" "/cmf/storm/contents/actualites/zombie-real-estate-when-dead-spaces-reincarnate-as-logistics-powerhouses" "/cmf/storm/contents/actualites/french-real-estate-market-2024-mapping-a-year-under-pressure" "/cmf/storm/contents/actualites/the-logistics-metaverse-how-digital-twins-are-revolutionizing-asset-management" "/cmf/storm/contents/actualites/the-great-eurasian-game-the-new-race-for-border-warehouses" "/cmf/storm/contents/actualites/container-crisis-global-supply-chain-faces-a-systemic-inflection-point" "/cmf/storm/contents/actualites/green-finance-how-climate-bonds-are-revolutionizing-logistics-real-estate" "/cmf/storm/contents/actualites/ukraine-2025-the-logistics-reconstruction-reshaping-eurasia-s-economic-dna" "/cmf/storm/contents/actualites/reindustrialization-paradox-the-quantum-conundrum-of-french-industrial-space" "/cmf/storm/contents/actualites/energy-crisis-thermosensitive-warehouses-emerge-as-resilient-fortresses-amid-energy-chaos" "/cmf/storm/contents/actualites/crowdfunding-revolution-citizen-disruption-reinventing-urban-micro-logistics" "/cmf/storm/contents/actualites/cyberwar-smart-warehouses-under-fire-from-hackers-4-0" "/cmf/storm/contents/actualites/silver-tsunami-how-demographic-aging-is-reinventing-the-logistics-equation" "/cmf/storm/contents/actualites/extreme-climate-the-parametric-revolution-reinventing-financial-immunity-for-logistics-assets" "/cmf/storm/contents/actualites/decarbonized-transport-the-technological-metamorphosis-reinventing-logistics-real-estate" "/cmf/storm/contents/actualites/food-sovereignty-smart-agro-warehouses-reinventing-our-strategic-autonomy" "/cmf/storm/contents/actualites/rare-metals-the-underground-silicon-valley-reshaping-european-geopolitics" "/cmf/storm/contents/actualites/dark-stores-2-0-the-chameleon-infrastructure-reshaping-urban-real-estate-dynamics" ] |
|
1.30 ms (0.13%) |
5 |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/storm/routes/en/news/logistics-real-estate-2025-the-new-frontiers-of-the-french-supply-chain" "default_live" ] |
|
1.13 ms (0.12%) |
1 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/storm/contents/actualites/ai-revolution-in-logistics-real-estate-smart-warehouses-redefining-the-game" "/cmf/storm/contents/actualites/ai-in-real-estate-beyond-the-hype-a-strategic-revolution" "/cmf/storm/contents/actualites/european-logistics-real-estate-anatomy-of-a-meteoric-rise" "/cmf/storm/contents/actualites/gafalogistics-how-tech-titans-are-disrupting-the-global-supply-chain-chessboard" "/cmf/storm/contents/actualites/energy-revolution-how-warehouses-are-becoming-power-plants" "/cmf/storm/contents/actualites/the-talent-war-robotization-as-a-strategic-weapon-in-logistics" "/cmf/storm/contents/actualites/zombie-real-estate-when-dead-spaces-reincarnate-as-logistics-powerhouses" "/cmf/storm/contents/actualites/french-real-estate-market-2024-mapping-a-year-under-pressure" "/cmf/storm/contents/actualites/the-logistics-metaverse-how-digital-twins-are-revolutionizing-asset-management" "/cmf/storm/contents/actualites/the-great-eurasian-game-the-new-race-for-border-warehouses" "/cmf/storm/contents/actualites/container-crisis-global-supply-chain-faces-a-systemic-inflection-point" "/cmf/storm/contents/actualites/green-finance-how-climate-bonds-are-revolutionizing-logistics-real-estate" "/cmf/storm/contents/actualites/ukraine-2025-the-logistics-reconstruction-reshaping-eurasia-s-economic-dna" "/cmf/storm/contents/actualites/reindustrialization-paradox-the-quantum-conundrum-of-french-industrial-space" "/cmf/storm/contents/actualites/energy-crisis-thermosensitive-warehouses-emerge-as-resilient-fortresses-amid-energy-chaos" "/cmf/storm/contents/actualites/crowdfunding-revolution-citizen-disruption-reinventing-urban-micro-logistics" "/cmf/storm/contents/actualites/cyberwar-smart-warehouses-under-fire-from-hackers-4-0" "/cmf/storm/contents/actualites/silver-tsunami-how-demographic-aging-is-reinventing-the-logistics-equation" "/cmf/storm/contents/actualites/extreme-climate-the-parametric-revolution-reinventing-financial-immunity-for-logistics-assets" "/cmf/storm/contents/actualites/decarbonized-transport-the-technological-metamorphosis-reinventing-logistics-real-estate" "/cmf/storm/contents/actualites/food-sovereignty-smart-agro-warehouses-reinventing-our-strategic-autonomy" "/cmf/storm/contents/actualites/rare-metals-the-underground-silicon-valley-reshaping-european-geopolitics" "/cmf/storm/contents/actualites/dark-stores-2-0-the-chameleon-infrastructure-reshaping-urban-real-estate-dynamics" "default_live" ] |
|
0.88 ms (0.09%) |
1 |
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 = ? OR path = ?) ORDER BY sort_order ASC
Parameters:
[ "default_live" "/cmf/storm/contents/louer" "/cmf/storm/contents/about-us" "/cmf/storm/contents/buy" "/cmf/storm/contents/contact-us" "/cmf/storm/contents/storm-map" ] |
|
0.69 ms (0.07%) |
4 |
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
1
]
|
|
0.43 ms (0.04%) |
2 |
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" "5fddce57-01e8-441a-8a14-8a3babf30c1d" ] |
|
0.40 ms (0.04%) |
1 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/storm/contents/louer" "/cmf/storm/contents/about-us" "/cmf/storm/contents/buy" "/cmf/storm/contents/contact-us" "/cmf/storm/contents/storm-map" "default_live" ] |
|
0.40 ms (0.04%) |
3 |
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/storm/contents/acheter" ] |
|
0.32 ms (0.03%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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_menu_3"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.29 ms (0.03%) |
3 |
SELECT phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract, phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable, phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names, phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created, phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected, phpcr_type_props.on_parent_version AS property_on_parent_version, phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple, phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value, phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created, phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected, phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type, phpcr_type_childs.primary_types AS child_primary_types FROM phpcr_type_nodes LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters:
[] |
|
0.27 ms (0.03%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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()="service_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.25 ms (0.03%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
|
0.25 ms (0.03%) |
3 |
SELECT m0_.id AS id_0, m1_.version AS version_1, m1_.name AS name_2, m2_.title AS title_3, m3_.title AS title_4 FROM me_media m0_ LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles AND (m1_.version = m4_.version) LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = ?) WHERE m0_.id IN (?)
Parameters:
[ "en" 52811 ] |
|
0.22 ms (0.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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()="burger_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.18 ms (0.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = 'fe2c557b-08ba-49d8-bb7c-156b6abd9e0c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ','))) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
0.17 ms (0.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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()="main"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.16 ms (0.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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_menu_1"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.16 ms (0.02%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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_menu_2"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.13 ms (0.01%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((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_menu_4"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
|
|
0.11 ms (0.01%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/connexion' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.10 ms (0.01%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '35e8121f-c8e9-4cc7-8ff5-9cd381abbf42' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ','))) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC
Parameters:
[
"default_live"
]
|
|
0.10 ms (0.01%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
|
0.09 ms (0.01%) |
1 |
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:
[ "storm-preprod.ewm.dev/{localization}" "dev" "storm" ] |
|
0.07 ms (0.01%) |
1 |
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/profile-settings' LIMIT 1
Parameters:
[
"default_live"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.