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

Just a moment while we calculate your route...

Distance from Sampit to Blue Ridge

Driving Distance
419.2 mi • 674.7 km
Flying Distance
297.4 mi • 478.7 km
A
B
Leaflet © OpenStreetMap contributors
57 mph avg speed
West direction
6 hr 53 min travel time

Route Information

The driving distance from Sampit, South Carolina to Blue Ridge, Georgia is 419.2 mi (674.7 km)

The straight-line (air) distance is 297.4 mi (478.7 km)

The estimated flight time is 0 hr 36 min

The estimated travel time by road is 6 hours 53 minutes

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

Location Details

Origin:


No image available
Place Sampit
State/Province South Carolina
Country US
Latitude 33.364056
Longitude -79.458672
GPS 33.364056° N, 79.458672° W
Local Time 5:04 AM
Timezone America/New_York

Destination:

Blue Ridge
Place Blue Ridge
State/Province Georgia
Country US
Latitude 34.863972
Longitude -84.324087
GPS 34.863972° N, 84.324087° W
Local Time 5:04 AM
Timezone America/New_York

Journey Summary

Traveling from Sampit, South Carolina to Blue Ridge, Georgia covers 419.2 mi (674.7 km) in a west direction. This highway, long-distance route typically takes 6 hours 53 minutes under normal conditions.

Drivers have 2 route options between these locations (380.5-419.2 miles / 612-675 km). The primary route shown here saves 22 minutes compared to alternatives.

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

Available Routes

I-26 W and US-74 W
419.2 mi 6 hours 53 minutes
Shortest
I-26 W
380.5 mi 6 hours 32 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

