Query Metrics
59
Database Queries
5
Different statements
30.44 ms
Query time
0
Invalid entities
83
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.42 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_user_develop1"
]
|
| 2 | 2.33 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, 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:
[] |
| 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:
[
54
]
|
| 4 | 2.14 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:
[
54
]
|
| 5 | 0.80 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1957
]
|
| 6 | 0.56 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1938
]
|
| 7 | 0.47 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1949
]
|
| 8 | 0.45 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1928
]
|
| 9 | 0.43 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1939
]
|
| 10 | 0.44 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1941
]
|
| 11 | 0.43 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1929
]
|
| 12 | 0.42 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1950
]
|
| 13 | 0.44 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1958
]
|
| 14 | 0.43 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
2004
]
|
| 15 | 0.42 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1940
]
|
| 16 | 0.42 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1930
]
|
| 17 | 0.42 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1959
]
|
| 18 | 0.42 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1951
]
|
| 19 | 0.47 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1942
]
|
| 20 | 0.38 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1931
]
|
| 21 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1940
]
|
| 22 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1960
]
|
| 23 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1953
]
|
| 24 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1961
]
|
| 25 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1941
]
|
| 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:
[
1932
]
|
| 27 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1942
]
|
| 28 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1962
]
|
| 29 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1948
]
|
| 30 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1933
]
|
| 31 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1954
]
|
| 32 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1963
]
|
| 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:
[
2004
]
|
| 34 | 0.40 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
2005
]
|
| 35 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1943
]
|
| 36 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1955
]
|
| 37 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1944
]
|
| 38 | 0.29 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1964
]
|
| 39 | 0.30 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1956
]
|
| 40 | 0.29 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
2193
]
|
| 41 | 0.30 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1965
]
|
| 42 | 0.31 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1945
]
|
| 43 | 0.31 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1943
]
|
| 44 | 0.29 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1935
]
|
| 45 | 0.29 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1946
]
|
| 46 | 0.30 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
2194
]
|
| 47 | 0.29 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1936
]
|
| 48 | 0.30 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1937
]
|
| 49 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1947
]
|
| 50 | 0.31 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1948
]
|
| 51 | 0.60 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_user"
]
|
| 52 | 0.67 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_user_basic"
]
|
| 53 | 0.44 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_user_basic_with_zoom"
]
|
| 54 | 0.43 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:
[
"external_dz_nrw"
]
|
| 55 | 0.42 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:
[
"external_osm"
]
|
| 56 | 0.40 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:
[
"link_mapbender"
]
|
| 57 | 0.38 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:
[
"link_fossgis"
]
|
| 58 | 0.62 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_user"
]
|
| 59 | 0.47 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_user_basic"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| geodata_db | doctrine.dbal.geodata_db_connection |
| tn_db | doctrine.dbal.tn_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 | 42 |
| Mapbender\CoreBundle\Entity\Application | 19 |
| FOM\UserBundle\Entity\Permission | 19 |
| Mapbender\CoreBundle\Entity\RegionProperties | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Mapbender\CoreBundle\Entity\Application | No errors. |
| Mapbender\CoreBundle\Entity\RegionProperties | No errors. |
| Mapbender\CoreBundle\Entity\Element | No errors. |
| Mapbender\CoreBundle\Entity\Layerset | No errors. |
| FOM\UserBundle\Entity\Permission | No errors. |
| FOM\UserBundle\Entity\AbstractUser | No errors. |
| FOM\UserBundle\Entity\AbstractProfile | No errors. |
| FOM\UserBundle\Entity\BasicProfile | No errors. |
| FOM\UserBundle\Entity\User | No errors. |
| FOM\UserBundle\Entity\Group | No errors. |
| Mapbender\CoreBundle\Entity\SourceInstanceAssignment | No errors. |
| Mapbender\CoreBundle\Entity\SourceInstance | No errors. |
| Mapbender\CoreBundle\Entity\ReusableSourceInstanceAssignment | No errors. |
| Mapbender\CoreBundle\Entity\SRS | No errors. |