Symfony Profiler

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 = 'b3ab3fc1-61a8-31c0-bda6-1dbfe425fc5f';

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

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

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 IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

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 IN ('bed4b1d0-9723-4865-8ef5-d2cee34040da', 'f9b0d3c3-e4fd-4700-92fa-379b64a5dc88', 'eb4d9af3-2611-4790-be8d-48bed63fd992', 'ec240703-6cd6-4baf-bca8-61b6a73ef9fc', 'b5564b21-2f0b-4dd1-afa3-2f7557d7f1ab', 'e3621ab9-75d3-4a20-93cb-eb693ccf9563', 'a4a7abd6-d4f4-4a12-92fc-bdaea416cbc9', 'a523eaeb-339f-4871-a5b3-405204ebad15', 'b795d4f2-7422-464d-9000-320d3e189582', 'be000408-a96d-489c-bf5c-6f2eb44d655b', 'f000b7e3-1a72-4930-9c07-388164014a4e', 'a977d433-43d8-4d9c-b062-6d574ad2fe6a', 'da358a01-a918-4e9e-853c-4308e948ef53', 'a0ade7cb-7d4c-4fb1-847d-9cb018ac16e7', 'ec4a8417-bf5b-47bf-98b7-a8b9f1a37854', 'dd3fdc38-0a40-44ae-a946-148a0a90ce24', 'bab08fff-3cc6-488c-852d-e961563501a8', 'cb191a45-a569-4dcd-bd92-d836085b7070', 'da456ea9-022c-453f-9f82-0c447a19e9f8', 'eff667f5-a8e0-45f7-87cb-4debf6723e81', 'f5e2f23c-05e3-4b40-88bc-e123d9ce4556', 'e6225547-0f74-4c84-af92-29d1b50cdb18', 'd2d524d7-9a40-4c04-a1d7-0892c2d3bb81', 'b611b6cf-969b-47a1-83b8-7facb88cff05', 'f2047d2f-c7e0-43ad-83ae-371be62662ef', 'c46858b0-0bf1-4374-82ab-e8636912db7a', 'dac184a6-d64d-429a-beab-5916c927692c', 'a4a3b312-ada3-4f59-bcbf-3c49bfec84fd', 'bcdac5f7-655b-4fc6-9663-e0d2783c8568', 'febb7c9c-a914-493c-8d9c-e3b56b8be88e', 'f48ad3b9-6763-4ab6-8fbc-aad1e39b500b', 'c7817ff2-c843-4483-bf80-34af2acf0880', 'cbae12aa-95aa-4c2a-a4df-248e7c915ebb', 'e930813d-7097-450e-9991-2fe177dd7e66', 'de11c672-6b2d-42f6-80a6-73eba889c2c3', 'e1403398-b66d-4075-85e1-6d78da19a0e5', 'd4132105-3756-4566-b159-12b94582c99a', 'f1354f63-afd3-41ae-b8dc-d3bab807e014', 'e397d83c-2370-4dc4-9e4b-506ecf38c2cc', 'c8ef0387-da42-4900-87f0-75550da89081', 'df844016-6d38-4914-8154-fb858cbf557f', 'a0e28a53-c279-4d21-b3dd-d17d8f2d4e88', 'fe201206-da75-4b9a-be6d-c72320815057', 'c82c016e-3ff8-4f8a-a15f-df0e2b17db3c', 'ebf4793a-8541-4dcf-bdad-aef16a4f2ccc', 'f05af2ec-eeb2-49b7-a4d7-c766b8d7a68c', 'c8663737-13e5-4435-815f-ad8063996177', 'c85b2fb3-4a66-4f99-b927-6801dee74e02', 'b4a16551-2973-4e0d-8b28-973a342181ed', 'd9c4cf99-536e-4a93-929d-d6cc0a40807a', 'b4ceef15-338d-43c5-a3ea-a2c4c374e4c6', 'cd6c7afd-dddd-4b0e-8298-39f05b092df9', 'a21ef72a-d369-4452-b883-75d500711f03', 'b3394483-da00-43c7-966a-6becfa4f2818', 'b98cd7c1-a0c6-4533-bd63-98290f32d747', 'd1fa58cc-be65-441e-96be-675728e41d7a', 'bc228a1a-dbd5-41b1-96ac-57fe126f09e4', 'ece8cadb-da5e-4728-9291-64de67dd8a12', 'bc3bdc71-045b-49d9-a3a2-c007c35d5220', 'd21342b4-cec4-4eb4-846b-cb464c7ab1ba', 'c2b79c2d-bdc9-4ab8-b8bb-d14b375e7cef', 'db28119b-bcf7-4f69-bc41-1ce6c45fb5b2', 'fc45a400-f38d-4a26-b8f3-4a82f3100f3d', 'fdcbdf86-59e4-4ea3-9ab9-4b3ad07b54bd', 'cfbb2a20-074a-43b3-8f96-509d0e203752', 'bbc953f1-080a-4262-a2b2-a8c98789033d', 'f5fcac06-2d50-4e10-b994-86c7c6053fba', 'beda94fa-f38c-46e3-842b-9a5e1e708775', 'c24224d1-ef58-4dc7-a8ee-3a741a70b63c', 'ea413402-4332-4ee8-a4f4-dfe74e6fa411', 'e4d13134-66cc-4a87-a6be-71c0a4809b3d', 'c110581c-2ca3-4ad3-8063-ba7b2d2a9201', 'c8d85328-d671-48ac-8081-367764125683', 'e2d2f072-362b-4f1f-95ea-7cb56d3b59ef', 'ddeb316e-e8e5-4142-b092-92b15b0d9c02', 'eaaa08f3-6764-45d5-9ffc-9c31b1fccdc0', 'b5ef4138-ea13-4185-8c8b-afb326acf394', 'a5498dee-b665-4ae6-9fc1-6dbf02b6b60e', 'b8cce85e-1df2-46a0-b93b-23e06db9b4a3', 'dcab7e6a-f3b6-4483-a7e2-ebde0ae0dfd0', 'b015d73c-736c-4ce7-9984-dfb79d14922d', 'a6fb053e-462e-4fdf-9856-9806afd15ea7', 'c17f6e8b-291c-4f7e-9ca2-45cafc46c9b0', 'bfcdba2e-291e-41ce-a9b3-06d82b66b22e', 'd7204687-5243-4bc4-a4df-9f21cc6078b5', 'b32725bb-c179-42a3-9f51-7af7b9a150b4', 'e3604205-c211-476e-ad60-0bbe2eb316f9', 'c341a3f5-0ea8-4798-ba34-df5dd0d569cf', 'ce68ee35-49c5-4eda-98b5-22f27f358e50', 'e5030030-bb3e-4a46-ae90-3ef4dbeea5c3', 'f01b31a1-4762-11ea-92dd-782bcb0d78b1', 'bb8458ab-9f21-4183-b6c8-086196129b3d', 'db1f7edc-39b9-4551-bec2-5b4fa8e9a8f2', 'c0a6e1c9-b902-48d9-8683-019645dc22e6', 'e0baa3dc-013e-4f70-884a-f819f6dffa8d', 'de520a1d-b968-4740-bb1d-9a4477136d24', 'b0030912-f7d1-4556-a9e3-b89173530033', 'fbf3c9cd-d93b-4968-9ad3-0c09e69d5af0', 'cb054d0b-60cb-44cc-ba98-21e439141aff', 'ad802a1d-2c49-49ec-acd8-65ab7ae6d04e', 'b36e7010-ebef-4c4b-9cff-db08dec2467c', 'f0a588c5-2d0b-41e8-96cf-7678b7e20b08', 'eec1f762-18e9-41a8-96ae-209008a63caa', 'd3f72273-3e63-419d-92de-771a1f0602e9', 'a273e3fb-53e4-4afc-b9e0-9857bf85711b', 'a15a0de6-27f8-459b-b97c-27e316bcf3a3', 'c078b3d6-e7e1-48e3-a91b-3f12068c1d22', 'ae63fcf0-229f-481c-9814-14091e254645', 'd1f87cdc-8445-4f4f-be97-fd12553955be', 'aa7210f2-12e0-4e86-a1ef-344dd32b736b', 'dea53f80-5712-11eb-b869-b026282c0641', 'f5429cbb-2e28-11eb-99a9-b026282c0641', '68ee6187-b9ff-11ea-bcda-782bcb0d78b1', '69dce31a-9e5b-11ea-bb8f-782bcb0d78b1', 'dac28fea-4807-11ea-92dd-782bcb0d78b1', '227d3910-3933-11ea-bb74-782bcb0d78b1', '0109ecb6-0e77-11e9-94fb-782bcb0d78b1', '7cfe15ff-1614-11e7-a6ce-005056ae0004', 'c09f7c7d-bd56-11e6-b9ca-005056ae0004', '24265982-5242-435d-a4e4-d28f4ef27adf', '872643fc-d37a-4dba-b4cc-ede16e320e59', '42a5cab5-764d-4fe6-a0a8-e22e9cbd9106', '104a3545-db92-4154-a92c-b86e2bf60994');

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 = 'blp-dev-debug' LIMIT 1;

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_._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');