Source scan: 8 of 9 tables exercised at runtime — 1 unexercised; recording may be missing code paths
fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 — 16.15 ms across 200 eventsfi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 — 13.68 ms across 100 eventsfi.vesas.jdbclens.capture.CapturingPreparedStatement.executeBatch:301 — 11.93 ms across 1 eventsWidths are total DB time. Hover any frame for its full class + line.
One bar per invocation of Profiler.currentOperation(name). Position is wall-clock start; width is that invocation's duration. Hover a bar for details.
Wall is the clock time the op took end-to-end. DB is how much of that was spent inside JDBC calls. The split bar is DB (blue) vs. non-DB (gray) — a mostly-gray bar means the app, network, or external I/O is where the time went, not the database.
| Operation | Wall | DB | Non-DB | DB vs. non-DB | Events | Templates |
|---|---|---|---|---|---|---|
monthly-reconciliation | 44.29 ms | 29.63 ms | 14.65 ms | 2300 | 5 | |
schema | 30.36 ms | 24.02 ms | 6.34 ms | 11 | 10 | |
seed-orders | 42.78 ms | 17.53 ms | 25.25 ms | 600 | 1 | |
seed-customers | 32.86 ms | 14.22 ms | 18.64 ms | 4 | 1 | |
match-master-detail | 29.06 ms | 13.85 ms | 15.21 ms | 1980 | 5 | |
place-orders | 26.00 ms | 13.15 ms | 12.84 ms | 1600 | 2 | |
list-dashboard | 27.46 ms | 12.62 ms | 14.84 ms | 1205 | 2 | |
product-search | 14.90 ms | 12.21 ms | 2.70 ms | 56 | 2 | |
post-master-update | 17.86 ms | 10.66 ms | 7.20 ms | 1140 | 4 | |
refund-latest | 3.13 s | 9.81 ms | 3.12 s | 300 | 3 | |
apply-flat-discount | 13.29 ms | 7.83 ms | 5.45 ms | 905 | 3 | |
order-report | 9.91 ms | 6.94 ms | 2.98 ms | 65 | 2 | |
complete-checkout | 18.98 ms | 6.45 ms | 12.52 ms | 725 | 5 | |
outbox-dispatch | 10.88 ms | 6.13 ms | 4.75 ms | 334 | 4 | |
render-hot-item | 5.30 ms | 4.88 ms | 422.20 us | 50 | 1 | |
enrich-with-codes | 10.15 ms | 3.63 ms | 6.52 ms | 1200 | 2 | |
migrate-timezone | 6.39 ms | 3.40 ms | 3.00 ms | 480 | 2 | |
purge | 3.33 ms | 3.13 ms | 200.00 us | 8 | 2 | |
daily-report | 5.92 ms | 3.12 ms | 2.79 ms | 390 | 3 | |
finalize-shipment | 5.67 ms | 2.63 ms | 3.04 ms | 150 | 2 | |
heartbeat | 3.00 ms | 2.28 ms | 718.50 us | 90 | 1 | |
update-profile | 4.77 ms | 2.11 ms | 2.67 ms | 200 | 2 | |
paginated-export | 4.11 ms | 1.23 ms | 2.88 ms | 255 | 1 | |
outbox-seed | 3.56 ms | 1.17 ms | 2.39 ms | 150 | 1 | |
seed-products | 1.42 ms | 774.80 us | 648.80 us | 4 | 1 | |
schema-extend | 870.00 us | 738.30 us | 131.70 us | 5 | 1 | |
| (no operation) | 64.60 us | 64.60 us | 0 ns | 1 | 0 |
Each TX below committed or rolled back at least one write, but between two of its statements the app spent real time outside the database — usually an HTTP call, a file read, or heavy CPU work. Row/page locks taken by the earlier writes were held the whole time. The call-site listed below each bar is where execution was when the gap started: that's almost always where the non-DB work is happening.
INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)Each card below is a run of many short explicit transactions fired back-to-back from the same outer method. Each TX did only a handful of statements and committed — the signature of a loop that commits every iteration (a per-object ORM save inside a for, or any per-record commit() in batch code). Cards are ranked by total wall time the pattern consumed.
SELECT MIN(ID) FROM CUSTOMERS WHERE ID > ?SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ?UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ?SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ?commit(). Each commit costs a WAL flush and a client round-trip; amortising that across 50–500 records typically reclaims most of the run's wall time. If atomicity is per-record by design, consider whether the commit is what's needed or whether a savepoint + single outer commit would suffice.A template fired many times from one call-site — usually a loop that runs one query per row instead of one batched query. Parameters typically differ per call (one ID per row). Cards are ranked by total DB time; count is across the whole recording. See Redundant queries below for the identical-parameters variant.
SELECT SUM(amount) FROM orders WHERE customer_id = ?SELECT MIN(ID) FROM ORDERS WHERE CUSTOMER_ID = ? AND ID > ?UPDATE orders SET amount = ? WHERE id = ?INSERT INTO customer_balances (customer_id, orders_count, lifetime_spend, last_order_at, updated_at) VALUES (?, ?, ?, ?, ?)SELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1UPDATE orders SET refunded = TRUE WHERE id = ?UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ?UPDATE outbox_events SET status = 'SENT', processed_at = ? WHERE id = ?INSERT INTO AUDIT (KIND, PAYLOAD, TS) VALUES (?, ?, ?)UPDATE orders SET shipped_at = ? WHERE id = ?SELECT customer_id, orders_count, lifetime_spend, last_order_at FROM customer_balances WHERE customer_id = ?UPDATE orders SET status = ? WHERE id = ?SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ?INSERT INTO outbox_events (kind, payload, status, created_at) VALUES (?, ?, 'PENDING', ?)UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?SELECT email FROM customers WHERE id = ?SELECT id, name, email FROM customers LIMIT ? OFFSET ?SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ?SELECT ID, NAME FROM CUSTOMERS WHERE ID = ?A pair of templates whose shape betrays row-at-a-time access through hand-written SQL: one query walks a key column with MIN / MAX and a strict inequality, the other fetches row fields by that same key. Both queries live under the same outer method. The fix is not the usual N+1 batch-or-join — it's to replace the pair with one scrolling ResultSet, or one set-oriented GROUP BY. Nested pairs (a walk-and-fetch loop inside another walk-and-fetch loop) are flagged — those are almost always replaceable with a single JOIN … GROUP BY.
orders.idSELECT MIN(ID) FROM ORDERS WHERE CUSTOMER_ID = ? AND ID > ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readNextDetail:111SELECT ID, AMOUNT, STATUS FROM ORDERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readDetailFields:125SELECT … FROM orders JOIN … GROUP BY would replace — the row-at-a-time shape hides set semantics that the analyzer can recover from the call pattern.customers.idSELECT MIN(ID) FROM CUSTOMERS WHERE ID > ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readNextKey:79SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120ResultSet (SELECT … FROM customers ORDER BY id) and iterate it via ResultSet.next(). Each iteration then costs one row, not two round-trips.customers.idSELECT MIN(ID) FROM CUSTOMERS WHERE ID > ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readNextMaster:84SELECT ID, NAME FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readMasterFields:98ResultSet (SELECT … FROM customers ORDER BY id) and iterate it via ResultSet.next(). Each iteration then costs one row, not two round-trips.UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ?Two or more UPDATEs landed on the same row inside one operation — each a separate round-trip, trigger fire, CDC event, and replication message. The overlap label tells you the flavour: mergeable means disjoint SET columns that collapse cleanly into one UPDATE; overlapping means some columns get written twice (the last write wins — often a stale copy from a different service); redundant means the exact same SET clause fired more than once.
orders.id = 1UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 96.20 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 59.40 usorders.id = 48UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 62.80 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 54.20 usorders.id = 157UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 66.70 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 46.30 usorders.id = 35UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 46.00 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 60.20 usorders.id = 131UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 55.70 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 49.80 usorders.id = 92UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 41.80 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 61.80 usorders.id = 74UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 42.20 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 58.80 usorders.id = 22UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 38.80 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 59.10 usorders.id = 66UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 38.70 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 58.70 usorders.id = 40UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 41.90 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 52.70 usorders.id = 118UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 50.00 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 42.10 usorders.id = 14UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 46.10 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 43.30 usorders.id = 196UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 40.40 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 47.20 usorders.id = 183UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 40.00 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 47.40 usorders.id = 27UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 38.80 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 47.00 usorders.id = 61UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 40.60 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 45.10 usorders.id = 87UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 39.20 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 44.20 usorders.id = 144UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 39.60 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 43.50 usorders.id = 105UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 41.20 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 41.80 usorders.id = 100UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 42.10 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 40.70 usorders.id = 53UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 40.10 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 42.40 usorders.id = 113UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 38.30 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 43.70 usorders.id = 170UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 39.50 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 42.30 usorders.id = 9UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 39.90 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 41.70 usorders.id = 79UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 40.90 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 40.30 usThe same template fired more than once with identical parameters inside one logical operation — usually a lookup that should be cached or fetched once and passed through the call chain. Different from N+1 above: N+1 repeats a template with different parameters (a loop over rows); a redundant finding repeats it with identical parameters (no caching). Cards are ranked by total DB time.
SELECT v FROM settings WHERE k = ?[1] k=max_order_valueSELECT COUNT(*) FROM orders WHERE customer_id = ?[1] customer_id=1SELECT V FROM SETTINGS WHERE K = ?[1] K=currency_label_EURSELECT V FROM SETTINGS WHERE K = ?[1] K=shipping_label_STDSELECT v FROM settings WHERE k = ?[1] k=max_order_valueSELECT V FROM SETTINGS WHERE K = ?[1] K=status_label_OPENSELECT v FROM settings WHERE k = ?[1] k=default_currencySELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=148SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=141SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=127SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=134SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=169SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=162SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1[1] customer_id=155orders.customer_id = 17SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 5.96 msSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 165.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 35.40 usorders.customer_id = 1SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 823.20 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 246.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 51.60 usorders.customer_id = 20SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 172.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 90.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 87.30 usorders.customer_id = 14SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 183.50 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 100.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 33.50 usorders.customer_id = 2SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 137.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 104.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 43.10 usorders.customer_id = 5SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 119.70 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 94.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 46.10 usorders.customer_id = 9SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 107.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 93.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 59.40 usorders.customer_id = 13SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 109.20 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 97.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 37.70 usorders.customer_id = 15SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 121.20 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 105.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 16.60 usorders.customer_id = 22SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 122.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 95.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 25.60 usorders.customer_id = 7SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 105.20 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 95.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 38.10 usorders.customer_id = 6SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 109.60 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 91.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 36.60 usorders.customer_id = 18SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 107.50 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 96.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 30.80 usorders.customer_id = 21SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 107.70 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 96.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.40 usorders.customer_id = 4SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 99.80 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 96.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 35.00 usorders.customer_id = 10SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 101.30 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 98.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 30.10 usorders.customer_id = 24SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 101.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 91.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 36.00 usorders.customer_id = 12SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 99.90 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 96.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 32.00 usorders.customer_id = 3SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 102.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 95.80 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.30 usorders.customer_id = 23SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 104.50 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 89.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.20 usorders.customer_id = 16SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 99.30 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 94.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 28.30 usorders.customer_id = 11SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 96.30 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 92.50 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 31.90 usorders.customer_id = 40SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 113.10 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 79.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 27.40 usorders.customer_id = 25SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 107.20 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 82.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 23.40 usorders.customer_id = 26SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 88.60 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 82.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 36.80 usorders.customer_id = 33SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 96.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.90 usorders.customer_id = 27SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 94.50 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 28.30 usorders.customer_id = 8SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 96.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 92.50 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 14.80 usorders.customer_id = 37SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 104.10 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 75.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.60 usorders.customer_id = 42SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 97.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 74.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.60 usorders.customer_id = 32SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 87.70 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 86.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.70 usorders.customer_id = 19SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 84.30 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.50 usorders.customer_id = 44SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 101.30 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 74.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.60 uscustomers.id = 1UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 100.10 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 64.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 32.90 usorders.customer_id = 41SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 89.60 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 83.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.30 usorders.customer_id = 28SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 83.70 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 82.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.40 usorders.customer_id = 48SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 99.90 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 72.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 23.60 usorders.customer_id = 39SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 93.50 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 75.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 24.90 usorders.customer_id = 51SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 98.50 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 74.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.00 usorders.customer_id = 52SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.20 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 82.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 24.60 usorders.customer_id = 54SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 108.70 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 60.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.10 usorders.customer_id = 34SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.30 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 81.50 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 24.00 usorders.customer_id = 43SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 90.70 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 85.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 12.80 usorders.customer_id = 31SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 84.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 79.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 24.20 usorders.customer_id = 38SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 88.70 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 73.80 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 23.20 usorders.customer_id = 30SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 82.40 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 78.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.90 usorders.customer_id = 46SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 87.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 74.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.70 usorders.customer_id = 36SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 86.60 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 82.80 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 12.60 usorders.customer_id = 49SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 79.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 73.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 28.90 usorders.customer_id = 29SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 86.40 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 81.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 12.80 usorders.customer_id = 45SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 81.40 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 75.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 23.30 usorders.customer_id = 35SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 78.50 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 78.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.10 usorders.customer_id = 96SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 93.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 61.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.80 usorders.customer_id = 50SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 80.40 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 79.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 12.70 usorders.customer_id = 53SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 75.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 73.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.30 usorders.customer_id = 47SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 74.40 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 73.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.40 usorders.customer_id = 74SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 71.30 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 66.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 24.20 usorders.customer_id = 64SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.20 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 60.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 14.90 usorders.customer_id = 65SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 74.80 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 56.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 27.10 usorders.customer_id = 68SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 74.80 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 56.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 25.50 usorders.id = 1UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 96.20 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 59.40 usorders.customer_id = 98SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 84.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 20.30 usorders.customer_id = 100SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 68.60 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 65.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.20 usorders.customer_id = 66SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 64.40 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 61.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.90 usorders.customer_id = 94SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 70.60 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 61.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.40 usorders.customer_id = 71SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 76.60 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 52.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.40 usorders.customer_id = 82SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 78.60 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 20.10 usorders.customer_id = 62SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 62.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 56.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.90 usorders.customer_id = 59SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 68.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 55.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.80 usorders.customer_id = 73SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 64.80 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 51.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.10 uscustomers.id = 92SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 115.20 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 27.10 usorders.customer_id = 61SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 58.90 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 56.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.40 usorders.customer_id = 60SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 55.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 54.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 27.20 usorders.customer_id = 85SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 70.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 53.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 12.90 usorders.customer_id = 84SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 63.30 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 51.80 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 20.90 usorders.customer_id = 58SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 58.90 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 52.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 23.30 usorders.customer_id = 80SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 57.50 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 56.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.90 usorders.customer_id = 63SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 53.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 52.80 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.20 usorders.customer_id = 67SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 56.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.20 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.60 usorders.customer_id = 69SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 52.90 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 26.30 usorders.customer_id = 72SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 51.70 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 50.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 27.40 usorders.customer_id = 55SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 55.40 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 53.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 20.90 usorders.customer_id = 56SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 53.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 53.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.90 usorders.customer_id = 79SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 49.80 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 29.20 usorders.customer_id = 83SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.80 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 23.20 usorders.customer_id = 97SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 54.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 52.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 18.50 usorders.customer_id = 57SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 58.30 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 52.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 11.90 usorders.customer_id = 70SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 50.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.40 usorders.customer_id = 90SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.00 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 48.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 22.80 usorders.customer_id = 75SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 52.00 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.00 usorders.customer_id = 77SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.20 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.40 usorders.customer_id = 86SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.60 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 50.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.60 usorders.customer_id = 95SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 49.80 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.60 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 21.00 usorders.customer_id = 89SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 52.70 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 48.90 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 18.70 usorders.customer_id = 76SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.30 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.80 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 20.00 usorders.customer_id = 87SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 51.50 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 18.90 usorders.customer_id = 88SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 50.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 49.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 20.90 usorders.customer_id = 81SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.50 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 50.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.00 usorders.customer_id = 78SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 55.80 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.70 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 12.00 usorders.customer_id = 91SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 49.90 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.10 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 19.90 usorders.customer_id = 93SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 49.30 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 49.00 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 18.90 usorders.id = 48UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 62.80 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 54.20 usorders.customer_id = 92SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 52.10 usSELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 50.30 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 13.30 usorders.customer_id = 99SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 1× · 51.60 usSELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 1× · 51.40 usSELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 1× · 11.50 usorders.id = 157UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 66.70 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 46.30 uscustomers.id = 1UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 71.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 35.50 usorders.id = 35UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 60.20 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 46.00 usorders.id = 131UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 55.70 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 49.80 usorders.id = 92UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 61.80 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 41.80 usorders.id = 74UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 58.80 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 42.20 usorders.id = 22UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 59.10 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 38.80 uscustomers.id = 8SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 66.50 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 31.30 usorders.id = 66UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 58.70 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 38.70 uscustomers.id = 54UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 62.00 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 24.20 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 10.60 uscustomers.id = 1SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 76.20 usSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 20.30 uscustomers.id = 124UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 77.10 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 18.00 uscustomers.id = 154UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 55.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 39.60 usorders.id = 40UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 52.70 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 41.90 uscustomers.id = 175UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 65.00 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 27.90 uscustomers.id = 58UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 79.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.90 usorders.id = 118UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 50.00 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 42.10 usorders.id = 14UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 46.10 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 43.30 usorders.id = 196UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 47.20 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 40.40 usorders.id = 183UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 47.40 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 40.00 usorders.id = 27UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 47.00 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 38.80 usorders.id = 61UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 45.10 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 40.60 usorders.id = 87UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 44.20 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 39.20 usorders.id = 144UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 43.50 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 39.60 usorders.id = 105UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 41.80 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 41.20 usorders.id = 100UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 42.10 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 40.70 usorders.id = 53UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 42.40 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 40.10 uscustomers.id = 141UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 63.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 18.60 uscustomers.id = 56UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 43.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 39.10 usorders.id = 113UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 43.70 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 38.30 usorders.id = 170UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 42.30 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 39.50 usorders.id = 9UPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 41.70 usUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 39.90 uscustomers.id = 127SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 61.50 usSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 20.00 usorders.id = 79UPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 1× · 40.90 usUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 1× · 40.30 uscustomers.id = 49UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 67.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.80 uscustomers.id = 1UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 51.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 28.20 uscustomers.id = 39UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 55.60 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.30 uscustomers.id = 19SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 46.40 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.50 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.60 uscustomers.id = 90UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 60.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 18.20 uscustomers.id = 192UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 55.20 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 22.20 uscustomers.id = 9UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 35.50 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 32.20 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.50 uscustomers.id = 42UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 52.90 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.60 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.50 uscustomers.id = 36SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 41.80 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 34.30 uscustomers.id = 158UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 54.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 18.10 uscustomers.id = 38UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 59.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 5SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 36.60 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.60 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.30 uscustomers.id = 18UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 47.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 23.60 uscustomers.id = 52UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 44.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 26.50 uscustomers.id = 103UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 45.10 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 25.90 uscustomers.id = 188UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 50.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 20.30 uscustomers.id = 2UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 31.40 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 20.50 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 18.60 uscustomers.id = 16SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 29.90 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 14.70 uscustomers.id = 73UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 52.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 16.70 uscustomers.id = 34UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 45.00 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.10 uscustomers.id = 107UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 51.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.30 uscustomers.id = 71SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 35.30 usSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 32.30 uscustomers.id = 26UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 54.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.70 uscustomers.id = 3UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 24.10 uscustomers.id = 22SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 28.30 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.80 uscustomers.id = 57UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 53.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.00 uscustomers.id = 10UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 39.40 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 10.20 uscustomers.id = 14UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 30.20 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 25.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.60 uscustomers.id = 40UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 42.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.80 uscustomers.id = 49UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 34.00 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 22.80 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.70 uscustomers.id = 39UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 48.20 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 16.20 uscustomers.id = 86UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 45.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 19.00 uscustomers.id = 6UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 27.30 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 26.10 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 10.40 uscustomers.id = 12UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 38.30 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.40 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.90 uscustomers.id = 171UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 44.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 18.70 uscustomers.id = 45UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 40.90 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.20 uscustomers.id = 5UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 20.40 uscustomers.id = 35UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 45.00 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.50 uscustomers.id = 69UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 43.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.60 uscustomers.id = 36UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 38.60 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.20 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.10 uscustomers.id = 5UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 43.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.50 uscustomers.id = 11UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 31.60 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 18.10 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 10.60 uscustomers.id = 27SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 27.50 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.10 uscustomers.id = 9UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.20 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.80 uscustomers.id = 6UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 46.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.50 uscustomers.id = 53UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 47.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.40 uscustomers.id = 29UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 46.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.90 uscustomers.id = 137UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.30 uscustomers.id = 9UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 46.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.00 uscustomers.id = 25SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 26.00 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.40 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.10 uscustomers.id = 120UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 16.80 uscustomers.id = 7UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 29.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 20.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.60 uscustomers.id = 53UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 35.20 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.60 uscustomers.id = 169SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 38.50 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 20.30 uscustomers.id = 22UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 41.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 16.60 uscustomers.id = 25UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 41.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 15.50 uscustomers.id = 32UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 24.60 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.70 uscustomers.id = 47UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 39.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 17.50 uscustomers.id = 39UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.20 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 14.10 uscustomers.id = 4UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 28.60 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 17.80 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.80 uscustomers.id = 2UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 40.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 15.20 uscustomers.id = 56SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 24.90 usUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.70 uscustomers.id = 50SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 35.60 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 19.90 uscustomers.id = 22UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 43.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 11.80 uscustomers.id = 16UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 42.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.50 uscustomers.id = 44UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 18.30 uscustomers.id = 21UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 21.80 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.40 uscustomers.id = 26UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 20.60 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.50 uscustomers.id = 85SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 29.20 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 25.20 uscustomers.id = 43UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 33.20 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.50 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.60 uscustomers.id = 13UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 41.10 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.10 uscustomers.id = 44UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 32.80 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.80 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.50 uscustomers.id = 35UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 39.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 14.40 uscustomers.id = 52UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.50 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 21.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.40 uscustomers.id = 28UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 41.00 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.30 uscustomers.id = 13UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 28.40 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.80 uscustomers.id = 22SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 31.90 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 21.00 uscustomers.id = 8UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.90 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 10.50 uscustomers.id = 60UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 40.10 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.60 uscustomers.id = 3UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.80 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.80 uscustomers.id = 19UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 40.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 11.80 uscustomers.id = 99SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 30.00 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 21.90 uscustomers.id = 56UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 39.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 11.80 uscustomers.id = 20UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 37.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 59UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 14.10 uscustomers.id = 29UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.00 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 18.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.80 uscustomers.id = 11UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 37.10 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.50 uscustomers.id = 78SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 26.90 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 23.60 uscustomers.id = 41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.90 uscustomers.id = 28UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.10 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.40 uscustomers.id = 46UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.30 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 16.10 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.00 uscustomers.id = 4UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 50UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.30 uscustomers.id = 37UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 37.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 11.90 uscustomers.id = 43UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.40 uscustomers.id = 31UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 37.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.10 uscustomers.id = 7UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 29SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 27.90 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 21.50 uscustomers.id = 10UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.70 uscustomers.id = 17UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.50 uscustomers.id = 55UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.40 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 11.20 uscustomers.id = 38UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 28.30 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 12.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.00 uscustomers.id = 113SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 28.20 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 21.00 uscustomers.id = 32UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.00 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 27UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 18UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.90 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.80 uscustomers.id = 12UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.20 uscustomers.id = 52UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.60 uscustomers.id = 17UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 25.30 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.10 uscustomers.id = 15SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 26.50 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 22.20 uscustomers.id = 21UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.80 uscustomers.id = 14UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.10 uscustomers.id = 15UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.60 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 15.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.60 uscustomers.id = 23UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.00 uscustomers.id = 36UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.00 uscustomers.id = 45UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.50 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.90 uscustomers.id = 48UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.00 uscustomers.id = 8UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.60 uscustomers.id = 30UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.70 uscustomers.id = 51UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 36.10 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.20 uscustomers.id = 20UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.90 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.50 uscustomers.id = 35UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.90 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.40 uscustomers.id = 15UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.70 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.30 uscustomers.id = 24UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.60 uscustomers.id = 33UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.40 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.60 uscustomers.id = 54UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.00 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.00 uscustomers.id = 18UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.10 uscustomers.id = 34UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 35.30 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.50 uscustomers.id = 40UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 34.60 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.20 uscustomers.id = 55UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 34.90 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 12.90 uscustomers.id = 41UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.30 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 12.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 10.10 uscustomers.id = 42UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 34.20 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 13.10 uscustomers.id = 31UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.80 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.00 uscustomers.id = 46UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 1× · 34.80 usSELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 1× · 11.90 uscustomers.id = 43SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 26.20 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 20.40 uscustomers.id = 23UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.20 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.20 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.80 uscustomers.id = 134SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 26.10 usSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 20.00 uscustomers.id = 57SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 23.90 usSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 22.00 uscustomers.id = 37UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 24.20 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.30 uscustomers.id = 24UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.50 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.40 uscustomers.id = 30UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.60 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.60 uscustomers.id = 33UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.40 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 14.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.40 uscustomers.id = 50UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 23.50 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.40 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.90 uscustomers.id = 58UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.00 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 9.00 uscustomers.id = 57UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.20 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 12.90 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.70 uscustomers.id = 64SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 22.20 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 21.40 uscustomers.id = 48UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.50 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.30 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.60 uscustomers.id = 51UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.40 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.20 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.70 uscustomers.id = 60UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.10 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 12.70 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 8.10 uscustomers.id = 47UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 22.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 12.80 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.30 uscustomers.id = 59UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 1× · 21.70 usSELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 1× · 13.00 usSELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 1× · 7.80 uscustomers.id = 106SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 23.20 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 17.70 uscustomers.id = 155SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 22.30 usSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 17.90 uscustomers.id = 120SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 21.10 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 17.60 uscustomers.id = 141SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 19.30 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 16.80 uscustomers.id = 148SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 18.80 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 16.80 uscustomers.id = 162SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 1× · 18.80 usSELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 1× · 16.80 uscustomers.id = 1SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 1SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 124SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 154SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 175SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 58SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 141SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 56SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 49SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 1SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 90SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 192SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 158SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 38SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 54SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 18SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 52SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 103SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 188SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 73SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 107SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 26SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 3SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 57SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 39SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 86SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 39SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 171SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 5SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 35SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 42SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 69SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 5SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 9SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 6SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 53SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 29SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 137SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 9SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 120SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 22SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 25SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 47SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 39SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 2SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 22SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 16SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 44SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 13SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 35SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 28SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 34SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 60SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 19SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 22SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 56SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 20SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 59SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 11SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 41SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 40SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 4SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 2SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 50SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 37SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 43SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 31SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 10SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 7SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 10SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 17SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 32SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 27SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 45SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 12SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 52SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 21SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 14SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 23SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 36SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 45SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 48SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 8SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 30SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 51SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 15SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 24SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 33SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 54SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 18SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 34SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 40SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 55SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 42SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 12SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 46SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73UPDATE … RETURNING.customers.id = 36SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 9SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 53SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 11SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 49SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 43SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 44SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 14SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 16SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 7SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 4SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 6SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 13SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 8SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 38SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 55SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 3SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 5SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 41SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 46SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 26SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 18SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 25SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 28SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 17SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 20SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 35SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 15SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 19SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 21SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 27SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 29SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 31SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 37SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 32SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 23SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 52SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 50SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 30SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 58SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 24SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 57SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 33SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 56SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 60SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 48SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 51SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 47SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.customers.id = 59SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112UPDATE … RETURNING.| Call-site | DB time | Count | Templates |
|---|---|---|---|
fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 | 16.15 ms | 200 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 | 13.68 ms | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingPreparedStatement.executeBatch:301 | 11.93 ms | 1 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 | 9.55 ms | 200 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 | 8.35 ms | 100 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 | 7.54 ms | 200 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 7.25 ms | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readNextDetail:111 | 7.15 ms | 158 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 7.03 ms | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 5.90 ms | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readNextKey:79 | 5.64 ms | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 4.91 ms | 1 | 1 |
fi.vesas.jdbclens.sample.dao.SettingsDao.getByKey:14 | 4.71 ms | 200 | 1 |
fi.vesas.jdbclens.sample.service.OrderReportService.topCustomersBySpend:40 | 4.56 ms | 1 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.updateAmount:118 | 4.33 ms | 100 | 1 |
fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20 | 3.22 ms | 1 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37 | 2.98 ms | 25 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37 | 2.94 ms | 100 | 1 |
fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readNextMaster:84 | 2.83 ms | 50 | 1 |
fi.vesas.jdbclens.sample.dao.AuditDao.log:14 | 2.72 ms | 25 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 | 2.64 ms | 10 | 1 |
fi.vesas.jdbclens.sample.dao.BalanceDao.insert:51 | 2.59 ms | 100 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 | 2.53 ms | 100 | 1 |
fi.vesas.jdbclens.sample.service.PurgeService.purgeProcessedOutboxEvents:21 | 2.45 ms | 1 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 | 2.43 ms | 60 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47 | 2.36 ms | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 2.23 ms | 10 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 2.07 ms | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 1.99 ms | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 | 1.81 ms | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 1.78 ms | 7 | 1 |
fi.vesas.jdbclens.sample.dao.OutboxDao.markSent:57 | 1.65 ms | 43 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 1.46 ms | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 1.45 ms | 30 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 | 1.34 ms | 30 | 1 |
fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.writeMasterBreak:145 | 1.29 ms | 50 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 | 1.28 ms | 25 | 1 |
fi.vesas.jdbclens.sample.dao.AuditDao.log:14 | 1.26 ms | 25 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 | 1.21 ms | 25 | 1 |
fi.vesas.jdbclens.sample.dao.AuditDao.log:14 | 1.20 ms | 43 | 1 |
fi.vesas.jdbclens.sample.dao.BalanceDao.findByCustomer:31 | 1.18 ms | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 1.16 ms | 200 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 | 1.15 ms | 25 | 1 |
fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 | 1.13 ms | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 1.13 ms | 200 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.commit:202 | 1.06 ms | 25 | 1 |
fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readDetailFields:125 | 1.05 ms | 108 | 1 |
fi.vesas.jdbclens.sample.dao.OutboxDao.enqueue:30 | 1.03 ms | 50 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.resolveCurrencyLabel:79 | 990.40 us | 60 | 1 |
fi.vesas.jdbclens.sample.dao.AuditDao.log:14 | 982.50 us | 30 | 1 |
fi.vesas.jdbclens.sample.dao.OutboxDao.markFailed:67 | 951.20 us | 7 | 1 |
fi.vesas.jdbclens.sample.dao.AuditDao.log:14 | 932.60 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 900.20 us | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.resolveShippingLabel:99 | 841.50 us | 60 | 1 |
fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13 | 827.60 us | 30 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.commit:202 | 822.40 us | 1 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 | 820.70 us | 60 | 1 |
fi.vesas.jdbclens.sample.dao.SettingsDao.getByKey:14 | 816.50 us | 25 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.resolveStatusLabel:89 | 811.60 us | 60 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 | 793.70 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.commit:202 | 785.80 us | 60 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 | 780.30 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 772.50 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 724.10 us | 1 | 1 |
fi.vesas.jdbclens.sample.dao.SettingsDao.getByKey:14 | 720.90 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 688.50 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 670.20 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 665.90 us | 1 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 | 662.10 us | 25 | 1 |
fi.vesas.jdbclens.sample.service.PaginatedExportService.fetchPage:42 | 656.10 us | 11 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 601.70 us | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 | 577.50 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 | 560.10 us | 1 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 | 542.50 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingPreparedStatement.executeBatch:301 | 520.70 us | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.readOrder:67 | 517.30 us | 60 | 1 |
fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readMasterFields:98 | 506.50 us | 50 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.findRecent:20 | 506.30 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 493.00 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 479.60 us | 1 | 1 |
fi.vesas.jdbclens.sample.dao.ProductDao.findByIds:44 | 462.40 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 409.20 us | 200 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 | 403.90 us | 30 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 307.40 us | 11 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 285.50 us | 158 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 275.40 us | 100 | 1 |
fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 | 272.50 us | 10 | 1 |
fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20 | 271.50 us | 1 | 1 |
fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20 | 258.00 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 236.00 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 234.90 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 226.90 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 220.20 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 219.30 us | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 192.10 us | 30 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 188.30 us | 108 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 179.20 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 174.10 us | 50 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 173.70 us | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 166.90 us | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 164.60 us | 200 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 161.70 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.commit:202 | 159.50 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 157.10 us | 60 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.seedCodes:33 | 150.30 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 150.10 us | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 147.30 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 144.10 us | 100 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 143.60 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 142.30 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 138.80 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 131.70 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 130.40 us | 50 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 130.00 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 128.70 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 128.30 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 127.90 us | 43 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 113.20 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 109.30 us | 43 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 98.20 us | 50 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 94.00 us | 30 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 93.40 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 87.70 us | 100 | 1 |
fi.vesas.jdbclens.sample.dao.OrderDao.findRecent:20 | 87.10 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 77.10 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 71.50 us | 30 | 1 |
fi.vesas.jdbclens.sample.dao.OutboxDao.listPending:40 | 56.00 us | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.seedCodes:37 | 54.60 us | 1 | 1 |
fi.vesas.jdbclens.sample.cobol.CodeLookupService.seedCodes:35 | 53.50 us | 1 | 1 |
fi.vesas.jdbclens.sample.service.PurgeService.trimAuditLog:28 | 53.10 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 48.40 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 44.90 us | 50 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 44.00 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 36.70 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 34.60 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 32.70 us | 60 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 28.70 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 23.30 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 20.90 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 19.20 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 17.60 us | 25 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 14.80 us | 10 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 8.50 us | 1 | 1 |
fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 | 5.80 us | 1 | 1 |
| Template | DB time | Count | p50 | p99 | Distribution | Call-sites |
|---|---|---|---|---|---|---|
INSERT INTO orders (customer_id, amount) VALUES (?, ?) | 24.49 ms | 425 | 45.50 us | 187.80 us | 6 | |
SELECT COUNT(*) FROM orders WHERE customer_id = ? | 17.65 ms | 140 | 59.30 us | 2.44 ms | 6 | |
INSERT INTO customers (id, name, email, phone, address_line, city, state, postal_code, country, timezone) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | 11.93 ms | 1 | 11.93 ms | 11.93 ms | 2 | |
SELECT name FROM customers WHERE id = ? | 10.34 ms | 225 | 39.30 us | 167.90 us | 4 | |
SELECT MIN(ID) FROM CUSTOMERS WHERE ID > ? | 8.47 ms | 110 | 63.30 us | 198.40 us | 4 | |
SELECT SUM(amount) FROM orders WHERE customer_id = ? | 8.35 ms | 100 | 76.60 us | 172.00 us | 2 | |
CREATE TABLE orders (id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, amount DECIMAL(?,?), status VARCHAR(?), shipped_at TIMESTAMP, refunded BOOLEAN DEFAULT FALSE) | 7.25 ms | 1 | 7.25 ms | 7.25 ms | 1 | |
SELECT MIN(ID) FROM ORDERS WHERE CUSTOMER_ID = ? AND ID > ? | 7.15 ms | 158 | 44.70 us | 113.90 us | 2 | |
INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP) | 7.09 ms | 148 | 29.60 us | 175.40 us | 10 | |
SELECT v FROM settings WHERE k = ? | 6.25 ms | 250 | 19.40 us | 79.70 us | 6 | |
SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 | 5.92 ms | 125 | 30.00 us | 219.90 us | 4 | |
CREATE TABLE settings (k VARCHAR(?) PRIMARY KEY, v VARCHAR(?)) | 5.90 ms | 1 | 5.90 ms | 5.90 ms | 1 | |
CREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(?), email VARCHAR(?), phone VARCHAR(?), address_line VARCHAR(?), city VARCHAR(?), state VARCHAR(?), postal_code VARCHAR(?), country VARCHAR(?), timezone VARCHAR(?)) | 4.91 ms | 1 | 4.91 ms | 4.91 ms | 1 | |
SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o.amount) DESC LIMIT ? | 4.56 ms | 1 | 4.56 ms | 4.56 ms | 2 | |
UPDATE orders SET amount = ? WHERE id = ? | 4.33 ms | 100 | 39.60 us | 75.70 us | 2 | |
SELECT id, name, price FROM products WHERE name LIKE ? | 3.75 ms | 3 | 271.50 us | 3.22 ms | 6 | |
UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? | 3.70 ms | 85 | 41.00 us | 77.10 us | 4 | |
SELECT V FROM SETTINGS WHERE K = ? | 2.64 ms | 180 | 12.60 us | 36.20 us | 6 | |
INSERT INTO customer_balances (customer_id, orders_count, lifetime_spend, last_order_at, updated_at) VALUES (?, ?, ?, ?, ?) | 2.59 ms | 100 | 20.40 us | 88.10 us | 2 | |
SELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 | 2.53 ms | 100 | 23.30 us | 59.40 us | 2 | |
DELETE FROM outbox_events WHERE status = 'SENT' AND processed_at < ? | 2.45 ms | 1 | 2.45 ms | 2.45 ms | 2 | |
UPDATE orders SET refunded = TRUE WHERE id = ? | 2.36 ms | 25 | 78.90 us | 167.20 us | 2 | |
SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? | 2.04 ms | 125 | 13.10 us | 56.10 us | 8 | |
INSERT INTO settings (k, v) VALUES (?, ?), (?, ?) | 1.99 ms | 1 | 1.99 ms | 1.99 ms | 1 | |
UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? | 1.81 ms | 60 | 25.10 us | 62.00 us | 2 | |
UPDATE outbox_events SET status = 'SENT', processed_at = ? WHERE id = ? | 1.65 ms | 43 | 31.90 us | 164.00 us | 2 | |
SELECT ID, AMOUNT, STATUS FROM ORDERS WHERE ID = ? | 1.57 ms | 168 | 8.60 us | 20.00 us | 4 | |
INSERT INTO AUDIT (KIND, PAYLOAD, TS) VALUES (?, ?, ?) | 1.29 ms | 50 | 21.20 us | 85.90 us | 2 | |
UPDATE orders SET shipped_at = ? WHERE id = ? | 1.21 ms | 25 | 46.30 us | 61.80 us | 2 | |
SELECT customer_id, orders_count, lifetime_spend, last_order_at FROM customer_balances WHERE customer_id = ? | 1.18 ms | 100 | 9.80 us | 44.60 us | 2 | |
UPDATE orders SET status = ? WHERE id = ? | 1.15 ms | 25 | 40.90 us | 96.20 us | 2 | |
SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? | 1.13 ms | 60 | 15.70 us | 46.40 us | 2 | |
INSERT INTO outbox_events (kind, payload, status, created_at) VALUES (?, ?, 'PENDING', ?) | 1.03 ms | 50 | 17.10 us | 96.10 us | 2 | |
UPDATE outbox_events SET status = 'FAILED', attempts = attempts + 1, last_error = ? WHERE id = ? | 951.20 us | 7 | 33.10 us | 601.90 us | 2 | |
UPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ? | 827.60 us | 30 | 19.40 us | 88.60 us | 2 | |
CREATE TABLE reconciliation_exceptions (id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, expected DECIMAL(?,?), actual DECIMAL(?,?), reason VARCHAR(?), detected_at TIMESTAMP) | 772.50 us | 1 | 772.50 us | 772.50 us | 1 | |
CREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, sku VARCHAR(?), name VARCHAR(?), category VARCHAR(?), price DECIMAL(?,?), stock_qty INT) | 688.50 us | 1 | 688.50 us | 688.50 us | 1 | |
CREATE TABLE audit (id INT AUTO_INCREMENT PRIMARY KEY, kind VARCHAR(?), payload VARCHAR(?), ts TIMESTAMP) | 670.20 us | 1 | 670.20 us | 670.20 us | 1 | |
CREATE TABLE outbox_events (id INT AUTO_INCREMENT PRIMARY KEY, kind VARCHAR(?), payload VARCHAR(?), status VARCHAR(?) DEFAULT ?, attempts INT DEFAULT ?, last_error VARCHAR(?), created_at TIMESTAMP, processed_at TIMESTAMP) | 665.90 us | 1 | 665.90 us | 665.90 us | 1 | |
SELECT email FROM customers WHERE id = ? | 662.10 us | 25 | 21.90 us | 76.20 us | 2 | |
SELECT id, name, email FROM customers LIMIT ? OFFSET ? | 656.10 us | 11 | 53.60 us | 115.10 us | 2 | |
CREATE TABLE sessions (id INT PRIMARY KEY, last_seen TIMESTAMP) | 601.70 us | 1 | 601.70 us | 601.70 us | 1 | |
SELECT id, customer_id FROM orders ORDER BY id DESC LIMIT ? | 593.40 us | 2 | 506.30 us | 506.30 us | 4 | |
SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? | 577.50 us | 60 | 8.50 us | 28.30 us | 2 | |
CREATE TABLE customer_balances (customer_id INT PRIMARY KEY, orders_count INT, lifetime_spend DECIMAL(?,?), last_order_at TIMESTAMP, updated_at TIMESTAMP) | 560.10 us | 1 | 560.10 us | 560.10 us | 1 | |
INSERT INTO products (sku, name, category, price, stock_qty) VALUES (?, ?, ?, ?, ?) | 520.70 us | 1 | 520.70 us | 520.70 us | 2 | |
SELECT ID, NAME FROM CUSTOMERS WHERE ID = ? | 506.50 us | 50 | 9.30 us | 31.70 us | 2 | |
SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | 462.40 us | 1 | 462.40 us | 462.40 us | 2 | |
MERGE INTO SETTINGS (K, V) KEY(K) VALUES (?, ?) | 258.40 us | 3 | 54.60 us | 150.30 us | 4 | |
SELECT id, kind, payload, attempts FROM outbox_events WHERE status = ? ORDER BY id LIMIT ? | 56.00 us | 1 | 56.00 us | 56.00 us | 2 | |
SELECT COUNT(*) FROM audit | 53.10 us | 1 | 53.10 us | 53.10 us | 2 |
Every table touched in this recording with its readers and writers. Tables labelled read-only had no writes during capture — that makes them the cleanest cache candidates, but the label is only ever a lower bound on safety (writes outside the recording window stay invisible). For read/write tables, the writer call-site count is the number of places that need invalidation (or write-through) hooks. Source-scan is enabled: each row also shows static readers/writers seen in .java files. A UNEXERCISED WRITES badge means the source has writer sites that didn't run during this recording — the real answer to 'is it safe to cache?'.
orders 794 reads · 600 writes · 13 reader sites · 7 writer sites · 9 ops · static: 8 readers / 5 writersSELECT MIN(ID) FROM ORDERS WHERE CUSTOMER_ID = ? AND ID > ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readNextDetail:111 · 158×SELECT ID, AMOUNT, STATUS FROM ORDERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readDetailFields:125 · 108×SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37 · 100×SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 100×SELECT SUM(amount) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.sumAmountByCustomer:65 · 100×SELECT shipped_at FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.latestOrderAtByCustomer:80 · 100×SELECT ID, AMOUNT, STATUS FROM ORDERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CodeLookupService.readOrder:67 · 60×SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 30×SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1 — fi.vesas.jdbclens.sample.dao.OrderDao.findLatestByCustomer:37 · 25×SELECT COUNT(*) FROM orders WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.countByCustomer:55 · 10×SELECT id, customer_id FROM orders ORDER BY id DESC LIMIT ? — fi.vesas.jdbclens.sample.dao.OrderDao.findRecent:20 · 1×SELECT id, customer_id FROM orders ORDER BY id DESC LIMIT ? — fi.vesas.jdbclens.sample.dao.OrderDao.findRecent:20 · 1×SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o.amount) DESC LIMIT ? — fi.vesas.jdbclens.sample.service.OrderReportService.topCustomersBySpend:40 · 1×INSERT INTO orders (customer_id, amount) VALUES (?, ?) — fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 · 200×INSERT INTO orders (customer_id, amount) VALUES (?, ?) — fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 · 200×UPDATE orders SET amount = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateAmount:118 · 100× · SET amountINSERT INTO orders (customer_id, amount) VALUES (?, ?) — fi.vesas.jdbclens.sample.dao.OrderDao.insert:91 · 25×UPDATE orders SET refunded = TRUE WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markRefunded:47 · 25× · SET refundedUPDATE orders SET status = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.updateStatus:100 · 25× · SET statusUPDATE orders SET shipped_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OrderDao.markShipped:109 · 25× · SET shipped_atSELECT ID, AMOUNT, STATUS FROM ORDERS WHERE ID = ?SELECT MIN(ID) FROM ORDERS WHERE CUSTOMER_ID = ? AND ID > ?SELECT ID, AMOUNT, STATUS FROM ORDERS WHERE ID = ?SELECT id, customer_id FROM orders ORDER BY id DESC LIMIT ?SELECT id, amount FROM orders WHERE customer_id = ? ORDER BY id DESC LIMIT 1SELECT COUNT(*) FROM orders WHERE customer_id = ?SELECT SUM(amount) FROM orders WHERE customer_id = ?SELECT shipped_at FROM orders WHERE customer_id = ?UPDATE orders SET refunded = TRUE WHERE id = ?INSERT INTO orders (customer_id, amount) VALUES (?, ?)UPDATE orders SET status = ? WHERE id = ?UPDATE orders SET shipped_at = ? WHERE id = ?UPDATE orders SET amount = ? WHERE id = ?customers 667 reads · 146 writes · 14 reader sites · 4 writer sites · 9 ops · static: 8 readers / 3 writersSELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 200×SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 60×SELECT MIN(ID) FROM CUSTOMERS WHERE ID > ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readNextKey:79 · 60×SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.readMasterRecord:93 · 60×SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.invalidKeyCheck:120 · 60×SELECT MIN(ID) FROM CUSTOMERS WHERE ID > ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readNextMaster:84 · 50×SELECT ID, NAME FROM CUSTOMERS WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.readMasterFields:98 · 50×SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 30×SELECT name FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findById:14 · 25×SELECT email FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findEmailById:24 · 25×SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 25×SELECT id, name, email FROM customers LIMIT ? OFFSET ? — fi.vesas.jdbclens.sample.service.PaginatedExportService.fetchPage:42 · 11×SELECT id, name, email, phone, address_line, city, state, postal_code, country, timezone FROM customers WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.findFullById:41 · 10×SELECT c.id, c.name, COUNT(o.id), SUM(o.amount) FROM orders o JOIN customers c ON c.id = o.customer_id GROUP BY c.id, c.name ORDER BY SUM(o.amount) DESC LIMIT ? — fi.vesas.jdbclens.sample.service.OrderReportService.topCustomersBySpend:40 · 1×UPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 60× · SET name, email, phone, address_line, city, state, postal_code, country, timezoneUPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ? — fi.vesas.jdbclens.sample.cobol.CustomerMasterBatchJob.rewriteMasterRecord:112 · 60× · SET name, countryUPDATE customers SET name = ?, email = ?, phone = ?, address_line = ?, city = ?, state = ?, postal_code = ?, country = ?, timezone = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.CustomerDao.updateAll:73 · 25× · SET name, email, phone, address_line, city, state, postal_code, country, timezoneINSERT INTO customers (id, name, email, phone, address_line, city, state, postal_code, country, timezone) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) — fi.vesas.jdbclens.capture.CapturingPreparedStatement.executeBatch:301 · 1×SELECT MIN(ID) FROM CUSTOMERS WHERE ID > ?SELECT ID, NAME, EMAIL, COUNTRY FROM CUSTOMERS WHERE ID = ?SELECT COUNT(*) FROM CUSTOMERS WHERE ID = ?SELECT MIN(ID) FROM CUSTOMERS WHERE ID > ?SELECT ID, NAME FROM CUSTOMERS WHERE ID = ?SELECT name FROM customers WHERE id = ?SELECT email FROM customers WHERE id = ?SELECT id, name, email FROM customers LIMIT ? OFFSET ?UPDATE CUSTOMERS SET NAME = ?, COUNTRY = ? WHERE ID = ?UPDATE customers SET name = ?, email = ?, phone = ?,INSERT INTO customers (id, name, email, phone, address_line,settings 430 reads · 1 writes · 6 reader sites · 1 writer sites · 3 ops · static: 4 readers / 1 writersSELECT v FROM settings WHERE k = ? — fi.vesas.jdbclens.sample.dao.SettingsDao.getByKey:14 · 200×SELECT V FROM SETTINGS WHERE K = ? — fi.vesas.jdbclens.sample.cobol.CodeLookupService.resolveCurrencyLabel:79 · 60×SELECT V FROM SETTINGS WHERE K = ? — fi.vesas.jdbclens.sample.cobol.CodeLookupService.resolveStatusLabel:89 · 60×SELECT V FROM SETTINGS WHERE K = ? — fi.vesas.jdbclens.sample.cobol.CodeLookupService.resolveShippingLabel:99 · 60×SELECT v FROM settings WHERE k = ? — fi.vesas.jdbclens.sample.dao.SettingsDao.getByKey:14 · 25×SELECT v FROM settings WHERE k = ? — fi.vesas.jdbclens.sample.dao.SettingsDao.getByKey:14 · 25×INSERT INTO settings (k, v) VALUES (?, ?), (?, ?) — fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203 · 1×SELECT V FROM SETTINGS WHERE K = ?SELECT V FROM SETTINGS WHERE K = ?SELECT V FROM SETTINGS WHERE K = ?SELECT v FROM settings WHERE k = ?INSERT INTO settings (k, v) VALUEScustomer_balances 100 reads · 100 writes · 1 reader sites · 1 writer sites · 1 ops · static: 0 readers / 2 writersSELECT customer_id, orders_count, lifetime_spend, last_order_at FROM customer_balances WHERE customer_id = ? — fi.vesas.jdbclens.sample.dao.BalanceDao.findByCustomer:31 · 100×INSERT INTO customer_balances (customer_id, orders_count, lifetime_spend, last_order_at, updated_at) VALUES (?, ?, ?, ?, ?) — fi.vesas.jdbclens.sample.dao.BalanceDao.insert:51 · 100×INSERT INTO customer_balancesUPDATE customer_balances SET orders_count = ?,products 4 reads · 1 writes · 4 reader sites · 1 writer sites · 1 ops · static: 2 readers / 1 writersSELECT id, name, price FROM products WHERE name LIKE ? — fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20 · 1×SELECT id, name, price FROM products WHERE name LIKE ? — fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20 · 1×SELECT id, name, price FROM products WHERE name LIKE ? — fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20 · 1×SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) — fi.vesas.jdbclens.sample.dao.ProductDao.findByIds:44 · 1×INSERT INTO products (sku, name, category, price, stock_qty) VALUES (?, ?, ?, ?, ?) — fi.vesas.jdbclens.capture.CapturingPreparedStatement.executeBatch:301 · 1×SELECT id, name, price FROM products WHERE name LIKE ?SELECT id, name, price FROM products WHERE id IN (INSERT INTO products (sku, name, category, price, stock_qty)audit 1 reads · 198 writes · 1 reader sites · 6 writer sites · 1 ops · static: 1 readers / 3 writersSELECT COUNT(*) FROM audit — fi.vesas.jdbclens.sample.service.PurgeService.trimAuditLog:28 · 1×INSERT INTO AUDIT (KIND, PAYLOAD, TS) VALUES (?, ?, ?) — fi.vesas.jdbclens.sample.cobol.MasterDetailMergeJob.writeMasterBreak:145 · 50×INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP) — fi.vesas.jdbclens.sample.dao.AuditDao.log:14 · 43×INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP) — fi.vesas.jdbclens.sample.dao.AuditDao.log:14 · 30×INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP) — fi.vesas.jdbclens.sample.dao.AuditDao.log:14 · 25×INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP) — fi.vesas.jdbclens.sample.dao.AuditDao.log:14 · 25×INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP) — fi.vesas.jdbclens.sample.dao.AuditDao.log:14 · 25×SELECT COUNT(*) FROM auditINSERT INTO AUDIT (KIND, PAYLOAD, TS) VALUES (?, ?, ?)INSERT INTO audit (kind, payload, ts) VALUES (?, ?, CURRENT_TIMESTAMP)DELETE FROM audit WHERE id IN (SELECT id FROM audit ORDER BY id LIMIT ?)outbox_events 1 reads · 101 writes · 1 reader sites · 4 writer sites · 1 ops · static: 1 readers / 4 writersSELECT id, kind, payload, attempts FROM outbox_events WHERE status = ? ORDER BY id LIMIT ? — fi.vesas.jdbclens.sample.dao.OutboxDao.listPending:40 · 1×INSERT INTO outbox_events (kind, payload, status, created_at) VALUES (?, ?, 'PENDING', ?) — fi.vesas.jdbclens.sample.dao.OutboxDao.enqueue:30 · 50×UPDATE outbox_events SET status = 'SENT', processed_at = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OutboxDao.markSent:57 · 43× · SET status, processed_atUPDATE outbox_events SET status = 'FAILED', attempts = attempts + 1, last_error = ? WHERE id = ? — fi.vesas.jdbclens.sample.dao.OutboxDao.markFailed:67 · 7× · SET status, attempts, last_errorDELETE FROM outbox_events WHERE status = 'SENT' AND processed_at < ? — fi.vesas.jdbclens.sample.service.PurgeService.purgeProcessedOutboxEvents:21 · 1×SELECT id, kind, payload, attempts FROM outbox_eventsINSERT INTO outbox_events (kind, payload, status, created_at)UPDATE outbox_events SET status = 'SENT', processed_at = ?UPDATE outbox_events SET status = 'FAILED',DELETE FROM outbox_events WHERE status = 'SENT' AND processed_at < ?sessions 0 reads · 30 writes · 0 reader sites · 1 writer sites · 0 ops · static: 0 readers / 1 writersUPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ? — fi.vesas.jdbclens.sample.dao.SessionDao.touchLastSeen:13 · 30× · SET last_seenUPDATE sessions SET last_seen = CURRENT_TIMESTAMP WHERE id = ?Every explicit transaction reconstructed from COMMIT / ROLLBACK boundaries. The overview gives the overall transaction shape of the workload; the table below lists the longest transactions by wall-clock time. Commit-per-record runs are flagged in their own findings section above.
Top 20 explicit transactions by wall-clock duration. Useful for eyeballing outliers the detector did not otherwise flag.
| operation | thread | wall | DB | writes | reads | outcome | opening call-site |
|---|---|---|---|---|---|---|---|
| refund-latest | 1 | 135.50 ms | 632.90 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 128.15 ms | 285.20 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 126.19 ms | 304.30 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 126.11 ms | 381.90 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 126.04 ms | 545.60 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 125.38 ms | 423.50 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 125.38 ms | 525.70 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 125.37 ms | 417.90 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 125.24 ms | 321.10 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 125.08 ms | 366.90 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.91 ms | 332.10 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.70 ms | 334.90 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.70 ms | 496.60 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.62 ms | 360.50 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.52 ms | 328.00 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.36 ms | 383.60 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.22 ms | 381.40 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.19 ms | 307.40 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.07 ms | 373.80 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |
| refund-latest | 1 | 124.03 ms | 472.70 us | 2 | 1 | commit | fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66 |