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

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

"COMMIT"

"COMMIT";

SELECT
  object_Product.id as id,
  object_Product.type as `type`
FROM
  object_Product
WHERE
  parentId = ?
  AND object_Product.type IN ('object', 'variant', 'folder')
ORDER BY
  `key` ASC

SELECT object_Product.id as id, object_Product.type as `type` FROM object_Product WHERE parentId = 216861 AND  object_Product.type IN ('object','variant','folder') ORDER BY `key` ASC  ;

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 12;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 12;

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, 219805, 'object', 12, '', 1780404664, 0, 1, '#0 /home/dev-pim/www/vendor/pimcore/pimcore/models/Element/AbstractElement.php(607): Pimcore\\Model\\Version->save()
#1 /home/dev-pim/www/vendor/pimcore/pimcore/models/DataObject/Concrete.php(268): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion()
#2 /home/dev-pim/www/vendor/pimcore/pimcore/models/DataObject/Concrete.php(206): Pimcore\\Model\\DataObject\\Concrete->saveVersion()
#3 /home/dev-pim/www/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(550): Pimcore\\Model\\DataObject\\Concrete->update()
#4 /home/dev-pim/www/vendor/pimcore/pimcore/models/DataObject/Concrete.php(637): Pimcore\\Model\\DataObject\\AbstractObject->save()
#5 /home/dev-pim/www/bundles/FormBundle/src/Service/PharmaOrderService.php(471): Pimcore\\Model\\DataObject\\Concrete->save()
#6 /home/dev-pim/www/bundles/FormBundle/src/Service/PharmaOrderService.php(197): FormBundle\\Service\\PharmaOrderService->findAndUpdateOrCreateCustomer()
#7 /home/dev-pim/www/bundles/FormBundle/src/Controller/AdminFormController.php(120): FormBundle\\Service\\PharmaOrderService->processSubmission()
#8 /home/dev-pim/www/vendor/symfony/http-kernel/HttpKernel.php(181): FormBundle\\Controller\\AdminFormController->pharmaCreateOrderFormAction()
#9 /home/dev-pim/www/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#10 /home/dev-pim/www/vendor/symfony/http-kernel/Kernel.php(208): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#11 /home/dev-pim/www/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#12 /home/dev-pim/www/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#13 /home/dev-pim/www/public/index.php(19): require_once(\'...\')
#14 {main}', 8, NULL, NULL, 0, 'fs');

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 12;

SELECT
  id
FROM
  objects
WHERE
  `path` = BINARY ?
  AND `key` = BINARY ?

SELECT id FROM objects WHERE `path` = BINARY '/Produkte/Pharma/' AND `key` = BINARY 'PE-Nahrung';

SELECT
  id,
  type
FROM
  users
WHERE
  id > 0
  AND `type` IN ('user', 'userfolder')
ORDER BY
  `name` ASC

SELECT id,type FROM users WHERE id > 0 AND `type` IN ('user','userfolder') ORDER BY `name` ASC;

UPDATE
  objects
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `key` = ?,
  `index` = ?,
  `childrenSortBy` = ?,
  `childrenSortOrder` = ?,
  `classId` = ?,
  `published` = ?,
  `className` = ?
WHERE
  `id` = ?

UPDATE objects SET `path` = '/Kunden/M/', `id` = 219805, `creationDate` = 1777881080, `modificationDate` = 1780404664, `versionCount` = 8, `userOwner` = 12, `userModification` = 12, `parentId` = 219804, `type` = 'object', `key` = 'Max-Mustermann', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'Customer', `published` = 1, `className` = 'Customer' WHERE `id` = 219805;

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:69:\\\"Pimcore\\\\Bundle\\\\SimpleBackendSearchBundle\\\\Message\\\\SearchBackendMessage\\\":2:{s:7:\\\"\\0*\\0type\\\";s:6:\\\"object\\\";s:5:\\\"\\0*\\0id\\\";i:219805;}}', '[]', 'pimcore_search_backend_message', '2026-06-02 12:51:04', '2026-06-02 12:51:04');

