- Use ILIKE instead of LIKE for PostgreSQL case-insensitive search - Add hashid fallback in Brand::getLogoUrl() and getBannerUrl() - Prevents route generation errors when hashid is missing from eager load - Reduce eager loading in index() to only needed columns - Add pagination to listings() method - Filter hashid at DB level instead of PHP collection