How to setup port forwarding in Windows

To start:

netsh interface portproxy add v4tov4 listenport=8080 listenaddress=0.0.0.0 connectport=80 connectaddress=127.0.0.1

And to remove:

netsh interface portproxy delete v4tov4 listenport=8080 listenaddress=0.0.0.0

You can also use:

netsh interface portproxy reset

or

netsh interface portproxy delete

to drop the forwarding. If you face some issue setting this up please refer to this.

How to get and debug WordPress SQL queries

WordPress provides handy way to get all queries and to debug them easily.

To enable queries collecting add the following in your wp-config.php:

define('SAVEQUERIES', true);

Next should be added to your theme footer (wp-content/themes/<your_theme>/footer.php)

<?php echo get_num_queries(); ?> queries in <?php timer_stop(1); ?> seconds.

<?php
if (current_user_can('administrator')){
global $wpdb;
echo "<pre>";
print_r($wpdb->queries);
echo "</pre>";
}
?>

At the end you should be able to get something like:

134 queries in 0.301 seconds.

and a bunch of SQL queries.