Symfony Profiler

Query Metrics

87 Database Queries
41 Different statements
193.57 ms Query time
0 Invalid entities
114 Managed entities
Queries

Group similar statements
dplan connection


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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_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._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._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_._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.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.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.phase_definition_id AS phase_definition_id_13, t0.designated_phase_definition_id AS designated_phase_definition_id_14, t0.designated_phase_change_user_id AS designated_phase_change_user_id_15 FROM procedure_phase t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.audience AS audience_3, t0.permission_set AS permission_set_4, t0.participation_state AS participation_state_5, t0.closing_phase AS closing_phase_6, t0.order_in_audience AS order_in_audience_7, t0.creation_date AS creation_date_8, t0.modification_date AS modification_date_9, t0.customer_id AS customer_id_10 FROM procedure_phase_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.procedure_id AS procedure_id_4, t0.allowed_to_enable_map AS allowed_to_enable_map_5, t0.has_priority_area AS has_priority_area_6, t0.participation_guest_only AS participation_guest_only_7, t8._p_id AS _p_id_9, t8._p_name AS _p_name_10, t8._p_short_url AS _p_short_url_11, t8._o_name AS _o_name_12, t8._p_desc AS _p_desc_13, t8._p_logo AS _p_logo_14, t8._p_extern_id AS _p_extern_id_15, t8._p_plis_id AS _p_plis_id_16, t8._p_closed AS _p_closed_17, t8._p_deleted AS _p_deleted_18, t8._p_master AS _p_master_19, t8.master_template AS master_template_20, t8._p_external_name AS _p_external_name_21, t8._p_external_desc AS _p_external_desc_22, t8._p_public_participation AS _p_public_participation_23, t8._p_public_participation_contact AS _p_public_participation_contact_24, t8._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_25, t8._p_location_name AS _p_location_name_26, t8._p_location_postcode AS _p_location_postcode_27, t8._p_municipal_code AS _p_municipal_code_28, t8._p_ars AS _p_ars_29, t8._p_created_date AS _p_created_date_30, t8._p_closed_date AS _p_closed_date_31, t8._p_deleted_date AS _p_deleted_date_32, t8.agency_main_email_address AS agency_main_email_address_33, t8.extern_id AS extern_id_34, t8.current_slug_id AS current_slug_id_35, t8._o_id AS _o_id_36, t8.phase_id AS phase_id_37, t8.public_participation_phase_id AS public_participation_phase_id_38, t8.customer AS customer_39, t8.procedure_type_id AS procedure_type_id_40, t8.statement_form_definition_id AS statement_form_definition_id_41, t8.procedure_behavior_definition_id AS procedure_behavior_definition_id_42, t8.procedure_ui_definition_id AS procedure_ui_definition_id_43, t44.id AS id_45, t44.creation_date AS creation_date_46, t44.modification_date AS modification_date_47, t44.name AS name_48, t44.description AS description_49, t44.statement_form_definition_id AS statement_form_definition_id_50, t44.procedure_behavior_definition_id AS procedure_behavior_definition_id_51, t44.procedure_ui_definition_id AS procedure_ui_definition_id_52 FROM procedure_behavior_definition t0 LEFT JOIN _procedure t8 ON t8.procedure_behavior_definition_id = t0.id LEFT JOIN procedure_type t44 ON t44.procedure_behavior_definition_id = t0.id WHERE t0.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 = ?
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_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._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.current_slug_id AS current_slug_id_27, t0._o_id AS _o_id_28, t0.phase_id AS phase_id_29, t0.public_participation_phase_id AS public_participation_phase_id_30, t31._ps_id AS _ps_id_32, t31._ps_map_extent AS _ps_map_extent_33, t31._ps_start_scale AS _ps_start_scale_34, t31._ps_available_scale AS _ps_available_scale_35, t31._ps_bounding_box AS _ps_bounding_box_36, t31._ps_information_url AS _ps_information_url_37, t31._ps_default_layer AS _ps_default_layer_38, t31._ps_territory AS _ps_territory_39, t31._ps_coordinate AS _ps_coordinate_40, t31._ps_plan_enable AS _ps_plan_enable_41, t31.allow_anonymous_statements AS allow_anonymous_statements_42, t31.expand_procedure_description AS expand_procedure_description_43, t31._ps_plan_text AS _ps_plan_text_44, t31._ps_plan_pdf AS _ps_plan_pdf_45, t31._ps_plan_para1_pdf AS _ps_plan_para1_pdf_46, t31._ps_plan_para2_pdf AS _ps_plan_para2_pdf_47, t31._ps_plan_draw_text AS _ps_plan_draw_text_48, t31._ps_plan_draw_pdf AS _ps_plan_draw_pdf_49, t31._ps_email_title AS _ps_email_title_50, t31._ps_email_text AS _ps_email_text_51, t31._ps_email_cc AS _ps_email_cc_52, t31._ps_links AS _ps_links_53, t31._ps_pictogram AS _ps_pictogram_54, t31._ps_pictogram_copyright AS _ps_pictogram_copyright_55, t31._ps_pictogram_alt_text AS _ps_pictogram_alt_text_56, t31._ps_send_mails_to_counties AS _ps_send_mails_to_counties_57, t31.planning_area AS planning_area_58, t31.scales AS scales_59, t31.legal_notice AS legal_notice_60, t31.copyright AS copyright_61, t31.map_hint AS map_hint_62, t31._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_63, t31._p_id AS _p_id_64, t0.customer AS customer_65, t0.procedure_type_id AS procedure_type_id_66, t0.statement_form_definition_id AS statement_form_definition_id_67, t0.procedure_behavior_definition_id AS procedure_behavior_definition_id_68, t0.procedure_ui_definition_id AS procedure_ui_definition_id_69 FROM _procedure t0 LEFT JOIN _procedure_settings t31 ON t31._p_id = t0._p_id WHERE t0._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, t0.custom_fields AS custom_fields_20, t0.current_slug_id AS current_slug_id_21, t22._mt_id AS _mt_id_23, t22._mt_gateway_group AS _mt_gateway_group_24, t22._mt_orga_name AS _mt_orga_name_25, t22._o_id AS _o_id_26, t22._mt_department_name AS _mt_department_name_27, t22._mt_sign AS _mt_sign_28, t22._mt_email AS _mt_email_29, t22._mt_cc_email AS _mt_cc_email_30, t22._mt_contact_person AS _mt_contact_person_31, t22._mt_memo AS _mt_memo_32, t22._mt_comment AS _mt_comment_33, t22._mt_registered AS _mt_registered_34, t22._mt_district_hh_mitte AS _mt_district_hh_mitte_35, t22._mt_district_eimsbuettel AS _mt_district_eimsbuettel_36, t22._mt_district_altona AS _mt_district_altona_37, t22._mt_district_hh_nord AS _mt_district_hh_nord_38, t22._mt_district_wandsbek AS _mt_district_wandsbek_39, t22._mt_district_bergedorf AS _mt_district_bergedorf_40, t22._mt_district_harburg AS _mt_district_harburg_41, t22._mt_district_bsu AS _mt_district_bsu_42, t22._mt_document_rough_agreement AS _mt_document_rough_agreement_43, t22._mt_document_agreement AS _mt_document_agreement_44, t22._mt_document_notice AS _mt_document_notice_45, t22._mt_document_assessment AS _mt_document_assessment_46, t22._mt_created_date AS _mt_created_date_47, t22._mt_modified_date AS _mt_modified_date_48, t22._o_id AS _o_id_49, t22._d_id AS _d_id_50, t0.branding_id AS branding_id_51 FROM _orga t0 LEFT JOIN _master_toeb t22 ON t22._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, t0.custom_fields AS custom_fields_20, t0.current_slug_id AS current_slug_id_21, t22._mt_id AS _mt_id_23, t22._mt_gateway_group AS _mt_gateway_group_24, t22._mt_orga_name AS _mt_orga_name_25, t22._o_id AS _o_id_26, t22._mt_department_name AS _mt_department_name_27, t22._mt_sign AS _mt_sign_28, t22._mt_email AS _mt_email_29, t22._mt_cc_email AS _mt_cc_email_30, t22._mt_contact_person AS _mt_contact_person_31, t22._mt_memo AS _mt_memo_32, t22._mt_comment AS _mt_comment_33, t22._mt_registered AS _mt_registered_34, t22._mt_district_hh_mitte AS _mt_district_hh_mitte_35, t22._mt_district_eimsbuettel AS _mt_district_eimsbuettel_36, t22._mt_district_altona AS _mt_district_altona_37, t22._mt_district_hh_nord AS _mt_district_hh_nord_38, t22._mt_district_wandsbek AS _mt_district_wandsbek_39, t22._mt_district_bergedorf AS _mt_district_bergedorf_40, t22._mt_district_harburg AS _mt_district_harburg_41, t22._mt_district_bsu AS _mt_district_bsu_42, t22._mt_document_rough_agreement AS _mt_document_rough_agreement_43, t22._mt_document_agreement AS _mt_document_agreement_44, t22._mt_document_notice AS _mt_document_notice_45, t22._mt_document_assessment AS _mt_document_assessment_46, t22._mt_created_date AS _mt_created_date_47, t22._mt_modified_date AS _mt_modified_date_48, t22._o_id AS _o_id_49, t22._d_id AS _d_id_50, t0.branding_id AS branding_id_51 FROM _orga t0 LEFT JOIN _master_toeb t22 ON t22._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._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 = ?
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.phase_definition_id AS phase_definition_id_13, t0.designated_phase_definition_id AS designated_phase_definition_id_14, t0.designated_phase_change_user_id AS designated_phase_change_user_id_15 FROM procedure_phase t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM slug t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.full_address AS full_address_2 FROM email_address t0 INNER JOIN procedure_agency_extra_email_address ON t0.id = procedure_agency_extra_email_address.email_address_id WHERE procedure_agency_extra_email_address.procedure_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.audience AS audience_3, t0.permission_set AS permission_set_4, t0.participation_state AS participation_state_5, t0.closing_phase AS closing_phase_6, t0.order_in_audience AS order_in_audience_7, t0.creation_date AS creation_date_8, t0.modification_date AS modification_date_9, t0.customer_id AS customer_id_10 FROM procedure_phase_definition t0 WHERE t0.id = ?
SELECT t0._e_id AS _e_id_1, t0._e_p_id AS _e_p_id_2, t0._p_id AS _p_id_3, t0._e_category AS _e_category_4, t0._e_title AS _e_title_5, t0._e_icon AS _e_icon_6, t0._e_icon_title AS _e_icon_title_7, t0._e_text AS _e_text_8, t0._e_file AS _e_file_9, t0._e_order AS _e_order_10, t0._e_enabled AS _e_enabled_11, t0._e_deleted AS _e_deleted_12, t0._e_create_date AS _e_create_date_13, t0._e_modify_date AS _e_modify_date_14, t0._e_delete_date AS _e_delete_date_15, t0._e_designated_switch_date AS _e_designated_switch_date_16, t0.permission AS permission_17, t0._e_p_id AS _e_p_id_18, t0._p_id AS _p_id_19 FROM _elements t0 WHERE t0._p_id = ?
SELECT t0._s_id AS _s_id_1, t0._s_orga_id AS _s_orga_id_2, t0._s_key AS _s_key_3, t0._s_content AS _s_content_4, t0._s_create_date AS _s_create_date_5, t0._s_modified_date AS _s_modified_date_6, t0._s_procedure_id AS _s_procedure_id_7, t0._s_user_id AS _s_user_id_8, t0._s_orga_id AS _s_orga_id_9 FROM _settings t0 WHERE t0._s_key = ? AND t0._s_procedure_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.current_slug_id AS current_slug_id_27, t0._o_id AS _o_id_28, t0.phase_id AS phase_id_29, t0.public_participation_phase_id AS public_participation_phase_id_30, t31._ps_id AS _ps_id_32, t31._ps_map_extent AS _ps_map_extent_33, t31._ps_start_scale AS _ps_start_scale_34, t31._ps_available_scale AS _ps_available_scale_35, t31._ps_bounding_box AS _ps_bounding_box_36, t31._ps_information_url AS _ps_information_url_37, t31._ps_default_layer AS _ps_default_layer_38, t31._ps_territory AS _ps_territory_39, t31._ps_coordinate AS _ps_coordinate_40, t31._ps_plan_enable AS _ps_plan_enable_41, t31.allow_anonymous_statements AS allow_anonymous_statements_42, t31.expand_procedure_description AS expand_procedure_description_43, t31._ps_plan_text AS _ps_plan_text_44, t31._ps_plan_pdf AS _ps_plan_pdf_45, t31._ps_plan_para1_pdf AS _ps_plan_para1_pdf_46, t31._ps_plan_para2_pdf AS _ps_plan_para2_pdf_47, t31._ps_plan_draw_text AS _ps_plan_draw_text_48, t31._ps_plan_draw_pdf AS _ps_plan_draw_pdf_49, t31._ps_email_title AS _ps_email_title_50, t31._ps_email_text AS _ps_email_text_51, t31._ps_email_cc AS _ps_email_cc_52, t31._ps_links AS _ps_links_53, t31._ps_pictogram AS _ps_pictogram_54, t31._ps_pictogram_copyright AS _ps_pictogram_copyright_55, t31._ps_pictogram_alt_text AS _ps_pictogram_alt_text_56, t31._ps_send_mails_to_counties AS _ps_send_mails_to_counties_57, t31.planning_area AS planning_area_58, t31.scales AS scales_59, t31.legal_notice AS legal_notice_60, t31.copyright AS copyright_61, t31.map_hint AS map_hint_62, t31._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_63, t31._p_id AS _p_id_64, t0.customer AS customer_65, t0.procedure_type_id AS procedure_type_id_66, t0.statement_form_definition_id AS statement_form_definition_id_67, t0.procedure_behavior_definition_id AS procedure_behavior_definition_id_68, t0.procedure_ui_definition_id AS procedure_ui_definition_id_69 FROM _procedure t0 LEFT JOIN _procedure_settings t31 ON t31._p_id = t0._p_id WHERE t0.master_template = ? LIMIT 1
SELECT t0._g_id AS _g_id_1, t0._g_bplan AS _g_bplan_2, t0.default_visibility AS default_visibility_3, t0._g_deleted AS _g_deleted_4, t0._g_legend AS _g_legend_5, t0._g_layers AS _g_layers_6, t0._g_name AS _g_name_7, t0._g_opacity AS _g_opacity_8, t0._g_order AS _g_order_9, t0._projection_label AS _projection_label_10, t0._projection_value AS _projection_value_11, t0._p_id AS _p_id_12, t0._g_print AS _g_print_13, t0._g_scope AS _g_scope_14, t0._g_scope1 AS _g_scope1_15, t0._g_type AS _g_type_16, t0._g_servicetype AS _g_servicetype_17, t0._g_cabilities AS _g_cabilities_18, t0._g_tile_matrix_set AS _g_tile_matrix_set_19, t0._g_url AS _g_url_20, t0.enabled AS enabled_21, t0._g_global_id AS _g_global_id_22, t0.layer_version AS layer_version_23, t0._g_xplan AS _g_xplan_24, t0._g_create_date AS _g_create_date_25, t0._g_modify_date AS _g_modify_date_26, t0._g_delete_date AS _g_delete_date_27, t0.tree_order AS tree_order_28, t0.user_toggle_visibility AS user_toggle_visibility_29, t0.visibility_group_id AS visibility_group_id_30, t0._g_is_minimap AS _g_is_minimap_31, t0._g_pcsh_id AS _g_pcsh_id_32, t33._pcsh_id AS _pcsh_id_34, t33._pcsh_key AS _pcsh_key_35, t33._pcsh_text AS _pcsh_text_36, t33._pcsh_created AS _pcsh_created_37, t33._pcsh_modified AS _pcsh_modified_38, t0.category_id AS category_id_39 FROM _gis t0 LEFT JOIN _platform_context_sensitive_help t33 ON t0._g_pcsh_id = t33._pcsh_id WHERE t0._p_id = ? AND t0._g_deleted = ? AND t0.enabled = ? AND t0._g_type = ? ORDER BY t0._g_order ASC
SELECT t0._g_id AS _g_id_1, t0._g_bplan AS _g_bplan_2, t0.default_visibility AS default_visibility_3, t0._g_deleted AS _g_deleted_4, t0._g_legend AS _g_legend_5, t0._g_layers AS _g_layers_6, t0._g_name AS _g_name_7, t0._g_opacity AS _g_opacity_8, t0._g_order AS _g_order_9, t0._projection_label AS _projection_label_10, t0._projection_value AS _projection_value_11, t0._p_id AS _p_id_12, t0._g_print AS _g_print_13, t0._g_scope AS _g_scope_14, t0._g_scope1 AS _g_scope1_15, t0._g_type AS _g_type_16, t0._g_servicetype AS _g_servicetype_17, t0._g_cabilities AS _g_cabilities_18, t0._g_tile_matrix_set AS _g_tile_matrix_set_19, t0._g_url AS _g_url_20, t0.enabled AS enabled_21, t0._g_global_id AS _g_global_id_22, t0.layer_version AS layer_version_23, t0._g_xplan AS _g_xplan_24, t0._g_create_date AS _g_create_date_25, t0._g_modify_date AS _g_modify_date_26, t0._g_delete_date AS _g_delete_date_27, t0.tree_order AS tree_order_28, t0.user_toggle_visibility AS user_toggle_visibility_29, t0.visibility_group_id AS visibility_group_id_30, t0._g_is_minimap AS _g_is_minimap_31, t0._g_pcsh_id AS _g_pcsh_id_32, t33._pcsh_id AS _pcsh_id_34, t33._pcsh_key AS _pcsh_key_35, t33._pcsh_text AS _pcsh_text_36, t33._pcsh_created AS _pcsh_created_37, t33._pcsh_modified AS _pcsh_modified_38, t0.category_id AS category_id_39 FROM _gis t0 LEFT JOIN _platform_context_sensitive_help t33 ON t0._g_pcsh_id = t33._pcsh_id WHERE t0._g_id = ? LIMIT 1
SELECT t0._g_id AS _g_id_1, t0._g_bplan AS _g_bplan_2, t0.default_visibility AS default_visibility_3, t0._g_deleted AS _g_deleted_4, t0._g_legend AS _g_legend_5, t0._g_layers AS _g_layers_6, t0._g_name AS _g_name_7, t0._g_opacity AS _g_opacity_8, t0._g_order AS _g_order_9, t0._projection_label AS _projection_label_10, t0._projection_value AS _projection_value_11, t0._p_id AS _p_id_12, t0._g_print AS _g_print_13, t0._g_scope AS _g_scope_14, t0._g_scope1 AS _g_scope1_15, t0._g_type AS _g_type_16, t0._g_servicetype AS _g_servicetype_17, t0._g_cabilities AS _g_cabilities_18, t0._g_tile_matrix_set AS _g_tile_matrix_set_19, t0._g_url AS _g_url_20, t0.enabled AS enabled_21, t0._g_global_id AS _g_global_id_22, t0.layer_version AS layer_version_23, t0._g_xplan AS _g_xplan_24, t0._g_create_date AS _g_create_date_25, t0._g_modify_date AS _g_modify_date_26, t0._g_delete_date AS _g_delete_date_27, t0.tree_order AS tree_order_28, t0.user_toggle_visibility AS user_toggle_visibility_29, t0.visibility_group_id AS visibility_group_id_30, t0._g_is_minimap AS _g_is_minimap_31, t0._g_pcsh_id AS _g_pcsh_id_32, t33._pcsh_id AS _pcsh_id_34, t33._pcsh_key AS _pcsh_key_35, t33._pcsh_text AS _pcsh_text_36, t33._pcsh_created AS _pcsh_created_37, t33._pcsh_modified AS _pcsh_modified_38, t0.category_id AS category_id_39 FROM _gis t0 LEFT JOIN _platform_context_sensitive_help t33 ON t0._g_pcsh_id = t33._pcsh_id WHERE t0._g_id = ? LIMIT 1
SELECT t0._g_id AS _g_id_1, t0._g_bplan AS _g_bplan_2, t0.default_visibility AS default_visibility_3, t0._g_deleted AS _g_deleted_4, t0._g_legend AS _g_legend_5, t0._g_layers AS _g_layers_6, t0._g_name AS _g_name_7, t0._g_opacity AS _g_opacity_8, t0._g_order AS _g_order_9, t0._projection_label AS _projection_label_10, t0._projection_value AS _projection_value_11, t0._p_id AS _p_id_12, t0._g_print AS _g_print_13, t0._g_scope AS _g_scope_14, t0._g_scope1 AS _g_scope1_15, t0._g_type AS _g_type_16, t0._g_servicetype AS _g_servicetype_17, t0._g_cabilities AS _g_cabilities_18, t0._g_tile_matrix_set AS _g_tile_matrix_set_19, t0._g_url AS _g_url_20, t0.enabled AS enabled_21, t0._g_global_id AS _g_global_id_22, t0.layer_version AS layer_version_23, t0._g_xplan AS _g_xplan_24, t0._g_create_date AS _g_create_date_25, t0._g_modify_date AS _g_modify_date_26, t0._g_delete_date AS _g_delete_date_27, t0.tree_order AS tree_order_28, t0.user_toggle_visibility AS user_toggle_visibility_29, t0.visibility_group_id AS visibility_group_id_30, t0._g_is_minimap AS _g_is_minimap_31, t0._g_pcsh_id AS _g_pcsh_id_32, t33._pcsh_id AS _pcsh_id_34, t33._pcsh_key AS _pcsh_key_35, t33._pcsh_text AS _pcsh_text_36, t33._pcsh_created AS _pcsh_created_37, t33._pcsh_modified AS _pcsh_modified_38, t0.category_id AS category_id_39 FROM _gis t0 LEFT JOIN _platform_context_sensitive_help t33 ON t0._g_pcsh_id = t33._pcsh_id WHERE t0._g_id = ? LIMIT 1
SELECT t0._g_id AS _g_id_1, t0._g_bplan AS _g_bplan_2, t0.default_visibility AS default_visibility_3, t0._g_deleted AS _g_deleted_4, t0._g_legend AS _g_legend_5, t0._g_layers AS _g_layers_6, t0._g_name AS _g_name_7, t0._g_opacity AS _g_opacity_8, t0._g_order AS _g_order_9, t0._projection_label AS _projection_label_10, t0._projection_value AS _projection_value_11, t0._p_id AS _p_id_12, t0._g_print AS _g_print_13, t0._g_scope AS _g_scope_14, t0._g_scope1 AS _g_scope1_15, t0._g_type AS _g_type_16, t0._g_servicetype AS _g_servicetype_17, t0._g_cabilities AS _g_cabilities_18, t0._g_tile_matrix_set AS _g_tile_matrix_set_19, t0._g_url AS _g_url_20, t0.enabled AS enabled_21, t0._g_global_id AS _g_global_id_22, t0.layer_version AS layer_version_23, t0._g_xplan AS _g_xplan_24, t0._g_create_date AS _g_create_date_25, t0._g_modify_date AS _g_modify_date_26, t0._g_delete_date AS _g_delete_date_27, t0.tree_order AS tree_order_28, t0.user_toggle_visibility AS user_toggle_visibility_29, t0.visibility_group_id AS visibility_group_id_30, t0._g_is_minimap AS _g_is_minimap_31, t0._g_pcsh_id AS _g_pcsh_id_32, t33._pcsh_id AS _pcsh_id_34, t33._pcsh_key AS _pcsh_key_35, t33._pcsh_text AS _pcsh_text_36, t33._pcsh_created AS _pcsh_created_37, t33._pcsh_modified AS _pcsh_modified_38, t0.category_id AS category_id_39 FROM _gis t0 LEFT JOIN _platform_context_sensitive_help t33 ON t0._g_pcsh_id = t33._pcsh_id WHERE t0._p_id = ? AND t0._g_deleted = ? AND t0.enabled = ? AND t0._g_type = ? ORDER BY t0._g_order ASC
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_0, t0_._c_name AS _c_name_1 FROM _county t0_, _county t1_ INNER JOIN customer_county c2_ ON t1_._c_id = c2_.county_id WHERE c2_.customer_id = ? ORDER BY t0_._c_name ASC
SELECT t0_._n_id AS _n_id_0, t0_._p_id AS _p_id_1, t0_._n_title AS _n_title_2, t0_._n_description AS _n_description_3, t0_._n_text AS _n_text_4, t0_._n_picture AS _n_picture_5, t0_._n_picture_title AS _n_picture_title_6, t0_._n_pdf AS _n_pdf_7, t0_._n_pdf_title AS _n_pdf_title_8, t0_._n_enabled AS _n_enabled_9, t0_._n_deleted AS _n_deleted_10, t0_._n_create_date AS _n_create_date_11, t0_._n_modify_date AS _n_modify_date_12, t0_._n_delete_date AS _n_delete_date_13, t0_.designated_switch_date AS designated_switch_date_14, t0_.designated_state AS designated_state_15, t0_.determined_to_switch AS determined_to_switch_16 FROM _news t0_ LEFT JOIN _news_roles t2_ ON t0_._n_id = t2_._n_id LEFT JOIN _role t1_ ON t1_._r_id = t2_._r_id WHERE t0_._n_deleted = ? AND t0_._n_enabled = ? AND t0_._p_id = ? AND t1_._r_code IN (?) ORDER BY t0_._n_create_date DESC
SELECT t0._mls_id AS _mls_id_1, t0._p_id AS _p_id_2, t0._mls_context AS _mls_context_3, t0._mls_namespace AS _mls_namespace_4, t0._mls_idents AS _mls_idents_5, t0.customer_id AS customer_id_6 FROM _manual_list_sort t0 WHERE t0._mls_context = ? AND t0._p_id = ? AND t0._mls_namespace = ? AND t0.customer_id IS NULL LIMIT 1
SELECT t0_._e_id AS _e_id_0, t0_._e_p_id AS _e_p_id_1, t0_._p_id AS _p_id_2, t0_._e_category AS _e_category_3, t0_._e_title AS _e_title_4, t0_._e_icon AS _e_icon_5, t0_._e_icon_title AS _e_icon_title_6, t0_._e_text AS _e_text_7, t0_._e_file AS _e_file_8, t0_._e_order AS _e_order_9, t0_._e_enabled AS _e_enabled_10, t0_._e_deleted AS _e_deleted_11, t0_._e_create_date AS _e_create_date_12, t0_._e_modify_date AS _e_modify_date_13, t0_._e_delete_date AS _e_delete_date_14, t0_._e_designated_switch_date AS _e_designated_switch_date_15, t0_.permission AS permission_16, t0_._e_p_id AS _e_p_id_17, t0_._p_id AS _p_id_18 FROM _elements t0_ WHERE t0_._p_id = ? AND t0_._e_deleted = ? AND NOT (t0_._e_title = ?) ORDER BY t0_._e_order ASC
SELECT t0_._e_id AS _e_id_0, t0_._e_p_id AS _e_p_id_1, t0_._p_id AS _p_id_2, t0_._e_category AS _e_category_3, t0_._e_title AS _e_title_4, t0_._e_icon AS _e_icon_5, t0_._e_icon_title AS _e_icon_title_6, t0_._e_text AS _e_text_7, t0_._e_file AS _e_file_8, t0_._e_order AS _e_order_9, t0_._e_enabled AS _e_enabled_10, t0_._e_deleted AS _e_deleted_11, t0_._e_create_date AS _e_create_date_12, t0_._e_modify_date AS _e_modify_date_13, t0_._e_delete_date AS _e_delete_date_14, t0_._e_designated_switch_date AS _e_designated_switch_date_15, t0_.permission AS permission_16, t0_._e_p_id AS _e_p_id_17, t0_._p_id AS _p_id_18 FROM _elements t0_ WHERE t0_._p_id = ? AND t0_._e_deleted = ? AND t0_._e_enabled = ? AND (EXISTS (SELECT 1 FROM _elements_orga_doctrine t1_ WHERE t1_._e_id = t0_._e_id AND t1_._o_id IN (?)) OR (SELECT COUNT(*) FROM _elements_orga_doctrine t1_ WHERE t1_._e_id = t0_._e_id) = ?) ORDER BY t0_._e_order ASC
SELECT t0._e_id AS _e_id_1, t0._e_p_id AS _e_p_id_2, t0._p_id AS _p_id_3, t0._e_category AS _e_category_4, t0._e_title AS _e_title_5, t0._e_icon AS _e_icon_6, t0._e_icon_title AS _e_icon_title_7, t0._e_text AS _e_text_8, t0._e_file AS _e_file_9, t0._e_order AS _e_order_10, t0._e_enabled AS _e_enabled_11, t0._e_deleted AS _e_deleted_12, t0._e_create_date AS _e_create_date_13, t0._e_modify_date AS _e_modify_date_14, t0._e_delete_date AS _e_delete_date_15, t0._e_designated_switch_date AS _e_designated_switch_date_16, t0.permission AS permission_17, t0._e_p_id AS _e_p_id_18, t0._p_id AS _p_id_19 FROM _elements t0 WHERE t0._p_id = ? AND t0._e_category = ? AND t0._e_title = ? LIMIT 1
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, t0.custom_fields AS custom_fields_20, t0.current_slug_id AS current_slug_id_21, t22._mt_id AS _mt_id_23, t22._mt_gateway_group AS _mt_gateway_group_24, t22._mt_orga_name AS _mt_orga_name_25, t22._o_id AS _o_id_26, t22._mt_department_name AS _mt_department_name_27, t22._mt_sign AS _mt_sign_28, t22._mt_email AS _mt_email_29, t22._mt_cc_email AS _mt_cc_email_30, t22._mt_contact_person AS _mt_contact_person_31, t22._mt_memo AS _mt_memo_32, t22._mt_comment AS _mt_comment_33, t22._mt_registered AS _mt_registered_34, t22._mt_district_hh_mitte AS _mt_district_hh_mitte_35, t22._mt_district_eimsbuettel AS _mt_district_eimsbuettel_36, t22._mt_district_altona AS _mt_district_altona_37, t22._mt_district_hh_nord AS _mt_district_hh_nord_38, t22._mt_district_wandsbek AS _mt_district_wandsbek_39, t22._mt_district_bergedorf AS _mt_district_bergedorf_40, t22._mt_district_harburg AS _mt_district_harburg_41, t22._mt_district_bsu AS _mt_district_bsu_42, t22._mt_document_rough_agreement AS _mt_document_rough_agreement_43, t22._mt_document_agreement AS _mt_document_agreement_44, t22._mt_document_notice AS _mt_document_notice_45, t22._mt_document_assessment AS _mt_document_assessment_46, t22._mt_created_date AS _mt_created_date_47, t22._mt_modified_date AS _mt_modified_date_48, t22._o_id AS _o_id_49, t22._d_id AS _d_id_50, t0.branding_id AS branding_id_51 FROM _orga t0 LEFT JOIN _master_toeb t22 ON t22._o_id = t0._o_id WHERE t0._o_id = ?
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.procedure_id AS procedure_id_4, t5._p_id AS _p_id_6, t5._p_name AS _p_name_7, t5._p_short_url AS _p_short_url_8, t5._o_name AS _o_name_9, t5._p_desc AS _p_desc_10, t5._p_logo AS _p_logo_11, t5._p_extern_id AS _p_extern_id_12, t5._p_plis_id AS _p_plis_id_13, t5._p_closed AS _p_closed_14, t5._p_deleted AS _p_deleted_15, t5._p_master AS _p_master_16, t5.master_template AS master_template_17, t5._p_external_name AS _p_external_name_18, t5._p_external_desc AS _p_external_desc_19, t5._p_public_participation AS _p_public_participation_20, t5._p_public_participation_contact AS _p_public_participation_contact_21, t5._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_22, t5._p_location_name AS _p_location_name_23, t5._p_location_postcode AS _p_location_postcode_24, t5._p_municipal_code AS _p_municipal_code_25, t5._p_ars AS _p_ars_26, t5._p_created_date AS _p_created_date_27, t5._p_closed_date AS _p_closed_date_28, t5._p_deleted_date AS _p_deleted_date_29, t5.agency_main_email_address AS agency_main_email_address_30, t5.extern_id AS extern_id_31, t5.current_slug_id AS current_slug_id_32, t5._o_id AS _o_id_33, t5.phase_id AS phase_id_34, t5.public_participation_phase_id AS public_participation_phase_id_35, t5.customer AS customer_36, t5.procedure_type_id AS procedure_type_id_37, t5.statement_form_definition_id AS statement_form_definition_id_38, t5.procedure_behavior_definition_id AS procedure_behavior_definition_id_39, t5.procedure_ui_definition_id AS procedure_ui_definition_id_40, t41.id AS id_42, t41.creation_date AS creation_date_43, t41.modification_date AS modification_date_44, t41.name AS name_45, t41.description AS description_46, t41.statement_form_definition_id AS statement_form_definition_id_47, t41.procedure_behavior_definition_id AS procedure_behavior_definition_id_48, t41.procedure_ui_definition_id AS procedure_ui_definition_id_49 FROM statement_form_definition t0 LEFT JOIN _procedure t5 ON t5.statement_form_definition_id = t0.id LEFT JOIN procedure_type t41 ON t41.statement_form_definition_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.name AS name_4, t0.order_number AS order_number_5, t0.enabled AS enabled_6, t0.required AS required_7, t0.statement_form_definition_id AS statement_form_definition_id_8 FROM statement_field_definition t0 WHERE t0.statement_form_definition_id = ? ORDER BY t0.order_number ASC
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_._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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? LIMIT 1
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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? LIMIT 1
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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? LIMIT 1
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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? 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 = ? 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 = ? 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 = ? LIMIT 1
SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.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_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 = ? LIMIT 1
SELECT t0._f_id AS _f_id_1, t0._f_ident AS _f_ident_2, t0._f_hash AS _f_hash_3, t0._f_name AS _f_name_4, t0._f_description AS _f_description_5, t0._f_path AS _f_path_6, t0._f_filename AS _f_filename_7, t0._f_tags AS _f_tags_8, t0._f_author AS _f_author_9, t0._f_application AS _f_application_10, t0._f_mimetype AS _f_mimetype_11, t0._f_created AS _f_created_12, t0._f_modified AS _f_modified_13, t0._f_valid_until AS _f_valid_until_14, t0._f_deleted AS _f_deleted_15, t0._f_stat_down AS _f_stat_down_16, t0._f_infected AS _f_infected_17, t0._f_last_v_scan AS _f_last_v_scan_18, t0._f_blocked AS _f_blocked_19, t0.size AS size_20, t0.procedure_id AS procedure_id_21 FROM _files t0 WHERE t0._f_ident = ?
SELECT t0_._pcsh_id AS _pcsh_id_0, t0_._pcsh_key AS _pcsh_key_1, t0_._pcsh_text AS _pcsh_text_2, t0_._pcsh_created AS _pcsh_created_3, t0_._pcsh_modified AS _pcsh_modified_4 FROM _platform_context_sensitive_help t0_ WHERE t0_._pcsh_key = ? LIMIT 1
SELECT t0_._pcsh_id AS _pcsh_id_0, t0_._pcsh_key AS _pcsh_key_1, t0_._pcsh_text AS _pcsh_text_2, t0_._pcsh_created AS _pcsh_created_3, t0_._pcsh_modified AS _pcsh_modified_4 FROM _platform_context_sensitive_help t0_ WHERE t0_._pcsh_key = ? LIMIT 1
SELECT t0_._pcsh_id AS _pcsh_id_0, t0_._pcsh_key AS _pcsh_key_1, t0_._pcsh_text AS _pcsh_text_2, t0_._pcsh_created AS _pcsh_created_3, t0_._pcsh_modified AS _pcsh_modified_4 FROM _platform_context_sensitive_help t0_ WHERE t0_._pcsh_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.procedure_id AS procedure_id_4, t0.map_hint_default AS map_hint_default_5, t0.statement_form_hint_statement AS statement_form_hint_statement_6, t0.statement_form_hint_personal_data AS statement_form_hint_personal_data_7, t0.statement_form_hint_recheck AS statement_form_hint_recheck_8, t0.statement_public_submit_confirmation_text AS statement_public_submit_confirmation_text_9, t10._p_id AS _p_id_11, t10._p_name AS _p_name_12, t10._p_short_url AS _p_short_url_13, t10._o_name AS _o_name_14, t10._p_desc AS _p_desc_15, t10._p_logo AS _p_logo_16, t10._p_extern_id AS _p_extern_id_17, t10._p_plis_id AS _p_plis_id_18, t10._p_closed AS _p_closed_19, t10._p_deleted AS _p_deleted_20, t10._p_master AS _p_master_21, t10.master_template AS master_template_22, t10._p_external_name AS _p_external_name_23, t10._p_external_desc AS _p_external_desc_24, t10._p_public_participation AS _p_public_participation_25, t10._p_public_participation_contact AS _p_public_participation_contact_26, t10._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_27, t10._p_location_name AS _p_location_name_28, t10._p_location_postcode AS _p_location_postcode_29, t10._p_municipal_code AS _p_municipal_code_30, t10._p_ars AS _p_ars_31, t10._p_created_date AS _p_created_date_32, t10._p_closed_date AS _p_closed_date_33, t10._p_deleted_date AS _p_deleted_date_34, t10.agency_main_email_address AS agency_main_email_address_35, t10.extern_id AS extern_id_36, t10.current_slug_id AS current_slug_id_37, t10._o_id AS _o_id_38, t10.phase_id AS phase_id_39, t10.public_participation_phase_id AS public_participation_phase_id_40, t10.customer AS customer_41, t10.procedure_type_id AS procedure_type_id_42, t10.statement_form_definition_id AS statement_form_definition_id_43, t10.procedure_behavior_definition_id AS procedure_behavior_definition_id_44, t10.procedure_ui_definition_id AS procedure_ui_definition_id_45, t46.id AS id_47, t46.creation_date AS creation_date_48, t46.modification_date AS modification_date_49, t46.name AS name_50, t46.description AS description_51, t46.statement_form_definition_id AS statement_form_definition_id_52, t46.procedure_behavior_definition_id AS procedure_behavior_definition_id_53, t46.procedure_ui_definition_id AS procedure_ui_definition_id_54 FROM procedure_ui_definition t0 LEFT JOIN _procedure t10 ON t10.procedure_ui_definition_id = t0.id LEFT JOIN procedure_type t46 ON t46.procedure_ui_definition_id = t0.id WHERE t0.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_subdomain = ? 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.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_._e_id AS _e_id_0, t0_._e_p_id AS _e_p_id_1, t0_._p_id AS _p_id_2, t0_._e_category AS _e_category_3, t0_._e_title AS _e_title_4, t0_._e_icon AS _e_icon_5, t0_._e_icon_title AS _e_icon_title_6, t0_._e_text AS _e_text_7, t0_._e_file AS _e_file_8, t0_._e_order AS _e_order_9, t0_._e_enabled AS _e_enabled_10, t0_._e_deleted AS _e_deleted_11, t0_._e_create_date AS _e_create_date_12, t0_._e_modify_date AS _e_modify_date_13, t0_._e_delete_date AS _e_delete_date_14, t0_._e_designated_switch_date AS _e_designated_switch_date_15, t0_.permission AS permission_16, t0_._e_p_id AS _e_p_id_17, t0_._p_id AS _p_id_18 FROM _elements t0_ WHERE t0_._p_id = ? AND t0_._e_deleted = ? AND t0_._e_enabled = ? AND (EXISTS (SELECT 1 FROM _elements_orga_doctrine t1_ WHERE t1_._e_id = t0_._e_id AND t1_._o_id IN (?)) OR (SELECT COUNT(*) FROM _elements_orga_doctrine t1_ WHERE t1_._e_id = t0_._e_id) = ?) ORDER BY t0_._e_order ASC
SELECT t0._sd_id AS _sd_id_1, t0._sd_category AS _sd_category_2, t0._sd_order AS _sd_order_3, t0._sd_title AS _sd_title_4, t0._sd_text AS _sd_text_5, t0._sd_symbol AS _sd_symbol_6, t0._sd_document AS _sd_document_7, t0._sd_statement_enabled AS _sd_statement_enabled_8, t0._sd_visible AS _sd_visible_9, t0._sd_deleted AS _sd_deleted_10, t0._sd_create_date AS _sd_create_date_11, t0._sd_modify_date AS _sd_modify_date_12, t0._sd_delete_date AS _sd_delete_date_13, t0._p_id AS _p_id_14, t0._e_id AS _e_id_15 FROM _single_doc t0 WHERE t0._e_id = ? ORDER BY t0._sd_order ASC, t0._sd_create_date ASC
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, t0.custom_fields AS custom_fields_20, t0.current_slug_id AS current_slug_id_21, t22._mt_id AS _mt_id_23, t22._mt_gateway_group AS _mt_gateway_group_24, t22._mt_orga_name AS _mt_orga_name_25, t22._o_id AS _o_id_26, t22._mt_department_name AS _mt_department_name_27, t22._mt_sign AS _mt_sign_28, t22._mt_email AS _mt_email_29, t22._mt_cc_email AS _mt_cc_email_30, t22._mt_contact_person AS _mt_contact_person_31, t22._mt_memo AS _mt_memo_32, t22._mt_comment AS _mt_comment_33, t22._mt_registered AS _mt_registered_34, t22._mt_district_hh_mitte AS _mt_district_hh_mitte_35, t22._mt_district_eimsbuettel AS _mt_district_eimsbuettel_36, t22._mt_district_altona AS _mt_district_altona_37, t22._mt_district_hh_nord AS _mt_district_hh_nord_38, t22._mt_district_wandsbek AS _mt_district_wandsbek_39, t22._mt_district_bergedorf AS _mt_district_bergedorf_40, t22._mt_district_harburg AS _mt_district_harburg_41, t22._mt_district_bsu AS _mt_district_bsu_42, t22._mt_document_rough_agreement AS _mt_document_rough_agreement_43, t22._mt_document_agreement AS _mt_document_agreement_44, t22._mt_document_notice AS _mt_document_notice_45, t22._mt_document_assessment AS _mt_document_assessment_46, t22._mt_created_date AS _mt_created_date_47, t22._mt_modified_date AS _mt_modified_date_48, t22._o_id AS _o_id_49, t22._d_id AS _d_id_50, t0.branding_id AS branding_id_51 FROM _orga t0 LEFT JOIN _master_toeb t22 ON t22._o_id = t0._o_id INNER JOIN _elements_orga_doctrine ON t0._o_id = _elements_orga_doctrine._o_id WHERE _elements_orga_doctrine._e_id = ?
SELECT t0._pd_id AS _pd_id_1, t0._pd_category AS _pd_category_2, t0._pd_title AS _pd_title_3, t0._pd_text AS _pd_text_4, t0._pd_order AS _pd_order_5, t0._pd_visible AS _pd_visible_6, t0._pd_deleted AS _pd_deleted_7, t0._pd_lockreason AS _pd_lockreason_8, t0._pd_create_date AS _pd_create_date_9, t0._pd_modify_date AS _pd_modify_date_10, t0._pd_delete_date AS _pd_delete_date_11, t0._p_id AS _p_id_12, t0._pd_parent_id AS _pd_parent_id_13, t0._e_id AS _e_id_14 FROM _para_doc t0 WHERE t0._p_id = ? AND t0._e_id = ? AND t0._pd_visible IN (?, ?) AND t0._pd_deleted = ? ORDER BY t0._pd_order ASC
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_._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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? LIMIT 1
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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? LIMIT 1
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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? LIMIT 1
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_.current_slug_id AS current_slug_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, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ WHERE t0_._p_id = ? LIMIT 1
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? 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 = ? LIMIT 1
SELECT t0_._p_short_url AS _p_short_url_0 FROM _procedure t0_ WHERE t0_._p_id = ?
Database Connections

