American Whitewater

Messages Timeline Exceptions Views0 Route Queries5 Models1 Mails Gate Session Request

7.4.32.02s9MBGET graphql

Booting (229ms)
Application (1.79s)
1 x Application (88.69%)
1.79s
1 x Booting (11.31%)
229ms

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 unique203ms

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

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

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

Metadata
Bindings	0. 2854 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'

19.88ms/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'

33.32ms/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" = 2854

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

Metadata
Bindings	0. 2854
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: y35rdJVffJWWFhSfv2CfaDiPI6UAiewKyywHYZtt
page: array:1 [ "count" => -1 ]
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/2840/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: "2854") {\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=eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsNGNZWEtycHc0K1l5YjB0Uk1EWWxTY1RTbU9uMzVnUkMxRk9wL3k2aW9EYVVQVFVtam5KK3ozMzdtSFIiLCJtYWMiOiIxNWZiMDg5OGQ5NTE2MTg1M2Q5MDEwOTFmNDJhOWUzMDNkNmZkMWVhYzVjOGVjOTMyZGY1NzIyMGMwNGRhY2YzIn0%3D; americanwhitewater_session=D74hpUkmNfwsoHL54yPtkQzFSZTSO3Os1DRIm7nl ◀XSRF-TOKEN=eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsN ▶"
  ]
  "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/2854/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 => "eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsNGNZWEtycHc0K1l5YjB0Uk1EWWxTY1RTbU9uMzVnUkMxRk9wL3k2aW9EYVVQVFVtam5KK3ozMzdtSFIiLCJtYWMiOiIxNWZiMDg5OGQ5NTE2MTg1M2Q5MDEwOTFmNDJhOWUzMDNkNmZkMWVhYzVjOGVjOTMyZGY1NzIyMGMwNGRhY2YzIn0= ◀eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsNGNZWEtycHc0 ▶"
  ]
  "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=eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsNGNZWEtycHc0K1l5YjB0Uk1EWWxTY1RTbU9uMzVnUkMxRk9wL3k2aW9EYVVQVFVtam5KK3ozMzdtSFIiLCJtYWMiOiIxNWZiMDg5OGQ5NTE2MTg1M2Q5MDEwOTFmNDJhOWUzMDNkNmZkMWVhYzVjOGVjOTMyZGY1NzIyMGMwNGRhY2YzIn0%3D; americanwhitewater_session=D74hpUkmNfwsoHL54yPtkQzFSZTSO3Os1DRIm7nl ◀XSRF-TOKEN=eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsN ▶"
  "HTTP_PRIORITY" => "u=1, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_REFERER" => "https://beta.americanwhitewater.org/content/River/view/river-detail/2854/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" => "30405"
  "REMOTE_ADDR" => "3.133.91.217"
  "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" => 1743788647.569
  "REQUEST_TIME" => 1743788647
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsNGNZWEtycHc0K1l5YjB0Uk1EWWxTY1RTbU9uMzVnUkMxRk9wL3k2aW9EYVVQVFVtam5KK3ozMzdtSFIiLCJtYWMiOiIxNWZiMDg5OGQ5NTE2MTg1M2Q5MDEwOTFmNDJhOWUzMDNkNmZkMWVhYzVjOGVjOTMyZGY1NzIyMGMwNGRhY2YzIn0= ◀eyJpdiI6Imd3aU44K0srREVvZGgxQUJ2S0FyN0E9PSIsInZhbHVlIjoiWTEybUI2UzhDQWIvOEdvYSszbmN4bXExS0dmV2xHb3o3MWhuUnZlWE5udGU1WnhLMWZYZHpsVkJyUjVJWkhRdWlvbnVsNGNZWEtycHc0 ▶"
  "americanwhitewater_session" => "D74hpUkmNfwsoHL54yPtkQzFSZTSO3Os1DRIm7nl"
]

response_headers

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

session_attributes

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

1 x Application (88.69%)	1.79s
1 x Booting (11.31%)	229ms