Optimize get_payment_info call

[pierre]

get_payment_info has quite an overhead compared toget_payment_method_detail. In my testing, the overhead is between 15ms (p75) up to 25ms (p98).

Thoughts:

• Could we retrieve the response and transaction rows in one query?