CREATE TABLE posts (
  id BIGINT PRIMARY KEY,
  author_id BIGINT NOT NULL,
  status VARCHAR(20) NOT NULL,
  published_at TIMESTAMP NULL,
  title VARCHAR(255) NOT NULL
);
CREATE INDEX idx_posts_status_published ON posts(status, published_at DESC);
CREATE INDEX idx_posts_author_status ON posts(author_id, status);
EXPLAIN SELECT id, title FROM posts WHERE status='publish' ORDER BY published_at DESC LIMIT 20;