American Whitewater

Messages Timeline Exceptions Views0 Route Queries5 Models1 Mails Gate Session Request

7.4.31.83s9MBGET graphql

Booting (197ms)
Application (1.63s)
1 x Application (89.23%)
1.63s
1 x Booting (10.77%)
197ms

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 unique181ms

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

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

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

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

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

16.03ms/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" = 2280

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

Metadata
Bindings	0. 2280
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: M6n6NplHLjiMAOTDMOiilm0FoRdolael6UozBdP7
page: array:1 [ "count" => -1 ]
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/2742/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: "2280") {\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=eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ05MUEtvTlVvQ1lvNXRvUXVZcytjQ3l4RkVZdkE1R0I3V2ZtOGZwQ0ZsTno1czBBQjhCZDZjcGc0dlIiLCJtYWMiOiIwMjExNzA3NWE4YTU3MjEyNjNmYmJjNmQ3YTNhZDgxOWFmZDA3NTFkMGI4NzdkYzcyMGU1ZmIzYTJhMWZhNDYxIn0%3D; americanwhitewater_session=2gd5ZR4abtxgeOqLmqtou3p2X10d1v7bDmX1eqjg ◀XSRF-TOKEN=eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ ▶"
  ]
  "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/2280/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 => "eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ05MUEtvTlVvQ1lvNXRvUXVZcytjQ3l4RkVZdkE1R0I3V2ZtOGZwQ0ZsTno1czBBQjhCZDZjcGc0dlIiLCJtYWMiOiIwMjExNzA3NWE4YTU3MjEyNjNmYmJjNmQ3YTNhZDgxOWFmZDA3NTFkMGI4NzdkYzcyMGU1ZmIzYTJhMWZhNDYxIn0= ◀eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ05MUEtvTlVv ▶"
  ]
  "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=eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ05MUEtvTlVvQ1lvNXRvUXVZcytjQ3l4RkVZdkE1R0I3V2ZtOGZwQ0ZsTno1czBBQjhCZDZjcGc0dlIiLCJtYWMiOiIwMjExNzA3NWE4YTU3MjEyNjNmYmJjNmQ3YTNhZDgxOWFmZDA3NTFkMGI4NzdkYzcyMGU1ZmIzYTJhMWZhNDYxIn0%3D; americanwhitewater_session=2gd5ZR4abtxgeOqLmqtou3p2X10d1v7bDmX1eqjg ◀XSRF-TOKEN=eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ ▶"
  "HTTP_PRIORITY" => "u=1, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_REFERER" => "https://beta.americanwhitewater.org/content/River/view/river-detail/2280/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" => "4306"
  "REMOTE_ADDR" => "3.14.88.3"
  "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" => 1743791843.1971
  "REQUEST_TIME" => 1743791843
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ05MUEtvTlVvQ1lvNXRvUXVZcytjQ3l4RkVZdkE1R0I3V2ZtOGZwQ0ZsTno1czBBQjhCZDZjcGc0dlIiLCJtYWMiOiIwMjExNzA3NWE4YTU3MjEyNjNmYmJjNmQ3YTNhZDgxOWFmZDA3NTFkMGI4NzdkYzcyMGU1ZmIzYTJhMWZhNDYxIn0= ◀eyJpdiI6Ilpha2VjNGNVeVgyTXFMaHVVS2M3b2c9PSIsInZhbHVlIjoiUGp2OUVIa2xoTDhTc3FKeWpqekhoTzRnSlk5bnlveDNJLzdyK1Z4T2gvVGZKUU1Oc0VwVmpER1VZU2NUTUg1c0ZINUVKZ05MUEtvTlVv ▶"
  "americanwhitewater_session" => "2gd5ZR4abtxgeOqLmqtou3p2X10d1v7bDmX1eqjg"
]

response_headers

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

session_attributes

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

1 x Application (89.23%)	1.63s
1 x Booting (10.77%)	197ms