Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.63 ms Query time

0 Invalid entities

21 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

1.68 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 ORDER BY t0.title ASC

Parameters:

[]

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
ORDER BY
  t0.title ASC

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 ORDER BY t0.title ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Mapbender\CoreBundle\Controller\WelcomeController->list (line 44)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.96 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	Mapbender\CoreBundle\Controller\WelcomeController->list (line 51)
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)

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\Application	21

Entities Mapping

Class	Mapping errors
Mapbender\CoreBundle\Entity\SRS	No errors.
Mapbender\CoreBundle\Entity\Application	No errors.
Mapbender\CoreBundle\Entity\SourceInstanceAssignment	No errors.
Mapbender\CoreBundle\Entity\SourceInstance	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.