Symfony Profiler

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 = ?

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 = 3;

SELECT
  p.property_id,
  p.id
FROM
  property AS p

SELECT p.property_id, p.id
FROM property AS p;

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 = ?

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 = 77;

"START TRANSACTION"

"START TRANSACTION";

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 ('female', 'Klaudia Vornheder', '+41797690042', 'mme.cloudine@proton.me', NULL, NULL, NULL, 'Guten Tag, wir interessieren uns für diese Immobilie.
Bitte rufen Sie uns dazu an.
Vielen Dank.
Freundliche Grüsse
Klaudia Vornheder', NULL, 'de', 0, 0, 1, 'completed', 1, NULL, 'propertyowner', 0x019DA948441978388F97A0CE1B1B8AC6, NULL, NULL, 0, 0, '2026-04-20 07:06:18', '2026-04-20 07:06:18', 77);

"COMMIT"

"COMMIT";

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 = ?

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 = 77;

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 = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '77' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\Property';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  contact
SET
  copper_response = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE contact SET copper_response = '{\"id\":182271939,\"name\":\"Klaudia Vornheder\",\"prefix\":null,\"first_name\":\"Klaudia\",\"middle_name\":null,\"last_name\":\"Vornheder\",\"suffix\":null,\"address\":{\"street\":\"\",\"city\":\"\",\"state\":\"\",\"postal_code\":\"\",\"country\":null},\"assignee_id\":null,\"company_id\":null,\"company_name\":null,\"contact_type_id\":1517331,\"details\":null,\"emails\":[{\"email\":\"mme.cloudine@proton.me\",\"category\":\"work\"}],\"phone_numbers\":[{\"number\":\"+41797690042\",\"category\":\"work\"}],\"socials\":[],\"tags\":[],\"title\":null,\"websites\":[],\"custom_fields\":[{\"custom_field_definition_id\":419601,\"value\":1398696},{\"custom_field_definition_id\":419597,\"value\":1398681},{\"custom_field_definition_id\":416285,\"value\":true},{\"custom_field_definition_id\":513854,\"value\":1665738},{\"custom_field_definition_id\":680846,\"value\":\"Propertyowner\"},{\"custom_field_definition_id\":714273,\"value\":\"Guten Tag, wir interessieren uns f\\u00fcr diese Immobilie.\\nBitte rufen Sie uns dazu an.\\nVielen Dank.\\nFreundliche Gr\\u00fcsse\\nKlaudia Vornheder\"},{\"custom_field_definition_id\":714272,\"value\":\"25-11213\"},{\"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\":408925,\"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\":424541,\"value\":[]},{\"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\":665583,\"value\":false},{\"custom_field_definition_id\":655848,\"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\":655849,\"value\":null},{\"custom_field_definition_id\":712434,\"value\":null},{\"custom_field_definition_id\":711918,\"value\":null},{\"custom_field_definition_id\":723079,\"value\":null},{\"custom_field_definition_id\":728484,\"value\":null},{\"custom_field_definition_id\":733033,\"value\":null},{\"custom_field_definition_id\":667051,\"value\":null}],\"date_created\":1776661597,\"date_modified\":1776661597,\"date_last_contacted\":null,\"interaction_count\":0,\"leads_converted_from\":[],\"date_lead_created\":null}', updated_at = '2026-04-20 07:06:21' WHERE id = 25427;

"COMMIT"

"COMMIT";

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

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;

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 = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\EmailSettings';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  contact
SET
  sent_to_customer = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE contact SET sent_to_customer = 1, updated_at = '2026-04-20 07:06:21' WHERE id = 25427;

"COMMIT"

"COMMIT";