Query Metrics
65
Database Queries
21
Different statements
49.82 ms
Query time
0
Invalid entities
39
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
17.75 ms (35.62%) |
13 |
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"
]
|
|
6.36 ms (12.77%) |
12 |
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
]
|
|
5.17 ms (10.38%) |
12 |
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 ] |
|
3.88 ms (7.79%) |
3 |
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"
]
|
|
2.92 ms (5.87%) |
1 |
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
]
|
|
1.77 ms (3.55%) |
1 |
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
]
|
|
1.56 ms (3.14%) |
6 |
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
]
|
|
1.35 ms (2.71%) |
1 |
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 ] |
|
1.21 ms (2.44%) |
1 |
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
]
|
|
1.17 ms (2.34%) |
1 |
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"
]
|
|
1.10 ms (2.20%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.93 ms (1.87%) |
2 |
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
]
|
|
0.80 ms (1.60%) |
2 |
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
]
|
|
0.65 ms (1.30%) |
1 |
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"
]
|
|
0.62 ms (1.25%) |
2 |
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
]
|
|
0.58 ms (1.16%) |
1 |
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
]
|
|
0.56 ms (1.12%) |
1 |
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 ] |
|
0.46 ms (0.93%) |
1 |
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
]
|
|
0.41 ms (0.82%) |
1 |
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
]
|
|
0.37 ms (0.73%) |
1 |
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
]
|
|
0.20 ms (0.39%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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 |