Events

Associated Rivers

Events

April 2019

Associated Rivers

The contacts below include staff and volunteers working on this project. Make sure you are logged in if you wish to join the group.

Title	Name	City

Calendar Control Date:
Calendar by Date by Title

Events

Hoosic River release

Hoosic,NY runs 04/27/19 - 04/27/19
[+] favorites

(iCal)

Hoosic NY

3. Schaghticoke Dam to Powerhouse III+(V)

Join AW and support river stewardship nationwide!

Messages Timeline Exceptions Views24 Route Queries48 Models6 Mails Gate Session Request

7.4.3986ms81MBGET content/{url}

Booting (34.45ms)
Application (952ms)
1 x Application (96.51%)
952ms
1 x Booting (3.49%)
34.45ms

24 templates were rendered

legacy.views.container-adminbox (resources/views/legacy/views/container-adminbox.blade.php)7blade
Params
0
components
1
title
2
attachNode
3
iconClass
4
id
5
class
6
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-adminbox (resources/views/legacy/views/container-adminbox.blade.php)7blade
Params
0
components
1
title
2
attachNode
3
iconClass
4
id
5
class
6
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
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
page.river-summary.components.level-legend (resources/views/page/river-summary/components/level-legend.blade.php)5blade
Params
0
css
1
RiverColors
2
id
3
options
4
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
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
components.river.summary-list (resources/views/components/river/summary-list.blade.php)3blade
Params
0
rivers
1
metrics
2
formRenderService
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

Params
0	`components`
1	`title`
2	`attachNode`
3	`iconClass`
4	`id`
5	`class`
6	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`components`
1	`title`
2	`attachNode`
3	`iconClass`
4	`id`
5	`class`
6	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`css`
1	`RiverColors`
2	`id`
3	`options`
4	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`components`
1	`controls`
2	`id`
3	`class`
4	`title`
5	`formRenderService`

Params
0	`contents`
1	`formRenderService`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`
7	`stack`
8	`component`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`
7	`stack`
8	`component`

Params
0	`rivers`
1	`metrics`
2	`formRenderService`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`

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


obLevel
__env
app
errors
contents
formRenderService
layout
menu
searchurl
loginurl
logouturl
__currentLoopData
child
loop
otherchild
shouldNotifyUser
user

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


obLevel
__env
app
errors
contents
formRenderService
layout
menu
searchurl
loginurl
logouturl
__currentLoopData
child
loop
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

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`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`contents`
5	`formRenderService`
6	`layout`
7	`menu`

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::7S3RnBZOjVwYvccb
file: app/Http/Controllers/Wh2oController.php:34-68

48 statements were executed, 14 of which were duplicated, 34 unique121ms

select * from security where domain in ('DirectoryGadget') and area is null;

413μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select count(*)   from contact_header ch right join contacts c on c.id = ch.contact_id  where (1=1)  and listing = 'projects'and area = '68'

855μ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:441 8. /app/Legacy/Repositories/UserInfo.php:646 9. /code/wh2o/DirectoryGadget.inc:382

select * from security where domain in ('pp-Legacy-Security-DirectorySecurity') and area is null;

200μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select *   from contact_header ch right join contacts c on c.id = ch.contact_id  where (1=1)  and listing = 'projects'and area = '68'  order by area,sort_id desc, manager desc, title offset 0 limit 500

3.52ms/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/UserInfo.php:629 9. /code/wh2o/DirectoryGadget.inc:383

select * from listinggroups where listing='projects' and area = '68'

469μ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/UserInfo.php:129 9. /code/wh2o/DirectoryGadget.inc:393

select * from listinggroups where listing='projects'

5.44ms/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/UserInfo.php:133 9. /code/wh2o/DirectoryGadget.inc:393

select * from listings where deleted = 0

1.82ms/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/UserInfo.php:664 9. /app/Legacy/Repositories/UserInfo.php:1258

select * from listing2permkey

246μ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/UserInfo.php:665 9. /app/Legacy/Repositories/UserInfo.php:1258

select * from projects where deleted_at is null and ( id='68' or short_name = '68' )

