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

Just a moment while we calculate your route...

Distance from Wegra to Unger

Driving Distance
620.4 mi 998.4 km
Flying Distance
499.7 mi 804.2 km
A
B
Leaflet © OpenStreetMap contributors

Route Information

The driving distance from Wegra, Alabama to Unger, Oklahoma is 620.4 mi (998.4 km)

The straight-line (air) distance is 499.7 mi (804.2 km)

The estimated flight time is 1 hr 0 min

The estimated travel time by road is 9 hours 59 minutes

Traveling highway, long-distance in a west direction. Average speeds around 64 mph.

Location Details

Origin:


No image available
Place Wegra
State/Province Alabama
Country US
Latitude 33.634274
Longitude -87.104165
GPS 33.634274° N, 87.104165° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Unger
State/Province Oklahoma
Country US
Latitude 34.026211
Longitude -95.781916
GPS 34.026211° N, 95.781916° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Wegra, Alabama to Unger, Oklahoma covers 620.4 mi (998.4 km) in a west direction. This highway, long-distance route typically takes 9 hours 59 minutes under normal conditions.

Drivers have 3 route options between these locations (592.5-655.0 miles / 953-1,054 km). The primary route shown here saves 29 minutes compared to alternatives.

The route features scenic views along the way. with average speeds around 64 mph (103 km/h).

Available Routes

I-22
620.4 mi 9 hours 59 minutes
Shortest
I-22 and I-40 W
655 mi 10 hours 1 minute
I-22 and US-70 W
592.5 mi 9 hours 32 minutes
Fastest

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.

