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.
"SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.agency_name AS agency_name_3, t0.agency_reference AS agency_reference_4, t0.lastupdate AS lastupdate_5, t0.status_id AS status_id_6, t0.reference AS reference_7, t0.name AS name_8, t0.adresse AS adresse_9, t0.price AS price_10, t0.surface AS surface_11, t0.rooms AS rooms_12, t0.bathrooms AS bathrooms_13, t0.showerrooms AS showerrooms_14, t0.bedrooms AS bedrooms_15, t0.floor AS floor_16, t0.description AS description_17, t0.promotion_id AS promotion_id_18, t0.transaction_type AS transaction_type_19, t0.enabled AS enabled_20, t0.featured AS featured_21, t0.type_property AS type_property_22, t0.longitude AS longitude_23, t0.latitude AS latitude_24, t0.zip AS zip_25, t0.videos_object AS videos_object_26, t0.visit3ds_object AS visit3ds_object_27, t0.disponibilite_date AS disponibilite_date_28, t0.status AS status_29, t0.country_fr AS country_fr_30, t0.district_fr AS district_fr_31, t0.canton_fr AS canton_fr_32, t0.quarter_fr AS quarter_fr_33, t0.zone_fr AS zone_fr_34, t0.city_fr AS city_fr_35, t0.disponible_fr AS disponible_fr_36, t0.broker_id AS broker_id_37, t0.country_id AS country_id_38, t0.canton_id AS canton_id_39, t0.district_id AS district_id_40, t0.quarter_id AS quarter_id_41, t0.zone_id AS zone_id_42, t0.city_id AS city_id_43, t0.type_id AS type_id_44, t0.disponible_id AS disponible_id_45 FROM property t0 WHERE t0.id = ?"
(parameters:
[1 => 126]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.agency_name AS agency_name_3, t0.agency_reference AS agency_reference_4, t0.lastupdate AS lastupdate_5, t0.status_id AS status_id_6, t0.reference AS reference_7, t0.name AS name_8, t0.adresse AS adresse_9, t0.price AS price_10, t0.surface AS surface_11, t0.rooms AS rooms_12, t0.bathrooms AS bathrooms_13, t0.showerrooms AS showerrooms_14, t0.bedrooms AS bedrooms_15, t0.floor AS floor_16, t0.description AS description_17, t0.promotion_id AS promotion_id_18, t0.transaction_type AS transaction_type_19, t0.enabled AS enabled_20, t0.featured AS featured_21, t0.type_property AS type_property_22, t0.longitude AS longitude_23, t0.latitude AS latitude_24, t0.zip AS zip_25, t0.videos_object AS videos_object_26, t0.visit3ds_object AS visit3ds_object_27, t0.disponibilite_date AS disponibilite_date_28, t0.status AS status_29, t0.country_fr AS country_fr_30, t0.district_fr AS district_fr_31, t0.canton_fr AS canton_fr_32, t0.quarter_fr AS quarter_fr_33, t0.zone_fr AS zone_fr_34, t0.city_fr AS city_fr_35, t0.disponible_fr AS disponible_fr_36, t0.broker_id AS broker_id_37, t0.country_id AS country_id_38, t0.canton_id AS canton_id_39, t0.district_id AS district_id_40, t0.quarter_id AS quarter_id_41, t0.zone_id AS zone_id_42, t0.city_id AS city_id_43, t0.type_id AS type_id_44, t0.disponible_id AS disponible_id_45 FROM property t0 WHERE t0.id = ?"
"params" => [1 => 126]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?"
(parameters:
[1 => 6]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?"
"params" => [1 => 6]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?"
(parameters:
[1 => 126]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?"
"params" => [1 => 126]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.broker_id AS broker_id_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.job AS job_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile AS mobile_8 FROM broker t0 WHERE t0.id = ?"
(parameters:
[1 => 6]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.broker_id AS broker_id_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.job AS job_5, t0.email AS email_6, t0.phone AS phone_7, t0.mobile AS mobile_8 FROM broker t0 WHERE t0.id = ?"
"params" => [1 => 6]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT DISTINCT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, SQRT((p1_.latitude - p0_.latitude) * (p1_.latitude - p0_.latitude) + (p1_.longitude - p0_.longitude) * (p1_.longitude - p0_.longitude)) AS sclr_36, p0_.broker_id AS broker_id_37, p0_.country_id AS country_id_38, p0_.canton_id AS canton_id_39, p0_.district_id AS district_id_40, p0_.quarter_id AS quarter_id_41, p0_.zone_id AS zone_id_42, p0_.city_id AS city_id_43, p0_.type_id AS type_id_44, p0_.disponible_id AS disponible_id_45 FROM property p0_ INNER JOIN property p1_ WHERE p0_.transaction_type = ? AND p1_.id = 126 AND p0_.id <> 126 AND p1_.type_id = p0_.type_id AND p0_.surface <= p1_.surface + (p1_.surface * 0.5) AND p0_.surface >= p1_.surface - (p1_.surface * 0.5) AND p0_.price <= p1_.price + (p1_.price * 0.5) AND p0_.price >= p1_.price - (p1_.price * 0.5) HAVING sclr_36 <= 35000 ORDER BY p0_.id DESC"
(parameters:
[1 => 2]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT DISTINCT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, SQRT((p1_.latitude - p0_.latitude) * (p1_.latitude - p0_.latitude) + (p1_.longitude - p0_.longitude) * (p1_.longitude - p0_.longitude)) AS sclr_36, p0_.broker_id AS broker_id_37, p0_.country_id AS country_id_38, p0_.canton_id AS canton_id_39, p0_.district_id AS district_id_40, p0_.quarter_id AS quarter_id_41, p0_.zone_id AS zone_id_42, p0_.city_id AS city_id_43, p0_.type_id AS type_id_44, p0_.disponible_id AS disponible_id_45 FROM property p0_ INNER JOIN property p1_ WHERE p0_.transaction_type = ? AND p1_.id = 126 AND p0_.id <> 126 AND p1_.type_id = p0_.type_id AND p0_.surface <= p1_.surface + (p1_.surface * 0.5) AND p0_.surface >= p1_.surface - (p1_.surface * 0.5) AND p0_.price <= p1_.price + (p1_.price * 0.5) AND p0_.price >= p1_.price - (p1_.price * 0.5) HAVING sclr_36 <= 35000 ORDER BY p0_.id DESC"
"params" => [1 => 2]
"types" => [1 => 1]
]
User Deprecated: The "urls" variable is deprecated, set "localizations" instead in the "seo.html.twig". ("@SuluWebsite/Extension/seo.html.twig" at line 9).
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.
[
"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
"""
"SELECT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, p0_.broker_id AS broker_id_36, p0_.country_id AS country_id_37, p0_.canton_id AS canton_id_38, p0_.district_id AS district_id_39, p0_.quarter_id AS quarter_id_40, p0_.zone_id AS zone_id_41, p0_.city_id AS city_id_42, p0_.type_id AS type_id_43, p0_.disponible_id AS disponible_id_44 FROM property p0_ INNER JOIN type t1_ ON p0_.type_id = t1_.id WHERE p0_.transaction_type = ? ORDER BY p0_.id DESC"
(parameters:
[1 => 2]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, p0_.broker_id AS broker_id_36, p0_.country_id AS country_id_37, p0_.canton_id AS canton_id_38, p0_.district_id AS district_id_39, p0_.quarter_id AS quarter_id_40, p0_.zone_id AS zone_id_41, p0_.city_id AS city_id_42, p0_.type_id AS type_id_43, p0_.disponible_id AS disponible_id_44 FROM property p0_ INNER JOIN type t1_ ON p0_.type_id = t1_.id WHERE p0_.transaction_type = ? ORDER BY p0_.id DESC"
"params" => [1 => 2]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?"
(parameters:
[1 => 10]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?"
"params" => [1 => 10]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?"
(parameters:
[1 => 137]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?"
"params" => [1 => 137]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?"
(parameters:
[1 => 5]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = ?"
"params" => [1 => 5]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?"
(parameters:
[1 => 135]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = ?"
"params" => [1 => 135]
"types" => [1 => 1]
]
[
"sql" => "SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC"
"params" => [1 => "/cmf/bernard_nicod_commercial"
2 => "default_live"
]
"types" => [1 => 22 => 2]
]
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 id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order\n FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
"""
User Deprecated: Since symfony/http-kernel 5.3: "Symfony\Component\HttpKernel\Event\KernelEvent::isMasterRequest()" is deprecated, use "isMainRequest()" instead.
"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, w1_.id ASC"
[
"sql" => "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, w1_.id ASC"
"params" => [1 => "bn-invest-com.ewm.dev"
2 => "dev"
3 => "bernard_nicod_commercial"
]
"types" => [1 => 22 => 23 => 2]
]