GET https://testing-fraenkische-backend.uhp-software.com/api/object/5868/variation/15656/material-list/subsystems?lang=en

Response
200 OK
Browse referrer URL
IP
86.33.86.37
Profiled on
Token
6fecf7

Query Metrics

10 Database Queries
9 Different statements
11.68 ms Query time
0 Invalid entities
40 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.83 ms 
SELECT t0.id AS id_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.gender AS gender_8, t0.email AS email_9, t0.password AS password_10, t0.role AS role_11, t0.enabled AS enabled_12, t0.confirm_email_token AS confirm_email_token_13, t0.created_at AS created_at_14, t0.last_login_at AS last_login_at_15, t0.blocked AS blocked_16, t0.forgot_password_token AS forgot_password_token_17, t0.forgot_password_expiration_date AS forgot_password_expiration_date_18, t0.discriminator, t1.company_id AS company_id_19, t2.crm_token AS crm_token_20, t2.crm_rep_id AS crm_rep_id_21, t2.company_id AS company_id_22, t4.anonymous_user_id AS anonymous_user_id_23, t4.company_id AS company_id_24 FROM registered_user t0 LEFT JOIN external_user t1 ON t0.id = t1.id LEFT JOIN internal_user t2 ON t0.id = t2.id LEFT JOIN admin_user t3 ON t0.id = t3.id LEFT JOIN anonymous_external_user t4 ON t0.id = t4.id WHERE t0.email = ? LIMIT 1
Parameters: 
[
  "kelava@uhp.digital"
]
View formatted query    View runnable query    Explain query
2 1.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.date_deleted AS date_deleted_6, t0.status AS status_7, t0.calculation_method AS calculation_method_8, t0.is_quick_and_easy AS is_quick_and_easy_9, t0.mwod_base_calculation_option AS mwod_base_calculation_option_10, t0.mwod_dimension_optimization_option AS mwod_dimension_optimization_option_11, t0.mwod_system_type_option AS mwod_system_type_option_12, t0.mwod_infiltration_system_option AS mwod_infiltration_system_option_13, t0.swd_system_option AS swd_system_option_14, t0.mwod_water_storage_option AS mwod_water_storage_option_15, t0.block_type_option AS block_type_option_16, t0.mwod_net_volume AS mwod_net_volume_17, t0.mwod_gross_volume AS mwod_gross_volume_18, t0.mwod_vsp AS mwod_vsp_19, t0.control_shaft_type_option AS control_shaft_type_option_20, t0.pipe_swale_type_option AS pipe_swale_type_option_21, t0.total_number_of_control_shafts AS total_number_of_control_shafts_22, t0.pre_stormwater_treatment_total_number_of_control_shafts AS pre_stormwater_treatment_total_number_of_control_shafts_23, t0.number_of_frontal_control_shafts AS number_of_frontal_control_shafts_24, t0.pre_stormwater_treatment_number_of_frontal_control_shafts AS pre_stormwater_treatment_number_of_frontal_control_shafts_25, t0.number_of_trench_control_shafts AS number_of_trench_control_shafts_26, t0.switched_to_stormwater_treatment_flow AS switched_to_stormwater_treatment_flow_27, t0.switched_to_discharge_control_flow AS switched_to_discharge_control_flow_28, t0.switched_to_proof_of_overflow AS switched_to_proof_of_overflow_29, t0.rain_data AS rain_data_30, t0.expert_mode_dimensioning_type AS expert_mode_dimensioning_type_31, t0.rain_data_type AS rain_data_type_32, t0.stormwater_infiltration_workflow_option_type AS stormwater_infiltration_workflow_option_type_33, t0.stormwater_infiltration_workflow_option_value AS stormwater_infiltration_workflow_option_value_34, t0.stormwater_detention_workflow_option AS stormwater_detention_workflow_option_35, t0.stormwater_treatment_workflow_option AS stormwater_treatment_workflow_option_36, t0.rain_recurring_interval AS rain_recurring_interval_37, t0.trench_rain_recurring_interval AS trench_rain_recurring_interval_38, t0.additional_factor AS additional_factor_39, t0.trench_additional_factor AS trench_additional_factor_40, t0.flow_duration AS flow_duration_41, t0.overrun_frequency AS overrun_frequency_42, t0.security_coefficient AS security_coefficient_43, t0.additional_water_into_drench AS additional_water_into_drench_44, t0.trench_additional_water_into_drench AS trench_additional_water_into_drench_45, t0.permeable_sides AS permeable_sides_46, t0.drain_correction_factor AS drain_correction_factor_47, t0.drain_correction_factor_type AS drain_correction_factor_type_48, t0.trench_correction_factor AS trench_correction_factor_49, t0.trench_correction_factor_type AS trench_correction_factor_type_50, t0.original_length AS original_length_51, t0.expert_workflow AS expert_workflow_52, t0.is_alternative_name AS is_alternative_name_53, t0.ditch_dimensions_length AS ditch_dimensions_length_54, t0.ditch_dimensions_width AS ditch_dimensions_width_55, t0.ditch_dimensions_height AS ditch_dimensions_height_56, t0.ditch_dimensions_adjusted_length AS ditch_dimensions_adjusted_length_57, t0.ditch_dimensions_adjusted_width AS ditch_dimensions_adjusted_width_58, t0.ditch_dimensions_temporary_volume AS ditch_dimensions_temporary_volume_59, t0.trench_dimensions_length AS trench_dimensions_length_60, t0.trench_dimensions_width AS trench_dimensions_width_61, t0.trench_dimensions_depth AS trench_dimensions_depth_62, t0.trench_dimensions_angle_of_repose AS trench_dimensions_angle_of_repose_63, t0.pipe_swale_gravel_storage_coefficient AS pipe_swale_gravel_storage_coefficient_64, t0.pipe_swale_number_of_pipe_lines AS pipe_swale_number_of_pipe_lines_65, t0.current_step_flow AS current_step_flow_66, t0.current_step_step AS current_step_step_67, t0.drain_drainage_capability_input_type AS drain_drainage_capability_input_type_68, t0.drain_drainage_capability_original_value AS drain_drainage_capability_original_value_69, t0.drain_drainage_capability_converted_value AS drain_drainage_capability_converted_value_70, t0.trench_drainage_capability_input_type AS trench_drainage_capability_input_type_71, t0.trench_drainage_capability_original_value AS trench_drainage_capability_original_value_72, t0.trench_drainage_capability_converted_value AS trench_drainage_capability_converted_value_73, t0.unscaled_length_length AS unscaled_length_length_74, t0.unscaled_length_rain_amount_in_millimeters AS unscaled_length_rain_amount_in_millimeters_75, t0.unscaled_length_rain_amount_in_liters_per_second_per_hectare AS unscaled_length_rain_amount_in_liters_per_second_per_hectare_76, t0.unscaled_length_rain_duration AS unscaled_length_rain_duration_77, t0.rigoplan_object_id AS rigoplan_object_id_78, t79.id AS id_80, t79.created_at AS created_at_81, t79.updated_at AS updated_at_82, t79.comment AS comment_83, t79.object_variation_id AS object_variation_id_84, t85.id AS id_86, t85.protection_requirement AS protection_requirement_87, t85.rain_duration AS rain_duration_88, t85.average_terrain_inclination AS average_terrain_inclination_89, t85.max_discharge_at_complete_fill_up AS max_discharge_at_complete_fill_up_90, t85.volume AS volume_91, t85.gross_volume AS gross_volume_92, t85.net_volume AS net_volume_93, t85.drainage_system_type AS drainage_system_type_94, t85.additional_overflow_volume AS additional_overflow_volume_95, t85.consider_larger_drainage_area AS consider_larger_drainage_area_96, t85.ditch_dimensions_length AS ditch_dimensions_length_97, t85.ditch_dimensions_width AS ditch_dimensions_width_98, t85.ditch_dimensions_height AS ditch_dimensions_height_99, t85.ditch_dimensions_adjusted_length AS ditch_dimensions_adjusted_length_100, t85.ditch_dimensions_adjusted_width AS ditch_dimensions_adjusted_width_101, t85.ditch_dimensions_temporary_volume AS ditch_dimensions_temporary_volume_102, t85.trench_dimensions_length AS trench_dimensions_length_103, t85.trench_dimensions_width AS trench_dimensions_width_104, t85.trench_dimensions_depth AS trench_dimensions_depth_105, t85.trench_dimensions_angle_of_repose AS trench_dimensions_angle_of_repose_106, t85.allowed_flooding_frequency_id AS allowed_flooding_frequency_id_107, t85.object_variation_id AS object_variation_id_108, t0.parent_id AS parent_id_109, t110.id AS id_111, t110.drain_input_type AS drain_input_type_112, t110.drain_original_value AS drain_original_value_113, t110.drain_converted_value AS drain_converted_value_114, t110.drain_correction_factor_fort AS drain_correction_factor_fort_115, t110.drain_correction_factor_fmethod AS drain_correction_factor_fmethod_116, t110.drain_correction_factor_fmethod_type AS drain_correction_factor_fmethod_type_117, t110.trench_input_type AS trench_input_type_118, t110.trench_original_value AS trench_original_value_119, t110.trench_converted_value AS trench_converted_value_120, t110.trench_correction_factor_fmethod AS trench_correction_factor_fmethod_121, t110.trench_correction_factor_fort AS trench_correction_factor_fort_122, t110.trench_correction_factor_fmethod_type AS trench_correction_factor_fmethod_type_123, t110.object_variation_id AS object_variation_id_124, t0.water_type_id AS water_type_id_125, t126.id AS id_127, t126.created_at AS created_at_128, t126.updated_at AS updated_at_129, t126.width AS width_130, t126.height AS height_131, t126.variation_id AS variation_id_132, t0.last_modified_by AS last_modified_by_133, t0.creator_id AS creator_id_134, t135.id AS id_136, t135.cap_amount AS cap_amount_137, t135.cap_type AS cap_type_138, t135.date_created AS date_created_139, t135.date_updated AS date_updated_140, t135.object_variation_id AS object_variation_id_141, t142.id AS id_143, t142.shaft_type AS shaft_type_144, t142.shaft_amount AS shaft_amount_145, t142.frontal_shaft_amount AS frontal_shaft_amount_146, t142.date_created AS date_created_147, t142.date_updated AS date_updated_148, t142.object_variation_id AS object_variation_id_149 FROM object_variation t0 LEFT JOIN material_list t79 ON t79.object_variation_id = t0.id LEFT JOIN proof_of_overflow t85 ON t85.object_variation_id = t0.id LEFT JOIN drainage_capability_dwa_a138_part1 t110 ON t110.object_variation_id = t0.id LEFT JOIN grid t126 ON t126.variation_id = t0.id LEFT JOIN discharge_control_check_cap t135 ON t135.object_variation_id = t0.id LEFT JOIN overflow_shaft t142 ON t142.object_variation_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "15656"
]
View formatted query    View runnable query    Explain query
3 0.40 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.is_quickstart_object AS is_quickstart_object_7, t0.crm_id AS crm_id_8, t0.crm_status AS crm_status_9, t0.crm_opportunity_id AS crm_opportunity_id_10, t0.crm_seq_no AS crm_seq_no_11, t0.last_accessed_at AS last_accessed_at_12, t0.address_id AS address_id_13, t0.creator_id AS creator_id_14, t0.sales_contact_id AS sales_contact_id_15, t0.technical_contact_id AS technical_contact_id_16, t0.customer_company_id AS customer_company_id_17, t0.last_accessed_by AS last_accessed_by_18, t0.last_modified_by AS last_modified_by_19 FROM rigoplan_object t0 WHERE t0.id = ?
Parameters: 
[
  5868
]
View formatted query    View runnable query    Explain query
4 0.90 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.date_deleted AS date_deleted_6, t0.status AS status_7, t0.calculation_method AS calculation_method_8, t0.is_quick_and_easy AS is_quick_and_easy_9, t0.mwod_base_calculation_option AS mwod_base_calculation_option_10, t0.mwod_dimension_optimization_option AS mwod_dimension_optimization_option_11, t0.mwod_system_type_option AS mwod_system_type_option_12, t0.mwod_infiltration_system_option AS mwod_infiltration_system_option_13, t0.swd_system_option AS swd_system_option_14, t0.mwod_water_storage_option AS mwod_water_storage_option_15, t0.block_type_option AS block_type_option_16, t0.mwod_net_volume AS mwod_net_volume_17, t0.mwod_gross_volume AS mwod_gross_volume_18, t0.mwod_vsp AS mwod_vsp_19, t0.control_shaft_type_option AS control_shaft_type_option_20, t0.pipe_swale_type_option AS pipe_swale_type_option_21, t0.total_number_of_control_shafts AS total_number_of_control_shafts_22, t0.pre_stormwater_treatment_total_number_of_control_shafts AS pre_stormwater_treatment_total_number_of_control_shafts_23, t0.number_of_frontal_control_shafts AS number_of_frontal_control_shafts_24, t0.pre_stormwater_treatment_number_of_frontal_control_shafts AS pre_stormwater_treatment_number_of_frontal_control_shafts_25, t0.number_of_trench_control_shafts AS number_of_trench_control_shafts_26, t0.switched_to_stormwater_treatment_flow AS switched_to_stormwater_treatment_flow_27, t0.switched_to_discharge_control_flow AS switched_to_discharge_control_flow_28, t0.switched_to_proof_of_overflow AS switched_to_proof_of_overflow_29, t0.rain_data AS rain_data_30, t0.expert_mode_dimensioning_type AS expert_mode_dimensioning_type_31, t0.rain_data_type AS rain_data_type_32, t0.stormwater_infiltration_workflow_option_type AS stormwater_infiltration_workflow_option_type_33, t0.stormwater_infiltration_workflow_option_value AS stormwater_infiltration_workflow_option_value_34, t0.stormwater_detention_workflow_option AS stormwater_detention_workflow_option_35, t0.stormwater_treatment_workflow_option AS stormwater_treatment_workflow_option_36, t0.rain_recurring_interval AS rain_recurring_interval_37, t0.trench_rain_recurring_interval AS trench_rain_recurring_interval_38, t0.additional_factor AS additional_factor_39, t0.trench_additional_factor AS trench_additional_factor_40, t0.flow_duration AS flow_duration_41, t0.overrun_frequency AS overrun_frequency_42, t0.security_coefficient AS security_coefficient_43, t0.additional_water_into_drench AS additional_water_into_drench_44, t0.trench_additional_water_into_drench AS trench_additional_water_into_drench_45, t0.permeable_sides AS permeable_sides_46, t0.drain_correction_factor AS drain_correction_factor_47, t0.drain_correction_factor_type AS drain_correction_factor_type_48, t0.trench_correction_factor AS trench_correction_factor_49, t0.trench_correction_factor_type AS trench_correction_factor_type_50, t0.original_length AS original_length_51, t0.expert_workflow AS expert_workflow_52, t0.is_alternative_name AS is_alternative_name_53, t0.ditch_dimensions_length AS ditch_dimensions_length_54, t0.ditch_dimensions_width AS ditch_dimensions_width_55, t0.ditch_dimensions_height AS ditch_dimensions_height_56, t0.ditch_dimensions_adjusted_length AS ditch_dimensions_adjusted_length_57, t0.ditch_dimensions_adjusted_width AS ditch_dimensions_adjusted_width_58, t0.ditch_dimensions_temporary_volume AS ditch_dimensions_temporary_volume_59, t0.trench_dimensions_length AS trench_dimensions_length_60, t0.trench_dimensions_width AS trench_dimensions_width_61, t0.trench_dimensions_depth AS trench_dimensions_depth_62, t0.trench_dimensions_angle_of_repose AS trench_dimensions_angle_of_repose_63, t0.pipe_swale_gravel_storage_coefficient AS pipe_swale_gravel_storage_coefficient_64, t0.pipe_swale_number_of_pipe_lines AS pipe_swale_number_of_pipe_lines_65, t0.current_step_flow AS current_step_flow_66, t0.current_step_step AS current_step_step_67, t0.drain_drainage_capability_input_type AS drain_drainage_capability_input_type_68, t0.drain_drainage_capability_original_value AS drain_drainage_capability_original_value_69, t0.drain_drainage_capability_converted_value AS drain_drainage_capability_converted_value_70, t0.trench_drainage_capability_input_type AS trench_drainage_capability_input_type_71, t0.trench_drainage_capability_original_value AS trench_drainage_capability_original_value_72, t0.trench_drainage_capability_converted_value AS trench_drainage_capability_converted_value_73, t0.unscaled_length_length AS unscaled_length_length_74, t0.unscaled_length_rain_amount_in_millimeters AS unscaled_length_rain_amount_in_millimeters_75, t0.unscaled_length_rain_amount_in_liters_per_second_per_hectare AS unscaled_length_rain_amount_in_liters_per_second_per_hectare_76, t0.unscaled_length_rain_duration AS unscaled_length_rain_duration_77, t0.rigoplan_object_id AS rigoplan_object_id_78, t79.id AS id_80, t79.created_at AS created_at_81, t79.updated_at AS updated_at_82, t79.comment AS comment_83, t79.object_variation_id AS object_variation_id_84, t85.id AS id_86, t85.protection_requirement AS protection_requirement_87, t85.rain_duration AS rain_duration_88, t85.average_terrain_inclination AS average_terrain_inclination_89, t85.max_discharge_at_complete_fill_up AS max_discharge_at_complete_fill_up_90, t85.volume AS volume_91, t85.gross_volume AS gross_volume_92, t85.net_volume AS net_volume_93, t85.drainage_system_type AS drainage_system_type_94, t85.additional_overflow_volume AS additional_overflow_volume_95, t85.consider_larger_drainage_area AS consider_larger_drainage_area_96, t85.ditch_dimensions_length AS ditch_dimensions_length_97, t85.ditch_dimensions_width AS ditch_dimensions_width_98, t85.ditch_dimensions_height AS ditch_dimensions_height_99, t85.ditch_dimensions_adjusted_length AS ditch_dimensions_adjusted_length_100, t85.ditch_dimensions_adjusted_width AS ditch_dimensions_adjusted_width_101, t85.ditch_dimensions_temporary_volume AS ditch_dimensions_temporary_volume_102, t85.trench_dimensions_length AS trench_dimensions_length_103, t85.trench_dimensions_width AS trench_dimensions_width_104, t85.trench_dimensions_depth AS trench_dimensions_depth_105, t85.trench_dimensions_angle_of_repose AS trench_dimensions_angle_of_repose_106, t85.allowed_flooding_frequency_id AS allowed_flooding_frequency_id_107, t85.object_variation_id AS object_variation_id_108, t0.parent_id AS parent_id_109, t110.id AS id_111, t110.drain_input_type AS drain_input_type_112, t110.drain_original_value AS drain_original_value_113, t110.drain_converted_value AS drain_converted_value_114, t110.drain_correction_factor_fort AS drain_correction_factor_fort_115, t110.drain_correction_factor_fmethod AS drain_correction_factor_fmethod_116, t110.drain_correction_factor_fmethod_type AS drain_correction_factor_fmethod_type_117, t110.trench_input_type AS trench_input_type_118, t110.trench_original_value AS trench_original_value_119, t110.trench_converted_value AS trench_converted_value_120, t110.trench_correction_factor_fmethod AS trench_correction_factor_fmethod_121, t110.trench_correction_factor_fort AS trench_correction_factor_fort_122, t110.trench_correction_factor_fmethod_type AS trench_correction_factor_fmethod_type_123, t110.object_variation_id AS object_variation_id_124, t0.water_type_id AS water_type_id_125, t126.id AS id_127, t126.created_at AS created_at_128, t126.updated_at AS updated_at_129, t126.width AS width_130, t126.height AS height_131, t126.variation_id AS variation_id_132, t0.last_modified_by AS last_modified_by_133, t0.creator_id AS creator_id_134, t135.id AS id_136, t135.cap_amount AS cap_amount_137, t135.cap_type AS cap_type_138, t135.date_created AS date_created_139, t135.date_updated AS date_updated_140, t135.object_variation_id AS object_variation_id_141, t142.id AS id_143, t142.shaft_type AS shaft_type_144, t142.shaft_amount AS shaft_amount_145, t142.frontal_shaft_amount AS frontal_shaft_amount_146, t142.date_created AS date_created_147, t142.date_updated AS date_updated_148, t142.object_variation_id AS object_variation_id_149 FROM object_variation t0 LEFT JOIN material_list t79 ON t79.object_variation_id = t0.id LEFT JOIN proof_of_overflow t85 ON t85.object_variation_id = t0.id LEFT JOIN drainage_capability_dwa_a138_part1 t110 ON t110.object_variation_id = t0.id LEFT JOIN grid t126 ON t126.variation_id = t0.id LEFT JOIN discharge_control_check_cap t135 ON t135.object_variation_id = t0.id LEFT JOIN overflow_shaft t142 ON t142.object_variation_id = t0.id WHERE t0.parent_id = ?
Parameters: 
[
  15656
]
View formatted query    View runnable query    Explain query
5 0.79 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.date_deleted AS date_deleted_6, t0.status AS status_7, t0.calculation_method AS calculation_method_8, t0.is_quick_and_easy AS is_quick_and_easy_9, t0.mwod_base_calculation_option AS mwod_base_calculation_option_10, t0.mwod_dimension_optimization_option AS mwod_dimension_optimization_option_11, t0.mwod_system_type_option AS mwod_system_type_option_12, t0.mwod_infiltration_system_option AS mwod_infiltration_system_option_13, t0.swd_system_option AS swd_system_option_14, t0.mwod_water_storage_option AS mwod_water_storage_option_15, t0.block_type_option AS block_type_option_16, t0.mwod_net_volume AS mwod_net_volume_17, t0.mwod_gross_volume AS mwod_gross_volume_18, t0.mwod_vsp AS mwod_vsp_19, t0.control_shaft_type_option AS control_shaft_type_option_20, t0.pipe_swale_type_option AS pipe_swale_type_option_21, t0.total_number_of_control_shafts AS total_number_of_control_shafts_22, t0.pre_stormwater_treatment_total_number_of_control_shafts AS pre_stormwater_treatment_total_number_of_control_shafts_23, t0.number_of_frontal_control_shafts AS number_of_frontal_control_shafts_24, t0.pre_stormwater_treatment_number_of_frontal_control_shafts AS pre_stormwater_treatment_number_of_frontal_control_shafts_25, t0.number_of_trench_control_shafts AS number_of_trench_control_shafts_26, t0.switched_to_stormwater_treatment_flow AS switched_to_stormwater_treatment_flow_27, t0.switched_to_discharge_control_flow AS switched_to_discharge_control_flow_28, t0.switched_to_proof_of_overflow AS switched_to_proof_of_overflow_29, t0.rain_data AS rain_data_30, t0.expert_mode_dimensioning_type AS expert_mode_dimensioning_type_31, t0.rain_data_type AS rain_data_type_32, t0.stormwater_infiltration_workflow_option_type AS stormwater_infiltration_workflow_option_type_33, t0.stormwater_infiltration_workflow_option_value AS stormwater_infiltration_workflow_option_value_34, t0.stormwater_detention_workflow_option AS stormwater_detention_workflow_option_35, t0.stormwater_treatment_workflow_option AS stormwater_treatment_workflow_option_36, t0.rain_recurring_interval AS rain_recurring_interval_37, t0.trench_rain_recurring_interval AS trench_rain_recurring_interval_38, t0.additional_factor AS additional_factor_39, t0.trench_additional_factor AS trench_additional_factor_40, t0.flow_duration AS flow_duration_41, t0.overrun_frequency AS overrun_frequency_42, t0.security_coefficient AS security_coefficient_43, t0.additional_water_into_drench AS additional_water_into_drench_44, t0.trench_additional_water_into_drench AS trench_additional_water_into_drench_45, t0.permeable_sides AS permeable_sides_46, t0.drain_correction_factor AS drain_correction_factor_47, t0.drain_correction_factor_type AS drain_correction_factor_type_48, t0.trench_correction_factor AS trench_correction_factor_49, t0.trench_correction_factor_type AS trench_correction_factor_type_50, t0.original_length AS original_length_51, t0.expert_workflow AS expert_workflow_52, t0.is_alternative_name AS is_alternative_name_53, t0.ditch_dimensions_length AS ditch_dimensions_length_54, t0.ditch_dimensions_width AS ditch_dimensions_width_55, t0.ditch_dimensions_height AS ditch_dimensions_height_56, t0.ditch_dimensions_adjusted_length AS ditch_dimensions_adjusted_length_57, t0.ditch_dimensions_adjusted_width AS ditch_dimensions_adjusted_width_58, t0.ditch_dimensions_temporary_volume AS ditch_dimensions_temporary_volume_59, t0.trench_dimensions_length AS trench_dimensions_length_60, t0.trench_dimensions_width AS trench_dimensions_width_61, t0.trench_dimensions_depth AS trench_dimensions_depth_62, t0.trench_dimensions_angle_of_repose AS trench_dimensions_angle_of_repose_63, t0.pipe_swale_gravel_storage_coefficient AS pipe_swale_gravel_storage_coefficient_64, t0.pipe_swale_number_of_pipe_lines AS pipe_swale_number_of_pipe_lines_65, t0.current_step_flow AS current_step_flow_66, t0.current_step_step AS current_step_step_67, t0.drain_drainage_capability_input_type AS drain_drainage_capability_input_type_68, t0.drain_drainage_capability_original_value AS drain_drainage_capability_original_value_69, t0.drain_drainage_capability_converted_value AS drain_drainage_capability_converted_value_70, t0.trench_drainage_capability_input_type AS trench_drainage_capability_input_type_71, t0.trench_drainage_capability_original_value AS trench_drainage_capability_original_value_72, t0.trench_drainage_capability_converted_value AS trench_drainage_capability_converted_value_73, t0.unscaled_length_length AS unscaled_length_length_74, t0.unscaled_length_rain_amount_in_millimeters AS unscaled_length_rain_amount_in_millimeters_75, t0.unscaled_length_rain_amount_in_liters_per_second_per_hectare AS unscaled_length_rain_amount_in_liters_per_second_per_hectare_76, t0.unscaled_length_rain_duration AS unscaled_length_rain_duration_77, t0.rigoplan_object_id AS rigoplan_object_id_78, t79.id AS id_80, t79.created_at AS created_at_81, t79.updated_at AS updated_at_82, t79.comment AS comment_83, t79.object_variation_id AS object_variation_id_84, t85.id AS id_86, t85.protection_requirement AS protection_requirement_87, t85.rain_duration AS rain_duration_88, t85.average_terrain_inclination AS average_terrain_inclination_89, t85.max_discharge_at_complete_fill_up AS max_discharge_at_complete_fill_up_90, t85.volume AS volume_91, t85.gross_volume AS gross_volume_92, t85.net_volume AS net_volume_93, t85.drainage_system_type AS drainage_system_type_94, t85.additional_overflow_volume AS additional_overflow_volume_95, t85.consider_larger_drainage_area AS consider_larger_drainage_area_96, t85.ditch_dimensions_length AS ditch_dimensions_length_97, t85.ditch_dimensions_width AS ditch_dimensions_width_98, t85.ditch_dimensions_height AS ditch_dimensions_height_99, t85.ditch_dimensions_adjusted_length AS ditch_dimensions_adjusted_length_100, t85.ditch_dimensions_adjusted_width AS ditch_dimensions_adjusted_width_101, t85.ditch_dimensions_temporary_volume AS ditch_dimensions_temporary_volume_102, t85.trench_dimensions_length AS trench_dimensions_length_103, t85.trench_dimensions_width AS trench_dimensions_width_104, t85.trench_dimensions_depth AS trench_dimensions_depth_105, t85.trench_dimensions_angle_of_repose AS trench_dimensions_angle_of_repose_106, t85.allowed_flooding_frequency_id AS allowed_flooding_frequency_id_107, t85.object_variation_id AS object_variation_id_108, t0.parent_id AS parent_id_109, t110.id AS id_111, t110.drain_input_type AS drain_input_type_112, t110.drain_original_value AS drain_original_value_113, t110.drain_converted_value AS drain_converted_value_114, t110.drain_correction_factor_fort AS drain_correction_factor_fort_115, t110.drain_correction_factor_fmethod AS drain_correction_factor_fmethod_116, t110.drain_correction_factor_fmethod_type AS drain_correction_factor_fmethod_type_117, t110.trench_input_type AS trench_input_type_118, t110.trench_original_value AS trench_original_value_119, t110.trench_converted_value AS trench_converted_value_120, t110.trench_correction_factor_fmethod AS trench_correction_factor_fmethod_121, t110.trench_correction_factor_fort AS trench_correction_factor_fort_122, t110.trench_correction_factor_fmethod_type AS trench_correction_factor_fmethod_type_123, t110.object_variation_id AS object_variation_id_124, t0.water_type_id AS water_type_id_125, t126.id AS id_127, t126.created_at AS created_at_128, t126.updated_at AS updated_at_129, t126.width AS width_130, t126.height AS height_131, t126.variation_id AS variation_id_132, t0.last_modified_by AS last_modified_by_133, t0.creator_id AS creator_id_134, t135.id AS id_136, t135.cap_amount AS cap_amount_137, t135.cap_type AS cap_type_138, t135.date_created AS date_created_139, t135.date_updated AS date_updated_140, t135.object_variation_id AS object_variation_id_141, t142.id AS id_143, t142.shaft_type AS shaft_type_144, t142.shaft_amount AS shaft_amount_145, t142.frontal_shaft_amount AS frontal_shaft_amount_146, t142.date_created AS date_created_147, t142.date_updated AS date_updated_148, t142.object_variation_id AS object_variation_id_149 FROM object_variation t0 LEFT JOIN material_list t79 ON t79.object_variation_id = t0.id LEFT JOIN proof_of_overflow t85 ON t85.object_variation_id = t0.id LEFT JOIN drainage_capability_dwa_a138_part1 t110 ON t110.object_variation_id = t0.id LEFT JOIN grid t126 ON t126.variation_id = t0.id LEFT JOIN discharge_control_check_cap t135 ON t135.object_variation_id = t0.id LEFT JOIN overflow_shaft t142 ON t142.object_variation_id = t0.id WHERE t0.id = ?
Parameters: 
[
  15657
]
View formatted query    View runnable query    Explain query
6 5.78 ms 
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.comment AS comment_3, m1_.id AS id_4, m1_.order_number AS order_number_5, m1_.is_optional AS is_optional_6, m2_.id AS id_7, m2_.abbreviation AS abbreviation_8, m2_.name AS name_9, m2_.order_number AS order_number_10, m3_.id AS id_11, m3_.calculated_quantity AS calculated_quantity_12, m3_.custom_quantity AS custom_quantity_13, m3_.price_per_unit_amount AS price_per_unit_amount_14, m3_.price_per_unit_currency AS price_per_unit_currency_15, m3_.custom_price_per_unit_amount AS custom_price_per_unit_amount_16, m3_.custom_price_per_unit_currency AS custom_price_per_unit_currency_17, m3_.date_deleted AS date_deleted_18, m3_.is_optional AS is_optional_19, m3_.is_changed_price AS is_changed_price_20, m3_.is_alternate_product AS is_alternate_product_21, p4_.id AS id_22, p4_.sap_number AS sap_number_23, p4_.rigoplan_sap AS rigoplan_sap_24, p4_.number AS number_25, p4_.sorting_number AS sorting_number_26, p4_.internal_name AS internal_name_27, p4_.short_description AS short_description_28, p4_.long_description AS long_description_29, p4_.unit AS unit_30, p4_.ph_number AS ph_number_31, p4_.ph_name AS ph_name_32, a5_.id AS id_33, a5_.abbreviation AS abbreviation_34, a5_.name AS name_35, p6_.id AS id_36, p6_.sap_number AS sap_number_37, p6_.rigoplan_sap AS rigoplan_sap_38, p6_.number AS number_39, p6_.sorting_number AS sorting_number_40, p6_.internal_name AS internal_name_41, p6_.short_description AS short_description_42, p6_.long_description AS long_description_43, p6_.unit AS unit_44, p6_.ph_number AS ph_number_45, p6_.ph_name AS ph_name_46, m0_.object_variation_id AS object_variation_id_47, m1_.material_list_id AS material_list_id_48, m1_.material_list_product_group_id AS material_list_product_group_id_49, m1_.parent_id AS parent_id_50, m3_.product_id AS product_id_51, m3_.material_list_item_id AS material_list_item_id_52, p4_.alternative_product_group_id AS alternative_product_group_id_53, p6_.alternative_product_group_id AS alternative_product_group_id_54 FROM material_list m0_ LEFT JOIN material_list_item m1_ ON m0_.id = m1_.material_list_id LEFT JOIN material_list_product_group m2_ ON m1_.material_list_product_group_id = m2_.id LEFT JOIN material_list_product m3_ ON m1_.id = m3_.material_list_item_id AND (m3_.date_deleted IS NULL) LEFT JOIN product p4_ ON m3_.product_id = p4_.id LEFT JOIN alternative_product_group a5_ ON p4_.alternative_product_group_id = a5_.id LEFT JOIN product p6_ ON a5_.id = p6_.alternative_product_group_id WHERE m0_.object_variation_id = ? ORDER BY m2_.order_number ASC, m1_.order_number ASC, ISNULL(p4_.sorting_number) ASC, p4_.sorting_number ASC, p4_.number ASC
Parameters: 
[
  15657
]
View formatted query    View runnable query    Explain query
7 0.66 ms 
SELECT m0_.id AS id_0, m0_.order_number AS order_number_1, m0_.is_optional AS is_optional_2, m1_.id AS id_3, m1_.abbreviation AS abbreviation_4, m1_.name AS name_5, m1_.order_number AS order_number_6, m2_.id AS id_7, m2_.calculated_quantity AS calculated_quantity_8, m2_.custom_quantity AS custom_quantity_9, m2_.price_per_unit_amount AS price_per_unit_amount_10, m2_.price_per_unit_currency AS price_per_unit_currency_11, m2_.custom_price_per_unit_amount AS custom_price_per_unit_amount_12, m2_.custom_price_per_unit_currency AS custom_price_per_unit_currency_13, m2_.date_deleted AS date_deleted_14, m2_.is_optional AS is_optional_15, m2_.is_changed_price AS is_changed_price_16, m2_.is_alternate_product AS is_alternate_product_17, p3_.id AS id_18, p3_.sap_number AS sap_number_19, p3_.rigoplan_sap AS rigoplan_sap_20, p3_.number AS number_21, p3_.sorting_number AS sorting_number_22, p3_.internal_name AS internal_name_23, p3_.short_description AS short_description_24, p3_.long_description AS long_description_25, p3_.unit AS unit_26, p3_.ph_number AS ph_number_27, p3_.ph_name AS ph_name_28, a4_.id AS id_29, a4_.abbreviation AS abbreviation_30, a4_.name AS name_31, p5_.id AS id_32, p5_.sap_number AS sap_number_33, p5_.rigoplan_sap AS rigoplan_sap_34, p5_.number AS number_35, p5_.sorting_number AS sorting_number_36, p5_.internal_name AS internal_name_37, p5_.short_description AS short_description_38, p5_.long_description AS long_description_39, p5_.unit AS unit_40, p5_.ph_number AS ph_number_41, p5_.ph_name AS ph_name_42, m0_.material_list_id AS material_list_id_43, m0_.material_list_product_group_id AS material_list_product_group_id_44, m0_.parent_id AS parent_id_45, m2_.product_id AS product_id_46, m2_.material_list_item_id AS material_list_item_id_47, p3_.alternative_product_group_id AS alternative_product_group_id_48, p5_.alternative_product_group_id AS alternative_product_group_id_49 FROM material_list_item m0_ LEFT JOIN material_list_product_group m1_ ON m0_.material_list_product_group_id = m1_.id LEFT JOIN material_list_product m2_ ON m0_.id = m2_.material_list_item_id AND (m2_.date_deleted IS NULL) LEFT JOIN product p3_ ON m2_.product_id = p3_.id LEFT JOIN alternative_product_group a4_ ON p3_.alternative_product_group_id = a4_.id LEFT JOIN product p5_ ON a4_.id = p5_.alternative_product_group_id WHERE m0_.parent_id = ? ORDER BY m1_.order_number ASC, m0_.order_number ASC, ISNULL(p3_.sorting_number) ASC, p3_.sorting_number ASC, p3_.number ASC
Parameters: 
[
  4699
]
View formatted query    View runnable query    Explain query
8 0.29 ms 
SELECT t0.id AS id_1, t0.street_name_and_number AS street_name_and_number_2, t0.postal_code AS postal_code_3, t0.city AS city_4, t0.email AS email_5, t0.country_id AS country_id_6 FROM address t0 WHERE t0.id = ?
Parameters: 
[
  6179
]
View formatted query    View runnable query    Explain query
9 0.28 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.has_related_cities AS has_related_cities_4, t0.short_abbreviation AS short_abbreviation_5, t0.currency AS currency_6 FROM country t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
10 0.31 ms 
SELECT t0.id AS id_1, t0.shaft_type AS shaft_type_2, t0.max_allowed_flow AS max_allowed_flow_3, t0.average_flow AS average_flow_4, t0.max_retainable_height AS max_retainable_height_5, t0.frontal_placement AS frontal_placement_6, t0.quadro_overflow AS quadro_overflow_7, t0.frontal_quadro_overflow_placement AS frontal_quadro_overflow_placement_8, t0.throttle_type AS throttle_type_9, t0.outlet_dimension AS outlet_dimension_10, t0.object_variation_id AS object_variation_id_11 FROM discharge_control t0 WHERE t0.object_variation_id = ?
Parameters: 
[
  15657
]
View formatted query    View runnable query    Explain query

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
ProductBundle\Entity\Product 15
ObjectBundle\Entity\MaterialListProduct 12
ObjectBundle\Entity\ObjectVariation 2
UserBundle\Entity\RegisteredUser 1
UserBundle\Entity\Company 1
ObjectBundle\Entity\RigoplanObject 1
AppBundle\Entity\Address 1
ObjectBundle\Entity\MaterialList 1
GPMBundle\Entity\Grid 1
ObjectBundle\Entity\OverflowShaft 1
ObjectBundle\Entity\MaterialListItem 1
ObjectBundle\Entity\MaterialListProductGroup 1
ObjectBundle\Entity\AlternativeProductGroup 1
AppBundle\Entity\Country 1

