Symfony Profiler

SELECT
  t0._p_id AS _p_id_1,
  t0._p_name AS _p_name_2,
  t0._p_short_url AS _p_short_url_3,
  t0._o_name AS _o_name_4,
  t0._p_desc AS _p_desc_5,
  t0._p_logo AS _p_logo_6,
  t0._p_extern_id AS _p_extern_id_7,
  t0._p_plis_id AS _p_plis_id_8,
  t0._p_closed AS _p_closed_9,
  t0._p_deleted AS _p_deleted_10,
  t0._p_master AS _p_master_11,
  t0.master_template AS master_template_12,
  t0._p_external_name AS _p_external_name_13,
  t0._p_external_desc AS _p_external_desc_14,
  t0._p_public_participation AS _p_public_participation_15,
  t0._p_public_participation_contact AS _p_public_participation_contact_16,
  t0._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_17,
  t0._p_location_name AS _p_location_name_18,
  t0._p_location_postcode AS _p_location_postcode_19,
  t0._p_municipal_code AS _p_municipal_code_20,
  t0._p_ars AS _p_ars_21,
  t0._p_created_date AS _p_created_date_22,
  t0._p_closed_date AS _p_closed_date_23,
  t0._p_deleted_date AS _p_deleted_date_24,
  t0.agency_main_email_address AS agency_main_email_address_25,
  t0.extern_id AS extern_id_26,
  t0.current_slug_id AS current_slug_id_27,
  t0._o_id AS _o_id_28,
  t0.phase_id AS phase_id_29,
  t0.public_participation_phase_id AS public_participation_phase_id_30,
  t31._ps_id AS _ps_id_32,
  t31._ps_map_extent AS _ps_map_extent_33,
  t31._ps_start_scale AS _ps_start_scale_34,
  t31._ps_available_scale AS _ps_available_scale_35,
  t31._ps_bounding_box AS _ps_bounding_box_36,
  t31._ps_information_url AS _ps_information_url_37,
  t31._ps_default_layer AS _ps_default_layer_38,
  t31._ps_territory AS _ps_territory_39,
  t31._ps_coordinate AS _ps_coordinate_40,
  t31._ps_plan_enable AS _ps_plan_enable_41,
  t31.allow_anonymous_statements AS allow_anonymous_statements_42,
  t31.expand_procedure_description AS expand_procedure_description_43,
  t31._ps_plan_text AS _ps_plan_text_44,
  t31._ps_plan_pdf AS _ps_plan_pdf_45,
  t31._ps_plan_para1_pdf AS _ps_plan_para1_pdf_46,
  t31._ps_plan_para2_pdf AS _ps_plan_para2_pdf_47,
  t31._ps_plan_draw_text AS _ps_plan_draw_text_48,
  t31._ps_plan_draw_pdf AS _ps_plan_draw_pdf_49,
  t31._ps_email_title AS _ps_email_title_50,
  t31._ps_email_text AS _ps_email_text_51,
  t31._ps_email_cc AS _ps_email_cc_52,
  t31._ps_links AS _ps_links_53,
  t31._ps_pictogram AS _ps_pictogram_54,
  t31._ps_pictogram_copyright AS _ps_pictogram_copyright_55,
  t31._ps_pictogram_alt_text AS _ps_pictogram_alt_text_56,
  t31._ps_send_mails_to_counties AS _ps_send_mails_to_counties_57,
  t31.planning_area AS planning_area_58,
  t31.scales AS scales_59,
  t31.legal_notice AS legal_notice_60,
  t31.copyright AS copyright_61,
  t31.map_hint AS map_hint_62,
  t31._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_63,
  t31._p_id AS _p_id_64,
  t0.customer AS customer_65,
  t0.procedure_type_id AS procedure_type_id_66,
  t0.statement_form_definition_id AS statement_form_definition_id_67,
  t0.procedure_behavior_definition_id AS procedure_behavior_definition_id_68,
  t0.procedure_ui_definition_id AS procedure_ui_definition_id_69
FROM
  _procedure t0
  LEFT JOIN _procedure_settings t31 ON t31._p_id = t0._p_id
WHERE
  t0._p_id = ?

