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

Question

You are using prepared statements and wonder if `WHERE x=:x AND y=:y` is somewhere "translated" to `WHERE x='abc' AND y='xyz'` and if you can inspect it? — VolkerK, Dec 22 '09 at 11:05
I just realized that my question is basically a dupe: http://stackoverflow.com/questions/2411182/how-to-debug-pdo-database-queries Some good suggestions were left there, too. — Nathan Long, Mar 09 '10 at 18:25

score 1 · Answer 1 · answered Dec 22 '09 at 11:56

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.

score 1 · Accepted Answer · answered Dec 22 '09 at 12:05

1

If you are using MySQL, enable the query log?

answered Dec 22 '09 at 12:05

keimol

26
1

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

2 Answers2