Symfony Profiler

Query Metrics

13 Database Queries

12 Different statements

10.13 ms Query time

1 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.46 ms
(34.20%)

SELECT f0_.id AS id_0, f0_.uuid AS uuid_1, f0_.current_step AS current_step_2, f0_.sort_code_completed AS sort_code_completed_3, f0_.sort_code AS sort_code_4, f0_.construction_year AS construction_year_5, f0_.last_comprehensive_renovation_year AS last_comprehensive_renovation_year_6, f0_.residential_units AS residential_units_7, f0_.number_of_floors AS number_of_floors_8, f0_.number_of_full_floors AS number_of_full_floors_9, f0_.floor_height AS floor_height_10, f0_.heated_living_area_m2 AS heated_living_area_m2_11, f0_.heating_construction_year AS heating_construction_year_12, f0_.basement_heated AS basement_heated_13, f0_.top_floor_heated AS top_floor_heated_14, f0_.roof_heated_state AS roof_heated_state_15, f0_.building_usage_type AS building_usage_type_16, f0_.building_type AS building_type_17, f0_.building_sub_type AS building_sub_type_18, f0_.energy_consumption_data AS energy_consumption_data_19, f0_.vacancy_periods AS vacancy_periods_20, f0_.step_data AS step_data_21, f0_.on_office_user_id AS on_office_user_id_22, f0_.on_office_customer_web_id AS on_office_customer_web_id_23, f0_.on_office_estate_id AS on_office_estate_id_24, f0_.on_office_api_claim AS on_office_api_claim_25, f0_.street AS street_26, f0_.house_number AS house_number_27, f0_.city AS city_28, f0_.country AS country_29, f0_.email AS email_30, f0_.building_orientation AS building_orientation_31, f0_.heated_usable_area_m2 AS heated_usable_area_m2_32, f0_.commercial_share_percentage AS commercial_share_percentage_33, f0_.stairwell_heated AS stairwell_heated_34, f0_.has_solar_hot_water AS has_solar_hot_water_35, f0_.has_solar_heating AS has_solar_heating_36, f0_.has_heat_pump_hot_water AS has_heat_pump_hot_water_37, f0_.has_heat_pump_heating AS has_heat_pump_heating_38, f0_.has_hot_water_circulation AS has_hot_water_circulation_39, f0_.solar_collector_area_m2 AS solar_collector_area_m2_40, f0_.dhw_decentral_area_m2 AS dhw_decentral_area_m2_41, f0_.dhw_decentral_surcharge AS dhw_decentral_surcharge_42, f0_.personen AS personen_43, f0_.ww_verbrauch_lp_d AS ww_verbrauch_lp_d_44, f0_.verification_hash AS verification_hash_45, f0_.address_confirmed AS address_confirmed_46, f0_.construction_year_at_registration AS construction_year_at_registration_47, f0_.residential_units_at_registration AS residential_units_at_registration_48, f0_.renovated_to1977_standard AS renovated_to1977_standard_49, f0_.pre1977_confirmation_given AS pre1977_confirmation_given_50, f0_.funnel_building_type AS funnel_building_type_51, f0_.heating_energy_carrier AS heating_energy_carrier_52, f0_.hot_water_energy_carrier AS hot_water_energy_carrier_53, f0_.hot_water_generation AS hot_water_generation_54, f0_.ventilation_types AS ventilation_types_55, f0_.cooling_types AS cooling_types_56, f0_.air_conditioning_count AS air_conditioning_count_57, f0_.cooled_area_m2 AS cooled_area_m2_58, f0_.air_conditioning_inspection_date AS air_conditioning_inspection_date_59, f0_.heating_generates_hot_water AS heating_generates_hot_water_60, f0_.house_image_path AS house_image_path_61, f0_.purpose AS purpose_62, f0_.finished AS finished_63, f0_.dibt_registration_number AS dibt_registration_number_64, f0_.dibt_processed AS dibt_processed_65, f0_.insufficient_information_mail AS insufficient_information_mail_66, f0_.pdf_email_sent AS pdf_email_sent_67, f0_.pdf_file_path AS pdf_file_path_68, f0_.preview_pdf_file_path AS preview_pdf_file_path_69, f0_.selected_product_identifier AS selected_product_identifier_70, f0_.payment_status AS payment_status_71, f0_.payment_parameter_cache_id AS payment_parameter_cache_id_72, f0_.payment_paid_at AS payment_paid_at_73, f0_.plausi_status AS plausi_status_74, f0_.plausi_errors AS plausi_errors_75, f0_.plausi_checked_at AS plausi_checked_at_76, f0_.heating_photo_bypass AS heating_photo_bypass_77, f0_.heating_review_required AS heating_review_required_78, f0_.heating_review_completed AS heating_review_completed_79, f0_.heating_review_requested_at AS heating_review_requested_at_80, f0_.heating_plausibility AS heating_plausibility_81, f0_.heating_check_passed AS heating_check_passed_82, f0_.certificate_type AS certificate_type_83, f0_.origin AS origin_84, f0_.construction_elements_data AS construction_elements_data_85, f0_.windows_data AS windows_data_86, f0_.doors_data AS doors_data_87, f0_.thermal_bridges_data AS thermal_bridges_data_88, f0_.certificate_reason AS certificate_reason_89, f0_.building_attachment_type AS building_attachment_type_90, f0_.building_category AS building_category_91, f0_.building_usable_area AS building_usable_area_92, f0_.insulation_present AS insulation_present_93, f0_.insulation_data AS insulation_data_94, f0_.heating_system_year AS heating_system_year_95, f0_.heating_distribution_type AS heating_distribution_type_96, f0_.heiz_uebertragung AS heiz_uebertragung_97, f0_.heiz_verteilnetz AS heiz_verteilnetz_98, f0_.heiz_layout AS heiz_layout_99, f0_.heiz_technik AS heiz_technik_100, f0_.tw_speicher_aufstellung AS tw_speicher_aufstellung_101, f0_.has_secondary_heating_system AS has_secondary_heating_system_102, f0_.secondary_heating_data AS secondary_heating_data_103, f0_.uses_renewable_energy AS uses_renewable_energy_104, f0_.renewable_energy_data AS renewable_energy_data_105, f0_.has_radiator_niches AS has_radiator_niches_106, f0_.has_roller_shutter_boxes AS has_roller_shutter_boxes_107, f0_.underfloor_heating_share AS underfloor_heating_share_108, f0_.heating_system_photo AS heating_system_photo_109, f0_.created_at AS created_at_110, f0_.updated_at AS updated_at_111, f0_.person_id AS person_id_112, f0_.funnel_id AS funnel_id_113 FROM funnel_states f0_ WHERE f0_.on_office_user_id = ? AND f0_.on_office_estate_id = ? AND f0_.id <> ? AND f0_.payment_paid_at IS NULL AND f0_.current_step <> ? ORDER BY f0_.created_at DESC LIMIT 1

