Video poker casino flash slots free download.Enjoy Free 888+200 Daily Legal Bonus

Resolved Angelo Rocha
(@angelorocha)

3 years, 9 months ago
I’m using wpdb to identify queries performed on my site’s home page.
My code is basically this:
```
global $wpdb;
$queries = [];
$total   = 0;
foreach($wpdb->queries as $key => $query):
	$queries[] = [
		'query' => $query[0],
		'start' => number_format_i18n($query[1], 4),
		'end'   => $query[3],
		'rows'  => count($wpdb->get_results($query[0], ARRAY_A)),
		'stack' => explode(',', $query[2]),
	];
	$total     += $query[1];
endforeach;

var_dump($queries);
```
It works fine, I can see the queries made for the homepage. But there’s one thing I can’t do, what query monitor does, identify which plugins are doing these queries.

I would like to know if this is something unique to the query monitor or if there is any wordpress functionality that can show which plugins are doing these queries.

Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Author John Blackbourn
(@johnbillion)

WordPress Core Developer

3 years, 9 months ago

It’s the patented, top-secret, generations-old recipe from my great-grandmother inside Query Monitor which is used to figure out what is responsible for any given query.

The vanilla stack trace that WordPress stores (in $query[2] in your code) isn’t enough to accurately figure it out, which is why QM uses its own db.php file and uses it to store a full stack trace.

* https://github.com/johnbillion/query-monitor/blob/7fc836b8d68f04ae4d0c2ff115400c2db4a55269/wp-content/db.php#L110
* https://github.com/johnbillion/query-monitor/blob/7fc836b8d68f04ae4d0c2ff115400c2db4a55269/classes/Backtrace.php#L115-L146

Thread Starter Angelo Rocha
(@angelorocha)

3 years, 9 months ago

Woa, very good, lol.
Thanks man! I will investigate the recipe <3
Thread Starter Angelo Rocha
(@angelorocha)

3 years, 9 months ago
Done!
```
global $wpdb;

$queries = [];
$total   = 0;
foreach($wpdb->queries as $key => $query):
	$queries[] = [
		'query'     => $query[0],
		'start'     => number_format_i18n($query[1], 4),
		'end'       => $query[3],
		'rows'      => count($wpdb->get_results($query[0], ARRAY_A)),
		'component' => $query['trace']->get_component()->name,
	];
	$total     += $query[1];
endforeach;
var_dump($queries);
```
Output:
```
array (size=5)
      'query' => string 'SELECT option_value FROM wp_options WHERE option_name = 'active_sitewide_plugins' LIMIT 1' (length=89)
      'start' => string '0,0001' (length=6)
      'end' => float 1624391505.7874
      'rows' => int 0
      'component' => string 'Plugin: buddypress' (length=18)
```
Thanks again!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘How query monitor identifies queries made by plugins?’ is closed to new replies.