DBIx::ShowCaller
This module, when used instead of the DBI module, will prefix each SQL command with a comment with an info about the Perl file and line that issued the prepare, do or selectall_* call. It then makes it easier to debug the system using for example command cache and logs of the database server. The SQL commands look like
/* /www/scripts/script.pl at line 25 */ select name from prodcuts where id = ?
The module includes a man page with more info.
Download DBIx-ShowCaller-0.80.tar.gz, the latest release.