We have triggers running to update Contact when Campaign Member Status is changed for different types of Campaigns. Each trigger has filtering, that means only those Campaign Members fall in a particular campaign will update Contact.  We have another new campaign and just developed a simple trigger to update Contact.  The trigger itself is running fine but when we deployed to production, another two test class has error "System.LimitException: Too many SOQL queries: 101".  One is related to Campaign while the other is related to Contact.  May I know why?