https://avocadostore-ordersync.kaipara.de/avocadostore/order_export_webhook/1

Query Metrics

3 Database Queries
2 Different statements
3.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.20 ms
(66.19%)
2
SELECT t0.id AS id_1, t0.synced AS synced_2, t0.avocadostore_order_id AS avocadostore_order_id_3, t0.purchase_date AS purchase_date_4, t0.payment_date AS payment_date_5, t0.buyer_name AS buyer_name_6, t0.currency AS currency_7, t0.shipping_price AS shipping_price_8, t0.shipping_tax AS shipping_tax_9, t0.shipping_service_level AS shipping_service_level_10, t0.recipient_name AS recipient_name_11, t0.ship_address1 AS ship_address1_12, t0.ship_address2 AS ship_address2_13, t0.ship_city AS ship_city_14, t0.ship_postal_code AS ship_postal_code_15, t0.ship_country AS ship_country_16, t0.bill_address1 AS bill_address1_17, t0.bill_address2 AS bill_address2_18, t0.bill_city AS bill_city_19, t0.bill_postal_code AS bill_postal_code_20, t0.bill_country AS bill_country_21, t0.ship_address_additional AS ship_address_additional_22, t0.ship_address_street AS ship_address_street_23, t0.ship_address_no AS ship_address_no_24, t0.bill_address_additional AS bill_address_additional_25, t0.bill_address_street AS bill_address_street_26, t0.bill_address_no AS bill_address_no_27, t0.buyer_id AS buyer_id_28, t0.shopware_customer_id AS shopware_customer_id_29, t0.error_count AS error_count_30, t0.error_date AS error_date_31, t0.connection_id AS connection_id_32 FROM avocadostore_order t0 WHERE t0.avocadostore_order_id = ? LIMIT 1
Parameters:
[
  "1d7cbd37-6dbf-4c40-b23b-0111ea1403b4"
]
1.13 ms
(33.81%)
1
SELECT t0.id AS id_1, t0.shopware_api_version AS shopware_api_version_2, t0.shopware_base_url AS shopware_base_url_3, t0.shopware_admin_api_username AS shopware_admin_api_username_4, t0.shopware_admin_api_password AS shopware_admin_api_password_5, t0.shopware_admin_api_access_token AS shopware_admin_api_access_token_6, t0.shopware_admin_api_refresh_token AS shopware_admin_api_refresh_token_7, t0.shopware_admin_api_expire_time AS shopware_admin_api_expire_time_8, t0.shopware_sales_channel_id AS shopware_sales_channel_id_9, t0.shopware_customer_id AS shopware_customer_id_10, t0.shopware_payment_id AS shopware_payment_id_11, t0.shopware_sales_channel_access_key AS shopware_sales_channel_access_key_12 FROM avocadostore_to_shopware_connection t0 WHERE t0.id = ?
Parameters:
[
  "1"
]

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\AvocadostoreToShopwareConnection No errors.
App\Entity\AvocadostoreOrder No errors.
App\Entity\AvocadostoreOrderLine No errors.