rendered paste body# dtrace -n 'pid$target::*mysql_parse*:entry { @[copyinstr(arg1)] = count(); }' -p `pgrep -x mysqld`
dtrace: description 'pid$target::*mysql_parse*:entry ' matched 1 probe
^C
SELECT id,genre FROM genre WHERE genre = "African" 1
SELECT id,genre FROM genre WHERE genre = "Jazz" 1
SELECT id,genre FROM genre WHERE genre = "Latin" 1
SELECT id,genre FROM genre WHERE genre = "Modern" 1
SELECT id,genre FROM genre WHERE genre = "Radio Drama" 1
SELECT id,genre FROM genre WHERE genre = "Rock" 1
SELECT id,genre FROM genre WHERE genre = "Unclassifiable" 1
SELECT id,genre FROM genre WHERE genre = "World" 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND MATCH( title, instruments, description, feel ) AGAINST ( "+angry " in boolean m 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND MATCH( title, instruments, description, feel ) AGAINST ( "+angry +music " in bo 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND MATCH( title, instruments, description, feel ) AGAINST ( "+movie " in boolean m 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND MATCH( title, instruments, description, feel ) AGAINST ( "+movie +themes " in b 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND MATCH( title, instruments, description, feel ) AGAINST ( "+snooze " in boolean 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 11 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 12 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 13 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 17 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 19 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 2 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 24 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 25 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND p.feel LIKE "%Action%" ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND p.feel LIKE "%Bright%" ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND p.feel LIKE "%Calming%" ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND p.feel LIKE "%Dark%" ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 1
SELECT id,genre FROM genre WHERE genre = "Acid Jazz" 2
SELECT id,genre FROM genre WHERE genre = "Funk" 2
SELECT id,genre FROM genre WHERE genre = "Holiday" 2
SELECT id,genre FROM genre WHERE genre = "Pop" 2
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND MATCH( title, instruments, description, feel ) AGAINST ( "+christmas " in boole 2
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 1 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 2
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 16 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 2
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 8 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 2
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 9 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 2
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND p.feel LIKE "%Mystical%" ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 2
SELECT id,genre FROM genre WHERE genre = "Soundtrack" 3
SELECT p.uuid, p.title, p.filename, p.length, p.instruments, g.genre, p.bpm, p.year, p.description, p.feel, p.uploaded, p.pick FROM pieces p, genre g WHERE p.genre = g.id AND g.id = 22 ORDER BY p.pick DESC, p.uploaded DESC, p.year DESC 3
SELECT feel FROM pieces 38
SELECT id,genre FROM genre ORDER BY genre 38