=======================================================================
  DETAILED BATCH QUERY TIMING ANALYSIS
  Testing with 50 orders
=======================================================================

Loaded 50 order IDs

  Items found: 57
  Unique partslinks: 8

  Status history rows: 127
  Return rows: 0
  Cost rows: 0
  Partscan rows: 3
  Parts suppliers rows: 89
  Problem parts rows: 0
  Suppliers: 116

------------------------------------------------------------
  QUERY TIMING BREAKDOWN (Batch Method)
------------------------------------------------------------

  1. Orders                     0.57 ms
  2. Items + joins              1.04 ms
  3. Status history             0.72 ms
  4. Returns                    0.26 ms
  5. Additional costs          12.61 ms
  6. Partscan inventory         0.68 ms
  7. Parts suppliers            1.49 ms
  8. Problem parts              0.11 ms
  9. All suppliers              0.21 ms
  10. User assignments          0.37 ms
  11. Dept assignments          0.17 ms
------------------------------------------------------------
  TOTAL                        18.24 ms

============================================================
  REAL-WORLD PROJECTION
============================================================

  Current method (50 HTTP calls):
    Est. query time:    60 ms + Network:  2500 ms =   2560 ms

  Batch method (1 HTTP call):
    Query time:         18 ms + Network:    50 ms =     68 ms

  *** PROJECTED IMPROVEMENT: 37.5x faster ***

============================================================