| Label | Statement | Rows | Time |
|---|
| as_of:server_date | SELECT date('now', 'localtime') | 1 | 0.013s |
| orders | SELECT o.order_id, o.order_date, o.region, o.customer, o.status, o.promised_date, o.actual_ship_date, o.net_total FROM orders o WHERE o.order_date >= :since | 532 | 0.007s |
| orders:count | SELECT COUNT(*) FROM ( SELECT o.order_id, o.order_date, o.region, o.customer, o.status, o.promised_date, o.actual_ship_date, o.net_total FROM orders o WHERE o.order_date >= :since | 1 | 0.002s |
| order_lines | SELECT l.order_id, l.item_code, l.qty FROM order_lines l JOIN orders o ON o.order_id = l.order_id WHERE o.order_date >= :since | 1,325 | 0.009s |
| order_lines:count | SELECT COUNT(*) FROM ( SELECT l.order_id, l.item_code, l.qty FROM order_lines l JOIN orders o ON o.order_id = l.order_id WHERE o.order_date >= :since ) t | 1 | 0.003s |
| inventory | SELECT i.item_code, i.stock_qty FROM inventory i | 40 | 0.002s |
| inventory:count | SELECT COUNT(*) FROM ( SELECT i.item_code, i.stock_qty FROM inventory i ) t | 1 | 0.001s |