Washington Recreational River Runners

Renton,WA
https://wrrr.org/
president@wrrr.org
150 Members
Contact: Rebecca Post
president@wrrr.org

WRRR is a non-profit group of boaters who run rivers in all sort of inflatable boats (rafts, catboats, inflatable kayaks), kayaks and canoes, with members throughout Washington State and the Pacific Northwest.

Home Reaches

Cedar River (Landsburg bridge to Maplewood Roadside Park)
Cispus (3 - FR 23 Bridge to FR 28 Bridge (The Upper))
Cispus (4 - Road 28 Bridge to Scanewa Reservoir (The Lower))
Green (2 - Green River Gorge)
Methow (3. Averill (at McFarland Creek) access to Pateros)
Nooksack, N. Fork (3 - Douglas Fir Campground to Mt. Baker Highway milepost 27)
Sauk (1 - Bedal Campground to Whitechuck River (Upper))
Sauk (2 - Whitechuck River to Darrington)
Sauk (3 - Clear Creek to Darrington)
Skagit (3. Copper Creek to Rockport)
Skagit (2. Goodell Creek to Copper Creek)
Skykomish (1 - Index (Sunset Falls) to Split Rock)
Skykomish, N. Fork (2. Bear Creek (Drumb-beater) to South Fork confluence)
Snoqualmie, Middle Fork (3 - Taylor River to Concrete Bridge (Granite Creek))
Snoqualmie, Middle Fork (4 - Concrete Bridge to Tanner (Middle-Middle))
Snoqualmie, Middle Fork (5 - Tanner to North Bend)
Snoqualmie, S. Fork (2. Twin Falls State Park to 436th St. Bridge)
Stillaguamish, S. Fork (2 - Mallardy Creek to Verlot (Middle))
Tieton (1. Rimrock Reservoir to Windy Point Campground (Upper))
Wenatchee (3. Leavenworth to Cashmere)
Yakima (Confluence with Teanaway River to Thorp)
White Salmon (4 - BZ Corner to Buck Creek)
Skykomish (2 - Railroad Bridge to Big Eddy)

Associated Projects

Cispus River Access (WA)

AW has been working to enforce requirements for public access to the Cispus River.

Elwha Restoration (WA)

The Elwha River will be restored by removing two dams that have blocked salmon and degraded recreational opportunities on one of the Pacific Northwest's most spectacular rivers.

Puyallup Watershed (WA)

Major rivers of the Puyallup watershed include the Carbon, Puyallup, and White which drain the western and northern slopes of Mt. Rainier which we are working to preserve and protect.

