Coolest Guides on the Planet

coolest guides on the planet

Coolest Guides On The Planet

  • Home
  • macOS
  • WebDev
  • All Posts
  • Contact

Find out how many database queries per pageload in WordPress

April 12, 2014 Leave a Comment

To find out how many WordPress mysql database queries a page requests and how long it takes the page to load whilst querying the database, you can add in a PHP function to a WordPress hook to find out. This can be displayed in either the source code of the html or rendered on the actual page.

Add a Function and Action

function themenamechild_mysql_queries () {
	echo '<!-- ';
	echo get_num_queries();
	echo ' queries in ';
	timer_stop(1);
	echo ' seconds.-->';

}
add_action ('wp_footer','themenamechild_mysql_queries', 999);
add_action ('wp_after_admin_bar_render','themenamechild_mysql_queries', 999);

The above code needs to be placed  in your functions.php file of your theme. The function will get the number of queries the page makes to the database and time how long it takes, this will then be echoed out to the wp_footer hook which is the last hook to fire on the page, it is given a priority of 999 so it executes very late on the page. I have also added the last hook to fire if your are logged in as admin; wp_after_admin_bar_render

page-load-queries

You can see the result in the source view of a page a the bottom.

If you want to see the numbers in the front end as appose to the source, do it like this instead:

function themenamechild_mysql_queries () {
	echo get_num_queries();
	echo ' queries in ';
	timer_stop(1);
	echo ' seconds.';

}
add_action ('wp_footer','themenamechild_mysql_queries', 999);

This removes the comment and one less action as the numbers will display at the bottom of the page.

page-load-queries-frontend

Cats: Database, WebDev, WordPress Tags: mysql

Tags

3gs 10.6 apache backup baseband boot clean urls cpanel css curl custom database drupal el capitan git Google image instadmg ios iphone jailbreak keys lion mac macos mojave macos sierra menu mysql OSX panda php phpmyadmin private public redirect redsn0w remote rsa SEO shell ssh terminal unstoppables upgrade urls

Donate a Beer to the Coolest Guides

Get Beaver Builder Now!

Discuss

3gs 10.6 apache backup baseband boot clean urls cpanel css curl custom database drupal el capitan git Google image instadmg ios iphone jailbreak keys lion mac macos mojave macos sierra menu mysql OSX panda php phpmyadmin private public redirect redsn0w remote rsa SEO shell ssh terminal unstoppables upgrade urls
Get DesktopServer

Lynda

Lynda.com Online Training Videos

TreeHouse

smlinks

Learn WordPress
osx-modify-shell-path

How to Add to the Shell Path in macOS Big Sur and Catalina using Terminal

October 19, 2019

virtual-hosts osx 10.10 yosemite

Set up Virtual Hosts on macOS Catalina 10.15 in Apache

October 19, 2019

Installing Homebrew on macOS Catalina 10.15, Package Manager for Linux Apps

October 18, 2019

Where is the bash shell in macos Catalina?

October 12, 2019

Refine your search

  • All
  • Modules
  • Themes
  • Documentation
  • Forums & Issues
  • Groups

RSS ars technica

  • Spotify seizes the day after Apple is forced to allow external payments
  • Apple and Meta furious at EU over fines totaling €700 million
  • After market tumult, Trump exempts smartphones from massive new tariffs
  • Apple silent as Trump promises “impossible” US-made iPhones
  • Apple enables RCS messaging for Google Fi subscribers at last

RSS mac surfer

  • Tot is new text editor for Mac, iPhone, and iPad focused on constraints and ease of use
  • TiPbITS: Google Drive Sorting Can Hide New Documents
  • How to take a screenshot on a MacBook Pro
  • How To Create Simple Animation With Mac Keynote
  • Last Week on My Mac: Virus pandemics

Donate

Copyright © 2025· Neil Gee - All Rights Reserved - Hosted by Runcloud

Copyright © 2025 · gee on Genesis Framework · WordPress · Log in