Symfony Profiler

Query Metrics

71 Database Queries

32 Different statements

246.20 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._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.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._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

#▲	Time	Info
1	12.75 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
2	6.64 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
3	11.18 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: [`"40e7c2db-0a92-37ce-8a38-bc065334bdb2"`] 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 = '40e7c2db-0a92-37ce-8a38-bc065334bdb2';
4	3.41 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: [`"7fe72f15-9d7f-3172-bcfb-01cf53eaeb12"`] 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 = '7fe72f15-9d7f-3172-bcfb-01cf53eaeb12';
5	3.58 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	7.54 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	1.86 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.58 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: [`"74aefbd3-25f9-3903-8e4b-6b0700470749"`] 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 = '74aefbd3-25f9-3903-8e4b-6b0700470749';
9	13.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._p_id = ? AND t0._e_id = ? AND t0._pd_visible IN (?, ?) AND t0._pd_deleted = ? ORDER BY t0._pd_order ASC Parameters: [`"84d23daa-481d-4a01-8582-614b15e170b0" "17b2b555-f39c-4c60-8a24-b57d79923763" 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 = '84d23daa-481d-4a01-8582-614b15e170b0' AND t0._e_id = '17b2b555-f39c-4c60-8a24-b57d79923763' AND t0._pd_visible IN (1, 2) AND t0._pd_deleted = 0 ORDER BY t0._pd_order ASC;
10	16.85 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: [`"ee375466-d3e0-4c1b-91b0-cc697ec2b472"`] 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 = 'ee375466-d3e0-4c1b-91b0-cc697ec2b472' ORDER BY t0._pd_order ASC;
11	4.43 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: [`"685e102f-55b7-4a2a-9ec9-33a4e89e12a5"`] 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 = '685e102f-55b7-4a2a-9ec9-33a4e89e12a5' ORDER BY t0._pd_order ASC;
12	1.43 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: [`"28a74c84-9d4a-4b95-8e7e-d45f022e83de"`] 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 = '28a74c84-9d4a-4b95-8e7e-d45f022e83de' ORDER BY t0._pd_order ASC;
13	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: [`"052c2105-6dc7-4359-b280-6cc0dd000874"`] 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 = '052c2105-6dc7-4359-b280-6cc0dd000874' ORDER BY t0._pd_order ASC;
14	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: [`"4e508b51-db12-41e0-ad7e-83d27dc5a028"`] 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 = '4e508b51-db12-41e0-ad7e-83d27dc5a028' ORDER BY t0._pd_order ASC;
15	0.98 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: [`"ce86bb75-08cb-4e65-840f-1ea6fad555e5"`] 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 = 'ce86bb75-08cb-4e65-840f-1ea6fad555e5' ORDER BY t0._pd_order ASC;
16	1.53 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: [`"4faf914d-edf8-487f-aa29-af2a7ff3de43"`] 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 = '4faf914d-edf8-487f-aa29-af2a7ff3de43' ORDER BY t0._pd_order ASC;
17	0.92 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: [`"7096ec9e-b51c-4265-a2da-b1db9dfb864c"`] 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 = '7096ec9e-b51c-4265-a2da-b1db9dfb864c' ORDER BY t0._pd_order ASC;
18	8.10 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: [`"09b7287b-5056-4115-9af8-b8cddfc81706"`] 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 = '09b7287b-5056-4115-9af8-b8cddfc81706' ORDER BY t0._pd_order ASC;
19	4.47 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: [`"39f710b3-ce33-488f-aa0e-7af392cd1f39"`] 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 = '39f710b3-ce33-488f-aa0e-7af392cd1f39' ORDER BY t0._pd_order ASC;
20	4.17 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: [`"58979f7a-b1e4-4b9d-9196-6c4019ade926"`] 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 = '58979f7a-b1e4-4b9d-9196-6c4019ade926' ORDER BY t0._pd_order ASC;
21	1.44 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: [`"895a4670-7e80-43b8-92a7-b73d54078286"`] 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 = '895a4670-7e80-43b8-92a7-b73d54078286' ORDER BY t0._pd_order ASC;
22	0.97 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: [`"412e0099-0d0f-4649-a13e-b72ee95206db"`] 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 = '412e0099-0d0f-4649-a13e-b72ee95206db' ORDER BY t0._pd_order ASC;
23	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: [`"5114f7b4-80f3-44d2-b1e3-6ecd04e50e4e"`] 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 = '5114f7b4-80f3-44d2-b1e3-6ecd04e50e4e' ORDER BY t0._pd_order ASC;
24	0.89 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: [`"254b6354-f600-44a2-bdd5-f95936098ac3"`] 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 = '254b6354-f600-44a2-bdd5-f95936098ac3' ORDER BY t0._pd_order ASC;
25	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: [`"1e0e46f9-0ba6-4a6e-9279-d2c37f33a689"`] 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 = '1e0e46f9-0ba6-4a6e-9279-d2c37f33a689' ORDER BY t0._pd_order ASC;
26	7.77 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: [`"1ab0429d-acf0-4f51-919c-4071e5e12267"`] 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 = '1ab0429d-acf0-4f51-919c-4071e5e12267' ORDER BY t0._pd_order ASC;
27	2.71 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: [`"ddc94cd8-de69-4291-991b-6fcef37ee74c"`] 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 = 'ddc94cd8-de69-4291-991b-6fcef37ee74c' ORDER BY t0._pd_order ASC;
28	1.03 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: [`"085a28bd-4367-4705-9d37-8bd3ff7b7a19"`] 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 = '085a28bd-4367-4705-9d37-8bd3ff7b7a19' ORDER BY t0._pd_order ASC;
29	1.06 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: [`"1093c31c-35b0-440d-bc66-8ff3d90c54ec"`] 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 = '1093c31c-35b0-440d-bc66-8ff3d90c54ec' ORDER BY t0._pd_order ASC;
30	0.96 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: [`"10a0b1a6-3633-427a-9e60-8d0c6a769e06"`] 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 = '10a0b1a6-3633-427a-9e60-8d0c6a769e06' ORDER BY t0._pd_order ASC;
31	0.97 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: [`"17b2b555-f39c-4c60-8a24-b57d79923763"`] 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 = '17b2b555-f39c-4c60-8a24-b57d79923763';
32	0.91 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
33	0.80 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
34	1.08 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';
35	2.77 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';
36	11.45 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';
37	0.63 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';
38	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 procedure_planningoffices ON t0._o_id = procedure_planningoffices._o_id WHERE procedure_planningoffices._p_id = ? Parameters: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
39	3.90 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
40	3.67 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
41	3.76 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM slug t0 WHERE t0.id = ? Parameters: [`"717bf89f-1fea-3856-bca7-5a3ff7330f7c"`] 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 = '717bf89f-1fea-3856-bca7-5a3ff7330f7c';
42	0.81 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
43	1.50 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
44	1.48 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: [`"17b2b555-f39c-4c60-8a24-b57d79923763"`] 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 = '17b2b555-f39c-4c60-8a24-b57d79923763' LIMIT 1;
45	1.93 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: [`"17b2b555-f39c-4c60-8a24-b57d79923763"`] 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 = '17b2b555-f39c-4c60-8a24-b57d79923763' ORDER BY t0._sd_order ASC, t0._sd_create_date ASC;
46	9.22 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: [`"17b2b555-f39c-4c60-8a24-b57d79923763"`] 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 = '17b2b555-f39c-4c60-8a24-b57d79923763';
47	3.80 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: [`"33ccb0a5-7cc3-48dc-aa5b-8f4bf87dcb71"`] 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 = '33ccb0a5-7cc3-48dc-aa5b-8f4bf87dcb71';
48	1.93 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: [`"84d23daa-481d-4a01-8582-614b15e170b0" "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 = '84d23daa-481d-4a01-8582-614b15e170b0' AND t0._e_category = 'statement' AND t0._e_title = 'Fehlanzeige' LIMIT 1;
49	2.49 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;
50	3.84 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0' LIMIT 1;
51	2.55 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;
52	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;
53	7.20 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0' LIMIT 1;
54	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;
55	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;
56	1.46 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0' LIMIT 1;
57	1.76 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;
58	4.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;
59	1.44 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: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0' LIMIT 1;
60	2.49 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;
61	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;
62	4.22 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	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;
64	8.43 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.59 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';
66	4.45 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;
67	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;
68	1.06 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';
69	12.39 ms	SELECT t0_._p_short_url AS _p_short_url_0 FROM _procedure t0_ WHERE t0_._p_id = ? Parameters: [`"84d23daa-481d-4a01-8582-614b15e170b0"`] 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 = '84d23daa-481d-4a01-8582-614b15e170b0';
70	3.22 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: [`"429a73d7-7ed8-33ec-8df6-46087cafaf35"`] 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 = '429a73d7-7ed8-33ec-8df6-46087cafaf35';
71	1.18 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: [`"429a73d7-7ed8-33ec-8df6-46087cafaf35"`] 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 = '429a73d7-7ed8-33ec-8df6-46087cafaf35' ORDER BY t0.order_number ASC;

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\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\Address	No errors.
demosplan\DemosPlanCoreBundle\Entity\User\AddressBookEntry	No errors.
demosplan\DemosPlanCoreBundle\Entity\Procedure\StatementFieldDefinition	No errors.

install entity manager

No loaded entities.

Symfony Profiler

GET http://diplanbau-dev-debug-docker.demos-europe.eu/verfahren/84d23daa-481d-4a01-8582-614b15e170b0/public/paragraph/17b2b555-f39c-4c60-8a24-b57d79923763?page=6&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