aboutsummaryrefslogtreecommitdiff
path: root/packages/merchant-backoffice-ui/error.db
diff options
context:
space:
mode:
Diffstat (limited to 'packages/merchant-backoffice-ui/error.db')
-rw-r--r--packages/merchant-backoffice-ui/error.db22
1 files changed, 22 insertions, 0 deletions
diff --git a/packages/merchant-backoffice-ui/error.db b/packages/merchant-backoffice-ui/error.db
new file mode 100644
index 000000000..ee76b3a51
--- /dev/null
+++ b/packages/merchant-backoffice-ui/error.db
@@ -0,0 +1,22 @@
+ JOIN bank_account_transactions AS txs
+ ON bank_transaction=txs.bank_transaction_id
+ WHERE
+ bank_account_id=$1 AND
+ bank_transaction_id > $2
+ ORDER BY bank_transaction_id ASC
+ LIMIT $3
+
+2024-08-01 09:45:45.981 -03 [sebasjm] sebasjm@bank DETAIL: parameters: $1 = '5', $2 = '0', $3 = '1024'
+2024-08-01 09:45:45.981 -03 [sebasjm] sebasjm@bank LOG: duration: 0.011 ms
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant DEBUG: bind <unnamed> to lookup_kyc_status
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant LOG: duration: 0.057 ms bind lookup_kyc_status: SELECT h_wire,exchange_kyc_serial,payto_uri,exchange_url,kyc_timestamp,kyc_ok FROM merchant_instances JOIN merchant_accounts USING (merchant_serial) JOIN merchant_kyc USING (account_serial) WHERE merchant_instances.merchant_id=$1
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant DETAIL: parameters: $1 = 'default'
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant LOG: execute lookup_kyc_status: SELECT h_wire,exchange_kyc_serial,payto_uri,exchange_url,kyc_timestamp,kyc_ok FROM merchant_instances JOIN merchant_accounts USING (merchant_serial) JOIN merchant_kyc USING (account_serial) WHERE merchant_instances.merchant_id=$1
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant DETAIL: parameters: $1 = 'default'
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant LOG: duration: 0.036 ms
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant DEBUG: bind <unnamed> to select_accounts
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant LOG: duration: 0.028 ms bind select_accounts: SELECT h_wire,salt,payto_uri,credit_facade_url,credit_facade_credentials,active FROM merchant_accounts WHERE merchant_serial= (SELECT merchant_serial FROM merchant_instances WHERE merchant_id=$1);
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant DETAIL: parameters: $1 = 'default'
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant LOG: execute select_accounts: SELECT h_wire,salt,payto_uri,credit_facade_url,credit_facade_credentials,active FROM merchant_accounts WHERE merchant_serial= (SELECT merchant_serial FROM merchant_instances WHERE merchant_id=$1);
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant DETAIL: parameters: $1 = 'default'
+2024-08-01 09:45:47.237 -03 [sebasjm] sebasjm@merchant LOG: duration: 0.019 ms