Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

62.07 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

24.63 ms
(39.68%)

SELECT s0_.name AS name_0, s0_.role_key AS role_key_1, s0_.securitySystem AS securitySystem_2, s0_.anonymous AS anonymous_3, s0_.id AS id_4, s0_.created AS created_5, s0_.changed AS changed_6, s1_.context AS context_7, s1_.module AS module_8, s1_.permissions AS permissions_9, s1_.id AS id_10, s0_.idSecurityTypes AS idSecurityTypes_11, s0_.idUsersCreator AS idUsersCreator_12, s0_.idUsersChanger AS idUsersChanger_13, s1_.idRoles AS idRoles_14 FROM se_roles s0_ LEFT JOIN se_permissions s1_ ON s0_.id = s1_.idRoles WHERE s0_.anonymous = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.role_key AS role_key_1,
  s0_.securitySystem AS securitySystem_2,
  s0_.anonymous AS anonymous_3,
  s0_.id AS id_4,
  s0_.created AS created_5,
  s0_.changed AS changed_6,
  s1_.context AS context_7,
  s1_.module AS module_8,
  s1_.permissions AS permissions_9,
  s1_.id AS id_10,
  s0_.idSecurityTypes AS idSecurityTypes_11,
  s0_.idUsersCreator AS idUsersCreator_12,
  s0_.idUsersChanger AS idUsersChanger_13,
  s1_.idRoles AS idRoles_14
FROM
  se_roles s0_
  LEFT JOIN se_permissions s1_ ON s0_.id = s1_.idRoles
WHERE
  s0_.anonymous = ?

SELECT s0_.name AS name_0, s0_.role_key AS role_key_1, s0_.securitySystem AS securitySystem_2, s0_.anonymous AS anonymous_3, s0_.id AS id_4, s0_.created AS created_5, s0_.changed AS changed_6, s1_.context AS context_7, s1_.module AS module_8, s1_.permissions AS permissions_9, s1_.id AS id_10, s0_.idSecurityTypes AS idSecurityTypes_11, s0_.idUsersCreator AS idUsersCreator_12, s0_.idUsersChanger AS idUsersChanger_13, s1_.idRoles AS idRoles_14 FROM se_roles s0_ LEFT JOIN se_permissions s1_ ON s0_.id = s1_.idRoles WHERE s0_.anonymous = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 83)
7	Sulu\Bundle\SecurityBundle\Entity\RoleRepository->findAllRoles (line 328)
8	Sulu\Component\Security\Authorization\AccessControl\AccessControlManager->getRolesForLocale (line 135)
9	Sulu\Component\Security\Authorization\AccessControl\AccessControlManager->getUserPermissions (line 57)
10	Sulu\Component\Security\Authorization\SecurityContextVoter->vote (line 38)
11	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 70)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 37)
13	Symfony\Component\Security\Core\Authorization\Strategy\UnanimousStrategy->decide (line 59)
14	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 60)
15	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 48)
16	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 39)
17	Sulu\Component\Security\Authorization\SecurityChecker->hasPermission (line 25)
18	Sulu\Component\Security\Authorization\AbstractSecurityChecker->checkPermission (line 110)
19	Sulu\Bundle\MediaBundle\Controller\MediaStreamController->downloadAction (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 71)

17.41 ms
(28.05%)

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.version AS version_3, m1_.id AS id_4, m1_.created AS created_5, m1_.changed AS changed_6, m2_.name AS name_7, m2_.version AS version_8, m2_.subVersion AS subVersion_9, m2_.size AS size_10, m2_.downloadCounter AS downloadCounter_11, m2_.storageOptions AS storageOptions_12, m2_.mimeType AS mimeType_13, m2_.properties AS properties_14, m2_.focusPointX AS focusPointX_15, m2_.focusPointY AS focusPointY_16, m2_.id AS id_17, m2_.created AS created_18, m2_.changed AS changed_19, m0_.idMediaTypes AS idMediaTypes_20, m0_.idPreviewImage AS idPreviewImage_21, m0_.idCollections AS idCollections_22, m0_.idUsersCreator AS idUsersCreator_23, m0_.idUsersChanger AS idUsersChanger_24, m1_.idMedia AS idMedia_25, m1_.idUsersCreator AS idUsersCreator_26, m1_.idUsersChanger AS idUsersChanger_27, m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_28, m2_.idFiles AS idFiles_29, m2_.idUsersCreator AS idUsersCreator_30, m2_.idUsersChanger AS idUsersChanger_31 FROM me_media m0_ LEFT JOIN me_files m1_ ON m0_.id = m1_.idMedia LEFT JOIN me_file_versions m2_ ON m1_.id = m2_.idFiles AND (m1_.version = m2_.version) WHERE m0_.id = ?

