Paginate count(*) query issue.

[nikunj-7span]

• Laravel Version: 8.0
• PHP Version: 7.3.0
• Database Driver & Version: MySQL 5.7.34

Describe the Bug

When I use paginate for pagination the data it call the count( * ) query every time even I pass the column name like count(['id']), and the count( * ) query scan all row in the table.

• Table name is mobiles and it has 45 column

• Route

Route::get("mobiles", "Api\V1\MobileController@show");

• Controller

namespace App\Http\Controllers\Api\V1;

class MobileController extends Controller
{
    public function show()
    {
        return Mobile::paginate(10 , ['id']);
    }
 }

• Call mobiles route
• Telescope showing me that two queries

Actual result

Expected result

Steps To Reproduce:

• The following image shows that I had done changes as per our functionality, It will take the first column name from the passed in the paginate method array of $columns params and that query does not scan all columns of the mobiles tables.

Final Results:

[parallels999]

Sounds like a great addition, did you make a pull request?