Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 353
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• PHPCR
• Debug
• Emails
• Serializer
• JMS Serializer 0 + 0
• Sulu
• Configuration

Query Metrics

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

[
  19
]

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 = 19;

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 (m2_.version IN (?, m2_.version)) WHERE m0_.id = ?

[
  1
  "19"
]

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 (
    m2_.version IN (?, 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 (m2_.version IN (1, m2_.version)) WHERE m0_.id = '19';

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
]

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;

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

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

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

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
]

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;

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

[
  19
]

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

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