Parameters:

[
  "10"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.created AS created_1,
  m0_.changed AS changed_2,
  m1_.version AS version_3,
  m1_.id AS id_4,
  m1_.created AS created_5,
  m1_.changed AS changed_6,
  m2_.name AS name_7,
  m2_.version AS version_8,
  m2_.subVersion AS subVersion_9,
  m2_.size AS size_10,
  m2_.downloadCounter AS downloadCounter_11,
  m2_.storageOptions AS storageOptions_12,
  m2_.mimeType AS mimeType_13,
  m2_.properties AS properties_14,
  m2_.focusPointX AS focusPointX_15,
  m2_.focusPointY AS focusPointY_16,
  m2_.id AS id_17,
  m2_.created AS created_18,
  m2_.changed AS changed_19,
  m0_.idMediaTypes AS idMediaTypes_20,
  m0_.idPreviewImage AS idPreviewImage_21,
  m0_.idCollections AS idCollections_22,
  m0_.idUsersCreator AS idUsersCreator_23,
  m0_.idUsersChanger AS idUsersChanger_24,
  m1_.idMedia AS idMedia_25,
  m1_.idUsersCreator AS idUsersCreator_26,
  m1_.idUsersChanger AS idUsersChanger_27,
  m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_28,
  m2_.idFiles AS idFiles_29,
  m2_.idUsersCreator AS idUsersCreator_30,
  m2_.idUsersChanger AS idUsersChanger_31
FROM
  me_media m0_
  LEFT JOIN me_files m1_ ON m0_.id = m1_.idMedia
  LEFT JOIN me_file_versions m2_ ON m1_.id = m2_.idFiles
  AND (m1_.version = m2_.version)
WHERE
  m0_.id = ?

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.version AS version_3, m1_.id AS id_4, m1_.created AS created_5, m1_.changed AS changed_6, m2_.name AS name_7, m2_.version AS version_8, m2_.subVersion AS subVersion_9, m2_.size AS size_10, m2_.downloadCounter AS downloadCounter_11, m2_.storageOptions AS storageOptions_12, m2_.mimeType AS mimeType_13, m2_.properties AS properties_14, m2_.focusPointX AS focusPointX_15, m2_.focusPointY AS focusPointY_16, m2_.id AS id_17, m2_.created AS created_18, m2_.changed AS changed_19, m0_.idMediaTypes AS idMediaTypes_20, m0_.idPreviewImage AS idPreviewImage_21, m0_.idCollections AS idCollections_22, m0_.idUsersCreator AS idUsersCreator_23, m0_.idUsersChanger AS idUsersChanger_24, m1_.idMedia AS idMedia_25, m1_.idUsersCreator AS idUsersCreator_26, m1_.idUsersChanger AS idUsersChanger_27, m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_28, m2_.idFiles AS idFiles_29, m2_.idUsersCreator AS idUsersCreator_30, m2_.idUsersChanger AS idUsersChanger_31 FROM me_media m0_ LEFT JOIN me_files m1_ ON m0_.id = m1_.idMedia LEFT JOIN me_file_versions m2_ ON m1_.id = m2_.idFiles AND (m1_.version = m2_.version) WHERE m0_.id = '10';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 125)
7	Sulu\Bundle\MediaBundle\Entity\MediaRepository->findMediaByIdForRendering (line 221)
8	Sulu\Bundle\MediaBundle\Controller\MediaStreamController->getFileVersion (line 99)
9	Sulu\Bundle\MediaBundle\Controller\MediaStreamController->downloadAction (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 71)

12.11 ms
(19.51%)

UPDATE me_file_versions SET downloadCounter = downloadCounter + 1 WHERE id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  me_file_versions
SET
  downloadCounter = downloadCounter + 1
WHERE
  id = ?

