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

Just a moment while we calculate your route...

Distance from Grove Point to Longview

Driving Distance
562.5 mi 905.3 km
Flying Distance
398.1 mi 640.7 km
A
B
Leaflet © OpenStreetMap contributors

Route Information

The driving distance from Grove Point, Georgia to Longview, Tennessee is 562.5 mi (905.3 km)

The straight-line (air) distance is 398.1 mi (640.7 km)

The estimated flight time is 0 hr 48 min

The estimated travel time by road is 8 hours 30 minutes

Traveling fast highway, long-distance in a northwest direction. Average speeds around 75 mph.

Location Details

Origin:


No image available
Place Grove Point
State/Province Georgia
Country US
Latitude 31.9516
Longitude -81.203999
GPS 31.9516° N, 81.203999° W
Local Time 5:04 AM
Timezone America/New_York

Destination:


No image available
Place Longview
State/Province Tennessee
Country US
Latitude 35.64118
Longitude -86.529438
GPS 35.64118° N, 86.529438° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Grove Point, Georgia to Longview, Tennessee covers 562.5 mi (905.3 km) in a northwest direction. This fast highway, long-distance route typically takes 8 hours 30 minutes under normal conditions.

Drivers have 2 route options between these locations (468.0-562.5 miles / 753-905 km). The primary route shown here saves 1 hour and 21 minutes compared to alternatives.

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

Available Routes

I-16 W and I-20 W
562.5 mi 8 hours 30 minutes
Shortest Tolls
I-16 W and I-75 N
468 mi 7 hours 9 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.

