Skip to content

Instantly share code, notes, and snippets.

@Sherlockboy

Sherlockboy/comunity_members.php

Created December 16, 2025 06:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Sherlockboy/e5f7cc7b4434fda72f2f952e16fc7d58 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Sherlockboy/e5f7cc7b4434fda72f2f952e16fc7d58 to your computer and use it in GitHub Desktop.
Download ZIP
Query optimization task
Raw
comunity_members.php
<?php
/**
* The admin reports that the "Community Members" page takes 15 seconds to load.
* It shows 10K members with their last activity, course progress, and subscription status.
*/
$members = Community::find($id)
->members()
->with(['lastActivity', 'courseProgress', 'subscription'])
->paginate(50);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment