Symfony Profiler

[
  "route" => "app_contact_new"
  "route_parameters" => [
    "_route" => "app_contact_new"
    "_controller" => "App\Controller\ContactController::new"
    "_locale" => "de"
  ]
  "request_uri" => "https://liberate-gvs.ch/kontakte/kreieren"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "10.0.0.138"
    "port" => 3306
    "user" => "liberate"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "liberate"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.name AS name_6, t0.locale AS locale_7, t0.picture AS picture_8 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "project@propertyowner.ch"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\LocaleSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerOUyFbEo\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => """
    SELECT p.property_id, p.id\n
    FROM property AS p
    """
]

[
  "sql" => "SELECT t0.id AS id_1, t0.revision AS revision_2, t0.public_id AS public_id_3, t0.offer_type AS offer_type_4, t0.sell_price AS sell_price_5, t0.rent_price AS rent_price_6, t0.publishing_status AS publishing_status_7, t0.apartments_count AS apartments_count_8, t0.rooms_count AS rooms_count_9, t0.bathrooms_count AS bathrooms_count_10, t0.floor AS floor_11, t0.floors_count AS floors_count_12, t0.living_area AS living_area_13, t0.land_area AS land_area_14, t0.usable_area AS usable_area_15, t0.ceiling_height AS ceiling_height_16, t0.year_built AS year_built_17, t0.last_renovation AS last_renovation_18, t0.calendly_url AS calendly_url_19, t0.tour_first_date_delay AS tour_first_date_delay_20, t0.tour_week_days AS tour_week_days_21, t0.waiting_list_active AS waiting_list_active_22, t0.favourite_richard AS favourite_richard_23, t0.location_optimiser_active AS location_optimiser_active_24, t0.video AS video_25, t0.video2 AS video2_26, t0.virtual_tour AS virtual_tour_27, t0.title AS title_28, t0.description_results AS description_results_29, t0.description_detail_view AS description_detail_view_30, t0.benefits AS benefits_31, t0.description_external_portals AS description_external_portals_32, t0.property_id AS property_id_33, t0.wordpress_export_active AS wordpress_export_active_34, t0.wordpress_exported_revision AS wordpress_exported_revision_35, t0.wordpress_page_url AS wordpress_page_url_36, t0.wordpress_post_id AS wordpress_post_id_37, t0.main_language AS main_language_38, t0.draft_at AS draft_at_39, t0.paused_at AS paused_at_40, t0.archived_at AS archived_at_41, t0.on_air_at AS on_air_at_42, t0.reserved_at AS reserved_at_43, t0.sold_or_rented_at AS sold_or_rented_at_44, t0.automatic_translation_disabled AS automatic_translation_disabled_45, t0.automatic_translated AS automatic_translated_46, t0.first_published_at AS first_published_at_47, t0.edit_lock_until AS edit_lock_until_48, t0.forced_publishing_phases AS forced_publishing_phases_49, t0.disallowed_publishing_phases AS disallowed_publishing_phases_50, t0.created_at AS created_at_51, t0.updated_at AS updated_at_52, t0.category_id AS category_id_53, t0.object_type_id AS object_type_id_54, t0.agent_id AS agent_id_55, t0.address_id AS address_id_56, t0.cloned_from_id AS cloned_from_id_57, t0.edit_lock_by_user_id AS edit_lock_by_user_id_58, t0.mandate_id AS mandate_id_59 FROM property t0 WHERE t0.id = ?"
  "params" => [
    1 => 170
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "170"
    2 => "de"
    3 => "App\Entity\Property"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "INSERT INTO contact (gender, name, phone, email, street, zip_code, city, message, submission_date, language, sales_documentation_request, viewing_request, property_question, status, manually_inserted, external_id, external_portal, public_id, sent_to_customer, copper_response, hidden, auto_reply_sent, created_at, updated_at, property_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "male"
    2 => "Daniel Jucker"
    3 => "0774381887"
    4 => "dan.jucker@yandex.com"
    5 => null
    6 => null
    7 => null
    8 => """
      Guten Tag Leutrim\n
       \n
      Danke für die Unterlagen zur 3 1/2 Zi Wohnung Sagenmattli 3, Sachseln am See. Wir sind interessiert, haben viele Fragen und würden gerne besichtigen.\n
       \n
      Da den Verkauf unser EFH im Ried West 16, Giswil in den nächsten Wochen verschrieben wird, suchen wir umgehend die passende Wohnung und sollten Umzugsdaten planen.\n
       \n
      Gerne können Sie mich jederzeit telefonisch anrufen. Vorschlag-Termine für eine Besichtung aus unser Seite:\n
      - Dienstag, 21.04.2026  10:00-11:00, oder ab 15:00\n
      - Freitag,    24.04.2026, Vormittag\n
       \n
      Wir freuen uns auf das weitere Vorgehen.\n
       \n
      mfg,\n
      Daniel Jucker\n
      Ried West 16\n
      6074 Giswil\n
      dan.jucker@yandex.com\n
      077 4381887
      """
    9 => null
    10 => "de"
    11 => 0
    12 => 1
    13 => 0
    14 => "completed"
    15 => 1
    16 => null
    17 => "SMG"
    18 => b"\x01©CëÛr#¢í\x00%Û³­+"
    19 => null
    20 => null
    21 => 0
    22 => 0
    23 => "2026-04-20 07:01:34"
    24 => "2026-04-20 07:01:34"
    25 => 170
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 5
    12 => 5
    13 => 5
    14 => 2
    15 => 5
    16 => 2
    17 => 2
    18 => 2
    19 => 5
    20 => 2
    21 => 5
    22 => 5
    23 => 2
    24 => 2
    25 => 1
  ]
]

