Symfony Profiler

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1784788704 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');

UPDATE
  versions
SET
  `id` = ?,
  `cid` = ?,
  `ctype` = ?,
  `userId` = ?,
  `note` = ?,
  `date` = ?,
  `public` = ?,
  `serialized` = ?,
  `stackTrace` = ?,
  `versionCount` = ?,
  `binaryFileHash` = ?,
  `binaryFileId` = ?,
  `autoSave` = ?,
  `storageType` = ?
WHERE
  `id` = ?

UPDATE versions SET `id` = 1897, `cid` = 8642, `ctype` = 'object', `userId` = 61, `note` = '', `date` = 1784788704, `public` = 0, `serialized` = 1, `stackTrace` = '#0 /var/www/pimcore/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /var/www/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /var/www/pimcore/vendor/pimcore/admin-ui-classic-bundle/src/Controller/Admin/DataObject/DataObjectController.php(1423): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /var/www/pimcore/vendor/symfony/http-kernel/HttpKernel.php(181): Pimcore\\Bundle\\AdminBundle\\Controller\\Admin\\DataObject\\DataObjectController->saveAction()
#4 /var/www/pimcore/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#5 /var/www/pimcore/vendor/symfony/http-kernel/Kernel.php(208): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#6 /var/www/pimcore/public/index.php(41): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 {main}', `versionCount` = 8, `binaryFileHash` = NULL, `binaryFileId` = NULL, `autoSave` = 1, `storageType` = 'fs' WHERE `id` = 1897;

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

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

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1784788704 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_8642
tags
', 'class_mobile_job_offer
tags
');

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

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

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 61;

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 61;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 61;

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 = 8642;

SELECT
  *
FROM
  object_store_mobile_job_offer
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_mobile_job_offer WHERE oo_id = 8642 FOR UPDATE;

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 '/Oferty pracy dla dla aplikacji mobilnej/Kasia G/UZ MGR Piła/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  *
FROM
  object_relations_mobile_job_offer
WHERE
  src_id = ?

SELECT * FROM object_relations_mobile_job_offer WHERE src_id = 8642;

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

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

SELECT
  *
FROM
  versions
WHERE
  id = ?

SELECT * FROM versions WHERE id = 1897;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'mobile_job_offer';

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

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

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

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

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

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,8044,7638) AND inheritable = 1)
                         OR cid = 8642 ) 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 = 8642 AND cType = 'object' AND userId = 61  ;

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 = 'http://www.geminipolska.com.pl/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
  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 = 8642 AND ctype = 'object' AND (`date` > 1784788579 OR versionCount > 5) AND ((autoSave = 1 AND userId = 61) OR autoSave = 0) ORDER BY `versionCount` DESC LIMIT 1;

SELECT
  *
FROM
  users
WHERE
  `id` = ?

SELECT * FROM users WHERE `id` = 39;

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, 8044, 7638, 8642)
  AND userId IN (39, 61)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 61) 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,8044,7638,8642) AND userId IN (39,61)
            ORDER BY LENGTH(cpath) DESC, FIELD(userId, 61) DESC LIMIT 1
        ;

SELECT
  `save`
FROM
  users_workspaces_object
WHERE
  cid IN (1, 8044, 7638, 8642)
  AND userId IN (39, 61)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 61) DESC,
  `save` DESC
LIMIT
  1

SELECT `save` FROM users_workspaces_object WHERE cid IN (1,8044,7638,8642) AND userId IN (39,61) ORDER BY LENGTH(cpath) DESC, FIELD(userId, 61) DESC, `save` DESC LIMIT 1;

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 (1897, 8642, 'object', 61, '', 1784788704, 0, 1, '#0 /var/www/pimcore/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /var/www/pimcore/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /var/www/pimcore/vendor/pimcore/admin-ui-classic-bundle/src/Controller/Admin/DataObject/DataObjectController.php(1423): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /var/www/pimcore/vendor/symfony/http-kernel/HttpKernel.php(181): Pimcore\\Bundle\\AdminBundle\\Controller\\Admin\\DataObject\\DataObjectController->saveAction()
#4 /var/www/pimcore/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#5 /var/www/pimcore/vendor/symfony/http-kernel/Kernel.php(208): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#6 /var/www/pimcore/public/index.php(41): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 {main}', 8, NULL, NULL, 1, 'fs');

SELECT
  *
FROM
  object_collection_mobileJobOfferWorkingDay_mobile_job_offer
WHERE
  id = ?
  AND fieldname = ?
ORDER BY
  `index` ASC

SELECT * FROM object_collection_mobileJobOfferWorkingDay_mobile_job_offer WHERE id = 8642 AND fieldname = 'workingDays' ORDER BY `index` ASC;

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
  object_relations_4
WHERE
  src_id = ?

SELECT * FROM object_relations_4 WHERE src_id = 4070;

SELECT
  `list`
FROM
  users_workspaces_object
WHERE
  LOCATE(cpath, ?)= 1
  AND userId IN (39, 61)
ORDER BY
  LENGTH(cpath) DESC,
  FIELD(userId, 61) DESC,
  `list` DESC
LIMIT
  1

SELECT `list` FROM users_workspaces_object WHERE LOCATE(cpath, '/Oferty pracy dla dla aplikacji mobilnej/Kasia G/UZ MGR Piła')=1 AND
        userId IN (39,61)
        ORDER BY LENGTH(cpath) DESC, FIELD(userId, 61) DESC, `list` 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 = 7638
  AND userId IN (39, 61)
ORDER BY
  FIELD(userId, 61) DESC

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

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

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

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1784788704 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'redirect
tags
', 'route
tags
');

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 8642 FOR UPDATE;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';