Query Metrics
390
Database Queries
83
Different statements
112.88 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
25.42 ms (22.52%) |
90 |
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:
[ 1781795561 "site_domain_367af465ca304630cf45a2132778bed1" ] |
|
5.72 ms (5.07%) |
18 |
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:
[ 1781795561 "object_18123\x01tags\x01" "class_product\x01tags\x01" "asset_607\x01tags\x01" "asset_608\x01tags\x01" ] |
|
5.19 ms (4.60%) |
17 |
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:
[
21957
]
|
|
5.04 ms (4.46%) |
42 |
INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 18123 "object" "product" 21957 "fieldcollection" "lineItems" "0" ] |
|
4.57 ms (4.04%) |
42 |
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.85 ms (3.41%) |
16 |
SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE
Parameters:
[
18123
]
|
|
3.53 ms (3.13%) |
17 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
21957
]
|
|
2.49 ms (2.20%) |
9 |
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:
[ 1781795561 "system\x01tags\x01" "site\x01tags\x01" ] |
|
2.46 ms (2.18%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2107' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
2.36 ms (2.09%) |
21 |
INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 21957 0 "lineItems" "Nuss-Schnecke 95G" "2107" 1.0 70.0 "CHF" "fulfilled" 0 "[]" ] |
|
1.93 ms (1.71%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '4923' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.86 ms (1.64%) |
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:
[
8043305140562
]
|
|
1.73 ms (1.54%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3691' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.73 ms (1.53%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2095' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.72 ms (1.52%) |
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 => 1781795561 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"gö\x07À\x1E";i:1781795561;}" ] |
|
1.69 ms (1.50%) |
2 |
INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 21957 0 "payload" "{"id":8043305140562,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/8043305140562","app_id":580111,"browser_ip":"194.230.161.206","buyer_accepts_marketing":false,"cancel_reason":null,"cancelled_at":null,"cart_token":"hWNDTgz8pCbTdwGdnjYY8zB5","checkout_id":48585547776338,"checkout_token":"30c4aab74ba22ee2e75107bdf3ee3fdb","client_details":{"accept_language":"de-CH","browser_height":null,"browser_ip":"194.230.161.206","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:14:00+02:00","company":null,"confirmation_number":"4P2CTZMHK","confirmed":true,"contact_email":"schmidlinpatricia@gmail.com","created_at":"2026-06-18T12:19:27+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":"1868.89","current_subtotal_price_set":{"shop_money":{"amount":"1868.89","currency_code":"CHF"},"presentment_money":{"amount":"1868.89","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":"1868.89","current_total_price_set":{"shop_money":{"amount":"1868.89","currency_code":"CHF"},"presentment_money":{"amount":"1868.89","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":"schmidlinpatricia@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":"#1510","note":null,"note_attributes":[],"number":510,"order_number":1510,"order_status_url":"https:\/\/shop.myleomat.ch\/99699687762\/orders\/6808c2d2526a65f0d866df7b82c85fd9\/authenticate?key=d14046d97208fb9b2ea5e6202095de23","original_total_additional_fees_set":null,"original_total_duties_set":null,"payment_gateway_names":["Kauf auf Rechnung (Invoice)"],"phone":"+41789030611","po_number":null,"presentment_currency":"CHF","processed_at":"2026-06-18T12:19:26+02:00","reference":null,"referring_site":null,"source_identifier":null,"source_name":"web","source_url":null,"subtotal_price":"1868.89","subtotal_price_set":{"shop_money":{"amount":"1868.89","currency_code":"CHF"},"presentment_money":{"amount":"1868.89","currency_code":"CHF"}},"tags":"leomat-erp-status:processed","tax_exempt":false,"tax_lines":[],"taxes_included":true,"test":false,"token":"6808c2d2526a65f0d866df7b82c85fd9","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":"1868.89","total_line_items_price_set":{"shop_money":{"amount":"1868.89","currency_code":"CHF"},"presentment_money":{"amount":"1868.89","currency_code":"CHF"}},"total_outstanding":"0.00","total_price":"1868.89","total_price_set":{"shop_money":{"amount":"1868.89","currency_code":"CHF"},"presentment_money":{"amount":"1868.89","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:39+02:00","user_id":null,"billing_address":{"first_name":"Patricia","address1":"Ulrich-Röschstrasse 8","phone":null,"city":"Goldach","zip":"9403","province":null,"country":"Switzerland","last_name":"Schmidlin","address2":null,"company":null,"latitude":47.4743141,"longitude":9.467543,"name":"Patricia Schmidlin","country_code":"CH","province_code":null},"customer":{"id":10155345740114,"created_at":"2026-03-19T06:39:42+01:00","updated_at":"2026-06-18T15:14:03+02:00","first_name":"Schmidlin","last_name":"131210000","state":"enabled","note":null,"verified_email":true,"multipass_identifier":null,"tax_exempt":false,"email":"schmidlinpatricia@gmail.com","phone":"+41789030611","currency":"CHF","tax_exemptions":[],"admin_graphql_api_id":"gid:\/\/shopify\/Customer\/10155345740114","default_address":{"id":12420133126482,"customer_id":10155345740114,"first_name":"Patricia","last_name":"Schmidlin","company":null,"address1":"Ulrich-Röschstrasse 8","address2":null,"city":"Goldach","province":null,"country":"Switzerland","zip":"9403","phone":null,"name":"Patricia Schmidlin","province_code":null,"country_code":"CH","country_name":"Switzerland","default":true}},"discount_applications":[],"fulfillments":[{"id":7007050269010,"admin_graphql_api_id":"gid:\/\/shopify\/Fulfillment\/7007050269010","created_at":"2026-06-18T15:13:57+02:00","location_id":113214685522,"name":"#1510.1","order_id":8043305140562,"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:57+02:00","line_items":[{"id":18745039094098,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039094098","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Nuss-Schnecke 95G","price":"70.00","price_set":{"shop_money":{"amount":"70.00","currency_code":"CHF"},"presentment_money":{"amount":"70.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687786189138,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2107","taxable":true,"title":"Nuss-Schnecke 95G","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":53072735469906,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039126866,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039126866","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Nussgipfel 90G","price":"80.00","price_set":{"shop_money":{"amount":"80.00","currency_code":"CHF"},"presentment_money":{"amount":"80.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687786123602,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2106","taxable":true,"title":"Nussgipfel 90G","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":53072735207762,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039159634,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039159634","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Laugenschnecke Gefüllt Gala-Frischkäse","price":"132.00","price_set":{"shop_money":{"amount":"132.00","currency_code":"CHF"},"presentment_money":{"amount":"132.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687757386066,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1435","taxable":true,"title":"Laugenschnecke Gefüllt Gala-Frischkäse","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":53072656302418,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039192402,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039192402","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Laugenbrezel Gefüllt M.butter","price":"100.00","price_set":{"shop_money":{"amount":"100.00","currency_code":"CHF"},"presentment_money":{"amount":"100.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687757189458,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1434","taxable":true,"title":"Laugenbrezel Gefüllt M.butter","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":53072655843666,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039225170,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039225170","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Stimorol Infinity Spearmint","price":"32.00","price_set":{"shop_money":{"amount":"32.00","currency_code":"CHF"},"presentment_money":{"amount":"32.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687758500178,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1486","taxable":true,"title":"Stimorol Infinity Spearmint","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":53072658039122,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039257938,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039257938","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":1,"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":18745039290706,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039290706","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":18745039323474,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039323474","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Op1\/Nespresso Finezzo","price":"21.00","price_set":{"shop_money":{"amount":"21.00","currency_code":"CHF"},"presentment_money":{"amount":"21.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687902122322,"properties":[],"quantity":2,"requires_shipping":true,"sku":"3679","taxable":true,"title":"Op1\/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":53073135763794,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039356242,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039356242","attributed_staffs":[],"current_quantity":20,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Op1\/Nespresso Forte","price":"21.00","price_set":{"shop_money":{"amount":"21.00","currency_code":"CHF"},"presentment_money":{"amount":"21.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687902581074,"properties":[],"quantity":20,"requires_shipping":true,"sku":"3681","taxable":true,"title":"Op1\/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":53073137828178,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039389010,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039389010","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745039421778,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039421778","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Bohnencafé Chicco Doro Caffèrino","price":"221.00","price_set":{"shop_money":{"amount":"221.00","currency_code":"CHF"},"presentment_money":{"amount":"221.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687926468946,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3932","taxable":true,"title":"Bohnencafé Chicco Doro Caffèrino","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":53073266770258,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039454546,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039454546","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Maggi Rindsbouillon","price":"179.40","price_set":{"shop_money":{"amount":"179.40","currency_code":"CHF"},"presentment_money":{"amount":"179.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687848808786,"properties":[],"quantity":1,"requires_shipping":true,"sku":"4923","taxable":true,"title":"Maggi Rindsbouillon","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":53072978575698,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039487314,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039487314","attributed_staffs":[],"current_quantity":1,"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":1,"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":18745039520082,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039520082","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Valser Mineral Mit Kohlensauere","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":10687783567698,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2095","taxable":true,"title":"Valser Mineral Mit Kohlensauere","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":53072728326482,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039552850,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039552850","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Valser Mineral Naturelle","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":10687783338322,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2094","taxable":true,"title":"Valser Mineral Naturelle","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":53072727900498,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039585618,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039585618","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":18745039618386,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039618386","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745039651154,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039651154","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Red Bull Classic 25Cl Dose","price":"61.25","price_set":{"shop_money":{"amount":"61.25","currency_code":"CHF"},"presentment_money":{"amount":"61.25","currency_code":"CHF"}},"product_exists":true,"product_id":10687696732498,"properties":[],"quantity":1,"requires_shipping":true,"sku":"647","taxable":true,"title":"Red Bull Classic 25Cl Dose","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":53072457498962,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039683922,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039683922","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Henniez Mit Kohlensäure 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":10687905726802,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3691","taxable":true,"title":"Henniez Mit Kohlensäure 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":53073152213330,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039716690,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039716690","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":18745039749458,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039749458","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola Zero 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":10687913361746,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3776","taxable":true,"title":"Coca-Cola Zero 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":53073196253522,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}]}],"line_items":[{"id":18745039094098,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039094098","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Nuss-Schnecke 95G","price":"70.00","price_set":{"shop_money":{"amount":"70.00","currency_code":"CHF"},"presentment_money":{"amount":"70.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687786189138,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2107","taxable":true,"title":"Nuss-Schnecke 95G","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":53072735469906,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039126866,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039126866","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Nussgipfel 90G","price":"80.00","price_set":{"shop_money":{"amount":"80.00","currency_code":"CHF"},"presentment_money":{"amount":"80.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687786123602,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2106","taxable":true,"title":"Nussgipfel 90G","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":53072735207762,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039159634,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039159634","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Laugenschnecke Gefüllt Gala-Frischkäse","price":"132.00","price_set":{"shop_money":{"amount":"132.00","currency_code":"CHF"},"presentment_money":{"amount":"132.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687757386066,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1435","taxable":true,"title":"Laugenschnecke Gefüllt Gala-Frischkäse","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":53072656302418,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039192402,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039192402","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Laugenbrezel Gefüllt M.butter","price":"100.00","price_set":{"shop_money":{"amount":"100.00","currency_code":"CHF"},"presentment_money":{"amount":"100.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687757189458,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1434","taxable":true,"title":"Laugenbrezel Gefüllt M.butter","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":53072655843666,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039225170,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039225170","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Stimorol Infinity Spearmint","price":"32.00","price_set":{"shop_money":{"amount":"32.00","currency_code":"CHF"},"presentment_money":{"amount":"32.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687758500178,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1486","taxable":true,"title":"Stimorol Infinity Spearmint","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":53072658039122,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039257938,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039257938","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":1,"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":18745039290706,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039290706","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":18745039323474,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039323474","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Op1\/Nespresso Finezzo","price":"21.00","price_set":{"shop_money":{"amount":"21.00","currency_code":"CHF"},"presentment_money":{"amount":"21.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687902122322,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3679","taxable":true,"title":"Op1\/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":53073135763794,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039356242,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039356242","attributed_staffs":[],"current_quantity":20,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Op1\/Nespresso Forte","price":"21.00","price_set":{"shop_money":{"amount":"21.00","currency_code":"CHF"},"presentment_money":{"amount":"21.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687902581074,"properties":[],"quantity":20,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3681","taxable":true,"title":"Op1\/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":53073137828178,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039389010,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039389010","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745039421778,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039421778","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Bohnencafé Chicco Doro Caffèrino","price":"221.00","price_set":{"shop_money":{"amount":"221.00","currency_code":"CHF"},"presentment_money":{"amount":"221.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687926468946,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3932","taxable":true,"title":"Bohnencafé Chicco Doro Caffèrino","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":53073266770258,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039454546,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039454546","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Maggi Rindsbouillon","price":"179.40","price_set":{"shop_money":{"amount":"179.40","currency_code":"CHF"},"presentment_money":{"amount":"179.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687848808786,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"4923","taxable":true,"title":"Maggi Rindsbouillon","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":53072978575698,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039487314,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039487314","attributed_staffs":[],"current_quantity":1,"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":1,"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":18745039520082,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039520082","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Valser Mineral Mit Kohlensauere","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":10687783567698,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2095","taxable":true,"title":"Valser Mineral Mit Kohlensauere","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":53072728326482,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039552850,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039552850","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Valser Mineral Naturelle","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":10687783338322,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2094","taxable":true,"title":"Valser Mineral Naturelle","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":53072727900498,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039585618,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039585618","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":18745039618386,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039618386","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","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":18745039651154,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039651154","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Red Bull Classic 25Cl Dose","price":"61.25","price_set":{"shop_money":{"amount":"61.25","currency_code":"CHF"},"presentment_money":{"amount":"61.25","currency_code":"CHF"}},"product_exists":true,"product_id":10687696732498,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"647","taxable":true,"title":"Red Bull Classic 25Cl Dose","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":53072457498962,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039683922,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039683922","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Henniez Mit Kohlensäure 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":10687905726802,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3691","taxable":true,"title":"Henniez Mit Kohlensäure 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":53073152213330,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745039716690,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039716690","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":18745039749458,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745039749458","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola Zero 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":10687913361746,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3776","taxable":true,"title":"Coca-Cola Zero 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":53073196253522,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}],"payment_terms":null,"refunds":[],"shipping_address":null,"shipping_lines":[{"id":6259368886610,"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:41" ] |
|
1.65 ms (1.46%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1434' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.60 ms (1.41%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3776' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.38 ms (1.22%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2106' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.34 ms (1.19%) |
16 |
SELECT * FROM object_relations_product WHERE src_id = ?
Parameters:
[
18123
]
|
|
1.33 ms (1.18%) |
16 |
SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de','fr')
Parameters:
[
18123
]
|
|
1.30 ms (1.15%) |
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.28 ms (1.13%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3679' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.28 ms (1.13%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1435' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.20 ms (1.06%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3932' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.17 ms (1.04%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
|
1.14 ms (1.01%) |
2 |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
21945
]
|
|
1.12 ms (0.99%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2094' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.10 ms (0.98%) |
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.10 ms (0.97%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3681' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.04 ms (0.92%) |
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/" 21957 1781777971 1781795561 15 0 0 21945 "object" "1510" 0 null null "orders" 1 "Orders" 21957 ] |
|
1.04 ms (0.92%) |
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.03 ms (0.92%) |
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:
[] |
|
1.03 ms (0.91%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '647' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.98 ms (0.87%) |
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.95 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` = '348' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.95 ms (0.84%) |
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/" 21957 1781777971 1781795561 15 0 0 21945 "object" "1510" 0 null null "orders" 1 "Orders" ] |
|
0.90 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` = '1986' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.86 ms (0.76%) |
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.83 ms (0.73%) |
1 |
SELECT * FROM object_relations_orders WHERE src_id = ?
Parameters:
[
21957
]
|
|
0.81 ms (0.72%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1486' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.74 ms (0.66%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
|
0.68 ms (0.61%) |
1 |
DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 21957 "lineItems" ] |
|
0.66 ms (0.58%) |
1 |
DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 21957 "payload" ] |
|
0.62 ms (0.55%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21957')
Parameters:
[] |
|
0.61 ms (0.54%) |
1 |
SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 21957 "payload" ] |
|
0.61 ms (0.54%) |
1 |
SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21957' AND `fieldname` = 'payload' LIMIT 1
Parameters:
[] |
|
0.59 ms (0.52%) |
1 |
INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 21957 8043305140562.0 "1510" "paid" 1868.89 "CHF" "schmidlinpatricia@gmail.com" "2026-06-18 12:19:27" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1510",\n "ExternalOrderReference": "fa3d40f6-1fbc-43a2-9eca-9952397526c4",\n "ExternalOrderNumber": 510,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1868.89,\n "TotalAmountExcludingTax": 1868.89\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 70,\n "PerQuantityIncludingTax": 70,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 70,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2107,\n "Type": "A",\n "Name": "14157",\n "Description": "Nuss-Schnecke 95G"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 80,\n "PerQuantityIncludingTax": 80,\n "PositionTotalExcludingTax": 80,\n "PositionTotalIncludingTax": 80,\n "PerQuantityExcludingTaxRelevant": 80,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2106,\n "Type": "A",\n "Name": "14156",\n "Description": "Nussgipfel 90G"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 132,\n "PerQuantityIncludingTax": 132,\n "PositionTotalExcludingTax": 132,\n "PositionTotalIncludingTax": 132,\n "PerQuantityExcludingTaxRelevant": 132,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1435,\n "Type": "A",\n "Name": "13599",\n "Description": "Laugenschnecke Gefüllt Gala-Frischkäse"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 100,\n "PerQuantityIncludingTax": 100,\n "PositionTotalExcludingTax": 100,\n "PositionTotalIncludingTax": 100,\n "PerQuantityExcludingTaxRelevant": 100,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1434,\n "Type": "A",\n "Name": "13598",\n "Description": "Laugenbrezel Gefüllt M.butter"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 32,\n "PerQuantityIncludingTax": 32,\n "PositionTotalExcludingTax": 32,\n "PositionTotalIncludingTax": 32,\n "PerQuantityExcludingTaxRelevant": 32,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1486,\n "Type": "A",\n "Name": "13661",\n "Description": "Stimorol Infinity Spearmint"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 20,\n "PositionTotalIncludingTax": 20,\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": 7,\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": 8,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3679,\n "Type": "A",\n "Name": "17476",\n "Description": "Op1\/Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 20,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 420,\n "PositionTotalIncludingTax": 420,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3681,\n "Type": "A",\n "Name": "17478",\n "Description": "Op1\/Nespresso Forte"\n }\n },\n {\n "LineItemId": 10,\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": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 221,\n "PerQuantityIncludingTax": 221,\n "PositionTotalExcludingTax": 221,\n "PositionTotalIncludingTax": 221,\n "PerQuantityExcludingTaxRelevant": 221,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3932,\n "Type": "A",\n "Name": "11983",\n "Description": "Bohnencafé Chicco Doro Caffèrino"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179.4,\n "PerQuantityIncludingTax": 179.4,\n "PositionTotalExcludingTax": 179.4,\n "PositionTotalIncludingTax": 179.4,\n "PerQuantityExcludingTaxRelevant": 179.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4923,\n "Type": "A",\n "Name": "12758",\n "Description": "Maggi Rindsbouillon"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\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": 14,\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": 2095,\n "Type": "A",\n "Name": "14150",\n "Description": "Valser Mineral Mit Kohlensauere"\n }\n },\n {\n "LineItemId": 15,\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": 2094,\n "Type": "A",\n "Name": "14149",\n "Description": "Valser Mineral Naturelle"\n }\n },\n {\n "LineItemId": 16,\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": 17,\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": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 61.25,\n "PerQuantityIncludingTax": 61.25,\n "PositionTotalExcludingTax": 61.25,\n "PositionTotalIncludingTax": 61.25,\n "PerQuantityExcludingTaxRelevant": 61.25,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 647,\n "Type": "A",\n "Name": "12331",\n "Description": "Red Bull Classic 25Cl Dose"\n }\n },\n {\n "LineItemId": 19,\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": 3691,\n "Type": "A",\n "Name": "17492",\n "Description": "Henniez Mit Kohlensäure 5Dl Pet"\n }\n },\n {\n "LineItemId": 20,\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": 21,\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": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "cb663647-df7a-4d7a-2bab-23abb57f0ca9",\n "Account": "Schmidlin"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\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.58 ms (0.52%) |
1 |
SHOW COLUMNS FROM object_store_orders
Parameters:
[] |
|
0.56 ms (0.50%) |
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:
[ 21957 8043305140562.0 "1510" "paid" 1868.89 "CHF" "schmidlinpatricia@gmail.com" "2026-06-18 12:19:27" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1510",\n "ExternalOrderReference": "fa3d40f6-1fbc-43a2-9eca-9952397526c4",\n "ExternalOrderNumber": 510,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1868.89,\n "TotalAmountExcludingTax": 1868.89\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 70,\n "PerQuantityIncludingTax": 70,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 70,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2107,\n "Type": "A",\n "Name": "14157",\n "Description": "Nuss-Schnecke 95G"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 80,\n "PerQuantityIncludingTax": 80,\n "PositionTotalExcludingTax": 80,\n "PositionTotalIncludingTax": 80,\n "PerQuantityExcludingTaxRelevant": 80,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2106,\n "Type": "A",\n "Name": "14156",\n "Description": "Nussgipfel 90G"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 132,\n "PerQuantityIncludingTax": 132,\n "PositionTotalExcludingTax": 132,\n "PositionTotalIncludingTax": 132,\n "PerQuantityExcludingTaxRelevant": 132,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1435,\n "Type": "A",\n "Name": "13599",\n "Description": "Laugenschnecke Gefüllt Gala-Frischkäse"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 100,\n "PerQuantityIncludingTax": 100,\n "PositionTotalExcludingTax": 100,\n "PositionTotalIncludingTax": 100,\n "PerQuantityExcludingTaxRelevant": 100,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1434,\n "Type": "A",\n "Name": "13598",\n "Description": "Laugenbrezel Gefüllt M.butter"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 32,\n "PerQuantityIncludingTax": 32,\n "PositionTotalExcludingTax": 32,\n "PositionTotalIncludingTax": 32,\n "PerQuantityExcludingTaxRelevant": 32,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1486,\n "Type": "A",\n "Name": "13661",\n "Description": "Stimorol Infinity Spearmint"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 20,\n "PositionTotalIncludingTax": 20,\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": 7,\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": 8,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3679,\n "Type": "A",\n "Name": "17476",\n "Description": "Op1\/Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 20,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 420,\n "PositionTotalIncludingTax": 420,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3681,\n "Type": "A",\n "Name": "17478",\n "Description": "Op1\/Nespresso Forte"\n }\n },\n {\n "LineItemId": 10,\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": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 221,\n "PerQuantityIncludingTax": 221,\n "PositionTotalExcludingTax": 221,\n "PositionTotalIncludingTax": 221,\n "PerQuantityExcludingTaxRelevant": 221,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3932,\n "Type": "A",\n "Name": "11983",\n "Description": "Bohnencafé Chicco Doro Caffèrino"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179.4,\n "PerQuantityIncludingTax": 179.4,\n "PositionTotalExcludingTax": 179.4,\n "PositionTotalIncludingTax": 179.4,\n "PerQuantityExcludingTaxRelevant": 179.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4923,\n "Type": "A",\n "Name": "12758",\n "Description": "Maggi Rindsbouillon"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\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": 14,\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": 2095,\n "Type": "A",\n "Name": "14150",\n "Description": "Valser Mineral Mit Kohlensauere"\n }\n },\n {\n "LineItemId": 15,\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": 2094,\n "Type": "A",\n "Name": "14149",\n "Description": "Valser Mineral Naturelle"\n }\n },\n {\n "LineItemId": 16,\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": 17,\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": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 61.25,\n "PerQuantityIncludingTax": 61.25,\n "PositionTotalExcludingTax": 61.25,\n "PositionTotalIncludingTax": 61.25,\n "PerQuantityExcludingTaxRelevant": 61.25,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 647,\n "Type": "A",\n "Name": "12331",\n "Description": "Red Bull Classic 25Cl Dose"\n }\n },\n {\n "LineItemId": 19,\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": 3691,\n "Type": "A",\n "Name": "17492",\n "Description": "Henniez Mit Kohlensäure 5Dl Pet"\n }\n },\n {\n "LineItemId": 20,\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": 21,\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": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "cb663647-df7a-4d7a-2bab-23abb57f0ca9",\n "Account": "Schmidlin"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\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 } """ 21957 ] |
|
0.56 ms (0.50%) |
1 |
INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 8043305140562.0 "1510" "paid" 1868.89 "CHF" "schmidlinpatricia@gmail.com" "2026-06-18 12:19:27" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1510",\n "ExternalOrderReference": "fa3d40f6-1fbc-43a2-9eca-9952397526c4",\n "ExternalOrderNumber": 510,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1868.89,\n "TotalAmountExcludingTax": 1868.89\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 70,\n "PerQuantityIncludingTax": 70,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 70,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2107,\n "Type": "A",\n "Name": "14157",\n "Description": "Nuss-Schnecke 95G"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 80,\n "PerQuantityIncludingTax": 80,\n "PositionTotalExcludingTax": 80,\n "PositionTotalIncludingTax": 80,\n "PerQuantityExcludingTaxRelevant": 80,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2106,\n "Type": "A",\n "Name": "14156",\n "Description": "Nussgipfel 90G"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 132,\n "PerQuantityIncludingTax": 132,\n "PositionTotalExcludingTax": 132,\n "PositionTotalIncludingTax": 132,\n "PerQuantityExcludingTaxRelevant": 132,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1435,\n "Type": "A",\n "Name": "13599",\n "Description": "Laugenschnecke Gefüllt Gala-Frischkäse"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 100,\n "PerQuantityIncludingTax": 100,\n "PositionTotalExcludingTax": 100,\n "PositionTotalIncludingTax": 100,\n "PerQuantityExcludingTaxRelevant": 100,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1434,\n "Type": "A",\n "Name": "13598",\n "Description": "Laugenbrezel Gefüllt M.butter"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 32,\n "PerQuantityIncludingTax": 32,\n "PositionTotalExcludingTax": 32,\n "PositionTotalIncludingTax": 32,\n "PerQuantityExcludingTaxRelevant": 32,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1486,\n "Type": "A",\n "Name": "13661",\n "Description": "Stimorol Infinity Spearmint"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 20,\n "PositionTotalIncludingTax": 20,\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": 7,\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": 8,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3679,\n "Type": "A",\n "Name": "17476",\n "Description": "Op1\/Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 20,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 420,\n "PositionTotalIncludingTax": 420,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3681,\n "Type": "A",\n "Name": "17478",\n "Description": "Op1\/Nespresso Forte"\n }\n },\n {\n "LineItemId": 10,\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": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 221,\n "PerQuantityIncludingTax": 221,\n "PositionTotalExcludingTax": 221,\n "PositionTotalIncludingTax": 221,\n "PerQuantityExcludingTaxRelevant": 221,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3932,\n "Type": "A",\n "Name": "11983",\n "Description": "Bohnencafé Chicco Doro Caffèrino"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179.4,\n "PerQuantityIncludingTax": 179.4,\n "PositionTotalExcludingTax": 179.4,\n "PositionTotalIncludingTax": 179.4,\n "PerQuantityExcludingTaxRelevant": 179.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4923,\n "Type": "A",\n "Name": "12758",\n "Description": "Maggi Rindsbouillon"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\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": 14,\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": 2095,\n "Type": "A",\n "Name": "14150",\n "Description": "Valser Mineral Mit Kohlensauere"\n }\n },\n {\n "LineItemId": 15,\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": 2094,\n "Type": "A",\n "Name": "14149",\n "Description": "Valser Mineral Naturelle"\n }\n },\n {\n "LineItemId": 16,\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": 17,\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": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 61.25,\n "PerQuantityIncludingTax": 61.25,\n "PositionTotalExcludingTax": 61.25,\n "PositionTotalIncludingTax": 61.25,\n "PerQuantityExcludingTaxRelevant": 61.25,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 647,\n "Type": "A",\n "Name": "12331",\n "Description": "Red Bull Classic 25Cl Dose"\n }\n },\n {\n "LineItemId": 19,\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": 3691,\n "Type": "A",\n "Name": "17492",\n "Description": "Henniez Mit Kohlensäure 5Dl Pet"\n }\n },\n {\n "LineItemId": 20,\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": 21,\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": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "cb663647-df7a-4d7a-2bab-23abb57f0ca9",\n "Account": "Schmidlin"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\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 } """ 21957 ] |
|
0.55 ms (0.49%) |
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:
[ 8043305140562.0 "1510" "paid" 1868.89 "CHF" "schmidlinpatricia@gmail.com" "2026-06-18 12:19:27" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1510",\n "ExternalOrderReference": "fa3d40f6-1fbc-43a2-9eca-9952397526c4",\n "ExternalOrderNumber": 510,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1868.89,\n "TotalAmountExcludingTax": 1868.89\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 70,\n "PerQuantityIncludingTax": 70,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 70,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2107,\n "Type": "A",\n "Name": "14157",\n "Description": "Nuss-Schnecke 95G"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 80,\n "PerQuantityIncludingTax": 80,\n "PositionTotalExcludingTax": 80,\n "PositionTotalIncludingTax": 80,\n "PerQuantityExcludingTaxRelevant": 80,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2106,\n "Type": "A",\n "Name": "14156",\n "Description": "Nussgipfel 90G"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 132,\n "PerQuantityIncludingTax": 132,\n "PositionTotalExcludingTax": 132,\n "PositionTotalIncludingTax": 132,\n "PerQuantityExcludingTaxRelevant": 132,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1435,\n "Type": "A",\n "Name": "13599",\n "Description": "Laugenschnecke Gefüllt Gala-Frischkäse"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 100,\n "PerQuantityIncludingTax": 100,\n "PositionTotalExcludingTax": 100,\n "PositionTotalIncludingTax": 100,\n "PerQuantityExcludingTaxRelevant": 100,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1434,\n "Type": "A",\n "Name": "13598",\n "Description": "Laugenbrezel Gefüllt M.butter"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 32,\n "PerQuantityIncludingTax": 32,\n "PositionTotalExcludingTax": 32,\n "PositionTotalIncludingTax": 32,\n "PerQuantityExcludingTaxRelevant": 32,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1486,\n "Type": "A",\n "Name": "13661",\n "Description": "Stimorol Infinity Spearmint"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 20,\n "PositionTotalIncludingTax": 20,\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": 7,\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": 8,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 42,\n "PositionTotalIncludingTax": 42,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3679,\n "Type": "A",\n "Name": "17476",\n "Description": "Op1\/Nespresso Finezzo"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 20,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21,\n "PerQuantityIncludingTax": 21,\n "PositionTotalExcludingTax": 420,\n "PositionTotalIncludingTax": 420,\n "PerQuantityExcludingTaxRelevant": 21,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3681,\n "Type": "A",\n "Name": "17478",\n "Description": "Op1\/Nespresso Forte"\n }\n },\n {\n "LineItemId": 10,\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": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 221,\n "PerQuantityIncludingTax": 221,\n "PositionTotalExcludingTax": 221,\n "PositionTotalIncludingTax": 221,\n "PerQuantityExcludingTaxRelevant": 221,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3932,\n "Type": "A",\n "Name": "11983",\n "Description": "Bohnencafé Chicco Doro Caffèrino"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179.4,\n "PerQuantityIncludingTax": 179.4,\n "PositionTotalExcludingTax": 179.4,\n "PositionTotalIncludingTax": 179.4,\n "PerQuantityExcludingTaxRelevant": 179.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4923,\n "Type": "A",\n "Name": "12758",\n "Description": "Maggi Rindsbouillon"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\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": 14,\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": 2095,\n "Type": "A",\n "Name": "14150",\n "Description": "Valser Mineral Mit Kohlensauere"\n }\n },\n {\n "LineItemId": 15,\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": 2094,\n "Type": "A",\n "Name": "14149",\n "Description": "Valser Mineral Naturelle"\n }\n },\n {\n "LineItemId": 16,\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": 17,\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": 18,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 61.25,\n "PerQuantityIncludingTax": 61.25,\n "PositionTotalExcludingTax": 61.25,\n "PositionTotalIncludingTax": 61.25,\n "PerQuantityExcludingTaxRelevant": 61.25,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 647,\n "Type": "A",\n "Name": "12331",\n "Description": "Red Bull Classic 25Cl Dose"\n }\n },\n {\n "LineItemId": 19,\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": 3691,\n "Type": "A",\n "Name": "17492",\n "Description": "Henniez Mit Kohlensäure 5Dl Pet"\n }\n },\n {\n "LineItemId": 20,\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": 21,\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": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "cb663647-df7a-4d7a-2bab-23abb57f0ca9",\n "Account": "Schmidlin"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Patricia",\n "Name": "Schmidlin",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n }\n },\n "Address": {\n "Street": "Ulrich-Röschstrasse",\n "HouseNumber": "8",\n "PostCode": "9403",\n "City": "Goldach",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "schmidlinpatricia@gmail.com"\n },\n "Id": 870704\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 } """ 21957 21957 ] |
|
0.49 ms (0.43%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.44 ms (0.39%) |
1 |
SHOW COLUMNS FROM object_query_orders
Parameters:
[] |
|
0.41 ms (0.36%) |
5 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/webhook/shopify/leomat/" "order" ] |
|
0.39 ms (0.35%) |
1 |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 21957 "object" 0 "" 1781795561 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" ] |
|
0.39 ms (0.34%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
21957
]
|
|
0.32 ms (0.28%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Orders/Leomat/2026/06/18/" "1510" ] |
|
0.30 ms (0.27%) |
2 |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"orders"
]
|
|
0.30 ms (0.26%) |
1 |
SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE
Parameters:
[
21957
]
|
|
0.28 ms (0.25%) |
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:21957;}}" "[]" "pimcore_search_backend_message" "2026-06-18 15:12:42" "2026-06-18 15:12:42" ] |
|
0.25 ms (0.22%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/webhook/shopify/leomat/order"
]
|
|
0.23 ms (0.21%) |
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:
[ 1781795561 "object_17947\x01tags\x01" "class_product\x01tags\x01" "asset_196\x01tags\x01" "asset_197\x01tags\x01" "asset_198\x01tags\x01" ] |
|
0.22 ms (0.19%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
21957
]
|
|
0.20 ms (0.17%) |
1 |
SELECT * FROM object_query_orders WHERE oo_id = ?
Parameters:
[
21957
]
|
|
0.19 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:
[ 1781795561 "object_17957\x01tags\x01" "class_product\x01tags\x01" "asset_218\x01tags\x01" "asset_219\x01tags\x01" "asset_220\x01tags\x01" "asset_221\x01tags\x01" ] |
|
0.19 ms (0.17%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.19 ms (0.17%) |
1 |
SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21957' AND `fieldname` = 'lineItems' LIMIT 1
Parameters:
[] |
|
0.18 ms (0.16%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_21957\x01tags\x01" "object_properties\x01tags\x01" ] |
|
0.16 ms (0.14%) |
1 |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
21957
]
|
|
0.14 ms (0.13%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 21957 "object" ] |
|
0.13 ms (0.12%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
|
0.11 ms (0.10%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = 21957 AND `ctype` = 'object'
Parameters:
[] |
|
0.11 ms (0.10%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 21957 ] |
|
0.11 ms (0.10%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21957')
Parameters:
[] |
|
0.11 ms (0.10%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21957')
Parameters:
[] |
|
0.11 ms (0.09%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21957')
Parameters:
[] |
|
0.10 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
|
0.07 ms (0.06%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 21957 "object" ] |
|
0.07 ms (0.06%) |
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:
[
21957
]
|
|
0.06 ms (0.06%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
|
0.06 ms (0.05%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
|
0.05 ms (0.04%) |
1 |
SELECT * FROM users_workspaces_document 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.