我怎样才能在Laravel Eloquent的哪里和哪里做？

This is what I currently have:

$query->orderBy('id', 'DESC')

        ->where('totalColorless', '!=', 0) // currently removes all of these...
        ->where('totalResidual', '!=', 0) // ...and all of these

        ->get();

How can I make it so it removes rows which fulfill both WHERE criteria at the same time?

try with "orWhere":

[...]
->where('totalColorless', '!=', 0)
->orWhere('totalResidual', '!=', 0)
[...]

I think you must put orderBy() before get() and after where()