Symfony Profiler

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

SELECT t0_._p_id AS _p_id_0, t0_._p_name AS _p_name_1, t0_._p_short_url AS _p_short_url_2, t0_._o_name AS _o_name_3, t0_._p_desc AS _p_desc_4, t0_._p_logo AS _p_logo_5, t0_._p_extern_id AS _p_extern_id_6, t0_._p_plis_id AS _p_plis_id_7, t0_._p_closed AS _p_closed_8, t0_._p_deleted AS _p_deleted_9, t0_._p_master AS _p_master_10, t0_.master_template AS master_template_11, t0_._p_external_name AS _p_external_name_12, t0_._p_external_desc AS _p_external_desc_13, t0_._p_public_participation AS _p_public_participation_14, t0_._p_public_participation_contact AS _p_public_participation_contact_15, t0_._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_16, t0_._p_location_name AS _p_location_name_17, t0_._p_location_postcode AS _p_location_postcode_18, t0_._p_municipal_code AS _p_municipal_code_19, t0_._p_ars AS _p_ars_20, t0_._p_created_date AS _p_created_date_21, t0_._p_closed_date AS _p_closed_date_22, t0_._p_deleted_date AS _p_deleted_date_23, t0_.agency_main_email_address AS agency_main_email_address_24, t0_.extern_id AS extern_id_25, t0_.current_slug_id AS current_slug_id_26, t0_._o_id AS _o_id_27, t0_.phase_id AS phase_id_28, t0_.public_participation_phase_id AS public_participation_phase_id_29, t0_.customer AS customer_30, t0_.procedure_type_id AS procedure_type_id_31, t0_.statement_form_definition_id AS statement_form_definition_id_32, t0_.procedure_behavior_definition_id AS procedure_behavior_definition_id_33, t0_.procedure_ui_definition_id AS procedure_ui_definition_id_34 FROM _procedure t0_ INNER JOIN procedure_slug p2_ ON t0_._p_id = p2_.p_id INNER JOIN slug s1_ ON s1_.id = p2_.s_id WHERE s1_.name = 'e84cf07e-8fcb-461f-a742-84519db586b0333';

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.allow_uninvited_institutions AS allow_uninvited_institutions_13,
  t0._ps_plan_text AS _ps_plan_text_14,
  t0._ps_plan_pdf AS _ps_plan_pdf_15,
  t0._ps_plan_para1_pdf AS _ps_plan_para1_pdf_16,
  t0._ps_plan_para2_pdf AS _ps_plan_para2_pdf_17,
  t0._ps_plan_draw_text AS _ps_plan_draw_text_18,
  t0._ps_plan_draw_pdf AS _ps_plan_draw_pdf_19,
  t0._ps_email_title AS _ps_email_title_20,
  t0._ps_email_text AS _ps_email_text_21,
  t0._ps_email_cc AS _ps_email_cc_22,
  t0._ps_links AS _ps_links_23,
  t0._ps_pictogram AS _ps_pictogram_24,
  t0._ps_pictogram_copyright AS _ps_pictogram_copyright_25,
  t0._ps_pictogram_alt_text AS _ps_pictogram_alt_text_26,
  t0._ps_send_mails_to_counties AS _ps_send_mails_to_counties_27,
  t0.planning_area AS planning_area_28,
  t0.scales AS scales_29,
  t0.legal_notice AS legal_notice_30,
  t0.copyright AS copyright_31,
  t0.map_hint AS map_hint_32,
  t0._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_33,
  t0._p_id AS _p_id_34
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.allow_uninvited_institutions AS allow_uninvited_institutions_13, t0._ps_plan_text AS _ps_plan_text_14, t0._ps_plan_pdf AS _ps_plan_pdf_15, t0._ps_plan_para1_pdf AS _ps_plan_para1_pdf_16, t0._ps_plan_para2_pdf AS _ps_plan_para2_pdf_17, t0._ps_plan_draw_text AS _ps_plan_draw_text_18, t0._ps_plan_draw_pdf AS _ps_plan_draw_pdf_19, t0._ps_email_title AS _ps_email_title_20, t0._ps_email_text AS _ps_email_text_21, t0._ps_email_cc AS _ps_email_cc_22, t0._ps_links AS _ps_links_23, t0._ps_pictogram AS _ps_pictogram_24, t0._ps_pictogram_copyright AS _ps_pictogram_copyright_25, t0._ps_pictogram_alt_text AS _ps_pictogram_alt_text_26, t0._ps_send_mails_to_counties AS _ps_send_mails_to_counties_27, t0.planning_area AS planning_area_28, t0.scales AS scales_29, t0.legal_notice AS legal_notice_30, t0.copyright AS copyright_31, t0.map_hint AS map_hint_32, t0._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_33, t0._p_id AS _p_id_34 FROM _procedure_settings t0 WHERE t0._p_id = 'e84cf07e-8fcb-461f-a742-84519db586b0';

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

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

