diff --git a/src/app/http/controllers/HCURLShortenerController.php b/src/app/http/controllers/HCURLShortenerController.php
index <HASH>..<HASH> 100644
--- a/src/app/http/controllers/HCURLShortenerController.php
+++ b/src/app/http/controllers/HCURLShortenerController.php
@@ -232,7 +232,7 @@ class HCURLShortenerController extends HCBaseController
         if (!$record)
             abort(404);
 
-        DB::table(HCShortURL::getTableName())->where('short_url_key', $shortURLKey)->increment('clicks');
+        $record->increment('clicks');
 
         return redirect($record->url);
     }
diff --git a/src/app/models/HCShortURL.php b/src/app/models/HCShortURL.php
index <HASH>..<HASH> 100644
--- a/src/app/models/HCShortURL.php
+++ b/src/app/models/HCShortURL.php
@@ -20,4 +20,14 @@ class HCShortURL extends HCUuidModel
      */
     protected $fillable = ['id', 'url', 'short_url_key', 'description', 'clicks'];
 
+    /**
+     * Get hashed link attribute
+     *
+     * @return \Illuminate\Contracts\Routing\UrlGenerator|string
+     */
+    public function getShortUrlLinkAttribute()
+    {
+        return route('url.shortener', $this->short_url_key);
+    }
+
 }
added hashed url getting helper and optimized incrementing