Mysql Queries per Visit – Crazy High

It goes against the grain here to recommend plugins but that’s what you need here.

To view in the browser;

https://wordpress.org/plugins/query-monitor/

To view in WP-CLI;

https://runcommand.io/wp/query-debug/

Both of these will list the queries and how long each one takes. That should give you enough information to make informed decisions about what to do in your case.

https://codex.wordpress.org/Debugging_in_WordPress

In your wp-config.php you may need to add defined( 'SCRIPT_DEBUG') or define( 'SCRIPT_DEBUG', true ); as well as define( 'WP_DEBUG', true );

Related Posts:

  1. WordPress database scalability from the code perspective
  2. WordPress for a very large website
  3. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  4. How to solve slow WordPress site caused by attachment_metadata
  5. Database slowdown after update to 3.4.1
  6. Which is more efficient? Using usermeta, or creating a new MySQL table?
  7. Improve performance by removing unnecessary database queries
  8. How to prevent/delay MySQL connections when an object cache is used?
  9. Rename a table in MySQL
  10. How should I tackle –secure-file-priv in MySQL?
  11. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  12. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  13. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  14. MySQL SELECT increment counter
  15. phpMyAdmin – Error > Incorrect format parameter?
  16. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  17. Using wpdb to connect to a separate database
  18. MySQL Database User: Which Privileges are needed?
  19. Why is my database import losing text widget data?
  20. Will it break my site if I delete all transient records in wp_options table?
  21. Checking if Database Table exists
  22. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  23. Please explain how WordPress works with MySQL character set and collation at a low level
  24. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  25. How to fetch Data in WordPress using MySQLi or $wpdb
  26. WordPress Database lost auto increment
  27. Connect to database using wordpress wp-config file
  28. wpdb->insert multiple record at once
  29. Reset Post IDs to less than 64bit integer
  30. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  31. Restoring WordPress posts from database only
  32. How to define composite keys with dbDelta()
  33. Is it possible to define two databases for one installation?
  34. Does WordPress use the InnoDB engine for MySQL by default?
  35. Slow wp_term_relationships query
  36. How to use “TRUNCATE TABLE” MySQL statement?
  37. Can I use MariaDB instead of MySQL in wordpress?
  38. Performance tips for a large user base [closed]
  39. Slow SQL_CALC_FOUND_ROWS Query
  40. WP_Options ID high
  41. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  42. What are conventions about the schema of the $table_prefix
  43. Split WP install between 2 databases?
  44. WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
  45. Inserting Post Meta From SQL
  46. Improve or optimize a very slow query
  47. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  48. Why does dbDelta() not catch MysqlErrors?
  49. Efficiency on displaying random authors based on large database
  50. Is deleting orphaned wp_options entries safe?
  51. Is altering a default WordPress database table update safe?
  52. Huge wp_options table
  53. “MySQL server has gone away” since update to 3.8
  54. Delete all post meta except featured image
  55. Custom DB_COLLATE (collation) value not working on fresh install?
  56. What causes the “max_user_connections” warning on WordPress frontend?
  57. what to do when your WordPress database is too large?
  58. Change all http to https in mysql databse?
  59. WooCommerce – Query for ordered products
  60. Large database causes slow load
  61. Relationship between performance and database size
  62. Changing BIGINT to INT
  63. Error establishing a database connection – with Debug Data
  64. How to execute mulitple statement SQL queries using $wpdb->query?
  65. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  66. Can I transfer a mysql database to another site?
  67. WordPress and automated MySQL backups to a different host
  68. Database with mixed collation (utf8mb4 & utf8_general_ci)
  69. Query WordPress database by registered date and role
  70. MySQL Syntax Error upon restoring database from backup [closed]
  71. Tons of Twitter rows in my database
  72. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  73. How to insert data into MySQL database from the form created in WordPress site
  74. Set Display Name to first and last name (phpmyadmin SQL Query)
  75. Size article thumbnails and retrieve them directly from database
  76. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  77. Is it safe to convert tables from MyISAM to InnoDB?
  78. Emojis getting converted to “?”
  79. wp_redirection_404 table has grown to 7GB
  80. Migrating database / content of non-CMS site to WordPress
  81. Does WordPress ever need multiple databases?
  82. Why are no posts showing despite my apparently correct DB restoration?
  83. Select Multiple meta_value from WP DB; Single Query
  84. Delete all post meta except featured image Using SQL
  85. How do I properly update the WordPress database password?
  86. wpdb_prepare with multiple or condition
  87. One post carries 30 postmeta values, is this too much?
  88. Is it possible to split database tables using HyperDB?
  89. Adding new row to wp_post table
  90. WordPress Install and Database on separate hosting?
  91. What happens if I overwrite the current wp_options table with a backup from a week ago?
  92. WordPress mysql table double prefixes
  93. SQL Error wp_commentmeta – incorrect table definition
  94. WordPress database error – Error in SQL syntax – I can’t identify any error?
  95. CRUD operations using WordPress database API
  96. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  97. How do I get the posts within a certain year/date(with sql query)?
  98. Multiple wp_options tables to share content across installs
  99. WordPress database import: Row size too large
  100. Advanced SELECT query with condtional statements
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)