American Whitewater

Messages Timeline Exceptions Views0 Route Queries5 Models1 Mails Gate Session Request

7.4.31.87s9MBGET graphql

Booting (190ms)
Application (1.68s)
1 x Application (89.8%)
1.68s
1 x Booting (10.2%)
190ms

0 templates were rendered

uri: GET graphql
as: graphql
middleware: Nuwave\Lighthouse\Support\Http\Middleware\AttemptAuthentication:web, Nuwave\Lighthouse\Support\Http\Middleware\AttemptAuthentication:api, Nuwave\Lighthouse\Support\Http\Middleware\AcceptJson
controller: Nuwave\Lighthouse\Support\Http\Controllers\GraphQLController@query
file: vendor/nuwave/lighthouse/src/Support/Http/Controllers/GraphQLController.php:51-69

5 statements were executed, 3 of which were duplicated, 2 unique254ms

select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'

105ms/app/Reach.php:163wh2o

Metadata
Bindings	0. public 1. reaches
Backtrace	10. /app/Reach.php:163 12. /vendor/nuwave/lighthouse/src/Schema/Directives/FirstDirective.php:45 13. /vendor/nuwave/lighthouse/src/Schema/Factories/FieldFactory.php:166 14. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:632 15. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:555

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 "id" = '2683' and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1

34.92ms/vendor/nuwave/lighthouse/src/Schema/Directives/FirstDirective.php:48wh2o

Metadata
Bindings	0. 2683 1. true
Backtrace	15. /vendor/nuwave/lighthouse/src/Schema/Directives/FirstDirective.php:48 16. /vendor/nuwave/lighthouse/src/Schema/Factories/FieldFactory.php:166 17. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:632 18. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:555 19. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:1247

select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'

50.15ms/app/Reach.php:163wh2o

Metadata
Bindings	0. public 1. reaches
Backtrace	10. /app/Reach.php:163 19. /vendor/nuwave/lighthouse/src/Schema/Directives/FirstDirective.php:48 20. /vendor/nuwave/lighthouse/src/Schema/Factories/FieldFactory.php:166 21. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:632 22. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:555

select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'

43.33ms/app/Reach.php:163wh2o

Metadata
Bindings	0. public 1. reaches
Backtrace	10. /app/Reach.php:163 21. /vendor/nuwave/lighthouse/src/Schema/Directives/FirstDirective.php:48 22. /vendor/nuwave/lighthouse/src/Schema/Factories/FieldFactory.php:166 23. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:632 24. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:555

select "events".*, "event_reach"."reach_id" as "pivot_reach_id", "event_reach"."event_id" as "pivot_event_id" from "events" inner join "event_reach" on "events"."id" = "event_reach"."event_id" where "event_reach"."reach_id" = 2683

20.59ms/app/Models/Base/MarkdownHtmlConvertible.php:28wh2o

Metadata
Bindings	0. 2683
Backtrace	18. /app/Models/Base/MarkdownHtmlConvertible.php:28 20. /vendor/webonyx/graphql-php/src/Executor/Executor.php:176 21. /vendor/nuwave/lighthouse/src/Schema/Factories/FieldFactory.php:166 22. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:632 23. /vendor/webonyx/graphql-php/src/Executor/ReferenceExecutor.php:555

App\Reach: 1

_token: xxyh86LUaIbRtRrGGL7GZ2ZXW8iYswakbctSAmNZ
page: array:1 [ "count" => -1 ]
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/4098/main"...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/graphql

status_code

status_text

format

html

content_type

application/json

request_query

[]

request_request

  0 of 0   
array:1 [▼
  "query" => """
    \n
            query {\n
                reach(id: "2683") {\n
                  events \n
                  {\n
                    id,\n
                    category\n
                    title,\n
                    dates { id,event_date,min,max,id,metric_id,start_time,end_time }  \n
                 \n
                  }\n
                     \n
             \n
                }\n
            }
    """
]

request_headers

  0 of 0   
