Symfony Profiler

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

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 > 1789641170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_906
tags
', 'class_6
tags
', 'asset_297
tags
', 'asset_298
tags
', 'asset_299
tags
', 'asset_300
tags
', 'asset_301
tags
', 'asset_302
tags
', 'asset_303
tags
');

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

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = '6';

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

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

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

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

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

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

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

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

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 > 1789641170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_835
tags
', 'class_6
tags
', 'asset_303
tags
', 'asset_297
tags
', 'asset_298
tags
', 'asset_299
tags
', 'asset_300
tags
', 'asset_301
tags
', 'asset_302
tags
');

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

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

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

DELETE FROM schedule_tasks WHERE `cid` = 906 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 = 906 AND cType = 'object' AND userId = 1  ;

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 906 FOR UPDATE;

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

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

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 > 1789641170 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_properties_906');

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

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

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

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

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

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

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

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 > 1789641170 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 > 1789641170 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, 835, 100, 25, 5, 3)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'object'

SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,835,100,25,5,3) AND inheritable = 1)
                         OR cid = 906 ) 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 > 1789641170 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 > 1789641170 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`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 906, 'object', 1, '', 1789641170, 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/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 /var/www/pimcore/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#8 /var/www/pimcore/public/index.php(19): require_once(\'...\')
#9 {main}', 8, NULL, NULL, 1, 'fs');

SELECT
  COUNT(*)
FROM
  object_6
WHERE
  parentId = ?
  AND object_6.type IN ('object', 'variant')

SELECT COUNT(*) FROM object_6 WHERE parentId = 906 AND  object_6.type IN ('object','variant');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:26:\\\"messenger.bus.pimcore-core\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:37:\\\"App\\\\Message\\\\SyncMagentoProductMessage\\\":2:{s:48:\\\"\\0App\\\\Message\\\\SyncMagentoProductMessage\\0productId\\\";i:906;s:45:\\\"\\0App\\\\Message\\\\SyncMagentoProductMessage\\0action\\\";s:6:\\\"upsert\\\";}}', '[]', 'default', '2026-09-17 10:32:50', '2026-09-17 10:32:50');

"COMMIT"

"COMMIT";

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 '/Categories/Gold/Men/Mens Chains/BECGJSWBACH2600835/BECGJSWBACH2600906/%' 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, 835, 100, 25, 5, 3)
  AND `type` = 'object'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,835,100,25,5,3) AND `type`='object' AND locked = 'propagate' LIMIT 1;

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

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

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 '/Categories/Gold/Men/Mens Chains/BECGJSWBACH2600835/BECGJSWBACH2600906/%' 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, 835, 100, 25, 5, 3)
  AND `type` = 'object'
  AND locked = 'propagate'
LIMIT
  1

SELECT id FROM tree_locks WHERE id IN (1,835,100,25,5,3) AND `type`='object' AND locked = 'propagate' LIMIT 1;

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

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

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

SELECT
  *
FROM
  object_store_6
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_6 WHERE oo_id = 906 FOR UPDATE;

select
  `image_gallery`
from
  object_store_6
where
  oo_id = 906

select `image_gallery` from object_store_6 where oo_id  = 906;

select
  `video_gallery`
from
  object_store_6
where
  oo_id = 906

select `video_gallery` from object_store_6 where oo_id  = 906;

SELECT
  *
FROM
  object_relations_6
WHERE
  src_id = ?

SELECT * FROM object_relations_6 WHERE src_id = 906;