Symfony Profiler

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
ORDER BY
  t0.id ASC

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 ORDER BY t0.id ASC;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  avocadostore_to_shopware_connection
SET
  shopware_admin_api_access_token = ?,
  shopware_admin_api_refresh_token = ?
WHERE
  id = ?

UPDATE avocadostore_to_shopware_connection SET shopware_admin_api_access_token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiJhZG1pbmlzdHJhdGlvbiIsImp0aSI6IjA4YmI3MGQxODEyZDU2NzI3MWQ5YjU1OWQ2YWIxN2U1OWQyYmMyOGJkOWYwZTgzZGQ0MDI1YWYyZTcwNmYxNzIzNDY3MzEwMjNlMzU5ODY4IiwiaWF0IjoxNzI3NTU5MzAxLjg5Nzc1NSwibmJmIjoxNzI3NTU5MzAxLjg5Nzc1NiwiZXhwIjoxNzI3NTU5OTAxLjg5MDc4NSwic3ViIjoiYWU2ZGU4MWUyZDExNGQ5ODllMTRmZDZmNGQwNGM0YjYiLCJzY29wZXMiOlsid3JpdGUiLCJhZG1pbiJdfQ.N-NsEs9Z7RvLBYPrXrhjdKv9bHqKiEf6vWXh8X8XFacmjJqzh6sKUsPJNxXLWyhhHxh-xpuPK0f77rE8LI8gxQO0NiK8R64NNa6mkJwg6MePB9J9tZWU4Ldrq1DckytacEdMt5qET5UVQaJZrpwhbZwB4zpXVwu-tt5jLU7svRuQm3-3UuOKx7DXahQ_GwvsGRtExZUMklIgpUX8Ve1Wh-eyCFo8tkdcEsNdZR2HG1_LWbdSZfN15Ds00IntRZN2xVRFNPcvNDLEapUoYG3c7fv9mKVrtS_YTCN2bbj648dnFXKrsf4LcU4GyXdzRuahX3b1E9Vk0zxKyQ6DZo-2Iw', shopware_admin_api_refresh_token = 'def50200470738d405f46af6819fa908b1f6e9f88f0079cbdc1cac003f94add43074e8d09d2b2b8363d3a46345c6f1e6718a54badc26d09d629b25d2de688cac8e14745b9c45cc47ad418b8cdb2de401718dd8168a860a178759966b9c0319c9d2c5f140af1990d7793e90796f25c6935115ec58088ce3b98e61d0c6b9a004b33dabf485cbc86930057aa8a644cc3af0187ac96907fd2e8d2bc5c18db64d00473ba3ea64a097d357f8ca39359a2981f19fa97d8676307590a0d46f38d4bb0958e81fc04ca5982d38a022d71ac73a06f96f6bec88725c8a524087f1f303b6061aeab2e16579fc4d1b517e9cdd852fe321184cb853c8bbb18e7c396624326f1fe4bb43390631bb7782e7d7089264c2fe02f4f7a71655fcbb7bbca194a5dae60188492b6633c34f5f2d86b353d3a41cd5ebb9a4c4412c52a5a46be306f4cbf478a3bb62db550aa2e39e05f9835098890a714db2fbe1ff52b09612fc2c27b8a885344aab1379e7b5b73bfbf34f95964f69f10c81a5771d50f9d1269b9ddab759c855c9bc69a22279238beaefe9bb5b09511651d03726e4630334e45211e42295' WHERE id = 1;

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.synced AS synced_1,
  a0_.avocadostore_order_id AS avocadostore_order_id_2,
  a0_.purchase_date AS purchase_date_3,
  a0_.payment_date AS payment_date_4,
  a0_.buyer_name AS buyer_name_5,
  a0_.currency AS currency_6,
  a0_.shipping_price AS shipping_price_7,
  a0_.shipping_tax AS shipping_tax_8,
  a0_.shipping_service_level AS shipping_service_level_9,
  a0_.recipient_name AS recipient_name_10,
  a0_.ship_address1 AS ship_address1_11,
  a0_.ship_address2 AS ship_address2_12,
  a0_.ship_city AS ship_city_13,
  a0_.ship_postal_code AS ship_postal_code_14,
  a0_.ship_country AS ship_country_15,
  a0_.bill_address1 AS bill_address1_16,
  a0_.bill_address2 AS bill_address2_17,
  a0_.bill_city AS bill_city_18,
  a0_.bill_postal_code AS bill_postal_code_19,
  a0_.bill_country AS bill_country_20,
  a0_.ship_address_additional AS ship_address_additional_21,
  a0_.ship_address_street AS ship_address_street_22,
  a0_.ship_address_no AS ship_address_no_23,
  a0_.bill_address_additional AS bill_address_additional_24,
  a0_.bill_address_street AS bill_address_street_25,
  a0_.bill_address_no AS bill_address_no_26,
  a0_.buyer_id AS buyer_id_27,
  a0_.shopware_customer_id AS shopware_customer_id_28,
  a0_.error_count AS error_count_29,
  a0_.error_date AS error_date_30,
  a0_.connection_id AS connection_id_31
FROM
  avocadostore_order a0_
WHERE
  a0_.connection_id = ?
  AND a0_.synced = 0
  AND a0_.payment_date IS NOT NULL

SELECT a0_.id AS id_0, a0_.synced AS synced_1, a0_.avocadostore_order_id AS avocadostore_order_id_2, a0_.purchase_date AS purchase_date_3, a0_.payment_date AS payment_date_4, a0_.buyer_name AS buyer_name_5, a0_.currency AS currency_6, a0_.shipping_price AS shipping_price_7, a0_.shipping_tax AS shipping_tax_8, a0_.shipping_service_level AS shipping_service_level_9, a0_.recipient_name AS recipient_name_10, a0_.ship_address1 AS ship_address1_11, a0_.ship_address2 AS ship_address2_12, a0_.ship_city AS ship_city_13, a0_.ship_postal_code AS ship_postal_code_14, a0_.ship_country AS ship_country_15, a0_.bill_address1 AS bill_address1_16, a0_.bill_address2 AS bill_address2_17, a0_.bill_city AS bill_city_18, a0_.bill_postal_code AS bill_postal_code_19, a0_.bill_country AS bill_country_20, a0_.ship_address_additional AS ship_address_additional_21, a0_.ship_address_street AS ship_address_street_22, a0_.ship_address_no AS ship_address_no_23, a0_.bill_address_additional AS bill_address_additional_24, a0_.bill_address_street AS bill_address_street_25, a0_.bill_address_no AS bill_address_no_26, a0_.buyer_id AS buyer_id_27, a0_.shopware_customer_id AS shopware_customer_id_28, a0_.error_count AS error_count_29, a0_.error_date AS error_date_30, a0_.connection_id AS connection_id_31 FROM avocadostore_order a0_ WHERE a0_.connection_id = 1 AND a0_.synced = 0 AND a0_.payment_date IS NOT NULL;