Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- N+1 (one query per order) SELECT id FROM orders; -- returns 100 rows -- then for each row: SELECT * FROM customers WHERE id = ?; -- Fixed with JOIN SELECT o.id, c.name FROM orders o JOIN customers c ON c.id = o.customer_id;
Result
Open