SELECT t0._p_id AS _p_id_1, t0._p_name AS _p_name_2, t0._p_short_url AS _p_short_url_3, t0._o_name AS _o_name_4, t0._p_desc AS _p_desc_5, t0._p_logo AS _p_logo_6, t0._p_extern_id AS _p_extern_id_7, t0._p_plis_id AS _p_plis_id_8, t0._p_closed AS _p_closed_9, t0._p_deleted AS _p_deleted_10, t0._p_master AS _p_master_11, t0.master_template AS master_template_12, t0._p_external_name AS _p_external_name_13, t0._p_external_desc AS _p_external_desc_14, t0._p_public_participation AS _p_public_participation_15, t0._p_public_participation_contact AS _p_public_participation_contact_16, t0._p_public_participation_publication_enabled AS _p_public_participation_publication_enabled_17, t0._p_location_name AS _p_location_name_18, t0._p_location_postcode AS _p_location_postcode_19, t0._p_municipal_code AS _p_municipal_code_20, t0._p_ars AS _p_ars_21, t0._p_created_date AS _p_created_date_22, t0._p_closed_date AS _p_closed_date_23, t0._p_deleted_date AS _p_deleted_date_24, t0.agency_main_email_address AS agency_main_email_address_25, t0.extern_id AS extern_id_26, t0.current_slug_id AS current_slug_id_27, t0._o_id AS _o_id_28, t0.phase_id AS phase_id_29, t0.public_participation_phase_id AS public_participation_phase_id_30, t31._ps_id AS _ps_id_32, t31._ps_map_extent AS _ps_map_extent_33, t31._ps_start_scale AS _ps_start_scale_34, t31._ps_available_scale AS _ps_available_scale_35, t31._ps_bounding_box AS _ps_bounding_box_36, t31._ps_information_url AS _ps_information_url_37, t31._ps_default_layer AS _ps_default_layer_38, t31._ps_territory AS _ps_territory_39, t31._ps_coordinate AS _ps_coordinate_40, t31._ps_plan_enable AS _ps_plan_enable_41, t31.allow_anonymous_statements AS allow_anonymous_statements_42, t31.expand_procedure_description AS expand_procedure_description_43, t31._ps_plan_text AS _ps_plan_text_44, t31._ps_plan_pdf AS _ps_plan_pdf_45, t31._ps_plan_para1_pdf AS _ps_plan_para1_pdf_46, t31._ps_plan_para2_pdf AS _ps_plan_para2_pdf_47, t31._ps_plan_draw_text AS _ps_plan_draw_text_48, t31._ps_plan_draw_pdf AS _ps_plan_draw_pdf_49, t31._ps_email_title AS _ps_email_title_50, t31._ps_email_text AS _ps_email_text_51, t31._ps_email_cc AS _ps_email_cc_52, t31._ps_links AS _ps_links_53, t31._ps_pictogram AS _ps_pictogram_54, t31._ps_pictogram_copyright AS _ps_pictogram_copyright_55, t31._ps_pictogram_alt_text AS _ps_pictogram_alt_text_56, t31._ps_send_mails_to_counties AS _ps_send_mails_to_counties_57, t31.planning_area AS planning_area_58, t31.scales AS scales_59, t31.legal_notice AS legal_notice_60, t31.copyright AS copyright_61, t31.map_hint AS map_hint_62, t31._p_public_participation_feedback_enabled AS _p_public_participation_feedback_enabled_63, t31._p_id AS _p_id_64, t0.customer AS customer_65, t0.procedure_type_id AS procedure_type_id_66, t0.statement_form_definition_id AS statement_form_definition_id_67, t0.procedure_behavior_definition_id AS procedure_behavior_definition_id_68, t0.procedure_ui_definition_id AS procedure_ui_definition_id_69 FROM _procedure t0 LEFT JOIN _procedure_settings t31 ON t31._p_id = t0._p_id WHERE t0._p_id = 'd6dc9938-8a3d-4433-bf85-79be7485827e';

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 = '2c65f872-27cd-4e65-9ae6-acb5fffa8f70';

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 = 'd6dc9938-8a3d-4433-bf85-79be7485827e';

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._c_id AS _c_id_1,
  t0._c_name AS _c_name_2,
  t0._c_title AS _c_title_3,
  t0._c_description AS _c_description_4,
  t0._c_picture AS _c_picture_5,
  t0._c_picture_title AS _c_picture_title_6,
  t0._c_enabled AS _c_enabled_7,
  t0._c_deleted AS _c_deleted_8,
  t0._c_create_date AS _c_create_date_9,
  t0._c_modify_date AS _c_modify_date_10,
  t0._c_delete_date AS _c_delete_date_11,
  t0.custom AS custom_12
