Symfony Profiler

SELECT
  t0_._p_id AS _p_id_0,
  t0_._p_name AS _p_name_1,
  t0_._p_short_url AS _p_short_url_2,
  t0_._o_name AS _o_name_3,
  t0_._p_desc AS _p_desc_4,
  t0_._p_logo AS _p_logo_5,
  t0_._p_extern_id AS _p_extern_id_6,
  t0_._p_plis_id AS _p_plis_id_7,
  t0_._p_closed AS _p_closed_8,
  t0_._p_deleted AS _p_deleted_9,
  t0_._p_master AS _p_master_10,
  t0_.master_template AS master_template_11,
  t0_._p_external_name AS _p_external_name_12,
  t0_._p_external_desc AS _p_external_desc_13,
  t0_._p_public_participation AS _p_public_participation_14,
  t0_._p_public_participation_contact AS _p_public_participation_contact_15,
  t0_._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_16,
  t0_._p_location_name AS _p_location_name_17,
  t0_._p_location_postcode AS _p_location_postcode_18,
  t0_._p_municipal_code AS _p_municipal_code_19,
  t0_._p_ars AS _p_ars_20,
  t0_._p_created_date AS _p_created_date_21,
  t0_._p_closed_date AS _p_closed_date_22,
  t0_._p_deleted_date AS _p_deleted_date_23,
  t0_.agency_main_email_address AS agency_main_email_address_24,
  t0_.extern_id AS extern_id_25,
  t0_._o_id AS _o_id_26,
  t0_.phase_id AS phase_id_27,
  t0_.public_participation_phase_id AS public_participation_phase_id_28,
  t0_.customer AS customer_29,
  t0_.procedure_type_id AS procedure_type_id_30,
  t0_.statement_form_definition_id AS statement_form_definition_id_31,
  t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_32,
  t0_.procedure_ui_definition_id AS procedure_ui_definition_id_33,
  t0_.current_slug_id AS current_slug_id_34
FROM
  _procedure t0_
  INNER JOIN procedure_slug p2_ ON t0_._p_id = p2_.p_id
  INNER JOIN slug s1_ ON s1_.id = p2_.s_id
WHERE
  s1_.name = ?

SELECT t0_._p_id AS _p_id_0, t0_._p_name AS _p_name_1, t0_._p_short_url AS _p_short_url_2, t0_._o_name AS _o_name_3, t0_._p_desc AS _p_desc_4, t0_._p_logo AS _p_logo_5, t0_._p_extern_id AS _p_extern_id_6, t0_._p_plis_id AS _p_plis_id_7, t0_._p_closed AS _p_closed_8, t0_._p_deleted AS _p_deleted_9, t0_._p_master AS _p_master_10, t0_.master_template AS master_template_11, t0_._p_external_name AS _p_external_name_12, t0_._p_external_desc AS _p_external_desc_13, t0_._p_public_participation AS _p_public_participation_14, t0_._p_public_participation_contact AS _p_public_participation_contact_15, t0_._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_16, t0_._p_location_name AS _p_location_name_17, t0_._p_location_postcode AS _p_location_postcode_18, t0_._p_municipal_code AS _p_municipal_code_19, t0_._p_ars AS _p_ars_20, t0_._p_created_date AS _p_created_date_21, t0_._p_closed_date AS _p_closed_date_22, t0_._p_deleted_date AS _p_deleted_date_23, t0_.agency_main_email_address AS agency_main_email_address_24, t0_.extern_id AS extern_id_25, t0_._o_id AS _o_id_26, t0_.phase_id AS phase_id_27, t0_.public_participation_phase_id AS public_participation_phase_id_28, t0_.customer AS customer_29, t0_.procedure_type_id AS procedure_type_id_30, t0_.statement_form_definition_id AS statement_form_definition_id_31, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_32, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_33, t0_.current_slug_id AS current_slug_id_34 FROM _procedure t0_ INNER JOIN procedure_slug p2_ ON t0_._p_id = p2_.p_id INNER JOIN slug s1_ ON s1_.id = p2_.s_id WHERE s1_.name = '505ee4f0-32c0-4f50-a7b1-3ba42d3935db';

