I have something like this in my trigger
IF(VAR_ENABLED AND ((SELECT 1 FROM .... OR SELECT 1 FROM ...))
I noticed that the second condition is executed anyway when VAR_ENABLED is set to FALSE
>Solution :
Search conditions within parentheses are evaluated first. If the order
of evaluation is not specified by parentheses, NOT is applied before
AND, and AND is applied before OR. The order in which operators at the
same precedence level are evaluated is undefined to allow for
optimization of search conditions.