2.87ms/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. /app/Legacy/Repositories/LookupHelpers/LookupProjectInfo.php:33

select * from security where domain in ('SecurityGadget') and area is null;

178μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from listings where deleted = 0

2.73ms/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/UserInfo.php:664 9. /app/Legacy/Forms/ContactAddForm.php:20

select * from listing2permkey

192μ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/UserInfo.php:665 9. /app/Legacy/Forms/ContactAddForm.php:20

select * from security where domain in ('ArticleGadget') and area is null;

1.48ms/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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from "articles" where ("id" = 'contactDirectory_projects' or "short_name" = 'contactDirectory_projects') and "articles"."deleted_at" is null and "articles"."is_final" = 'true' limit 1

610μs/app/Legacy/Repositories/NewsInfo.php:61wh2o

Metadata
Bindings	0. contactDirectory_projects 1. contactDirectory_projects 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/DirectoryGadget.inc:470

select * from security_defaults where domain in ('ArticleGadget');

150μ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/SecurityInfo.php:134 9. /app/Legacy/Security/BaseSecurity.php:200

select * from security where domain in ('LinkerGadget') and area is null;

288μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from security_defaults where domain in ('LinkerGadget');

153μ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/SecurityInfo.php:134 9. /app/Legacy/Security/BaseSecurity.php:200

select * from security where domain in ('ContactGadget') and area is null;

3.2ms/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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from "contacts" where "contacts"."id" = 0 limit 1

1.77ms/app/Legacy/Repositories/UserInfo.php:865wh2o

Metadata
Bindings	0. 0
Backtrace	19. /app/Legacy/Repositories/UserInfo.php:865 20. /code/wh2o/ContactGadget.inc:209 21. /code/wh2o/ContactGadget.inc:151 22. /code/wh2o/Page1.inc:930 23. /code/wh2o/Page1.inc:1019

select * from "articles" where "articles"."id" = '10151' and "articles"."deleted_at" is null and "articles"."is_final" = 'true' limit 1

3.24ms/app/MetaControllers/NewsMetaController.php:89wh2o

Metadata
Bindings	0. 10151 1. true
Backtrace	19. /app/MetaControllers/NewsMetaController.php:89 20. /code/wh2o/ArticleGadget.inc:283 21. /code/wh2o/ArticleGadget.inc:198 22. /code/wh2o/Page1.inc:930 23. /code/wh2o/Page1.inc:1019

select * from "articles" where "articles"."id" = '10151' and "articles"."deleted_at" is null and "articles"."is_final" = 'true' limit 1

550μs/app/MetaControllers/NewsMetaController.php:89wh2o

Metadata
Bindings	0. 10151 1. true
Backtrace	19. /app/MetaControllers/NewsMetaController.php:89 20. /code/wh2o/ArticleGadget.inc:283 21. /code/wh2o/ArticleGadget.inc:199 22. /code/wh2o/Page1.inc:930 23. /code/wh2o/Page1.inc:1019

select * from linker_gadgets

468μ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

128μ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 = 'listinggroup' and (l.sourceid = 'projects-68' or g.is_list =0 ))
or (l.targetcomp = 'listinggroup' and l.targetid='projects-68' and l.mutual = 1 )

651μ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 security where domain in ('CalendarGadget') and area is null;

160μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

SELECT *
FROM contactinstance2contact
NATURAL LEFT JOIN contact_header
NATURAL LEFT JOIN contacts
WHERE instance = 'Calendar'

44.21ms/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/UserInfo.php:925 9. /code/wh2o/ContactGadget.inc:199

select distinct name,listing from listings where deleted = 0

272μ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/UserInfo.php:773 9. /app/Legacy/Forms/ContactInstanceForm.php:20

select distinct area as area from contact_header

5.16ms/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/UserInfo.php:788 9. /app/Legacy/Forms/ContactInstanceForm.php:29

select distinct title as title from contact_header

2.86ms/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/UserInfo.php:765 9. /app/Legacy/Forms/ContactInstanceForm.php:38

select * from "contacts" where "contacts"."id" = 5062 limit 1

350μs/code/wh2o/ContactGadget.inc:186wh2o

