# 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