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
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.type AS type_2,
  f0_.create_date AS create_date_3,
  f0_.modify_date AS modify_date_4,
  f0_.customer_id AS customer_id_5
FROM
  faq_category f0_
WHERE
  f0_.customer_id = ?
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.type AS type_2, f0_.create_date AS create_date_3, f0_.modify_date AS modify_date_4, f0_.customer_id AS customer_id_5 FROM faq_category f0_ WHERE f0_.customer_id = 'fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c' ORDER BY f0_.title ASC;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'd0fca1d2-aa32-493b-ab80-61eff56b207d' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = '' AND t0._p_id = 'global' AND t0._mls_namespace = '' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = '95dd55d5-422d-4b48-b30b-ab04a989edfc' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = 'faq:category:95dd55d5-422d-4b48-b30b-ab04a989edfc' AND t0._p_id = 'global' AND t0._mls_namespace = 'faq' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = '8a4e9199-fa57-4bed-9d80-b7945bc76ca8' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = 'faq:category:8a4e9199-fa57-4bed-9d80-b7945bc76ca8' AND t0._p_id = 'global' AND t0._mls_namespace = 'faq' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = '9f74fa24-f96f-47a2-b8f6-8de68db6676d' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = 'faq:category:9f74fa24-f96f-47a2-b8f6-8de68db6676d' AND t0._p_id = 'global' AND t0._mls_namespace = 'faq' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'e32661d8-5424-45d8-8907-c45d2cf97cfd' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = 'faq:category:e32661d8-5424-45d8-8907-c45d2cf97cfd' AND t0._p_id = 'global' AND t0._mls_namespace = 'faq' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = '03d0f3a0-f0f0-405d-988b-a1370caada0c' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = '' AND t0._p_id = 'global' AND t0._mls_namespace = '' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'bb67f735-2928-420d-8c9d-5cce493fbc35' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = 'faq:category:bb67f735-2928-420d-8c9d-5cce493fbc35' AND t0._p_id = 'global' AND t0._mls_namespace = 'faq' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'a582ad87-be74-4160-b019-200dfc357f3f' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = '' AND t0._p_id = 'global' AND t0._mls_namespace = '' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'a039ec34-b358-403f-b35b-33cecf640170' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = '' AND t0._p_id = 'global' AND t0._mls_namespace = '' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'e388d6ad-ff1f-4a79-975a-c1f30635d75a' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = 'faq:category:e388d6ad-ff1f-4a79-975a-c1f30635d75a' AND t0._p_id = 'global' AND t0._mls_namespace = 'faq' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = '867c32eb-a1fe-4407-96a4-26eef4e43745' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;

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 IS NULL
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 = '' AND t0._p_id = 'global' AND t0._mls_namespace = '' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.text AS text_2,
  f0_.enabled AS enabled_3,
  f0_.create_date AS create_date_4,
  f0_.modify_date AS modify_date_5,
  f0_.faq_category_id AS faq_category_id_6
FROM
  faq f0_
  LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id
  LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id
  LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id
WHERE
  f0_.enabled = ?
  AND f1_.id = ?
  AND t2_._r_code IN (?)
ORDER BY
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = 1 AND f1_.id = 'c3d711fc-cdd0-42fe-9dcd-77d5bfa276c8' AND t2_._r_code IN ('RGUEST') ORDER BY f0_.title ASC;