Symfony Profiler

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_._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._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 = 'mv' 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.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.customer_id = ?
  AND t0.is_deleted = ?
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.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.customer_id = 'fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c' AND t0.is_deleted = 0 ORDER BY t0.audience ASC, t0.order_in_audience ASC;

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 = 'mv' 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.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.customer_id = ?
  AND t0.is_deleted = ?
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.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.customer_id = 'fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c' AND t0.is_deleted = 0 ORDER BY t0.audience ASC, t0.order_in_audience ASC;

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 = 'mv' LIMIT 1;

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 = 'fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c' ORDER BY t0_._pc_create_date DESC;

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 = '4b9f78a0-7689-11ef-9b51-b026282c0641';

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 = '4b9f78a0-7689-11ef-9b51-b026282c0641';

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 = '4ba31042-7689-11ef-9b51-b026282c0641';

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 = '4ba31042-7689-11ef-9b51-b026282c0641';

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 = '4ba6e706-7689-11ef-9b51-b026282c0641';

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 = '4ba6e706-7689-11ef-9b51-b026282c0641';

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 = '4bae019a-7689-11ef-9b51-b026282c0641';

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 = '4bae019a-7689-11ef-9b51-b026282c0641';

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 = '4b487d4b-7689-11ef-9b51-b026282c0641';

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 = '4b487d4b-7689-11ef-9b51-b026282c0641';

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 = '4b4c2017-7689-11ef-9b51-b026282c0641';