| Label | Statement | Rows | Time |
|---|
| as_of:server_date | SELECT date('now', 'localtime') | 1 | 0.006s |
| 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 | 980 | 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 AS o WHERE o.order_date >= :sin | 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 | 2,478 | 0.009s |
| order_lines:count | SELECT COUNT(*) FROM ( SELECT l.order_id, l.item_code, l.qty FROM order_lines AS l JOIN orders AS 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.001s |
| inventory:count | SELECT COUNT(*) FROM ( SELECT i.item_code, i.stock_qty FROM inventory AS i ) t | 1 | 0.001s |
| receivables | SELECT r.invoice_id, r.customer, r.due_date, r.open_amount FROM receivables r WHERE r.open_amount <> 0 | 81 | 0.002s |
| receivables:count | SELECT COUNT(*) FROM ( SELECT r.invoice_id, r.customer, r.due_date, r.open_amount FROM receivables AS r WHERE r.open_amount <> 0 ) t | 1 | 0.001s |