Sampit
South Carolina , US
Edwards
South Carolina, US
31.8 mi
Fulton Crossroads
South Carolina, US
65.6 mi
Gaston
South Carolina, US
99.6 mi
Mt Willing
South Carolina, US
134.5 mi
Greenwood
South Carolina, US
165.5 mi
Starr
South Carolina, US
198.4 mi
Eastanollee
Georgia, US
231.8 mi
Helen
Georgia, US
261.5 mi
Blue Ridge
Georgia , US
Messages30RequestTimelineExceptionsViews2Queries169Models148MailsGate
SettingsRequest history2.37sRequest 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/sampit-ftk76sio/blue-ridge-zo4z6umn
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:46] LOG.warning: No denormalized route found for origin-destination ID: 889934
  • infolog[09:04:46] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 85...
  • infolog[09:04:46] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:47] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:48] LOG.info: Processing route #1 data for origin-destination ID: 889934 { "origin": "Sam...
  • infolog[09:04:48] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:48] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:48] LOG.info: Ignoring 9 nested sub-directions for direction index 0
  • debuglog[09:04:48] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:48] LOG.info: Ignoring 13 nested sub-directions for direction index 1
  • debuglog[09:04:48] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:48] LOG.info: Ignoring 21 nested sub-directions for direction index 2
  • infolog[09:04:48] LOG.info: Saved 3 directions for route ID: 2518678
  • infolog[09:04:48] LOG.info: Found a shorter route: 612335 meters for route ID: 2518678
  • infolog[09:04:48] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:48] LOG.info: Processing route #2 data for origin-destination ID: 889934 { "origin": "Sam...
  • infolog[09:04:48] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:48] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:48] LOG.info: Ignoring 9 nested sub-directions for direction index 0
  • debuglog[09:04:48] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:48] LOG.info: Ignoring 5 nested sub-directions for direction index 1
  • debuglog[09:04:48] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:48] LOG.info: Ignoring 9 nested sub-directions for direction index 2
  • infolog[09:04:48] LOG.info: Saved 3 directions for route ID: 2518679
  • infolog[09:04:48] LOG.info: Successfully denormalized route data { "origin_destination_id": 889934, ...
  • infolog[09:04:48] LOG.info: Saved 2 routes for origin-destination ID: 889934
  • infolog[09:04:48] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518678, ...
  • infolog[09:04:48] LOG.info: Incremented view count for route { "id": 2518678, "name": "I-26 W", ...
  • infolog[09:04:48] LOG.info: Updated denormalized route for route { "route_id": 2518678, "views": 1 ...
  • infolog[09:04:48] LOG.info: Found existing routes { "route_count": 2, "default_route_id": 2518678, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/sampit-ftk76sio/blue-ridge-zo4z6umn
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
2.37s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "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"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "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"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a30548ce4c985-IAD"
  ]
]
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:48 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "sRDo7bpOU4NBSIUh02uG8Yij0YNHN4aXJqArDWx0"
]
  • Booting (7.16ms)time
  • Application (2.36s)time
  • Routing (335μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (35μs)
  • 1 x Application (99.7%)
    2.36s
    1 x Booting (0.3%)
    7.16ms
    1 x Routing (0.01%)
    335μs
    1 x Preparing Response (0%)
    35μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    169 statements were executed (97 duplicates)Show only duplicatesdistance946ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 69 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance12.74msselect * from "sessions" where "id" = '6OzzdlWelkeWg4I0tmPFQrzIArtKhQ6oKZNrnqCn' limit 1
      Bindings
      • 0: 6OzzdlWelkeWg4I0tmPFQrzIArtKhQ6oKZNrnqCn
      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#548distance9.18msselect * from "places" where "slug" = 'sampit' and ("hash" = 'ftk76sio') limit 1
      Bindings
      • 0: sampit
      • 1: ftk76sio
      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#548distance490μsselect * from "places" where "slug" = 'blue-ridge' and ("hash" = 'zo4z6umn') limit 1
      Bindings
      • 0: blue-ridge
      • 1: zo4z6umn
      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#104distance690μsselect * from "origin_destinations" where ("origin_id" = 85471 and "destination_id" = 14517) limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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.99msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (85471, 14517, '2025-05-18 09:04:46', '2025-05-18 09:04:46') returning "id"
      Bindings
      • 0: 85471
      • 1: 14517
      • 2: 2025-05-18 09:04:46
      • 3: 2025-05-18 09:04:46
      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.31msselect * from "denormalised_routes" where "origin_destination_id" = 889934 limit 1
      Bindings
      • 0: 889934
      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#70distance520μsselect exists(select "id" from "routes" where "origin_destination_id" = 889934 limit 1) as "exists"
      Bindings
      • 0: 889934
      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#158distance750μsdelete from "routes" where "origin_destination_id" = 889934
      Bindings
      • 0: 889934
      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#172distance430μsselect * from "places" where "places"."id" = 85471 limit 1
      Bindings
      • 0: 85471
      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#173distance320μsselect * from "places" where "places"."id" = 14517 limit 1
      Bindings
      • 0: 14517
      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#225distance1.59msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889934, 'I-26 W', 612335, 'm', 23546, 1, 'This route has tolls.', 33.0832651, 34.8937586, null, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 889934
      • 1: I-26 W
      • 2: 612335
      • 3: m
      • 4: 23546
      • 5: 1
      • 6: This route has tolls.
      • 7: 33.0832651
      • 8: 34.8937586
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:48
      • 12: 2025-05-18 09:04:48
      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.19msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518678, 0, 'Take US-17 ALT S and Cooper Store Rd to I-26 W in Berkeley County', 88188, 'm', 3888, -79.83425905, 33.2236694, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 0
      • 2: Take US-17 ALT S and Cooper Store Rd to I-26 W in Berkeley County
      • 3: 88188
      • 4: m
      • 5: 3888
      • 6: -79.83425904999999
      • 7: 33.223669400000006
      • 8: 0
      • 9: 2025-05-18 09:04:48
      • 10: 2025-05-18 09:04:48
      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#548distance740μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518678, 1, 'Follow I-26 W, I-385 N and I-85 S to GA-17 N in Franklin County. Take exit 173 from I-85 S', 373561, 'm', 12325, -81.6677288, 33.9295686, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 1
      • 2: Follow I-26 W, I-385 N and I-85 S to GA-17 N in Franklin County. Take exit 173 from I-85 S
      • 3: 373561
      • 4: m
      • 5: 12325
      • 6: -81.66772879999999
      • 7: 33.929568599999996
      • 8: 0
      • 9: 2025-05-18 09:04:48
      • 10: 2025-05-18 09:04:48
      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#548distance710μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518678, 2, 'Continue on GA-17 N. Take GA-348 W, US-129 N/US-19 N and US-76 W to E 1st St/Old Hwy 76/Old U.S. 76 in Blue Ridge', 150586, 'm', 7333, -83.7248097, 34.6706397, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 2
      • 2: Continue on GA-17 N. Take GA-348 W, US-129 N/US-19 N and US-76 W to E 1st St/Old Hwy 76/Old U.S. 76 in Blue Ridge
      • 3: 150586
      • 4: m
      • 5: 7333
      • 6: -83.7248097
      • 7: 34.670639699999995
      • 8: 0
      • 9: 2025-05-18 09:04:48
      • 10: 2025-05-18 09:04:48
      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#225distance840μsinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889934, 'I-26 W and US-74 W', 674683, 'm', 24807, 0, 'No', 33.0832651, 35.559738, null, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 889934
      • 1: I-26 W and US-74 W
      • 2: 674683
      • 3: m
      • 4: 24807
      • 5: 0
      • 6: No
      • 7: 33.0832651
      • 8: 35.559737999999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:48
      • 12: 2025-05-18 09:04:48
      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#548distance810μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518679, 0, 'Take US-17 ALT S and Cooper Store Rd to I-26 W in Berkeley County', 88188, 'm', 3888, -79.83425905, 33.2236694, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518679
      • 1: 0
      • 2: Take US-17 ALT S and Cooper Store Rd to I-26 W in Berkeley County
      • 3: 88188
      • 4: m
      • 5: 3888
      • 6: -79.83425904999999
      • 7: 33.223669400000006
      • 8: 0
      • 9: 2025-05-18 09:04:48
      • 10: 2025-05-18 09:04:48
      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#548distance700μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518679, 1, 'Follow I-26 W to US-74 W/Great Smoky Mountains Expy in Haywood County. Take exit 27 from I-40/US-74 W', 406354, 'm', 13313, -81.5633239, 34.3217077, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518679
      • 1: 1
      • 2: Follow I-26 W to US-74 W/Great Smoky Mountains Expy in Haywood County. Take exit 27 from I-40/US-74 W
      • 3: 406354
      • 4: m
      • 5: 13313
      • 6: -81.5633239
      • 7: 34.3217077
      • 8: 0
      • 9: 2025-05-18 09:04:48
      • 10: 2025-05-18 09:04:48
      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#548distance710μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518679, 2, 'Continue on US-74 W. Drive to E 1st St/Old Hwy 76/Old U.S. 76 in Blue Ridge', 180141, 'm', 7606, -83.6205873, 35.2038245, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518679
      • 1: 2
      • 2: Continue on US-74 W. Drive to E 1st St/Old Hwy 76/Old U.S. 76 in Blue Ridge
      • 3: 180141
      • 4: m
      • 5: 7606
      • 6: -83.6205873
      • 7: 35.203824499999996
      • 8: 0
      • 9: 2025-05-18 09:04:48
      • 10: 2025-05-18 09:04:48
      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#24distance580μsselect * from "route_waypoints" where "route_id" = 2518678
      Bindings
      • 0: 2518678
      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#103distance300μsselect * from "origin_destinations" where "origin_destinations"."id" = 889934 limit 1
      Bindings
      • 0: 889934
      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#103distance350μsselect * from "places" where "places"."id" = 85471 limit 1
      Bindings
      • 0: 85471
      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" = 14517 limit 1
      Bindings
      • 0: 14517
      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#226distance112msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.530713333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.999273666667)) + sin(radians(33.530713333333)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance820μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 38801 limit 1
      Bindings
      • 0: 38801
      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#226distance88.2msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.697370666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-80.539875333333)) + sin(radians(33.697370666667)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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" = 55104 limit 1
      Bindings
      • 0: 55104
      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#226distance94.04msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.864028)) * cos(radians(lat)) * cos(radians(lng) - radians(-81.080477)) + sin(radians(33.864028)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 12221 limit 1
      Bindings
      • 0: 12221
      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#226distance108msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.030685333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-81.621078666667)) + sin(radians(34.030685333333)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance750μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 83523 limit 1
      Bindings
      • 0: 83523
      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(34.197342666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-82.161680333333)) + sin(radians(34.197342666667)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance620μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 2161 limit 1
      Bindings
      • 0: 2161
      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.8msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.364)) * cos(radians(lat)) * cos(radians(lng) - radians(-82.702282)) + sin(radians(34.364)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 26403 limit 1
      Bindings
      • 0: 26403
      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(34.530657333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-83.242883666667)) + sin(radians(34.530657333333)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 49226 limit 1
      Bindings
      • 0: 49226
      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(34.697314666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-83.783485333333)) + sin(radians(34.697314666667)) * 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" != 85471 and "places"."id" != 14517 order by "distance" asc limit 1
      Bindings
      • 0: 85471
      • 1: 14517
      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#158distance510μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 21009 limit 1
      Bindings
      • 0: 21009
      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#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 38801) limit 1
      Bindings
      • 0: 2518678
      • 1: 38801
      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 (2518678, 38801, 0.11111111111111, 3, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 38801
      • 2: 0.1111111111111111
      • 3: 3
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance290μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 55104) limit 1
      Bindings
      • 0: 2518678
      • 1: 55104
      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#78distance840μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 55104, 0.22222222222222, 3, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 55104
      • 2: 0.2222222222222222
      • 3: 3
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance290μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 12221) limit 1
      Bindings
      • 0: 2518678
      • 1: 12221
      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#78distance750μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 12221, 0.33333333333333, 3, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 12221
      • 2: 0.3333333333333333
      • 3: 3
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance290μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 83524) limit 1
      Bindings
      • 0: 2518678
      • 1: 83524
      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#78distance680μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 83524, 0.44444444444444, 3, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 83524
      • 2: 0.4444444444444444
      • 3: 3
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance290μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 2161) limit 1
      Bindings
      • 0: 2518678
      • 1: 2161
      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#78distance830μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 2161, 0.55555555555556, 0, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 2161
      • 2: 0.5555555555555556
      • 3: 0
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 26403) limit 1
      Bindings
      • 0: 2518678
      • 1: 26403
      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#78distance930μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 26403, 0.66666666666667, 1, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 26403
      • 2: 0.6666666666666666
      • 3: 1
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance270μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 49226) limit 1
      Bindings
      • 0: 2518678
      • 1: 49226
      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#78distance760μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 49226, 0.77777777777778, 1, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 49226
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#78distance280μsselect * from "route_waypoints" where ("route_id" = 2518678 and "place_id" = 21009) limit 1
      Bindings
      • 0: 2518678
      • 1: 21009
      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#78distance750μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518678, 21009, 0.88888888888889, 3, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 2518678
      • 1: 21009
      • 2: 0.8888888888888888
      • 3: 3
      • 4: 2025-05-18 09:04:48
      • 5: 2025-05-18 09:04:48
      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#366distance460μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518678 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518678
      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#45distance440μsselect * from "denormalised_routes" where "origin_destination_id" = 889934 limit 1
      Bindings
      • 0: 889934
      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#123distance530μsselect * from "route_directions" where "route_directions"."route_id" = 2518678 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518678
      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#198distance320μsselect * from "locations" where "locations"."id" = 85471 limit 1
      Bindings
      • 0: 85471
      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#215distance340μsselect * from "states" where "states"."id" = 13 limit 1
      Bindings
      • 0: 13
      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#330distance290μ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#198distance270μsselect * from "locations" where "locations"."id" = 14517 limit 1
      Bindings
      • 0: 14517
      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#198distance420μsselect * from "cities" where "cities"."id" = 7290 limit 1
      Bindings
      • 0: 7290
      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#215distance260μsselect * from "states" where "states"."id" = 25 limit 1
      Bindings
      • 0: 25
      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#330distance290μ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.73msinsert 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 (85471, 'Sampit', 'Sampit, SC 29440', 'sampit', 'ftk76sio', 33.364056, -79.458672, null, 'South Carolina', 'US', 'America/New_York', 14517, 'Blue Ridge', 'Blue Ridge, GA 30513', 'blue-ridge', 'zo4z6umn', 34.863972, -84.324087, 'Blue Ridge', 'Georgia', 'US', 'America/New_York', 2518678, 'I-26 W', 612335, 'm', 23546, 380.487211285, 612335, '6 hours 32 minutes', '6 hours 32 minutes', 612.335, '612.3 km', null, 392, 1, 'This route has tolls.', '380.5 mi', 296.94683252322, 0.29694683252322, '"[{\"id\":8350682,\"route_id\":2518678,\"step_index\":\"0\",\"instruction\":\"Take US-17 ALT S and Cooper Store Rd to I-26 W in Berkeley County\",\"distance\":88188,\"distance_unit\":\"m\",\"time\":\"3888\",\"latitude\":-79.8342591,\"longitude\":33.2236694,\"is_sub_step\":false},{\"id\":8350683,\"route_id\":2518678,\"step_index\":\"1\",\"instruction\":\"Follow I-26 W, I-385 N and I-85 S to GA-17 N in Franklin County. Take exit 173 from I-85 S\",\"distance\":373561,\"distance_unit\":\"m\",\"time\":\"12325\",\"latitude\":-81.6677288,\"longitude\":33.9295686,\"is_sub_step\":false},{\"id\":8350684,\"route_id\":2518678,\"step_index\":\"2\",\"instruction\":\"Continue on GA-17 N. Take GA-348 W, US-129 N\\\/US-19 N and US-76 W to E 1st St\\\/Old Hwy 76\\\/Old U.S. 76 in Blue Ridge\",\"distance\":150586,\"distance_unit\":\"m\",\"time\":\"7333\",\"latitude\":-83.7248097,\"longitude\":34.6706397,\"is_sub_step\":false}]"', 612335, 612335, '22 minutes', 0, 'west', 'east', '[{"name":"Edwards","description":"425 mi to destination","state":"South Carolina","country":"US","full_address":"Edwards, SC 29590","lat":"33.564332","lng":"-79.954798","fraction":0.1111111111111111,"type":"State","distance_km":3,"place_id":38801,"slug":"edwards","hash":"hp021ggw"},{"name":"Fulton Crossroads","description":"Traveled 106 mi from origin","state":"South Carolina","country":"US","full_address":"Fulton Crossroads, SC 29125","lat":"33.727938","lng":"-80.510363","fraction":0.2222222222222222,"type":"State","distance_km":3,"place_id":55104,"slug":"fulton-crossroads","hash":"6m857wjf"},{"name":"Gaston","description":"319 mi to destination","state":"South Carolina","country":"US","full_address":"Gaston, SC 29053","lat":"33.817097","lng":"-81.100929","fraction":0.3333333333333333,"type":"City","distance_km":3,"place_id":12221,"slug":"gaston","hash":"vpfntohj"},{"name":"Mt Willing","description":"Traveled 212 mi from origin","state":"South Carolina","country":"US","full_address":"Mt Willing, SC 29138","lat":"34.004304","lng":"-81.667884","fraction":0.4444444444444444,"type":"State","distance_km":3,"place_id":83524,"slug":"mt-willing","hash":"2509pmkt"},{"name":"Greenwood","description":"212 mi to destination","state":"South Carolina","country":"US","full_address":"Greenwood, SC","lat":"34.195400","lng":"-82.161788","fraction":0.5555555555555556,"type":"City","distance_km":0,"place_id":2161,"slug":"greenwood","hash":"u9zowr92"},{"name":"Starr","description":"Traveled 319 mi from origin","state":"South Carolina","country":"US","full_address":"Starr, SC 29684","lat":"34.377051","lng":"-82.695689","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":26403,"slug":"starr","hash":"8r1nb4ul"},{"name":"Eastanollee","description":"106 mi to destination","state":"Georgia","country":"US","full_address":"Eastanollee, GA 30538","lat":"34.520378","lng":"-83.255437","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":49226,"slug":"eastanollee","hash":"6mj61cdq"},{"name":"Helen","description":"Traveled 425 mi from origin","state":"Georgia","country":"US","full_address":"Helen, GA 30545","lat":"34.701484","lng":"-83.731568","fraction":0.8888888888888888,"type":"City","distance_km":3,"place_id":21009,"slug":"helen","hash":"2zhsbez8"}]', 1, 8, '{"distanceInMiles":380.4882746964594,"distanceMilesFormatted":"380.5 miles","distanceFormatted":"380.5 miles","distanceKmFormatted":"612 km","timeHours":6.533333333333333,"timeFormatted":"6 hours 32 minutes","avgSpeed":57,"routeDescriptors":["highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"west"}', null, 'sampit-ftk76sio/blue-ridge-zo4z6umn', 0, null, null, 0, '"[{\"name\":\"Edwards\",\"description\":\"425 mi to destination\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Edwards, SC 29590\",\"lat\":\"33.564332\",\"lng\":\"-79.954798\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":3,\"place_id\":38801,\"slug\":\"edwards\",\"hash\":\"hp021ggw\"},{\"name\":\"Fulton Crossroads\",\"description\":\"Traveled 106 mi from origin\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Fulton Crossroads, SC 29125\",\"lat\":\"33.727938\",\"lng\":\"-80.510363\",\"fraction\":0.2222222222222222,\"type\":\"State\",\"distance_km\":3,\"place_id\":55104,\"slug\":\"fulton-crossroads\",\"hash\":\"6m857wjf\"},{\"name\":\"Gaston\",\"description\":\"319 mi to destination\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Gaston, SC 29053\",\"lat\":\"33.817097\",\"lng\":\"-81.100929\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":3,\"place_id\":12221,\"slug\":\"gaston\",\"hash\":\"vpfntohj\"},{\"name\":\"Mt Willing\",\"description\":\"Traveled 212 mi from origin\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Mt Willing, SC 29138\",\"lat\":\"34.004304\",\"lng\":\"-81.667884\",\"fraction\":0.4444444444444444,\"type\":\"State\",\"distance_km\":3,\"place_id\":83524,\"slug\":\"mt-willing\",\"hash\":\"2509pmkt\"},{\"name\":\"Greenwood\",\"description\":\"212 mi to destination\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Greenwood, SC\",\"lat\":\"34.195400\",\"lng\":\"-82.161788\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":0,\"place_id\":2161,\"slug\":\"greenwood\",\"hash\":\"u9zowr92\"},{\"name\":\"Starr\",\"description\":\"Traveled 319 mi from origin\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Starr, SC 29684\",\"lat\":\"34.377051\",\"lng\":\"-82.695689\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":26403,\"slug\":\"starr\",\"hash\":\"8r1nb4ul\"},{\"name\":\"Eastanollee\",\"description\":\"106 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Eastanollee, GA 30538\",\"lat\":\"34.520378\",\"lng\":\"-83.255437\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":49226,\"slug\":\"eastanollee\",\"hash\":\"6mj61cdq\"},{\"name\":\"Helen\",\"description\":\"Traveled 425 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Helen, GA 30545\",\"lat\":\"34.701484\",\"lng\":\"-83.731568\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":3,\"place_id\":21009,\"slug\":\"helen\",\"hash\":\"2zhsbez8\"}]"', 3, 889934, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 85471
      • 1: Sampit
      • 2: Sampit, SC 29440
      • 3: sampit
      • 4: ftk76sio
      • 5: 33.364056
      • 6: -79.458672
      • 7: 
      • 8: South Carolina
      • 9: US
      • 10: America/New_York
      • 11: 14517
      • 12: Blue Ridge
      • 13: Blue Ridge, GA 30513
      • 14: blue-ridge
      • 15: zo4z6umn
      • 16: 34.863972
      • 17: -84.324087
      • 18: Blue Ridge
      • 19: Georgia
      • 20: US
      • 21: America/New_York
      • 22: 2518678
      • 23: I-26 W
      • 24: 612335
      • 25: m
      • 26: 23546
      • 27: 380.487211285
      • 28: 612335
      • 29: 6 hours 32 minutes
      • 30: 6 hours 32 minutes
      • 31: 612.335
      • 32: 612.3 km
      • 33: 
      • 34: 392
      • 35: 1
      • 36: This route has tolls.
      • 37: 380.5 mi
      • 38: 296.94683252322466
      • 39: 0.2969468325232247
      • 40: "[{\"id\":8350682,\"route_id\":2518678,\"step_index\":\"0\",\"instruction\":\"Take US-17 ALT S and Cooper Store Rd to I-26 W in Berkeley County\",\"distance\":88188,\"distance_unit\":\"m\",\"time\":\"3888\",\"latitude\":-79.8342591,\"longitude\":33.2236694,\"is_sub_step\":false},{\"id\":8350683,\"route_id\":2518678,\"step_index\":\"1\",\"instruction\":\"Follow I-26 W, I-385 N and I-85 S to GA-17 N in Franklin County. Take exit 173 from I-85 S\",\"distance\":373561,\"distance_unit\":\"m\",\"time\":\"12325\",\"latitude\":-81.6677288,\"longitude\":33.9295686,\"is_sub_step\":false},{\"id\":8350684,\"route_id\":2518678,\"step_index\":\"2\",\"instruction\":\"Continue on GA-17 N. Take GA-348 W, US-129 N\\\/US-19 N and US-76 W to E 1st St\\\/Old Hwy 76\\\/Old U.S. 76 in Blue Ridge\",\"distance\":150586,\"distance_unit\":\"m\",\"time\":\"7333\",\"latitude\":-83.7248097,\"longitude\":34.6706397,\"is_sub_step\":false}]"
      • 41: 612335
      • 42: 612335
      • 43: 22 minutes
      • 44: 0
      • 45: west
      • 46: east
      • 47: [{"name":"Edwards","description":"425 mi to destination","state":"South Carolina","country":"US","full_address":"Edwards, SC 29590","lat":"33.564332","lng":"-79.954798","fraction":0.1111111111111111,"type":"State","distance_km":3,"place_id":38801,"slug":"edwards","hash":"hp021ggw"},{"name":"Fulton Crossroads","description":"Traveled 106 mi from origin","state":"South Carolina","country":"US","full_address":"Fulton Crossroads, SC 29125","lat":"33.727938","lng":"-80.510363","fraction":0.2222222222222222,"type":"State","distance_km":3,"place_id":55104,"slug":"fulton-crossroads","hash":"6m857wjf"},{"name":"Gaston","description":"319 mi to destination","state":"South Carolina","country":"US","full_address":"Gaston, SC 29053","lat":"33.817097","lng":"-81.100929","fraction":0.3333333333333333,"type":"City","distance_km":3,"place_id":12221,"slug":"gaston","hash":"vpfntohj"},{"name":"Mt Willing","description":"Traveled 212 mi from origin","state":"South Carolina","country":"US","full_address":"Mt Willing, SC 29138","lat":"34.004304","lng":"-81.667884","fraction":0.4444444444444444,"type":"State","distance_km":3,"place_id":83524,"slug":"mt-willing","hash":"2509pmkt"},{"name":"Greenwood","description":"212 mi to destination","state":"South Carolina","country":"US","full_address":"Greenwood, SC","lat":"34.195400","lng":"-82.161788","fraction":0.5555555555555556,"type":"City","distance_km":0,"place_id":2161,"slug":"greenwood","hash":"u9zowr92"},{"name":"Starr","description":"Traveled 319 mi from origin","state":"South Carolina","country":"US","full_address":"Starr, SC 29684","lat":"34.377051","lng":"-82.695689","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":26403,"slug":"starr","hash":"8r1nb4ul"},{"name":"Eastanollee","description":"106 mi to destination","state":"Georgia","country":"US","full_address":"Eastanollee, GA 30538","lat":"34.520378","lng":"-83.255437","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":49226,"slug":"eastanollee","hash":"6mj61cdq"},{"name":"Helen","description":"Traveled 425 mi from origin","state":"Georgia","country":"US","full_address":"Helen, GA 30545","lat":"34.701484","lng":"-83.731568","fraction":0.8888888888888888,"type":"City","distance_km":3,"place_id":21009,"slug":"helen","hash":"2zhsbez8"}]
      • 48: 1
      • 49: 8
      • 50: {"distanceInMiles":380.4882746964594,"distanceMilesFormatted":"380.5 miles","distanceFormatted":"380.5 miles","distanceKmFormatted":"612 km","timeHours":6.533333333333333,"timeFormatted":"6 hours 32 minutes","avgSpeed":57,"routeDescriptors":["highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"west"}
      • 51: 
      • 52: sampit-ftk76sio/blue-ridge-zo4z6umn
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Edwards\",\"description\":\"425 mi to destination\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Edwards, SC 29590\",\"lat\":\"33.564332\",\"lng\":\"-79.954798\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":3,\"place_id\":38801,\"slug\":\"edwards\",\"hash\":\"hp021ggw\"},{\"name\":\"Fulton Crossroads\",\"description\":\"Traveled 106 mi from origin\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Fulton Crossroads, SC 29125\",\"lat\":\"33.727938\",\"lng\":\"-80.510363\",\"fraction\":0.2222222222222222,\"type\":\"State\",\"distance_km\":3,\"place_id\":55104,\"slug\":\"fulton-crossroads\",\"hash\":\"6m857wjf\"},{\"name\":\"Gaston\",\"description\":\"319 mi to destination\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Gaston, SC 29053\",\"lat\":\"33.817097\",\"lng\":\"-81.100929\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":3,\"place_id\":12221,\"slug\":\"gaston\",\"hash\":\"vpfntohj\"},{\"name\":\"Mt Willing\",\"description\":\"Traveled 212 mi from origin\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Mt Willing, SC 29138\",\"lat\":\"34.004304\",\"lng\":\"-81.667884\",\"fraction\":0.4444444444444444,\"type\":\"State\",\"distance_km\":3,\"place_id\":83524,\"slug\":\"mt-willing\",\"hash\":\"2509pmkt\"},{\"name\":\"Greenwood\",\"description\":\"212 mi to destination\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Greenwood, SC\",\"lat\":\"34.195400\",\"lng\":\"-82.161788\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":0,\"place_id\":2161,\"slug\":\"greenwood\",\"hash\":\"u9zowr92\"},{\"name\":\"Starr\",\"description\":\"Traveled 319 mi from origin\",\"state\":\"South Carolina\",\"country\":\"US\",\"full_address\":\"Starr, SC 29684\",\"lat\":\"34.377051\",\"lng\":\"-82.695689\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":26403,\"slug\":\"starr\",\"hash\":\"8r1nb4ul\"},{\"name\":\"Eastanollee\",\"description\":\"106 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Eastanollee, GA 30538\",\"lat\":\"34.520378\",\"lng\":\"-83.255437\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":49226,\"slug\":\"eastanollee\",\"hash\":\"6mj61cdq\"},{\"name\":\"Helen\",\"description\":\"Traveled 425 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Helen, GA 30545\",\"lat\":\"34.701484\",\"lng\":\"-83.731568\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":3,\"place_id\":21009,\"slug\":\"helen\",\"hash\":\"2zhsbez8\"}]"
      • 58: 3
      • 59: 889934
      • 60: 2025-05-18 09:04:48
      • 61: 2025-05-18 09:04:48
      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#70distance390μsselect exists(select "id" from "routes" where "origin_destination_id" = 889934 limit 1) as "exists"
      Bindings
      • 0: 889934
      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#1186distance530μsselect * from "routes" where "routes"."origin_destination_id" = 889934 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889934
      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#1186distance350μsselect * from "route_directions" where "route_directions"."route_id" in (2518678, 2518679) 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#225distance770μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:48' where "id" = 2518678
      Bindings
      • 0: 2025-05-18 09:04:48
      • 1: 2518678
      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#235distance330μsselect * from "origin_destinations" where "origin_destinations"."id" = 889934 limit 1
      Bindings
      • 0: 889934
      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#244distance360μsselect * from "places" where "places"."id" = 85471 limit 1
      Bindings
      • 0: 85471
      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#245distance320μsselect * from "places" where "places"."id" = 14517 limit 1
      Bindings
      • 0: 14517
      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" = 2518678
      Bindings
      • 0: 2518678
      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#28distance310μsselect * from "places" where "places"."id" = 38801 limit 1
      Bindings
      • 0: 38801
      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 "locations" where "locations"."id" in (38801)
      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 (13)
      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#28distance310μsselect * from "places" where "places"."id" = 55104 limit 1
      Bindings
      • 0: 55104
      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 "locations" where "locations"."id" in (55104)
      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#28distance250μsselect * from "states" where "states"."id" in (13)
      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#39distance300μ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#28distance310μsselect * from "places" where "places"."id" = 12221 limit 1
      Bindings
      • 0: 12221
      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 "locations" where "locations"."id" in (12221)
      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 "cities" where "cities"."id" in (8757)
      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 "states" where "states"."id" in (13)
      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#28distance300μsselect * from "places" where "places"."id" = 83524 limit 1
      Bindings
      • 0: 83524
      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 "locations" where "locations"."id" in (83523)
      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#28distance240μsselect * from "states" where "states"."id" in (13)
      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#39distance260μ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" = 2161 limit 1
      Bindings
      • 0: 2161
      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#28distance250μsselect * from "locations" where "locations"."id" in (2161)
      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 (688)
      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#28distance230μsselect * from "states" where "states"."id" in (13)
      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#39distance290μ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#28distance290μsselect * from "places" where "places"."id" = 26403 limit 1
      Bindings
      • 0: 26403
      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 "locations" where "locations"."id" in (26403)
      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 (16892)
      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#28distance240μsselect * from "states" where "states"."id" in (13)
      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#39distance300μ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
    • distance330μsselect * from "places" where "places"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" in (49226)
    • distance240μsselect * from "cities" where "cities"."id" in (24430)
    • distance230μsselect * from "states" where "states"."id" in (25)
    • distance250μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance310μsselect * from "places" where "places"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" in (21009)
    • distance250μsselect * from "cities" where "cities"."id" in (13926)
    • distance250μsselect * from "states" where "states"."id" in (25)
    • distance300μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance510μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance650μsselect * from "route_waypoints" where "route_id" = ?
    • distance450μsselect * from "places" where "places"."id" = ? limit 1
    • distance320μsselect * from "locations" where "locations"."id" in (38801)
    • distance290μsselect * from "states" where "states"."id" in (13)
    • distance350μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" in (55104)
    • distance340μsselect * from "states" where "states"."id" in (13)
    • distance300μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance370μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (12221)
    • distance310μsselect * from "cities" where "cities"."id" in (8757)
    • distance280μsselect * from "states" where "states"."id" in (13)
    • distance370μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance340μsselect * from "places" where "places"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" in (83523)
    • distance270μsselect * from "states" where "states"."id" in (13)
    • distance930μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" in (2161)
    • distance270μsselect * from "cities" where "cities"."id" in (688)
    • distance320μsselect * from "states" where "states"."id" in (13)
    • distance340μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance340μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (26403)
    • distance240μsselect * from "cities" where "cities"."id" in (16892)
    • distance230μsselect * from "states" where "states"."id" in (13)
    • distance300μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance330μsselect * from "places" where "places"."id" = ? limit 1
    • distance320μsselect * from "locations" where "locations"."id" in (49226)
    • distance250μsselect * from "cities" where "cities"."id" in (24430)
    • distance310μsselect * from "states" where "states"."id" in (25)
    • distance290μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" in (21009)
    • distance260μsselect * from "cities" where "cities"."id" in (13926)
    • distance270μsselect * from "states" where "states"."id" in (25)
    • distance280μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance330μsselect * from "states" where "states"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance260μsselect * from "states" where "states"."id" = ? limit 1
    • distance560μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance400μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance950μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance29.31msselect * from "images" where "images"."place_id" in (85471)
    • distance470μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.8msselect * from "images" where "images"."place_id" in (14517)
    • distance630μsselect * from "routes" where "origin_destination_id" = ?
    • distance600μ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"
    • distance460μsselect * from "route_directions" where "route_directions"."route_id" in (2518678, 2518679) order by "step_index" asc, "step_index" asc
    • distance430μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance370μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance660μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance420μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance370μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance510μ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\Location
    20Location.php#?
    App\Models\State
    20State.php#?
    App\Models\Country
    18Country.php#?
    App\Models\RouteDirection
    15RouteDirection.php#?
    App\Models\City
    11City.php#?
    App\Models\Route
    5Route.php#?
    App\Models\Image
    4Image.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:48GET/distance/sampit-ftk76sio/blue-ridge-zo4z6umn302169148