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

Just a moment while we calculate your route...

Distance from Redding to Peteet

Driving Distance
79.8 mi 128.4 km
Flying Distance
56.9 mi 91.5 km
A
B
Leaflet © OpenStreetMap contributors

Route Information

The driving distance from Redding, Mississippi to Peteet, Mississippi is 79.8 mi (128.4 km)

The straight-line (air) distance is 56.9 mi (91.5 km)

The estimated flight time is 0 hr 7 min

The estimated travel time by road is 1 hour 25 minutes

Traveling mixed highways and local roads, substantial in a southwest direction. Average speeds around 52 mph.

Location Details

Origin:


No image available
Place Redding
State/Province Mississippi
Country US
Latitude 33.722618
Longitude -89.513133
GPS 33.722618° N, 89.513133° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Peteet
State/Province Mississippi
Country US
Latitude 33.343178
Longitude -90.387864
GPS 33.343178° N, 90.387864° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Redding, Mississippi to Peteet, Mississippi covers 79.8 mi (128.4 km) in a southwest direction. This mixed highways and local roads, substantial route typically takes 1 hour 25 minutes under normal conditions.

Drivers have 3 route options between these locations (72.1-98.4 miles / 116-158 km). The primary route shown here saves 22 minutes compared to alternatives.

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

Available Routes

US-82 W
79.8 mi 1 hour 25 minutes
Shortest
US-82 W and MS-7 S
98.4 mi 1 hour 42 minutes
MS-8 W and MS-7 S
72.1 mi 1 hour 21 minutes
Fastest

How is the distance calculated?

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

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

SettingsRequest history1.65sRequest 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/redding-a7d7g08m/peteet-ly2ydcz6
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:49] LOG.warning: No denormalized route found for origin-destination ID: 889938
  • infolog[09:04:49] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 62...
  • infolog[09:04:49] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:49] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:49] LOG.info: Processing route #1 data for origin-destination ID: 889938 { "origin": "Red...
  • infolog[09:04:49] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 1 nested sub-directions for direction index 0
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 5 nested sub-directions for direction index 1
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 2 nested sub-directions for direction index 2
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 1 nested sub-directions for direction index 3
  • infolog[09:04:49] LOG.info: Saved 4 directions for route ID: 2518685
  • infolog[09:04:49] LOG.info: Found a shorter route: 116003 meters for route ID: 2518685
  • infolog[09:04:49] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:49] LOG.info: Processing route #2 data for origin-destination ID: 889938 { "origin": "Red...
  • infolog[09:04:49] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:49] LOG.info: Saved 3 directions for route ID: 2518686
  • infolog[09:04:49] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:49] LOG.info: Processing route #3 data for origin-destination ID: 889938 { "origin": "Red...
  • infolog[09:04:49] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 2 nested sub-directions for direction index 1
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:49] LOG.info: Saved 3 directions for route ID: 2518687
  • infolog[09:04:50] LOG.info: Successfully denormalized route data { "origin_destination_id": 889938, ...
  • infolog[09:04:50] LOG.info: Saved 3 routes for origin-destination ID: 889938
  • infolog[09:04:50] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518685, ...
  • infolog[09:04:50] LOG.info: Incremented view count for route { "id": 2518685, "name": "MS-8 W and M...
  • infolog[09:04:50] LOG.info: Updated denormalized route for route { "route_id": 2518685, "views": 1 ...
  • infolog[09:04:50] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518685, ...
status
200 OK
full_url
https://routedistance.io/distance/redding-a7d7g08m/peteet-ly2ydcz6
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
1.65s
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 => "941a30650d5cc985-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:50 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "A8aADoemqDPVd70M260EziJf0t9sQ0FCRKzlxJcX" ]
  • Booting (8.05ms)time
  • Application (1.64s)time
  • Routing (480μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (33μs)
  • 1 x Application (99.51%)
    1.64s
    1 x Booting (0.49%)
    8.05ms
    1 x Routing (0.03%)
    480μs
    1 x Preparing Response (0%)
    33μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    176 statements were executed (103 duplicates)Show only duplicatesdistance955ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 76 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance17.87msselect * from "sessions" where "id" = 'zVdkKNqAWctKqIuoDpJDjtwcjmPHZfoDRHRbqCc8' limit 1
      Bindings
      • 0: zVdkKNqAWctKqIuoDpJDjtwcjmPHZfoDRHRbqCc8
      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#548distance8.58msselect * from "places" where "slug" = 'redding' and ("hash" = 'a7d7g08m') limit 1
      Bindings
      • 0: redding
      • 1: a7d7g08m
      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#548distance830μsselect * from "places" where "slug" = 'peteet' and ("hash" = 'ly2ydcz6') limit 1
      Bindings
      • 0: peteet
      • 1: ly2ydcz6
      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#104distance970μsselect * from "origin_destinations" where ("origin_id" = 62797 and "destination_id" = 56313) limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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.57msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (62797, 56313, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 62797
      • 1: 56313
      • 2: 2025-05-18 09:04:49
      • 3: 2025-05-18 09:04:49
      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.85msselect * from "denormalised_routes" where "origin_destination_id" = 889938 limit 1
      Bindings
      • 0: 889938
      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#70distance740μsselect exists(select "id" from "routes" where "origin_destination_id" = 889938 limit 1) as "exists"
      Bindings
      • 0: 889938
      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.58msdelete from "routes" where "origin_destination_id" = 889938
      Bindings
      • 0: 889938
      Backtrace
      • app/Services/DistanceCalculationService.php:158
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#172distance480μsselect * from "places" where "places"."id" = 62797 limit 1
      Bindings
      • 0: 62797
      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#173distance1.33msselect * from "places" where "places"."id" = 56313 limit 1
      Bindings
      • 0: 56313
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance3.8msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889938, 'MS-8 W and MS-7 S', 116003, 'm', 4887, 0, 'No', 33.3431776, 33.7876656, null, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 889938
      • 1: MS-8 W and MS-7 S
      • 2: 116003
      • 3: m
      • 4: 4887
      • 5: 0
      • 6: No
      • 7: 33.3431776
      • 8: 33.7876656
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:49
      • 12: 2025-05-18 09:04:49
      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.14msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518685, 0, '', 6232, 'm', 291, -89.53393905, 33.74210645, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518685
      • 1: 0
      • 2: 
      • 3: 6232
      • 4: m
      • 5: 291
      • 6: -89.53393905
      • 7: 33.74210645
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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 (2518685, 1, 'Continue on MS-8 W. Take MS-7 S to Co Rd 512/Damgard Rd in Leflore County', 84716, 'm', 3566, -89.88235665, 33.6234654, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518685
      • 1: 1
      • 2: Continue on MS-8 W. Take MS-7 S to Co Rd 512/Damgard Rd in Leflore County
      • 3: 84716
      • 4: m
      • 5: 3566
      • 6: -89.88235664999999
      • 7: 33.6234654
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance2.52msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518685, 2, 'Follow Co Rd 512 to MS-7 S', 10086, 'm', 483, -90.2546826, 33.44909615, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518685
      • 1: 2
      • 2: Follow Co Rd 512 to MS-7 S
      • 3: 10086
      • 4: m
      • 5: 483
      • 6: -90.2546826
      • 7: 33.44909615
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance850μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518685, 3, '', 14969, 'm', 547, -90.34432635, 33.39305775, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518685
      • 1: 3
      • 2: 
      • 3: 14969
      • 4: m
      • 5: 547
      • 6: -90.34432635
      • 7: 33.39305775
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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.05msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889938, 'US-82 W', 128371, 'm', 5104, 0, 'No', 33.3431776, 33.7620913, null, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 889938
      • 1: US-82 W
      • 2: 128371
      • 3: m
      • 4: 5104
      • 5: 0
      • 6: No
      • 7: 33.3431776
      • 8: 33.7620913
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:49
      • 12: 2025-05-18 09:04:49
      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#548distance740μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518686, 0, 'Get on I-55 S from MS-8 W, Camp McCain Rd and Nat G Troutt Rd', 35906, 'm', 1658, -89.6638742, 33.72046415, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518686
      • 1: 0
      • 2: Get on I-55 S from MS-8 W, Camp McCain Rd and Nat G Troutt Rd
      • 3: 35906
      • 4: m
      • 5: 1658
      • 6: -89.6638742
      • 7: 33.72046415
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance760μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518686, 1, 'Follow I-55 S and US-82 W to Co Rd 512/Damgard Rd in Leflore County', 67410, 'm', 2416, -89.98740915, 33.5690511, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518686
      • 1: 1
      • 2: Follow I-55 S and US-82 W to Co Rd 512/Damgard Rd in Leflore County
      • 3: 67410
      • 4: m
      • 5: 2416
      • 6: -89.98740914999999
      • 7: 33.569051099999996
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance850μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518686, 2, 'Follow Co Rd 512 to MS-7 S', 25055, 'm', 1030, -90.29862305, 33.40135825, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518686
      • 1: 2
      • 2: Follow Co Rd 512 to MS-7 S
      • 3: 25055
      • 4: m
      • 5: 1030
      • 6: -90.29862305
      • 7: 33.40135825
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#225distance5.75msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889938, 'US-82 W and MS-7 S', 158386, 'm', 6160, 0, 'No', 33.3431776, 33.7226181, null, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 889938
      • 1: US-82 W and MS-7 S
      • 2: 158386
      • 3: m
      • 4: 6160
      • 5: 0
      • 6: No
      • 7: 33.3431776
      • 8: 33.7226181
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:49
      • 12: 2025-05-18 09:04:49
      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.28msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518687, 0, 'Take Cadaretta Rd, MS-404 E and MS-9 S to US-82 W in Webster County', 39880, 'm', 1770, -89.39020065, 33.62284085, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518687
      • 1: 0
      • 2: Take Cadaretta Rd, MS-404 E and MS-9 S to US-82 W in Webster County
      • 3: 39880
      • 4: m
      • 5: 1770
      • 6: -89.39020065
      • 7: 33.622840849999996
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.01msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518687, 1, 'Follow US-82 W to Co Rd 512/Damgard Rd in Leflore County', 93451, 'm', 3360, -89.75845725, 33.48087175, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518687
      • 1: 1
      • 2: Follow US-82 W to Co Rd 512/Damgard Rd in Leflore County
      • 3: 93451
      • 4: m
      • 5: 3360
      • 6: -89.75845724999999
      • 7: 33.48087175
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance850μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518687, 2, 'Follow Co Rd 512 to MS-7 S', 25055, 'm', 1030, -90.29862305, 33.40135825, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518687
      • 1: 2
      • 2: Follow Co Rd 512 to MS-7 S
      • 3: 25055
      • 4: m
      • 5: 1030
      • 6: -90.29862305
      • 7: 33.40135825
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#24distance2.13msselect * from "route_waypoints" where "route_id" = 2518685
      Bindings
      • 0: 2518685
      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#103distance710μsselect * from "origin_destinations" where "origin_destinations"."id" = 889938 limit 1
      Bindings
      • 0: 889938
      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#103distance730μsselect * from "places" where "places"."id" = 62797 limit 1
      Bindings
      • 0: 62797
      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#104distance830μsselect * from "places" where "places"."id" = 56313 limit 1
      Bindings
      • 0: 56313
      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#226distance110msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.680458)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.610325333333)) + sin(radians(33.680458)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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#158distance950μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 38096 limit 1
      Bindings
      • 0: 38096
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.638298)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.707517666667)) + sin(radians(33.638298)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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.34msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 17810 limit 1
      Bindings
      • 0: 17810
      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.92msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.596138)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.80471)) + sin(radians(33.596138)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 68673 limit 1
      Bindings
      • 0: 68673
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.553978)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.901902333333)) + sin(radians(33.553978)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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#158distance830μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 22604 limit 1
      Bindings
      • 0: 22604
      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#226distance99.45msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.511818)) * cos(radians(lat)) * cos(radians(lng) - radians(-89.999094666667)) + sin(radians(33.511818)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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" = 56877 limit 1
      Bindings
      • 0: 56877
      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#226distance95.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.469658)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.096287)) + sin(radians(33.469658)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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#158distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 54299 limit 1
      Bindings
      • 0: 54299
      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#226distance86.84msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.427498)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.193479333333)) + sin(radians(33.427498)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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.76msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 26996 limit 1
      Bindings
      • 0: 26996
      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#226distance85.71msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.385338)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.290671666667)) + sin(radians(33.385338)) * 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" != 62797 and "places"."id" != 56313 order by "distance" asc limit 1
      Bindings
      • 0: 62797
      • 1: 56313
      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#158distance570μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 52663 limit 1
      Bindings
      • 0: 52663
      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" = 2518685 and "place_id" = 38096) limit 1
      Bindings
      • 0: 2518685
      • 1: 38096
      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.29msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518685, 38096, 0.11111111111111, 1, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 38096
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      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" = 2518685 and "place_id" = 17810) limit 1
      Bindings
      • 0: 2518685
      • 1: 17810
      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 (2518685, 17810, 0.22222222222222, 0, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 17810
      • 2: 0.2222222222222222
      • 3: 0
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      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" = 2518685 and "place_id" = 68673) limit 1
      Bindings
      • 0: 2518685
      • 1: 68673
      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 (2518685, 68673, 0.33333333333333, 5, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 68673
      • 2: 0.3333333333333333
      • 3: 5
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      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" = 2518685 and "place_id" = 22604) limit 1
      Bindings
      • 0: 2518685
      • 1: 22604
      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#78distance770μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518685, 22604, 0.44444444444444, 3, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 22604
      • 2: 0.4444444444444444
      • 3: 3
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518685 and "place_id" = 56877) limit 1
      Bindings
      • 0: 2518685
      • 1: 56877
      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 (2518685, 56877, 0.55555555555556, 1, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 56877
      • 2: 0.5555555555555556
      • 3: 1
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance410μsselect * from "route_waypoints" where ("route_id" = 2518685 and "place_id" = 54299) limit 1
      Bindings
      • 0: 2518685
      • 1: 54299
      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 (2518685, 54299, 0.66666666666667, 3, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 54299
      • 2: 0.6666666666666666
      • 3: 3
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      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#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518685 and "place_id" = 26996) limit 1
      Bindings
      • 0: 2518685
      • 1: 26996
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance860μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518685, 26996, 0.77777777777778, 2, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 26996
      • 2: 0.7777777777777778
      • 3: 2
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      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" = 2518685 and "place_id" = 52663) limit 1
      Bindings
      • 0: 2518685
      • 1: 52663
      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#78distance920μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518685, 52663, 0.88888888888889, 1, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 2518685
      • 1: 52663
      • 2: 0.8888888888888888
      • 3: 1
      • 4: 2025-05-18 09:04:50
      • 5: 2025-05-18 09:04:50
      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#366distance530μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518685 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518685
      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#45distance360μsselect * from "denormalised_routes" where "origin_destination_id" = 889938 limit 1
      Bindings
      • 0: 889938
      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#123distance520μsselect * from "route_directions" where "route_directions"."route_id" = 2518685 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518685
      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#198distance300μsselect * from "locations" where "locations"."id" = 62797 limit 1
      Bindings
      • 0: 62797
      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" = 43 limit 1
      Bindings
      • 0: 43
      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#330distance330μ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#198distance260μsselect * from "locations" where "locations"."id" = 56313 limit 1
      Bindings
      • 0: 56313
      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#215distance280μsselect * from "states" where "states"."id" = 43 limit 1
      Bindings
      • 0: 43
      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#330distance250μ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.7msinsert 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 (62797, 'Redding', 'Redding, MS 38929', 'redding', 'a7d7g08m', 33.722618, -89.513133, null, 'Mississippi', 'US', 'America/Chicago', 56313, 'Peteet', 'Peteet, MS 38761', 'peteet', 'ly2ydcz6', 33.343178, -90.387864, null, 'Mississippi', 'US', 'America/Chicago', 2518685, 'MS-8 W and MS-7 S', 116003, 'm', 4887, 72.080900113, 116003, '1 hour 21 minutes', '1 hour 21 minutes', 116.003, '116 km', null, 81, 0, 'No', '72.1 mi', 56.792194916251, 0.056792194916251, '"[{\"id\":8350707,\"route_id\":2518685,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":6232,\"distance_unit\":\"m\",\"time\":\"291\",\"latitude\":-89.5339391,\"longitude\":33.7421065,\"is_sub_step\":false},{\"id\":8350708,\"route_id\":2518685,\"step_index\":\"1\",\"instruction\":\"Continue on MS-8 W. Take MS-7 S to Co Rd 512\\\/Damgard Rd in Leflore County\",\"distance\":84716,\"distance_unit\":\"m\",\"time\":\"3566\",\"latitude\":-89.8823567,\"longitude\":33.6234654,\"is_sub_step\":false},{\"id\":8350709,\"route_id\":2518685,\"step_index\":\"2\",\"instruction\":\"Follow Co Rd 512 to MS-7 S\",\"distance\":10086,\"distance_unit\":\"m\",\"time\":\"483\",\"latitude\":-90.2546826,\"longitude\":33.4490962,\"is_sub_step\":false},{\"id\":8350710,\"route_id\":2518685,\"step_index\":\"3\",\"instruction\":\"\",\"distance\":14969,\"distance_unit\":\"m\",\"time\":\"547\",\"latitude\":-90.3443264,\"longitude\":33.3930578,\"is_sub_step\":false}]"', 116003, 116003, '22 minutes', 0, 'southwest', 'northeast', '[{"name":"Lilac","description":"81 mi to destination","state":"Mississippi","country":"US","full_address":"Lilac, MS 38925","lat":"33.669564","lng":"-89.588412","fraction":0.1111111111111111,"type":"State","distance_km":1,"place_id":38096,"slug":"lilac","hash":"30bz3gc1"},{"name":"Duck Hill","description":"Traveled 20 mi from origin","state":"Mississippi","country":"US","full_address":"Duck Hill, MS 38925","lat":"33.633175","lng":"-89.711194","fraction":0.2222222222222222,"type":"City","distance_km":0,"place_id":17810,"slug":"duck-hill","hash":"dbasalei"},{"name":"McCarley","description":"61 mi to destination","state":"Mississippi","country":"US","full_address":"McCarley, MS 38967","lat":"33.523178","lng":"-89.833972","fraction":0.3333333333333333,"type":"City","distance_km":5,"place_id":68673,"slug":"mccarley","hash":"t32xcj39"},{"name":"North Carrollton","description":"Traveled 41 mi from origin","state":"Mississippi","country":"US","full_address":"North Carrollton, MS","lat":"33.518177","lng":"-89.920639","fraction":0.4444444444444444,"type":"City","distance_km":3,"place_id":22604,"slug":"north-carrollton","hash":"bp22n8a9"},{"name":"Malmaison","description":"41 mi to destination","state":"Mississippi","country":"US","full_address":"Malmaison, MS 38917","lat":"33.522343","lng":"-90.007306","fraction":0.5555555555555556,"type":"State","distance_km":1,"place_id":56877,"slug":"malmaison","hash":"x9cmp15l"},{"name":"Valley Hill","description":"Traveled 61 mi from origin","state":"Mississippi","country":"US","full_address":"Valley Hill, MS 38930","lat":"33.504288","lng":"-90.061195","fraction":0.6666666666666666,"type":"City","distance_km":3,"place_id":54299,"slug":"valley-hill","hash":"z05bsj5r"},{"name":"Sidon","description":"20 mi to destination","state":"Mississippi","country":"US","full_address":"Sidon, MS 38954","lat":"33.408041","lng":"-90.208641","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":26996,"slug":"sidon","hash":"g1c4716f"},{"name":"Phillipstown","description":"Traveled 81 mi from origin","state":"Mississippi","country":"US","full_address":"Phillipstown, MS 38954","lat":"33.389289","lng":"-90.278973","fraction":0.8888888888888888,"type":"City","distance_km":1,"place_id":52663,"slug":"phillipstown","hash":"ddtst6bc"}]', 1, 8, '{"distanceInMiles":72.08110156958753,"distanceMilesFormatted":"72.1 miles","distanceFormatted":"72.1 miles","distanceKmFormatted":"116 km","timeHours":1.35,"timeFormatted":"1 hour 21 minutes","avgSpeed":52,"routeDescriptors":["mixed highways and local roads","substantial"],"journeyType":"major journey","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southwest"}', null, 'redding-a7d7g08m/peteet-ly2ydcz6', 0, null, null, 0, '"[{\"name\":\"Lilac\",\"description\":\"81 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Lilac, MS 38925\",\"lat\":\"33.669564\",\"lng\":\"-89.588412\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":1,\"place_id\":38096,\"slug\":\"lilac\",\"hash\":\"30bz3gc1\"},{\"name\":\"Duck Hill\",\"description\":\"Traveled 20 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Duck Hill, MS 38925\",\"lat\":\"33.633175\",\"lng\":\"-89.711194\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":0,\"place_id\":17810,\"slug\":\"duck-hill\",\"hash\":\"dbasalei\"},{\"name\":\"McCarley\",\"description\":\"61 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"McCarley, MS 38967\",\"lat\":\"33.523178\",\"lng\":\"-89.833972\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":5,\"place_id\":68673,\"slug\":\"mccarley\",\"hash\":\"t32xcj39\"},{\"name\":\"North Carrollton\",\"description\":\"Traveled 41 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"North Carrollton, MS\",\"lat\":\"33.518177\",\"lng\":\"-89.920639\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":3,\"place_id\":22604,\"slug\":\"north-carrollton\",\"hash\":\"bp22n8a9\"},{\"name\":\"Malmaison\",\"description\":\"41 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Malmaison, MS 38917\",\"lat\":\"33.522343\",\"lng\":\"-90.007306\",\"fraction\":0.5555555555555556,\"type\":\"State\",\"distance_km\":1,\"place_id\":56877,\"slug\":\"malmaison\",\"hash\":\"x9cmp15l\"},{\"name\":\"Valley Hill\",\"description\":\"Traveled 61 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Valley Hill, MS 38930\",\"lat\":\"33.504288\",\"lng\":\"-90.061195\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":3,\"place_id\":54299,\"slug\":\"valley-hill\",\"hash\":\"z05bsj5r\"},{\"name\":\"Sidon\",\"description\":\"20 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Sidon, MS 38954\",\"lat\":\"33.408041\",\"lng\":\"-90.208641\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":26996,\"slug\":\"sidon\",\"hash\":\"g1c4716f\"},{\"name\":\"Phillipstown\",\"description\":\"Traveled 81 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Phillipstown, MS 38954\",\"lat\":\"33.389289\",\"lng\":\"-90.278973\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":1,\"place_id\":52663,\"slug\":\"phillipstown\",\"hash\":\"ddtst6bc\"}]"', 4, 889938, '2025-05-18 09:04:50', '2025-05-18 09:04:50') returning "id"
      Bindings
      • 0: 62797
      • 1: Redding
      • 2: Redding, MS 38929
      • 3: redding
      • 4: a7d7g08m
      • 5: 33.722618
      • 6: -89.513133
      • 7: 
      • 8: Mississippi
      • 9: US
      • 10: America/Chicago
      • 11: 56313
      • 12: Peteet
      • 13: Peteet, MS 38761
      • 14: peteet
      • 15: ly2ydcz6
      • 16: 33.343178
      • 17: -90.387864
      • 18: 
      • 19: Mississippi
      • 20: US
      • 21: America/Chicago
      • 22: 2518685
      • 23: MS-8 W and MS-7 S
      • 24: 116003
      • 25: m
      • 26: 4887
      • 27: 72.080900113
      • 28: 116003
      • 29: 1 hour 21 minutes
      • 30: 1 hour 21 minutes
      • 31: 116.003
      • 32: 116 km
      • 33: 
      • 34: 81
      • 35: 0
      • 36: No
      • 37: 72.1 mi
      • 38: 56.79219491625124
      • 39: 0.05679219491625124
      • 40: "[{\"id\":8350707,\"route_id\":2518685,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":6232,\"distance_unit\":\"m\",\"time\":\"291\",\"latitude\":-89.5339391,\"longitude\":33.7421065,\"is_sub_step\":false},{\"id\":8350708,\"route_id\":2518685,\"step_index\":\"1\",\"instruction\":\"Continue on MS-8 W. Take MS-7 S to Co Rd 512\\\/Damgard Rd in Leflore County\",\"distance\":84716,\"distance_unit\":\"m\",\"time\":\"3566\",\"latitude\":-89.8823567,\"longitude\":33.6234654,\"is_sub_step\":false},{\"id\":8350709,\"route_id\":2518685,\"step_index\":\"2\",\"instruction\":\"Follow Co Rd 512 to MS-7 S\",\"distance\":10086,\"distance_unit\":\"m\",\"time\":\"483\",\"latitude\":-90.2546826,\"longitude\":33.4490962,\"is_sub_step\":false},{\"id\":8350710,\"route_id\":2518685,\"step_index\":\"3\",\"instruction\":\"\",\"distance\":14969,\"distance_unit\":\"m\",\"time\":\"547\",\"latitude\":-90.3443264,\"longitude\":33.3930578,\"is_sub_step\":false}]"
      • 41: 116003
      • 42: 116003
      • 43: 22 minutes
      • 44: 0
      • 45: southwest
      • 46: northeast
      • 47: [{"name":"Lilac","description":"81 mi to destination","state":"Mississippi","country":"US","full_address":"Lilac, MS 38925","lat":"33.669564","lng":"-89.588412","fraction":0.1111111111111111,"type":"State","distance_km":1,"place_id":38096,"slug":"lilac","hash":"30bz3gc1"},{"name":"Duck Hill","description":"Traveled 20 mi from origin","state":"Mississippi","country":"US","full_address":"Duck Hill, MS 38925","lat":"33.633175","lng":"-89.711194","fraction":0.2222222222222222,"type":"City","distance_km":0,"place_id":17810,"slug":"duck-hill","hash":"dbasalei"},{"name":"McCarley","description":"61 mi to destination","state":"Mississippi","country":"US","full_address":"McCarley, MS 38967","lat":"33.523178","lng":"-89.833972","fraction":0.3333333333333333,"type":"City","distance_km":5,"place_id":68673,"slug":"mccarley","hash":"t32xcj39"},{"name":"North Carrollton","description":"Traveled 41 mi from origin","state":"Mississippi","country":"US","full_address":"North Carrollton, MS","lat":"33.518177","lng":"-89.920639","fraction":0.4444444444444444,"type":"City","distance_km":3,"place_id":22604,"slug":"north-carrollton","hash":"bp22n8a9"},{"name":"Malmaison","description":"41 mi to destination","state":"Mississippi","country":"US","full_address":"Malmaison, MS 38917","lat":"33.522343","lng":"-90.007306","fraction":0.5555555555555556,"type":"State","distance_km":1,"place_id":56877,"slug":"malmaison","hash":"x9cmp15l"},{"name":"Valley Hill","description":"Traveled 61 mi from origin","state":"Mississippi","country":"US","full_address":"Valley Hill, MS 38930","lat":"33.504288","lng":"-90.061195","fraction":0.6666666666666666,"type":"City","distance_km":3,"place_id":54299,"slug":"valley-hill","hash":"z05bsj5r"},{"name":"Sidon","description":"20 mi to destination","state":"Mississippi","country":"US","full_address":"Sidon, MS 38954","lat":"33.408041","lng":"-90.208641","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":26996,"slug":"sidon","hash":"g1c4716f"},{"name":"Phillipstown","description":"Traveled 81 mi from origin","state":"Mississippi","country":"US","full_address":"Phillipstown, MS 38954","lat":"33.389289","lng":"-90.278973","fraction":0.8888888888888888,"type":"City","distance_km":1,"place_id":52663,"slug":"phillipstown","hash":"ddtst6bc"}]
      • 48: 1
      • 49: 8
      • 50: {"distanceInMiles":72.08110156958753,"distanceMilesFormatted":"72.1 miles","distanceFormatted":"72.1 miles","distanceKmFormatted":"116 km","timeHours":1.35,"timeFormatted":"1 hour 21 minutes","avgSpeed":52,"routeDescriptors":["mixed highways and local roads","substantial"],"journeyType":"major journey","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southwest"}
      • 51: 
      • 52: redding-a7d7g08m/peteet-ly2ydcz6
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Lilac\",\"description\":\"81 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Lilac, MS 38925\",\"lat\":\"33.669564\",\"lng\":\"-89.588412\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":1,\"place_id\":38096,\"slug\":\"lilac\",\"hash\":\"30bz3gc1\"},{\"name\":\"Duck Hill\",\"description\":\"Traveled 20 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Duck Hill, MS 38925\",\"lat\":\"33.633175\",\"lng\":\"-89.711194\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":0,\"place_id\":17810,\"slug\":\"duck-hill\",\"hash\":\"dbasalei\"},{\"name\":\"McCarley\",\"description\":\"61 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"McCarley, MS 38967\",\"lat\":\"33.523178\",\"lng\":\"-89.833972\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":5,\"place_id\":68673,\"slug\":\"mccarley\",\"hash\":\"t32xcj39\"},{\"name\":\"North Carrollton\",\"description\":\"Traveled 41 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"North Carrollton, MS\",\"lat\":\"33.518177\",\"lng\":\"-89.920639\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":3,\"place_id\":22604,\"slug\":\"north-carrollton\",\"hash\":\"bp22n8a9\"},{\"name\":\"Malmaison\",\"description\":\"41 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Malmaison, MS 38917\",\"lat\":\"33.522343\",\"lng\":\"-90.007306\",\"fraction\":0.5555555555555556,\"type\":\"State\",\"distance_km\":1,\"place_id\":56877,\"slug\":\"malmaison\",\"hash\":\"x9cmp15l\"},{\"name\":\"Valley Hill\",\"description\":\"Traveled 61 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Valley Hill, MS 38930\",\"lat\":\"33.504288\",\"lng\":\"-90.061195\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":3,\"place_id\":54299,\"slug\":\"valley-hill\",\"hash\":\"z05bsj5r\"},{\"name\":\"Sidon\",\"description\":\"20 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Sidon, MS 38954\",\"lat\":\"33.408041\",\"lng\":\"-90.208641\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":26996,\"slug\":\"sidon\",\"hash\":\"g1c4716f\"},{\"name\":\"Phillipstown\",\"description\":\"Traveled 81 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Phillipstown, MS 38954\",\"lat\":\"33.389289\",\"lng\":\"-90.278973\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":1,\"place_id\":52663,\"slug\":\"phillipstown\",\"hash\":\"ddtst6bc\"}]"
      • 58: 4
      • 59: 889938
      • 60: 2025-05-18 09:04:50
      • 61: 2025-05-18 09:04:50
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance480μsselect exists(select "id" from "routes" where "origin_destination_id" = 889938 limit 1) as "exists"
      Bindings
      • 0: 889938
      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#1186distance640μsselect * from "routes" where "routes"."origin_destination_id" = 889938 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889938
      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#1186distance470μsselect * from "route_directions" where "route_directions"."route_id" in (2518685, 2518686, 2518687) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance1.1msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:50' where "id" = 2518685
      Bindings
      • 0: 2025-05-18 09:04:50
      • 1: 2518685
      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#235distance460μsselect * from "origin_destinations" where "origin_destinations"."id" = 889938 limit 1
      Bindings
      • 0: 889938
      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#244distance410μsselect * from "places" where "places"."id" = 62797 limit 1
      Bindings
      • 0: 62797
      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#245distance330μsselect * from "places" where "places"."id" = 56313 limit 1
      Bindings
      • 0: 56313
      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#24distance330μsselect * from "route_waypoints" where "route_id" = 2518685
      Bindings
      • 0: 2518685
      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#28distance330μsselect * from "places" where "places"."id" = 38096 limit 1
      Bindings
      • 0: 38096
      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 (38096)
      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 (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance280μ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" = 17810 limit 1
      Bindings
      • 0: 17810
      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 "locations" where "locations"."id" in (17810)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance440μsselect * from "cities" where "cities"."id" in (12091)
      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 (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance270μ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#28distance350μsselect * from "places" where "places"."id" = 68673 limit 1
      Bindings
      • 0: 68673
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance300μsselect * from "locations" where "locations"."id" in (68673)
      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 (28910)
      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 (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance280μ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#28distance2.64msselect * from "places" where "places"."id" = 22604 limit 1
      Bindings
      • 0: 22604
      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#28distance480μsselect * from "locations" where "locations"."id" in (22604)
      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 (14864)
      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 (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance340μ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#28distance350μsselect * from "places" where "places"."id" = 56877 limit 1
      Bindings
      • 0: 56877
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance300μsselect * from "locations" where "locations"."id" in (56877)
      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#28distance310μsselect * from "states" where "states"."id" in (43)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#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
    • distance380μsselect * from "places" where "places"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" in (54299)
    • distance320μsselect * from "cities" where "cities"."id" in (25691)
    • distance250μsselect * from "states" where "states"."id" in (43)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance240μsselect * from "locations" where "locations"."id" in (26996)
    • distance280μsselect * from "cities" where "cities"."id" in (17192)
    • distance240μsselect * from "states" where "states"."id" in (43)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance510μsselect * from "places" where "places"."id" = ? limit 1
    • distance1.24msselect * from "locations" where "locations"."id" in (52663)
    • distance340μsselect * from "cities" where "cities"."id" in (18968)
    • distance820μsselect * from "states" where "states"."id" in (43)
    • distance840μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance1.68msselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance430μsselect * from "route_waypoints" where "route_id" = ?
    • distance370μsselect * from "places" where "places"."id" = ? limit 1
    • distance350μsselect * from "locations" where "locations"."id" in (38096)
    • distance1.68msselect * from "states" where "states"."id" in (43)
    • distance540μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance500μsselect * from "places" where "places"."id" = ? limit 1
    • distance390μsselect * from "locations" where "locations"."id" in (17810)
    • distance340μsselect * from "cities" where "cities"."id" in (12091)
    • distance370μsselect * from "states" where "states"."id" in (43)
    • distance370μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance450μsselect * from "places" where "places"."id" = ? limit 1
    • distance330μsselect * from "locations" where "locations"."id" in (68673)
    • distance360μsselect * from "cities" where "cities"."id" in (28910)
    • distance330μsselect * from "states" where "states"."id" in (43)
    • distance390μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance410μsselect * from "places" where "places"."id" = ? limit 1
    • distance360μsselect * from "locations" where "locations"."id" in (22604)
    • distance330μsselect * from "cities" where "cities"."id" in (14864)
    • distance350μsselect * from "states" where "states"."id" in (43)
    • distance380μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance430μsselect * from "places" where "places"."id" = ? limit 1
    • distance470μsselect * from "locations" where "locations"."id" in (56877)
    • distance360μsselect * from "states" where "states"."id" in (43)
    • distance290μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance310μsselect * from "places" where "places"."id" = ? limit 1
    • distance270μsselect * from "locations" where "locations"."id" in (54299)
    • distance220μsselect * from "cities" where "cities"."id" in (25691)
    • distance220μsselect * from "states" where "states"."id" in (43)
    • distance270μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance270μsselect * from "places" where "places"."id" = ? limit 1
    • distance230μsselect * from "locations" where "locations"."id" in (26996)
    • distance250μsselect * from "cities" where "cities"."id" in (17192)
    • distance210μsselect * from "states" where "states"."id" in (43)
    • distance260μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance280μsselect * from "places" where "places"."id" = ? limit 1
    • distance220μsselect * from "locations" where "locations"."id" in (52663)
    • distance230μsselect * from "cities" where "cities"."id" in (18968)
    • distance220μsselect * from "states" where "states"."id" in (43)
    • distance230μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance230μsselect * from "states" where "states"."id" = ? limit 1
    • distance230μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance250μsselect * from "states" where "states"."id" = ? limit 1
    • distance380μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance370μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance2.09msupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance370μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.39msselect * from "images" where "images"."place_id" in (62797)
    • distance520μsselect * from "places" where "places"."id" = ? limit 1
    • distance24.77msselect * from "images" where "images"."place_id" in (56313)
    • distance770μsselect * from "routes" where "origin_destination_id" = ?
    • distance580μ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"
    • distance540μsselect * from "route_directions" where "route_directions"."route_id" in (2518685, 2518686, 2518687) order by "step_index" asc, "step_index" asc
    • distance800μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance420μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance400μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance790μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance780μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance380μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance560μ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\RouteDirection
    24RouteDirection.php#?
    App\Models\RouteWaypoint
    24RouteWaypoint.php#?
    App\Models\Location
    20Location.php#?
    App\Models\State
    20State.php#?
    App\Models\Country
    18Country.php#?
    App\Models\City
    12City.php#?
    App\Models\Route
    7Route.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:50GET/distance/redding-a7d7g08m/peteet-ly2ydcz6422176156