SELECT
  t0._ps_id AS _ps_id_1,
  t0._ps_map_extent AS _ps_map_extent_2,
  t0._ps_start_scale AS _ps_start_scale_3,
  t0._ps_available_scale AS _ps_available_scale_4,
  t0._ps_bounding_box AS _ps_bounding_box_5,
  t0._ps_information_url AS _ps_information_url_6,
  t0._ps_default_layer AS _ps_default_layer_7,
  t0._ps_territory AS _ps_territory_8,
  t0._ps_coordinate AS _ps_coordinate_9,
  t0._ps_plan_enable AS _ps_plan_enable_10,
  t0.allow_anonymous_statements AS allow_anonymous_statements_11,
  t0.expand_procedure_description AS expand_procedure_description_12,
  t0._ps_plan_text AS _ps_plan_text_13,
  t0._ps_plan_pdf AS _ps_plan_pdf_14,
  t0._ps_plan_para1_pdf AS _ps_plan_para1_pdf_15,
  t0._ps_plan_para2_pdf AS _ps_plan_para2_pdf_16,
  t0._ps_plan_draw_text AS _ps_plan_draw_text_17,
  t0._ps_plan_draw_pdf AS _ps_plan_draw_pdf_18,
  t0._ps_email_title AS _ps_email_title_19,
  t0._ps_email_text AS _ps_email_text_20,
  t0._ps_email_cc AS _ps_email_cc_21,
  t0._ps_links AS _ps_links_22,
  t0._ps_pictogram AS _ps_pictogram_23,
  t0._ps_pictogram_copyright AS _ps_pictogram_copyright_24,
  t0._ps_pictogram_alt_text AS _ps_pictogram_alt_text_25,
  t0._ps_send_mails_to_counties AS _ps_send_mails_to_counties_26,
  t0.planning_area AS planning_area_27,
  t0.scales AS scales_28,
  t0.legal_notice AS legal_notice_29,
  t0.copyright AS copyright_30,
  t0.map_hint AS map_hint_31,
  t0._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_32,
  t0._p_id AS _p_id_33
FROM
  _procedure_settings t0
WHERE
  t0._p_id = ?

SELECT t0._ps_id AS _ps_id_1, t0._ps_map_extent AS _ps_map_extent_2, t0._ps_start_scale AS _ps_start_scale_3, t0._ps_available_scale AS _ps_available_scale_4, t0._ps_bounding_box AS _ps_bounding_box_5, t0._ps_information_url AS _ps_information_url_6, t0._ps_default_layer AS _ps_default_layer_7, t0._ps_territory AS _ps_territory_8, t0._ps_coordinate AS _ps_coordinate_9, t0._ps_plan_enable AS _ps_plan_enable_10, t0.allow_anonymous_statements AS allow_anonymous_statements_11, t0.expand_procedure_description AS expand_procedure_description_12, t0._ps_plan_text AS _ps_plan_text_13, t0._ps_plan_pdf AS _ps_plan_pdf_14, t0._ps_plan_para1_pdf AS _ps_plan_para1_pdf_15, t0._ps_plan_para2_pdf AS _ps_plan_para2_pdf_16, t0._ps_plan_draw_text AS _ps_plan_draw_text_17, t0._ps_plan_draw_pdf AS _ps_plan_draw_pdf_18, t0._ps_email_title AS _ps_email_title_19, t0._ps_email_text AS _ps_email_text_20, t0._ps_email_cc AS _ps_email_cc_21, t0._ps_links AS _ps_links_22, t0._ps_pictogram AS _ps_pictogram_23, t0._ps_pictogram_copyright AS _ps_pictogram_copyright_24, t0._ps_pictogram_alt_text AS _ps_pictogram_alt_text_25, t0._ps_send_mails_to_counties AS _ps_send_mails_to_counties_26, t0.planning_area AS planning_area_27, t0.scales AS scales_28, t0.legal_notice AS legal_notice_29, t0.copyright AS copyright_30, t0.map_hint AS map_hint_31, t0._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_32, t0._p_id AS _p_id_33 FROM _procedure_settings t0 WHERE t0._p_id = '505ee4f0-32c0-4f50-a7b1-3ba42d3935db';

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.creation_date AS creation_date_4,
  t0.modification_date AS modification_date_5,
  t0.designated_phase AS designated_phase_6,
  t0.designated_switch_date AS designated_switch_date_7,
  t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8,
  t0.designated_end_date AS designated_end_date_9,
  t0.iteration AS iteration_10,
  t0.step AS step_11,
  t0.phase_key AS phase_key_12,
  t0.designated_phase_change_user_id AS designated_phase_change_user_id_13
FROM
  procedure_phase t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.creation_date AS creation_date_4, t0.modification_date AS modification_date_5, t0.designated_phase AS designated_phase_6, t0.designated_switch_date AS designated_switch_date_7, t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8, t0.designated_end_date AS designated_end_date_9, t0.iteration AS iteration_10, t0.step AS step_11, t0.phase_key AS phase_key_12, t0.designated_phase_change_user_id AS designated_phase_change_user_id_13 FROM procedure_phase t0 WHERE t0.id = 'e1a2b3e6-cd77-3e0a-9a10-be6f5a0fb6f9';

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.creation_date AS creation_date_4,
  t0.modification_date AS modification_date_5,
  t0.designated_phase AS designated_phase_6,
  t0.designated_switch_date AS designated_switch_date_7,
  t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8,
  t0.designated_end_date AS designated_end_date_9,
  t0.iteration AS iteration_10,
  t0.step AS step_11,
  t0.phase_key AS phase_key_12,
  t0.designated_phase_change_user_id AS designated_phase_change_user_id_13
FROM
  procedure_phase t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.creation_date AS creation_date_4, t0.modification_date AS modification_date_5, t0.designated_phase AS designated_phase_6, t0.designated_switch_date AS designated_switch_date_7, t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8, t0.designated_end_date AS designated_end_date_9, t0.iteration AS iteration_10, t0.step AS step_11, t0.phase_key AS phase_key_12, t0.designated_phase_change_user_id AS designated_phase_change_user_id_13 FROM procedure_phase t0 WHERE t0.id = 'e21f1dd7-87cc-3c86-9fd5-62eb2a8269dd';

