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

Just a moment while we calculate your route...

Distance from University of Puget Sound to Orting

Driving Distance
22.6 mi • 36.4 km
Flying Distance
17.3 mi • 27.8 km
A
B
Leaflet © OpenStreetMap contributors
39 mph avg speed
Southeast direction
37 min travel time

Route Information

The driving distance from University of Puget Sound, Washington to Orting, Washington is 22.6 mi (36.4 km)

The straight-line (air) distance is 17.3 mi (27.8 km)

The estimated flight time is 0 hr 2 min

The estimated travel time by road is 37 minutes

Traveling secondary roads, moderate in a southeast direction. Average speeds around 39 mph.

Location Details

Origin:

University of Puget Sound
Place University of Puget Sound
State/Province Washington
Country US
Latitude 47.26175
Longitude -122.481444
GPS 47.26175° N, 122.481444° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Destination:

Orting
Place Orting
State/Province Washington
Country US
Latitude 47.09788
Longitude -122.204282
GPS 47.09788° N, 122.204282° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Journey Summary

Traveling from University of Puget Sound, Washington to Orting, Washington covers 22.6 mi (36.4 km) in a southeast direction. This secondary roads, moderate route typically takes 37 minutes under normal conditions.

Drivers have 3 route options between these locations (22.6-25.0 miles / 36-40 km). The primary route shown here saves 3 minutes compared to alternatives.

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

Available Routes

I-5 N and WA-162 E
22.6 mi 37 minutes
Shortest
WA-512 E
25 mi 38 minutes
WA-162 E
22.6 mi 36 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

