1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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
|