SELECT
  t0._c_id AS _c_id_1,
  t0.imprint AS imprint_2,
  t0.data_protection AS data_protection_3,
  t0.terms_of_use AS terms_of_use_4,
  t0.xplanning AS xplanning_5,
  t0.map_attribution AS map_attribution_6,
  t0.base_layer_url AS base_layer_url_7,
  t0.base_layer_layers AS base_layer_layers_8,
  t0.accessibility_explanation AS accessibility_explanation_9,
  t0.sign_language_overview_description AS sign_language_overview_description_10,
  t0.simple_language_overview_description AS simple_language_overview_description_11,
  t0._c_name AS _c_name_12,
  t0._c_subdomain AS _c_subdomain_13,
  t0._procedure AS _procedure_14,
  t0.branding_id AS branding_id_15
FROM
  customer t0
WHERE
  t0._c_subdomain = ?
LIMIT
  1

SELECT t0._c_id AS _c_id_1, t0.imprint AS imprint_2, t0.data_protection AS data_protection_3, t0.terms_of_use AS terms_of_use_4, t0.xplanning AS xplanning_5, t0.map_attribution AS map_attribution_6, t0.base_layer_url AS base_layer_url_7, t0.base_layer_layers AS base_layer_layers_8, t0.accessibility_explanation AS accessibility_explanation_9, t0.sign_language_overview_description AS sign_language_overview_description_10, t0.simple_language_overview_description AS simple_language_overview_description_11, t0._c_name AS _c_name_12, t0._c_subdomain AS _c_subdomain_13, t0._procedure AS _procedure_14, t0.branding_id AS branding_id_15 FROM customer t0 WHERE t0._c_subdomain = 'diplanbau-dev-debug-docker' LIMIT 1;

SELECT
  t0_._r_id AS _r_id_0,
  t0_._r_code AS _r_code_1,
  t0_._r_group_code AS _r_group_code_2,
  t0_._r_group_name AS _r_group_name_3
FROM
  _role t0_
WHERE
  t0_._r_code IN (?)

SELECT t0_._r_id AS _r_id_0, t0_._r_code AS _r_code_1, t0_._r_group_code AS _r_group_code_2, t0_._r_group_name AS _r_group_name_3 FROM _role t0_ WHERE t0_._r_code IN ('RGUEST');

SELECT
  t0.id AS id_1,
  t0.permission AS permission_2,
  t0.creation_date AS creation_date_3,
  t0.modification_date AS modification_date_4,
  t0.orga_id AS orga_id_5,
  t0.role_id AS role_id_6,
  t0.customer_id AS customer_id_7
FROM
  access_control t0
WHERE
  t0.role_id IN (?)
  AND t0.orga_id IN (?)
  AND t0.customer_id IN (?)

SELECT t0.id AS id_1, t0.permission AS permission_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.orga_id AS orga_id_5, t0.role_id AS role_id_6, t0.customer_id AS customer_id_7 FROM access_control t0 WHERE t0.role_id IN ('71a2ebbc-0968-11e1-9d8e-1c64a3042bca') AND t0.orga_id IN ('cdec5e4b-3f06-11e4-a6a8-005056ae0004') AND t0.customer_id IN (NULL);

SELECT
  t0.id AS id_1,
  t0.creation_date AS creation_date_2,
  t0.modification_date AS modification_date_3,
  t0.allowed_to_enable_map AS allowed_to_enable_map_4,
  t0.has_priority_area AS has_priority_area_5,
  t0.participation_guest_only AS participation_guest_only_6,
  t0.procedure_id AS procedure_id_7,
  t0.procedure_type_id AS procedure_type_id_8
FROM
  procedure_behavior_definition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.allowed_to_enable_map AS allowed_to_enable_map_4, t0.has_priority_area AS has_priority_area_5, t0.participation_guest_only AS participation_guest_only_6, t0.procedure_id AS procedure_id_7, t0.procedure_type_id AS procedure_type_id_8 FROM procedure_behavior_definition t0 WHERE t0.id = 'aa2c36d2-d935-35df-958c-299319366ff1';

SELECT
  t0._c_id AS _c_id_1,
  t0.imprint AS imprint_2,
  t0.data_protection AS data_protection_3,
  t0.terms_of_use AS terms_of_use_4,
  t0.xplanning AS xplanning_5,
  t0.map_attribution AS map_attribution_6,
  t0.base_layer_url AS base_layer_url_7,
  t0.base_layer_layers AS base_layer_layers_8,
  t0.accessibility_explanation AS accessibility_explanation_9,
  t0.sign_language_overview_description AS sign_language_overview_description_10,
  t0.simple_language_overview_description AS simple_language_overview_description_11,
  t0._c_name AS _c_name_12,
  t0._c_subdomain AS _c_subdomain_13,
  t0._procedure AS _procedure_14,
  t0.branding_id AS branding_id_15
FROM
  customer t0
WHERE
  t0._c_id = ?

