POST https://leomatapi.test.mediadivision.ch/webhook/shopify/leomat/order

Response
200 OK
IP
34.53.182.28
Profiled on
Token
c15a50

Query Metrics

209 Database Queries
69 Different statements
61.66 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
16.57 ms
(26.87%) 		57 
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 (?)
Parameters: 
[
  1781795567
  "site_domain_367af465ca304630cf45a2132778bed1"
]
View formatted query    View runnable query    Explain query
2.33 ms
(3.78%) 		14 
INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  17910
  "object"
  "product"
  21963
  "fieldcollection"
  "lineItems"
  "0"
]
View formatted query    View runnable query    Explain query
1.94 ms
(3.15%) 		8 
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 (?, ?)
Parameters: 
[
  1781795567
  "system\x01tags\x01"
  "site\x01tags\x01"
]
View formatted query    View runnable query    Explain query
1.87 ms
(3.03%) 		7 
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 = ?
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
1.68 ms
(2.73%) 		7 
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
1.59 ms
(2.57%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1907'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.55 ms
(2.51%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '4925'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.51 ms
(2.45%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '348'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.49 ms
(2.41%) 		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)
Parameters: 
[
  2 => 30
  3 => 1781795567
  0 => "system_cache_write_lock"
  1 => b"O:1:"©":1:{s:6:"†gö\x07À\x1E";i:1781795567;}"
]
View formatted query    View runnable query    Explain query
1.45 ms
(2.34%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3709'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.41 ms
(2.29%) 		1 
SELECT * FROM object_relations_orders WHERE src_id = ?
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
1.41 ms
(2.29%) 		6 
SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE
Parameters: 
[
  17910
]
View formatted query    View runnable query    Explain query
1.35 ms
(2.19%) 		2 
INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  21963
  0
  "payload"
  "{"id":8043963547986,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/8043963547986","app_id":580111,"browser_ip":"178.197.214.112","buyer_accepts_marketing":false,"cancel_reason":null,"cancelled_at":null,"cart_token":"hWNDTLBwUbNhuvBwwZSN1RnH","checkout_id":48586281353554,"checkout_token":"f8455a6342b4e3c2bb540f711bf6c263","client_details":{"accept_language":"de-CH","browser_height":null,"browser_ip":"178.197.214.112","browser_width":null,"session_hash":null,"user_agent":"Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Mobile Safari\/537.36"},"closed_at":null,"company":null,"confirmation_number":"88LVLWAX8","confirmed":true,"contact_email":"claribel_matilde@hotmail.com","created_at":"2026-06-18T15:22:12+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":"708.60","current_subtotal_price_set":{"shop_money":{"amount":"708.60","currency_code":"CHF"},"presentment_money":{"amount":"708.60","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":"708.60","current_total_price_set":{"shop_money":{"amount":"708.60","currency_code":"CHF"},"presentment_money":{"amount":"708.60","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-CH","device_id":null,"discount_codes":[],"duties_included":false,"email":"claribel_matilde@hotmail.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":"#1514","note":"Tour 17 bereits bezogen","note_attributes":[],"number":514,"order_number":1514,"order_status_url":"https:\/\/shop.myleomat.ch\/99699687762\/orders\/4940d02c281257d432aae3ceb0f62144\/authenticate?key=84aca13b7e5c8c5bc1f9f3b231bd0908","original_total_additional_fees_set":null,"original_total_duties_set":null,"payment_gateway_names":["Barzahlung (NUR BEI ABHOLUNG)"],"phone":"+41796159359","po_number":null,"presentment_currency":"CHF","processed_at":"2026-06-18T15:22:11+02:00","reference":null,"referring_site":null,"source_identifier":null,"source_name":"web","source_url":null,"subtotal_price":"708.60","subtotal_price_set":{"shop_money":{"amount":"708.60","currency_code":"CHF"},"presentment_money":{"amount":"708.60","currency_code":"CHF"}},"tags":"","tax_exempt":false,"tax_lines":[],"taxes_included":true,"test":false,"token":"4940d02c281257d432aae3ceb0f62144","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":"708.60","total_line_items_price_set":{"shop_money":{"amount":"708.60","currency_code":"CHF"},"presentment_money":{"amount":"708.60","currency_code":"CHF"}},"total_outstanding":"708.60","total_price":"708.60","total_price_set":{"shop_money":{"amount":"708.60","currency_code":"CHF"},"presentment_money":{"amount":"708.60","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-18T15:22:13+02:00","user_id":null,"billing_address":{"first_name":"Leomat","address1":"Wiesenstrasse","phone":null,"city":"Tübach","zip":"9327","province":null,"country":"Switzerland","last_name":"AG","address2":"2","company":null,"latitude":47.4859367,"longitude":9.4585259,"name":"Leomat AG","country_code":"CH","province_code":null},"customer":{"id":10155383292242,"created_at":"2026-03-19T06:49:38+01:00","updated_at":"2026-06-18T15:22:13+02:00","first_name":"Matilde","last_name":"2026530000","state":"enabled","note":null,"verified_email":true,"multipass_identifier":null,"tax_exempt":false,"email":"claribel_matilde@hotmail.com","phone":"+41796159359","currency":"CHF","tax_exemptions":[],"admin_graphql_api_id":"gid:\/\/shopify\/Customer\/10155383292242","default_address":{"id":12417847492946,"customer_id":10155383292242,"first_name":"Leomat","last_name":"AG","company":null,"address1":"Wiesenstrasse","address2":"2","city":"Tübach","province":null,"country":"Switzerland","zip":"9327","phone":null,"name":"Leomat AG","province_code":null,"country_code":"CH","country_name":"Switzerland","default":true}},"discount_applications":[],"fulfillments":[],"line_items":[{"id":18746422657362,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422657362","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":2,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Linzertörtli 75G","price":"20.00","price_set":{"shop_money":{"amount":"20.00","currency_code":"CHF"},"presentment_money":{"amount":"20.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687687590226,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"348","taxable":true,"title":"Linzertörtli 75G","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":53072429482322,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18746422690130,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422690130","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":2,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Leomat Café-Creamer Rahmig","price":"93.60","price_set":{"shop_money":{"amount":"93.60","currency_code":"CHF"},"presentment_money":{"amount":"93.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687776293202,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1986","taxable":true,"title":"Leomat Café-Creamer Rahmig","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":53072702308690,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18746422722898,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422722898","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":1,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nescafé Gold De Luxe\/Poc -Normales Aroma","price":"256.50","price_set":{"shop_money":{"amount":"256.50","currency_code":"CHF"},"presentment_money":{"amount":"256.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687818432850,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2775","taxable":true,"title":"Nescafé Gold De Luxe\/Poc -Normales Aroma","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":53072833020242,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18746422755666,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422755666","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":1,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Monday Energy Dose 25Cl","price":"36.50","price_set":{"shop_money":{"amount":"36.50","currency_code":"CHF"},"presentment_money":{"amount":"36.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687772492114,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1907","taxable":true,"title":"Monday Energy Dose 25Cl","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":53072683336018,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18746422788434,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422788434","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":1,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Automatenzucker (Vending)","price":"27.50","price_set":{"shop_money":{"amount":"27.50","currency_code":"CHF"},"presentment_money":{"amount":"27.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687848907090,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"4925","taxable":true,"title":"Automatenzucker (Vending)","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":53072978739538,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18746422821202,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422821202","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":1,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Kaffeerahm Portionen 12G","price":"22.90","price_set":{"shop_money":{"amount":"22.90","currency_code":"CHF"},"presentment_money":{"amount":"22.90","currency_code":"CHF"}},"product_exists":true,"product_id":10687771509074,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1877","taxable":true,"title":"Kaffeerahm Portionen 12G","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":53072682156370,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18746422853970,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18746422853970","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":1,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Automatenbecher \"Bio\" 3.0 Dl","price":"138.00","price_set":{"shop_money":{"amount":"138.00","currency_code":"CHF"},"presentment_money":{"amount":"138.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687906971986,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3709","taxable":true,"title":"Automatenbecher \"Bio\" 3.0 Dl","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":53073158308178,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}],"payment_terms":null,"refunds":[],"shipping_address":null,"shipping_lines":[{"id":6259838091602,"carrier_identifier":null,"code":"Wiesenstrasse 2","current_discounted_price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"discounted_price":"0.00","discounted_price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"is_removed":false,"phone":null,"price":"0.00","price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"requested_fulfillment_service_id":null,"source":"shopify","title":"Wiesenstrasse 2","tax_lines":[],"discount_allocations":[]}],"returns":[],"line_item_groups":[]}"
  "orders/create"
  "2026-06-18 15:23:28"
]
View formatted query    View runnable query    Explain query
1.31 ms
(2.13%) 		14 
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
Parameters: 
[
  "Leomat"
  "Leomat"
]
View formatted query    View runnable query    Explain query
1.30 ms
(2.10%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2775'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.26 ms
(2.04%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1877'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.25 ms
(2.02%) 		5 
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters: 
[
  1781795567
  "object_17910\x01tags\x01"
  "class_product\x01tags\x01"
  "asset_308\x01tags\x01"
  "asset_309\x01tags\x01"
]
View formatted query    View runnable query    Explain query
1.11 ms
(1.80%) 		1 
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "/Orders/Leomat/2026/06/18/"
  21963
  1781789008
  1781795567
  8
  0
  0
  21945
  "object"
  "1514"
  0
  null
  null
  "orders"
  1
  "Orders"
]
View formatted query    View runnable query    Explain query
1.05 ms
(1.71%) 		7 
INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  21963
  0
  "lineItems"
  "Linzertörtli 75G"
  "348"
  2.0
  20.0
  "CHF"
  "fulfilled"
  0
  "[]"
]
View formatted query    View runnable query    Explain query
1.01 ms
(1.64%) 		1 
SHOW COLUMNS FROM objects
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.90 ms
(1.46%) 		2 
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
Parameters: 
[
  8043963547986
]
View formatted query    View runnable query    Explain query
0.83 ms
(1.34%) 		1 
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1986'  AND  object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.81 ms
(1.31%) 		1 
SHOW COLUMNS FROM object_query_orders
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.78 ms
(1.26%) 		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
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.72 ms
(1.17%) 		1 
SHOW COLUMNS FROM versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.64 ms
(1.04%) 		1 
SHOW COLUMNS FROM object_store_orders
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.63 ms
(1.03%) 		1 
SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters: 
[
  21963
  "payload"
]
View formatted query    View runnable query    Explain query
0.60 ms
(0.97%) 		1 
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `classId` = ?, `published` = ?, `className` = ? WHERE `id` = ?
Parameters: 
[
  "/Orders/Leomat/2026/06/18/"
  21963
  1781789008
  1781795567
  8
  0
  0
  21945
  "object"
  "1514"
  0
  null
  null
  "orders"
  1
  "Orders"
  21963
]
View formatted query    View runnable query    Explain query
0.56 ms
(0.90%) 		1 
UPDATE object_query_orders SET `orderId` = ?, `orderNumber` = ?, `status` = ?, `totalPrice__value` = ?, `totalPrice__unit` = ?, `customerEmail` = ?, `createdAt` = ?, `abacusOrderId` = ?, `abacusStatus` = ?, `sentToAbacus` = ?, `abacusPayload` = ?, `oo_id` = ? WHERE `oo_id` = ?
Parameters: 
[
  8043963547986.0
  "1514"
  "paid"
  708.6
  "CHF"
  "claribel_matilde@hotmail.com"
  "2026-06-18 15:22:12"
  null
  "processed"
  1
  """
    {\n
        "InboxOrderRequest": {\n
            "Comment": "#1514",\n
            "ExternalOrderReference": "bb46aa95-38ba-49d2-aa57-64d1e0e85f0a",\n
            "ExternalOrderNumber": 514,\n
            "CreationDate": "2026-06-18",\n
            "Language": "de",\n
            "DeliveryMethodName": "3",\n
            "TaxType": "Included",\n
            "AdditionalInfoList": [],\n
            "Summary": {\n
                "CurrencyId": "CHF",\n
                "TotalAmountIncludingTax": 708.6,\n
                "TotalAmountExcludingTax": 708.6\n
            },\n
            "IsGuest": false,\n
            "PositionList": [\n
                {\n
                    "LineItemId": 1,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 20,\n
                        "PerQuantityIncludingTax": 20,\n
                        "PositionTotalExcludingTax": 40,\n
                        "PositionTotalIncludingTax": 40,\n
                        "PerQuantityExcludingTaxRelevant": 20,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 348,\n
                        "Type": "A",\n
                        "Name": "11648",\n
                        "Description": "Linzertörtli 75G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 2,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 93.6,\n
                        "PerQuantityIncludingTax": 93.6,\n
                        "PositionTotalExcludingTax": 187.2,\n
                        "PositionTotalIncludingTax": 187.2,\n
                        "PerQuantityExcludingTaxRelevant": 93.6,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1986,\n
                        "Type": "A",\n
                        "Name": "12155",\n
                        "Description": "Leomat Café-Creamer Rahmig"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 3,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 256.5,\n
                        "PerQuantityIncludingTax": 256.5,\n
                        "PositionTotalExcludingTax": 256.5,\n
                        "PositionTotalIncludingTax": 256.5,\n
                        "PerQuantityExcludingTaxRelevant": 256.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 2775,\n
                        "Type": "A",\n
                        "Name": "10001",\n
                        "Description": "Nescafé Gold De Luxe\/Poc -Normales Aroma"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 4,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 36.5,\n
                        "PerQuantityIncludingTax": 36.5,\n
                        "PositionTotalExcludingTax": 36.5,\n
                        "PositionTotalIncludingTax": 36.5,\n
                        "PerQuantityExcludingTaxRelevant": 36.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1907,\n
                        "Type": "A",\n
                        "Name": "13877",\n
                        "Description": "Monday Energy Dose 25Cl"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 5,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 27.5,\n
                        "PerQuantityIncludingTax": 27.5,\n
                        "PositionTotalExcludingTax": 27.5,\n
                        "PositionTotalIncludingTax": 27.5,\n
                        "PerQuantityExcludingTaxRelevant": 27.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 4925,\n
                        "Type": "A",\n
                        "Name": "10034",\n
                        "Description": "Automatenzucker (Vending)"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 6,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 22.9,\n
                        "PerQuantityIncludingTax": 22.9,\n
                        "PositionTotalExcludingTax": 22.9,\n
                        "PositionTotalIncludingTax": 22.9,\n
                        "PerQuantityExcludingTaxRelevant": 22.9,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1877,\n
                        "Type": "A",\n
                        "Name": "10025",\n
                        "Description": "Kaffeerahm Portionen 12G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 7,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 138,\n
                        "PerQuantityIncludingTax": 138,\n
                        "PositionTotalExcludingTax": 138,\n
                        "PositionTotalIncludingTax": 138,\n
                        "PerQuantityExcludingTaxRelevant": 138,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 3709,\n
                        "Type": "A",\n
                        "Name": "17507",\n
                        "Description": "Automatenbecher \"Bio\" 3.0 Dl"\n
                    }\n
                }\n
            ],\n
            "CustomerSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "PaymentSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "ShippingHandlingList": [],\n
            "Shopper": {\n
                "Id": "5758f266-cb68-cb1a-2dd3-46ade4dcd0a5",\n
                "Account": "Matilde"\n
            },\n
            "DeliverySubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            }\n
        },\n
        "_status_sync": {\n
            "erp_status": "processed",\n
            "erp_updated_at": "2026-06-18T15:00:03+00:00",\n
            "erp_status_source": "leomat_xlsx"\n
        }\n
    }
    """
  21963
  21963
]
View formatted query    View runnable query    Explain query
0.55 ms
(0.89%) 		1 
INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  8043963547986.0
  "1514"
  "paid"
  708.6
  "CHF"
  "claribel_matilde@hotmail.com"
  "2026-06-18 15:22:12"
  null
  "processed"
  1
  """
    {\n
        "InboxOrderRequest": {\n
            "Comment": "#1514",\n
            "ExternalOrderReference": "bb46aa95-38ba-49d2-aa57-64d1e0e85f0a",\n
            "ExternalOrderNumber": 514,\n
            "CreationDate": "2026-06-18",\n
            "Language": "de",\n
            "DeliveryMethodName": "3",\n
            "TaxType": "Included",\n
            "AdditionalInfoList": [],\n
            "Summary": {\n
                "CurrencyId": "CHF",\n
                "TotalAmountIncludingTax": 708.6,\n
                "TotalAmountExcludingTax": 708.6\n
            },\n
            "IsGuest": false,\n
            "PositionList": [\n
                {\n
                    "LineItemId": 1,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 20,\n
                        "PerQuantityIncludingTax": 20,\n
                        "PositionTotalExcludingTax": 40,\n
                        "PositionTotalIncludingTax": 40,\n
                        "PerQuantityExcludingTaxRelevant": 20,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 348,\n
                        "Type": "A",\n
                        "Name": "11648",\n
                        "Description": "Linzertörtli 75G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 2,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 93.6,\n
                        "PerQuantityIncludingTax": 93.6,\n
                        "PositionTotalExcludingTax": 187.2,\n
                        "PositionTotalIncludingTax": 187.2,\n
                        "PerQuantityExcludingTaxRelevant": 93.6,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1986,\n
                        "Type": "A",\n
                        "Name": "12155",\n
                        "Description": "Leomat Café-Creamer Rahmig"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 3,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 256.5,\n
                        "PerQuantityIncludingTax": 256.5,\n
                        "PositionTotalExcludingTax": 256.5,\n
                        "PositionTotalIncludingTax": 256.5,\n
                        "PerQuantityExcludingTaxRelevant": 256.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 2775,\n
                        "Type": "A",\n
                        "Name": "10001",\n
                        "Description": "Nescafé Gold De Luxe\/Poc -Normales Aroma"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 4,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 36.5,\n
                        "PerQuantityIncludingTax": 36.5,\n
                        "PositionTotalExcludingTax": 36.5,\n
                        "PositionTotalIncludingTax": 36.5,\n
                        "PerQuantityExcludingTaxRelevant": 36.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1907,\n
                        "Type": "A",\n
                        "Name": "13877",\n
                        "Description": "Monday Energy Dose 25Cl"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 5,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 27.5,\n
                        "PerQuantityIncludingTax": 27.5,\n
                        "PositionTotalExcludingTax": 27.5,\n
                        "PositionTotalIncludingTax": 27.5,\n
                        "PerQuantityExcludingTaxRelevant": 27.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 4925,\n
                        "Type": "A",\n
                        "Name": "10034",\n
                        "Description": "Automatenzucker (Vending)"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 6,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 22.9,\n
                        "PerQuantityIncludingTax": 22.9,\n
                        "PositionTotalExcludingTax": 22.9,\n
                        "PositionTotalIncludingTax": 22.9,\n
                        "PerQuantityExcludingTaxRelevant": 22.9,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1877,\n
                        "Type": "A",\n
                        "Name": "10025",\n
                        "Description": "Kaffeerahm Portionen 12G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 7,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 138,\n
                        "PerQuantityIncludingTax": 138,\n
                        "PositionTotalExcludingTax": 138,\n
                        "PositionTotalIncludingTax": 138,\n
                        "PerQuantityExcludingTaxRelevant": 138,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 3709,\n
                        "Type": "A",\n
                        "Name": "17507",\n
                        "Description": "Automatenbecher \"Bio\" 3.0 Dl"\n
                    }\n
                }\n
            ],\n
            "CustomerSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "PaymentSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "ShippingHandlingList": [],\n
            "Shopper": {\n
                "Id": "5758f266-cb68-cb1a-2dd3-46ade4dcd0a5",\n
                "Account": "Matilde"\n
            },\n
            "DeliverySubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            }\n
        },\n
        "_status_sync": {\n
            "erp_status": "processed",\n
            "erp_updated_at": "2026-06-18T15:00:03+00:00",\n
            "erp_status_source": "leomat_xlsx"\n
        }\n
    }
    """
  21963
]
View formatted query    View runnable query    Explain query
0.53 ms
(0.85%) 		1 
SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21963' AND `fieldname` = 'payload' LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.48 ms
(0.77%) 		1 
INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  21963
  8043963547986.0
  "1514"
  "paid"
  708.6
  "CHF"
  "claribel_matilde@hotmail.com"
  "2026-06-18 15:22:12"
  null
  "processed"
  1
  """
    {\n
        "InboxOrderRequest": {\n
            "Comment": "#1514",\n
            "ExternalOrderReference": "bb46aa95-38ba-49d2-aa57-64d1e0e85f0a",\n
            "ExternalOrderNumber": 514,\n
            "CreationDate": "2026-06-18",\n
            "Language": "de",\n
            "DeliveryMethodName": "3",\n
            "TaxType": "Included",\n
            "AdditionalInfoList": [],\n
            "Summary": {\n
                "CurrencyId": "CHF",\n
                "TotalAmountIncludingTax": 708.6,\n
                "TotalAmountExcludingTax": 708.6\n
            },\n
            "IsGuest": false,\n
            "PositionList": [\n
                {\n
                    "LineItemId": 1,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 20,\n
                        "PerQuantityIncludingTax": 20,\n
                        "PositionTotalExcludingTax": 40,\n
                        "PositionTotalIncludingTax": 40,\n
                        "PerQuantityExcludingTaxRelevant": 20,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 348,\n
                        "Type": "A",\n
                        "Name": "11648",\n
                        "Description": "Linzertörtli 75G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 2,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 93.6,\n
                        "PerQuantityIncludingTax": 93.6,\n
                        "PositionTotalExcludingTax": 187.2,\n
                        "PositionTotalIncludingTax": 187.2,\n
                        "PerQuantityExcludingTaxRelevant": 93.6,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1986,\n
                        "Type": "A",\n
                        "Name": "12155",\n
                        "Description": "Leomat Café-Creamer Rahmig"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 3,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 256.5,\n
                        "PerQuantityIncludingTax": 256.5,\n
                        "PositionTotalExcludingTax": 256.5,\n
                        "PositionTotalIncludingTax": 256.5,\n
                        "PerQuantityExcludingTaxRelevant": 256.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 2775,\n
                        "Type": "A",\n
                        "Name": "10001",\n
                        "Description": "Nescafé Gold De Luxe\/Poc -Normales Aroma"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 4,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 36.5,\n
                        "PerQuantityIncludingTax": 36.5,\n
                        "PositionTotalExcludingTax": 36.5,\n
                        "PositionTotalIncludingTax": 36.5,\n
                        "PerQuantityExcludingTaxRelevant": 36.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1907,\n
                        "Type": "A",\n
                        "Name": "13877",\n
                        "Description": "Monday Energy Dose 25Cl"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 5,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 27.5,\n
                        "PerQuantityIncludingTax": 27.5,\n
                        "PositionTotalExcludingTax": 27.5,\n
                        "PositionTotalIncludingTax": 27.5,\n
                        "PerQuantityExcludingTaxRelevant": 27.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 4925,\n
                        "Type": "A",\n
                        "Name": "10034",\n
                        "Description": "Automatenzucker (Vending)"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 6,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 22.9,\n
                        "PerQuantityIncludingTax": 22.9,\n
                        "PositionTotalExcludingTax": 22.9,\n
                        "PositionTotalIncludingTax": 22.9,\n
                        "PerQuantityExcludingTaxRelevant": 22.9,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1877,\n
                        "Type": "A",\n
                        "Name": "10025",\n
                        "Description": "Kaffeerahm Portionen 12G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 7,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 138,\n
                        "PerQuantityIncludingTax": 138,\n
                        "PositionTotalExcludingTax": 138,\n
                        "PositionTotalIncludingTax": 138,\n
                        "PerQuantityExcludingTaxRelevant": 138,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 3709,\n
                        "Type": "A",\n
                        "Name": "17507",\n
                        "Description": "Automatenbecher \"Bio\" 3.0 Dl"\n
                    }\n
                }\n
            ],\n
            "CustomerSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "PaymentSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "ShippingHandlingList": [],\n
            "Shopper": {\n
                "Id": "5758f266-cb68-cb1a-2dd3-46ade4dcd0a5",\n
                "Account": "Matilde"\n
            },\n
            "DeliverySubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            }\n
        },\n
        "_status_sync": {\n
            "erp_status": "processed",\n
            "erp_updated_at": "2026-06-18T15:00:03+00:00",\n
            "erp_status_source": "leomat_xlsx"\n
        }\n
    }
    """
]
View formatted query    View runnable query    Explain query
0.47 ms
(0.77%) 		2 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.46 ms
(0.74%) 		6 
SELECT * FROM object_relations_product WHERE src_id = ?
Parameters: 
[
  17910
]
View formatted query    View runnable query    Explain query
0.46 ms
(0.74%) 		1 
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21963')
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.44 ms
(0.71%) 		1 
UPDATE object_store_orders SET `oo_id` = ?, `orderId` = ?, `orderNumber` = ?, `status` = ?, `totalPrice__value` = ?, `totalPrice__unit` = ?, `customerEmail` = ?, `createdAt` = ?, `abacusOrderId` = ?, `abacusStatus` = ?, `sentToAbacus` = ?, `abacusPayload` = ? WHERE `oo_id` = ?
Parameters: 
[
  21963
  8043963547986.0
  "1514"
  "paid"
  708.6
  "CHF"
  "claribel_matilde@hotmail.com"
  "2026-06-18 15:22:12"
  null
  "processed"
  1
  """
    {\n
        "InboxOrderRequest": {\n
            "Comment": "#1514",\n
            "ExternalOrderReference": "bb46aa95-38ba-49d2-aa57-64d1e0e85f0a",\n
            "ExternalOrderNumber": 514,\n
            "CreationDate": "2026-06-18",\n
            "Language": "de",\n
            "DeliveryMethodName": "3",\n
            "TaxType": "Included",\n
            "AdditionalInfoList": [],\n
            "Summary": {\n
                "CurrencyId": "CHF",\n
                "TotalAmountIncludingTax": 708.6,\n
                "TotalAmountExcludingTax": 708.6\n
            },\n
            "IsGuest": false,\n
            "PositionList": [\n
                {\n
                    "LineItemId": 1,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 20,\n
                        "PerQuantityIncludingTax": 20,\n
                        "PositionTotalExcludingTax": 40,\n
                        "PositionTotalIncludingTax": 40,\n
                        "PerQuantityExcludingTaxRelevant": 20,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 348,\n
                        "Type": "A",\n
                        "Name": "11648",\n
                        "Description": "Linzertörtli 75G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 2,\n
                    "Quantity": 2,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 93.6,\n
                        "PerQuantityIncludingTax": 93.6,\n
                        "PositionTotalExcludingTax": 187.2,\n
                        "PositionTotalIncludingTax": 187.2,\n
                        "PerQuantityExcludingTaxRelevant": 93.6,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1986,\n
                        "Type": "A",\n
                        "Name": "12155",\n
                        "Description": "Leomat Café-Creamer Rahmig"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 3,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 256.5,\n
                        "PerQuantityIncludingTax": 256.5,\n
                        "PositionTotalExcludingTax": 256.5,\n
                        "PositionTotalIncludingTax": 256.5,\n
                        "PerQuantityExcludingTaxRelevant": 256.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 2775,\n
                        "Type": "A",\n
                        "Name": "10001",\n
                        "Description": "Nescafé Gold De Luxe\/Poc -Normales Aroma"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 4,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 36.5,\n
                        "PerQuantityIncludingTax": 36.5,\n
                        "PositionTotalExcludingTax": 36.5,\n
                        "PositionTotalIncludingTax": 36.5,\n
                        "PerQuantityExcludingTaxRelevant": 36.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1907,\n
                        "Type": "A",\n
                        "Name": "13877",\n
                        "Description": "Monday Energy Dose 25Cl"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 5,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 27.5,\n
                        "PerQuantityIncludingTax": 27.5,\n
                        "PositionTotalExcludingTax": 27.5,\n
                        "PositionTotalIncludingTax": 27.5,\n
                        "PerQuantityExcludingTaxRelevant": 27.5,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 4925,\n
                        "Type": "A",\n
                        "Name": "10034",\n
                        "Description": "Automatenzucker (Vending)"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 6,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 22.9,\n
                        "PerQuantityIncludingTax": 22.9,\n
                        "PositionTotalExcludingTax": 22.9,\n
                        "PositionTotalIncludingTax": 22.9,\n
                        "PerQuantityExcludingTaxRelevant": 22.9,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 1877,\n
                        "Type": "A",\n
                        "Name": "10025",\n
                        "Description": "Kaffeerahm Portionen 12G"\n
                    }\n
                },\n
                {\n
                    "LineItemId": 7,\n
                    "Quantity": 1,\n
                    "PriceInfo": {\n
                        "PriceFromApi": false,\n
                        "PerQuantityExcludingTax": 138,\n
                        "PerQuantityIncludingTax": 138,\n
                        "PositionTotalExcludingTax": 138,\n
                        "PositionTotalIncludingTax": 138,\n
                        "PerQuantityExcludingTaxRelevant": 138,\n
                        "CurrencyId": "CHF",\n
                        "TaxInfo": {\n
                            "Code": 312,\n
                            "CodeAsString": "312",\n
                            "Rate": 0,\n
                            "Amount": 0\n
                        }\n
                    },\n
                    "Product": {\n
                        "Id": 3709,\n
                        "Type": "A",\n
                        "Name": "17507",\n
                        "Description": "Automatenbecher \"Bio\" 3.0 Dl"\n
                    }\n
                }\n
            ],\n
            "CustomerSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "PaymentSubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            },\n
            "ShippingHandlingList": [],\n
            "Shopper": {\n
                "Id": "5758f266-cb68-cb1a-2dd3-46ade4dcd0a5",\n
                "Account": "Matilde"\n
            },\n
            "DeliverySubject": {\n
                "Salutation": "",\n
                "FirstName": "Leomat",\n
                "Name": "AG",\n
                "CompanyName": "",\n
                "DateOfBirth": "1900-01-01",\n
                "Contact": {\n
                    "Salutation": "",\n
                    "FirstName": "Leomat",\n
                    "Name": "AG",\n
                    "DateOfBirth": "1900-01-01",\n
                    "Communication": {\n
                        "Phone": "",\n
                        "Email": "claribel_matilde@hotmail.com"\n
                    }\n
                },\n
                "Address": {\n
                    "Street": "Wiesenstrasse",\n
                    "HouseNumber": "",\n
                    "PostCode": "9327",\n
                    "City": "Tübach",\n
                    "CountryId": "CH"\n
                },\n
                "Communication": {\n
                    "Phone": "",\n
                    "Email": "claribel_matilde@hotmail.com"\n
                },\n
                "Id": 21457\n
            }\n
        },\n
        "_status_sync": {\n
            "erp_status": "processed",\n
            "erp_updated_at": "2026-06-18T15:00:03+00:00",\n
            "erp_status_source": "leomat_xlsx"\n
        }\n
    }
    """
  21963
]
View formatted query    View runnable query    Explain query
0.43 ms
(0.70%) 		1 
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
0.41 ms
(0.67%) 		1 
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE
                     (
                         (cid IN (1,21945,19990,5997,5996,5995) AND inheritable = 1)
                         OR cid = ? ) AND ctype='object'
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
0.41 ms
(0.66%) 		1 
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  null
  21963
  "object"
  0
  ""
  1781795567
  0
  1
  """
    #0 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/Element/AbstractElement.php(632): Pimcore\Model\Version->save()\n
    #1 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/Concrete.php(275): Pimcore\Model\Element\AbstractElement->doSaveVersion()\n
    #2 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/Concrete.php(213): Pimcore\Model\DataObject\Concrete->saveVersion()\n
    #3 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(537): Pimcore\Model\DataObject\Concrete->update()\n
    #4 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/Element/AbstractElement.php(775): Pimcore\Model\DataObject\AbstractObject->Pimcore\Model\DataObject\{closure}()\n
    #5 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(483): Pimcore\Model\Element\AbstractElement->retryableFunction()\n
    #6 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/Concrete.php(642): Pimcore\Model\DataObject\AbstractObject->save()\n
    #7 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/bundles/PimcoreShopifyIntegrationBundle/src/Controller/ShopifyWebhookController.php(246): Pimcore\Model\DataObject\Concrete->save()\n
    #8 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/bundles/PimcoreShopifyIntegrationBundle/src/Controller/ShopifyWebhookController.php(104): PimcoreShopifyIntegrationBundle\Controller\ShopifyWebhookController->handleOrderUpsert()\n
    #9 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/http-kernel/HttpKernel.php(183): PimcoreShopifyIntegrationBundle\Controller\ShopifyWebhookController->orderWebhook()\n
    #10 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()\n
    #11 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/http-kernel/Kernel.php(193): Symfony\Component\HttpKernel\HttpKernel->handle()\n
    #12 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\Component\HttpKernel\Kernel->handle()\n
    #13 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/autoload_runtime.php(29): Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()\n
    #14 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/public/index.php(16): require_once('...')\n
    #15 {main}
    """
  8
  null
  null
  0
  "fs"
]
View formatted query    View runnable query    Explain query
0.38 ms
(0.62%) 		5 
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters: 
[
  "/webhook/shopify/leomat/"
  "order"
]
View formatted query    View runnable query    Explain query
0.38 ms
(0.62%) 		6 
SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de','fr')
Parameters: 
[
  17910
]
View formatted query    View runnable query    Explain query
0.35 ms
(0.57%) 		2 
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters: 
[
  21945
]
View formatted query    View runnable query    Explain query
0.33 ms
(0.54%) 		1 
DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ?
Parameters: 
[
  21963
  "payload"
]
View formatted query    View runnable query    Explain query
0.31 ms
(0.51%) 		1 
SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21963' AND `fieldname` = 'lineItems' LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.44%) 		1 
DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ?
Parameters: 
[
  21963
  "lineItems"
]
View formatted query    View runnable query    Explain query
0.27 ms
(0.43%) 		1 
SELECT * FROM object_query_orders WHERE oo_id = ?
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.41%) 		1 
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters: 
[
  "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:21963;}}"
  "[]"
  "pimcore_search_backend_message"
  "2026-06-18 15:12:47"
  "2026-06-18 15:12:47"
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.41%) 		2 
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters: 
[
  "/Orders/Leomat/2026/06/18/"
  "1514"
]
View formatted query    View runnable query    Explain query
0.23 ms
(0.38%) 		1 
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters: 
[
  "object_21963\x01tags\x01"
  "object_properties\x01tags\x01"
]
View formatted query    View runnable query    Explain query
0.22 ms
(0.36%) 		4 
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters: 
[
  "/webhook/shopify/leomat/order"
]
View formatted query    View runnable query    Explain query
0.22 ms
(0.35%) 		1 
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.35%) 		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 (?, ?, ?, ?, ?)
Parameters: 
[
  1781795567
  "object_18268\x01tags\x01"
  "class_product\x01tags\x01"
  "asset_894\x01tags\x01"
  "asset_895\x01tags\x01"
  "asset_896\x01tags\x01"
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.33%) 		1 
SELECT type,classId,className FROM objects WHERE id = ?
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.33%) 		1 
SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE
Parameters: 
[
  21963
]
View formatted query    View runnable query    Explain query
0.20 ms
(0.32%) 		2 
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters: 
[
  "orders"
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.31%) 		1 
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21963')
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.28%) 		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 (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1781795567
  "object_18771\x01tags\x01"
  "class_product\x01tags\x01"
  "asset_1634\x01tags\x01"
  "asset_1635\x01tags\x01"
  "asset_1636\x01tags\x01"
  "asset_1637\x01tags\x01"
  "asset_1638\x01tags\x01"
]
View formatted query    View runnable query    Explain query
0.17 ms
(0.27%) 		1 
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21963')
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.27%) 		2 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.26%) 		1 
DELETE FROM schedule_tasks WHERE `cid` = 21963 AND `ctype` = 'object'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.26%) 		1 
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21963')
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.15 ms
(0.24%) 		1 
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters: 
[
  21963
  "object"
]
View formatted query    View runnable query    Explain query
0.15 ms
(0.24%) 		1 
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters: 
[
  "user"
  0
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.22%) 		1 
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters: 
[
  "object"
  21963
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.15%) 		1 
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters: 
[
  21963
  "object"
]
View formatted query    View runnable query    Explain query
0.09 ms
(0.14%) 		1 
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
0.08 ms
(0.14%) 		1 
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.07 ms
(0.11%) 		1 
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
0.06 ms
(0.10%) 		1 
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.