[oik] plugins.com

WordPress plugins and themes

  • Home
  • About
    • lazy shortcodes
    • smart shortcodes
    • oik base plugin
      • oik – donate
      • oik PayPal buttons
      • oik installation
      • oik Button Shortcode button
      • oik changelog
      • oik FAQ
      • oik plugins on SVN
      • oik plugins on GitHub
  • Plugins
    • oik base plugin
    • FREE oik plugins
    • WordPress plugins
    • Premium oik plugins
    • Bespoke oik plugins
  • Shortcodes
    • Shortcode examples
  • Blocks
    • Block examples
  • APIs
    • ALL action and filter hooks
  • Blog
You are here: Home / WordPress plugins from oik-plugins / FREE oik plugins / oik-bwtrace – debug trace for WordPress / Settings > oik action options / Action options – options / Trace ‘shutdown’ saved queries

Trace ‘shutdown’ saved queries

Select the Trace 'shutdown' saved queries checkbox to obtain a summary of the queries performed during the transaction.

The output is produced in two trace records.

  1. The WPDB global object – providing all the details.
  2. Summarised using [bw_sql] shortcodes.

Example

C:\apache\htdocs\wordpress\wp-content\plugins\oik-bwtrace\includes\oik-actions.php(153:0) bw_trace_saved_queries(1) 39 2 2019-12-04T16:26:33+00:00 0.306400 0.016622 cf=shutdown 52 3912 6291456/6291456 256M F=600 saved queries wpdb Object
(
    [show_errors] => 1
    [suppress_errors] => 
    [last_error] => 
    [num_queries] => 52
    [num_rows] => 1
    [rows_affected] => 0
    [insert_id] => 0
    [last_query] => 
		SELECT comment_approved, COUNT( * ) AS total
		FROM wp_comments
		
		GROUP BY comment_approved
	
    [last_result] => Array
        (
            [0] => stdClass Object
                (
                    [comment_approved] => 1
                    [total] => 52
                )

        )

and

C:\apache\htdocs\wordpress\wp-content\plugins\oik-bwtrace\includes\oik-actions.php(156:0) bw_trace_saved_queries(2) 40 2 2019-12-04T16:26:33+00:00 0.307534 0.001134 cf=shutdown 52 3912 6291456/6291456 256M F=600 Queries: 52 in 0.043546438217163 
<h3>Queries</h3>
[bw_sql 1 0.000951 get_option]SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1[/bw_sql]
[bw_sql 2 0.001354 WP_User::get_data_by]SELECT * FROM wp_users WHERE user_login = 'wp' LIMIT 1[/bw_sql]
[bw_sql 3 0.001507 update_meta_cache]SELECT user_id&comma;  meta_key&comma;  meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC[/bw_sql]

Notes

  • In my experience the elapsed time of the SQL queries hardly ever reveals a performance problem with data access.
  • When this option is selected the Daily Trace Summary report will show the Query time.
  • See bw_trace_saved_queries().

Published: December 4, 2019 | Last updated: December 1, 2020

Information

Component:
  • oik-bwtrace – debug trace for WordPress
Letters: T

Recent plugin updates

oik-weight-zone-shipping v0.2.2 

Upgrade to oik-weight-zone-shipping v0.2.2 for internationalized strings for migration. This version may also resolve a problem where a Warning message is produced while listing Shipping classes.

 ...
oik-weight-zone-shipping v0.2.1 

oik-weight-zone-shipping v0.2.1 fixes a problem with v0.2.0 on worpress.org, where two new files weren't included in the SVN repository.

 ...
oik-weightcountry-shipping v1.4.0 

oik-weightcountry-shipping v1.4.0 has been tested with WordPress 5.6 and WooCommerce 4.8.0. It is no longer supported. We suggest you switch to the oik weight zone shipping plugin.

 ...
oik-weight-zone-shipping v0.2.0 

oik-weight-zone-shipping v0.2.0 now supports migration from oik weight/country shipping. You can create Multi Rate shipping tables and methods restricting shipping classes.

 ...
oik-css v1.1.1 

oik-css v1.1.1 contains an update for improved compatibility with Gutenberg. It has been tested with WordPress 5.6 and WordPress Multi Site.

 ...

Plugins

  • All Plugins
  • oik base plugin
  • FREE oik plugins
  • WordPress plugins
  • Premium oik plugins

Themes

  • FREE themes
  • Bespoke themes
  • Premium themes

Blocks

  • All Blocks
  • Block examples
  • About Blocks

Shortcodes

  • All Shortcodes
  • Shortcode examples
  • About Shortcodes

Reference

  • About APIs
  • All APIs
  • All Classes
  • All Files
  • All Hooks

Support

  • Contact
  • Cookies policy
  • Get API key
  • Privacy
  • Request support
  • Sitemap
  • Stay informed
  • Terms and Conditions
oik-plugins
Email: [email protected]

Weight shipping plugins

Find out which cart weight shipping plugin you need for your WooCommerce site.
Which cart weight based plugin do I need?

Site:  www.oik-plugins.com
© Copyright oik-plugins 2011-2021. All rights reserved.


Website designed and developed by Herb Miller of Bobbing Wide
Proudly powered by WordPress and oik-plugins