Find Slow WordPress or WooCommerce Database Queries with WP-CLI

Slow database queries can really kill the performance and user experience of your WordPress site or WooCommerce store. Most users will try Query Monitor to identify slow MySQL queries on their site which is a fantastic plugin. If you want to gather data over time you can use New Relic which is incredibly valuable.

Today we weill use a WP-CLI package called query-debug made by the creator of WP-CLI himself Daniel Bachhuber.

Using WP-CLI to Find Slow Database Queries

Install the query-debug WP-CLI package

wp package install runcommand/query-debug --allow-root

The basic usage of this WP-CLI command to find slow queries is this, very simple

wp query-debug --allow-root

Output

Loading https://wpbulletdev.com/ executed 516 queries in 0.509073 seconds. Use --format=table to see the full list.

You can also track the queries for a specific URL by adding the --url parameter

wp query-debug --allow-root --url="https://guides.wp-bullet.com/fixing-wp_options-table-missing-unique-column-primary-key/"

Output

Loading https://guides.wp-bullet.com/fixing-wp_options-table-missing-unique-column-primary-key executed 99 queries in 0.150912 seconds. Use --format=table to see the full list.

So if you have a WooCommerce shop category page you could find any slow queries like this

wp query-debug --url="https://www.degros.nl/product-categorie/kappersgroothandel/" --allow-root

Output not showing any slow queries really but you could dig further with wp profile following this tutorial.

Loading https://www.degros.nl/product-categorie/kappersgroothandel executed 288 queries in 0.253751 seconds. Use --format=table to see the full list.

You could even make a list of pages to test for high MySQL database query time with a bash script like this

WPPATH=""

WPFLAGS="--path=${WPPATH} --allow-root"

WPCLIPATH=$(which wp)

# Install profile and doctor commands
# WP-CLI query-debug command check and install
PACKAGEQUERY=$(wp package list | grep -i 'query-debug')

# install query-debug if necessary
if [[ -z "${PACKAGEQUERY}" ]] ; then
    echo "Installing WP-CLI query-debug"
    #wget -q https://goo.gl/1YNEmw -O - | bash > /dev/null 2>&1
    php -d memory_limit=-1 ${WPCLIPATH} package install runcommand/query-debug ${WPFLAGS}
fi

# list of URLs to check
URLS=(
https://www.degros.nl/
https://www.degros.nl/product-categorie/kappersgroothandel/
)

# run the query-debug command for each URL
for URL in ${URLS[@]}
do
    echo "Testing ${URL} queries"
    ${WPCLIPATH} query-debug --url="${URL}" ${WPFLAGS}
done

We can also get a debug summary by adding the --debug flag

wp query-debug --debug --allow-root

Output

Debug (bootstrap): Loading packages from: /root/.wp-cli/packages/vendor/autoload.php (0.016s)
Debug (bootstrap): Loading detected autoloader: /root/.wp-cli/packages/vendor/autoload.php (0.017s)
Debug (commands): Adding command: plugin (0.038s)
Debug (commands): Adding command: theme (0.041s)
Debug (commands): Adding command: mod in theme Namespace (0.042s)
Debug (commands): Adding command: comment (0.045s)
Debug (commands): Adding command: meta in comment Namespace (0.048s)
Debug (commands): Adding command: menu (0.049s)
Debug (commands): Adding command: item in menu Namespace (0.05s)
Debug (commands): Adding command: location in menu Namespace (0.051s)
Debug (commands): Deferring command: network meta (0.051s)
Debug (commands): Adding command: option (0.053s)
Debug (commands): Adding command: post (0.055s)
Debug (commands): Adding command: meta in post Namespace (0.056s)
Debug (commands): Adding command: term in post Namespace (0.058s)
Debug (commands): Adding command: post-type (0.059s)
Debug (commands): Adding command: site (0.061s)
Debug (commands): Adding command: meta in site Namespace (0.062s)
Debug (commands): Adding command: option in site Namespace (0.064s)
Debug (commands): Adding command: taxonomy (0.065s)
Debug (commands): Adding command: term (0.067s)
Debug (commands): Adding command: meta in term Namespace (0.068s)
Debug (commands): Adding command: user (0.07s)
Debug (commands): Adding command: meta in user Namespace (0.072s)
Debug (commands): Adding command: session in user Namespace (0.073s)
Debug (commands): Adding command: term in user Namespace (0.074s)
Debug (commands): Adding command: network (0.074s)
Debug (hooks): Processing hook "after_add_command:network" with 1 callbacks (0.074s)
Debug (hooks): On hook "after_add_command:network": Closure in file phar:///usr/bin/wp/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 634 (0.074s)
Debug (commands): Adding command: meta in network Namespace (0.075s)
Debug (commands): Adding command: core (0.076s)
Debug (commands): Adding command: verify-checksums in core Namespace (0.077s)
Debug (commands): Adding command: verify-checksums in plugin Namespace (0.079s)
Debug (commands): Adding command: core (0.084s)
Debug (commands): Adding command: cron (0.085s)
Debug (commands): Adding command: event in cron Namespace (0.087s)
Debug (commands): Adding command: schedule in cron Namespace (0.087s)
Debug (commands): Deferring command: language core (0.089s)
Debug (commands): Deferring command: language plugin (0.09s)
Debug (commands): Deferring command: language theme (0.091s)
Debug (hooks): Immediately invoking on passed hook "after_add_command:site": Closure in file /root/.wp-cli/packages/vendor/wp-cli/language-command/language-command.php at line 39 (0.091s)
Debug (commands): Adding command: switch-language in site Namespace (0.092s)
Debug (commands): Adding command: language (0.092s)
Debug (hooks): Processing hook "after_add_command:language" with 3 callbacks (0.092s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///usr/bin/wp/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 634 (0.093s)
Debug (commands): Adding command: core in language Namespace (0.093s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///usr/bin/wp/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 634 (0.093s)
Debug (commands): Adding command: plugin in language Namespace (0.093s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///usr/bin/wp/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 634 (0.093s)
Debug (commands): Adding command: theme in language Namespace (0.093s)
Debug (commands): Adding command: vuln (0.098s)
Debug (commands): Adding command: query-debug (0.101s)
Debug (commands): Adding command: doctor (0.105s)
Debug (commandfactory): No doc comment for profile. (0.109s)
Debug (commands): Adding command: profile (0.11s)
Debug (bootstrap): Fallback autoloader paths: phar://wp-cli.phar/vendor/autoload.php (0.115s)
Debug (bootstrap): Loading detected autoloader: phar://wp-cli.phar/vendor/autoload.php (0.115s)
Debug (commands): Adding command: cache (0.117s)
Debug (commands): Adding command: transient (0.119s)
Debug (commands): Adding command: db (0.122s)
Debug (commands): Adding command: scaffold (0.126s)
Debug (commands): Adding command: export (0.127s)
Debug (commands): Adding command: config (0.129s)
Debug (commands): Adding command: eval (0.129s)
Debug (commands): Adding command: eval-file (0.13s)
Debug (commands): Adding command: import (0.131s)
Debug (commands): Adding command: media (0.134s)
Debug (commands): Adding command: package (0.136s)
Debug (commands): Adding command: embed (0.137s)
Debug (commands): Adding command: fetch in embed Namespace (0.137s)
Debug (commands): Adding command: provider in embed Namespace (0.138s)
Debug (commands): Adding command: handler in embed Namespace (0.138s)
Debug (commands): Adding command: cache in embed Namespace (0.139s)
Debug (commands): Adding command: i18n (0.139s)
Debug (commands): Adding command: make-pot in i18n Namespace (0.141s)
Debug (commands): Adding command: make-json in i18n Namespace (0.141s)
Debug (commands): Adding command: maintenance-mode (0.142s)
Debug (commands): Adding command: rewrite (0.143s)
Debug (commands): Adding command: rewrite (0.143s)
Debug (commands): Adding command: cap (0.144s)
Debug (commands): Adding command: role (0.145s)
Debug (commands): Adding command: search-replace (0.148s)
Debug (commands): Adding command: server (0.148s)
Debug (commands): Adding command: shell (0.149s)
Debug (commands): Adding command: super-admin (0.149s)
Debug (commands): Adding command: widget (0.151s)
Debug (commands): Adding command: sidebar (0.151s)
Debug (bootstrap): Adding framework command: phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/commands/cli.php (0.152s)
Debug (commands): Adding command: cli (0.154s)
Debug (commands): Adding command: cache in cli Namespace (0.154s)
Debug (commands): Adding command: alias in cli Namespace (0.155s)
Debug (bootstrap): Adding framework command: phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/commands/help.php (0.155s)
Debug (commands): Adding command: help (0.156s)
Debug (bootstrap): No readable global config found (0.156s)
Debug (bootstrap): No project config found (0.157s)
Debug (bootstrap): argv: /usr/bin/wp query-debug --debug --allow-root (0.157s)
Debug (bootstrap): ABSPATH defined: /var/www/guides.wp-bullet.com/ (0.157s)
Debug (hooks): Processing hook "before_run_command" with 1 callbacks (0.157s)
Debug (hooks): On hook "before_run_command": WP_CLI\Bootstrap\RegisterDeferredCommands->add_deferred_commands() (0.157s)
Debug (bootstrap): Running command: query-debug (0.157s)
Debug (bootstrap): Begin WordPress load (0.165s)
Debug (bootstrap): wp-config.php path: /var/www/guides.wp-bullet.com/wp-config.php (0.166s)
Debug (bootstrap): Set URL: https://guides.wp-bullet.com/ (0.52s)
Debug (commandfactory): No doc comment for autoptimize. (0.553s)
Debug (commands): Adding command: autoptimize (0.554s)
Debug (commands): Adding command: ewwwio (0.628s)
Debug (commands): Adding command: yoast (1.159s)
Debug (commands): Adding command: redirect in yoast Namespace (1.16s)
Debug: ewww_image_optimizer_init() (1.211s)
Debug (bootstrap): Loaded WordPress (1.252s)
Debug (hooks): Processing hook "after_wp_load" with 1 callbacks (1.253s)
Debug (hooks): On hook "after_wp_load": string (1.253s)
Debug: ewww_image_optimizer_restapi_compat_check() (1.253s)
Debug (rest): No schema title found for /, skipping REST command registration. (1.272s)
Debug (rest): No schema title found for /oembed/1.0, skipping REST command registration. (1.272s)
Debug (rest): No schema title found for /oembed/1.0/embed, skipping REST command registration. (1.272s)
Debug (rest): No schema title found for /oembed/1.0/proxy, skipping REST command registration. (1.272s)
Debug (rest): No schema title found for /disqus/v1, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /disqus/v1/sync/webhook, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /disqus/v1/sync/comment, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /disqus/v1/sync/status, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /disqus/v1/sync/enable, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /disqus/v1/sync/disable, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /disqus/v1/export/post, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /recently/v1, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /recently/v1/widget/(?P[\d]+), skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /yoast/v1, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /yoast/v1/configurator, skipping REST command registration. (1.273s)
Debug (rest): No schema title found for /yoast/v1/reindex_posts, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /yoast/v1/indexables/(?P\w+)/(?P\d+), skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /yoast/v1/file_size, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /yoast/v1/statistics, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /yoast/v1/myyoast, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /yoast/v1/myyoast/connect, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /wordpress-popular-posts/v1, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /wordpress-popular-posts/v1/popular-posts, skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /wordpress-popular-posts/v1/popular-posts/widget/(?P[\d]+), skipping REST command registration. (1.274s)
Debug (rest): No schema title found for /wp/v2, skipping REST command registration. (1.274s)
Debug (commands): Deferring command: rest post list (1.274s)
Debug (commands): Deferring command: rest post diff (1.274s)
Debug (commands): Deferring command: rest post create (1.274s)
Debug (commands): Deferring command: rest post generate (1.275s)
Debug (commands): Deferring command: rest post get (1.275s)
Debug (commands): Deferring command: rest post update (1.275s)
Debug (commands): Deferring command: rest post edit (1.275s)
Debug (commands): Deferring command: rest post delete (1.275s)
Debug (commands): Deferring command: rest post-revision list (1.275s)
Debug (commands): Deferring command: rest post-revision diff (1.275s)
Debug (commands): Deferring command: rest post-revision get (1.275s)
Debug (commands): Deferring command: rest post-revision delete (1.275s)
Debug (commands): Deferring command: rest post-revision list (1.275s)
Debug (commands): Deferring command: rest post-revision diff (1.275s)
Debug (commands): Deferring command: rest post-revision create (1.276s)
Debug (commands): Deferring command: rest post-revision generate (1.276s)
Debug (commands): Deferring command: rest post-revision get (1.276s)
Debug (commands): Deferring command: rest page list (1.276s)
Debug (commands): Deferring command: rest page diff (1.276s)
Debug (commands): Deferring command: rest page create (1.276s)
Debug (commands): Deferring command: rest page generate (1.276s)
Debug (commands): Deferring command: rest page get (1.276s)
Debug (commands): Deferring command: rest page update (1.276s)
Debug (commands): Deferring command: rest page edit (1.277s)
Debug (commands): Deferring command: rest page delete (1.277s)
Debug (commands): Deferring command: rest page-revision list (1.277s)
Debug (commands): Deferring command: rest page-revision diff (1.277s)
Debug (commands): Deferring command: rest page-revision get (1.277s)
Debug (commands): Deferring command: rest page-revision delete (1.277s)
Debug (commands): Deferring command: rest page-revision list (1.277s)
Debug (commands): Deferring command: rest page-revision diff (1.277s)
Debug (commands): Deferring command: rest page-revision create (1.277s)
Debug (commands): Deferring command: rest page-revision generate (1.277s)
Debug (commands): Deferring command: rest page-revision get (1.277s)
Debug (commands): Deferring command: rest attachment list (1.277s)
Debug (commands): Deferring command: rest attachment diff (1.277s)
Debug (commands): Deferring command: rest attachment create (1.278s)
Debug (commands): Deferring command: rest attachment generate (1.278s)
Debug (commands): Deferring command: rest attachment get (1.278s)
Debug (commands): Deferring command: rest attachment update (1.278s)
Debug (commands): Deferring command: rest attachment edit (1.278s)
Debug (commands): Deferring command: rest attachment delete (1.278s)
Debug (rest): No schema title found for /wp/v2/media/(?P[\d]+)/post-process, skipping REST command registration. (1.278s)
Debug (commands): Deferring command: rest wp_block list (1.278s)
Debug (commands): Deferring command: rest wp_block diff (1.278s)
Debug (commands): Deferring command: rest wp_block create (1.278s)
Debug (commands): Deferring command: rest wp_block generate (1.278s)
Debug (commands): Deferring command: rest wp_block get (1.278s)
Debug (commands): Deferring command: rest wp_block update (1.279s)
Debug (commands): Deferring command: rest wp_block edit (1.279s)
Debug (commands): Deferring command: rest wp_block delete (1.279s)
Debug (commands): Deferring command: rest wp_block-revision list (1.279s)
Debug (commands): Deferring command: rest wp_block-revision diff (1.279s)
Debug (commands): Deferring command: rest wp_block-revision create (1.279s)
Debug (commands): Deferring command: rest wp_block-revision generate (1.279s)
Debug (commands): Deferring command: rest wp_block-revision get (1.279s)
Debug (commands): Deferring command: rest type list (1.279s)
Debug (commands): Deferring command: rest type diff (1.279s)
Debug (commands): Deferring command: rest type get (1.279s)
Debug (commands): Deferring command: rest status list (1.28s)
Debug (commands): Deferring command: rest status diff (1.28s)
Debug (commands): Deferring command: rest status get (1.28s)
Debug (commands): Deferring command: rest taxonomy list (1.28s)
Debug (commands): Deferring command: rest taxonomy diff (1.28s)
Debug (commands): Deferring command: rest taxonomy get (1.28s)
Debug (commands): Deferring command: rest category list (1.28s)
Debug (commands): Deferring command: rest category diff (1.28s)
Debug (commands): Deferring command: rest category create (1.28s)
Debug (commands): Deferring command: rest category generate (1.28s)
Debug (commands): Deferring command: rest category get (1.281s)
Debug (commands): Deferring command: rest category update (1.281s)
Debug (commands): Deferring command: rest category edit (1.281s)
Debug (commands): Deferring command: rest category delete (1.281s)
Debug (commands): Deferring command: rest tag list (1.281s)
Debug (commands): Deferring command: rest tag diff (1.281s)
Debug (commands): Deferring command: rest tag create (1.281s)
Debug (commands): Deferring command: rest tag generate (1.281s)
Debug (commands): Deferring command: rest tag get (1.281s)
Debug (commands): Deferring command: rest tag update (1.281s)
Debug (commands): Deferring command: rest tag edit (1.281s)
Debug (commands): Deferring command: rest tag delete (1.281s)
Debug (commands): Deferring command: rest user list (1.281s)
Debug (commands): Deferring command: rest user diff (1.281s)
Debug (commands): Deferring command: rest user create (1.281s)
Debug (commands): Deferring command: rest user generate (1.281s)
Debug (commands): Deferring command: rest user get (1.281s)
Debug (commands): Deferring command: rest user update (1.281s)
Debug (commands): Deferring command: rest user edit (1.282s)
Debug (commands): Deferring command: rest user delete (1.282s)
Debug (commands): Deferring command: rest user list (1.282s)
Debug (commands): Deferring command: rest user diff (1.282s)
Debug (commands): Deferring command: rest comment list (1.282s)
Debug (commands): Deferring command: rest comment diff (1.282s)
Debug (commands): Deferring command: rest comment create (1.282s)
Debug (commands): Deferring command: rest comment generate (1.282s)
Debug (commands): Deferring command: rest comment get (1.282s)
Debug (commands): Deferring command: rest comment update (1.282s)
Debug (commands): Deferring command: rest comment edit (1.282s)
Debug (commands): Deferring command: rest comment delete (1.282s)
Debug (commands): Deferring command: rest search-result list (1.282s)
Debug (commands): Deferring command: rest search-result diff (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest rendered-block get (1.282s)
Debug (commands): Deferring command: rest settings list (1.282s)
Debug (commands): Deferring command: rest settings diff (1.282s)
Debug (commands): Deferring command: rest theme list (1.283s)
Debug (commands): Deferring command: rest theme diff (1.283s)
Debug (query-debug): Main WP_Query: is_home (1.3s)
Debug (query-debug): Theme template: generatepress/index.php (1.304s)
Loading https://guides.wp-bullet.com/ executed 91 queries in 0.040145 seconds. Use --format=table to see the full list.

If you want even more detail we can add the --format=table --allow-root parameter

wp query-debug --format=table --url="https://guides.wp-bullet.com/fixing-wp_options-table-missing-unique-column-primary-key"

Output – warning this is quite long!

+----------+--------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------+
| seconds  | backtrace                                                                                                    | query                                                                                                           |
+----------+--------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------+
| 0.000681 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), wp_not_installed, is_blog_installed, wp_load_allo | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'                                         |
|          | ptions                                                                                                       |                                                                                                                 |
| 0.000131 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/mu-plugins/0-worker.php'), include | SELECT option_value FROM wp_options WHERE option_name = 'mwp_link_monitor_enabled' LIMIT 1                      |
|          | _once('/plugins/worker/init.php'), mwp_init, MWP_WordPress_Context->optionGet, get_option                    |                                                                                                                 |
| 8.9E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/mu-plugins/0-worker.php'), include | SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1                             |
|          | _once('/plugins/worker/init.php'), mwp_init, register_uninstall_hook, get_option                             |                                                                                                                 |
| 9.0E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/mu-plugins/0-worker.php'), include | SELECT option_value FROM wp_options WHERE option_name = 'mwp_worker_brand' LIMIT 1                              |
|          | _once('/plugins/worker/init.php'), mwp_init, MWP_Worker_Kernel->__construct, MWP_ServiceContainer_Abstract-> |                                                                                                                 |
|          | getEventDispatcher, MWP_ServiceContainer_Production->createEventDispatcher, MWP_ServiceContainer_Abstract->g |                                                                                                                 |
|          | etBrand, MWP_ServiceContainer_Production->createWorkerBrand, MWP_Worker_Brand->__construct, MWP_WordPress_Co |                                                                                                                 |
|          | ntext->optionGet, get_option                                                                                 |                                                                                                                 |
| 0.000175 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), wp_get_active_and_valid_plugins, get_option, appl | SELECT  t.*, tt.* FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxo |
|          | y_filters('option_active_plugins'), WP_Hook->apply_filters, WP_Bullet_MU_Plugin_Manager->disable_plugins, WP | nomy IN ('category') AND t.slug = 'fixing-wp_options-table-missing-unique-column-primary-key' ORDER BY t.name A |
|          | _Bullet_MU_Plugin_Manager->is_post_skipped, WP_Bullet_MU_Plugin_Manager->is_page_skipped_by_post_type, get_c | SC                                                                                                              |
|          | ategory_by_path, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms                                   |                                                                                                                 |
| 0.02051  | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), wp_get_active_and_valid_plugins, get_option, appl | SELECT * FROM wp_posts WHERE post_name SOUNDS LIKE '/fixing-wp_options-table-missing-unique-column-primary-key/ |
|          | y_filters('option_active_plugins'), WP_Hook->apply_filters, WP_Bullet_MU_Plugin_Manager->disable_plugins, WP | '                                                                                                               |
|          | _Bullet_MU_Plugin_Manager->is_post_skipped, WP_Bullet_MU_Plugin_Manager->is_page_skipped_by_post_type, WP_Bu |                                                                                                                 |
|          | llet_MU_Plugin_Manager->is_taxonomy_included, WP_Bullet_MU_Plugin_Manager->get_post_type                     |                                                                                                                 |
| 0.000535 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), wp_get_active_and_valid_plugins, get_option, appl | SELECT * FROM wp_posts WHERE post_name SOUNDS LIKE '/fixing-wp_options-table-missing-unique-column-primary-key/ |
|          | y_filters('option_active_plugins'), WP_Hook->apply_filters, WP_Bullet_MU_Plugin_Manager->disable_plugins, WP | '                                                                                                               |
|          | _Bullet_MU_Plugin_Manager->is_post_skipped, WP_Bullet_MU_Plugin_Manager->is_page_skipped_by_post_type, WP_Bu |                                                                                                                 |
|          | llet_MU_Plugin_Manager->is_taxonomy_included, WP_Bullet_MU_Plugin_Manager->get_post_type                     |                                                                                                                 |
| 0.000682 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/advanced-database-cleaner- | SELECT option_value FROM wp_options WHERE option_name = 'aDBc_settings' LIMIT 1                                 |
|          | pro/advanced-db-cleaner.php'), ADBC_Advanced_DB_Cleaner_Pro->__construct, ADBC_Advanced_DB_Cleaner_Pro->aDBc |                                                                                                                 |
|          | _update_settings, get_option                                                                                 |                                                                                                                 |
| 8.4E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_rules' LIMIT 1                        |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 4.2E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_additional' LIMIT 1                   |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 4.6E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_queue' LIMIT 1                        |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 6.1E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_viewport' LIMIT 1                     |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 3.8E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_finclude' LIMIT 1                     |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 3.6E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_rlimit' LIMIT 1                       |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 5.3E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_noptimize' LIMIT 1                    |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 4.2E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_debug' LIMIT 1                        |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 5.8E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_key' LIMIT 1                          |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 5.1E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_keyst' LIMIT 1                        |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 3.7E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/autoptimize-criticalcss/ao | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_ccss_servicestatus' LIMIT 1                |
|          | _criticss_aas.php'), autoptimizeCriticalCSS->__construct, autoptimizeCriticalCSS->setup, autoptimizeCritical |                                                                                                                 |
|          | CSS::fetch_options, get_option                                                                               |                                                                                                                 |
| 0.000157 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/disqus-conditional-load/di | SELECT * FROM wp_posts WHERE post_name SOUNDS LIKE '/fixing-wp_options-table-missing-unique-column-primary-key/ |
|          | squs-conditional-load.php'), dcl_instance, Disqus_Conditional_Load::instance, Disqus_Conditional_Load->__con | '                                                                                                               |
|          | struct, DCL_Helper->__construct, DCL_Helper->dcl_ready, DCL_Helper->is_disqus_active, DCL_Helper->plugin_act |                                                                                                                 |
|          | ive, is_plugin_active, get_option, apply_filters('option_active_plugins'), WP_Hook->apply_filters, WP_Bullet |                                                                                                                 |
|          | _MU_Plugin_Manager->disable_plugins, WP_Bullet_MU_Plugin_Manager->is_post_skipped, WP_Bullet_MU_Plugin_Manag |                                                                                                                 |
|          | er->is_page_skipped_by_post_type, WP_Bullet_MU_Plugin_Manager->is_taxonomy_included, WP_Bullet_MU_Plugin_Man |                                                                                                                 |
|          | ager->get_post_type                                                                                          |                                                                                                                 |
| 6.6E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/disqus-conditional-load/di | SELECT * FROM wp_posts WHERE post_name SOUNDS LIKE '/fixing-wp_options-table-missing-unique-column-primary-key/ |
|          | squs-conditional-load.php'), dcl_instance, Disqus_Conditional_Load::instance, Disqus_Conditional_Load->__con | '                                                                                                               |
|          | struct, DCL_Helper->__construct, DCL_Helper->dcl_ready, DCL_Helper->is_disqus_active, DCL_Helper->plugin_act |                                                                                                                 |
|          | ive, is_plugin_active, get_option, apply_filters('option_active_plugins'), WP_Hook->apply_filters, WP_Bullet |                                                                                                                 |
|          | _MU_Plugin_Manager->disable_plugins, WP_Bullet_MU_Plugin_Manager->is_post_skipped, WP_Bullet_MU_Plugin_Manag |                                                                                                                 |
|          | er->is_page_skipped_by_post_type, WP_Bullet_MU_Plugin_Manager->is_taxonomy_included, WP_Bullet_MU_Plugin_Man |                                                                                                                 |
|          | ager->get_post_type                                                                                          |                                                                                                                 |
| 7.1E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/disqus-conditional-load/di | SELECT * FROM wp_posts WHERE post_name SOUNDS LIKE '/fixing-wp_options-table-missing-unique-column-primary-key/ |
|          | squs-conditional-load.php'), dcl_instance, Disqus_Conditional_Load::instance, Disqus_Conditional_Load->__con | '                                                                                                               |
|          | struct, Disqus_Conditional_Load->load_dependencies, DCL_Helper->is_disqus_compatible, DCL_Helper->is_disqus_ |                                                                                                                 |
|          | active, DCL_Helper->plugin_active, is_plugin_active, get_option, apply_filters('option_active_plugins'), WP_ |                                                                                                                 |
|          | Hook->apply_filters, WP_Bullet_MU_Plugin_Manager->disable_plugins, WP_Bullet_MU_Plugin_Manager->is_post_skip |                                                                                                                 |
|          | ped, WP_Bullet_MU_Plugin_Manager->is_page_skipped_by_post_type, WP_Bullet_MU_Plugin_Manager->is_taxonomy_inc |                                                                                                                 |
|          | luded, WP_Bullet_MU_Plugin_Manager->get_post_type                                                            |                                                                                                                 |
| 8.3E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/disqus-conditional-load/di | SELECT * FROM wp_posts WHERE post_name SOUNDS LIKE '/fixing-wp_options-table-missing-unique-column-primary-key/ |
|          | squs-conditional-load.php'), dcl_instance, Disqus_Conditional_Load::instance, Disqus_Conditional_Load->__con | '                                                                                                               |
|          | struct, Disqus_Conditional_Load->load_dependencies, DCL_Helper->is_disqus_compatible, DCL_Helper->is_disqus_ |                                                                                                                 |
|          | active, DCL_Helper->plugin_active, is_plugin_active, get_option, apply_filters('option_active_plugins'), WP_ |                                                                                                                 |
|          | Hook->apply_filters, WP_Bullet_MU_Plugin_Manager->disable_plugins, WP_Bullet_MU_Plugin_Manager->is_post_skip |                                                                                                                 |
|          | ped, WP_Bullet_MU_Plugin_Manager->is_page_skipped_by_post_type, WP_Bullet_MU_Plugin_Manager->is_taxonomy_inc |                                                                                                                 |
|          | luded, WP_Bullet_MU_Plugin_Manager->get_post_type                                                            |                                                                                                                 |
| 0.000241 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/ga-in/gainwp.php'), GAINWP | SELECT option_value FROM wp_options WHERE option_name = 'gadash_options' LIMIT 1                                |
|          | , GAINWP_Manager::instance, GAINWP_Config->__construct, GAINWP_Config->option_keys_rename, get_option        |                                                                                                                 |
| 8.6E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/ga-in/gainwp.php'), GAINWP | SELECT option_value FROM wp_options WHERE option_name = 'gainwp_version' LIMIT 1                                |
|          | , GAINWP_Manager::instance, GAINWP_Config->__construct, GAINWP_Config->get_plugin_options, GAINWP_Config->ma |                                                                                                                 |
|          | intain_compatibility, get_option                                                                             |                                                                                                                 |
| 7.6E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/gp-premium/gp-premium.php' | SELECT option_value FROM wp_options WHERE option_name = 'generate_package_backgrounds' LIMIT 1                  |
|          | ), generatepress_is_module_active, get_option                                                                |                                                                                                                 |
| 0.000188 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/gp-premium/gp-premium.php' | SELECT option_value FROM wp_options WHERE option_name = 'generate_package_sections' LIMIT 1                     |
|          | ), generatepress_is_module_active, get_option                                                                |                                                                                                                 |
| 0.000154 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/gp-premium/gp-premium.php' | SELECT option_value FROM wp_options WHERE option_name = 'generate_package_woocommerce' LIMIT 1                  |
|          | ), generatepress_is_module_active, get_option                                                                |                                                                                                                 |
| 0.000176 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/pretty-link/pretty-link.ph | SELECT option_value FROM wp_options WHERE option_name = 'plp_edge_updates' LIMIT 1                              |
|          | p'), PrliUpdateController->__construct, get_option                                                           |                                                                                                                 |
| 0.000157 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/pretty-link/pretty-link.ph | SELECT option_value FROM wp_options WHERE option_name = 'prli_disable_all_popups' LIMIT 1                       |
|          | p'), PrliPopupController->load_hooks, get_option                                                             |                                                                                                                 |
| 0.000177 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/pretty-link/pretty-link.ph | SELECT option_value FROM wp_options WHERE option_name = 'plp_index_keywords' LIMIT 1                            |
|          | p'), require_once('/plugins/pretty-link/pro/pretty-link-pro.php'), PlpKeywordsController->load_hooks, get_op |                                                                                                                 |
|          | tion                                                                                                         |                                                                                                                 |
| 0.000156 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/recently/recently.php'), R | SELECT option_value FROM wp_options WHERE option_name = 'recently_config' LIMIT 1                               |
|          | ecently->__construct, Recently->define_admin_hooks, Recently_Admin->__construct, Recently_Settings::get, get |                                                                                                                 |
|          | _option                                                                                                      |                                                                                                                 |
| 0.000163 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/sendgrid-email-delivery-si | SELECT option_value FROM wp_options WHERE option_name = 'sendgrid_mc_auth_valid' LIMIT 1                        |
|          | mplified/wpsendgrid.php'), Sendgrid_Tools::get_mc_auth_valid, Sendgrid_Tools::get_sendgrid_option, get_optio |                                                                                                                 |
|          | n                                                                                                            |                                                                                                                 |
| 0.000106 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/svg-support/svg-support.ph | SELECT option_value FROM wp_options WHERE option_name = 'bodhi_svgs_admin_notice_dismissed' LIMIT 1             |
|          | p'), get_option                                                                                              |                                                                                                                 |
| 0.000158 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/wordpress-popular-posts/wo | SELECT option_value FROM wp_options WHERE option_name = 'wpp_settings_config' LIMIT 1                           |
|          | rdpress-popular-posts.php'), require('/plugins/wordpress-popular-posts/src/Bootstrap.php'), WordPressPopular |                                                                                                                 |
|          | Posts\Container\Container->configure, WordPressPopularPosts\Container\WordPressPopularPostsConfiguration->mo |                                                                                                                 |
|          | dify, WordPressPopularPosts\Settings::get, get_option                                                        |                                                                                                                 |
| 0.000605 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/wp-file-manager/file_folde | SHOW TABLES LIKE 'wp_wpfm_backup'                                                                               |
|          | r_manager.php'), mk_file_folder_manager->__construct, mk_file_folder_manager->mk_file_manager_create_tables  |                                                                                                                 |
| 0.000153 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action,  | SELECT option_value FROM wp_options WHERE option_name = 'aDBc_security_folder_code' LIMIT 1                     |
|          | WP_Hook->apply_filters, ADBC_Advanced_DB_Cleaner_Pro->plugins_loaded, get_option                             |                                                                                                                 |
| 0.000128 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action,  | SELECT option_value FROM wp_options WHERE option_name = 'ari_adminer_settings' LIMIT 1                          |
|          | WP_Hook->apply_filters, ari_adminer_init, Ari_Adminer\Plugin->init, Ari_Adminer\Helpers\Settings::get_option |                                                                                                                 |
|          | , Ari_Adminer\Helpers\Settings::options, get_option                                                          |                                                                                                                 |
| 7.1E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action,  | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_enable_site_config' LIMIT 1                |
|          | WP_Hook->apply_filters, autoptimizeMain->setup, autoptimizeOptionWrapper::get_option, get_network_option, ge |                                                                                                                 |
|          | t_option                                                                                                     |                                                                                                                 |
| 0.000105 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action,  | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_minify_excluded' LIMIT 1                   |
|          | WP_Hook->apply_filters, autoptimizeMain->setup, do_action('autoptimize_setup_done'), WP_Hook->do_action, WP_ |                                                                                                                 |
|          | Hook->apply_filters, autoptimizeMain->check_cache_and_run, autoptimizeConfig->get, autoptimizeOptionWrapper: |                                                                                                                 |
|          | :get_option, get_option                                                                                      |                                                                                                                 |
| 0.000134 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action,  | SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1                    |
|          | WP_Hook->apply_filters, Classic_Editor::init_actions, Classic_Editor::get_settings, get_option               |                                                                                                                 |
| 4.7E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action,  | SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1                        |
|          | WP_Hook->apply_filters, Classic_Editor::init_actions, Classic_Editor::get_settings, get_option               |                                                                                                                 |
| 0.000146 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1                          |
|          | pply_filters, wp_widgets_init, do_action('widgets_init'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Wid |                                                                                                                 |
|          | get_Factory->_register_widgets, WP_Widget->_register, WP_Widget_Text->_register_one, wp_add_inline_script, w |                                                                                                                 |
|          | p_scripts, WP_Scripts->__construct, WP_Scripts->init, do_action_ref_array('wp_default_scripts'), WP_Hook->do |                                                                                                                 |
|          | _action, WP_Hook->apply_filters, wp_default_packages, wp_register_tinymce_scripts, script_concat_settings, g |                                                                                                                 |
|          | et_site_option, get_network_option, get_option                                                               |                                                                                                                 |
| 0.00014  | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT li.*, CONCAT("https://guides.wp-bullet.com","/",li.slug) AS pretty_url       FROM wp_prli_links AS li    |
|          | pply_filters, PrliAppController->redirect, PrliLink->is_pretty_link, PrliLink->is_pretty_link_slug, PrliLink |     WHERE slug='fixing-wp_options-table-missing-unique-column-primary-key'                AND link_status='enab |
|          | ->getOneFromSlug, PrliLink->get_one_by                                                                       | led'                                                                                                            |
| 0.000588 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wp_insert_ip_127.0.0.1' LIMIT 1     |
|          | pply_filters, wp_insert_ip_to_country, get_transient, get_option                                             |                                                                                                                 |
| 0.000212 | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = '_transient_wp_insert_ip_127.0.0.1' LIMIT 1             |
|          | pply_filters, wp_insert_ip_to_country, get_transient, get_option                                             |                                                                                                                 |
| 6.8E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = 'wp_insert_adwidgets' LIMIT 1                           |
|          | pply_filters, wp_insert_ip_to_country, wp_insert_is_geoip_enabled, get_option                                |                                                                                                                 |
| 7.4E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = 'wp_insert_inthemeads' LIMIT 1                          |
|          | pply_filters, wp_insert_ip_to_country, wp_insert_is_geoip_enabled, get_option                                |                                                                                                                 |
| 5.3E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = 'wp_insert_shortcodeads' LIMIT 1                        |
|          | pply_filters, wp_insert_ip_to_country, wp_insert_is_geoip_enabled, get_option                                |                                                                                                                 |
| 6.1E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = 'wp_insert_vi_code_settings' LIMIT 1                    |
|          | pply_filters, wp_insert_vi_gdpr_popup_init, get_option                                                       |                                                                                                                 |
| 5.0E-5   | WP_CLI\Runner->load_wordpress, require('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->a | SELECT option_value FROM wp_options WHERE option_name = 'wpp_ver' LIMIT 1                                       |
|          | pply_filters, WordPressPopularPosts\Admin\Admin->upgrade_check, WordPressPopularPosts\Admin\Admin->upgrade_s |                                                                                                                 |
|          | ite, get_option                                                                                              |                                                                                                                 |
| 0.000738 | wp, WP->main, WP->parse_request, get_page_by_path                                                            |               SELECT ID, post_name, post_parent, post_type            FROM wp_posts           WHERE post_name IN ('fixing-wp_options-table- |
|          |                                                                                                              | missing-unique-column-primary-key')                 AND post_type IN ('page','attachment')                                    |
| 0.001687 | wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts                                          | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_name = 'fixing-wp_options-table-missing-unique- |
|          |                                                                                                              | column-primary-key' AND wp_posts.post_type = 'post'  ORDER BY wp_posts.post_date DESC                           |
| 0.000126 | wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_ | SELECT  t.*, tt.*, tr.object_id FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id |
|          | cache, wp_get_object_terms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms                        |  INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('cat |
|          |                                                                                                              | egory', 'post_tag', 'post_format') AND tr.object_id IN (4179) ORDER BY t.name ASC                               |
| 0.000495 | wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_postmeta_cac | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4179) ORDER BY meta_id ASC              |
|          | he, update_meta_cache                                                                                        |                                                                                                                 |
| 0.000214 | wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, wp_insert_track_ad_inst | SELECT option_value FROM wp_options WHERE option_name = 'wp_insert_abtesting_mode' LIMIT 1                      |
|          | ance, get_option                                                                                             |                                                                                                                 |
| 6.3E-5   | wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, generate_premium_do_ele | SELECT   wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'gp_elements' AND ((wp_posts.post_statu |
|          | ments, get_posts, WP_Query->query, WP_Query->get_posts                                                       | s = 'publish'))  ORDER BY wp_posts.post_date ASC LIMIT 0, 500                                                   |
| 0.00037  | wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, generate_premium_do_ele | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6906) ORDER BY meta_id ASC              |
|          | ments, get_post_meta, get_metadata, update_meta_cache                                                        |                                                                                                                 |
| 6.9E-5   | wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, generate_page_header_do | SELECT option_value FROM wp_options WHERE option_name = 'generate_page_header_global_locations' LIMIT 1         |
|          | _setup, generate_page_header_get_options, get_option                                                         |                                                                                                                 |
| 6.7E-5   | wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, autoptimizeImages->run_ | SELECT option_value FROM wp_options WHERE option_name = 'autoptimize_imgopt_provider_stat' LIMIT 1              |
|          | on_frontend, autoptimizeImages->should_run, autoptimizeImages->get_imgopt_provider_userstatus, autoptimizeOp |                                                                                                                 |
|          | tionWrapper::get_option, get_option                                                                          |                                                                                                                 |
| 5.4E-5   | wp, WP->main, do_action_ref_array('wp'), WP_Hook->do_action, WP_Hook->apply_filters, WPB_LL->start_functiona | SELECT option_value FROM wp_options WHERE option_name = 'wp_bullet_lazy_load_styles_tab' LIMIT 1                |
|          | lity, WPB_LL->is_disabled, WPB_LL_Parser::get_instance, WPB_LL_Parser->__construct, wpb_get_option, get_opti |                                                                                                                 |
|          | on                                                                                                           |                                                                                                                 |
| 0.000117 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT option_value FROM wp_options WHERE option_name = 'disqus_render_js' LIMIT 1                              |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, wp_enqueue_scripts, do_action('wp_enqueue_scripts'), WP_Hook- |                                                                                                                 |
|          | >do_action, WP_Hook->apply_filters, Disqus_Public->enqueue_comment_embed, get_option                         |                                                                                                                 |
| 6.8E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT option_value FROM wp_options WHERE option_name = 'disqus_sso_enabled' LIMIT 1                            |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, wp_enqueue_scripts, do_action('wp_enqueue_scripts'), WP_Hook- |                                                                                                                 |
|          | >do_action, WP_Hook->apply_filters, Disqus_Public->enqueue_comment_embed, Disqus_Public::embed_vars_for_post |                                                                                                                 |
|          | , get_option                                                                                                 |                                                                                                                 |
| 0.000132 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT * FROM wp_users WHERE ID = '1' LIMIT 1                                                                   |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio |                                                                                                                 |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, wp_reset_query, wp_reset_postdata, WP_Query->reset_po |                                                                                                                 |
|          | stdata, WP_Query->setup_postdata, WP_Query->generate_postdata, get_userdata, get_user_by, WP_User::get_data_ |                                                                                                                 |
|          | by                                                                                                           |                                                                                                                 |
| 7.7E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC                |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio |                                                                                                                 |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, wp_reset_query, wp_reset_postdata, WP_Query->reset_po |                                                                                                                 |
|          | stdata, WP_Query->setup_postdata, WP_Query->generate_postdata, get_userdata, get_user_by, WP_User->init, WP_ |                                                                                                                 |
|          | User->for_site, WP_User->get_caps_data, get_user_meta, get_metadata, update_meta_cache                       |                                                                                                                 |
| 0.000135 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT  t.term_id, tt.parent, tt.count, tt.taxonomy FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t. |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' | term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE  |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio | tt.taxonomy IN ('category') AND tr.object_id IN (4179) ORDER BY t.name ASC                                      |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, do_action('wpseo_opengraph'), WP_Hook->do_action, WP_ |                                                                                                                 |
|          | Hook->apply_filters, WPSEO_OpenGraph->description, get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hoo |                                                                                                                 |
|          | k->apply_filters, wp_trim_excerpt, apply_filters('the_content'), WP_Hook->apply_filters, wp_insert_inpostads |                                                                                                                 |
|          | _the_content, wp_insert_get_ad_status, wp_insert_get_page_details, wp_get_post_categories, wp_get_object_ter |                                                                                                                 |
|          | ms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms                                                |                                                                                                                 |
| 8.3E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (27,17,18,13) ORDER BY meta_id ASC       |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio |                                                                                                                 |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, do_action('wpseo_opengraph'), WP_Hook->do_action, WP_ |                                                                                                                 |
|          | Hook->apply_filters, WPSEO_OpenGraph->description, get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hoo |                                                                                                                 |
|          | k->apply_filters, wp_trim_excerpt, apply_filters('the_content'), WP_Hook->apply_filters, wp_insert_inpostads |                                                                                                                 |
|          | _the_content, wp_insert_get_ad_status, wp_insert_get_page_details, wp_get_post_categories, wp_get_object_ter |                                                                                                                 |
|          | ms, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms, update_termmeta_cache, update_meta_cache      |                                                                                                                 |
| 8.3E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo |          SELECT plm.meta_value as replacement_url,                CONCAT('https://guides.wp-bullet.com/',li.slu |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' | g) AS url           FROM wp_prli_links li           JOIN wp_prli_link_metas plm             ON li.id = plm.link |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio | _id          WHERE plm.meta_key='prli-url-replacements'            AND plm.meta_value  ''            AND li.l |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, do_action('wpseo_opengraph'), WP_Hook->do_action, WP_ | ink_status='enabled'                                                                                            |
|          | Hook->apply_filters, WPSEO_OpenGraph->description, get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hoo |                                                                                                                 |
|          | k->apply_filters, wp_trim_excerpt, apply_filters('the_content'), WP_Hook->apply_filters, PlpKeywordsControll |                                                                                                                 |
|          | er->replace_keywords, PlpUrlReplacement->getURLToLinksArray                                                  |                                                                                                                 |
| 6.8E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo |          SELECT kw.text as keyword,                li.name as title,                li.url as link_url,         |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |         li.id as link_id,                CONCAT('https://guides.wp-bullet.com/',li.slug) AS url           FROM  |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio | wp_prli_links li           JOIN wp_prli_keywords kw             ON li.id=kw.link_id          WHERE kw.text  ' |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, do_action('wpseo_opengraph'), WP_Hook->do_action, WP_ | '            AND li.link_status='enabled'          AND li.url NOT LIKE '%/fixing-wp\\_options-table-missing-uni |
|          | Hook->apply_filters, WPSEO_OpenGraph->description, get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hoo | que-column-primary-key/'          ORDER BY CHAR_LENGTH(kw.text) DESC,                kw.text ASC                |
|          | k->apply_filters, wp_trim_excerpt, apply_filters('the_content'), WP_Hook->apply_filters, PlpKeywordsControll |                                                                                                                 |
|          | er->replace_keywords, PlpKeyword->get_post_keywords_lookup, PlpKeyword->getKeywordToLinksArray               |                                                                                                                 |
| 0.00048  | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT * FROM wp_posts WHERE ID = 4221 LIMIT 1                                                                  |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio |                                                                                                                 |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, do_action('wpseo_opengraph'), WP_Hook->do_action, WP_ |                                                                                                                 |
|          | Hook->apply_filters, WPSEO_OpenGraph->image, WPSEO_OpenGraph_Image->__construct, WPSEO_OpenGraph_Image->set_ |                                                                                                                 |
|          | images, WPSEO_OpenGraph_Image->set_singular_image, WPSEO_OpenGraph_Image->set_user_defined_image, WPSEO_Open |                                                                                                                 |
|          | Graph_Image->set_featured_image, WPSEO_OpenGraph_Image->add_image_by_id, WPSEO_OpenGraph_Image->is_valid_att |                                                                                                                 |
|          | achment, get_post_mime_type, get_post, WP_Post::get_instance                                                 |                                                                                                                 |
| 0.000336 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4221) ORDER BY meta_id ASC              |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, custom_yoast_head, do_action('wpseo_head'), WP_Hook->do_actio |                                                                                                                 |
|          | n, WP_Hook->apply_filters, WPSEO_OpenGraph->opengraph, do_action('wpseo_opengraph'), WP_Hook->do_action, WP_ |                                                                                                                 |
|          | Hook->apply_filters, WPSEO_OpenGraph->image, WPSEO_OpenGraph_Image->__construct, WPSEO_OpenGraph_Image->set_ |                                                                                                                 |
|          | images, WPSEO_OpenGraph_Image->set_singular_image, WPSEO_OpenGraph_Image->set_user_defined_image, WPSEO_Open |                                                                                                                 |
|          | Graph_Image->set_featured_image, WPSEO_OpenGraph_Image->add_image_by_id, WPSEO_Image_Utils::get_variations,  |                                                                                                                 |
|          | WPSEO_Image_Utils::get_image, WPSEO_Image_Utils::get_full_size_image_data, wp_get_attachment_metadata, get_p |                                                                                                                 |
|          | ost_meta, get_metadata, update_meta_cache                                                                    |                                                                                                                 |
| 0.000151 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT * FROM wp_posts WHERE ID = 4667 LIMIT 1                                                                  |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, wp_site_icon, has_site_icon, get_site_icon_url, wp_get_attach |                                                                                                                 |
|          | ment_image_url, wp_get_attachment_image_src, image_downsize, wp_attachment_is_image, wp_attachment_is, get_p |                                                                                                                 |
|          | ost, WP_Post::get_instance                                                                                   |                                                                                                                 |
| 0.000686 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4667) ORDER BY meta_id ASC              |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, wp_site_icon, has_site_icon, get_site_icon_url, wp_get_attach |                                                                                                                 |
|          | ment_image_url, wp_get_attachment_image_src, image_downsize, wp_attachment_is_image, wp_attachment_is, get_a |                                                                                                                 |
|          | ttached_file, get_post_meta, get_metadata, update_meta_cache                                                 |                                                                                                                 |
| 8.9E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT * FROM wp_posts WHERE ID = 4375 LIMIT 1                                                                  |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), wp_head, do_action('wp_head' |                                                                                                                 |
|          | ), WP_Hook->do_action, WP_Hook->apply_filters, wp_custom_css_cb, wp_get_custom_css, wp_get_custom_css_post,  |                                                                                                                 |
|          | get_post, WP_Post::get_instance                                                                              |                                                                                                                 |
| 7.2E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_header') |  = 2                                                                                                            |
|          | , WP_Hook->do_action, WP_Hook->apply_filters, generate_construct_header, do_action('generate_before_header_c |                                                                                                                 |
|          | ontent'), WP_Hook->do_action, WP_Hook->apply_filters, GeneratePress_Hook->execute_hook, eval, generate_secon |                                                                                                                 |
|          | dary_navigation_position, wp_nav_menu, wp_get_nav_menu_object, get_term, WP_Term::get_instance               |                                                                                                                 |
| 4.7E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_header') |  tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('2') ORDER BY tr.object_id ASC        |
|          | , WP_Hook->do_action, WP_Hook->apply_filters, generate_construct_header, do_action('generate_before_header_c |                                                                                                                 |
|          | ontent'), WP_Hook->do_action, WP_Hook->apply_filters, GeneratePress_Hook->execute_hook, eval, generate_secon |                                                                                                                 |
|          | dary_navigation_position, wp_nav_menu, wp_get_nav_menu_items, get_objects_in_term                            |                                                                                                                 |
| 7.8E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (29) AND wp_posts.post_type = 'nav_menu_item'  |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_header') | AND ((wp_posts.post_status = 'publish'))  ORDER BY wp_posts.menu_order ASC                                      |
|          | , WP_Hook->do_action, WP_Hook->apply_filters, generate_construct_header, do_action('generate_before_header_c |                                                                                                                 |
|          | ontent'), WP_Hook->do_action, WP_Hook->apply_filters, GeneratePress_Hook->execute_hook, eval, generate_secon |                                                                                                                 |
|          | dary_navigation_position, wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_post |                                                                                                                 |
|          | s                                                                                                            |                                                                                                                 |
| 0.000406 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (29) ORDER BY meta_id ASC                |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_header') |                                                                                                                 |
|          | , WP_Hook->do_action, WP_Hook->apply_filters, generate_construct_header, do_action('generate_before_header_c |                                                                                                                 |
|          | ontent'), WP_Hook->do_action, WP_Hook->apply_filters, GeneratePress_Hook->execute_hook, eval, generate_secon |                                                                                                                 |
|          | dary_navigation_position, wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_post |                                                                                                                 |
|          | s, update_post_caches, update_postmeta_cache, update_meta_cache                                              |                                                                                                                 |
| 8.5E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he |  = 3                                                                                                            |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_object, get_term, WP_Term::get_instance                             |                                                                                                                 |
| 5.5E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he |  tt.term_taxonomy_id WHERE tt.taxonomy IN ('nav_menu') AND tt.term_id IN ('3') ORDER BY tr.object_id ASC        |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_objects_in_term                                          |                                                                                                                 |
| 0.000139 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (16,435,436,437,438,439,440,441,442,650,651,27 |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he | 06,2837) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish'))  ORDER BY wp_posts.m |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio | enu_order ASC                                                                                                   |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts              |                                                                                                                 |
| 0.000935 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (16,435,438,442,437,436,439,440,441,2837 |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he | ,2706,650,651) ORDER BY meta_id ASC                                                                             |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts, update_post |                                                                                                                 |
|          | _caches, update_postmeta_cache, update_meta_cache                                                            |                                                                                                                 |
| 9.8E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT   wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.ID IN (23,10) AND wp_posts.post_type = 'page' AND (( |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he | wp_posts.post_status = 'publish'))  ORDER BY wp_posts.post_date DESC                                            |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts              |                                                                                                                 |
| 0.000329 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (23,10) ORDER BY meta_id ASC             |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he |                                                                                                                 |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts, update_post |                                                                                                                 |
|          | _caches, update_postmeta_cache, update_meta_cache                                                            |                                                                                                                 |
| 9.8E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT  t.*, tt.* FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxo |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he | nomy IN ('category') AND t.term_id IN ( 18,17,7,5,6,8,10,13 ) AND tt.count > 0 ORDER BY t.name ASC              |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms    |                                                                                                                 |
| 8.6E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_header, lo | SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (10,5,8,7,6) ORDER BY meta_id ASC        |
|          | cate_template, load_template, require_once('/themes/generatepress/header.php'), do_action('generate_after_he |                                                                                                                 |
|          | ader'), WP_Hook->do_action, WP_Hook->apply_filters, generate_add_navigation_after_header, generate_navigatio |                                                                                                                 |
|          | n_position, wp_nav_menu, wp_get_nav_menu_items, get_terms, WP_Term_Query->query, WP_Term_Query->get_terms, u |                                                                                                                 |
|          | pdate_termmeta_cache, update_meta_cache                                                                      |                                                                                                                 |
| 0.000685 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_template_p | SELECT p.ID FROM wp_posts AS p  WHERE p.post_date do_action, WP_Hook->apply_filters, generate_footer_meta, generate_content_ |                                                                                                                 |
|          | nav, get_adjacent_post                                                                                       |                                                                                                                 |
| 0.000344 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_template_p | SELECT * FROM wp_posts WHERE ID = 3749 LIMIT 1                                                                  |
|          | art, locate_template, load_template, require('/themes/generatepress/content-single.php'), do_action('generat |                                                                                                                 |
|          | e_after_entry_content'), WP_Hook->do_action, WP_Hook->apply_filters, generate_footer_meta, generate_content_ |                                                                                                                 |
|          | nav, get_adjacent_post, get_post, WP_Post::get_instance                                                      |                                                                                                                 |
| 0.000275 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_template_p | SELECT p.ID FROM wp_posts AS p  WHERE p.post_date > '2017-09-19 14:06:41' AND p.post_type = 'post'  AND p.post_ |
|          | art, locate_template, load_template, require('/themes/generatepress/content-single.php'), do_action('generat | status = 'publish' ORDER BY p.post_date ASC LIMIT 1                                                             |
|          | e_after_entry_content'), WP_Hook->do_action, WP_Hook->apply_filters, generate_footer_meta, generate_content_ |                                                                                                                 |
|          | nav, get_adjacent_post                                                                                       |                                                                                                                 |
| 0.002746 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), get_template_p | SELECT * FROM wp_posts WHERE ID = 848 LIMIT 1                                                                   |
|          | art, locate_template, load_template, require('/themes/generatepress/content-single.php'), do_action('generat |                                                                                                                 |
|          | e_after_entry_content'), WP_Hook->do_action, WP_Hook->apply_filters, generate_footer_meta, generate_content_ |                                                                                                                 |
|          | nav, get_adjacent_post, get_post, WP_Post::get_instance                                                      |                                                                                                                 |
| 8.8E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), comments_templ | SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID FROM wp_comments  WHERE ( comment_approved = '1' ) AND commen |
|          | ate, WP_Comment_Query->__construct, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Quer | t_post_ID = 4179 AND comment_parent = 0  ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC  |
|          | y->get_comment_ids                                                                                           |                                                                                                                 |
| 8.2E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), comments_templ | SELECT wp_comments.* FROM wp_comments WHERE comment_ID IN (502)                                                 |
|          | ate, WP_Comment_Query->__construct, WP_Comment_Query->query, WP_Comment_Query->get_comments, _prime_comment_ |                                                                                                                 |
|          | caches                                                                                                       |                                                                                                                 |
| 8.3E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), comments_templ | SELECT  wp_comments.comment_ID FROM wp_comments  WHERE ( comment_approved = '1' ) AND comment_post_ID = 4179 AN |
|          | ate, WP_Comment_Query->__construct, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Quer | D comment_parent IN ( 502 )  ORDER BY wp_comments.comment_date_gmt ASC, wp_comments.comment_ID ASC              |
|          | y->fill_descendants, get_comments, WP_Comment_Query->query, WP_Comment_Query->get_comments, WP_Comment_Query |                                                                                                                 |
|          | ->get_comment_ids                                                                                            |                                                                                                                 |
| 0.000101 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), generate_const | SELECT DISTINCT tt2.term_id AS tag_id FROM wp_posts as posts INNER JOIN wp_term_relationships as tr2 ON posts.I |
|          | ruct_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/generatepress/sidebar.php' | D = tr2.object_ID INNER JOIN wp_term_taxonomy as tt2 ON tr2.term_taxonomy_id = tt2.term_taxonomy_id  WHERE post |
|          | ), dynamic_sidebar, WP_Widget->display_callback, WP_Bullet_Category_Cloud_Widget->widget                     | s.post_status = 'publish' AND tt2.taxonomy = 'category'  AND posts.post_type IN ('post')                        |
| 0.000151 | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), generate_const | SELECT  t.*, tt.* FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxo |
|          | ruct_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/generatepress/sidebar.php' | nomy IN ('category') AND t.term_id IN ( 32,14,31,30,27,29,28,1,24,25,23,15,19,20,22,11,16,21,8,9,10,4,17,13,18, |
|          | ), dynamic_sidebar, WP_Widget->display_callback, WP_Bullet_Category_Cloud_Widget->widget, WP_Bullet_Category | 7,6,5 ) ORDER BY tt.count DESC                                                                                  |
|          | _Cloud_Widget->render_cloud, WP_Bullet_Category_Cloud_Widget->get_cloud_default_format, wp_tag_cloud, get_te |                                                                                                                 |
|          | rms, WP_Term_Query->query, WP_Term_Query->get_terms                                                          |                                                                                                                 |
| 9.2E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), generate_const | SELECT term_id, meta_key, meta_value FROM wp_termmeta WHERE term_id IN (23,4,20,9,30,11,24,31,22,25,15,16,21,19 |
|          | ruct_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/generatepress/sidebar.php' | ,28,29,1,14,32) ORDER BY meta_id ASC                                                                            |
|          | ), dynamic_sidebar, WP_Widget->display_callback, WP_Bullet_Category_Cloud_Widget->widget, WP_Bullet_Category |                                                                                                                 |
|          | _Cloud_Widget->render_cloud, WP_Bullet_Category_Cloud_Widget->get_cloud_default_format, wp_tag_cloud, get_te |                                                                                                                 |
|          | rms, WP_Term_Query->query, WP_Term_Query->get_terms, update_termmeta_cache, update_meta_cache                |                                                                                                                 |
| 7.5E-5   | require_once('wp-includes/template-loader.php'), include('/themes/generatepress/single.php'), generate_const | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts  WHERE post_typ |
|          | ruct_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/generatepress/sidebar.php' | e = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC       |
|          | ), dynamic_sidebar, WP_Widget->display_callback, WP_Widget_Archives->widget, wp_get_archives                 |                                                                                                                 |
+----------+--------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------+

You can see that scientific notation is used in the time column above but you can try to show the biggest queries

SHELL_PIPE=0 wp query-debug --allow-root --url="https://guides.wp-bullet.com/fixing-wp_options-table-missing-unique-column-primary-key/" --format=table | sort -n | tail -n 20