It would be great to have a built-in SQL profiler for CME and Content Delivery in Sites. For example : Adding/concatenating 'sql_profile=yes' in the URL should show all the queries running in the background for the current activity.
SDL Worldserver has already incorporated this feature where concatenating &sql_profile=yes in the URL shows all the queries running in the background for the page loaded.