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

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

Query Metrics

12 Database Queries
8 Different statements
59.49 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 16.92 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: 
[
  "0197f88387fe729e9a76ac9623c1fe39"
]
View formatted query    View runnable query    Explain query
4 0.27 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 19.37 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: 
[
  "0197f88387fe729e9a76ac9623c1fe39"
]
View formatted query    View runnable query    Explain query
6 0.14 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.64 ms 
UPDATE team_shop_orders SET order_data = ? WHERE id = ?
Parameters: 
[
  "{"id":"0197f88387fe729e9a76ac9623c1fe39","type":"order","attributes":{"versionId":"0fa91ce3e96a4bc2be4bd9ce752c3425","autoIncrement":133,"orderNumber":"4000029","billingAddressId":"0197f88387fd708daff033b0cf07f57f","billingAddressVersionId":"0fa91ce3e96a4bc2be4bd9ce752c3425","currencyId":"b7d2554b0ce847cd82f3ac9bd1c0dfca","languageId":"2fbb5fe2e29a4d70aa5854ce7ce3e20b","salesChannelId":"4795cac42ae8425a8a0a666866aff775","orderDateTime":"2025-07-11T08:04:19.068+00:00","orderDate":"2025-07-11T00:00:00.000+00:00","price":{"extensions":[],"netPrice":148.93,"totalPrice":161.0,"calculatedTaxes":[{"extensions":[],"tax":12.07,"taxRate":8.1,"price":161.0}],"taxRules":[{"extensions":[],"taxRate":8.1,"percentage":100.0}],"positionPrice":161.0,"taxStatus":"gross","rawTotal":161.0},"amountTotal":161.0,"amountNet":148.93,"positionPrice":161.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":"wiUQ3LIAwKkRf8KqFliRLmb39drfFndT","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-11T08:04:19.120+00:00","updatedAt":"2025-08-09T09:05:44.186+00:00","apiAlias":"order_foreign_keys_extension"},"links":{"self":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39"},"relationships":{"stateMachineState":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/state-machine-state"}},"orderCustomer":{"data":{"type":"order_customer","id":"0197f883880a729392de3576b9b00bad"},"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/order-customer"}},"currency":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/currency"}},"language":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/language"}},"salesChannel":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/sales-channel"}},"addresses":{"data":[{"type":"order_address","id":"0197f88387fd708daff033b0cf07f57f"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/addresses"}},"billingAddress":{"data":{"type":"order_address","id":"0197f88387fd708daff033b0cf07f57f"},"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/billing-address"}},"deliveries":{"data":[{"type":"order_delivery","id":"0197f88388097140861758ff567fd784"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/deliveries"}},"lineItems":{"data":[{"type":"order_line_item","id":"0197f88387fd708daff033b0c89ac8ac"},{"type":"order_line_item","id":"0197f88387fd708daff033b0c9917594"},{"type":"order_line_item","id":"0197f88387fd708daff033b0c9c3561a"},{"type":"order_line_item","id":"0197f88387fd708daff033b0ca68e76f"},{"type":"order_line_item","id":"0197f88387fd708daff033b0cb11dbd9"},{"type":"order_line_item","id":"0197f88387fd708daff033b0cbe2dcd4"},{"type":"order_line_item","id":"0197f88387fd708daff033b0ccb20a4b"},{"type":"order_line_item","id":"0197f88387fd708daff033b0cccc530e"},{"type":"order_line_item","id":"0197f88387fd708daff033b0ccf6f990"},{"type":"order_line_item","id":"0197f88387fd708daff033b0cd34c8fe"},{"type":"order_line_item","id":"0197f88387fd708daff033b0cda55017"},{"type":"order_line_item","id":"0197f88387fd708daff033b0cdea415b"},{"type":"order_line_item","id":"0197f88387fd708daff033b0ce29eef7"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/line-items"}},"transactions":{"data":[{"type":"order_transaction","id":"0197f883880a729392de3576b9d2b255"}],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/transactions"}},"documents":{"data":[],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/documents"}},"tags":{"data":[],"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/tags"}},"createdBy":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/created-by"}},"updatedBy":{"data":null,"links":{"related":"https:\/\/srv1c.sw6uhlsport-clubshops2.gbc.systems\/api\/order\/0197f88387fe729e9a76ac9623c1fe39\/updated-by"}}},"meta":null}"
  2735
]
View formatted query    View runnable query    Explain query
8 4.09 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 16.29 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: 
[
  "0197f88387fe729e9a76ac9623c1fe39"
]
View formatted query    View runnable query    Explain query
10 0.13 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.22 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:45"
  "{"shopId":"4","orderId":"0197f88387fe729e9a76ac9623c1fe39","neuer Status":"019145c91dbc71cea88796b999cb6303"}"
  "["Bestellungsstatus ge\u00e4ndert"]"
  null
]
View formatted query    View runnable query    Explain query
12 0.98 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.