American Whitewater

Messages Timeline Exceptions Views0 Route Queries8 Models6 Mails Gate Session Request

7.4.32.25s9MBGET graphql

Booting (202ms)
Application (2.05s)
1 x Application (91%)
2.05s
1 x Booting (9%)
202ms

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

8 statements were executed, 4 of which were duplicated, 4 unique413ms

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

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

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

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

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

18.18ms/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 column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'

19.26ms/app/Reach.php:163wh2o

Metadata
Bindings	0. public 1. reaches
Backtrace	10. /app/Reach.php:163 18. /vendor/nuwave/lighthouse/src/Execution/DataLoader/RelationFetcher.php:39 19. /vendor/nuwave/lighthouse/src/Execution/DataLoader/RelationBatchLoader.php:62 20. /vendor/nuwave/lighthouse/src/Execution/DataLoader/BatchLoader.php:102 21. /vendor/webonyx/graphql-php/src/Deferred.php:58

select * from "rapids" where "rapids"."reach_id" in (1109) and "rapids"."is_final" = 'true' and "rapids"."deleted_at" is null

90.19ms/vendor/nuwave/lighthouse/src/Execution/DataLoader/RelationFetcher.php:39wh2o

Metadata
Bindings	0. true
Backtrace	19. /vendor/nuwave/lighthouse/src/Execution/DataLoader/RelationFetcher.php:39 20. /vendor/nuwave/lighthouse/src/Execution/DataLoader/RelationBatchLoader.php:62 21. /vendor/nuwave/lighthouse/src/Execution/DataLoader/BatchLoader.php:102 22. /vendor/webonyx/graphql-php/src/Deferred.php:58 23. /vendor/webonyx/graphql-php/src/Deferred.php:45

select * from "posts_photos" where "posts_photos"."id" = 'jqGkoe3wmgadkKFQ2tEAH' and "posts_photos"."id" is not null and "posts_photos"."deleted_at" is null and "posts_photos"."is_final" = 'true' limit 1

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

Metadata
Bindings	0. jqGkoe3wmgadkKFQ2tEAH 1. true
Backtrace	19. /app/Models/Base/MarkdownHtmlConvertible.php:28 21. /vendor/webonyx/graphql-php/src/Executor/Executor.php:176 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 * from "posts_photos" where "posts_photos"."id" = '90msTW6aiKhIAt931vewL' and "posts_photos"."id" is not null and "posts_photos"."deleted_at" is null and "posts_photos"."is_final" = 'true' limit 1

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

Metadata
Bindings	0. 90msTW6aiKhIAt931vewL 1. true
Backtrace	19. /app/Models/Base/MarkdownHtmlConvertible.php:28 21. /vendor/webonyx/graphql-php/src/Executor/Executor.php:176 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

App\POI: 5
App\Reach: 1

_token: giXDoAiYqnmtEIIth5SCTfRrIyvRSJMd8FyC1SbN
page: array:1 [ "count" => -1 ]
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/1109/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: 1109) {\n
                pois {\n
                  approximate\n
                  character\n
                  description_md\n
                  difficulty\n
                  distance\n
                  id\n
                  name\n
                  rloc\n
                  photo {\n
                    poi_name\n
                    subject\n
                    description\n
                    author\n
                    caption\n
                    photo_date\n
                    image {\n
                      uri {\n
                        thumb\n
                        medium\n
                        big\n
                      }\n
                    }\n
                    id\n
                  }\n
                }\n
              }\n
            }\n
          
    """
]

request_headers

  0 of 0   
array:20 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtWHZObGQ4UkV0NGFPa2hJc0tPYkt6T3NjYWpydnAzM1VtT1V2aEdGZWtpZWp4M3VYM3ZsbmFyRVFDcmMiLCJtYWMiOiIzZTVkNTk4N2NjOWVhN2IxYmFlNWQ2NGZjN2IwOTQ0MWJiOTNlYWU2MjBiMDkyN2U1Zjc3ODViMWM3YjU4YTA4In0%3D; americanwhitewater_session=nWFtKoCxXz3RXeeHF63ysVE4E6tnqb0UatLmWz6Q ◀XSRF-TOKEN=eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtW ▶"
  ]
  "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/1109/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 => "eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtWHZObGQ4UkV0NGFPa2hJc0tPYkt6T3NjYWpydnAzM1VtT1V2aEdGZWtpZWp4M3VYM3ZsbmFyRVFDcmMiLCJtYWMiOiIzZTVkNTk4N2NjOWVhN2IxYmFlNWQ2NGZjN2IwOTQ0MWJiOTNlYWU2MjBiMDkyN2U1Zjc3ODViMWM3YjU4YTA4In0= ◀eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtWHZObGQ4UkV0 ▶"
  ]
  "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 => "702"
  ]
  "host" => array:1 [▶
    0 => "beta.americanwhitewater.org"
  ]
]

request_server

  0 of 0   
array:47 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtWHZObGQ4UkV0NGFPa2hJc0tPYkt6T3NjYWpydnAzM1VtT1V2aEdGZWtpZWp4M3VYM3ZsbmFyRVFDcmMiLCJtYWMiOiIzZTVkNTk4N2NjOWVhN2IxYmFlNWQ2NGZjN2IwOTQ0MWJiOTNlYWU2MjBiMDkyN2U1Zjc3ODViMWM3YjU4YTA4In0%3D; americanwhitewater_session=nWFtKoCxXz3RXeeHF63ysVE4E6tnqb0UatLmWz6Q ◀XSRF-TOKEN=eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtW ▶"
  "HTTP_PRIORITY" => "u=1, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_REFERER" => "https://beta.americanwhitewater.org/content/River/view/river-detail/1109/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" => "702"
  "HTTP_HOST" => "beta.americanwhitewater.org"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "beta.americanwhitewater.org"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.18.125"
  "REMOTE_PORT" => "33584"
  "REMOTE_ADDR" => "3.145.177.180"
  "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" => "702"
  "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" => 1743817479.8634
  "REQUEST_TIME" => 1743817479
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtWHZObGQ4UkV0NGFPa2hJc0tPYkt6T3NjYWpydnAzM1VtT1V2aEdGZWtpZWp4M3VYM3ZsbmFyRVFDcmMiLCJtYWMiOiIzZTVkNTk4N2NjOWVhN2IxYmFlNWQ2NGZjN2IwOTQ0MWJiOTNlYWU2MjBiMDkyN2U1Zjc3ODViMWM3YjU4YTA4In0= ◀eyJpdiI6ImdUNVdnSU9XazZaWGk4RjVGVTRxYWc9PSIsInZhbHVlIjoiclVUSFhkWkExbXZvNDhzSXhVaVNWS1RQTUdvcmdEaGwvdEYrcjJEdTFodWhoOXlwQ29KMEdJMXNybDB0WEl5RGpIcDJtWHZObGQ4UkV0 ▶"
  "americanwhitewater_session" => "nWFtKoCxXz3RXeeHF63ysVE4E6tnqb0UatLmWz6Q"
]

response_headers

  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 05 Apr 2025 01:44:42 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "application/json"
  ]
]

session_attributes

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

1 x Application (91%)	2.05s
1 x Booting (9%)	202ms