POST https://sw6uhlsport-middleware.gbc.systems/ordersDispatchAjax

Response
200 OK
Browse referrer URL
IP
46.14.90.66
Profiled on
Token
a7ec40

Query Metrics

12 Database Queries
8 Different statements
67.65 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.28 ms 
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.locale AS locale_6, t0.team_shop_ids AS team_shop_ids_7, t0.address AS address_8, t0.city AS city_9, t0.telefon AS telefon_10, t0.contact_person AS contact_person_11, t0.avatar AS avatar_12, t0.name AS name_13, t0.badge_color AS badge_color_14, t0.first_name AS first_name_15, t0.last_name AS last_name_16 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  116
]
View formatted query    View runnable query    Explain query
2 0.16 ms 
SELECT t0.id AS id_1, t0.shop_name AS shop_name_2, t0.shop_owner AS shop_owner_3, t0.shop_email AS shop_email_4, t0.shop_user AS shop_user_5, t0.shop_password AS shop_password_6, t0.shop_url AS shop_url_7, t0.shop_sap_number AS shop_sap_number_8, t0.status AS status_9, t0.shop_type AS shop_type_10, t0.orders_number_range_start AS orders_number_range_start_11, t0.shop_club_number AS shop_club_number_12, t0.b2c AS b2c_13, t0.is_sending_articles_to_shop AS is_sending_articles_to_shop_14, t0.sales_organisation AS sales_organisation_15, t0.distribution_channel AS distribution_channel_16, t0.division AS division_17, t0.db_name AS db_name_18, t0.instance AS instance_19, t0.sales_channel_id AS sales_channel_id_20 FROM team_shops t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "4"
]
View formatted query    View runnable query    Explain query
3 17.19 ms 
SELECT t0.id AS id_1, t0.team_shop_id AS team_shop_id_2, t0.order_data AS order_data_3, t0.order_id AS order_id_4, t0.order_number AS order_number_5, t0.processed AS processed_6, t0.processed_date AS processed_date_7, t0.approved AS approved_8, t0.rush_order AS rush_order_9, t0.drop_shipping AS drop_shipping_10, t0.export_type AS export_type_11, t0.uhlsport_refinement AS uhlsport_refinement_12, t0.changed_date AS changed_date_13, t0.order_customer AS order_customer_14, t0.order_payment AS order_payment_15, t0.order_items AS order_items_16, t0.order_shipping AS order_shipping_17 FROM team_shop_orders t0 WHERE t0.order_id = ? LIMIT 1
Parameters: 
[
  "01980deed85771a0ae65a628cd0e97ba"
]
View formatted query    View runnable query    Explain query
4 0.23 ms 
SELECT t0.id AS id_1, t0.instance_url AS instance_url_2, t0.username AS username_3, t0.password AS password_4, t0.comment AS comment_5, t0.default_uuids AS default_uuids_6, t0.custom_fields_uuids AS custom_fields_uuids_7, t0.payments AS payments_8, t0.shipping_methods AS shipping_methods_9, t0.currencies AS currencies_10, t0.properties AS properties_11, t0.state_machines AS state_machines_12, t0.countries AS countries_13, t0.salutations AS salutations_14, t0.technical_name AS technical_name_15, t0.upstream_group AS upstream_group_16 FROM shopware_instances t0 WHERE t0.id = ? LIMIT 1
Parameters: 
[
  "4"
]
View formatted query    View runnable query    Explain query
5 23.39 ms 
SELECT t0.id AS id_1, t0.team_shop_id AS team_shop_id_2, t0.order_data AS order_data_3, t0.order_id AS order_id_4, t0.order_number AS order_number_5, t0.processed AS processed_6, t0.processed_date AS processed_date_7, t0.approved AS approved_8, t0.rush_order AS rush_order_9, t0.drop_shipping AS drop_shipping_10, t0.export_type AS export_type_11, t0.uhlsport_refinement AS uhlsport_refinement_12, t0.changed_date AS changed_date_13, t0.order_customer AS order_customer_14, t0.order_payment AS order_payment_15, t0.order_items AS order_items_16, t0.order_shipping AS order_shipping_17 FROM team_shop_orders t0 WHERE t0.order_id = ? LIMIT 1
Parameters: 
[
  "01980deed85771a0ae65a628cd0e97ba"
]
View formatted query    View runnable query    Explain query
6 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.73 ms 
UPDATE team_shop_orders SET order_data = ? WHERE id = ?
Parameters: 
[
  "{"id":"01980deed85771a0ae65a628cd0e97ba","type":"order","attributes":{"versionId":"0fa91ce3e96a4bc2be4bd9ce752c3425","autoIncrement":139,"orderNumber":"4000031","billingAddressId":"01980deed85673a18d4f3590ea8f82f3","billingAddressVersionId":"0fa91ce3e96a4bc2be4bd9ce752c3425","currencyId":"b7d2554b0ce847cd82f3ac9bd1c0dfca","languageId":"2fbb5fe2e29a4d70aa5854ce7ce3e20b","salesChannelId":"4795cac42ae8425a8a0a666866aff775","orderDateTime":"2025-07-15T11:53:33.525+00:00","orderDate":"2025-07-15T00:00:00.000+00:00","price":{"extensions":[],"netPrice":103.61,"totalPrice":112.0,"calculatedTaxes":[{"extensions":[],"tax":8.39,"taxRate":8.1,"price":112.0}],"taxRules":[{"extensions":[],"taxRate":8.1,"percentage":100.0}],"positionPrice":112.0,"taxStatus":"gross","rawTotal":112.0},"amountTotal":112.0,"amountNet":103.61,"positionPrice":112.0,"taxStatus":"gross","shippingCosts":{"extensions":[],"unitPrice":0.0,"quantity":1,"totalPrice":0.0,"calculatedTaxes":[{"extensions":[],"tax":0.0,"taxRate":8.1,"price":0.0}],"taxRules":[{"extensions":[],"taxRate":8.1,"percentage":100.0}],"referencePrice":null,"listPrice":null,"regulationPrice":null},"shippingTotal":0.0,"currencyFactor":1.0,"deepLinkCode":"qqszxyVYOG4iVw59L47rRdqRNhx84Ndl","affiliateCode":null,"campaignCode":null,"customerComment":null,"source":null,"stateId":"019145c91dbc71cea88796b999cb6303","ruleIds":["019145c91cdb729887a9d40b77caa4a5","019145c91cee71b4ae744658068ba9b1","019145c92772702388f1f0e38cd0f0d4","019145c91d367060ad6839d12b6bb82b"],"customFields":null,"createdById":null,"updatedById":"019145d3348c759090a8d759a570ba65","itemRounding":{"extensions":[],"decimals":2,"interval":0.01,"roundForNet":true},"totalRounding":{"extensions":[],"decimals":2,"interval":0.01,"roundForNet":true},"createdAt":"2025-07-15T11:53:33.583+00:00","updatedAt":"2025-08-09T09:05:49.709+00:00","apiAlias":"order_foreign_keys_extension"},"links":{"self":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba"},"relationships":{"stateMachineState":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/state-machine-state"}},"orderCustomer":{"data":{"type":"order_customer","id":"01980deed863709e97947f35cd76c6c6"},"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/order-customer"}},"currency":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/currency"}},"language":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/language"}},"salesChannel":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/sales-channel"}},"addresses":{"data":[{"type":"order_address","id":"01980deed85673a18d4f3590ea8f82f3"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/addresses"}},"billingAddress":{"data":{"type":"order_address","id":"01980deed85673a18d4f3590ea8f82f3"},"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/billing-address"}},"deliveries":{"data":[{"type":"order_delivery","id":"01980deed862709287f5953414874376"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/deliveries"}},"lineItems":{"data":[{"type":"order_line_item","id":"01980deed85673a18d4f3590e6de9c58"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e7d20499"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e7e9edeb"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e8cd2528"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e8d6ee21"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e9493d9d"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e96729c9"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e9888eff"},{"type":"order_line_item","id":"01980deed85673a18d4f3590e9f10354"},{"type":"order_line_item","id":"01980deed85673a18d4f3590ea0ca2dc"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/line-items"}},"transactions":{"data":[{"type":"order_transaction","id":"01980deed863709e97947f35ce0beca3"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/transactions"}},"documents":{"data":[],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/documents"}},"tags":{"data":[],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/tags"}},"createdBy":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/created-by"}},"updatedBy":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/01980deed85771a0ae65a628cd0e97ba\/updated-by"}}},"meta":null}"
  2861
]
View formatted query    View runnable query    Explain query
8 1.34 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 22.69 ms 
SELECT t0.id AS id_1, t0.team_shop_id AS team_shop_id_2, t0.order_data AS order_data_3, t0.order_id AS order_id_4, t0.order_number AS order_number_5, t0.processed AS processed_6, t0.processed_date AS processed_date_7, t0.approved AS approved_8, t0.rush_order AS rush_order_9, t0.drop_shipping AS drop_shipping_10, t0.export_type AS export_type_11, t0.uhlsport_refinement AS uhlsport_refinement_12, t0.changed_date AS changed_date_13, t0.order_customer AS order_customer_14, t0.order_payment AS order_payment_15, t0.order_items AS order_items_16, t0.order_shipping AS order_shipping_17 FROM team_shop_orders t0 WHERE t0.order_id = ? LIMIT 1
Parameters: 
[
  "01980deed85771a0ae65a628cd0e97ba"
]
View formatted query    View runnable query    Explain query
10 0.09 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.26 ms 
INSERT INTO user_history (user, ACTION, date, data, message, deleted) VALUES (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "Berger S+S"
  "App\Controller\FrontendControllers\OrderSummaryController::changeStatus"
  "2025-08-09 09:05:50"
  "{"shopId":"4","orderId":"01980deed85771a0ae65a628cd0e97ba","neuer Status":"019145c91dbc71cea88796b999cb6303"}"
  "["Bestellungsstatus ge\u00e4ndert"]"
  null
]
View formatted query    View runnable query    Explain query
12 1.16 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\TeamShops No errors.
App\Entity\TeamShopOrders No errors.
App\Entity\ShopwareInstances No errors.
App\Entity\UserHistory No errors.