SELECT t0._c_id AS _c_id_1, t0.imprint AS imprint_2, t0.data_protection AS data_protection_3, t0.terms_of_use AS terms_of_use_4, t0.xplanning AS xplanning_5, t0.map_attribution AS map_attribution_6, t0.base_layer_url AS base_layer_url_7, t0.base_layer_layers AS base_layer_layers_8, t0.accessibility_explanation AS accessibility_explanation_9, t0.sign_language_overview_description AS sign_language_overview_description_10, t0.simple_language_overview_description AS simple_language_overview_description_11, t0._c_name AS _c_name_12, t0._c_subdomain AS _c_subdomain_13, t0._procedure AS _procedure_14, t0.branding_id AS branding_id_15 FROM customer t0 WHERE t0._c_id = '8e4172c6-ada2-3352-a3ec-f585a3969933';

SELECT
  t0_._o_id AS _o_id_0
FROM
  _procedure t1_
  INNER JOIN _procedure_orga_doctrine t2_ ON t1_._p_id = t2_._p_id
  INNER JOIN _orga t0_ ON t0_._o_id = t2_._o_id
WHERE
  t1_._p_id = ?

SELECT t0_._o_id AS _o_id_0 FROM _procedure t1_ INNER JOIN _procedure_orga_doctrine t2_ ON t1_._p_id = t2_._p_id INNER JOIN _orga t0_ ON t0_._o_id = t2_._o_id WHERE t1_._p_id = '505ee4f0-32c0-4f50-a7b1-3ba42d3935db';

SELECT
  t0_._o_id AS _o_id_0
FROM
  _procedure t1_
  INNER JOIN procedure_planningoffices p2_ ON t1_._p_id = p2_._p_id
  INNER JOIN _orga t0_ ON t0_._o_id = p2_._o_id
WHERE
  t1_._p_id = ?

SELECT t0_._o_id AS _o_id_0 FROM _procedure t1_ INNER JOIN procedure_planningoffices p2_ ON t1_._p_id = p2_._p_id INNER JOIN _orga t0_ ON t0_._o_id = p2_._o_id WHERE t1_._p_id = '505ee4f0-32c0-4f50-a7b1-3ba42d3935db';

SELECT
  t0._p_id AS _p_id_1,
  t0._p_name AS _p_name_2,
  t0._p_short_url AS _p_short_url_3,
  t0._o_name AS _o_name_4,
  t0._p_desc AS _p_desc_5,
  t0._p_logo AS _p_logo_6,
  t0._p_extern_id AS _p_extern_id_7,
  t0._p_plis_id AS _p_plis_id_8,
  t0._p_closed AS _p_closed_9,
  t0._p_deleted AS _p_deleted_10,
  t0._p_master AS _p_master_11,
  t0.master_template AS master_template_12,
  t0._p_external_name AS _p_external_name_13,
  t0._p_external_desc AS _p_external_desc_14,
  t0._p_public_participation AS _p_public_participation_15,
  t0._p_public_participation_contact AS _p_public_participation_contact_16,
  t0._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_17,
  t0._p_location_name AS _p_location_name_18,
  t0._p_location_postcode AS _p_location_postcode_19,
  t0._p_municipal_code AS _p_municipal_code_20,
  t0._p_ars AS _p_ars_21,
  t0._p_created_date AS _p_created_date_22,
  t0._p_closed_date AS _p_closed_date_23,
  t0._p_deleted_date AS _p_deleted_date_24,
  t0.agency_main_email_address AS agency_main_email_address_25,
  t0.extern_id AS extern_id_26,
  t0._o_id AS _o_id_27,
  t0.phase_id AS phase_id_28,
  t0.public_participation_phase_id AS public_participation_phase_id_29,
  t30._ps_id AS _ps_id_31,
  t30._ps_map_extent AS _ps_map_extent_32,
  t30._ps_start_scale AS _ps_start_scale_33,
  t30._ps_available_scale AS _ps_available_scale_34,
  t30._ps_bounding_box AS _ps_bounding_box_35,
  t30._ps_information_url AS _ps_information_url_36,
  t30._ps_default_layer AS _ps_default_layer_37,
  t30._ps_territory AS _ps_territory_38,
  t30._ps_coordinate AS _ps_coordinate_39,
  t30._ps_plan_enable AS _ps_plan_enable_40,
  t30.allow_anonymous_statements AS allow_anonymous_statements_41,
  t30.expand_procedure_description AS expand_procedure_description_42,
  t30._ps_plan_text AS _ps_plan_text_43,
  t30._ps_plan_pdf AS _ps_plan_pdf_44,
  t30._ps_plan_para1_pdf AS _ps_plan_para1_pdf_45,
  t30._ps_plan_para2_pdf AS _ps_plan_para2_pdf_46,
  t30._ps_plan_draw_text AS _ps_plan_draw_text_47,
  t30._ps_plan_draw_pdf AS _ps_plan_draw_pdf_48,
  t30._ps_email_title AS _ps_email_title_49,
  t30._ps_email_text AS _ps_email_text_50,
  t30._ps_email_cc AS _ps_email_cc_51,
  t30._ps_links AS _ps_links_52,
  t30._ps_pictogram AS _ps_pictogram_53,
  t30._ps_pictogram_copyright AS _ps_pictogram_copyright_54,
  t30._ps_pictogram_alt_text AS _ps_pictogram_alt_text_55,
  t30._ps_send_mails_to_counties AS _ps_send_mails_to_counties_56,
  t30.planning_area AS planning_area_57,
  t30.scales AS scales_58,
  t30.legal_notice AS legal_notice_59,
  t30.copyright AS copyright_60,
  t30.map_hint AS map_hint_61,
  t30._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_62,
  t30._p_id AS _p_id_63,
  t0.customer AS customer_64,
  t0.procedure_type_id AS procedure_type_id_65,
  t0.statement_form_definition_id AS statement_form_definition_id_66,
  t0.procedure_behavior_definition_id AS procedure_behavior_definition_id_67,
  t0.procedure_ui_definition_id AS procedure_ui_definition_id_68,
  t0.current_slug_id AS current_slug_id_69