FROM
  _category t0
  INNER JOIN _platform_content_categories ON t0._c_id = _platform_content_categories._c_id
WHERE
  _platform_content_categories._pc_id = ?

SELECT t0._c_id AS _c_id_1, t0._c_name AS _c_name_2, t0._c_title AS _c_title_3, t0._c_description AS _c_description_4, t0._c_picture AS _c_picture_5, t0._c_picture_title AS _c_picture_title_6, t0._c_enabled AS _c_enabled_7, t0._c_deleted AS _c_deleted_8, t0._c_create_date AS _c_create_date_9, t0._c_modify_date AS _c_modify_date_10, t0._c_delete_date AS _c_delete_date_11, t0.custom AS custom_12 FROM _category t0 INNER JOIN _platform_content_categories ON t0._c_id = _platform_content_categories._c_id WHERE _platform_content_categories._pc_id = '6170625d-58eb-4c4a-8f3a-591e4ad0995f';

SELECT
  t0._r_id AS _r_id_1,
  t0._r_code AS _r_code_2,
  t0._r_group_code AS _r_group_code_3,
  t0._r_group_name AS _r_group_name_4
FROM
  _role t0
  INNER JOIN _platform_content_roles ON t0._r_id = _platform_content_roles._r_id
WHERE
  _platform_content_roles._pc_id = ?

SELECT t0._r_id AS _r_id_1, t0._r_code AS _r_code_2, t0._r_group_code AS _r_group_code_3, t0._r_group_name AS _r_group_name_4 FROM _role t0 INNER JOIN _platform_content_roles ON t0._r_id = _platform_content_roles._r_id WHERE _platform_content_roles._pc_id = '6170625d-58eb-4c4a-8f3a-591e4ad0995f';

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.audience AS audience_3,
  t0.permission_set AS permission_set_4,
  t0.participation_state AS participation_state_5,
  t0.closing_phase AS closing_phase_6,
  t0.order_in_audience AS order_in_audience_7,
  t0.creation_date AS creation_date_8,
  t0.modification_date AS modification_date_9,
  t0.customer_id AS customer_id_10
FROM
  procedure_phase_definition t0
WHERE
  t0.customer_id = ?
ORDER BY
  t0.audience ASC,
  t0.order_in_audience ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.audience AS audience_3, t0.permission_set AS permission_set_4, t0.participation_state AS participation_state_5, t0.closing_phase AS closing_phase_6, t0.order_in_audience AS order_in_audience_7, t0.creation_date AS creation_date_8, t0.modification_date AS modification_date_9, t0.customer_id AS customer_id_10 FROM procedure_phase_definition t0 WHERE t0.customer_id = '8e4172c6-ada2-3352-a3ec-f585a3969933' ORDER BY t0.audience ASC, t0.order_in_audience ASC;

SELECT
  t0_._pc_id AS _pc_id_0,
  t0_._pc_type AS _pc_type_1,
  t0_._pc_title AS _pc_title_2,
  t0_._pc_description AS _pc_description_3,
  t0_._pc_text AS _pc_text_4,
  t0_._pc_picture AS _pc_picture_5,
  t0_._pc_picture_title AS _pc_picture_title_6,
  t0_._pc_pdf AS _pc_pdf_7,
  t0_._pc_pdf_title AS _pc_pdf_title_8,
  t0_._pc_enabled AS _pc_enabled_9,
  t0_._pc_deleted AS _pc_deleted_10,
  t0_._pc_create_date AS _pc_create_date_11,
  t0_._pc_modify_date AS _pc_modify_date_12,
  t0_._pc_delete_date AS _pc_delete_date_13,
  t0_.customer_id AS customer_id_14
