Symfony Profiler

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
  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/save' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/admin/object/save?task=autoSave' AND `type` = 'path_query') OR
                (source = 'https://web8765.sportalpen.ms.mynet.at/admin/object/save?task=autoSave' 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
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 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
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CONF_PRIVACY';

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'CONF_BUSINESS';

SELECT
  *
FROM
  users
WHERE
  `id` = ?

SELECT * FROM users WHERE `id` = 31;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 31;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 31;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 31;

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

SELECT * FROM users WHERE `type` = 'role' AND id = 31;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 31;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 31;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 31;

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_perspectives';

SELECT
  id
FROM
  settings_store
WHERE
  scope = ?

SELECT id FROM settings_store WHERE scope = 'pimcore_custom_views';

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 = 111 AND ctype = 'object' AND (`date` > 1773325555 OR versionCount > 19) AND ((autoSave = 1 AND userId = 30) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT
  `save`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 2, 111)
  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,2,111) AND userId IN (31,30) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `save` DESC LIMIT 1;

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

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

DELETE FROM
  schedule_tasks
WHERE
  `cid` = 111
  AND `ctype` = 'object'

DELETE FROM schedule_tasks WHERE `cid` = 111 AND `ctype` = 'object';

SELECT
  id
FROM
  versions
WHERE
  autoSave = 1
  AND cid = ?
  AND cType = ?
  AND userId = ?

SELECT id FROM versions WHERE autoSave = 1 AND cid = 111 AND cType = 'object' AND userId = 30  ;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 111 FOR UPDATE;

SELECT
  MAX(versionCount)
FROM
  versions
WHERE
  cid = ?
  AND ctype = 'object'

SELECT MAX(versionCount) FROM versions WHERE cid = 111 AND ctype = 'object';

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

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

SELECT
  *
FROM
  object_relations_CONF_BUSINESS
WHERE
  src_id = ?

SELECT * FROM object_relations_CONF_BUSINESS WHERE src_id = 111;

INSERT INTO versions (
  `id`, `cid`, `ctype`, `userId`, `note`,
  `date`, `public`, `serialized`, `stackTrace`,
  `versionCount`, `binaryFileHash`,
  `binaryFileId`, `autoSave`, `storageType`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 111, 'object', 30, '', 1773325693, 0, 1, '#0 /data/web/web8765/home/site/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /data/web/web8765/home/site/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /data/web/web8765/home/site/vendor/pimcore/admin-ui-classic-bundle/src/Controller/Admin/DataObject/DataObjectController.php(1423): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /data/web/web8765/home/site/vendor/symfony/http-kernel/HttpKernel.php(181): Pimcore\\Bundle\\AdminBundle\\Controller\\Admin\\DataObject\\DataObjectController->saveAction()
#4 /data/web/web8765/home/site/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#5 /data/web/web8765/home/site/vendor/symfony/http-kernel/Kernel.php(197): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#6 /data/web/web8765/home/site/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 /data/web/web8765/home/site/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#8 /data/web/web8765/home/site/public/index.php(19): require_once(\'...\')
#9 {main}', 20, NULL, NULL, 1, 'fs');

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

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

SELECT id FROM tree_locks WHERE id IN (1,2) 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, '/konfiguration/business')=1 AND
        userId IN (31,30)
        ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) DESC, `list` DESC 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 = 111  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
  userId,
  cid,
  `list`,
  `view`,
  `publish`,
  `delete`,
  `rename`,
  `create`,
  `settings`,
  `versions`,
  `properties`,
  `save`,
  `unpublish`,
  `lEdit`,
  `lView`,
  `layouts`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 2, 111)
  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,2,111) AND userId IN (31,30)
            ORDER BY LENGTH(cpath) DESC, FIELD(userId, 30) 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 = 111
  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 = 111 AND userId IN (31,30)
             ORDER BY FIELD(userId, 30) 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 '/konfiguration/business/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

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

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

SELECT
  `type`,
  `className`,
  `classId`
FROM
  objects
WHERE
  `id` = ?

SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 111;

SELECT
  objects.*,
  tree_locks.locked as locked
FROM
  objects
  LEFT JOIN tree_locks ON objects.id = tree_locks.id
  AND tree_locks.type = 'object'
WHERE
  objects.id = ?

SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = 111;

SELECT
  *
FROM
  object_store_CONF_BUSINESS
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_CONF_BUSINESS WHERE oo_id = 111 FOR UPDATE;

SELECT
  *
FROM
  object_localized_data_CONF_BUSINESS
WHERE
  ooo_id = ?
  AND language IN ('de')

SELECT * FROM object_localized_data_CONF_BUSINESS WHERE ooo_id = 111 AND language IN ('de');

SELECT
  *
FROM
  object_relations_CONF_BUSINESS
WHERE
  src_id = ?

SELECT * FROM object_relations_CONF_BUSINESS WHERE src_id = 111;