Name	Service
dplan	doctrine.dbal.dplan_connection
dplan_install	doctrine.dbal.dplan_install_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
install	doctrine.orm.install_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
demosplan\DemosPlanCoreBundle\Entity\Document\Paragraph	49
demosplan\DemosPlanCoreBundle\Entity\Procedure\StatementFieldDefinition	13
demosplan\DemosPlanCoreBundle\Entity\Map\GisLayer	10
demosplan\DemosPlanCoreBundle\Entity\Document\Elements	9
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedurePhase	6
demosplan\DemosPlanCoreBundle\Entity\Slug	4
demosplan\DemosPlanCoreBundle\Entity\Procedure\Procedure	3
demosplan\DemosPlanCoreBundle\Entity\User\Orga	3
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureSettings	3
demosplan\DemosPlanCoreBundle\Entity\Help\ContextualHelp	3
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedurePhaseDefinition	2
demosplan\DemosPlanCoreBundle\Entity\User\Customer	1
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureType	1
demosplan\DemosPlanCoreBundle\Entity\Procedure\StatementFormDefinition	1
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureBehaviorDefinition	1
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureUiDefinition	1
demosplan\DemosPlanCoreBundle\Entity\User\Role	1
demosplan\DemosPlanCoreBundle\Entity\Branding	1
demosplan\DemosPlanCoreBundle\Entity\Map\GisLayerCategory	1
demosplan\DemosPlanCoreBundle\Entity\File	1
install entity manager