SELECT
  t0_._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 = 'e84cf07e-8fcb-461f-a742-84519db586b0';

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

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

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

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

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

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.creation_date AS creation_date_4, t0.modification_date AS modification_date_5, t0.designated_phase AS designated_phase_6, t0.designated_switch_date AS designated_switch_date_7, t0.designated_switch_date_timestamp AS designated_switch_date_timestamp_8, t0.designated_end_date AS designated_end_date_9, t0.iteration AS iteration_10, t0.step AS step_11, t0.phase_key AS phase_key_12, t0.phase_definition_id AS phase_definition_id_13, t0.designated_phase_definition_id AS designated_phase_definition_id_14, t0.designated_phase_change_user_id AS designated_phase_change_user_id_15 FROM procedure_phase t0 WHERE t0.id = '8ed23058-73e3-4170-a570-50f098b31673';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.audience AS audience_3,
  t0.permission_set AS permission_set_4,
  t0.participation_state AS participation_state_5,
  t0.closing_phase AS closing_phase_6,
  t0.is_deleted AS is_deleted_7,
  t0.order_in_audience AS order_in_audience_8,
  t0.creation_date AS creation_date_9,
  t0.modification_date AS modification_date_10,
  t0.deleted_date AS deleted_date_11,
  t0.customer_id AS customer_id_12
FROM
  procedure_phase_definition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.audience AS audience_3, t0.permission_set AS permission_set_4, t0.participation_state AS participation_state_5, t0.closing_phase AS closing_phase_6, t0.is_deleted AS is_deleted_7, t0.order_in_audience AS order_in_audience_8, t0.creation_date AS creation_date_9, t0.modification_date AS modification_date_10, t0.deleted_date AS deleted_date_11, t0.customer_id AS customer_id_12 FROM procedure_phase_definition t0 WHERE t0.id = '6a0e5cfb-5926-11f1-9719-b026282c0641';

SELECT
  t0.id AS id_1,
  t0.creation_date AS creation_date_2,
  t0.modification_date AS modification_date_3,
  t0.procedure_id AS procedure_id_4,
  t0.allowed_to_enable_map AS allowed_to_enable_map_5,
  t0.has_priority_area AS has_priority_area_6,
  t0.participation_guest_only AS participation_guest_only_7,
  t8._p_id AS _p_id_9,
  t8._p_name AS _p_name_10,
  t8._p_short_url AS _p_short_url_11,
  t8._o_name AS _o_name_12,
  t8._p_desc AS _p_desc_13,
  t8._p_logo AS _p_logo_14,
  t8._p_extern_id AS _p_extern_id_15,
  t8._p_plis_id AS _p_plis_id_16,
  t8._p_closed AS _p_closed_17,
  t8._p_deleted AS _p_deleted_18,
  t8._p_master AS _p_master_19,
  t8.master_template AS master_template_20,
  t8._p_external_name AS _p_external_name_21,
  t8._p_external_desc AS _p_external_desc_22,
  t8._p_public_participation AS _p_public_participation_23,
  t8._p_public_participation_contact AS _p_public_participation_contact_24,
  t8._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_25,
  t8._p_location_name AS _p_location_name_26,
  t8._p_location_postcode AS _p_location_postcode_27,
  t8._p_municipal_code AS _p_municipal_code_28,
  t8._p_ars AS _p_ars_29,
  t8._p_created_date AS _p_created_date_30,
  t8._p_closed_date AS _p_closed_date_31,
  t8._p_deleted_date AS _p_deleted_date_32,
  t8.agency_main_email_address AS agency_main_email_address_33,
  t8.extern_id AS extern_id_34,
  t8.current_slug_id AS current_slug_id_35,
  t8._o_id AS _o_id_36,
  t8.phase_id AS phase_id_37,
  t8.public_participation_phase_id AS public_participation_phase_id_38,
  t8.customer AS customer_39,
  t8.procedure_type_id AS procedure_type_id_40,
  t8.statement_form_definition_id AS statement_form_definition_id_41,
  t8.procedure_behavior_definition_id AS procedure_behavior_definition_id_42,
  t8.procedure_ui_definition_id AS procedure_ui_definition_id_43,
  t44.id AS id_45,
  t44.creation_date AS creation_date_46,
  t44.modification_date AS modification_date_47,
  t44.name AS name_48,
  t44.description AS description_49,
  t44.statement_form_definition_id AS statement_form_definition_id_50,
  t44.procedure_behavior_definition_id AS procedure_behavior_definition_id_51,
  t44.procedure_ui_definition_id AS procedure_ui_definition_id_52
