sql_sniffer.php

<?php

class mysqlisniffer extends \mysqli
{
    private $queries = [];

    public function query($query, $resultmode = MYSQLI_STORE_RESULT)
    {
        $this->queries[] = ['debug_backtrace' => array_map(function ($item) {
            return [
                $item['file'] . ':' . $item['line'],
                $item['class'] . '::' . $item['function'] . '()'
            ];

        }, debug_backtrace()), 'query' => $query];
        return parent::query($query, $resultmode);
    }

    private function printBackLog()
    {
        echo '<pre>';
        print_r($this->queries);
        echo '</pre>';
    }


    public function __destruct()
    {
        $this->printBackLog();
    }
}


$db = new mysqlisniffer(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);