When using Doctrine 1.X and 2.X with symfony1.X and Symfony2.X we found ourselves often not being able to use the profiler to get runnable queries. Often this was due to background processing in the application, for example via Gearman. To convert queries we wrote up this quick script. Just copy and paste the log line from the starting SQL to the end (including brackets and parameters), select your Doctrine version and click submit. We'll output the runnable version of the query with the parameters plugged in. No queries are saved to our server.