Loading...
Loading...
Compare original and translation side by side
Optimize this slow database queryFix the N+1 query problem in this codeOptimize this slow database queryFix the N+1 query problem in this codeAnalyze query performance and suggest indexesAnalyze query performance and suggest indexesundefinedundefinedundefinedundefinedundefinedundefinedSELECT * FROM users
WHERE email = 'user@example.com';
-- Execution time: 450msSELECT * FROM users
WHERE email = 'user@example.com';
-- 执行时间：450ms-- Add index
CREATE INDEX idx_users_email ON users(email);
-- Optimized query
SELECT id, email, name FROM users
WHERE email = 'user@example.com';
-- Execution time: 2ms-- 添加索引
CREATE INDEX idx_users_email ON users(email);
-- 优化后的查询
SELECT id, email, name FROM users
WHERE email = 'user@example.com';
-- 执行时间：2msundefinedundefinedreferences/query_patterns.mdreferences/query_patterns.md