Symfony Profiler

[
  "route" => "front_property_show"
  "route_parameters" => [
    "_route" => "front_property_show"
    "_controller" => "App\Front\Controller\PropertyController::show"
    "slug" => "appartement-ecully-20220021"
  ]
  "request_uri" => "https://carrier.alpium.com/bien/appartement-ecully-20220021"
  "method" => "GET"
]

[
  "firewall_name" => "customer"
  "authenticators" => 2
]

[
  "firewall_name" => "customer"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "customer"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "customer"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "customer"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "pb16jo.myd.infomaniak.com"
    "port" => 3306
    "user" => "pb16jo_carrier"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "pb16jo_carrier"
    "serverVersion" => "10.11.15-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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)"
  "params" => [
    1 => "appartement-ecully-20220021"
    2 => "available"
    3 => "public"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1220
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1220}
    3 => Doctrine\DBAL\ParameterType {#1220}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => b"\x01ŸK€VŒt\x06¹žëPVzë‰"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1220
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x01ŸK€VŒt\x06¹žëPVzë‰"
    2 => "available"
    3 => "public"
    4 => "sale"
    5 => Symfony\Component\Uid\UuidV7 {#1371
      #uid: "019f4b80-3a45-7a5c-b52e-c3019fdea856"
      toBase58: "1CctCAMo6KXKUT7rypzzUV"
      toBase32: "01KX5R0EJ5F9EBABP306FXXA2P"
      time: "2026-07-10 10:08:42.565663 UTC"
    }
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1220
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1220}
    3 => Doctrine\DBAL\ParameterType {#1220}
    4 => Doctrine\DBAL\ParameterType {#1220}
    5 => Doctrine\DBAL\ParameterType {#1220}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x01ŸK€VŒt\x06¹žëPVzë‰"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1220
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => b"\x01ŸK€VŒt\x06¹žëPVzë‰"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1220
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1220
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2508
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#2508}
  ]
]

[
  "sql" => "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"
]