Symfony Profiler

SELECT
  id
FROM
  versions
WHERE
  cid = ?
  AND ctype = ?
  AND autoSave = 0
ORDER BY
  `id` ASC

SELECT id FROM versions WHERE cid = 151 AND ctype = 'object'  AND autoSave = 0 ORDER BY `id` ASC;

INSERT INTO edit_lock (
  `id`, `cid`, `ctype`, `userId`, `sessionId`,
  `date`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO edit_lock (`id`, `cid`, `ctype`, `userId`, `sessionId`, `date`) VALUES (NULL, 151, 'object', 30, 'iashgvrtfj24chtmmtpr1ecolo', 1773325826);

SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  o.className as subtype,
  o.published as published,
  concat(o.path, o.key) as `path`,
  r.index
FROM
  objects o,
  object_relations_JOB r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND o.id = r.dest_id
  AND r.type = 'object'
UNION
SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  a.type as subtype,
  "null" as published,
  concat(a.path, a.filename) as `path`,
  r.index
FROM
  assets a,
  object_relations_JOB r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND a.id = r.dest_id
  AND r.type = 'asset'
UNION
SELECT
  r.dest_id as dest_id,
  r.dest_id as id,
  r.type,
  d.type as subtype,
  d.published as published,
  concat(d.path, d.key) as `path`,
  r.index
FROM
  documents d,
  object_relations_JOB r
WHERE
  r.fieldname = ?
  AND r.ownertype = 'object'
  AND r.src_id = ?
  AND d.id = r.dest_id
  AND r.type = 'document'
ORDER BY
  `index` ASC

SELECT r.dest_id as dest_id, r.dest_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index
            FROM objects o, object_relations_JOB r
            WHERE r.fieldname= 'kind'
            AND r.ownertype = 'object'
            AND r.src_id = 151
            AND o.id = r.dest_id
            AND r.type='object'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type,  a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index
            FROM assets a, object_relations_JOB r
            WHERE r.fieldname= 'kind'
            AND r.ownertype = 'object'
            AND r.src_id = 151
            AND a.id = r.dest_id
            AND r.type='asset'

            UNION SELECT r.dest_id as dest_id, r.dest_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index
            FROM documents d, object_relations_JOB r
            WHERE r.fieldname= 'kind'
            AND r.ownertype = 'object'
            AND r.src_id = 151
            AND d.id = r.dest_id
            AND r.type='document'

            ORDER BY `index` ASC;

UPDATE
  users
SET
  lastLogin = ?
WHERE
  id = ?

UPDATE users SET lastLogin = 1773325826 WHERE id = 30;

SELECT
  id
FROM
  versions
WHERE
  cid = ?
  AND ctype = ?
  AND (
    `date` > ?
    OR versionCount > ?
  )
  AND (
    (
      autoSave = 1
      AND userId = ?
    )
    OR autoSave = 0
  )
ORDER BY
  `versionCount` DESC
LIMIT
  1

SELECT id FROM versions WHERE cid = 151 AND ctype = 'object' AND (`date` > 1764500112 OR versionCount > 17) AND ((autoSave = 1 AND userId = 30) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT
  userId,
  `list`,
  `view`,
  `publish`,
  `delete`,
  `rename`,
  `create`,
  `settings`,
  `versions`,
  `properties`,
  `save`,
  `unpublish`,
  `lEdit`,
  `lView`,
  `layouts`
FROM
  users_workspaces_object
WHERE
  cid = 18
  AND userId IN (31, 30)
ORDER BY
  FIELD(userId, 30) DESC

SELECT userId,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object
             WHERE cid = 18 AND userId IN (31,30)
             ORDER BY FIELD(userId, 30) DESC
             ;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CONF_PRIVACY';

SELECT
  *
FROM
  users
WHERE
  `type` = ?
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 30;

SELECT
  *
FROM
  versions
WHERE
  id = ?

SELECT * FROM versions WHERE id = 3777;

SELECT
  *
FROM
  settings_store
WHERE
  id = ?
  AND scope = ?

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 30;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 30;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 30;

SELECT
  *
FROM
  edit_lock
WHERE
  cid = ?
  AND ctype = ?

SELECT * FROM edit_lock WHERE cid = 151 AND ctype = 'object';

SELECT
  *
FROM
  redirects
WHERE
  (
    (
      source = ?
      AND (
        `type` = ?
        OR `type` = ?
      )
    )
    OR (
      source = ?
      AND `type` = ?
    )
    OR (
      source = ?
      AND `type` = ?
    )
  )
  AND active = 1
  AND (
    regex IS NULL
    OR regex = 0
  )
  AND (
    expiry > UNIX_TIMESTAMP()
    OR expiry IS NULL
  )
  AND sourceSite IS NULL
  AND priority = 99
ORDER BY
  `priority` DESC

SELECT * FROM redirects WHERE
            (
                (source = '/admin/object/get' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/admin/object/get?_dc=1773325826182&id=151' AND `type` = 'path_query') OR
                (source = 'https://web8765.sportalpen.ms.mynet.at/admin/object/get?_dc=1773325826182&id=151' AND `type` = 'entire_uri')
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';

SELECT
  `save`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 18, 151)
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC,
  `save` DESC
LIMIT
  1

SELECT `save` FROM users_workspaces_object WHERE cid IN (1,18,151) AND userId IN (31,30) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `save` DESC LIMIT 1;

SELECT
  COUNT(*)
FROM
  sites

SELECT COUNT(*) FROM sites ;

SELECT
  `lView`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 18, 151)
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC,
  `lView` DESC

SELECT `lView`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,18,151) AND userId IN (31,30) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `lView` DESC;

SELECT
  tree_locks.id
FROM
  tree_locks
  INNER JOIN objects ON tree_locks.id = objects.id
WHERE
  objects.path LIKE ?
  AND tree_locks.type = 'object'
  AND tree_locks.locked IS NOT NULL
  AND tree_locks.locked != ''
LIMIT
  1

SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.id WHERE objects.path LIKE '/jobs/Betonmischmeister/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

SELECT
  *
FROM
  users
WHERE
  `id` = ?

SELECT * FROM users WHERE `id` = 31;

SELECT
  `lEdit`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 18, 151)
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC,
  `lEdit` DESC