FROM
  procedure_behavior_definition t0
  LEFT JOIN _procedure t8 ON t8.procedure_behavior_definition_id = t0.id
  LEFT JOIN procedure_type t44 ON t44.procedure_behavior_definition_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.modification_date AS modification_date_3, t0.procedure_id AS procedure_id_4, t0.allowed_to_enable_map AS allowed_to_enable_map_5, t0.has_priority_area AS has_priority_area_6, t0.participation_guest_only AS participation_guest_only_7, t8._p_id AS _p_id_9, t8._p_name AS _p_name_10, t8._p_short_url AS _p_short_url_11, t8._o_name AS _o_name_12, t8._p_desc AS _p_desc_13, t8._p_logo AS _p_logo_14, t8._p_extern_id AS _p_extern_id_15, t8._p_plis_id AS _p_plis_id_16, t8._p_closed AS _p_closed_17, t8._p_deleted AS _p_deleted_18, t8._p_master AS _p_master_19, t8.master_template AS master_template_20, t8._p_external_name AS _p_external_name_21, t8._p_external_desc AS _p_external_desc_22, t8._p_public_participation AS _p_public_participation_23, t8._p_public_participation_contact AS _p_public_participation_contact_24, t8._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_25, t8._p_location_name AS _p_location_name_26, t8._p_location_postcode AS _p_location_postcode_27, t8._p_municipal_code AS _p_municipal_code_28, t8._p_ars AS _p_ars_29, t8._p_created_date AS _p_created_date_30, t8._p_closed_date AS _p_closed_date_31, t8._p_deleted_date AS _p_deleted_date_32, t8.agency_main_email_address AS agency_main_email_address_33, t8.extern_id AS extern_id_34, t8.current_slug_id AS current_slug_id_35, t8._o_id AS _o_id_36, t8.phase_id AS phase_id_37, t8.public_participation_phase_id AS public_participation_phase_id_38, t8.customer AS customer_39, t8.procedure_type_id AS procedure_type_id_40, t8.statement_form_definition_id AS statement_form_definition_id_41, t8.procedure_behavior_definition_id AS procedure_behavior_definition_id_42, t8.procedure_ui_definition_id AS procedure_ui_definition_id_43, t44.id AS id_45, t44.creation_date AS creation_date_46, t44.modification_date AS modification_date_47, t44.name AS name_48, t44.description AS description_49, t44.statement_form_definition_id AS statement_form_definition_id_50, t44.procedure_behavior_definition_id AS procedure_behavior_definition_id_51, t44.procedure_ui_definition_id AS procedure_ui_definition_id_52 FROM procedure_behavior_definition t0 LEFT JOIN _procedure t8 ON t8.procedure_behavior_definition_id = t0.id LEFT JOIN procedure_type t44 ON t44.procedure_behavior_definition_id = t0.id WHERE t0.id = '9301e4ec-3672-4be0-9b42-c9207d6e62b2';

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 = '3c49c37c-cb5d-4e85-bac6-7104e6555bb0' LIMIT 1;

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 = 'e84cf07e-8fcb-461f-a742-84519db586b0' AND t0._e_id = '3c49c37c-cb5d-4e85-bac6-7104e6555bb0' AND t0._pd_visible IN (1, 2) AND t0._pd_deleted = 0 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 = '27491d4d-5e3b-4aa2-a4b0-67d24d63bdbb' 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 = '02a1f1f9-a5af-4a07-b801-fb1ce90e3b23' 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 = 'a6b47114-f0bc-4c11-90d0-f2b2f7d84a63' ORDER BY t0._pd_order ASC;