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

Just a moment while we calculate your route...

Distance from Davidson to Antram

Driving Distance
22.1 mi • 35.6 km
Flying Distance
13.2 mi • 21.3 km
A
B
Leaflet © OpenStreetMap contributors
35 mph avg speed
North direction
38 min travel time

Route Information

The driving distance from Davidson, Pennsylvania to Antram, Pennsylvania is 22.1 mi (35.6 km)

The straight-line (air) distance is 13.2 mi (21.3 km)

The estimated flight time is 0 hr 2 min

The estimated travel time by road is 38 minutes

Traveling secondary roads, moderate in a north direction. Average speeds around 35 mph.

Location Details

Origin:


No image available
Place Davidson
State/Province Pennsylvania
Country US
Latitude 39.722856
Longitude -79.880057
GPS 39.722856° N, 79.880057° W
Local Time 5:04 AM
Timezone America/New_York

Destination:


No image available
Place Antram
State/Province Pennsylvania
Country US
Latitude 39.912876
Longitude -79.915236
GPS 39.912876° N, 79.915236° W
Local Time 5:04 AM
Timezone America/New_York

Journey Summary

Traveling from Davidson, Pennsylvania to Antram, Pennsylvania covers 22.1 mi (35.6 km) in a north direction. This secondary roads, moderate route typically takes 38 minutes under normal conditions.

Drivers have 3 route options between these locations (19.3-23.7 miles / 31-38 km). The primary route shown here saves 10 minutes compared to alternatives.

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

Available Routes

PA-166 N and Sr3013
22.1 mi 38 minutes
Shortest
US-119 N
23.7 mi 42 minutes
PA-166 N
19.3 mi 33 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.

Journey Waypoints