SELECT `lEdit`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,18,151) AND userId IN (31,30) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `lEdit` DESC;

SELECT
  userId,
  cid,
  `list`,
  `view`,
  `publish`,
  `delete`,
  `rename`,
  `create`,
  `settings`,
  `versions`,
  `properties`,
  `save`,
  `unpublish`,
  `lEdit`,
  `lView`,
  `layouts`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 18, 151)
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC
LIMIT
  1

SELECT userId,cid,`list`,`view`,`publish`,`delete`,`rename`,`create`,`settings`,`versions`,`properties`,`save`,`unpublish`,`lEdit`,`lView`,`layouts` FROM users_workspaces_object
            WHERE cid IN (1,18,151) AND userId IN (31,30)
            ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC LIMIT 1
        ;

SELECT
  `view`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 18, 151)
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC,
  `view` DESC
LIMIT
  1

SELECT `view` FROM users_workspaces_object WHERE cid IN (1,18,151) AND userId IN (31,30) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `view` DESC LIMIT 1;

SELECT
  *
FROM
  translations_admin
LIMIT
  1;

SELECT * FROM translations_admin LIMIT 1;;

SELECT
  name,
  type,
  data,
  cid,
  inheritable,
  cpath
FROM
  properties
WHERE
  (
    (
      cid IN (1, 18)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,18) AND inheritable = 1)
                         OR cid = 151 ) AND ctype='object';

SELECT
  `layouts`,
  cid,
  cpath
FROM
  users_workspaces_object
WHERE
  cid IN (1, 18, 151)
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC,
  `layouts` DESC

SELECT `layouts`,cid,cpath FROM users_workspaces_object WHERE cid IN (1,18,151) AND userId IN (31,30) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `layouts` DESC;

SELECT
  id
FROM
  tree_locks
WHERE
  id IN (1, 18)
  AND `type` = 'object'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,18) AND `type`='object' AND locked = 'propagate' LIMIT 1;

SELECT
  id
FROM
  schedule_tasks
WHERE
  `cid` = ?
  AND `ctype` = ?

SELECT id FROM schedule_tasks WHERE `cid` = 151 AND `ctype` = 'object' ;

SELECT
  classId
FROM
  objects
WHERE
  `path` like ?
  AND `type` = 'object'
LIMIT
  1

SELECT classId FROM objects WHERE `path` like '/jobs/Betonmischmeister/%' AND `type` = 'object' LIMIT 1;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'jobCategory';

SELECT
  *
FROM
  object_relations_JOB
WHERE
  src_id = ?

SELECT * FROM object_relations_JOB WHERE src_id = 151;

DELETE FROM
  tmp_store
WHERE
  id = ?

DELETE FROM tmp_store WHERE id = 'object_session_151_iashgvrtfj24chtmmtpr1ecolo';