问循环查询还是sql查询，哪个更快？

EN

$payMethods = PayMethod::has('payments')->get();
    $payments = collect();

    foreach ($payMethods as $payMethod) {

        $paid = 0;

        if ($payMethod->bankProvider->provider->type == 1) {
            foreach ($payMethod->payments as $payment) {
                $paid +=  $payment->price;
            }
        }

        $payments[$payMethod->name] = $paid;

    }

    return response()->json($payments);

$payMethods = PayMethod::has('payments')->get();
    $payments = collect();

    foreach ($payMethods as $payMethod) {

        $sql = 'SELECT ROUND(SUM(a.price), 2) AS amount FROM payments a 
                JOIN paymethods b ON a.paymethod_id = b.id
                JOIN bank_provider c ON b.bank_provider_id = c.id
                JOIN providers d ON c.provider_id = d.id
                WHERE d.`type` = 1 AND a.paymethod_id = :paymethod_id AND a.deleted_at IS NULL';

        $paid = DB::select($sql, ['paymethod_id' => $payMethod->id]);

        $payments[$payMethod->name] = $paid[0]->amount;

    }

    return response()->json($payments);