array:20 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qazBqYnlkWlh3QVJTSUZHYUcwd3R6aS96b1RtNmJFM3pIaU9lSnp3bzBuL3lvcVhyOU9sb1FjcEJLRmoiLCJtYWMiOiI1MmEwNTcyOTU5MGEzZDQ0YjM3MjI5ZjVlNWRmMzI2NTMwZWIxNTllN2I2NTg4MmEzOThlZjBhOTAzOTQzNDIxIn0%3D; americanwhitewater_session=IylFAb0ks5V874tmsOTzD1o0Hkft9bpIR5256Ejm ◀XSRF-TOKEN=eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qa ▶"
  ]
  "priority" => array:1 [▶
    0 => "u=1, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "referer" => array:1 [▶
    0 => "https://beta.americanwhitewater.org/content/River/view/river-detail/2683/main"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "empty"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "cors"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "same-origin"
  ]
  "origin" => array:1 [▶
    0 => "https://beta.americanwhitewater.org"
  ]
  "content-type" => array:1 [▶
    0 => "application/json; charset=UTF-8"
  ]
  "accept" => array:1 [▶
    0 => "application/json"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "x-requested-with" => array:1 [▶
    0 => "XMLHttpRequest"
  ]
  "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""
  ]
  "x-xsrf-token" => array:1 [▶
    0 => "eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qazBqYnlkWlh3QVJTSUZHYUcwd3R6aS96b1RtNmJFM3pIaU9lSnp3bzBuL3lvcVhyOU9sb1FjcEJLRmoiLCJtYWMiOiI1MmEwNTcyOTU5MGEzZDQ0YjM3MjI5ZjVlNWRmMzI2NTMwZWIxNTllN2I2NTg4MmEzOThlZjBhOTAzOTQzNDIxIn0= ◀eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qazBqYnlkWlh3 ▶"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "cache-control" => array:1 [▶
    0 => "no-store, no-cache, must-revalidate, post-check=0, pre-check=0"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "content-length" => array:1 [▶
    0 => "347"
  ]
  "host" => array:1 [▶
    0 => "beta.americanwhitewater.org"
  ]
]

request_server

  0 of 0   
array:47 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qazBqYnlkWlh3QVJTSUZHYUcwd3R6aS96b1RtNmJFM3pIaU9lSnp3bzBuL3lvcVhyOU9sb1FjcEJLRmoiLCJtYWMiOiI1MmEwNTcyOTU5MGEzZDQ0YjM3MjI5ZjVlNWRmMzI2NTMwZWIxNTllN2I2NTg4MmEzOThlZjBhOTAzOTQzNDIxIn0%3D; americanwhitewater_session=IylFAb0ks5V874tmsOTzD1o0Hkft9bpIR5256Ejm ◀XSRF-TOKEN=eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qa ▶"
  "HTTP_PRIORITY" => "u=1, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_REFERER" => "https://beta.americanwhitewater.org/content/River/view/river-detail/2683/main"
  "HTTP_SEC_FETCH_DEST" => "empty"
  "HTTP_SEC_FETCH_MODE" => "cors"
  "HTTP_SEC_FETCH_SITE" => "same-origin"
  "HTTP_ORIGIN" => "https://beta.americanwhitewater.org"
  "HTTP_CONTENT_TYPE" => "application/json; charset=UTF-8"
  "HTTP_ACCEPT" => "application/json, text/plain, */*"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_X_REQUESTED_WITH" => "XMLHttpRequest"
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_X_XSRF_TOKEN" => "******"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_CACHE_CONTROL" => "no-store, no-cache, must-revalidate, post-check=0, pre-check=0"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONTENT_LENGTH" => "347"
  "HTTP_HOST" => "beta.americanwhitewater.org"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta.americanwhitewater.org"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.18.125"
  "REMOTE_PORT" => "42930"
  "REMOTE_ADDR" => "18.216.220.244"
  "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" => "/graphql"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => "347"
  "CONTENT_TYPE" => "application/json; charset=UTF-8"
  "REQUEST_METHOD" => "POST"
  "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" => 1743787208.9067
  "REQUEST_TIME" => 1743787208
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qazBqYnlkWlh3QVJTSUZHYUcwd3R6aS96b1RtNmJFM3pIaU9lSnp3bzBuL3lvcVhyOU9sb1FjcEJLRmoiLCJtYWMiOiI1MmEwNTcyOTU5MGEzZDQ0YjM3MjI5ZjVlNWRmMzI2NTMwZWIxNTllN2I2NTg4MmEzOThlZjBhOTAzOTQzNDIxIn0= ◀eyJpdiI6ImtHUGFBN2NKSDYrVVp5UmpDSXFiSkE9PSIsInZhbHVlIjoidE44TnBKM1FESE1jeGpMaURFREE0cjR5elk1WGdTd1JSdVFWNW5DUm9NZjBEYU5EUHI2WW42d1pBLzlBTVQvTXlEbm1qazBqYnlkWlh3 ▶"
  "americanwhitewater_session" => "IylFAb0ks5V874tmsOTzD1o0Hkft9bpIR5256Ejm"
]

response_headers

  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 04 Apr 2025 17:20:10 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "application/json"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "xxyh86LUaIbRtRrGGL7GZ2ZXW8iYswakbctSAmNZ"
  "page" => array:1 [▶
    "count" => -1
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
  "_previous" => array:1 [▶
    "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/4098/main"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

1 x Application (89.8%)	1.68s
1 x Booting (10.2%)	190ms