If you use DBI::Profile fomr the DBI distribution it will log the SQL for you along with some profiling data as you execute the queries.

DBI::Profile produces much less output than DBI::Trace

hth,