I would like to turn on a profiler in Craft CMS so I can see what DB queries are being run and how long they take.
Is this possible?
Yup! Just turn on devMode in your general config:
return array(
'devMode' => true,
);
And then just open up a console (Firebug, Chrome, etc) and look in the profiling summary report.