Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.hektor_id AS hektor_id_1,
  p0_.hektor_agency_code AS hektor_agency_code_2,
  p0_.reference AS reference_3,
  p0_.hektor_payload_hash AS hektor_payload_hash_4,
  p0_.last_seen_in_export_at AS last_seen_in_export_at_5,
  p0_.archived_from_export_at AS archived_from_export_at_6,
  p0_.sold_at AS sold_at_7,
  p0_.last_synced_at AS last_synced_at_8,
  p0_.transaction_type AS transaction_type_9,
  p0_.property_type AS property_type_10,
  p0_.property_sub_type AS property_sub_type_11,
  p0_.price AS price_12,
  p0_.fees AS fees_13,
  p0_.fees_paid_by AS fees_paid_by_14,
  p0_.price_excluding_fees AS price_excluding_fees_15,
  p0_.living_surface AS living_surface_16,
  p0_.land_surface AS land_surface_17,
  p0_.rooms AS rooms_18,
  p0_.bedrooms AS bedrooms_19,
  p0_.bathrooms AS bathrooms_20,
  p0_.shower_rooms AS shower_rooms_21,
  p0_.toilets AS toilets_22,
  p0_.floor AS floor_23,
  p0_.floors_count AS floors_count_24,
  p0_.construction_year AS construction_year_25,
  p0_.title AS title_26,
  p0_.description AS description_27,
  p0_.postal_code_raw AS postal_code_raw_28,
  p0_.city_raw AS city_raw_29,
  p0_.address AS address_30,
  p0_.latitude AS latitude_31,
  p0_.longitude AS longitude_32,
  p0_.energy_class AS energy_class_33,
  p0_.energy_value AS energy_value_34,
  p0_.ges_class AS ges_class_35,
  p0_.ges_value AS ges_value_36,
  p0_.exclusive_mandate AS exclusive_mandate_37,
  p0_.favorite AS favorite_38,
  p0_.prestige AS prestige_39,
  p0_.investment AS investment_40,
  p0_.contact_phone AS contact_phone_41,
  p0_.contact_name AS contact_name_42,
  p0_.contact_email AS contact_email_43,
  p0_.hektor_advisor_code AS hektor_advisor_code_44,
  p0_.virtual_tour_url AS virtual_tour_url_45,
  p0_.fees_schedule_url AS fees_schedule_url_46,
  p0_.status AS status_47,
  p0_.visibility AS visibility_48,
  p0_.segment AS segment_49,
  p0_.segment_forced AS segment_forced_50,
  p0_.featured AS featured_51,
  p0_.show_on_homepage AS show_on_homepage_52,
  p0_.price_hidden AS price_hidden_53,
  p0_.created_at AS created_at_54,
  p0_.updated_at AS updated_at_55,
  p0_.deleted_at AS deleted_at_56,
  p0_.agency_id AS agency_id_57,
  p0_.territory_id AS territory_id_58,
  p0_.city_id AS city_id_59,
  p0_.district_id AS district_id_60,
  p0_.advisor_id AS advisor_id_61
FROM
  properties p0_
  INNER JOIN property_seo p1_ ON p0_.id = p1_.property_id
