Logging slow queries in Laravel environments (e.g. /app/start/[environment].php)

SlowQueryListeningOnLaravel4

/** @var \Illuminate\Log\Writer $log */
$log = App::make('log');

DB::listen(function ($sql, $bindings, $time) use ($log) {

	if ( ! starts_with($sql, 'select'))
		return;

	//  only log long running select statements
	if ($time <= 1)
		return;

	$found = 0;
	while (($pos = strpos($sql, '?')) !== false)
	{
		$finding = $bindings[$found];
		if (is_array($finding))
		{
			$finding = '"' . implode('", "', $finding) . '"';
		}
		elseif (!is_numeric($finding))
		{
			$finding = '"' . $finding . '"';
		}

		$sql1 = substr($sql, 0, $pos);
		$sql2 = substr($sql, $pos + 1);

		$sql = $sql1 . $finding . $sql2;

		$found++;
	}

	$log->debug($sql . ' | ' . $time . 'ms');
});