Symfony Profiler

Query Metrics

73 Database Queries

33 Different statements

102.89 ms Query time

0 Invalid entities

Queries

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_._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._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.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 = ?
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.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._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._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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_order ASC
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._pd_parent_id = ? ORDER BY t0._pd_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._e_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._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._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.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 = ?
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_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._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.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._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._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._e_id = ? LIMIT 1
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, 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 _elements_orga_doctrine ON t0._o_id = _elements_orga_doctrine._o_id WHERE _elements_orga_doctrine._e_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 WHERE t0._o_id = ?
SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ?
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._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._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_._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_ 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_._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_ 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_._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_ 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_._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_ 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_._p_short_url AS _p_short_url_0 FROM _procedure t0_ WHERE t0_._p_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.procedure_type_id AS procedure_type_id_5 FROM statement_form_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.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.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.map_hint_default AS map_hint_default_4, t0.statement_form_hint_statement AS statement_form_hint_statement_5, t0.statement_form_hint_personal_data AS statement_form_hint_personal_data_6, t0.statement_form_hint_recheck AS statement_form_hint_recheck_7, t0.statement_public_submit_confirmation_text AS statement_public_submit_confirmation_text_8, t0.procedure_id AS procedure_id_9, t0.procedure_type_id AS procedure_type_id_10 FROM procedure_ui_definition t0 WHERE t0.id = ?

