Log CakePHP 2.x queries. Line 455

log_queries.php

$references = array(
	'SELECT'  => 'yellow',
	'deleted' => 'red',
	'DELETE'  => 'red',
	'UPDATE'  => 'blue',
	'INSERT'  => 'green',
);

$excludes = array('SHOW FULL COLUMNS', 'Aro', 'Aco', 'Permission', 'SHOW TABLES', 'SELECT CHARACTER_SET_NAME', 'SELECT COUNT');
$print = true;
$color = 'magenta';

foreach ($excludes as $exclude) {
	if (strstr($sql, $exclude)) {
		$print = false;
		break;
	}
}

foreach ($references as $keyword => $update) {
	if (strstr($sql, $keyword)) {
		$color = $update;
		break;
	}
}

if ($print) {
	$display = strstr($sql, 'FROM');
	CakeLog::write('error', "<{$color}>{$display}</{$color}>");
}