Productivity Tips

// Recommended log levels
Apex Code: FINEST
System: INFO
Validation: INFO
Database: FINE
Workflow: INFO

System.debug('=== AccountTrigger ===');
System.debug('Records: ' + 
    JSON.serializePretty(newAccounts));
System.debug('SOQL used: ' + 
    Limits.getQueries() + '/' + 
    Limits.getLimitQueries());

// Quick limit check
System.debug(Limits.getCpuTime());
System.debug(Limits.getHeapSize());
System.debug(Limits.getQueries());

// ❌ Wrong — hits limit fast
for (Account a : accounts) {
    List<Contact> c = [SELECT Id FROM 
        Contact WHERE AccountId = :a.Id];
}

// ✅ Right — one query for all
Map<Id, List<Contact>> cMap = new Map<>();
for (Contact c : [SELECT Id, AccountId 
    FROM Contact WHERE AccountId IN :accounts]) {
    if (!cMap.containsKey(c.AccountId))
        cMap.put(c.AccountId, new List<Contact>());
    cMap.get(c.AccountId).add(c);
}

// ❌ Injection risk
String q = 'SELECT Id FROM Account WHERE Name = \''
    + userInput + '\'';

// ✅ Safe bind variable
String name = userInput;
List<Account> accs = [SELECT Id FROM Account
    WHERE Name = :name];

SELECT Id, Name, Account.Name,
    (SELECT Id, Subject
     FROM Cases)
FROM Contact
WHERE Account.Industry = 'Technology'

Integer total = [SELECT COUNT() 
    FROM Opportunity 
    WHERE StageName = 'Closed Won' 
    AND CloseDate = THIS_YEAR];

public with sharing class AccountService {
    // Respects sharing rules ✅
    public static List<Account> getAccounts() {
        return [SELECT Id FROM Account];
    }

    // Isolated bypass for internal use only
    private without sharing class Admin {
        List<Account> getAllAccounts() {
            return [SELECT Id FROM Account];
        }
    }
}

SObjectAccessDecision decision = 
    Security.stripInaccessible(
        AccessType.CREATABLE, records);

insert decision.getRecords();

// Last resort — always escape
String safe = String.escapeSingleQuotes(input);
String q = 'SELECT Id FROM Account WHERE Name = \''
    + safe + '\'';