GET https://develop.mapbender.org/application/mapbender_user_yml

Query Metrics

51 Database Queries
6 Different statements
2.23 ms Query time
0 Invalid entities
47 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
0.91 ms
(40.83%)
44
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
  20
]
0.67 ms
(30.16%)
1
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:
[
  2
]
0.22 ms
(9.99%)
3
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_user_yml"
]
0.20 ms
(8.77%)
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, f0_.source_instance_id AS source_instance_id_10, f0_.shared_instance_assignment_id AS shared_instance_assignment_id_11 FROM fom_permission f0_ WHERE f0_.subject_domain = 'public'
Parameters:
[]
0.15 ms
(6.93%)
1
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:
[
  2
]
0.07 ms
(3.32%)
1
PRAGMA foreign_keys = ON;
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
geodata_db doctrine.dbal.geodata_db_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Mapbender\CoreBundle\Entity\Element 38
Mapbender\CoreBundle\Entity\Application 3
FOM\UserBundle\Entity\Permission 3
Mapbender\CoreBundle\Entity\RegionProperties 3