FROM
  _procedure t0
  LEFT JOIN _procedure_settings t30 ON t30._p_id = t0._p_id
WHERE
  t0._p_id = ?

SELECT t0._p_id AS _p_id_1, t0._p_name AS _p_name_2, t0._p_short_url AS _p_short_url_3, t0._o_name AS _o_name_4, t0._p_desc AS _p_desc_5, t0._p_logo AS _p_logo_6, t0._p_extern_id AS _p_extern_id_7, t0._p_plis_id AS _p_plis_id_8, t0._p_closed AS _p_closed_9, t0._p_deleted AS _p_deleted_10, t0._p_master AS _p_master_11, t0.master_template AS master_template_12, t0._p_external_name AS _p_external_name_13, t0._p_external_desc AS _p_external_desc_14, t0._p_public_participation AS _p_public_participation_15, t0._p_public_participation_contact AS _p_public_participation_contact_16, t0._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_17, t0._p_location_name AS _p_location_name_18, t0._p_location_postcode AS _p_location_postcode_19, t0._p_municipal_code AS _p_municipal_code_20, t0._p_ars AS _p_ars_21, t0._p_created_date AS _p_created_date_22, t0._p_closed_date AS _p_closed_date_23, t0._p_deleted_date AS _p_deleted_date_24, t0.agency_main_email_address AS agency_main_email_address_25, t0.extern_id AS extern_id_26, t0._o_id AS _o_id_27, t0.phase_id AS phase_id_28, t0.public_participation_phase_id AS public_participation_phase_id_29, t30._ps_id AS _ps_id_31, t30._ps_map_extent AS _ps_map_extent_32, t30._ps_start_scale AS _ps_start_scale_33, t30._ps_available_scale AS _ps_available_scale_34, t30._ps_bounding_box AS _ps_bounding_box_35, t30._ps_information_url AS _ps_information_url_36, t30._ps_default_layer AS _ps_default_layer_37, t30._ps_territory AS _ps_territory_38, t30._ps_coordinate AS _ps_coordinate_39, t30._ps_plan_enable AS _ps_plan_enable_40, t30.allow_anonymous_statements AS allow_anonymous_statements_41, t30.expand_procedure_description AS expand_procedure_description_42, t30._ps_plan_text AS _ps_plan_text_43, t30._ps_plan_pdf AS _ps_plan_pdf_44, t30._ps_plan_para1_pdf AS _ps_plan_para1_pdf_45, t30._ps_plan_para2_pdf AS _ps_plan_para2_pdf_46, t30._ps_plan_draw_text AS _ps_plan_draw_text_47, t30._ps_plan_draw_pdf AS _ps_plan_draw_pdf_48, t30._ps_email_title AS _ps_email_title_49, t30._ps_email_text AS _ps_email_text_50, t30._ps_email_cc AS _ps_email_cc_51, t30._ps_links AS _ps_links_52, t30._ps_pictogram AS _ps_pictogram_53, t30._ps_pictogram_copyright AS _ps_pictogram_copyright_54, t30._ps_pictogram_alt_text AS _ps_pictogram_alt_text_55, t30._ps_send_mails_to_counties AS _ps_send_mails_to_counties_56, t30.planning_area AS planning_area_57, t30.scales AS scales_58, t30.legal_notice AS legal_notice_59, t30.copyright AS copyright_60, t30.map_hint AS map_hint_61, t30._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_62, t30._p_id AS _p_id_63, t0.customer AS customer_64, t0.procedure_type_id AS procedure_type_id_65, t0.statement_form_definition_id AS statement_form_definition_id_66, t0.procedure_behavior_definition_id AS procedure_behavior_definition_id_67, t0.procedure_ui_definition_id AS procedure_ui_definition_id_68, t0.current_slug_id AS current_slug_id_69 FROM _procedure t0 LEFT JOIN _procedure_settings t30 ON t30._p_id = t0._p_id WHERE t0._p_id = 'd072d9a0-18b1-4bb5-9151-8493ba84a9f4';

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.creation_date AS creation_date_4,
  t0.modification_date AS modification_date_5,
  t0.designated_phase AS designated_phase_6,
  t0.designated_switch_date AS designated_switch_date_7,
  t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8,
  t0.designated_end_date AS designated_end_date_9,
  t0.iteration AS iteration_10,
  t0.step AS step_11,
  t0.phase_key AS phase_key_12,
  t0.designated_phase_change_user_id AS designated_phase_change_user_id_13
