Symfony Profiler

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

Query Metrics

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC

[
  "cms.koenig.ipv64.net"
  "dev"
  "website"
]

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'cms.koenig.ipv64.net' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'website' ORDER BY w0_.id ASC;

SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.version AS version_4, m1_.id AS id_5, m1_.created AS created_6, m1_.changed AS changed_7, m2_.name AS name_8, m2_.version AS version_9, m2_.subVersion AS subVersion_10, m2_.size AS size_11, m2_.downloadCounter AS downloadCounter_12, m2_.storageOptions AS storageOptions_13, m2_.mimeType AS mimeType_14, m2_.properties AS properties_15, m2_.focusPointX AS focusPointX_16, m2_.focusPointY AS focusPointY_17, m2_.id AS id_18, m2_.created AS created_19, m2_.changed AS changed_20, m3_.crop_x AS crop_x_21, m3_.crop_y AS crop_y_22, m3_.crop_width AS crop_width_23, m3_.crop_height AS crop_height_24, m3_.format_key AS format_key_25, m0_.idPreviewImage AS idPreviewImage_26, m0_.idCollections AS idCollections_27, m0_.idUsersCreator AS idUsersCreator_28, m0_.idUsersChanger AS idUsersChanger_29, m1_.idMedia AS idMedia_30, m1_.idUsersCreator AS idUsersCreator_31, m1_.idUsersChanger AS idUsersChanger_32, m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_33, m2_.idFiles AS idFiles_34, m2_.idUsersCreator AS idUsersCreator_35, m2_.idUsersChanger AS idUsersChanger_36, m3_.fileVersion AS fileVersion_37 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)) LEFT JOIN me_format_options m3_ ON m2_.id = m3_.fileVersion AND (m3_.format_key = ?) WHERE m0_.id = ?

[
  1
  "sulu-240x"
  3
]

SELECT
  m0_.type AS type_0,
  m0_.id AS id_1,
  m0_.created AS created_2,
  m0_.changed AS changed_3,
  m1_.version AS version_4,
  m1_.id AS id_5,
  m1_.created AS created_6,
  m1_.changed AS changed_7,
  m2_.name AS name_8,
  m2_.version AS version_9,
  m2_.subVersion AS subVersion_10,
  m2_.size AS size_11,
  m2_.downloadCounter AS downloadCounter_12,
  m2_.storageOptions AS storageOptions_13,
  m2_.mimeType AS mimeType_14,
  m2_.properties AS properties_15,
  m2_.focusPointX AS focusPointX_16,
  m2_.focusPointY AS focusPointY_17,
  m2_.id AS id_18,
  m2_.created AS created_19,
  m2_.changed AS changed_20,
  m3_.crop_x AS crop_x_21,
  m3_.crop_y AS crop_y_22,
  m3_.crop_width AS crop_width_23,
  m3_.crop_height AS crop_height_24,
  m3_.format_key AS format_key_25,
  m0_.idPreviewImage AS idPreviewImage_26,
  m0_.idCollections AS idCollections_27,
  m0_.idUsersCreator AS idUsersCreator_28,
  m0_.idUsersChanger AS idUsersChanger_29,
  m1_.idMedia AS idMedia_30,
  m1_.idUsersCreator AS idUsersCreator_31,
  m1_.idUsersChanger AS idUsersChanger_32,
  m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_33,
  m2_.idFiles AS idFiles_34,
  m2_.idUsersCreator AS idUsersCreator_35,
  m2_.idUsersChanger AS idUsersChanger_36,
  m3_.fileVersion AS fileVersion_37
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)
  )
  LEFT JOIN me_format_options m3_ ON m2_.id = m3_.fileVersion
  AND (m3_.format_key = ?)
WHERE
  m0_.id = ?

SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.version AS version_4, m1_.id AS id_5, m1_.created AS created_6, m1_.changed AS changed_7, m2_.name AS name_8, m2_.version AS version_9, m2_.subVersion AS subVersion_10, m2_.size AS size_11, m2_.downloadCounter AS downloadCounter_12, m2_.storageOptions AS storageOptions_13, m2_.mimeType AS mimeType_14, m2_.properties AS properties_15, m2_.focusPointX AS focusPointX_16, m2_.focusPointY AS focusPointY_17, m2_.id AS id_18, m2_.created AS created_19, m2_.changed AS changed_20, m3_.crop_x AS crop_x_21, m3_.crop_y AS crop_y_22, m3_.crop_width AS crop_width_23, m3_.crop_height AS crop_height_24, m3_.format_key AS format_key_25, m0_.idPreviewImage AS idPreviewImage_26, m0_.idCollections AS idCollections_27, m0_.idUsersCreator AS idUsersCreator_28, m0_.idUsersChanger AS idUsersChanger_29, m1_.idMedia AS idMedia_30, m1_.idUsersCreator AS idUsersCreator_31, m1_.idUsersChanger AS idUsersChanger_32, m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_33, m2_.idFiles AS idFiles_34, m2_.idUsersCreator AS idUsersCreator_35, m2_.idUsersChanger AS idUsersChanger_36, m3_.fileVersion AS fileVersion_37 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)) LEFT JOIN me_format_options m3_ ON m2_.id = m3_.fileVersion AND (m3_.format_key = 'sulu-240x') WHERE m0_.id = 3;