Query Metrics
239
Database Queries
72
Different statements
703.64 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
624.50 ms (88.75%) |
1 |
INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "/Orders/Leomat/2026/06/18/" 21956 1781777693 1781795559 15 0 0 21945 "object" "1509" 0 null null "orders" 1 "Orders" ] |
|
18.37 ms (2.61%) |
61 |
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:
[ 1781795559 "site_domain_367af465ca304630cf45a2132778bed1" ] |
|
3.22 ms (0.46%) |
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:
[ 21956 8043290919250.0 "1509" "paid" 911.24 "CHF" "veskovac.anita1@gmail.com" "2026-06-18 12:14:50" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1509",\n "ExternalOrderReference": "e55113f7-3f82-473c-a0af-8cec9471b37a",\n "ExternalOrderNumber": 509,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 911.24,\n "TotalAmountExcludingTax": 911.24\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 49.9,\n "PerQuantityIncludingTax": 49.9,\n "PositionTotalExcludingTax": 49.9,\n "PositionTotalIncludingTax": 49.9,\n "PerQuantityExcludingTaxRelevant": 49.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1571,\n "Type": "A",\n "Name": "13783",\n "Description": "Kaffeerahm Emmi 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48,\n "PerQuantityIncludingTax": 48,\n "PositionTotalExcludingTax": 48,\n "PositionTotalIncludingTax": 48,\n "PerQuantityExcludingTaxRelevant": 48,\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": 4,\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": 766,\n "Type": "A",\n "Name": "12531",\n "Description": "Shorley 5Dl Pet"\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": 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": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 22.9,\n "PerQuantityIncludingTax": 22.9,\n "PositionTotalExcludingTax": 22.9,\n "PositionTotalIncludingTax": 22.9,\n "PerQuantityExcludingTaxRelevant": 22.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1877,\n "Type": "A",\n "Name": "10025",\n "Description": "Kaffeerahm Portionen 12G"\n }\n },\n {\n "LineItemId": 8,\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": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 234,\n "PositionTotalIncludingTax": 234,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 10,\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 "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "778044d8-61ca-2b9c-acee-b70733a55451",\n "Account": "Anita"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n }\n },\n "_status_sync": {\n "erp_status": "processed",\n "erp_updated_at": "2026-06-18T15:00:03+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ 21956 ] |
|
3.12 ms (0.44%) |
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:
[ 1781795559 "object_18022\x01tags\x01" "class_product\x01tags\x01" "asset_409\x01tags\x01" "asset_410\x01tags\x01" ] |
|
2.55 ms (0.36%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21956')
Parameters:
[] |
|
2.49 ms (0.35%) |
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:
[ 1781795559 "system\x01tags\x01" "site\x01tags\x01" ] |
|
2.33 ms (0.33%) |
20 |
INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 18022 "object" "product" 21956 "fieldcollection" "lineItems" "0" ] |
|
2.32 ms (0.33%) |
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:
[] |
|
2.28 ms (0.32%) |
8 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
21956
]
|
|
1.96 ms (0.28%) |
8 |
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:
[
21956
]
|
|
1.88 ms (0.27%) |
2 |
INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 21956 0 "payload" "{"id":8043290919250,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/8043290919250","app_id":580111,"browser_ip":"194.230.161.72","buyer_accepts_marketing":false,"cancel_reason":null,"cancelled_at":null,"cart_token":"hWNDRQewP6At2sooYB9VKDvH","checkout_id":48585530769746,"checkout_token":"30e19f3eb69b2eefe0f7f2c6b4e65994","client_details":{"accept_language":"de-CH","browser_height":null,"browser_ip":"194.230.161.72","browser_width":null,"session_hash":null,"user_agent":"Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) SamsungBrowser\/30.0 Chrome\/143.0.0.0 Mobile Safari\/537.36"},"closed_at":"2026-06-18T15:13:54+02:00","company":null,"confirmation_number":"N150GGNMJ","confirmed":true,"contact_email":"veskovac.anita1@gmail.com","created_at":"2026-06-18T12:14:50+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":"911.24","current_subtotal_price_set":{"shop_money":{"amount":"911.24","currency_code":"CHF"},"presentment_money":{"amount":"911.24","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":"911.24","current_total_price_set":{"shop_money":{"amount":"911.24","currency_code":"CHF"},"presentment_money":{"amount":"911.24","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":"veskovac.anita1@gmail.com","estimated_taxes":false,"financial_status":"paid","fulfillment_status":"fulfilled","landing_site":"\/","landing_site_ref":null,"location_id":null,"merchant_business_entity_id":"30495605074","merchant_of_record_app_id":null,"name":"#1509","note":null,"note_attributes":[],"number":509,"order_number":1509,"order_status_url":"https:\/\/shop.myleomat.ch\/99699687762\/orders\/ff54ba673e84e32b8d52e2534cd82e59\/authenticate?key=40806aba5cdc35af52d638c3e6558be7","original_total_additional_fees_set":null,"original_total_duties_set":null,"payment_gateway_names":["Kauf auf Rechnung (Invoice)"],"phone":null,"po_number":null,"presentment_currency":"CHF","processed_at":"2026-06-18T12:14:49+02:00","reference":null,"referring_site":null,"source_identifier":null,"source_name":"web","source_url":null,"subtotal_price":"911.24","subtotal_price_set":{"shop_money":{"amount":"911.24","currency_code":"CHF"},"presentment_money":{"amount":"911.24","currency_code":"CHF"}},"tags":"leomat-erp-status:processed","tax_exempt":false,"tax_lines":[],"taxes_included":true,"test":false,"token":"ff54ba673e84e32b8d52e2534cd82e59","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":"911.24","total_line_items_price_set":{"shop_money":{"amount":"911.24","currency_code":"CHF"},"presentment_money":{"amount":"911.24","currency_code":"CHF"}},"total_outstanding":"0.00","total_price":"911.24","total_price_set":{"shop_money":{"amount":"911.24","currency_code":"CHF"},"presentment_money":{"amount":"911.24","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-18T17:12:37+02:00","user_id":null,"billing_address":{"first_name":"Anita","address1":"Mühlegutstrasse 14","phone":null,"city":"Goldach","zip":"9403","province":null,"country":"Switzerland","last_name":"Veskovac","address2":null,"company":null,"latitude":47.4764027,"longitude":9.4634459,"name":"Anita Veskovac","country_code":"CH","province_code":null},"customer":{"id":10155379720530,"created_at":"2026-03-19T06:48:44+01:00","updated_at":"2026-06-18T15:13:57+02:00","first_name":"Anita","last_name":"2020180000","state":"enabled","note":null,"verified_email":true,"multipass_identifier":null,"tax_exempt":false,"email":"veskovac.anita1@gmail.com","phone":null,"currency":"CHF","tax_exemptions":[],"admin_graphql_api_id":"gid:\/\/shopify\/Customer\/10155379720530","default_address":{"id":12461606732114,"customer_id":10155379720530,"first_name":"Anita","last_name":"Veskovac","company":null,"address1":"Mühlegutstrasse 14","address2":null,"city":"Goldach","province":null,"country":"Switzerland","zip":"9403","phone":null,"name":"Anita Veskovac","province_code":null,"country_code":"CH","country_name":"Switzerland","default":true}},"discount_applications":[],"fulfillments":[{"id":7007050039634,"admin_graphql_api_id":"gid:\/\/shopify\/Fulfillment\/7007050039634","created_at":"2026-06-18T15:13:53+02:00","location_id":113214685522,"name":"#1509.1","order_id":8043290919250,"origin_address":{},"receipt":{},"service":"manual","shipment_status":null,"status":"success","tracking_company":null,"tracking_number":null,"tracking_numbers":[],"tracking_url":null,"tracking_urls":[],"updated_at":"2026-06-18T15:13:53+02:00","line_items":[{"id":18745005080914,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005080914","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kaffeerahm Emmi 5Dl Pet","price":"49.90","price_set":{"shop_money":{"amount":"49.90","currency_code":"CHF"},"presentment_money":{"amount":"49.90","currency_code":"CHF"}},"product_exists":true,"product_id":10687767904594,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1571","taxable":true,"title":"Kaffeerahm Emmi 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":53072672424274,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005113682,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005113682","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Vollmilch Uht 3.5% (8X1.5L)","price":"17.54","price_set":{"shop_money":{"amount":"17.54","currency_code":"CHF"},"presentment_money":{"amount":"17.54","currency_code":"CHF"}},"product_exists":true,"product_id":10687803687250,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2396","taxable":true,"title":"Vollmilch Uht 3.5% (8X1.5L)","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":53072776724818,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005146450,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005146450","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Ghackets Mit Hörnli 350G","price":"48.00","price_set":{"shop_money":{"amount":"48.00","currency_code":"CHF"},"presentment_money":{"amount":"48.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":18745005179218,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005179218","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Shorley 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":10687697518930,"properties":[],"quantity":1,"requires_shipping":true,"sku":"766","taxable":true,"title":"Shorley 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":53072458940754,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005211986,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005211986","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745005244754,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005244754","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745005277522,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005277522","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kaffeerahm Portionen 12G","price":"22.90","price_set":{"shop_money":{"amount":"22.90","currency_code":"CHF"},"presentment_money":{"amount":"22.90","currency_code":"CHF"}},"product_exists":true,"product_id":10687771509074,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1877","taxable":true,"title":"Kaffeerahm Portionen 12G","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072682156370,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005310290,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005310290","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745005343058,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005343058","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Barone Leomat Premium Bohnenkaffee","price":"234.00","price_set":{"shop_money":{"amount":"234.00","currency_code":"CHF"},"presentment_money":{"amount":"234.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687698469202,"properties":[],"quantity":1,"requires_shipping":true,"sku":"819","taxable":true,"title":"Barone Leomat Premium Bohnenkaffee","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":53072461627730,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005375826,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005375826","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":[]}]}],"line_items":[{"id":18745005080914,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005080914","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kaffeerahm Emmi 5Dl Pet","price":"49.90","price_set":{"shop_money":{"amount":"49.90","currency_code":"CHF"},"presentment_money":{"amount":"49.90","currency_code":"CHF"}},"product_exists":true,"product_id":10687767904594,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1571","taxable":true,"title":"Kaffeerahm Emmi 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":53072672424274,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005113682,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005113682","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Vollmilch Uht 3.5% (8X1.5L)","price":"17.54","price_set":{"shop_money":{"amount":"17.54","currency_code":"CHF"},"presentment_money":{"amount":"17.54","currency_code":"CHF"}},"product_exists":true,"product_id":10687803687250,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2396","taxable":true,"title":"Vollmilch Uht 3.5% (8X1.5L)","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":53072776724818,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005146450,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005146450","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Ghackets Mit Hörnli 350G","price":"48.00","price_set":{"shop_money":{"amount":"48.00","currency_code":"CHF"},"presentment_money":{"amount":"48.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":18745005179218,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005179218","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Shorley 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":10687697518930,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"766","taxable":true,"title":"Shorley 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":53072458940754,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005211986,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005211986","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745005244754,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005244754","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745005277522,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005277522","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kaffeerahm Portionen 12G","price":"22.90","price_set":{"shop_money":{"amount":"22.90","currency_code":"CHF"},"presentment_money":{"amount":"22.90","currency_code":"CHF"}},"product_exists":true,"product_id":10687771509074,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1877","taxable":true,"title":"Kaffeerahm Portionen 12G","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072682156370,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005310290,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005310290","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745005343058,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005343058","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Barone Leomat Premium Bohnenkaffee","price":"234.00","price_set":{"shop_money":{"amount":"234.00","currency_code":"CHF"},"presentment_money":{"amount":"234.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687698469202,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"819","taxable":true,"title":"Barone Leomat Premium Bohnenkaffee","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":53072461627730,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745005375826,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745005375826","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":[]}],"payment_terms":null,"refunds":[],"shipping_address":null,"shipping_lines":[{"id":6259357122898,"carrier_identifier":null,"code":"Wiesenstrasse 2","current_discounted_price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"discounted_price":"0.00","discounted_price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"is_removed":false,"phone":null,"price":"0.00","price_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"requested_fulfillment_service_id":null,"source":"shopify","title":"Wiesenstrasse 2","tax_lines":[],"discount_allocations":[]}],"returns":[],"line_item_groups":[]}" "orders/updated" "2026-06-18 17:12:39" ] |
|
1.87 ms (0.27%) |
20 |
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" ] |
|
1.72 ms (0.25%) |
7 |
SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE
Parameters:
[
18022
]
|
|
1.72 ms (0.24%) |
1 |
UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `classId` = ?, `published` = ?, `className` = ? WHERE `id` = ?
Parameters:
[ "/Orders/Leomat/2026/06/18/" 21956 1781777693 1781795559 15 0 0 21945 "object" "1509" 0 null null "orders" 1 "Orders" 21956 ] |
|
1.50 ms (0.21%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1571' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.45 ms (0.21%) |
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:
[] |
|
1.41 ms (0.20%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1877' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.39 ms (0.20%) |
1 |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 21956 "object" 0 "" 1781795559 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} """ 15 null null 0 "fs" ] |
|
1.34 ms (0.19%) |
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:
[ 8043290919250.0 "1509" "paid" 911.24 "CHF" "veskovac.anita1@gmail.com" "2026-06-18 12:14:50" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1509",\n "ExternalOrderReference": "e55113f7-3f82-473c-a0af-8cec9471b37a",\n "ExternalOrderNumber": 509,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 911.24,\n "TotalAmountExcludingTax": 911.24\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 49.9,\n "PerQuantityIncludingTax": 49.9,\n "PositionTotalExcludingTax": 49.9,\n "PositionTotalIncludingTax": 49.9,\n "PerQuantityExcludingTaxRelevant": 49.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1571,\n "Type": "A",\n "Name": "13783",\n "Description": "Kaffeerahm Emmi 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48,\n "PerQuantityIncludingTax": 48,\n "PositionTotalExcludingTax": 48,\n "PositionTotalIncludingTax": 48,\n "PerQuantityExcludingTaxRelevant": 48,\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": 4,\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": 766,\n "Type": "A",\n "Name": "12531",\n "Description": "Shorley 5Dl Pet"\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": 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": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 22.9,\n "PerQuantityIncludingTax": 22.9,\n "PositionTotalExcludingTax": 22.9,\n "PositionTotalIncludingTax": 22.9,\n "PerQuantityExcludingTaxRelevant": 22.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1877,\n "Type": "A",\n "Name": "10025",\n "Description": "Kaffeerahm Portionen 12G"\n }\n },\n {\n "LineItemId": 8,\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": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 234,\n "PositionTotalIncludingTax": 234,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 10,\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 "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "778044d8-61ca-2b9c-acee-b70733a55451",\n "Account": "Anita"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n }\n },\n "_status_sync": {\n "erp_status": "processed",\n "erp_updated_at": "2026-06-18T15:00:03+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ 21956 21956 ] |
|
1.34 ms (0.19%) |
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:
[ 1781795559 "object_17957\x01tags\x01" "class_product\x01tags\x01" "asset_218\x01tags\x01" "asset_219\x01tags\x01" "asset_220\x01tags\x01" "asset_221\x01tags\x01" ] |
|
1.31 ms (0.19%) |
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 => 1781795560 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"\x7Fgö\x07À\x1E";i:1781795560;}" ] |
|
1.20 ms (0.17%) |
10 |
INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 21956 0 "lineItems" "Kaffeerahm Emmi 5Dl Pet" "1571" 1.0 49.9 "CHF" "fulfilled" 0 "[]" ] |
|
1.20 ms (0.17%) |
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.15 ms (0.16%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2396' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.10 ms (0.16%) |
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.05 ms (0.15%) |
1 |
DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 21956 "payload" ] |
|
1.03 ms (0.15%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '766' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.99 ms (0.14%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '819' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.87 ms (0.12%) |
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.78 ms (0.11%) |
7 |
SELECT * FROM object_relations_product WHERE src_id = ?
Parameters:
[
18022
]
|
|
0.72 ms (0.10%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Orders/Leomat/2026/06/18/" "1509" ] |
|
0.71 ms (0.10%) |
1 |
INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 8043290919250.0 "1509" "paid" 911.24 "CHF" "veskovac.anita1@gmail.com" "2026-06-18 12:14:50" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1509",\n "ExternalOrderReference": "e55113f7-3f82-473c-a0af-8cec9471b37a",\n "ExternalOrderNumber": 509,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 911.24,\n "TotalAmountExcludingTax": 911.24\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 49.9,\n "PerQuantityIncludingTax": 49.9,\n "PositionTotalExcludingTax": 49.9,\n "PositionTotalIncludingTax": 49.9,\n "PerQuantityExcludingTaxRelevant": 49.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1571,\n "Type": "A",\n "Name": "13783",\n "Description": "Kaffeerahm Emmi 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48,\n "PerQuantityIncludingTax": 48,\n "PositionTotalExcludingTax": 48,\n "PositionTotalIncludingTax": 48,\n "PerQuantityExcludingTaxRelevant": 48,\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": 4,\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": 766,\n "Type": "A",\n "Name": "12531",\n "Description": "Shorley 5Dl Pet"\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": 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": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 22.9,\n "PerQuantityIncludingTax": 22.9,\n "PositionTotalExcludingTax": 22.9,\n "PositionTotalIncludingTax": 22.9,\n "PerQuantityExcludingTaxRelevant": 22.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1877,\n "Type": "A",\n "Name": "10025",\n "Description": "Kaffeerahm Portionen 12G"\n }\n },\n {\n "LineItemId": 8,\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": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 234,\n "PositionTotalIncludingTax": 234,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 10,\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 "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "778044d8-61ca-2b9c-acee-b70733a55451",\n "Account": "Anita"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n }\n },\n "_status_sync": {\n "erp_status": "processed",\n "erp_updated_at": "2026-06-18T15:00:03+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ 21956 ] |
|
0.69 ms (0.10%) |
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:
[
8043290919250
]
|
|
0.69 ms (0.10%) |
1 |
SHOW COLUMNS FROM object_store_orders
Parameters:
[] |
|
0.67 ms (0.09%) |
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.65 ms (0.09%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
|
0.60 ms (0.09%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
|
0.59 ms (0.08%) |
7 |
SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de','fr')
Parameters:
[
18022
]
|
|
0.57 ms (0.08%) |
1 |
SHOW COLUMNS FROM object_query_orders
Parameters:
[] |
|
0.56 ms (0.08%) |
1 |
INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 21956 8043290919250.0 "1509" "paid" 911.24 "CHF" "veskovac.anita1@gmail.com" "2026-06-18 12:14:50" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1509",\n "ExternalOrderReference": "e55113f7-3f82-473c-a0af-8cec9471b37a",\n "ExternalOrderNumber": 509,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 911.24,\n "TotalAmountExcludingTax": 911.24\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 49.9,\n "PerQuantityIncludingTax": 49.9,\n "PositionTotalExcludingTax": 49.9,\n "PositionTotalIncludingTax": 49.9,\n "PerQuantityExcludingTaxRelevant": 49.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1571,\n "Type": "A",\n "Name": "13783",\n "Description": "Kaffeerahm Emmi 5Dl Pet"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48,\n "PerQuantityIncludingTax": 48,\n "PositionTotalExcludingTax": 48,\n "PositionTotalIncludingTax": 48,\n "PerQuantityExcludingTaxRelevant": 48,\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": 4,\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": 766,\n "Type": "A",\n "Name": "12531",\n "Description": "Shorley 5Dl Pet"\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": 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": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 22.9,\n "PerQuantityIncludingTax": 22.9,\n "PositionTotalExcludingTax": 22.9,\n "PositionTotalIncludingTax": 22.9,\n "PerQuantityExcludingTaxRelevant": 22.9,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1877,\n "Type": "A",\n "Name": "10025",\n "Description": "Kaffeerahm Portionen 12G"\n }\n },\n {\n "LineItemId": 8,\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": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 234,\n "PositionTotalIncludingTax": 234,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 10,\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 "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "778044d8-61ca-2b9c-acee-b70733a55451",\n "Account": "Anita"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Anita",\n "Name": "Veskovac",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n }\n },\n "Address": {\n "Street": "Mühlegutstrasse",\n "HouseNumber": "14",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "veskovac.anita1@gmail.com"\n },\n "Id": 870717\n }\n },\n "_status_sync": {\n "erp_status": "processed",\n "erp_updated_at": "2026-06-18T15:00:03+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ ] |
|
0.51 ms (0.07%) |
1 |
SELECT * FROM object_relations_orders WHERE src_id = ?
Parameters:
[
21956
]
|
|
0.50 ms (0.07%) |
1 |
SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 21956 "payload" ] |
|
0.48 ms (0.07%) |
2 |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
21945
]
|
|
0.42 ms (0.06%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
21956
]
|
|
0.38 ms (0.05%) |
1 |
DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 21956 "lineItems" ] |
|
0.35 ms (0.05%) |
1 |
SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,21945,19990,5997,5996,5995) AND inheritable = 1) OR cid = ? ) AND ctype='object'
Parameters:
[
21956
]
|
|
0.32 ms (0.05%) |
5 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/webhook/shopify/leomat/" "order" ] |
|
0.31 ms (0.04%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = 21956 AND `ctype` = 'object'
Parameters:
[] |
|
0.31 ms (0.04%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
21956
]
|
|
0.31 ms (0.04%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21956')
Parameters:
[] |
|
0.31 ms (0.04%) |
1 |
SELECT * FROM object_query_orders WHERE oo_id = ?
Parameters:
[
21956
]
|
|
0.30 ms (0.04%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.25 ms (0.04%) |
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:
[ 1781795559 "object_18268\x01tags\x01" "class_product\x01tags\x01" "asset_894\x01tags\x01" "asset_895\x01tags\x01" "asset_896\x01tags\x01" ] |
|
0.23 ms (0.03%) |
1 |
SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21956' AND `fieldname` = 'lineItems' LIMIT 1
Parameters:
[] |
|
0.23 ms (0.03%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_21956\x01tags\x01" "object_properties\x01tags\x01" ] |
|
0.22 ms (0.03%) |
1 |
SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21956' AND `fieldname` = 'payload' LIMIT 1
Parameters:
[] |
|
0.22 ms (0.03%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
|
0.21 ms (0.03%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.20 ms (0.03%) |
1 |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
21956
]
|
|
0.20 ms (0.03%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/webhook/shopify/leomat/order"
]
|
|
0.18 ms (0.03%) |
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:21956;}}" "[]" "pimcore_search_backend_message" "2026-06-18 15:12:40" "2026-06-18 15:12:40" ] |
|
0.17 ms (0.02%) |
1 |
SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE
Parameters:
[
21956
]
|
|
0.16 ms (0.02%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 21956 "object" ] |
|
0.15 ms (0.02%) |
2 |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"orders"
]
|
|
0.14 ms (0.02%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 21956 ] |
|
0.14 ms (0.02%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21956')
Parameters:
[] |
|
0.12 ms (0.02%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21956')
Parameters:
[] |
|
0.12 ms (0.02%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 21956 "object" ] |
|
0.10 ms (0.01%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
|
0.08 ms (0.01%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
|
0.08 ms (0.01%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
|
0.07 ms (0.01%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
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.