add tracing for BEGIN/COMMIT/ROLLBACK

Traces the beginning and ends of transactions.