[development] how to restore devel.module query log in HEAD
Gerhard Killesreiter
gerhard at killesreiter.de
Fri Aug 22 17:51:28 UTC 2008
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Moshe Weitzman schrieb:
> I'd appreciate suggestions on how to implement the query log for
> devel.module now that the new DB layer has landed. I've already
> submitted a patch to add timing info: http://drupal.org/node/298669
>
> But, it seems that PDO will not show us the SQL that was executed for
> any given prepared statement. We have access to the statement with
> placeholders, but that can be verbose as sin, and can't be copy/pasted
> into a console. Here is a statement for cache_set():
>
> INSERT INTO {cache_registry} (serialized, created, expire, headers,
> DATA, cid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1,
> :db_insert_placeholder_2, :db_insert_placeholder_3,
> :db_insert_placeholder_4, :db_insert_placeholder_5) ON DUPLICATE KEY
> UPDATE serialized=:db_update_placeholder_0,
> created=:db_update_placeholder_1, expire=:db_update_placeholder_2,
> headers=:db_update_placeholder_3, DATA=:db_update_placeholder_4
>
> Not so readable, eh?
If you just replace db_update_placeholder by something shorter, it
wouldn't be a problem, I think.
Cheers,
Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFIrvyffg6TFvELooQRAqBJAJ9nCCW04gAfgFExBAjzC9yB5/O+qQCfWMRC
sEPoBQkhK2BqocOW7vhmVmU=
=9Ymo
-----END PGP SIGNATURE-----
More information about the development
mailing list