op: product-search

56 events · 14.90 ms wall · 12.21 ms DB (82%) · 2.70 ms non-DB (18%)

DB 12.21 msnon-DB 2.70 ms

Transactions

Autocommit mode — every statement was its own transaction. Group related writes in one explicit transaction (and reads outside it) to cut round-trips.

#	duration	reads	max idle	outcome	longest template
1	3.22 ms	1	—	autocommit	`SELECT id, name, price FROM products WHERE name LIKE ?`
2	258.00 us	1	—	autocommit	`SELECT id, name, price FROM products WHERE name LIKE ?`
3	271.50 us	1	—	autocommit	`SELECT id, name, price FROM products WHERE name LIKE ?`
4	462.40 us	1	—	autocommit	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`

Timeline

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

+offset	gap	event	duration	template	params	call-site
0 ns	—	PREPARE	7.03 ms	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
7.19 ms	154.10 us	EXECUTE_QUERY	3.22 ms	`SELECT id, name, price FROM products WHERE name LIKE ?`	`[1] %Wireless%`	`fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20`
11.27 ms	869.50 us	NEXT	12.40 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.88 ms	599.10 us	NEXT	1.60 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.89 ms	4.60 us	NEXT	800 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.89 ms	2.60 us	NEXT	500 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.90 ms	2.30 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.90 ms	2.20 us	NEXT	1.80 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.90 ms	1.60 us	CLOSE	7.00 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
11.91 ms	3.00 us	CLOSE	3.70 us	—	—	`stack[-1]`
11.93 ms	11.50 us	PREPARE	8.50 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
12.06 ms	124.60 us	EXECUTE_QUERY	258.00 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	`[1] %Java%`	`fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20`
12.42 ms	106.20 us	NEXT	1.60 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.43 ms	4.50 us	NEXT	500 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.43 ms	2.40 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.44 ms	2.10 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.44 ms	2.10 us	NEXT	600 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.44 ms	500 ns	CLOSE	700 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.44 ms	600 ns	CLOSE	1.40 us	—	—	`stack[-1]`
12.45 ms	6.00 us	PREPARE	5.80 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
12.52 ms	63.60 us	EXECUTE_QUERY	271.50 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	`[1] %Model%`	`fi.vesas.jdbclens.sample.dao.ProductDao.findByNameLike:20`
12.87 ms	82.90 us	NEXT	1.30 us	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.88 ms	3.70 us	NEXT	500 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.88 ms	2.00 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.88 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.88 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.89 ms	1.70 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.89 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.89 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.89 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.89 ms	1.60 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.90 ms	1.60 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.90 ms	2.00 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.90 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.90 ms	1.60 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.90 ms	1.60 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.91 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.91 ms	1.80 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.91 ms	1.70 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.91 ms	400 ns	CLOSE	500 ns	`SELECT id, name, price FROM products WHERE name LIKE ?`	—	`stack[-1]`
12.91 ms	500 ns	CLOSE	1.10 us	—	—	`stack[-1]`
13.34 ms	426.30 us	PREPARE	900.20 us	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`fi.vesas.jdbclens.capture.CapturingConnection.wrapPrepared:66`
14.35 ms	105.90 us	EXECUTE_QUERY	462.40 us	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	`[1] 1, [2] 3, [3] 5, [4] 8, [5] 12, [6] 15, [7] 20, [8] 25, [9] 30, [10] 35`	`fi.vesas.jdbclens.sample.dao.ProductDao.findByIds:44`
14.87 ms	64.70 us	NEXT	1.30 us	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.88 ms	4.10 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.88 ms	1.90 us	NEXT	400 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.88 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.88 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.89 ms	1.70 us	NEXT	1.10 us	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.89 ms	1.80 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.89 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.89 ms	1.80 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.90 ms	1.70 us	NEXT	300 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.90 ms	1.60 us	NEXT	500 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.90 ms	400 ns	CLOSE	700 ns	`SELECT id, name, price FROM products WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`	—	`stack[-1]`
14.90 ms	400 ns	CLOSE	1.10 us	—	—	`stack[-1]`