Criterion to order a given query by a priority trend. This class may be applied in Laravel Query Builder.

OrderByPriorityTrendCriterion.php

<?php

namespace App\QueryBuilderCriteria;

use App\Contracts\QueryBuilderCriteria;
use Illuminate\Database\PostgresConnection;

class OrderByPriorityTrendCriterion extends QueryBuilderCriteria
{
    public function apply($queryBuilder)
    {
        if (!$queryBuilder->getConnection() instanceof PostgresConnection) {
            return $queryBuilder->orderByRaw('-LOG(1.0 - RAND()) / priority');
        }

        return $queryBuilder->orderByRaw('-LOG(1.0 - RANDOM()) / priority');
    }
}