Symfony Profiler

SELECT
  m0_.name AS name_0,
  m1_.name AS name_1,
  m1_.size AS size_2,
  m1_.mimeType AS mimeType_3,
  (
    CASE WHEN m2_.title IS NOT NULL THEN
      m2_.title
    ELSE
      m3_.title
    END
  ) AS sclr_4,
  m4_.id AS id_5,
  m5_.id AS id_6,
  m4_.idPreviewImage AS sclr_7,
  m6_.name AS name_8,
  m6_.version AS version_9,
  m6_.subVersion AS subVersion_10,
  m6_.mimeType AS mimeType_11,
  m7_.version AS version_12,
  m1_.subVersion AS subVersion_13,
  (
    CASE WHEN m2_.locale IS NOT NULL THEN
      m2_.locale
    ELSE
      m3_.locale
    END
  ) AS sclr_14,
  m1_.storageOptions AS storageOptions_15,
  m4_.created AS created_16
FROM
  me_media m4_
  LEFT JOIN me_media_types m0_ ON m4_.idMediaTypes = m0_.id
  LEFT JOIN me_files m7_ ON m4_.id = m7_.idMedia
  LEFT JOIN me_file_versions m1_ ON m7_.id = m1_.idFiles
  AND (m1_.version = m7_.version)
  LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions
  AND (m2_.locale = ?)
  LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id
  LEFT JOIN me_collections m5_ ON m4_.idCollections = m5_.id
  LEFT JOIN me_media m8_ ON m4_.idPreviewImage = m8_.id
  LEFT JOIN me_files m9_ ON m8_.id = m9_.idMedia
  LEFT JOIN me_file_versions m6_ ON m9_.id = m6_.idFiles
  AND (m6_.version = m9_.version)
WHERE
  m4_.id IN (?, ?)
ORDER BY
  created_16 DESC

SELECT m0_.name AS name_0, m1_.name AS name_1, m1_.size AS size_2, m1_.mimeType AS mimeType_3, (CASE WHEN m2_.title IS NOT NULL THEN m2_.title ELSE m3_.title END) AS sclr_4, m4_.id AS id_5, m5_.id AS id_6, m4_.idPreviewImage AS sclr_7, m6_.name AS name_8, m6_.version AS version_9, m6_.subVersion AS subVersion_10, m6_.mimeType AS mimeType_11, m7_.version AS version_12, m1_.subVersion AS subVersion_13, (CASE WHEN m2_.locale IS NOT NULL THEN m2_.locale ELSE m3_.locale END) AS sclr_14, m1_.storageOptions AS storageOptions_15, m4_.created AS created_16 FROM me_media m4_ LEFT JOIN me_media_types m0_ ON m4_.idMediaTypes = m0_.id LEFT JOIN me_files m7_ ON m4_.id = m7_.idMedia LEFT JOIN me_file_versions m1_ ON m7_.id = m1_.idFiles AND (m1_.version = m7_.version) LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = 'de') LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_collections m5_ ON m4_.idCollections = m5_.id LEFT JOIN me_media m8_ ON m4_.idPreviewImage = m8_.id LEFT JOIN me_files m9_ ON m8_.id = m9_.idMedia LEFT JOIN me_file_versions m6_ ON m9_.id = m6_.idFiles AND (m6_.version = m9_.version) WHERE m4_.id IN (288, 234) ORDER BY created_16 DESC;

SELECT
  m0_.id AS id_0,
  m0_.created AS created_1
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 = m1_.version)
  LEFT JOIN me_file_version_meta m3_ ON m2_.id = m3_.idFileVersions
  AND (m3_.locale = ?)
  LEFT JOIN me_file_version_meta m4_ ON m2_.idFileVersionsMetaDefault = m4_.id
  LEFT JOIN me_collections m5_ ON m0_.idCollections = m5_.id
  LEFT JOIN me_media_types m6_ ON m0_.idMediaTypes = m6_.id
WHERE
  (m5_.id = ?)
  AND (
    m6_.name IN (?)
  )
  AND (
    NOT (
      m0_.id IN (?, ?)
    )
  )
  AND (
    (
      m2_.name LIKE ?
      OR m3_.title LIKE ?
      OR (
        m3_.title IS NULL
        AND m4_.title LIKE ?
      )
      OR m3_.description LIKE ?
    )
  )
ORDER BY
  created_1 DESC
LIMIT
  50

SELECT m0_.id AS id_0, m0_.created AS created_1 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 = m1_.version) LEFT JOIN me_file_version_meta m3_ ON m2_.id = m3_.idFileVersions AND (m3_.locale = 'de') LEFT JOIN me_file_version_meta m4_ ON m2_.idFileVersionsMetaDefault = m4_.id LEFT JOIN me_collections m5_ ON m0_.idCollections = m5_.id LEFT JOIN me_media_types m6_ ON m0_.idMediaTypes = m6_.id WHERE (m5_.id = 23) AND (m6_.name IN ('image')) AND (NOT (m0_.id IN ('236', '238'))) AND ((m2_.name LIKE '%6665%' OR m3_.title LIKE '%6665%' OR (m3_.title IS NULL AND m4_.title LIKE '%6665%') OR m3_.description LIKE '%6665%')) ORDER BY created_1 DESC LIMIT 50;