INSERT INTO objects (`key`, `path`)
VALUES
  (?, ?)

INSERT INTO objects (`key`, `path`) VALUES ('order-20260602-145104', '/Kunden/M/Max-Mustermann/');

UPDATE
  email_log
SET
  `id` = ?,
  `documentId` = ?,
  `params` = ?,
  `requestUri` = ?,
  `from` = ?,
  `replyTo` = ?,
  `to` = ?,
  `cc` = ?,
  `bcc` = ?,
  `sentDate` = ?,
  `subject` = ?,
  `error` = ?
WHERE
  id = ?

UPDATE email_log SET `id` = 688, `documentId` = NULL, `params` = '[{\"key\":\"Debug-Redirected\",\"data\":{\"type\":\"simple\",\"value\":\"true\"}},{\"key\":\"Debug-Original-From\",\"data\":{\"type\":\"simple\",\"value\":\"\\\"Homecare von Morgen\\\" <ticket@homecare-vm.de>\"}},{\"key\":\"Debug-Original-To\",\"data\":{\"type\":\"simple\",\"value\":\"c.unger@gesundheit-von-morgen.de\"}},{\"key\":\"Debug-Original-Cc\",\"data\":{\"type\":\"simple\",\"value\":\"\"}},{\"key\":\"Debug-Original-Bcc\",\"data\":{\"type\":\"simple\",\"value\":\"\"}},{\"key\":\"Debug-Original-ReplyTo\",\"data\":{\"type\":\"simple\",\"value\":\"C.Unger@gesundheit-von-morgen.de\"}}]', `requestUri` = '/admin/form/pharma/order?customerId=219805&amp;tab=create-order', `from` = '\"Homecare von Morgen\" <ticket@homecare-vm.de>', `replyTo` = 'C.Unger@gesundheit-von-morgen.de', `to` = 'c.unger@gesundheit-von-morgen.de', `cc` = NULL, `bcc` = NULL, `sentDate` = 1780404665, `subject` = 'Neue Bestellung HvM Pharma GmbH | Max Mustermann', `error` = NULL WHERE id = 688;

DELETE FROM
  cache_items
WHERE
  item_id IN (?, ?)