WHERE
  (
    p1_.slug = ?
    AND p0_.status = ?
    AND p0_.visibility = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.hektor_id AS hektor_id_1, p0_.hektor_agency_code AS hektor_agency_code_2, p0_.reference AS reference_3, p0_.hektor_payload_hash AS hektor_payload_hash_4, p0_.last_seen_in_export_at AS last_seen_in_export_at_5, p0_.archived_from_export_at AS archived_from_export_at_6, p0_.sold_at AS sold_at_7, p0_.last_synced_at AS last_synced_at_8, p0_.transaction_type AS transaction_type_9, p0_.property_type AS property_type_10, p0_.property_sub_type AS property_sub_type_11, p0_.price AS price_12, p0_.fees AS fees_13, p0_.fees_paid_by AS fees_paid_by_14, p0_.price_excluding_fees AS price_excluding_fees_15, p0_.living_surface AS living_surface_16, p0_.land_surface AS land_surface_17, p0_.rooms AS rooms_18, p0_.bedrooms AS bedrooms_19, p0_.bathrooms AS bathrooms_20, p0_.shower_rooms AS shower_rooms_21, p0_.toilets AS toilets_22, p0_.floor AS floor_23, p0_.floors_count AS floors_count_24, p0_.construction_year AS construction_year_25, p0_.title AS title_26, p0_.description AS description_27, p0_.postal_code_raw AS postal_code_raw_28, p0_.city_raw AS city_raw_29, p0_.address AS address_30, p0_.latitude AS latitude_31, p0_.longitude AS longitude_32, p0_.energy_class AS energy_class_33, p0_.energy_value AS energy_value_34, p0_.ges_class AS ges_class_35, p0_.ges_value AS ges_value_36, p0_.exclusive_mandate AS exclusive_mandate_37, p0_.favorite AS favorite_38, p0_.prestige AS prestige_39, p0_.investment AS investment_40, p0_.contact_phone AS contact_phone_41, p0_.contact_name AS contact_name_42, p0_.contact_email AS contact_email_43, p0_.hektor_advisor_code AS hektor_advisor_code_44, p0_.virtual_tour_url AS virtual_tour_url_45, p0_.fees_schedule_url AS fees_schedule_url_46, p0_.status AS status_47, p0_.visibility AS visibility_48, p0_.segment AS segment_49, p0_.segment_forced AS segment_forced_50, p0_.featured AS featured_51, p0_.show_on_homepage AS show_on_homepage_52, p0_.price_hidden AS price_hidden_53, p0_.created_at AS created_at_54, p0_.updated_at AS updated_at_55, p0_.deleted_at AS deleted_at_56, p0_.agency_id AS agency_id_57, p0_.territory_id AS territory_id_58, p0_.city_id AS city_id_59, p0_.district_id AS district_id_60, p0_.advisor_id AS advisor_id_61 FROM properties p0_ INNER JOIN property_seo p1_ ON p0_.id = p1_.property_id WHERE (p1_.slug = 'appartement-lyon-202602025-holl-156' AND p0_.status = 'available' AND p0_.visibility = 'public') AND (p0_.deleted_at IS NULL);

SELECT
  p0_.id AS id_0,
  p0_.hektor_id AS hektor_id_1,
  p0_.hektor_agency_code AS hektor_agency_code_2,
  p0_.reference AS reference_3,
  p0_.hektor_payload_hash AS hektor_payload_hash_4,
  p0_.last_seen_in_export_at AS last_seen_in_export_at_5,
  p0_.archived_from_export_at AS archived_from_export_at_6,
  p0_.sold_at AS sold_at_7,
  p0_.last_synced_at AS last_synced_at_8,
  p0_.transaction_type AS transaction_type_9,
  p0_.property_type AS property_type_10,
  p0_.property_sub_type AS property_sub_type_11,
  p0_.price AS price_12,
  p0_.fees AS fees_13,
  p0_.fees_paid_by AS fees_paid_by_14,
  p0_.price_excluding_fees AS price_excluding_fees_15,
  p0_.living_surface AS living_surface_16,
  p0_.land_surface AS land_surface_17,
  p0_.rooms AS rooms_18,
  p0_.bedrooms AS bedrooms_19,
  p0_.bathrooms AS bathrooms_20,
  p0_.shower_rooms AS shower_rooms_21,
  p0_.toilets AS toilets_22,
  p0_.floor AS floor_23,
  p0_.floors_count AS floors_count_24,
  p0_.construction_year AS construction_year_25,
  p0_.title AS title_26,
  p0_.description AS description_27,
  p0_.postal_code_raw AS postal_code_raw_28,
  p0_.city_raw AS city_raw_29,
  p0_.address AS address_30,
  p0_.latitude AS latitude_31,
  p0_.longitude AS longitude_32,
  p0_.energy_class AS energy_class_33,
  p0_.energy_value AS energy_value_34,
  p0_.ges_class AS ges_class_35,
  p0_.ges_value AS ges_value_36,
  p0_.exclusive_mandate AS exclusive_mandate_37,
  p0_.favorite AS favorite_38,
  p0_.prestige AS prestige_39,
  p0_.investment AS investment_40,
  p0_.contact_phone AS contact_phone_41,
  p0_.contact_name AS contact_name_42,
  p0_.contact_email AS contact_email_43,
  p0_.hektor_advisor_code AS hektor_advisor_code_44,
  p0_.virtual_tour_url AS virtual_tour_url_45,
  p0_.fees_schedule_url AS fees_schedule_url_46,
  p0_.status AS status_47,
  p0_.visibility AS visibility_48,
  p0_.segment AS segment_49,
  p0_.segment_forced AS segment_forced_50,
  p0_.featured AS featured_51,
  p0_.show_on_homepage AS show_on_homepage_52,
  p0_.price_hidden AS price_hidden_53,
  p0_.created_at AS created_at_54,
  p0_.updated_at AS updated_at_55,
  p0_.deleted_at AS deleted_at_56,
  p0_.agency_id AS agency_id_57,
  p0_.territory_id AS territory_id_58,
  p0_.city_id AS city_id_59,
  p0_.district_id AS district_id_60,
  p0_.advisor_id AS advisor_id_61
FROM
  properties p0_
WHERE
  (
    p0_.id <> ?
    AND p0_.status = ?
    AND p0_.visibility = ?
    AND p0_.transaction_type = ?
    AND p0_.city_id = ?
  )
  AND (p0_.deleted_at IS NULL)
LIMIT
  3

SELECT p0_.id AS id_0, p0_.hektor_id AS hektor_id_1, p0_.hektor_agency_code AS hektor_agency_code_2, p0_.reference AS reference_3, p0_.hektor_payload_hash AS hektor_payload_hash_4, p0_.last_seen_in_export_at AS last_seen_in_export_at_5, p0_.archived_from_export_at AS archived_from_export_at_6, p0_.sold_at AS sold_at_7, p0_.last_synced_at AS last_synced_at_8, p0_.transaction_type AS transaction_type_9, p0_.property_type AS property_type_10, p0_.property_sub_type AS property_sub_type_11, p0_.price AS price_12, p0_.fees AS fees_13, p0_.fees_paid_by AS fees_paid_by_14, p0_.price_excluding_fees AS price_excluding_fees_15, p0_.living_surface AS living_surface_16, p0_.land_surface AS land_surface_17, p0_.rooms AS rooms_18, p0_.bedrooms AS bedrooms_19, p0_.bathrooms AS bathrooms_20, p0_.shower_rooms AS shower_rooms_21, p0_.toilets AS toilets_22, p0_.floor AS floor_23, p0_.floors_count AS floors_count_24, p0_.construction_year AS construction_year_25, p0_.title AS title_26, p0_.description AS description_27, p0_.postal_code_raw AS postal_code_raw_28, p0_.city_raw AS city_raw_29, p0_.address AS address_30, p0_.latitude AS latitude_31, p0_.longitude AS longitude_32, p0_.energy_class AS energy_class_33, p0_.energy_value AS energy_value_34, p0_.ges_class AS ges_class_35, p0_.ges_value AS ges_value_36, p0_.exclusive_mandate AS exclusive_mandate_37, p0_.favorite AS favorite_38, p0_.prestige AS prestige_39, p0_.investment AS investment_40, p0_.contact_phone AS contact_phone_41, p0_.contact_name AS contact_name_42, p0_.contact_email AS contact_email_43, p0_.hektor_advisor_code AS hektor_advisor_code_44, p0_.virtual_tour_url AS virtual_tour_url_45, p0_.fees_schedule_url AS fees_schedule_url_46, p0_.status AS status_47, p0_.visibility AS visibility_48, p0_.segment AS segment_49, p0_.segment_forced AS segment_forced_50, p0_.featured AS featured_51, p0_.show_on_homepage AS show_on_homepage_52, p0_.price_hidden AS price_hidden_53, p0_.created_at AS created_at_54, p0_.updated_at AS updated_at_55, p0_.deleted_at AS deleted_at_56, p0_.agency_id AS agency_id_57, p0_.territory_id AS territory_id_58, p0_.city_id AS city_id_59, p0_.district_id AS district_id_60, p0_.advisor_id AS advisor_id_61 FROM properties p0_ WHERE (p0_.id <> 0x019F4B80579E746DA814CC5A3E23DBF6 AND p0_.status = 'available' AND p0_.visibility = 'public' AND p0_.transaction_type = 'sale' AND p0_.city_id = '019f4b80-3a37-7adc-a7ab-ad7d5521c91b') AND (p0_.deleted_at IS NULL) LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.source AS source_2,
  t0.status AS status_3,
  t0.position AS position_4,
  t0.source_url AS source_url_5,
  t0.source_url_hash AS source_url_hash_6,
  t0.local_path AS local_path_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.file_size AS file_size_10,
  t0.title AS title_11,
  t0.alt_text AS alt_text_12,
  t0.download_attempts AS download_attempts_13,
  t0.last_error AS last_error_14,
  t0.downloaded_at AS downloaded_at_15,
  t0.orphaned_at AS orphaned_at_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.property_id AS property_id_19
FROM
  property_media t0
WHERE
  t0.property_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.source AS source_2, t0.status AS status_3, t0.position AS position_4, t0.source_url AS source_url_5, t0.source_url_hash AS source_url_hash_6, t0.local_path AS local_path_7, t0.width AS width_8, t0.height AS height_9, t0.file_size AS file_size_10, t0.title AS title_11, t0.alt_text AS alt_text_12, t0.download_attempts AS download_attempts_13, t0.last_error AS last_error_14, t0.downloaded_at AS downloaded_at_15, t0.orphaned_at AS orphaned_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.property_id AS property_id_19 FROM property_media t0 WHERE t0.property_id = 0x019F4B80579E746DA814CC5A3E23DBF6 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.feature_key AS feature_key_2,
  t0.label AS label_3,
  t0.value AS value_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.property_id AS property_id_8
FROM
  property_features t0
WHERE
  t0.property_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.feature_key AS feature_key_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.property_id AS property_id_8 FROM property_features t0 WHERE t0.property_id = 0x019F4B80579E746DA814CC5A3E23DBF6 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legal_name AS legal_name_4,
  t0.commercial_name AS commercial_name_5,
  t0.siret AS siret_6,
  t0.vat_number AS vat_number_7,
  t0.hektor_id AS hektor_id_8,
  t0.address AS address_9,
  t0.postal_code AS postal_code_10,
  t0.city AS city_11,
  t0.country AS country_12,
  t0.phone AS phone_13,
  t0.email AS email_14,
  t0.website_url AS website_url_15,
  t0.logo_url AS logo_url_16,
  t0.primary_color AS primary_color_17,
  t0.secondary_color AS secondary_color_18,
  t0.google_business_url AS google_business_url_19,
  t0.google_review_url AS google_review_url_20,
  t0.linkedin_url AS linkedin_url_21,
  t0.facebook_url AS facebook_url_22,
  t0.instagram_url AS instagram_url_23,
  t0.youtube_url AS youtube_url_24,
  t0.latitude AS latitude_25,
  t0.longitude AS longitude_26,
  t0.status AS status_27,
  t0.seo_title AS seo_title_28,
  t0.seo_meta_description AS seo_meta_description_29,
  t0.seo_h1 AS seo_h1_30,
  t0.seo_content AS seo_content_31,
  t0.created_at AS created_at_32,
  t0.updated_at AS updated_at_33,
  t0.deleted_at AS deleted_at_34
FROM
  agencies t0
WHERE
  t0.status = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legal_name AS legal_name_4, t0.commercial_name AS commercial_name_5, t0.siret AS siret_6, t0.vat_number AS vat_number_7, t0.hektor_id AS hektor_id_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.email AS email_14, t0.website_url AS website_url_15, t0.logo_url AS logo_url_16, t0.primary_color AS primary_color_17, t0.secondary_color AS secondary_color_18, t0.google_business_url AS google_business_url_19, t0.google_review_url AS google_review_url_20, t0.linkedin_url AS linkedin_url_21, t0.facebook_url AS facebook_url_22, t0.instagram_url AS instagram_url_23, t0.youtube_url AS youtube_url_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.status AS status_27, t0.seo_title AS seo_title_28, t0.seo_meta_description AS seo_meta_description_29, t0.seo_h1 AS seo_h1_30, t0.seo_content AS seo_content_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.deleted_at AS deleted_at_34 FROM agencies t0 WHERE t0.status = 'active' AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.seo_title AS seo_title_3,
  t0.seo_meta_description AS seo_meta_description_4,
  t0.seo_h1 AS seo_h1_5,
  t0.enriched_description AS enriched_description_6,
  t0.faq AS faq_7,
  t0.canonical_url AS canonical_url_8,
  t0.robots AS robots_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.property_id AS property_id_12
FROM
  property_seo t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.seo_title AS seo_title_3, t0.seo_meta_description AS seo_meta_description_4, t0.seo_h1 AS seo_h1_5, t0.enriched_description AS enriched_description_6, t0.faq AS faq_7, t0.canonical_url AS canonical_url_8, t0.robots AS robots_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.property_id AS property_id_12 FROM property_seo t0 WHERE t0.property_id = 0x019F4B80579E746DA814CC5A3E23DBF6;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.published AS published_5,
  t0.in_footer AS in_footer_6,
  t0.position AS position_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  legal_pages t0
WHERE
  t0.published = ?
  AND t0.in_footer = ?
ORDER BY
  t0.position ASC,
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.published AS published_5, t0.in_footer AS in_footer_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM legal_pages t0 WHERE t0.published = 1 AND t0.in_footer = 1 ORDER BY t0.position ASC, t0.title ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.category AS category_2,
  t0_.placement AS placement_3,
  t0_.code AS code_4,
  t0_.enabled AS enabled_5,
  t0_.position AS position_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  tracking_scripts t0_
WHERE
  t0_.enabled = 1
ORDER BY
  t0_.position ASC,
  t0_.created_at ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.category AS category_2, t0_.placement AS placement_3, t0_.code AS code_4, t0_.enabled AS enabled_5, t0_.position AS position_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM tracking_scripts t0_ WHERE t0_.enabled = 1 ORDER BY t0_.position ASC, t0_.created_at ASC;