Symfony Profiler

PRAGMA foreign_keys = ON;

PRAGMA foreign_keys = ON;;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.template AS template_5,
  t0.map_engine_code AS map_engine_code_6,
  t0.persistent_view AS persistent_view_7,
  t0.splashscreen AS splashscreen_8,
  t0.screenshot AS screenshot_9,
  t0.extra_assets AS extra_assets_10,
  t0.updated AS updated_11,
  t0.custom_css AS custom_css_12
FROM
  mb_core_application t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.template AS template_5, t0.map_engine_code AS map_engine_code_6, t0.persistent_view AS persistent_view_7, t0.splashscreen AS splashscreen_8, t0.screenshot AS screenshot_9, t0.extra_assets AS extra_assets_10, t0.updated AS updated_11, t0.custom_css AS custom_css_12 FROM mb_core_application t0 WHERE t0.slug = 'mapbender_user_basic_yml' LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.subject_domain AS subject_domain_1,
  f0_.subject AS subject_2,
  f0_.resource_domain AS resource_domain_3,
  f0_.resource_ref AS resource_ref_4,
  f0_.action AS action_5,
  f0_.user_id AS user_id_6,
  f0_.group_id AS group_id_7,
  f0_.element_id AS element_id_8,
  f0_.application_id AS application_id_9
FROM
  fom_permission f0_
WHERE
  f0_.subject_domain = 'public'

SELECT f0_.id AS id_0, f0_.subject_domain AS subject_domain_1, f0_.subject AS subject_2, f0_.resource_domain AS resource_domain_3, f0_.resource_ref AS resource_ref_4, f0_.action AS action_5, f0_.user_id AS user_id_6, f0_.group_id AS group_id_7, f0_.element_id AS element_id_8, f0_.application_id AS application_id_9 FROM fom_permission f0_ WHERE f0_.subject_domain = 'public';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.properties AS properties_3,
  t0.application_id AS application_id_4
FROM
  mb_core_regionproperties t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.properties AS properties_3, t0.application_id AS application_id_4 FROM mb_core_regionproperties t0 WHERE t0.application_id = 3 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.class AS class_3,
  t0.configuration AS configuration_4,
  t0.region AS region_5,
  t0.enabled AS enabled_6,
  t0.weight AS weight_7,
  t0.screenType AS screenType_8,
  t0.application_id AS application_id_9
FROM
  mb_core_element t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.class AS class_3, t0.configuration AS configuration_4, t0.region AS region_5, t0.enabled AS enabled_6, t0.weight AS weight_7, t0.screenType AS screenType_8, t0.application_id AS application_id_9 FROM mb_core_element t0 WHERE t0.application_id = 3 ORDER BY t0.weight ASC;

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 58 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 73 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 92 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 76 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 59 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 74 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 93 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 78 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 60 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 75 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 94 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 77 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 61 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 76 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 95 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 79 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 62 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 77 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 96 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 80 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 63 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 78 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 97 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 83 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 64 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 79 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 98 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 84 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 65 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 80 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 90 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 99 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 66 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 81 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 100 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 89 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 67 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 82 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 101 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 88 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 68 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 83 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 91 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 69 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 84 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 82 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 70 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 85 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 81 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 71 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 86 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 72 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 87 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 88 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 89 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 90 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 91 AND f0_.resource_domain = 'element');