User Deprecated: The Liip\ImagineBundle\Templating\FilterExtension class is deprecated since version 2.7 and will be removed in 3.0; configure "liip_imagine.twig.mode" to "lazy" instead.
User Deprecated: Since symfony/security-core 5.4: Not setting the 5th argument of "Symfony\Component\Security\Core\Authorization\AuthorizationChecker::__construct" to "false" is deprecated.
User Deprecated: Since symfony/security-bundle 5.3: The "sulu_security.encoder_factory" service is deprecated, use "security.password_hasher_factory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactory" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactoryInterface" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactoryInterface" instead.
User Deprecated: The "Sulu\Component\Localization\Localization::setXDefault" method is deprecated on "Sulu\Component\Localization\Localization" use "setDefault" instead.
User Deprecated: The "Sulu\Component\Webspace\Portal::getXDefaultLocalization" method is deprecated on "Sulu\Component\Webspace\Portal" use "getDefaultLocalization" instead.
User Deprecated: The "Sulu\Component\Webspace\Portal::setXDefaultLocalization" method is deprecated on "Sulu\Component\Webspace\Portal" use "setDefaultLocalization" instead.
[
"sql" => "SELECT 1 FROM phpcr_workspaces WHERE name = ?"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT prefix, uri FROM phpcr_namespaces"
doctrine
[
"sql" => "SELECT prefix, uri FROM phpcr_namespaces"
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"""
\nSELECT\nphpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\nphpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\nphpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\nphpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\nphpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\nphpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\nphpcr_type_props.on_parent_version AS property_on_parent_version,\nphpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\nphpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\nphpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\nphpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\nphpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\nphpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\nphpcr_type_childs.primary_types AS child_primary_types\nFROM\nphpcr_type_nodes\nLEFT JOIN\nphpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\nLEFT JOIN\nphpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
"""
(parameters:
[]
, types:
[]
)
doctrine
[
"sql" => """
\nSELECT\nphpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\nphpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\nphpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\nphpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\nphpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\nphpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\nphpcr_type_props.on_parent_version AS property_on_parent_version,\nphpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\nphpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\nphpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\nphpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\nphpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\nphpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\nphpcr_type_childs.primary_types AS child_primary_types\nFROM\nphpcr_type_nodes\nLEFT JOIN\nphpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\nLEFT JOIN\nphpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
"""
"params" => []
"types" => []
]
debug
Executing statement:
"""
\nSELECT\nphpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\nphpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\nphpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\nphpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\nphpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\nphpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\nphpcr_type_props.on_parent_version AS property_on_parent_version,\nphpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\nphpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\nphpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\nphpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\nphpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\nphpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\nphpcr_type_childs.primary_types AS child_primary_types\nFROM\nphpcr_type_nodes\nLEFT JOIN\nphpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\nLEFT JOIN\nphpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
"""
(parameters:
[]
, types:
[]
)
doctrine
[
"sql" => """
\nSELECT\nphpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,\nphpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,\nphpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,\nphpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,\nphpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,\nphpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,\nphpcr_type_props.on_parent_version AS property_on_parent_version,\nphpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,\nphpcr_type_props.fulltext_searchable AS property_fulltext_searchable,\nphpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,\nphpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,\nphpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,\nphpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,\nphpcr_type_childs.primary_types AS child_primary_types\nFROM\nphpcr_type_nodes\nLEFT JOIN\nphpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id\nLEFT JOIN\nphpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id\n
"""
"params" => []
"types" => []
]
debug
Executing statement:
"SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.path LIKE '/cmf/bernard_nicod_commercial/contents/%' OR n0.path = '/cmf/bernard_nicod_commercial/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:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.path LIKE '/cmf/bernard_nicod_commercial/contents/%' OR n0.path = '/cmf/bernard_nicod_commercial/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"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/louer' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/louer' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services/louer' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services/louer' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/actualites/est-ce-le-moment-de-vendre-mon-bien-immobilier' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/actualites/est-ce-le-moment-de-vendre-mon-bien-immobilier' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/acheter' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/acheter' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/a-propos' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/a-propos' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/lausanne-gare' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/lausanne-gare' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services/acheter' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services/acheter' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/actualites/quel-est-le-meilleur-moyen-de-vendre-un-bien-immobilier' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/actualites/quel-est-le-meilleur-moyen-de-vendre-un-bien-immobilier' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/lausanne-benjamin-constant' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/lausanne-benjamin-constant' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services/vendre' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services/vendre' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/nyon' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/nyon' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/actualites/trouver-et-financer-la-maison-ou-l-appartement-de-vos-reves' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/actualites/trouver-et-financer-la-maison-ou-l-appartement-de-vos-reves' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services/estimer' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services/estimer' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/geneve' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/geneve' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/actualites/louer-un-bien-sans-agence-un-processus-couteux-et-fastidieux' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/actualites/louer-un-bien-sans-agence-un-processus-couteux-et-fastidieux' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/actualites' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/actualites' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services/investir' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services/investir' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/morges' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/morges' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/yverdon' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/yverdon' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/nos-services/trouver-un-locataire' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/nos-services/trouver-un-locataire' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/vevey' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/vevey' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/montreux' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/montreux' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/faq' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/faq' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/aigle' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/aigle' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/groupe-bn' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/groupe-bn' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/politique-de-confidentialite' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/politique-de-confidentialite' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"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/bernard_nicod_commercial/contents/contact/monthey' LIMIT 1"
(parameters:
[1 => "default_live"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => "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/bernard_nicod_commercial/contents/contact/monthey' LIMIT 1"
"params" => [1 => "default_live"
]
"types" => [1 => 2]
]
deprecation
User Deprecated: Since symfony/security-bundle 5.4: Setting the $authenticatorManagerEnabled argument of "Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector::__construct" to "false" is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/http-kernel 5.3: "Symfony\Component\HttpKernel\Event\KernelEvent::isMasterRequest()" is deprecated, use "isMainRequest()" instead.
[
"sql" => """
SELECT DISTINCT k.CONSTRAINT_NAME,\n k.COLUMN_NAME,\n k.REFERENCED_TABLE_NAME,\n k.REFERENCED_COLUMN_NAME,\n k.ORDINAL_POSITION /*!50116,\n c.UPDATE_RULE,\n c.DELETE_RULE */\nFROM information_schema.key_column_usage k /*!50116\nINNER JOIN information_schema.referential_constraints c\nON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\nAND c.TABLE_NAME = k.TABLE_NAME\nAND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
"""
"params" => [1 => "rm9b6_bn_invest"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"""
SELECT c.COLUMN_NAME AS field,\n c.COLUMN_TYPE AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_SCHEMA = c.TABLE_SCHEMA\n AND t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""
[
"sql" => """
SELECT c.COLUMN_NAME AS field,\n c.COLUMN_TYPE AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_SCHEMA = c.TABLE_SCHEMA\n AND t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""
"params" => [1 => "rm9b6_bn_invest"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"""
SELECT NON_UNIQUE AS Non_Unique,\n INDEX_NAME AS Key_name,\n COLUMN_NAME AS Column_Name,\n SUB_PART AS Sub_Part,\n INDEX_TYPE AS Index_Type\nFROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
"""