Metadata
Bindings	0. 5062
Backtrace	19. /code/wh2o/ContactGadget.inc:186 20. /code/wh2o/ContactGadget.inc:174 21. /code/wh2o/Page1.inc:930 22. /code/wh2o/Page1.inc:1019 23. /code/wh2o/CalendarGadget.inc:609

SELECT events.id as event_id, events.id as id,
"events".title,
"events".city,
"events".description,
"events".category,
"events".uid,
"events".state,
"events".url,
"events".orgname,
"events".orgaddress,
"events".orgphone,
"events".orgfax,
"events".orgemail,
"events".site,
"events".reach_id,
"events".expectpart,
"events".expectspec,
"events".issue,
"events".media,
"events".nowreventinfo,
"events".contact_id,
"events".updated,
"events".html_description,
"events".retired,
"events".tz
,
max(event_dates.event_date) as maxdate,
min(event_dates.event_date) as mindate,
min(case when event_date < now() then null else event_date end ) as nextdate
FROM event_dates left join events on events.id=event_dates.event_id
WHERE (  event_id in ('2720','1167')  and retired=0 and deleted=0 ) group by
events.id,
"events".title,
"events".city,
"events".description,
"events".category,
"events".uid,
"events".state,
"events".url,
"events".orgname,
"events".orgaddress,
"events".orgphone,
"events".orgfax,
"events".orgemail,
"events".site,
"events".reach_id,
"events".expectpart,
"events".expectspec,
"events".issue,
"events".media,
"events".nowreventinfo,
"events".contact_id,
"events".updated,
"events".html_description,
"events".retired,
"events".tz

1.59ms/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/EventInfo.php:121 9. /code/wh2o/CalendarGadget.inc:670

SELECT * FROM event_dates
left join events on events.id=event_dates.event_id
WHERE (  event_id in ('2720')  and event_date between '2019-03-01' and '2019-07-01' and retired=0 and deleted=0 )
order by event_date desc limit 1000

1.24ms/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/EventInfo.php:307 9. /code/wh2o/CalendarGadget.inc:733

select name,id from geo_regions

176μ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/GeoInfo.php:93 9. /code/wh2o/CalendarGadget.inc:784

select * from security_defaults where domain in ('CalendarGadget');

133μ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/SecurityInfo.php:134 9. /app/Legacy/Security/BaseSecurity.php:200

select * from security where domain in ('CalendarSearchGadget') and area is null;

241μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from security where domain in ('NewsFeedGadget') and area is null;

112μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from security where domain in ('PersonalGaugesGadget') and area is null;

113μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select * from security where domain in ('UIHelpers-RiverColorsController') and area is null;

157μ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/SecurityInfo.php:188 9. /app/Legacy/Security/BaseSecurity.php:143

select r.id as rid,* from reach_map r where r.id in ('1320') ;

16.65ms/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/RiverInfo.php:277 9. /app/MetaControllers/RiverCollectionMetaController.php:20

select max(ed.event_date),l.targetid as id
from linker_lists as l
left join event_dates as ed on ed.event_id::char(10) = l.sourceid
where
l.targetid in ('1320')
and
l.targetcomp = 'river'
and
l.sourcecomp = 'event'
and
ed.event_date > now()
group by l.targetid			union select max(ed.event_date),l.sourceid as id
from linker_lists as l
left join event_dates as ed on ed.event_id::char(10) = l.targetid
where
l.sourceid in ('1320')
and
l.targetcomp = 'event'
and
l.sourcecomp = 'river'
and
ed.event_date > now()
group by l.sourceid

1.89ms/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/RiverInfo.php:822 9. /app/Legacy/Repositories/RiverInfo.php:1080

select max(post_date),reach_id as id
from posts  c
where
c.post_type=502
and
c.reach_id in (1320)
and
c.post_date > now()- ( interval '1 year')
group by reach_id

11.16ms/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/RiverInfo.php:786 9. /app/Legacy/Repositories/RiverInfo.php:1081

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

450μ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

380μ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

390μ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

310μ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

390μ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

320μ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 "geo_states" where "geo_states"."gmi" = 'USA-NYO' limit 1