Join AW and support river stewardship nationwide!
7.4.3PHP Version1.83sRequest Duration7MBMemory UsageGET content/{url}Route
    • Booting (47.06ms)
    • Application (1.79s)
    • 1 x Application (97.43%)
      1.79s
      1 x Booting (2.57%)
      47.06ms
      16 templates were rendered
      • legacy.views.container-view (resources/views/legacy/views/container-view.blade.php)6blade
        Params
        0
        components
        1
        controls
        2
        id
        3
        class
        4
        title
        5
        formRenderService
      • legacy.views.container-view (resources/views/legacy/views/container-view.blade.php)6blade
        Params
        0
        components
        1
        controls
        2
        id
        3
        class
        4
        title
        5
        formRenderService
      • legacy.views.container-view (resources/views/legacy/views/container-view.blade.php)6blade
        Params
        0
        components
        1
        controls
        2
        id
        3
        class
        4
        title
        5
        formRenderService
      • app::layout.gadget (resources/views/layout/gadget.blade.php)2blade
        Params
        0
        contents
        1
        formRenderService
      • layout.columnstyle.two-right (resources/views/layout/columnstyle/two-right.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
      • layout.columnstyle.componentstack (resources/views/layout/columnstyle/componentstack.blade.php)9blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
        7
        stack
        8
        component
      • layout.columnstyle.sidestack (resources/views/layout/columnstyle/sidestack.blade.php)9blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
        7
        stack
        8
        component
      • layout.main (resources/views/layout/main.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
      • layout._headers (resources/views/layout/_headers.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
      • layout.header (resources/views/layout/header.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
      • layout._scripts (resources/views/layout/_scripts.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
      • layout.navigation (resources/views/layout/navigation.blade.php)8blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
        7
        menu
      • includes.alert.membership (resources/views/includes/alert/membership.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
        7
        menu
        8
        searchurl
        9
        loginurl
        10
        logouturl
        11
        __currentLoopData
        12
        child
        13
        loop
        14
        otherchild
        15
        shouldNotifyUser
        16
        user
      • navigation.menu.static (resources/views/navigation/menu/static.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
        7
        menu
        8
        searchurl
        9
        loginurl
        10
        logouturl
        11
        __currentLoopData
        12
        child
        13
        loop
        14
        otherchild
      • includes.footer (resources/views/includes/footer.blade.php)8blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
        7
        menu
      • layout.pagemap (resources/views/layout/pagemap.blade.php)7blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        contents
        5
        formRenderService
        6
        layout
      uri
      GET content/{url}
      middleware
      web
      controller
      App\Http\Controllers\Wh2oController@content
      namespace
      App\Http\Controllers
      where
      as
      generated::Os9R4mqMKRF5ktoI
      file
      app/Http/Controllers/Wh2oController.php:34-68
      106 statements were executed, 77 of which were duplicated, 29 unique302ms
      • SELECT id, member_id, abstract, city, state, url, expiration, email, volunteer_id, affiliates.members, contact, description, reaches, name FROM affiliates where deleted_at is null and id = 70003
        638μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:375
        • 8. /app/Legacy/Repositories/AffiliateInfo.php:21
        • 9. /code/wh2o/ClubGadget.inc:290
      • select reachid from affiliates_reaches where affiliateid=70003
        300μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:415
        • 8. /app/Legacy/Repositories/AffiliateInfo.php:28
        • 9. /code/wh2o/ClubGadget.inc:290
      • select * from linker_gadgets
        188μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:391
        • 8. /app/Legacy/Repositories/LinksInfo.php:23
        • 9. /app/MetaControllers/LinkerMetaController.php:138
      • select * from linker_gadgets
        140μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:391
        • 8. /app/Legacy/Repositories/LinksInfo.php:23
        • 9. /app/MetaControllers/LinkerMetaController.php:138
      • select l.sourcecomp, l.sourceid, l.targetcomp, l.targetid, l.mutual, l.expire_date, l.id from linker_lists l left join linker_gadgets g on l.targetcomp = g.source where (l.sourcecomp = 'club' and (l.sourceid = '70003' or g.is_list =0 )) or (l.targetcomp = 'club' and l.targetid='70003' and l.mutual = 1 )
        435μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:391
        • 8. /app/Legacy/Repositories/LinksInfo.php:113
        • 9. /app/MetaControllers/LinkerMetaController.php:213
      • select * from projects where deleted_at is null and ( id='28' or short_name = '28' )
        491μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:375
        • 8. /app/Legacy/Repositories/ProjectInfo.php:13
        • 9. /code/wh2o/ProjectGadget.inc:151
      • select * from projects where deleted_at is null and ( id='40' or short_name = '40' )
        236μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:375
        • 8. /app/Legacy/Repositories/ProjectInfo.php:13
        • 9. /code/wh2o/ProjectGadget.inc:151
      • select * from projects where deleted_at is null and ( id='37' or short_name = '37' )
        231μs/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
        Metadata
        Backtrace
        • 4. /vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476
        • 6. /app/Legacy/Repositories/InfoADO.php:368
        • 7. /app/Legacy/Repositories/InfoADO.php:375
        • 8. /app/Legacy/Repositories/ProjectInfo.php:13
        • 9. /code/wh2o/ProjectGadget.inc:151
      • select * from "articles" where ("id" = '-SecurityGadget-explain' or "short_name" = '-SecurityGadget-explain') and "articles"."deleted_at" is null and "articles"."is_final" = 'true' limit 1
        500μs/app/Legacy/Repositories/NewsInfo.php:61wh2o
        Metadata
        Bindings
        • 0. -SecurityGadget-explain
        • 1. -SecurityGadget-explain
        • 2. true
        Backtrace
        • 15. /app/Legacy/Repositories/NewsInfo.php:61
        • 16. /code/wh2o/ArticleGadget.inc:128
        • 17. /code/wh2o/Page1.inc:930
        • 18. /code/wh2o/Page1.inc:1019
        • 19. /code/wh2o/SecurityGadget.inc:150
      • select * from "articles" where "short_name" = '-SecurityGadget-explain' limit 1
        7.15ms/app/Legacy/Repositories/NewsInfo.php:64wh2o
        Metadata
        Bindings
        • 0. -SecurityGadget-explain
        Backtrace
        • 15. /app/Legacy/Repositories/NewsInfo.php:64
        • 16. /code/wh2o/ArticleGadget.inc:128
        • 17. /code/wh2o/Page1.inc:930
        • 18. /code/wh2o/Page1.inc:1019
        • 19. /code/wh2o/SecurityGadget.inc:150
      • select * from "articles" where ("id" = '-SecurityGadget-explain' or "short_name" = '-SecurityGadget-explain') and "articles"."deleted_at" is null and "articles"."is_final" = 'true' limit 1
        420μs/app/Legacy/Repositories/NewsInfo.php:61wh2o
        Metadata
        Bindings
        • 0. -SecurityGadget-explain
        • 1. -SecurityGadget-explain
        • 2. true
        Backtrace
        • 15. /app/Legacy/Repositories/NewsInfo.php:61
        • 16. /code/wh2o/ArticleGadget.inc:128
        • 17. /code/wh2o/Page1.inc:930
        • 18. /code/wh2o/Page1.inc:1019
        • 19. /code/wh2o/SecurityGadget.inc:150
      • select * from "articles" where "short_name" = '-SecurityGadget-explain' limit 1
        340μs/app/Legacy/Repositories/NewsInfo.php:64wh2o
        Metadata
        Bindings
        • 0. -SecurityGadget-explain
        Backtrace
        • 15. /app/Legacy/Repositories/NewsInfo.php:64
        • 16. /code/wh2o/ArticleGadget.inc:128
        • 17. /code/wh2o/Page1.inc:930
        • 18. /code/wh2o/Page1.inc:1019
        • 19. /code/wh2o/SecurityGadget.inc:150
      • select * from "articles" where ("id" = '-SecurityGadget-explain' or "short_name" = '-SecurityGadget-explain') and "articles"."deleted_at" is null and "articles"."is_final" = 'true' limit 1
        410μs/app/Legacy/Repositories/NewsInfo.php:61wh2o
        Metadata
        Bindings
        • 0. -SecurityGadget-explain
        • 1. -SecurityGadget-explain
        • 2. true
        Backtrace
        • 15. /app/Legacy/Repositories/NewsInfo.php:61
        • 16. /code/wh2o/ArticleGadget.inc:128
        • 17. /code/wh2o/Page1.inc:930
        • 18. /code/wh2o/Page1.inc:1019
        • 19. /code/wh2o/SecurityGadget.inc:150
      • select * from "articles" where "short_name" = '-SecurityGadget-explain' limit 1
        1.41ms/app/Legacy/Repositories/NewsInfo.php:64wh2o
        Metadata
        Bindings
        • 0. -SecurityGadget-explain
        Backtrace
        • 15. /app/Legacy/Repositories/NewsInfo.php:64
        • 16. /code/wh2o/ArticleGadget.inc:128
        • 17. /code/wh2o/Page1.inc:930
        • 18. /code/wh2o/Page1.inc:1019
        • 19. /code/wh2o/SecurityGadget.inc:150
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        5.41ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2078 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        5.13ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2078
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.07ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.05ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.05ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2090 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.33ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2090
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.99ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.01ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.02ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2091 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.31ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2091
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.99ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.01ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.04ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2123 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        770μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2123
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.03ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.06ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2165 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        750μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2165
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.04ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.98ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.14ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2171 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.25ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2171
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.45ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.84ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.09ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2198 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        5.35ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2198
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        4.94ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.08ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.02ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2199 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        7.09ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2199
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.98ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.03ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2200 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.63ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2200
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.97ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.97ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.09ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2205 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.77ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2205
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.07ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2206 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.5ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2206
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.96ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        19.53ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        4.4ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2209 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        770μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2209
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.04ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.39ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.08ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2212 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        2.41ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2212
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        10.32ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.06ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.08ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2219 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        800μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2219
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        7.71ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.06ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.92ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2220 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        750μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2220
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.97ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.91ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.08ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2221 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        730μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2221
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.01ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2224 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.65ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2224
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.06ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2240 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        2.56ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2240
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.95ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.15ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.99ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2249 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.81ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2249
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.04ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.03ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.06ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2267 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        860μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2267
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.99ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.02ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.07ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 2276 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        1.3ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 2276
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.05ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.04ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.21ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 3064 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        2.29ms/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 3064
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.04ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        3.03ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.99ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 12. /app/Legacy/Repositories/RiverInfo.php:451
        • 13. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 14. /code/wh2o/ClubGadget.inc:486
        • 15. /code/wh2o/ClubGadget.inc:433
      • select *, to_jsonb( ARRAY[ coalesce(ST_XMin(Box2D(geom)), least(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMin(Box2D(geom)), least(ST_Y(ploc), ST_Y(tloc))), coalesce(ST_XMax(Box2D(geom)), greatest(ST_X(ploc), ST_X(tloc))), coalesce(ST_YMax(Box2D(geom)), greatest(ST_Y(ploc), ST_Y(tloc)))]) as bbox from "reaches" where "reaches"."id" = 3409 and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
        720μs/app/Legacy/Repositories/RiverInfo.php:451wh2o
        Metadata
        Bindings
        • 0. 3409
        • 1. true
        Backtrace
        • 19. /app/Legacy/Repositories/RiverInfo.php:451
        • 20. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 21. /code/wh2o/ClubGadget.inc:486
        • 22. /code/wh2o/ClubGadget.inc:433
        • 23. /app/Legacy/Models/Components/CGadget.php:530
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.96ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 23. /app/Legacy/Repositories/RiverInfo.php:451
        • 24. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 25. /code/wh2o/ClubGadget.inc:486
        • 26. /code/wh2o/ClubGadget.inc:433
      • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
        2.96ms/app/Reach.php:163wh2o
        Metadata
        Bindings
        • 0. public
        • 1. reaches
        Backtrace
        • 10. /app/Reach.php:163
        • 25. /app/Legacy/Repositories/RiverInfo.php:451
        • 26. /app/Legacy/Repositories/LookupHelpers/LookupRiverInfo.php:74
        • 27. /code/wh2o/ClubGadget.inc:486
        • 28. /code/wh2o/ClubGadget.inc:433
      App\Reach
      23
          _token
          eq5Pl7Xaqsl2RUDUUxvZnUgTeZKAIBP746dVzmpL
          page
          array:1 [ "count" => -1 ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /content/Club/view/clubid/70003
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "host" => array:1 [ 0 => "beta.americanwhitewater.org" ] ]
          request_server
          0 of 0
          array:42 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_HOST" => "beta.americanwhitewater.org" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "beta.americanwhitewater.org" "SERVER_PORT" => "443" "SERVER_ADDR" => "172.31.18.125" "REMOTE_PORT" => "8363" "REMOTE_ADDR" => "3.14.136.222" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => true "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/opt/americanwhitewater.org/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/content/Club/view/clubid/70003" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "PHP_VALUE" => "post_max_size=20M" "SCRIPT_FILENAME" => "/opt/americanwhitewater.org/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1743482059.9747 "REQUEST_TIME" => 1743482059 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 01 Apr 2025 04:34:20 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InVRQXpPNTFoRW44bE45b05PRTQvamc9PSIsInZhbHVlIjoiaG0zMDByeU5MM0VFWkZvNTg0cTRCY1k4TTFYeGdLUG4xTE1lS0RUZFVZV05TemtrMWpMNVlrUi9Qb1Z5bFBOcmdkVGRHM0FWdWp3U2pMTng3NFBCYWFEQXA4ZENScVl2ZWNwY0tqVnJBbVcxKzI4YkFYSHVvTFVXdG52TlBWYlEiLCJtYWMiOiI1NGY4YzgwYjU5ZWJkMTdjZWIxNzIzNzlhOWVlMjQyMDczMjE4MDI5NjQyZGI5N2Y2M2JkNmJiZGE5OGNiYTllIn0%3D; expires=Tue, 01-Apr-2025 06:34:21 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InVRQXpPNTFoRW44bE45b05PRTQvamc9PSIsInZhbHVlIjoiaG0zMDByeU5MM0VFWkZvNTg0cTRCY1k4TTFYeGdLUG4xTE1lS0RUZFVZV05TemtrMWpMNVlrUi9Qb1Z5bFBOcmdkVGRHM" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InVRQXpPNTFoRW44bE45b05PRTQvamc9PSIsInZhbHVlIjoiaG0zMDByeU5MM0VFWkZvNTg0cTRCY1k4TTFYeGdLUG4xTE1lS0RUZFVZV05TemtrMWpMNVlrUi9Qb1Z5bFBOcmdkVGRHM0FWdWp3U2pMTng3NFBCYWFEQXA4ZENScVl2ZWNwY0tqVnJBbVcxKzI4YkFYSHVvTFVXdG52TlBWYlEiLCJtYWMiOiI1NGY4YzgwYjU5ZWJkMTdjZWIxNzIzNzlhOWVlMjQyMDczMjE4MDI5NjQyZGI5N2Y2M2JkNmJiZGE5OGNiYTllIn0%3D; expires=Tue, 01-Apr-2025 06:34:21 GMT; path=/XSRF-TOKEN=eyJpdiI6InVRQXpPNTFoRW44bE45b05PRTQvamc9PSIsInZhbHVlIjoiaG0zMDByeU5MM0VFWkZvNTg0cTRCY1k4TTFYeGdLUG4xTE1lS0RUZFVZV05TemtrMWpMNVlrUi9Qb1Z5bFBOcmdkVGRHM" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "eq5Pl7Xaqsl2RUDUUxvZnUgTeZKAIBP746dVzmpL" "page" => array:1 [ "count" => -1 ] "PHPDEBUGBAR_STACK_DATA" => [] ]