How do I display database query statistics on Wordpress site?

mysql performance wordpress layout statistics

Try adding this to the bottom of the footer in your template:

<?php echo $wpdb->num_queries; ?> <?php _e('queries'); ?>. <?php timer_stop(1); ?> <?php _e('seconds'); ?>

mysql performance wordpress layout statistics

To explain pix0r's code:

$wpdb->num_queries is the number of database queries.
_e is for localization: http://faq.wordpress.net/view.php?p=50
timer_stop() returns the amount of time taken to render the page:
http://codex.wordpress.org/Function_Reference/timer_stop

mysql performance wordpress layout statistics

wordpress has a easy solution now

There is a function called get_num_queries() and as specified in other answers timer_stop().

<?php echo get_num_queries(); _e(' queries'); ?> in <?php timer_stop(1); _e(' seconds'); ?></p>

get_num_queries() - returns the number of database queries during the WordPress execution and accepts no parameters

CodeHunter