UPDATE me_file_versions SET downloadCounter = downloadCounter + 1 WHERE id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 43)
2	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 717)
6	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->increaseDownloadCounter (line 129)
7	Sulu\Bundle\MediaBundle\Controller\MediaStreamController->downloadAction (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 71)

4.63 ms
(7.47%)

SELECT m0_.collection_key AS collection_key_0 FROM me_media m1_ INNER JOIN me_collections m0_ ON m1_.idCollections = m0_.id WHERE m1_.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.collection_key AS collection_key_0
FROM
  me_media m1_
  INNER JOIN me_collections m0_ ON m1_.idCollections = m0_.id
WHERE
  m1_.id = ?

SELECT m0_.collection_key AS collection_key_0 FROM me_media m1_ INNER JOIN me_collections m0_ ON m1_.idCollections = m0_.id WHERE m1_.id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 137)
8	Sulu\Bundle\FormBundle\Event\ProtectedMediaSubscriber->isProtectedCollection (line 107)
9	Sulu\Bundle\FormBundle\Event\ProtectedMediaSubscriber->onRequest (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 71)

3.28 ms
(5.29%)

SELECT s0_.permissions AS permissions_0, s0_.entityId AS entityId_1, s0_.entityClass AS entityClass_2, s0_.entityIdInteger AS entityIdInteger_3, s0_.id AS id_4, s0_.idRoles AS idRoles_5 FROM se_access_controls s0_ LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id WHERE s0_.entityId = ? AND s0_.entityClass = ? AND s1_.securitySystem = ?

Parameters:

[
  11
  "Sulu\Bundle\MediaBundle\Entity\Collection"
  "extranet"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.permissions AS permissions_0,
  s0_.entityId AS entityId_1,
  s0_.entityClass AS entityClass_2,
  s0_.entityIdInteger AS entityIdInteger_3,
  s0_.id AS id_4,
  s0_.idRoles AS idRoles_5
FROM
  se_access_controls s0_
  LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id
WHERE
  s0_.entityId = ?
  AND s0_.entityClass = ?
  AND s1_.securitySystem = ?

SELECT s0_.permissions AS permissions_0, s0_.entityId AS entityId_1, s0_.entityClass AS entityClass_2, s0_.entityIdInteger AS entityIdInteger_3, s0_.id AS id_4, s0_.idRoles AS idRoles_5 FROM se_access_controls s0_ LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id WHERE s0_.entityId = 11 AND s0_.entityClass = 'Sulu\\Bundle\\MediaBundle\\Entity\\Collection' AND s1_.securitySystem = 'extranet';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 64)
7	Sulu\Bundle\SecurityBundle\Entity\AccessControlRepository->findByTypeAndId (line 90)
8	Sulu\Component\Security\Authorization\AccessControl\DoctrineAccessControlProvider->getPermissions (line 117)
9	Sulu\Component\Security\Authorization\AccessControl\AccessControlManager->getPermissions (line 210)
10	Sulu\Component\Security\Authorization\AccessControl\AccessControlManager->getUserObjectPermission (line 133)
11	Sulu\Component\Security\Authorization\AccessControl\AccessControlManager->getUserPermissions (line 57)
12	Sulu\Component\Security\Authorization\SecurityContextVoter->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\UnanimousStrategy->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 39)
19	Sulu\Component\Security\Authorization\SecurityChecker->hasPermission (line 25)
20	Sulu\Component\Security\Authorization\AbstractSecurityChecker->checkPermission (line 110)
21	Sulu\Bundle\MediaBundle\Controller\MediaStreamController->downloadAction (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 71)

Database Connections

Name	Service
default	doctrine.dbal.default_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
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\FormBundle\Entity\Form	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Sulu\Bundle\MediaBundle\Entity\File	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion	No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage	No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\SecurityBundle\Entity\Role	No errors.
Sulu\Bundle\SecurityBundle\Entity\Permission	No errors.
Sulu\Bundle\SecurityBundle\Entity\SecurityType	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole	No errors.
Sulu\Bundle\SecurityBundle\Entity\RoleSetting	No errors.
Sulu\Bundle\SecurityBundle\Entity\AccessControl	No errors.

Symfony Profiler

GET http://sudcms.otidea.com/media/10/download/nuages.png

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping