Categories

  • Access & Security 95
  • Administration 172
  • Advertisement 92
  • Audio & Video 66
  • Author & Content 99
  • Comments 96
  • Communication 110
  • Communities & Forums 84
  • Development 47
  • E-Commerce 76
  • Email Management 53
  • Events & Calendars 80
  • Language 25
  • Map & Weather 44
  • Migration & Conversion 28
  • Miscellaneous 254
  • Mobile 15
  • Photos 143
  • Plugins 260
  • SEO & Site Speed 118
  • Social 186
  • Theme Enhancement 169



  • Add this plugin to a List

    You need to be logged in to add this plugin to your list.

    Debug Queries

    Add to List

    List query-actions only for admins; for debug purposes. See all queries on the frontend of the blog and find the slowest part.

    New release, new Plugin

    Please use the plugin Debug Objects, provides more information and a cleaner query view as this older plugin.
    The new solution list also the plugin and core queries in different views.

    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 QUERY_CACHE_TYPE_OFF to FALSE.

    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.

    Params

    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 QUERY_CACHE_TYPE_OFF to FALSE.

    Example

    This is a example for evaluation.

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

    Acknowledgements

    Thanks to Joost de Valk on yoast.com for small modifed on the plugin for some extra info.

    Licence

    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 small donation 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 😉

    Rate This Plugin

    Please Login to Rate this Plugin!

    Function

    Feature

    Support

    0 Votes
    Not Rated Yet

    Wordpress.org Stats

    Ratings3.7
    Votes3
    Downloads42,529
    Last Updated762 Days ago
    Published10 years ago

    Report Wrong Category!