SettingsRequest history4.23sRequest 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/wegra-n8arwc0l/unger-9fcqcn9y
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:21] LOG.warning: No denormalized route found for origin-destination ID: 889904
  • infolog[09:04:21] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 51...
  • infolog[09:04:21] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #1 data for origin-destination ID: 889904 { "origin": "Weg...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 11 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 16 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 7 nested sub-directions for direction index 2
  • infolog[09:04:24] LOG.info: Saved 3 directions for route ID: 2518602
  • infolog[09:04:24] LOG.info: Found a shorter route: 953489 meters for route ID: 2518602
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #2 data for origin-destination ID: 889904 { "origin": "Weg...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 11 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 16 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 14 nested sub-directions for direction index 2
  • infolog[09:04:24] LOG.info: Saved 3 directions for route ID: 2518603
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #3 data for origin-destination ID: 889904 { "origin": "Weg...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 11 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 8 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 11 nested sub-directions for direction index 2
  • infolog[09:04:24] LOG.info: Saved 3 directions for route ID: 2518604
  • infolog[09:04:25] LOG.info: Successfully denormalized route data { "origin_destination_id": 889904, ...
  • infolog[09:04:25] LOG.info: Saved 3 routes for origin-destination ID: 889904
  • infolog[09:04:25] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518602, ...
  • infolog[09:04:25] LOG.info: Incremented view count for route { "id": 2518602, "name": "I-22 and US-...
  • infolog[09:04:25] LOG.info: Updated denormalized route for route { "route_id": 2518602, "views": 1 ...
  • infolog[09:04:25] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518602, ...
status
200 OK
full_url
https://routedistance.io/distance/wegra-n8arwc0l/unger-9fcqcn9y
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.23s
peak_memory
4MB
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 => "941a2fc7dc05c97c-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:25 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "9dxqnq6rt5Tjn7I3GPAC1FgqMvuLTFeWudlnBTYg" ]
  • Booting (9.31ms)time
  • Application (4.22s)time
  • Routing (439μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (47μs)
  • 1 x Application (99.78%)
    4.22s
    1 x Booting (0.22%)
    9.31ms
    1 x Routing (0.01%)
    439μs
    1 x Preparing Response (0%)
    47μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    175 statements were executed (101 duplicates)Show only duplicatesdistance979ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 75 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance13.28msselect * from "sessions" where "id" = 'Gkvzh4eruIYAuf1ToYaRUAUPeASLvNuafeaGI9wu' limit 1
      Bindings
      • 0: Gkvzh4eruIYAuf1ToYaRUAUPeASLvNuafeaGI9wu
      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.78msselect * from "places" where "slug" = 'wegra' and ("hash" = 'n8arwc0l') limit 1
      Bindings
      • 0: wegra
      • 1: n8arwc0l
      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#548distance600μsselect * from "places" where "slug" = 'unger' and ("hash" = '9fcqcn9y') limit 1
      Bindings
      • 0: unger
      • 1: 9fcqcn9y
      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#104distance800μsselect * from "origin_destinations" where ("origin_id" = 51761 and "destination_id" = 67478) limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#104distance1.93msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (51761, 67478, '2025-05-18 09:04:21', '2025-05-18 09:04:21') returning "id"
      Bindings
      • 0: 51761
      • 1: 67478
      • 2: 2025-05-18 09:04:21
      • 3: 2025-05-18 09:04:21
      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.35msselect * from "denormalised_routes" where "origin_destination_id" = 889904 limit 1
      Bindings
      • 0: 889904
      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#70distance610μsselect exists(select "id" from "routes" where "origin_destination_id" = 889904 limit 1) as "exists"
      Bindings
      • 0: 889904
      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.22msdelete from "routes" where "origin_destination_id" = 889904
      Bindings
      • 0: 889904
      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#172distance480μsselect * from "places" where "places"."id" = 51761 limit 1
      Bindings
      • 0: 51761
      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#173distance340μsselect * from "places" where "places"."id" = 67478 limit 1
      Bindings
      • 0: 67478
      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#225distance4msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889904, 'I-22 and US-70 W', 953489, 'm', 34375, 0, 'No', 33.6128026, 35.1711028, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889904
      • 1: I-22 and US-70 W
      • 2: 953489
      • 3: m
      • 4: 34375
      • 5: 0
      • 6: No
      • 7: 33.6128026
      • 8: 35.1711028
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      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.25msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518602, 0, 'Get on I-22/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd', 12512, 'm', 822, -87.09729655, 33.64698105, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518602
      • 1: 0
      • 2: Get on I-22/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd
      • 3: 12512
      • 4: m
      • 5: 822
      • 6: -87.09729655
      • 7: 33.64698105
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance770μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518602, 1, 'Continue on US-78 W. Take I-40 W and I-30 W to US-70 W/US-70 BUS in Hot Springs. Take exit 2 from US-270 W/US-70 W', 653243, 'm', 21818, -90.10170765, 34.42610775, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518602
      • 1: 1
      • 2: Continue on US-78 W. Take I-40 W and I-30 W to US-70 W/US-70 BUS in Hot Springs. Take exit 2 from US-270 W/US-70 W
      • 3: 653243
      • 4: m
      • 5: 21818
      • 6: -90.10170765
      • 7: 34.42610775000001
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance1.74msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518602, 2, 'Drive to US-70 W in Choctaw County', 287734, 'm', 11735, -94.4482079, 34.1979062, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518602
      • 1: 2
      • 2: Drive to US-70 W in Choctaw County
      • 3: 287734
      • 4: m
      • 5: 11735
      • 6: -94.4482079
      • 7: 34.1979062
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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.51msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889904, 'I-22', 998419, 'm', 35956, 0, 'No', 33.6128026, 35.1711028, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889904
      • 1: I-22
      • 2: 998419
      • 3: m
      • 4: 35956
      • 5: 0
      • 6: No
      • 7: 33.6128026
      • 8: 35.1711028
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      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#548distance800μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518603, 0, 'Get on I-22/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd', 12512, 'm', 822, -87.09729655, 33.64698105, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518603
      • 1: 0
      • 2: Get on I-22/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd
      • 3: 12512
      • 4: m
      • 5: 822
      • 6: -87.09729655
      • 7: 33.64698105
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance1.36msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518603, 1, 'Continue on US-78 W. Take I-40 W and I-30 W to US-270 W in Hot Springs. Take the US-270 W exit from US-270 W', 655523, 'm', 21897, -90.1028707, 34.42610775, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518603
      • 1: 1
      • 2: Continue on US-78 W. Take I-40 W and I-30 W to US-270 W in Hot Springs. Take the US-270 W exit from US-270 W
      • 3: 655523
      • 4: m
      • 5: 21897
      • 6: -90.1028707
      • 7: 34.42610775000001
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518603, 2, 'Continue on US-270 W. Take AR-88 W, OK-63 W, US-271 S and OK-2 S to US-70 W in Choctaw County', 330384, 'm', 13237, -94.4494342, 34.3841274, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518603
      • 1: 2
      • 2: Continue on US-270 W. Take AR-88 W, OK-63 W, US-271 S and OK-2 S to US-70 W in Choctaw County
      • 3: 330384
      • 4: m
      • 5: 13237
      • 6: -94.4494342
      • 7: 34.3841274
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#225distance2.14msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889904, 'I-22 and I-40 W', 1054048, 'm', 36114, 0, 'No', 33.6128026, 35.533776, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889904
      • 1: I-22 and I-40 W
      • 2: 1054048
      • 3: m
      • 4: 36114
      • 5: 0
      • 6: No
      • 7: 33.6128026
      • 8: 35.533775999999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      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#548distance820μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518604, 0, 'Get on I-22/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd', 12512, 'm', 822, -87.09729655, 33.64698105, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518604
      • 1: 0
      • 2: Get on I-22/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd
      • 3: 12512
      • 4: m
      • 5: 822
      • 6: -87.09729655
      • 7: 33.64698105
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518604, 1, 'Follow US-78 W and I-40 W to US-271 S in Pocola', 814000, 'm', 26548, -90.76477835, 34.60744435, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518604
      • 1: 1
      • 2: Follow US-78 W and I-40 W to US-271 S in Pocola
      • 3: 814000
      • 4: m
      • 5: 26548
      • 6: -90.76477835
      • 7: 34.607444349999994
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance720μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518604, 2, 'Take OK-112 S, US-271 S, OK-2 S and US-271 S to US-70 W in Choctaw County', 227536, 'm', 8744, -95.11134185, 34.657632, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518604
      • 1: 2
      • 2: Take OK-112 S, US-271 S, OK-2 S and US-271 S to US-70 W in Choctaw County
      • 3: 227536
      • 4: m
      • 5: 8744
      • 6: -95.11134185
      • 7: 34.65763199999999
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#24distance3.16msselect * from "route_waypoints" where "route_id" = 2518602
      Bindings
      • 0: 2518602
      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#103distance330μsselect * from "origin_destinations" where "origin_destinations"."id" = 889904 limit 1
      Bindings
      • 0: 889904
      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#103distance400μsselect * from "places" where "places"."id" = 51761 limit 1
      Bindings
      • 0: 51761
      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#104distance340μsselect * from "places" where "places"."id" = 67478 limit 1
      Bindings
      • 0: 67478
      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#226distance125msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.677822555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-88.068359555556)) + sin(radians(33.677822555556)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance800μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 54750 limit 1
      Bindings
      • 0: 54750
      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#226distance92.84msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.721371111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.032554111111)) + sin(radians(33.721371111111)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance3msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 21543 limit 1
      Bindings
      • 0: 21543
      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#226distance92.38msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.764919666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.996748666667)) + sin(radians(33.764919666667)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance1.36msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 27627 limit 1
      Bindings
      • 0: 27627
      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#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.808468222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.960943222222)) + sin(radians(33.808468222222)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance730μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 23562 limit 1
      Bindings
      • 0: 23562
      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#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.852016777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-91.925137777778)) + sin(radians(33.852016777778)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 87762 limit 1
      Bindings
      • 0: 87762
      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#226distance90.45msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.895565333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.889332333333)) + sin(radians(33.895565333333)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 20785 limit 1
      Bindings
      • 0: 20785
      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#226distance103msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.939113888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.853526888889)) + sin(radians(33.939113888889)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance1.51msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 8036 limit 1
      Bindings
      • 0: 8036
      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#226distance112msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.982662444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.817721444444)) + sin(radians(33.982662444444)) * 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" != 51761 and "places"."id" != 67478 order by "distance" asc limit 1
      Bindings
      • 0: 51761
      • 1: 67478
      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#158distance730μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 59579 limit 1
      Bindings
      • 0: 59579
      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#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518602 and "place_id" = 54750) limit 1
      Bindings
      • 0: 2518602
      • 1: 54750
      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.28msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 54750, 0.11111111111111, 2, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 54750
      • 2: 0.1111111111111111
      • 3: 2
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance410μsselect * from "route_waypoints" where ("route_id" = 2518602 and "place_id" = 21543) limit 1
      Bindings
      • 0: 2518602
      • 1: 21543
      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.03msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 21543, 0.22222222222222, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 21543
      • 2: 0.2222222222222222
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518602 and "place_id" = 27627) limit 1
      Bindings
      • 0: 2518602
      • 1: 27627
      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.1msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 27627, 0.33333333333333, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 27627
      • 2: 0.3333333333333333
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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" = 2518602 and "place_id" = 23562) limit 1
      Bindings
      • 0: 2518602
      • 1: 23562
      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.12msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 23562, 0.44444444444444, 2, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 23562
      • 2: 0.4444444444444444
      • 3: 2
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance430μsselect * from "route_waypoints" where ("route_id" = 2518602 and "place_id" = 87762) limit 1
      Bindings
      • 0: 2518602
      • 1: 87762
      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#78distance2msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 87762, 0.55555555555556, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 87762
      • 2: 0.5555555555555556
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518602 and "place_id" = 20785) limit 1
      Bindings
      • 0: 2518602
      • 1: 20785
      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.07msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 20785, 0.66666666666667, 3, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 20785
      • 2: 0.6666666666666666
      • 3: 3
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518602 and "place_id" = 8036) limit 1
      Bindings
      • 0: 2518602
      • 1: 8036
      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#78distance860μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 8036, 0.77777777777778, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 8036
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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" = 2518602 and "place_id" = 59579) limit 1
      Bindings
      • 0: 2518602
      • 1: 59579
      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#78distance910μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518602, 59579, 0.88888888888889, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518602
      • 1: 59579
      • 2: 0.8888888888888888
      • 3: 0
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#366distance600μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518602 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518602
      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#45distance500μsselect * from "denormalised_routes" where "origin_destination_id" = 889904 limit 1
      Bindings
      • 0: 889904
      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#123distance690μsselect * from "route_directions" where "route_directions"."route_id" = 2518602 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518602
      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#198distance380μsselect * from "locations" where "locations"."id" = 51761 limit 1
      Bindings
      • 0: 51761
      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#215distance380μsselect * from "states" where "states"."id" = 9 limit 1
      Bindings
      • 0: 9
      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#330distance390μ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#198distance340μsselect * from "locations" where "locations"."id" = 67478 limit 1
      Bindings
      • 0: 67478
      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#215distance380μsselect * from "states" where "states"."id" = 31 limit 1
      Bindings
      • 0: 31
      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#330distance340μ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#70distance2.22msinsert 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 (51761, 'Wegra', 'Wegra, AL 35130', 'wegra', 'n8arwc0l', 33.634274, -87.104165, null, 'Alabama', 'US', 'America/Chicago', 67478, 'Unger', 'Unger, OK 74727', 'unger', '9fcqcn9y', 34.026211, -95.781916, null, 'Oklahoma', 'US', 'America/Chicago', 2518602, 'I-22 and US-70 W', 953489, 'm', 34375, 592.470413419, 953489, '9 hours 32 minutes', '9 hours 32 minutes', 953.489, '953.5 km', null, 573, 0, 'No', '592.5 mi', 498.64677702349, 0.49864677702349, '"[{\"id\":8350443,\"route_id\":2518602,\"step_index\":\"0\",\"instruction\":\"Get on I-22\\\/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd\",\"distance\":12512,\"distance_unit\":\"m\",\"time\":\"822\",\"latitude\":-87.0972966,\"longitude\":33.6469811,\"is_sub_step\":false},{\"id\":8350444,\"route_id\":2518602,\"step_index\":\"1\",\"instruction\":\"Continue on US-78 W. Take I-40 W and I-30 W to US-70 W\\\/US-70 BUS in Hot Springs. Take exit 2 from US-270 W\\\/US-70 W\",\"distance\":653243,\"distance_unit\":\"m\",\"time\":\"21818\",\"latitude\":-90.1017077,\"longitude\":34.4261078,\"is_sub_step\":false},{\"id\":8350445,\"route_id\":2518602,\"step_index\":\"2\",\"instruction\":\"Drive to US-70 W in Choctaw County\",\"distance\":287734,\"distance_unit\":\"m\",\"time\":\"11735\",\"latitude\":-94.4482079,\"longitude\":34.1979062,\"is_sub_step\":false}]"', 953489, 953489, '29 minutes', 0, 'west', 'east', '[{"name":"Hightogy","description":"713 mi to destination","state":"Alabama","country":"US","full_address":"Hightogy, AL 35592","lat":"33.695111","lng":"-88.094751","fraction":0.1111111111111111,"type":"State","distance_km":2,"place_id":54750,"slug":"hightogy","hash":"s9axxnxr"},{"name":"Mantee","description":"Traveled 178 mi from origin","state":"Mississippi","country":"US","full_address":"Mantee, MS","lat":"33.731506","lng":"-89.055340","fraction":0.2222222222222222,"type":"City","distance_km":1,"place_id":21543,"slug":"mantee","hash":"qu9mwqp9"},{"name":"Holcomb","description":"535 mi to destination","state":"Mississippi","country":"US","full_address":"Holcomb, MS 38940","lat":"33.761056","lng":"-89.975143","fraction":0.3333333333333333,"type":"City","distance_km":1,"place_id":27627,"slug":"holcomb","hash":"4s5jwtlo"},{"name":"Beulah","description":"Traveled 357 mi from origin","state":"Mississippi","country":"US","full_address":"Beulah, MS 38726","lat":"33.786777","lng":"-90.979829","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":23562,"slug":"beulah","hash":"kuejmifv"},{"name":"Cornerville","description":"357 mi to destination","state":"Arkansas","country":"US","full_address":"Cornerville, AR 71667","lat":"33.844270","lng":"-91.940414","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":87762,"slug":"cornerville","hash":"drbfrumb"},{"name":"Sparkman","description":"Traveled 535 mi from origin","state":"Arkansas","country":"US","full_address":"Sparkman, AR 71763","lat":"33.916597","lng":"-92.847905","fraction":0.6666666666666666,"type":"City","distance_km":3,"place_id":20785,"slug":"sparkman","hash":"jft1jedz"},{"name":"Nashville","description":"178 mi to destination","state":"Arkansas","country":"US","full_address":"Nashville, AR 71852","lat":"33.948252","lng":"-93.847051","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":8036,"slug":"nashville","hash":"4deqps7d"},{"name":"Holly Creek","description":"Traveled 713 mi from origin","state":"Oklahoma","country":"US","full_address":"Holly Creek, OK 74745","lat":"33.978165","lng":"-94.816606","fraction":0.8888888888888888,"type":"State","distance_km":0,"place_id":59579,"slug":"holly-creek","hash":"ncyrtax3"}]', 1, 8, '{"distanceInMiles":592.4720692954876,"distanceMilesFormatted":"592.5 miles","distanceFormatted":"592.5 miles","distanceKmFormatted":"953 km","timeHours":9.533333333333333,"timeFormatted":"9 hours 32 minutes","avgSpeed":64,"routeDescriptors":["highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"west"}', null, 'wegra-n8arwc0l/unger-9fcqcn9y', 0, null, null, 0, '"[{\"name\":\"Hightogy\",\"description\":\"713 mi to destination\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Hightogy, AL 35592\",\"lat\":\"33.695111\",\"lng\":\"-88.094751\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":2,\"place_id\":54750,\"slug\":\"hightogy\",\"hash\":\"s9axxnxr\"},{\"name\":\"Mantee\",\"description\":\"Traveled 178 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Mantee, MS\",\"lat\":\"33.731506\",\"lng\":\"-89.055340\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":1,\"place_id\":21543,\"slug\":\"mantee\",\"hash\":\"qu9mwqp9\"},{\"name\":\"Holcomb\",\"description\":\"535 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Holcomb, MS 38940\",\"lat\":\"33.761056\",\"lng\":\"-89.975143\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":1,\"place_id\":27627,\"slug\":\"holcomb\",\"hash\":\"4s5jwtlo\"},{\"name\":\"Beulah\",\"description\":\"Traveled 357 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Beulah, MS 38726\",\"lat\":\"33.786777\",\"lng\":\"-90.979829\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":23562,\"slug\":\"beulah\",\"hash\":\"kuejmifv\"},{\"name\":\"Cornerville\",\"description\":\"357 mi to destination\",\"state\":\"Arkansas\",\"country\":\"US\",\"full_address\":\"Cornerville, AR 71667\",\"lat\":\"33.844270\",\"lng\":\"-91.940414\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":87762,\"slug\":\"cornerville\",\"hash\":\"drbfrumb\"},{\"name\":\"Sparkman\",\"description\":\"Traveled 535 mi from origin\",\"state\":\"Arkansas\",\"country\":\"US\",\"full_address\":\"Sparkman, AR 71763\",\"lat\":\"33.916597\",\"lng\":\"-92.847905\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":3,\"place_id\":20785,\"slug\":\"sparkman\",\"hash\":\"jft1jedz\"},{\"name\":\"Nashville\",\"description\":\"178 mi to destination\",\"state\":\"Arkansas\",\"country\":\"US\",\"full_address\":\"Nashville, AR 71852\",\"lat\":\"33.948252\",\"lng\":\"-93.847051\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":8036,\"slug\":\"nashville\",\"hash\":\"4deqps7d\"},{\"name\":\"Holly Creek\",\"description\":\"Traveled 713 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Holly Creek, OK 74745\",\"lat\":\"33.978165\",\"lng\":\"-94.816606\",\"fraction\":0.8888888888888888,\"type\":\"State\",\"distance_km\":0,\"place_id\":59579,\"slug\":\"holly-creek\",\"hash\":\"ncyrtax3\"}]"', 3, 889904, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 51761
      • 1: Wegra
      • 2: Wegra, AL 35130
      • 3: wegra
      • 4: n8arwc0l
      • 5: 33.634274
      • 6: -87.104165
      • 7: 
      • 8: Alabama
      • 9: US
      • 10: America/Chicago
      • 11: 67478
      • 12: Unger
      • 13: Unger, OK 74727
      • 14: unger
      • 15: 9fcqcn9y
      • 16: 34.026211
      • 17: -95.781916
      • 18: 
      • 19: Oklahoma
      • 20: US
      • 21: America/Chicago
      • 22: 2518602
      • 23: I-22 and US-70 W
      • 24: 953489
      • 25: m
      • 26: 34375
      • 27: 592.470413419
      • 28: 953489
      • 29: 9 hours 32 minutes
      • 30: 9 hours 32 minutes
      • 31: 953.489
      • 32: 953.5 km
      • 33: 
      • 34: 573
      • 35: 0
      • 36: No
      • 37: 592.5 mi
      • 38: 498.64677702349
      • 39: 0.49864677702349003
      • 40: "[{\"id\":8350443,\"route_id\":2518602,\"step_index\":\"0\",\"instruction\":\"Get on I-22\\\/US-78 W from Flat Creek Rd, Flat Top Rd and Sharon Blvd\",\"distance\":12512,\"distance_unit\":\"m\",\"time\":\"822\",\"latitude\":-87.0972966,\"longitude\":33.6469811,\"is_sub_step\":false},{\"id\":8350444,\"route_id\":2518602,\"step_index\":\"1\",\"instruction\":\"Continue on US-78 W. Take I-40 W and I-30 W to US-70 W\\\/US-70 BUS in Hot Springs. Take exit 2 from US-270 W\\\/US-70 W\",\"distance\":653243,\"distance_unit\":\"m\",\"time\":\"21818\",\"latitude\":-90.1017077,\"longitude\":34.4261078,\"is_sub_step\":false},{\"id\":8350445,\"route_id\":2518602,\"step_index\":\"2\",\"instruction\":\"Drive to US-70 W in Choctaw County\",\"distance\":287734,\"distance_unit\":\"m\",\"time\":\"11735\",\"latitude\":-94.4482079,\"longitude\":34.1979062,\"is_sub_step\":false}]"
      • 41: 953489
      • 42: 953489
      • 43: 29 minutes
      • 44: 0
      • 45: west
      • 46: east
      • 47: [{"name":"Hightogy","description":"713 mi to destination","state":"Alabama","country":"US","full_address":"Hightogy, AL 35592","lat":"33.695111","lng":"-88.094751","fraction":0.1111111111111111,"type":"State","distance_km":2,"place_id":54750,"slug":"hightogy","hash":"s9axxnxr"},{"name":"Mantee","description":"Traveled 178 mi from origin","state":"Mississippi","country":"US","full_address":"Mantee, MS","lat":"33.731506","lng":"-89.055340","fraction":0.2222222222222222,"type":"City","distance_km":1,"place_id":21543,"slug":"mantee","hash":"qu9mwqp9"},{"name":"Holcomb","description":"535 mi to destination","state":"Mississippi","country":"US","full_address":"Holcomb, MS 38940","lat":"33.761056","lng":"-89.975143","fraction":0.3333333333333333,"type":"City","distance_km":1,"place_id":27627,"slug":"holcomb","hash":"4s5jwtlo"},{"name":"Beulah","description":"Traveled 357 mi from origin","state":"Mississippi","country":"US","full_address":"Beulah, MS 38726","lat":"33.786777","lng":"-90.979829","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":23562,"slug":"beulah","hash":"kuejmifv"},{"name":"Cornerville","description":"357 mi to destination","state":"Arkansas","country":"US","full_address":"Cornerville, AR 71667","lat":"33.844270","lng":"-91.940414","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":87762,"slug":"cornerville","hash":"drbfrumb"},{"name":"Sparkman","description":"Traveled 535 mi from origin","state":"Arkansas","country":"US","full_address":"Sparkman, AR 71763","lat":"33.916597","lng":"-92.847905","fraction":0.6666666666666666,"type":"City","distance_km":3,"place_id":20785,"slug":"sparkman","hash":"jft1jedz"},{"name":"Nashville","description":"178 mi to destination","state":"Arkansas","country":"US","full_address":"Nashville, AR 71852","lat":"33.948252","lng":"-93.847051","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":8036,"slug":"nashville","hash":"4deqps7d"},{"name":"Holly Creek","description":"Traveled 713 mi from origin","state":"Oklahoma","country":"US","full_address":"Holly Creek, OK 74745","lat":"33.978165","lng":"-94.816606","fraction":0.8888888888888888,"type":"State","distance_km":0,"place_id":59579,"slug":"holly-creek","hash":"ncyrtax3"}]
      • 48: 1
      • 49: 8
      • 50: {"distanceInMiles":592.4720692954876,"distanceMilesFormatted":"592.5 miles","distanceFormatted":"592.5 miles","distanceKmFormatted":"953 km","timeHours":9.533333333333333,"timeFormatted":"9 hours 32 minutes","avgSpeed":64,"routeDescriptors":["highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"west"}
      • 51: 
      • 52: wegra-n8arwc0l/unger-9fcqcn9y
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Hightogy\",\"description\":\"713 mi to destination\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Hightogy, AL 35592\",\"lat\":\"33.695111\",\"lng\":\"-88.094751\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":2,\"place_id\":54750,\"slug\":\"hightogy\",\"hash\":\"s9axxnxr\"},{\"name\":\"Mantee\",\"description\":\"Traveled 178 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Mantee, MS\",\"lat\":\"33.731506\",\"lng\":\"-89.055340\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":1,\"place_id\":21543,\"slug\":\"mantee\",\"hash\":\"qu9mwqp9\"},{\"name\":\"Holcomb\",\"description\":\"535 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Holcomb, MS 38940\",\"lat\":\"33.761056\",\"lng\":\"-89.975143\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":1,\"place_id\":27627,\"slug\":\"holcomb\",\"hash\":\"4s5jwtlo\"},{\"name\":\"Beulah\",\"description\":\"Traveled 357 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Beulah, MS 38726\",\"lat\":\"33.786777\",\"lng\":\"-90.979829\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":23562,\"slug\":\"beulah\",\"hash\":\"kuejmifv\"},{\"name\":\"Cornerville\",\"description\":\"357 mi to destination\",\"state\":\"Arkansas\",\"country\":\"US\",\"full_address\":\"Cornerville, AR 71667\",\"lat\":\"33.844270\",\"lng\":\"-91.940414\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":87762,\"slug\":\"cornerville\",\"hash\":\"drbfrumb\"},{\"name\":\"Sparkman\",\"description\":\"Traveled 535 mi from origin\",\"state\":\"Arkansas\",\"country\":\"US\",\"full_address\":\"Sparkman, AR 71763\",\"lat\":\"33.916597\",\"lng\":\"-92.847905\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":3,\"place_id\":20785,\"slug\":\"sparkman\",\"hash\":\"jft1jedz\"},{\"name\":\"Nashville\",\"description\":\"178 mi to destination\",\"state\":\"Arkansas\",\"country\":\"US\",\"full_address\":\"Nashville, AR 71852\",\"lat\":\"33.948252\",\"lng\":\"-93.847051\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":8036,\"slug\":\"nashville\",\"hash\":\"4deqps7d\"},{\"name\":\"Holly Creek\",\"description\":\"Traveled 713 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Holly Creek, OK 74745\",\"lat\":\"33.978165\",\"lng\":\"-94.816606\",\"fraction\":0.8888888888888888,\"type\":\"State\",\"distance_km\":0,\"place_id\":59579,\"slug\":\"holly-creek\",\"hash\":\"ncyrtax3\"}]"
      • 58: 3
      • 59: 889904
      • 60: 2025-05-18 09:04:25
      • 61: 2025-05-18 09:04:25
      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#70distance460μsselect exists(select "id" from "routes" where "origin_destination_id" = 889904 limit 1) as "exists"
      Bindings
      • 0: 889904
      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#1186distance660μsselect * from "routes" where "routes"."origin_destination_id" = 889904 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889904
      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#1186distance510μsselect * from "route_directions" where "route_directions"."route_id" in (2518602, 2518603, 2518604) 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#225distance850μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:25' where "id" = 2518602
      Bindings
      • 0: 2025-05-18 09:04:25
      • 1: 2518602
      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#235distance390μsselect * from "origin_destinations" where "origin_destinations"."id" = 889904 limit 1
      Bindings
      • 0: 889904
      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#244distance430μsselect * from "places" where "places"."id" = 51761 limit 1
      Bindings
      • 0: 51761
      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#245distance400μsselect * from "places" where "places"."id" = 67478 limit 1
      Bindings
      • 0: 67478
      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#24distance350μsselect * from "route_waypoints" where "route_id" = 2518602
      Bindings
      • 0: 2518602
      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#28distance400μsselect * from "places" where "places"."id" = 54750 limit 1
      Bindings
      • 0: 54750
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance440μsselect * from "locations" where "locations"."id" in (54750)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance370μsselect * from "states" where "states"."id" in (9)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance330μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance400μsselect * from "places" where "places"."id" = 21543 limit 1
      Bindings
      • 0: 21543
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance380μsselect * from "locations" where "locations"."id" in (21543)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance560μsselect * from "cities" where "cities"."id" in (14239)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance340μsselect * from "states" where "states"."id" in (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance360μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance390μsselect * from "places" where "places"."id" = 27627 limit 1
      Bindings
      • 0: 27627
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance320μsselect * from "locations" where "locations"."id" in (27627)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance330μsselect * from "cities" where "cities"."id" in (8164)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance260μsselect * from "states" where "states"."id" in (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance320μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance330μsselect * from "places" where "places"."id" = 23562 limit 1
      Bindings
      • 0: 23562
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance300μsselect * from "locations" where "locations"."id" in (23562)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance280μsselect * from "cities" where "cities"."id" in (7227)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance320μsselect * from "states" where "states"."id" in (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance310μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance320μsselect * from "places" where "places"."id" = 87762 limit 1
      Bindings
      • 0: 87762
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance300μsselect * from "locations" where "locations"."id" in (87762)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance300μsselect * from "cities" where "cities"."id" in (21357)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance270μsselect * from "states" where "states"."id" in (28)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance320μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • distance350μsselect * from "places" where "places"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" in (20785)
    • distance280μsselect * from "cities" where "cities"."id" in (13819)
    • distance290μsselect * from "states" where "states"."id" in (28)
    • distance300μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance330μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (8036)
    • distance260μsselect * from "cities" where "cities"."id" in (61)
    • distance300μsselect * from "states" where "states"."id" in (28)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance250μsselect * from "locations" where "locations"."id" in (59579)
    • distance240μsselect * from "states" where "states"."id" in (31)
    • distance270μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance490μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance360μsselect * from "route_waypoints" where "route_id" = ?
    • distance310μsselect * from "places" where "places"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" in (54750)
    • distance250μsselect * from "states" where "states"."id" in (9)
    • distance270μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance330μsselect * from "places" where "places"."id" = ? limit 1
    • distance250μsselect * from "locations" where "locations"."id" in (21543)
    • distance270μsselect * from "cities" where "cities"."id" in (14239)
    • distance240μsselect * from "states" where "states"."id" in (43)
    • distance380μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance310μsselect * from "places" where "places"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" in (27627)
    • distance260μsselect * from "cities" where "cities"."id" in (8164)
    • distance230μsselect * from "states" where "states"."id" in (43)
    • distance270μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance300μsselect * from "places" where "places"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" in (23562)
    • distance260μsselect * from "cities" where "cities"."id" in (7227)
    • distance240μsselect * from "states" where "states"."id" in (43)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance300μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (87762)
    • distance250μsselect * from "cities" where "cities"."id" in (21357)
    • distance260μsselect * from "states" where "states"."id" in (28)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance300μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (20785)
    • distance250μsselect * from "cities" where "cities"."id" in (13819)
    • distance280μsselect * from "states" where "states"."id" in (28)
    • distance270μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance250μsselect * from "locations" where "locations"."id" in (8036)
    • distance250μsselect * from "cities" where "cities"."id" in (61)
    • distance270μsselect * from "states" where "states"."id" in (28)
    • distance270μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance340μsselect * from "places" where "places"."id" = ? limit 1
    • distance240μsselect * from "locations" where "locations"."id" in (59579)
    • distance250μsselect * from "states" where "states"."id" in (31)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance270μsselect * from "states" where "states"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance490μsselect * from "states" where "states"."id" = ? limit 1
    • distance460μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance440μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance1.17msupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.92msselect * from "images" where "images"."place_id" in (51761)
    • distance480μsselect * from "places" where "places"."id" = ? limit 1
    • distance23.43msselect * from "images" where "images"."place_id" in (67478)
    • distance520μsselect * from "routes" where "origin_destination_id" = ?
    • distance480μ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"
    • distance360μsselect * from "route_directions" where "route_directions"."route_id" in (2518602, 2518603, 2518604) order by "step_index" asc, "step_index" asc
    • distance320μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance280μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance310μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance590μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance390μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance310μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance480μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\Place
    26Place.php#?
    App\Models\RouteWaypoint
    24RouteWaypoint.php#?
    App\Models\RouteDirection
    21RouteDirection.php#?
    App\Models\Location
    20Location.php#?
    App\Models\State
    20State.php#?
    App\Models\Country
    18Country.php#?
    App\Models\City
    12City.php#?
    App\Models\Route
    7Route.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:25GET/distance/wegra-n8arwc0l/unger-9fcqcn9y402175153