op: refund-latest

300 events · 3.13 s wall · 9.81 ms DB (0%) · 3.12 s non-DB (100%)
non-DB 3.12 s

Transactions

#durationreadswritesmax idleoutcomelongest template
1135.50 ms22133.88 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
2121.21 ms22120.68 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
3125.08 ms22124.51 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
4123.28 ms22122.46 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
5125.38 ms22124.80 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
6126.04 ms22125.26 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
7125.38 ms22124.60 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
8124.19 ms22123.70 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
9124.07 ms22123.50 mscommitUPDATE orders SET refunded = TRUE WHERE id = ?
10124.36 ms22123.70 mscommitUPDATE orders SET refunded = TRUE WHERE id = ?
11124.22 ms22123.63 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
12124.70 ms22124.20 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
13125.24 ms22124.75 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
14126.11 ms22125.56 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
15126.19 ms22125.77 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
16122.08 ms22121.64 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
17124.91 ms22124.38 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
18124.52 ms22124.01 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
19128.15 ms22127.71 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
20124.03 ms22123.29 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
21124.70 ms22123.96 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
22125.37 ms22124.77 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
23124.02 ms22123.51 mscommitINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)
24123.59 ms22123.02 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1
25124.62 ms22124.09 mscommitSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1

Timeline

gap is idle time since the previous event on the same thread — highlighted rows had noticeably more app/non-DB time before them than the rest. Follow those to find where the op lost its wall-clock time outside the database.

