7.4.3PHP Version2.57sRequest Duration9MBMemory UsageGET graphqlRoute
    • Booting (169ms)
    • Application (2.4s)
    • 1 x Application (93.42%)
      2.40s
      1 x Booting (6.58%)
      169ms
      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
        6 statements were executed, 3 of which were duplicated, 3 unique270ms
        • select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
          59.3ms/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" = '1469' and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
          18.79ms/vendor/nuwave/lighthouse/src/Schema/Directives/FirstDirective.php:48wh2o
          Metadata
          Bindings
          • 0. 1469
          • 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'
          38.84ms/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.89ms/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 * from "river_summary" where "river_summary"."id" = 1469 and "river_summary"."id" is not null limit 1
          74.5ms/app/Models/Base/MarkdownHtmlConvertible.php:28wh2o
          Metadata
          Bindings
          • 0. 1469
          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" = '1606' and "posts_photos"."id" is not null and "posts_photos"."deleted_at" is null and "posts_photos"."is_final" = 'true' limit 1
          60.17ms/app/Models/Base/MarkdownHtmlConvertible.php:28wh2o
          Metadata
          Bindings
          • 0. 1606
          • 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\ReachReadingSummary
        1
        App\Reach
        1
          • error
            0 of 0
            array:4 [ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "view" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "view" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          • error
            0 of 0
            array:4 [ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\Reach)]" ]
          _token
          t6Dc9e2McV5mlFj5ukMEdKX4Fdy1MP78qsNTqdAb
          page
          array:1 [ "count" => -1 ]
          PHPDEBUGBAR_STACK_DATA
          []
          _previous
          array:1 [ "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/1469/main"...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /graphql
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          application/json
          request_query
          []
          
          request_request
          0 of 0
          array:1 [ "query" => """ \n {\n reach(id: 1469) {\n avggradient\n permiturl\n permitinfo\n id\n class\n description_md\n edited\n length\n maxgradient\n plat\n plon\n geom\n status\n permissions {\n domain\n permission\n result\n }\n readingsummary {\n adjusted_reach_class\n gauge_estimated\n gauge_id\n gauge_important\n gauge_max\n gauge_min\n gauge_perfect\n obs_id\n range_comment\n }\n photo {\n id\n post {\n user {\n name\n uid\n }\n }\n image {\n uri {\n medium\n big\n }\n }\n }\n river\n section\n altname\n }\n }\n \n """ ]
          request_headers
          0 of 0
          array:20 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV0tyeFp5TzFUSmVKY1k5ZHc0ci81cTFNcEJzQWZqRDFOZzJTYml2WE1zMWtyemlwT2hMMGp4SkI3cnciLCJtYWMiOiI5YmE0YTA5ZGE4YjBjMDZjMDMxOTA0MzQyMTdhM2Y2MTI0NjZmMjU4MTNlODlkNzJiZDBmNzRmMmI3MjMyZjMxIn0%3D; americanwhitewater_session=FuOQWx9mlvGnwc2J3WfgjdgbyLwEy16mPCmvOMkFXSRF-TOKEN=eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV" ] "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/1469/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 => "eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV0tyeFp5TzFUSmVKY1k5ZHc0ci81cTFNcEJzQWZqRDFOZzJTYml2WE1zMWtyemlwT2hMMGp4SkI3cnciLCJtYWMiOiI5YmE0YTA5ZGE4YjBjMDZjMDMxOTA0MzQyMTdhM2Y2MTI0NjZmMjU4MTNlODlkNzJiZDBmNzRmMmI3MjMyZjMxIn0=eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV0tyeFp5TzFU" ] "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 => "1486" ] "host" => array:1 [ 0 => "beta.americanwhitewater.org" ] ]
          request_server
          0 of 0
          array:47 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV0tyeFp5TzFUSmVKY1k5ZHc0ci81cTFNcEJzQWZqRDFOZzJTYml2WE1zMWtyemlwT2hMMGp4SkI3cnciLCJtYWMiOiI5YmE0YTA5ZGE4YjBjMDZjMDMxOTA0MzQyMTdhM2Y2MTI0NjZmMjU4MTNlODlkNzJiZDBmNzRmMmI3MjMyZjMxIn0%3D; americanwhitewater_session=FuOQWx9mlvGnwc2J3WfgjdgbyLwEy16mPCmvOMkFXSRF-TOKEN=eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV" "HTTP_PRIORITY" => "u=1, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_REFERER" => "https://beta.americanwhitewater.org/content/River/view/river-detail/1469/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" => "1486" "HTTP_HOST" => "beta.americanwhitewater.org" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "beta.americanwhitewater.org" "SERVER_PORT" => "443" "SERVER_ADDR" => "172.31.18.125" "REMOTE_PORT" => "3479" "REMOTE_ADDR" => "3.22.71.103" "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" => "1486" "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" => 1743793766.3051 "REQUEST_TIME" => 1743793766 ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV0tyeFp5TzFUSmVKY1k5ZHc0ci81cTFNcEJzQWZqRDFOZzJTYml2WE1zMWtyemlwT2hMMGp4SkI3cnciLCJtYWMiOiI5YmE0YTA5ZGE4YjBjMDZjMDMxOTA0MzQyMTdhM2Y2MTI0NjZmMjU4MTNlODlkNzJiZDBmNzRmMmI3MjMyZjMxIn0=eyJpdiI6IlBVOU5nMXc0SDE3RDdQUEY1NFNHdHc9PSIsInZhbHVlIjoiU1lRdFJuQkFPKzNHbEM5MXIrdXFUSllJeXRNdmdtbUpPdEVYNTkyRjBNMGZRWXRlaU1tZGlPbnUrbHZGZUZUUWhLMVBwV0tyeFp5TzFU" "americanwhitewater_session" => "FuOQWx9mlvGnwc2J3WfgjdgbyLwEy16mPCmvOMkF" ]
          response_headers
          0 of 0
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 04 Apr 2025 19:09:28 GMT" ] "content-type" => array:1 [ 0 => "application/json" ] ]
          session_attributes
          0 of 0
          array:5 [ "_token" => "t6Dc9e2McV5mlFj5ukMEdKX4Fdy1MP78qsNTqdAb" "page" => array:1 [ "count" => -1 ] "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [ "url" => "https://beta.americanwhitewater.org/content/River/view/river-detail/1469/main" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]