Parameters:

[
  "33"
  437
  78
  "on_office_wizard_step1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.uuid AS uuid_1,
  f0_.current_step AS current_step_2,
  f0_.sort_code_completed AS sort_code_completed_3,
  f0_.sort_code AS sort_code_4,
  f0_.construction_year AS construction_year_5,
  f0_.last_comprehensive_renovation_year AS last_comprehensive_renovation_year_6,
  f0_.residential_units AS residential_units_7,
  f0_.number_of_floors AS number_of_floors_8,
  f0_.number_of_full_floors AS number_of_full_floors_9,
  f0_.floor_height AS floor_height_10,
  f0_.heated_living_area_m2 AS heated_living_area_m2_11,
  f0_.heating_construction_year AS heating_construction_year_12,
  f0_.basement_heated AS basement_heated_13,
  f0_.top_floor_heated AS top_floor_heated_14,
  f0_.roof_heated_state AS roof_heated_state_15,
  f0_.building_usage_type AS building_usage_type_16,
  f0_.building_type AS building_type_17,
  f0_.building_sub_type AS building_sub_type_18,
  f0_.energy_consumption_data AS energy_consumption_data_19,
  f0_.vacancy_periods AS vacancy_periods_20,
  f0_.step_data AS step_data_21,
  f0_.on_office_user_id AS on_office_user_id_22,
  f0_.on_office_customer_web_id AS on_office_customer_web_id_23,
  f0_.on_office_estate_id AS on_office_estate_id_24,
  f0_.on_office_api_claim AS on_office_api_claim_25,
  f0_.street AS street_26,
  f0_.house_number AS house_number_27,
  f0_.city AS city_28,
  f0_.country AS country_29,
  f0_.email AS email_30,
  f0_.building_orientation AS building_orientation_31,
  f0_.heated_usable_area_m2 AS heated_usable_area_m2_32,
  f0_.commercial_share_percentage AS commercial_share_percentage_33,
  f0_.stairwell_heated AS stairwell_heated_34,
  f0_.has_solar_hot_water AS has_solar_hot_water_35,
  f0_.has_solar_heating AS has_solar_heating_36,
  f0_.has_heat_pump_hot_water AS has_heat_pump_hot_water_37,
  f0_.has_heat_pump_heating AS has_heat_pump_heating_38,
  f0_.has_hot_water_circulation AS has_hot_water_circulation_39,
  f0_.solar_collector_area_m2 AS solar_collector_area_m2_40,
  f0_.dhw_decentral_area_m2 AS dhw_decentral_area_m2_41,
  f0_.dhw_decentral_surcharge AS dhw_decentral_surcharge_42,
  f0_.personen AS personen_43,
  f0_.ww_verbrauch_lp_d AS ww_verbrauch_lp_d_44,
  f0_.verification_hash AS verification_hash_45,
  f0_.address_confirmed AS address_confirmed_46,
  f0_.construction_year_at_registration AS construction_year_at_registration_47,
  f0_.residential_units_at_registration AS residential_units_at_registration_48,
  f0_.renovated_to1977_standard AS renovated_to1977_standard_49,
  f0_.pre1977_confirmation_given AS pre1977_confirmation_given_50,
  f0_.funnel_building_type AS funnel_building_type_51,
  f0_.heating_energy_carrier AS heating_energy_carrier_52,
  f0_.hot_water_energy_carrier AS hot_water_energy_carrier_53,
  f0_.hot_water_generation AS hot_water_generation_54,
  f0_.ventilation_types AS ventilation_types_55,
  f0_.cooling_types AS cooling_types_56,
  f0_.air_conditioning_count AS air_conditioning_count_57,
  f0_.cooled_area_m2 AS cooled_area_m2_58,
  f0_.air_conditioning_inspection_date AS air_conditioning_inspection_date_59,
  f0_.heating_generates_hot_water AS heating_generates_hot_water_60,
  f0_.house_image_path AS house_image_path_61,
  f0_.purpose AS purpose_62,
  f0_.finished AS finished_63,
  f0_.dibt_registration_number AS dibt_registration_number_64,
  f0_.dibt_processed AS dibt_processed_65,
  f0_.insufficient_information_mail AS insufficient_information_mail_66,
  f0_.pdf_email_sent AS pdf_email_sent_67,
  f0_.pdf_file_path AS pdf_file_path_68,
  f0_.preview_pdf_file_path AS preview_pdf_file_path_69,
  f0_.selected_product_identifier AS selected_product_identifier_70,
  f0_.payment_status AS payment_status_71,
  f0_.payment_parameter_cache_id AS payment_parameter_cache_id_72,
  f0_.payment_paid_at AS payment_paid_at_73,
  f0_.plausi_status AS plausi_status_74,
  f0_.plausi_errors AS plausi_errors_75,
  f0_.plausi_checked_at AS plausi_checked_at_76,
  f0_.heating_photo_bypass AS heating_photo_bypass_77,
  f0_.heating_review_required AS heating_review_required_78,
  f0_.heating_review_completed AS heating_review_completed_79,
  f0_.heating_review_requested_at AS heating_review_requested_at_80,
  f0_.heating_plausibility AS heating_plausibility_81,
  f0_.heating_check_passed AS heating_check_passed_82,
  f0_.certificate_type AS certificate_type_83,
  f0_.origin AS origin_84,
  f0_.construction_elements_data AS construction_elements_data_85,
  f0_.windows_data AS windows_data_86,
  f0_.doors_data AS doors_data_87,
  f0_.thermal_bridges_data AS thermal_bridges_data_88,
  f0_.certificate_reason AS certificate_reason_89,
  f0_.building_attachment_type AS building_attachment_type_90,
  f0_.building_category AS building_category_91,
  f0_.building_usable_area AS building_usable_area_92,
  f0_.insulation_present AS insulation_present_93,
  f0_.insulation_data AS insulation_data_94,
  f0_.heating_system_year AS heating_system_year_95,
  f0_.heating_distribution_type AS heating_distribution_type_96,
  f0_.heiz_uebertragung AS heiz_uebertragung_97,
  f0_.heiz_verteilnetz AS heiz_verteilnetz_98,
  f0_.heiz_layout AS heiz_layout_99,
  f0_.heiz_technik AS heiz_technik_100,
  f0_.tw_speicher_aufstellung AS tw_speicher_aufstellung_101,
  f0_.has_secondary_heating_system AS has_secondary_heating_system_102,
  f0_.secondary_heating_data AS secondary_heating_data_103,
  f0_.uses_renewable_energy AS uses_renewable_energy_104,
  f0_.renewable_energy_data AS renewable_energy_data_105,
  f0_.has_radiator_niches AS has_radiator_niches_106,
  f0_.has_roller_shutter_boxes AS has_roller_shutter_boxes_107,
  f0_.underfloor_heating_share AS underfloor_heating_share_108,
  f0_.heating_system_photo AS heating_system_photo_109,
  f0_.created_at AS created_at_110,
  f0_.updated_at AS updated_at_111,
  f0_.person_id AS person_id_112,
  f0_.funnel_id AS funnel_id_113
FROM
  funnel_states f0_
WHERE
  f0_.on_office_user_id = ?
  AND f0_.on_office_estate_id = ?
  AND f0_.id <> ?
  AND f0_.payment_paid_at IS NULL
  AND f0_.current_step <> ?
ORDER BY
  f0_.created_at DESC
LIMIT
  1

SELECT f0_.id AS id_0, f0_.uuid AS uuid_1, f0_.current_step AS current_step_2, f0_.sort_code_completed AS sort_code_completed_3, f0_.sort_code AS sort_code_4, f0_.construction_year AS construction_year_5, f0_.last_comprehensive_renovation_year AS last_comprehensive_renovation_year_6, f0_.residential_units AS residential_units_7, f0_.number_of_floors AS number_of_floors_8, f0_.number_of_full_floors AS number_of_full_floors_9, f0_.floor_height AS floor_height_10, f0_.heated_living_area_m2 AS heated_living_area_m2_11, f0_.heating_construction_year AS heating_construction_year_12, f0_.basement_heated AS basement_heated_13, f0_.top_floor_heated AS top_floor_heated_14, f0_.roof_heated_state AS roof_heated_state_15, f0_.building_usage_type AS building_usage_type_16, f0_.building_type AS building_type_17, f0_.building_sub_type AS building_sub_type_18, f0_.energy_consumption_data AS energy_consumption_data_19, f0_.vacancy_periods AS vacancy_periods_20, f0_.step_data AS step_data_21, f0_.on_office_user_id AS on_office_user_id_22, f0_.on_office_customer_web_id AS on_office_customer_web_id_23, f0_.on_office_estate_id AS on_office_estate_id_24, f0_.on_office_api_claim AS on_office_api_claim_25, f0_.street AS street_26, f0_.house_number AS house_number_27, f0_.city AS city_28, f0_.country AS country_29, f0_.email AS email_30, f0_.building_orientation AS building_orientation_31, f0_.heated_usable_area_m2 AS heated_usable_area_m2_32, f0_.commercial_share_percentage AS commercial_share_percentage_33, f0_.stairwell_heated AS stairwell_heated_34, f0_.has_solar_hot_water AS has_solar_hot_water_35, f0_.has_solar_heating AS has_solar_heating_36, f0_.has_heat_pump_hot_water AS has_heat_pump_hot_water_37, f0_.has_heat_pump_heating AS has_heat_pump_heating_38, f0_.has_hot_water_circulation AS has_hot_water_circulation_39, f0_.solar_collector_area_m2 AS solar_collector_area_m2_40, f0_.dhw_decentral_area_m2 AS dhw_decentral_area_m2_41, f0_.dhw_decentral_surcharge AS dhw_decentral_surcharge_42, f0_.personen AS personen_43, f0_.ww_verbrauch_lp_d AS ww_verbrauch_lp_d_44, f0_.verification_hash AS verification_hash_45, f0_.address_confirmed AS address_confirmed_46, f0_.construction_year_at_registration AS construction_year_at_registration_47, f0_.residential_units_at_registration AS residential_units_at_registration_48, f0_.renovated_to1977_standard AS renovated_to1977_standard_49, f0_.pre1977_confirmation_given AS pre1977_confirmation_given_50, f0_.funnel_building_type AS funnel_building_type_51, f0_.heating_energy_carrier AS heating_energy_carrier_52, f0_.hot_water_energy_carrier AS hot_water_energy_carrier_53, f0_.hot_water_generation AS hot_water_generation_54, f0_.ventilation_types AS ventilation_types_55, f0_.cooling_types AS cooling_types_56, f0_.air_conditioning_count AS air_conditioning_count_57, f0_.cooled_area_m2 AS cooled_area_m2_58, f0_.air_conditioning_inspection_date AS air_conditioning_inspection_date_59, f0_.heating_generates_hot_water AS heating_generates_hot_water_60, f0_.house_image_path AS house_image_path_61, f0_.purpose AS purpose_62, f0_.finished AS finished_63, f0_.dibt_registration_number AS dibt_registration_number_64, f0_.dibt_processed AS dibt_processed_65, f0_.insufficient_information_mail AS insufficient_information_mail_66, f0_.pdf_email_sent AS pdf_email_sent_67, f0_.pdf_file_path AS pdf_file_path_68, f0_.preview_pdf_file_path AS preview_pdf_file_path_69, f0_.selected_product_identifier AS selected_product_identifier_70, f0_.payment_status AS payment_status_71, f0_.payment_parameter_cache_id AS payment_parameter_cache_id_72, f0_.payment_paid_at AS payment_paid_at_73, f0_.plausi_status AS plausi_status_74, f0_.plausi_errors AS plausi_errors_75, f0_.plausi_checked_at AS plausi_checked_at_76, f0_.heating_photo_bypass AS heating_photo_bypass_77, f0_.heating_review_required AS heating_review_required_78, f0_.heating_review_completed AS heating_review_completed_79, f0_.heating_review_requested_at AS heating_review_requested_at_80, f0_.heating_plausibility AS heating_plausibility_81, f0_.heating_check_passed AS heating_check_passed_82, f0_.certificate_type AS certificate_type_83, f0_.origin AS origin_84, f0_.construction_elements_data AS construction_elements_data_85, f0_.windows_data AS windows_data_86, f0_.doors_data AS doors_data_87, f0_.thermal_bridges_data AS thermal_bridges_data_88, f0_.certificate_reason AS certificate_reason_89, f0_.building_attachment_type AS building_attachment_type_90, f0_.building_category AS building_category_91, f0_.building_usable_area AS building_usable_area_92, f0_.insulation_present AS insulation_present_93, f0_.insulation_data AS insulation_data_94, f0_.heating_system_year AS heating_system_year_95, f0_.heating_distribution_type AS heating_distribution_type_96, f0_.heiz_uebertragung AS heiz_uebertragung_97, f0_.heiz_verteilnetz AS heiz_verteilnetz_98, f0_.heiz_layout AS heiz_layout_99, f0_.heiz_technik AS heiz_technik_100, f0_.tw_speicher_aufstellung AS tw_speicher_aufstellung_101, f0_.has_secondary_heating_system AS has_secondary_heating_system_102, f0_.secondary_heating_data AS secondary_heating_data_103, f0_.uses_renewable_energy AS uses_renewable_energy_104, f0_.renewable_energy_data AS renewable_energy_data_105, f0_.has_radiator_niches AS has_radiator_niches_106, f0_.has_roller_shutter_boxes AS has_roller_shutter_boxes_107, f0_.underfloor_heating_share AS underfloor_heating_share_108, f0_.heating_system_photo AS heating_system_photo_109, f0_.created_at AS created_at_110, f0_.updated_at AS updated_at_111, f0_.person_id AS person_id_112, f0_.funnel_id AS funnel_id_113 FROM funnel_states f0_ WHERE f0_.on_office_user_id = '33' AND f0_.on_office_estate_id = 437 AND f0_.id <> 78 AND f0_.payment_paid_at IS NULL AND f0_.current_step <> 'on_office_wizard_step1' ORDER BY f0_.created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
7	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
8	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 180)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

