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

Just a moment while we calculate your route...

Distance from Peytona Points to Lock Three

Driving Distance
16.8 mi • 27.1 km
Flying Distance
8.2 mi • 13.3 km
A
B
Leaflet © OpenStreetMap contributors
45 mph avg speed
East direction
22 min travel time

Route Information

The driving distance from Peytona Points, Alabama to Lock Three, Alabama is 16.8 mi (27.1 km)

The straight-line (air) distance is 8.2 mi (13.3 km)

The estimated flight time is 0 hr 1 min

The estimated travel time by road is 22 minutes

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

Location Details

Origin:


No image available
Place Peytona Points
State/Province Alabama
Country US
Latitude 34.806198
Longitude -87.555304
GPS 34.806198° N, 87.555304° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Lock Three
State/Province Alabama
Country US
Latitude 34.811754
Longitude -87.410578
GPS 34.811754° N, 87.410578° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Peytona Points, Alabama to Lock Three, Alabama covers 16.8 mi (27.1 km) in a east direction. This mixed highways and local roads, moderate route typically takes 22 minutes under normal conditions.

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

How is the distance calculated?

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

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

Journey Waypoints

Peytona Points
Alabama , US
Paradise Points
Alabama, US
0.6 mi
Ford City
Alabama, US
2.0 mi
Brooks Acres
Alabama, US
3.5 mi
Aqua Vista
Alabama, US
4.3 mi
Houstontown
Alabama, US
7.0 mi
Lock Three
Alabama , US
Messages16RequestTimelineExceptionsViews2Queries128Models60MailsGate
SettingsRequest history3.92sRequest 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/peytona-points-izfl3ne5/lock-three-zfunll46
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:26] LOG.warning: No denormalized route found for origin-destination ID: 889907
  • infolog[09:04:26] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 46...
  • infolog[09:04:26] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:27] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:27] LOG.info: Processing route #1 data for origin-destination ID: 889907 { "origin": "Pey...
  • infolog[09:04:27] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:27] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:27] LOG.info: Ignoring 7 nested sub-directions for direction index 0
  • infolog[09:04:27] LOG.info: Saved 1 directions for route ID: 2518608
  • infolog[09:04:27] LOG.info: Found a shorter route: 27096 meters for route ID: 2518608
  • infolog[09:04:28] LOG.info: Successfully denormalized route data { "origin_destination_id": 889907, ...
  • infolog[09:04:28] LOG.info: Saved 1 routes for origin-destination ID: 889907
  • infolog[09:04:28] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518608, ...
  • infolog[09:04:28] LOG.info: Incremented view count for route { "id": 2518608, "name": "River Rd and...
  • infolog[09:04:29] LOG.info: Updated denormalized route for route { "route_id": 2518608, "views": 1 ...
  • infolog[09:04:29] LOG.info: Found existing routes { "route_count": 1, "default_route_id": 2518608, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/peytona-points-izfl3ne5/lock-three-zfunll46
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
3.92s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a2fc7dc06c97c-IAD"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:29 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "YK3TNyD0UYisRRcgnF9hqk9OOVlvlw8RShO7W7t3"
]
  • Booting (11.54ms)time
  • Application (3.91s)time
  • Routing (476μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (32μs)
  • 1 x Application (99.71%)
    3.91s
    1 x Booting (0.29%)
    11.54ms
    1 x Routing (0.01%)
    476μs
    1 x Preparing Response (0%)
    32μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    128 statements were executed (93 duplicates)Show only duplicatesdistance2.29s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 28 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance19.39msselect * from "sessions" where "id" = 'Qn0OQl6hMVvKgnICMgy66pJPQdMimOusUOVyKQ3G' limit 1
      Bindings
      • 0: Qn0OQl6hMVvKgnICMgy66pJPQdMimOusUOVyKQ3G
      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#548distance14.16msselect * from "places" where "slug" = 'peytona-points' and ("hash" = 'izfl3ne5') limit 1
      Bindings
      • 0: peytona-points
      • 1: izfl3ne5
      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#548distance760μsselect * from "places" where "slug" = 'lock-three' and ("hash" = 'zfunll46') limit 1
      Bindings
      • 0: lock-three
      • 1: zfunll46
      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#104distance830μsselect * from "origin_destinations" where ("origin_id" = 46086 and "destination_id" = 81379) limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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.86msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (46086, 81379, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 46086
      • 1: 81379
      • 2: 2025-05-18 09:04:26
      • 3: 2025-05-18 09:04:26
      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#256distance2.93msselect * from "denormalised_routes" where "origin_destination_id" = 889907 limit 1
      Bindings
      • 0: 889907
      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#70distance1msselect exists(select "id" from "routes" where "origin_destination_id" = 889907 limit 1) as "exists"
      Bindings
      • 0: 889907
      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#158distance900μsdelete from "routes" where "origin_destination_id" = 889907
      Bindings
      • 0: 889907
      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#172distance710μsselect * from "places" where "places"."id" = 46086 limit 1
      Bindings
      • 0: 46086
      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#173distance890μsselect * from "places" where "places"."id" = 81379 limit 1
      Bindings
      • 0: 81379
      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#225distance6.59msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889907, 'River Rd and AL-101 N', 27096, 'm', 1369, 0, 'No', 34.7682448, 34.8220464, null, 0, '2025-05-18 09:04:27', '2025-05-18 09:04:27') returning "id"
      Bindings
      • 0: 889907
      • 1: River Rd and AL-101 N
      • 2: 27096
      • 3: m
      • 4: 1369
      • 5: 0
      • 6: No
      • 7: 34.7682448
      • 8: 34.8220464
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:27
      • 12: 2025-05-18 09:04:27
      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.42msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518608, 0, '', 27096, 'm', 1369, -87.46744905, 34.7951456, 0, '2025-05-18 09:04:27', '2025-05-18 09:04:27') returning "id"
      Bindings
      • 0: 2518608
      • 1: 0
      • 2: 
      • 3: 27096
      • 4: m
      • 5: 1369
      • 6: -87.46744905
      • 7: 34.7951456
      • 8: 0
      • 9: 2025-05-18 09:04:27
      • 10: 2025-05-18 09:04:27
      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#24distance950μsselect * from "route_waypoints" where "route_id" = 2518608
      Bindings
      • 0: 2518608
      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#103distance360μsselect * from "origin_destinations" where "origin_destinations"."id" = 889907 limit 1
      Bindings
      • 0: 889907
      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#103distance440μsselect * from "places" where "places"."id" = 46086 limit 1
      Bindings
      • 0: 46086
      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#104distance390μsselect * from "places" where "places"."id" = 81379 limit 1
      Bindings
      • 0: 81379
      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#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.806815333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.539223333333)) + sin(radians(34.806815333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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#158distance810μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 85027 limit 1
      Bindings
      • 0: 85027
      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#226distance84.1msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.807432666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.523142666667)) + sin(radians(34.807432666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance510μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 63119 limit 1
      Bindings
      • 0: 63119
      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#226distance84.96msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.80805)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.507062)) + sin(radians(34.80805)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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#158distance890μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 97835 limit 1
      Bindings
      • 0: 97835
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.92msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.808667333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.490981333333)) + sin(radians(34.808667333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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" = 83283 limit 1
      Bindings
      • 0: 83283
      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#226distance84.78msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.809284666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.474900666667)) + sin(radians(34.809284666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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#226distance86.75msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.809902)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.45882)) + sin(radians(34.809902)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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.29msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 71410 limit 1
      Bindings
      • 0: 71410
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.26msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.810519333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.442739333333)) + sin(radians(34.810519333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance88.05msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.811136666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.426658666667)) + sin(radians(34.811136666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      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#78distance420μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 85027) limit 1
      Bindings
      • 0: 2518608
      • 1: 85027
      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.36msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518608, 85027, 0.11111111111111, 1, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 2518608
      • 1: 85027
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:28
      • 5: 2025-05-18 09:04:28
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 63119) limit 1
      Bindings
      • 0: 2518608
      • 1: 63119
      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#78distance790μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518608, 63119, 0.22222222222222, 1, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 2518608
      • 1: 63119
      • 2: 0.2222222222222222
      • 3: 1
      • 4: 2025-05-18 09:04:28
      • 5: 2025-05-18 09:04:28
      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#78distance250μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 97835) limit 1
      Bindings
      • 0: 2518608
      • 1: 97835
      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.02msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518608, 97835, 0.33333333333333, 2, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 2518608
      • 1: 97835
      • 2: 0.3333333333333333
      • 3: 2
      • 4: 2025-05-18 09:04:28
      • 5: 2025-05-18 09:04:28
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance270μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 83283) limit 1
      Bindings
      • 0: 2518608
      • 1: 83283
      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#78distance730μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518608, 83283, 0.44444444444444, 2, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 2518608
      • 1: 83283
      • 2: 0.4444444444444444
      • 3: 2
      • 4: 2025-05-18 09:04:28
      • 5: 2025-05-18 09:04:28
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 71410) limit 1
      Bindings
      • 0: 2518608
      • 1: 71410
      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#78distance700μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518608, 71410, 0.66666666666667, 2, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 2518608
      • 1: 71410
      • 2: 0.6666666666666666
      • 3: 2
      • 4: 2025-05-18 09:04:28
      • 5: 2025-05-18 09:04:28
      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#366distance940μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518608 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518608
      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#45distance620μsselect * from "denormalised_routes" where "origin_destination_id" = 889907 limit 1
      Bindings
      • 0: 889907
      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#123distance730μsselect * from "route_directions" where "route_directions"."route_id" = 2518608 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518608
      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#198distance410μsselect * from "locations" where "locations"."id" = 46086 limit 1
      Bindings
      • 0: 46086
      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#215distance470μsselect * from "states" where "states"."id" = 9 limit 1
      Bindings
      • 0: 9
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:154
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance340μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:155
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance270μsselect * from "locations" where "locations"."id" = 81379 limit 1
      Bindings
      • 0: 81379
      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#215distance310μsselect * from "states" where "states"."id" = 9 limit 1
      Bindings
      • 0: 9
      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#330distance380μ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.83msinsert 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 (46086, 'Peytona Points', 'Peytona Points, AL 35661', 'peytona-points', 'izfl3ne5', 34.806198, -87.555304, null, 'Alabama', 'US', 'America/Chicago', 81379, 'Lock Three', 'Lock Three, AL 35652', 'lock-three', 'zfunll46', 34.811754, -87.410578, null, 'Alabama', 'US', 'America/Chicago', 2518608, 'River Rd and AL-101 N', 27096, 'm', 1369, 16.836668616, 27096, '22 minutes', '22 minutes', 27.096, '27.1 km', null, 23, 0, 'No', '16.8 mi', 8.2192361528827, 0.0082192361528827, '"[{\"id\":8350458,\"route_id\":2518608,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":27096,\"distance_unit\":\"m\",\"time\":\"1369\",\"latitude\":-87.4674491,\"longitude\":34.7951456,\"is_sub_step\":false}]"', 27096, 27096, 'no time', 0, 'east', 'west', '[{"name":"Paradise Points","description":"12 mi to destination","state":"Alabama","country":"US","full_address":"Paradise Points, AL 35661","lat":"34.799254","lng":"-87.549748","fraction":0.1111111111111111,"type":"State","distance_km":1,"place_id":85027,"slug":"paradise-points","hash":"mh37drhe"},{"name":"Ford City","description":"Traveled 3 mi from origin","state":"Alabama","country":"US","full_address":"Ford City, AL 35661","lat":"34.786369","lng":"-87.528946","fraction":0.2222222222222222,"type":"City","distance_km":1,"place_id":63119,"slug":"ford-city","hash":"biyplcxm"},{"name":"Brooks Acres","description":"9 mi to destination","state":"Alabama","country":"US","full_address":"Brooks Acres, AL 35645","lat":"34.834809","lng":"-87.505303","fraction":0.3333333333333333,"type":"State","distance_km":2,"place_id":97835,"slug":"brooks-acres","hash":"vbtgo67y"},{"name":"Aqua Vista","description":"Traveled 6 mi from origin","state":"Alabama","country":"US","full_address":"Aqua Vista, AL 35645","lat":"34.830364","lng":"-87.485302","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":83283,"slug":"aqua-vista","hash":"hxmkzif7"},{"name":"Houstontown","description":"Traveled 9 mi from origin","state":"Alabama","country":"US","full_address":"Houstontown, AL 35645","lat":"34.827309","lng":"-87.435023","fraction":0.6666666666666666,"type":"State","distance_km":2,"place_id":71410,"slug":"houstontown","hash":"n1dmqvr3"}]', 1, 5, '{"distanceInMiles":16.836715672263164,"distanceMilesFormatted":"16.8 miles","distanceFormatted":"16.8 miles","distanceKmFormatted":"27 km","timeHours":0.36666666666666664,"timeFormatted":"22 minutes","avgSpeed":45,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"east"}', null, 'peytona-points-izfl3ne5/lock-three-zfunll46', 0, null, null, 0, '"[{\"name\":\"Paradise Points\",\"description\":\"12 mi to destination\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Paradise Points, AL 35661\",\"lat\":\"34.799254\",\"lng\":\"-87.549748\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":1,\"place_id\":85027,\"slug\":\"paradise-points\",\"hash\":\"mh37drhe\"},{\"name\":\"Ford City\",\"description\":\"Traveled 3 mi from origin\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Ford City, AL 35661\",\"lat\":\"34.786369\",\"lng\":\"-87.528946\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":1,\"place_id\":63119,\"slug\":\"ford-city\",\"hash\":\"biyplcxm\"},{\"name\":\"Brooks Acres\",\"description\":\"9 mi to destination\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Brooks Acres, AL 35645\",\"lat\":\"34.834809\",\"lng\":\"-87.505303\",\"fraction\":0.3333333333333333,\"type\":\"State\",\"distance_km\":2,\"place_id\":97835,\"slug\":\"brooks-acres\",\"hash\":\"vbtgo67y\"},{\"name\":\"Aqua Vista\",\"description\":\"Traveled 6 mi from origin\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Aqua Vista, AL 35645\",\"lat\":\"34.830364\",\"lng\":\"-87.485302\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":83283,\"slug\":\"aqua-vista\",\"hash\":\"hxmkzif7\"},{\"name\":\"Houstontown\",\"description\":\"Traveled 9 mi from origin\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Houstontown, AL 35645\",\"lat\":\"34.827309\",\"lng\":\"-87.435023\",\"fraction\":0.6666666666666666,\"type\":\"State\",\"distance_km\":2,\"place_id\":71410,\"slug\":\"houstontown\",\"hash\":\"n1dmqvr3\"}]"', 1, 889907, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 46086
      • 1: Peytona Points
      • 2: Peytona Points, AL 35661
      • 3: peytona-points
      • 4: izfl3ne5
      • 5: 34.806198
      • 6: -87.555304
      • 7: 
      • 8: Alabama
      • 9: US
      • 10: America/Chicago
      • 11: 81379
      • 12: Lock Three
      • 13: Lock Three, AL 35652
      • 14: lock-three
      • 15: zfunll46
      • 16: 34.811754
      • 17: -87.410578
      • 18: 
      • 19: Alabama
      • 20: US
      • 21: America/Chicago
      • 22: 2518608
      • 23: River Rd and AL-101 N
      • 24: 27096
      • 25: m
      • 26: 1369
      • 27: 16.836668616
      • 28: 27096
      • 29: 22 minutes
      • 30: 22 minutes
      • 31: 27.096
      • 32: 27.1 km
      • 33: 
      • 34: 23
      • 35: 0
      • 36: No
      • 37: 16.8 mi
      • 38: 8.219236152882715
      • 39: 0.008219236152882715
      • 40: "[{\"id\":8350458,\"route_id\":2518608,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":27096,\"distance_unit\":\"m\",\"time\":\"1369\",\"latitude\":-87.4674491,\"longitude\":34.7951456,\"is_sub_step\":false}]"
      • 41: 27096
      • 42: 27096
      • 43: no time
      • 44: 0
      • 45: east
      • 46: west
      • 47: [{"name":"Paradise Points","description":"12 mi to destination","state":"Alabama","country":"US","full_address":"Paradise Points, AL 35661","lat":"34.799254","lng":"-87.549748","fraction":0.1111111111111111,"type":"State","distance_km":1,"place_id":85027,"slug":"paradise-points","hash":"mh37drhe"},{"name":"Ford City","description":"Traveled 3 mi from origin","state":"Alabama","country":"US","full_address":"Ford City, AL 35661","lat":"34.786369","lng":"-87.528946","fraction":0.2222222222222222,"type":"City","distance_km":1,"place_id":63119,"slug":"ford-city","hash":"biyplcxm"},{"name":"Brooks Acres","description":"9 mi to destination","state":"Alabama","country":"US","full_address":"Brooks Acres, AL 35645","lat":"34.834809","lng":"-87.505303","fraction":0.3333333333333333,"type":"State","distance_km":2,"place_id":97835,"slug":"brooks-acres","hash":"vbtgo67y"},{"name":"Aqua Vista","description":"Traveled 6 mi from origin","state":"Alabama","country":"US","full_address":"Aqua Vista, AL 35645","lat":"34.830364","lng":"-87.485302","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":83283,"slug":"aqua-vista","hash":"hxmkzif7"},{"name":"Houstontown","description":"Traveled 9 mi from origin","state":"Alabama","country":"US","full_address":"Houstontown, AL 35645","lat":"34.827309","lng":"-87.435023","fraction":0.6666666666666666,"type":"State","distance_km":2,"place_id":71410,"slug":"houstontown","hash":"n1dmqvr3"}]
      • 48: 1
      • 49: 5
      • 50: {"distanceInMiles":16.836715672263164,"distanceMilesFormatted":"16.8 miles","distanceFormatted":"16.8 miles","distanceKmFormatted":"27 km","timeHours":0.36666666666666664,"timeFormatted":"22 minutes","avgSpeed":45,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"east"}
      • 51: 
      • 52: peytona-points-izfl3ne5/lock-three-zfunll46
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Paradise Points\",\"description\":\"12 mi to destination\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Paradise Points, AL 35661\",\"lat\":\"34.799254\",\"lng\":\"-87.549748\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":1,\"place_id\":85027,\"slug\":\"paradise-points\",\"hash\":\"mh37drhe\"},{\"name\":\"Ford City\",\"description\":\"Traveled 3 mi from origin\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Ford City, AL 35661\",\"lat\":\"34.786369\",\"lng\":\"-87.528946\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":1,\"place_id\":63119,\"slug\":\"ford-city\",\"hash\":\"biyplcxm\"},{\"name\":\"Brooks Acres\",\"description\":\"9 mi to destination\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Brooks Acres, AL 35645\",\"lat\":\"34.834809\",\"lng\":\"-87.505303\",\"fraction\":0.3333333333333333,\"type\":\"State\",\"distance_km\":2,\"place_id\":97835,\"slug\":\"brooks-acres\",\"hash\":\"vbtgo67y\"},{\"name\":\"Aqua Vista\",\"description\":\"Traveled 6 mi from origin\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Aqua Vista, AL 35645\",\"lat\":\"34.830364\",\"lng\":\"-87.485302\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":83283,\"slug\":\"aqua-vista\",\"hash\":\"hxmkzif7\"},{\"name\":\"Houstontown\",\"description\":\"Traveled 9 mi from origin\",\"state\":\"Alabama\",\"country\":\"US\",\"full_address\":\"Houstontown, AL 35645\",\"lat\":\"34.827309\",\"lng\":\"-87.435023\",\"fraction\":0.6666666666666666,\"type\":\"State\",\"distance_km\":2,\"place_id\":71410,\"slug\":\"houstontown\",\"hash\":\"n1dmqvr3\"}]"
      • 58: 1
      • 59: 889907
      • 60: 2025-05-18 09:04:28
      • 61: 2025-05-18 09:04:28
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance420μsselect exists(select "id" from "routes" where "origin_destination_id" = 889907 limit 1) as "exists"
      Bindings
      • 0: 889907
      Backtrace
      • app/Models/OriginDestination.php:70
      • app/Services/DistanceCalculationService.php:1179
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#1186distance660μsselect * from "routes" where "routes"."origin_destination_id" = 889907 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889907
      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#1186distance430μsselect * from "route_directions" where "route_directions"."route_id" in (2518608) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance1.07msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:28' where "id" = 2518608
      Bindings
      • 0: 2025-05-18 09:04:28
      • 1: 2518608
      Backtrace
      • app/Models/Route.php:225
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#235distance390μsselect * from "origin_destinations" where "origin_destinations"."id" = 889907 limit 1
      Bindings
      • 0: 889907
      Backtrace
      • app/Models/Route.php:235
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#244distance430μsselect * from "places" where "places"."id" = 46086 limit 1
      Bindings
      • 0: 46086
      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#245distance420μsselect * from "places" where "places"."id" = 81379 limit 1
      Bindings
      • 0: 81379
      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" = 2518608
      Bindings
      • 0: 2518608
      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#103distance360μsselect * from "places" where "places"."id" = 46086 limit 1
      Bindings
      • 0: 46086
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#104distance390μsselect * from "places" where "places"."id" = 81379 limit 1
      Bindings
      • 0: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance90.39msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.806815333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.539223333333)) + sin(radians(34.806815333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 85027 limit 1
      Bindings
      • 0: 85027
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance92.21msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.807432666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.523142666667)) + sin(radians(34.807432666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 63119 limit 1
      Bindings
      • 0: 63119
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance87.97msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.80805)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.507062)) + sin(radians(34.80805)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 97835 limit 1
      Bindings
      • 0: 97835
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance97.44msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.808667333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.490981333333)) + sin(radians(34.808667333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance710μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 83283 limit 1
      Bindings
      • 0: 83283
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance90.34msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.809284666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.474900666667)) + sin(radians(34.809284666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance92.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.809902)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.45882)) + sin(radians(34.809902)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance570μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 71410 limit 1
      Bindings
      • 0: 71410
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance88.41msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.810519333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.442739333333)) + sin(radians(34.810519333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance88.03msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.811136666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.426658666667)) + sin(radians(34.811136666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#78distance540μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 85027) limit 1
      Bindings
      • 0: 2518608
      • 1: 85027
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance1.01msupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:29' where "id" = 6300266
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:29
      • 2: 6300266
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 63119) limit 1
      Bindings
      • 0: 2518608
      • 1: 63119
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance680μsupdate "route_waypoints" set "fraction" = 0.22222222222222, "updated_at" = '2025-05-18 09:04:29' where "id" = 6300267
      Bindings
      • 0: 0.2222222222222222
      • 1: 2025-05-18 09:04:29
      • 2: 6300267
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance340μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 97835) limit 1
      Bindings
      • 0: 2518608
      • 1: 97835
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance600μsupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:29' where "id" = 6300268
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:29
      • 2: 6300268
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance510μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 83283) limit 1
      Bindings
      • 0: 2518608
      • 1: 83283
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance670μsupdate "route_waypoints" set "fraction" = 0.44444444444444, "updated_at" = '2025-05-18 09:04:29' where "id" = 6300269
      Bindings
      • 0: 0.4444444444444444
      • 1: 2025-05-18 09:04:29
      • 2: 6300269
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance400μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 71410) limit 1
      Bindings
      • 0: 2518608
      • 1: 71410
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance650μsupdate "route_waypoints" set "fraction" = 0.66666666666667, "updated_at" = '2025-05-18 09:04:29' where "id" = 6300270
      Bindings
      • 0: 0.6666666666666666
      • 1: 2025-05-18 09:04:29
      • 2: 6300270
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteDenormalisationService.php#45distance570μsselect * from "denormalised_routes" where "origin_destination_id" = 889907 limit 1
      Bindings
      • 0: 889907
      Backtrace
      • app/Services/RouteDenormalisationService.php:45
      • app/Models/Route.php:279
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#24distance330μsselect * from "route_waypoints" where "route_id" = 2518608
      Bindings
      • 0: 2518608
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#103distance430μsselect * from "places" where "places"."id" = 46086 limit 1
      Bindings
      • 0: 46086
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#104distance350μsselect * from "places" where "places"."id" = 81379 limit 1
      Bindings
      • 0: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance88.92msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.806815333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.539223333333)) + sin(radians(34.806815333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 85027 limit 1
      Bindings
      • 0: 85027
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance89.54msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.807432666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.523142666667)) + sin(radians(34.807432666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 63119 limit 1
      Bindings
      • 0: 63119
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance90.09msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.80805)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.507062)) + sin(radians(34.80805)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 97835 limit 1
      Bindings
      • 0: 97835
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance84.58msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.808667333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.490981333333)) + sin(radians(34.808667333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 83283 limit 1
      Bindings
      • 0: 83283
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance82.67msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.809284666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.474900666667)) + sin(radians(34.809284666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance84.8msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.809902)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.45882)) + sin(radians(34.809902)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance1.6msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 71410 limit 1
      Bindings
      • 0: 71410
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance85.61msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.810519333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.442739333333)) + sin(radians(34.810519333333)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance91.24msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.811136666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-87.426658666667)) + sin(radians(34.811136666667)) * 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" != 46086 and "places"."id" != 81379 order by "distance" asc limit 1
      Bindings
      • 0: 46086
      • 1: 81379
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance590μsselect * from "route_waypoints" where ("route_id" = 2518608 and "place_id" = 85027) limit 1
      Bindings
      • 0: 2518608
      • 1: 85027
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • distance1.04msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance400μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance680μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance590μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance420μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance320μsselect * from "states" where "states"."id" = ? limit 1
    • distance250μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance260μsselect * from "states" where "states"."id" = ? limit 1
    • distance440μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance400μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance810μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "places" where "places"."id" = ? limit 1
    • distance26.86msselect * from "images" where "images"."place_id" in (46086)
    • distance730μsselect * from "places" where "places"."id" = ? limit 1
    • distance23.61msselect * from "images" where "images"."place_id" in (81379)
    • distance570μ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"
    • distance360μsselect * from "route_directions" where "route_directions"."route_id" in (2518608) order by "step_index" asc, "step_index" asc
    • distance380μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance630μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance380μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance420μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance590μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    25RouteWaypoint.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\RouteDirection
    3RouteDirection.php#?
    App\Models\Route
    3Route.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:29GET/distance/peytona-points-izfl3ne5/lock-three-zfunll4616212860