php – 从PDO准备语句中检索(或模拟)完整查询

Is there a way to get the raw sql string executed when calling PDOStatement::execute() on a prepared statement? For debugging purposes this would be extremely useful.

获胜的答案说明

[…] You can also get what you want if you
set the PDO attribute
PDO::ATTR_EMULATE_PREPARES. In this
mode,PDO interpolate parameters into
the sql query and sends the whole
query when you execute().

但是没有提到如何获取生成的查询字符串.我知道这是一个不错的主意性能明智,但这并不打扰我在调试模式.有人知道该怎么做吗

PS如果有一些方法我可以重新开始/提请注意原来的两年老话题,而不是开一个新话题,请让我知道.