shawfactor

<p>This plugin logs all wordpress queries in the current page request as a html comment at the end of your output.</p>
<p>It only does so when the get variable lh_log_queries is set. That variable has three settings.<br />
1. queries: this logs queries only<br />
2. hooks: this logs hooks only<br />
3. both: this logs both hooks and filters</p>
<p><strong>Like this plugin? Please consider <a href="https://wordpress.org/support/view/plugin-reviews/lh-log-queries/" rel="ugc">leaving a 5-star review</a>.</strong></p>
<p><strong>Love this plugin or want to help the LocalHero Project? Please consider <a href="https://lhero.org/portfolio/lh-log-queries/" rel="nofollow ugc">making a donation</a>.</strong></p>


LH Log Queries and hooks

Decisions not options for query and hook logging

Frank Bueltge

Inpsyde GmbH

<p>List query-actions only for admins; for debug purposes. See all queries on the frontend of the blog and find the slowest part.</p>
<h4>New release, new Plugin</h4>
<p>Please use the plugin <a href="https://wordpress.org/extend/plugins/debug-objects/" rel="ugc">Debug Objects</a>, provides more information and a cleaner query view as this older plugin.<br />
The new solution list also the plugin and core queries in different views.</p>
<p>Since version 1.0.0 the plugin disable the MySQL query cache for the current connected session. That will show you the real execution time for a query. To disable this behavior set the constant <code>QUERY_CACHE_TYPE_OFF</code> to <code>FALSE</code>.</p>
<p>The plugin is perfect for WordPress developers, plugin and theme developers and site administrators who are trying to find out why the blog is too slow.</p>
<h4>Params</h4>
<p>The plugin has since version 1.0.0 a constant to disable the mySQL Session cache. On defoult is the value on true and the cache is off for an better analyse! For change this, set the constant <code>QUERY_CACHE_TYPE_OFF</code> to <code>FALSE</code>.</p>
<h4>Example</h4>
<p>This is a example for evaluation.</p>
<pre><code># Time: 0.00198888778687
Query: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
Call from: require, require_once, require_once, require_once, is_blog_installed, wp_load_alloptions
# Time: 0.000695943832397
Query: UPDATE 'wp_options' SET 'option_value' = 'a:3:{i:0;b:0;s:25:\"adminimize/adminimize.php\";a:2:{i:0;O:10:\"adminimize\":1:{s:12:\"wp_filter_id\";i:0;}i:1;s:12:\"on_deinstall\";}s:31:\"debug_queries/debug_queries.php\";a:2:{i:0;O:12:\"DebugQueries\":1:{s:12:\"wp_filter_id\";i:0;}i:1;s:10:\"deactivate\";}}' WHERE 'option_name' = 'uninstall_plugins'
Call from: require, require_once, require_once, require_once, include_once, adminimize->adminimize, register_uninstall_hook, update_option

. . .

Total query time: 0.0155501365662 for 23 queries.
Total num_query time: 0.392 for 23 num_queries.
</code></pre>
<h4>Acknowledgements</h4>
<p>Thanks to Joost de Valk on <a href="http://yoast.com/" title="yoast.com" rel="nofollow ugc">yoast.com</a> for small modifed on the plugin for some extra info.</p>
<h4>Licence</h4>
<p>Good news, this plugin is free for everyone! Since it’s released under the GPL, you can use it free of charge on your personal or commercial blog. But if you enjoy this plugin, you can thank me and leave a <a href="http://bueltge.de/wunschliste/" title="Wishliste and Donate" rel="nofollow ugc">small donation</a> for the time I’ve spent writing and supporting this plugin. And I really don’t want to know how many hours of my life this plugin has already eaten 😉</p>


Debug Queries

List query-actions only for admins; for debug purposes

LH Log Queries and hooks vs Debug Queries