Query Metrics
258
Database Queries
71
Different statements
83.92 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.33 ms (24.23%) |
63 |
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:
[ 1781795564 "site_domain_367af465ca304630cf45a2132778bed1" ] |
|
4.02 ms (4.79%) |
10 |
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:
[
21960
]
|
|
3.54 ms (4.22%) |
22 |
INSERT INTO object_relations_orders (`dest_id`, `type`, `fieldname`, `src_id`, `ownertype`, `ownername`, `position`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 18286 "object" "product" 21960 "fieldcollection" "lineItems" "0" ] |
|
2.39 ms (2.84%) |
11 |
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:
[ 1781795565 "object_18286\x01tags\x01" "class_product\x01tags\x01" "asset_931\x01tags\x01" "asset_932\x01tags\x01" ] |
|
2.35 ms (2.80%) |
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:
[] |
|
2.25 ms (2.69%) |
9 |
SELECT * FROM object_store_product WHERE oo_id = ? FOR UPDATE
Parameters:
[
18286
]
|
|
2.22 ms (2.65%) |
10 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
21960
]
|
|
2.22 ms (2.64%) |
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:
[ 1781795564 "system\x01tags\x01" "site\x01tags\x01" ] |
|
2.20 ms (2.62%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3774' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
2.18 ms (2.59%) |
22 |
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" ] |
|
2.09 ms (2.49%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2816' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.71 ms (2.04%) |
11 |
INSERT INTO object_collection_LineItems_orders (`id`, `index`, `fieldname`, `title`, `sku`, `quantity`, `price__value`, `price__unit`, `fulfillmentStatus`, `taxable`, `metaData`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 21960 0 "lineItems" "Reinigungsmittel Milchschäumer" "2816" 4.0 17.5 "CHF" "fulfilled" 0 "[]" ] |
|
1.68 ms (2.00%) |
2 |
INSERT INTO object_collection_ShopifyPayload_orders (`id`, `index`, `fieldname`, `payload`, `topic`, `createdAt`) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 21960 0 "payload" "{"id":8043605492050,"admin_graphql_api_id":"gid:\/\/shopify\/Order\/8043605492050","app_id":580111,"browser_ip":"178.197.223.153","buyer_accepts_marketing":false,"cancel_reason":null,"cancelled_at":null,"cart_token":"hWNDTqkzeDpaCuSTUIIU7uc7","checkout_id":48585939321170,"checkout_token":"143925d4b8249554bb7ee6225ee4a6b2","client_details":{"accept_language":"de-CH","browser_height":null,"browser_ip":"178.197.223.153","browser_width":null,"session_hash":null,"user_agent":"Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Mobile Safari\/537.36"},"closed_at":"2026-06-18T15:14:05+02:00","company":null,"confirmation_number":"MN8904CDA","confirmed":true,"contact_email":"bb-gastrobetriebe@bluewin.ch","created_at":"2026-06-18T13:57:14+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":"676.04","current_subtotal_price_set":{"shop_money":{"amount":"676.04","currency_code":"CHF"},"presentment_money":{"amount":"676.04","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":"676.04","current_total_price_set":{"shop_money":{"amount":"676.04","currency_code":"CHF"},"presentment_money":{"amount":"676.04","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":"bb-gastrobetriebe@bluewin.ch","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":"#1512","note":"Tour 18 ","note_attributes":[],"number":512,"order_number":1512,"order_status_url":"https:\/\/shop.myleomat.ch\/99699687762\/orders\/9f941d3c2f65b456c2db606aed58cf59\/authenticate?key=f0a8aac7c7b8bba0eaabdfdd05ff257f","original_total_additional_fees_set":null,"original_total_duties_set":null,"payment_gateway_names":["Kauf auf Rechnung (Invoice)"],"phone":null,"po_number":null,"presentment_currency":"CHF","processed_at":"2026-06-18T13:57:12+02:00","reference":null,"referring_site":null,"source_identifier":null,"source_name":"web","source_url":null,"subtotal_price":"676.04","subtotal_price_set":{"shop_money":{"amount":"676.04","currency_code":"CHF"},"presentment_money":{"amount":"676.04","currency_code":"CHF"}},"tags":"leomat-erp-status:processed","tax_exempt":false,"tax_lines":[],"taxes_included":true,"test":false,"token":"9f941d3c2f65b456c2db606aed58cf59","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":"676.04","total_line_items_price_set":{"shop_money":{"amount":"676.04","currency_code":"CHF"},"presentment_money":{"amount":"676.04","currency_code":"CHF"}},"total_outstanding":"0.00","total_price":"676.04","total_price_set":{"shop_money":{"amount":"676.04","currency_code":"CHF"},"presentment_money":{"amount":"676.04","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:42+02:00","user_id":null,"billing_address":{"first_name":"Karin","address1":"Amriswilerstrasse 72","phone":null,"city":"Sitterdorf","zip":"8589","province":null,"country":"Switzerland","last_name":"Böniger","address2":null,"company":null,"latitude":47.5037526,"longitude":9.247883999999999,"name":"Karin Böniger","country_code":"CH","province_code":null},"customer":{"id":10155364974930,"created_at":"2026-03-19T06:44:55+01:00","updated_at":"2026-06-18T15:14:08+02:00","first_name":null,"last_name":"914330000","state":"enabled","note":null,"verified_email":true,"multipass_identifier":null,"tax_exempt":false,"email":"bb-gastrobetriebe@bluewin.ch","phone":null,"currency":"CHF","tax_exemptions":[],"admin_graphql_api_id":"gid:\/\/shopify\/Customer\/10155364974930","default_address":{"id":12613076287826,"customer_id":10155364974930,"first_name":"Karin","last_name":"Böniger","company":null,"address1":"Amriswilerstrasse 72","address2":null,"city":"Sitterdorf","province":null,"country":"Switzerland","zip":"8589","phone":null,"name":"Karin Böniger","province_code":null,"country_code":"CH","country_name":"Switzerland","default":true}},"discount_applications":[],"fulfillments":[{"id":7007050531154,"admin_graphql_api_id":"gid:\/\/shopify\/Fulfillment\/7007050531154","created_at":"2026-06-18T15:14:04+02:00","location_id":113214685522,"name":"#1512.1","order_id":8043605492050,"origin_address":{},"receipt":{},"service":"manual","shipment_status":null,"status":"success","tracking_company":null,"tracking_number":null,"tracking_numbers":[],"tracking_url":null,"tracking_urls":[],"updated_at":"2026-06-18T15:14:04+02:00","line_items":[{"id":18745720897874,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720897874","attributed_staffs":[],"current_quantity":4,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Reinigungsmittel Milchschäumer","price":"17.50","price_set":{"shop_money":{"amount":"17.50","currency_code":"CHF"},"presentment_money":{"amount":"17.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687823446354,"properties":[],"quantity":4,"requires_shipping":true,"sku":"2816","taxable":true,"title":"Reinigungsmittel Milchschäumer","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":53072865952082,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745720930642,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720930642","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Automatenbecher \"Hybrid\" 1,8 Dl","price":"179.00","price_set":{"shop_money":{"amount":"179.00","currency_code":"CHF"},"presentment_money":{"amount":"179.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687908020562,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3716","taxable":true,"title":"Automatenbecher \"Hybrid\" 1,8 Dl","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073162633554,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745720963410,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720963410","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Vollmilch Uht 3.5% (8X1.5L)","price":"17.54","price_set":{"shop_money":{"amount":"17.54","currency_code":"CHF"},"presentment_money":{"amount":"17.54","currency_code":"CHF"}},"product_exists":true,"product_id":10687803687250,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2396","taxable":true,"title":"Vollmilch Uht 3.5% (8X1.5L)","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072776724818,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745720996178,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720996178","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Fleischkäse","price":"40.00","price_set":{"shop_money":{"amount":"40.00","currency_code":"CHF"},"presentment_money":{"amount":"40.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687784059218,"properties":[],"quantity":1,"requires_shipping":true,"sku":"2097","taxable":true,"title":"Fleischkäse","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072728654162,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721028946,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721028946","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Baked Pretzel Salt 40G","price":"36.50","price_set":{"shop_money":{"amount":"36.50","currency_code":"CHF"},"presentment_money":{"amount":"36.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687897370962,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3585","taxable":true,"title":"Baked Pretzel Salt 40G","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":53073116660050,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721061714,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721061714","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Bauli Schoko Croissant","price":"13.60","price_set":{"shop_money":{"amount":"13.60","currency_code":"CHF"},"presentment_money":{"amount":"13.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687755092306,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1263","taxable":true,"title":"Bauli Schoko Croissant","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072652566866,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721094482,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721094482","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Monday Energy Dose 25Cl","price":"36.50","price_set":{"shop_money":{"amount":"36.50","currency_code":"CHF"},"presentment_money":{"amount":"36.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687772492114,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1907","taxable":true,"title":"Monday Energy Dose 25Cl","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072683336018,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721127250,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721127250","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687912771922,"properties":[],"quantity":1,"requires_shipping":true,"sku":"3774","taxable":true,"title":"Coca-Cola 5Dl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073191960914,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721160018,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721160018","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":18745721192786,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721192786","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kakao Aktiv Zuckerreduziert","price":"112.50","price_set":{"shop_money":{"amount":"112.50","currency_code":"CHF"},"presentment_money":{"amount":"112.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687759778130,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1520","taxable":true,"title":"Kakao Aktiv Zuckerreduziert","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072660693330,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721225554,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721225554","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Leomat Café-Creamer Rahmig","price":"93.60","price_set":{"shop_money":{"amount":"93.60","currency_code":"CHF"},"presentment_money":{"amount":"93.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687776293202,"properties":[],"quantity":1,"requires_shipping":true,"sku":"1986","taxable":true,"title":"Leomat Café-Creamer Rahmig","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072702308690,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}]}],"line_items":[{"id":18745720897874,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720897874","attributed_staffs":[],"current_quantity":4,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Reinigungsmittel Milchschäumer","price":"17.50","price_set":{"shop_money":{"amount":"17.50","currency_code":"CHF"},"presentment_money":{"amount":"17.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687823446354,"properties":[],"quantity":4,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2816","taxable":true,"title":"Reinigungsmittel Milchschäumer","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":53072865952082,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745720930642,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720930642","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Automatenbecher \"Hybrid\" 1,8 Dl","price":"179.00","price_set":{"shop_money":{"amount":"179.00","currency_code":"CHF"},"presentment_money":{"amount":"179.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687908020562,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3716","taxable":true,"title":"Automatenbecher \"Hybrid\" 1,8 Dl","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073162633554,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745720963410,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720963410","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Vollmilch Uht 3.5% (8X1.5L)","price":"17.54","price_set":{"shop_money":{"amount":"17.54","currency_code":"CHF"},"presentment_money":{"amount":"17.54","currency_code":"CHF"}},"product_exists":true,"product_id":10687803687250,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2396","taxable":true,"title":"Vollmilch Uht 3.5% (8X1.5L)","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072776724818,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745720996178,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745720996178","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Fleischkäse","price":"40.00","price_set":{"shop_money":{"amount":"40.00","currency_code":"CHF"},"presentment_money":{"amount":"40.00","currency_code":"CHF"}},"product_exists":true,"product_id":10687784059218,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"2097","taxable":true,"title":"Fleischkäse","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072728654162,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721028946,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721028946","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Baked Pretzel Salt 40G","price":"36.50","price_set":{"shop_money":{"amount":"36.50","currency_code":"CHF"},"presentment_money":{"amount":"36.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687897370962,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3585","taxable":true,"title":"Baked Pretzel Salt 40G","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":53073116660050,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721061714,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721061714","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Bauli Schoko Croissant","price":"13.60","price_set":{"shop_money":{"amount":"13.60","currency_code":"CHF"},"presentment_money":{"amount":"13.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687755092306,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1263","taxable":true,"title":"Bauli Schoko Croissant","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072652566866,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721094482,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721094482","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Monday Energy Dose 25Cl","price":"36.50","price_set":{"shop_money":{"amount":"36.50","currency_code":"CHF"},"presentment_money":{"amount":"36.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687772492114,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1907","taxable":true,"title":"Monday Energy Dose 25Cl","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072683336018,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721127250,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721127250","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Coca-Cola 5Dl Pet","price":"38.40","price_set":{"shop_money":{"amount":"38.40","currency_code":"CHF"},"presentment_money":{"amount":"38.40","currency_code":"CHF"}},"product_exists":true,"product_id":10687912771922,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"3774","taxable":true,"title":"Coca-Cola 5Dl Pet","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53073191960914,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721160018,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721160018","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":18745721192786,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721192786","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Kakao Aktiv Zuckerreduziert","price":"112.50","price_set":{"shop_money":{"amount":"112.50","currency_code":"CHF"},"presentment_money":{"amount":"112.50","currency_code":"CHF"}},"product_exists":true,"product_id":10687759778130,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1520","taxable":true,"title":"Kakao Aktiv Zuckerreduziert","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072660693330,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]},{"id":18745721225554,"admin_graphql_api_id":"gid:\/\/shopify\/LineItem\/18745721225554","attributed_staffs":[],"current_quantity":1,"fulfillable_quantity":0,"fulfillment_service":"manual","fulfillment_status":"fulfilled","gift_card":false,"grams":0,"name":"Leomat Café-Creamer Rahmig","price":"93.60","price_set":{"shop_money":{"amount":"93.60","currency_code":"CHF"},"presentment_money":{"amount":"93.60","currency_code":"CHF"}},"product_exists":true,"product_id":10687776293202,"properties":[],"quantity":1,"requires_shipping":true,"sales_line_item_group_id":null,"sku":"1986","taxable":true,"title":"Leomat Café-Creamer Rahmig","total_discount":"0.00","total_discount_set":{"shop_money":{"amount":"0.00","currency_code":"CHF"},"presentment_money":{"amount":"0.00","currency_code":"CHF"}},"variant_id":53072702308690,"variant_inventory_management":null,"variant_title":null,"vendor":"Leomat","tax_lines":[],"duties":[],"discount_allocations":[]}],"payment_terms":null,"refunds":[],"shipping_address":null,"shipping_lines":[{"id":6259622314322,"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:45" ] |
|
1.65 ms (1.96%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1520' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.61 ms (1.92%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3716' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.60 ms (1.90%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2097' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.56 ms (1.86%) |
1 |
DELETE FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 21960 "payload" ] |
|
1.47 ms (1.75%) |
1 |
SELECT * FROM object_collection_ShopifyPayload_orders WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 21960 "payload" ] |
|
1.39 ms (1.66%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '3585' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.28 ms (1.52%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '2396' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
1.25 ms (1.50%) |
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/" 21960 1781783837 1781795565 10 0 0 21945 "object" "1512" 0 null null "orders" 1 "Orders" ] |
|
1.24 ms (1.48%) |
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 => 1781795565 0 => "system_cache_write_lock" 1 => b"O:1:"©":1:{s:6:"„gö\x07À\x1E";i:1781795565;}" ] |
|
1.10 ms (1.31%) |
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:
[] |
|
1.08 ms (1.29%) |
2 |
SELECT CONCAT(`path`,`key`) as `path` FROM objects WHERE id = ?
Parameters:
[
21945
]
|
|
1.05 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` = '1907' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.94 ms (1.12%) |
1 |
SELECT object_shopifyconfig.id as id, object_shopifyconfig.type as `type` FROM object_shopifyconfig WHERE (active = 1 AND object_shopifyconfig.type IN ('object','variant','folder')) AND object_shopifyconfig.published = 1
Parameters:
[] |
|
0.90 ms (1.08%) |
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:
[
8043605492050
]
|
|
0.87 ms (1.04%) |
1 |
SELECT MAX(versionCount) FROM versions WHERE cid = ? AND ctype = 'object'
Parameters:
[
21960
]
|
|
0.84 ms (1.01%) |
1 |
SHOW COLUMNS FROM versions
Parameters:
[] |
|
0.81 ms (0.97%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'lineItems' AND src_id = '21960')
Parameters:
[] |
|
0.81 ms (0.97%) |
1 |
SHOW COLUMNS FROM object_store_orders
Parameters:
[] |
|
0.77 ms (0.92%) |
1 |
SHOW COLUMNS FROM objects
Parameters:
[] |
|
0.77 ms (0.92%) |
9 |
SELECT * FROM object_relations_product WHERE src_id = ?
Parameters:
[
18286
]
|
|
0.74 ms (0.88%) |
1 |
SELECT object_localized_product_de.id as id, object_localized_product_de.type as `type` FROM object_localized_product_de WHERE (`sku` = '1263' AND object_localized_product_de.type IN ('variant','object')) AND object_localized_product_de.published = 1 LIMIT 1
Parameters:
[] |
|
0.73 ms (0.86%) |
1 |
DELETE FROM object_collection_LineItems_orders WHERE id = ? AND fieldname = ?
Parameters:
[ 21960 "lineItems" ] |
|
0.66 ms (0.78%) |
1 |
INSERT INTO object_store_orders (`oo_id`, `orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 21960 8043605492050.0 "1512" "paid" 676.04 "CHF" "bb-gastrobetriebe@bluewin.ch" "2026-06-18 13:57:14" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1512",\n "ExternalOrderReference": "9c0c74ca-3fa2-4fc6-97a7-c57347f555de",\n "ExternalOrderNumber": 512,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 676.04,\n "TotalAmountExcludingTax": 676.04\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 4,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.5,\n "PerQuantityIncludingTax": 17.5,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 17.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2816,\n "Type": "A",\n "Name": "13303",\n "Description": "Reinigungsmittel Milchschäumer"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 40,\n "PerQuantityIncludingTax": 40,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 40,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2097,\n "Type": "A",\n "Name": "11842",\n "Description": "Fleischkäse"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3585,\n "Type": "A",\n "Name": "17408",\n "Description": "Baked Pretzel Salt 40G"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 13.6,\n "PositionTotalIncludingTax": 13.6,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1907,\n "Type": "A",\n "Name": "13877",\n "Description": "Monday Energy Dose 25Cl"\n }\n },\n {\n "LineItemId": 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": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "f1fe27d3-2f30-0971-e782-9b44318546a9",\n "Account": ""\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n }\n },\n "_status_sync": {\n "erp_status": "processed",\n "erp_updated_at": "2026-06-18T15:00:03+00:00",\n "erp_status_source": "leomat_xlsx"\n }\n } """ ] |
|
0.63 ms (0.76%) |
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/" 21960 1781783837 1781795565 10 0 0 21945 "object" "1512" 0 null null "orders" 1 "Orders" 21960 ] |
|
0.62 ms (0.74%) |
9 |
SELECT * FROM object_localized_data_product WHERE ooo_id = ? AND language IN ('de','fr')
Parameters:
[
18286
]
|
|
0.55 ms (0.65%) |
1 |
INSERT INTO object_query_orders (`orderId`, `orderNumber`, `status`, `totalPrice__value`, `totalPrice__unit`, `customerEmail`, `createdAt`, `abacusOrderId`, `abacusStatus`, `sentToAbacus`, `abacusPayload`, `oo_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 8043605492050.0 "1512" "paid" 676.04 "CHF" "bb-gastrobetriebe@bluewin.ch" "2026-06-18 13:57:14" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1512",\n "ExternalOrderReference": "9c0c74ca-3fa2-4fc6-97a7-c57347f555de",\n "ExternalOrderNumber": 512,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 676.04,\n "TotalAmountExcludingTax": 676.04\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 4,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.5,\n "PerQuantityIncludingTax": 17.5,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 17.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2816,\n "Type": "A",\n "Name": "13303",\n "Description": "Reinigungsmittel Milchschäumer"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 40,\n "PerQuantityIncludingTax": 40,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 40,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2097,\n "Type": "A",\n "Name": "11842",\n "Description": "Fleischkäse"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3585,\n "Type": "A",\n "Name": "17408",\n "Description": "Baked Pretzel Salt 40G"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 13.6,\n "PositionTotalIncludingTax": 13.6,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1907,\n "Type": "A",\n "Name": "13877",\n "Description": "Monday Energy Dose 25Cl"\n }\n },\n {\n "LineItemId": 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": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "f1fe27d3-2f30-0971-e782-9b44318546a9",\n "Account": ""\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\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 } """ 21960 ] |
|
0.51 ms (0.61%) |
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:
[ 21960 8043605492050.0 "1512" "paid" 676.04 "CHF" "bb-gastrobetriebe@bluewin.ch" "2026-06-18 13:57:14" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1512",\n "ExternalOrderReference": "9c0c74ca-3fa2-4fc6-97a7-c57347f555de",\n "ExternalOrderNumber": 512,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 676.04,\n "TotalAmountExcludingTax": 676.04\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 4,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.5,\n "PerQuantityIncludingTax": 17.5,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 17.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2816,\n "Type": "A",\n "Name": "13303",\n "Description": "Reinigungsmittel Milchschäumer"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 40,\n "PerQuantityIncludingTax": 40,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 40,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2097,\n "Type": "A",\n "Name": "11842",\n "Description": "Fleischkäse"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3585,\n "Type": "A",\n "Name": "17408",\n "Description": "Baked Pretzel Salt 40G"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 13.6,\n "PositionTotalIncludingTax": 13.6,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1907,\n "Type": "A",\n "Name": "13877",\n "Description": "Monday Energy Dose 25Cl"\n }\n },\n {\n "LineItemId": 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": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "f1fe27d3-2f30-0971-e782-9b44318546a9",\n "Account": ""\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\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 } """ 21960 ] |
|
0.50 ms (0.60%) |
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:
[ 8043605492050.0 "1512" "paid" 676.04 "CHF" "bb-gastrobetriebe@bluewin.ch" "2026-06-18 13:57:14" null "processed" 1 """ {\n "InboxOrderRequest": {\n "Comment": "#1512",\n "ExternalOrderReference": "9c0c74ca-3fa2-4fc6-97a7-c57347f555de",\n "ExternalOrderNumber": 512,\n "CreationDate": "2026-06-18",\n "Language": "de",\n "DeliveryMethodName": "3",\n "TaxType": "Included",\n "AdditionalInfoList": [],\n "Summary": {\n "CurrencyId": "CHF",\n "TotalAmountIncludingTax": 676.04,\n "TotalAmountExcludingTax": 676.04\n },\n "IsGuest": false,\n "PositionList": [\n {\n "LineItemId": 1,\n "Quantity": 4,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.5,\n "PerQuantityIncludingTax": 17.5,\n "PositionTotalExcludingTax": 70,\n "PositionTotalIncludingTax": 70,\n "PerQuantityExcludingTaxRelevant": 17.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2816,\n "Type": "A",\n "Name": "13303",\n "Description": "Reinigungsmittel Milchschäumer"\n }\n },\n {\n "LineItemId": 2,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 179,\n "PerQuantityIncludingTax": 179,\n "PositionTotalExcludingTax": 179,\n "PositionTotalIncludingTax": 179,\n "PerQuantityExcludingTaxRelevant": 179,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3716,\n "Type": "A",\n "Name": "17512",\n "Description": "Automatenbecher \"Hybrid\" 1,8 Dl"\n }\n },\n {\n "LineItemId": 3,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 17.54,\n "PerQuantityIncludingTax": 17.54,\n "PositionTotalExcludingTax": 17.54,\n "PositionTotalIncludingTax": 17.54,\n "PerQuantityExcludingTaxRelevant": 17.54,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2396,\n "Type": "A",\n "Name": "14370",\n "Description": "Vollmilch Uht 3.5% (8X1.5L)"\n }\n },\n {\n "LineItemId": 4,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 40,\n "PerQuantityIncludingTax": 40,\n "PositionTotalExcludingTax": 40,\n "PositionTotalIncludingTax": 40,\n "PerQuantityExcludingTaxRelevant": 40,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 2097,\n "Type": "A",\n "Name": "11842",\n "Description": "Fleischkäse"\n }\n },\n {\n "LineItemId": 5,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3585,\n "Type": "A",\n "Name": "17408",\n "Description": "Baked Pretzel Salt 40G"\n }\n },\n {\n "LineItemId": 6,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 13.6,\n "PerQuantityIncludingTax": 13.6,\n "PositionTotalExcludingTax": 13.6,\n "PositionTotalIncludingTax": 13.6,\n "PerQuantityExcludingTaxRelevant": 13.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1263,\n "Type": "A",\n "Name": "13366",\n "Description": "Bauli Schoko Croissant"\n }\n },\n {\n "LineItemId": 7,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 36.5,\n "PerQuantityIncludingTax": 36.5,\n "PositionTotalExcludingTax": 36.5,\n "PositionTotalIncludingTax": 36.5,\n "PerQuantityExcludingTaxRelevant": 36.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1907,\n "Type": "A",\n "Name": "13877",\n "Description": "Monday Energy Dose 25Cl"\n }\n },\n {\n "LineItemId": 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": 3774,\n "Type": "A",\n "Name": "17620",\n "Description": "Coca-Cola 5Dl Pet"\n }\n },\n {\n "LineItemId": 9,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 38.4,\n "PerQuantityIncludingTax": 38.4,\n "PositionTotalExcludingTax": 38.4,\n "PositionTotalIncludingTax": 38.4,\n "PerQuantityExcludingTaxRelevant": 38.4,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 3776,\n "Type": "A",\n "Name": "17622",\n "Description": "Coca-Cola Zero 5Dl Pet"\n }\n },\n {\n "LineItemId": 10,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 112.5,\n "PerQuantityIncludingTax": 112.5,\n "PositionTotalExcludingTax": 112.5,\n "PositionTotalIncludingTax": 112.5,\n "PerQuantityExcludingTaxRelevant": 112.5,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1520,\n "Type": "A",\n "Name": "13728",\n "Description": "Kakao Aktiv Zuckerreduziert"\n }\n },\n {\n "LineItemId": 11,\n "Quantity": 1,\n "PriceInfo": {\n "PriceFromApi": false,\n "PerQuantityExcludingTax": 93.6,\n "PerQuantityIncludingTax": 93.6,\n "PositionTotalExcludingTax": 93.6,\n "PositionTotalIncludingTax": 93.6,\n "PerQuantityExcludingTaxRelevant": 93.6,\n "CurrencyId": "CHF",\n "TaxInfo": {\n "Code": 312,\n "CodeAsString": "312",\n "Rate": 0,\n "Amount": 0\n }\n },\n "Product": {\n "Id": 1986,\n "Type": "A",\n "Name": "12155",\n "Description": "Leomat Café-Creamer Rahmig"\n }\n }\n ],\n "CustomerSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "PaymentSubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\n },\n "ShippingHandlingList": [],\n "Shopper": {\n "Id": "f1fe27d3-2f30-0971-e782-9b44318546a9",\n "Account": ""\n },\n "DeliverySubject": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "CompanyName": "",\n "DateOfBirth": "1900-01-01",\n "Contact": {\n "Salutation": "",\n "FirstName": "Karin",\n "Name": "Böniger",\n "DateOfBirth": "1900-01-01",\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n }\n },\n "Address": {\n "Street": "Amriswilerstrasse",\n "HouseNumber": "72",\n "PostCode": "8589",\n "City": "Sitterdorf",\n "CountryId": "CH"\n },\n "Communication": {\n "Phone": "",\n "Email": "bb-gastrobetriebe@bluewin.ch"\n },\n "Id": 871200\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 } """ 21960 21960 ] |
|
0.49 ms (0.58%) |
1 |
SHOW COLUMNS FROM object_query_orders
Parameters:
[] |
|
0.48 ms (0.57%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.46 ms (0.55%) |
1 |
INSERT INTO versions (`id`, `cid`, `ctype`, `userId`, `note`, `date`, `public`, `serialized`, `stackTrace`, `versionCount`, `binaryFileHash`, `binaryFileId`, `autoSave`, `storageType`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null 21960 "object" 0 "" 1781795565 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} """ 10 null null 0 "fs" ] |
|
0.43 ms (0.51%) |
5 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/webhook/shopify/leomat/" "order" ] |
|
0.40 ms (0.48%) |
1 |
SELECT * FROM object_relations_orders WHERE src_id = ?
Parameters:
[
21960
]
|
|
0.37 ms (0.44%) |
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:21960;}}" "[]" "pimcore_search_backend_message" "2026-06-18 15:12:45" "2026-06-18 15:12:45" ] |
|
0.35 ms (0.41%) |
1 |
SELECT `id` FROM `object_collection_ShopifyPayload_orders` WHERE `id` = '21960' AND `fieldname` = 'payload' LIMIT 1
Parameters:
[] |
|
0.25 ms (0.30%) |
1 |
SELECT versionCount FROM objects WHERE id = ? FOR UPDATE
Parameters:
[
21960
]
|
|
0.24 ms (0.28%) |
1 |
SELECT `id` FROM `object_collection_LineItems_orders` WHERE `id` = '21960' AND `fieldname` = 'lineItems' LIMIT 1
Parameters:
[] |
|
0.22 ms (0.26%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'fieldcollection' AND ownername = 'payload' AND src_id = '21960')
Parameters:
[] |
|
0.21 ms (0.25%) |
1 |
SELECT * FROM object_query_orders WHERE oo_id = ?
Parameters:
[
21960
]
|
|
0.21 ms (0.25%) |
2 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Orders/Leomat/2026/06/18/" "1512" ] |
|
0.21 ms (0.25%) |
1 |
DELETE FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ "object_21960\x01tags\x01" "object_properties\x01tags\x01" ] |
|
0.21 ms (0.25%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.21 ms (0.24%) |
2 |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"orders"
]
|
|
0.18 ms (0.22%) |
1 |
DELETE FROM tree_locks WHERE id = ? AND type = ?
Parameters:
[ 21960 "object" ] |
|
0.18 ms (0.22%) |
1 |
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[ "user" 0 ] |
|
0.18 ms (0.21%) |
1 |
SELECT * FROM object_store_orders WHERE oo_id = ? FOR UPDATE
Parameters:
[
21960
]
|
|
0.18 ms (0.21%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/webhook/shopify/leomat/order"
]
|
|
0.18 ms (0.21%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~lineItems/%' AND src_id = '21960')
Parameters:
[] |
|
0.17 ms (0.20%) |
1 |
DELETE FROM object_relations_orders WHERE (ownertype = 'localizedfield' AND ownername LIKE '/fieldcollection~payload/%' AND src_id = '21960')
Parameters:
[] |
|
0.17 ms (0.20%) |
1 |
SELECT type,classId,className FROM objects WHERE id = ?
Parameters:
[
21960
]
|
|
0.15 ms (0.18%) |
1 |
SELECT id, targetType, targetId FROM dependencies WHERE sourceType= ? AND sourceId = ?
Parameters:
[ "object" 21960 ] |
|
0.14 ms (0.17%) |
1 |
DELETE FROM schedule_tasks WHERE `cid` = 21960 AND `ctype` = 'object'
Parameters:
[] |
|
0.10 ms (0.12%) |
1 |
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
0
]
|
|
0.09 ms (0.11%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
|
0.09 ms (0.11%) |
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:
[
21960
]
|
|
0.09 ms (0.11%) |
1 |
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
0
]
|
|
0.09 ms (0.10%) |
1 |
SELECT id FROM schedule_tasks WHERE `cid` = ? AND `ctype` = ?
Parameters:
[ 21960 "object" ] |
|
0.08 ms (0.09%) |
1 |
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
0
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
No managed entities.
Entities Mapping
No mapped entities.