1 x Application (92.68%) | 847ms |
1 x Booting (7.32%) | 66.87ms |
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
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" = '1238' and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select "reaches".*, (select count(*) from "reaches" as "laravel_reserved_0" where "reaches"."id" = "laravel_reserved_0"."id") as "revisions_count", 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 "reaches"."id" in (1238) and "reaches"."is_final" = 'true' and "reaches"."deleted_at" is null order by "reaches"."revision" desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from "reaches" where "reaches"."id" in (1238) order by "revision" desc limit 100 offset 0
Metadata | |
---|---|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select column_name from information_schema.columns where table_schema = 'public' and table_name = 'reaches'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from "users" where "users"."uid" = 148194 and "users"."uid" is not null and "users"."deleted_at" is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from "users" where "users"."uid" = 148194 and "users"."uid" is not null and "users"."deleted_at" is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from "users" where "users"."uid" = 148194 and "users"."uid" is not null and "users"."deleted_at" is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from "users" where "users"."uid" = 148194 and "users"."uid" is not null and "users"."deleted_at" is null limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "create" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "view" "result" => true "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "update" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
0 of 0array:4 [▶ "ability" => "delete" "result" => false "user" => 0 "arguments" => "[0 => Object(App\ReachRevision)]" ]
200
[]
0 of 0array:1 [▼ "query" => """ \n query {\n reach( id: 1238) {\n revisions(first:100,page:0){\n data {\n id\n revision\n sk {\n name\n }\n permissions {\n domain\n permission\n result\n }\n revision_comment\n edited\n }\n }\n }\n } """ ]
0 of 0array:20 [▼ "cookie" => array:1 [▶ 0 => "PHPSESSID=mjbsme72orok19rvs0rljde6ai; americanwhitewater_session=enm0Amrr5J8hQo81goWYnz3unA6MyFImi4TbD1I1; XSRF-TOKEN=eyJpdiI6IlFFMlFhckYxa0JRbFI4KzBTM2tvVGc9PSIsInZhbHVlIjoibjlxbDFsZE9IeFRaU0JpTmtmbzZkbHQ3bktER2k3QnR4dEhDTW92K1FYOUtFaU1yZnFnUGNJeGkySzQrUWJLNmJ2RHBZcGV5Y0ZiUUFkY2F6NVJ0bXhNMktUTmNVbzZkd3pJVXlpaVRVVjY2bUw1anJUZ1lEb01sMi9JTjd2dnUiLCJtYWMiOiJmNDM5ZTRlN2UxZWVhNjczZTIwZDNlNWU4YjQzOTRjYmIwY2I5YjZhNDg4ZDEwYWRlYTk4YjI2NDNkMmVlYTA2In0%3D ◀PHPSESSID=mjbsme72orok19rvs0rljde6ai; americanwhitewater_session=enm0Amrr5J8hQo81goWYnz3unA6MyFImi4TbD1I1; XSRF-TOKEN=eyJpdiI6IlFFMlFhckYxa0JRbFI4KzBTM2tvVGc9PS ▶" ] "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/1238/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 => "eyJpdiI6IkQ1QjlMbmkxREgxbnlveUE4OGY3M1E9PSIsInZhbHVlIjoiK3dYSXdldEFpSHJQNm0rMGc4bUxCN0NOaTFwWURuRVdGZnBabFV3OFROVWc4cGhOZ0FKNno3dmpIQlhieThzdFpzTmVxUFkwdytUMmJYRkk4YXhKOExzNFptWFdCeGRDZGh3bGg1OU1zRytUQTBCZWI2bjVwZXlHNDV6Vmgwc0siLCJtYWMiOiI4YmUzMDk2OTAxZGI2MDMxMDRkN2ZlZWFhMGNjMTU4NDNmZGFjYWUxNDJjNDM0MGYyMzQ4N2QyMGFiNWYyMWZhIn0= ◀eyJpdiI6IkQ1QjlMbmkxREgxbnlveUE4OGY3M1E9PSIsInZhbHVlIjoiK3dYSXdldEFpSHJQNm0rMGc4bUxCN0NOaTFwWURuRVdGZnBabFV3OFROVWc4cGhOZ0FKNno3dmpIQlhieThzdFpzTmVxUFkwdytUMmJY ▶" ] "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 => "522" ] "host" => array:1 [▶ 0 => "beta.americanwhitewater.org" ] ]
0 of 0array:47 [▼ "USER" => "www-data" "HOME" => "/var/www" "HTTP_COOKIE" => "PHPSESSID=mjbsme72orok19rvs0rljde6ai; americanwhitewater_session=enm0Amrr5J8hQo81goWYnz3unA6MyFImi4TbD1I1; XSRF-TOKEN=eyJpdiI6IlFFMlFhckYxa0JRbFI4KzBTM2tvVGc9PSIsInZhbHVlIjoibjlxbDFsZE9IeFRaU0JpTmtmbzZkbHQ3bktER2k3QnR4dEhDTW92K1FYOUtFaU1yZnFnUGNJeGkySzQrUWJLNmJ2RHBZcGV5Y0ZiUUFkY2F6NVJ0bXhNMktUTmNVbzZkd3pJVXlpaVRVVjY2bUw1anJUZ1lEb01sMi9JTjd2dnUiLCJtYWMiOiJmNDM5ZTRlN2UxZWVhNjczZTIwZDNlNWU4YjQzOTRjYmIwY2I5YjZhNDg4ZDEwYWRlYTk4YjI2NDNkMmVlYTA2In0%3D ◀PHPSESSID=mjbsme72orok19rvs0rljde6ai; americanwhitewater_session=enm0Amrr5J8hQo81goWYnz3unA6MyFImi4TbD1I1; XSRF-TOKEN=eyJpdiI6IlFFMlFhckYxa0JRbFI4KzBTM2tvVGc9PS ▶" "HTTP_PRIORITY" => "u=1, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_REFERER" => "https://beta.americanwhitewater.org/content/River/view/river-detail/1238/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" => "522" "HTTP_HOST" => "beta.americanwhitewater.org" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "beta.americanwhitewater.org" "SERVER_PORT" => "443" "SERVER_ADDR" => "172.31.18.125" "REMOTE_PORT" => "13580" "REMOTE_ADDR" => "3.131.82.143" "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" => "522" "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" => 1741875166.9151 "REQUEST_TIME" => 1741875166 ]
0 of 0array:3 [▼ "PHPSESSID" => "mjbsme72orok19rvs0rljde6ai" "americanwhitewater_session" => "enm0Amrr5J8hQo81goWYnz3unA6MyFImi4TbD1I1" "XSRF-TOKEN" => "eyJpdiI6IlFFMlFhckYxa0JRbFI4KzBTM2tvVGc9PSIsInZhbHVlIjoibjlxbDFsZE9IeFRaU0JpTmtmbzZkbHQ3bktER2k3QnR4dEhDTW92K1FYOUtFaU1yZnFnUGNJeGkySzQrUWJLNmJ2RHBZcGV5Y0ZiUUFkY2F6NVJ0bXhNMktUTmNVbzZkd3pJVXlpaVRVVjY2bUw1anJUZ1lEb01sMi9JTjd2dnUiLCJtYWMiOiJmNDM5ZTRlN2UxZWVhNjczZTIwZDNlNWU4YjQzOTRjYmIwY2I5YjZhNDg4ZDEwYWRlYTk4YjI2NDNkMmVlYTA2In0= ◀eyJpdiI6IlFFMlFhckYxa0JRbFI4KzBTM2tvVGc9PSIsInZhbHVlIjoibjlxbDFsZE9IeFRaU0JpTmtmbzZkbHQ3bktER2k3QnR4dEhDTW92K1FYOUtFaU1yZnFnUGNJeGkySzQrUWJLNmJ2RHBZcGV5Y0ZiUUFk ▶" ]
0 of 0array:3 [▼ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 13 Mar 2025 14:12:47 GMT" ] "content-type" => array:1 [▶ 0 => "application/json" ] ]
0 of 0array:5 [▼ "_token" => "uCtWCqMbrM6YeZKEdchtWELkUXKkfgjPbb4t8GcK" "page" => array:1 [▶ "count" => 6 ] "_previous" => array:1 [▶ "url" => "https://beta.americanwhitewater.org/content/River/detail/id/2011" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => array:1 [▶ "X85dc82448a942902b397c191e9e6e2bc" => null ] ]