Symfony Profiler

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

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 = 0x01A0CB2E97787674A3C8C0BCA6EF3EC2 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 = ?
  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.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 = ?

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

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;

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

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

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO funnel_state_log (
  uuid, action, message, context, created_at,
  updated_at, funnel_state_id, funnel_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO funnel_state_log (uuid, action, message, context, created_at, updated_at, funnel_state_id, funnel_id) VALUES (0x01A0CB487C52738A986E74A42C8E8045, 'step_completed', 'Step \"building-envelope\" completed', '{\"step\":\"building-envelope\",\"current_step\":\"on_office_wizard_complete\"}', '2026-09-23 00:42:00', '2026-09-23 00:42:00', 113, 96);

UPDATE
  funnel_states
SET
  air_conditioning_inspection_date = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE funnel_states SET air_conditioning_inspection_date = '2028-05-04', updated_at = '2026-09-23 00:42:00' WHERE id = 113;

UPDATE
  funnel_external_walls
SET
  length = ?,
  width = ?
WHERE
  id = ?

UPDATE funnel_external_walls SET length = '8', width = '4' WHERE id = 4;

"COMMIT"

"COMMIT";

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

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

"START TRANSACTION"

"START TRANSACTION";