-- Use ONLY a disposable database created for this demo after approval.
-- This query mirrors the composite index in the migration. Capture raw results;
-- never copy SQLite measurements into a MySQL report.
SELECT VERSION();
EXPLAIN ANALYZE SELECT id, subtotal_cents, created_at FROM quotes
 WHERE dealer_id = 42 AND status = 'approved'
 ORDER BY created_at DESC, id DESC LIMIT 20;
-- For a before plan, restore a disposable pre-index fixture snapshot or use
-- IGNORE INDEX (dealer_status_recent) in this query; do not drop production indexes.
EXPLAIN ANALYZE SELECT id, subtotal_cents, created_at FROM quotes IGNORE INDEX (dealer_status_recent)
 WHERE dealer_id = 42 AND status = 'approved'
 ORDER BY created_at DESC, id DESC LIMIT 20;