Symfony Profiler

Query Metrics

393 Database Queries
23 Different statements
817.35 ms Query time
0 Invalid entities
314 Managed entities
Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.website AS website_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.vat_number AS vat_number_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM company t0
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.label AS label_3, t0.enabled AS enabled_4, t0.mode AS mode_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.expires_at AS expires_at_8, t0.last_sync_at AS last_sync_at_9, t0.last_error AS last_error_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.company_id AS company_id_13 FROM integration_connection t0 WHERE t0.company_id = ? AND t0.provider = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.number AS number_2, t0.title AS title_3, t0.status AS status_4, t0.currency AS currency_5, t0.total_net AS total_net_6, t0.total_taxes AS total_taxes_7, t0.total_gross AS total_gross_8, t0.invoice_date AS invoice_date_9, t0.due_date AS due_date_10, t0.paid_at AS paid_at_11, t0.external_id AS external_id_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.raw_payload AS raw_payload_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.billing_period_start AS billing_period_start_18, t0.billing_period_end AS billing_period_end_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21, t0.friq_contract_id AS friq_contract_id_22 FROM invoice t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3, t0.company_name AS company_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.street AS street_11, t0.house_number AS house_number_12, t0.address_addition AS address_addition_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.country_code AS country_code_16, t0.vat_number AS vat_number_17, t0.status AS status_18, t0.source AS source_19, t0.notes AS notes_20, t0.active AS active_21, t0.last_synced_at AS last_synced_at_22, t0.sync_status AS sync_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.company_id AS company_id_26 FROM client t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.invoice_id AS invoice_id_10 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC, t0.id ASC
"START TRANSACTION"
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO invoice_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE invoice SET invoice_date = ?, due_date = ?, last_synced_at = ?, raw_payload = ?, updated_at = ? WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
DELETE FROM invoice_line WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
"START TRANSACTION"
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE integration_connection SET last_sync_at = ?, updated_at = ? WHERE id = ?
UPDATE external_reference SET external_hash = ?, last_pulled_at = ?, raw_payload = ?, updated_at = ? WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.number AS number_3, t0.title AS title_4, t0.status AS status_5, t0.recurring AS recurring_6, t0.currency AS currency_7, t0.total_net AS total_net_8, t0.total_taxes AS total_taxes_9, t0.total_gross AS total_gross_10, t0.order_date AS order_date_11, t0.valid_until AS valid_until_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.repetition_payload AS repetition_payload_15, t0.raw_payload AS raw_payload_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.next_due_date AS next_due_date_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21 FROM `order` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3, t0.company_name AS company_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.street AS street_11, t0.house_number AS house_number_12, t0.address_addition AS address_addition_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.country_code AS country_code_16, t0.vat_number AS vat_number_17, t0.status AS status_18, t0.source AS source_19, t0.notes AS notes_20, t0.active AS active_21, t0.last_synced_at AS last_synced_at_22, t0.sync_status AS sync_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.company_id AS company_id_26 FROM client t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.order_entity_id AS order_entity_id_10 FROM order_line t0 WHERE t0.order_entity_id = ? ORDER BY t0.position ASC, t0.id ASC
"START TRANSACTION"
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE `order` SET order_date = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.number AS number_3, t0.title AS title_4, t0.status AS status_5, t0.recurring AS recurring_6, t0.currency AS currency_7, t0.total_net AS total_net_8, t0.total_taxes AS total_taxes_9, t0.total_gross AS total_gross_10, t0.order_date AS order_date_11, t0.valid_until AS valid_until_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.repetition_payload AS repetition_payload_15, t0.raw_payload AS raw_payload_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.next_due_date AS next_due_date_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21 FROM `order` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3, t0.company_name AS company_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.street AS street_11, t0.house_number AS house_number_12, t0.address_addition AS address_addition_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.country_code AS country_code_16, t0.vat_number AS vat_number_17, t0.status AS status_18, t0.source AS source_19, t0.notes AS notes_20, t0.active AS active_21, t0.last_synced_at AS last_synced_at_22, t0.sync_status AS sync_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.company_id AS company_id_26 FROM client t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.order_entity_id AS order_entity_id_10 FROM order_line t0 WHERE t0.order_entity_id = ? ORDER BY t0.position ASC, t0.id ASC
"START TRANSACTION"
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE external_reference SET last_pulled_at = ?, updated_at = ? WHERE id = ?
UPDATE `order` SET order_date = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.number AS number_3, t0.title AS title_4, t0.status AS status_5, t0.recurring AS recurring_6, t0.currency AS currency_7, t0.total_net AS total_net_8, t0.total_taxes AS total_taxes_9, t0.total_gross AS total_gross_10, t0.order_date AS order_date_11, t0.valid_until AS valid_until_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.repetition_payload AS repetition_payload_15, t0.raw_payload AS raw_payload_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.next_due_date AS next_due_date_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21 FROM `order` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.order_entity_id AS order_entity_id_10 FROM order_line t0 WHERE t0.order_entity_id = ? ORDER BY t0.position ASC, t0.id ASC
"START TRANSACTION"
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE external_reference SET last_pulled_at = ?, updated_at = ? WHERE id = ?
UPDATE `order` SET order_date = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.number AS number_3, t0.title AS title_4, t0.status AS status_5, t0.recurring AS recurring_6, t0.currency AS currency_7, t0.total_net AS total_net_8, t0.total_taxes AS total_taxes_9, t0.total_gross AS total_gross_10, t0.order_date AS order_date_11, t0.valid_until AS valid_until_12, t0.last_synced_at AS last_synced_at_13, t0.sync_status AS sync_status_14, t0.repetition_payload AS repetition_payload_15, t0.raw_payload AS raw_payload_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.next_due_date AS next_due_date_19, t0.company_id AS company_id_20, t0.client_id AS client_id_21 FROM `order` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.display_name AS display_name_3, t0.company_name AS company_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.email AS email_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.website AS website_10, t0.street AS street_11, t0.house_number AS house_number_12, t0.address_addition AS address_addition_13, t0.zip_code AS zip_code_14, t0.city AS city_15, t0.country_code AS country_code_16, t0.vat_number AS vat_number_17, t0.status AS status_18, t0.source AS source_19, t0.notes AS notes_20, t0.active AS active_21, t0.last_synced_at AS last_synced_at_22, t0.sync_status AS sync_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.company_id AS company_id_26 FROM client t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.text AS text_3, t0.quantity AS quantity_4, t0.unit_price AS unit_price_5, t0.discount AS discount_6, t0.total AS total_7, t0.tax_rate AS tax_rate_8, t0.raw_payload AS raw_payload_9, t0.order_entity_id AS order_entity_id_10 FROM order_line t0 WHERE t0.order_entity_id = ? ORDER BY t0.position ASC, t0.id ASC
"START TRANSACTION"
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE external_reference SET last_pulled_at = ?, updated_at = ? WHERE id = ?
UPDATE `order` SET order_date = ?, last_synced_at = ?, updated_at = ? WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
DELETE FROM order_line WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT o0_.id AS id_0, o0_.external_id AS external_id_1, o0_.number AS number_2, o0_.title AS title_3, o0_.status AS status_4, o0_.recurring AS recurring_5, o0_.currency AS currency_6, o0_.total_net AS total_net_7, o0_.total_taxes AS total_taxes_8, o0_.total_gross AS total_gross_9, o0_.order_date AS order_date_10, o0_.valid_until AS valid_until_11, o0_.last_synced_at AS last_synced_at_12, o0_.sync_status AS sync_status_13, o0_.repetition_payload AS repetition_payload_14, o0_.raw_payload AS raw_payload_15, o0_.created_at AS created_at_16, o0_.updated_at AS updated_at_17, o0_.next_due_date AS next_due_date_18, o0_.company_id AS company_id_19, o0_.client_id AS client_id_20 FROM `order` o0_ WHERE o0_.company_id = ? AND o0_.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
"START TRANSACTION"
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO `order` (external_id, number, title, status, recurring, currency, total_net, total_taxes, total_gross, order_date, valid_until, last_synced_at, sync_status, repetition_payload, raw_payload, created_at, updated_at, next_due_date, company_id, client_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO order_line (position, text, quantity, unit_price, discount, total, tax_rate, raw_payload, order_entity_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE external_reference SET last_pulled_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
"START TRANSACTION"
INSERT INTO external_reference (provider, entity_type, entity_id, external_id, external_hash, sync_status, last_pulled_at, last_pushed_at, last_error, raw_payload, created_at, updated_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INSERT INTO sync_log (provider, entity_type, entity_id, external_id, direction, status, message, payload, created_at, company_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE integration_connection SET last_sync_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.label AS label_3, t0.enabled AS enabled_4, t0.mode AS mode_5, t0.access_token AS access_token_6, t0.refresh_token AS refresh_token_7, t0.expires_at AS expires_at_8, t0.last_sync_at AS last_sync_at_9, t0.last_error AS last_error_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.company_id AS company_id_13 FROM integration_connection t0 WHERE t0.company_id = ? AND t0.provider = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.external_id AS external_id_5, t0.external_hash AS external_hash_6, t0.sync_status AS sync_status_7, t0.last_pulled_at AS last_pulled_at_8, t0.last_pushed_at AS last_pushed_at_9, t0.last_error AS last_error_10, t0.raw_payload AS raw_payload_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14 FROM external_reference t0 WHERE t0.company_id = ? AND t0.provider = ? AND t0.entity_type = ? AND t0.external_id = ? LIMIT 1
"START TRANSACTION"
UPDATE integration_connection SET last_sync_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
"START TRANSACTION"
UPDATE integration_connection SET last_sync_at = ?, updated_at = ? WHERE id = ?
"COMMIT"
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.
Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ExternalReference	251
App\Entity\OrderLine	32
App\Entity\InvoiceLine	11
App\Entity\SyncLog	6
App\Entity\Order	5
App\Entity\Client	4
App\Entity\Company	2
App\Entity\IntegrationConnection	2
App\Entity\Invoice	1
Entities Mapping

Class	Mapping errors
App\Entity\Company	No errors.
App\Entity\CompanyUser	No errors.
App\Entity\IntegrationConnection	No errors.
App\Entity\ExternalReference	No errors.
App\Entity\Invoice	No errors.
App\Entity\Client	No errors.
App\Entity\FriqContract	No errors.
App\Entity\InvoiceLine	No errors.
App\Entity\SyncLog	No errors.
App\Entity\Order	No errors.
App\Entity\OrderLine	No errors.
Symfony Profiler

GET https://friq.ch/cron/bexio/import-all

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
