golden hour

/var/www/html/wp-content/plugins/query-monitor/collectors

File/Folder	Size	Actions
admin.php	3.62 KB
assets.php	7.13 KB
assets_scripts.php	971 B
assets_styles.php	659 B
block_editor.php	4.87 KB
cache.php	3.14 KB
caps.php	6.49 KB
conditionals.php	2.38 KB
db_callers.php	789 B
db_components.php	828 B
db_dupes.php	2.79 KB
db_queries.php	5.99 KB
debug_bar.php	2.38 KB
environment.php	8.96 KB
hooks.php	1.52 KB
http.php	8.79 KB
languages.php	4.1 KB
logger.php	4.26 KB
overview.php	2.71 KB
php_errors.php	15.45 KB
raw_request.php	2.36 KB
redirects.php	772 B
request.php	6.61 KB
theme.php	8.96 KB
timing.php	3.28 KB
transients.php	2.44 KB

Edit: db_dupes.php

<?php
/**
 * Duplicate database query collector.
 *
 * @package query-monitor
 */

defined( 'ABSPATH' ) || exit;

class QM_Collector_DB_Dupes extends QM_Collector {

public $id = 'db_dupes';

public function process() {
		$dbq = QM_Collectors::get( 'db_queries' );

if ( ! $dbq ) {
			return;
		}
		if ( ! isset( $dbq->data['dupes'] ) ) {
			return;
		}

// Filter out SQL queries that do not have dupes
		$this->data['dupes'] = array_filter( $dbq->data['dupes'], array( $this, 'filter_dupe_items' ) );

// Ignore dupes from `WP_Query->set_found_posts()`
		unset( $this->data['dupes']['SELECT FOUND_ROWS()'] );

$stacks     = array();
		$tops       = array();
		$callers    = array();
		$components = array();

// Loop over all SQL queries that have dupes
		foreach ( $this->data['dupes'] as $sql => $query_ids ) {

// Loop over each query
			foreach ( $query_ids as $query_id ) {

if ( isset( $dbq->data['dbs']['$wpdb']->rows[ $query_id ]['trace'] ) ) {
					$trace     = $dbq->data['dbs']['$wpdb']->rows[ $query_id ]['trace'];
					$stack     = wp_list_pluck( $trace->get_filtered_trace(), 'id' );
					$component = $trace->get_component();

// Populate the component counts for this query
					if ( isset( $components[ $sql ][ $component->name ] ) ) {
						$components[ $sql ][ $component->name ]++;
					} else {
						$components[ $sql ][ $component->name ] = 1;
					}
				} else {
					$stack = array_reverse( explode( ', ', $dbq->data['dbs']['$wpdb']->rows[ $query_id ]['stack'] ) );
				}

// Populate the caller counts for this query
				if ( isset( $callers[ $sql ][ $stack[0] ] ) ) {
					$callers[ $sql ][ $stack[0] ]++;
				} else {
					$callers[ $sql ][ $stack[0] ] = 1;
				}

// Populate the stack for this query
				$stacks[ $sql ][] = $stack;

}

// Get the callers which are common to all stacks for this query
			$common = call_user_func_array( 'array_intersect', $stacks[ $sql ] );

// Remove callers which are common to all stacks for this query
			foreach ( $stacks[ $sql ] as $i => $stack ) {
				$stacks[ $sql ][ $i ] = array_values( array_diff( $stack, $common ) );

// No uncommon callers within the stack? Just use the topmost caller.
				if ( empty( $stacks[ $sql ][ $i ] ) ) {
					$stacks[ $sql ][ $i ] = array_keys( $callers[ $sql ] );
				}
			}

// Wave a magic wand
			$sources[ $sql ] = array_count_values( wp_list_pluck( $stacks[ $sql ], 0 ) );

}

if ( ! empty( $sources ) ) {
			$this->data['dupe_sources']    = $sources;
			$this->data['dupe_callers']    = $callers;
			$this->data['dupe_components'] = $components;
		}

}
}

function register_qm_collector_db_dupes( array $collectors, QueryMonitor $qm ) {
	$collectors['db_dupes'] = new QM_Collector_DB_Dupes();
	return $collectors;
}

add_filter( 'qm/collectors', 'register_qm_collector_db_dupes', 25, 2 );