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

Just a moment while we calculate your route...

Distance from Gresham to Downs

Driving Distance
46.3 mi • 74.5 km
Flying Distance
36.4 mi • 58.6 km
A
B
Leaflet © OpenStreetMap contributors
42 mph avg speed
Southwest direction
1 hr 9 min travel time

Route Information

The driving distance from Gresham, Oregon to Downs, Oregon is 46.3 mi (74.5 km)

The straight-line (air) distance is 36.4 mi (58.6 km)

The estimated flight time is 0 hr 4 min

The estimated travel time by road is 1 hour 9 minutes

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

Location Details

Origin:

Gresham
Place Gresham
State/Province Oregon
Country US
Latitude 45.504472
Longitude -122.435666
GPS 45.504472° N, 122.435666° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Destination:


No image available
Place Downs
State/Province Oregon
Country US
Latitude 45.042343
Longitude -122.79398
GPS 45.042343° N, 122.79398° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Journey Summary

Traveling from Gresham, Oregon to Downs, Oregon covers 46.3 mi (74.5 km) in a southwest direction. This mixed highways and local roads, moderate route typically takes 1 hour 9 minutes under normal conditions.

Drivers have 3 route options between these locations (46.0-46.8 miles / 74-75 km). The primary route shown here saves 3 minutes compared to alternatives.

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

Available Routes

OR-213/Cascade Hwy S and OR-213 S
46.3 mi 1 hour 9 minutes
Shortest
OR-212 W, OR-213/Cascade Hwy S and OR-213 S
46.8 mi 1 hour 8 minutes
OR-213/Cascade Hwy S
46 mi 1 hour 6 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

