Symfony Profiler

"COMMIT"

"COMMIT";

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;

INSERT INTO draft (
  revision, request, route, parameters,
  user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO draft (revision, request, route, parameters, user_id) VALUES (0x019ECA5F35B83A900BA7C1184B8FA990, 'a:3:{s:8:\"property\";a:46:{s:9:\"offerType\";s:4:\"sell\";s:8:\"category\";s:1:\"1\";s:10:\"objectType\";s:1:\"2\";s:10:\"propertyId\";s:8:\"26-00142\";s:14:\"sellPrice_mask\";s:13:\"3’400’000\";s:9:\"sellPrice\";s:7:\"3400000\";s:14:\"rentPrice_mask\";s:0:\"\";s:9:\"rentPrice\";s:0:\"\";s:7:\"address\";a:6:{s:7:\"zipCode\";s:4:\"1831\";s:4:\"city\";s:4:\"2337\";s:8:\"district\";s:6:\"Sursee\";s:6:\"canton\";s:6:\"Luzern\";s:6:\"street\";s:9:\"Burghalde\";s:10:\"streetDoor\";s:2:\"10\";}s:12:\"mainLanguage\";s:2:\"de\";s:15:\"apartmentsCount\";s:0:\"\";s:10:\"roomsCount\";s:3:\"7.5\";s:14:\"bathroomsCount\";s:1:\"2\";s:5:\"floor\";s:0:\"\";s:10:\"livingArea\";s:3:\"166\";s:15:\"livingArea_mask\";s:3:\"166\";s:11:\"floorsCount\";s:1:\"3\";s:8:\"landArea\";s:4:\"1852\";s:13:\"landArea_mask\";s:7:\"1’852\";s:10:\"usableArea\";s:3:\"334\";s:15:\"usableArea_mask\";s:3:\"334\";s:13:\"ceilingHeight\";s:0:\"\";s:9:\"yearBuilt\";s:4:\"1983\";s:14:\"yearBuilt_mask\";s:4:\"1983\";s:14:\"lastRenovation\";s:0:\"\";s:19:\"lastRenovation_mask\";s:0:\"\";s:16:\"propertyFeatures\";a:17:{i:30;a:2:{s:7:\"checked\";s:1:\"1\";s:4:\"data\";s:25:\"Wärmepumpe (Luft/Wasser)\";}i:0;a:1:{s:7:\"checked\";s:1:\"1\";}i:6;a:1:{s:4:\"data\";s:0:\"\";}i:7;a:1:{s:7:\"checked\";s:1:\"1\";}i:27;a:1:{s:4:\"data\";s:0:\"\";}i:31;a:1:{s:4:\"data\";s:0:\"\";}i:4;a:2:{s:7:\"checked\";s:1:\"1\";s:4:\"data\";s:2:\"21\";}i:5;a:2:{s:7:\"checked\";s:1:\"1\";s:4:\"data\";s:2:\"28\";}i:16;a:1:{s:4:\"data\";s:0:\"\";}i:28;a:1:{s:4:\"data\";s:0:\"\";}i:29;a:1:{s:4:\"data\";s:0:\"\";}i:10;a:1:{s:7:\"checked\";s:1:\"1\";}i:12;a:1:{s:7:\"checked\";s:1:\"1\";}i:21;a:1:{s:7:\"checked\";s:1:\"1\";}i:37;a:1:{s:7:\"checked\";s:1:\"1\";}i:38;a:1:{s:7:\"checked\";s:1:\"1\";}i:17;a:1:{s:7:\"checked\";s:1:\"1\";}}s:6:\"images\";a:42:{i:0;s:5:\"35090\";i:1;s:5:\"35027\";i:2;s:5:\"35041\";i:3;s:5:\"35034\";i:4;s:5:\"35040\";i:5;s:5:\"35036\";i:6;s:5:\"35030\";i:7;s:5:\"35039\";i:8;s:5:\"35043\";i:9;s:5:\"35042\";i:10;s:5:\"35025\";i:11;s:5:\"35010\";i:12;s:5:\"35014\";i:13;s:5:\"35018\";i:14;s:5:\"35023\";i:15;s:5:\"35011\";i:16;s:5:\"34996\";i:17;s:5:\"34990\";i:18;s:5:\"34997\";i:19;s:5:\"34986\";i:20;s:5:\"34995\";i:21;s:5:\"35064\";i:22;s:5:\"35060\";i:23;s:5:\"35062\";i:24;s:5:\"35058\";i:25;s:5:\"35059\";i:26;s:5:\"35053\";i:27;s:5:\"35057\";i:28;s:5:\"35000\";i:29;s:5:\"35052\";i:30;s:5:\"35047\";i:31;s:5:\"35088\";i:32;s:5:\"35005\";i:33;s:5:\"35079\";i:34;s:5:\"34989\";i:35;s:5:\"35085\";i:36;s:5:\"35087\";i:37;s:5:\"35089\";i:38;s:5:\"35075\";i:39;s:5:\"35072\";i:40;s:5:\"35073\";i:41;s:5:\"35074\";}s:14:\"imagesVertical\";a:2:{i:0;s:5:\"35094\";i:1;s:5:\"35093\";}s:9:\"documents\";a:1:{i:0;s:4:\"1682\";}s:5:\"video\";s:40:\"https://vimeo.com/1200074759?fl=ml&fe=ec\";s:6:\"video2\";s:0:\"\";s:11:\"virtualTour\";s:45:\"https://my.matterport.com/show/?m=rNjP4BhBmrq\";s:5:\"title\";s:69:\"MONTE CASTELLO - FANTASTISCHES ANWESEN MIT NEBENGEBÄUDE UND WEINBERG\";s:18:\"descriptionResults\";s:768:\"<p>Ein&nbsp;Hauch&nbsp;von&nbsp;Süditalien&nbsp;in&nbsp;der&nbsp;Innerschweiz:&nbsp;Diese&nbsp;aussergewöhnliche&nbsp;Liegenschaft&nbsp;in&nbsp;Wolhusen&nbsp;vereint&nbsp;grosszügiges&nbsp;Wohnen,&nbsp;attraktive&nbsp;Renditemöglichkeiten&nbsp;und&nbsp;mediterranes&nbsp;Flair.&nbsp;Auf&nbsp;einem&nbsp;1&#39;852&nbsp;m²&nbsp;grossen&nbsp;Grundstück&nbsp;befinden&nbsp;sich&nbsp;eine&nbsp;7.5&nbsp;Zimmer&nbsp;Hauptwohnung,&nbsp;drei&nbsp;erfolgreich&nbsp;vermietete&nbsp;Einliegerwohnungen&nbsp;sowie&nbsp;ein&nbsp;idyllischer&nbsp;Aussenbereich&nbsp;mit&nbsp;Weinreben,&nbsp;Gartenhaus&nbsp;und&nbsp;verschiedenen&nbsp;Sitzplätzen.&nbsp;Ein&nbsp;einzigartiges&nbsp;Angebot&nbsp;für&nbsp;Eigennutzer,&nbsp;Mehrgenerationenwohnen&nbsp;oder&nbsp;Investoren.</p>\";s:21:\"descriptionDetailView\";s:3099:\"<p>An&nbsp;herrlicher&nbsp;Südwesthanglage&nbsp;in&nbsp;Wolhusen&nbsp;erwartet&nbsp;Sie&nbsp;eine&nbsp;ganz&nbsp;besondere&nbsp;Liegenschaft&nbsp;mit&nbsp;viel&nbsp;Charme,&nbsp;grosszügigem&nbsp;Platzangebot&nbsp;und&nbsp;attraktiven&nbsp;Nutzungsmöglichkeiten.&nbsp;Auf&nbsp;dem&nbsp;1&#39;852&nbsp;m²&nbsp;grossen&nbsp;Grundstück&nbsp;vereinen&nbsp;sich&nbsp;stilvolles&nbsp;Wohnen,&nbsp;naturnahes&nbsp;Lebensgefühl&nbsp;und&nbsp;interessante&nbsp;Ertragsmöglichkeiten&nbsp;zu&nbsp;einem&nbsp;aussergewöhnlichen&nbsp;Gesamtpaket.</p><p></p><p>Das&nbsp;Haupthaus&nbsp;bietet&nbsp;eine&nbsp;grosszügige&nbsp;7.5&nbsp;Zimmer&nbsp;Wohnung&nbsp;mit&nbsp;rund&nbsp;166&nbsp;m²&nbsp;Wohnfläche.&nbsp;Der&nbsp;rustikale&nbsp;Innenausbau&nbsp;mit&nbsp;sichtbarem&nbsp;Mauerwerk&nbsp;und&nbsp;Holzelementen&nbsp;schafft&nbsp;eine&nbsp;warme&nbsp;und&nbsp;einladende&nbsp;Atmosphäre.&nbsp;Ein&nbsp;gemütliches&nbsp;Cheminée&nbsp;im&nbsp;Wohnzimmer&nbsp;sowie&nbsp;die&nbsp;halb&nbsp;offene&nbsp;Schreinerküche&nbsp;mit&nbsp;gestemmten&nbsp;Fronten,&nbsp;Barelement&nbsp;und&nbsp;zusätzlichem&nbsp;Holzkochherd&nbsp;unterstreichen&nbsp;den&nbsp;einzigartigen&nbsp;Charakter&nbsp;des&nbsp;Hauses.&nbsp;Das&nbsp;Master&nbsp;Bedroom&nbsp;mit&nbsp;sichtbarer&nbsp;Holzkonstruktion&nbsp;und&nbsp;integrierter&nbsp;Ankleide&nbsp;vermittelt&nbsp;ein&nbsp;besonders&nbsp;behagliches&nbsp;Wohngefühl.</p><p></p><p>Zusätzlich&nbsp;verfügt&nbsp;die&nbsp;Liegenschaft&nbsp;über&nbsp;drei&nbsp;attraktive&nbsp;Einliegerwohnungen&nbsp;mit&nbsp;insgesamt&nbsp;92&nbsp;m²&nbsp;Wohnfläche,&nbsp;die&nbsp;derzeit&nbsp;erfolgreich&nbsp;vermietet&nbsp;werden&nbsp;und&nbsp;interessante&nbsp;Zusatzerträge&nbsp;generieren.&nbsp;Damit&nbsp;eignet&nbsp;sich&nbsp;das&nbsp;Objekt&nbsp;ideal&nbsp;für&nbsp;Mehrgenerationenwohnen,&nbsp;Wohnen&nbsp;und&nbsp;Arbeiten&nbsp;unter&nbsp;einem&nbsp;Dach&nbsp;oder&nbsp;als&nbsp;renditestarke&nbsp;Investition.</p><p></p><p>Das&nbsp;umfangreiche&nbsp;Nebenraumangebot&nbsp;mit&nbsp;Werkstatt,&nbsp;Geräteraum&nbsp;auf&nbsp;zwei&nbsp;Geschossen,&nbsp;Keller,&nbsp;Technikraum&nbsp;und&nbsp;Waschküche&nbsp;bietet&nbsp;zusätzlichen&nbsp;Komfort&nbsp;und&nbsp;viel&nbsp;Stauraum.</p><p></p><p>Auch&nbsp;der&nbsp;Aussenbereich&nbsp;begeistert:&nbsp;Rund&nbsp;110&nbsp;Weinreben&nbsp;der&nbsp;Sorte&nbsp;«Cabernet&nbsp;Monte&nbsp;Castello»&nbsp;verleihen&nbsp;dem&nbsp;Anwesen&nbsp;mediterranes&nbsp;Flair.&nbsp;Mehrere&nbsp;Gartensitzplätze,&nbsp;zwei&nbsp;Balkone,&nbsp;eine&nbsp;grosszügige&nbsp;Rasenfläche,&nbsp;eine&nbsp;Piazza&nbsp;sowie&nbsp;ein&nbsp;separates&nbsp;Gartenhaus&nbsp;schaffen&nbsp;zahlreiche&nbsp;Möglichkeiten&nbsp;zum&nbsp;Entspannen&nbsp;und&nbsp;Geniessen.&nbsp;</p><p></p><p>Mit&nbsp;einer&nbsp;Gesamtnutzfläche&nbsp;von&nbsp;334&nbsp;m²,&nbsp;diversen&nbsp;Aussenparkplätzen&nbsp;und&nbsp;einer&nbsp;einzigartigen&nbsp;Kombination&nbsp;aus&nbsp;Wohnqualität,&nbsp;Natur&nbsp;und&nbsp;Ertragspotenzial&nbsp;bietet&nbsp;diese&nbsp;Liegenschaft&nbsp;eine&nbsp;seltene&nbsp;Gelegenheit&nbsp;in&nbsp;der&nbsp;Region&nbsp;Wolhusen.</p>\";s:8:\"benefits\";s:1549:\"<ul><li><strong>Üppige&nbsp;Flächenverhältnisse</strong>:&nbsp;Fantastische&nbsp;334&nbsp;m²&nbsp;Gesamtnutzfläche&nbsp;</li><li><strong>Grundriss</strong>:&nbsp;Viel&nbsp;Platz&nbsp;im&nbsp;Haupthaus&nbsp;mit&nbsp;166&nbsp;m²&nbsp;Wohnfläche&nbsp;</li><li><strong>Einliegerwohnungen</strong>:&nbsp;Drei&nbsp;attraktive&nbsp;Einliegerwohnungen&nbsp;mit&nbsp;insgesamt&nbsp;92&nbsp;m²&nbsp;Wohnfläche,&nbsp;welche&nbsp;sehr&nbsp;erfolgreich&nbsp;als&nbsp;Air&nbsp;BnB&nbsp;vermietet&nbsp;werden&nbsp;</li><li><strong>Innenausbau</strong>:&nbsp;Rustikaler&nbsp;Innenausbau&nbsp;mit&nbsp;Kombination&nbsp;aus&nbsp;Sichtmauerwerk&nbsp;und&nbsp;Holz.&nbsp;Gemütliches&nbsp;Cheminée&nbsp;im&nbsp;Wohnzimmer&nbsp;</li><li><strong>Küche</strong>:Halboffene&nbsp;Schreinerküche&nbsp;mit&nbsp;gestemmten&nbsp;Fronten,&nbsp;Barelement&nbsp;und&nbsp;zusätzlichem&nbsp;Holzkochherd</li><li><strong>Vielfältiges&nbsp;Nebenraumangebot</strong>:&nbsp;Werkstatt&nbsp;und&nbsp;Geräteraum&nbsp;auf&nbsp;zwei&nbsp;Geschossen&nbsp;im&nbsp;Gartenhaus,&nbsp;dazu&nbsp;Keller,&nbsp;grosser&nbsp;Technikraum&nbsp;und&nbsp;Waschküche&nbsp;im&nbsp;Haupthaus&nbsp;</li><li><strong>Exklusiver&nbsp;Aussenbereich</strong>:&nbsp;110&nbsp;Weinreben&nbsp;(erweiterbar&nbsp;auf&nbsp;600),&nbsp;Gartensitzplätze&nbsp;zu&nbsp;beiden&nbsp;Wohnungen,&nbsp;zwei&nbsp;Balkone,&nbsp;Rasenfläche,&nbsp;Piazza&nbsp;und&nbsp;Gartenhaus&nbsp;</li><li><strong>Parksituation</strong>:&nbsp;Diverse&nbsp;Aussenstellplätze&nbsp;sind&nbsp;im&nbsp;Preis&nbsp;inbegriffen</li></ul>\";s:26:\"descriptionExternalPortals\";s:3488:\"<p>An&nbsp;herrlicher&nbsp;Südwesthanglage&nbsp;in&nbsp;Wolhusen&nbsp;erwartet&nbsp;Sie&nbsp;eine&nbsp;ganz&nbsp;besondere&nbsp;Liegenschaft&nbsp;mit&nbsp;viel&nbsp;Charme,&nbsp;grosszügigem&nbsp;Platzangebot&nbsp;und&nbsp;attraktiven&nbsp;Nutzungsmöglichkeiten.&nbsp;Auf&nbsp;dem&nbsp;1&#39;852&nbsp;m²&nbsp;grossen&nbsp;Grundstück&nbsp;vereinen&nbsp;sich&nbsp;stilvolles&nbsp;Wohnen,&nbsp;naturnahes&nbsp;Lebensgefühl&nbsp;und&nbsp;interessante&nbsp;Ertragsmöglichkeiten&nbsp;zu&nbsp;einem&nbsp;aussergewöhnlichen&nbsp;Gesamtpaket.</p><p></p><p>Das&nbsp;Haupthaus&nbsp;bietet&nbsp;eine&nbsp;grosszügige&nbsp;7.5&nbsp;Zimmer&nbsp;Wohnung&nbsp;mit&nbsp;rund&nbsp;166&nbsp;m²&nbsp;Wohnfläche.&nbsp;Der&nbsp;rustikale&nbsp;Innenausbau&nbsp;mit&nbsp;sichtbarem&nbsp;Mauerwerk&nbsp;und&nbsp;Holzelementen&nbsp;schafft&nbsp;eine&nbsp;warme&nbsp;und&nbsp;einladende&nbsp;Atmosphäre.&nbsp;Ein&nbsp;gemütliches&nbsp;Cheminée&nbsp;im&nbsp;Wohnzimmer&nbsp;sowie&nbsp;die&nbsp;halb&nbsp;offene&nbsp;Schreinerküche&nbsp;mit&nbsp;gestemmten&nbsp;Fronten,&nbsp;Barelement&nbsp;und&nbsp;zusätzlichem&nbsp;Holzkochherd&nbsp;unterstreichen&nbsp;den&nbsp;einzigartigen&nbsp;Charakter&nbsp;des&nbsp;Hauses.&nbsp;Das&nbsp;Master&nbsp;Bedroom&nbsp;mit&nbsp;sichtbarer&nbsp;Holzkonstruktion&nbsp;und&nbsp;integrierter&nbsp;Ankleide&nbsp;vermittelt&nbsp;ein&nbsp;besonders&nbsp;behagliches&nbsp;Wohngefühl.</p><p></p><p>Zusätzlich&nbsp;verfügt&nbsp;die&nbsp;Liegenschaft&nbsp;über&nbsp;drei&nbsp;attraktive&nbsp;Einliegerwohnungen&nbsp;mit&nbsp;insgesamt&nbsp;92&nbsp;m²&nbsp;Wohnfläche,&nbsp;die&nbsp;derzeit&nbsp;erfolgreich&nbsp;vermietet&nbsp;werden&nbsp;und&nbsp;interessante&nbsp;Zusatzerträge&nbsp;generieren.&nbsp;Damit&nbsp;eignet&nbsp;sich&nbsp;das&nbsp;Objekt&nbsp;ideal&nbsp;für&nbsp;Mehrgenerationenwohnen,&nbsp;Wohnen&nbsp;und&nbsp;Arbeiten&nbsp;unter&nbsp;einem&nbsp;Dach&nbsp;oder&nbsp;als&nbsp;renditestarke&nbsp;Investition.</p><p></p><p>Das&nbsp;umfangreiche&nbsp;Nebenraumangebot&nbsp;mit&nbsp;Werkstatt,&nbsp;Geräteraum&nbsp;auf&nbsp;zwei&nbsp;Geschossen,&nbsp;Keller,&nbsp;Technikraum&nbsp;und&nbsp;Waschküche&nbsp;bietet&nbsp;zusätzlichen&nbsp;Komfort&nbsp;und&nbsp;viel&nbsp;Stauraum.</p><p></p><p>Auch&nbsp;der&nbsp;Aussenbereich&nbsp;begeistert:&nbsp;Rund&nbsp;110&nbsp;Weinreben&nbsp;der&nbsp;Sorte&nbsp;«Cabernet&nbsp;Monte&nbsp;Castello»&nbsp;verleihen&nbsp;dem&nbsp;Anwesen&nbsp;mediterranes&nbsp;Flair.&nbsp;Mehrere&nbsp;Gartensitzplätze,&nbsp;zwei&nbsp;Balkone,&nbsp;eine&nbsp;grosszügige&nbsp;Rasenfläche,&nbsp;eine&nbsp;Piazza&nbsp;sowie&nbsp;ein&nbsp;separates&nbsp;Gartenhaus&nbsp;schaffen&nbsp;zahlreiche&nbsp;Möglichkeiten&nbsp;zum&nbsp;Entspannen&nbsp;und&nbsp;Geniessen.&nbsp;</p><p></p><p>Mit&nbsp;einer&nbsp;Gesamtnutzfläche&nbsp;von&nbsp;334&nbsp;m²,&nbsp;diversen&nbsp;Aussenparkplätzen&nbsp;und&nbsp;einer&nbsp;einzigartigen&nbsp;Kombination&nbsp;aus&nbsp;Wohnqualität,&nbsp;Natur&nbsp;und&nbsp;Ertragspotenzial&nbsp;bietet&nbsp;diese&nbsp;Liegenschaft&nbsp;eine&nbsp;seltene&nbsp;Gelegenheit&nbsp;in&nbsp;der&nbsp;Region&nbsp;Wolhusen.</p>Interessiert? Weitere Informationen, Bilder und einen virtuellen Rundgang sowie Besichtigungsmöglichkeiten finden Sie unter: propertyowner.ch/de/immobilien/26-00142 <br><br>Als Mitglied im Grundeigentümer Verband Schweiz profitieren Sie von einer kostenlosen Immobilienbewertung und erhalten Zugang zu exklusiven Inseraten auf propertyowner.ch, bevor diese öffentlich publiziert werden.\";s:5:\"agent\";s:2:\"20\";s:11:\"calendlyUrl\";s:0:\"\";s:18:\"tourFirstDateDelay\";s:1:\"5\";s:12:\"tourWeekDays\";a:6:{i:0;s:6:\"monday\";i:1;s:7:\"tuesday\";i:2;s:9:\"wednesday\";i:3;s:8:\"thursday\";i:4;s:6:\"friday\";i:5;s:8:\"saturday\";}s:21:\"wordpressExportActive\";s:1:\"1\";s:16:\"publishingStatus\";s:6:\"on_air\";s:6:\"_token\";s:114:\"363d98b26df.ikzgniZcy9-A_vjB64caBLuwkrY8tDBFyG-gR8SAHwQ.7Dum70k-gKaxmZaxqd5RXdzAx5tax2p3kiXoA6zKXUL9LY3Efy6kvPOJvQ\";s:16:\"submissionLocale\";a:3:{s:22:\"changeSubmissionLocale\";s:2:\"de\";s:26:\"submissionLocalePersistNew\";s:1:\"0\";s:22:\"submissionLocaleLoaded\";s:2:\"de\";}}s:8:\"filepond\";s:15:\"[object Object]\";s:22:\"images_secondary_order\";s:57:\"[\"35090\",\"35027\",\"35034\",\"35025\",\"35014\",\"35023\",\"35030\"]\";}', 'app_property_edit', '{\"id\":654,\"submissionLocale\":\"de\"}', 3);

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.publish_full_address AS publish_full_address_47,
  t0.first_published_at AS first_published_at_48,
  t0.edit_lock_until AS edit_lock_until_49,
  t0.forced_publishing_phases AS forced_publishing_phases_50,
  t0.disallowed_publishing_phases AS disallowed_publishing_phases_51,
  t0.media_url_original_images AS media_url_original_images_52,
  t0.media_url_web_images AS media_url_web_images_53,
  t0.media_url_floor_plans AS media_url_floor_plans_54,
  t0.media_upload_status AS media_upload_status_55,
  t0.additional_publishing_delays AS additional_publishing_delays_56,
  t0.created_at AS created_at_57,
  t0.updated_at AS updated_at_58,
  t0.category_id AS category_id_59,
  t0.object_type_id AS object_type_id_60,
  t0.agent_id AS agent_id_61,
  t0.address_id AS address_id_62,
  t0.cloned_from_id AS cloned_from_id_63,
  t0.edit_lock_by_user_id AS edit_lock_by_user_id_64,
  t0.mandate_id AS mandate_id_65
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.publish_full_address AS publish_full_address_47, t0.first_published_at AS first_published_at_48, t0.edit_lock_until AS edit_lock_until_49, t0.forced_publishing_phases AS forced_publishing_phases_50, t0.disallowed_publishing_phases AS disallowed_publishing_phases_51, t0.media_url_original_images AS media_url_original_images_52, t0.media_url_web_images AS media_url_web_images_53, t0.media_url_floor_plans AS media_url_floor_plans_54, t0.media_upload_status AS media_upload_status_55, t0.additional_publishing_delays AS additional_publishing_delays_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.category_id AS category_id_59, t0.object_type_id AS object_type_id_60, t0.agent_id AS agent_id_61, t0.address_id AS address_id_62, t0.cloned_from_id AS cloned_from_id_63, t0.edit_lock_by_user_id AS edit_lock_by_user_id_64, t0.mandate_id AS mandate_id_65 FROM property t0 WHERE t0.id = '654';

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 = '654' AND e0_.locale = 'de' AND e0_.object_class = 'App\\Entity\\Property';

SELECT
  t0.id AS id_1,
  t0.revision AS revision_2,
  t0.request AS request_3,
  t0.route AS route_4,
  t0.parameters AS parameters_5,
  t0.user_id AS user_id_6
FROM
  draft t0
WHERE
  t0.user_id = ?
  AND t0.revision = ?
  AND t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.revision AS revision_2, t0.request AS request_3, t0.route AS route_4, t0.parameters AS parameters_5, t0.user_id AS user_id_6 FROM draft t0 WHERE t0.user_id = 3 AND t0.revision = 0x019ECA5F35B83A900BA7C1184B8FA990 AND t0.route = 'app_property_edit' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";