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

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

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

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

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

SELECT
  *
FROM
  object_store_orders
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_orders WHERE oo_id = 19957 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 > 1781860012 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 = 19957 AND fieldname = 'payload' ORDER BY `index` ASC;

SELECT
  *
FROM
  object_relations_orders
WHERE
  src_id = ?

SELECT * FROM object_relations_orders WHERE src_id = 19957;

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` = '1944'
    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` = '1944'  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 > 1781860012 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_18061');

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 > 1781860012 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_18061
tags
', 'class_product
tags
', 'asset_483
tags
', 'asset_484
tags
');

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

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

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

SELECT
  *
FROM
  object_store_product
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_product WHERE oo_id = 18061 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 = 18061 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 > 1781860012 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_483');

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

SELECT
  *
FROM
  object_relations_product
WHERE
  src_id = ?

SELECT * FROM object_relations_product WHERE src_id = 18061;

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

SELECT
  object_localized_product_de.id as id,
  object_localized_product_de.type as `type`
FROM
  object_localized_product_de
WHERE
  (
    `sku` = '1949'
    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` = '1949'  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 > 1781860012 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_18064');

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 > 1781860012 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_18064
tags
', 'class_product
tags
', 'asset_489
tags
', 'asset_490
tags
');

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

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

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

SELECT
  *
FROM
  object_store_product
WHERE
  oo_id = ? FOR
UPDATE

SELECT * FROM object_store_product WHERE oo_id = 18064 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 = 18064 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 > 1781860012 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_489');

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

SELECT
  *
FROM
  object_relations_product
WHERE
  src_id = ?

SELECT * FROM object_relations_product WHERE src_id = 18064;

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

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

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

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

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

SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/05/29/' AND `key` = BINARY '1233';

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

SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/05/29/' AND `key` = BINARY '1233';

"START TRANSACTION"

"START TRANSACTION";

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

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

SELECT
  versionCount
FROM
  objects
WHERE
  id = ? FOR
UPDATE

SELECT versionCount FROM objects WHERE id = 19957 FOR UPDATE;

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

SELECT MAX(versionCount) FROM versions WHERE cid = 19957 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 > 1781860012 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 > 1781860012 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 = 19957;

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/05/29/', 19957, 1780023886, 1781860012, 990, 0, 0, 19955, 'object', '1233', 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/05/29/', `id` = 19957, `creationDate` = 1780023886, `modificationDate` = 1781860012, `versionCount` = 990, `userOwner` = 0, `userModification` = 0, `parentId` = 19955, `type` = 'object', `key` = '1233', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'orders', `published` = 1, `className` = 'Orders' WHERE `id` = 19957;

DELETE FROM
  tree_locks
WHERE
  id = ?
  AND type = ?

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

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

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

DELETE FROM
  object_collection_LineItems_orders
WHERE
  id = ?
  AND fieldname = ?

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

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

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

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

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

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 (18061, 'object', 'product', 19957, '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', 19957, '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 (19957, 0, 'lineItems', 'Hilcona Ch Poulet Murren 235Gr', '1944', 13, 7, 'CHF', 'fulfilled', 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 (18064, 'object', 'product', 19957, 'fieldcollection', 'lineItems', '1');

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', 19957, 'fieldcollection', 'lineItems', '1');