Phpunit Query Count Assertions Laravel Package

Full Changelog: https://github.com/mattiasgeniar/phpunit-query-count-assertions/compare/1.2.4...1.2.5

What's Changed

• Add query location reporting to assertion failures by @mattiasgeniar in https://github.com/mattiasgeniar/phpunit-query-count-assertions/pull/14

Full Changelog: https://github.com/mattiasgeniar/phpunit-query-count-assertions/compare/1.1.6...1.1.7

PHP 8.4 support

Support for Laravel 12

Support for Laravel 11.x added

• support Laravel 10

• support Laravel 9

• support Laravel 9

Full Changelog: https://github.com/mattiasgeniar/phpunit-query-count-assertions/compare/1.2.1...1.2.3

What's Changed

• Support multiple connections by @mattiasgeniar in https://github.com/mattiasgeniar/phpunit-query-count-assertions/pull/17

Full Changelog: https://github.com/mattiasgeniar/phpunit-query-count-assertions/compare/1.2.2...1.2.4

Query Performance Assertions: Index Usage, Duplicates & Timing

This release adds powerful query performance assertions to catch inefficient queries in your tests.

New Assertions

Index Usage Detection

Detect full table scans and missing indexes by running EXPLAIN on your queries:

$this->assertAllQueriesUseIndexes(function () {
    User::where('email', 'test@example.com')->first();
});

Supports MySQL, MariaDB, and SQLite. Detects full table scans, unused indexes, filesort, temporary tables, and more.

Duplicate Query Detection

Catch repeated identical queries:

$this->assertNoDuplicateQueries(function () {
    User::find(1);
    User::find(1); // Fails - duplicate
});

Query Timing Assertions

Set performance budgets for your queries:

$this->assertMaxQueryTime(100, fn() => ...);    // No single query over 100ms
$this->assertTotalQueryTime(500, fn() => ...);  // Total time under 500ms

Row Count Threshold (MySQL/MariaDB)

Fail when queries examine too many rows:

$this->assertMaxRowsExamined(1000, fn() => User::where('status', 'active')->get());

Combined Efficiency Assertion

Check everything at once—N+1, duplicates, and index usage:

$this->assertQueriesAreEfficient(function () {
    $users = User::with('posts')->get();
});

Or use trackQueries() in setUp/beforeEach for test-wide tracking.

Custom Query Analysers

Add support for additional databases:

AssertsQueryCounts::registerQueryAnalyser(new PostgresAnalyser());

Other Improvements

• Issue severity levels (ERROR, WARNING, INFO) with configurable failure thresholds
• Small table optimization: ignores full scans on tables < 10 rows
• FK constraint context in SQLite scan warnings
• PHPStan analysis added to CI

Backwards Compatibility

Fully backwards compatible. All existing methods unchanged.

Summary

• Add Doctrine/Symfony and Phalcon support via a driver-based architecture, while keeping Laravel zero-config
• Unsupported features (lazy loading on Doctrine/Phalcon, query timing on Doctrine) now emit PHPUnit warnings instead of skipping the entire test
• Add CI matrix covering all three frameworks across PHP 8.2–8.4

Simplify API by consolidating tracking methods

Summary

• Consolidated trackQueriesForEfficiency() into trackQueries() — one method now does everything
• Changed trackQueries() from static to instance method for consistent $this-> API

Breaking Changes

self::trackQueries() → $this->trackQueries()

The method is no longer static. Update your setUp/beforeEach:

// Before
protected function setUp(): void
{
    parent::setUp();
    self::trackQueries();
}

// After
protected function setUp(): void
{
    parent::setUp();
    $this->trackQueries();
}

trackQueriesForEfficiency() is deprecated

Replace with trackQueries():

// Before
$this->trackQueriesForEfficiency();

// After
$this->trackQueries();

Migration

Find and replace in your test files:

Why

The previous API had two methods that were confusingly similar:

• trackQueries() — basic query logging
• trackQueriesForEfficiency() — query logging + N+1 detection

Now there's just one method that does everything. If you only need query counts, the efficiency tracking has zero overhead — just don't call assertQueriesAreEfficient().

• initial release