Now run below scripts one by one, do you find any difference...
No. Each side of the AND condition has to be evaluated to determine whether the row is selected.
But if you'd used OR rather than AND, are you wondering whether, if the first condition evaluates to TRUE, subsequent tests are omitted?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.