Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

7.91 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

1.75 ms

SELECT t0.weight AS weight_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.title AS title_7, t0.basesource AS basesource_8, t0.layerset AS layerset_9, t0.discr, t1.srs AS srs_10, t1.format AS format_11, t1.infoformat AS infoformat_12, t1.exceptionformat AS exceptionformat_13, t1.transparency AS transparency_14, t1.opacity AS opacity_15, t1.proxy AS proxy_16, t1.tiled AS tiled_17, t1.dimensions AS dimensions_18, t1.vendorspecifics AS vendorspecifics_19, t1.buffer AS buffer_20, t1.ratio AS ratio_21, t1.refresh_interval AS refresh_interval_22, t1.layerOrder AS layerorder_23, t1.wmssource AS wmssource_24, t2.opacity AS opacity_25, t2.proxy AS proxy_26, t2.wmtssource AS wmtssource_27, t3.min_scale AS min_scale_28, t3.max_scale AS max_scale_29, t3.selected AS selected_30, t3.allow_selected AS allow_selected_31, t3.feature_info AS feature_info_32, t3.feature_info_allow_toggle AS feature_info_allow_toggle_33, t3.feature_info_title AS feature_info_title_34, t3.hide_if_no_title AS hide_if_no_title_35, t3.feature_info_property_map AS feature_info_property_map_36, t3.opacity AS opacity_37, t3.print_scale_correction AS print_scale_correction_38, t3.legend_enabled AS legend_enabled_39, t3.legend_property_map AS legend_property_map_40, t3.source AS source_41 FROM mb_core_sourceinstance t0 LEFT JOIN mb_wms_wmsinstance t1 ON t0.id = t1.id LEFT JOIN mb_wmts_wmtsinstance t2 ON t0.id = t2.id LEFT JOIN mb_vectortiles_instance t3 ON t0.id = t3.id WHERE t0.id = ?

Parameters:

[
  "976"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.weight AS weight_4,
  t0.enabled AS enabled_5,
  t0.id AS id_6,
  t0.title AS title_7,
  t0.basesource AS basesource_8,
  t0.layerset AS layerset_9,
  t0.discr,
  t1.srs AS srs_10,
  t1.format AS format_11,
  t1.infoformat AS infoformat_12,
  t1.exceptionformat AS exceptionformat_13,
  t1.transparency AS transparency_14,
  t1.opacity AS opacity_15,
  t1.proxy AS proxy_16,
  t1.tiled AS tiled_17,
  t1.dimensions AS dimensions_18,
  t1.vendorspecifics AS vendorspecifics_19,
  t1.buffer AS buffer_20,
  t1.ratio AS ratio_21,
  t1.refresh_interval AS refresh_interval_22,
  t1.layerOrder AS layerorder_23,
  t1.wmssource AS wmssource_24,
  t2.opacity AS opacity_25,
  t2.proxy AS proxy_26,
  t2.wmtssource AS wmtssource_27,
  t3.min_scale AS min_scale_28,
  t3.max_scale AS max_scale_29,
  t3.selected AS selected_30,
  t3.allow_selected AS allow_selected_31,
  t3.feature_info AS feature_info_32,
  t3.feature_info_allow_toggle AS feature_info_allow_toggle_33,
  t3.feature_info_title AS feature_info_title_34,
  t3.hide_if_no_title AS hide_if_no_title_35,
  t3.feature_info_property_map AS feature_info_property_map_36,
  t3.opacity AS opacity_37,
  t3.print_scale_correction AS print_scale_correction_38,
  t3.legend_enabled AS legend_enabled_39,
  t3.legend_property_map AS legend_property_map_40,
  t3.source AS source_41
FROM
  mb_core_sourceinstance t0
  LEFT JOIN mb_wms_wmsinstance t1 ON t0.id = t1.id
  LEFT JOIN mb_wmts_wmtsinstance t2 ON t0.id = t2.id
  LEFT JOIN mb_vectortiles_instance t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.weight AS weight_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.title AS title_7, t0.basesource AS basesource_8, t0.layerset AS layerset_9, t0.discr, t1.srs AS srs_10, t1.format AS format_11, t1.infoformat AS infoformat_12, t1.exceptionformat AS exceptionformat_13, t1.transparency AS transparency_14, t1.opacity AS opacity_15, t1.proxy AS proxy_16, t1.tiled AS tiled_17, t1.dimensions AS dimensions_18, t1.vendorspecifics AS vendorspecifics_19, t1.buffer AS buffer_20, t1.ratio AS ratio_21, t1.refresh_interval AS refresh_interval_22, t1.layerOrder AS layerorder_23, t1.wmssource AS wmssource_24, t2.opacity AS opacity_25, t2.proxy AS proxy_26, t2.wmtssource AS wmtssource_27, t3.min_scale AS min_scale_28, t3.max_scale AS max_scale_29, t3.selected AS selected_30, t3.allow_selected AS allow_selected_31, t3.feature_info AS feature_info_32, t3.feature_info_allow_toggle AS feature_info_allow_toggle_33, t3.feature_info_title AS feature_info_title_34, t3.hide_if_no_title AS hide_if_no_title_35, t3.feature_info_property_map AS feature_info_property_map_36, t3.opacity AS opacity_37, t3.print_scale_correction AS print_scale_correction_38, t3.legend_enabled AS legend_enabled_39, t3.legend_property_map AS legend_property_map_40, t3.source AS source_41 FROM mb_core_sourceinstance t0 LEFT JOIN mb_wms_wmsinstance t1 ON t0.id = t1.id LEFT JOIN mb_wmts_wmtsinstance t2 ON t0.id = t2.id LEFT JOIN mb_vectortiles_instance t3 ON t0.id = t3.id WHERE t0.id = '976';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Mapbender\CoreBundle\Controller\InstanceTunnelController->getGrantedTunnelEndpoint (line 89)
6	Mapbender\CoreBundle\Controller\InstanceTunnelController->instancetunnel (line 41)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.12 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.selected AS selected_3, t0.application_id AS application_id_4 FROM mb_core_layerset t0 WHERE t0.id = ?

Parameters:

[
  161
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.selected AS selected_3,
  t0.application_id AS application_id_4
FROM
  mb_core_layerset t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.selected AS selected_3, t0.application_id AS application_id_4 FROM mb_core_layerset t0 WHERE t0.id = 161;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\Mapbender\CoreBundle\Entity\Layerset::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\Mapbender\CoreBundle\Entity\Layerset->__get (line 184)
7	Mapbender\CoreBundle\Entity\Layerset->getApplication (line 143)
8	Mapbender\CoreBundle\Controller\InstanceTunnelController->getGrantedTunnelEndpoint (line 93)
9	Mapbender\CoreBundle\Controller\InstanceTunnelController->instancetunnel (line 41)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

3.46 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.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query View query backtrace

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.id = ?

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.id = 26;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\Mapbender\CoreBundle\Entity\Application::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\Mapbender\CoreBundle\Entity\Application->__get (line 184)
7	Mapbender\CoreBundle\Entity\Application->getSource (line 139)
8	FOM\UserBundle\Security\Permission\YamlApplicationVoter->supports (line 44)
9	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 34)
10	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 38)
11	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 70)
12	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 37)
13	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 59)
14	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 60)
15	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 48)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->isGranted (line 205)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->denyAccessUnlessGranted (line 216)
18	Mapbender\CoreBundle\Controller\InstanceTunnelController->getGrantedTunnelEndpoint (line 94)
19	Mapbender\CoreBundle\Controller\InstanceTunnelController->instancetunnel (line 41)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 197)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

