Using queries in and i see 7000+queries?

195 queries for one page is a lot. 7000 queries is not a lot, it is insane.

Install Query Monitor. It tracks all queries and presents them in groups.

enter image description here

I don’t know if it can track that many queries, this is probably an interesting stress test. 🙂

Find the source of those queries, deactivate it. If you are not sure what the source is, disable all plugins and switch to the default theme. Does it still happen? If it doesn’t reactivate each component separately until the queries explode again.

Related Posts:

  1. What’s a good strategy for planning WordPress DB growth?
  2. Optimize Multiple Taxonomy Term MySQL Query?
  3. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  4. How to reduce uncached page generation time?
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  7. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  8. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  9. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  10. MySQL server startup error ‘The server quit without updating PID file’
  11. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  12. When to use SELECT … FOR UPDATE?
  13. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  14. 1052: Column ‘id’ in field list is ambiguous
  15. Escape string Python for MySQL
  16. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  17. Search for all occurrences of a string in a mysql database
  18. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  19. SQL ZOO List each continent and the name of the country that comes first alphabetically
  20. How to convert a string to date in MySQL?
  21. MySQL COUNT DISTINCT
  22. How to update a record using sequelize for node?
  23. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  24. Convert MySQL to SQlite [closed]
  25. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  26. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  27. Convert partially non-numeric text into number in MySQL query
  28. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  29. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  30. MySQL: What’s the difference between float and double?
  31. How can I search (case-insensitive) in a column using LIKE wildcard?
  32. MySQL Select Multiple VALUES
  33. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  34. How to unblock with mysqladmin flush hosts
  35. If variable equals value php [duplicate]
  36. Node.js MySQL – Error: connect ECONNREFUSED
  37. Solution to “subquery returns more than 1 row” error
  38. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  39. How To have Dynamic SQL in MySQL Stored Procedure
  40. MySQL – UPDATE query with LIMIT
  41. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  42. What SQL Query to do a simple find and replace
  43. WordPress mysqli and PDO
  44. Scanning Database for malicious Data
  45. how to refresh wordpress permalink settings? (without admin panel)
  46. Ordering posts by day (not time) AND meta value
  47. wpdb->prepare function remove single quote for %s in SQL statment
  48. Problems with DBDelta with FOREIGN key?
  49. Is it useful to turn on MySQL query cache for performance
  50. Programmatically changing role information; editing role name and deleting
  51. Search and replace in post content
  52. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  53. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  54. wpdb insert and boolean fields
  55. What are the issues associated with upgrading MySQL for WordPress?
  56. How to find meta entries with their posts missing via SQL?
  57. Mysql SELECT posts
  58. #1115 – Unknown character set: ‘utf8mb4’
  59. How to add a private user page populated from sql?
  60. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  61. Which is better and faster ? WordPress Queries or SQL Query
  62. Using WPDB->Insert()
  63. Active DB queries in WordPress?
  64. Changing MySQL password via WHM – does this affect WordPress?
  65. Run Username SQL Query from WordPress Child Theme Functions File
  66. SQL syntax error. However, it works normally at phpmyadmin
  67. Setting up WordPress Locally on WAMP for a new site (with one already)
  68. string literals in query
  69. MySQL query for taxonomy-meta
  70. Editing mysql tables/database with wordpress or other app/cms
  71. Create pages from MySQL database
  72. Sql – Search with serialized Data / better database concept
  73. WordPress unescape text on mysql?
  74. Getting data from Mysql Table..confusing
  75. Exporting completed webiste for another server
  76. SQL Statement – Mass Delete Custom Post Types
  77. Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
  78. latency problems with wordpress install (from SQL import)
  79. mysql – Delete keyword with link from wordpress post database
  80. Creating dynamic content and pages for 1000’s of locations
  81. Remove duplicate media entries from mysql database
  82. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  83. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  84. DB option update with wp-cli
  85. SQL: How to find all attachments that are not used in any posts/pages/custom_post_types
  86. Find locations of all featured images of draft posts via SQL
  87. wpdb insert into point column in db
  88. MySQL Actibity without any active visitors via Google Analytics
  89. 403 Forbidden home on localhost with nginx server
  90. WPDB delivers wrong results from complex queries
  91. How to change link in all posts?
  92. WP Meta Query – mixed AND / OR query doesn’t work
  93. #1115 – Unknown character set: ‘utf8mb4’
  94. Get data from 3rd table
  95. Query sql for truncate post_content in wp_posts table
  96. Foreach only outputs if id is 0
  97. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  98. InnoDB: Error: log file ./ib_logfile0 is of different size
  99. Postgres equivalent to MySQL’s \G?
  100. How can I show mysql locks?
tech