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

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

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

SELECT id FROM documents WHERE `path` = BINARY '/webhook/shopify/leomat/' AND `key` = BINARY 'order';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify/leomat/order';

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

SELECT id FROM documents WHERE `path` = BINARY '/webhook/shopify/' AND `key` = BINARY 'leomat';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify/leomat';

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

SELECT id FROM documents WHERE `path` = BINARY '/webhook/' AND `key` = BINARY 'shopify';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify';

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

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'webhook';

SELECT
  id
FROM
  documents_page
WHERE
  prettyUrl = ?

SELECT id FROM documents_page WHERE prettyUrl = '/webhook';

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

SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';

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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1
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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1');

SELECT
  *
FROM
  properties
WHERE
  (
    (
      cid IN (1)
      AND inheritable = 1
    )
    OR cid = ?
  )
  AND ctype = 'document'

SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = 1
                             ) AND ctype='document';

SELECT
  object_shopifyconfig.id as id,
  object_shopifyconfig.type as `type`
FROM
  object_shopifyconfig
WHERE
  (
    active = 1
    AND object_shopifyconfig.type IN ('object', 'variant', 'folder')
  )
  AND object_shopifyconfig.published = 1

SELECT object_shopifyconfig.id as id, object_shopifyconfig.type as `type` FROM object_shopifyconfig WHERE (active = 1 AND  object_shopifyconfig.type IN ('object','variant','folder')) AND object_shopifyconfig.published = 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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_263');

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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_263
tags
', 'class_shopifyconfig
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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4654');

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

SELECT
  object_orders.id as id,
  object_orders.type as `type`
FROM
  object_orders
WHERE
  (
    orderId = ?
    AND object_orders.type IN ('object', 'variant', 'folder')
  )
  AND object_orders.published = 1

SELECT object_orders.id as id, object_orders.type as `type` FROM object_orders WHERE (orderId = 7661270630738 AND  object_orders.type IN ('object','variant','folder')) AND object_orders.published = 1;

SELECT
  object_orders.id as id,
  object_orders.type as `type`
FROM
  object_orders
WHERE
  (
    orderId = ?
    AND object_orders.type IN ('object', 'variant', 'folder')
  )
  AND object_orders.published = 1

SELECT object_orders.id as id, object_orders.type as `type` FROM object_orders WHERE (orderId = 7661270630738 AND  object_orders.type IN ('object','variant','folder')) AND object_orders.published = 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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19152');

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

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

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

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

SELECT
  *
FROM
  object_store_orders
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_orders WHERE oo_id = 19152 FOR UPDATE;

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

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

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

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

SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = 19152 AND fieldname = 'payload' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_relations_orders
WHERE
  src_id = ?

SELECT * FROM object_relations_orders WHERE src_id = 19152;

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

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

SELECT
  object_localized_product_de.id as id,
  object_localized_product_de.type as `type`
FROM
  object_localized_product_de
WHERE
  (
    `sku` = '304'
    AND object_localized_product_de.type IN ('variant', 'object')
  )
  AND object_localized_product_de.published = 1
LIMIT
  1

SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '304'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_17900');

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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_17900
tags
', 'class_product
tags
', 'asset_288
tags
');

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

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

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

SELECT
  *
FROM
  object_store_product
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_product WHERE oo_id = 17900 FOR UPDATE;

SELECT
  *
FROM
  object_localized_data_product
WHERE
  ooo_id = ?
  AND language IN ('de', 'fr')

SELECT * FROM object_localized_data_product WHERE ooo_id = 17900 AND language IN ('de','fr');

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

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

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

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

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

SELECT
  *
FROM
  object_relations_product
WHERE
  src_id = ?

SELECT * FROM object_relations_product WHERE src_id = 17900;

SELECT
  object_vendor.id as id,
  object_vendor.type as `type`
FROM
  object_vendor
WHERE
  (
    shopifyVendorId = ?
    OR name = ?
    AND object_vendor.type IN ('object', 'variant', 'folder')
  )
  AND object_vendor.published = 1

SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE (shopifyVendorId = 'Leomat' OR name = 'Leomat' AND  object_vendor.type IN ('object','variant','folder')) AND object_vendor.published = 1;

SELECT
  object_vendor.id as id,
  object_vendor.type as `type`
FROM
  object_vendor
WHERE
  (
    shopifyVendorId = ?
    OR name = ?
    AND object_vendor.type IN ('object', 'variant', 'folder')
  )
  AND object_vendor.published = 1

SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE (shopifyVendorId = 'Leomat' OR name = 'Leomat' AND  object_vendor.type IN ('object','variant','folder')) AND object_vendor.published = 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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6002');

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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6002
tags
', 'class_vendor
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 > 1781838074 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_19151');

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

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

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

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

SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/04/02/' AND `key` = BINARY '1034';

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

SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/04/02/' AND `key` = BINARY '1034';

"START TRANSACTION"

"START TRANSACTION";

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 19152 FOR UPDATE;

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

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

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

SHOW COLUMNS
FROM
  objects

SHOW COLUMNS FROM objects;

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

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

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 ('/Orders/Leomat/2026/04/02/', 19152, 1775116485, 1781838074, 3418, 0, 0, 19151, 'object', '1034', 0, NULL, NULL, 'orders', 1, 'Orders');

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` = '/Orders/Leomat/2026/04/02/', `id` = 19152, `creationDate` = 1775116485, `modificationDate` = 1781838074, `versionCount` = 3418, `userOwner` = 0, `userModification` = 0, `parentId` = 19151, `type` = 'object', `key` = '1034', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'orders', `published` = 1, `className` = 'Orders' WHERE `id` = 19152;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

SELECT
  `id`
FROM
  `object_collection_LineItems_orders`
WHERE
  `id` = '19152'
  AND `fieldname` = 'lineItems'
LIMIT
  1

SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '19152' AND `fieldname` = 'lineItems' LIMIT 1;

DELETE FROM
  object_collection_LineItems_orders
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_LineItems_orders WHERE id = 19152 AND fieldname = 'lineItems';

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'fieldcollection'
    AND ownername = 'lineItems'
    AND src_id = '19152'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '19152');

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'localizedfield'
    AND ownername LIKE '/fieldcollection~lineItems/%'
    AND src_id = '19152'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '19152');

INSERT INTO object_relations_orders (
  `dest_id`, `type`, `fieldname`, `src_id`,
  `ownertype`, `ownername`, `position`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (17900, 'object', 'product', 19152, 'fieldcollection', 'lineItems', '0');

INSERT INTO object_relations_orders (
  `dest_id`, `type`, `fieldname`, `src_id`,
  `ownertype`, `ownername`, `position`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (6002, 'object', 'vendor', 19152, 'fieldcollection', 'lineItems', '0');

INSERT INTO object_collection_LineItems_orders (
  `id`, `index`, `fieldname`, `title`,
  `sku`, `quantity`, `price__value`,
  `price__unit`, `fulfillmentStatus`,
  `taxable`, `metaData`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (19152, 0, 'lineItems', 'Assugrin Classic Spenderdose 300 Stk', '304', 1, 82, 'CHF', '', 0, '[]');

SELECT
  `id`
FROM
  `object_collection_ShopifyPayload_orders`
WHERE
  `id` = '19152'
  AND `fieldname` = 'payload'
LIMIT
  1

SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '19152' AND `fieldname` = 'payload' LIMIT 1;

DELETE FROM
  object_collection_ShopifyPayload_orders
WHERE
  id = ?
  AND fieldname = ?

DELETE FROM object_collection_ShopifyPayload_orders WHERE id = 19152 AND fieldname = 'payload';

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'fieldcollection'
    AND ownername = 'payload'
    AND src_id = '19152'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '19152');

DELETE FROM
  object_relations_orders
WHERE
  (
    ownertype = 'localizedfield'
    AND ownername LIKE '/fieldcollection~payload/%'
    AND src_id = '19152'
  )

DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '19152');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19152, 0, 'payload', '{\"id\":7661270630738,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7661270630738\",\"app_id\":580111,\"browser_ip\":\"49.43.89.138\",\"buyer_accepts_marketing\":true,\"cancel_reason\":\"declined\",\"cancelled_at\":\"2026-04-09T17:22:45+02:00\",\"cart_token\":\"hWNAYFBjl8LJ9zLRw9sOgguR\",\"checkout_id\":48218958037330,\"checkout_token\":\"d9afd6d4d13acf26691a4ad129673819\",\"client_details\":{\"accept_language\":\"de-DE\",\"browser_height\":null,\"browser_ip\":\"49.43.89.138\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/146.0.0.0 Safari\\/537.36\"},\"closed_at\":\"2026-04-09T17:22:45+02:00\",\"company\":null,\"confirmation_number\":\"VP5MUVP51\",\"confirmed\":true,\"contact_email\":\"leomat2@yopmail.com\",\"created_at\":\"2026-04-02T09:54:42+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"0.00\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"0.00\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-DE\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"leomat2@yopmail.com\",\"estimated_taxes\":false,\"financial_status\":\"voided\",\"fulfillment_status\":null,\"landing_site\":\"\\/\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1034\",\"note\":null,\"note_attributes\":[],\"number\":34,\"order_number\":1034,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/8df97da1faca8257c3105fc4d0815983\\/authenticate?key=fc351b7ec59353a744e8cb559735ac9c\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-02T09:54:41+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"82.00\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:rejected\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"8df97da1faca8257c3105fc4d0815983\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"82.00\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"0.00\",\"total_price\":\"82.00\",\"total_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-06-19T05:01:12+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Leo Mat\",\"address1\":\"Tübacher Weg 9327\",\"phone\":null,\"city\":\"Oberteuringen\",\"zip\":\"88094\",\"province\":null,\"country\":\"Germany\",\"last_name\":\"Testing\",\"address2\":null,\"company\":null,\"latitude\":47.7258058,\"longitude\":9.4651617,\"name\":\"Leo Mat Testing\",\"country_code\":\"DE\",\"province_code\":null},\"customer\":{\"id\":10153220473170,\"created_at\":\"2026-03-18T09:27:35+01:00\",\"updated_at\":\"2026-05-19T10:01:24+02:00\",\"first_name\":\"Leo\",\"last_name\":\"mat 2\",\"state\":\"enabled\",\"note\":\"\",\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"leomat2@yopmail.com\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10153220473170\",\"default_address\":{\"id\":12293988483410,\"customer_id\":10153220473170,\"first_name\":\"Leo Mat\",\"last_name\":\"Testing\",\"company\":null,\"address1\":\"Testrasse 1\",\"address2\":\"TEst 1\",\"city\":\"Tübach\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"9327\",\"phone\":null,\"name\":\"Leo Mat Testing\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18027351638354,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18027351638354\",\"attributed_staffs\":[],\"current_quantity\":0,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Assugrin Classic Spenderdose 300 Stk\",\"price\":\"82.00\",\"price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687686803794,\"properties\":[],\"quantity\":1,\"requires_shipping\":false,\"sales_line_item_group_id\":null,\"sku\":\"304\",\"taxable\":true,\"title\":\"Assugrin Classic Spenderdose 300 Stk\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072427057490,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[{\"id\":1074213749074,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Refund\\/1074213749074\",\"created_at\":\"2026-04-09T17:22:44+02:00\",\"note\":\"Order canceled\",\"order_id\":7661270630738,\"processed_at\":\"2026-04-09T17:22:44+02:00\",\"restock\":true,\"total_duties_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"user_id\":null,\"order_adjustments\":[],\"transactions\":[{\"id\":8835827859794,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/OrderTransaction\\/8835827859794\",\"amount\":\"0.00\",\"authorization\":null,\"created_at\":\"2026-04-09T17:22:44+02:00\",\"currency\":\"CHF\",\"device_id\":null,\"error_code\":null,\"gateway\":\"Kauf auf Rechnung (Invoice)\",\"kind\":\"void\",\"location_id\":null,\"message\":\"Marked the Kauf auf Rechnung (Invoice) payment as voided\",\"order_id\":7661270630738,\"parent_id\":8809380151634,\"payment_id\":\"#1034.1\",\"processed_at\":\"2026-04-09T17:22:44+02:00\",\"receipt\":{},\"source_name\":\"283573485569\",\"status\":\"success\",\"test\":false,\"user_id\":null}],\"refund_line_items\":[{\"id\":767194333522,\"line_item_id\":18027351638354,\"location_id\":113214685522,\"quantity\":1,\"restock_type\":\"cancel\",\"subtotal\":82.0,\"subtotal_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"total_tax\":0.0,\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"line_item\":{\"id\":18027351638354,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18027351638354\",\"attributed_staffs\":[],\"current_quantity\":0,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Assugrin Classic Spenderdose 300 Stk\",\"price\":\"82.00\",\"price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687686803794,\"properties\":[],\"quantity\":1,\"requires_shipping\":false,\"sku\":\"304\",\"taxable\":true,\"title\":\"Assugrin Classic Spenderdose 300 Stk\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072427057490,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}}],\"duties\":[]}],\"shipping_address\":null,\"shipping_lines\":[],\"returns\":[],\"line_item_groups\":[]}', 'orders/updated', '2026-06-19 05:01:14');

INSERT INTO object_collection_ShopifyPayload_orders (
  `id`, `index`, `fieldname`, `payload`,
  `topic`, `createdAt`
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (19152, 1, 'payload', '{\"id\":7661270630738,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/7661270630738\",\"app_id\":580111,\"browser_ip\":\"49.43.89.138\",\"buyer_accepts_marketing\":true,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNAYFBjl8LJ9zLRw9sOgguR\",\"checkout_id\":48218958037330,\"checkout_token\":\"d9afd6d4d13acf26691a4ad129673819\",\"client_details\":{\"accept_language\":\"de-DE\",\"browser_height\":null,\"browser_ip\":\"49.43.89.138\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/146.0.0.0 Safari\\/537.36\"},\"closed_at\":null,\"confirmation_number\":\"VP5MUVP51\",\"confirmed\":true,\"contact_email\":\"leomat2@yopmail.com\",\"created_at\":\"2026-04-02T09:54:42+02:00\",\"currency\":\"CHF\",\"current_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_subtotal_price\":\"82.00\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"current_total_additional_fees_set\":null,\"current_total_discounts\":\"0.00\",\"current_total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"current_total_duties_set\":null,\"current_total_price\":\"82.00\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"current_total_tax\":\"0.00\",\"current_total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"customer_locale\":\"de-DE\",\"device_id\":null,\"discount_codes\":[],\"duties_included\":false,\"email\":\"leomat2@yopmail.com\",\"estimated_taxes\":false,\"financial_status\":\"pending\",\"fulfillment_status\":null,\"landing_site\":\"\\/\",\"landing_site_ref\":null,\"location_id\":null,\"merchant_business_entity_id\":\"30495605074\",\"merchant_of_record_app_id\":null,\"name\":\"#1034\",\"note\":null,\"note_attributes\":[],\"number\":34,\"order_number\":1034,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/8df97da1faca8257c3105fc4d0815983\\/authenticate?key=fc351b7ec59353a744e8cb559735ac9c\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Kauf auf Rechnung (Invoice)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-04-02T09:54:41+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"82.00\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"tags\":\"\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"8df97da1faca8257c3105fc4d0815983\",\"total_cash_rounding_payment_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_cash_rounding_refund_adjustment_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_discounts\":\"0.00\",\"total_discounts_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_line_items_price\":\"82.00\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"82.00\",\"total_price\":\"82.00\",\"total_price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"total_shipping_price_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tax\":\"0.00\",\"total_tax_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"total_tip_received\":\"0.00\",\"total_weight\":0,\"updated_at\":\"2026-04-02T09:54:43+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Leo Mat\",\"address1\":\"Tübacher Weg 9327\",\"phone\":null,\"city\":\"Oberteuringen\",\"zip\":\"88094\",\"province\":null,\"country\":\"Germany\",\"last_name\":\"Testing\",\"address2\":null,\"company\":null,\"latitude\":47.7258058,\"longitude\":9.4651617,\"name\":\"Leo Mat Testing\",\"country_code\":\"DE\",\"province_code\":null},\"customer\":{\"id\":10153220473170,\"created_at\":\"2026-03-18T09:27:35+01:00\",\"updated_at\":\"2026-04-02T09:54:43+02:00\",\"first_name\":\"Leo\",\"last_name\":\"mat 2\",\"state\":\"enabled\",\"note\":\"\",\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"leomat2@yopmail.com\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10153220473170\",\"default_address\":{\"id\":12292908155218,\"customer_id\":10153220473170,\"first_name\":\"Leo Mat\",\"last_name\":\"Testing\",\"company\":null,\"address1\":\"Tübacher Weg 9327\",\"address2\":null,\"city\":\"Oberteuringen\",\"province\":null,\"country\":\"Germany\",\"zip\":\"88094\",\"phone\":null,\"name\":\"Leo Mat Testing\",\"province_code\":null,\"country_code\":\"DE\",\"country_name\":\"Germany\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[],\"line_items\":[{\"id\":18027351638354,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18027351638354\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":1,\"fulfillment_service\":\"manual\",\"fulfillment_status\":null,\"gift_card\":false,\"grams\":0,\"name\":\"Assugrin Classic Spenderdose 300 Stk\",\"price\":\"82.00\",\"price_set\":{\"shop_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"82.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687686803794,\"properties\":[],\"quantity\":1,\"requires_shipping\":false,\"sales_line_item_group_id\":null,\"sku\":\"304\",\"taxable\":true,\"title\":\"Assugrin Classic Spenderdose 300 Stk\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072427057490,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":null,\"shipping_lines\":[],\"returns\":[],\"line_item_groups\":[]}', 'orders/create', '2026-04-02 09:54:45');

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

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

SHOW COLUMNS
FROM
  object_store_orders

SHOW COLUMNS FROM object_store_orders;

INSERT INTO object_store_orders (
  `oo_id`, `orderId`, `orderNumber`,
  `status`, `totalPrice__value`, `totalPrice__unit`,
  `customerEmail`, `createdAt`, `abacusOrderId`,
  `abacusStatus`, `sentToAbacus`,
  `abacusPayload`
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)