Query Metrics
389
Database Queries
84
Different statements
121.76 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.87 ms (17.96%) |
87 |
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:
[ 1781859736 "site_domain_367af465ca304630cf45a2132778bed1" ] |
|
6.92 ms (5.69%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
19338
]
|
|
5.92 ms (4.86%) |
16 |
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:
[
19338
]
|
|
5.40 ms (4.43%) |
20 |
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:
[ 1781859736 "object_18799\x01tags\x01" "class_product\x01tags\x01" "asset_1671\x01tags\x01" "asset_1672\x01tags\x01" ] |
|
4.49 ms (3.69%) |
44 |
INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 18799 "object" "product" 19338 "fieldcollection" "lineItems" "0" ] |
|
4.21 ms (3.46%) |
16 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
19338
]
|
|
3.95 ms (3.24%) |
15 |
SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE
Parameters:
[
18799
]
|
|
3.89 ms (3.20%) |
44 |
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" ] |
|
3.68 ms (3.03%) |
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/05/07/" 19338 1778158876 1781859736 1858 0 0 19335 "object" "1065" 0 null null "orders" 1 "Orders" 19338 ] |
|
3.42 ms (2.81%) |
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 => 1781859737 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"0b÷\x07À\x1E";i:1781859737;}" ] |
|
2.84 ms (2.33%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3775' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
2.28 ms (1.87%) |
2 |
INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 19338 0 "payload" "{"id":7785655304530,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/7785655304530","app_id":580111,"browser_ip":"178.197.211.170","buyer_accepts_marketing":false,"cancel_reason":"declined","cancelled_at":"2026-05-19T16:02:21+02:00","cart_token":"hWNBsZ5pC8xxjZYjGqyGXbWt","checkout_id":48397678903634,"checkout_token":"b4c89116d70e926c4274525961e9f764","client_details":{"accept_language":"de-CH","browser_height":null,"browser_ip":"178.197.211.170","browser_width":null,"session_hash":null,"user_agent":"Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/147.0.0.0 Mobile Safari\/537.36"},"closed_at":"2026-05-19T16:02:21+02:00","company":null,"confirmation_number":"FXIAWWK8D","confirmed":true,"contact_email":"claribel_matilde@hotmail.com","created_at":"2026-05-07T15:01: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":"0.00","current_subtotal_price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"current_total_additional_fees_set":null,"current_total_discounts":"0.00","current_total_discounts_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"current_total_duties_set":null,"current_total_price":"0.00","current_total_price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"current_total_tax":"0.00","current_total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"customer_locale":"de-CH","device_id":null,"discount_codes":[],"duties_included":false,"email":"claribel_matilde@hotmail.com","estimated_taxes":false,"financial_status":"voided","fulfillment_status":null,"landing_site":"\/","landing_site_ref":null,"location_id":null,"merchant_business_entity_id":"30495605074","merchant_of_record_app_id":null,"name":"#1065","note":"Tour 17 bereits bezogen. ","note_attributes":[],"number":65,"order_number":1065,"order_status_url":"https:\/\/shop.myleomat.ch\/99699687762\/orders\/deae71d87bbbfe56e417421ade4b54c3\/authenticate?key=36ef7d6afa5e8c70544014a4a27aca1b","original_total_additional_fees_set":null,"original_total_duties_set":null,"payment_gateway_names":["Kauf auf Rechnung (Invoice)"],"phone":"+41796159359","po_number":null,"presentment_currency":"CHF","processed_at":"2026-05-07T15:01:10+02:00","reference":null,"referring_site":null,"source_identifier":null,"source_name":"web","source_url":null,"subtotal_price":"1535.36","subtotal_price_set":{"shop_money":{"amount":"1535.36","currency_code":"CHF"},"presentment_money":{"amount":"1535.36","currency_code":"CHF"}},"tags":"leomat-erp-status:rejected","tax_exempt":false,"tax_lines":[],"taxes_included":true,"test":false,"token":"deae71d87bbbfe56e417421ade4b54c3","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":"1535.36","total_line_items_price_set":{"shop_money":{"amount":"1535.36","currency_code":"CHF"},"presentment_money":{"amount":"1535.36","currency_code":"CHF"}},"total_outstanding":"0.00","total_price":"1535.36","total_price_set":{"shop_money":{"amount":"1535.36","currency_code":"CHF"},"presentment_money":{"amount":"1535.36","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-19T11:02:14+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-18T16:13:23+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":18284489146706,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489146706","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Coca-Cola Mezzo Mix 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687913066834,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3775","taxable":true,"title":"Coca-Cola Mezzo Mix 5Dl Pet","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":53073194484050,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489179474,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489179474","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nespresso Finezzo","price":"35.00","price_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687904809298,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3686","taxable":true,"title":"Nespresso Finezzo","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":53073146347858,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489212242,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489212242","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nespresso Intenso","price":"35.00","price_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687904416082,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3684","taxable":true,"title":"Nespresso Intenso","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":53073144054098,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489245010,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489245010","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nespresso Forte","price":"35.00","price_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687904645458,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3685","taxable":true,"title":"Nespresso Forte","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":53073145495890,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489277778,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489277778","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Icetea Peach 5Dl","price":"18.40","price_set":{"shop_money":{"amount":"18.40","currency_code":"CHF"},"presentment_money":{"amount":"18.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687815385426,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2680","taxable":true,"title":"Icetea Peach 5Dl","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":53072813883730,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489310546,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489310546","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Icetea Lemon 5Dl","price":"18.40","price_set":{"shop_money":{"amount":"18.40","currency_code":"CHF"},"presentment_money":{"amount":"18.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687815090514,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2679","taxable":true,"title":"Icetea Lemon 5Dl","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":53072811589970,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489343314,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489343314","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Automatenbecher \"Hybrid\" 1,8 Dl","price":"179.00","price_set":{"shop_money":{"amount":"179.00","currency_code":"CHF"},"presentment_money":{"amount":"179.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687908020562,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3716","taxable":true,"title":"Automatenbecher \"Hybrid\" 1,8 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":53073162633554,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489376082,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489376082","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Henniez Naturale 5Dl Pet","price":"30.70","price_set":{"shop_money":{"amount":"30.70","currency_code":"CHF"},"presentment_money":{"amount":"30.70","currency_code":"CHF"}},"product_exists":true,"product_id":10687905497426,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3690","taxable":true,"title":"Henniez Naturale 5Dl Pet","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":53073151623506,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489408850,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489408850","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Coca-Cola 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687912771922,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3774","taxable":true,"title":"Coca-Cola 5Dl Pet","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":53073191960914,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489441618,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489441618","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Fini Pica Jungle Ropes Erdbeer","price":"21.10","price_set":{"shop_money":{"amount":"21.10","currency_code":"CHF"},"presentment_money":{"amount":"21.10","currency_code":"CHF"}},"product_exists":true,"product_id":10687756894546,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1410","taxable":true,"title":"Fini Pica Jungle Ropes Erdbeer","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":53072655548754,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489474386,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489474386","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Bauli Schoko Croissant","price":"13.60","price_set":{"shop_money":{"amount":"13.60","currency_code":"CHF"},"presentment_money":{"amount":"13.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687755092306,"properties":[],"quantity":3,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1263","taxable":true,"title":"Bauli Schoko Croissant","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":53072652566866,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489507154,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489507154","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Kit Kat Choco Waffel","price":"34.50","price_set":{"shop_money":{"amount":"34.50","currency_code":"CHF"},"presentment_money":{"amount":"34.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687926632786,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3945","taxable":true,"title":"Kit Kat Choco Waffel","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":53073266999634,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489539922,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489539922","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Granini Fruchtcocktail 33Cl Pet","price":"53.76","price_set":{"shop_money":{"amount":"53.76","currency_code":"CHF"},"presentment_money":{"amount":"53.76","currency_code":"CHF"}},"product_exists":true,"product_id":10687771214162,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1862","taxable":true,"title":"Granini Fruchtcocktail 33Cl Pet","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":53072681566546,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489572690,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489572690","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"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":18284489605458,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489605458","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Kakao Aktiv Zuckerreduziert","price":"112.50","price_set":{"shop_money":{"amount":"112.50","currency_code":"CHF"},"presentment_money":{"amount":"112.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687759778130,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1520","taxable":true,"title":"Kakao Aktiv Zuckerreduziert","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":53072660693330,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489638226,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489638226","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"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":18284489670994,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489670994","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Fusili Ai Funghi 350G","price":"42.00","price_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687890162002,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3345","taxable":true,"title":"Fusili Ai Funghi 350G","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":53073102405970,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489703762,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489703762","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Ravioli Napoletana 350G","price":"42.00","price_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687890653522,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3352","taxable":true,"title":"Ravioli Napoletana 350G","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":53073102995794,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489736530,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489736530","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Ghackets Mit Hörnli 350G","price":"42.00","price_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687890456914,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3348","taxable":true,"title":"Ghackets Mit Hörnli 350G","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":53073102831954,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489769298,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489769298","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"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":3,"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":18284489802066,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489802066","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Milka Tender","price":"77.44","price_set":{"shop_money":{"amount":"77.44","currency_code":"CHF"},"presentment_money":{"amount":"77.44","currency_code":"CHF"}},"product_exists":true,"product_id":10687701451090,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1007","taxable":true,"title":"Milka Tender","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":53072469524818,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18284489834834,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489834834","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Teebeutel Hagenbutten","price":"13.50","price_set":{"shop_money":{"amount":"13.50","currency_code":"CHF"},"presentment_money":{"amount":"13.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687768756562,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1577","taxable":true,"title":"Teebeutel Hagenbutten","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":53072673898834,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}],"payment_terms":null,"refunds":[{"id":1081745768786,"admin_graphql_api_id":"gid:\/\/shopify\/Refund\/1081745768786","created_at":"2026-05-19T16:02:20+02:00","note":"Order canceled","order_id":7785655304530,"processed_at":"2026-05-19T16:02:20+02:00","restock":true,"total_duties_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"user_id":null,"order_adjustments":[],"transactions":[{"id":8988068348242,"admin_graphql_api_id":"gid:\/\/shopify\/OrderTransaction\/8988068348242","amount":"0.00","authorization":null,"created_at":"2026-05-19T16:02:20+02:00","currency":"CHF","device_id":null,"error_code":null,"gateway":"Kauf auf Rechnung (Invoice)","kind":"void","location_id":null,"message":"Marked the Kauf auf Rechnung (Invoice) payment as voided","order_id":7785655304530,"parent_id":8951981244754,"payment_id":"#1065.1","processed_at":"2026-05-19T16:02:20+02:00","receipt":{},"source_name":"283573485569","status":"success","test":false,"user_id":null}],"refund_line_items":[{"id":773933269330,"line_item_id":18284489146706,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":38.4,"subtotal_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489146706,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489146706","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Coca-Cola Mezzo Mix 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687913066834,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3775","taxable":true,"title":"Coca-Cola Mezzo Mix 5Dl Pet","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":53073194484050,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933302098,"line_item_id":18284489179474,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":35.0,"subtotal_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489179474,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489179474","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nespresso Finezzo","price":"35.00","price_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687904809298,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3686","taxable":true,"title":"Nespresso Finezzo","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":53073146347858,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933334866,"line_item_id":18284489212242,"location_id":113214685522,"quantity":2,"restock_type":"cancel","subtotal":70.0,"subtotal_set":{"shop_money":{"amount":"70.00","currency_code":"CHF"},"presentment_money":{"amount":"70.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489212242,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489212242","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nespresso Intenso","price":"35.00","price_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687904416082,"properties":[],"quantity":2,"requires_shipping":true,"sku":"3684","taxable":true,"title":"Nespresso Intenso","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":53073144054098,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933367634,"line_item_id":18284489245010,"location_id":113214685522,"quantity":2,"restock_type":"cancel","subtotal":70.0,"subtotal_set":{"shop_money":{"amount":"70.00","currency_code":"CHF"},"presentment_money":{"amount":"70.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489245010,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489245010","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Nespresso Forte","price":"35.00","price_set":{"shop_money":{"amount":"35.00","currency_code":"CHF"},"presentment_money":{"amount":"35.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687904645458,"properties":[],"quantity":2,"requires_shipping":true,"sku":"3685","taxable":true,"title":"Nespresso Forte","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":53073145495890,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933400402,"line_item_id":18284489277778,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":18.4,"subtotal_set":{"shop_money":{"amount":"18.40","currency_code":"CHF"},"presentment_money":{"amount":"18.40","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489277778,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489277778","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Icetea Peach 5Dl","price":"18.40","price_set":{"shop_money":{"amount":"18.40","currency_code":"CHF"},"presentment_money":{"amount":"18.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687815385426,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2680","taxable":true,"title":"Icetea Peach 5Dl","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":53072813883730,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933433170,"line_item_id":18284489310546,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":18.4,"subtotal_set":{"shop_money":{"amount":"18.40","currency_code":"CHF"},"presentment_money":{"amount":"18.40","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489310546,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489310546","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Icetea Lemon 5Dl","price":"18.40","price_set":{"shop_money":{"amount":"18.40","currency_code":"CHF"},"presentment_money":{"amount":"18.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687815090514,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2679","taxable":true,"title":"Icetea Lemon 5Dl","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":53072811589970,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933465938,"line_item_id":18284489343314,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":179.0,"subtotal_set":{"shop_money":{"amount":"179.00","currency_code":"CHF"},"presentment_money":{"amount":"179.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489343314,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489343314","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Automatenbecher \"Hybrid\" 1,8 Dl","price":"179.00","price_set":{"shop_money":{"amount":"179.00","currency_code":"CHF"},"presentment_money":{"amount":"179.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687908020562,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3716","taxable":true,"title":"Automatenbecher \"Hybrid\" 1,8 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":53073162633554,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933498706,"line_item_id":18284489376082,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":30.7,"subtotal_set":{"shop_money":{"amount":"30.70","currency_code":"CHF"},"presentment_money":{"amount":"30.70","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489376082,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489376082","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Henniez Naturale 5Dl Pet","price":"30.70","price_set":{"shop_money":{"amount":"30.70","currency_code":"CHF"},"presentment_money":{"amount":"30.70","currency_code":"CHF"}},"product_exists":true,"product_id":10687905497426,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3690","taxable":true,"title":"Henniez Naturale 5Dl Pet","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":53073151623506,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933531474,"line_item_id":18284489408850,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":38.4,"subtotal_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489408850,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489408850","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Coca-Cola 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687912771922,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3774","taxable":true,"title":"Coca-Cola 5Dl Pet","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":53073191960914,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933564242,"line_item_id":18284489441618,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":21.1,"subtotal_set":{"shop_money":{"amount":"21.10","currency_code":"CHF"},"presentment_money":{"amount":"21.10","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489441618,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489441618","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Fini Pica Jungle Ropes Erdbeer","price":"21.10","price_set":{"shop_money":{"amount":"21.10","currency_code":"CHF"},"presentment_money":{"amount":"21.10","currency_code":"CHF"}},"product_exists":true,"product_id":10687756894546,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1410","taxable":true,"title":"Fini Pica Jungle Ropes Erdbeer","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":53072655548754,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933597010,"line_item_id":18284489474386,"location_id":113214685522,"quantity":3,"restock_type":"cancel","subtotal":40.8,"subtotal_set":{"shop_money":{"amount":"40.80","currency_code":"CHF"},"presentment_money":{"amount":"40.80","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489474386,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489474386","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Bauli Schoko Croissant","price":"13.60","price_set":{"shop_money":{"amount":"13.60","currency_code":"CHF"},"presentment_money":{"amount":"13.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687755092306,"properties":[],"quantity":3,"requires_shipping":true,"sku":"1263","taxable":true,"title":"Bauli Schoko Croissant","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":53072652566866,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933629778,"line_item_id":18284489507154,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":34.5,"subtotal_set":{"shop_money":{"amount":"34.50","currency_code":"CHF"},"presentment_money":{"amount":"34.50","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489507154,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489507154","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Kit Kat Choco Waffel","price":"34.50","price_set":{"shop_money":{"amount":"34.50","currency_code":"CHF"},"presentment_money":{"amount":"34.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687926632786,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3945","taxable":true,"title":"Kit Kat Choco Waffel","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":53073266999634,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933662546,"line_item_id":18284489539922,"location_id":113214685522,"quantity":2,"restock_type":"cancel","subtotal":107.52,"subtotal_set":{"shop_money":{"amount":"107.52","currency_code":"CHF"},"presentment_money":{"amount":"107.52","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489539922,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489539922","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Granini Fruchtcocktail 33Cl Pet","price":"53.76","price_set":{"shop_money":{"amount":"53.76","currency_code":"CHF"},"presentment_money":{"amount":"53.76","currency_code":"CHF"}},"product_exists":true,"product_id":10687771214162,"properties":[],"quantity":2,"requires_shipping":true,"sku":"1862","taxable":true,"title":"Granini Fruchtcocktail 33Cl Pet","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":53072681566546,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933695314,"line_item_id":18284489572690,"location_id":113214685522,"quantity":2,"restock_type":"cancel","subtotal":187.2,"subtotal_set":{"shop_money":{"amount":"187.20","currency_code":"CHF"},"presentment_money":{"amount":"187.20","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489572690,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489572690","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"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,"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":773933728082,"line_item_id":18284489605458,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":112.5,"subtotal_set":{"shop_money":{"amount":"112.50","currency_code":"CHF"},"presentment_money":{"amount":"112.50","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489605458,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489605458","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Kakao Aktiv Zuckerreduziert","price":"112.50","price_set":{"shop_money":{"amount":"112.50","currency_code":"CHF"},"presentment_money":{"amount":"112.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687759778130,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1520","taxable":true,"title":"Kakao Aktiv Zuckerreduziert","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":53072660693330,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933760850,"line_item_id":18284489638226,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":256.5,"subtotal_set":{"shop_money":{"amount":"256.50","currency_code":"CHF"},"presentment_money":{"amount":"256.50","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489638226,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489638226","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"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,"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":773933793618,"line_item_id":18284489670994,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":42.0,"subtotal_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489670994,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489670994","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Fusili Ai Funghi 350G","price":"42.00","price_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687890162002,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3345","taxable":true,"title":"Fusili Ai Funghi 350G","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":53073102405970,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933826386,"line_item_id":18284489703762,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":42.0,"subtotal_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489703762,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489703762","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Ravioli Napoletana 350G","price":"42.00","price_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687890653522,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3352","taxable":true,"title":"Ravioli Napoletana 350G","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":53073102995794,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933859154,"line_item_id":18284489736530,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":42.0,"subtotal_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489736530,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489736530","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Ghackets Mit Hörnli 350G","price":"42.00","price_set":{"shop_money":{"amount":"42.00","currency_code":"CHF"},"presentment_money":{"amount":"42.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687890456914,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3348","taxable":true,"title":"Ghackets Mit Hörnli 350G","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":53073102831954,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933891922,"line_item_id":18284489769298,"location_id":113214685522,"quantity":3,"restock_type":"cancel","subtotal":60.0,"subtotal_set":{"shop_money":{"amount":"60.00","currency_code":"CHF"},"presentment_money":{"amount":"60.00","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489769298,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489769298","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"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":3,"requires_shipping":true,"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":773933924690,"line_item_id":18284489802066,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":77.44,"subtotal_set":{"shop_money":{"amount":"77.44","currency_code":"CHF"},"presentment_money":{"amount":"77.44","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489802066,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489802066","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Milka Tender","price":"77.44","price_set":{"shop_money":{"amount":"77.44","currency_code":"CHF"},"presentment_money":{"amount":"77.44","currency_code":"CHF"}},"product_exists":true,"product_id":10687701451090,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1007","taxable":true,"title":"Milka Tender","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":53072469524818,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}},{"id":773933957458,"line_item_id":18284489834834,"location_id":113214685522,"quantity":1,"restock_type":"cancel","subtotal":13.5,"subtotal_set":{"shop_money":{"amount":"13.50","currency_code":"CHF"},"presentment_money":{"amount":"13.50","currency_code":"CHF"}},"total_tax":0.0,"total_tax_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"line_item":{"id":18284489834834,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18284489834834","attributed_staffs":[],"current_quantity":0,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":null,"gift_card":false,"grams":0,"name":"Teebeutel Hagenbutten","price":"13.50","price_set":{"shop_money":{"amount":"13.50","currency_code":"CHF"},"presentment_money":{"amount":"13.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687768756562,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1577","taxable":true,"title":"Teebeutel Hagenbutten","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":53072673898834,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}}],"duties":[]}],"shipping_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},"shipping_lines":[{"id":6133735358802,"carrier_identifier":null,"code":"free shipping","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":"free shipping","tax_lines":[],"discount_allocations":[]}],"returns":[],"line_item_groups":[]}" "orders/updated" "2026-06-19 11:02:16" ] |
|
2.08 ms (1.71%) |
22 |
INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 19338 0 "lineItems" "Coca-Cola Mezzo Mix 5Dl Pet" "3775" 1.0 38.4 "CHF" "" 0 "[]" ] |
|
1.81 ms (1.49%) |
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:
[ 1781859736 "system\x01tags\x01" "site\x01tags\x01" ] |
|
1.75 ms (1.43%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3348' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.70 ms (1.40%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1007' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.68 ms (1.38%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3716' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.64 ms (1.35%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3774' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.62 ms (1.33%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3686' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.61 ms (1.32%) |
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:
[] |
|
1.59 ms (1.30%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3690' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.57 ms (1.29%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3684' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.53 ms (1.26%) |
15 |
SELECT * FROM object_relations_product WHERE src_id = ?
Parameters:
[
18799
]
|
|
1.50 ms (1.23%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3685' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.42 ms (1.16%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1577' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.39 ms (1.14%) |
15 |
SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de','fr')
Parameters:
[
18799
]
|
|
1.33 ms (1.09%) |
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:
[
7785655304530
]
|
|
1.22 ms (1.00%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3945' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.12 ms (0.92%) |
1 |
DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 19338 "payload" ] |
|
1.05 ms (0.86%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1410' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.02 ms (0.84%) |
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:
[] |
|
1.01 ms (0.83%) |
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/05/07/" 19338 1778158876 1781859736 1858 0 0 19335 "object" "1065" 0 null null "orders" 1 "Orders" ] |
|
0.97 ms (0.80%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2680' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.96 ms (0.79%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2679' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.96 ms (0.79%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3352' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.96 ms (0.78%) |
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:
[] |
|
0.90 ms (0.74%) |
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:
[ 19338 7785655304530.0 "1065" "voided" 0.0 "CHF" "claribel_matilde@hotmail.com" "2026-05-07 15:01:12" null "rejected" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1065",\n "ExternalOrderReference": "75992ab1-1d5f-457a-807d-c19c35bf60aa",\n "ExternalOrderNumber": 65,\n "CreationDate": "2026-05-07",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1535.36,\n "TotalAmountExcludingTax": 1535.36\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 35,\n "PositionTotalIncludingTax": 35,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3686,\n "Type": "A",\n "Name": "17484",\n "Description": "Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3684,\n "Type": "A",\n "Name": "17481",\n "Description": "Nespresso Intenso"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3685,\n "Type": "A",\n "Name": "17482",\n "Description": "Nespresso Forte"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2680,\n "Type": "A",\n "Name": "14591",\n "Description": "Icetea Peach 5Dl"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2679,\n "Type": "A",\n "Name": "14590",\n "Description": "Icetea Lemon 5Dl"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 30.7,\n "PerQuantityIncludingTax": 30.7,\n "PositionTotalExcludingTax": 30.7,\n "PositionTotalIncludingTax": 30.7,\n "PerQuantityExcludingTaxRelevant": 30.7,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3690,\n "Type": "A",\n "Name": "17491",\n "Description": "Henniez Naturale 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 40.8,\n "PositionTotalIncludingTax": 40.8,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 107.52,\n "PositionTotalIncludingTax": 107.52,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 14,\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": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 16,\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": 17,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3345,\n "Type": "A",\n "Name": "17267",\n "Description": "Fusili Ai Funghi 350G"\n }\n },\n {\n "LineItemId": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3352,\n "Type": "A",\n "Name": "17274",\n "Description": "Ravioli Napoletana 350G"\n }\n },\n {\n "LineItemId": 19,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3348,\n "Type": "A",\n "Name": "17270",\n "Description": "Ghackets Mit Hörnli 350G"\n }\n },\n {\n "LineItemId": 20,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 60,\n "PositionTotalIncludingTax": 60,\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": 21,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 77.44,\n "PerQuantityIncludingTax": 77.44,\n "PositionTotalExcludingTax": 77.44,\n "PositionTotalIncludingTax": 77.44,\n "PerQuantityExcludingTaxRelevant": 77.44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1007,\n "Type": "A",\n "Name": "12980",\n "Description": "Milka Tender"\n }\n },\n {\n "LineItemId": 22,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.5,\n "PerQuantityIncludingTax": 13.5,\n "PositionTotalExcludingTax": 13.5,\n "PositionTotalIncludingTax": 13.5,\n "PerQuantityExcludingTaxRelevant": 13.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1577,\n "Type": "A",\n "Name": "13789",\n "Description": "Teebeutel Hagenbutten"\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 "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": "rejected",\n "erp_updated_at": "2026-06-19T09:00:02+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ 19338 ] |
|
0.89 ms (0.73%) |
1 |
INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 7785655304530.0 "1065" "voided" 0.0 "CHF" "claribel_matilde@hotmail.com" "2026-05-07 15:01:12" null "rejected" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1065",\n "ExternalOrderReference": "75992ab1-1d5f-457a-807d-c19c35bf60aa",\n "ExternalOrderNumber": 65,\n "CreationDate": "2026-05-07",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1535.36,\n "TotalAmountExcludingTax": 1535.36\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 35,\n "PositionTotalIncludingTax": 35,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3686,\n "Type": "A",\n "Name": "17484",\n "Description": "Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3684,\n "Type": "A",\n "Name": "17481",\n "Description": "Nespresso Intenso"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3685,\n "Type": "A",\n "Name": "17482",\n "Description": "Nespresso Forte"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2680,\n "Type": "A",\n "Name": "14591",\n "Description": "Icetea Peach 5Dl"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2679,\n "Type": "A",\n "Name": "14590",\n "Description": "Icetea Lemon 5Dl"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 30.7,\n "PerQuantityIncludingTax": 30.7,\n "PositionTotalExcludingTax": 30.7,\n "PositionTotalIncludingTax": 30.7,\n "PerQuantityExcludingTaxRelevant": 30.7,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3690,\n "Type": "A",\n "Name": "17491",\n "Description": "Henniez Naturale 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 40.8,\n "PositionTotalIncludingTax": 40.8,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 107.52,\n "PositionTotalIncludingTax": 107.52,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 14,\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": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 16,\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": 17,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3345,\n "Type": "A",\n "Name": "17267",\n "Description": "Fusili Ai Funghi 350G"\n }\n },\n {\n "LineItemId": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3352,\n "Type": "A",\n "Name": "17274",\n "Description": "Ravioli Napoletana 350G"\n }\n },\n {\n "LineItemId": 19,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3348,\n "Type": "A",\n "Name": "17270",\n "Description": "Ghackets Mit Hörnli 350G"\n }\n },\n {\n "LineItemId": 20,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 60,\n "PositionTotalIncludingTax": 60,\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": 21,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 77.44,\n "PerQuantityIncludingTax": 77.44,\n "PositionTotalExcludingTax": 77.44,\n "PositionTotalIncludingTax": 77.44,\n "PerQuantityExcludingTaxRelevant": 77.44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1007,\n "Type": "A",\n "Name": "12980",\n "Description": "Milka Tender"\n }\n },\n {\n "LineItemId": 22,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.5,\n "PerQuantityIncludingTax": 13.5,\n "PositionTotalExcludingTax": 13.5,\n "PositionTotalIncludingTax": 13.5,\n "PerQuantityExcludingTaxRelevant": 13.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1577,\n "Type": "A",\n "Name": "13789",\n "Description": "Teebeutel Hagenbutten"\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 "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": "rejected",\n "erp_updated_at": "2026-06-19T09:00:02+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ 19338 ] |
|
0.89 ms (0.73%) |
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:
[ 7785655304530.0 "1065" "voided" 0.0 "CHF" "claribel_matilde@hotmail.com" "2026-05-07 15:01:12" null "rejected" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1065",\n "ExternalOrderReference": "75992ab1-1d5f-457a-807d-c19c35bf60aa",\n "ExternalOrderNumber": 65,\n "CreationDate": "2026-05-07",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1535.36,\n "TotalAmountExcludingTax": 1535.36\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 35,\n "PositionTotalIncludingTax": 35,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3686,\n "Type": "A",\n "Name": "17484",\n "Description": "Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3684,\n "Type": "A",\n "Name": "17481",\n "Description": "Nespresso Intenso"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3685,\n "Type": "A",\n "Name": "17482",\n "Description": "Nespresso Forte"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2680,\n "Type": "A",\n "Name": "14591",\n "Description": "Icetea Peach 5Dl"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2679,\n "Type": "A",\n "Name": "14590",\n "Description": "Icetea Lemon 5Dl"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 30.7,\n "PerQuantityIncludingTax": 30.7,\n "PositionTotalExcludingTax": 30.7,\n "PositionTotalIncludingTax": 30.7,\n "PerQuantityExcludingTaxRelevant": 30.7,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3690,\n "Type": "A",\n "Name": "17491",\n "Description": "Henniez Naturale 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 40.8,\n "PositionTotalIncludingTax": 40.8,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 107.52,\n "PositionTotalIncludingTax": 107.52,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 14,\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": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 16,\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": 17,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3345,\n "Type": "A",\n "Name": "17267",\n "Description": "Fusili Ai Funghi 350G"\n }\n },\n {\n "LineItemId": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3352,\n "Type": "A",\n "Name": "17274",\n "Description": "Ravioli Napoletana 350G"\n }\n },\n {\n "LineItemId": 19,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3348,\n "Type": "A",\n "Name": "17270",\n "Description": "Ghackets Mit Hörnli 350G"\n }\n },\n {\n "LineItemId": 20,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 60,\n "PositionTotalIncludingTax": 60,\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": 21,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 77.44,\n "PerQuantityIncludingTax": 77.44,\n "PositionTotalExcludingTax": 77.44,\n "PositionTotalIncludingTax": 77.44,\n "PerQuantityExcludingTaxRelevant": 77.44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1007,\n "Type": "A",\n "Name": "12980",\n "Description": "Milka Tender"\n }\n },\n {\n "LineItemId": 22,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.5,\n "PerQuantityIncludingTax": 13.5,\n "PositionTotalExcludingTax": 13.5,\n "PositionTotalIncludingTax": 13.5,\n "PerQuantityExcludingTaxRelevant": 13.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1577,\n "Type": "A",\n "Name": "13789",\n "Description": "Teebeutel Hagenbutten"\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 "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": "rejected",\n "erp_updated_at": "2026-06-19T09:00:02+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ 19338 19338 ] |
|
0.86 ms (0.71%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1862' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.85 ms (0.70%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '19338')
Parameters:
[] |
|
0.83 ms (0.68%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Orders/Leomat/2026/05/07/" "1065" ] |
|
0.78 ms (0.64%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1520' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.76 ms (0.62%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
|
0.75 ms (0.62%) |
1 |
SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 19338 "payload" ] |
|
0.74 ms (0.61%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3345' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.67 ms (0.55%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1263' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.67 ms (0.55%) |
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:
[] |
|
0.62 ms (0.51%) |
1 |
SHOW COLUMNS FROM object_query_orders
Parameters:
[] |
|
0.62 ms (0.51%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
|
0.61 ms (0.50%) |
1 |
SHOW COLUMNS FROM object_store_orders
Parameters:
[] |
|
0.61 ms (0.50%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.60 ms (0.50%) |
1 |
INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 19338 7785655304530.0 "1065" "voided" 0.0 "CHF" "claribel_matilde@hotmail.com" "2026-05-07 15:01:12" null "rejected" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1065",\n "ExternalOrderReference": "75992ab1-1d5f-457a-807d-c19c35bf60aa",\n "ExternalOrderNumber": 65,\n "CreationDate": "2026-05-07",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1535.36,\n "TotalAmountExcludingTax": 1535.36\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 35,\n "PositionTotalIncludingTax": 35,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3686,\n "Type": "A",\n "Name": "17484",\n "Description": "Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3684,\n "Type": "A",\n "Name": "17481",\n "Description": "Nespresso Intenso"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 35,\n "PerQuantityIncludingTax": 35,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 35,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3685,\n "Type": "A",\n "Name": "17482",\n "Description": "Nespresso Forte"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2680,\n "Type": "A",\n "Name": "14591",\n "Description": "Icetea Peach 5Dl"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18.4,\n "PerQuantityIncludingTax": 18.4,\n "PositionTotalExcludingTax": 18.4,\n "PositionTotalIncludingTax": 18.4,\n "PerQuantityExcludingTaxRelevant": 18.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2679,\n "Type": "A",\n "Name": "14590",\n "Description": "Icetea Lemon 5Dl"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 30.7,\n "PerQuantityIncludingTax": 30.7,\n "PositionTotalExcludingTax": 30.7,\n "PositionTotalIncludingTax": 30.7,\n "PerQuantityExcludingTaxRelevant": 30.7,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3690,\n "Type": "A",\n "Name": "17491",\n "Description": "Henniez Naturale 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 40.8,\n "PositionTotalIncludingTax": 40.8,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 107.52,\n "PositionTotalIncludingTax": 107.52,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 14,\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": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 16,\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": 17,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3345,\n "Type": "A",\n "Name": "17267",\n "Description": "Fusili Ai Funghi 350G"\n }\n },\n {\n "LineItemId": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3352,\n "Type": "A",\n "Name": "17274",\n "Description": "Ravioli Napoletana 350G"\n }\n },\n {\n "LineItemId": 19,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42,\n "PerQuantityIncludingTax": 42,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 42,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3348,\n "Type": "A",\n "Name": "17270",\n "Description": "Ghackets Mit Hörnli 350G"\n }\n },\n {\n "LineItemId": 20,\n "Quantity": 3,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 60,\n "PositionTotalIncludingTax": 60,\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": 21,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 77.44,\n "PerQuantityIncludingTax": 77.44,\n "PositionTotalExcludingTax": 77.44,\n "PositionTotalIncludingTax": 77.44,\n "PerQuantityExcludingTaxRelevant": 77.44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1007,\n "Type": "A",\n "Name": "12980",\n "Description": "Milka Tender"\n }\n },\n {\n "LineItemId": 22,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.5,\n "PerQuantityIncludingTax": 13.5,\n "PositionTotalExcludingTax": 13.5,\n "PositionTotalIncludingTax": 13.5,\n "PerQuantityExcludingTaxRelevant": 13.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1577,\n "Type": "A",\n "Name": "13789",\n "Description": "Teebeutel Hagenbutten"\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 "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": "rejected",\n "erp_updated_at": "2026-06-19T09:00:02+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ ] |
|
0.49 ms (0.40%) |
1 |
DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 19338 "lineItems" ] |
|
0.44 ms (0.36%) |
5 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/webhook/shopify/leomat/" "order" ] |
|
0.39 ms (0.32%) |
1 |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 19338 "object" 0 "" 1781859736 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} """ 1858 null null 0 "fs" ] |
|
0.39 ms (0.32%) |
1 |
SELECT * FROM object_relations_orders WHERE src_id = ?
Parameters:
[
19338
]
|
|
0.32 ms (0.26%) |
2 |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
19335
]
|
|
0.31 ms (0.25%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
19338
]
|
|
0.29 ms (0.24%) |
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:19338;}}" "[]" "pimcore_search_backend_message" "2026-06-19 09:02:17" "2026-06-19 09:02:17" ] |
|
0.27 ms (0.23%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/webhook/shopify/leomat/order"
]
|
|
0.26 ms (0.22%) |
1 |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,19335,19311,5997,5996,5995) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
19338
]
|
|
0.25 ms (0.21%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 19338 "object" ] |
|
0.25 ms (0.20%) |
1 |
SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '19338' AND `fieldname` = 'payload' LIMIT 1
Parameters:
[] |
|
0.24 ms (0.19%) |
1 |
SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '19338' AND `fieldname` = 'lineItems' LIMIT 1
Parameters:
[] |
|
0.24 ms (0.19%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_19338\x01tags\x01" "object_properties\x01tags\x01" ] |
|
0.23 ms (0.19%) |
1 |
SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE
Parameters:
[
19338
]
|
|
0.23 ms (0.19%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '19338')
Parameters:
[] |
|
0.22 ms (0.18%) |
2 |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"orders"
]
|
|
0.22 ms (0.18%) |
1 |
SELECT * FROM object_query_orders WHERE oo_id = ?
Parameters:
[
19338
]
|
|
0.21 ms (0.17%) |
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:
[ 1781859736 "object_18268\x01tags\x01" "class_product\x01tags\x01" "asset_894\x01tags\x01" "asset_895\x01tags\x01" "asset_896\x01tags\x01" ] |
|
0.18 ms (0.15%) |
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:
[ 1781859736 "object_17533\x01tags\x01" "class_product\x01tags\x01" "asset_3651\x01tags\x01" ] |
|
0.18 ms (0.15%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.17 ms (0.14%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = 19338 AND `ctype` = 'object'
Parameters:
[] |
|
0.15 ms (0.12%) |
1 |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
19338
]
|
|
0.13 ms (0.11%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
|
0.12 ms (0.10%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 19338 ] |
|
0.11 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
|
0.11 ms (0.09%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '19338')
Parameters:
[] |
|
0.10 ms (0.09%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '19338')
Parameters:
[] |
|
0.09 ms (0.07%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 19338 "object" ] |
|
0.08 ms (0.06%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
|
0.06 ms (0.05%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
|
0.05 ms (0.04%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
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.