Loading...
Calculating Your Route
Finding the best route
Verifying Locations

Just a moment while we calculate your route...

Distance from Teton to Canning

Driving Distance
33.9 mi • 54.5 km
Flying Distance
24.8 mi • 39.8 km
A
B
Leaflet © OpenStreetMap contributors
43 mph avg speed
East direction
48 min travel time

Route Information

The driving distance from Teton, South Dakota to Canning, South Dakota is 33.9 mi (54.5 km)

The straight-line (air) distance is 24.8 mi (39.8 km)

The estimated flight time is 0 hr 3 min

The estimated travel time by road is 48 minutes

Traveling mixed highways and local roads, moderate in a east direction. Average speeds around 43 mph.

Location Details

Origin:


No image available
Place Teton
State/Province South Dakota
Country US
Latitude 44.286926
Longitude -100.507914
GPS 44.286926° N, 100.507914° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Canning
State/Province South Dakota
Country US
Latitude 44.396372
Longitude -100.032068
GPS 44.396372° N, 100.032068° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Teton, South Dakota to Canning, South Dakota covers 33.9 mi (54.5 km) in a east direction. This mixed highways and local roads, moderate route typically takes 48 minutes under normal conditions.

Drivers have 2 route options between these locations (31.4-33.9 miles / 50-55 km). The primary route shown here saves 5 minutes compared to alternatives.

The route features scenic views, toll sections. with average speeds around 43 mph (69 km/h).

Available Routes

Bad River Rd
33.9 mi 48 minutes
Shortest Tolls
Bad River Rd and 205th St
31.4 mi 44 minutes
Fastest Tolls

How is the distance calculated?

Driving distances are based on actual road data. We use advanced routing algorithms that consider traffic, tolls, highways, and local streets. For air distances (as the crow flies), we use the Vincenty formula. It's a precise method that accounts for the Earth's shape and provides accuracy up to 0.5 mm.

When multiple route options exist, we display both the shortest and fastest paths. Travel times are estimated based on typical speeds for each road type, though actual times may vary with traffic and weather conditions. All distances are shown in both miles and kilometers for convenience.

Journey Waypoints

