Symfony Profiler

Query Metrics

318 Database Queries

75 Different statements

99.15 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Time▼	Count	Info
21.13 ms (21.31%)	75	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: [`1781795563 "site_domain_367af465ca304630cf45a2132778bed1"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781795563 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_367af465ca304630cf45a2132778bed1');
5.95 ms (6.00%)	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: [`8043312087378`] View formatted query View runnable query Explain query SELECT object_orders.id as id, object_orders.type as `type` FROM object_orders WHERE ( orderId = ? AND object_orders.type IN ('object', 'variant', 'folder') ) AND object_orders.published = 1 SELECT object_orders.id as id, object_orders.type as `type` FROM object_orders WHERE (orderId = 8043312087378 AND object_orders.type IN ('object','variant','folder')) AND object_orders.published = 1;
4.66 ms (4.70%)	15	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: [`1781795563 "object_17216\x01tags\x01" "class_product\x01tags\x01" "asset_3012\x01tags\x01" "asset_516\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781795563 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_17216tags', 'class_producttags', 'asset_3012tags', 'asset_516tags');
3.99 ms (4.02%)	14	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`21958`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 21958;
3.61 ms (3.64%)	30	INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`17216 "object" "product" 21958 "fieldcollection" "lineItems" "0"`] View formatted query View runnable query Explain query INSERT INTO object_relations_orders ( `dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position` ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (17216, 'object', 'product', 21958, 'fieldcollection', 'lineItems', '0');
3.54 ms (3.57%)	14	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: [`21958`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 21958;
2.80 ms (2.82%)	13	SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE Parameters: [`17963`] View formatted query View runnable query Explain query SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_product WHERE oo_id = 17963 FOR UPDATE;
2.43 ms (2.45%)	8	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1781795563 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1781795563 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
2.30 ms (2.32%)	30	SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE (shopifyVendorId = ? OR name = ? AND object_vendor.type IN ('object','variant','folder')) AND object_vendor.published = 1 Parameters: [`"Leomat" "Leomat"`] View formatted query View runnable query Explain query SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE ( shopifyVendorId = ? OR name = ? AND object_vendor.type IN ('object', 'variant', 'folder') ) AND object_vendor.published = 1 SELECT object_vendor.id as id, object_vendor.type as `type` FROM object_vendor WHERE (shopifyVendorId = 'Leomat' OR name = 'Leomat' AND object_vendor.type IN ('object','variant','folder')) AND object_vendor.published = 1;
2.28 ms (2.30%)	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: [] View formatted query View runnable query Explain query 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 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;
2.22 ms (2.24%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3945' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '3945' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3945' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
2.15 ms (2.17%)	2	INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (?, ?, ?, ?, ?, ?) Parameters: [21958 0 "payload" "{"id":8043312087378,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/8043312087378","app_id":580111,"browser_ip":"194.230.161.125","buyer_accepts_marketing":false,"cancel_reason":null,"cancelled_at":null,"cart_token":"hWNDThLxyfJXEHk1hypDArZL","checkout_id":48585556492626,"checkout_token":"46c901841ea9496906d66a8780a25e42","client_details":{"accept_language":"de-CH","browser_height":null,"browser_ip":"194.230.161.125","browser_width":null,"session_hash":null,"user_agent":"Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Mobile Safari\/537.36"},"closed_at":"2026-06-18T13:14:16+02:00","company":null,"confirmation_number":"4CM57A0IF","confirmed":true,"contact_email":"ruhland.josephine@hotmail.com","created_at":"2026-06-18T12:21:48+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":"1177.41","current_subtotal_price_set":{"shop_money":{"amount":"1177.41","currency_code":"CHF"},"presentment_money":{"amount":"1177.41","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":"1177.41","current_total_price_set":{"shop_money":{"amount":"1177.41","currency_code":"CHF"},"presentment_money":{"amount":"1177.41","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":"ruhland.josephine@hotmail.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":"#1511","note":"Tour 13","note_attributes":[],"number":511,"order_number":1511,"order_status_url":"https:\/\/shop.myleomat.ch\/99699687762\/orders\/fca8e59ef15306aeceeae1c5e0603bad\/authenticate?key=b0eda9c17b3b67b0857167104175f3f2","original_total_additional_fees_set":null,"original_total_duties_set":null,"payment_gateway_names":["Barzahlung (NUR BEI ABHOLUNG)"],"phone":null,"po_number":null,"presentment_currency":"CHF","processed_at":"2026-06-18T12:21:47+02:00","reference":null,"referring_site":null,"source_identifier":null,"source_name":"web","source_url":null,"subtotal_price":"1177.41","subtotal_price_set":{"shop_money":{"amount":"1177.41","currency_code":"CHF"},"presentment_money":{"amount":"1177.41","currency_code":"CHF"}},"tags":"leomat-erp-status:processed","tax_exempt":false,"tax_lines":[],"taxes_included":true,"test":false,"token":"fca8e59ef15306aeceeae1c5e0603bad","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":"1177.41","total_line_items_price_set":{"shop_money":{"amount":"1177.41","currency_code":"CHF"},"presentment_money":{"amount":"1177.41","currency_code":"CHF"}},"total_outstanding":"0.00","total_price":"1177.41","total_price_set":{"shop_money":{"amount":"1177.41","currency_code":"CHF"},"presentment_money":{"amount":"1177.41","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:41+02:00","user_id":null,"billing_address":{"first_name":"Josephine","address1":"Buhofstrasse 54a","phone":null,"city":"Rheineck","zip":"9424","province":null,"country":"Switzerland","last_name":"Ruhland","address2":null,"company":null,"latitude":47.4697399,"longitude":9.5771564,"name":"Josephine Ruhland","country_code":"CH","province_code":null},"customer":{"id":10155383390546,"created_at":"2026-03-19T06:49:40+01:00","updated_at":"2026-06-18T13:14:19+02:00","first_name":null,"last_name":"2026540000","state":"enabled","note":null,"verified_email":true,"multipass_identifier":null,"tax_exempt":false,"email":"ruhland.josephine@hotmail.com","phone":null,"currency":"CHF","tax_exemptions":[],"admin_graphql_api_id":"gid:\/\/shopify\/Customer\/10155383390546","default_address":{"id":12417817313618,"customer_id":10155383390546,"first_name":"Josephine","last_name":"Ruhland","company":null,"address1":"Buhofstrasse 54a","address2":null,"city":"Rheineck","province":null,"country":"Switzerland","zip":"9424","phone":null,"name":"Josephine Ruhland","province_code":null,"country_code":"CH","country_name":"Switzerland","default":true}},"discount_applications":[],"fulfillments":[{"id":7006505369938,"admin_graphql_api_id":"gid:\/\/shopify\/Fulfillment\/7006505369938","created_at":"2026-06-18T13:14:15+02:00","location_id":113214685522,"name":"#1511.1","order_id":8043312087378,"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-18T13:14:15+02:00","line_items":[{"id":18745054855506,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054855506","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Leomat Café-Creamer Rahmig","price":"93.60","price_set":{"shop_money":{"amount":"93.60","currency_code":"CHF"},"presentment_money":{"amount":"93.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687776293202,"properties":[],"quantity":2,"requires_shipping":true,"sku":"1986","taxable":true,"title":"Leomat Café-Creamer Rahmig","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072702308690,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054888274,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054888274","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Barone Leomat Premium Bohnenkaffee","price":"234.00","price_set":{"shop_money":{"amount":"234.00","currency_code":"CHF"},"presentment_money":{"amount":"234.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687698469202,"properties":[],"quantity":2,"requires_shipping":true,"sku":"819","taxable":true,"title":"Barone Leomat Premium Bohnenkaffee","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072461627730,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054921042,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054921042","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Automatenzucker (Vending)","price":"27.50","price_set":{"shop_money":{"amount":"27.50","currency_code":"CHF"},"presentment_money":{"amount":"27.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687848907090,"properties":[],"quantity":1,"requires_shipping":true,"sku":"4925","taxable":true,"title":"Automatenzucker (Vending)","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072978739538,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054953810,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054953810","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Bio Sambuco Holunder 5Dl Pet","price":"20.40","price_set":{"shop_money":{"amount":"20.40","currency_code":"CHF"},"presentment_money":{"amount":"20.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687759188306,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1510","taxable":true,"title":"Bio Sambuco Holunder 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":53072659022162,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054986578,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054986578","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Granini Fruchtcocktail 33Cl Pet","price":"53.76","price_set":{"shop_money":{"amount":"53.76","currency_code":"CHF"},"presentment_money":{"amount":"53.76","currency_code":"CHF"}},"product_exists":true,"product_id":10687771214162,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1862","taxable":true,"title":"Granini Fruchtcocktail 33Cl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072681566546,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055019346,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055019346","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Rivella Rot 5Dl Pet","price":"48.95","price_set":{"shop_money":{"amount":"48.95","currency_code":"CHF"},"presentment_money":{"amount":"48.95","currency_code":"CHF"}},"product_exists":true,"product_id":10687684706642,"properties":[],"quantity":1,"requires_shipping":true,"sku":"211","taxable":true,"title":"Rivella Rot 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":53072421978450,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055052114,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055052114","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":[]},{"id":18745055084882,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055084882","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola Mezzo Mix 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687913066834,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3775","taxable":true,"title":"Coca-Cola Mezzo Mix 5Dl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073194484050,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055117650,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055117650","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687912771922,"properties":[],"quantity":2,"requires_shipping":true,"sku":"3774","taxable":true,"title":"Coca-Cola 5Dl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073191960914,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055150418,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055150418","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Twix Knusperkeks 2X25G","price":"44.00","price_set":{"shop_money":{"amount":"44.00","currency_code":"CHF"},"presentment_money":{"amount":"44.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687680708946,"properties":[],"quantity":1,"requires_shipping":true,"sku":"23","taxable":true,"title":"Twix Knusperkeks 2X25G","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":53072414441810,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055183186,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055183186","attributed_staffs":[],"current_quantity":2,"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":2,"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":18745055215954,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055215954","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Fini Pica Jungle Ropes Erdbeer","price":"21.10","price_set":{"shop_money":{"amount":"21.10","currency_code":"CHF"},"presentment_money":{"amount":"21.10","currency_code":"CHF"}},"product_exists":true,"product_id":10687756894546,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1410","taxable":true,"title":"Fini Pica Jungle Ropes Erdbeer","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072655548754,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055248722,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055248722","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Pfaffenhut Bisquits","price":"18.00","price_set":{"shop_money":{"amount":"18.00","currency_code":"CHF"},"presentment_money":{"amount":"18.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687701614930,"properties":[],"quantity":2,"requires_shipping":true,"sku":"1013","taxable":true,"title":"Pfaffenhut Bisquits","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":53072469852498,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055281490,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055281490","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Snickers","price":"42.40","price_set":{"shop_money":{"amount":"42.40","currency_code":"CHF"},"presentment_money":{"amount":"42.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687697879378,"properties":[],"quantity":1,"requires_shipping":true,"sku":"769","taxable":true,"title":"Snickers","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":53072459432274,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055314258,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055314258","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kit Kat Choco Waffel","price":"34.50","price_set":{"shop_money":{"amount":"34.50","currency_code":"CHF"},"presentment_money":{"amount":"34.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687926632786,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3945","taxable":true,"title":"Kit Kat Choco Waffel","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073266999634,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}]}],"line_items":[{"id":18745054855506,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054855506","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Leomat Café-Creamer Rahmig","price":"93.60","price_set":{"shop_money":{"amount":"93.60","currency_code":"CHF"},"presentment_money":{"amount":"93.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687776293202,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1986","taxable":true,"title":"Leomat Café-Creamer Rahmig","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072702308690,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054888274,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054888274","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Barone Leomat Premium Bohnenkaffee","price":"234.00","price_set":{"shop_money":{"amount":"234.00","currency_code":"CHF"},"presentment_money":{"amount":"234.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687698469202,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"819","taxable":true,"title":"Barone Leomat Premium Bohnenkaffee","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072461627730,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054921042,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054921042","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Automatenzucker (Vending)","price":"27.50","price_set":{"shop_money":{"amount":"27.50","currency_code":"CHF"},"presentment_money":{"amount":"27.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687848907090,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"4925","taxable":true,"title":"Automatenzucker (Vending)","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072978739538,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054953810,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054953810","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Bio Sambuco Holunder 5Dl Pet","price":"20.40","price_set":{"shop_money":{"amount":"20.40","currency_code":"CHF"},"presentment_money":{"amount":"20.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687759188306,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1510","taxable":true,"title":"Bio Sambuco Holunder 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":53072659022162,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745054986578,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745054986578","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Granini Fruchtcocktail 33Cl Pet","price":"53.76","price_set":{"shop_money":{"amount":"53.76","currency_code":"CHF"},"presentment_money":{"amount":"53.76","currency_code":"CHF"}},"product_exists":true,"product_id":10687771214162,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1862","taxable":true,"title":"Granini Fruchtcocktail 33Cl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072681566546,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055019346,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055019346","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Rivella Rot 5Dl Pet","price":"48.95","price_set":{"shop_money":{"amount":"48.95","currency_code":"CHF"},"presentment_money":{"amount":"48.95","currency_code":"CHF"}},"product_exists":true,"product_id":10687684706642,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"211","taxable":true,"title":"Rivella Rot 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":53072421978450,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055052114,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055052114","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":[]},{"id":18745055084882,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055084882","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola Mezzo Mix 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687913066834,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3775","taxable":true,"title":"Coca-Cola Mezzo Mix 5Dl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073194484050,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055117650,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055117650","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687912771922,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3774","taxable":true,"title":"Coca-Cola 5Dl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073191960914,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055150418,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055150418","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Twix Knusperkeks 2X25G","price":"44.00","price_set":{"shop_money":{"amount":"44.00","currency_code":"CHF"},"presentment_money":{"amount":"44.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687680708946,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"23","taxable":true,"title":"Twix Knusperkeks 2X25G","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":53072414441810,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055183186,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055183186","attributed_staffs":[],"current_quantity":2,"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":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"348","taxable":true,"title":"Linzertörtli 75G","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072429482322,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055215954,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055215954","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Fini Pica Jungle Ropes Erdbeer","price":"21.10","price_set":{"shop_money":{"amount":"21.10","currency_code":"CHF"},"presentment_money":{"amount":"21.10","currency_code":"CHF"}},"product_exists":true,"product_id":10687756894546,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1410","taxable":true,"title":"Fini Pica Jungle Ropes Erdbeer","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072655548754,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055248722,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055248722","attributed_staffs":[],"current_quantity":2,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Pfaffenhut Bisquits","price":"18.00","price_set":{"shop_money":{"amount":"18.00","currency_code":"CHF"},"presentment_money":{"amount":"18.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687701614930,"properties":[],"quantity":2,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1013","taxable":true,"title":"Pfaffenhut Bisquits","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":53072469852498,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055281490,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055281490","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Snickers","price":"42.40","price_set":{"shop_money":{"amount":"42.40","currency_code":"CHF"},"presentment_money":{"amount":"42.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687697879378,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"769","taxable":true,"title":"Snickers","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":53072459432274,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745055314258,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745055314258","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kit Kat Choco Waffel","price":"34.50","price_set":{"shop_money":{"amount":"34.50","currency_code":"CHF"},"presentment_money":{"amount":"34.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687926632786,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3945","taxable":true,"title":"Kit Kat Choco Waffel","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073266999634,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}],"payment_terms":null,"refunds":[],"shipping_address":null,"shipping_lines":[{"id":6259374621010,"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:43"] View formatted query View runnable query Explain query INSERT INTO object_collection_ShopifyPayload_orders ( `id`, `index`, `fieldname`, `payload`, `topic`, `createdAt` ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (21958, 0, 'payload', '{\"id\":8043312087378,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Order\\/8043312087378\",\"app_id\":580111,\"browser_ip\":\"194.230.161.125\",\"buyer_accepts_marketing\":false,\"cancel_reason\":null,\"cancelled_at\":null,\"cart_token\":\"hWNDThLxyfJXEHk1hypDArZL\",\"checkout_id\":48585556492626,\"checkout_token\":\"46c901841ea9496906d66a8780a25e42\",\"client_details\":{\"accept_language\":\"de-CH\",\"browser_height\":null,\"browser_ip\":\"194.230.161.125\",\"browser_width\":null,\"session_hash\":null,\"user_agent\":\"Mozilla\\/5.0 (Linux; Android 10; K) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/149.0.0.0 Mobile Safari\\/537.36\"},\"closed_at\":\"2026-06-18T13:14:16+02:00\",\"company\":null,\"confirmation_number\":\"4CM57A0IF\",\"confirmed\":true,\"contact_email\":\"ruhland.josephine@hotmail.com\",\"created_at\":\"2026-06-18T12:21:48+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\":\"1177.41\",\"current_subtotal_price_set\":{\"shop_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"1177.41\",\"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\":\"1177.41\",\"current_total_price_set\":{\"shop_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"1177.41\",\"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\":\"ruhland.josephine@hotmail.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\":\"#1511\",\"note\":\"Tour 13\",\"note_attributes\":[],\"number\":511,\"order_number\":1511,\"order_status_url\":\"https:\\/\\/shop.myleomat.ch\\/99699687762\\/orders\\/fca8e59ef15306aeceeae1c5e0603bad\\/authenticate?key=b0eda9c17b3b67b0857167104175f3f2\",\"original_total_additional_fees_set\":null,\"original_total_duties_set\":null,\"payment_gateway_names\":[\"Barzahlung (NUR BEI ABHOLUNG)\"],\"phone\":null,\"po_number\":null,\"presentment_currency\":\"CHF\",\"processed_at\":\"2026-06-18T12:21:47+02:00\",\"reference\":null,\"referring_site\":null,\"source_identifier\":null,\"source_name\":\"web\",\"source_url\":null,\"subtotal_price\":\"1177.41\",\"subtotal_price_set\":{\"shop_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"}},\"tags\":\"leomat-erp-status:processed\",\"tax_exempt\":false,\"tax_lines\":[],\"taxes_included\":true,\"test\":false,\"token\":\"fca8e59ef15306aeceeae1c5e0603bad\",\"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\":\"1177.41\",\"total_line_items_price_set\":{\"shop_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"}},\"total_outstanding\":\"0.00\",\"total_price\":\"1177.41\",\"total_price_set\":{\"shop_money\":{\"amount\":\"1177.41\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"1177.41\",\"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:41+02:00\",\"user_id\":null,\"billing_address\":{\"first_name\":\"Josephine\",\"address1\":\"Buhofstrasse 54a\",\"phone\":null,\"city\":\"Rheineck\",\"zip\":\"9424\",\"province\":null,\"country\":\"Switzerland\",\"last_name\":\"Ruhland\",\"address2\":null,\"company\":null,\"latitude\":47.4697399,\"longitude\":9.5771564,\"name\":\"Josephine Ruhland\",\"country_code\":\"CH\",\"province_code\":null},\"customer\":{\"id\":10155383390546,\"created_at\":\"2026-03-19T06:49:40+01:00\",\"updated_at\":\"2026-06-18T13:14:19+02:00\",\"first_name\":null,\"last_name\":\"2026540000\",\"state\":\"enabled\",\"note\":null,\"verified_email\":true,\"multipass_identifier\":null,\"tax_exempt\":false,\"email\":\"ruhland.josephine@hotmail.com\",\"phone\":null,\"currency\":\"CHF\",\"tax_exemptions\":[],\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Customer\\/10155383390546\",\"default_address\":{\"id\":12417817313618,\"customer_id\":10155383390546,\"first_name\":\"Josephine\",\"last_name\":\"Ruhland\",\"company\":null,\"address1\":\"Buhofstrasse 54a\",\"address2\":null,\"city\":\"Rheineck\",\"province\":null,\"country\":\"Switzerland\",\"zip\":\"9424\",\"phone\":null,\"name\":\"Josephine Ruhland\",\"province_code\":null,\"country_code\":\"CH\",\"country_name\":\"Switzerland\",\"default\":true}},\"discount_applications\":[],\"fulfillments\":[{\"id\":7006505369938,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/Fulfillment\\/7006505369938\",\"created_at\":\"2026-06-18T13:14:15+02:00\",\"location_id\":113214685522,\"name\":\"#1511.1\",\"order_id\":8043312087378,\"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-18T13:14:15+02:00\",\"line_items\":[{\"id\":18745054855506,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054855506\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Leomat Café-Creamer Rahmig\",\"price\":\"93.60\",\"price_set\":{\"shop_money\":{\"amount\":\"93.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"93.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687776293202,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sku\":\"1986\",\"taxable\":true,\"title\":\"Leomat Café-Creamer Rahmig\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072702308690,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054888274,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054888274\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Barone Leomat Premium Bohnenkaffee\",\"price\":\"234.00\",\"price_set\":{\"shop_money\":{\"amount\":\"234.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"234.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687698469202,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sku\":\"819\",\"taxable\":true,\"title\":\"Barone Leomat Premium Bohnenkaffee\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072461627730,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054921042,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054921042\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Automatenzucker (Vending)\",\"price\":\"27.50\",\"price_set\":{\"shop_money\":{\"amount\":\"27.50\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"27.50\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687848907090,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"4925\",\"taxable\":true,\"title\":\"Automatenzucker (Vending)\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072978739538,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054953810,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054953810\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Bio Sambuco Holunder 5Dl Pet\",\"price\":\"20.40\",\"price_set\":{\"shop_money\":{\"amount\":\"20.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"20.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687759188306,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"1510\",\"taxable\":true,\"title\":\"Bio Sambuco Holunder 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\":53072659022162,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054986578,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054986578\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Granini Fruchtcocktail 33Cl Pet\",\"price\":\"53.76\",\"price_set\":{\"shop_money\":{\"amount\":\"53.76\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"53.76\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687771214162,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"1862\",\"taxable\":true,\"title\":\"Granini Fruchtcocktail 33Cl Pet\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072681566546,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055019346,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055019346\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Rivella Rot 5Dl Pet\",\"price\":\"48.95\",\"price_set\":{\"shop_money\":{\"amount\":\"48.95\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"48.95\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687684706642,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"211\",\"taxable\":true,\"title\":\"Rivella Rot 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\":53072421978450,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055052114,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055052114\",\"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\":[]},{\"id\":18745055084882,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055084882\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Coca-Cola Mezzo Mix 5Dl Pet\",\"price\":\"38.40\",\"price_set\":{\"shop_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687913066834,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"3775\",\"taxable\":true,\"title\":\"Coca-Cola Mezzo Mix 5Dl Pet\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53073194484050,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055117650,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055117650\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Coca-Cola 5Dl Pet\",\"price\":\"38.40\",\"price_set\":{\"shop_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687912771922,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sku\":\"3774\",\"taxable\":true,\"title\":\"Coca-Cola 5Dl Pet\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53073191960914,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055150418,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055150418\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Twix Knusperkeks 2X25G\",\"price\":\"44.00\",\"price_set\":{\"shop_money\":{\"amount\":\"44.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"44.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687680708946,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"23\",\"taxable\":true,\"title\":\"Twix Knusperkeks 2X25G\",\"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\":53072414441810,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055183186,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055183186\",\"attributed_staffs\":[],\"current_quantity\":2,\"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\":2,\"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\":18745055215954,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055215954\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Fini Pica Jungle Ropes Erdbeer\",\"price\":\"21.10\",\"price_set\":{\"shop_money\":{\"amount\":\"21.10\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"21.10\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687756894546,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"1410\",\"taxable\":true,\"title\":\"Fini Pica Jungle Ropes Erdbeer\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072655548754,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055248722,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055248722\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Pfaffenhut Bisquits\",\"price\":\"18.00\",\"price_set\":{\"shop_money\":{\"amount\":\"18.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"18.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687701614930,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sku\":\"1013\",\"taxable\":true,\"title\":\"Pfaffenhut Bisquits\",\"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\":53072469852498,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055281490,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055281490\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Snickers\",\"price\":\"42.40\",\"price_set\":{\"shop_money\":{\"amount\":\"42.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"42.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687697879378,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"769\",\"taxable\":true,\"title\":\"Snickers\",\"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\":53072459432274,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055314258,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055314258\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Kit Kat Choco Waffel\",\"price\":\"34.50\",\"price_set\":{\"shop_money\":{\"amount\":\"34.50\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"34.50\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687926632786,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sku\":\"3945\",\"taxable\":true,\"title\":\"Kit Kat Choco Waffel\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53073266999634,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}]}],\"line_items\":[{\"id\":18745054855506,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054855506\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Leomat Café-Creamer Rahmig\",\"price\":\"93.60\",\"price_set\":{\"shop_money\":{\"amount\":\"93.60\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"93.60\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687776293202,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"1986\",\"taxable\":true,\"title\":\"Leomat Café-Creamer Rahmig\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072702308690,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054888274,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054888274\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Barone Leomat Premium Bohnenkaffee\",\"price\":\"234.00\",\"price_set\":{\"shop_money\":{\"amount\":\"234.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"234.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687698469202,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"819\",\"taxable\":true,\"title\":\"Barone Leomat Premium Bohnenkaffee\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072461627730,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054921042,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054921042\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Automatenzucker (Vending)\",\"price\":\"27.50\",\"price_set\":{\"shop_money\":{\"amount\":\"27.50\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"27.50\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687848907090,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"4925\",\"taxable\":true,\"title\":\"Automatenzucker (Vending)\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072978739538,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054953810,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054953810\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Bio Sambuco Holunder 5Dl Pet\",\"price\":\"20.40\",\"price_set\":{\"shop_money\":{\"amount\":\"20.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"20.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687759188306,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"1510\",\"taxable\":true,\"title\":\"Bio Sambuco Holunder 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\":53072659022162,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745054986578,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745054986578\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Granini Fruchtcocktail 33Cl Pet\",\"price\":\"53.76\",\"price_set\":{\"shop_money\":{\"amount\":\"53.76\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"53.76\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687771214162,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"1862\",\"taxable\":true,\"title\":\"Granini Fruchtcocktail 33Cl Pet\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072681566546,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055019346,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055019346\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Rivella Rot 5Dl Pet\",\"price\":\"48.95\",\"price_set\":{\"shop_money\":{\"amount\":\"48.95\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"48.95\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687684706642,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"211\",\"taxable\":true,\"title\":\"Rivella Rot 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\":53072421978450,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055052114,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055052114\",\"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\":[]},{\"id\":18745055084882,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055084882\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Coca-Cola Mezzo Mix 5Dl Pet\",\"price\":\"38.40\",\"price_set\":{\"shop_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687913066834,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"3775\",\"taxable\":true,\"title\":\"Coca-Cola Mezzo Mix 5Dl Pet\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53073194484050,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055117650,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055117650\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Coca-Cola 5Dl Pet\",\"price\":\"38.40\",\"price_set\":{\"shop_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"38.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687912771922,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"3774\",\"taxable\":true,\"title\":\"Coca-Cola 5Dl Pet\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53073191960914,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055150418,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055150418\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Twix Knusperkeks 2X25G\",\"price\":\"44.00\",\"price_set\":{\"shop_money\":{\"amount\":\"44.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"44.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687680708946,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"23\",\"taxable\":true,\"title\":\"Twix Knusperkeks 2X25G\",\"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\":53072414441810,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055183186,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055183186\",\"attributed_staffs\":[],\"current_quantity\":2,\"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\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"348\",\"taxable\":true,\"title\":\"Linzertörtli 75G\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072429482322,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055215954,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055215954\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Fini Pica Jungle Ropes Erdbeer\",\"price\":\"21.10\",\"price_set\":{\"shop_money\":{\"amount\":\"21.10\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"21.10\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687756894546,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"1410\",\"taxable\":true,\"title\":\"Fini Pica Jungle Ropes Erdbeer\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53072655548754,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055248722,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055248722\",\"attributed_staffs\":[],\"current_quantity\":2,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Pfaffenhut Bisquits\",\"price\":\"18.00\",\"price_set\":{\"shop_money\":{\"amount\":\"18.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"18.00\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687701614930,\"properties\":[],\"quantity\":2,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"1013\",\"taxable\":true,\"title\":\"Pfaffenhut Bisquits\",\"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\":53072469852498,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055281490,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055281490\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Snickers\",\"price\":\"42.40\",\"price_set\":{\"shop_money\":{\"amount\":\"42.40\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"42.40\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687697879378,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"769\",\"taxable\":true,\"title\":\"Snickers\",\"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\":53072459432274,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]},{\"id\":18745055314258,\"admin_graphql_api_id\":\"gid:\\/\\/shopify\\/LineItem\\/18745055314258\",\"attributed_staffs\":[],\"current_quantity\":1,\"fulfillable_quantity\":0,\"fulfillment_service\":\"manual\",\"fulfillment_status\":\"fulfilled\",\"gift_card\":false,\"grams\":0,\"name\":\"Kit Kat Choco Waffel\",\"price\":\"34.50\",\"price_set\":{\"shop_money\":{\"amount\":\"34.50\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"34.50\",\"currency_code\":\"CHF\"}},\"product_exists\":true,\"product_id\":10687926632786,\"properties\":[],\"quantity\":1,\"requires_shipping\":true,\"sales_line_item_group_id\":null,\"sku\":\"3945\",\"taxable\":true,\"title\":\"Kit Kat Choco Waffel\",\"total_discount\":\"0.00\",\"total_discount_set\":{\"shop_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"},\"presentment_money\":{\"amount\":\"0.00\",\"currency_code\":\"CHF\"}},\"variant_id\":53073266999634,\"variant_inventory_management\":null,\"variant_title\":null,\"vendor\":\"Leomat\",\"tax_lines\":[],\"duties\":[],\"discount_allocations\":[]}],\"payment_terms\":null,\"refunds\":[],\"shipping_address\":null,\"shipping_lines\":[{\"id\":6259374621010,\"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:43');
2.01 ms (2.02%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '211' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '211' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '211' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
2.00 ms (2.02%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1986' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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 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;
1.79 ms (1.80%)	15	INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`21958 0 "lineItems" "Leomat Café-Creamer Rahmig" "1986" 2.0 93.6 "CHF" "fulfilled" 0 "[]"`] View formatted query View runnable query Explain query INSERT INTO object_collection_LineItems_orders ( `id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (21958, 0, 'lineItems', 'Leomat Café-Creamer Rahmig', '1986', 2, 93.6, 'CHF', 'fulfilled', 0, '[]');
1.61 ms (1.63%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '4925' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '4925' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '4925' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
1.51 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 => 1781795563 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"‚gö\x07À\x1E";i:1781795563;}"`] View formatted query View runnable query Explain query 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) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (30, 1781795563, 'system_cache_write_lock', 0x4F3A313A22A9223A313A7B733A363A228267F607C01E223B693A313738313739353536333B7D) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
1.46 ms (1.47%)	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/" 21958 1781778111 1781795563 14 0 0 21945 "object" "1511" 0 null null "orders" 1 "Orders" 21958`] View formatted query View runnable query Explain query UPDATE objects SET `path` = ?, `id` = ?, `creationDate` = ?, `modificationDate` = ?, `versionCount` = ?, `userOwner` = ?, `userModification` = ?, `parentId` = ?, `type` = ?, `key` = ?, `index` = ?, `childrenSortBy` = ?, `childrenSortOrder` = ?, `classId` = ?, `published` = ?, `className` = ? WHERE `id` = ? UPDATE objects SET `path` = '/Orders/Leomat/2026/06/18/', `id` = 21958, `creationDate` = 1781778111, `modificationDate` = 1781795563, `versionCount` = 14, `userOwner` = 0, `userModification` = 0, `parentId` = 21945, `type` = 'object', `key` = '1511', `index` = 0, `childrenSortBy` = NULL, `childrenSortOrder` = NULL, `classId` = 'orders', `published` = 1, `className` = 'Orders' WHERE `id` = 21958;
1.42 ms (1.43%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3775' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '3775' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3775' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
1.33 ms (1.34%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3774' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '3774' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3774' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
1.28 ms (1.29%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '769' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '769' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '769' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
1.24 ms (1.25%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1013' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '1013' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1013' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
1.20 ms (1.21%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '348' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query 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 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;
1.14 ms (1.15%)	13	SELECT * FROM object_relations_product WHERE src_id = ? Parameters: [`17963`] View formatted query View runnable query Explain query SELECT * FROM object_relations_product WHERE src_id = ? SELECT * FROM object_relations_product WHERE src_id = 17963;
1.05 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` = '819' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '819' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '819' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
1.02 ms (1.03%)	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/" 21958 1781778111 1781795563 14 0 0 21945 "object" "1511" 0 null null "orders" 1 "Orders"`] View formatted query View runnable query Explain query INSERT INTO objects ( `path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) INSERT INTO objects (`path`, `id`, `creationDate`, `modificationDate`, `versionCount`, `userOwner`, `userModification`, `parentId`, `type`, `key`, `index`, `childrenSortBy`, `childrenSortOrder`, `classId`, `published`, `className`) VALUES ('/Orders/Leomat/2026/06/18/', 21958, 1781778111, 1781795563, 14, 0, 0, 21945, 'object', '1511', 0, NULL, NULL, 'orders', 1, 'Orders');
1.01 ms (1.01%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1510' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '1510' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1510' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
0.98 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` = '1410' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '1410' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1410' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
0.96 ms (0.97%)	13	SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de','fr') Parameters: [`17963`] View formatted query View runnable query Explain query SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de', 'fr') SELECT * FROM object_localized_data_product WHERE ooo_id = 17963 AND language IN ('de','fr');
0.92 ms (0.93%)	1	SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`21958 "payload"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = 21958 AND fieldname = 'payload' ORDER BY `index` ASC;
0.90 ms (0.90%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1862' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '1862' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1862' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
0.81 ms (0.81%)	1	DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? Parameters: [`21958 "payload"`] View formatted query View runnable query Explain query DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? DELETE FROM object_collection_ShopifyPayload_orders WHERE id = 21958 AND fieldname = 'payload';
0.79 ms (0.79%)	2	SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Orders/Leomat/2026/06/18/" "1511"`] View formatted query View runnable query Explain query SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM objects WHERE `path` = BINARY '/Orders/Leomat/2026/06/18/' AND `key` = BINARY '1511';
0.79 ms (0.79%)	1	SHOW COLUMNS FROM objects Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM objects SHOW COLUMNS FROM objects;
0.76 ms (0.77%)	1	INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [21958 8043312087378.0 "1511" "paid" 1177.41 "CHF" "ruhland.josephine@hotmail.com" "2026-06-18 12:21:48" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1511",\n "ExternalOrderReference": "18c7067b-3d9c-42df-a7c9-c3ece89fd4ea",\n "ExternalOrderNumber": 511,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1177.41,\n "TotalAmountExcludingTax": 1177.41\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 187.2,\n "PositionTotalIncludingTax": 187.2,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 468,\n "PositionTotalIncludingTax": 468,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 27.5,\n "PerQuantityIncludingTax": 27.5,\n "PositionTotalExcludingTax": 27.5,\n "PositionTotalIncludingTax": 27.5,\n "PerQuantityExcludingTaxRelevant": 27.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4925,\n "Type": "A",\n "Name": "10034",\n "Description": "Automatenzucker (Vending)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20.4,\n "PerQuantityIncludingTax": 20.4,\n "PositionTotalExcludingTax": 20.4,\n "PositionTotalIncludingTax": 20.4,\n "PerQuantityExcludingTaxRelevant": 20.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1510,\n "Type": "A",\n "Name": "13710",\n "Description": "Bio Sambuco Holunder 5Dl Pet"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 53.76,\n "PositionTotalIncludingTax": 53.76,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48.95,\n "PerQuantityIncludingTax": 48.95,\n "PositionTotalExcludingTax": 48.95,\n "PositionTotalIncludingTax": 48.95,\n "PerQuantityExcludingTaxRelevant": 48.95,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 211,\n "Type": "A",\n "Name": "11266",\n "Description": "Rivella Rot 5Dl Pet"\n }\n },\n {\n "LineItemId": 7,\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 "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 76.8,\n "PositionTotalIncludingTax": 76.8,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 44,\n "PerQuantityIncludingTax": 44,\n "PositionTotalExcludingTax": 44,\n "PositionTotalIncludingTax": 44,\n "PerQuantityExcludingTaxRelevant": 44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 23,\n "Type": "A",\n "Name": "10077",\n "Description": "Twix Knusperkeks 2X25G"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 20,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 348,\n "Type": "A",\n "Name": "11648",\n "Description": "Linzertörtli 75G"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18,\n "PerQuantityIncludingTax": 18,\n "PositionTotalExcludingTax": 36,\n "PositionTotalIncludingTax": 36,\n "PerQuantityExcludingTaxRelevant": 18,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1013,\n "Type": "A",\n "Name": "12986",\n "Description": "Pfaffenhut Bisquits"\n }\n },\n {\n "LineItemId": 14,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42.4,\n "PerQuantityIncludingTax": 42.4,\n "PositionTotalExcludingTax": 42.4,\n "PositionTotalIncludingTax": 42.4,\n "PerQuantityExcludingTaxRelevant": 42.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 769,\n "Type": "A",\n "Name": "12535",\n "Description": "Snickers"\n }\n },\n {\n "LineItemId": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "a828224b-66ab-d7d9-b4f1-d88514027076",\n "Account": "Ruhland"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n }\n },\n "_status_sync": {\n "erp_status": "processed",\n "erp_updated_at": "2026-06-18T15:00:03+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """] View formatted query View runnable query Explain query INSERT INTO object_store_orders ( `oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (21958, 8043312087378, '1511', 'paid', 1177.41, 'CHF', 'ruhland.josephine@hotmail.com', '2026-06-18 12:21:48', NULL, 'processed', 1, '{ \"InboxOrderRequest\": { \"Comment\": \"#1511\", \"ExternalOrderReference\": \"18c7067b-3d9c-42df-a7c9-c3ece89fd4ea\", \"ExternalOrderNumber\": 511, \"CreationDate\": \"2026-06-18\", \"Language\": \"de\", \"DeliveryMethodName\": \"3\", \"TaxType\": \"Included\", \"AdditionalInfoList\": [], \"Summary\": { \"CurrencyId\": \"CHF\", \"TotalAmountIncludingTax\": 1177.41, \"TotalAmountExcludingTax\": 1177.41 }, \"IsGuest\": false, \"PositionList\": [ { \"LineItemId\": 1, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 93.6, \"PerQuantityIncludingTax\": 93.6, \"PositionTotalExcludingTax\": 187.2, \"PositionTotalIncludingTax\": 187.2, \"PerQuantityExcludingTaxRelevant\": 93.6, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1986, \"Type\": \"A\", \"Name\": \"12155\", \"Description\": \"Leomat Café-Creamer Rahmig\" } }, { \"LineItemId\": 2, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 234, \"PerQuantityIncludingTax\": 234, \"PositionTotalExcludingTax\": 468, \"PositionTotalIncludingTax\": 468, \"PerQuantityExcludingTaxRelevant\": 234, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 819, \"Type\": \"A\", \"Name\": \"12593\", \"Description\": \"Barone Leomat Premium Bohnenkaffee\" } }, { \"LineItemId\": 3, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 27.5, \"PerQuantityIncludingTax\": 27.5, \"PositionTotalExcludingTax\": 27.5, \"PositionTotalIncludingTax\": 27.5, \"PerQuantityExcludingTaxRelevant\": 27.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 4925, \"Type\": \"A\", \"Name\": \"10034\", \"Description\": \"Automatenzucker (Vending)\" } }, { \"LineItemId\": 4, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20.4, \"PerQuantityIncludingTax\": 20.4, \"PositionTotalExcludingTax\": 20.4, \"PositionTotalIncludingTax\": 20.4, \"PerQuantityExcludingTaxRelevant\": 20.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1510, \"Type\": \"A\", \"Name\": \"13710\", \"Description\": \"Bio Sambuco Holunder 5Dl Pet\" } }, { \"LineItemId\": 5, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 53.76, \"PerQuantityIncludingTax\": 53.76, \"PositionTotalExcludingTax\": 53.76, \"PositionTotalIncludingTax\": 53.76, \"PerQuantityExcludingTaxRelevant\": 53.76, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1862, \"Type\": \"A\", \"Name\": \"13866\", \"Description\": \"Granini Fruchtcocktail 33Cl Pet\" } }, { \"LineItemId\": 6, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 48.95, \"PerQuantityIncludingTax\": 48.95, \"PositionTotalExcludingTax\": 48.95, \"PositionTotalIncludingTax\": 48.95, \"PerQuantityExcludingTaxRelevant\": 48.95, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 211, \"Type\": \"A\", \"Name\": \"11266\", \"Description\": \"Rivella Rot 5Dl Pet\" } }, { \"LineItemId\": 7, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3776, \"Type\": \"A\", \"Name\": \"17622\", \"Description\": \"Coca-Cola Zero 5Dl Pet\" } }, { \"LineItemId\": 8, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3775, \"Type\": \"A\", \"Name\": \"17621\", \"Description\": \"Coca-Cola Mezzo Mix 5Dl Pet\" } }, { \"LineItemId\": 9, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 76.8, \"PositionTotalIncludingTax\": 76.8, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3774, \"Type\": \"A\", \"Name\": \"17620\", \"Description\": \"Coca-Cola 5Dl Pet\" } }, { \"LineItemId\": 10, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 44, \"PerQuantityIncludingTax\": 44, \"PositionTotalExcludingTax\": 44, \"PositionTotalIncludingTax\": 44, \"PerQuantityExcludingTaxRelevant\": 44, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 23, \"Type\": \"A\", \"Name\": \"10077\", \"Description\": \"Twix Knusperkeks 2X25G\" } }, { \"LineItemId\": 11, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20, \"PerQuantityIncludingTax\": 20, \"PositionTotalExcludingTax\": 40, \"PositionTotalIncludingTax\": 40, \"PerQuantityExcludingTaxRelevant\": 20, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 348, \"Type\": \"A\", \"Name\": \"11648\", \"Description\": \"Linzertörtli 75G\" } }, { \"LineItemId\": 12, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 21.1, \"PerQuantityIncludingTax\": 21.1, \"PositionTotalExcludingTax\": 21.1, \"PositionTotalIncludingTax\": 21.1, \"PerQuantityExcludingTaxRelevant\": 21.1, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1410, \"Type\": \"A\", \"Name\": \"13568\", \"Description\": \"Fini Pica Jungle Ropes Erdbeer\" } }, { \"LineItemId\": 13, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 18, \"PerQuantityIncludingTax\": 18, \"PositionTotalExcludingTax\": 36, \"PositionTotalIncludingTax\": 36, \"PerQuantityExcludingTaxRelevant\": 18, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1013, \"Type\": \"A\", \"Name\": \"12986\", \"Description\": \"Pfaffenhut Bisquits\" } }, { \"LineItemId\": 14, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 42.4, \"PerQuantityIncludingTax\": 42.4, \"PositionTotalExcludingTax\": 42.4, \"PositionTotalIncludingTax\": 42.4, \"PerQuantityExcludingTaxRelevant\": 42.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 769, \"Type\": \"A\", \"Name\": \"12535\", \"Description\": \"Snickers\" } }, { \"LineItemId\": 15, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 34.5, \"PerQuantityIncludingTax\": 34.5, \"PositionTotalExcludingTax\": 34.5, \"PositionTotalIncludingTax\": 34.5, \"PerQuantityExcludingTaxRelevant\": 34.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3945, \"Type\": \"A\", \"Name\": \"10074\", \"Description\": \"Kit Kat Choco Waffel\" } } ], \"CustomerSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"PaymentSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"ShippingHandlingList\": [], \"Shopper\": { \"Id\": \"a828224b-66ab-d7d9-b4f1-d88514027076\", \"Account\": \"Ruhland\" }, \"DeliverySubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 } }, \"_status_sync\": { \"erp_status\": \"processed\", \"erp_updated_at\": \"2026-06-18T15:00:03+00:00\", \"erp_status_source\": \"leomat_xlsx\" } }');
0.74 ms (0.75%)	1	SHOW COLUMNS FROM object_store_orders Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_store_orders SHOW COLUMNS FROM object_store_orders;
0.74 ms (0.74%)	1	SELECT object_shopifyconfig.id as id, object_shopifyconfig.type as `type` FROM object_shopifyconfig WHERE (active = 1 AND object_shopifyconfig.type IN ('object','variant','folder')) AND object_shopifyconfig.published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_shopifyconfig.id as id, object_shopifyconfig.type as `type` FROM object_shopifyconfig WHERE ( active = 1 AND object_shopifyconfig.type IN ('object', 'variant', 'folder') ) AND object_shopifyconfig.published = 1 SELECT object_shopifyconfig.id as id, object_shopifyconfig.type as `type` FROM object_shopifyconfig WHERE (active = 1 AND object_shopifyconfig.type IN ('object','variant','folder')) AND object_shopifyconfig.published = 1;
0.68 ms (0.69%)	1	DELETE FROM schedule_tasks WHERE `cid` = 21958 AND `ctype` = 'object' Parameters: [] View formatted query View runnable query Explain query DELETE FROM schedule_tasks WHERE `cid` = 21958 AND `ctype` = 'object' DELETE FROM schedule_tasks WHERE `cid` = 21958 AND `ctype` = 'object';
0.68 ms (0.68%)	1	SHOW COLUMNS FROM versions Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM versions SHOW COLUMNS FROM versions;
0.65 ms (0.65%)	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: [8043312087378.0 "1511" "paid" 1177.41 "CHF" "ruhland.josephine@hotmail.com" "2026-06-18 12:21:48" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1511",\n "ExternalOrderReference": "18c7067b-3d9c-42df-a7c9-c3ece89fd4ea",\n "ExternalOrderNumber": 511,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1177.41,\n "TotalAmountExcludingTax": 1177.41\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 187.2,\n "PositionTotalIncludingTax": 187.2,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 468,\n "PositionTotalIncludingTax": 468,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 27.5,\n "PerQuantityIncludingTax": 27.5,\n "PositionTotalExcludingTax": 27.5,\n "PositionTotalIncludingTax": 27.5,\n "PerQuantityExcludingTaxRelevant": 27.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4925,\n "Type": "A",\n "Name": "10034",\n "Description": "Automatenzucker (Vending)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20.4,\n "PerQuantityIncludingTax": 20.4,\n "PositionTotalExcludingTax": 20.4,\n "PositionTotalIncludingTax": 20.4,\n "PerQuantityExcludingTaxRelevant": 20.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1510,\n "Type": "A",\n "Name": "13710",\n "Description": "Bio Sambuco Holunder 5Dl Pet"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 53.76,\n "PositionTotalIncludingTax": 53.76,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48.95,\n "PerQuantityIncludingTax": 48.95,\n "PositionTotalExcludingTax": 48.95,\n "PositionTotalIncludingTax": 48.95,\n "PerQuantityExcludingTaxRelevant": 48.95,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 211,\n "Type": "A",\n "Name": "11266",\n "Description": "Rivella Rot 5Dl Pet"\n }\n },\n {\n "LineItemId": 7,\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 "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 76.8,\n "PositionTotalIncludingTax": 76.8,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 44,\n "PerQuantityIncludingTax": 44,\n "PositionTotalExcludingTax": 44,\n "PositionTotalIncludingTax": 44,\n "PerQuantityExcludingTaxRelevant": 44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 23,\n "Type": "A",\n "Name": "10077",\n "Description": "Twix Knusperkeks 2X25G"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 20,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 348,\n "Type": "A",\n "Name": "11648",\n "Description": "Linzertörtli 75G"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18,\n "PerQuantityIncludingTax": 18,\n "PositionTotalExcludingTax": 36,\n "PositionTotalIncludingTax": 36,\n "PerQuantityExcludingTaxRelevant": 18,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1013,\n "Type": "A",\n "Name": "12986",\n "Description": "Pfaffenhut Bisquits"\n }\n },\n {\n "LineItemId": 14,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42.4,\n "PerQuantityIncludingTax": 42.4,\n "PositionTotalExcludingTax": 42.4,\n "PositionTotalIncludingTax": 42.4,\n "PerQuantityExcludingTaxRelevant": 42.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 769,\n "Type": "A",\n "Name": "12535",\n "Description": "Snickers"\n }\n },\n {\n "LineItemId": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "a828224b-66ab-d7d9-b4f1-d88514027076",\n "Account": "Ruhland"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\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 } """ 21958 21958] View formatted query View runnable query Explain query UPDATE object_query_orders SET `orderId` = ?, `orderNumber` = ?, `status` = ?, `totalPrice__value` = ?, `totalPrice__unit` = ?, `customerEmail` = ?, `createdAt` = ?, `abacusOrderId` = ?, `abacusStatus` = ?, `sentToAbacus` = ?, `abacusPayload` = ?, `oo_id` = ? WHERE `oo_id` = ? UPDATE object_query_orders SET `orderId` = 8043312087378, `orderNumber` = '1511', `status` = 'paid', `totalPrice__value` = 1177.41, `totalPrice__unit` = 'CHF', `customerEmail` = 'ruhland.josephine@hotmail.com', `createdAt` = '2026-06-18 12:21:48', `abacusOrderId` = NULL, `abacusStatus` = 'processed', `sentToAbacus` = 1, `abacusPayload` = '{ \"InboxOrderRequest\": { \"Comment\": \"#1511\", \"ExternalOrderReference\": \"18c7067b-3d9c-42df-a7c9-c3ece89fd4ea\", \"ExternalOrderNumber\": 511, \"CreationDate\": \"2026-06-18\", \"Language\": \"de\", \"DeliveryMethodName\": \"3\", \"TaxType\": \"Included\", \"AdditionalInfoList\": [], \"Summary\": { \"CurrencyId\": \"CHF\", \"TotalAmountIncludingTax\": 1177.41, \"TotalAmountExcludingTax\": 1177.41 }, \"IsGuest\": false, \"PositionList\": [ { \"LineItemId\": 1, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 93.6, \"PerQuantityIncludingTax\": 93.6, \"PositionTotalExcludingTax\": 187.2, \"PositionTotalIncludingTax\": 187.2, \"PerQuantityExcludingTaxRelevant\": 93.6, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1986, \"Type\": \"A\", \"Name\": \"12155\", \"Description\": \"Leomat Café-Creamer Rahmig\" } }, { \"LineItemId\": 2, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 234, \"PerQuantityIncludingTax\": 234, \"PositionTotalExcludingTax\": 468, \"PositionTotalIncludingTax\": 468, \"PerQuantityExcludingTaxRelevant\": 234, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 819, \"Type\": \"A\", \"Name\": \"12593\", \"Description\": \"Barone Leomat Premium Bohnenkaffee\" } }, { \"LineItemId\": 3, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 27.5, \"PerQuantityIncludingTax\": 27.5, \"PositionTotalExcludingTax\": 27.5, \"PositionTotalIncludingTax\": 27.5, \"PerQuantityExcludingTaxRelevant\": 27.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 4925, \"Type\": \"A\", \"Name\": \"10034\", \"Description\": \"Automatenzucker (Vending)\" } }, { \"LineItemId\": 4, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20.4, \"PerQuantityIncludingTax\": 20.4, \"PositionTotalExcludingTax\": 20.4, \"PositionTotalIncludingTax\": 20.4, \"PerQuantityExcludingTaxRelevant\": 20.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1510, \"Type\": \"A\", \"Name\": \"13710\", \"Description\": \"Bio Sambuco Holunder 5Dl Pet\" } }, { \"LineItemId\": 5, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 53.76, \"PerQuantityIncludingTax\": 53.76, \"PositionTotalExcludingTax\": 53.76, \"PositionTotalIncludingTax\": 53.76, \"PerQuantityExcludingTaxRelevant\": 53.76, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1862, \"Type\": \"A\", \"Name\": \"13866\", \"Description\": \"Granini Fruchtcocktail 33Cl Pet\" } }, { \"LineItemId\": 6, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 48.95, \"PerQuantityIncludingTax\": 48.95, \"PositionTotalExcludingTax\": 48.95, \"PositionTotalIncludingTax\": 48.95, \"PerQuantityExcludingTaxRelevant\": 48.95, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 211, \"Type\": \"A\", \"Name\": \"11266\", \"Description\": \"Rivella Rot 5Dl Pet\" } }, { \"LineItemId\": 7, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3776, \"Type\": \"A\", \"Name\": \"17622\", \"Description\": \"Coca-Cola Zero 5Dl Pet\" } }, { \"LineItemId\": 8, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3775, \"Type\": \"A\", \"Name\": \"17621\", \"Description\": \"Coca-Cola Mezzo Mix 5Dl Pet\" } }, { \"LineItemId\": 9, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 76.8, \"PositionTotalIncludingTax\": 76.8, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3774, \"Type\": \"A\", \"Name\": \"17620\", \"Description\": \"Coca-Cola 5Dl Pet\" } }, { \"LineItemId\": 10, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 44, \"PerQuantityIncludingTax\": 44, \"PositionTotalExcludingTax\": 44, \"PositionTotalIncludingTax\": 44, \"PerQuantityExcludingTaxRelevant\": 44, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 23, \"Type\": \"A\", \"Name\": \"10077\", \"Description\": \"Twix Knusperkeks 2X25G\" } }, { \"LineItemId\": 11, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20, \"PerQuantityIncludingTax\": 20, \"PositionTotalExcludingTax\": 40, \"PositionTotalIncludingTax\": 40, \"PerQuantityExcludingTaxRelevant\": 20, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 348, \"Type\": \"A\", \"Name\": \"11648\", \"Description\": \"Linzertörtli 75G\" } }, { \"LineItemId\": 12, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 21.1, \"PerQuantityIncludingTax\": 21.1, \"PositionTotalExcludingTax\": 21.1, \"PositionTotalIncludingTax\": 21.1, \"PerQuantityExcludingTaxRelevant\": 21.1, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1410, \"Type\": \"A\", \"Name\": \"13568\", \"Description\": \"Fini Pica Jungle Ropes Erdbeer\" } }, { \"LineItemId\": 13, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 18, \"PerQuantityIncludingTax\": 18, \"PositionTotalExcludingTax\": 36, \"PositionTotalIncludingTax\": 36, \"PerQuantityExcludingTaxRelevant\": 18, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1013, \"Type\": \"A\", \"Name\": \"12986\", \"Description\": \"Pfaffenhut Bisquits\" } }, { \"LineItemId\": 14, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 42.4, \"PerQuantityIncludingTax\": 42.4, \"PositionTotalExcludingTax\": 42.4, \"PositionTotalIncludingTax\": 42.4, \"PerQuantityExcludingTaxRelevant\": 42.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 769, \"Type\": \"A\", \"Name\": \"12535\", \"Description\": \"Snickers\" } }, { \"LineItemId\": 15, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 34.5, \"PerQuantityIncludingTax\": 34.5, \"PositionTotalExcludingTax\": 34.5, \"PositionTotalIncludingTax\": 34.5, \"PerQuantityExcludingTaxRelevant\": 34.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3945, \"Type\": \"A\", \"Name\": \"10074\", \"Description\": \"Kit Kat Choco Waffel\" } } ], \"CustomerSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"PaymentSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"ShippingHandlingList\": [], \"Shopper\": { \"Id\": \"a828224b-66ab-d7d9-b4f1-d88514027076\", \"Account\": \"Ruhland\" }, \"DeliverySubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 } }, \"_status_sync\": { \"erp_status\": \"processed\", \"erp_updated_at\": \"2026-06-18T15:00:03+00:00\", \"erp_status_source\": \"leomat_xlsx\" } }', `oo_id` = 21958 WHERE `oo_id` = 21958;
0.64 ms (0.65%)	1	SHOW COLUMNS FROM object_query_orders Parameters: [] View formatted query View runnable query Explain query SHOW COLUMNS FROM object_query_orders SHOW COLUMNS FROM object_query_orders;
0.64 ms (0.64%)	1	INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [8043312087378.0 "1511" "paid" 1177.41 "CHF" "ruhland.josephine@hotmail.com" "2026-06-18 12:21:48" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1511",\n "ExternalOrderReference": "18c7067b-3d9c-42df-a7c9-c3ece89fd4ea",\n "ExternalOrderNumber": 511,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1177.41,\n "TotalAmountExcludingTax": 1177.41\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 187.2,\n "PositionTotalIncludingTax": 187.2,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 468,\n "PositionTotalIncludingTax": 468,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 27.5,\n "PerQuantityIncludingTax": 27.5,\n "PositionTotalExcludingTax": 27.5,\n "PositionTotalIncludingTax": 27.5,\n "PerQuantityExcludingTaxRelevant": 27.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4925,\n "Type": "A",\n "Name": "10034",\n "Description": "Automatenzucker (Vending)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20.4,\n "PerQuantityIncludingTax": 20.4,\n "PositionTotalExcludingTax": 20.4,\n "PositionTotalIncludingTax": 20.4,\n "PerQuantityExcludingTaxRelevant": 20.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1510,\n "Type": "A",\n "Name": "13710",\n "Description": "Bio Sambuco Holunder 5Dl Pet"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 53.76,\n "PositionTotalIncludingTax": 53.76,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48.95,\n "PerQuantityIncludingTax": 48.95,\n "PositionTotalExcludingTax": 48.95,\n "PositionTotalIncludingTax": 48.95,\n "PerQuantityExcludingTaxRelevant": 48.95,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 211,\n "Type": "A",\n "Name": "11266",\n "Description": "Rivella Rot 5Dl Pet"\n }\n },\n {\n "LineItemId": 7,\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 "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 76.8,\n "PositionTotalIncludingTax": 76.8,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 44,\n "PerQuantityIncludingTax": 44,\n "PositionTotalExcludingTax": 44,\n "PositionTotalIncludingTax": 44,\n "PerQuantityExcludingTaxRelevant": 44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 23,\n "Type": "A",\n "Name": "10077",\n "Description": "Twix Knusperkeks 2X25G"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 20,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 348,\n "Type": "A",\n "Name": "11648",\n "Description": "Linzertörtli 75G"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18,\n "PerQuantityIncludingTax": 18,\n "PositionTotalExcludingTax": 36,\n "PositionTotalIncludingTax": 36,\n "PerQuantityExcludingTaxRelevant": 18,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1013,\n "Type": "A",\n "Name": "12986",\n "Description": "Pfaffenhut Bisquits"\n }\n },\n {\n "LineItemId": 14,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42.4,\n "PerQuantityIncludingTax": 42.4,\n "PositionTotalExcludingTax": 42.4,\n "PositionTotalIncludingTax": 42.4,\n "PerQuantityExcludingTaxRelevant": 42.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 769,\n "Type": "A",\n "Name": "12535",\n "Description": "Snickers"\n }\n },\n {\n "LineItemId": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "a828224b-66ab-d7d9-b4f1-d88514027076",\n "Account": "Ruhland"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\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 } """ 21958] View formatted query View runnable query Explain query INSERT INTO object_query_orders ( `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (8043312087378, '1511', 'paid', 1177.41, 'CHF', 'ruhland.josephine@hotmail.com', '2026-06-18 12:21:48', NULL, 'processed', 1, '{ \"InboxOrderRequest\": { \"Comment\": \"#1511\", \"ExternalOrderReference\": \"18c7067b-3d9c-42df-a7c9-c3ece89fd4ea\", \"ExternalOrderNumber\": 511, \"CreationDate\": \"2026-06-18\", \"Language\": \"de\", \"DeliveryMethodName\": \"3\", \"TaxType\": \"Included\", \"AdditionalInfoList\": [], \"Summary\": { \"CurrencyId\": \"CHF\", \"TotalAmountIncludingTax\": 1177.41, \"TotalAmountExcludingTax\": 1177.41 }, \"IsGuest\": false, \"PositionList\": [ { \"LineItemId\": 1, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 93.6, \"PerQuantityIncludingTax\": 93.6, \"PositionTotalExcludingTax\": 187.2, \"PositionTotalIncludingTax\": 187.2, \"PerQuantityExcludingTaxRelevant\": 93.6, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1986, \"Type\": \"A\", \"Name\": \"12155\", \"Description\": \"Leomat Café-Creamer Rahmig\" } }, { \"LineItemId\": 2, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 234, \"PerQuantityIncludingTax\": 234, \"PositionTotalExcludingTax\": 468, \"PositionTotalIncludingTax\": 468, \"PerQuantityExcludingTaxRelevant\": 234, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 819, \"Type\": \"A\", \"Name\": \"12593\", \"Description\": \"Barone Leomat Premium Bohnenkaffee\" } }, { \"LineItemId\": 3, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 27.5, \"PerQuantityIncludingTax\": 27.5, \"PositionTotalExcludingTax\": 27.5, \"PositionTotalIncludingTax\": 27.5, \"PerQuantityExcludingTaxRelevant\": 27.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 4925, \"Type\": \"A\", \"Name\": \"10034\", \"Description\": \"Automatenzucker (Vending)\" } }, { \"LineItemId\": 4, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20.4, \"PerQuantityIncludingTax\": 20.4, \"PositionTotalExcludingTax\": 20.4, \"PositionTotalIncludingTax\": 20.4, \"PerQuantityExcludingTaxRelevant\": 20.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1510, \"Type\": \"A\", \"Name\": \"13710\", \"Description\": \"Bio Sambuco Holunder 5Dl Pet\" } }, { \"LineItemId\": 5, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 53.76, \"PerQuantityIncludingTax\": 53.76, \"PositionTotalExcludingTax\": 53.76, \"PositionTotalIncludingTax\": 53.76, \"PerQuantityExcludingTaxRelevant\": 53.76, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1862, \"Type\": \"A\", \"Name\": \"13866\", \"Description\": \"Granini Fruchtcocktail 33Cl Pet\" } }, { \"LineItemId\": 6, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 48.95, \"PerQuantityIncludingTax\": 48.95, \"PositionTotalExcludingTax\": 48.95, \"PositionTotalIncludingTax\": 48.95, \"PerQuantityExcludingTaxRelevant\": 48.95, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 211, \"Type\": \"A\", \"Name\": \"11266\", \"Description\": \"Rivella Rot 5Dl Pet\" } }, { \"LineItemId\": 7, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3776, \"Type\": \"A\", \"Name\": \"17622\", \"Description\": \"Coca-Cola Zero 5Dl Pet\" } }, { \"LineItemId\": 8, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3775, \"Type\": \"A\", \"Name\": \"17621\", \"Description\": \"Coca-Cola Mezzo Mix 5Dl Pet\" } }, { \"LineItemId\": 9, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 76.8, \"PositionTotalIncludingTax\": 76.8, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3774, \"Type\": \"A\", \"Name\": \"17620\", \"Description\": \"Coca-Cola 5Dl Pet\" } }, { \"LineItemId\": 10, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 44, \"PerQuantityIncludingTax\": 44, \"PositionTotalExcludingTax\": 44, \"PositionTotalIncludingTax\": 44, \"PerQuantityExcludingTaxRelevant\": 44, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 23, \"Type\": \"A\", \"Name\": \"10077\", \"Description\": \"Twix Knusperkeks 2X25G\" } }, { \"LineItemId\": 11, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20, \"PerQuantityIncludingTax\": 20, \"PositionTotalExcludingTax\": 40, \"PositionTotalIncludingTax\": 40, \"PerQuantityExcludingTaxRelevant\": 20, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 348, \"Type\": \"A\", \"Name\": \"11648\", \"Description\": \"Linzertörtli 75G\" } }, { \"LineItemId\": 12, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 21.1, \"PerQuantityIncludingTax\": 21.1, \"PositionTotalExcludingTax\": 21.1, \"PositionTotalIncludingTax\": 21.1, \"PerQuantityExcludingTaxRelevant\": 21.1, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1410, \"Type\": \"A\", \"Name\": \"13568\", \"Description\": \"Fini Pica Jungle Ropes Erdbeer\" } }, { \"LineItemId\": 13, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 18, \"PerQuantityIncludingTax\": 18, \"PositionTotalExcludingTax\": 36, \"PositionTotalIncludingTax\": 36, \"PerQuantityExcludingTaxRelevant\": 18, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1013, \"Type\": \"A\", \"Name\": \"12986\", \"Description\": \"Pfaffenhut Bisquits\" } }, { \"LineItemId\": 14, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 42.4, \"PerQuantityIncludingTax\": 42.4, \"PositionTotalExcludingTax\": 42.4, \"PositionTotalIncludingTax\": 42.4, \"PerQuantityExcludingTaxRelevant\": 42.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 769, \"Type\": \"A\", \"Name\": \"12535\", \"Description\": \"Snickers\" } }, { \"LineItemId\": 15, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 34.5, \"PerQuantityIncludingTax\": 34.5, \"PositionTotalExcludingTax\": 34.5, \"PositionTotalIncludingTax\": 34.5, \"PerQuantityExcludingTaxRelevant\": 34.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3945, \"Type\": \"A\", \"Name\": \"10074\", \"Description\": \"Kit Kat Choco Waffel\" } } ], \"CustomerSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"PaymentSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"ShippingHandlingList\": [], \"Shopper\": { \"Id\": \"a828224b-66ab-d7d9-b4f1-d88514027076\", \"Account\": \"Ruhland\" }, \"DeliverySubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 } }, \"_status_sync\": { \"erp_status\": \"processed\", \"erp_updated_at\": \"2026-06-18T15:00:03+00:00\", \"erp_status_source\": \"leomat_xlsx\" } }', 21958);
0.60 ms (0.60%)	1	SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' Parameters: [`21958`] View formatted query View runnable query Explain query SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object' SELECT MAX(versionCount) FROM versions WHERE cid = 21958 AND ctype = 'object';
0.58 ms (0.58%)	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: [21958 8043312087378.0 "1511" "paid" 1177.41 "CHF" "ruhland.josephine@hotmail.com" "2026-06-18 12:21:48" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1511",\n "ExternalOrderReference": "18c7067b-3d9c-42df-a7c9-c3ece89fd4ea",\n "ExternalOrderNumber": 511,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 1177.41,\n "TotalAmountExcludingTax": 1177.41\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 187.2,\n "PositionTotalIncludingTax": 187.2,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 234,\n "PerQuantityIncludingTax": 234,\n "PositionTotalExcludingTax": 468,\n "PositionTotalIncludingTax": 468,\n "PerQuantityExcludingTaxRelevant": 234,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 819,\n "Type": "A",\n "Name": "12593",\n "Description": "Barone Leomat Premium Bohnenkaffee"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 27.5,\n "PerQuantityIncludingTax": 27.5,\n "PositionTotalExcludingTax": 27.5,\n "PositionTotalIncludingTax": 27.5,\n "PerQuantityExcludingTaxRelevant": 27.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 4925,\n "Type": "A",\n "Name": "10034",\n "Description": "Automatenzucker (Vending)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20.4,\n "PerQuantityIncludingTax": 20.4,\n "PositionTotalExcludingTax": 20.4,\n "PositionTotalIncludingTax": 20.4,\n "PerQuantityExcludingTaxRelevant": 20.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1510,\n "Type": "A",\n "Name": "13710",\n "Description": "Bio Sambuco Holunder 5Dl Pet"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 53.76,\n "PerQuantityIncludingTax": 53.76,\n "PositionTotalExcludingTax": 53.76,\n "PositionTotalIncludingTax": 53.76,\n "PerQuantityExcludingTaxRelevant": 53.76,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1862,\n "Type": "A",\n "Name": "13866",\n "Description": "Granini Fruchtcocktail 33Cl Pet"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 48.95,\n "PerQuantityIncludingTax": 48.95,\n "PositionTotalExcludingTax": 48.95,\n "PositionTotalIncludingTax": 48.95,\n "PerQuantityExcludingTaxRelevant": 48.95,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 211,\n "Type": "A",\n "Name": "11266",\n "Description": "Rivella Rot 5Dl Pet"\n }\n },\n {\n "LineItemId": 7,\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 "LineItemId": 8,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3775,\n "Type": "A",\n "Name": "17621",\n "Description": "Coca-Cola Mezzo Mix 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 76.8,\n "PositionTotalIncludingTax": 76.8,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 44,\n "PerQuantityIncludingTax": 44,\n "PositionTotalExcludingTax": 44,\n "PositionTotalIncludingTax": 44,\n "PerQuantityExcludingTaxRelevant": 44,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 23,\n "Type": "A",\n "Name": "10077",\n "Description": "Twix Knusperkeks 2X25G"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 20,\n "PerQuantityIncludingTax": 20,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 20,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 348,\n "Type": "A",\n "Name": "11648",\n "Description": "Linzertörtli 75G"\n }\n },\n {\n "LineItemId": 12,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 21.1,\n "PerQuantityIncludingTax": 21.1,\n "PositionTotalExcludingTax": 21.1,\n "PositionTotalIncludingTax": 21.1,\n "PerQuantityExcludingTaxRelevant": 21.1,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1410,\n "Type": "A",\n "Name": "13568",\n "Description": "Fini Pica Jungle Ropes Erdbeer"\n }\n },\n {\n "LineItemId": 13,\n "Quantity": 2,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 18,\n "PerQuantityIncludingTax": 18,\n "PositionTotalExcludingTax": 36,\n "PositionTotalIncludingTax": 36,\n "PerQuantityExcludingTaxRelevant": 18,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1013,\n "Type": "A",\n "Name": "12986",\n "Description": "Pfaffenhut Bisquits"\n }\n },\n {\n "LineItemId": 14,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 42.4,\n "PerQuantityIncludingTax": 42.4,\n "PositionTotalExcludingTax": 42.4,\n "PositionTotalIncludingTax": 42.4,\n "PerQuantityExcludingTaxRelevant": 42.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 769,\n "Type": "A",\n "Name": "12535",\n "Description": "Snickers"\n }\n },\n {\n "LineItemId": 15,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 34.5,\n "PerQuantityIncludingTax": 34.5,\n "PositionTotalExcludingTax": 34.5,\n "PositionTotalIncludingTax": 34.5,\n "PerQuantityExcludingTaxRelevant": 34.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3945,\n "Type": "A",\n "Name": "10074",\n "Description": "Kit Kat Choco Waffel"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "a828224b-66ab-d7d9-b4f1-d88514027076",\n "Account": "Ruhland"\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Josephine",\n "Name": "Ruhland",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n }\n },\n "Address": {\n "Street": "Buhofstrasse",\n "HouseNumber": "54a",\n "PostCode": "9424",\n "City": "Rheineck",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "ruhland.josephine@hotmail.com"\n },\n "Id": 21458\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 } """ 21958] View formatted query View runnable query Explain query UPDATE object_store_orders SET `oo_id` = ?, `orderId` = ?, `orderNumber` = ?, `status` = ?, `totalPrice__value` = ?, `totalPrice__unit` = ?, `customerEmail` = ?, `createdAt` = ?, `abacusOrderId` = ?, `abacusStatus` = ?, `sentToAbacus` = ?, `abacusPayload` = ? WHERE `oo_id` = ? UPDATE object_store_orders SET `oo_id` = 21958, `orderId` = 8043312087378, `orderNumber` = '1511', `status` = 'paid', `totalPrice__value` = 1177.41, `totalPrice__unit` = 'CHF', `customerEmail` = 'ruhland.josephine@hotmail.com', `createdAt` = '2026-06-18 12:21:48', `abacusOrderId` = NULL, `abacusStatus` = 'processed', `sentToAbacus` = 1, `abacusPayload` = '{ \"InboxOrderRequest\": { \"Comment\": \"#1511\", \"ExternalOrderReference\": \"18c7067b-3d9c-42df-a7c9-c3ece89fd4ea\", \"ExternalOrderNumber\": 511, \"CreationDate\": \"2026-06-18\", \"Language\": \"de\", \"DeliveryMethodName\": \"3\", \"TaxType\": \"Included\", \"AdditionalInfoList\": [], \"Summary\": { \"CurrencyId\": \"CHF\", \"TotalAmountIncludingTax\": 1177.41, \"TotalAmountExcludingTax\": 1177.41 }, \"IsGuest\": false, \"PositionList\": [ { \"LineItemId\": 1, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 93.6, \"PerQuantityIncludingTax\": 93.6, \"PositionTotalExcludingTax\": 187.2, \"PositionTotalIncludingTax\": 187.2, \"PerQuantityExcludingTaxRelevant\": 93.6, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1986, \"Type\": \"A\", \"Name\": \"12155\", \"Description\": \"Leomat Café-Creamer Rahmig\" } }, { \"LineItemId\": 2, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 234, \"PerQuantityIncludingTax\": 234, \"PositionTotalExcludingTax\": 468, \"PositionTotalIncludingTax\": 468, \"PerQuantityExcludingTaxRelevant\": 234, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 819, \"Type\": \"A\", \"Name\": \"12593\", \"Description\": \"Barone Leomat Premium Bohnenkaffee\" } }, { \"LineItemId\": 3, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 27.5, \"PerQuantityIncludingTax\": 27.5, \"PositionTotalExcludingTax\": 27.5, \"PositionTotalIncludingTax\": 27.5, \"PerQuantityExcludingTaxRelevant\": 27.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 4925, \"Type\": \"A\", \"Name\": \"10034\", \"Description\": \"Automatenzucker (Vending)\" } }, { \"LineItemId\": 4, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20.4, \"PerQuantityIncludingTax\": 20.4, \"PositionTotalExcludingTax\": 20.4, \"PositionTotalIncludingTax\": 20.4, \"PerQuantityExcludingTaxRelevant\": 20.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1510, \"Type\": \"A\", \"Name\": \"13710\", \"Description\": \"Bio Sambuco Holunder 5Dl Pet\" } }, { \"LineItemId\": 5, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 53.76, \"PerQuantityIncludingTax\": 53.76, \"PositionTotalExcludingTax\": 53.76, \"PositionTotalIncludingTax\": 53.76, \"PerQuantityExcludingTaxRelevant\": 53.76, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1862, \"Type\": \"A\", \"Name\": \"13866\", \"Description\": \"Granini Fruchtcocktail 33Cl Pet\" } }, { \"LineItemId\": 6, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 48.95, \"PerQuantityIncludingTax\": 48.95, \"PositionTotalExcludingTax\": 48.95, \"PositionTotalIncludingTax\": 48.95, \"PerQuantityExcludingTaxRelevant\": 48.95, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 211, \"Type\": \"A\", \"Name\": \"11266\", \"Description\": \"Rivella Rot 5Dl Pet\" } }, { \"LineItemId\": 7, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3776, \"Type\": \"A\", \"Name\": \"17622\", \"Description\": \"Coca-Cola Zero 5Dl Pet\" } }, { \"LineItemId\": 8, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 38.4, \"PositionTotalIncludingTax\": 38.4, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3775, \"Type\": \"A\", \"Name\": \"17621\", \"Description\": \"Coca-Cola Mezzo Mix 5Dl Pet\" } }, { \"LineItemId\": 9, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 38.4, \"PerQuantityIncludingTax\": 38.4, \"PositionTotalExcludingTax\": 76.8, \"PositionTotalIncludingTax\": 76.8, \"PerQuantityExcludingTaxRelevant\": 38.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3774, \"Type\": \"A\", \"Name\": \"17620\", \"Description\": \"Coca-Cola 5Dl Pet\" } }, { \"LineItemId\": 10, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 44, \"PerQuantityIncludingTax\": 44, \"PositionTotalExcludingTax\": 44, \"PositionTotalIncludingTax\": 44, \"PerQuantityExcludingTaxRelevant\": 44, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 23, \"Type\": \"A\", \"Name\": \"10077\", \"Description\": \"Twix Knusperkeks 2X25G\" } }, { \"LineItemId\": 11, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 20, \"PerQuantityIncludingTax\": 20, \"PositionTotalExcludingTax\": 40, \"PositionTotalIncludingTax\": 40, \"PerQuantityExcludingTaxRelevant\": 20, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 348, \"Type\": \"A\", \"Name\": \"11648\", \"Description\": \"Linzertörtli 75G\" } }, { \"LineItemId\": 12, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 21.1, \"PerQuantityIncludingTax\": 21.1, \"PositionTotalExcludingTax\": 21.1, \"PositionTotalIncludingTax\": 21.1, \"PerQuantityExcludingTaxRelevant\": 21.1, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1410, \"Type\": \"A\", \"Name\": \"13568\", \"Description\": \"Fini Pica Jungle Ropes Erdbeer\" } }, { \"LineItemId\": 13, \"Quantity\": 2, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 18, \"PerQuantityIncludingTax\": 18, \"PositionTotalExcludingTax\": 36, \"PositionTotalIncludingTax\": 36, \"PerQuantityExcludingTaxRelevant\": 18, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 1013, \"Type\": \"A\", \"Name\": \"12986\", \"Description\": \"Pfaffenhut Bisquits\" } }, { \"LineItemId\": 14, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 42.4, \"PerQuantityIncludingTax\": 42.4, \"PositionTotalExcludingTax\": 42.4, \"PositionTotalIncludingTax\": 42.4, \"PerQuantityExcludingTaxRelevant\": 42.4, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 769, \"Type\": \"A\", \"Name\": \"12535\", \"Description\": \"Snickers\" } }, { \"LineItemId\": 15, \"Quantity\": 1, \"PriceInfo\": { \"PriceFromApi\": false, \"PerQuantityExcludingTax\": 34.5, \"PerQuantityIncludingTax\": 34.5, \"PositionTotalExcludingTax\": 34.5, \"PositionTotalIncludingTax\": 34.5, \"PerQuantityExcludingTaxRelevant\": 34.5, \"CurrencyId\": \"CHF\", \"TaxInfo\": { \"Code\": 312, \"CodeAsString\": \"312\", \"Rate\": 0, \"Amount\": 0 } }, \"Product\": { \"Id\": 3945, \"Type\": \"A\", \"Name\": \"10074\", \"Description\": \"Kit Kat Choco Waffel\" } } ], \"CustomerSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"PaymentSubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 }, \"ShippingHandlingList\": [], \"Shopper\": { \"Id\": \"a828224b-66ab-d7d9-b4f1-d88514027076\", \"Account\": \"Ruhland\" }, \"DeliverySubject\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"CompanyName\": \"\", \"DateOfBirth\": \"1900-01-01\", \"Contact\": { \"Salutation\": \"\", \"FirstName\": \"Josephine\", \"Name\": \"Ruhland\", \"DateOfBirth\": \"1900-01-01\", \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" } }, \"Address\": { \"Street\": \"Buhofstrasse\", \"HouseNumber\": \"54a\", \"PostCode\": \"9424\", \"City\": \"Rheineck\", \"CountryId\": \"CH\" }, \"Communication\": { \"Phone\": \"\", \"Email\": \"ruhland.josephine@hotmail.com\" }, \"Id\": 21458 } }, \"_status_sync\": { \"erp_status\": \"processed\", \"erp_updated_at\": \"2026-06-18T15:00:03+00:00\", \"erp_status_source\": \"leomat_xlsx\" } }' WHERE `oo_id` = 21958;
0.56 ms (0.56%)	1	SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '23' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE ( `sku` = '23' AND object_localized_product_de.type IN ('variant', 'object') ) AND object_localized_product_de.published = 1 LIMIT 1 SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '23' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1;
0.54 ms (0.54%)	1	DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ? Parameters: [`21958 "lineItems"`] View formatted query View runnable query Explain query DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ? DELETE FROM object_collection_LineItems_orders WHERE id = 21958 AND fieldname = 'lineItems';
0.53 ms (0.53%)	1	DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21958') Parameters: [] View formatted query View runnable query Explain query DELETE FROM object_relations_orders WHERE ( ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21958' ) DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21958');
0.44 ms (0.45%)	2	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
0.42 ms (0.42%)	5	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/webhook/shopify/leomat/" "order"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/webhook/shopify/leomat/' AND `key` = BINARY 'order';
0.36 ms (0.37%)	2	SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ? Parameters: [`21945`] View formatted query View runnable query Explain query SELECT CONCAT(`path`, `key`) as `path` FROM objects WHERE id = ? SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = 21945;
0.36 ms (0.36%)	1	INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [null 21958 "object" 0 "" 1781795563 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} """ 14 null null 0 "fs"] View formatted query View runnable query Explain query INSERT INTO versions ( `id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (NULL, 21958, 'object', 0, '', 1781795563, 0, 1, '#0 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/Element/AbstractElement.php(632): Pimcore\\Model\\Version->save() #1 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/Concrete.php(275): Pimcore\\Model\\Element\\AbstractElement->doSaveVersion() #2 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/Concrete.php(213): Pimcore\\Model\\DataObject\\Concrete->saveVersion() #3 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(537): Pimcore\\Model\\DataObject\\Concrete->update() #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}() #5 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/AbstractObject.php(483): Pimcore\\Model\\Element\\AbstractElement->retryableFunction() #6 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/pimcore/pimcore/models/DataObject/Concrete.php(642): Pimcore\\Model\\DataObject\\AbstractObject->save() #7 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/bundles/PimcoreShopifyIntegrationBundle/src/Controller/ShopifyWebhookController.php(246): Pimcore\\Model\\DataObject\\Concrete->save() #8 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/bundles/PimcoreShopifyIntegrationBundle/src/Controller/ShopifyWebhookController.php(104): PimcoreShopifyIntegrationBundle\\Controller\\ShopifyWebhookController->handleOrderUpsert() #9 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/http-kernel/HttpKernel.php(183): PimcoreShopifyIntegrationBundle\\Controller\\ShopifyWebhookController->orderWebhook() #10 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw() #11 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/http-kernel/Kernel.php(193): Symfony\\Component\\HttpKernel\\HttpKernel->handle() #12 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle() #13 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run() #14 /var/www/vhosts/reflection486.lcube-server.de/leomatapi/public/public/index.php(16): require_once(\'...\') #15 {main}', 14, NULL, NULL, 0, 'fs');
0.33 ms (0.33%)	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:21958;}}" "[]" "pimcore_search_backend_message" "2026-06-18 15:12:43" "2026-06-18 15:12:43"] View formatted query View runnable query Explain query INSERT INTO messenger_messages ( body, headers, queue_name, created_at, available_at ) VALUES (?, ?, ?, ?, ?) INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('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:21958;}}', '[]', 'pimcore_search_backend_message', '2026-06-18 15:12:43', '2026-06-18 15:12:43');
0.32 ms (0.33%)	1	SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE Parameters: [`21958`] View formatted query View runnable query Explain query SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_orders WHERE oo_id = 21958 FOR UPDATE;
0.32 ms (0.32%)	1	SELECT * FROM object_relations_orders WHERE src_id = ? Parameters: [`21958`] View formatted query View runnable query Explain query SELECT * FROM object_relations_orders WHERE src_id = ? SELECT * FROM object_relations_orders WHERE src_id = 21958;
0.31 ms (0.32%)	1	SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? Parameters: [`21958 "object"`] View formatted query View runnable query Explain query SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ? SELECT id FROM schedule_tasks WHERE `cid` = 21958 AND `ctype` = 'object' ;
0.31 ms (0.31%)	1	DELETE FROM tree_locks WHERE id = ? AND type = ? Parameters: [`21958 "object"`] View formatted query View runnable query Explain query DELETE FROM tree_locks WHERE id = ? AND type = ? DELETE FROM tree_locks WHERE id = 21958 AND type = 'object';
0.30 ms (0.31%)	1	SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21958' AND `fieldname` = 'payload' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21958' AND `fieldname` = 'payload' LIMIT 1 SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21958' AND `fieldname` = 'payload' LIMIT 1;
0.29 ms (0.29%)	4	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/webhook/shopify/leomat/order"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/webhook/shopify/leomat/order';
0.29 ms (0.29%)	1	SELECT versionCount FROM objects WHERE id = ? FOR UPDATE Parameters: [`21958`] View formatted query View runnable query Explain query SELECT versionCount FROM objects WHERE id = ? FOR UPDATE SELECT versionCount FROM objects WHERE id = 21958 FOR UPDATE;
0.28 ms (0.29%)	1	SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21958' AND `fieldname` = 'lineItems' LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21958' AND `fieldname` = 'lineItems' LIMIT 1 SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21958' AND `fieldname` = 'lineItems' LIMIT 1;
0.26 ms (0.26%)	1	SELECT * FROM object_query_orders WHERE oo_id = ? Parameters: [`21958`] View formatted query View runnable query Explain query SELECT * FROM object_query_orders WHERE oo_id = ? SELECT * FROM object_query_orders WHERE oo_id = 21958;
0.22 ms (0.22%)	2	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"orders"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = 'orders' ;
0.22 ms (0.22%)	1	DELETE FROM cache_items WHERE item_id IN (?, ?) Parameters: [`"object_21958\x01tags\x01" "object_properties\x01tags\x01"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_id IN (?, ?) DELETE FROM cache_items WHERE item_id IN ('object_21958tags', 'object_propertiestags');
0.20 ms (0.20%)	2	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
0.17 ms (0.17%)	1	DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21958') Parameters: [] View formatted query View runnable query Explain query DELETE FROM object_relations_orders WHERE ( ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21958' ) DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21958');
0.16 ms (0.16%)	1	DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21958') Parameters: [] View formatted query View runnable query Explain query DELETE FROM object_relations_orders WHERE ( ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21958' ) DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21958');
0.16 ms (0.16%)	1	SELECT type,classId,className FROM objects WHERE id = ? Parameters: [`21958`] View formatted query View runnable query Explain query SELECT type, classId, className FROM objects WHERE id = ? SELECT type,classId,className FROM objects WHERE id = 21958;
0.15 ms (0.15%)	1	DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21958') Parameters: [] View formatted query View runnable query Explain query DELETE FROM object_relations_orders WHERE ( ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21958' ) DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21958');
0.14 ms (0.14%)	1	SELECT * FROM users WHERE `type` = ? AND id = ? Parameters: [`"user" 0`] View formatted query View runnable query Explain query SELECT * FROM users WHERE `type` = ? AND id = ? SELECT * FROM users WHERE `type` = 'user' AND id = 0;
0.12 ms (0.12%)	1	SELECT * FROM users_workspaces_asset WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_asset WHERE userId = ? SELECT * FROM users_workspaces_asset WHERE userId = 0;
0.11 ms (0.11%)	1	SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ? Parameters: [`"object" 21958`] View formatted query View runnable query Explain query SELECT id, targetType, targetId FROM dependencies WHERE sourceType = ? AND sourceId = ? SELECT id, targetType, targetId FROM dependencies WHERE sourceType= 'object' AND sourceId = 21958;
0.09 ms (0.09%)	1	SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = 1 ) AND ctype='document';
0.08 ms (0.08%)	1	SELECT * FROM users_workspaces_document WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_document WHERE userId = ? SELECT * FROM users_workspaces_document WHERE userId = 0;
0.07 ms (0.07%)	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: [`21958`] View formatted query View runnable query Explain query 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' SELECT name, type, data, cid, inheritable, cpath FROM properties WHERE ( (cid IN (1,21945,19990,5997,5996,5995) AND inheritable = 1) OR cid = 21958 ) AND ctype='object';
0.06 ms (0.06%)	1	SELECT * FROM users_workspaces_object WHERE userId = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT * FROM users_workspaces_object WHERE userId = ? SELECT * FROM users_workspaces_object WHERE userId = 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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width