SettingsRequest history2.45sRequest 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/grove-point-7fa751vq/longview-aaccc4sm
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:40] LOG.warning: No denormalized route found for origin-destination ID: 889924
  • infolog[09:04:40] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 55...
  • infolog[09:04:40] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:42] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:42] LOG.info: Processing route #1 data for origin-destination ID: 889924 { "origin": "Gro...
  • infolog[09:04:42] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:42] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:42] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:42] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:42] LOG.info: Ignoring 9 nested sub-directions for direction index 1
  • debuglog[09:04:42] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:42] LOG.info: Ignoring 6 nested sub-directions for direction index 2
  • infolog[09:04:42] LOG.info: Saved 3 directions for route ID: 2518653
  • infolog[09:04:42] LOG.info: Found a shorter route: 753148 meters for route ID: 2518653
  • infolog[09:04:42] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:42] LOG.info: Processing route #2 data for origin-destination ID: 889924 { "origin": "Gro...
  • infolog[09:04:42] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:42] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:42] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:42] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:42] LOG.info: Ignoring 10 nested sub-directions for direction index 1
  • debuglog[09:04:42] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:42] LOG.info: Ignoring 7 nested sub-directions for direction index 2
  • infolog[09:04:42] LOG.info: Saved 3 directions for route ID: 2518656
  • infolog[09:04:42] LOG.info: Successfully denormalized route data { "origin_destination_id": 889924, ...
  • infolog[09:04:42] LOG.info: Saved 2 routes for origin-destination ID: 889924
  • infolog[09:04:42] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518653, ...
  • infolog[09:04:42] LOG.info: Incremented view count for route { "id": 2518653, "name": "I-16 W and I...
  • infolog[09:04:42] LOG.info: Updated denormalized route for route { "route_id": 2518653, "views": 1 ...
  • infolog[09:04:42] LOG.info: Found existing routes { "route_count": 2, "default_route_id": 2518653, ...
status
200 OK
full_url
https://routedistance.io/distance/grove-point-7fa751vq/longview-aaccc4sm
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.45s
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 => "941a302d6c88c985-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:43 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "CDLwf6Lzf3ox94B52sL8FNarFq7AccUDQS4zTt0Y" ]
  • Booting (7.27ms)time
  • Application (2.44s)time
  • Routing (462μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (42μs)
  • 1 x Application (99.7%)
    2.44s
    1 x Booting (0.3%)
    7.27ms
    1 x Routing (0.02%)
    462μs
    1 x Preparing Response (0%)
    42μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    168 statements were executed (97 duplicates)Show only duplicatesdistance944ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 68 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance12.49msselect * from "sessions" where "id" = 'quW1uFdTkb7ZJlI8gHtupbgXFwA4sOkyv3Axr5sF' limit 1
      Bindings
      • 0: quW1uFdTkb7ZJlI8gHtupbgXFwA4sOkyv3Axr5sF
      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.66msselect * from "places" where "slug" = 'grove-point' and ("hash" = '7fa751vq') limit 1
      Bindings
      • 0: grove-point
      • 1: 7fa751vq
      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#548distance660μsselect * from "places" where "slug" = 'longview' and ("hash" = 'aaccc4sm') limit 1
      Bindings
      • 0: longview
      • 1: aaccc4sm
      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#104distance1.18msselect * from "origin_destinations" where ("origin_id" = 55942 and "destination_id" = 40335) limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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#104distance2.6msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (55942, 40335, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 55942
      • 1: 40335
      • 2: 2025-05-18 09:04:40
      • 3: 2025-05-18 09:04:40
      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.71msselect * from "denormalised_routes" where "origin_destination_id" = 889924 limit 1
      Bindings
      • 0: 889924
      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#70distance710μsselect exists(select "id" from "routes" where "origin_destination_id" = 889924 limit 1) as "exists"
      Bindings
      • 0: 889924
      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.92msdelete from "routes" where "origin_destination_id" = 889924
      Bindings
      • 0: 889924
      Backtrace
      • app/Services/DistanceCalculationService.php:158
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#172distance2.13msselect * from "places" where "places"."id" = 55942 limit 1
      Bindings
      • 0: 55942
      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#173distance550μsselect * from "places" where "places"."id" = 40335 limit 1
      Bindings
      • 0: 40335
      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#225distance2.03msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889924, 'I-16 W and I-75 N', 753148, 'm', 25779, 1, 'Your destination is in a different time zone.', 31.951514, 35.6411798, null, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 889924
      • 1: I-16 W and I-75 N
      • 2: 753148
      • 3: m
      • 4: 25779
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 31.951514
      • 8: 35.641179799999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:42
      • 12: 2025-05-18 09:04:42
      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#548distance5.06msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518653, 0, 'Get on I-16 W in Effingham County from GA-204 W and Old River Rd', 29881, 'm', 1558, -81.3005038, 32.03975265, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 0
      • 2: Get on I-16 W in Effingham County from GA-204 W and Old River Rd
      • 3: 29881
      • 4: m
      • 5: 1558
      • 6: -81.30050379999999
      • 7: 32.039752650000004
      • 8: 0
      • 9: 2025-05-18 09:04:42
      • 10: 2025-05-18 09:04:42
      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#548distance870μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518653, 1, 'Follow I-16 W, I-75 N and I-24 W to TN-64 W in Beechgrove. Take exit 97 from I-24 W', 688836, 'm', 22451, -83.8168955, 33.8767444, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 1
      • 2: Follow I-16 W, I-75 N and I-24 W to TN-64 W in Beechgrove. Take exit 97 from I-24 W
      • 3: 688836
      • 4: m
      • 5: 22451
      • 6: -83.8168955
      • 7: 33.8767444
      • 8: 0
      • 9: 2025-05-18 09:04:42
      • 10: 2025-05-18 09:04:42
      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 (2518653, 2, 'Take TN-82 S to Pepper Hill Rd in Bedford County', 34431, 'm', 1770, -86.38552785, 35.6122583, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 2
      • 2: Take TN-82 S to Pepper Hill Rd in Bedford County
      • 3: 34431
      • 4: m
      • 5: 1770
      • 6: -86.38552785
      • 7: 35.6122583
      • 8: 0
      • 9: 2025-05-18 09:04:42
      • 10: 2025-05-18 09:04:42
      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.11msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889924, 'I-16 W and I-20 W', 905265, 'm', 30602, 1, 'Your destination is in a different time zone.', 31.951514, 35.6413124, null, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 889924
      • 1: I-16 W and I-20 W
      • 2: 905265
      • 3: m
      • 4: 30602
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 31.951514
      • 8: 35.6413124
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:42
      • 12: 2025-05-18 09:04:42
      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#548distance970μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518656, 0, 'Get on I-16 W in Effingham County from GA-204 W and Old River Rd', 29881, 'm', 1558, -81.3005038, 32.03975265, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518656
      • 1: 0
      • 2: Get on I-16 W in Effingham County from GA-204 W and Old River Rd
      • 3: 29881
      • 4: m
      • 5: 1558
      • 6: -81.30050379999999
      • 7: 32.039752650000004
      • 8: 0
      • 9: 2025-05-18 09:04:42
      • 10: 2025-05-18 09:04:42
      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#548distance900μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518656, 1, 'Continue on I-16 W. Take I-75 N, I-20 W and I-65 N to US-31A N in Marshall County. Take exit 22 from I-65 N', 811269, 'm', 25953, -84.1657996, 33.71860235, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518656
      • 1: 1
      • 2: Continue on I-16 W. Take I-75 N, I-20 W and I-65 N to US-31A N in Marshall County. Take exit 22 from I-65 N
      • 3: 811269
      • 4: m
      • 5: 25953
      • 6: -84.1657996
      • 7: 33.71860235
      • 8: 0
      • 9: 2025-05-18 09:04:42
      • 10: 2025-05-18 09:04:42
      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#548distance780μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518656, 2, 'Continue on US-31A N. Take TN-270 E to Pepper Hill Rd in Bedford County', 64115, 'm', 3091, -86.70507715, 35.47506235, 0, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518656
      • 1: 2
      • 2: Continue on US-31A N. Take TN-270 E to Pepper Hill Rd in Bedford County
      • 3: 64115
      • 4: m
      • 5: 3091
      • 6: -86.70507715
      • 7: 35.47506235
      • 8: 0
      • 9: 2025-05-18 09:04:42
      • 10: 2025-05-18 09:04:42
      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#24distance650μsselect * from "route_waypoints" where "route_id" = 2518653
      Bindings
      • 0: 2518653
      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#103distance2.44msselect * from "origin_destinations" where "origin_destinations"."id" = 889924 limit 1
      Bindings
      • 0: 889924
      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#103distance390μsselect * from "places" where "places"."id" = 55942 limit 1
      Bindings
      • 0: 55942
      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#104distance350μsselect * from "places" where "places"."id" = 40335 limit 1
      Bindings
      • 0: 40335
      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#226distance105msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(32.361553333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-81.795714444444)) + sin(radians(32.361553333333)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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.11msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 50786 limit 1
      Bindings
      • 0: 50786
      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#226distance97.76msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(32.771506666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-82.387429888889)) + sin(radians(32.771506666667)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 12166 limit 1
      Bindings
      • 0: 12166
      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#226distance97.45msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.18146)) * cos(radians(lat)) * cos(radians(lng) - radians(-82.979145333333)) + sin(radians(33.18146)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 71812 limit 1
      Bindings
      • 0: 71812
      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#226distance100msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.591413333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-83.570860777778)) + sin(radians(33.591413333333)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance700μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 52473 limit 1
      Bindings
      • 0: 52473
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance91.48msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.001366666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.162576222222)) + sin(radians(34.001366666667)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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" = 1605 limit 1
      Bindings
      • 0: 1605
      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#226distance97.79msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.41132)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.754291666667)) + sin(radians(34.41132)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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#158distance4.42msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 75853 limit 1
      Bindings
      • 0: 75853
      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#226distance93.85msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.821273333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-85.346007111111)) + sin(radians(34.821273333333)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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#158distance520μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 91202 limit 1
      Bindings
      • 0: 91202
      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.62msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.231226666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-85.937722555556)) + sin(radians(35.231226666667)) * 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" != 55942 and "places"."id" != 40335 order by "distance" asc limit 1
      Bindings
      • 0: 55942
      • 1: 40335
      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" = 9915 limit 1
      Bindings
      • 0: 9915
      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#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518653 and "place_id" = 50786) limit 1
      Bindings
      • 0: 2518653
      • 1: 50786
      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.33msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518653, 50786, 0.11111111111111, 3, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 50786
      • 2: 0.1111111111111111
      • 3: 3
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518653 and "place_id" = 12165) limit 1
      Bindings
      • 0: 2518653
      • 1: 12165
      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#78distance880μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518653, 12165, 0.22222222222222, 7, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 12165
      • 2: 0.2222222222222222
      • 3: 7
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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" = 2518653 and "place_id" = 71812) limit 1
      Bindings
      • 0: 2518653
      • 1: 71812
      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#78distance780μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518653, 71812, 0.33333333333333, 5, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 71812
      • 2: 0.3333333333333333
      • 3: 5
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518653 and "place_id" = 52473) limit 1
      Bindings
      • 0: 2518653
      • 1: 52473
      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#78distance710μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518653, 52473, 0.44444444444444, 1, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 52473
      • 2: 0.4444444444444444
      • 3: 1
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518653 and "place_id" = 1605) limit 1
      Bindings
      • 0: 2518653
      • 1: 1605
      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#78distance870μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518653, 1605, 0.55555555555556, 1, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 1605
      • 2: 0.5555555555555556
      • 3: 1
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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" = 2518653 and "place_id" = 75853) limit 1
      Bindings
      • 0: 2518653
      • 1: 75853
      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 (2518653, 75853, 0.66666666666667, 2, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 75853
      • 2: 0.6666666666666666
      • 3: 2
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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" = 2518653 and "place_id" = 91202) limit 1
      Bindings
      • 0: 2518653
      • 1: 91202
      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#78distance780μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518653, 91202, 0.77777777777778, 1, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 91202
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518653 and "place_id" = 9915) limit 1
      Bindings
      • 0: 2518653
      • 1: 9915
      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 (2518653, 9915, 0.88888888888889, 2, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 2518653
      • 1: 9915
      • 2: 0.8888888888888888
      • 3: 2
      • 4: 2025-05-18 09:04:42
      • 5: 2025-05-18 09:04:42
      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#366distance510μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518653 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518653
      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#45distance390μsselect * from "denormalised_routes" where "origin_destination_id" = 889924 limit 1
      Bindings
      • 0: 889924
      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" = 2518653 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518653
      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#198distance310μsselect * from "locations" where "locations"."id" = 55942 limit 1
      Bindings
      • 0: 55942
      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#215distance300μsselect * from "states" where "states"."id" = 25 limit 1
      Bindings
      • 0: 25
      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#330distance300μ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#198distance330μsselect * from "locations" where "locations"."id" = 40335 limit 1
      Bindings
      • 0: 40335
      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#215distance250μsselect * from "states" where "states"."id" = 34 limit 1
      Bindings
      • 0: 34
      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#70distance1.95msinsert 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 (55942, 'Grove Point', 'Grove Point, GA 31419', 'grove-point', '7fa751vq', 31.9516, -81.203999, null, 'Georgia', 'US', 'America/New_York', 40335, 'Longview', 'Longview, TN 37020', 'longview', 'aaccc4sm', 35.64118, -86.529438, null, 'Tennessee', 'US', 'America/Chicago', 2518653, 'I-16 W and I-75 N', 753148, 'm', 25779, 467.984325908, 753148, '7 hours 9 minutes', '7 hours 9 minutes', 753.148, '753.1 km', null, 430, 1, 'Your destination is in a different time zone.', '468 mi', 397.98104137289, 0.39798104137289, '"[{\"id\":8350607,\"route_id\":2518653,\"step_index\":\"0\",\"instruction\":\"Get on I-16 W in Effingham County from GA-204 W and Old River Rd\",\"distance\":29881,\"distance_unit\":\"m\",\"time\":\"1558\",\"latitude\":-81.3005038,\"longitude\":32.0397527,\"is_sub_step\":false},{\"id\":8350609,\"route_id\":2518653,\"step_index\":\"1\",\"instruction\":\"Follow I-16 W, I-75 N and I-24 W to TN-64 W in Beechgrove. Take exit 97 from I-24 W\",\"distance\":688836,\"distance_unit\":\"m\",\"time\":\"22451\",\"latitude\":-83.8168955,\"longitude\":33.8767444,\"is_sub_step\":false},{\"id\":8350611,\"route_id\":2518653,\"step_index\":\"2\",\"instruction\":\"Take TN-82 S to Pepper Hill Rd in Bedford County\",\"distance\":34431,\"distance_unit\":\"m\",\"time\":\"1770\",\"latitude\":-86.3855279,\"longitude\":35.6122583,\"is_sub_step\":false}]"', 753148, 753148, '1 hour and 21 minutes', 0, 'northwest', 'southeast', '[{"name":"Jimps","description":"569 mi to destination","state":"Georgia","country":"US","full_address":"Jimps, GA 30458","lat":"32.385735","lng":"-81.835391","fraction":0.1111111111111111,"type":"State","distance_km":3,"place_id":50786,"slug":"jimps","hash":"1qepjjtb"},{"name":"Wadley","description":"Traveled 142 mi from origin","state":"Georgia","country":"US","full_address":"Wadley, GA","lat":"32.866371","lng":"-82.404598","fraction":0.2222222222222222,"type":"City","distance_km":7,"place_id":12165,"slug":"wadley","hash":"kd03rrq6"},{"name":"Linton","description":"427 mi to destination","state":"Georgia","country":"US","full_address":"Linton, GA 31087","lat":"33.116538","lng":"-82.992647","fraction":0.3333333333333333,"type":"City","distance_km":5,"place_id":71812,"slug":"linton","hash":"vprl1mp1"},{"name":"Dorsey","description":"Traveled 285 mi from origin","state":"Georgia","country":"US","full_address":"Dorsey, GA 30650","lat":"33.605402","lng":"-83.552669","fraction":0.4444444444444444,"type":"State","distance_km":1,"place_id":52473,"slug":"dorsey","hash":"6zwt2pwr"},{"name":"Duluth","description":"285 mi to destination","state":"Georgia","country":"US","full_address":"Duluth, GA","lat":"34.002879","lng":"-84.144638","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":1605,"slug":"duluth","hash":"54ko1vor"},{"name":"Yarbroughs Mill","description":"Traveled 427 mi from origin","state":"Georgia","country":"US","full_address":"Yarbroughs Mill, GA 30139","lat":"34.427312","lng":"-84.774104","fraction":0.6666666666666666,"type":"City","distance_km":2,"place_id":75853,"slug":"yarbroughs-mill","hash":"hadbrzad"},{"name":"Pond Spring","description":"142 mi to destination","state":"Georgia","country":"US","full_address":"Pond Spring, GA 30707","lat":"34.822300","lng":"-85.325513","fraction":0.7777777777777778,"type":"State","distance_km":1,"place_id":91202,"slug":"pond-spring","hash":"qgejec8u"},{"name":"Sewanee","description":"Traveled 569 mi from origin","state":"Tennessee","country":"US","full_address":"Sewanee, TN 37375","lat":"35.203137","lng":"-85.921090","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":9915,"slug":"sewanee","hash":"nwvflvrz"}]', 1, 8, '{"distanceInMiles":467.98563386232865,"distanceMilesFormatted":"468 miles","distanceFormatted":"468 miles","distanceKmFormatted":"753 km","timeHours":7.15,"timeFormatted":"7 hours 9 minutes","avgSpeed":75,"routeDescriptors":["fast highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["scenic views","toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}', null, 'grove-point-7fa751vq/longview-aaccc4sm', 0, null, null, 0, '"[{\"name\":\"Jimps\",\"description\":\"569 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Jimps, GA 30458\",\"lat\":\"32.385735\",\"lng\":\"-81.835391\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":3,\"place_id\":50786,\"slug\":\"jimps\",\"hash\":\"1qepjjtb\"},{\"name\":\"Wadley\",\"description\":\"Traveled 142 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Wadley, GA\",\"lat\":\"32.866371\",\"lng\":\"-82.404598\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":7,\"place_id\":12165,\"slug\":\"wadley\",\"hash\":\"kd03rrq6\"},{\"name\":\"Linton\",\"description\":\"427 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Linton, GA 31087\",\"lat\":\"33.116538\",\"lng\":\"-82.992647\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":5,\"place_id\":71812,\"slug\":\"linton\",\"hash\":\"vprl1mp1\"},{\"name\":\"Dorsey\",\"description\":\"Traveled 285 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Dorsey, GA 30650\",\"lat\":\"33.605402\",\"lng\":\"-83.552669\",\"fraction\":0.4444444444444444,\"type\":\"State\",\"distance_km\":1,\"place_id\":52473,\"slug\":\"dorsey\",\"hash\":\"6zwt2pwr\"},{\"name\":\"Duluth\",\"description\":\"285 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Duluth, GA\",\"lat\":\"34.002879\",\"lng\":\"-84.144638\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":1605,\"slug\":\"duluth\",\"hash\":\"54ko1vor\"},{\"name\":\"Yarbroughs Mill\",\"description\":\"Traveled 427 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Yarbroughs Mill, GA 30139\",\"lat\":\"34.427312\",\"lng\":\"-84.774104\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":2,\"place_id\":75853,\"slug\":\"yarbroughs-mill\",\"hash\":\"hadbrzad\"},{\"name\":\"Pond Spring\",\"description\":\"142 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Pond Spring, GA 30707\",\"lat\":\"34.822300\",\"lng\":\"-85.325513\",\"fraction\":0.7777777777777778,\"type\":\"State\",\"distance_km\":1,\"place_id\":91202,\"slug\":\"pond-spring\",\"hash\":\"qgejec8u\"},{\"name\":\"Sewanee\",\"description\":\"Traveled 569 mi from origin\",\"state\":\"Tennessee\",\"country\":\"US\",\"full_address\":\"Sewanee, TN 37375\",\"lat\":\"35.203137\",\"lng\":\"-85.921090\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":9915,\"slug\":\"sewanee\",\"hash\":\"nwvflvrz\"}]"', 3, 889924, '2025-05-18 09:04:42', '2025-05-18 09:04:42') returning "id"
      Bindings
      • 0: 55942
      • 1: Grove Point
      • 2: Grove Point, GA 31419
      • 3: grove-point
      • 4: 7fa751vq
      • 5: 31.9516
      • 6: -81.203999
      • 7: 
      • 8: Georgia
      • 9: US
      • 10: America/New_York
      • 11: 40335
      • 12: Longview
      • 13: Longview, TN 37020
      • 14: longview
      • 15: aaccc4sm
      • 16: 35.64118
      • 17: -86.529438
      • 18: 
      • 19: Tennessee
      • 20: US
      • 21: America/Chicago
      • 22: 2518653
      • 23: I-16 W and I-75 N
      • 24: 753148
      • 25: m
      • 26: 25779
      • 27: 467.984325908
      • 28: 753148
      • 29: 7 hours 9 minutes
      • 30: 7 hours 9 minutes
      • 31: 753.148
      • 32: 753.1 km
      • 33: 
      • 34: 430
      • 35: 1
      • 36: Your destination is in a different time zone.
      • 37: 468 mi
      • 38: 397.98104137288703
      • 39: 0.39798104137288703
      • 40: "[{\"id\":8350607,\"route_id\":2518653,\"step_index\":\"0\",\"instruction\":\"Get on I-16 W in Effingham County from GA-204 W and Old River Rd\",\"distance\":29881,\"distance_unit\":\"m\",\"time\":\"1558\",\"latitude\":-81.3005038,\"longitude\":32.0397527,\"is_sub_step\":false},{\"id\":8350609,\"route_id\":2518653,\"step_index\":\"1\",\"instruction\":\"Follow I-16 W, I-75 N and I-24 W to TN-64 W in Beechgrove. Take exit 97 from I-24 W\",\"distance\":688836,\"distance_unit\":\"m\",\"time\":\"22451\",\"latitude\":-83.8168955,\"longitude\":33.8767444,\"is_sub_step\":false},{\"id\":8350611,\"route_id\":2518653,\"step_index\":\"2\",\"instruction\":\"Take TN-82 S to Pepper Hill Rd in Bedford County\",\"distance\":34431,\"distance_unit\":\"m\",\"time\":\"1770\",\"latitude\":-86.3855279,\"longitude\":35.6122583,\"is_sub_step\":false}]"
      • 41: 753148
      • 42: 753148
      • 43: 1 hour and 21 minutes
      • 44: 0
      • 45: northwest
      • 46: southeast
      • 47: [{"name":"Jimps","description":"569 mi to destination","state":"Georgia","country":"US","full_address":"Jimps, GA 30458","lat":"32.385735","lng":"-81.835391","fraction":0.1111111111111111,"type":"State","distance_km":3,"place_id":50786,"slug":"jimps","hash":"1qepjjtb"},{"name":"Wadley","description":"Traveled 142 mi from origin","state":"Georgia","country":"US","full_address":"Wadley, GA","lat":"32.866371","lng":"-82.404598","fraction":0.2222222222222222,"type":"City","distance_km":7,"place_id":12165,"slug":"wadley","hash":"kd03rrq6"},{"name":"Linton","description":"427 mi to destination","state":"Georgia","country":"US","full_address":"Linton, GA 31087","lat":"33.116538","lng":"-82.992647","fraction":0.3333333333333333,"type":"City","distance_km":5,"place_id":71812,"slug":"linton","hash":"vprl1mp1"},{"name":"Dorsey","description":"Traveled 285 mi from origin","state":"Georgia","country":"US","full_address":"Dorsey, GA 30650","lat":"33.605402","lng":"-83.552669","fraction":0.4444444444444444,"type":"State","distance_km":1,"place_id":52473,"slug":"dorsey","hash":"6zwt2pwr"},{"name":"Duluth","description":"285 mi to destination","state":"Georgia","country":"US","full_address":"Duluth, GA","lat":"34.002879","lng":"-84.144638","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":1605,"slug":"duluth","hash":"54ko1vor"},{"name":"Yarbroughs Mill","description":"Traveled 427 mi from origin","state":"Georgia","country":"US","full_address":"Yarbroughs Mill, GA 30139","lat":"34.427312","lng":"-84.774104","fraction":0.6666666666666666,"type":"City","distance_km":2,"place_id":75853,"slug":"yarbroughs-mill","hash":"hadbrzad"},{"name":"Pond Spring","description":"142 mi to destination","state":"Georgia","country":"US","full_address":"Pond Spring, GA 30707","lat":"34.822300","lng":"-85.325513","fraction":0.7777777777777778,"type":"State","distance_km":1,"place_id":91202,"slug":"pond-spring","hash":"qgejec8u"},{"name":"Sewanee","description":"Traveled 569 mi from origin","state":"Tennessee","country":"US","full_address":"Sewanee, TN 37375","lat":"35.203137","lng":"-85.921090","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":9915,"slug":"sewanee","hash":"nwvflvrz"}]
      • 48: 1
      • 49: 8
      • 50: {"distanceInMiles":467.98563386232865,"distanceMilesFormatted":"468 miles","distanceFormatted":"468 miles","distanceKmFormatted":"753 km","timeHours":7.15,"timeFormatted":"7 hours 9 minutes","avgSpeed":75,"routeDescriptors":["fast highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["scenic views","toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}
      • 51: 
      • 52: grove-point-7fa751vq/longview-aaccc4sm
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Jimps\",\"description\":\"569 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Jimps, GA 30458\",\"lat\":\"32.385735\",\"lng\":\"-81.835391\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":3,\"place_id\":50786,\"slug\":\"jimps\",\"hash\":\"1qepjjtb\"},{\"name\":\"Wadley\",\"description\":\"Traveled 142 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Wadley, GA\",\"lat\":\"32.866371\",\"lng\":\"-82.404598\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":7,\"place_id\":12165,\"slug\":\"wadley\",\"hash\":\"kd03rrq6\"},{\"name\":\"Linton\",\"description\":\"427 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Linton, GA 31087\",\"lat\":\"33.116538\",\"lng\":\"-82.992647\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":5,\"place_id\":71812,\"slug\":\"linton\",\"hash\":\"vprl1mp1\"},{\"name\":\"Dorsey\",\"description\":\"Traveled 285 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Dorsey, GA 30650\",\"lat\":\"33.605402\",\"lng\":\"-83.552669\",\"fraction\":0.4444444444444444,\"type\":\"State\",\"distance_km\":1,\"place_id\":52473,\"slug\":\"dorsey\",\"hash\":\"6zwt2pwr\"},{\"name\":\"Duluth\",\"description\":\"285 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Duluth, GA\",\"lat\":\"34.002879\",\"lng\":\"-84.144638\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":1605,\"slug\":\"duluth\",\"hash\":\"54ko1vor\"},{\"name\":\"Yarbroughs Mill\",\"description\":\"Traveled 427 mi from origin\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Yarbroughs Mill, GA 30139\",\"lat\":\"34.427312\",\"lng\":\"-84.774104\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":2,\"place_id\":75853,\"slug\":\"yarbroughs-mill\",\"hash\":\"hadbrzad\"},{\"name\":\"Pond Spring\",\"description\":\"142 mi to destination\",\"state\":\"Georgia\",\"country\":\"US\",\"full_address\":\"Pond Spring, GA 30707\",\"lat\":\"34.822300\",\"lng\":\"-85.325513\",\"fraction\":0.7777777777777778,\"type\":\"State\",\"distance_km\":1,\"place_id\":91202,\"slug\":\"pond-spring\",\"hash\":\"qgejec8u\"},{\"name\":\"Sewanee\",\"description\":\"Traveled 569 mi from origin\",\"state\":\"Tennessee\",\"country\":\"US\",\"full_address\":\"Sewanee, TN 37375\",\"lat\":\"35.203137\",\"lng\":\"-85.921090\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":9915,\"slug\":\"sewanee\",\"hash\":\"nwvflvrz\"}]"
      • 58: 3
      • 59: 889924
      • 60: 2025-05-18 09:04:42
      • 61: 2025-05-18 09:04:42
      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#70distance420μsselect exists(select "id" from "routes" where "origin_destination_id" = 889924 limit 1) as "exists"
      Bindings
      • 0: 889924
      Backtrace
      • app/Models/OriginDestination.php:70
      • app/Services/DistanceCalculationService.php:1179
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#1186distance610μsselect * from "routes" where "routes"."origin_destination_id" = 889924 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889924
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#1186distance420μsselect * from "route_directions" where "route_directions"."route_id" in (2518653, 2518656) 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#225distance890μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:42' where "id" = 2518653
      Bindings
      • 0: 2025-05-18 09:04:42
      • 1: 2518653
      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#235distance380μsselect * from "origin_destinations" where "origin_destinations"."id" = 889924 limit 1
      Bindings
      • 0: 889924
      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#244distance400μsselect * from "places" where "places"."id" = 55942 limit 1
      Bindings
      • 0: 55942
      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#245distance430μsselect * from "places" where "places"."id" = 40335 limit 1
      Bindings
      • 0: 40335
      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#24distance310μsselect * from "route_waypoints" where "route_id" = 2518653
      Bindings
      • 0: 2518653
      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#28distance370μsselect * from "places" where "places"."id" = 50786 limit 1
      Bindings
      • 0: 50786
      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#28distance490μsselect * from "locations" where "locations"."id" in (50786)
      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#28distance410μsselect * from "states" where "states"."id" in (25)
      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#28distance460μsselect * from "places" where "places"."id" = 12165 limit 1
      Bindings
      • 0: 12165
      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#28distance420μsselect * from "locations" where "locations"."id" in (12166)
      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#28distance490μsselect * from "cities" where "cities"."id" in (8710)
      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 (25)
      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#39distance370μ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#28distance340μsselect * from "places" where "places"."id" = 71812 limit 1
      Bindings
      • 0: 71812
      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 (71812)
      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#28distance350μsselect * from "cities" where "cities"."id" in (5498)
      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#28distance290μsselect * from "states" where "states"."id" in (25)
      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#28distance410μsselect * from "places" where "places"."id" = 52473 limit 1
      Bindings
      • 0: 52473
      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#28distance430μsselect * from "locations" where "locations"."id" in (52473)
      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#28distance450μsselect * from "states" where "states"."id" in (25)
      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#39distance400μ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#28distance500μsselect * from "places" where "places"."id" = 1605 limit 1
      Bindings
      • 0: 1605
      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#28distance400μsselect * from "locations" where "locations"."id" in (1605)
      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#28distance360μsselect * from "cities" where "cities"."id" in (211)
      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 (25)
      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#28distance460μsselect * from "places" where "places"."id" = 75853 limit 1
      Bindings
      • 0: 75853
      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 "locations" where "locations"."id" in (75853)
      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 "cities" where "cities"."id" in (30435)
      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#28distance350μsselect * from "states" where "states"."id" in (25)
      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
    • distance380μsselect * from "places" where "places"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" in (91202)
    • distance240μsselect * from "states" where "states"."id" in (25)
    • distance340μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance320μsselect * from "locations" where "locations"."id" in (9915)
    • distance300μsselect * from "cities" where "cities"."id" in (7333)
    • distance230μsselect * from "states" where "states"."id" in (34)
    • distance250μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance470μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance440μsselect * from "route_waypoints" where "route_id" = ?
    • distance380μsselect * from "places" where "places"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" in (50786)
    • distance290μsselect * from "states" where "states"."id" in (25)
    • distance270μ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 (12166)
    • distance240μsselect * from "cities" where "cities"."id" in (8710)
    • distance260μsselect * from "states" where "states"."id" in (25)
    • distance280μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance290μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (71812)
    • distance250μsselect * from "cities" where "cities"."id" in (5498)
    • distance270μsselect * from "states" where "states"."id" in (25)
    • distance340μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" in (52473)
    • distance300μsselect * from "states" where "states"."id" in (25)
    • distance400μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance410μsselect * from "places" where "places"."id" = ? limit 1
    • distance300μsselect * from "locations" where "locations"."id" in (1605)
    • distance290μsselect * from "cities" where "cities"."id" in (211)
    • distance330μsselect * from "states" where "states"."id" in (25)
    • distance350μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance440μsselect * from "places" where "places"."id" = ? limit 1
    • distance400μsselect * from "locations" where "locations"."id" in (75853)
    • distance380μsselect * from "cities" where "cities"."id" in (30435)
    • distance380μsselect * from "states" where "states"."id" in (25)
    • distance380μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance500μsselect * from "places" where "places"."id" = ? limit 1
    • distance370μsselect * from "locations" where "locations"."id" in (91202)
    • distance390μsselect * from "states" where "states"."id" in (25)
    • distance380μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance490μsselect * from "places" where "places"."id" = ? limit 1
    • distance420μsselect * from "locations" where "locations"."id" in (9915)
    • distance330μsselect * from "cities" where "cities"."id" in (7333)
    • distance320μsselect * from "states" where "states"."id" in (34)
    • distance370μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance320μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance350μsselect * from "states" where "states"."id" = ? limit 1
    • distance280μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance350μsselect * from "states" where "states"."id" = ? limit 1
    • distance620μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance610μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance1.15msupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance560μsselect * from "places" where "places"."id" = ? limit 1
    • distance30.68msselect * from "images" where "images"."place_id" in (55942)
    • distance820μsselect * from "places" where "places"."id" = ? limit 1
    • distance24.59msselect * from "images" where "images"."place_id" in (40335)
    • distance620μsselect * from "routes" where "origin_destination_id" = ?
    • distance540μ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"
    • distance390μsselect * from "route_directions" where "route_directions"."route_id" in (2518653, 2518656) order by "step_index" asc, "step_index" asc
    • distance410μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance390μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance680μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance440μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance320μ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\Location
    20Location.php#?
    App\Models\State
    20State.php#?
    App\Models\Country
    18Country.php#?
    App\Models\RouteDirection
    15RouteDirection.php#?
    App\Models\City
    10City.php#?
    App\Models\Route
    5Route.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:43GET/distance/grove-point-7fa751vq/longview-aaccc4sm302168143