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

How can I see the开发者_运维百科 SQL statements which go to the database when using PDO?

If you are using MySQL, enable the query log?

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.