FROM
  _platform_content t0_
  INNER JOIN _platform_content_roles t2_ ON t0_._pc_id = t2_._pc_id
  INNER JOIN _role t1_ ON t1_._r_id = t2_._r_id
WHERE
  t1_._r_code IN (?)
  AND t0_._pc_deleted = ?
  AND t0_._pc_enabled = ?
  AND t0_._pc_type = ?
  AND t0_.customer_id = ?
ORDER BY
  t0_._pc_create_date DESC

SELECT t0_._pc_id AS _pc_id_0, t0_._pc_type AS _pc_type_1, t0_._pc_title AS _pc_title_2, t0_._pc_description AS _pc_description_3, t0_._pc_text AS _pc_text_4, t0_._pc_picture AS _pc_picture_5, t0_._pc_picture_title AS _pc_picture_title_6, t0_._pc_pdf AS _pc_pdf_7, t0_._pc_pdf_title AS _pc_pdf_title_8, t0_._pc_enabled AS _pc_enabled_9, t0_._pc_deleted AS _pc_deleted_10, t0_._pc_create_date AS _pc_create_date_11, t0_._pc_modify_date AS _pc_modify_date_12, t0_._pc_delete_date AS _pc_delete_date_13, t0_.customer_id AS customer_id_14 FROM _platform_content t0_ INNER JOIN _platform_content_roles t2_ ON t0_._pc_id = t2_._pc_id INNER JOIN _role t1_ ON t1_._r_id = t2_._r_id WHERE t1_._r_code IN ('RGUEST') AND t0_._pc_deleted = 0 AND t0_._pc_enabled = 1 AND t0_._pc_type = 'news' AND t0_.customer_id = '8e4172c6-ada2-3352-a3ec-f585a3969933' ORDER BY t0_._pc_create_date DESC;

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';

SELECT
  t0._mls_id AS _mls_id_1,
  t0._p_id AS _p_id_2,
  t0._mls_context AS _mls_context_3,
  t0._mls_namespace AS _mls_namespace_4,
  t0._mls_idents AS _mls_idents_5,
  t0.customer_id AS customer_id_6
FROM
  _manual_list_sort t0
WHERE
  t0._mls_context = ?
  AND t0._p_id = ?
  AND t0._mls_namespace = ?
  AND t0.customer_id = ?
LIMIT
  1

SELECT t0._mls_id AS _mls_id_1, t0._p_id AS _p_id_2, t0._mls_context AS _mls_context_3, t0._mls_namespace AS _mls_namespace_4, t0._mls_idents AS _mls_idents_5, t0.customer_id AS customer_id_6 FROM _manual_list_sort t0 WHERE t0._mls_context = 'global:news' AND t0._p_id = 'global' AND t0._mls_namespace = 'content:news' AND t0.customer_id = '8e4172c6-ada2-3352-a3ec-f585a3969933' LIMIT 1;

SELECT
  t0._s_id AS _s_id_1,
  t0._s_orga_id AS _s_orga_id_2,
  t0._s_key AS _s_key_3,
  t0._s_content AS _s_content_4,
  t0._s_create_date AS _s_create_date_5,
  t0._s_modified_date AS _s_modified_date_6,
  t0._s_procedure_id AS _s_procedure_id_7,
  t0._s_user_id AS _s_user_id_8,
  t0._s_orga_id AS _s_orga_id_9
FROM
  _settings t0
WHERE
  t0._s_key = ?
  AND t0._s_user_id = ?

SELECT t0._s_id AS _s_id_1, t0._s_orga_id AS _s_orga_id_2, t0._s_key AS _s_key_3, t0._s_content AS _s_content_4, t0._s_create_date AS _s_create_date_5, t0._s_modified_date AS _s_modified_date_6, t0._s_procedure_id AS _s_procedure_id_7, t0._s_user_id AS _s_user_id_8, t0._s_orga_id AS _s_orga_id_9 FROM _settings t0 WHERE t0._s_key = 'markedParticipated' AND t0._s_user_id = '73830656-3e48-11e4-a6a8-005056ae0004';

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

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';