GeminiLabs\BlackBar\Modules\Queries

Complexity

Total Complexity

13

Size/Duplication

Total Lines	71
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	label()	0	3	1
A	sortByTime()	0	6	3
A	hasEntries()	0	4	1
A	entries()	0	39	5
A	info()	0	9	3

<?php

namespace GeminiLabs\BlackBar\Modules;

class Queries extends Module
{
    public function entries(): array
    {
        global $wpdb;
        $entries = [];
        $index = 0;
        $search = [
            'FROM', 'GROUP BY', 'INNER JOIN', 'LEFT JOIN', 'LIMIT',
            'ON DUPLICATE KEY UPDATE', 'ORDER BY', 'OFFSET', ' SET', 'WHERE',
        ];
        $replace = array_map(function ($value) {
            return PHP_EOL.$value;
        }, $search);
        foreach ($wpdb->queries as $query) {
            $sql = preg_replace('/\s\s+/', ' ', trim($query[0]));
            $sql = str_replace(PHP_EOL, ' ', $sql);
            $sql = str_replace(['( ', ' )', ' ,'], ['(', ')', ','], $sql);
            $sql = str_replace($search, $replace, $sql);
            $parts = explode(PHP_EOL, $sql);
            $sql = array_reduce($parts, function ($carry, $part) {
                if (str_starts_with($part, 'SELECT') && strlen($part) > 100) {
                    $part = preg_replace('/\s*(,)\s*/', ','.PHP_EOL.'  ', $part);
                }
                if (str_starts_with($part, 'WHERE')) {
                    $part = str_replace('AND', PHP_EOL.'  AND', $part);
                }
                return $carry.$part.PHP_EOL;
            });
            $trace = explode(', ', $query[2]);
            $nanoseconds = (int) round($query[1] * 1e9);
            $entries[] = [
                'index' => $index++,
                'sql' => $sql,
                'time' => $nanoseconds,
                'time_formatted' => $this->formatTime($nanoseconds),
                'trace' => array_reverse($trace, true),
            ];
        }
        uasort($entries, [$this, 'sortByTime']);
        return $entries;
    }

    public function hasEntries(): bool
    {
        global $wpdb;
        return !empty($wpdb->queries);
    }

    public function info(): string
    {
        if (!defined('SAVEQUERIES') || !SAVEQUERIES) {
            return '';
        }
        global $wpdb;
        $seconds = (float) array_sum(wp_list_pluck($wpdb->queries, 1));
        $nanoseconds = (int) round($seconds * 1e9);
        return $this->formatTime($nanoseconds);
    }

    public function label(): string
    {
        return __('SQL', 'blackbar');
    }

    protected function sortByTime(array $a, array $b): int
    {
        if ($a['time'] !== $b['time']) {
            return ($a['time'] > $b['time']) ? -1 : 1;
        }
        return 0;
    }
}