pdo log

pdolog.php

<?php

class PDOLog extends PDO{

    public $queriesLog = [];
    public $transactionCounter = 0;

    public function prepare(){
        $arg_list = func_get_args();
        $this->queriesLog[] = $arg_list[0];
        return  call_user_func_array(array($this, 'parent::' . __FUNCTION__), $arg_list);
    }

    public function beginTransaction()
    {
        $this->transactionCounter++;
        return parent::beginTransaction();

    }
    public function commit()
    {

        $this->transactionCounter = 0;
        return parent::commit();

    }

    public function rollback()
    {
        $this->transactionCounter = 0;
        return parent::rollback();
    }
}

$pdo = new PDOLog();

$pdo->queriesLog;
$pdo->pdotransactionCounter;