Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO onoffice_marketplace_estate_snapshot (
  customer_web_id, user_id, estate_id,
  api_claim, data, images, fetched_at,
  error
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO onoffice_marketplace_estate_snapshot (customer_web_id, user_id, estate_id, api_claim, data, images, fetched_at, error) VALUES ('web107621', '33', 437, 'vgYfEn-4C8dNJ-1cIC2Bii0EbH7wfkb6OJ7QGqGQyQ0_NIrJderwGSGYRb07jmB6mJrEN6GmyaK8bAMEib2tu1YsZKk3M7rPtP_z4UKrgUa_r1cMYLZ2LI8sWFTuzBXgXg9xp4PdLXsukp6K3IGnWjHU6nQlbe5U3LEZ9qT31qs16zHygI5UAJ1geXHT6KBrtOYAKIA10-OSv1SkuAxWGwo-R7xuNM_Au5T1lZIvl0iMk2xfv_RHCGvidUihEToJ', '{\"Id\":\"437\",\"InterneBemerkung\":\"\",\"abdatum\":\"0000-00-00\",\"accessibility\":[],\"akquise_wahrscheinlichkeit\":\"medium\",\"amtsgericht\":\"\",\"angeschl_gastronomie\":[],\"anzahl_badezimmer\":\"3.00\",\"anzahl_balkone\":\"1.00\",\"anzahl_betten\":\"0.00\",\"anzahl_schlafzimmer\":\"0.00\",\"anzahl_sep_wc\":\"0.00\",\"anzahl_tagungsraeume\":\"0.00\",\"anzahl_terrassen\":\"2.00\",\"anzahl_wohneinheiten\":\"0.00\",\"anzahl_zimmer\":\"8.00\",\"auftragbis\":\"2027-02-11\",\"auftragsart\":\"ind_Schl_4773\",\"aussen_courtage\":\"2,975 % inkl. MwSt.\",\"ausstatt_beschr\":\"- Wohnhaus mit Einliegerwohnung (2 Wohneinheiten + Einliegerwohnung m\\u00f6glich)\\r\\n- W\\u00e4rmepumpe aus 2017 mit Fu\\u00dfbodenheizung\\r\\n- zus\\u00e4tzliche Holz\\u00f6fen\\r\\n- voll unterkellert\\r\\n- 2 Terrassen und 1 Balkon\\r\\n- erneuerte B\\u00e4der\\r\\n- gro\\u00dfes Nebengeb\\u00e4ude mit 2 Garagen und Lagerfl\\u00e4che\",\"ausstattungsqualitaet\":\"\",\"autoExpose\":\"0\",\"balkon\":\"1\",\"barrierefrei\":\"0\",\"baujahr\":\"1980\",\"bebaubar_mit\":[],\"bebaubar_nach\":\"\",\"befeuerung\":[\"holz\",\"luftwp\"],\"benutzer\":\"33\",\"boden\":[],\"bueroflaeche\":\"0.00\",\"denkmalgeschuetzt\":\"0\",\"distanz_autobahn\":\"0.00\",\"distanz_grundschule\":\"0.00\",\"distanz_gymnasium\":\"0.00\",\"distanz_kindergarten\":\"0.00\",\"distanz_realschule\":\"0.00\",\"distanz_zentrum\":\"0.00\",\"einliegerwohnung\":\"1\",\"endenergiebedarf\":\"0.00\",\"endenergiebedarfStrom\":\"0.00\",\"endenergiebedarfWaerme\":\"0.00\",\"endenergieverbrauchStrom\":\"0.00\",\"endenergieverbrauchWaerme\":\"0.00\",\"energieausweisBaujahr\":\"1984\",\"energieausweis_gueltig_bis\":\"2036-06-11\",\"energieausweistyp\":\"Energieverbrauchskennwert\",\"energietraeger\":\"oel\",\"energieverbrauchskennwert\":\"26.00\",\"energyClass\":\"A+\",\"erbpacht\":\"0.00\",\"erschliessung\":\"\",\"erschliessungskosten\":\"0.00\",\"erstellt_am\":\"2026-05-18 00:00:00\",\"etage\":\"\",\"etagen_zahl\":\"3.00\",\"fahrstuhl\":[],\"flur\":\"\",\"flurstueck\":\"\",\"gaesteWc\":\"1\",\"gastroflaeche\":\"0.00\",\"geaendert_am\":\"2026-09-09 14:11:29\",\"gemarkung\":\"\",\"gesamtflaeche\":\"0.00\",\"gewerbeflaeche\":\"0.00\",\"gewerbliche_nutzung\":\"0\",\"gfz\":\"\",\"grundbuch\":\"\",\"grundbuchblatt\":\"\",\"grundstuecksflaeche\":\"820.00\",\"grz\":\"\",\"hausgeld\":\"0.00\",\"hausnummer\":\"20\",\"haustiere\":\"\",\"heizkosten\":\"0.00\",\"heizkosten_in_nebenkosten\":\"\",\"heizungsart\":[\"fussboden\",\"waermepumpe\"],\"immobilienherkunft\":[],\"innen_courtage\":\"2,975 % inkl. MwSt.\",\"internetAccessType\":[],\"kabel_sat_tv\":\"1\",\"kaltmiete\":\"0.00\",\"kamin\":\"1\",\"kaufpreis\":\"470000.00\",\"kaution\":null,\"klimatisiert\":\"1\",\"ladenflaeche\":\"0.00\",\"lage\":\"Idyllisch eingebettet im Biosph\\u00e4renreservat Bayerische Rh\\u00f6n und direkt am Fu\\u00dfe des Kreuzbergs gelegen, bietet der Burkardrother Ortsteil Gef\\u00e4ll die perfekte Balance aus naturnahem R\\u00fcckzugsort und guter Erreichbarkeit. Alle Besorgungen des t\\u00e4glichen Bedarfs, Schulen und \\u00c4rzte befinden sich im nur 5 Autominuten entfernten Hauptort Burkardroth. Dank der schnellen Anbindung an die Autobahn A7 (ca. 15 Minuten) sowie an die St\\u00e4dte Bad Kissingen und Bad Br\\u00fcckenau (jeweils rund 20 Minuten) ist diese absolut ruhige Wohnlage auch f\\u00fcr Pendler hochattraktiv. Ein ideales Pflaster f\\u00fcr Familien und Naturliebhaber, die die Natur direkt vor der Haust\\u00fcr suchen, ohne auf eine solide Infrastruktur verzichten zu wollen.\",\"lagerflaeche\":\"0.00\",\"land\":\"DEU\",\"letzte_aktion\":\"2026-08-27\",\"miete_pauschal\":\"0.00\",\"miete_pauschal_pro\":\"\",\"mieteinnahmen_ist\":\"0.00\",\"mieteinnahmen_pro_jahr_ist\":\"0.00\",\"mieteinnahmen_pro_jahr_soll\":\"0.00\",\"mieteinnahmen_pro_monat\":\"0.00\",\"mieteinnahmen_soll\":\"0.00\",\"mls_provisionsAbgabe_beschreibung\":null,\"multiParkingLot\":{\"carport\":{\"Count\":null,\"Price\":null,\"MarketingType\":null},\"duplex\":{\"Count\":null,\"Price\":null,\"MarketingType\":null},\"parkingSpace\":{\"Count\":null,\"Price\":null,\"MarketingType\":null},\"garage\":{\"Count\":null,\"Price\":null,\"MarketingType\":null},\"multiStoryGarage\":{\"Count\":null,\"Price\":null,\"MarketingType\":null},\"undergroundGarage\":{\"Count\":null,\"Price\":null,\"MarketingType\":null},\"otherParkingLot\":{\"Count\":null,\"Price\":null,\"MarketingType\":null}},\"nebenflaeche\":\"0.00\",\"nebenkosten\":\"0.00\",\"nettokaltmiete\":\"0.00\",\"nutzflaeche\":\"0.00\",\"nutzungsart\":\"wohnen\",\"objektart\":\"haus\",\"objektbeschreibung\":\"Dieses freistehende Mehrfamilienhaus in massiver Bauweise bietet ca. 281 m\\u00b2 Wohnfl\\u00e4che auf drei Ebenen. Es umfasst aktuell eine Hauptwohneinheit im EG und DG und eine separate Einliegerwohnung im Untergeschoss, die auch getrennt bewohnt werden k\\u00f6nnte. Eine Teilung von EG und DG in separate Wohnungen w\\u00e4re ebenfalls m\\u00f6glich. Das Objekt wurde 1984 erbaut und zeichnet sich durch seine erh\\u00f6hte Hanglage mit Panoramablick aus. Die Beheizung erfolgt \\u00fcber eine moderne Luft-Wasser-W\\u00e4rmepumpe aus dem Jahr 2017 in Kombination mit einer Fu\\u00dfbodenheizung und erg\\u00e4nzenden Holz\\u00f6fen auf jeder Etage. Alle Badezimmer im Haus wurden bereits modernisiert. Zum Anwesen geh\\u00f6rt ein gro\\u00dfes Nebengeb\\u00e4ude mit Doppelgarage und zus\\u00e4tzlichem Stauraum im Dachspitz sowie ein gepflegter Garten mit Natursteinmauern.\",\"objektnr_extern\":\"21\\/26\",\"objekttitel\":\"Gepflegtes Einfamilienhaus mit Einliegerwohnung und Fernblick in Burkardroth-Gef\\u00e4ll\",\"objekttyp\":\"einfamilienhaus\",\"ort\":\"Burkardroth \\/ Gef\\u00e4ll\",\"pacht\":\"0.00\",\"placeholderEnergy\":\"0\",\"plz\":\"97705\",\"provisionsAbgabe\":\"50\",\"provisionsAbgabe_innen\":\"50\",\"provisionsfrei\":\"0\",\"sauna\":\"1\",\"schaufensterTv_veroeffentlichen\":\"1\",\"scout_region\":\"\",\"sonstige_angaben\":\"\",\"stammobjekt\":\"0\",\"status\":\"1\",\"status2\":\"\",\"strasse\":\"Seebachstr.\",\"teilbar_ab\":\"0.00\",\"terrasse\":\"1\",\"transferStreetWithoutHouseNumber\":null,\"unterkellert\":\"JA\",\"verfuegbar_ab\":\"nach Vereinbarung\",\"verkaufsflaeche\":\"0.00\",\"verkauft_am\":\"0000-00-00\",\"vermarktungsart\":\"kauf\",\"vermietbare_flaeche\":\"0.00\",\"vermietet\":\"0\",\"vermittlungswahrscheinlichkeit\":\"medium\",\"waehrung\":\"EUR\",\"warmmiete\":\"0.00\",\"warmwasserEnthalten\":\"1\",\"whirlpool\":\"1\",\"wintergarten\":\"1\",\"wohnflaeche\":\"281.00\",\"wohnungsnr\":\"\",\"x_fache\":\"0.00\",\"x_fache_soll\":\"0.00\",\"zustand\":\"gepflegt\",\"zzgl_mehrwertsteuer\":\"0\"}', '[{\"id\":\"437\",\"title\":\"image-3\",\"url\":\"https:\\/\\/image.onoffice.de\\/smart20\\/Objekte\\/vrenergie-dev\\/437\\/aa8cf301-6305-4da5-8f2b-e6712273aaa6.jpg\",\"thumbnailUrl\":\"https:\\/\\/image.onoffice.de\\/smart20\\/Objekte\\/vrenergie-dev\\/437\\/aa8cf301-6305-4da5-8f2b-e6712273aaa6.jpg\",\"type\":\"Titelbild\",\"rank\":0,\"width\":null,\"height\":null,\"estateId\":\"437\",\"estateMainId\":\"437\",\"originalName\":\"image-3.jpg\",\"text\":\"\",\"modified\":1788398898,\"rawData\":{\"estateid\":\"437\",\"type\":\"Titelbild\",\"url\":\"https:\\/\\/image.onoffice.de\\/smart20\\/Objekte\\/vrenergie-dev\\/437\\/aa8cf301-6305-4da5-8f2b-e6712273aaa6.jpg\",\"title\":\"image-3\",\"text\":\"\",\"originalname\":\"image-3.jpg\",\"modified\":1788398898,\"estateMainId\":\"437\"}}]', '2026-09-22 22:18:26', NULL);

INSERT INTO funnel_states (
  uuid, current_step, sort_code_completed,
  sort_code, construction_year, last_comprehensive_renovation_year,
  residential_units, number_of_floors,
  number_of_full_floors, floor_height,
  heated_living_area_m2, heating_construction_year,
  basement_heated, top_floor_heated,
  roof_heated_state, building_usage_type,
  building_type, building_sub_type,
  energy_consumption_data, vacancy_periods,
  step_data, on_office_user_id, on_office_customer_web_id,
  on_office_estate_id, on_office_api_claim,
  street, house_number, city, country,
  email, building_orientation, heated_usable_area_m2,
  commercial_share_percentage, stairwell_heated,
  has_solar_hot_water, has_solar_heating,
  has_heat_pump_hot_water, has_heat_pump_heating,
  has_hot_water_circulation, solar_collector_area_m2,
  dhw_decentral_area_m2, dhw_decentral_surcharge,
  personen, ww_verbrauch_lp_d, verification_hash,
  address_confirmed, construction_year_at_registration,
  residential_units_at_registration,
  renovated_to1977_standard, pre1977_confirmation_given,
  funnel_building_type, heating_energy_carrier,
  hot_water_energy_carrier, hot_water_generation,
  ventilation_types, cooling_types,
  air_conditioning_count, cooled_area_m2,
  air_conditioning_inspection_date,
  heating_generates_hot_water, house_image_path,
  purpose, finished, dibt_registration_number,
  dibt_processed, insufficient_information_mail,
  pdf_email_sent, pdf_file_path, preview_pdf_file_path,
  selected_product_identifier, payment_status,
  payment_parameter_cache_id, payment_paid_at,
  plausi_status, plausi_errors, plausi_checked_at,
  heating_photo_bypass, heating_review_required,
  heating_review_completed, heating_review_requested_at,
  heating_plausibility, heating_check_passed,
  certificate_type, origin, construction_elements_data,
  windows_data, doors_data, thermal_bridges_data,
  certificate_reason, building_attachment_type,
  building_category, building_usable_area,
  insulation_present, insulation_data,
  heating_system_year, heating_distribution_type,
  heiz_uebertragung, heiz_verteilnetz,
  heiz_layout, heiz_technik, tw_speicher_aufstellung,
  has_secondary_heating_system, secondary_heating_data,
  uses_renewable_energy, renewable_energy_data,
  has_radiator_niches, has_roller_shutter_boxes,
  underfloor_heating_share, heating_system_photo,
  created_at, updated_at, person_id,
  funnel_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO funnel_states (uuid, current_step, sort_code_completed, sort_code, construction_year, last_comprehensive_renovation_year, residential_units, number_of_floors, number_of_full_floors, floor_height, heated_living_area_m2, heating_construction_year, basement_heated, top_floor_heated, roof_heated_state, building_usage_type, building_type, building_sub_type, energy_consumption_data, vacancy_periods, step_data, on_office_user_id, on_office_customer_web_id, on_office_estate_id, on_office_api_claim, street, house_number, city, country, email, building_orientation, heated_usable_area_m2, commercial_share_percentage, stairwell_heated, has_solar_hot_water, has_solar_heating, has_heat_pump_hot_water, has_heat_pump_heating, has_hot_water_circulation, solar_collector_area_m2, dhw_decentral_area_m2, dhw_decentral_surcharge, personen, ww_verbrauch_lp_d, verification_hash, address_confirmed, construction_year_at_registration, residential_units_at_registration, renovated_to1977_standard, pre1977_confirmation_given, funnel_building_type, heating_energy_carrier, hot_water_energy_carrier, hot_water_generation, ventilation_types, cooling_types, air_conditioning_count, cooled_area_m2, air_conditioning_inspection_date, heating_generates_hot_water, house_image_path, purpose, finished, dibt_registration_number, dibt_processed, insufficient_information_mail, pdf_email_sent, pdf_file_path, preview_pdf_file_path, selected_product_identifier, payment_status, payment_parameter_cache_id, payment_paid_at, plausi_status, plausi_errors, plausi_checked_at, heating_photo_bypass, heating_review_required, heating_review_completed, heating_review_requested_at, heating_plausibility, heating_check_passed, certificate_type, origin, construction_elements_data, windows_data, doors_data, thermal_bridges_data, certificate_reason, building_attachment_type, building_category, building_usable_area, insulation_present, insulation_data, heating_system_year, heating_distribution_type, heiz_uebertragung, heiz_verteilnetz, heiz_layout, heiz_technik, tw_speicher_aufstellung, has_secondary_heating_system, secondary_heating_data, uses_renewable_energy, renewable_energy_data, has_radiator_niches, has_roller_shutter_boxes, underfloor_heating_share, heating_system_photo, created_at, updated_at, person_id, funnel_id) VALUES (0x01A0CAC50E4374DA81F2B9009194DA5C, 'sort-code', 0, '97705', 1980, NULL, 1, 2, 2, NULL, NULL, NULL, 0, NULL, 'no', 'residential', 'neubau', NULL, NULL, NULL, '[]', NULL, NULL, NULL, NULL, 'Seebachstr.', '20', 'Burkardroth / Gefäll', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'detached', NULL, NULL, NULL, '[\"window_ventilation\"]', NULL, NULL, NULL, NULL, 1, NULL, NULL, 0, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, 0, NULL, 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-09-22 22:18:27', '2026-09-22 22:18:27', NULL, 94);

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.customer_web_id AS customer_web_id_2,
  t0.user_id AS user_id_3,
  t0.api_claim AS api_claim_4,
  t0.last_seen_at AS last_seen_at_5,
  t0.seen_count AS seen_count_6
FROM
  onoffice_marketplace_user_activation t0
WHERE
  t0.customer_web_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.customer_web_id AS customer_web_id_2, t0.user_id AS user_id_3, t0.api_claim AS api_claim_4, t0.last_seen_at AS last_seen_at_5, t0.seen_count AS seen_count_6 FROM onoffice_marketplace_user_activation t0 WHERE t0.customer_web_id = 'web107621' AND t0.user_id = '33' LIMIT 1;

UPDATE
  funnel_states
SET
  construction_year = ?,
  number_of_full_floors = ?,
  heated_living_area_m2 = ?,
  heating_construction_year = ?,
  basement_heated = ?,
  building_usage_type = ?,
  building_sub_type = ?,
  street = ?,
  house_number = ?,
  city = ?,
  heated_usable_area_m2 = ?,
  construction_year_at_registration = ?,
  heating_energy_carrier = ?,
  air_conditioning_count = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE funnel_states SET construction_year = 1980, number_of_full_floors = 3, heated_living_area_m2 = 281, heating_construction_year = 1984, basement_heated = 1, building_usage_type = 'residential', building_sub_type = 'single_family', street = 'Seebachstr.', house_number = '20', city = 'Burkardroth / Gefäll', heated_usable_area_m2 = 0, construction_year_at_registration = 1980, heating_energy_carrier = 'heating_oil', air_conditioning_count = 1, updated_at = '2026-09-22 22:18:27' WHERE id = 109;

INSERT INTO building_assessment (
  building_usage_type, building_type,
  construction_year, renovation_years,
  residential_units, number_of_floors,
  number_of_full_floors, heated_living_area_m2,
  heated_usable_area_m2, heated_net_floor_area_m2,
  technical_area_m2, circulation_area_m2,
  total_net_floor_area_m2, roof_area_m2,
  gross_floor_area_m2, energy_relevant_volume_m3,
  commercial_share_percentage, unusual_usage_notes,
  partially_unheated_areas_description,
  partially_unheated_area_m2, air_conditioning_count,
  air_conditioning_inspection_date,
  inspection_date, drawing_state,
  status, created_at, updated_at, person_id,
  address_id, billing_address_id,
  plans_and_documents_id, building_envelope_heating_id,
  building_details_id, ventilation_system_id,
  heating_system_id, solar_and_hot_water_id,
  photo_documentation_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO building_assessment (building_usage_type, building_type, construction_year, renovation_years, residential_units, number_of_floors, number_of_full_floors, heated_living_area_m2, heated_usable_area_m2, heated_net_floor_area_m2, technical_area_m2, circulation_area_m2, total_net_floor_area_m2, roof_area_m2, gross_floor_area_m2, energy_relevant_volume_m3, commercial_share_percentage, unusual_usage_notes, partially_unheated_areas_description, partially_unheated_area_m2, air_conditioning_count, air_conditioning_inspection_date, inspection_date, drawing_state, status, created_at, updated_at, person_id, address_id, billing_address_id, plans_and_documents_id, building_envelope_heating_id, building_details_id, ventilation_system_id, heating_system_id, solar_and_hot_water_id, photo_documentation_id) VALUES ('residential', 'neubau', 1980, NULL, 1, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-09-22 22:18:26', 'as_is', 'draft', '2026-09-22 22:18:26', '2026-09-22 22:18:26', NULL, 162, 163, 94, 94, 94, NULL, NULL, NULL, 94);

INSERT INTO addresses (
  street, house_number, zip_code, city,
  country, additional_info, created_at,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO addresses (street, house_number, zip_code, city, country, additional_info, created_at, updated_at) VALUES ('Seebachstr.', '20', '97705', 'Burkardroth / Gefäll', 'DEU', NULL, '2026-09-22 22:18:26', '2026-09-22 22:18:26');

SELECT
  t0.id AS id_1,
  t0.customer_web_id AS customer_web_id_2,
  t0.user_id AS user_id_3,
  t0.estate_id AS estate_id_4,
  t0.api_claim AS api_claim_5,
  t0.data AS data_6,
  t0.images AS images_7,
  t0.fetched_at AS fetched_at_8,
  t0.error AS error_9
FROM
  onoffice_marketplace_estate_snapshot t0
WHERE
  t0.customer_web_id = ?
  AND t0.user_id = ?
  AND t0.estate_id = ?
ORDER BY
  t0.fetched_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.customer_web_id AS customer_web_id_2, t0.user_id AS user_id_3, t0.estate_id AS estate_id_4, t0.api_claim AS api_claim_5, t0.data AS data_6, t0.images AS images_7, t0.fetched_at AS fetched_at_8, t0.error AS error_9 FROM onoffice_marketplace_estate_snapshot t0 WHERE t0.customer_web_id = 'web107621' AND t0.user_id = '33' AND t0.estate_id = 437 ORDER BY t0.fetched_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.customer_web_id AS customer_web_id_2,
  t0.customer_name AS customer_name_3,
  t0.api_claim AS api_claim_4,
  t0.activated_at AS activated_at_5,
  t0.api_token AS api_token_6,
  t0.api_secret AS api_secret_7,
  t0.user_id AS user_id_8,
  t0.parameter_cache_id AS parameter_cache_id_9
FROM
  onoffice_marketplace_activation t0
WHERE
  t0.customer_web_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.customer_web_id AS customer_web_id_2, t0.customer_name AS customer_name_3, t0.api_claim AS api_claim_4, t0.activated_at AS activated_at_5, t0.api_token AS api_token_6, t0.api_secret AS api_secret_7, t0.user_id AS user_id_8, t0.parameter_cache_id AS parameter_cache_id_9 FROM onoffice_marketplace_activation t0 WHERE t0.customer_web_id = 'web107621' LIMIT 1;

INSERT INTO funnels (
  uuid, created_by_id, internal_opens,
  external_opens, qr_code, disabled,
  expected_sort_code, selected_product_identifier,
  created_at, updated_at, building_assessment_id,
  information_provider_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO funnels (uuid, created_by_id, internal_opens, external_opens, qr_code, disabled, expected_sort_code, selected_product_identifier, created_at, updated_at, building_assessment_id, information_provider_id) VALUES (0x01A0CAC50E43745281F2B90091561099, 'SYSTEM', 0, 0, NULL, 0, NULL, NULL, '2026-09-22 22:18:27', '2026-09-22 22:18:27', 94, NULL);

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

UPDATE
  onoffice_marketplace_user_activation
SET
  last_seen_at = ?
WHERE
  id = ?

UPDATE onoffice_marketplace_user_activation SET last_seen_at = '2026-09-22 22:18:26' WHERE id = 1;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO building_envelope_heating (
  basement_heated, basement_heated_rooms,
  basement_staircase_in_heated_area,
  stairwell_heated, roof_heated, roof_heated_rooms
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO building_envelope_heating (basement_heated, basement_heated_rooms, basement_staircase_in_heated_area, stairwell_heated, roof_heated, roof_heated_rooms) VALUES ('no', NULL, 0, 0, 'no', NULL);

INSERT INTO building_details (
  roller_shutter_box_insulation, roller_shutter_box_notes,
  heating_niches_present, heating_niche_depth_cm,
  heating_niche_rooms
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO building_details (roller_shutter_box_insulation, roller_shutter_box_notes, heating_niches_present, heating_niche_depth_cm, heating_niche_rooms) VALUES ('none', NULL, 0, NULL, NULL);

INSERT INTO photo_documentation (
  exterior_facade_photos, window_photos,
  roller_shutter_box_photos, entrance_door_photos,
  roof_photos, basement_ceiling_photos,
  heating_system_photos, pumps_and_storage_photos,
  domestic_hot_water_photos
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO photo_documentation (exterior_facade_photos, window_photos, roller_shutter_box_photos, entrance_door_photos, roof_photos, basement_ceiling_photos, heating_system_photos, pumps_and_storage_photos, domestic_hot_water_photos) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO plans_and_documents (
  has_floor_plans, has_sections, has_elevations,
  has_site_plan, plans_current_state,
  window_measurements_in_plans, measurement_basis,
  window_measured_by
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO plans_and_documents (has_floor_plans, has_sections, has_elevations, has_site_plan, plans_current_state, window_measurements_in_plans, measurement_basis, window_measured_by) VALUES (0, 0, 0, 0, NULL, NULL, NULL, NULL);