DELETE FROM cache_items WHERE item_id IN ('object_219805
tags
', 'object_properties
tags
');

INSERT INTO assets (filename, path, parentId)
VALUES
  (?, ?, ?)

INSERT INTO assets (filename, path, parentId) VALUES ('06', '/Bestellungen/Dokumente/2026/', 680);

INSERT INTO application_logs (
  pid, priority, message, timestamp,
  component, fileobject, relatedobject,
  relatedobjecttype, source
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO application_logs (pid, priority, message, timestamp, component, fileobject, relatedobject, relatedobjecttype, source) VALUES (2554556, 'info', 'Imagick PDF conversion failed, trying GD fallback: Failed to get the image contents (empty or invalid image?)', '2026-06-02 12:51:04', 'FormBundle\\Service\\PharmaOrderService', NULL, NULL, NULL, 'FormBundle\\Service\\PharmaOrderService::convertImageToPdf:804');

INSERT INTO dependencies (
  sourceid, sourcetype, targetid, targettype
)
VALUES
  (?, ?, ?, ?)

INSERT INTO dependencies (sourceid, sourcetype, targetid, targettype) VALUES (226054, 'object', 219805, 'object');

SELECT
  id,
  targetType,
  targetId
FROM
  dependencies
WHERE
  sourceType = ?
  AND sourceId = ?

SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 219805;

SELECT
  id
FROM
  assets
WHERE
  `path` = BINARY ?
  AND `filename` = BINARY ?

SELECT id FROM assets WHERE `path` = BINARY '/Bestellungen/Dokumente/2026/06/' AND `filename` = BINARY '02';

SELECT
  *
FROM
  translations_messages
LIMIT
  1;

SELECT * FROM translations_messages LIMIT 1;;

INSERT INTO objects (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `key`, `index`,
  `childrenSortBy`, `childrenSortOrder`,
  `classId`, `published`, `className`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/Kunden/M/', 219805, 1777881080, 1780404664, 8, 12, 12, 219804, 'object', 'Max-Mustermann', 0, NULL, NULL, 'Customer', 1, 'Customer');

SELECT
  *
FROM
  translations_messages
WHERE
  `key` = ?
  AND `language` IN (?)
ORDER BY
  `creationDate`

SELECT * FROM translations_messages WHERE `key` = 'PharmaOrderMail.Subject'
            AND `language` IN ('de') ORDER BY `creationDate` ;

INSERT INTO email_log ()
VALUES
  ()

INSERT INTO email_log () VALUES ();

SELECT
  *
FROM
  object_relations_Order
WHERE
  dest_id = ?
  AND fieldname = ?
  AND ownertype = 'object'

SELECT * FROM object_relations_Order WHERE dest_id = 219805 AND fieldname = 'customer' AND ownertype = 'object';

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

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

SELECT
  object_OrderRecipient.id as id,
  object_OrderRecipient.type as `type`
FROM
  object_OrderRecipient
WHERE
  parentId = ?
  AND object_OrderRecipient.type IN ('object', 'variant', 'folder')
ORDER BY
  `key` ASC

SELECT object_OrderRecipient.id as id, object_OrderRecipient.type as `type` FROM object_OrderRecipient WHERE parentId = 219304 AND  object_OrderRecipient.type IN ('object','variant','folder') ORDER BY `key` ASC  ;

SELECT
  *
FROM
  email_blocklist
WHERE
  address = ?

SELECT * FROM email_blocklist WHERE address = 'c.unger@gesundheit-von-morgen.de';

SELECT
  CONCAT(`path`, `key`) as `path`
FROM
  objects
WHERE
  id = ?

SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 219804;

SELECT
  assets.*,
  tree_locks.locked
FROM
  assets
  LEFT JOIN tree_locks ON assets.id = tree_locks.id
  AND tree_locks.type = 'asset'
WHERE
  assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets
            LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'
                WHERE assets.id = 680;

INSERT INTO lock_keys (
  key_id, key_token, key_expiration
)
VALUES
  (
    ?,
    ?,
    UNIX_TIMESTAMP(
      NOW(6)
    ) + 300
  )

INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('eeb1b76e68cab380e6b85b21c7050bf0841598731b05a9cfba69b04f69a17488', 'nOGW/kgyPKL5r3P/TYhrZ4qk1hDKT8pxF/usg5LzTZ4=', UNIX_TIMESTAMP(NOW(6)) + 300);

DELETE FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?

DELETE FROM lock_keys WHERE key_id = 'eeb1b76e68cab380e6b85b21c7050bf0841598731b05a9cfba69b04f69a17488' AND key_token = 'nOGW/kgyPKL5r3P/TYhrZ4qk1hDKT8pxF/usg5LzTZ4=';

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_query_Order
WHERE
  oo_id = ?

SELECT * FROM object_query_Order WHERE oo_id = 226054;

SELECT
  *
FROM
  object_relations_Order
WHERE
  src_id = ?

SELECT * FROM object_relations_Order WHERE src_id = 226054;

SELECT
  id
FROM
  classes
WHERE
  name = ?

SELECT id FROM classes WHERE name = 'Order';

SELECT
  object_Customer.id as id,
  object_Customer.type as `type`
FROM
  object_Customer
WHERE
  firstname = ?
  AND lastname = ?
  AND birthdate = ?
  AND object_Customer.type IN ('object', 'variant', 'folder')
LIMIT
  1

SELECT object_Customer.id as id, object_Customer.type as `type` FROM object_Customer WHERE firstname = 'Max' AND lastname = 'Mustermann' AND birthdate = '1950-01-01' AND  object_Customer.type IN ('object','variant','folder') LIMIT 1;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

DELETE FROM tree_locks WHERE id = 219805 AND type = 'object';

"START TRANSACTION"

"START TRANSACTION";

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

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

DELETE FROM
  object_metadata_Order
WHERE
  id = '226054'
  AND fieldname = 'productsParenteralNutrition'
  AND position = '0'

DELETE FROM object_metadata_Order WHERE id = '226054' AND fieldname = 'productsParenteralNutrition' AND position = '0';

INSERT INTO object_store_Order (
  `oo_id`, `dateTimeOrder`, `user`,
  `customerNumber`, `firstname`, `lastname`,
  `email`, `phone`, `birthdate`, `careLevel`,
  `isNewCustomer`, `street`, `housenumber`,
  `zipCode`, `city`, `deliveryFirstname`,
  `deliveryLastname`, `deliveryAddressStreet`,
  `deliveryAddressHousenumber`, `deliveryAddressZipCode`,
  `deliveryAddressCity`, `customerSource`,
  `location`, `dateTimeDelivery`,
  `dateDelivery`, `deliveryTimeSelection`,
  `advertisingConsent`, `paymentExemption`,
  `blockEmailReceivers`, `notes`,
  `blockProductsParenteralNutrition`,
  `blockProductsAdditivesRinsingSyringes`,
  `blockProductsInfusionSolutions`,
  `productsCompoundingParenteralNutrition`,
  `blockProductsOthers`, `dateTimeSent`,
  `blockSentEmailReceivers`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_store_Order (`oo_id`, `dateTimeOrder`, `user`, `customerNumber`, `firstname`, `lastname`, `email`, `phone`, `birthdate`, `careLevel`, `isNewCustomer`, `street`, `housenumber`, `zipCode`, `city`, `deliveryFirstname`, `deliveryLastname`, `deliveryAddressStreet`, `deliveryAddressHousenumber`, `deliveryAddressZipCode`, `deliveryAddressCity`, `customerSource`, `location`, `dateTimeDelivery`, `dateDelivery`, `deliveryTimeSelection`, `advertisingConsent`, `paymentExemption`, `blockEmailReceivers`, `notes`, `blockProductsParenteralNutrition`, `blockProductsAdditivesRinsingSyringes`, `blockProductsInfusionSolutions`, `productsCompoundingParenteralNutrition`, `blockProductsOthers`, `dateTimeSent`, `blockSentEmailReceivers`) VALUES (226054, '2026-06-02 14:51:04', '12', '', 'Max', 'Mustermann', '', '0123456789', '1950-01-01', '', -1, 'Standardstraße', '123', '98654', 'Musterhausen', '', '', '', '', '', '', 'Uniklinikum Köln', '', NULL, NULL, '', NULL, 1, 'a:1:{i:0;a:2:{s:5:\"title\";a:3:{s:4:\"name\";s:5:\"title\";s:4:\"type\";s:5:\"input\";s:4:\"data\";s:22:\"(Kopie)-E-Mail-Adresse\";}s:5:\"email\";a:3:{s:4:\"name\";s:5:\"email\";s:4:\"type\";s:5:\"input\";s:4:\"data\";s:32:\"c.unger@gesundheit-von-morgen.de\";}}}', '', 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:0:{}', 'a:0:{}', NULL, 'a:0:{}');

UPDATE
  object_store_Order
SET
  `oo_id` = ?,
  `dateTimeOrder` = ?,
  `user` = ?,
  `customerNumber` = ?,
  `firstname` = ?,
  `lastname` = ?,
  `email` = ?,
  `phone` = ?,
  `birthdate` = ?,
  `careLevel` = ?,
  `isNewCustomer` = ?,
  `street` = ?,
  `housenumber` = ?,
  `zipCode` = ?,
  `city` = ?,
  `deliveryFirstname` = ?,
  `deliveryLastname` = ?,
  `deliveryAddressStreet` = ?,
  `deliveryAddressHousenumber` = ?,
  `deliveryAddressZipCode` = ?,
  `deliveryAddressCity` = ?,
  `customerSource` = ?,
  `location` = ?,
  `dateTimeDelivery` = ?,
  `dateDelivery` = ?,
  `deliveryTimeSelection` = ?,
  `advertisingConsent` = ?,
  `paymentExemption` = ?,
  `blockEmailReceivers` = ?,
  `notes` = ?,
  `blockProductsParenteralNutrition` = ?,
  `blockProductsAdditivesRinsingSyringes` = ?,
  `blockProductsInfusionSolutions` = ?,
  `productsCompoundingParenteralNutrition` = ?,
  `blockProductsOthers` = ?,
  `dateTimeSent` = ?,
  `blockSentEmailReceivers` = ?
WHERE
  `oo_id` = ?

UPDATE object_store_Order SET `oo_id` = 226054, `dateTimeOrder` = '2026-06-02 14:51:04', `user` = '12', `customerNumber` = '', `firstname` = 'Max', `lastname` = 'Mustermann', `email` = '', `phone` = '0123456789', `birthdate` = '1950-01-01', `careLevel` = '', `isNewCustomer` = -1, `street` = 'Standardstraße', `housenumber` = '123', `zipCode` = '98654', `city` = 'Musterhausen', `deliveryFirstname` = '', `deliveryLastname` = '', `deliveryAddressStreet` = '', `deliveryAddressHousenumber` = '', `deliveryAddressZipCode` = '', `deliveryAddressCity` = '', `customerSource` = 'Uniklinikum Köln', `location` = '', `dateTimeDelivery` = NULL, `dateDelivery` = NULL, `deliveryTimeSelection` = '', `advertisingConsent` = NULL, `paymentExemption` = 1, `blockEmailReceivers` = 'a:1:{i:0;a:2:{s:5:\"title\";a:3:{s:4:\"name\";s:5:\"title\";s:4:\"type\";s:5:\"input\";s:4:\"data\";s:22:\"(Kopie)-E-Mail-Adresse\";}s:5:\"email\";a:3:{s:4:\"name\";s:5:\"email\";s:4:\"type\";s:5:\"input\";s:4:\"data\";s:32:\"c.unger@gesundheit-von-morgen.de\";}}}', `notes` = '', `blockProductsParenteralNutrition` = 'a:0:{}', `blockProductsAdditivesRinsingSyringes` = 'a:0:{}', `blockProductsInfusionSolutions` = 'a:0:{}', `productsCompoundingParenteralNutrition` = 'a:0:{}', `blockProductsOthers` = 'a:0:{}', `dateTimeSent` = '2026-06-02 14:51:05', `blockSentEmailReceivers` = 'a:1:{i:0;a:2:{s:5:\"title\";a:3:{s:4:\"name\";s:5:\"title\";s:4:\"type\";s:5:\"input\";s:4:\"data\";s:10:\"Debug Mail\";}s:5:\"email\";a:3:{s:4:\"name\";s:5:\"email\";s:4:\"type\";s:5:\"input\";s:4:\"data\";s:32:\"c.unger@gesundheit-von-morgen.de\";}}}' WHERE `oo_id` = 226054;

SELECT
  CONCAT(`path`, filename) as `path`
FROM
  assets
WHERE
  id = ?

SELECT CONCAT(`path`,filename) as `path` FROM assets WHERE id = 680;

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/form/pharma/order' AND (`type` = 'path' OR `type` = 'auto_create')) OR
                (source = '/admin/form/pharma/order?customerId=219805&tab=create-order' AND `type` = 'path_query') OR
                (source = 'https://dev.pim.hvm.care/admin/form/pharma/order?customerId=219805&tab=create-order' 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;

SHOW COLUMNS
FROM
  object_store_Order

SHOW COLUMNS FROM object_store_Order;

SELECT
  `name`
FROM
  assets_metadata
WHERE
  cid = ?
LIMIT
  1

SELECT `name` FROM assets_metadata WHERE cid = 1052 LIMIT 1;

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 (30, 1780404664, 'system_cache_write_lock', 0x000000021701A9140111064F2EE107C01E0A6A1ED1B8) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);

UPDATE
  assets
SET
  `path` = ?,
  `id` = ?,
  `creationDate` = ?,
  `modificationDate` = ?,
  `versionCount` = ?,
  `userOwner` = ?,
  `userModification` = ?,
  `parentId` = ?,
  `type` = ?,
  `filename` = ?,
  `mimetype` = ?,
  `customSettings` = ?,
  `hasMetaData` = ?,
  `dataModificationDate` = ?
WHERE
  `id` = ?

UPDATE assets SET `path` = '/Bestellungen/Dokumente/2026/', `id` = 1052, `creationDate` = 1780404664, `modificationDate` = 1780404664, `versionCount` = 1, `userOwner` = 1, `userModification` = 0, `parentId` = 680, `type` = 'folder', `filename` = '06', `mimetype` = NULL, `customSettings` = 'a:0:{}', `hasMetaData` = 0, `dataModificationDate` = NULL WHERE `id` = 1052;

SHOW COLUMNS
FROM
  assets

SHOW COLUMNS FROM assets;

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

SHOW COLUMNS
FROM
  object_query_Order

SHOW COLUMNS FROM object_query_Order;

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

SHOW COLUMNS
FROM
  object_store_Customer

SHOW COLUMNS FROM object_store_Customer;

INSERT INTO assets (
  `path`, `id`, `creationDate`, `modificationDate`,
  `versionCount`, `userOwner`, `userModification`,
  `parentId`, `type`, `filename`, `mimetype`,
  `customSettings`, `hasMetaData`,
  `dataModificationDate`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO assets (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `filename`, `mimetype`, `customSettings`, `hasMetaData`, `dataModificationDate`) VALUES ('/Bestellungen/Dokumente/2026/', 1052, 1780404664, 1780404664, 1, 1, 0, 680, 'folder', '06', NULL, 'a:0:{}', 0, NULL);

SHOW COLUMNS
FROM
  object_query_Customer

SHOW COLUMNS FROM object_query_Customer;

SHOW COLUMNS
FROM
  versions

SHOW COLUMNS FROM versions;

SHOW COLUMNS
FROM
  email_log

SHOW COLUMNS FROM email_log;

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'Customer';

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

SELECT type,classId,className FROM objects WHERE id = 219805;

SELECT
  1
FROM
  lock_keys
WHERE
  key_id = ?
  AND key_token = ?
  AND key_expiration > UNIX_TIMESTAMP(
    NOW(6)
  )

SELECT 1 FROM lock_keys WHERE key_id = 'eeb1b76e68cab380e6b85b21c7050bf0841598731b05a9cfba69b04f69a17488' AND key_token = 'nOGW/kgyPKL5r3P/TYhrZ4qk1hDKT8pxF/usg5LzTZ4=' AND key_expiration > UNIX_TIMESTAMP(NOW(6));

SELECT
  versionCount
FROM
  assets
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM assets WHERE id = 1052 FOR UPDATE;

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

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

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 219805 FOR UPDATE;

SELECT
  *
FROM
  object_relations_Customer
WHERE
  src_id = ?

SELECT * FROM object_relations_Customer WHERE src_id = 219805;

SELECT
  *
FROM
  tmp_store
WHERE
  id = ?

SELECT * FROM tmp_store WHERE id = 'maintenance_mode';

INSERT INTO object_store_Customer (
  `oo_id`, `dateTimeCreation`, `createdByUser`,
  `isTest`, `customerNumber`, `firstname`,
  `lastname`, `email`, `phone`, `birthdate`,
  `careLevel`, `street`, `housenumber`,
  `zipCode`, `city`, `deliveryAddressStreet`,
  `deliveryAddressHousenumber`, `deliveryAddressZipCode`,
  `deliveryAddressCity`, `customerSource`,
  `location`, `advertisingConsent`,
  `paymentExemption`, `exitReason`,
  `exitDate`, `exitNotes`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_store_Customer (`oo_id`, `dateTimeCreation`, `createdByUser`, `isTest`, `customerNumber`, `firstname`, `lastname`, `email`, `phone`, `birthdate`, `careLevel`, `street`, `housenumber`, `zipCode`, `city`, `deliveryAddressStreet`, `deliveryAddressHousenumber`, `deliveryAddressZipCode`, `deliveryAddressCity`, `customerSource`, `location`, `advertisingConsent`, `paymentExemption`, `exitReason`, `exitDate`, `exitNotes`) VALUES (219805, '2026-05-04 09:51:20', '12', 1, '9871234', 'Max', 'Mustermann', '', '0123456789', '1950-01-01', 'unknown', 'Standardstraße', '123', '98654', 'Musterhausen', '', '', '', '', 'Uniklinikum Köln', 'Köln', 1, 1, NULL, NULL, NULL);

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1, 680, 665, 664)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'asset'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1,680,665,664) AND inheritable = 1) OR cid = 1052 )
                                 AND ctype='asset';

UPDATE
  assets
SET
  customSettings = ?
WHERE
  id = ?

UPDATE assets SET customSettings = 'a:1:{s:8:\"checksum\";s:32:\"972b858d26a5579a77e0784127b3b8ad\";}' WHERE id = 1054;

SELECT
  IFNULL(binaryFileId, id)
FROM
  versions
WHERE
  binaryFileHash = ?
  AND cid = ?
  AND storageType = ?
ORDER BY
  id ASC
LIMIT
  1

SELECT IFNULL(binaryFileId, id) FROM versions WHERE binaryFileHash = '5b3db0ace5c44ac586b76abdf147c04aff8854dc07892dcc397a58249d3093cecde093f621f4b13c89f114df81f39a4e776761278805eeed67e16cd4d2aa138c' AND cid = 1054 AND storageType = 'fs' ORDER BY id ASC LIMIT 1;

INSERT INTO object_query_Order (
  `dateTimeOrder`, `user`, `customerNumber`,
  `firstname`, `lastname`, `email`,
  `phone`, `birthdate`, `careLevel`,
  `isNewCustomer`, `street`, `housenumber`,
  `zipCode`, `city`, `deliveryFirstname`,
  `deliveryLastname`, `deliveryAddressStreet`,
  `deliveryAddressHousenumber`, `deliveryAddressZipCode`,
  `deliveryAddressCity`, `customerSource`,
  `location`, `dateTimeDelivery`,
  `dateDelivery`, `deliveryTimeSelection`,
  `advertisingConsent`, `paymentExemption`,
  `notes`, `dateTimeSent`, `oo_id`
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO object_query_Order (`dateTimeOrder`, `user`, `customerNumber`, `firstname`, `lastname`, `email`, `phone`, `birthdate`, `careLevel`, `isNewCustomer`, `street`, `housenumber`, `zipCode`, `city`, `deliveryFirstname`, `deliveryLastname`, `deliveryAddressStreet`, `deliveryAddressHousenumber`, `deliveryAddressZipCode`, `deliveryAddressCity`, `customerSource`, `location`, `dateTimeDelivery`, `dateDelivery`, `deliveryTimeSelection`, `advertisingConsent`, `paymentExemption`, `notes`, `dateTimeSent`, `oo_id`) VALUES ('2026-06-02 14:51:04', '12', '', 'Max', 'Mustermann', '', '0123456789', '1950-01-01', '', -1, 'Standardstraße', '123', '98654', 'Musterhausen', '', '', '', '', '', '', 'Uniklinikum Köln', '', NULL, NULL, '', NULL, 1, '', '2026-06-02 14:51:05', 226054);