How to log all Doctrine queries to file?

Question

I'm using Doctrine and want to log all generated SQL queries.

I know that I could use $q->getSqlQuery() but I don't want to do that manually each time.

Is there a way to do it automatically?

Answer 1

If you turn logging on all queries shoudl be logged to your application log in the log directory. To do this set logging_enabled to true in your settings.yml.