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

Query Metrics

5 Database Queries
3 Different statements
12.68 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.92 ms
(94.01%)
3
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.44 ms
(3.47%)
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.32 ms
(2.52%)
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"
]

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.