Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.90 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.89 ms
(65.08%)

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\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 44)
4	Mapbender\CoreBundle\Controller\WelcomeController->list (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.01 ms
(34.92%)

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 AS resource_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 AS resource_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 AS resource_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\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 221)
7	FOM\UserBundle\Security\Permission\PermissionManager->getPermissionsForUser (line 52)
8	FOM\UserBundle\Security\Permission\PermissionManager->isGranted (line 96)
9	FOM\UserBundle\Security\Permission\ResourceDomainApplication->overrideDecision (line 49)
10	FOM\UserBundle\Security\Permission\PermissionManager->isGranted (line 353)
11	FOM\UserBundle\Security\Permission\PermissionManager->voteOnAttribute (line 48)
12	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 38)
13	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 70)
14	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 37)
15	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 59)
16	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 60)
17	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 48)
18	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 205)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->isGranted (line 51)
20	Mapbender\CoreBundle\Controller\WelcomeController->list (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
copperotka	doctrine.dbal.copperotka_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

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.

Symfony Profiler

GET http://prehistcopper.elte.hu/

Configuration Settings

Theme

Page Width