GET https://schulung.foss.academy/mapbender/application/3p_v2/element/1168/listing

Query Metrics

6 Database Queries
6 Different statements
5.18 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.22 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:
[
  "3p_v2"
]
2 0.78 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.18 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.id = ? AND t0.application_id = ?) ORDER BY t0.weight ASC
Parameters:
[
  1168
  37
]
4 0.58 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  1168
]
5 0.79 ms
SELECT COUNT(*) FROM mb_core_viewmanager_state t0 WHERE (t0.slug = ? AND t0.user_id IS NULL)
Parameters:
[
  "3p_v2"
]
6 0.64 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.user_id AS user_id_3, t0.mtime AS mtime_4, t0.title AS title_5, t0.view_params AS view_params_6, t0.layerset_diffs AS layerset_diffs_7, t0.source_diffs AS source_diffs_8 FROM mb_core_viewmanager_state t0 WHERE (t0.slug = ? AND t0.user_id IS NULL) ORDER BY t0.slug ASC, t0.user_id ASC
Parameters:
[
  "3p_v2"
]

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.