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
a8b972

Query Metrics

65 Database Queries
21 Different statements
49.82 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.17 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.80 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.56 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 1.21 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 1.03 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 0.37 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
7 0.29 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
8 1.29 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594302"
]
View formatted query    View runnable query    Explain query
9 0.64 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  640
]
View formatted query    View runnable query    Explain query
10 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: 
[
  3
]
View formatted query    View runnable query    Explain query
11 0.27 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: 
[
  58
]
View formatted query    View runnable query    Explain query
12 0.22 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: 
[
  5
]
View formatted query    View runnable query    Explain query
13 0.23 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: 
[
  10
]
View formatted query    View runnable query    Explain query
14 0.65 ms 
SELECT m0_.id AS id_0, m0_.abbreviation AS abbreviation_1, COALESCE(t1_.content, m0_.name) AS name_2, m0_.order_number AS order_number_3 FROM material_list_product_group m0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'name' AND t1_.object_class = 'ObjectBundle\\Entity\\MaterialListProductGroup' AND t1_.foreign_key = m0_.id WHERE m0_.abbreviation = ?
Parameters: 
[
  "storage_volume"
]
View formatted query    View runnable query    Explain query
15 0.59 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594400"
]
View formatted query    View runnable query    Explain query
16 0.45 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  649
]
View formatted query    View runnable query    Explain query
17 0.56 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594400"
]
View formatted query    View runnable query    Explain query
18 0.52 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594401"
]
View formatted query    View runnable query    Explain query
19 0.33 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  644
]
View formatted query    View runnable query    Explain query
20 0.46 ms 
SELECT t0.id AS id_1, t0.handle AS handle_2, t0.is_grouped_element AS is_grouped_element_3, t0.orientation AS orientation_4, t0.grouped_element_width AS grouped_element_width_5, t0.grouped_element_height AS grouped_element_height_6, t0.graphical_element_class AS graphical_element_class_7, t0.deleted_at AS deleted_at_8, t0.position_x AS position_x_9, t0.position_y AS position_y_10, t0.grid_id AS grid_id_11, t0.parent_id AS parent_id_12, t0.connected_element_id AS connected_element_id_13 FROM graphical_element t0 WHERE t0.grid_id = ?
Parameters: 
[
  2889
]
View formatted query    View runnable query    Explain query
21 0.36 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
22 0.41 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_type AS system_type_3, t0.product_amount AS product_amount_4, t0.sewer_depth AS sewer_depth_5, t0.inlet_outlet_dimensions AS inlet_outlet_dimensions_6, t0.shaft_cover_type AS shaft_cover_type_7, t0.infiltration_area AS infiltration_area_8, t0.transist_value AS transist_value_9, t0.r_crit AS r_crit_10, t0.surface_loading_qa AS surface_loading_qa_11, t0.drain AS drain_12, t0.pool_overflow AS pool_overflow_13, t0.extraneous_water_inflow AS extraneous_water_inflow_14, t0.left_amount AS left_amount_15, t0.right_amount AS right_amount_16, t0.straight_amount AS straight_amount_17, t0.calculation_option AS calculation_option_18, t0.dwa_a138_part1_coefficients AS dwa_a138_part1_coefficients_19, t0.efficiency_nwt AS efficiency_nwt_20, t0.current_step_flow AS current_step_flow_21, t0.current_step_step AS current_step_step_22, t0.inlet_outlet_id AS inlet_outlet_id_23, t0.stormwater_treatment_product_id AS stormwater_treatment_product_id_24, t0.object_variation_id AS object_variation_id_25 FROM stormwater_treatment t0 WHERE t0.object_variation_id = ?
Parameters: 
[
  15657
]
View formatted query    View runnable query    Explain query
23 0.58 ms 
SELECT t0.id AS id_1, t0.action AS action_2, t0.is_current_step AS is_current_step_3, t0.start_orientation AS start_orientation_4, t0.end_orientation AS end_orientation_5, t0.created_at AS created_at_6, t0.is_connected_step AS is_connected_step_7, t0.start_position_x AS start_position_x_8, t0.start_position_y AS start_position_y_9, t0.end_position_x AS end_position_x_10, t0.end_position_y AS end_position_y_11, t0.graphical_element_id AS graphical_element_id_12, t0.grid_id AS grid_id_13, t0.start_connecting_element_id AS start_connecting_element_id_14, t0.end_connecting_element_id AS end_connecting_element_id_15 FROM gpm_history_step t0 WHERE t0.grid_id = ? ORDER BY t0.created_at ASC
Parameters: 
[
  2889
]
View formatted query    View runnable query    Explain query
24 0.74 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594485"
]
View formatted query    View runnable query    Explain query
25 1.68 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  629
]
View formatted query    View runnable query    Explain query
26 6.69 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594486"
]
View formatted query    View runnable query    Explain query
27 0.43 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  630
]
View formatted query    View runnable query    Explain query
28 1.72 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51594425"
]
View formatted query    View runnable query    Explain query
29 0.48 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  590
]
View formatted query    View runnable query    Explain query
30 1.44 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51550551"
]
View formatted query    View runnable query    Explain query
31 0.47 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  136
]
View formatted query    View runnable query    Explain query
32 0.64 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51919505"
]
View formatted query    View runnable query    Explain query
33 0.38 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  375
]
View formatted query    View runnable query    Explain query
34 0.79 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51991095"
]
View formatted query    View runnable query    Explain query
35 0.39 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  388
]
View formatted query    View runnable query    Explain query
36 1.34 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "TXTD0000000000015"
]
View formatted query    View runnable query    Explain query
37 0.38 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  662
]
View formatted query    View runnable query    Explain query
38 0.50 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "TXTD0000000000016"
]
View formatted query    View runnable query    Explain query
39 0.38 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  663
]
View formatted query    View runnable query    Explain query
40 0.92 ms 
SELECT p0_.id AS id_0, p0_.sap_number AS sap_number_1, p0_.rigoplan_sap AS rigoplan_sap_2, p0_.number AS number_3, p0_.sorting_number AS sorting_number_4, COALESCE(t1_.content, p0_.internal_name) AS internal_name_5, COALESCE(t2_.content, p0_.short_description) AS short_description_6, COALESCE(t3_.content, p0_.long_description) AS long_description_7, p0_.unit AS unit_8, p0_.ph_number AS ph_number_9, p0_.ph_name AS ph_name_10, p0_.alternative_product_group_id AS alternative_product_group_id_11 FROM product p0_ INNER JOIN product_unit_price p4_ ON p0_.id = p4_.product_id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'internalName' AND t1_.object_class = 'ProductBundle\\Entity\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'de' AND t2_.field = 'shortDescription' AND t2_.object_class = 'ProductBundle\\Entity\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'de' AND t3_.field = 'longDescription' AND t3_.object_class = 'ProductBundle\\Entity\\Product' AND t3_.foreign_key = p0_.id WHERE p0_.number = ?
Parameters: 
[
  "51695002"
]
View formatted query    View runnable query    Explain query
41 0.34 ms 
SELECT t0.id AS id_1, t0.quantity_range_min AS quantity_range_min_2, t0.quantity_range_max AS quantity_range_max_3, t0.price_amount AS price_amount_4, t0.price_currency AS price_currency_5, t0.country_id AS country_id_6, t0.product_id AS product_id_7 FROM product_unit_price t0 WHERE t0.product_id = ?
Parameters: 
[
  352
]
View formatted query    View runnable query    Explain query
42 0.20 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
43 1.35 ms 
INSERT INTO material_list (created_at, updated_at, comment, object_variation_id) VALUES (?, ?, ?, ?)
Parameters: 
[
  "2026-03-02 13:27:36"
  "2026-03-02 13:27:36"
  null
  15657
]
View formatted query    View runnable query    Explain query
44 0.56 ms 
INSERT INTO material_list_item (order_number, is_optional, material_list_id, material_list_product_group_id, parent_id) VALUES (?, ?, ?, ?, ?)
Parameters: 
[
  null
  null
  2573
  4
  null
]
View formatted query    View runnable query    Explain query
45 0.45 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  142
  null
  0.86
  "EUR"
  null
  null
  null
  0
  0
  0
  640
  4702
]
View formatted query    View runnable query    Explain query
46 0.91 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  180
  null
  34.8
  "EUR"
  null
  null
  null
  0
  0
  0
  649
  4702
]
View formatted query    View runnable query    Explain query
47 0.42 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  36
  null
  15.03
  "EUR"
  null
  null
  null
  0
  0
  0
  644
  4702
]
View formatted query    View runnable query    Explain query
48 0.31 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  52
  null
  9.54
  "EUR"
  null
  null
  null
  0
  0
  0
  629
  4702
]
View formatted query    View runnable query    Explain query
49 0.45 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  26
  null
  5.85
  "EUR"
  null
  null
  null
  0
  0
  0
  630
  4702
]
View formatted query    View runnable query    Explain query
50 0.24 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  null
  481.5
  "EUR"
  null
  null
  null
  0
  0
  0
  590
  4702
]
View formatted query    View runnable query    Explain query
51 0.41 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  null
  108.9
  "EUR"
  null
  null
  null
  0
  0
  0
  136
  4702
]
View formatted query    View runnable query    Explain query
52 0.56 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  null
  33.08
  "EUR"
  null
  null
  null
  0
  0
  0
  375
  4702
]
View formatted query    View runnable query    Explain query
53 0.41 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  null
  94.32
  "EUR"
  null
  null
  null
  0
  0
  0
  388
  4702
]
View formatted query    View runnable query    Explain query
54 0.31 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  null
  0.0
  "EUR"
  null
  null
  null
  0
  0
  0
  662
  4702
]
View formatted query    View runnable query    Explain query
55 0.23 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  6
  null
  0.0
  "EUR"
  null
  null
  null
  0
  0
  0
  663
  4702
]
View formatted query    View runnable query    Explain query
56 0.49 ms 
INSERT INTO material_list_product (calculated_quantity, custom_quantity, price_per_unit_amount, price_per_unit_currency, custom_price_per_unit_amount, custom_price_per_unit_currency, date_deleted, is_optional, is_changed_price, is_alternate_product, product_id, material_list_item_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  119
  null
  2.21
  "EUR"
  null
  null
  null
  0
  0
  0
  352
  4702
]
View formatted query    View runnable query    Explain query
57 1.10 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
58 1.77 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
59 2.92 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: 
[
  4702
]
View formatted query    View runnable query    Explain query
60 1.05 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
61 0.37 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
62 0.37 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.id = ?
Parameters: 
[
  581
]
View formatted query    View runnable query    Explain query
63 0.26 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
64 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
65 0.43 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
ObjectBundle\Entity\MaterialList 1
ObjectBundle\Entity\MaterialListItem 1
ObjectBundle\Entity\MaterialListProductGroup 1
ObjectBundle\Entity\AlternativeProductGroup 1
ObjectBundle\Entity\RigoplanObject 1
GPMBundle\Entity\Grid 1
AppBundle\Entity\Address 1
UserBundle\Entity\RegisteredUser 1
UserBundle\Entity\Company 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.
GPMBundle\Entity\GpmHistoryStep No errors.
AppBundle\Entity\Country No errors.
ProductBundle\Entity\ProductUnitPrice No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
ObjectBundle\Entity\AlternativeProductGroup No errors.
ObjectBundle\Entity\InletOutlet No errors.
ObjectBundle\Entity\StormwaterTreatmentProduct No errors.
ObjectBundle\Entity\MaterialListItem No errors.
ObjectBundle\Entity\MaterialListProduct No errors.