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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f');

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f');

INSERT INTO cache_items (
  item_id, item_data, item_lifetime,
  item_time
)
VALUES
  (?, ?, ?, ?) ON DUPLICATE KEY
UPDATE
  item_data =
VALUES
  (item_data),
  item_lifetime =
VALUES
  (item_lifetime),
  item_time =
VALUES
  (item_time)

INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (66, 1793106032, 'app:ce82b1a2ae0029fce1373a9bbcce99a8b55d6b7f', 0x4F3A313A22A9223A313A7B733A363A222BFDA208C01E223B4F3A35303A2253796D666F6E795C436F6D706F6E656E745C526174654C696D697465725C506F6C6963795C536C6964696E6757696E646F77223A313A7B733A34313A2200000011000000000000003C73747564696F5F6170695F67656E6572616C2D3137322E31382E302E31223B643A313739333130363033382E3334353136313B7D7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 1;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 1;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 1;

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('studio_backend_user_permissions');

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4');

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4
tags
', 'class_3
tags
');

SELECT
  *
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 * FROM versions WHERE cid = 4 AND ctype = 'object' AND (`date` > 1793105999 OR versionCount > 1) AND ((autoSave = 1 AND userId = 1) OR autoSave = 0)  ORDER BY `versionCount` DESC LIMIT 1;

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1');

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1
tags
');

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

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

SELECT
  `id`,
  `name`
FROM
  classes
WHERE
  id = ?

SELECT `id`, `name` FROM classes WHERE id = '3' ;

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4');

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

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

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

SELECT * FROM versions WHERE autoSave = 1 AND cid = 4 AND cType = 'object' AND userId = 1  ;

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 1;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 1;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 1;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 4 FOR UPDATE;

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

SELECT MAX(versionCount) FROM versions WHERE cid = 4 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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_versions');

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system
tags
', 'resource
tags
');

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

INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`, `coauthorType`, `coauthor`) VALUES (9, 4, 'object', 1, '', 1793106032, 0, 1, '#0 /var/www/html/vendor/pimcore/pimcore/models/Element/AbstractElement.php(660): Pimcore\\Model\\Version->save()
#1 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(280): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion(NULL, true, true, true)
#2 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/ElementSaveService.php(85): Pimcore\\Model\\DataObject\\Concrete->saveVersion(true, true, NULL, true)
#3 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/ElementSaveService.php(64): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\ElementSaveService->processVersionTasks(Object(Pimcore\\Model\\DataObject\\Product), Object(Pimcore\\Model\\User), \'autoSave\')
#4 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/ElementSaveService.php(53): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\ElementSaveService->processTask(Object(Pimcore\\Model\\DataObject\\Product), Object(Pimcore\\Model\\User), \'autoSave\')
#5 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Updater/Service/UpdateService.php(102): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\ElementSaveService->save(Object(Pimcore\\Model\\DataObject\\Product), Object(Pimcore\\Model\\User), \'autoSave\')
#6 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/CoauthorService.php(65): Pimcore\\Bundle\\StudioBackendBundle\\Updater\\Service\\UpdateService->{closure:Pimcore\\Bundle\\StudioBackendBundle\\Updater\\Service\\UpdateService::update():101}()
#7 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Updater/Service/UpdateService.php(109): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\CoauthorService->runWithCoauthor(NULL, Object(Closure))
#8 /var/www/html/vendor/pimcore/studio-backend-bundle/src/DataObject/Controller/UpdateController.php(78): Pimcore\\Bundle\\StudioBackendBundle\\Updater\\Service\\UpdateService->update(\'object\', 4, Array)
#9 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(185): Pimcore\\Bundle\\StudioBackendBundle\\DataObject\\Controller\\UpdateController->dataObjectUpdateById(4, Object(Pimcore\\Bundle\\StudioBackendBundle\\MappedParameter\\DataParameter))
#10 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)
#11 /var/www/html/vendor/symfony/http-kernel/Kernel.php(195): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#12 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(34): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))
#13 /var/www/html/vendor/autoload_runtime.php(32): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#14 /var/www/html/public/index.php(16): require_once(\'/var/www/html/v...\')
#15 {main}', 6, NULL, NULL, 1, 'fs', NULL, NULL);

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

UPDATE versions SET `id` = 9, `cid` = 4, `ctype` = 'object', `userId` = 1, `note` = '', `date` = 1793106032, `public` = 0, `serialized` = 1, `stackTrace` = '#0 /var/www/html/vendor/pimcore/pimcore/models/Element/AbstractElement.php(660): Pimcore\\Model\\Version->save()
#1 /var/www/html/vendor/pimcore/pimcore/models/DataObject/Concrete.php(280): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion(NULL, true, true, true)
#2 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/ElementSaveService.php(85): Pimcore\\Model\\DataObject\\Concrete->saveVersion(true, true, NULL, true)
#3 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/ElementSaveService.php(64): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\ElementSaveService->processVersionTasks(Object(Pimcore\\Model\\DataObject\\Product), Object(Pimcore\\Model\\User), \'autoSave\')
#4 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/ElementSaveService.php(53): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\ElementSaveService->processTask(Object(Pimcore\\Model\\DataObject\\Product), Object(Pimcore\\Model\\User), \'autoSave\')
#5 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Updater/Service/UpdateService.php(102): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\ElementSaveService->save(Object(Pimcore\\Model\\DataObject\\Product), Object(Pimcore\\Model\\User), \'autoSave\')
#6 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Element/Service/CoauthorService.php(65): Pimcore\\Bundle\\StudioBackendBundle\\Updater\\Service\\UpdateService->{closure:Pimcore\\Bundle\\StudioBackendBundle\\Updater\\Service\\UpdateService::update():101}()
#7 /var/www/html/vendor/pimcore/studio-backend-bundle/src/Updater/Service/UpdateService.php(109): Pimcore\\Bundle\\StudioBackendBundle\\Element\\Service\\CoauthorService->runWithCoauthor(NULL, Object(Closure))
#8 /var/www/html/vendor/pimcore/studio-backend-bundle/src/DataObject/Controller/UpdateController.php(78): Pimcore\\Bundle\\StudioBackendBundle\\Updater\\Service\\UpdateService->update(\'object\', 4, Array)
#9 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(185): Pimcore\\Bundle\\StudioBackendBundle\\DataObject\\Controller\\UpdateController->dataObjectUpdateById(4, Object(Pimcore\\Bundle\\StudioBackendBundle\\MappedParameter\\DataParameter))
#10 /var/www/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)
#11 /var/www/html/vendor/symfony/http-kernel/Kernel.php(195): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#12 /var/www/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(34): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))
#13 /var/www/html/vendor/autoload_runtime.php(32): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#14 /var/www/html/public/index.php(16): require_once(\'/var/www/html/v...\')
#15 {main}', `versionCount` = 6, `binaryFileHash` = NULL, `binaryFileId` = NULL, `autoSave` = 1, `storageType` = 'fs', `coauthorType` = NULL, `coauthor` = NULL WHERE `id` = 9;

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\GenericDataIndexBundle\\PimcoreGenericDataIndexBundle' AND scope = 'pimcore';

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

SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\GenericDataIndexBundle\\PimcoreGenericDataIndexBundle' AND scope = 'pimcore';

SELECT
  *
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 * FROM versions WHERE cid = 4 AND ctype = 'object' AND (`date` > 1793105999 OR versionCount > 1) AND ((autoSave = 1 AND userId = 1) OR autoSave = 0)  ORDER BY `versionCount` DESC LIMIT 1;

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1');

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

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

SELECT
  `id`,
  `name`
FROM
  classes
WHERE
  id = ?

SELECT `id`, `name` FROM classes WHERE id = '3' ;

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 > 1793106032 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4');