/**
	 * Execute the console command.
	 *
	 * @throws Exception
	 */
	public function handle(): void
	{
		// Add debugQueries method into console command handle method:
		$this->debugQueries();
	}
	
	/**
	 * Dump DB queries
	 */
	private function debugQueries()
	{

		// Show queries
		\DB::listen(function ($sql) {

			try {
				$fullQueryString = vsprintf(str_replace('?', '%s', $sql->sql), collect($sql->bindings)->map(function ($binding) {
					return is_numeric($binding) ? $binding : "'{$binding}'";
				})->toArray());
			} catch (Exception $ex) {
				$fullQueryString = $ex->getMessage();
			}

			dump([
				'QUERY' => $sql->sql,
				'BINDINGS' => $sql->bindings,
				'FULL QUERY STRING' => $fullQueryString,
				'QUERY EXECUTION TIME' => $sql->time,
				'CONNECTION NAME' => $sql->connectionName,
			]);

		});
	}