Davidson
Pennsylvania , US
Blosser Hill
Pennsylvania, US
1.8 mi
New Geneva
Pennsylvania, US
4.8 mi
Glassworks
Pennsylvania, US
5.8 mi
Rocks Works
Pennsylvania, US
8.0 mi
Masontown
Pennsylvania, US
8.6 mi
Huron
Pennsylvania, US
10.6 mi
Gates
Pennsylvania, US
11.7 mi
Antram
Pennsylvania , US
Messages48RequestTimelineExceptionsViews2Queries164Models102MailsGate
SettingsRequest history4.44sRequest 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/davidson-duhljlt1/antram-mjzc76ch
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:22] LOG.warning: No denormalized route found for origin-destination ID: 889906
  • infolog[09:04:22] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 20...
  • infolog[09:04:22] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #1 data for origin-destination ID: 889906 { "origin": "Dav...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 3 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 6 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 1 nested sub-directions for direction index 2
  • infolog[09:04:24] LOG.info: Saved 3 directions for route ID: 2518597
  • infolog[09:04:24] LOG.info: Found a shorter route: 31126 meters for route ID: 2518597
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #2 data for origin-destination ID: 889906 { "origin": "Dav...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 3 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 6 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 4 nested sub-directions for direction index 2
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 1 nested sub-directions for direction index 3
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 1 nested sub-directions for direction index 4
  • infolog[09:04:24] LOG.info: Saved 5 directions for route ID: 2518598
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #3 data for origin-destination ID: 889906 { "origin": "Dav...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 3 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 2 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 6 nested sub-directions for direction index 2
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 1 nested sub-directions for direction index 3
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 1 nested sub-directions for direction index 4
  • infolog[09:04:24] LOG.info: Saved 5 directions for route ID: 2518599
  • infolog[09:04:25] LOG.info: Successfully denormalized route data { "origin_destination_id": 889906, ...
  • infolog[09:04:25] LOG.info: Saved 3 routes for origin-destination ID: 889906
  • infolog[09:04:25] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518597, ...
  • infolog[09:04:25] LOG.info: Incremented view count for route { "id": 2518597, "name": "PA-166 N", ...
  • infolog[09:04:26] LOG.info: Updated denormalized route for route { "route_id": 2518597, "views": 1 ...
  • infolog[09:04:26] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518597, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/davidson-duhljlt1/antram-mjzc76ch
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
4.45s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "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-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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 => "941a2fc7dc04c97c-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:27 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "ZaCJUeaywTTYoaaHdynAXhjVHQgwaEyU8wJyptiI"
]
  • Booting (8.58ms)time
  • Application (4.43s)time
  • Routing (371μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (50μs)
  • 1 x Application (99.81%)
    4.43s
    1 x Booting (0.19%)
    8.58ms
    1 x Routing (0.01%)
    371μs
    1 x Preparing Response (0%)
    50μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    164 statements were executed (101 duplicates)Show only duplicatesdistance2.6s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 64 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance15.2msselect * from "sessions" where "id" = '4Rz6F47DVZJyJqLJ9yfIS20pNpX0utj1LZC3bQtM' limit 1
      Bindings
      • 0: 4Rz6F47DVZJyJqLJ9yfIS20pNpX0utj1LZC3bQtM
      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#548distance7.99msselect * from "places" where "slug" = 'davidson' and ("hash" = 'duhljlt1') limit 1
      Bindings
      • 0: davidson
      • 1: duhljlt1
      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#548distance850μsselect * from "places" where "slug" = 'antram' and ("hash" = 'mjzc76ch') limit 1
      Bindings
      • 0: antram
      • 1: mjzc76ch
      Backtrace
      • app/Http/Controllers/RouteController.php:548
      • app/Http/Controllers/RouteController.php:60
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • RouteController.php#104distance1.09msselect * from "origin_destinations" where ("origin_id" = 20414 and "destination_id" = 101559) limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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.44msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (20414, 101559, '2025-05-18 09:04:22', '2025-05-18 09:04:22') returning "id"
      Bindings
      • 0: 20414
      • 1: 101559
      • 2: 2025-05-18 09:04:22
      • 3: 2025-05-18 09:04:22
      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.73msselect * from "denormalised_routes" where "origin_destination_id" = 889906 limit 1
      Bindings
      • 0: 889906
      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#70distance700μsselect exists(select "id" from "routes" where "origin_destination_id" = 889906 limit 1) as "exists"
      Bindings
      • 0: 889906
      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#158distance730μsdelete from "routes" where "origin_destination_id" = 889906
      Bindings
      • 0: 889906
      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#172distance500μsselect * from "places" where "places"."id" = 20414 limit 1
      Bindings
      • 0: 20414
      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#173distance310μsselect * from "places" where "places"."id" = 101559 limit 1
      Bindings
      • 0: 101559
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance1.4msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889906, 'PA-166 N', 31126, 'm', 1983, 0, 'No', 39.7228562, 39.9134609, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889906
      • 1: PA-166 N
      • 2: 31126
      • 3: m
      • 4: 1983
      • 5: 0
      • 6: No
      • 7: 39.722856199999995
      • 8: 39.9134609
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance1.71msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518597, 0, 'Take Stewartstown Rd to Morgantown Rd in Point Marion', 2765, 'm', 320, -79.89043525, 39.7304188, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518597
      • 1: 0
      • 2: Take Stewartstown Rd to Morgantown Rd in Point Marion
      • 3: 2765
      • 4: m
      • 5: 320
      • 6: -79.89043525
      • 7: 39.7304188
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance990μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518597, 1, 'Follow PA-166 N to Sr3013 in Adah', 22568, 'm', 1246, -79.90923345, 39.8187159, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518597
      • 1: 1
      • 2: Follow PA-166 N to Sr3013 in Adah
      • 3: 22568
      • 4: m
      • 5: 1246
      • 6: -79.90923345
      • 7: 39.818715899999994
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance710μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518597, 2, '', 5793, 'm', 417, -79.9112005, 39.90273425, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518597
      • 1: 2
      • 2: 
      • 3: 5793
      • 4: m
      • 5: 417
      • 6: -79.91120049999999
      • 7: 39.90273425
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance850μsinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889906, 'PA-166 N and Sr3013', 35594, 'm', 2283, 0, 'No', 39.7228562, 39.9134609, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889906
      • 1: PA-166 N and Sr3013
      • 2: 35594
      • 3: m
      • 4: 2283
      • 5: 0
      • 6: No
      • 7: 39.722856199999995
      • 8: 39.9134609
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance790μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518598, 0, 'Take Stewartstown Rd to Morgantown Rd in Point Marion', 2765, 'm', 320, -79.89043525, 39.7304188, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518598
      • 1: 0
      • 2: Take Stewartstown Rd to Morgantown Rd in Point Marion
      • 3: 2765
      • 4: m
      • 5: 320
      • 6: -79.89043525
      • 7: 39.7304188
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance720μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518598, 1, 'Follow PA-166 N, New Geneva Rd and Woodside Old Frame Rd to Sr3010 in Nicholson Township', 16216, 'm', 857, -79.88901735, 39.7854414, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518598
      • 1: 1
      • 2: Follow PA-166 N, New Geneva Rd and Woodside Old Frame Rd to Sr3010 in Nicholson Township
      • 3: 16216
      • 4: m
      • 5: 857
      • 6: -79.88901734999999
      • 7: 39.785441399999996
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance700μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518598, 2, 'Take T458 and Leckrone-Highhouse Rd to PA-166 N in McClellandtown', 7249, 'm', 465, -79.8692285, 39.8520764, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518598
      • 1: 2
      • 2: Take T458 and Leckrone-Highhouse Rd to PA-166 N in McClellandtown
      • 3: 7249
      • 4: m
      • 5: 465
      • 6: -79.86922849999999
      • 7: 39.852076399999994
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance670μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518598, 3, '', 3571, 'm', 224, -79.8919252, 39.8853509, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518598
      • 1: 3
      • 2: 
      • 3: 3571
      • 4: m
      • 5: 224
      • 6: -79.89192519999999
      • 7: 39.885350900000006
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518598, 4, '', 5793, 'm', 417, -79.9112005, 39.90273425, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518598
      • 1: 4
      • 2: 
      • 3: 5793
      • 4: m
      • 5: 417
      • 6: -79.91120049999999
      • 7: 39.90273425
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance850μsinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889906, 'US-119 N', 38066, 'm', 2526, 0, 'No', 39.7228562, 39.9134609, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889906
      • 1: US-119 N
      • 2: 38066
      • 3: m
      • 4: 2526
      • 5: 0
      • 6: No
      • 7: 39.722856199999995
      • 8: 39.9134609
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518599, 0, 'Take Stewartstown Rd to Morgantown Rd in Point Marion', 2765, 'm', 320, -79.89043525, 39.7304188, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518599
      • 1: 0
      • 2: Take Stewartstown Rd to Morgantown Rd in Point Marion
      • 3: 2765
      • 4: m
      • 5: 320
      • 6: -79.89043525
      • 7: 39.7304188
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance800μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518599, 1, 'Follow US-119 N to High House Rd in Smithfield', 12947, 'm', 747, -79.8539805, 39.7706229, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518599
      • 1: 1
      • 2: Follow US-119 N to High House Rd in Smithfield
      • 3: 12947
      • 4: m
      • 5: 747
      • 6: -79.85398049999999
      • 7: 39.77062289999999
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance890μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518599, 2, 'Take Smithfield-Masontown Rd, Sr3010, T458 and Leckrone-Highhouse Rd to PA-166 N in McClellandtown', 12990, 'm', 818, -79.8482166, 39.8372579, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518599
      • 1: 2
      • 2: Take Smithfield-Masontown Rd, Sr3010, T458 and Leckrone-Highhouse Rd to PA-166 N in McClellandtown
      • 3: 12990
      • 4: m
      • 5: 818
      • 6: -79.8482166
      • 7: 39.837257900000004
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance770μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518599, 3, '', 3571, 'm', 224, -79.8919252, 39.8853509, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518599
      • 1: 3
      • 2: 
      • 3: 3571
      • 4: m
      • 5: 224
      • 6: -79.89192519999999
      • 7: 39.885350900000006
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance980μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518599, 4, '', 5793, 'm', 417, -79.9112005, 39.90273425, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518599
      • 1: 4
      • 2: 
      • 3: 5793
      • 4: m
      • 5: 417
      • 6: -79.91120049999999
      • 7: 39.90273425
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance780μsselect * from "route_waypoints" where "route_id" = 2518597
      Bindings
      • 0: 2518597
      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#103distance410μsselect * from "origin_destinations" where "origin_destinations"."id" = 889906 limit 1
      Bindings
      • 0: 889906
      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#103distance430μsselect * from "places" where "places"."id" = 20414 limit 1
      Bindings
      • 0: 20414
      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#104distance380μsselect * from "places" where "places"."id" = 101559 limit 1
      Bindings
      • 0: 101559
      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#226distance97.16msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.743969333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.883965777778)) + sin(radians(39.743969333333)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance940μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 67992 limit 1
      Bindings
      • 0: 67992
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.81msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.765082666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.887874555556)) + sin(radians(39.765082666667)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#226distance91.15msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.786196)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.891783333333)) + sin(radians(39.786196)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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" = 75064 limit 1
      Bindings
      • 0: 75064
      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#226distance98.79msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.807309333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.895692111111)) + sin(radians(39.807309333333)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 54052 limit 1
      Bindings
      • 0: 54052
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance97.73msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.828422666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.899600888889)) + sin(radians(39.828422666667)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 59723 limit 1
      Bindings
      • 0: 59723
      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#226distance98.4msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.849536)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.903509666667)) + sin(radians(39.849536)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 9388 limit 1
      Bindings
      • 0: 9388
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.9msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.870649333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.907418444444)) + sin(radians(39.870649333333)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance480μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 78915 limit 1
      Bindings
      • 0: 78915
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.77msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.891762666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.911327222222)) + sin(radians(39.891762666667)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 96207 limit 1
      Bindings
      • 0: 96207
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 67992) limit 1
      Bindings
      • 0: 2518597
      • 1: 67992
      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.69msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518597, 67992, 0.11111111111111, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 67992
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance630μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 75064) limit 1
      Bindings
      • 0: 2518597
      • 1: 75064
      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#78distance970μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518597, 75064, 0.33333333333333, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 75064
      • 2: 0.3333333333333333
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 54052) limit 1
      Bindings
      • 0: 2518597
      • 1: 54052
      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#78distance950μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518597, 54052, 0.44444444444444, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 54052
      • 2: 0.4444444444444444
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance390μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 59723) limit 1
      Bindings
      • 0: 2518597
      • 1: 59723
      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#78distance850μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518597, 59723, 0.55555555555556, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 59723
      • 2: 0.5555555555555556
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 9388) limit 1
      Bindings
      • 0: 2518597
      • 1: 9388
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.33msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518597, 9388, 0.66666666666667, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 9388
      • 2: 0.6666666666666666
      • 3: 0
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance360μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 78915) limit 1
      Bindings
      • 0: 2518597
      • 1: 78915
      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.17msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518597, 78915, 0.77777777777778, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 78915
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 96207) limit 1
      Bindings
      • 0: 2518597
      • 1: 96207
      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 (2518597, 96207, 0.88888888888889, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518597
      • 1: 96207
      • 2: 0.8888888888888888
      • 3: 0
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#366distance570μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518597 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518597
      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#45distance460μsselect * from "denormalised_routes" where "origin_destination_id" = 889906 limit 1
      Bindings
      • 0: 889906
      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#123distance640μsselect * from "route_directions" where "route_directions"."route_id" = 2518597 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518597
      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#198distance390μsselect * from "locations" where "locations"."id" = 20414 limit 1
      Bindings
      • 0: 20414
      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#198distance590μsselect * from "cities" where "cities"."id" = 13609 limit 1
      Bindings
      • 0: 13609
      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#215distance450μsselect * from "states" where "states"."id" = 11 limit 1
      Bindings
      • 0: 11
      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#330distance380μ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#198distance310μsselect * from "locations" where "locations"."id" = 101559 limit 1
      Bindings
      • 0: 101559
      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#198distance380μsselect * from "cities" where "cities"."id" = 36702 limit 1
      Bindings
      • 0: 36702
      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#215distance360μsselect * from "states" where "states"."id" = 11 limit 1
      Bindings
      • 0: 11
      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#330distance320μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance2.39msinsert 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 (20414, 'Davidson', 'Davidson, Springhill Township, PA 15474', 'davidson', 'duhljlt1', 39.722856, -79.880057, 'Springhill Township', 'Pennsylvania', 'US', 'America/New_York', 101559, 'Antram', 'Antram, PA 15410', 'antram', 'mjzc76ch', 39.912876, -79.915236, 'Antram', 'Pennsylvania', 'US', 'America/New_York', 2518597, 'PA-166 N', 31126, 'm', 1983, 19.340793746, 31126, '33 minutes', '33 minutes', 31.126, '31.1 km', null, 33, 0, 'No', '19.3 mi', 13.261181400727, 0.013261181400727, '"[{\"id\":8350424,\"route_id\":2518597,\"step_index\":\"0\",\"instruction\":\"Take Stewartstown Rd to Morgantown Rd in Point Marion\",\"distance\":2765,\"distance_unit\":\"m\",\"time\":\"320\",\"latitude\":-79.8904353,\"longitude\":39.7304188,\"is_sub_step\":false},{\"id\":8350425,\"route_id\":2518597,\"step_index\":\"1\",\"instruction\":\"Follow PA-166 N to Sr3013 in Adah\",\"distance\":22568,\"distance_unit\":\"m\",\"time\":\"1246\",\"latitude\":-79.9092335,\"longitude\":39.8187159,\"is_sub_step\":false},{\"id\":8350426,\"route_id\":2518597,\"step_index\":\"2\",\"instruction\":\"\",\"distance\":5793,\"distance_unit\":\"m\",\"time\":\"417\",\"latitude\":-79.9112005,\"longitude\":39.9027343,\"is_sub_step\":false}]"', 31126, 31126, '10 minutes', 0, 'north', 'south', '[{"name":"Blosser Hill","description":"19 mi to destination","state":"Pennsylvania","country":"US","full_address":"Blosser Hill, PA 15451","lat":"39.745911","lng":"-79.897002","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":67992,"slug":"blosser-hill","hash":"6xmnefbr"},{"name":"New Geneva","description":"14 mi to destination","state":"Pennsylvania","country":"US","full_address":"New Geneva, PA 15478","lat":"39.788411","lng":"-79.909223","fraction":0.3333333333333333,"type":"City","distance_km":1,"place_id":75064,"slug":"new-geneva","hash":"pc9t7ahy"},{"name":"Glassworks","description":"Traveled 9 mi from origin","state":"Pennsylvania","country":"US","full_address":"Glassworks, Monongahela Township, PA 15338","lat":"39.802022","lng":"-79.914222","fraction":0.4444444444444444,"type":"City","distance_km":1,"place_id":54052,"slug":"glassworks","hash":"u8d0qfl3"},{"name":"Rocks Works","description":"9 mi to destination","state":"Pennsylvania","country":"US","full_address":"Rocks Works, Nicholson Township, PA 15461","lat":"39.837299","lng":"-79.895887","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":59723,"slug":"rocks-works","hash":"ic54cvr6"},{"name":"Masontown","description":"Traveled 14 mi from origin","state":"Pennsylvania","country":"US","full_address":"Masontown, PA 15461","lat":"39.846743","lng":"-79.899776","fraction":0.6666666666666666,"type":"City","distance_km":0,"place_id":9388,"slug":"masontown","hash":"a376nzlo"},{"name":"Huron","description":"5 mi to destination","state":"Pennsylvania","country":"US","full_address":"Huron, Ronco, PA 15476","lat":"39.873687","lng":"-79.919220","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":78915,"slug":"huron","hash":"0tj8e0oe"},{"name":"Gates","description":"Traveled 19 mi from origin","state":"Pennsylvania","country":"US","full_address":"Gates, German Township, PA 15410","lat":"39.889798","lng":"-79.911163","fraction":0.8888888888888888,"type":"City","distance_km":0,"place_id":96207,"slug":"gates","hash":"fbjzftot"}]', 1, 7, '{"distanceInMiles":19.340847800961885,"distanceMilesFormatted":"19.3 miles","distanceFormatted":"19.3 miles","distanceKmFormatted":"31 km","timeHours":0.55,"timeFormatted":"33 minutes","avgSpeed":35,"routeDescriptors":["secondary roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"north"}', null, 'davidson-duhljlt1/antram-mjzc76ch', 0, null, null, 0, '"[{\"name\":\"Blosser Hill\",\"description\":\"19 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Blosser Hill, PA 15451\",\"lat\":\"39.745911\",\"lng\":\"-79.897002\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":67992,\"slug\":\"blosser-hill\",\"hash\":\"6xmnefbr\"},{\"name\":\"New Geneva\",\"description\":\"14 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"New Geneva, PA 15478\",\"lat\":\"39.788411\",\"lng\":\"-79.909223\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":1,\"place_id\":75064,\"slug\":\"new-geneva\",\"hash\":\"pc9t7ahy\"},{\"name\":\"Glassworks\",\"description\":\"Traveled 9 mi from origin\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Glassworks, Monongahela Township, PA 15338\",\"lat\":\"39.802022\",\"lng\":\"-79.914222\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":1,\"place_id\":54052,\"slug\":\"glassworks\",\"hash\":\"u8d0qfl3\"},{\"name\":\"Rocks Works\",\"description\":\"9 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Rocks Works, Nicholson Township, PA 15461\",\"lat\":\"39.837299\",\"lng\":\"-79.895887\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":59723,\"slug\":\"rocks-works\",\"hash\":\"ic54cvr6\"},{\"name\":\"Masontown\",\"description\":\"Traveled 14 mi from origin\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Masontown, PA 15461\",\"lat\":\"39.846743\",\"lng\":\"-79.899776\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":0,\"place_id\":9388,\"slug\":\"masontown\",\"hash\":\"a376nzlo\"},{\"name\":\"Huron\",\"description\":\"5 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Huron, Ronco, PA 15476\",\"lat\":\"39.873687\",\"lng\":\"-79.919220\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":78915,\"slug\":\"huron\",\"hash\":\"0tj8e0oe\"},{\"name\":\"Gates\",\"description\":\"Traveled 19 mi from origin\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Gates, German Township, PA 15410\",\"lat\":\"39.889798\",\"lng\":\"-79.911163\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":0,\"place_id\":96207,\"slug\":\"gates\",\"hash\":\"fbjzftot\"}]"', 3, 889906, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 20414
      • 1: Davidson
      • 2: Davidson, Springhill Township, PA 15474
      • 3: davidson
      • 4: duhljlt1
      • 5: 39.722856
      • 6: -79.880057
      • 7: Springhill Township
      • 8: Pennsylvania
      • 9: US
      • 10: America/New_York
      • 11: 101559
      • 12: Antram
      • 13: Antram, PA 15410
      • 14: antram
      • 15: mjzc76ch
      • 16: 39.912876
      • 17: -79.915236
      • 18: Antram
      • 19: Pennsylvania
      • 20: US
      • 21: America/New_York
      • 22: 2518597
      • 23: PA-166 N
      • 24: 31126
      • 25: m
      • 26: 1983
      • 27: 19.340793746
      • 28: 31126
      • 29: 33 minutes
      • 30: 33 minutes
      • 31: 31.126
      • 32: 31.1 km
      • 33: 
      • 34: 33
      • 35: 0
      • 36: No
      • 37: 19.3 mi
      • 38: 13.2611814007269
      • 39: 0.0132611814007269
      • 40: "[{\"id\":8350424,\"route_id\":2518597,\"step_index\":\"0\",\"instruction\":\"Take Stewartstown Rd to Morgantown Rd in Point Marion\",\"distance\":2765,\"distance_unit\":\"m\",\"time\":\"320\",\"latitude\":-79.8904353,\"longitude\":39.7304188,\"is_sub_step\":false},{\"id\":8350425,\"route_id\":2518597,\"step_index\":\"1\",\"instruction\":\"Follow PA-166 N to Sr3013 in Adah\",\"distance\":22568,\"distance_unit\":\"m\",\"time\":\"1246\",\"latitude\":-79.9092335,\"longitude\":39.8187159,\"is_sub_step\":false},{\"id\":8350426,\"route_id\":2518597,\"step_index\":\"2\",\"instruction\":\"\",\"distance\":5793,\"distance_unit\":\"m\",\"time\":\"417\",\"latitude\":-79.9112005,\"longitude\":39.9027343,\"is_sub_step\":false}]"
      • 41: 31126
      • 42: 31126
      • 43: 10 minutes
      • 44: 0
      • 45: north
      • 46: south
      • 47: [{"name":"Blosser Hill","description":"19 mi to destination","state":"Pennsylvania","country":"US","full_address":"Blosser Hill, PA 15451","lat":"39.745911","lng":"-79.897002","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":67992,"slug":"blosser-hill","hash":"6xmnefbr"},{"name":"New Geneva","description":"14 mi to destination","state":"Pennsylvania","country":"US","full_address":"New Geneva, PA 15478","lat":"39.788411","lng":"-79.909223","fraction":0.3333333333333333,"type":"City","distance_km":1,"place_id":75064,"slug":"new-geneva","hash":"pc9t7ahy"},{"name":"Glassworks","description":"Traveled 9 mi from origin","state":"Pennsylvania","country":"US","full_address":"Glassworks, Monongahela Township, PA 15338","lat":"39.802022","lng":"-79.914222","fraction":0.4444444444444444,"type":"City","distance_km":1,"place_id":54052,"slug":"glassworks","hash":"u8d0qfl3"},{"name":"Rocks Works","description":"9 mi to destination","state":"Pennsylvania","country":"US","full_address":"Rocks Works, Nicholson Township, PA 15461","lat":"39.837299","lng":"-79.895887","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":59723,"slug":"rocks-works","hash":"ic54cvr6"},{"name":"Masontown","description":"Traveled 14 mi from origin","state":"Pennsylvania","country":"US","full_address":"Masontown, PA 15461","lat":"39.846743","lng":"-79.899776","fraction":0.6666666666666666,"type":"City","distance_km":0,"place_id":9388,"slug":"masontown","hash":"a376nzlo"},{"name":"Huron","description":"5 mi to destination","state":"Pennsylvania","country":"US","full_address":"Huron, Ronco, PA 15476","lat":"39.873687","lng":"-79.919220","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":78915,"slug":"huron","hash":"0tj8e0oe"},{"name":"Gates","description":"Traveled 19 mi from origin","state":"Pennsylvania","country":"US","full_address":"Gates, German Township, PA 15410","lat":"39.889798","lng":"-79.911163","fraction":0.8888888888888888,"type":"City","distance_km":0,"place_id":96207,"slug":"gates","hash":"fbjzftot"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":19.340847800961885,"distanceMilesFormatted":"19.3 miles","distanceFormatted":"19.3 miles","distanceKmFormatted":"31 km","timeHours":0.55,"timeFormatted":"33 minutes","avgSpeed":35,"routeDescriptors":["secondary roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"north"}
      • 51: 
      • 52: davidson-duhljlt1/antram-mjzc76ch
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Blosser Hill\",\"description\":\"19 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Blosser Hill, PA 15451\",\"lat\":\"39.745911\",\"lng\":\"-79.897002\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":67992,\"slug\":\"blosser-hill\",\"hash\":\"6xmnefbr\"},{\"name\":\"New Geneva\",\"description\":\"14 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"New Geneva, PA 15478\",\"lat\":\"39.788411\",\"lng\":\"-79.909223\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":1,\"place_id\":75064,\"slug\":\"new-geneva\",\"hash\":\"pc9t7ahy\"},{\"name\":\"Glassworks\",\"description\":\"Traveled 9 mi from origin\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Glassworks, Monongahela Township, PA 15338\",\"lat\":\"39.802022\",\"lng\":\"-79.914222\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":1,\"place_id\":54052,\"slug\":\"glassworks\",\"hash\":\"u8d0qfl3\"},{\"name\":\"Rocks Works\",\"description\":\"9 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Rocks Works, Nicholson Township, PA 15461\",\"lat\":\"39.837299\",\"lng\":\"-79.895887\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":59723,\"slug\":\"rocks-works\",\"hash\":\"ic54cvr6\"},{\"name\":\"Masontown\",\"description\":\"Traveled 14 mi from origin\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Masontown, PA 15461\",\"lat\":\"39.846743\",\"lng\":\"-79.899776\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":0,\"place_id\":9388,\"slug\":\"masontown\",\"hash\":\"a376nzlo\"},{\"name\":\"Huron\",\"description\":\"5 mi to destination\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Huron, Ronco, PA 15476\",\"lat\":\"39.873687\",\"lng\":\"-79.919220\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":78915,\"slug\":\"huron\",\"hash\":\"0tj8e0oe\"},{\"name\":\"Gates\",\"description\":\"Traveled 19 mi from origin\",\"state\":\"Pennsylvania\",\"country\":\"US\",\"full_address\":\"Gates, German Township, PA 15410\",\"lat\":\"39.889798\",\"lng\":\"-79.911163\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":0,\"place_id\":96207,\"slug\":\"gates\",\"hash\":\"fbjzftot\"}]"
      • 58: 3
      • 59: 889906
      • 60: 2025-05-18 09:04:25
      • 61: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance480μsselect exists(select "id" from "routes" where "origin_destination_id" = 889906 limit 1) as "exists"
      Bindings
      • 0: 889906
      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#1186distance580μsselect * from "routes" where "routes"."origin_destination_id" = 889906 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889906
      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 (2518597, 2518598, 2518599) 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#225distance950μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:25' where "id" = 2518597
      Bindings
      • 0: 2025-05-18 09:04:25
      • 1: 2518597
      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#235distance340μsselect * from "origin_destinations" where "origin_destinations"."id" = 889906 limit 1
      Bindings
      • 0: 889906
      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#244distance1.39msselect * from "places" where "places"."id" = 20414 limit 1
      Bindings
      • 0: 20414
      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" = 101559 limit 1
      Bindings
      • 0: 101559
      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#24distance2.96msselect * from "route_waypoints" where "route_id" = 2518597
      Bindings
      • 0: 2518597
      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#103distance320μsselect * from "places" where "places"."id" = 20414 limit 1
      Bindings
      • 0: 20414
      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#104distance320μsselect * from "places" where "places"."id" = 101559 limit 1
      Bindings
      • 0: 101559
      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#226distance117msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.743969333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.883965777778)) + sin(radians(39.743969333333)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance740μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 67992 limit 1
      Bindings
      • 0: 67992
      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#226distance91.47msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.765082666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.887874555556)) + sin(radians(39.765082666667)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#226distance96.94msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.786196)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.891783333333)) + sin(radians(39.786196)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance830μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 75064 limit 1
      Bindings
      • 0: 75064
      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#226distance96.89msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.807309333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.895692111111)) + sin(radians(39.807309333333)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance2.2msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 54052 limit 1
      Bindings
      • 0: 54052
      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#226distance117msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.828422666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.899600888889)) + sin(radians(39.828422666667)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance1.18msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 59723 limit 1
      Bindings
      • 0: 59723
      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#226distance93.27msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.849536)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.903509666667)) + sin(radians(39.849536)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance490μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 9388 limit 1
      Bindings
      • 0: 9388
      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#226distance104msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.870649333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.907418444444)) + sin(radians(39.870649333333)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance730μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 78915 limit 1
      Bindings
      • 0: 78915
      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#226distance142msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.891762666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.911327222222)) + sin(radians(39.891762666667)) * 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" != 20414 and "places"."id" != 101559 order by "distance" asc limit 1
      Bindings
      • 0: 20414
      • 1: 101559
      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#158distance560μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 96207 limit 1
      Bindings
      • 0: 96207
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 67992) limit 1
      Bindings
      • 0: 2518597
      • 1: 67992
      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#78distance870μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300236
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:26
      • 2: 6300236
      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#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518597 and "place_id" = 75064) limit 1
      Bindings
      • 0: 2518597
      • 1: 75064
      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#78distance700μsupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300237
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:26
      • 2: 6300237
      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
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance800μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance420μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance760μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μ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
    • distance780μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance360μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance850μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance550μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance420μsselect * from "route_waypoints" where "route_id" = ?
    • distance470μsselect * from "places" where "places"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance103msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.743969333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.883965777778)) + sin(radians(39.743969333333)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance540μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance100msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.765082666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.887874555556)) + sin(radians(39.765082666667)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance94.14msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.786196)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.891783333333)) + sin(radians(39.786196)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance112msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.807309333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.895692111111)) + sin(radians(39.807309333333)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance800μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance114msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.828422666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.899600888889)) + sin(radians(39.828422666667)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance760μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.849536)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.903509666667)) + sin(radians(39.849536)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance1.62msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance93.73msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.870649333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.907418444444)) + sin(radians(39.870649333333)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance1.56msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance99.81msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.891762666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-79.911327222222)) + sin(radians(39.891762666667)) * 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" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance390μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance930μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance610μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance690μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance560μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance270μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance570μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance260μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance600μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance550μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance260μsselect * from "states" where "states"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance240μsselect * from "states" where "states"."id" = ? limit 1
    • distance470μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance360μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance720μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.49msselect * from "images" where "images"."place_id" in (20414)
    • distance610μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.12msselect * from "images" where "images"."place_id" in (101559)
    • distance680μsselect * from "routes" where "origin_destination_id" = ?
    • distance660μ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"
    • distance480μsselect * from "route_directions" where "route_directions"."route_id" in (2518597, 2518598, 2518599) order by "step_index" asc, "step_index" asc
    • distance410μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance410μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance350μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance650μ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" = ?
    • distance330μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance520μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    35RouteWaypoint.php#?
    App\Models\RouteDirection
    29RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:27GET/distance/davidson-duhljlt1/antram-mjzc76ch482164102