Home Home Retrieve MySQL Queries Programatically in WordPress

Retrieve MySQL Queries Programatically in WordPress

You can retrieve the list of executed MySQL queries programatically in WordPress to analyse or display them.

First you need to place the below code in wp-config.php file so that WordPress allows you to do so.

define('SAVEQUERIES', true);

Now using the below PHP code you can retrieve the list of queries

<?php

global $wpdb;
$queries = $wpdb->queries; //$queries stores all the queries.
Narayan Prusty
WordPress Change Empty Trash IntervalHashing using Web Cryptography API
Comments: 1
  1. 4 years ago

    Small trick but very useful.

    ReplyCancel

Leave a Reply

To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks:

Here is some inline `code`.

Narayan Prusty

I am a full-stack web developer. I specialize in Blockchain and JavaScript. This is my personal blog where I write about programming and technologies that I learn and feel interesting to share.

4 years ago 1 Comment WordPress
Share this
Related Articles