FROM
  procedure_phase t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.creation_date AS creation_date_4, t0.modification_date AS modification_date_5, t0.designated_phase AS designated_phase_6, t0.designated_switch_date AS designated_switch_date_7, t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8, t0.designated_end_date AS designated_end_date_9, t0.iteration AS iteration_10, t0.step AS step_11, t0.phase_key AS phase_key_12, t0.designated_phase_change_user_id AS designated_phase_change_user_id_13 FROM procedure_phase t0 WHERE t0.id = '4222e472-fb23-3a8f-88a1-66770e650418';

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.creation_date AS creation_date_4,
  t0.modification_date AS modification_date_5,
  t0.designated_phase AS designated_phase_6,
  t0.designated_switch_date AS designated_switch_date_7,
  t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8,
  t0.designated_end_date AS designated_end_date_9,
  t0.iteration AS iteration_10,
  t0.step AS step_11,
  t0.phase_key AS phase_key_12,
  t0.designated_phase_change_user_id AS designated_phase_change_user_id_13
FROM
  procedure_phase t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.creation_date AS creation_date_4, t0.modification_date AS modification_date_5, t0.designated_phase AS designated_phase_6, t0.designated_switch_date AS designated_switch_date_7, t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8, t0.designated_end_date AS designated_end_date_9, t0.iteration AS iteration_10, t0.step AS step_11, t0.phase_key AS phase_key_12, t0.designated_phase_change_user_id AS designated_phase_change_user_id_13 FROM procedure_phase t0 WHERE t0.id = '44c93325-6c8f-3108-b4de-23f931b48111';

SELECT
  t0._o_id AS _o_id_1,
  t0._o_name AS _o_name_2,
  t0._o_gateway_name AS _o_gateway_name_3,
  t0._o_code AS _o_code_4,
  t0._o_created_date AS _o_created_date_5,
  t0._o_modified_date AS _o_modified_date_6,
  t0._o_cc_email2 AS _o_cc_email2_7,
  t0._o_email_reviewer_admin AS _o_email_reviewer_admin_8,
  t0._o_deleted AS _o_deleted_9,
  t0._o_showname AS _o_showname_10,
  t0._o_showlist AS _o_showlist_11,
  t0._o_gw_id AS _o_gw_id_12,
  t0._o_competence AS _o_competence_13,
  t0._o_email2 AS _o_email2_14,
  t0._o_contact_person AS _o_contact_person_15,
  t0._o_paper_copy AS _o_paper_copy_16,
  t0._o_paper_copy_spec AS _o_paper_copy_spec_17,
  t0.data_protection AS data_protection_18,
  t0.imprint AS imprint_19,
  t20._mt_id AS _mt_id_21,
  t20._mt_gateway_group AS _mt_gateway_group_22,
  t20._mt_orga_name AS _mt_orga_name_23,
  t20._o_id AS _o_id_24,
  t20._mt_department_name AS _mt_department_name_25,
  t20._mt_sign AS _mt_sign_26,
  t20._mt_email AS _mt_email_27,
  t20._mt_cc_email AS _mt_cc_email_28,
  t20._mt_contact_person AS _mt_contact_person_29,
  t20._mt_memo AS _mt_memo_30,
  t20._mt_comment AS _mt_comment_31,
  t20._mt_registered AS _mt_registered_32,
  t20._mt_district_hh_mitte AS _mt_district_hh_mitte_33,
  t20._mt_district_eimsbuettel AS _mt_district_eimsbuettel_34,
  t20._mt_district_altona AS _mt_district_altona_35,
  t20._mt_district_hh_nord AS _mt_district_hh_nord_36,
  t20._mt_district_wandsbek AS _mt_district_wandsbek_37,
  t20._mt_district_bergedorf AS _mt_district_bergedorf_38,
  t20._mt_district_harburg AS _mt_district_harburg_39,
  t20._mt_district_bsu AS _mt_district_bsu_40,
  t20._mt_document_rough_agreement AS _mt_document_rough_agreement_41,
  t20._mt_document_agreement AS _mt_document_agreement_42,
  t20._mt_document_notice AS _mt_document_notice_43,
  t20._mt_document_assessment AS _mt_document_assessment_44,
  t20._mt_created_date AS _mt_created_date_45,
  t20._mt_modified_date AS _mt_modified_date_46,
  t20._o_id AS _o_id_47,
  t20._d_id AS _d_id_48,
  t0.branding_id AS branding_id_49,
  t0.current_slug_id AS current_slug_id_50
FROM
  _orga t0
  LEFT JOIN _master_toeb t20 ON t20._o_id = t0._o_id
  INNER JOIN procedure_planningoffices ON t0._o_id = procedure_planningoffices._o_id
WHERE
  procedure_planningoffices._p_id = ?

