remove duplicate unique column rows in laravel

remove-duplicates.php

<?php
Route::get('test', function () {

$raw = \DB::raw('count(*) as total');
$requestCounts = \App\Models\Cards::query()->select('card_slug', $raw)->havingRaw('COUNT(*) > 1')->groupBy('card_slug')->limit(500)->pluck('total', 'card_slug');
if (ob_get_level() == 0) ob_start();
foreach ($requestCounts as $key => $val) {
    echo $key . ' - ' . $val . '<br>';
    $ids = \App\Models\Cards::where('card_slug', $key)->pluck('id');
    unset($ids[0]);
    \App\Models\Cards::whereIn('id', $ids)->delete();
    ob_flush();
    flush();
    echo '<script>var scrollingElement = (document.scrollingElement || document.body);
    scrollingElement.scrollTop = scrollingElement.scrollHeight;</script>';
}
ob_end_flush();
});