Gresham
Oregon , US
Happy Valley
Oregon, US
5.7 mi
Richardson Creek
Oregon, US
7.2 mi
Echo Dell
Oregon, US
12.7 mi
Fishers Corner
Oregon, US
16.1 mi
O'Neil Corners
Oregon, US
19.5 mi
Macksburg
Oregon, US
22.8 mi
Hamricks Corner
Oregon, US
27.2 mi
Monitor
Oregon, US
31.7 mi
Downs
Oregon , US
Messages34RequestTimelineExceptionsViews2Queries178Models156MailsGate
SettingsRequest history4.7sRequest 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/gresham-dalbe4wr/downs-lneo8dfs
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:21] LOG.warning: No denormalized route found for origin-destination ID: 889905
  • infolog[09:04:21] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 53...
  • infolog[09:04:21] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:25] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:25] LOG.info: Processing route #1 data for origin-destination ID: 889905 { "origin": "Gre...
  • infolog[09:04:25] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:25] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:25] LOG.info: Ignoring 10 nested sub-directions for direction index 0
  • debuglog[09:04:25] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:25] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • infolog[09:04:25] LOG.info: Saved 2 directions for route ID: 2518605
  • infolog[09:04:25] LOG.info: Found a shorter route: 74100 meters for route ID: 2518605
  • infolog[09:04:25] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:25] LOG.info: Processing route #2 data for origin-destination ID: 889905 { "origin": "Gre...
  • infolog[09:04:25] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:25] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:25] LOG.info: Ignoring 7 nested sub-directions for direction index 0
  • debuglog[09:04:25] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:25] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • infolog[09:04:25] LOG.info: Saved 2 directions for route ID: 2518606
  • infolog[09:04:25] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:25] LOG.info: Processing route #3 data for origin-destination ID: 889905 { "origin": "Gre...
  • infolog[09:04:25] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:25] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:25] LOG.info: Ignoring 9 nested sub-directions for direction index 0
  • debuglog[09:04:25] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:25] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • infolog[09:04:25] LOG.info: Saved 2 directions for route ID: 2518607
  • infolog[09:04:26] LOG.info: Successfully denormalized route data { "origin_destination_id": 889905, ...
  • infolog[09:04:26] LOG.info: Saved 3 routes for origin-destination ID: 889905
  • infolog[09:04:26] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518605, ...
  • infolog[09:04:26] LOG.info: Incremented view count for route { "id": 2518605, "name": "OR-213\/Casc...
  • infolog[09:04:26] LOG.info: Updated denormalized route for route { "route_id": 2518605, "views": 1 ...
  • infolog[09:04:26] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518605, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/gresham-dalbe4wr/downs-lneo8dfs
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.7s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a2fc7dc08c97c-IAD"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:26 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "EvtbXjeX2HKnNWNl1Nsljht7vCASmA5WqEpj6vrA"
]
  • Booting (7.58ms)time
  • Application (4.69s)time
  • Routing (449μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (37μs)
  • 1 x Application (99.84%)
    4.69s
    1 x Booting (0.16%)
    7.58ms
    1 x Routing (0.01%)
    449μs
    1 x Preparing Response (0%)
    37μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    178 statements were executed (107 duplicates)Show only duplicatesdistance1.19s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 78 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance16.98msselect * from "sessions" where "id" = 'br7Yn29PCqNabV4i4iSiKp0g2TfRBJGysfFU7teO' limit 1
      Bindings
      • 0: br7Yn29PCqNabV4i4iSiKp0g2TfRBJGysfFU7teO
      Backtrace
      • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:96
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:116
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:104
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:88
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:146
    • RouteController.php#548distance8.37msselect * from "places" where "slug" = 'gresham' and ("hash" = 'dalbe4wr') limit 1
      Bindings
      • 0: gresham
      • 1: dalbe4wr
      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#548distance630μsselect * from "places" where "slug" = 'downs' and ("hash" = 'lneo8dfs') limit 1
      Bindings
      • 0: downs
      • 1: lneo8dfs
      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#104distance800μsselect * from "origin_destinations" where ("origin_id" = 530 and "destination_id" = 68127) limit 1
      Bindings
      • 0: 530
      • 1: 68127
      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#104distance1.84msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (530, 68127, '2025-05-18 09:04:21', '2025-05-18 09:04:21') returning "id"
      Bindings
      • 0: 530
      • 1: 68127
      • 2: 2025-05-18 09:04:21
      • 3: 2025-05-18 09:04:21
      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.55msselect * from "denormalised_routes" where "origin_destination_id" = 889905 limit 1
      Bindings
      • 0: 889905
      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#70distance820μsselect exists(select "id" from "routes" where "origin_destination_id" = 889905 limit 1) as "exists"
      Bindings
      • 0: 889905
      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#158distance6.89msdelete from "routes" where "origin_destination_id" = 889905
      Bindings
      • 0: 889905
      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#172distance1.04msselect * from "places" where "places"."id" = 530 limit 1
      Bindings
      • 0: 530
      Backtrace
      • app/Services/DistanceCalculationService.php:172
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#173distance1.52msselect * from "places" where "places"."id" = 68127 limit 1
      Bindings
      • 0: 68127
      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#225distance4.62msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889905, 'OR-213/Cascade Hwy S', 74100, 'm', 3999, 0, 'No', 45.0419192, 45.5044804, null, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 889905
      • 1: OR-213/Cascade Hwy S
      • 2: 74100
      • 3: m
      • 4: 3999
      • 5: 0
      • 6: No
      • 7: 45.041919199999995
      • 8: 45.5044804
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:25
      • 12: 2025-05-18 09:04:25
      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.26msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518605, 0, 'Take I-205 S and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County', 66029, 'm', 3575, -122.57439975, 45.27887075, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518605
      • 1: 0
      • 2: Take I-205 S and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County
      • 3: 66029
      • 4: m
      • 5: 3575
      • 6: -122.57439975000001
      • 7: 45.27887075
      • 8: 0
      • 9: 2025-05-18 09:04:25
      • 10: 2025-05-18 09:04:25
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.64msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518605, 1, 'Drive to Downs Rd NE', 8071, 'm', 424, -122.7535439, 45.04762035, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518605
      • 1: 1
      • 2: Drive to Downs Rd NE
      • 3: 8071
      • 4: m
      • 5: 424
      • 6: -122.7535439
      • 7: 45.047620349999995
      • 8: 0
      • 9: 2025-05-18 09:04:25
      • 10: 2025-05-18 09:04:25
      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#225distance2.08msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889905, 'OR-213/Cascade Hwy S and OR-213 S', 74482, 'm', 4160, 0, 'No', 45.0419192, 45.5045951, null, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 889905
      • 1: OR-213/Cascade Hwy S and OR-213 S
      • 2: 74482
      • 3: m
      • 4: 4160
      • 5: 0
      • 6: No
      • 7: 45.041919199999995
      • 8: 45.504595099999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:25
      • 12: 2025-05-18 09:04:25
      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#548distance2.54msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518606, 0, 'Follow NW Division St, I-205 S and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County', 66411, 'm', 3736, -122.57341415, 45.2789281, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518606
      • 1: 0
      • 2: Follow NW Division St, I-205 S and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County
      • 3: 66411
      • 4: m
      • 5: 3736
      • 6: -122.57341414999999
      • 7: 45.2789281
      • 8: 0
      • 9: 2025-05-18 09:04:25
      • 10: 2025-05-18 09:04:25
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.2msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518606, 1, 'Drive to Downs Rd NE', 8071, 'm', 424, -122.7535439, 45.04762035, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518606
      • 1: 1
      • 2: Drive to Downs Rd NE
      • 3: 8071
      • 4: m
      • 5: 424
      • 6: -122.7535439
      • 7: 45.047620349999995
      • 8: 0
      • 9: 2025-05-18 09:04:25
      • 10: 2025-05-18 09:04:25
      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#225distance3.44msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889905, 'OR-212 W, OR-213/Cascade Hwy S and OR-213 S', 75342, 'm', 4115, 0, 'No', 45.0419192, 45.5044804, null, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 889905
      • 1: OR-212 W, OR-213/Cascade Hwy S and OR-213 S
      • 2: 75342
      • 3: m
      • 4: 4115
      • 5: 0
      • 6: No
      • 7: 45.041919199999995
      • 8: 45.5044804
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:25
      • 12: 2025-05-18 09:04:25
      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.09msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518607, 0, 'Take OR-212 W and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County', 67271, 'm', 3691, -122.57362165, 45.27887075, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518607
      • 1: 0
      • 2: Take OR-212 W and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County
      • 3: 67271
      • 4: m
      • 5: 3691
      • 6: -122.57362164999999
      • 7: 45.27887075
      • 8: 0
      • 9: 2025-05-18 09:04:25
      • 10: 2025-05-18 09:04:25
      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#548distance880μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518607, 1, 'Drive to Downs Rd NE', 8071, 'm', 424, -122.7535439, 45.04762035, 0, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518607
      • 1: 1
      • 2: Drive to Downs Rd NE
      • 3: 8071
      • 4: m
      • 5: 424
      • 6: -122.7535439
      • 7: 45.047620349999995
      • 8: 0
      • 9: 2025-05-18 09:04:25
      • 10: 2025-05-18 09:04:25
      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#24distance730μsselect * from "route_waypoints" where "route_id" = 2518605
      Bindings
      • 0: 2518605
      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#103distance400μsselect * from "origin_destinations" where "origin_destinations"."id" = 889905 limit 1
      Bindings
      • 0: 889905
      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#103distance500μsselect * from "places" where "places"."id" = 530 limit 1
      Bindings
      • 0: 530
      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#104distance400μsselect * from "places" where "places"."id" = 68127 limit 1
      Bindings
      • 0: 68127
      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#226distance239msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.453124333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.47547866667)) + sin(radians(45.453124333333)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance810μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 2042 limit 1
      Bindings
      • 0: 2042
      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#226distance170msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.401776666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.51529133333)) + sin(radians(45.401776666667)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance570μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 41249 limit 1
      Bindings
      • 0: 41249
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance95.51msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.350429)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.555104)) + sin(radians(45.350429)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance570μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 51710 limit 1
      Bindings
      • 0: 51710
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance100msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.299081333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.59491666667)) + sin(radians(45.299081333333)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance570μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 105901 limit 1
      Bindings
      • 0: 105901
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.247733666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.63472933333)) + sin(radians(45.247733666667)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      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#158distance930μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 105817 limit 1
      Bindings
      • 0: 105817
      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#226distance113msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.196386)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.674542)) + sin(radians(45.196386)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      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" = 54370 limit 1
      Bindings
      • 0: 54370
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance94.35msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.145038333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.71435466667)) + sin(radians(45.145038333333)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 105851 limit 1
      Bindings
      • 0: 105851
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance95.42msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(45.093690666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.75416733333)) + sin(radians(45.093690666667)) * 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" != 530 and "places"."id" != 68127 order by "distance" asc limit 1
      Bindings
      • 0: 530
      • 1: 68127
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 44970 limit 1
      Bindings
      • 0: 44970
      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#78distance340μsselect * from "route_waypoints" where ("route_id" = 2518605 and "place_id" = 2042) limit 1
      Bindings
      • 0: 2518605
      • 1: 2042
      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.25msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 2042, 0.11111111111111, 2, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 2042
      • 2: 0.1111111111111111
      • 3: 2
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      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#78distance340μsselect * from "route_waypoints" where ("route_id" = 2518605 and "place_id" = 41249) limit 1
      Bindings
      • 0: 2518605
      • 1: 41249
      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#78distance990μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 41249, 0.22222222222222, 2, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 41249
      • 2: 0.2222222222222222
      • 3: 2
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518605 and "place_id" = 51710) limit 1
      Bindings
      • 0: 2518605
      • 1: 51710
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance780μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 51710, 0.33333333333333, 2, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 51710
      • 2: 0.3333333333333333
      • 3: 2
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance410μsselect * from "route_waypoints" where ("route_id" = 2518605 and "place_id" = 105901) limit 1
      Bindings
      • 0: 2518605
      • 1: 105901
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance920μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 105901, 0.44444444444444, 2, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 105901
      • 2: 0.4444444444444444
      • 3: 2
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      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" = 2518605 and "place_id" = 105817) limit 1
      Bindings
      • 0: 2518605
      • 1: 105817
      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#78distance810μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 105817, 0.55555555555556, 2, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 105817
      • 2: 0.5555555555555556
      • 3: 2
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      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" = 2518605 and "place_id" = 54370) limit 1
      Bindings
      • 0: 2518605
      • 1: 54370
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance920μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 54370, 0.66666666666667, 1, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 54370
      • 2: 0.6666666666666666
      • 3: 1
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      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.15msselect * from "route_waypoints" where ("route_id" = 2518605 and "place_id" = 105851) limit 1
      Bindings
      • 0: 2518605
      • 1: 105851
      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.13msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 105851, 0.77777777777778, 2, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 105851
      • 2: 0.7777777777777778
      • 3: 2
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      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#78distance420μsselect * from "route_waypoints" where ("route_id" = 2518605 and "place_id" = 44970) limit 1
      Bindings
      • 0: 2518605
      • 1: 44970
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance920μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518605, 44970, 0.88888888888889, 1, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 2518605
      • 1: 44970
      • 2: 0.8888888888888888
      • 3: 1
      • 4: 2025-05-18 09:04:26
      • 5: 2025-05-18 09:04:26
      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#366distance710μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518605 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518605
      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#45distance540μsselect * from "denormalised_routes" where "origin_destination_id" = 889905 limit 1
      Bindings
      • 0: 889905
      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#123distance750μsselect * from "route_directions" where "route_directions"."route_id" = 2518605 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518605
      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#198distance420μsselect * from "locations" where "locations"."id" = 530 limit 1
      Bindings
      • 0: 530
      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#198distance630μsselect * from "cities" where "cities"."id" = 498 limit 1
      Bindings
      • 0: 498
      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#215distance420μsselect * from "states" where "states"."id" = 12 limit 1
      Bindings
      • 0: 12
      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#330distance420μ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#198distance400μsselect * from "locations" where "locations"."id" = 68127 limit 1
      Bindings
      • 0: 68127
      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#198distance360μsselect * from "cities" where "cities"."id" = 9683 limit 1
      Bindings
      • 0: 9683
      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" = 12 limit 1
      Bindings
      • 0: 12
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:168
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance380μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance2.49msinsert 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 (530, 'Gresham', 'Gresham, OR', 'gresham', 'dalbe4wr', 45.504472, -122.435666, 'Gresham', 'Oregon', 'US', 'America/Los_Angeles', 68127, 'Downs', 'Downs, OR 97362', 'downs', 'lneo8dfs', 45.042343, -122.79398, 'Downs', 'Oregon', 'US', 'America/Los_Angeles', 2518605, 'OR-213/Cascade Hwy S', 74100, 'm', 3999, 46.0435911, 74100, '1 hour 6 minutes', '1 hour 6 minutes', 74.1, '74.1 km', null, 67, 0, 'No', '46 mi', 36.373770475359, 0.036373770475359, '"[{\"id\":8350452,\"route_id\":2518605,\"step_index\":\"0\",\"instruction\":\"Take I-205 S and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County\",\"distance\":66029,\"distance_unit\":\"m\",\"time\":\"3575\",\"latitude\":-122.5743998,\"longitude\":45.2788708,\"is_sub_step\":false},{\"id\":8350453,\"route_id\":2518605,\"step_index\":\"1\",\"instruction\":\"Drive to Downs Rd NE\",\"distance\":8071,\"distance_unit\":\"m\",\"time\":\"424\",\"latitude\":-122.7535439,\"longitude\":45.0476204,\"is_sub_step\":false}]"', 74100, 74100, '3 minutes', 0, 'southwest', 'northeast', '[{"name":"Happy Valley","description":"52 mi to destination","state":"Oregon","country":"US","full_address":"Happy Valley, OR","lat":"45.441233","lng":"-122.512528","fraction":0.1111111111111111,"type":"City","distance_km":2,"place_id":2042,"slug":"happy-valley","hash":"wgxc49ae"},{"name":"Richardson Creek","description":"Traveled 13 mi from origin","state":"Oregon","country":"US","full_address":"Richardson Creek, Damascus, OR 97089","lat":"45.401904","lng":"-122.465276","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":41249,"slug":"richardson-creek","hash":"omrufbt7"},{"name":"Echo Dell","description":"39 mi to destination","state":"Oregon","country":"US","full_address":"Echo Dell, OR 97045","lat":"45.332344","lng":"-122.527589","fraction":0.3333333333333333,"type":"City","distance_km":2,"place_id":51710,"slug":"echo-dell","hash":"48hd4o32"},{"name":"Fishers Corner","description":"Traveled 26 mi from origin","state":"Oregon","country":"US","full_address":"Fishers Corner, OR 97045","lat":"45.290400","lng":"-122.564534","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":105901,"slug":"fishers-corner","hash":"hxabuxkt"},{"name":"O''Neil Corners","description":"26 mi to destination","state":"Oregon","country":"US","full_address":"O''Neil Corners, OR 97013","lat":"45.270677","lng":"-122.661758","fraction":0.5555555555555556,"type":"City","distance_km":2,"place_id":105817,"slug":"oneil-corners","hash":"e73h54p7"},{"name":"Macksburg","description":"Traveled 39 mi from origin","state":"Oregon","country":"US","full_address":"Macksburg, OR 97013","lat":"45.213890","lng":"-122.660000","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":54370,"slug":"macksburg","hash":"ofq68z3r"},{"name":"Hamricks Corner","description":"13 mi to destination","state":"Oregon","country":"US","full_address":"Hamricks Corner, OR 97013","lat":"45.151233","lng":"-122.681757","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":105851,"slug":"hamricks-corner","hash":"jesk93su"},{"name":"Monitor","description":"Traveled 52 mi from origin","state":"Oregon","country":"US","full_address":"Monitor, OR 97071","lat":"45.101510","lng":"-122.748146","fraction":0.8888888888888888,"type":"City","distance_km":1,"place_id":44970,"slug":"monitor","hash":"hmigw8cz"}]', 1, 8, '{"distanceInMiles":46.04371978575068,"distanceMilesFormatted":"46 miles","distanceFormatted":"46 miles","distanceKmFormatted":"74 km","timeHours":1.1,"timeFormatted":"1 hour 6 minutes","avgSpeed":42,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southwest"}', null, 'gresham-dalbe4wr/downs-lneo8dfs', 0, null, null, 0, '"[{\"name\":\"Happy Valley\",\"description\":\"52 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Happy Valley, OR\",\"lat\":\"45.441233\",\"lng\":\"-122.512528\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":2,\"place_id\":2042,\"slug\":\"happy-valley\",\"hash\":\"wgxc49ae\"},{\"name\":\"Richardson Creek\",\"description\":\"Traveled 13 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Richardson Creek, Damascus, OR 97089\",\"lat\":\"45.401904\",\"lng\":\"-122.465276\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":41249,\"slug\":\"richardson-creek\",\"hash\":\"omrufbt7\"},{\"name\":\"Echo Dell\",\"description\":\"39 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Echo Dell, OR 97045\",\"lat\":\"45.332344\",\"lng\":\"-122.527589\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":2,\"place_id\":51710,\"slug\":\"echo-dell\",\"hash\":\"48hd4o32\"},{\"name\":\"Fishers Corner\",\"description\":\"Traveled 26 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Fishers Corner, OR 97045\",\"lat\":\"45.290400\",\"lng\":\"-122.564534\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":105901,\"slug\":\"fishers-corner\",\"hash\":\"hxabuxkt\"},{\"name\":\"O''Neil Corners\",\"description\":\"26 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"O''Neil Corners, OR 97013\",\"lat\":\"45.270677\",\"lng\":\"-122.661758\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":2,\"place_id\":105817,\"slug\":\"oneil-corners\",\"hash\":\"e73h54p7\"},{\"name\":\"Macksburg\",\"description\":\"Traveled 39 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Macksburg, OR 97013\",\"lat\":\"45.213890\",\"lng\":\"-122.660000\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":54370,\"slug\":\"macksburg\",\"hash\":\"ofq68z3r\"},{\"name\":\"Hamricks Corner\",\"description\":\"13 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Hamricks Corner, OR 97013\",\"lat\":\"45.151233\",\"lng\":\"-122.681757\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":105851,\"slug\":\"hamricks-corner\",\"hash\":\"jesk93su\"},{\"name\":\"Monitor\",\"description\":\"Traveled 52 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Monitor, OR 97071\",\"lat\":\"45.101510\",\"lng\":\"-122.748146\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":1,\"place_id\":44970,\"slug\":\"monitor\",\"hash\":\"hmigw8cz\"}]"', 2, 889905, '2025-05-18 09:04:26', '2025-05-18 09:04:26') returning "id"
      Bindings
      • 0: 530
      • 1: Gresham
      • 2: Gresham, OR
      • 3: gresham
      • 4: dalbe4wr
      • 5: 45.504472
      • 6: -122.435666
      • 7: Gresham
      • 8: Oregon
      • 9: US
      • 10: America/Los_Angeles
      • 11: 68127
      • 12: Downs
      • 13: Downs, OR 97362
      • 14: downs
      • 15: lneo8dfs
      • 16: 45.042343
      • 17: -122.79398
      • 18: Downs
      • 19: Oregon
      • 20: US
      • 21: America/Los_Angeles
      • 22: 2518605
      • 23: OR-213/Cascade Hwy S
      • 24: 74100
      • 25: m
      • 26: 3999
      • 27: 46.0435911
      • 28: 74100
      • 29: 1 hour 6 minutes
      • 30: 1 hour 6 minutes
      • 31: 74.1
      • 32: 74.1 km
      • 33: 
      • 34: 67
      • 35: 0
      • 36: No
      • 37: 46 mi
      • 38: 36.37377047535912
      • 39: 0.03637377047535912
      • 40: "[{\"id\":8350452,\"route_id\":2518605,\"step_index\":\"0\",\"instruction\":\"Take I-205 S and OR-213 S to Mt Angel Scotts Mills Rd NE in Marion County\",\"distance\":66029,\"distance_unit\":\"m\",\"time\":\"3575\",\"latitude\":-122.5743998,\"longitude\":45.2788708,\"is_sub_step\":false},{\"id\":8350453,\"route_id\":2518605,\"step_index\":\"1\",\"instruction\":\"Drive to Downs Rd NE\",\"distance\":8071,\"distance_unit\":\"m\",\"time\":\"424\",\"latitude\":-122.7535439,\"longitude\":45.0476204,\"is_sub_step\":false}]"
      • 41: 74100
      • 42: 74100
      • 43: 3 minutes
      • 44: 0
      • 45: southwest
      • 46: northeast
      • 47: [{"name":"Happy Valley","description":"52 mi to destination","state":"Oregon","country":"US","full_address":"Happy Valley, OR","lat":"45.441233","lng":"-122.512528","fraction":0.1111111111111111,"type":"City","distance_km":2,"place_id":2042,"slug":"happy-valley","hash":"wgxc49ae"},{"name":"Richardson Creek","description":"Traveled 13 mi from origin","state":"Oregon","country":"US","full_address":"Richardson Creek, Damascus, OR 97089","lat":"45.401904","lng":"-122.465276","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":41249,"slug":"richardson-creek","hash":"omrufbt7"},{"name":"Echo Dell","description":"39 mi to destination","state":"Oregon","country":"US","full_address":"Echo Dell, OR 97045","lat":"45.332344","lng":"-122.527589","fraction":0.3333333333333333,"type":"City","distance_km":2,"place_id":51710,"slug":"echo-dell","hash":"48hd4o32"},{"name":"Fishers Corner","description":"Traveled 26 mi from origin","state":"Oregon","country":"US","full_address":"Fishers Corner, OR 97045","lat":"45.290400","lng":"-122.564534","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":105901,"slug":"fishers-corner","hash":"hxabuxkt"},{"name":"O'Neil Corners","description":"26 mi to destination","state":"Oregon","country":"US","full_address":"O'Neil Corners, OR 97013","lat":"45.270677","lng":"-122.661758","fraction":0.5555555555555556,"type":"City","distance_km":2,"place_id":105817,"slug":"oneil-corners","hash":"e73h54p7"},{"name":"Macksburg","description":"Traveled 39 mi from origin","state":"Oregon","country":"US","full_address":"Macksburg, OR 97013","lat":"45.213890","lng":"-122.660000","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":54370,"slug":"macksburg","hash":"ofq68z3r"},{"name":"Hamricks Corner","description":"13 mi to destination","state":"Oregon","country":"US","full_address":"Hamricks Corner, OR 97013","lat":"45.151233","lng":"-122.681757","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":105851,"slug":"hamricks-corner","hash":"jesk93su"},{"name":"Monitor","description":"Traveled 52 mi from origin","state":"Oregon","country":"US","full_address":"Monitor, OR 97071","lat":"45.101510","lng":"-122.748146","fraction":0.8888888888888888,"type":"City","distance_km":1,"place_id":44970,"slug":"monitor","hash":"hmigw8cz"}]
      • 48: 1
      • 49: 8
      • 50: {"distanceInMiles":46.04371978575068,"distanceMilesFormatted":"46 miles","distanceFormatted":"46 miles","distanceKmFormatted":"74 km","timeHours":1.1,"timeFormatted":"1 hour 6 minutes","avgSpeed":42,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southwest"}
      • 51: 
      • 52: gresham-dalbe4wr/downs-lneo8dfs
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Happy Valley\",\"description\":\"52 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Happy Valley, OR\",\"lat\":\"45.441233\",\"lng\":\"-122.512528\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":2,\"place_id\":2042,\"slug\":\"happy-valley\",\"hash\":\"wgxc49ae\"},{\"name\":\"Richardson Creek\",\"description\":\"Traveled 13 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Richardson Creek, Damascus, OR 97089\",\"lat\":\"45.401904\",\"lng\":\"-122.465276\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":41249,\"slug\":\"richardson-creek\",\"hash\":\"omrufbt7\"},{\"name\":\"Echo Dell\",\"description\":\"39 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Echo Dell, OR 97045\",\"lat\":\"45.332344\",\"lng\":\"-122.527589\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":2,\"place_id\":51710,\"slug\":\"echo-dell\",\"hash\":\"48hd4o32\"},{\"name\":\"Fishers Corner\",\"description\":\"Traveled 26 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Fishers Corner, OR 97045\",\"lat\":\"45.290400\",\"lng\":\"-122.564534\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":105901,\"slug\":\"fishers-corner\",\"hash\":\"hxabuxkt\"},{\"name\":\"O'Neil Corners\",\"description\":\"26 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"O'Neil Corners, OR 97013\",\"lat\":\"45.270677\",\"lng\":\"-122.661758\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":2,\"place_id\":105817,\"slug\":\"oneil-corners\",\"hash\":\"e73h54p7\"},{\"name\":\"Macksburg\",\"description\":\"Traveled 39 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Macksburg, OR 97013\",\"lat\":\"45.213890\",\"lng\":\"-122.660000\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":54370,\"slug\":\"macksburg\",\"hash\":\"ofq68z3r\"},{\"name\":\"Hamricks Corner\",\"description\":\"13 mi to destination\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Hamricks Corner, OR 97013\",\"lat\":\"45.151233\",\"lng\":\"-122.681757\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":105851,\"slug\":\"hamricks-corner\",\"hash\":\"jesk93su\"},{\"name\":\"Monitor\",\"description\":\"Traveled 52 mi from origin\",\"state\":\"Oregon\",\"country\":\"US\",\"full_address\":\"Monitor, OR 97071\",\"lat\":\"45.101510\",\"lng\":\"-122.748146\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":1,\"place_id\":44970,\"slug\":\"monitor\",\"hash\":\"hmigw8cz\"}]"
      • 58: 2
      • 59: 889905
      • 60: 2025-05-18 09:04:26
      • 61: 2025-05-18 09:04:26
      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#70distance590μsselect exists(select "id" from "routes" where "origin_destination_id" = 889905 limit 1) as "exists"
      Bindings
      • 0: 889905
      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#1186distance730μsselect * from "routes" where "routes"."origin_destination_id" = 889905 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889905
      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#1186distance550μsselect * from "route_directions" where "route_directions"."route_id" in (2518605, 2518606, 2518607) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance1.03msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:26' where "id" = 2518605
      Bindings
      • 0: 2025-05-18 09:04:26
      • 1: 2518605
      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#235distance430μsselect * from "origin_destinations" where "origin_destinations"."id" = 889905 limit 1
      Bindings
      • 0: 889905
      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#244distance510μsselect * from "places" where "places"."id" = 530 limit 1
      Bindings
      • 0: 530
      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#245distance440μsselect * from "places" where "places"."id" = 68127 limit 1
      Bindings
      • 0: 68127
      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#24distance380μsselect * from "route_waypoints" where "route_id" = 2518605
      Bindings
      • 0: 2518605
      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#28distance410μsselect * from "places" where "places"."id" = 2042 limit 1
      Bindings
      • 0: 2042
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance450μsselect * from "locations" where "locations"."id" in (2042)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance380μsselect * from "cities" where "cities"."id" in (1812)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance360μsselect * from "states" where "states"."id" in (12)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance400μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance420μsselect * from "places" where "places"."id" = 41249 limit 1
      Bindings
      • 0: 41249
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance410μsselect * from "locations" where "locations"."id" in (41249)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance410μsselect * from "cities" where "cities"."id" in (2427)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance340μsselect * from "states" where "states"."id" in (12)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance370μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance430μsselect * from "places" where "places"."id" = 51710 limit 1
      Bindings
      • 0: 51710
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance350μsselect * from "locations" where "locations"."id" in (51710)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance370μsselect * from "cities" where "cities"."id" in (25040)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance360μsselect * from "states" where "states"."id" in (12)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance370μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance420μsselect * from "places" where "places"."id" = 105901 limit 1
      Bindings
      • 0: 105901
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance390μsselect * from "locations" where "locations"."id" in (105901)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance360μsselect * from "cities" where "cities"."id" in (39331)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance360μsselect * from "states" where "states"."id" in (12)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance370μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance450μsselect * from "places" where "places"."id" = 105817 limit 1
      Bindings
      • 0: 105817
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance360μsselect * from "locations" where "locations"."id" in (105817)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance340μsselect * from "cities" where "cities"."id" in (39278)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#28distance340μsselect * from "states" where "states"."id" in (12)
      Backtrace
      • app/Services/RouteWaypointService.php:28
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#39distance500μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Services/RouteWaypointService.php:39
      • app/Services/RouteWaypointService.php:27
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • distance420μsselect * from "places" where "places"."id" = ? limit 1
    • distance330μsselect * from "locations" where "locations"."id" in (54370)
    • distance300μsselect * from "cities" where "cities"."id" in (17452)
    • distance310μsselect * from "states" where "states"."id" in (12)
    • distance310μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" in (105851)
    • distance420μsselect * from "cities" where "cities"."id" in (39296)
    • distance290μsselect * from "states" where "states"."id" in (12)
    • distance310μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance300μsselect * from "locations" where "locations"."id" in (44970)
    • distance320μsselect * from "cities" where "cities"."id" in (23377)
    • distance280μsselect * from "states" where "states"."id" in (12)
    • distance310μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance580μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance470μsselect * from "route_waypoints" where "route_id" = ?
    • distance400μsselect * from "places" where "places"."id" = ? limit 1
    • distance340μsselect * from "locations" where "locations"."id" in (2042)
    • distance300μsselect * from "cities" where "cities"."id" in (1812)
    • distance300μsselect * from "states" where "states"."id" in (12)
    • distance330μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance380μsselect * from "places" where "places"."id" = ? limit 1
    • distance380μsselect * from "locations" where "locations"."id" in (41249)
    • distance280μsselect * from "cities" where "cities"."id" in (2427)
    • distance300μsselect * from "states" where "states"."id" in (12)
    • distance300μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" in (51710)
    • distance300μsselect * from "cities" where "cities"."id" in (25040)
    • distance280μsselect * from "states" where "states"."id" in (12)
    • distance290μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance530μsselect * from "places" where "places"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" in (105901)
    • distance290μsselect * from "cities" where "cities"."id" in (39331)
    • distance260μsselect * from "states" where "states"."id" in (12)
    • distance330μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" in (105817)
    • distance270μsselect * from "cities" where "cities"."id" in (39278)
    • distance280μsselect * from "states" where "states"."id" in (12)
    • distance290μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" in (54370)
    • distance270μsselect * from "cities" where "cities"."id" in (17452)
    • distance280μsselect * from "states" where "states"."id" in (12)
    • distance280μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance310μsselect * from "places" where "places"."id" = ? limit 1
    • distance300μsselect * from "locations" where "locations"."id" in (105851)
    • distance260μsselect * from "cities" where "cities"."id" in (39296)
    • distance280μsselect * from "states" where "states"."id" in (12)
    • distance280μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance340μsselect * from "locations" where "locations"."id" in (44970)
    • distance320μsselect * from "cities" where "cities"."id" in (23377)
    • distance330μsselect * from "states" where "states"."id" in (12)
    • distance370μsselect * from "countries" where "countries"."id" = ? limit 1
    • distance320μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance290μsselect * from "states" where "states"."id" = ? limit 1
    • distance310μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance280μsselect * from "states" where "states"."id" = ? limit 1
    • distance570μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance420μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance1.03msupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance560μsselect * from "places" where "places"."id" = ? limit 1
    • distance24.28msselect * from "images" where "images"."place_id" in (530)
    • distance600μsselect * from "places" where "places"."id" = ? limit 1
    • distance27.39msselect * from "images" where "images"."place_id" in (68127)
    • distance590μsselect * from "routes" where "origin_destination_id" = ?
    • distance530μsselect exists(select * from (select "id", "route_id", row_number() over (partition by "route_directions"."route_id") as "laravel_row" from "route_directions") as "laravel_table" where "laravel_row" <= 1 order by "laravel_row") as "exists"
    • distance390μsselect * from "route_directions" where "route_directions"."route_id" in (2518605, 2518606, 2518607) order by "step_index" asc, "step_index" asc
    • distance440μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance340μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance380μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance730μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance440μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance360μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance560μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\Place
    26Place.php#?
    App\Models\RouteWaypoint
    24RouteWaypoint.php#?
    App\Models\Location
    20Location.php#?
    App\Models\State
    20State.php#?
    App\Models\City
    18City.php#?
    App\Models\Country
    18Country.php#?
    App\Models\RouteDirection
    14RouteDirection.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Image
    4Image.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:26GET/distance/gresham-dalbe4wr/downs-lneo8dfs342178156