#▲	Time	Info
1	1.90 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
2	3.79 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
3	3.44 ms	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 = ? Parameters: [`"8e18ac3d-7d08-441f-b576-7fb9973659c6"`] View formatted query View runnable query Explain query 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 = '8e18ac3d-7d08-441f-b576-7fb9973659c6';
4	0.64 ms	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 = ? Parameters: [`"121fe533-167f-4275-a2f3-22aef734627a"`] View formatted query View runnable query Explain query 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 = '121fe533-167f-4275-a2f3-22aef734627a';
5	0.84 ms	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 Parameters: [`"diplanbau-dev-debug-docker"`] View formatted query View runnable query Explain query 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;
6	4.08 ms	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 (?) Parameters: [`"RGUEST"`] View formatted query View runnable query Explain query 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');
7	0.65 ms	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 (?) Parameters: [`"71a2ebbc-0968-11e1-9d8e-1c64a3042bca" "cdec5e4b-3f06-11e4-a6a8-005056ae0004" null`] View formatted query View runnable query Explain query 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);
8	0.57 ms	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 = ? Parameters: [`"e40b70e3-3494-400a-acd8-256e85241699"`] View formatted query View runnable query Explain query 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 = 'e40b70e3-3494-400a-acd8-256e85241699';
9	2.87 ms	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 Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9" "86b98c2e-a322-4339-b90c-9c368b95f486" 1 2 0`] View formatted query View runnable query Explain query 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._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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9' AND t0._e_id = '86b98c2e-a322-4339-b90c-9c368b95f486' AND t0._pd_visible IN (1, 2) AND t0._pd_deleted = 0 ORDER BY t0._pd_order ASC;
10	1.09 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"707e8928-ad31-4093-a3dd-300f8e5b56a5"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '707e8928-ad31-4093-a3dd-300f8e5b56a5' ORDER BY t0._pd_order ASC;
11	1.01 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"66b256e9-755d-47c7-9434-1bbc8a875e4d"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '66b256e9-755d-47c7-9434-1bbc8a875e4d' ORDER BY t0._pd_order ASC;
12	0.90 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"6762ed39-314b-48eb-b64b-d5d8310273e5"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '6762ed39-314b-48eb-b64b-d5d8310273e5' ORDER BY t0._pd_order ASC;
13	1.15 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"eb2470a8-5ee9-4e6f-89d2-9d42c5bba359"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = 'eb2470a8-5ee9-4e6f-89d2-9d42c5bba359' ORDER BY t0._pd_order ASC;
14	0.91 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"2b28e4cd-5150-44ed-9d1d-35e8b7de5e8f"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '2b28e4cd-5150-44ed-9d1d-35e8b7de5e8f' ORDER BY t0._pd_order ASC;
15	0.90 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"d92d4eea-8d8f-44b1-9ffe-efe57a1b3828"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = 'd92d4eea-8d8f-44b1-9ffe-efe57a1b3828' ORDER BY t0._pd_order ASC;
16	0.90 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"44a39c4f-a8d6-45ee-a6b0-6fe112f57daf"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '44a39c4f-a8d6-45ee-a6b0-6fe112f57daf' ORDER BY t0._pd_order ASC;
17	0.99 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"b088e972-b0e7-4c4f-bc47-b6339b994ce3"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = 'b088e972-b0e7-4c4f-bc47-b6339b994ce3' ORDER BY t0._pd_order ASC;
18	0.90 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"4ab29be5-76ea-4930-aa19-6cd2561e01cb"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '4ab29be5-76ea-4930-aa19-6cd2561e01cb' ORDER BY t0._pd_order ASC;
19	3.80 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"e0b34d94-feaa-48d0-a402-0becab4e437b"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = 'e0b34d94-feaa-48d0-a402-0becab4e437b' ORDER BY t0._pd_order ASC;
20	0.91 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"211b301e-f4cd-4aa0-9a57-b5f8f9743bd0"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '211b301e-f4cd-4aa0-9a57-b5f8f9743bd0' ORDER BY t0._pd_order ASC;
21	0.94 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"5c560496-e2af-4af4-a7d0-a3753c1a2026"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '5c560496-e2af-4af4-a7d0-a3753c1a2026' ORDER BY t0._pd_order ASC;
22	0.90 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"8e39c175-02ce-402a-a26b-c7eb735c61b5"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '8e39c175-02ce-402a-a26b-c7eb735c61b5' ORDER BY t0._pd_order ASC;
23	1.01 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"9e672c95-917a-44b3-840f-aa50d1f8f9d4"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '9e672c95-917a-44b3-840f-aa50d1f8f9d4' ORDER BY t0._pd_order ASC;
24	1.00 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"76a2c02e-d9eb-496a-a751-090e81dbb076"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '76a2c02e-d9eb-496a-a751-090e81dbb076' ORDER BY t0._pd_order ASC;
25	1.13 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"bb45cd91-5d18-4a7a-9b87-48753b36e1bd"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = 'bb45cd91-5d18-4a7a-9b87-48753b36e1bd' ORDER BY t0._pd_order ASC;
26	0.91 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"796fd71a-5686-4aa6-a22d-5622f69955e4"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '796fd71a-5686-4aa6-a22d-5622f69955e4' ORDER BY t0._pd_order ASC;
27	0.91 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"3d6ea158-5d57-440d-b9ae-7660f674b542"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '3d6ea158-5d57-440d-b9ae-7660f674b542' ORDER BY t0._pd_order ASC;
28	0.94 ms	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._pd_parent_id = ? ORDER BY t0._pd_order ASC Parameters: [`"9077bbfc-2307-4cce-9aec-913841f156e9"`] View formatted query View runnable query Explain query 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._pd_parent_id = ? ORDER BY t0._pd_order ASC 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._pd_parent_id = '9077bbfc-2307-4cce-9aec-913841f156e9' ORDER BY t0._pd_order ASC;
29	1.00 ms	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._e_id = ? Parameters: [`"86b98c2e-a322-4339-b90c-9c368b95f486"`] View formatted query View runnable query Explain query 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._e_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._e_id = '86b98c2e-a322-4339-b90c-9c368b95f486';
30	0.84 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
31	0.82 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
32	0.95 ms	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 = ? Parameters: [`"8e4172c6-ada2-3352-a3ec-f585a3969933"`] View formatted query View runnable query Explain query 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';
33	2.59 ms	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 = ? Parameters: [`"d072d9a0-18b1-4bb5-9151-8493ba84a9f4"`] View formatted query View runnable query Explain query 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';
34	0.65 ms	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 = ? Parameters: [`"4222e472-fb23-3a8f-88a1-66770e650418"`] View formatted query View runnable query Explain query 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';
35	0.62 ms	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 = ? Parameters: [`"44c93325-6c8f-3108-b4de-23f931b48111"`] View formatted query View runnable query Explain query 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';
36	3.18 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
37	2.15 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
38	1.32 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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._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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
39	0.97 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
40	0.41 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM slug t0 WHERE t0.id = ? Parameters: [`"435211f8-91e0-49c3-8f78-9b9816066111"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM slug t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM slug t0 WHERE t0.id = '435211f8-91e0-49c3-8f78-9b9816066111';
41	4.45 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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.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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
42	1.45 ms	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 = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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._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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
43	1.07 ms	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._e_id = ? LIMIT 1 Parameters: [`"86b98c2e-a322-4339-b90c-9c368b95f486"`] View formatted query View runnable query Explain query 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._e_id = ? LIMIT 1 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._e_id = '86b98c2e-a322-4339-b90c-9c368b95f486' LIMIT 1;
44	0.99 ms	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 Parameters: [`"86b98c2e-a322-4339-b90c-9c368b95f486"`] View formatted query View runnable query Explain query 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._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 = '86b98c2e-a322-4339-b90c-9c368b95f486' ORDER BY t0._sd_order ASC, t0._sd_create_date ASC;
45	2.24 ms	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 _elements_orga_doctrine ON t0._o_id = _elements_orga_doctrine._o_id WHERE _elements_orga_doctrine._e_id = ? Parameters: [`"86b98c2e-a322-4339-b90c-9c368b95f486"`] View formatted query View runnable query Explain query 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 _elements_orga_doctrine ON t0._o_id = _elements_orga_doctrine._o_id WHERE _elements_orga_doctrine._e_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 _elements_orga_doctrine ON t0._o_id = _elements_orga_doctrine._o_id WHERE _elements_orga_doctrine._e_id = '86b98c2e-a322-4339-b90c-9c368b95f486';
46	2.04 ms	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 WHERE t0._o_id = ? Parameters: [`"030528df-19d5-4fa5-857a-502251422bdc"`] View formatted query View runnable query Explain query 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 WHERE t0._o_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 WHERE t0._o_id = '030528df-19d5-4fa5-857a-502251422bdc';
47	4.15 ms	SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ? Parameters: [`"02f69450-56de-3792-9131-b8ced37919d6"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = '02f69450-56de-3792-9131-b8ced37919d6';
48	1.05 ms	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 = ? Parameters: [`"a674d886-c373-406c-8ac7-12cc6214995f"`] View formatted query View runnable query Explain query 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._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 = 'a674d886-c373-406c-8ac7-12cc6214995f';
49	1.23 ms	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 Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9" "statement" "Fehlanzeige"`] View formatted query View runnable query Explain query 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._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 = 'fa05c9b3-2d54-4800-841b-89a94344d3d9' AND t0._e_category = 'statement' AND t0._e_title = 'Fehlanzeige' LIMIT 1;
50	0.98 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
51	2.41 ms	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_ WHERE t0_._p_id = ? LIMIT 1 Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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_ WHERE t0_._p_id = ? 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_._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_ WHERE t0_._p_id = 'fa05c9b3-2d54-4800-841b-89a94344d3d9' LIMIT 1;
52	0.93 ms	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 Parameters: [`"8e4172c6-ada2-3352-a3ec-f585a3969933"`] View formatted query View runnable query Explain query 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 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 = '8e4172c6-ada2-3352-a3ec-f585a3969933' LIMIT 1;
53	0.93 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
54	1.43 ms	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_ WHERE t0_._p_id = ? LIMIT 1 Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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_ WHERE t0_._p_id = ? 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_._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_ WHERE t0_._p_id = 'fa05c9b3-2d54-4800-841b-89a94344d3d9' LIMIT 1;
55	0.92 ms	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 Parameters: [`"8e4172c6-ada2-3352-a3ec-f585a3969933"`] View formatted query View runnable query Explain query 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 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 = '8e4172c6-ada2-3352-a3ec-f585a3969933' LIMIT 1;
56	0.96 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
57	2.18 ms	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_ WHERE t0_._p_id = ? LIMIT 1 Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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_ WHERE t0_._p_id = ? 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_._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_ WHERE t0_._p_id = 'fa05c9b3-2d54-4800-841b-89a94344d3d9' LIMIT 1;
58	0.94 ms	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 Parameters: [`"8e4172c6-ada2-3352-a3ec-f585a3969933"`] View formatted query View runnable query Explain query 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 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 = '8e4172c6-ada2-3352-a3ec-f585a3969933' LIMIT 1;
59	0.93 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
60	1.42 ms	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_ WHERE t0_._p_id = ? LIMIT 1 Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query 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_ WHERE t0_._p_id = ? 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_._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_ WHERE t0_._p_id = 'fa05c9b3-2d54-4800-841b-89a94344d3d9' LIMIT 1;
61	0.92 ms	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 Parameters: [`"8e4172c6-ada2-3352-a3ec-f585a3969933"`] View formatted query View runnable query Explain query 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 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 = '8e4172c6-ada2-3352-a3ec-f585a3969933' LIMIT 1;
62	0.93 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
63	2.65 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
64	0.94 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
65	0.94 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
66	0.41 ms	SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ? Parameters: [`"c2c5ce48-8af4-4887-aaea-bd5702496a9f"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = 'c2c5ce48-8af4-4887-aaea-bd5702496a9f';
67	0.93 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
68	0.92 ms	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 Parameters: [`"sh"`] View formatted query View runnable query Explain query 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 = 'sh' LIMIT 1;
69	3.33 ms	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 = ? Parameters: [`"d5badb1f-4690-4ac9-a8f6-de016909ef8b"`] View formatted query View runnable query Explain query 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._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 = 'd5badb1f-4690-4ac9-a8f6-de016909ef8b';
70	0.46 ms	SELECT t0_._p_short_url AS _p_short_url_0 FROM _procedure t0_ WHERE t0_._p_id = ? Parameters: [`"fa05c9b3-2d54-4800-841b-89a94344d3d9"`] View formatted query View runnable query Explain query SELECT t0_._p_short_url AS _p_short_url_0 FROM _procedure t0_ WHERE t0_._p_id = ? SELECT t0_._p_short_url AS _p_short_url_0 FROM _procedure t0_ WHERE t0_._p_id = 'fa05c9b3-2d54-4800-841b-89a94344d3d9';
71	0.49 ms	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.procedure_type_id AS procedure_type_id_5 FROM statement_form_definition t0 WHERE t0.id = ? Parameters: [`"c75a802a-43c4-4e22-82a3-d9cd9c042532"`] View formatted query View runnable query Explain query 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.procedure_type_id AS procedure_type_id_5 FROM statement_form_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.procedure_type_id AS procedure_type_id_5 FROM statement_form_definition t0 WHERE t0.id = 'c75a802a-43c4-4e22-82a3-d9cd9c042532';
72	1.13 ms	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 Parameters: [`"c75a802a-43c4-4e22-82a3-d9cd9c042532"`] View formatted query View runnable query Explain query 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.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 = 'c75a802a-43c4-4e22-82a3-d9cd9c042532' ORDER BY t0.order_number ASC;
73	0.67 ms	SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.map_hint_default AS map_hint_default_4, t0.statement_form_hint_statement AS statement_form_hint_statement_5, t0.statement_form_hint_personal_data AS statement_form_hint_personal_data_6, t0.statement_form_hint_recheck AS statement_form_hint_recheck_7, t0.statement_public_submit_confirmation_text AS statement_public_submit_confirmation_text_8, t0.procedure_id AS procedure_id_9, t0.procedure_type_id AS procedure_type_id_10 FROM procedure_ui_definition t0 WHERE t0.id = ? Parameters: [`"b90d3d05-80e7-44ef-a15c-1e607dc0f0fd"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.map_hint_default AS map_hint_default_4, t0.statement_form_hint_statement AS statement_form_hint_statement_5, t0.statement_form_hint_personal_data AS statement_form_hint_personal_data_6, t0.statement_form_hint_recheck AS statement_form_hint_recheck_7, t0.statement_public_submit_confirmation_text AS statement_public_submit_confirmation_text_8, t0.procedure_id AS procedure_id_9, t0.procedure_type_id AS procedure_type_id_10 FROM procedure_ui_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.map_hint_default AS map_hint_default_4, t0.statement_form_hint_statement AS statement_form_hint_statement_5, t0.statement_form_hint_personal_data AS statement_form_hint_personal_data_6, t0.statement_form_hint_recheck AS statement_form_hint_recheck_7, t0.statement_public_submit_confirmation_text AS statement_public_submit_confirmation_text_8, t0.procedure_id AS procedure_id_9, t0.procedure_type_id AS procedure_type_id_10 FROM procedure_ui_definition t0 WHERE t0.id = 'b90d3d05-80e7-44ef-a15c-1e607dc0f0fd';

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.

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\UserAccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\AccessControl	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\User	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Orga	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\Slug	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\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\Department	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaType	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\UserRoleInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\ParagraphVersion	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerCounty	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaStatusInCustomer	No errors.
demosplan\DemosPlanCoreBundle\Entity\Video	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\SupportContact	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTagCategory	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\MasterToeb	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Address	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\Statement\ConsultationToken	No errors.
demosplan\DemosPlanCoreBundle\Entity\StatementAttachment	No errors.
demosplan\DemosPlanCoreBundle\Entity\EntitySyncLink	No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\SingleDocumentVersion	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\StatementVote	No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Tag	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\AddressBookEntry	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\StatementFieldDefinition	No errors.
demosplan\DemosPlanCoreBundle\Entity\Flood	No errors.

install entity manager

No loaded entities.

Symfony Profiler

GET http://diplanbau-dev-debug-docker.demos-europe.eu/verfahren/fa05c9b3-2d54-4800-841b-89a94344d3d9/public/paragraph/86b98c2e-a322-4339-b90c-9c368b95f486?page=7&r_…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

dplan connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

install entity manager