Retrieve comments and its count() by paginate in one query

Hello guys, I want to retrive comments and comments_count but I want to know that is it possible to do this in one query?

In controller I have this

$comments = $product->comments()
		->with(['user', 'rating'])
		->withCount('replies')->paginate(5);
$comment_count = $product->comments()->count();

Can I do this in one query? or is there a better way to do this?

Best Answer

Level 75

Use paginator total method. It will be executed only one query for pagination.

$comments = $product->comments()
	->with(['user', 'rating'])
	->withCount('replies')
    ->paginate(5);

$comment_count = $comments->total();

1 like

Please or to participate in this conversation.