GET https://schulung.foss.academy/mapbender/application/mapbender_demo_nrw_db_imp1

Query Metrics

34 Database Queries
5 Different statements
18.41 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 2.26 ms
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
Parameters:
[
  "mapbender_demo_nrw_db_imp1"
]
2 1.02 ms
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'
Parameters:
[]
3 1.56 ms
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
Parameters:
[
  25
]
4 2.05 ms
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
Parameters:
[
  25
]
5 0.87 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  847
]
6 0.55 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  833
]
7 0.44 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  852
]
8 0.41 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  828
]
9 0.39 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  834
]
10 0.38 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  853
]
11 0.37 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  829
]
12 0.41 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  848
]
13 0.39 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  854
]
14 0.37 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  830
]
15 0.38 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  849
]
16 0.40 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  835
]
17 0.37 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  855
]
18 0.36 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  831
]
19 0.37 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  850
]
20 0.34 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  836
]
21 0.32 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  832
]
22 0.32 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  856
]
23 0.32 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  851
]
24 0.33 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  837
]
25 0.37 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  857
]
26 0.36 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  838
]
27 0.33 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  839
]
28 0.33 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  840
]
29 0.32 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  841
]
30 0.32 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  842
]
31 0.32 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  843
]
32 0.34 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  844
]
33 0.37 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  845
]
34 0.33 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  846
]

Database Connections

Name Service
default doctrine.dbal.default_connection
geodata_db doctrine.dbal.geodata_db_connection
ne2 doctrine.dbal.ne2_connection
alkis doctrine.dbal.alkis_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.