How can I see the SQL statements which go to the database when using PDO?

Question

How can I see the SQL statements which go to the database when using PDO?

Answer 1

I don't know how to do this with bare PDO, but if you wrap PDO in a Zend_Db_Adapter, then you can use Zend_Db_Profiler.

Then you'll be able to see the parameterized queries, together with the parameter values. Also, its profiling, i.e. measuring the query execution times.

Answer 2

If you are using MySQL, enable the query log?