SELECT
  COUNT(m0_.id) AS sclr_0
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 = m1_.version)
  LEFT JOIN me_file_version_meta m3_ ON m2_.id = m3_.idFileVersions
  AND (m3_.locale = ?)
  LEFT JOIN me_file_version_meta m4_ ON m2_.idFileVersionsMetaDefault = m4_.id
  LEFT JOIN me_collections m5_ ON m0_.idCollections = m5_.id
  LEFT JOIN me_media_types m6_ ON m0_.idMediaTypes = m6_.id
WHERE
  (m5_.id = ?)
  AND (
    m6_.name IN (?)
  )
  AND (
    NOT (
      m0_.id IN (?, ?)
    )
  )
  AND (
    NOT (
      m0_.id IN (?, ?)
    )
  )
  AND (
    (
      m2_.name LIKE ?
      OR m3_.title LIKE ?
      OR (
        m3_.title IS NULL
        AND m4_.title LIKE ?
      )
      OR m3_.description LIKE ?
    )
  )

SELECT COUNT(m0_.id) AS sclr_0 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 = m1_.version) LEFT JOIN me_file_version_meta m3_ ON m2_.id = m3_.idFileVersions AND (m3_.locale = 'de') LEFT JOIN me_file_version_meta m4_ ON m2_.idFileVersionsMetaDefault = m4_.id LEFT JOIN me_collections m5_ ON m0_.idCollections = m5_.id LEFT JOIN me_media_types m6_ ON m0_.idMediaTypes = m6_.id WHERE (m5_.id = 23) AND (m6_.name IN ('image')) AND (NOT (m0_.id IN ('236', '238'))) AND (NOT (m0_.id IN ('236', '238'))) AND ((m2_.name LIKE '%6665%' OR m3_.title LIKE '%6665%' OR (m3_.title IS NULL AND m4_.title LIKE '%6665%') OR m3_.description LIKE '%6665%'));

SELECT
  s0_.username AS username_0,
  s0_.password AS password_1,
  s0_.locale AS locale_2,
  s0_.salt AS salt_3,
  s0_.locked AS locked_4,
  s0_.enabled AS enabled_5,
  s0_.lastLogin AS lastLogin_6,
  s0_.confirmationKey AS confirmationKey_7,
  s0_.passwordResetToken AS passwordResetToken_8,
  s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9,
  s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10,
  s0_.privateKey AS privateKey_11,
  s0_.apiKey AS apiKey_12,
  s0_.email AS email_13,
  s0_.id AS id_14,
  s0_.created AS created_15,
  s0_.changed AS changed_16,
  s1_.locale AS locale_17,
  s1_.id AS id_18,
  s2_.name AS name_19,
  s2_.role_key AS role_key_20,
  s2_.securitySystem AS securitySystem_21,
  s2_.anonymous AS anonymous_22,
  s2_.id AS id_23,
  s2_.created AS created_24,
  s2_.changed AS changed_25,
  s3_.context AS context_26,
  s3_.module AS module_27,
  s3_.permissions AS permissions_28,
  s3_.id AS id_29,
  s0_.idContacts AS idContacts_30,
  s0_.idUsersCreator AS idUsersCreator_31,
  s0_.idUsersChanger AS idUsersChanger_32,
  s1_.idUsers AS idUsers_33,
  s1_.idRoles AS idRoles_34,
  s2_.idSecurityTypes AS idSecurityTypes_35,
  s2_.idUsersCreator AS idUsersCreator_36,
  s2_.idUsersChanger AS idUsersChanger_37,
  s3_.idRoles AS idRoles_38
FROM
  se_users s0_
  LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers
  LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id
  LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles
WHERE
  s0_.id = ?

SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.module AS module_27, s3_.permissions AS permissions_28, s3_.id AS id_29, s0_.idContacts AS idContacts_30, s0_.idUsersCreator AS idUsersCreator_31, s0_.idUsersChanger AS idUsersChanger_32, s1_.idUsers AS idUsers_33, s1_.idRoles AS idRoles_34, s2_.idSecurityTypes AS idSecurityTypes_35, s2_.idUsersCreator AS idUsersCreator_36, s2_.idUsersChanger AS idUsersChanger_37, s3_.idRoles AS idRoles_38 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.id = 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 = ?

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 = '23' AND s0_.entityClass = 'Sulu\\Bundle\\MediaBundle\\Entity\\Collection' AND s1_.securitySystem = 'Sulu';

SELECT
  t0.method AS method_1,
  t0.options AS options_2,
  t0.id AS id_3,
  t0.idUsers AS idUsers_4
FROM
  se_user_two_factors t0
WHERE
  t0.idUsers = ?

SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = 1;

SELECT
  m0_.collection_type_key AS collection_type_key_0
FROM
  me_collections m1_
  LEFT JOIN me_collection_types m0_ ON m1_.idCollectionTypes = m0_.id
WHERE
  m1_.id = ?

SELECT m0_.collection_type_key AS collection_type_key_0 FROM me_collections m1_ LEFT JOIN me_collection_types m0_ ON m1_.idCollectionTypes = m0_.id WHERE m1_.id = 23;