Start with "Switch on tracing", this module trace every queries performed behind the scene, store them and push the stored queries to another server on request.
Provides a visual testing page for Drupal themes. Quickly compare the display of common elements across your themes, and verify that your new theme addresses all common style elements.