-----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-----