GET https://sw6uhlsport-middleware.gbc.systems/order_summary/20/approve

Query Metrics

56 Database Queries
5 Different statements
737.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
733.26 ms
(99.41%)
52
SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.shop_id AS shop_id_6, t0.editable AS editable_7, t0.comment AS comment_8, t0.user AS user_9, t0.upload_date AS upload_date_10, t0.article_to_shop_id AS article_to_shop_id_11, t0.order_number AS order_number_12, t0.order_line_uuid AS order_line_uuid_13 FROM media t0 WHERE t0.shop_id = ? AND t0.order_number = ?
Parameters:
[
  20
  "20000052"
]
3.41 ms
(0.46%)
1
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.team_shop_id = ? ORDER BY t0.order_number DESC
Parameters:
[
  20
]
0.51 ms
(0.07%)
1
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:
[
  143
]
0.26 ms
(0.04%)
1
SELECT t0_.id AS id_0, t0_.shop_name AS shop_name_1, t0_.shop_owner AS shop_owner_2, t0_.shop_email AS shop_email_3, t0_.shop_user AS shop_user_4, t0_.shop_password AS shop_password_5, t0_.shop_url AS shop_url_6, t0_.shop_sap_number AS shop_sap_number_7, t0_.status AS status_8, t0_.shop_type AS shop_type_9, t0_.orders_number_range_start AS orders_number_range_start_10, t0_.shop_club_number AS shop_club_number_11, t0_.b2c AS b2c_12, t0_.is_sending_articles_to_shop AS is_sending_articles_to_shop_13, t0_.sales_organisation AS sales_organisation_14, t0_.distribution_channel AS distribution_channel_15, t0_.division AS division_16, t0_.db_name AS db_name_17, t0_.instance AS instance_18, t0_.sales_channel_id AS sales_channel_id_19 FROM team_shops t0_ WHERE t0_.id IN (?, ?, ?)
Parameters:
[
  "20"
  "130"
  "222"
]
0.20 ms
(0.03%)
1
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:
[
  "2"
]

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\Media No errors.
App\Entity\ShopwareInstances No errors.