[
  "sql" => "UPDATE contact SET copper_response = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => "{"id":177012348,"name":"Daniel Jucker","prefix":null,"first_name":"Daniel","middle_name":null,"last_name":"Jucker","suffix":null,"address":{"street":null,"city":null,"state":"","postal_code":null,"country":null},"assignee_id":null,"company_id":null,"company_name":null,"contact_type_id":1517329,"details":null,"emails":[{"email":"dan.jucker@yandex.com","category":"work"}],"phone_numbers":[{"number":"0774381887","category":"work"}],"socials":[],"tags":[],"title":null,"websites":[],"custom_fields":[{"custom_field_definition_id":408925,"value":1760392800},{"custom_field_definition_id":416285,"value":true},{"custom_field_definition_id":419597,"value":1398681},{"custom_field_definition_id":419601,"value":1398695},{"custom_field_definition_id":424541,"value":[1407861,1407862,1407863,1407864,1407865,1407866,1407867,1407868,1407869,1407870,1407871]},{"custom_field_definition_id":513854,"value":1665738},{"custom_field_definition_id":655848,"value":"https:\/\/www.propertyowner.ch\/de\/immobilien\/25-10081"},{"custom_field_definition_id":655849,"value":null},{"custom_field_definition_id":665583,"value":true},{"custom_field_definition_id":680846,"value":"Swiss Marketplace Group (SMG)"},{"custom_field_definition_id":712434,"value":"25-10081"},{"custom_field_definition_id":714272,"value":null},{"custom_field_definition_id":714273,"value":"   (25-10081) Guten Tag Wir interessieren Uns f\u00fcr dieses Objekt. Bitte um weitere Details, Adresse, Nachbarschaft, Finanzierung planen wir \u00fcber Verkauf gegenw\u00e4rtiges EFH bei Ried West 16, 6074 Giswil mfg, Daniel Jucker dan.(Element versteckt)"},{"custom_field_definition_id":723079,"value":"Guten Tag Leutrim\n \nDanke f\u00fcr die Unterlagen zur 3 1\/2 Zi Wohnung Sagenmattli 3, Sachseln am See. Wir sind interessiert, haben viele Fragen und w\u00fcrden gerne besichtigen.\n \nDa den Verkauf unser EFH im Ried West 16, Giswil in den n\u00e4chsten Wochen verschrieben wird, suchen wir umgehend die passende Wohnung und sollten Umzugsdaten planen.\n \nGerne k\u00f6nnen Sie mich jederzeit telefonisch anrufen. Vorschlag-Termine f\u00fcr eine Besichtung aus unser Seite:\n- Dienstag, 21.04.2026  10:00-11:00, oder ab 15:00\n- Freitag,    24.04.2026, Vormittag\n \nWir freuen uns auf das weitere Vorgehen.\n \nmfg,\nDaniel Jucker\nRied West 16\n6074 Giswil\ndan.jucker@yandex.com\n077 4381887"},{"custom_field_definition_id":733033,"value":2157926},{"custom_field_definition_id":661483,"value":null},{"custom_field_definition_id":428087,"value":null},{"custom_field_definition_id":428088,"value":null},{"custom_field_definition_id":419448,"value":null},{"custom_field_definition_id":411838,"value":null},{"custom_field_definition_id":444577,"value":null},{"custom_field_definition_id":416289,"value":null},{"custom_field_definition_id":416295,"value":null},{"custom_field_definition_id":416294,"value":null},{"custom_field_definition_id":444578,"value":null},{"custom_field_definition_id":444576,"value":null},{"custom_field_definition_id":472925,"value":false},{"custom_field_definition_id":495980,"value":false},{"custom_field_definition_id":495981,"value":null},{"custom_field_definition_id":515127,"value":false},{"custom_field_definition_id":644913,"value":false},{"custom_field_definition_id":533117,"value":null},{"custom_field_definition_id":543052,"value":null},{"custom_field_definition_id":543050,"value":null},{"custom_field_definition_id":543047,"value":null},{"custom_field_definition_id":543055,"value":null},{"custom_field_definition_id":543049,"value":null},{"custom_field_definition_id":543051,"value":null},{"custom_field_definition_id":543056,"value":null},{"custom_field_definition_id":543054,"value":null},{"custom_field_definition_id":543061,"value":null},{"custom_field_definition_id":543060,"value":null},{"custom_field_definition_id":543057,"value":null},{"custom_field_definition_id":543059,"value":null},{"custom_field_definition_id":543058,"value":null},{"custom_field_definition_id":543062,"value":null},{"custom_field_definition_id":543063,"value":null},{"custom_field_definition_id":543066,"value":null},{"custom_field_definition_id":543067,"value":null},{"custom_field_definition_id":543068,"value":null},{"custom_field_definition_id":543069,"value":null},{"custom_field_definition_id":543070,"value":null},{"custom_field_definition_id":543072,"value":null},{"custom_field_definition_id":543073,"value":null},{"custom_field_definition_id":543074,"value":null},{"custom_field_definition_id":543075,"value":null},{"custom_field_definition_id":543076,"value":null},{"custom_field_definition_id":543077,"value":null},{"custom_field_definition_id":543078,"value":null},{"custom_field_definition_id":544714,"value":false},{"custom_field_definition_id":543081,"value":null},{"custom_field_definition_id":543082,"value":null},{"custom_field_definition_id":544715,"value":false},{"custom_field_definition_id":544716,"value":null},{"custom_field_definition_id":544731,"value":null},{"custom_field_definition_id":544733,"value":false},{"custom_field_definition_id":545602,"value":null},{"custom_field_definition_id":545603,"value":null},{"custom_field_definition_id":545604,"value":null},{"custom_field_definition_id":545605,"value":null},{"custom_field_definition_id":545606,"value":null},{"custom_field_definition_id":567606,"value":false},{"custom_field_definition_id":574767,"value":[]},{"custom_field_definition_id":585559,"value":false},{"custom_field_definition_id":651566,"value":null},{"custom_field_definition_id":651567,"value":null},{"custom_field_definition_id":636483,"value":null},{"custom_field_definition_id":636484,"value":null},{"custom_field_definition_id":636485,"value":null},{"custom_field_definition_id":714336,"value":null},{"custom_field_definition_id":647405,"value":false},{"custom_field_definition_id":651565,"value":null},{"custom_field_definition_id":651568,"value":null},{"custom_field_definition_id":648595,"value":null},{"custom_field_definition_id":648594,"value":null},{"custom_field_definition_id":648596,"value":null},{"custom_field_definition_id":648597,"value":null},{"custom_field_definition_id":653135,"value":[]},{"custom_field_definition_id":656699,"value":null},{"custom_field_definition_id":411834,"value":null},{"custom_field_definition_id":407213,"value":null},{"custom_field_definition_id":715409,"value":null},{"custom_field_definition_id":700581,"value":[]},{"custom_field_definition_id":700583,"value":[]},{"custom_field_definition_id":416281,"value":[]},{"custom_field_definition_id":711918,"value":null},{"custom_field_definition_id":728484,"value":null},{"custom_field_definition_id":667051,"value":null}],"date_created":1760446947,"date_modified":1776661313,"date_last_contacted":1776471349,"interaction_count":4,"leads_converted_from":[],"date_lead_created":null}"
    2 => "2026-04-20 07:01:36"
    3 => 25423
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.property_viewing_request_text AS property_viewing_request_text_2, t0.pdf_request_by_category AS pdf_request_by_category_3, t0.property_waiting_list AS property_waiting_list_4, t0.auto_reply AS auto_reply_5, t0.photo_assignment_greetings AS photo_assignment_greetings_6, t0.photo_assignment_ending AS photo_assignment_ending_7, t0.photo_assignment_email AS photo_assignment_email_8, t0.mandate_recommended_agent_email AS mandate_recommended_agent_email_9, t0.mandate_recommended_agent_greetings AS mandate_recommended_agent_greetings_10, t0.mandate_recommended_agent_ending AS mandate_recommended_agent_ending_11, t0.mandate_kickoff_meeting AS mandate_kickoff_meeting_12, t0.auto_reply_active AS auto_reply_active_13, t0.auto_reply_active_from AS auto_reply_active_from_14, t0.auto_reply_active_until AS auto_reply_active_until_15 FROM email_settings t0 LIMIT 1"
]

[
  "sql" => "SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?"
  "params" => [
    1 => "1"
    2 => "de"
    3 => "App\Entity\EmailSettings"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "UPDATE contact SET sent_to_customer = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => 1
    2 => "2026-04-20 07:01:36"
    3 => 25423
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]