Entities Mapping

Class Mapping errors
UserBundle\ValueObject\ForgotPasswordToken No errors.
UserBundle\Entity\RegisteredUser No errors.
UserBundle\Entity\AnonymousExternalUser No errors.
UserBundle\Entity\ExternalUser No errors.
UserBundle\Entity\InternalUser No errors.
UserBundle\Entity\AdminUser No errors.
UserBundle\Entity\Company No errors.
ObjectBundle\Entity\RigoplanObject No errors.
ObjectBundle\ValueObject\DitchDimensions No errors.
ObjectBundle\ValueObject\TrenchDimensions No errors.
ObjectBundle\ValueObject\PipeSwale No errors.
ObjectBundle\ValueObject\FlowStep No errors.
ObjectBundle\ValueObject\DrainageCapability No errors.
ObjectBundle\ValueObject\UnscaledLength No errors.
ObjectBundle\Entity\ObjectVariation No errors.
ObjectBundle\Entity\MaterialList No errors.
ObjectBundle\Entity\ProofOfOverflow No errors.
ObjectBundle\Entity\LocationAllowedFloodingFrequency No errors.
ObjectBundle\Entity\DrainageCapabilityDwaA138Part1 No errors.
ObjectBundle\Entity\WaterType No errors.
GPMBundle\Entity\Grid No errors.
ObjectBundle\Entity\DischargeControlCheckCap No errors.
ObjectBundle\Entity\OverflowShaft No errors.
ObjectBundle\Entity\VariationFlow No errors.
ObjectBundle\Entity\DischargeControl No errors.
ObjectBundle\Entity\Area No errors.
ObjectBundle\Entity\StormwaterTreatment No errors.
ProductBundle\Entity\Product No errors.
ObjectBundle\Entity\MaterialListProductGroup No errors.
GPMBundle\Grid\Position No errors.
GPMBundle\Entity\GraphicalElement No errors.
AppBundle\Entity\Address No errors.
AppBundle\Entity\ContactPerson No errors.
ObjectBundle\Entity\MaterialListItem No errors.
GPMBundle\Entity\GpmHistoryStep No errors.
ObjectBundle\Entity\MaterialListProduct No errors.
ObjectBundle\Entity\AlternativeProductGroup No errors.
ProductBundle\Entity\ProductUnitPrice No errors.
AppBundle\Entity\Country No errors.