2.10 ms
(20.76%)

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

Parameters:

[
  b"\x01 ‡r\x16 xa¢\x14‰GsB\x08“"
]

View formatted query View runnable query Explain query View query backtrace

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 = 0x01A0877216A07861A214894773420893 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 39)
5	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 180)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.20 ms
(11.88%)

SELECT MIN(p0_.amount) AS sclr_0, MAX(p0_.amount) AS sclr_1, p0_.currency AS currency_2 FROM payment_product p0_ WHERE p0_.certificate_type = ? AND p0_.active = 1 GROUP BY p0_.currency

Parameters:

[
  "bedarfsausweis"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MIN(p0_.amount) AS sclr_0,
  MAX(p0_.amount) AS sclr_1,
  p0_.currency AS currency_2
FROM
  payment_product p0_
WHERE
  p0_.certificate_type = ?
  AND p0_.active = 1
GROUP BY
  p0_.currency

SELECT MIN(p0_.amount) AS sclr_0, MAX(p0_.amount) AS sclr_1, p0_.currency AS currency_2 FROM payment_product p0_ WHERE p0_.certificate_type = 'bedarfsausweis' AND p0_.active = 1 GROUP BY p0_.currency;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Payment\ProductRepository->findPriceRangeByCertificateType (line 27)
7	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 54)
8	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 180)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.54 ms
(5.34%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.expected_filename AS expected_filename_4, t0.waiting_at AS waiting_at_5, t0.done_at AS done_at_6, t0.failed_at AS failed_at_7, t0.local_pdf_relative_path AS local_pdf_relative_path_8, t0.error_message AS error_message_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.funnel_state_id AS funnel_state_id_12 FROM funnel_state_verification_states t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.status AS status_3,
  t0.expected_filename AS expected_filename_4,
  t0.waiting_at AS waiting_at_5,
  t0.done_at AS done_at_6,
  t0.failed_at AS failed_at_7,
  t0.local_pdf_relative_path AS local_pdf_relative_path_8,
  t0.error_message AS error_message_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.funnel_state_id AS funnel_state_id_12
FROM
  funnel_state_verification_states t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.expected_filename AS expected_filename_4, t0.waiting_at AS waiting_at_5, t0.done_at AS done_at_6, t0.failed_at AS failed_at_7, t0.local_pdf_relative_path AS local_pdf_relative_path_8, t0.error_message AS error_message_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.funnel_state_id AS funnel_state_id_12 FROM funnel_state_verification_states t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.49 ms
(4.80%)

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

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.41 ms
(4.04%)

SELECT t0.id AS id_1, t0.heiz_uebertragung AS heiz_uebertragung_2, t0.heiz_vorlauf_temp AS heiz_vorlauf_temp_3, t0.heiz_ruecklauf_temp AS heiz_ruecklauf_temp_4, t0.heiz_verteilnetz AS heiz_verteilnetz_5, t0.heiz_verteilung_baujahr AS heiz_verteilung_baujahr_6, t0.heiz_verteilung_gedaemmt AS heiz_verteilung_gedaemmt_7, t0.heiz_speicher_baujahr AS heiz_speicher_baujahr_8, t0.heiz_speicher_vorhanden AS heiz_speicher_vorhanden_9, t0.heiz_erzeugung_baujahr AS heiz_erzeugung_baujahr_10, t0.heiz_layout AS heiz_layout_11, t0.heiz_technik AS heiz_technik_12, t0.heiz_energietraeger AS heiz_energietraeger_13, t0.heiz_hersteller AS heiz_hersteller_14, t0.heiz_vorlauf_temp_sommer AS heiz_vorlauf_temp_sommer_15, t0.tw_verteilung_baujahr AS tw_verteilung_baujahr_16, t0.tw_verteilnetz AS tw_verteilnetz_17, t0.tw_zirkulation AS tw_zirkulation_18, t0.tw_speicher_aufstellung AS tw_speicher_aufstellung_19, t0.tw_speicher_baujahr AS tw_speicher_baujahr_20, t0.tw_erzeugung_baujahr AS tw_erzeugung_baujahr_21, t0.tw_technik AS tw_technik_22, t0.tw_solaranlage AS tw_solaranlage_23, t0.tw_solar_area_m2 AS tw_solar_area_m2_24, t0.tw_energietraeger AS tw_energietraeger_25, t0.tw_hersteller AS tw_hersteller_26, t0.lueftung_vorhanden AS lueftung_vorhanden_27, t0.lueftung_verteilung_baujahr AS lueftung_verteilung_baujahr_28, t0.lueftung_erzeugung_baujahr AS lueftung_erzeugung_baujahr_29, t0.lueftung_aufstellort AS lueftung_aufstellort_30, t0.lueftung_art AS lueftung_art_31, t0.kuehlung_vorhanden AS kuehlung_vorhanden_32, t0.kuehlung_erzeugung_baujahr AS kuehlung_erzeugung_baujahr_33, t0.kuehlung_technik AS kuehlung_technik_34, t0.kuehl_flaeche AS kuehl_flaeche_35, t0.funnel_state_id AS funnel_state_id_36 FROM funnel_anlagen t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.heiz_uebertragung AS heiz_uebertragung_2,
  t0.heiz_vorlauf_temp AS heiz_vorlauf_temp_3,
  t0.heiz_ruecklauf_temp AS heiz_ruecklauf_temp_4,
  t0.heiz_verteilnetz AS heiz_verteilnetz_5,
  t0.heiz_verteilung_baujahr AS heiz_verteilung_baujahr_6,
  t0.heiz_verteilung_gedaemmt AS heiz_verteilung_gedaemmt_7,
  t0.heiz_speicher_baujahr AS heiz_speicher_baujahr_8,
  t0.heiz_speicher_vorhanden AS heiz_speicher_vorhanden_9,
  t0.heiz_erzeugung_baujahr AS heiz_erzeugung_baujahr_10,
  t0.heiz_layout AS heiz_layout_11,
  t0.heiz_technik AS heiz_technik_12,
  t0.heiz_energietraeger AS heiz_energietraeger_13,
  t0.heiz_hersteller AS heiz_hersteller_14,
  t0.heiz_vorlauf_temp_sommer AS heiz_vorlauf_temp_sommer_15,
  t0.tw_verteilung_baujahr AS tw_verteilung_baujahr_16,
  t0.tw_verteilnetz AS tw_verteilnetz_17,
  t0.tw_zirkulation AS tw_zirkulation_18,
  t0.tw_speicher_aufstellung AS tw_speicher_aufstellung_19,
  t0.tw_speicher_baujahr AS tw_speicher_baujahr_20,
  t0.tw_erzeugung_baujahr AS tw_erzeugung_baujahr_21,
  t0.tw_technik AS tw_technik_22,
  t0.tw_solaranlage AS tw_solaranlage_23,
  t0.tw_solar_area_m2 AS tw_solar_area_m2_24,
  t0.tw_energietraeger AS tw_energietraeger_25,
  t0.tw_hersteller AS tw_hersteller_26,
  t0.lueftung_vorhanden AS lueftung_vorhanden_27,
  t0.lueftung_verteilung_baujahr AS lueftung_verteilung_baujahr_28,
  t0.lueftung_erzeugung_baujahr AS lueftung_erzeugung_baujahr_29,
  t0.lueftung_aufstellort AS lueftung_aufstellort_30,
  t0.lueftung_art AS lueftung_art_31,
  t0.kuehlung_vorhanden AS kuehlung_vorhanden_32,
  t0.kuehlung_erzeugung_baujahr AS kuehlung_erzeugung_baujahr_33,
  t0.kuehlung_technik AS kuehlung_technik_34,
  t0.kuehl_flaeche AS kuehl_flaeche_35,
  t0.funnel_state_id AS funnel_state_id_36
FROM
  funnel_anlagen t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.heiz_uebertragung AS heiz_uebertragung_2, t0.heiz_vorlauf_temp AS heiz_vorlauf_temp_3, t0.heiz_ruecklauf_temp AS heiz_ruecklauf_temp_4, t0.heiz_verteilnetz AS heiz_verteilnetz_5, t0.heiz_verteilung_baujahr AS heiz_verteilung_baujahr_6, t0.heiz_verteilung_gedaemmt AS heiz_verteilung_gedaemmt_7, t0.heiz_speicher_baujahr AS heiz_speicher_baujahr_8, t0.heiz_speicher_vorhanden AS heiz_speicher_vorhanden_9, t0.heiz_erzeugung_baujahr AS heiz_erzeugung_baujahr_10, t0.heiz_layout AS heiz_layout_11, t0.heiz_technik AS heiz_technik_12, t0.heiz_energietraeger AS heiz_energietraeger_13, t0.heiz_hersteller AS heiz_hersteller_14, t0.heiz_vorlauf_temp_sommer AS heiz_vorlauf_temp_sommer_15, t0.tw_verteilung_baujahr AS tw_verteilung_baujahr_16, t0.tw_verteilnetz AS tw_verteilnetz_17, t0.tw_zirkulation AS tw_zirkulation_18, t0.tw_speicher_aufstellung AS tw_speicher_aufstellung_19, t0.tw_speicher_baujahr AS tw_speicher_baujahr_20, t0.tw_erzeugung_baujahr AS tw_erzeugung_baujahr_21, t0.tw_technik AS tw_technik_22, t0.tw_solaranlage AS tw_solaranlage_23, t0.tw_solar_area_m2 AS tw_solar_area_m2_24, t0.tw_energietraeger AS tw_energietraeger_25, t0.tw_hersteller AS tw_hersteller_26, t0.lueftung_vorhanden AS lueftung_vorhanden_27, t0.lueftung_verteilung_baujahr AS lueftung_verteilung_baujahr_28, t0.lueftung_erzeugung_baujahr AS lueftung_erzeugung_baujahr_29, t0.lueftung_aufstellort AS lueftung_aufstellort_30, t0.lueftung_art AS lueftung_art_31, t0.kuehlung_vorhanden AS kuehlung_vorhanden_32, t0.kuehlung_erzeugung_baujahr AS kuehlung_erzeugung_baujahr_33, t0.kuehlung_technik AS kuehlung_technik_34, t0.kuehl_flaeche AS kuehl_flaeche_35, t0.funnel_state_id AS funnel_state_id_36 FROM funnel_anlagen t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.39 ms
(3.80%)

SELECT t0.id AS id_1, t0.shape_type AS shape_type_2, t0.length AS length_3, t0.width AS width_4, t0.length_large AS length_large_5, t0.width_large AS width_large_6, t0.length_short AS length_short_7, t0.width_short AS width_short_8, t0.orientation AS orientation_9, t0.bauweise_art AS bauweise_art_10, t0.renovation_year AS renovation_year_11, t0.sort_order AS sort_order_12, t0.funnel_state_id AS funnel_state_id_13 FROM funnel_external_walls t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.shape_type AS shape_type_2,
  t0.length AS length_3,
  t0.width AS width_4,
  t0.length_large AS length_large_5,
  t0.width_large AS width_large_6,
  t0.length_short AS length_short_7,
  t0.width_short AS width_short_8,
  t0.orientation AS orientation_9,
  t0.bauweise_art AS bauweise_art_10,
  t0.renovation_year AS renovation_year_11,
  t0.sort_order AS sort_order_12,
  t0.funnel_state_id AS funnel_state_id_13
FROM
  funnel_external_walls t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.shape_type AS shape_type_2, t0.length AS length_3, t0.width AS width_4, t0.length_large AS length_large_5, t0.width_large AS width_large_6, t0.length_short AS length_short_7, t0.width_short AS width_short_8, t0.orientation AS orientation_9, t0.bauweise_art AS bauweise_art_10, t0.renovation_year AS renovation_year_11, t0.sort_order AS sort_order_12, t0.funnel_state_id AS funnel_state_id_13 FROM funnel_external_walls t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.34 ms
(3.39%)

SELECT t0.id AS id_1, t0.has_old_leaky_shutter_boxes AS has_old_leaky_shutter_boxes_2, t0.has_controlled_ventilation_system AS has_controlled_ventilation_system_3, t0.has_chimney_or_open_shafts AS has_chimney_or_open_shafts_4, t0.has_noticeable_draft AS has_noticeable_draft_5, t0.estimated_n50 AS estimated_n50_6, t0.estimated_airtightness_class AS estimated_airtightness_class_7, t0.estimated_heat_recovery_percent AS estimated_heat_recovery_percent_8, t0.estimated_heat_recovery_efficiency AS estimated_heat_recovery_efficiency_9, t0.estimated_q50 AS estimated_q50_10, t0.estimated_v50 AS estimated_v50_11, t0.estimated_building_air_volume AS estimated_building_air_volume_12, t0.estimated_envelope_area AS estimated_envelope_area_13, t0.source AS source_14, t0.confidence AS confidence_15, t0.funnel_state_id AS funnel_state_id_16 FROM funnel_ventilations t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.has_old_leaky_shutter_boxes AS has_old_leaky_shutter_boxes_2,
  t0.has_controlled_ventilation_system AS has_controlled_ventilation_system_3,
  t0.has_chimney_or_open_shafts AS has_chimney_or_open_shafts_4,
  t0.has_noticeable_draft AS has_noticeable_draft_5,
  t0.estimated_n50 AS estimated_n50_6,
  t0.estimated_airtightness_class AS estimated_airtightness_class_7,
  t0.estimated_heat_recovery_percent AS estimated_heat_recovery_percent_8,
  t0.estimated_heat_recovery_efficiency AS estimated_heat_recovery_efficiency_9,
  t0.estimated_q50 AS estimated_q50_10,
  t0.estimated_v50 AS estimated_v50_11,
  t0.estimated_building_air_volume AS estimated_building_air_volume_12,
  t0.estimated_envelope_area AS estimated_envelope_area_13,
  t0.source AS source_14,
  t0.confidence AS confidence_15,
  t0.funnel_state_id AS funnel_state_id_16
FROM
  funnel_ventilations t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.has_old_leaky_shutter_boxes AS has_old_leaky_shutter_boxes_2, t0.has_controlled_ventilation_system AS has_controlled_ventilation_system_3, t0.has_chimney_or_open_shafts AS has_chimney_or_open_shafts_4, t0.has_noticeable_draft AS has_noticeable_draft_5, t0.estimated_n50 AS estimated_n50_6, t0.estimated_airtightness_class AS estimated_airtightness_class_7, t0.estimated_heat_recovery_percent AS estimated_heat_recovery_percent_8, t0.estimated_heat_recovery_efficiency AS estimated_heat_recovery_efficiency_9, t0.estimated_q50 AS estimated_q50_10, t0.estimated_v50 AS estimated_v50_11, t0.estimated_building_air_volume AS estimated_building_air_volume_12, t0.estimated_envelope_area AS estimated_envelope_area_13, t0.source AS source_14, t0.confidence AS confidence_15, t0.funnel_state_id AS funnel_state_id_16 FROM funnel_ventilations t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.32 ms
(3.18%)

SELECT t0.id AS id_1, t0.confidence AS confidence_2, t0.interpretation AS interpretation_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.funnel_state_id AS funnel_state_id_6 FROM plausi_storages t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.confidence AS confidence_2,
  t0.interpretation AS interpretation_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.funnel_state_id AS funnel_state_id_6
FROM
  plausi_storages t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.confidence AS confidence_2, t0.interpretation AS interpretation_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.funnel_state_id AS funnel_state_id_6 FROM plausi_storages t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.32 ms
(3.12%)

SELECT t0.id AS id_1, t0.installation_date AS installation_date_2, t0.generated_heat_kwh AS generated_heat_kwh_3, t0.consumed_electricity_kwh AS consumed_electricity_kwh_4, t0.funnel_state_id AS funnel_state_id_5 FROM funnel_heat_pumps t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.installation_date AS installation_date_2,
  t0.generated_heat_kwh AS generated_heat_kwh_3,
  t0.consumed_electricity_kwh AS consumed_electricity_kwh_4,
  t0.funnel_state_id AS funnel_state_id_5
FROM
  funnel_heat_pumps t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.installation_date AS installation_date_2, t0.generated_heat_kwh AS generated_heat_kwh_3, t0.consumed_electricity_kwh AS consumed_electricity_kwh_4, t0.funnel_state_id AS funnel_state_id_5 FROM funnel_heat_pumps t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.29 ms
(2.84%)

SELECT t0.id AS id_1, t0.basement_type AS basement_type_2, t0.basement_ceiling_type AS basement_ceiling_type_3, t0.basement_insulation AS basement_insulation_4, t0.renovation_year AS renovation_year_5, t0.funnel_state_id AS funnel_state_id_6 FROM funnel_basements t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.basement_type AS basement_type_2,
  t0.basement_ceiling_type AS basement_ceiling_type_3,
  t0.basement_insulation AS basement_insulation_4,
  t0.renovation_year AS renovation_year_5,
  t0.funnel_state_id AS funnel_state_id_6
FROM
  funnel_basements t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.basement_type AS basement_type_2, t0.basement_ceiling_type AS basement_ceiling_type_3, t0.basement_insulation AS basement_insulation_4, t0.renovation_year AS renovation_year_5, t0.funnel_state_id AS funnel_state_id_6 FROM funnel_basements t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.27 ms
(2.65%)

SELECT t0.id AS id_1, t0.roof_type AS roof_type_2, t0.construction_type AS construction_type_3, t0.roof_form_type AS roof_form_type_4, t0.roof_height_m AS roof_height_m_5, t0.roof_spitzboden_height_m AS roof_spitzboden_height_m_6, t0.renovation_year AS renovation_year_7, t0.sort_order AS sort_order_8, t0.funnel_state_id AS funnel_state_id_9 FROM funnel_roofs t0 WHERE t0.funnel_state_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.roof_type AS roof_type_2,
  t0.construction_type AS construction_type_3,
  t0.roof_form_type AS roof_form_type_4,
  t0.roof_height_m AS roof_height_m_5,
  t0.roof_spitzboden_height_m AS roof_spitzboden_height_m_6,
  t0.renovation_year AS renovation_year_7,
  t0.sort_order AS sort_order_8,
  t0.funnel_state_id AS funnel_state_id_9
FROM
  funnel_roofs t0
WHERE
  t0.funnel_state_id = ?

SELECT t0.id AS id_1, t0.roof_type AS roof_type_2, t0.construction_type AS construction_type_3, t0.roof_form_type AS roof_form_type_4, t0.roof_height_m AS roof_height_m_5, t0.roof_spitzboden_height_m AS roof_spitzboden_height_m_6, t0.renovation_year AS renovation_year_7, t0.sort_order AS sort_order_8, t0.funnel_state_id AS funnel_state_id_9 FROM funnel_roofs t0 WHERE t0.funnel_state_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
11	App\Repository\Funnel\FunnelStateRepository->findPreviousUnfinishedFunnels (line 190)
12	App\Controller\Public\Action\OnOfficeWizard\Step1Action->__invoke (line 52)
13	App\Controller\Public\OnOfficeWizardController->step1 (line 93)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 180)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Funnel\FunnelState	2
App\Entity\Person	2
App\Entity\Funnel\Funnel	1
App\Entity\Funnel\FunnelAnlage	1

Entities Mapping

Class	Mapping errors
App\Entity\Funnel\FunnelState	The field App\Entity\Funnel\FunnelState#plausiStorage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Plausi\PlausiStorage#funnelState does not contain the required 'inversedBy: "plausiStorage"' attribute.
App\Entity\Person	No errors.
App\Entity\Funnel\FunnelStateVerificationState	No errors.
App\Entity\Funnel\Funnel	No errors.
App\Entity\Funnel\FunnelExternalWall	No errors.
App\Entity\Funnel\FunnelRoof	No errors.
App\Entity\Funnel\FunnelBasement	No errors.
App\Entity\Funnel\FunnelVentilation	No errors.
App\Entity\Funnel\FunnelAnlage	No errors.
App\Entity\Funnel\FunnelHeatPump	No errors.
App\Entity\Plausi\PlausiStorage	No errors.
App\Entity\Climate\ClimateData	No errors.
App\Entity\Funnel\FunnelWindow	No errors.
App\Entity\Funnel\FunnelDoor	No errors.
App\Entity\Payment\Product	No errors.

Symfony Profiler

GET https://stage.vr-energie-immo.de/on-office/wizard/01a08772-16a0-7861-a214-894773420893

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping