CiviCRM Community Forums (archive)

hey,

i was wondering what the best way to display the mysql queries that are run during page load is.

in the end, i turned on query logging in mysql because i couldn't see a CiviCRM way of doing it, but that file was getting huge pretty quickly and it wasn't easy to navigate (lots of unecessary queries) I thought there was maybe a constant i could define in civicrm.settings.php that would output all queries at the top of the page / in a pop up somwhere, but i can't find that documented. maybe i imagined it...

FWIW, the reason I wanted to do this was that in 2.2.3 the activities tab was showing an artificially high count for activities for contacts that had sent emails.  Turns out that it was counting a email to 30 people as 30 activities, whereas it was only showing as one row in the activity tab.  (I guess this maybe fixed now and i did try and replicate on demo but there is no send email functionality). 

Maybe there is a better way to debug this kind of thing.  any suggestions?

great answer, thanks