GET https://oakswell.ewm.dev/en/properties/lot-3-opportunite-rare-a-celigny-superbe-5-pieces-avec-terrasse-de-26-m2/RKG4-2D68

Response
200 OK
IP
216.73.216.55
Profiled on
Token
89e267

Query Metrics

27 Database Queries
13 Different statements
5.86 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.19 ms 
SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.lot_reference AS lot_reference_3, t0.status AS status_4, t0.offer_type AS offer_type_5, t0.currency AS currency_6, t0.sale_price AS sale_price_7, t0.rent_net AS rent_net_8, t0.rent_extra AS rent_extra_9, t0.title_translations AS title_translations_10, t0.description_translations AS description_translations_11, t0.available_from AS available_from_12, t0.hide_price AS hide_price_13, t0.virtual_visit_url AS virtual_visit_url_14, t0.video_url AS video_url_15, t0.lat AS lat_16, t0.lng AS lng_17, t0.route AS route_18, t0.locality_translations AS locality_translations_19, t0.state_translations AS state_translations_20, t0.postcode AS postcode_21, t0.country_code AS country_code_22, t0.number_of_rooms AS number_of_rooms_23, t0.number_of_bedrooms AS number_of_bedrooms_24, t0.number_of_bathrooms AS number_of_bathrooms_25, t0.number_of_floors AS number_of_floors_26, t0.floor_of_flat AS floor_of_flat_27, t0.living_surface AS living_surface_28, t0.land_surface AS land_surface_29, t0.garden_surface AS garden_surface_30, t0.balcony_surface AS balcony_surface_31, t0.terrace_surface AS terrace_surface_32, t0.weighted_floor_surface AS weighted_floor_surface_33, t0.construction_year AS construction_year_34, t0.renovation_year AS renovation_year_35, t0.heating AS heating_36, t0.number_of_indoor_parkings AS number_of_indoor_parkings_37, t0.number_of_outdoor_parkings AS number_of_outdoor_parkings_38, t0.has_view AS has_view_39, t0.has_elevator AS has_elevator_40, t0.has_gym AS has_gym_41, t0.has_sauna AS has_sauna_42, t0.has_fireplace AS has_fireplace_43, t0.has_swimming_pool AS has_swimming_pool_44, t0.has_cellar AS has_cellar_45, t0.is_child_friendly AS is_child_friendly_46, t0.is_luxury AS is_luxury_47, t0.is_new_development AS is_new_development_48, t0.is_wheelchair_accessible AS is_wheelchair_accessible_49, t0.property_type_name AS property_type_name_50, t0.property_type_label_translations AS property_type_label_translations_51, t0.slug_en AS slug_en_52, t0.slug_fr AS slug_fr_53, t0.images AS images_54, t0.api_created_at AS api_created_at_55, t0.api_updated_at AS api_updated_at_56, t0.synced_at AS synced_at_57, t0.development_id AS development_id_58, t0.broker_id AS broker_id_59, t60.id AS id_61, t60.crm_link AS crm_link_62, t60.first_name AS first_name_63, t60.last_name AS last_name_64, t60.emails AS emails_65, t60.phone_numbers AS phone_numbers_66, t60.appraisal_reason AS appraisal_reason_67, t60.appraisal_perceived_value AS appraisal_perceived_value_68, t60.sale_horizon AS sale_horizon_69, t60.buy_horizon AS buy_horizon_70, t60.source_name AS source_name_71, t60.lead_property_data AS lead_property_data_72, t60.api_created_at AS api_created_at_73, t60.synced_at AS synced_at_74, t60.property_id AS property_id_75 FROM realadvisor_property t0 LEFT JOIN realadvisor_lead t60 ON t60.property_id = t0.id WHERE t0.lot_reference = ? LIMIT 1
Parameters: 
[
  "RKG4-2D68"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.01 ms 
SELECT r0_.id AS id_0, r0_.api_id AS api_id_1, r0_.lot_reference AS lot_reference_2, r0_.status AS status_3, r0_.offer_type AS offer_type_4, r0_.currency AS currency_5, r0_.sale_price AS sale_price_6, r0_.rent_net AS rent_net_7, r0_.rent_extra AS rent_extra_8, r0_.title_translations AS title_translations_9, r0_.description_translations AS description_translations_10, r0_.available_from AS available_from_11, r0_.hide_price AS hide_price_12, r0_.virtual_visit_url AS virtual_visit_url_13, r0_.video_url AS video_url_14, r0_.lat AS lat_15, r0_.lng AS lng_16, r0_.route AS route_17, r0_.locality_translations AS locality_translations_18, r0_.state_translations AS state_translations_19, r0_.postcode AS postcode_20, r0_.country_code AS country_code_21, r0_.number_of_rooms AS number_of_rooms_22, r0_.number_of_bedrooms AS number_of_bedrooms_23, r0_.number_of_bathrooms AS number_of_bathrooms_24, r0_.number_of_floors AS number_of_floors_25, r0_.floor_of_flat AS floor_of_flat_26, r0_.living_surface AS living_surface_27, r0_.land_surface AS land_surface_28, r0_.garden_surface AS garden_surface_29, r0_.balcony_surface AS balcony_surface_30, r0_.terrace_surface AS terrace_surface_31, r0_.weighted_floor_surface AS weighted_floor_surface_32, r0_.construction_year AS construction_year_33, r0_.renovation_year AS renovation_year_34, r0_.heating AS heating_35, r0_.number_of_indoor_parkings AS number_of_indoor_parkings_36, r0_.number_of_outdoor_parkings AS number_of_outdoor_parkings_37, r0_.has_view AS has_view_38, r0_.has_elevator AS has_elevator_39, r0_.has_gym AS has_gym_40, r0_.has_sauna AS has_sauna_41, r0_.has_fireplace AS has_fireplace_42, r0_.has_swimming_pool AS has_swimming_pool_43, r0_.has_cellar AS has_cellar_44, r0_.is_child_friendly AS is_child_friendly_45, r0_.is_luxury AS is_luxury_46, r0_.is_new_development AS is_new_development_47, r0_.is_wheelchair_accessible AS is_wheelchair_accessible_48, r0_.property_type_name AS property_type_name_49, r0_.property_type_label_translations AS property_type_label_translations_50, r0_.slug_en AS slug_en_51, r0_.slug_fr AS slug_fr_52, r0_.images AS images_53, r0_.api_created_at AS api_created_at_54, r0_.api_updated_at AS api_updated_at_55, r0_.synced_at AS synced_at_56, r0_.development_id AS development_id_57, r0_.broker_id AS broker_id_58 FROM realadvisor_property r0_ WHERE r0_.id <> ? AND LOWER(r0_.status) <> ? AND r0_.offer_type = ? ORDER BY r0_.api_updated_at DESC LIMIT 6
Parameters: 
[
  24
  "sold"
  "sell"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.21 ms 
SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.14 ms 
SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.15 ms 
SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.15 ms 
SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.14 ms 
SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.13 ms 
SELECT t0.id AS id_1, t0.crm_link AS crm_link_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.emails AS emails_5, t0.phone_numbers AS phone_numbers_6, t0.appraisal_reason AS appraisal_reason_7, t0.appraisal_perceived_value AS appraisal_perceived_value_8, t0.sale_horizon AS sale_horizon_9, t0.buy_horizon AS buy_horizon_10, t0.source_name AS source_name_11, t0.lead_property_data AS lead_property_data_12, t0.api_created_at AS api_created_at_13, t0.synced_at AS synced_at_14, t0.property_id AS property_id_15 FROM realadvisor_lead t0 WHERE t0.property_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.15 ms 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.11 ms 
SELECT prefix, uri FROM phpcr_namespaces
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.13 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/oakswell"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.11 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/oakswell"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.15 ms 
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.12 ms 
SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
Parameters: 
[
  "default_live"
  "f9f35d88-32f3-474e-8cdd-cc69fb2d50b4"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.10 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/snippets/header/header"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.15 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/snippets/header"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.12 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/snippets/header"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.27 ms 
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.16 ms 
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.16 ms 
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/oakswell/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"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.14 ms 
SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="rightMain"]) > 0')) AND n0.path LIKE '/cmf/oakswell/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"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.15 ms 
SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?)
Parameters: 
[
  "default_live"
  "e24b17ff-f0f6-4ede-b97c-12fcb1db6e8f"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.11 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/snippets/footer/footer"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.13 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/snippets/footer"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.12 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/snippets/footer"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.18 ms 
SELECT t0.id AS id_1, t0.api_id AS api_id_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.linked_in_profile AS linked_in_profile_5, t0.facebook_profile AS facebook_profile_6, t0.instagram_profile AS instagram_profile_7, t0.youtube_profile AS youtube_profile_8, t0.twitter_profile AS twitter_profile_9, t0.primary_phone_number AS primary_phone_number_10, t0.emails AS emails_11, t0.phone_numbers AS phone_numbers_12, t0.image_url AS image_url_13, t0.synced_at AS synced_at_14 FROM realadvisor_broker t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.20 ms 
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters: 
[
  "oakswell.ewm.dev/{localization}"
  "dev"
  "oakswell"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Property 7
App\Entity\Broker 2
App\Entity\Development 1

Entities Mapping

Class Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
App\Entity\Property No errors.
App\Entity\Development No errors.
App\Entity\Broker No errors.
App\Entity\Lead No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.