SELECT t0._o_id AS _o_id_1, t0._o_name AS _o_name_2, t0._o_gateway_name AS _o_gateway_name_3, t0._o_code AS _o_code_4, t0._o_created_date AS _o_created_date_5, t0._o_modified_date AS _o_modified_date_6, t0._o_cc_email2 AS _o_cc_email2_7, t0._o_email_reviewer_admin AS _o_email_reviewer_admin_8, t0._o_deleted AS _o_deleted_9, t0._o_showname AS _o_showname_10, t0._o_showlist AS _o_showlist_11, t0._o_gw_id AS _o_gw_id_12, t0._o_competence AS _o_competence_13, t0._o_email2 AS _o_email2_14, t0._o_contact_person AS _o_contact_person_15, t0._o_paper_copy AS _o_paper_copy_16, t0._o_paper_copy_spec AS _o_paper_copy_spec_17, t0.data_protection AS data_protection_18, t0.imprint AS imprint_19, t20._mt_id AS _mt_id_21, t20._mt_gateway_group AS _mt_gateway_group_22, t20._mt_orga_name AS _mt_orga_name_23, t20._o_id AS _o_id_24, t20._mt_department_name AS _mt_department_name_25, t20._mt_sign AS _mt_sign_26, t20._mt_email AS _mt_email_27, t20._mt_cc_email AS _mt_cc_email_28, t20._mt_contact_person AS _mt_contact_person_29, t20._mt_memo AS _mt_memo_30, t20._mt_comment AS _mt_comment_31, t20._mt_registered AS _mt_registered_32, t20._mt_district_hh_mitte AS _mt_district_hh_mitte_33, t20._mt_district_eimsbuettel AS _mt_district_eimsbuettel_34, t20._mt_district_altona AS _mt_district_altona_35, t20._mt_district_hh_nord AS _mt_district_hh_nord_36, t20._mt_district_wandsbek AS _mt_district_wandsbek_37, t20._mt_district_bergedorf AS _mt_district_bergedorf_38, t20._mt_district_harburg AS _mt_district_harburg_39, t20._mt_district_bsu AS _mt_district_bsu_40, t20._mt_document_rough_agreement AS _mt_document_rough_agreement_41, t20._mt_document_agreement AS _mt_document_agreement_42, t20._mt_document_notice AS _mt_document_notice_43, t20._mt_document_assessment AS _mt_document_assessment_44, t20._mt_created_date AS _mt_created_date_45, t20._mt_modified_date AS _mt_modified_date_46, t20._o_id AS _o_id_47, t20._d_id AS _d_id_48, t0.branding_id AS branding_id_49, t0.current_slug_id AS current_slug_id_50 FROM _orga t0 LEFT JOIN _master_toeb t20 ON t20._o_id = t0._o_id INNER JOIN procedure_planningoffices ON t0._o_id = procedure_planningoffices._o_id WHERE procedure_planningoffices._p_id = '505ee4f0-32c0-4f50-a7b1-3ba42d3935db';

SELECT
  t0._o_id AS _o_id_1,
  t0._o_name AS _o_name_2,
  t0._o_gateway_name AS _o_gateway_name_3,
  t0._o_code AS _o_code_4,
  t0._o_created_date AS _o_created_date_5,
  t0._o_modified_date AS _o_modified_date_6,
  t0._o_cc_email2 AS _o_cc_email2_7,
  t0._o_email_reviewer_admin AS _o_email_reviewer_admin_8,
  t0._o_deleted AS _o_deleted_9,
  t0._o_showname AS _o_showname_10,
  t0._o_showlist AS _o_showlist_11,
  t0._o_gw_id AS _o_gw_id_12,
  t0._o_competence AS _o_competence_13,
  t0._o_email2 AS _o_email2_14,
  t0._o_contact_person AS _o_contact_person_15,
  t0._o_paper_copy AS _o_paper_copy_16,
  t0._o_paper_copy_spec AS _o_paper_copy_spec_17,
  t0.data_protection AS data_protection_18,
  t0.imprint AS imprint_19,
  t20._mt_id AS _mt_id_21,
  t20._mt_gateway_group AS _mt_gateway_group_22,
  t20._mt_orga_name AS _mt_orga_name_23,
  t20._o_id AS _o_id_24,
  t20._mt_department_name AS _mt_department_name_25,
  t20._mt_sign AS _mt_sign_26,
  t20._mt_email AS _mt_email_27,
  t20._mt_cc_email AS _mt_cc_email_28,
  t20._mt_contact_person AS _mt_contact_person_29,
  t20._mt_memo AS _mt_memo_30,
  t20._mt_comment AS _mt_comment_31,
  t20._mt_registered AS _mt_registered_32,
  t20._mt_district_hh_mitte AS _mt_district_hh_mitte_33,
  t20._mt_district_eimsbuettel AS _mt_district_eimsbuettel_34,
  t20._mt_district_altona AS _mt_district_altona_35,
  t20._mt_district_hh_nord AS _mt_district_hh_nord_36,
  t20._mt_district_wandsbek AS _mt_district_wandsbek_37,
  t20._mt_district_bergedorf AS _mt_district_bergedorf_38,
  t20._mt_district_harburg AS _mt_district_harburg_39,
  t20._mt_district_bsu AS _mt_district_bsu_40,
  t20._mt_document_rough_agreement AS _mt_document_rough_agreement_41,
  t20._mt_document_agreement AS _mt_document_agreement_42,
  t20._mt_document_notice AS _mt_document_notice_43,
  t20._mt_document_assessment AS _mt_document_assessment_44,
  t20._mt_created_date AS _mt_created_date_45,
  t20._mt_modified_date AS _mt_modified_date_46,
  t20._o_id AS _o_id_47,
  t20._d_id AS _d_id_48,
  t0.branding_id AS branding_id_49,
  t0.current_slug_id AS current_slug_id_50