390μsview::431006a3df29e007636b99b8f2357411f319a4c2:17wh2o

Metadata
Bindings	0. USA-NYO
Backtrace	19. view::431006a3df29e007636b99b8f2357411f319a4c2:17 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 22. /vendor/laravel/framework/src/Illuminate/View/View.php:139 23. /vendor/laravel/framework/src/Illuminate/View/View.php:122 24. /vendor/laravel/framework/src/Illuminate/View/View.php:91

App\State: 1
App\Contact: 2
App\Article: 3

_token: xW9qZsTZkTkUmHIqj57XAvf1fAfehLKlORVLW6XN
pref: []
page: array:1 [ "count" => -1 ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/content/Directory/view/listing/projects-68

status_code

status_text

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" => "18927"
  "REMOTE_ADDR" => "3.22.101.207"
  "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/Directory/view/listing/projects-68"
  "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" => 1745381066.721
  "REQUEST_TIME" => 1745381066
]

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 => "Wed, 23 Apr 2025 04:04:27 GMT"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitqR0VDc1pseDhqdmZ5Q2tuZnlzZHc9PSIsInZhbHVlIjoiZ3VvQ3phUGVHSXlDRUo1SmV1eGxKeWZjdXE4d3RaK2d1Z01zcFN1b1BBTURMK01iMmdVa3lrQVZGMU1VdWlyS0tIWUJvcXFlZ3BqWEZzMXpJTzJNZlV4UHBQenl6NG1FcmVmRkp1ZGg3RnhsOHBLWHdFZlhNWndleHVKN1pnUVgiLCJtYWMiOiI3ZGM3MjAzNTY1YWU4ODIxODdiZjY1NmUzYmY0NzE1ZjE0NTNlMDI2ZWM0ZDQ5ZjE5ZWM2OTQzZDUwOTBmZGQxIn0%3D; expires=Wed, 23-Apr-2025 06:04:27 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IitqR0VDc1pseDhqdmZ5Q2tuZnlzZHc9PSIsInZhbHVlIjoiZ3VvQ3phUGVHSXlDRUo1SmV1eGxKeWZjdXE4d3RaK2d1Z01zcFN1b1BBTURMK01iMmdVa3lrQVZGMU1VdWlyS0tIWUJvc ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitqR0VDc1pseDhqdmZ5Q2tuZnlzZHc9PSIsInZhbHVlIjoiZ3VvQ3phUGVHSXlDRUo1SmV1eGxKeWZjdXE4d3RaK2d1Z01zcFN1b1BBTURMK01iMmdVa3lrQVZGMU1VdWlyS0tIWUJvcXFlZ3BqWEZzMXpJTzJNZlV4UHBQenl6NG1FcmVmRkp1ZGg3RnhsOHBLWHdFZlhNWndleHVKN1pnUVgiLCJtYWMiOiI3ZGM3MjAzNTY1YWU4ODIxODdiZjY1NmUzYmY0NzE1ZjE0NTNlMDI2ZWM0ZDQ5ZjE5ZWM2OTQzZDUwOTBmZGQxIn0%3D; expires=Wed, 23-Apr-2025 06:04:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IitqR0VDc1pseDhqdmZ5Q2tuZnlzZHc9PSIsInZhbHVlIjoiZ3VvQ3phUGVHSXlDRUo1SmV1eGxKeWZjdXE4d3RaK2d1Z01zcFN1b1BBTURMK01iMmdVa3lrQVZGMU1VdWlyS0tIWUJvc ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "xW9qZsTZkTkUmHIqj57XAvf1fAfehLKlORVLW6XN"
  "pref" => []
  "page" => array:1 [▶
    "count" => -1
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (96.51%)	952ms
1 x Booting (3.49%)	34.45ms

April 2019

27 <div class="event event-0"> <span class="title"> Hoosic River release </span><br> <span class="detail">1:00 pm -4:00 pm america/new_york<br> Annual Release </span><br> </div> <div class="event event-0"> <span class="title"> Hoosic River release </span><br> <span class="detail">1:00 pm -4:00 pm america/new_york<br> Annual Release </span><br> </div>