Teton
South Dakota , US
Fort Pierre
South Dakota, US
8.1 mi
Pierre
South Dakota, US
9.4 mi
Alto
South Dakota, US
19.0 mi
Canning
South Dakota , US
Messages26RequestTimelineExceptionsViews2Queries117Models61MailsGate
SettingsRequest history4sRequest Duration3MBMemory Usage12.x
Laravel Version
12.10.2
PHP Version
8.3.6
Environment
production
Debug Mode
Enabled
URL
routedistance.io
Timezone
UTC
Locale
en
GET distance/{origin}/{destination}
status
200 OK
full_url
https://routedistance.io/distance/teton-iaisw1v7/canning-sqlxgwsq
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[09:04:30] LOG.warning: No denormalized route found for origin-destination ID: 889913
  • infolog[09:04:30] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 82...
  • infolog[09:04:30] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:32] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:32] LOG.info: Processing route #1 data for origin-destination ID: 889913 { "origin": "Tet...
  • infolog[09:04:32] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:32] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:32] LOG.info: Ignoring 8 nested sub-directions for direction index 0
  • debuglog[09:04:32] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:32] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • infolog[09:04:32] LOG.info: Saved 2 directions for route ID: 2518624
  • infolog[09:04:32] LOG.info: Found a shorter route: 50488 meters for route ID: 2518624
  • infolog[09:04:32] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:32] LOG.info: Processing route #2 data for origin-destination ID: 889913 { "origin": "Tet...
  • infolog[09:04:32] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:32] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:32] LOG.info: Ignoring 7 nested sub-directions for direction index 0
  • debuglog[09:04:32] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:32] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • infolog[09:04:32] LOG.info: Saved 2 directions for route ID: 2518625
  • infolog[09:04:33] LOG.info: Successfully denormalized route data { "origin_destination_id": 889913, ...
  • infolog[09:04:33] LOG.info: Saved 2 routes for origin-destination ID: 889913
  • infolog[09:04:33] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518624, ...
  • infolog[09:04:33] LOG.info: Incremented view count for route { "id": 2518624, "name": "Bad River Rd...
  • infolog[09:04:33] LOG.info: Updated denormalized route for route { "route_id": 2518624, "views": 1 ...
  • infolog[09:04:33] LOG.info: Found existing routes { "route_count": 2, "default_route_id": 2518624, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/teton-iaisw1v7/canning-sqlxgwsq
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
4.01s
peak_memory
6MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a2ff20ba9c985-IAD"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:34 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "2BZKf4PYdl8MX8ltzEShoLlQwoVXL526YYVOmFoY"
]
  • Booting (13.58ms)time
  • Application (3.99s)time
  • Routing (415μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (56μs)
  • 1 x Application (99.66%)
    3.99s
    1 x Booting (0.34%)
    13.58ms
    1 x Routing (0.01%)
    415μs
    1 x Preparing Response (0%)
    56μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    117 statements were executed (79 duplicates)Show only duplicatesdistance2.4s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 17 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance12.07msselect * from "sessions" where "id" = 'M8d3nz3XFHvDM7OtuaOyBvNd5V5bu7EB7VOrNYqv' limit 1
      Bindings
      • 0: M8d3nz3XFHvDM7OtuaOyBvNd5V5bu7EB7VOrNYqv
      Backtrace
      • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:96
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:116
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:104
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:88
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:146
    • RouteController.php#548distance6.4msselect * from "places" where "slug" = 'teton' and ("hash" = 'iaisw1v7') limit 1
      Bindings
      • 0: teton
      • 1: iaisw1v7
      Backtrace
      • app/Http/Controllers/RouteController.php:548
      • app/Http/Controllers/RouteController.php:59
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • RouteController.php#548distance540μsselect * from "places" where "slug" = 'canning' and ("hash" = 'sqlxgwsq') limit 1
      Bindings
      • 0: canning
      • 1: sqlxgwsq
      Backtrace
      • app/Http/Controllers/RouteController.php:548
      • app/Http/Controllers/RouteController.php:60
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • RouteController.php#104distance720μsselect * from "origin_destinations" where ("origin_id" = 82908 and "destination_id" = 90986) limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Http/Controllers/RouteController.php:104
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
    • RouteController.php#104distance3.91msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (82908, 90986, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 82908
      • 1: 90986
      • 2: 2025-05-18 09:04:30
      • 3: 2025-05-18 09:04:30
      Backtrace
      • app/Http/Controllers/RouteController.php:104
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
    • RouteDenormalisationService.php#256distance1.32msselect * from "denormalised_routes" where "origin_destination_id" = 889913 limit 1
      Bindings
      • 0: 889913
      Backtrace
      • app/Services/RouteDenormalisationService.php:256
      • app/Http/Controllers/RouteController.php:111
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • OriginDestination.php#70distance1.45msselect exists(select "id" from "routes" where "origin_destination_id" = 889913 limit 1) as "exists"
      Bindings
      • 0: 889913
      Backtrace
      • app/Models/OriginDestination.php:70
      • app/Http/Controllers/RouteController.php:240
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#158distance3.72msdelete from "routes" where "origin_destination_id" = 889913
      Bindings
      • 0: 889913
      Backtrace
      • app/Services/DistanceCalculationService.php:158
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#172distance2.98msselect * from "places" where "places"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Services/DistanceCalculationService.php:172
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#173distance450μsselect * from "places" where "places"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance3.08msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889913, 'Bad River Rd and 205th St', 50488, 'm', 2662, 1, 'Your destination is in a different time zone.', 44.2869263, 44.4188232, null, 0, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 889913
      • 1: Bad River Rd and 205th St
      • 2: 50488
      • 3: m
      • 4: 2662
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 44.2869263
      • 8: 44.4188232
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:32
      • 12: 2025-05-18 09:04:32
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance1.34msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518624, 0, 'Follow Bad River Rd, US-83 N and US-14 E to 295th Ave in West Hughes', 31423, 'm', 1704, -100.37835895, 44.3530531, 0, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 2518624
      • 1: 0
      • 2: Follow Bad River Rd, US-83 N and US-14 E to 295th Ave in West Hughes
      • 3: 31423
      • 4: m
      • 5: 1704
      • 6: -100.37835894999999
      • 7: 44.3530531
      • 8: 0
      • 9: 2025-05-18 09:04:32
      • 10: 2025-05-18 09:04:32
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance810μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518624, 1, 'Take 205th St to Chesley Rd', 19065, 'm', 958, -100.14023225, 44.4075976, 0, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 2518624
      • 1: 1
      • 2: Take 205th St to Chesley Rd
      • 3: 19065
      • 4: m
      • 5: 958
      • 6: -100.14023225
      • 7: 44.4075976
      • 8: 0
      • 9: 2025-05-18 09:04:32
      • 10: 2025-05-18 09:04:32
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance1.09msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889913, 'Bad River Rd', 54547, 'm', 2907, 1, 'Your destination is in a different time zone.', 44.2869263, 44.3971868, null, 0, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 889913
      • 1: Bad River Rd
      • 2: 54547
      • 3: m
      • 4: 2907
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 44.2869263
      • 8: 44.3971868
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:32
      • 12: 2025-05-18 09:04:32
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance840μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518625, 0, 'Take Bad River Rd and SD-34 E to 300th Ave/Nystrom Rd in West Hughes', 36433, 'm', 1914, -100.338711, 44.32998135, 0, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 2518625
      • 1: 0
      • 2: Take Bad River Rd and SD-34 E to 300th Ave/Nystrom Rd in West Hughes
      • 3: 36433
      • 4: m
      • 5: 1914
      • 6: -100.338711
      • 7: 44.32998135
      • 8: 0
      • 9: 2025-05-18 09:04:32
      • 10: 2025-05-18 09:04:32
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance830μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518625, 1, 'Take Co Rd 652 to Chesley Rd', 18114, 'm', 993, -100.10058815, 44.36478595, 0, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 2518625
      • 1: 1
      • 2: Take Co Rd 652 to Chesley Rd
      • 3: 18114
      • 4: m
      • 5: 993
      • 6: -100.10058815
      • 7: 44.36478595
      • 8: 0
      • 9: 2025-05-18 09:04:32
      • 10: 2025-05-18 09:04:32
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance620μsselect * from "route_waypoints" where "route_id" = 2518624
      Bindings
      • 0: 2518624
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#103distance380μsselect * from "origin_destinations" where "origin_destinations"."id" = 889913 limit 1
      Bindings
      • 0: 889913
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#103distance430μsselect * from "places" where "places"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#104distance380μsselect * from "places" where "places"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance124msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.299086666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.45504222222)) + sin(radians(44.299086666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance770μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 10802 limit 1
      Bindings
      • 0: 10802
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance110msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.311247333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.40217044444)) + sin(radians(44.311247333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance96.75msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.323408)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.34929866667)) + sin(radians(44.323408)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance94.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.335568666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.29642688889)) + sin(radians(44.335568666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance700μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 3392 limit 1
      Bindings
      • 0: 3392
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance91.18msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.347729333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.24355511111)) + sin(radians(44.347729333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance88.27msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.35989)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.19068333333)) + sin(radians(44.35989)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance560μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 51112 limit 1
      Bindings
      • 0: 51112
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance83.95msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.372050666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.13781155556)) + sin(radians(44.372050666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance103msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.384211333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.08493977778)) + sin(radians(44.384211333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#78distance520μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 10802) limit 1
      Bindings
      • 0: 2518624
      • 1: 10802
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance5.53msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518624, 10802, 0.11111111111111, 6, '2025-05-18 09:04:33', '2025-05-18 09:04:33') returning "id"
      Bindings
      • 0: 2518624
      • 1: 10802
      • 2: 0.1111111111111111
      • 3: 6
      • 4: 2025-05-18 09:04:33
      • 5: 2025-05-18 09:04:33
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance360μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 3392) limit 1
      Bindings
      • 0: 2518624
      • 1: 3392
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.25msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518624, 3392, 0.44444444444444, 4, '2025-05-18 09:04:33', '2025-05-18 09:04:33') returning "id"
      Bindings
      • 0: 2518624
      • 1: 3392
      • 2: 0.4444444444444444
      • 3: 4
      • 4: 2025-05-18 09:04:33
      • 5: 2025-05-18 09:04:33
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 51112) limit 1
      Bindings
      • 0: 2518624
      • 1: 51112
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.17msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518624, 51112, 0.66666666666667, 4, '2025-05-18 09:04:33', '2025-05-18 09:04:33') returning "id"
      Bindings
      • 0: 2518624
      • 1: 51112
      • 2: 0.6666666666666666
      • 3: 4
      • 4: 2025-05-18 09:04:33
      • 5: 2025-05-18 09:04:33
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#366distance2.58msselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518624 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518624
      Backtrace
      • app/Services/DistanceCalculationService.php:366
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteDenormalisationService.php#45distance450μsselect * from "denormalised_routes" where "origin_destination_id" = 889913 limit 1
      Bindings
      • 0: 889913
      Backtrace
      • app/Services/RouteDenormalisationService.php:45
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteDenormalisationService.php#123distance670μsselect * from "route_directions" where "route_directions"."route_id" = 2518624 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518624
      Backtrace
      • app/Services/RouteDenormalisationService.php:123
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • Place.php#198distance1.59msselect * from "locations" where "locations"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:153
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance700μsselect * from "cities" where "cities"."id" = 31961 limit 1
      Bindings
      • 0: 31961
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:153
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#215distance1.71msselect * from "states" where "states"."id" = 49 limit 1
      Bindings
      • 0: 49
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:154
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance360μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:155
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance310μsselect * from "locations" where "locations"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:167
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance300μsselect * from "cities" where "cities"."id" = 20756 limit 1
      Bindings
      • 0: 20756
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:167
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#215distance270μsselect * from "states" where "states"."id" = 49 limit 1
      Bindings
      • 0: 49
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:168
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance280μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance4.69msinsert into "denormalised_routes" ("origin_id", "origin_place", "origin_formatted_address", "origin_slug", "origin_hash", "origin_lat", "origin_lng", "origin_city", "origin_state", "origin_country", "origin_timezone", "destination_id", "destination_place", "destination_formatted_address", "destination_slug", "destination_hash", "destination_lat", "destination_lng", "destination_city", "destination_state", "destination_country", "destination_timezone", "default_route_id", "route_name", "distance", "distance_unit", "time", "distance_miles", "distance_formatted", "time_formatted", "formatted_time", "distance_km", "distance_km_formatted", "time_hours", "time_minutes", "has_tolls", "tolls", "formatted_miles", "straight_line_distance", "straight_line_distance_km", "route_directions", "min_distance", "max_distance", "time_savings", "straight_line", "origin_direction", "destination_direction", "waypoints", "has_waypoints", "waypoints_count", "journey_info", "polyline", "url_path", "views", "map_image", "website", "comments_count", "intermediate_locations", "directions_count", "origin_destination_id", "updated_at", "created_at") values (82908, 'Teton', 'Teton, South Stanley, SD 57532', 'teton', 'iaisw1v7', 44.286926, -100.507914, 'South Stanley', 'South Dakota', 'US', 'America/Chicago', 90986, 'Canning', 'Canning, West Hughes, SD 57501', 'canning', 'sqlxgwsq', 44.396372, -100.032068, 'West Hughes', 'South Dakota', 'US', 'America/Chicago', 2518624, 'Bad River Rd and 205th St', 50488, 'm', 2662, 31.371779048, 50488, '44 minutes', '44 minutes', 50.488, '50.5 km', null, 44, 1, 'Your destination is in a different time zone.', '31.4 mi', 24.699691979938, 0.024699691979938, '"[{\"id\":8350514,\"route_id\":2518624,\"step_index\":\"0\",\"instruction\":\"Follow Bad River Rd, US-83 N and US-14 E to 295th Ave in West Hughes\",\"distance\":31423,\"distance_unit\":\"m\",\"time\":\"1704\",\"latitude\":-100.378359,\"longitude\":44.3530531,\"is_sub_step\":false},{\"id\":8350515,\"route_id\":2518624,\"step_index\":\"1\",\"instruction\":\"Take 205th St to Chesley Rd\",\"distance\":19065,\"distance_unit\":\"m\",\"time\":\"958\",\"latitude\":-100.1402323,\"longitude\":44.4075976,\"is_sub_step\":false}]"', 50488, 50488, '5 minutes', 0, 'east', 'west', '[{"name":"Fort Pierre","description":"35 mi to destination","state":"South Dakota","country":"US","full_address":"Fort Pierre, SD 57532","lat":"44.353593","lng":"-100.373745","fraction":0.1111111111111111,"type":"City","distance_km":6,"place_id":10802,"slug":"fort-pierre","hash":"y8jly24d"},{"name":"Pierre","description":"Traveled 18 mi from origin","state":"South Dakota","country":"US","full_address":"Pierre, SD 57501","lat":"44.366788","lng":"-100.353752","fraction":0.4444444444444444,"type":"City","distance_km":4,"place_id":3392,"slug":"pierre","hash":"vxvnm5wc"},{"name":"Alto","description":"Traveled 27 mi from origin","state":"South Dakota","country":"US","full_address":"Alto, SD 57501","lat":"44.329983","lng":"-100.127349","fraction":0.6666666666666666,"type":"City","distance_km":4,"place_id":51112,"slug":"alto","hash":"mz61uk3i"}]', 1, 3, '{"distanceInMiles":31.371866727975444,"distanceMilesFormatted":"31.4 miles","distanceFormatted":"31.4 miles","distanceKmFormatted":"50 km","timeHours":0.7333333333333333,"timeFormatted":"44 minutes","avgSpeed":43,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"east"}', null, 'teton-iaisw1v7/canning-sqlxgwsq', 0, null, null, 0, '"[{\"name\":\"Fort Pierre\",\"description\":\"35 mi to destination\",\"state\":\"South Dakota\",\"country\":\"US\",\"full_address\":\"Fort Pierre, SD 57532\",\"lat\":\"44.353593\",\"lng\":\"-100.373745\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":6,\"place_id\":10802,\"slug\":\"fort-pierre\",\"hash\":\"y8jly24d\"},{\"name\":\"Pierre\",\"description\":\"Traveled 18 mi from origin\",\"state\":\"South Dakota\",\"country\":\"US\",\"full_address\":\"Pierre, SD 57501\",\"lat\":\"44.366788\",\"lng\":\"-100.353752\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":4,\"place_id\":3392,\"slug\":\"pierre\",\"hash\":\"vxvnm5wc\"},{\"name\":\"Alto\",\"description\":\"Traveled 27 mi from origin\",\"state\":\"South Dakota\",\"country\":\"US\",\"full_address\":\"Alto, SD 57501\",\"lat\":\"44.329983\",\"lng\":\"-100.127349\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":4,\"place_id\":51112,\"slug\":\"alto\",\"hash\":\"mz61uk3i\"}]"', 2, 889913, '2025-05-18 09:04:33', '2025-05-18 09:04:33') returning "id"
      Bindings
      • 0: 82908
      • 1: Teton
      • 2: Teton, South Stanley, SD 57532
      • 3: teton
      • 4: iaisw1v7
      • 5: 44.286926
      • 6: -100.507914
      • 7: South Stanley
      • 8: South Dakota
      • 9: US
      • 10: America/Chicago
      • 11: 90986
      • 12: Canning
      • 13: Canning, West Hughes, SD 57501
      • 14: canning
      • 15: sqlxgwsq
      • 16: 44.396372
      • 17: -100.032068
      • 18: West Hughes
      • 19: South Dakota
      • 20: US
      • 21: America/Chicago
      • 22: 2518624
      • 23: Bad River Rd and 205th St
      • 24: 50488
      • 25: m
      • 26: 2662
      • 27: 31.371779048
      • 28: 50488
      • 29: 44 minutes
      • 30: 44 minutes
      • 31: 50.488
      • 32: 50.5 km
      • 33: 
      • 34: 44
      • 35: 1
      • 36: Your destination is in a different time zone.
      • 37: 31.4 mi
      • 38: 24.699691979938493
      • 39: 0.024699691979938494
      • 40: "[{\"id\":8350514,\"route_id\":2518624,\"step_index\":\"0\",\"instruction\":\"Follow Bad River Rd, US-83 N and US-14 E to 295th Ave in West Hughes\",\"distance\":31423,\"distance_unit\":\"m\",\"time\":\"1704\",\"latitude\":-100.378359,\"longitude\":44.3530531,\"is_sub_step\":false},{\"id\":8350515,\"route_id\":2518624,\"step_index\":\"1\",\"instruction\":\"Take 205th St to Chesley Rd\",\"distance\":19065,\"distance_unit\":\"m\",\"time\":\"958\",\"latitude\":-100.1402323,\"longitude\":44.4075976,\"is_sub_step\":false}]"
      • 41: 50488
      • 42: 50488
      • 43: 5 minutes
      • 44: 0
      • 45: east
      • 46: west
      • 47: [{"name":"Fort Pierre","description":"35 mi to destination","state":"South Dakota","country":"US","full_address":"Fort Pierre, SD 57532","lat":"44.353593","lng":"-100.373745","fraction":0.1111111111111111,"type":"City","distance_km":6,"place_id":10802,"slug":"fort-pierre","hash":"y8jly24d"},{"name":"Pierre","description":"Traveled 18 mi from origin","state":"South Dakota","country":"US","full_address":"Pierre, SD 57501","lat":"44.366788","lng":"-100.353752","fraction":0.4444444444444444,"type":"City","distance_km":4,"place_id":3392,"slug":"pierre","hash":"vxvnm5wc"},{"name":"Alto","description":"Traveled 27 mi from origin","state":"South Dakota","country":"US","full_address":"Alto, SD 57501","lat":"44.329983","lng":"-100.127349","fraction":0.6666666666666666,"type":"City","distance_km":4,"place_id":51112,"slug":"alto","hash":"mz61uk3i"}]
      • 48: 1
      • 49: 3
      • 50: {"distanceInMiles":31.371866727975444,"distanceMilesFormatted":"31.4 miles","distanceFormatted":"31.4 miles","distanceKmFormatted":"50 km","timeHours":0.7333333333333333,"timeFormatted":"44 minutes","avgSpeed":43,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"east"}
      • 51: 
      • 52: teton-iaisw1v7/canning-sqlxgwsq
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Fort Pierre\",\"description\":\"35 mi to destination\",\"state\":\"South Dakota\",\"country\":\"US\",\"full_address\":\"Fort Pierre, SD 57532\",\"lat\":\"44.353593\",\"lng\":\"-100.373745\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":6,\"place_id\":10802,\"slug\":\"fort-pierre\",\"hash\":\"y8jly24d\"},{\"name\":\"Pierre\",\"description\":\"Traveled 18 mi from origin\",\"state\":\"South Dakota\",\"country\":\"US\",\"full_address\":\"Pierre, SD 57501\",\"lat\":\"44.366788\",\"lng\":\"-100.353752\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":4,\"place_id\":3392,\"slug\":\"pierre\",\"hash\":\"vxvnm5wc\"},{\"name\":\"Alto\",\"description\":\"Traveled 27 mi from origin\",\"state\":\"South Dakota\",\"country\":\"US\",\"full_address\":\"Alto, SD 57501\",\"lat\":\"44.329983\",\"lng\":\"-100.127349\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":4,\"place_id\":51112,\"slug\":\"alto\",\"hash\":\"mz61uk3i\"}]"
      • 58: 2
      • 59: 889913
      • 60: 2025-05-18 09:04:33
      • 61: 2025-05-18 09:04:33
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance480μsselect exists(select "id" from "routes" where "origin_destination_id" = 889913 limit 1) as "exists"
      Bindings
      • 0: 889913
      Backtrace
      • app/Models/OriginDestination.php:70
      • app/Services/DistanceCalculationService.php:1179
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#1186distance610μsselect * from "routes" where "routes"."origin_destination_id" = 889913 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889913
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#1186distance420μsselect * from "route_directions" where "route_directions"."route_id" in (2518624, 2518625) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance1.07msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:33' where "id" = 2518624
      Bindings
      • 0: 2025-05-18 09:04:33
      • 1: 2518624
      Backtrace
      • app/Models/Route.php:225
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#235distance450μsselect * from "origin_destinations" where "origin_destinations"."id" = 889913 limit 1
      Bindings
      • 0: 889913
      Backtrace
      • app/Models/Route.php:235
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#244distance490μsselect * from "places" where "places"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Models/Route.php:244
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#245distance380μsselect * from "places" where "places"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Models/Route.php:245
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance370μsselect * from "route_waypoints" where "route_id" = 2518624
      Bindings
      • 0: 2518624
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#103distance400μsselect * from "places" where "places"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#104distance420μsselect * from "places" where "places"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance94.24msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.299086666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.45504222222)) + sin(radians(44.299086666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 10802 limit 1
      Bindings
      • 0: 10802
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance93.13msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.311247333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.40217044444)) + sin(radians(44.311247333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance92.14msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.323408)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.34929866667)) + sin(radians(44.323408)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance89.2msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.335568666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.29642688889)) + sin(radians(44.335568666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 3392 limit 1
      Bindings
      • 0: 3392
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance90.75msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.347729333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.24355511111)) + sin(radians(44.347729333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance87.78msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.35989)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.19068333333)) + sin(radians(44.35989)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 51112 limit 1
      Bindings
      • 0: 51112
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance89.71msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.372050666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.13781155556)) + sin(radians(44.372050666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance92.06msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.384211333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.08493977778)) + sin(radians(44.384211333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#78distance460μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 10802) limit 1
      Bindings
      • 0: 2518624
      • 1: 10802
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance950μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:33' where "id" = 6300303
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:33
      • 2: 6300303
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 3392) limit 1
      Bindings
      • 0: 2518624
      • 1: 3392
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance680μsupdate "route_waypoints" set "fraction" = 0.44444444444444, "updated_at" = '2025-05-18 09:04:33' where "id" = 6300304
      Bindings
      • 0: 0.4444444444444444
      • 1: 2025-05-18 09:04:33
      • 2: 6300304
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 51112) limit 1
      Bindings
      • 0: 2518624
      • 1: 51112
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance650μsupdate "route_waypoints" set "fraction" = 0.66666666666667, "updated_at" = '2025-05-18 09:04:33' where "id" = 6300305
      Bindings
      • 0: 0.6666666666666666
      • 1: 2025-05-18 09:04:33
      • 2: 6300305
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteDenormalisationService.php#45distance570μsselect * from "denormalised_routes" where "origin_destination_id" = 889913 limit 1
      Bindings
      • 0: 889913
      Backtrace
      • app/Services/RouteDenormalisationService.php:45
      • app/Models/Route.php:279
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#24distance350μsselect * from "route_waypoints" where "route_id" = 2518624
      Bindings
      • 0: 2518624
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#103distance430μsselect * from "places" where "places"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#104distance370μsselect * from "places" where "places"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance90.72msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.299086666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.45504222222)) + sin(radians(44.299086666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 10802 limit 1
      Bindings
      • 0: 10802
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance91.68msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.311247333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.40217044444)) + sin(radians(44.311247333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance93.64msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.323408)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.34929866667)) + sin(radians(44.323408)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance89.35msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.335568666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.29642688889)) + sin(radians(44.335568666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 3392 limit 1
      Bindings
      • 0: 3392
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance92.88msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.347729333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.24355511111)) + sin(radians(44.347729333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance95.48msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.35989)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.19068333333)) + sin(radians(44.35989)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 51112 limit 1
      Bindings
      • 0: 51112
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance95.54msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.372050666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.13781155556)) + sin(radians(44.372050666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance93.43msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(44.384211333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-100.08493977778)) + sin(radians(44.384211333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != 82908 and "places"."id" != 90986 order by "distance" asc limit 1
      Bindings
      • 0: 82908
      • 1: 90986
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance570μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 10802) limit 1
      Bindings
      • 0: 2518624
      • 1: 10802
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#78distance960μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:34' where "id" = 6300303
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:34
      • 2: 6300303
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#78distance360μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 3392) limit 1
      Bindings
      • 0: 2518624
      • 1: 3392
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#78distance710μsupdate "route_waypoints" set "fraction" = 0.44444444444444, "updated_at" = '2025-05-18 09:04:34' where "id" = 6300304
      Bindings
      • 0: 0.4444444444444444
      • 1: 2025-05-18 09:04:34
      • 2: 6300304
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518624 and "place_id" = 51112) limit 1
      Bindings
      • 0: 2518624
      • 1: 51112
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#78distance650μsupdate "route_waypoints" set "fraction" = 0.66666666666667, "updated_at" = '2025-05-18 09:04:34' where "id" = 6300305
      Bindings
      • 0: 0.6666666666666666
      • 1: 2025-05-18 09:04:34
      • 2: 6300305
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Place.php#215distance300μsselect * from "locations" where "locations"."id" = 82908 limit 1
      Bindings
      • 0: 82908
      Backtrace
      • app/Models/Place.php:215
      • app/Services/DistanceCalculationService.php:1101
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Place.php#215distance330μsselect * from "states" where "states"."id" = 49 limit 1
      Bindings
      • 0: 49
      Backtrace
      • app/Models/Place.php:215
      • app/Services/DistanceCalculationService.php:1101
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Place.php#215distance290μsselect * from "locations" where "locations"."id" = 90986 limit 1
      Bindings
      • 0: 90986
      Backtrace
      • app/Models/Place.php:215
      • app/Services/DistanceCalculationService.php:1102
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • distance350μsselect * from "states" where "states"."id" = ? limit 1
    • distance520μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance390μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance870μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.61msselect * from "images" where "images"."place_id" in (82908)
    • distance640μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.81msselect * from "images" where "images"."place_id" in (90986)
    • distance590μsselect * from "routes" where "origin_destination_id" = ?
    • distance570μsselect exists(select * from (select "id", "route_id", row_number() over (partition by "route_directions"."route_id") as "laravel_row" from "route_directions") as "laravel_table" where "laravel_row" <= 1 order by "laravel_row") as "exists"
    • distance430μsselect * from "route_directions" where "route_directions"."route_id" in (2518624, 2518625) order by "step_index" asc, "step_index" asc
    • distance360μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance320μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance700μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance430μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance380μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance500μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    15RouteWaypoint.php#?
    App\Models\Place
    14Place.php#?
    App\Models\RouteDirection
    10RouteDirection.php#?
    App\Models\Route
    5Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:34GET/distance/teton-iaisw1v7/canning-sqlxgwsq26211761