Class	Amount of managed objects
Entities Mapping

default entity manager

Class	Mapping errors
demosplan\DemosPlanCoreBundle\Entity\Procedure\Procedure	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Customer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\AccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\UserAccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Orga	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\User	No errors.
demosplan\DemosPlanCoreBundle\Entity\Slug	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedurePhase	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureSettings	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\TagTopic	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\NotificationReceiver	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\Elements	No errors.
demosplan\DemosPlanCoreBundle\Entity\EmailAddress	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureCategory	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Statement	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureType	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\StatementFormDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureBehaviorDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureUiDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\ExportFieldsConfiguration	No errors.
demosplan\DemosPlanCoreBundle\Entity\File	No errors.
demosplan\DemosPlanCoreBundle\Entity\Workflow\Place	No errors.
demosplan\DemosPlanCoreBundle\Entity\Branding	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\BoilerplateCategory	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\BoilerplateGroup	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\Boilerplate	No errors.
demosplan\DemosPlanCoreBundle\Entity\EntityContentChange	No errors.
demosplan\DemosPlanCoreBundle\Entity\Map\GisLayerCategory	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Role	No errors.
demosplan\DemosPlanCoreBundle\Entity\News\News	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\Paragraph	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedurePhaseDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\ProcedureSubscription	No errors.
demosplan\DemosPlanCoreBundle\Entity\Setting	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\SingleDocument	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\InstitutionMail	No errors.
demosplan\DemosPlanCoreBundle\Entity\CustomFields\CustomFieldConfiguration	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OAuthToken	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerOAuthConfig	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Department	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaType	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\UserRoleInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\SupportContact	No errors.
demosplan\DemosPlanCoreBundle\Entity\ManualListSort	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTag	No errors.
demosplan\DemosPlanCoreBundle\Entity\FileContainer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\SegmentComment	No errors.
demosplan\DemosPlanCoreBundle\Entity\Video	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\ConsultationToken	No errors.
demosplan\DemosPlanCoreBundle\Entity\StatementAttachment	No errors.
demosplan\DemosPlanCoreBundle\Entity\EntitySyncLink	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\ParagraphVersion	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\SingleDocumentVersion	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Tag	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\StatementVote	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerCounty	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaStatusInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTagCategory	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\MasterToeb	No errors.
demosplan\DemosPlanCoreBundle\Entity\GlobalContent	No errors.
demosplan\DemosPlanCoreBundle\Entity\Map\GisLayer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Help\ContextualHelp	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\County	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\HashedQuery	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\StatementAttribute	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\StatementFragment	No errors.
demosplan\DemosPlanCoreBundle\Entity\Flood	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Address	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\AddressBookEntry	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\StatementFieldDefinition	No errors.
install entity manager

No loaded entities.
Symfony Profiler

GET http://diplanbau-dev-debug-docker.demos-europe.eu/_fragment?_path=_format%3Dhtml%26_locale%3Dde%26_controller%3Ddemosplan%255CDemosPlanCoreBundle%255CController…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

dplan connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

install entity manager

Entities Mapping

default entity manager

install entity manager