University of Puget Sound
Washington , US
Tacoma
Washington, US
1.9 mi
Waller
Washington, US
7.0 mi
Summit
Washington, US
8.6 mi
South Hill
Washington, US
12.9 mi
Tehaleh
Washington, US
17.0 mi
Orting
Washington , US
Messages36RequestTimelineExceptionsViews2Queries140Models87MailsGate
SettingsRequest history3.41sRequest 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/university-of-puget-sound-tsgmbf2p/orting-fx0bsfx5
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:39] LOG.warning: No denormalized route found for origin-destination ID: 889923
  • infolog[09:04:39] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 17...
  • infolog[09:04:39] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:40] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:40] LOG.info: Processing route #1 data for origin-destination ID: 889923 { "origin": "Uni...
  • infolog[09:04:40] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 1 nested sub-directions for direction index 0
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 14 nested sub-directions for direction index 1
  • infolog[09:04:40] LOG.info: Saved 2 directions for route ID: 2518646
  • infolog[09:04:40] LOG.info: Found a shorter route: 36298 meters for route ID: 2518646
  • infolog[09:04:40] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:40] LOG.info: Processing route #2 data for origin-destination ID: 889923 { "origin": "Uni...
  • infolog[09:04:40] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 1 nested sub-directions for direction index 0
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 16 nested sub-directions for direction index 1
  • infolog[09:04:40] LOG.info: Saved 2 directions for route ID: 2518647
  • infolog[09:04:40] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:40] LOG.info: Processing route #3 data for origin-destination ID: 889923 { "origin": "Uni...
  • infolog[09:04:40] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 3 nested sub-directions for direction index 0
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 6 nested sub-directions for direction index 1
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 7 nested sub-directions for direction index 2
  • infolog[09:04:40] LOG.info: Saved 3 directions for route ID: 2518648
  • infolog[09:04:41] LOG.info: Successfully denormalized route data { "origin_destination_id": 889923, ...
  • infolog[09:04:41] LOG.info: Saved 3 routes for origin-destination ID: 889923
  • infolog[09:04:41] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518646, ...
  • infolog[09:04:41] LOG.info: Incremented view count for route { "id": 2518646, "name": "WA-162 E", ...
  • infolog[09:04:42] LOG.info: Updated denormalized route for route { "route_id": 2518646, "views": 1 ...
  • infolog[09:04:42] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518646, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/university-of-puget-sound-tsgmbf2p/orting-fx0bsfx5
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
3.42s
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 => "941a30254c70c985-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:43 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "nnWs2rNTFM2acqSUpVHLccDftdCR9kKYhiXrQbw3"
]
  • Booting (7.86ms)time
  • Application (3.41s)time
  • Routing (355μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (34μs)
  • 1 x Application (99.77%)
    3.41s
    1 x Booting (0.23%)
    7.86ms
    1 x Routing (0.01%)
    355μs
    1 x Preparing Response (0%)
    34μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    140 statements were executed (91 duplicates)Show only duplicatesdistance2.68s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 40 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance13.05msselect * from "sessions" where "id" = '24gey8TOn0ha5syQtYoyLyGXUcLzu0o7XTwdqKjx' limit 1
      Bindings
      • 0: 24gey8TOn0ha5syQtYoyLyGXUcLzu0o7XTwdqKjx
      Backtrace
      • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:96
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:116
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:104
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:88
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:146
    • RouteController.php#548distance6.17msselect * from "places" where "slug" = 'university-of-puget-sound' and ("hash" = 'tsgmbf2p') limit 1
      Bindings
      • 0: university-of-puget-sound
      • 1: tsgmbf2p
      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#548distance640μsselect * from "places" where "slug" = 'orting' and ("hash" = 'fx0bsfx5') limit 1
      Bindings
      • 0: orting
      • 1: fx0bsfx5
      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#104distance900μsselect * from "origin_destinations" where ("origin_id" = 170677 and "destination_id" = 4921) limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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.27msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (170677, 4921, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 170677
      • 1: 4921
      • 2: 2025-05-18 09:04:39
      • 3: 2025-05-18 09:04:39
      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.4msselect * from "denormalised_routes" where "origin_destination_id" = 889923 limit 1
      Bindings
      • 0: 889923
      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#70distance600μsselect exists(select "id" from "routes" where "origin_destination_id" = 889923 limit 1) as "exists"
      Bindings
      • 0: 889923
      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#158distance800μsdelete from "routes" where "origin_destination_id" = 889923
      Bindings
      • 0: 889923
      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#172distance540μsselect * from "places" where "places"."id" = 170677 limit 1
      Bindings
      • 0: 170677
      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#173distance510μsselect * from "places" where "places"."id" = 4921 limit 1
      Bindings
      • 0: 4921
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance2.25msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889923, 'WA-162 E', 36298, 'm', 2185, 0, 'No', 47.097836, 47.2617495, null, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 889923
      • 1: WA-162 E
      • 2: 36298
      • 3: m
      • 4: 2185
      • 5: 0
      • 6: No
      • 7: 47.097836
      • 8: 47.2617495
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:40
      • 12: 2025-05-18 09:04:40
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance1.28msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518646, 0, '', 8, 'm', 1, -122.4839618, 47.25992755, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518646
      • 1: 0
      • 2: 
      • 3: 8
      • 4: m
      • 5: 1
      • 6: -122.48396180000002
      • 7: 47.25992755
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      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 (2518646, 1, 'Continue on N Union Ave. Take WA-16 E, I-5 N and WA-167 N to WA-162 E in Orting', 36290, 'm', 2184, -122.3442708, 47.1788839, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518646
      • 1: 1
      • 2: Continue on N Union Ave. Take WA-16 E, I-5 N and WA-167 N to WA-162 E in Orting
      • 3: 36290
      • 4: m
      • 5: 2184
      • 6: -122.34427079999999
      • 7: 47.178883899999995
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance1.07msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889923, 'I-5 N and WA-162 E', 36352, 'm', 2279, 0, 'No', 47.097836, 47.2617495, null, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 889923
      • 1: I-5 N and WA-162 E
      • 2: 36352
      • 3: m
      • 4: 2279
      • 5: 0
      • 6: No
      • 7: 47.097836
      • 8: 47.2617495
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:40
      • 12: 2025-05-18 09:04:40
      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#548distance870μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518647, 0, '', 8, 'm', 1, -122.4839618, 47.25992755, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518647
      • 1: 0
      • 2: 
      • 3: 8
      • 4: m
      • 5: 1
      • 6: -122.48396180000002
      • 7: 47.25992755
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance870μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518647, 1, 'Continue on N Union Ave. Take WA-16 E, I-5 N and Valley Ave E to WA-162 E in Orting', 36344, 'm', 2278, -122.3442708, 47.1788839, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518647
      • 1: 1
      • 2: Continue on N Union Ave. Take WA-16 E, I-5 N and Valley Ave E to WA-162 E in Orting
      • 3: 36344
      • 4: m
      • 5: 2278
      • 6: -122.34427079999999
      • 7: 47.178883899999995
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance1.49msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889923, 'WA-512 E', 40208, 'm', 2313, 0, 'No', 47.097836, 47.2617495, null, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 889923
      • 1: WA-512 E
      • 2: 40208
      • 3: m
      • 4: 2313
      • 5: 0
      • 6: No
      • 7: 47.097836
      • 8: 47.2617495
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:40
      • 12: 2025-05-18 09:04:40
      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#548distance940μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518648, 0, 'Get on WA-16 E', 3342, 'm', 348, -122.4806738, 47.2470797, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518648
      • 1: 0
      • 2: Get on WA-16 E
      • 3: 3342
      • 4: m
      • 5: 348
      • 6: -122.48067379999999
      • 7: 47.2470797
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance780μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518648, 1, 'Take I-5 S and WA-512 E to WA-161 S/31st Ave SW S in Puyallup. Take the WA-161 S exit from WA-512 E', 23557, 'm', 928, -122.3884829, 47.19623125, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518648
      • 1: 1
      • 2: Take I-5 S and WA-512 E to WA-161 S/31st Ave SW S in Puyallup. Take the WA-161 S exit from WA-512 E
      • 3: 23557
      • 4: m
      • 5: 928
      • 6: -122.3884829
      • 7: 47.196231250000004
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      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#548distance810μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518648, 2, 'Take 39th Ave SE to WA-162 E in Orting', 13309, 'm', 1037, -122.24990375, 47.12938235, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518648
      • 1: 2
      • 2: Take 39th Ave SE to WA-162 E in Orting
      • 3: 13309
      • 4: m
      • 5: 1037
      • 6: -122.24990375000002
      • 7: 47.12938235
      • 8: 0
      • 9: 2025-05-18 09:04:40
      • 10: 2025-05-18 09:04:40
      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" = 2518646
      Bindings
      • 0: 2518646
      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#103distance470μsselect * from "origin_destinations" where "origin_destinations"."id" = 889923 limit 1
      Bindings
      • 0: 889923
      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#103distance460μsselect * from "places" where "places"."id" = 170677 limit 1
      Bindings
      • 0: 170677
      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#104distance420μsselect * from "places" where "places"."id" = 4921 limit 1
      Bindings
      • 0: 4921
      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#226distance93.5msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.243542222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.45064822222)) + sin(radians(47.243542222222)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#158distance910μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 242 limit 1
      Bindings
      • 0: 242
      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#226distance96.43msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.225334444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.41985244444)) + sin(radians(47.225334444444)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#226distance110msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.207126666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.38905666667)) + sin(radians(47.207126666667)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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" = 5121 limit 1
      Bindings
      • 0: 5121
      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.94msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.188918888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.35826088889)) + sin(radians(47.188918888889)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#226distance87.51msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.170711111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.32746511111)) + sin(radians(47.170711111111)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 4990 limit 1
      Bindings
      • 0: 4990
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance91.7msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.152503333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.29666933333)) + sin(radians(47.152503333333)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 608 limit 1
      Bindings
      • 0: 608
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance92.2msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.134295555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.26587355556)) + sin(radians(47.134295555556)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#226distance90.89msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.116087777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.23507777778)) + sin(radians(47.116087777778)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 6504 limit 1
      Bindings
      • 0: 6504
      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" = 2518646 and "place_id" = 242) limit 1
      Bindings
      • 0: 2518646
      • 1: 242
      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.24msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518646, 242, 0.11111111111111, 1, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518646
      • 1: 242
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:41
      • 5: 2025-05-18 09:04:41
      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" = 2518646 and "place_id" = 5121) limit 1
      Bindings
      • 0: 2518646
      • 1: 5121
      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.11msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518646, 5121, 0.33333333333333, 1, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518646
      • 1: 5121
      • 2: 0.3333333333333333
      • 3: 1
      • 4: 2025-05-18 09:04:41
      • 5: 2025-05-18 09:04:41
      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" = 2518646 and "place_id" = 4990) limit 1
      Bindings
      • 0: 2518646
      • 1: 4990
      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#78distance890μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518646, 4990, 0.55555555555556, 1, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518646
      • 1: 4990
      • 2: 0.5555555555555556
      • 3: 1
      • 4: 2025-05-18 09:04:41
      • 5: 2025-05-18 09:04:41
      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#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518646 and "place_id" = 608) limit 1
      Bindings
      • 0: 2518646
      • 1: 608
      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 (2518646, 608, 0.66666666666667, 2, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518646
      • 1: 608
      • 2: 0.6666666666666666
      • 3: 2
      • 4: 2025-05-18 09:04:41
      • 5: 2025-05-18 09:04:41
      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" = 2518646 and "place_id" = 6504) limit 1
      Bindings
      • 0: 2518646
      • 1: 6504
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance840μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518646, 6504, 0.88888888888889, 2, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518646
      • 1: 6504
      • 2: 0.8888888888888888
      • 3: 2
      • 4: 2025-05-18 09:04:41
      • 5: 2025-05-18 09:04:41
      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#366distance600μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518646 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518646
      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#45distance480μsselect * from "denormalised_routes" where "origin_destination_id" = 889923 limit 1
      Bindings
      • 0: 889923
      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#123distance650μsselect * from "route_directions" where "route_directions"."route_id" = 2518646 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518646
      Backtrace
      • app/Services/RouteDenormalisationService.php:123
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • Place.php#198distance410μsselect * from "locations" where "locations"."id" = 170690 limit 1
      Bindings
      • 0: 170690
      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#198distance560μsselect * from "cities" where "cities"."id" = 231 limit 1
      Bindings
      • 0: 231
      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#215distance370μsselect * from "states" where "states"."id" = 27 limit 1
      Bindings
      • 0: 27
      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#198distance350μsselect * from "locations" where "locations"."id" = 4921 limit 1
      Bindings
      • 0: 4921
      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#198distance350μsselect * from "cities" where "cities"."id" = 3975 limit 1
      Bindings
      • 0: 3975
      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#215distance330μsselect * from "states" where "states"."id" = 27 limit 1
      Bindings
      • 0: 27
      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#330distance360μ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.36msinsert 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 (170677, 'University of Puget Sound', 'University of Puget Sound, 1500 N Warner St, Tacoma, WA 98416', 'university-of-puget-sound', 'tsgmbf2p', 47.26175, -122.481444, 'Tacoma', 'Washington', 'US', 'America/Los_Angeles', 4921, 'Orting', 'Orting, WA 98360', 'orting', 'fx0bsfx5', 47.09788, -122.204282, 'Orting', 'Washington', 'US', 'America/Los_Angeles', 2518646, 'WA-162 E', 36298, 'm', 2185, 22.554524558, 36298, '36 minutes', '36 minutes', 36.298, '36.3 km', null, 36, 0, 'No', '22.6 mi', 17.251598909665, 0.017251598909665, '"[{\"id\":8350586,\"route_id\":2518646,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":8,\"distance_unit\":\"m\",\"time\":\"1\",\"latitude\":-122.4839618,\"longitude\":47.2599276,\"is_sub_step\":false},{\"id\":8350587,\"route_id\":2518646,\"step_index\":\"1\",\"instruction\":\"Continue on N Union Ave. Take WA-16 E, I-5 N and WA-167 N to WA-162 E in Orting\",\"distance\":36290,\"distance_unit\":\"m\",\"time\":\"2184\",\"latitude\":-122.3442708,\"longitude\":47.1788839,\"is_sub_step\":false}]"', 36298, 36298, '3 minutes', 0, 'southeast', 'northwest', '[{"name":"Tacoma","description":"25 mi to destination","state":"Washington","country":"US","full_address":"Tacoma, WA","lat":"47.255134","lng":"-122.442000","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":242,"slug":"tacoma","hash":"6wfrrk0x"},{"name":"Waller","description":"19 mi to destination","state":"Washington","country":"US","full_address":"Waller, WA","lat":"47.205063","lng":"-122.358851","fraction":0.3333333333333333,"type":"City","distance_km":1,"place_id":5121,"slug":"waller","hash":"97hr3yqn"},{"name":"Summit","description":"12 mi to destination","state":"Washington","country":"US","full_address":"Summit, WA","lat":"47.170040","lng":"-122.357095","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":4990,"slug":"summit","hash":"yljlmo5b"},{"name":"South Hill","description":"Traveled 19 mi from origin","state":"Washington","country":"US","full_address":"South Hill, WA","lat":"47.125676","lng":"-122.293008","fraction":0.6666666666666666,"type":"City","distance_km":2,"place_id":608,"slug":"south-hill","hash":"w3skone1"},{"name":"Tehaleh","description":"Traveled 25 mi from origin","state":"Washington","country":"US","full_address":"Tehaleh, WA","lat":"47.120157","lng":"-122.186466","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":6504,"slug":"tehaleh","hash":"vplcu2zs"}]', 1, 5, '{"distanceInMiles":22.554587594914686,"distanceMilesFormatted":"22.6 miles","distanceFormatted":"22.6 miles","distanceKmFormatted":"36 km","timeHours":0.6,"timeFormatted":"36 minutes","avgSpeed":39,"routeDescriptors":["secondary roads","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southeast"}', null, 'university-of-puget-sound-tsgmbf2p/orting-fx0bsfx5', 0, null, null, 0, '"[{\"name\":\"Tacoma\",\"description\":\"25 mi to destination\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Tacoma, WA\",\"lat\":\"47.255134\",\"lng\":\"-122.442000\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":242,\"slug\":\"tacoma\",\"hash\":\"6wfrrk0x\"},{\"name\":\"Waller\",\"description\":\"19 mi to destination\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Waller, WA\",\"lat\":\"47.205063\",\"lng\":\"-122.358851\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":1,\"place_id\":5121,\"slug\":\"waller\",\"hash\":\"97hr3yqn\"},{\"name\":\"Summit\",\"description\":\"12 mi to destination\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Summit, WA\",\"lat\":\"47.170040\",\"lng\":\"-122.357095\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":4990,\"slug\":\"summit\",\"hash\":\"yljlmo5b\"},{\"name\":\"South Hill\",\"description\":\"Traveled 19 mi from origin\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"South Hill, WA\",\"lat\":\"47.125676\",\"lng\":\"-122.293008\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":2,\"place_id\":608,\"slug\":\"south-hill\",\"hash\":\"w3skone1\"},{\"name\":\"Tehaleh\",\"description\":\"Traveled 25 mi from origin\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Tehaleh, WA\",\"lat\":\"47.120157\",\"lng\":\"-122.186466\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":6504,\"slug\":\"tehaleh\",\"hash\":\"vplcu2zs\"}]"', 2, 889923, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 170677
      • 1: University of Puget Sound
      • 2: University of Puget Sound, 1500 N Warner St, Tacoma, WA 98416
      • 3: university-of-puget-sound
      • 4: tsgmbf2p
      • 5: 47.26175
      • 6: -122.481444
      • 7: Tacoma
      • 8: Washington
      • 9: US
      • 10: America/Los_Angeles
      • 11: 4921
      • 12: Orting
      • 13: Orting, WA 98360
      • 14: orting
      • 15: fx0bsfx5
      • 16: 47.09788
      • 17: -122.204282
      • 18: Orting
      • 19: Washington
      • 20: US
      • 21: America/Los_Angeles
      • 22: 2518646
      • 23: WA-162 E
      • 24: 36298
      • 25: m
      • 26: 2185
      • 27: 22.554524558
      • 28: 36298
      • 29: 36 minutes
      • 30: 36 minutes
      • 31: 36.298
      • 32: 36.3 km
      • 33: 
      • 34: 36
      • 35: 0
      • 36: No
      • 37: 22.6 mi
      • 38: 17.251598909664832
      • 39: 0.017251598909664833
      • 40: "[{\"id\":8350586,\"route_id\":2518646,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":8,\"distance_unit\":\"m\",\"time\":\"1\",\"latitude\":-122.4839618,\"longitude\":47.2599276,\"is_sub_step\":false},{\"id\":8350587,\"route_id\":2518646,\"step_index\":\"1\",\"instruction\":\"Continue on N Union Ave. Take WA-16 E, I-5 N and WA-167 N to WA-162 E in Orting\",\"distance\":36290,\"distance_unit\":\"m\",\"time\":\"2184\",\"latitude\":-122.3442708,\"longitude\":47.1788839,\"is_sub_step\":false}]"
      • 41: 36298
      • 42: 36298
      • 43: 3 minutes
      • 44: 0
      • 45: southeast
      • 46: northwest
      • 47: [{"name":"Tacoma","description":"25 mi to destination","state":"Washington","country":"US","full_address":"Tacoma, WA","lat":"47.255134","lng":"-122.442000","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":242,"slug":"tacoma","hash":"6wfrrk0x"},{"name":"Waller","description":"19 mi to destination","state":"Washington","country":"US","full_address":"Waller, WA","lat":"47.205063","lng":"-122.358851","fraction":0.3333333333333333,"type":"City","distance_km":1,"place_id":5121,"slug":"waller","hash":"97hr3yqn"},{"name":"Summit","description":"12 mi to destination","state":"Washington","country":"US","full_address":"Summit, WA","lat":"47.170040","lng":"-122.357095","fraction":0.5555555555555556,"type":"City","distance_km":1,"place_id":4990,"slug":"summit","hash":"yljlmo5b"},{"name":"South Hill","description":"Traveled 19 mi from origin","state":"Washington","country":"US","full_address":"South Hill, WA","lat":"47.125676","lng":"-122.293008","fraction":0.6666666666666666,"type":"City","distance_km":2,"place_id":608,"slug":"south-hill","hash":"w3skone1"},{"name":"Tehaleh","description":"Traveled 25 mi from origin","state":"Washington","country":"US","full_address":"Tehaleh, WA","lat":"47.120157","lng":"-122.186466","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":6504,"slug":"tehaleh","hash":"vplcu2zs"}]
      • 48: 1
      • 49: 5
      • 50: {"distanceInMiles":22.554587594914686,"distanceMilesFormatted":"22.6 miles","distanceFormatted":"22.6 miles","distanceKmFormatted":"36 km","timeHours":0.6,"timeFormatted":"36 minutes","avgSpeed":39,"routeDescriptors":["secondary roads","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southeast"}
      • 51: 
      • 52: university-of-puget-sound-tsgmbf2p/orting-fx0bsfx5
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Tacoma\",\"description\":\"25 mi to destination\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Tacoma, WA\",\"lat\":\"47.255134\",\"lng\":\"-122.442000\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":242,\"slug\":\"tacoma\",\"hash\":\"6wfrrk0x\"},{\"name\":\"Waller\",\"description\":\"19 mi to destination\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Waller, WA\",\"lat\":\"47.205063\",\"lng\":\"-122.358851\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":1,\"place_id\":5121,\"slug\":\"waller\",\"hash\":\"97hr3yqn\"},{\"name\":\"Summit\",\"description\":\"12 mi to destination\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Summit, WA\",\"lat\":\"47.170040\",\"lng\":\"-122.357095\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":1,\"place_id\":4990,\"slug\":\"summit\",\"hash\":\"yljlmo5b\"},{\"name\":\"South Hill\",\"description\":\"Traveled 19 mi from origin\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"South Hill, WA\",\"lat\":\"47.125676\",\"lng\":\"-122.293008\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":2,\"place_id\":608,\"slug\":\"south-hill\",\"hash\":\"w3skone1\"},{\"name\":\"Tehaleh\",\"description\":\"Traveled 25 mi from origin\",\"state\":\"Washington\",\"country\":\"US\",\"full_address\":\"Tehaleh, WA\",\"lat\":\"47.120157\",\"lng\":\"-122.186466\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":6504,\"slug\":\"tehaleh\",\"hash\":\"vplcu2zs\"}]"
      • 58: 2
      • 59: 889923
      • 60: 2025-05-18 09:04:41
      • 61: 2025-05-18 09:04:41
      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#70distance460μsselect exists(select "id" from "routes" where "origin_destination_id" = 889923 limit 1) as "exists"
      Bindings
      • 0: 889923
      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#1186distance620μsselect * from "routes" where "routes"."origin_destination_id" = 889923 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889923
      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#1186distance450μsselect * from "route_directions" where "route_directions"."route_id" in (2518646, 2518647, 2518648) 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#225distance940μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:41' where "id" = 2518646
      Bindings
      • 0: 2025-05-18 09:04:41
      • 1: 2518646
      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#235distance440μsselect * from "origin_destinations" where "origin_destinations"."id" = 889923 limit 1
      Bindings
      • 0: 889923
      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#244distance480μsselect * from "places" where "places"."id" = 170677 limit 1
      Bindings
      • 0: 170677
      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#245distance360μsselect * from "places" where "places"."id" = 4921 limit 1
      Bindings
      • 0: 4921
      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#24distance320μsselect * from "route_waypoints" where "route_id" = 2518646
      Bindings
      • 0: 2518646
      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#103distance340μsselect * from "places" where "places"."id" = 170677 limit 1
      Bindings
      • 0: 170677
      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#104distance340μsselect * from "places" where "places"."id" = 4921 limit 1
      Bindings
      • 0: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance90.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.243542222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.45064822222)) + sin(radians(47.243542222222)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 242 limit 1
      Bindings
      • 0: 242
      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#226distance86.19msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.225334444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.41985244444)) + sin(radians(47.225334444444)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#226distance92.06msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.207126666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.38905666667)) + sin(radians(47.207126666667)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#158distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 5121 limit 1
      Bindings
      • 0: 5121
      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.07msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.188918888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.35826088889)) + sin(radians(47.188918888889)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#226distance90.54msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.170711111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.32746511111)) + sin(radians(47.170711111111)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#158distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 4990 limit 1
      Bindings
      • 0: 4990
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance90.01msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.152503333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.29666933333)) + sin(radians(47.152503333333)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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" = 608 limit 1
      Bindings
      • 0: 608
      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.97msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.134295555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.26587355556)) + sin(radians(47.134295555556)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#226distance93.4msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.116087777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.23507777778)) + sin(radians(47.116087777778)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      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#158distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 6504 limit 1
      Bindings
      • 0: 6504
      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#78distance400μsselect * from "route_waypoints" where ("route_id" = 2518646 and "place_id" = 242) limit 1
      Bindings
      • 0: 2518646
      • 1: 242
      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#78distance990μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:42' where "id" = 6300355
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:42
      • 2: 6300355
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518646 and "place_id" = 5121) limit 1
      Bindings
      • 0: 2518646
      • 1: 5121
      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#78distance710μsupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:42' where "id" = 6300356
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:42
      • 2: 6300356
      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#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518646 and "place_id" = 4990) limit 1
      Bindings
      • 0: 2518646
      • 1: 4990
      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#78distance730μsupdate "route_waypoints" set "fraction" = 0.55555555555556, "updated_at" = '2025-05-18 09:04:42' where "id" = 6300357
      Bindings
      • 0: 0.5555555555555556
      • 1: 2025-05-18 09:04:42
      • 2: 6300357
      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" = 2518646 and "place_id" = 608) limit 1
      Bindings
      • 0: 2518646
      • 1: 608
      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#78distance760μsupdate "route_waypoints" set "fraction" = 0.66666666666667, "updated_at" = '2025-05-18 09:04:42' where "id" = 6300358
      Bindings
      • 0: 0.6666666666666666
      • 1: 2025-05-18 09:04:42
      • 2: 6300358
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518646 and "place_id" = 6504) limit 1
      Bindings
      • 0: 2518646
      • 1: 6504
      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#78distance640μsupdate "route_waypoints" set "fraction" = 0.88888888888889, "updated_at" = '2025-05-18 09:04:42' where "id" = 6300359
      Bindings
      • 0: 0.8888888888888888
      • 1: 2025-05-18 09:04:42
      • 2: 6300359
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteDenormalisationService.php#45distance570μsselect * from "denormalised_routes" where "origin_destination_id" = 889923 limit 1
      Bindings
      • 0: 889923
      Backtrace
      • app/Services/RouteDenormalisationService.php:45
      • app/Models/Route.php:279
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#24distance550μsselect * from "route_waypoints" where "route_id" = 2518646
      Bindings
      • 0: 2518646
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#103distance510μsselect * from "places" where "places"."id" = 170677 limit 1
      Bindings
      • 0: 170677
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#104distance490μsselect * from "places" where "places"."id" = 4921 limit 1
      Bindings
      • 0: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.243542222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.45064822222)) + sin(radians(47.243542222222)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 242 limit 1
      Bindings
      • 0: 242
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance182msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.225334444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.41985244444)) + sin(radians(47.225334444444)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance198msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.207126666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.38905666667)) + sin(radians(47.207126666667)) * 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" != 170677 and "places"."id" != 4921 order by "distance" asc limit 1
      Bindings
      • 0: 170677
      • 1: 4921
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • distance730μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance212msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.188918888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.35826088889)) + sin(radians(47.188918888889)) * 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
    • distance97.54msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.170711111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.32746511111)) + sin(radians(47.170711111111)) * 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
    • distance520μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance92.56msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.152503333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.29666933333)) + sin(radians(47.152503333333)) * 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
    • distance490μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance90.44msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.134295555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.26587355556)) + sin(radians(47.134295555556)) * 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
    • distance89.4msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(47.116087777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-122.23507777778)) + sin(radians(47.116087777778)) * 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
    • distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance410μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance1.01msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance700μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance420μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance700μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance370μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance660μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance310μsselect * from "states" where "states"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance260μsselect * from "states" where "states"."id" = ? limit 1
    • distance480μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance400μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance920μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance390μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.41msselect * from "images" where "images"."place_id" in (170677)
    • distance620μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.54msselect * from "images" where "images"."place_id" in (4921)
    • distance570μsselect * from "routes" where "origin_destination_id" = ?
    • distance540μsselect exists(select * from (select "id", "route_id", row_number() over (partition by "route_directions"."route_id") as "laravel_row" from "route_directions") as "laravel_table" where "laravel_row" <= 1 order by "laravel_row") as "exists"
    • distance500μsselect * from "route_directions" where "route_directions"."route_id" in (2518646, 2518647, 2518648) 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
    • distance330μ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
    • distance590μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance420μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance320μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance470μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    25RouteWaypoint.php#?
    App\Models\RouteDirection
    16RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Image
    8Image.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:43GET/distance/university-of-puget-sound-tsgmbf2p/orting-fx0bsfx536214087