FROM
  _orga t0
  LEFT JOIN _master_toeb t20 ON t20._o_id = t0._o_id
  INNER JOIN procedure_orga_datainput ON t0._o_id = procedure_orga_datainput._o_id
WHERE
  procedure_orga_datainput._p_id = ?

SELECT t0._o_id AS _o_id_1, t0._o_name AS _o_name_2, t0._o_gateway_name AS _o_gateway_name_3, t0._o_code AS _o_code_4, t0._o_created_date AS _o_created_date_5, t0._o_modified_date AS _o_modified_date_6, t0._o_cc_email2 AS _o_cc_email2_7, t0._o_email_reviewer_admin AS _o_email_reviewer_admin_8, t0._o_deleted AS _o_deleted_9, t0._o_showname AS _o_showname_10, t0._o_showlist AS _o_showlist_11, t0._o_gw_id AS _o_gw_id_12, t0._o_competence AS _o_competence_13, t0._o_email2 AS _o_email2_14, t0._o_contact_person AS _o_contact_person_15, t0._o_paper_copy AS _o_paper_copy_16, t0._o_paper_copy_spec AS _o_paper_copy_spec_17, t0.data_protection AS data_protection_18, t0.imprint AS imprint_19, t20._mt_id AS _mt_id_21, t20._mt_gateway_group AS _mt_gateway_group_22, t20._mt_orga_name AS _mt_orga_name_23, t20._o_id AS _o_id_24, t20._mt_department_name AS _mt_department_name_25, t20._mt_sign AS _mt_sign_26, t20._mt_email AS _mt_email_27, t20._mt_cc_email AS _mt_cc_email_28, t20._mt_contact_person AS _mt_contact_person_29, t20._mt_memo AS _mt_memo_30, t20._mt_comment AS _mt_comment_31, t20._mt_registered AS _mt_registered_32, t20._mt_district_hh_mitte AS _mt_district_hh_mitte_33, t20._mt_district_eimsbuettel AS _mt_district_eimsbuettel_34, t20._mt_district_altona AS _mt_district_altona_35, t20._mt_district_hh_nord AS _mt_district_hh_nord_36, t20._mt_district_wandsbek AS _mt_district_wandsbek_37, t20._mt_district_bergedorf AS _mt_district_bergedorf_38, t20._mt_district_harburg AS _mt_district_harburg_39, t20._mt_district_bsu AS _mt_district_bsu_40, t20._mt_document_rough_agreement AS _mt_document_rough_agreement_41, t20._mt_document_agreement AS _mt_document_agreement_42, t20._mt_document_notice AS _mt_document_notice_43, t20._mt_document_assessment AS _mt_document_assessment_44, t20._mt_created_date AS _mt_created_date_45, t20._mt_modified_date AS _mt_modified_date_46, t20._o_id AS _o_id_47, t20._d_id AS _d_id_48, t0.branding_id AS branding_id_49, t0.current_slug_id AS current_slug_id_50 FROM _orga t0 LEFT JOIN _master_toeb t20 ON t20._o_id = t0._o_id INNER JOIN procedure_orga_datainput ON t0._o_id = procedure_orga_datainput._o_id WHERE procedure_orga_datainput._p_id = '505ee4f0-32c0-4f50-a7b1-3ba42d3935db';

SELECT
  t0._u_id AS _u_id_1,
  t0._u_dm_id AS _u_dm_id_2,
  t0._u_gender AS _u_gender_3,
  t0._u_title AS _u_title_4,
  t0._u_firstname AS _u_firstname_5,
  t0._u_lastname AS _u_lastname_6,
  t0._u_email AS _u_email_7,
  t0._u_login AS _u_login_8,
  t0._u_password AS _u_password_9,
  t0.alternative_login_password AS alternative_login_password_10,
  t0._u_salt AS _u_salt_11,
  t0._u_language AS _u_language_12,
  t0._u_created_date AS _u_created_date_13,
  t0._u_modified_date AS _u_modified_date_14,
  t0.last_login AS last_login_15,
  t0._u_deleted AS _u_deleted_16,
  t0._u_gw_id AS _u_gw_id_17,
  t0.flags AS flags_18,
  t0.provided_by_identity_provider AS provided_by_identity_provider_19,
  t0.totp_secret AS totp_secret_20,
  t0.totp_enabled AS totp_enabled_21,
  t0.auth_code AS auth_code_22,
  t0.auth_code_email_enabled AS auth_code_email_enabled_23,
  t0.twin_user_id AS twin_user_id_24
FROM
  _user t0
  INNER JOIN procedure_user ON t0._u_id = procedure_user.user_id
WHERE
  procedure_user.procedure_id = ?