N+1 query patterns repeat the same SQL many times per request. See per-route patterns and affected URLs in the Database queries page.
A query pattern repeated above the configured threshold during this audit.
n-plus-one-detected
N+1 queries happen when accessing a relation inside a loop without eager loading. Each iteration triggers a separate SQL query — 100 items = 101 queries.
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
Repeated queries
SELECT * FROM posts WHERE user_id = ?
app/Http/Controllers/BlogController.php:42
SELECT * FROM comments WHERE post_id = ?
app/View/Components/PostCard.php:18
// Eager-load the relationship
$users = User::with('posts')->get();
foreach ($users as $user) {
echo $user->posts->count();
}// 1 + N queries — fires a SELECT for each user
$users = User::all();
foreach ($users as $user) {
echo $user->posts->count();
}