Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.private AS private_3,
  p0_.level AS level_4,
  p0_._left AS _left_5,
  p0_._right AS _right_6,
  p0_.root AS root_7,
  p0_.compound_related AS compound_related_8,
  p0_.reference_id AS reference_id_9,
  p0_.exchangeable AS exchangeable_10,
  p0_.is_evaluable AS is_evaluable_11,
  p0_.synced AS synced_12,
  p0_.searchable AS searchable_13,
  p0_.deleted_at AS deleted_at_14,
  p0_.custom_order AS custom_order_15,
  p0_.parent_id AS parent_id_16
FROM
  property_types p0_
WHERE
  (p0_.parent_id IS NULL)
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_._left ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.private AS private_3, p0_.level AS level_4, p0_._left AS _left_5, p0_._right AS _right_6, p0_.root AS root_7, p0_.compound_related AS compound_related_8, p0_.reference_id AS reference_id_9, p0_.exchangeable AS exchangeable_10, p0_.is_evaluable AS is_evaluable_11, p0_.synced AS synced_12, p0_.searchable AS searchable_13, p0_.deleted_at AS deleted_at_14, p0_.custom_order AS custom_order_15, p0_.parent_id AS parent_id_16 FROM property_types p0_ WHERE (p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL) ORDER BY p0_._left ASC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.url AS url_2,
  a0_.description AS description_3,
  a0_.customer_title AS customer_title_4,
  a0_.customer_url AS customer_url_5,
  a0_.customer_description AS customer_description_6,
  a0_.end_at AS end_at_7,
  a0_.start_at AS start_at_8,
  a0_.color AS color_9,
  a0_.counter AS counter_10,
  a0_.top_bar AS top_bar_11,
  a0_.appear_on_mobile AS appear_on_mobile_12
FROM
  announcements a0_
WHERE
  a0_.top_bar IN (?)
  AND a0_.end_at >= ?

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (1) AND a0_.end_at >= '2025-01-18 03:46:20';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.alias AS alias_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.lat AS lat_6,
  t0.lon AS lon_7,
  t0.zoom AS zoom_8,
  t0.coordinates AS coordinates_9,
  t0.searchable AS searchable_10,
  t0.home_filter AS home_filter_11,
  t0.statistics_filter AS statistics_filter_12,
  t0.neighborhood_filter AS neighborhood_filter_13,
  t0.compound_filter AS compound_filter_14,
  t0.estimate AS estimate_15,
  t0.disabled AS disabled_16,
  t0.synced AS synced_17,
  t0.level AS level_18,
  t0._left AS _left_19,
  t0._right AS _right_20,
  t0.root AS root_21,
  t0.leads_counter AS leads_counter_22,
  t0.listings_counter AS listings_counter_23,
  t0.keyword AS keyword_24,
  t0.full_path AS full_path_25,
  t0.reference_id AS reference_id_26,
  t0.type AS type_27,
  t0.eligible_for_mortgage AS eligible_for_mortgage_28,
  t0.is_compound_location AS is_compound_location_29,
  t0.parent_id AS parent_id_30,
  t0.location_compound_id AS location_compound_id_31,
  t0.rating_id AS rating_id_32,
  t0.listing_id AS listing_id_33
FROM
  locations t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.slug IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.main AS main_6,
  t0.searchable AS searchable_7,
  t0.slug AS slug_8,
  t0.synced AS synced_9,
  t0.reference_id AS reference_id_10,
  t0.meta_search_description AS meta_search_description_11
FROM
  sections t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.private AS private_4,
  t0.level AS level_5,
  t0._left AS _left_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.compound_related AS compound_related_9,
  t0.reference_id AS reference_id_10,
  t0.exchangeable AS exchangeable_11,
  t0.is_evaluable AS is_evaluable_12,
  t0.synced AS synced_13,
  t0.searchable AS searchable_14,
  t0.deleted_at AS deleted_at_15,
  t0.custom_order AS custom_order_16,
  t0.parent_id AS parent_id_17
FROM
  property_types t0
WHERE
  t0.slug IS NULL
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE t0.slug IS NULL AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.main AS main_6,
  t0.searchable AS searchable_7,
  t0.slug AS slug_8,
  t0.synced AS synced_9,
  t0.reference_id AS reference_id_10,
  t0.meta_search_description AS meta_search_description_11
FROM
  sections t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.slug IS NULL LIMIT 1;