Online PHP editor | perf for nKqhD

@ 2025-10-25T07:34:18Z

<?php

/**
     * Scope a query to only include soft-deleted users with impending grace period.
     *
     * The user's grace period is considered impending if there are less than
     * a certain amount of days remaining before the hard deletion of that user.
     *
     * @param Builder $query The query to scope.
     * @param null|int $daysLeft The maximum amount of days remaining to consider the grace period impending.
     * @param bool $exact Whether to only include users having exactly `$daysLeft` days left to hard deletion.
     *
     * @return void
     *
     * @throws LogicException
     * @throws InvalidArgumentException
     */
    #[Scope]
    protected function deletionGraceImpending
    (
        Builder $query,
        ?int $daysLeft = null,
        bool $exact = false
    ): void
    {
        $graceDays = (int) config('user.delete_grace_days', 30);
        $daysLeft = (int) ($daysLeft ?? config('user.delete_grace_notify_days', 7));

        $now = Carbon::now();

        if($graceDays <= 0) {
            throw new LogicException(
                'The grace period must be a positive number of days.' .
                'Check the `user.delete_grace_days` configuration.'
            );
        }

        if ($daysLeft < 0) {
            throw new InvalidArgumentException('The value of $daysLeft cannot be negative.');
        } elseif ($daysLeft === 0) {
            Log::warning('The value of $daysLeft is zero. Returning empty result.');
            $query->whereRaw('1 = 0');
            return;
        } elseif ($daysLeft > $graceDays) {
            Log::warning("daysLeft ({$daysLeft}) exceeds graceDays ({$graceDays}). Returning empty result.");
            $query->whereRaw('1 = 0');
            return;
        }

        // Calculate the proper bounds for 'deleted_at'.
        // For the user to be included in query results, the following inequality should hold:
        //      $lowerBound ⩽ deleted_at ⩽ $upperBound

        $lowerBound = $now->copy()->subDays($graceDays);
        $upperBound = $now->copy()->subDays($graceDays - $daysLeft);

        if($exact)
            $lowerBound = $upperBound->copy()->subDay()->addSecond();

        $interval = CarbonPeriod::create($lowerBound, $upperBound);

        $query->onlyTrashed()->whereBetween('deleted_at', $interval);
    }

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
8.4.14	0.033	0.012	17.50
8.4.13	0.034	0.009	17.46
8.4.12	0.040	0.007	17.30
8.4.11	0.041	0.006	17.71
8.4.10	0.047	0.010	17.70
8.4.9	0.040	0.010	17.70
8.4.8	0.034	0.014	17.73
8.4.7	0.043	0.010	17.42
8.4.6	0.034	0.012	17.80
8.4.5	0.037	0.009	17.60
8.4.4	0.039	0.010	17.37
8.4.3	0.040	0.010	17.65
8.4.2	0.041	0.011	17.47
8.4.1	0.038	0.011	17.58
8.3.27	0.039	0.005	16.33
8.3.26	0.039	0.007	16.65
8.3.25	0.039	0.010	16.60
8.3.24	0.033	0.012	16.57
8.3.23	0.032	0.013	16.66
8.3.22	0.032	0.013	16.77
8.3.21	0.034	0.010	16.81
8.3.20	0.035	0.010	16.83
8.3.19	0.036	0.009	16.53
8.3.18	0.043	0.002	16.77
8.3.17	0.037	0.010	16.29
8.3.16	0.036	0.011	16.52
8.3.15	0.039	0.009	16.72
8.3.14	0.043	0.006	16.65
8.3.13	0.033	0.011	16.37
8.3.12	0.037	0.005	16.38
8.3.11	0.036	0.010	16.61
8.3.10	0.039	0.009	16.53
8.3.9	0.040	0.008	16.34
8.3.8	0.035	0.013	16.69
8.3.7	0.034	0.013	16.31
8.3.6	0.043	0.005	16.74
8.3.5	0.036	0.011	16.51
8.3.4	0.041	0.009	17.31
8.3.3	0.041	0.003	17.52
8.3.2	0.036	0.006	17.29
8.3.1	0.032	0.005	17.61
8.3.0	0.032	0.011	17.39
8.2.29	0.031	0.007	16.36
8.2.28	0.030	0.008	16.85
8.2.27	0.029	0.010	16.47
8.2.26	0.033	0.007	16.30
8.2.25	0.030	0.010	16.63
8.2.24	0.028	0.011	16.47
8.2.23	0.032	0.007	16.24
8.2.22	0.030	0.009	16.40
8.2.21	0.027	0.011	16.38
8.2.20	0.031	0.009	16.39
8.2.19	0.031	0.010	16.67
8.2.18	0.033	0.006	16.54
8.2.17	0.036	0.009	17.74
8.2.16	0.033	0.008	17.42
8.2.15	0.037	0.005	17.50
8.2.14	0.036	0.007	17.35
8.2.13	0.036	0.005	17.36
8.2.12	0.036	0.006	17.37
8.2.11	0.035	0.009	17.52
8.2.10	0.033	0.008	17.43
8.2.9	0.034	0.007	17.55
8.2.8	0.034	0.007	17.61
8.2.7	0.048	0.008	17.28
8.2.6	0.033	0.010	17.39
8.2.5	0.040	0.011	17.42
8.2.4	0.029	0.011	17.32
8.2.3	0.029	0.010	17.28
8.2.2	0.030	0.008	17.41
8.2.1	0.033	0.006	17.33
8.2.0	0.033	0.011	17.44

preferences:dark modelive previewkey bindings