+offsetgapeventdurationtemplateparamscall-site
0 nsPREPARE204.80 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
268.30 us63.50 usEXECUTE_QUERY58.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 1fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
355.20 us28.70 usNEXT300 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.01 ms650.80 usCLOSE300 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.01 ms1.30 usCLOSE600 nsstack[-1]
1.01 ms4.80 usPREPARE86.70 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.18 ms81.60 usEXECUTE_UPDATE147.60 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 401fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.36 ms32.70 usCLOSE400 nsstack[-1]
135.24 ms133.88 msPREPARE5.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
135.34 ms95.00 usEXECUTE_UPDATE87.40 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=1 order=401 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
135.46 ms29.60 usCLOSE800 nsstack[-1]
135.46 ms3.20 usCOMMIT40.00 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 2 of 25 · 12 events · 355.80 us DB time
135.54 msPREPARE1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
135.57 ms30.50 usEXECUTE_QUERY146.80 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 12fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
135.73 ms12.10 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
135.74 ms5.40 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
135.74 ms300 nsCLOSE400 nsstack[-1]
135.74 ms700 nsPREPARE1.00 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
135.75 ms11.70 usEXECUTE_UPDATE64.50 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 212fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
135.83 ms9.30 usCLOSE200 nsstack[-1]
256.51 ms120.68 msPREPARE6.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
256.59 ms78.30 usEXECUTE_UPDATE93.40 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=12 order=212 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
256.71 ms24.00 usCLOSE900 nsstack[-1]
256.72 ms2.40 usCOMMIT39.00 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 3 of 25 · 12 events · 366.90 us DB time
256.78 msPREPARE1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
256.82 ms38.20 usEXECUTE_QUERY135.80 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 23fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
256.96 ms11.20 usNEXT1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
256.97 ms5.40 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
256.97 ms300 nsCLOSE300 nsstack[-1]
256.97 ms700 nsPREPARE1.00 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
256.98 ms11.40 usEXECUTE_UPDATE76.30 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 223fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
257.07 ms10.00 usCLOSE300 nsstack[-1]
381.58 ms124.51 msPREPARE8.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
381.68 ms88.70 usEXECUTE_UPDATE97.10 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=23 order=223 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
381.81 ms39.40 usCLOSE1.30 usstack[-1]
381.82 ms2.40 usCOMMIT42.80 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 4 of 25 · 12 events · 504.60 us DB time
381.89 msPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
381.91 ms20.90 usEXECUTE_QUERY205.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 34fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
382.17 ms56.80 usNEXT1.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
382.18 ms7.80 usCLOSE900 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
382.18 ms900 nsCLOSE1.50 usstack[-1]
382.18 ms1.50 usPREPARE4.40 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
382.24 ms49.60 usEXECUTE_UPDATE115.50 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 234fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
382.38 ms23.30 usCLOSE400 nsstack[-1]
504.84 ms122.46 msPREPARE14.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
504.99 ms131.90 usEXECUTE_UPDATE113.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=34 order=234 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
505.12 ms15.50 usCLOSE900 nsstack[-1]
505.12 ms2.60 usCOMMIT44.60 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 5 of 25 · 12 events · 423.50 us DB time
505.19 msPREPARE1.80 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
505.21 ms20.80 usEXECUTE_QUERY168.80 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 45fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
505.39 ms12.60 usNEXT1.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
505.40 ms7.60 usCLOSE800 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
505.40 ms500 nsCLOSE400 nsstack[-1]
505.41 ms1.00 usPREPARE1.30 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
505.42 ms17.00 usEXECUTE_UPDATE69.90 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 245fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
505.50 ms9.90 usCLOSE300 nsstack[-1]
630.30 ms124.80 msPREPARE8.70 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
630.38 ms75.20 usEXECUTE_UPDATE89.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=45 order=245 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
630.49 ms13.60 usCLOSE900 nsstack[-1]
630.49 ms6.20 usCOMMIT79.40 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 6 of 25 · 12 events · 545.60 us DB time
630.60 msPREPARE2.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
630.62 ms20.90 usEXECUTE_QUERY219.90 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 56fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
630.91 ms63.00 usNEXT1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
630.92 ms7.90 usCLOSE900 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
630.92 ms1.00 usCLOSE1.30 usstack[-1]
630.92 ms1.70 usPREPARE4.40 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
630.95 ms26.90 usEXECUTE_UPDATE167.20 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 256fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
631.13 ms11.40 usCLOSE300 nsstack[-1]
756.39 ms125.26 msPREPARE7.40 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
756.48 ms87.70 usEXECUTE_UPDATE100.40 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=56 order=256 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
756.60 ms13.00 usCLOSE1.10 usstack[-1]
756.60 ms2.40 usCOMMIT39.00 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 7 of 25 · 12 events · 525.70 us DB time
756.66 msPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
756.69 ms20.60 usEXECUTE_QUERY200.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 67fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
756.94 ms57.00 usNEXT1.60 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
756.95 ms9.10 usCLOSE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
756.96 ms1.10 usCLOSE1.70 usstack[-1]
756.96 ms1.90 usPREPARE4.40 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
757.00 ms33.20 usEXECUTE_UPDATE142.50 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 267fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
757.15 ms11.10 usCLOSE300 nsstack[-1]
881.75 ms124.60 msPREPARE9.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
881.86 ms100.80 usEXECUTE_UPDATE121.40 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=67 order=267 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
882.00 ms14.90 usCLOSE1.10 usstack[-1]
882.00 ms2.40 usCOMMIT40.30 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 8 of 25 · 12 events · 307.40 us DB time
882.07 msPREPARE1.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
882.10 ms25.60 usEXECUTE_QUERY69.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 78fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
882.18 ms11.00 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
882.18 ms5.30 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
882.18 ms300 nsCLOSE300 nsstack[-1]
882.19 ms400 nsPREPARE1.00 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
882.21 ms20.10 usEXECUTE_UPDATE78.60 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 412fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
882.29 ms9.30 usCLOSE200 nsstack[-1]
1.01 s123.70 msPREPARE9.20 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.01 s95.10 usEXECUTE_UPDATE102.60 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=78 order=412 amount=74.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.01 s11.60 usCLOSE1.10 usstack[-1]
1.01 s2.60 usCOMMIT42.00 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 9 of 25 · 12 events · 373.80 us DB time
1.01 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.01 s18.50 usEXECUTE_QUERY103.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 89fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.01 s11.20 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.01 s6.40 usCLOSE800 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.01 s300 nsCLOSE400 nsstack[-1]
1.01 s600 nsPREPARE1.00 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.01 s49.70 usEXECUTE_UPDATE119.50 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 289fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.01 s12.40 usCLOSE400 nsstack[-1]
1.13 s123.50 msPREPARE8.20 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.13 s83.30 usEXECUTE_UPDATE96.50 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=89 order=289 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.13 s16.70 usCLOSE800 nsstack[-1]
1.13 s2.10 usCOMMIT40.70 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 10 of 25 · 12 events · 383.60 us DB time
1.13 sPREPARE1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.13 s38.40 usEXECUTE_QUERY106.90 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 100fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.13 s21.80 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.13 s5.10 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.13 s300 nsCLOSE300 nsstack[-1]
1.13 s600 nsPREPARE900 nsUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.13 s103.20 usEXECUTE_UPDATE139.10 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 300fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.13 s16.00 usCLOSE800 nsstack[-1]
1.25 s123.70 msPREPARE7.10 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.25 s70.10 usEXECUTE_UPDATE87.70 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=100 order=300 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.25 s12.70 usCLOSE800 nsstack[-1]
1.25 s1.90 usCOMMIT37.20 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 11 of 25 · 12 events · 381.40 us DB time
1.25 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.25 s38.00 usEXECUTE_QUERY108.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 111fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.25 s13.50 usNEXT1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.25 s6.10 usCLOSE800 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.25 s400 nsCLOSE400 nsstack[-1]
1.25 s600 nsPREPARE1.20 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.25 s14.50 usEXECUTE_UPDATE75.20 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 311fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.26 s11.10 usCLOSE300 nsstack[-1]
1.38 s123.63 msPREPARE10.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.38 s105.30 usEXECUTE_UPDATE133.60 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=111 order=311 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.38 s15.50 usCLOSE1.00 usstack[-1]
1.38 s2.50 usCOMMIT47.20 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 12 of 25 · 12 events · 334.90 us DB time
1.38 sPREPARE1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.38 s19.60 usEXECUTE_QUERY110.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 122fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.38 s11.50 usNEXT1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.38 s6.20 usCLOSE900 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.38 s300 nsCLOSE300 nsstack[-1]
1.38 s500 nsPREPARE1.10 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.38 s12.00 usEXECUTE_UPDATE69.70 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 322fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.38 s9.20 usCLOSE300 nsstack[-1]
1.50 s124.20 msPREPARE8.50 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.50 s89.10 usEXECUTE_UPDATE103.50 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=122 order=322 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.50 s12.50 usCLOSE800 nsstack[-1]
1.50 s1.90 usCOMMIT36.80 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 13 of 25 · 12 events · 321.10 us DB time
1.50 sPREPARE1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.50 s18.30 usEXECUTE_QUERY85.60 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 133fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.50 s10.50 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.50 s5.20 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.50 s300 nsCLOSE300 nsstack[-1]
1.50 s600 nsPREPARE900 nsUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.50 s11.20 usEXECUTE_UPDATE65.00 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 333fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.50 s9.30 usCLOSE300 nsstack[-1]
1.63 s124.75 msPREPARE10.50 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.63 s102.40 usEXECUTE_UPDATE112.00 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=133 order=333 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.63 s12.60 usCLOSE800 nsstack[-1]
1.63 s2.70 usCOMMIT42.90 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 14 of 25 · 12 events · 381.90 us DB time
1.63 sPREPARE1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.63 s19.40 usEXECUTE_QUERY94.70 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 144fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.63 s10.60 usNEXT1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.63 s6.20 usCLOSE800 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.63 s400 nsCLOSE300 nsstack[-1]
1.63 s400 nsPREPARE900 nsUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.63 s11.60 usEXECUTE_UPDATE70.40 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 344fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.63 s9.10 usCLOSE200 nsstack[-1]
1.75 s125.56 msPREPARE9.00 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.75 s95.60 usEXECUTE_UPDATE153.30 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=144 order=344 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.76 s15.10 usCLOSE1.40 usstack[-1]
1.76 s3.50 usCOMMIT48.30 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 15 of 25 · 12 events · 304.30 us DB time
1.76 sPREPARE1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.76 s22.40 usEXECUTE_QUERY56.50 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 155fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.76 s11.90 usNEXT1.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.76 s5.60 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.76 s400 nsCLOSE300 nsstack[-1]
1.76 s500 nsPREPARE1.20 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.76 s12.70 usEXECUTE_UPDATE85.60 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 423fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.76 s11.30 usCLOSE300 nsstack[-1]
1.88 s125.77 msPREPARE2.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.88 s35.40 usEXECUTE_UPDATE137.30 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=155 order=423 amount=129.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
1.88 s13.50 usCLOSE400 nsstack[-1]
1.88 s1.50 usCOMMIT16.40 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 16 of 25 · 12 events · 262.30 us DB time
1.88 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.88 s29.30 usEXECUTE_QUERY53.80 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 166fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
1.88 s10.90 usNEXT900 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.88 s4.00 usCLOSE500 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
1.88 s400 nsCLOSE300 nsstack[-1]
1.88 s500 nsPREPARE1.10 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
1.88 s12.30 usEXECUTE_UPDATE54.80 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 366fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
1.88 s10.70 usCLOSE300 nsstack[-1]
2.00 s121.64 msPREPARE8.10 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.00 s87.70 usEXECUTE_UPDATE100.70 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=166 order=366 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.00 s13.50 usCLOSE800 nsstack[-1]
2.00 s2.50 usCOMMIT39.80 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 17 of 25 · 12 events · 332.10 us DB time
2.00 sPREPARE1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.00 s20.50 usEXECUTE_QUERY77.90 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 177fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.00 s11.60 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.00 s5.50 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.00 s400 nsCLOSE400 nsstack[-1]
2.00 s500 nsPREPARE1.00 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.00 s13.00 usEXECUTE_UPDATE75.10 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 377fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.00 s13.80 usCLOSE400 nsstack[-1]
2.13 s124.38 msPREPARE10.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.13 s100.70 usEXECUTE_UPDATE114.70 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=177 order=377 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.13 s21.70 usCLOSE900 nsstack[-1]
2.13 s2.70 usCOMMIT48.10 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 18 of 25 · 12 events · 328.00 us DB time
2.13 sPREPARE1.60 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.13 s27.30 usEXECUTE_QUERY93.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 188fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.13 s19.00 usNEXT1.90 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.13 s6.50 usCLOSE2.60 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.13 s700 nsCLOSE500 nsstack[-1]
2.13 s1.00 usPREPARE1.60 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.13 s19.20 usEXECUTE_UPDATE85.60 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 388fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.13 s13.30 usCLOSE400 nsstack[-1]
2.25 s124.01 msPREPARE8.00 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.25 s79.80 usEXECUTE_UPDATE95.30 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=188 order=388 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.25 s12.10 usCLOSE700 nsstack[-1]
2.25 s2.20 usCOMMIT36.80 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 19 of 25 · 12 events · 285.20 us DB time
2.25 sPREPARE1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.25 s18.00 usEXECUTE_QUERY56.60 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 199fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.25 s10.20 usNEXT1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.25 s5.20 usCLOSE600 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.25 s400 nsCLOSE300 nsstack[-1]
2.25 s500 nsPREPARE800 nsUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.25 s10.70 usEXECUTE_UPDATE62.00 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 399fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.25 s10.80 usCLOSE200 nsstack[-1]
2.38 s127.71 msPREPARE10.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.38 s77.00 usEXECUTE_UPDATE112.50 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=199 order=399 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.38 s12.60 usCLOSE1.10 usstack[-1]
2.38 s2.30 usCOMMIT37.90 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 20 of 25 · 12 events · 472.70 us DB time
2.38 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.38 s19.40 usEXECUTE_QUERY137.70 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 10fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.38 s67.10 usNEXT1.70 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.38 s11.50 usCLOSE1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.38 s1.30 usCLOSE2.00 usstack[-1]
2.38 s1.90 usPREPARE5.20 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.38 s46.00 usEXECUTE_UPDATE133.40 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 210fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.38 s12.40 usCLOSE300 nsstack[-1]
2.50 s123.29 msPREPARE9.30 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.50 s92.60 usEXECUTE_UPDATE119.30 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=10 order=210 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.51 s14.60 usCLOSE1.10 usstack[-1]
2.51 s3.00 usCOMMIT60.40 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 21 of 25 · 12 events · 496.60 us DB time
2.51 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.51 s21.50 usEXECUTE_QUERY220.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 21fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.51 s55.50 usNEXT1.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.51 s8.00 usCLOSE1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.51 s1.00 usCLOSE1.40 usstack[-1]
2.51 s1.60 usPREPARE4.50 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.51 s27.80 usEXECUTE_UPDATE117.40 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 221fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.51 s11.40 usCLOSE300 nsstack[-1]
2.63 s123.96 msPREPARE8.60 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.63 s85.70 usEXECUTE_UPDATE94.00 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=21 order=221 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.63 s27.50 usCLOSE700 nsstack[-1]
2.63 s2.40 usCOMMIT45.60 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 22 of 25 · 12 events · 417.90 us DB time
2.63 sPREPARE1.50 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.63 s20.20 usEXECUTE_QUERY159.90 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 32fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.63 s13.70 usNEXT1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.63 s5.70 usCLOSE800 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.63 s400 nsCLOSE400 nsstack[-1]
2.63 s500 nsPREPARE1.30 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.63 s13.60 usEXECUTE_UPDATE73.60 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 232fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.63 s10.60 usCLOSE300 nsstack[-1]
2.75 s124.77 msPREPARE9.00 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.76 s98.60 usEXECUTE_UPDATE130.00 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=32 order=232 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.76 s13.60 usCLOSE800 nsstack[-1]
2.76 s3.00 usCOMMIT39.10 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 23 of 25 · 12 events · 328.90 us DB time
2.76 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.76 s20.70 usEXECUTE_QUERY73.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 43fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.76 s11.90 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.76 s5.50 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.76 s400 nsCLOSE400 nsstack[-1]
2.76 s500 nsPREPARE1.10 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.76 s13.10 usEXECUTE_UPDATE78.90 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 407fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.76 s10.90 usCLOSE400 nsstack[-1]
2.88 s123.51 msPREPARE9.20 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.88 s96.10 usEXECUTE_UPDATE123.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=43 order=407 amount=49.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
2.88 s13.40 usCLOSE900 nsstack[-1]
2.88 s2.20 usCOMMIT38.20 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 24 of 25 · 12 events · 379.60 us DB time
2.88 sPREPARE1.30 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.88 s22.90 usEXECUTE_QUERY121.50 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 54fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
2.88 s11.50 usNEXT1.10 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.88 s5.20 usCLOSE800 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
2.88 s300 nsCLOSE400 nsstack[-1]
2.88 s500 nsPREPARE1.10 usUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
2.88 s13.40 usEXECUTE_UPDATE99.60 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 254fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
2.88 s13.90 usCLOSE400 nsstack[-1]
3.00 s123.02 msPREPARE8.80 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
3.00 s109.70 usEXECUTE_UPDATE100.20 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=54 order=254 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
3.00 s13.50 usCLOSE900 nsstack[-1]
3.00 s2.40 usCOMMIT43.50 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202
Invocation 25 of 25 · 12 events · 360.50 us DB time
3.00 sPREPARE1.20 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
3.00 s20.20 usEXECUTE_QUERY119.40 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] 65fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37
3.00 s10.40 usNEXT1.00 usSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
3.00 s5.50 usCLOSE700 nsSELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1stack[-1]
3.00 s400 nsCLOSE300 nsstack[-1]
3.00 s500 nsPREPARE900 nsUPDATE orders SET refunded = TRUE WHERE id = ?fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
3.00 s11.40 usEXECUTE_UPDATE91.30 usUPDATE orders SET refunded = TRUE WHERE id = ?[1] 265fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47
3.00 s10.10 usCLOSE300 nsstack[-1]
3.13 s124.09 msPREPARE8.90 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66
3.13 s87.50 usEXECUTE_UPDATE97.10 usINSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)[1] refund, [2] customer=65 order=265 amount=19.95fi.vesas.jdbclens.sample.dao.AuditDao.log:14
3.13 s13.30 usCLOSE700 nsstack[-1]
3.13 s2.40 usCOMMIT38.70 usfi.vesas.jdbclens.capture.CapturingConnection.commit:202