1.58 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:

[]

View formatted query View runnable query Explain query View query backtrace

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';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	FOM\UserBundle\Security\Permission\PermissionManager->getPermissionsForUser (line 222)
7	FOM\UserBundle\Security\Permission\PermissionManager->isGranted (line 53)
8	FOM\UserBundle\Security\Permission\ResourceDomainApplication->overrideDecision (line 96)
9	FOM\UserBundle\Security\Permission\PermissionManager->isGranted (line 50)
10	FOM\UserBundle\Security\Permission\PermissionManager->voteOnAttribute (line 354)
11	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 48)
12	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 38)
13	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 70)
14	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 37)
15	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 59)
16	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 60)
17	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 48)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->isGranted (line 205)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->denyAccessUnlessGranted (line 216)
20	Mapbender\CoreBundle\Controller\InstanceTunnelController->getGrantedTunnelEndpoint (line 94)
21	Mapbender\CoreBundle\Controller\InstanceTunnelController->instancetunnel (line 41)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 197)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
alkissn	doctrine.dbal.alkissn_connection
ltb_pul_vib	doctrine.dbal.ltb_pul_vib_connection
vdc001	doctrine.dbal.vdc001_connection
anord1	doctrine.dbal.anord1_connection
p216	doctrine.dbal.p216_connection
vdc002	doctrine.dbal.vdc002_connection
p216bernaws	doctrine.dbal.p216bernaws_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\SourceInstance	1
Mapbender\CoreBundle\Entity\Layerset	1
Mapbender\CoreBundle\Entity\Source	1
Mapbender\CoreBundle\Entity\Application	1

Entities Mapping

Class	Mapping errors
Mapbender\CoreBundle\Entity\SourceInstanceAssignment	No errors.
Mapbender\CoreBundle\Entity\SourceInstance	No errors.
Mapbender\WmsBundle\Entity\WmsInstance	No errors.
Mapbender\WmtsBundle\Entity\WmtsInstance	No errors.
Mapbender\VectorTilesBundle\Entity\VectorTileInstance	No errors.
Mapbender\CoreBundle\Entity\Layerset	No errors.
Mapbender\CoreBundle\Entity\Source	No errors.
Mapbender\CoreBundle\Entity\HttpParsedSource	No errors.
Mapbender\WmsBundle\Entity\WmsSource	No errors.
Mapbender\WmtsBundle\Entity\HttpTileSource	No errors.
Mapbender\WmtsBundle\Entity\WmtsSource	No errors.
Mapbender\VectorTilesBundle\Entity\VectorTileSource	No errors.
Mapbender\CoreBundle\Entity\ReusableSourceInstanceAssignment	No errors.
Mapbender\CoreBundle\Entity\SourceInstanceItem	No errors.
Mapbender\WmsBundle\Entity\WmsInstanceLayer	No errors.
Mapbender\CoreBundle\Entity\Application	No errors.
Mapbender\CoreBundle\Entity\RegionProperties	No errors.
Mapbender\CoreBundle\Entity\Element	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\SRS	No errors.

Symfony Profiler

GET http://dev.karten.fim.solutions/instance/976/tunnel?BBOX=795692.2502966337%2C5802224.945537759%2C796030.917640635%2C5802563.61288176&CRS=EPSG%3A25832&FORMAT=ima…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping