LogicApps has two different kinds of triggers
The polling triggers are easy. Whenever the LogicApp is enabled and its trigger is scheduled, it will poll the source for new messages.
The subscribing triggers, like CDS(Dataverse)- and SQL-triggers, are a little harder.
Those triggers has state and remembers where it left off, so if you disable the logic app and re-enable it, then it will trigger for all of the items it has not yet seen since the last time the trigger fired.
This can give you massive problems, if you disabled the LogicApp for the purpose of mass-updating eg. SQL rows without triggering the LogicApp.
If you want to clear the trigger state change something in the trigger and save it before enabling it again. This should reset/clear any trigger state.
Any connector that needs a marker as to where it left off will utilize this.