Symfony Profiler

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/#\\_kategorien/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  1
FROM
  objects o
WHERE
  parentId = ?
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (31, 30)
        AND list = 1
        AND LOCATE(
          CONCAT(o.path, o.key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 30
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object uworow
        WHERE
          userId IN (31, 30)
          AND cid = id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1
  AND `type` IN ('object', 'folder')
LIMIT
  1

SELECT 1 FROM objects o WHERE parentId = 30  AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (31,30) AND list=1 AND LOCATE(CONCAT(o.path,o.key),cpath)=1 AND
            NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =30  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object uworow WHERE userId IN (31,30)  AND cid = id AND list=0) = 0, 0)) = 1 AND `type` IN ('object','folder') LIMIT 1;

SELECT
  1
FROM
  objects o
WHERE
  parentId = ?
  AND `type` IN ('object', 'folder')
LIMIT
  1

SELECT 1 FROM objects o WHERE parentId = 18  AND `type` IN ('object','folder') LIMIT 1;

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
  `list`
FROM
  users_workspaces_object
WHERE
  LOCATE(cpath, ?)= 1
  AND userId IN (31, 30)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 30) DESC,
  `list` DESC
LIMIT
  1

SELECT `list` FROM users_workspaces_object WHERE LOCATE(cpath, '/jobs')=1 AND
        userId IN (31,30)
        ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `list` DESC LIMIT 1;

SELECT
  COUNT(*)
FROM
  objects
WHERE
  objects.parentId = '18'
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (31, 30)
        AND list = 1
        AND LOCATE(
          CONCAT(objects.path, objects.key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 30
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object
        WHERE
          userId IN (31, 30)
          AND cid = objects.id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1
  AND objects.type IN ('object', 'folder')

SELECT COUNT(*) FROM objects WHERE objects.parentId = '18' AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (31,30) AND list=1 AND LOCATE(CONCAT(objects.path,objects.key),cpath)=1 AND
                NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =30  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object WHERE userId IN (31,30)  AND cid = objects.id AND list=0) = 0, 0)) = 1 AND  objects.type IN ('object','folder');

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
  objects.id as id,
  objects.type as `type`
FROM
  objects
WHERE
  objects.parentId = '18'
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (31, 30)
        AND list = 1
        AND LOCATE(
          CONCAT(objects.path, objects.key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 30
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object
        WHERE
          userId IN (31, 30)
          AND cid = objects.id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1
  AND objects.type IN ('object', 'folder')
ORDER BY
  CAST(
    objects.key AS CHAR CHARACTER SET utf8
  ) COLLATE utf8_general_ci ASC
LIMIT
  30

SELECT objects.id as id, objects.type as `type` FROM objects WHERE objects.parentId = '18' AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (31,30) AND list=1 AND LOCATE(CONCAT(objects.path,objects.key),cpath)=1 AND
                NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =30  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object WHERE userId IN (31,30)  AND cid = objects.id AND list=0) = 0, 0)) = 1 AND  objects.type IN ('object','folder') ORDER BY CAST(objects.key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC    LIMIT 30;

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
WHERE
  `type` = ?
  AND id = ?

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

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 30;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 30;

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/tree-get-children-by-id' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/admin/object/tree-get-children-by-id?_dc=1773325956907&limit=30&view=&fromPaging=0&start=0&parentPath=/jobs&page=1&node=18' AND `type` = 'path_query') OR
                (source = 'https://web8765.sportalpen.ms.mynet.at/admin/object/tree-get-children-by-id?_dc=1773325956907&fromPaging=0&limit=30&node=18&page=1&parentPath=/jobs&start=0&view=' 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
  COUNT(*) AS count
FROM
  objects o
WHERE
  parentId = ?
  AND IF(
    EXISTS(
      SELECT
        list
      FROM
        users_workspaces_object uwo
      WHERE
        userId IN (31, 30)
        AND list = 1
        AND LOCATE(
          CONCAT(o.path, o.key),
          cpath
        )= 1
        AND NOT EXISTS(
          SELECT
            list
          FROM
            users_workspaces_object
          WHERE
            userId = 30
            AND list = 0
            AND cpath = uwo.cpath
        )
    ),
    1,
    IF(
      1,
      EXISTS(
        SELECT
          list
        FROM
          users_workspaces_object uworow
        WHERE
          userId IN (31, 30)
          AND cid = id
          AND list = 0
      ) = 0,
      0
    )
  ) = 1

SELECT COUNT(*) AS count FROM objects o WHERE parentId = 18 AND IF(EXISTS(SELECT list FROM users_workspaces_object uwo WHERE userId IN (31,30) AND list=1 AND LOCATE(CONCAT(o.path,o.key),cpath)=1 AND
            NOT EXISTS(SELECT list FROM users_workspaces_object WHERE userId =30  AND list=0 AND cpath = uwo.cpath)),1,IF(1, EXISTS(SELECT list FROM users_workspaces_object uworow WHERE userId IN (31,30)  AND cid = id AND list=0) = 0, 0)) = 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
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';

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, 30)
  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,30) 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, 189)
  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,189) 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 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, 191)
  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,191) 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, 149)
  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,149) 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, 190)
  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,190) 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, 147)
  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,147) 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, 33)
  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,33) 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, 179)
  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,179) 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, 148)
  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,148) 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, 187)
  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,187) AND userId IN (31,30)
            ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC LIMIT 1
        ;