Add page_header() and page_footer() calls to admin.php so it shows the querylog. Also add a message_acess() if an unauthorized user browses to this page.

Also, enhance the querylog acccoridng to this post by Dries:

"And what about extending the SQL query log (see "settings
and filters") such that it shows successes and fails just like update.php does?"

Comments

moshe weitzman’s picture

moshe weitzman commented

what other interesting things may be discovered about a query? in db_query(), is it possible to know:

- how long a query took to execute
- which line or function called into db_query() (i.e. the call stack).

Also, is there some code out there for pretty printing SQL queries, similar to syntax highlighting in text editors.

Anonymous’s picture

(not verified) commented

Some of this has been done already.

Execution time isn't in yet.

Can we even trace the calling function? I don't think PHP currently has this functionailty out of the box. It should be in PHP 5.

moshe weitzman’s picture

moshe weitzman commented
Component: Code » Node system
Priority: Major » Normal

Closed. See Contrib -> Modules -> devel.module