Symfony Profiler

[
  "route" => "on_office_wizard_step2"
  "route_parameters" => [
    "_route" => "on_office_wizard_step2"
    "_controller" => "App\Controller\Public\OnOfficeWizardController::step2"
    "uuid" => "01a0cb2e-9778-7674-a3c8-c0bca6ef3ec2"
  ]
  "request_uri" => "https://stage.vr-energie-immo.de/on-office/wizard/01a0cb2e-9778-7674-a3c8-c0bca6ef3ec2/step2"
  "method" => "POST"
]

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

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "helios_stage"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "helios_stage"
    "serverVersion" => "mysql-8.0.45"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.current_step AS current_step_3, t0.sort_code_completed AS sort_code_completed_4, t0.sort_code AS sort_code_5, t0.construction_year AS construction_year_6, t0.last_comprehensive_renovation_year AS last_comprehensive_renovation_year_7, t0.residential_units AS residential_units_8, t0.number_of_floors AS number_of_floors_9, t0.number_of_full_floors AS number_of_full_floors_10, t0.floor_height AS floor_height_11, t0.heated_living_area_m2 AS heated_living_area_m2_12, t0.heating_construction_year AS heating_construction_year_13, t0.basement_heated AS basement_heated_14, t0.top_floor_heated AS top_floor_heated_15, t0.roof_heated_state AS roof_heated_state_16, t0.building_usage_type AS building_usage_type_17, t0.building_type AS building_type_18, t0.building_sub_type AS building_sub_type_19, t0.energy_consumption_data AS energy_consumption_data_20, t0.vacancy_periods AS vacancy_periods_21, t0.step_data AS step_data_22, t0.on_office_user_id AS on_office_user_id_23, t0.on_office_customer_web_id AS on_office_customer_web_id_24, t0.on_office_estate_id AS on_office_estate_id_25, t0.on_office_api_claim AS on_office_api_claim_26, t0.street AS street_27, t0.house_number AS house_number_28, t0.city AS city_29, t0.country AS country_30, t0.email AS email_31, t0.building_orientation AS building_orientation_32, t0.heated_usable_area_m2 AS heated_usable_area_m2_33, t0.commercial_share_percentage AS commercial_share_percentage_34, t0.stairwell_heated AS stairwell_heated_35, t0.has_solar_hot_water AS has_solar_hot_water_36, t0.has_solar_heating AS has_solar_heating_37, t0.has_heat_pump_hot_water AS has_heat_pump_hot_water_38, t0.has_heat_pump_heating AS has_heat_pump_heating_39, t0.has_hot_water_circulation AS has_hot_water_circulation_40, t0.solar_collector_area_m2 AS solar_collector_area_m2_41, t0.dhw_decentral_area_m2 AS dhw_decentral_area_m2_42, t0.dhw_decentral_surcharge AS dhw_decentral_surcharge_43, t0.personen AS personen_44, t0.ww_verbrauch_lp_d AS ww_verbrauch_lp_d_45, t0.verification_hash AS verification_hash_46, t0.address_confirmed AS address_confirmed_47, t0.construction_year_at_registration AS construction_year_at_registration_48, t0.residential_units_at_registration AS residential_units_at_registration_49, t0.renovated_to1977_standard AS renovated_to1977_standard_50, t0.pre1977_confirmation_given AS pre1977_confirmation_given_51, t0.funnel_building_type AS funnel_building_type_52, t0.heating_energy_carrier AS heating_energy_carrier_53, t0.hot_water_energy_carrier AS hot_water_energy_carrier_54, t0.hot_water_generation AS hot_water_generation_55, t0.ventilation_types AS ventilation_types_56, t0.cooling_types AS cooling_types_57, t0.air_conditioning_count AS air_conditioning_count_58, t0.cooled_area_m2 AS cooled_area_m2_59, t0.air_conditioning_inspection_date AS air_conditioning_inspection_date_60, t0.heating_generates_hot_water AS heating_generates_hot_water_61, t0.house_image_path AS house_image_path_62, t0.purpose AS purpose_63, t0.finished AS finished_64, t0.dibt_registration_number AS dibt_registration_number_65, t0.dibt_processed AS dibt_processed_66, t0.insufficient_information_mail AS insufficient_information_mail_67, t0.pdf_email_sent AS pdf_email_sent_68, t0.pdf_file_path AS pdf_file_path_69, t0.preview_pdf_file_path AS preview_pdf_file_path_70, t0.selected_product_identifier AS selected_product_identifier_71, t0.payment_status AS payment_status_72, t0.payment_parameter_cache_id AS payment_parameter_cache_id_73, t0.payment_paid_at AS payment_paid_at_74, t0.plausi_status AS plausi_status_75, t0.plausi_errors AS plausi_errors_76, t0.plausi_checked_at AS plausi_checked_at_77, t0.heating_photo_bypass AS heating_photo_bypass_78, t0.heating_review_required AS heating_review_required_79, t0.heating_review_completed AS heating_review_completed_80, t0.heating_review_requested_at AS heating_review_requested_at_81, t0.heating_plausibility AS heating_plausibility_82, t0.heating_check_passed AS heating_check_passed_83, t0.certificate_type AS certificate_type_84, t0.origin AS origin_85, t0.construction_elements_data AS construction_elements_data_86, t0.windows_data AS windows_data_87, t0.doors_data AS doors_data_88, t0.thermal_bridges_data AS thermal_bridges_data_89, t0.certificate_reason AS certificate_reason_90, t0.building_attachment_type AS building_attachment_type_91, t0.building_category AS building_category_92, t0.building_usable_area AS building_usable_area_93, t0.insulation_present AS insulation_present_94, t0.insulation_data AS insulation_data_95, t0.heating_system_year AS heating_system_year_96, t0.heating_distribution_type AS heating_distribution_type_97, t0.heiz_uebertragung AS heiz_uebertragung_98, t0.heiz_verteilnetz AS heiz_verteilnetz_99, t0.heiz_layout AS heiz_layout_100, t0.heiz_technik AS heiz_technik_101, t0.tw_speicher_aufstellung AS tw_speicher_aufstellung_102, t0.has_secondary_heating_system AS has_secondary_heating_system_103, t0.secondary_heating_data AS secondary_heating_data_104, t0.uses_renewable_energy AS uses_renewable_energy_105, t0.renewable_energy_data AS renewable_energy_data_106, t0.has_radiator_niches AS has_radiator_niches_107, t0.has_roller_shutter_boxes AS has_roller_shutter_boxes_108, t0.underfloor_heating_share AS underfloor_heating_share_109, t0.heating_system_photo AS heating_system_photo_110, t0.created_at AS created_at_111, t0.updated_at AS updated_at_112, t0.person_id AS person_id_113, t114.id AS id_115, t114.uuid AS uuid_116, t114.status AS status_117, t114.expected_filename AS expected_filename_118, t114.waiting_at AS waiting_at_119, t114.done_at AS done_at_120, t114.failed_at AS failed_at_121, t114.local_pdf_relative_path AS local_pdf_relative_path_122, t114.error_message AS error_message_123, t114.created_at AS created_at_124, t114.updated_at AS updated_at_125, t114.funnel_state_id AS funnel_state_id_126, t0.funnel_id AS funnel_id_127, t128.id AS id_129, t128.shape_type AS shape_type_130, t128.length AS length_131, t128.width AS width_132, t128.length_large AS length_large_133, t128.width_large AS width_large_134, t128.length_short AS length_short_135, t128.width_short AS width_short_136, t128.orientation AS orientation_137, t128.bauweise_art AS bauweise_art_138, t128.renovation_year AS renovation_year_139, t128.sort_order AS sort_order_140, t128.funnel_state_id AS funnel_state_id_141, t142.id AS id_143, t142.roof_type AS roof_type_144, t142.construction_type AS construction_type_145, t142.roof_form_type AS roof_form_type_146, t142.roof_height_m AS roof_height_m_147, t142.roof_spitzboden_height_m AS roof_spitzboden_height_m_148, t142.renovation_year AS renovation_year_149, t142.sort_order AS sort_order_150, t142.funnel_state_id AS funnel_state_id_151, t152.id AS id_153, t152.basement_type AS basement_type_154, t152.basement_ceiling_type AS basement_ceiling_type_155, t152.basement_insulation AS basement_insulation_156, t152.renovation_year AS renovation_year_157, t152.funnel_state_id AS funnel_state_id_158, t159.id AS id_160, t159.has_old_leaky_shutter_boxes AS has_old_leaky_shutter_boxes_161, t159.has_controlled_ventilation_system AS has_controlled_ventilation_system_162, t159.has_chimney_or_open_shafts AS has_chimney_or_open_shafts_163, t159.has_noticeable_draft AS has_noticeable_draft_164, t159.estimated_n50 AS estimated_n50_165, t159.estimated_airtightness_class AS estimated_airtightness_class_166, t159.estimated_heat_recovery_percent AS estimated_heat_recovery_percent_167, t159.estimated_heat_recovery_efficiency AS estimated_heat_recovery_efficiency_168, t159.estimated_q50 AS estimated_q50_169, t159.estimated_v50 AS estimated_v50_170, t159.estimated_building_air_volume AS estimated_building_air_volume_171, t159.estimated_envelope_area AS estimated_envelope_area_172, t159.source AS source_173, t159.confidence AS confidence_174, t159.funnel_state_id AS funnel_state_id_175, t176.id AS id_177, t176.heiz_uebertragung AS heiz_uebertragung_178, t176.heiz_vorlauf_temp AS heiz_vorlauf_temp_179, t176.heiz_ruecklauf_temp AS heiz_ruecklauf_temp_180, t176.heiz_verteilnetz AS heiz_verteilnetz_181, t176.heiz_verteilung_baujahr AS heiz_verteilung_baujahr_182, t176.heiz_verteilung_gedaemmt AS heiz_verteilung_gedaemmt_183, t176.heiz_speicher_baujahr AS heiz_speicher_baujahr_184, t176.heiz_speicher_vorhanden AS heiz_speicher_vorhanden_185, t176.heiz_erzeugung_baujahr AS heiz_erzeugung_baujahr_186, t176.heiz_layout AS heiz_layout_187, t176.heiz_technik AS heiz_technik_188, t176.heiz_energietraeger AS heiz_energietraeger_189, t176.heiz_hersteller AS heiz_hersteller_190, t176.heiz_vorlauf_temp_sommer AS heiz_vorlauf_temp_sommer_191, t176.tw_verteilung_baujahr AS tw_verteilung_baujahr_192, t176.tw_verteilnetz AS tw_verteilnetz_193, t176.tw_zirkulation AS tw_zirkulation_194, t176.tw_speicher_aufstellung AS tw_speicher_aufstellung_195, t176.tw_speicher_baujahr AS tw_speicher_baujahr_196, t176.tw_erzeugung_baujahr AS tw_erzeugung_baujahr_197, t176.tw_technik AS tw_technik_198, t176.tw_solaranlage AS tw_solaranlage_199, t176.tw_solar_area_m2 AS tw_solar_area_m2_200, t176.tw_energietraeger AS tw_energietraeger_201, t176.tw_hersteller AS tw_hersteller_202, t176.lueftung_vorhanden AS lueftung_vorhanden_203, t176.lueftung_verteilung_baujahr AS lueftung_verteilung_baujahr_204, t176.lueftung_erzeugung_baujahr AS lueftung_erzeugung_baujahr_205, t176.lueftung_aufstellort AS lueftung_aufstellort_206, t176.lueftung_art AS lueftung_art_207, t176.kuehlung_vorhanden AS kuehlung_vorhanden_208, t176.kuehlung_erzeugung_baujahr AS kuehlung_erzeugung_baujahr_209, t176.kuehlung_technik AS kuehlung_technik_210, t176.kuehl_flaeche AS kuehl_flaeche_211, t176.funnel_state_id AS funnel_state_id_212, t213.id AS id_214, t213.installation_date AS installation_date_215, t213.generated_heat_kwh AS generated_heat_kwh_216, t213.consumed_electricity_kwh AS consumed_electricity_kwh_217, t213.funnel_state_id AS funnel_state_id_218, t219.id AS id_220, t219.confidence AS confidence_221, t219.interpretation AS interpretation_222, t219.created_at AS created_at_223, t219.updated_at AS updated_at_224, t219.funnel_state_id AS funnel_state_id_225, t226.id AS id_227, t226.lat AS lat_228, t226.lon AS lon_229, t226.station_id AS station_id_230, t226.station_name AS station_name_231, t226.station_plz AS station_plz_232, t226.station_hoehe AS station_hoehe_233, t226.heiz_periode AS heiz_periode_234, t226.aussen_temp AS aussen_temp_235, t226.tiefst_temp AS tiefst_temp_236, t226.source AS source_237, t226.provenance AS provenance_238, t226.input_hash AS input_hash_239, t226.reference_period AS reference_period_240, t226.fetched_at AS fetched_at_241, t226.created_at AS created_at_242, t226.updated_at AS updated_at_243, t226.funnel_state_id AS funnel_state_id_244 FROM funnel_states t0 LEFT JOIN funnel_state_verification_states t114 ON t114.funnel_state_id = t0.id LEFT JOIN funnel_external_walls t128 ON t128.funnel_state_id = t0.id LEFT JOIN funnel_roofs t142 ON t142.funnel_state_id = t0.id LEFT JOIN funnel_basements t152 ON t152.funnel_state_id = t0.id LEFT JOIN funnel_ventilations t159 ON t159.funnel_state_id = t0.id LEFT JOIN funnel_anlagen t176 ON t176.funnel_state_id = t0.id LEFT JOIN funnel_heat_pumps t213 ON t213.funnel_state_id = t0.id LEFT JOIN plausi_storages t219 ON t219.funnel_state_id = t0.id LEFT JOIN climate_data t226 ON t226.funnel_state_id = t0.id WHERE t0.uuid = ? LIMIT 1"
  "params" => [
    1 => b"\x01 Ë.—xvt£ÈÀ¼¦ï>Â"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "web107621"
    2 => "33"
    3 => 437
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.company AS company_6, t0.position AS position_7, t0.street AS street_8, t0.house_number AS house_number_9, t0.zip_code AS zip_code_10, t0.city AS city_11, t0.salutation AS salutation_12, t0.title AS title_13, t0.language AS language_14, t0.mobile AS mobile_15, t0.fax AS fax_16, t0.url AS url_17, t0.country AS country_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM person t0 WHERE t0.id = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

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

[
  "user_id" => "33"
  "web_id" => "web107621"
  "has_api_token" => true
  "api_token_length" => 32
  "has_api_secret" => true
  "api_secret_length" => 64
  "has_hmac" => true
  "hmac_length" => 44
  "url" => "https://api.onoffice.de/api/stable/api.php"
  "body_keys" => [
    "request"
    "token"
  ]
]

[
  "http_code" => 200
  "url" => "https://api.onoffice.de/api/stable/api.php"
  "total_time" => 0.077126
]

[
  "sql" => "SELECT t0.id AS id_1, t0.count AS count_2, t0.door_type AS door_type_3, t0.door_material AS door_material_4, t0.orientation AS orientation_5, t0.renovation_year AS renovation_year_6, t0.sort_order AS sort_order_7, t0.funnel_state_id AS funnel_state_id_8 FROM funnel_doors t0 WHERE t0.funnel_state_id = ?"
  "params" => [
    1 => 113
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO funnel_state_log (uuid, action, message, context, created_at, updated_at, funnel_state_id, funnel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => b"\x01 ËH|RsŠ˜nt¤,Ž€E"
    2 => "step_completed"
    3 => "Step "building-envelope" completed"
    4 => "{"step":"building-envelope","current_step":"on_office_wizard_complete"}"
    5 => "2026-09-23 00:42:00"
    6 => "2026-09-23 00:42:00"
    7 => 113
    8 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2295}
    4 => Doctrine\DBAL\ParameterType {#2295}
    5 => Doctrine\DBAL\ParameterType {#2295}
    6 => Doctrine\DBAL\ParameterType {#2295}
    7 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
    8 => Doctrine\DBAL\ParameterType {#2292}
  ]
]

[
  "sql" => "UPDATE funnel_states SET air_conditioning_inspection_date = ?, updated_at = ? WHERE id = ?"
  "params" => [
    1 => "2028-05-04"
    2 => "2026-09-23 00:42:00"
    3 => 113
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "UPDATE funnel_external_walls SET length = ?, width = ? WHERE id = ?"
  "params" => [
    1 => "8"
    2 => "4"
    3 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_by_id AS created_by_id_3, t0.internal_opens AS internal_opens_4, t0.external_opens AS external_opens_5, t0.qr_code AS qr_code_6, t0.disabled AS disabled_7, t0.expected_sort_code AS expected_sort_code_8, t0.selected_product_identifier AS selected_product_identifier_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.building_assessment_id AS building_assessment_id_12, t0.information_provider_id AS information_provider_id_13 FROM funnels t0 WHERE t0.id = ?"
  "params" => [
    1 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "channel" => "funnel"
  "funnel_id" => 96
  "funnel_state_id" => 113
  "funnel_uuid" => "01a0cb2e-97ae-7b79-81a3-9405c33e80b0"
  "action" => "step_completed"
  "context" => [
    "step" => "building-envelope"
    "current_step" => "on_office_wizard_complete"
  ]
]

[
  "sql" => "INSERT INTO funnel_state_log (uuid, action, message, context, created_at, updated_at, funnel_state_id, funnel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => b"\x01 ËH|`s²Ž‡\x03\x1E\x10ì|ú"
    2 => "step_completed"
    3 => "Step "heating-system" completed"
    4 => "{"step":"heating-system","current_step":"on_office_wizard_complete"}"
    5 => "2026-09-23 00:42:00"
    6 => "2026-09-23 00:42:00"
    7 => 113
    8 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2295}
    4 => Doctrine\DBAL\ParameterType {#2295}
    5 => Doctrine\DBAL\ParameterType {#2295}
    6 => Doctrine\DBAL\ParameterType {#2295}
    7 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
    8 => Doctrine\DBAL\ParameterType {#2292}
  ]
]

[
  "sql" => "UPDATE funnel_anlagen SET tw_technik = ? WHERE id = ?"
  "params" => [
    1 => "zentral"
    2 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "channel" => "funnel"
  "funnel_id" => 96
  "funnel_state_id" => 113
  "funnel_uuid" => "01a0cb2e-97ae-7b79-81a3-9405c33e80b0"
  "action" => "step_completed"
  "context" => [
    "step" => "heating-system"
    "current_step" => "on_office_wizard_complete"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.count AS count_2, t0.window_frame AS window_frame_3, t0.glazing_type AS glazing_type_4, t0.orientation AS orientation_5, t0.year AS year_6, t0.area AS area_7, t0.sort_order AS sort_order_8, t0.funnel_state_id AS funnel_state_id_9 FROM funnel_windows t0 WHERE t0.funnel_state_id = ?"
  "params" => [
    1 => 113
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO funnel_state_log (uuid, action, message, context, created_at, updated_at, funnel_state_id, funnel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => b"\x01 ËH|iw“\x1E~´ÂlUW"
    2 => "step_completed"
    3 => "Step "ventilation-airtightness" completed"
    4 => "{"step":"ventilation-airtightness","current_step":"on_office_wizard_complete"}"
    5 => "2026-09-23 00:42:00"
    6 => "2026-09-23 00:42:00"
    7 => 113
    8 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2295}
    4 => Doctrine\DBAL\ParameterType {#2295}
    5 => Doctrine\DBAL\ParameterType {#2295}
    6 => Doctrine\DBAL\ParameterType {#2295}
    7 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
    8 => Doctrine\DBAL\ParameterType {#2292}
  ]
]

[
  "sql" => "UPDATE funnel_anlagen SET tw_technik = ? WHERE id = ?"
  "params" => [
    1 => "WT_HZG"
    2 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "channel" => "funnel"
  "funnel_id" => 96
  "funnel_state_id" => 113
  "funnel_uuid" => "01a0cb2e-97ae-7b79-81a3-9405c33e80b0"
  "action" => "step_completed"
  "context" => [
    "step" => "ventilation-airtightness"
    "current_step" => "on_office_wizard_complete"
  ]
]

[
  "sql" => "INSERT INTO funnel_state_log (uuid, action, message, context, created_at, updated_at, funnel_state_id, funnel_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => b"\x01 ËH|qp\x01¿Uê°õôjd"
    2 => "step_completed"
    3 => "Step "building-components" completed"
    4 => "{"step":"building-components","current_step":"on_office_wizard_complete"}"
    5 => "2026-09-23 00:42:00"
    6 => "2026-09-23 00:42:00"
    7 => 113
    8 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2295}
    4 => Doctrine\DBAL\ParameterType {#2295}
    5 => Doctrine\DBAL\ParameterType {#2295}
    6 => Doctrine\DBAL\ParameterType {#2295}
    7 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
    8 => Doctrine\DBAL\ParameterType {#2292}
  ]
]

[
  "sql" => "UPDATE funnel_external_walls SET length = ?, width = ? WHERE id = ?"
  "params" => [
    1 => "8.00"
    2 => "4.00"
    3 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2295
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2295}
    3 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "channel" => "funnel"
  "funnel_id" => 96
  "funnel_state_id" => 113
  "funnel_uuid" => "01a0cb2e-97ae-7b79-81a3-9405c33e80b0"
  "action" => "step_completed"
  "context" => [
    "step" => "building-components"
    "current_step" => "on_office_wizard_complete"
  ]
]

[
  "funnelStateId" => 113
  "certificateType" => "bedarfsausweis"
  "extension" => "evea"
  "enforceFinished" => true
]

[
  "sql" => "SELECT t0.id AS id_1, t0.building_usage_type AS building_usage_type_2, t0.building_type AS building_type_3, t0.construction_year AS construction_year_4, t0.renovation_years AS renovation_years_5, t0.residential_units AS residential_units_6, t0.number_of_floors AS number_of_floors_7, t0.number_of_full_floors AS number_of_full_floors_8, t0.heated_living_area_m2 AS heated_living_area_m2_9, t0.heated_usable_area_m2 AS heated_usable_area_m2_10, t0.heated_net_floor_area_m2 AS heated_net_floor_area_m2_11, t0.technical_area_m2 AS technical_area_m2_12, t0.circulation_area_m2 AS circulation_area_m2_13, t0.total_net_floor_area_m2 AS total_net_floor_area_m2_14, t0.roof_area_m2 AS roof_area_m2_15, t0.gross_floor_area_m2 AS gross_floor_area_m2_16, t0.energy_relevant_volume_m3 AS energy_relevant_volume_m3_17, t0.commercial_share_percentage AS commercial_share_percentage_18, t0.unusual_usage_notes AS unusual_usage_notes_19, t0.partially_unheated_areas_description AS partially_unheated_areas_description_20, t0.partially_unheated_area_m2 AS partially_unheated_area_m2_21, t0.air_conditioning_count AS air_conditioning_count_22, t0.air_conditioning_inspection_date AS air_conditioning_inspection_date_23, t0.inspection_date AS inspection_date_24, t0.drawing_state AS drawing_state_25, t0.status AS status_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t29.id AS id_30, t29.uuid AS uuid_31, t29.created_by_id AS created_by_id_32, t29.internal_opens AS internal_opens_33, t29.external_opens AS external_opens_34, t29.qr_code AS qr_code_35, t29.disabled AS disabled_36, t29.expected_sort_code AS expected_sort_code_37, t29.selected_product_identifier AS selected_product_identifier_38, t29.created_at AS created_at_39, t29.updated_at AS updated_at_40, t29.building_assessment_id AS building_assessment_id_41, t29.information_provider_id AS information_provider_id_42, t0.person_id AS person_id_43, t0.address_id AS address_id_44, t0.billing_address_id AS billing_address_id_45, t0.plans_and_documents_id AS plans_and_documents_id_46, t0.building_envelope_heating_id AS building_envelope_heating_id_47, t0.building_details_id AS building_details_id_48, t0.ventilation_system_id AS ventilation_system_id_49, t0.heating_system_id AS heating_system_id_50, t0.solar_and_hot_water_id AS solar_and_hot_water_id_51, t0.photo_documentation_id AS photo_documentation_id_52 FROM building_assessment t0 LEFT JOIN funnels t29 ON t29.building_assessment_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 96
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.house_number AS house_number_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.country AS country_6, t0.additional_info AS additional_info_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM addresses t0 WHERE t0.id = ?"
  "params" => [
    1 => 166
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.lat AS lat_2, t0.lon AS lon_3, t0.station_id AS station_id_4, t0.station_name AS station_name_5, t0.station_plz AS station_plz_6, t0.station_hoehe AS station_hoehe_7, t0.heiz_periode AS heiz_periode_8, t0.aussen_temp AS aussen_temp_9, t0.tiefst_temp AS tiefst_temp_10, t0.source AS source_11, t0.provenance AS provenance_12, t0.input_hash AS input_hash_13, t0.reference_period AS reference_period_14, t0.fetched_at AS fetched_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.funnel_state_id AS funnel_state_id_18 FROM climate_data t0 WHERE t0.funnel_state_id = ? LIMIT 1"
  "params" => [
    1 => 113
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2292
      +name: "INTEGER"
    }
  ]
]

[
  "funnelStateId" => 113
  "xmlSizeBytes" => 238496
  "durationMs" => 43.84
]

[
  "funnelStateId" => 113
  "blobFilename" => "blob_{7EC9D5FF-159B-48ED-B014-F9775589CDB1}.jpg"
]

[
  "funnelStateId" => 113
  "outputPath" => "/var/www/stage-helios/src/public/evea-downloads/VRENI-113-PRD-X-Seebachstr20-Bedarfsausweis.evea"
  "archiveSizeBytes" => 600940
  "extension" => "evea"
  "durationMs" => 95.49
]