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

Just a moment while we calculate your route...

Distance from Monroe to Clifside

Driving Distance
308.8 mi • 497 km
Flying Distance
195.1 mi • 313.9 km
A
B
Leaflet © OpenStreetMap contributors
60 mph avg speed
Northwest direction
4 hr 36 min travel time

Route Information

The driving distance from Monroe, Utah to Clifside, Nevada is 308.8 mi (497 km)

The straight-line (air) distance is 195.1 mi (313.9 km)

The estimated flight time is 0 hr 24 min

The estimated travel time by road is 4 hours 36 minutes

Traveling highway, long-distance in a northwest direction. Average speeds around 60 mph.

Location Details

Origin:

Monroe
Place Monroe
State/Province Utah
Country US
Latitude 38.629972
Longitude -112.120757
GPS 38.629972° N, 112.120757° W
Local Time 3:04 AM
Timezone America/Denver

Destination:


No image available
Place Clifside
State/Province Nevada
Country US
Latitude 40.916039
Longitude -114.277242
GPS 40.916039° N, 114.277242° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Journey Summary

Traveling from Monroe, Utah to Clifside, Nevada covers 308.8 mi (497 km) in a northwest direction. This highway, long-distance route typically takes 4 hours 36 minutes under normal conditions.

Drivers have 3 route options between these locations (300.6-312.2 miles / 484-502 km).

The route features scenic views, toll sections. with average speeds around 60 mph (97 km/h).

Available Routes

I-15 N and I-80 W
308.8 mi 4 hours 36 minutes
Shortest Fastest Tolls
US-50 W, I-15 N and I-80 W
312.2 mi 4 hours 37 minutes
Tolls
I-80 W
300.6 mi 4 hours 48 minutes
Tolls

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

Monroe
Utah , US
Meadow
Utah, US
23.6 mi
Van
Utah, US
50.9 mi
Hinckley
Utah, US
56.4 mi
Joy
Utah, US
82.3 mi
Clifton
Utah, US
136.3 mi
Gold Hill
Utah, US
140.0 mi
Wendover
Utah, US
177.7 mi
Clifside
Nevada , US
Messages61RequestTimelineExceptionsViews2Queries169Models121MailsGate
SettingsRequest history3.91sRequest 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/monroe-vwgxevev/clifside-wc9fm2yp
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:38] LOG.warning: No denormalized route found for origin-destination ID: 889922
  • infolog[09:04:38] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 10...
  • infolog[09:04:38] 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: 889922 { "origin": "Mon...
  • 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 5 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 2 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
  • 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 3
  • 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 4
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 2 nested sub-directions for direction index 5
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 5 nested sub-directions for direction index 6
  • infolog[09:04:40] LOG.info: Saved 7 directions for route ID: 2518643
  • infolog[09:04:40] LOG.info: Found a shorter route: 497046 meters for route ID: 2518643
  • 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: 889922 { "origin": "Mon...
  • 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 5 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 2 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
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 4 nested sub-directions for direction index 3
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 5 nested sub-directions for direction index 4
  • infolog[09:04:40] LOG.info: Saved 5 directions for route ID: 2518644
  • 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: 889922 { "origin": "Mon...
  • 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 5 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 11 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 3 nested sub-directions for direction index 2
  • 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 3
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 8 nested sub-directions for direction index 4
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 2 nested sub-directions for direction index 5
  • debuglog[09:04:40] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:40] LOG.info: Ignoring 5 nested sub-directions for direction index 6
  • infolog[09:04:40] LOG.info: Saved 7 directions for route ID: 2518645
  • infolog[09:04:40] LOG.info: Found a shorter route: 483807 meters for route ID: 2518645
  • infolog[09:04:41] LOG.info: Successfully denormalized route data { "origin_destination_id": 889922, ...
  • infolog[09:04:41] LOG.info: Saved 3 routes for origin-destination ID: 889922
  • infolog[09:04:41] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518645, ...
  • infolog[09:04:41] LOG.info: Incremented view count for route { "id": 2518645, "name": "I-80 W", ...
  • infolog[09:04:41] LOG.info: Updated denormalized route for route { "route_id": 2518645, "views": 1 ...
  • infolog[09:04:41] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518645, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/monroe-vwgxevev/clifside-wc9fm2yp
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
3.92s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a3023bc5cc985-IAD"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:42 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "MS1dHxjm3Y6emrKp9A4O2VVqiQawd7XRd3E91QNK"
]
  • Booting (6.99ms)time
  • Application (3.9s)time
  • Routing (360μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (36μs)
  • 1 x Application (99.82%)
    3.90s
    1 x Booting (0.18%)
    6.99ms
    1 x Routing (0.01%)
    360μs
    1 x Preparing Response (0%)
    36μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    169 statements were executed (98 duplicates)Show only duplicatesdistance2.36s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 69 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance13.9msselect * from "sessions" where "id" = '13ELMaJujh67kyhL1mulz83e9dY41TzyTJio0JYs' limit 1
      Bindings
      • 0: 13ELMaJujh67kyhL1mulz83e9dY41TzyTJio0JYs
      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.23msselect * from "places" where "slug" = 'monroe' and ("hash" = 'vwgxevev') limit 1
      Bindings
      • 0: monroe
      • 1: vwgxevev
      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" = 'clifside' and ("hash" = 'wc9fm2yp') limit 1
      Bindings
      • 0: clifside
      • 1: wc9fm2yp
      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#104distance870μsselect * from "origin_destinations" where ("origin_id" = 10936 and "destination_id" = 42444) limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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.24msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (10936, 42444, '2025-05-18 09:04:38', '2025-05-18 09:04:38') returning "id"
      Bindings
      • 0: 10936
      • 1: 42444
      • 2: 2025-05-18 09:04:38
      • 3: 2025-05-18 09:04:38
      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.75msselect * from "denormalised_routes" where "origin_destination_id" = 889922 limit 1
      Bindings
      • 0: 889922
      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#70distance690μsselect exists(select "id" from "routes" where "origin_destination_id" = 889922 limit 1) as "exists"
      Bindings
      • 0: 889922
      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#158distance860μsdelete from "routes" where "origin_destination_id" = 889922
      Bindings
      • 0: 889922
      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" = 10936 limit 1
      Bindings
      • 0: 10936
      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#173distance370μsselect * from "places" where "places"."id" = 42444 limit 1
      Bindings
      • 0: 42444
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance1.6msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889922, 'I-15 N and I-80 W', 497046, 'm', 16618, 1, 'Your destination is in a different time zone.', 38.6299724, 40.9160544, null, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 889922
      • 1: I-15 N and I-80 W
      • 2: 497046
      • 3: m
      • 4: 16618
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 38.6299724
      • 8: 40.9160544
      • 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.04msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 0, 'Get on I-70 E/US-89 N in Richfield from UT-118 N', 16369, 'm', 777, -112.1048086, 38.69400425, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 0
      • 2: Get on I-70 E/US-89 N in Richfield from UT-118 N
      • 3: 16369
      • 4: m
      • 5: 777
      • 6: -112.1048086
      • 7: 38.69400425
      • 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#548distance720μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 1, 'Follow I-70 E/US-89 N to State Hwy 259 S. Take exit 48 from I-70 E/US-89 N', 18134, 'm', 557, -112.03516495, 38.81550915, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 1
      • 2: Follow I-70 E/US-89 N to State Hwy 259 S. Take exit 48 from I-70 E/US-89 N
      • 3: 18134
      • 4: m
      • 5: 557
      • 6: -112.03516495
      • 7: 38.815509150000004
      • 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#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 2, 'Get on I-15 N in Millard County from US-50 W', 51519, 'm', 1964, -112.0200539, 39.0660807, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 2
      • 2: Get on I-15 N in Millard County from US-50 W
      • 3: 51519
      • 4: m
      • 5: 1964
      • 6: -112.0200539
      • 7: 39.0660807
      • 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#548distance710μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 3, 'Continue to South Salt Lake. Take exit 305A-305B-305C-305D from I-15 N', 188295, 'm', 5705, -111.8771547, 39.9918017, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 3
      • 2: Continue to South Salt Lake. Take exit 305A-305B-305C-305D from I-15 N
      • 3: 188295
      • 4: m
      • 5: 5705
      • 6: -111.8771547
      • 7: 39.9918017
      • 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#548distance690μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 4, '', 27074, 'm', 974, -112.0743426, 40.72203635, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 4
      • 2: 
      • 3: 27074
      • 4: m
      • 5: 974
      • 6: -112.07434260000001
      • 7: 40.72203635
      • 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#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 5, 'Follow I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W', 182142, 'm', 5530, -113.2192223, 40.75308695, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 5
      • 2: Follow I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W
      • 3: 182142
      • 4: m
      • 5: 5530
      • 6: -113.2192223
      • 7: 40.75308695
      • 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#548distance700μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518643, 6, 'Continue on Pilot Rd to your destination', 13513, 'm', 1111, -114.24459365, 40.8798252, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518643
      • 1: 6
      • 2: Continue on Pilot Rd to your destination
      • 3: 13513
      • 4: m
      • 5: 1111
      • 6: -114.24459365
      • 7: 40.8798252
      • 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#225distance860μsinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889922, 'US-50 W, I-15 N and I-80 W', 502399, 'm', 16646, 1, 'Your destination is in a different time zone.', 38.6299724, 40.9160544, null, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 889922
      • 1: US-50 W, I-15 N and I-80 W
      • 2: 502399
      • 3: m
      • 4: 16646
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 38.6299724
      • 8: 40.9160544
      • 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#548distance640μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518644, 0, 'Get on I-70 E/US-89 N in Richfield from UT-118 N', 16369, 'm', 777, -112.1048086, 38.69400425, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518644
      • 1: 0
      • 2: Get on I-70 E/US-89 N in Richfield from UT-118 N
      • 3: 16369
      • 4: m
      • 5: 777
      • 6: -112.1048086
      • 7: 38.69400425
      • 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#548distance650μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518644, 1, 'Follow I-70 E/US-89 N to State Hwy 259 S. Take exit 48 from I-70 E/US-89 N', 18134, 'm', 557, -112.03516495, 38.81550915, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518644
      • 1: 1
      • 2: Follow I-70 E/US-89 N to State Hwy 259 S. Take exit 48 from I-70 E/US-89 N
      • 3: 18134
      • 4: m
      • 5: 557
      • 6: -112.03516495
      • 7: 38.815509150000004
      • 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#548distance640μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518644, 2, 'Get on I-15 N in Millard County from US-50 W', 51519, 'm', 1964, -112.0200539, 39.0660807, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518644
      • 1: 2
      • 2: Get on I-15 N in Millard County from US-50 W
      • 3: 51519
      • 4: m
      • 5: 1964
      • 6: -112.0200539
      • 7: 39.0660807
      • 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#548distance860μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518644, 3, 'Follow I-15 N and I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W', 402864, 'm', 12237, -112.92730065, 40.05125175, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518644
      • 1: 3
      • 2: Follow I-15 N and I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W
      • 3: 402864
      • 4: m
      • 5: 12237
      • 6: -112.92730064999999
      • 7: 40.05125175
      • 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#548distance1.8msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518644, 4, 'Continue on Pilot Rd to your destination', 13513, 'm', 1111, -114.24459365, 40.8798252, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518644
      • 1: 4
      • 2: Continue on Pilot Rd to your destination
      • 3: 13513
      • 4: m
      • 5: 1111
      • 6: -114.24459365
      • 7: 40.8798252
      • 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.06msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889922, 'I-80 W', 483807, 'm', 17301, 1, 'Your destination is in a different time zone.', 38.6299724, 40.9160544, null, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 889922
      • 1: I-80 W
      • 2: 483807
      • 3: m
      • 4: 17301
      • 5: 1
      • 6: Your destination is in a different time zone.
      • 7: 38.6299724
      • 8: 40.9160544
      • 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#548distance780μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 0, 'Get on I-70 E/US-89 N in Richfield from UT-118 N', 16369, 'm', 777, -112.1048086, 38.69400425, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 0
      • 2: Get on I-70 E/US-89 N in Richfield from UT-118 N
      • 3: 16369
      • 4: m
      • 5: 777
      • 6: -112.1048086
      • 7: 38.69400425
      • 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#548distance710μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 1, 'Continue on I-70 E/US-89 N. Take US-50 W and I-15 N to I-15BL/UT-28 N in Nephi. Take exit 222 from I-15 N', 124136, 'm', 4146, -111.9762632, 39.2191561, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 1
      • 2: Continue on I-70 E/US-89 N. Take US-50 W and I-15 N to I-15BL/UT-28 N in Nephi. Take exit 222 from I-15 N
      • 3: 124136
      • 4: m
      • 5: 4146
      • 6: -111.97626319999998
      • 7: 39.2191561
      • 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#548distance740μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 2, 'Follow UT-132 W and Old Hwy 148/Rte 1812 to US-6 E', 39620, 'm', 1643, -112.0197232, 39.68693795, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 2
      • 2: Follow UT-132 W and Old Hwy 148/Rte 1812 to US-6 E
      • 3: 39620
      • 4: m
      • 5: 1643
      • 6: -112.0197232
      • 7: 39.68693795
      • 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#548distance700μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 3, '', 24543, 'm', 818, -112.17064555, 39.8164742, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 3
      • 2: 
      • 3: 24543
      • 4: m
      • 5: 818
      • 6: -112.17064555
      • 7: 39.8164742
      • 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#548distance740μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 4, 'Get on I-80 W in Tooele County from Mormon Trail and UT-138 W', 111914, 'm', 4136, -112.347468, 40.31528985, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 4
      • 2: Get on I-80 W in Tooele County from Mormon Trail and UT-138 W
      • 3: 111914
      • 4: m
      • 5: 4136
      • 6: -112.34746799999999
      • 7: 40.315289850000006
      • 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#548distance690μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 5, 'Follow I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W', 153712, 'm', 4670, -113.3671696, 40.77602115, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 5
      • 2: Follow I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W
      • 3: 153712
      • 4: m
      • 5: 4670
      • 6: -113.36716959999998
      • 7: 40.77602115
      • 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#548distance900μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518645, 6, 'Continue on Pilot Rd to your destination', 13513, 'm', 1111, -114.24459365, 40.8798252, 0, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518645
      • 1: 6
      • 2: Continue on Pilot Rd to your destination
      • 3: 13513
      • 4: m
      • 5: 1111
      • 6: -114.24459365
      • 7: 40.8798252
      • 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#24distance700μsselect * from "route_waypoints" where "route_id" = 2518645
      Bindings
      • 0: 2518645
      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#103distance430μsselect * from "origin_destinations" where "origin_destinations"."id" = 889922 limit 1
      Bindings
      • 0: 889922
      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#103distance450μsselect * from "places" where "places"."id" = 10936 limit 1
      Bindings
      • 0: 10936
      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#104distance340μsselect * from "places" where "places"."id" = 42444 limit 1
      Bindings
      • 0: 42444
      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#226distance92.9msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.883979444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.36036644444)) + sin(radians(38.883979444444)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance1.55msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 25391 limit 1
      Bindings
      • 0: 25391
      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.35msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.137986888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.59997588889)) + sin(radians(39.137986888889)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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" = 44570 limit 1
      Bindings
      • 0: 44570
      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#226distance90.18msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.391994333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.83958533333)) + sin(radians(39.391994333333)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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" = 18118 limit 1
      Bindings
      • 0: 18118
      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.25msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.646001777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.07919477778)) + sin(radians(39.646001777778)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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#158distance560μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 37570 limit 1
      Bindings
      • 0: 37570
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.85msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.900009222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.31880422222)) + sin(radians(39.900009222222)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance88.6msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.154016666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.55841366667)) + sin(radians(40.154016666667)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 73350 limit 1
      Bindings
      • 0: 73350
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.16msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.408024111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.79802311111)) + sin(radians(40.408024111111)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance890μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 63093 limit 1
      Bindings
      • 0: 63093
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.66msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.662031555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-114.03763255556)) + sin(radians(40.662031555556)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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" = 15716 limit 1
      Bindings
      • 0: 15716
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518645 and "place_id" = 25391) limit 1
      Bindings
      • 0: 2518645
      • 1: 25391
      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.32msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 25391, 0.11111111111111, 3, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 25391
      • 2: 0.1111111111111111
      • 3: 3
      • 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#78distance420μsselect * from "route_waypoints" where ("route_id" = 2518645 and "place_id" = 44570) limit 1
      Bindings
      • 0: 2518645
      • 1: 44570
      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#78distance910μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 44570, 0.22222222222222, 7, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 44570
      • 2: 0.2222222222222222
      • 3: 7
      • 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" = 2518645 and "place_id" = 18118) limit 1
      Bindings
      • 0: 2518645
      • 1: 18118
      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#78distance800μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 18118, 0.33333333333333, 10, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 18118
      • 2: 0.3333333333333333
      • 3: 10
      • 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#78distance400μsselect * from "route_waypoints" where ("route_id" = 2518645 and "place_id" = 37570) limit 1
      Bindings
      • 0: 2518645
      • 1: 37570
      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.32msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 37570, 0.44444444444444, 5, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 37570
      • 2: 0.4444444444444444
      • 3: 5
      • 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#78distance420μsselect * from "route_waypoints" where ("route_id" = 2518645 and "place_id" = 73349) limit 1
      Bindings
      • 0: 2518645
      • 1: 73349
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance790μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 73349, 0.66666666666667, 14, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 73349
      • 2: 0.6666666666666666
      • 3: 14
      • 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#78distance420μsselect * from "route_waypoints" where ("route_id" = 2518645 and "place_id" = 63093) limit 1
      Bindings
      • 0: 2518645
      • 1: 63093
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance990μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 63093, 0.77777777777778, 17, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 63093
      • 2: 0.7777777777777778
      • 3: 17
      • 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#78distance390μsselect * from "route_waypoints" where ("route_id" = 2518645 and "place_id" = 15716) limit 1
      Bindings
      • 0: 2518645
      • 1: 15716
      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#78distance760μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518645, 15716, 0.88888888888889, 5, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 2518645
      • 1: 15716
      • 2: 0.8888888888888888
      • 3: 5
      • 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#366distance560μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518645 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518645
      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" = 889922 limit 1
      Bindings
      • 0: 889922
      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" = 2518645 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518645
      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#198distance440μsselect * from "locations" where "locations"."id" = 10936 limit 1
      Bindings
      • 0: 10936
      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#198distance550μsselect * from "cities" where "cities"."id" = 251 limit 1
      Bindings
      • 0: 251
      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#215distance400μsselect * from "states" where "states"."id" = 30 limit 1
      Bindings
      • 0: 30
      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#330distance410μ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#198distance340μsselect * from "locations" where "locations"."id" = 42444 limit 1
      Bindings
      • 0: 42444
      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" = 18 limit 1
      Bindings
      • 0: 18
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:168
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance380μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance1.91msinsert 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 (10936, 'Monroe', 'Monroe, UT 84754', 'monroe', 'vwgxevev', 38.629972, -112.120757, 'Monroe', 'Utah', 'US', 'America/Denver', 42444, 'Clifside', 'Clifside, NV 89830', 'clifside', 'wc9fm2yp', 40.916039, -114.277242, null, 'Nevada', 'US', 'America/Los_Angeles', 2518645, 'I-80 W', 483807, 'm', 17301, 300.623639397, 483807, '4 hours 48 minutes', '4 hours 48 minutes', 483.807, '483.8 km', null, 288, 1, 'Your destination is in a different time zone.', '300.6 mi', 195.08260951902, 0.19508260951902, '"[{\"id\":8350579,\"route_id\":2518645,\"step_index\":\"0\",\"instruction\":\"Get on I-70 E\\\/US-89 N in Richfield from UT-118 N\",\"distance\":16369,\"distance_unit\":\"m\",\"time\":\"777\",\"latitude\":-112.1048086,\"longitude\":38.6940043,\"is_sub_step\":false},{\"id\":8350580,\"route_id\":2518645,\"step_index\":\"1\",\"instruction\":\"Continue on I-70 E\\\/US-89 N. Take US-50 W and I-15 N to I-15BL\\\/UT-28 N in Nephi. Take exit 222 from I-15 N\",\"distance\":124136,\"distance_unit\":\"m\",\"time\":\"4146\",\"latitude\":-111.9762632,\"longitude\":39.2191561,\"is_sub_step\":false},{\"id\":8350581,\"route_id\":2518645,\"step_index\":\"2\",\"instruction\":\"Follow UT-132 W and Old Hwy 148\\\/Rte 1812 to US-6 E\",\"distance\":39620,\"distance_unit\":\"m\",\"time\":\"1643\",\"latitude\":-112.0197232,\"longitude\":39.686938,\"is_sub_step\":false},{\"id\":8350582,\"route_id\":2518645,\"step_index\":\"3\",\"instruction\":\"\",\"distance\":24543,\"distance_unit\":\"m\",\"time\":\"818\",\"latitude\":-112.1706456,\"longitude\":39.8164742,\"is_sub_step\":false},{\"id\":8350583,\"route_id\":2518645,\"step_index\":\"4\",\"instruction\":\"Get on I-80 W in Tooele County from Mormon Trail and UT-138 W\",\"distance\":111914,\"distance_unit\":\"m\",\"time\":\"4136\",\"latitude\":-112.347468,\"longitude\":40.3152899,\"is_sub_step\":false},{\"id\":8350584,\"route_id\":2518645,\"step_index\":\"5\",\"instruction\":\"Follow I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W\",\"distance\":153712,\"distance_unit\":\"m\",\"time\":\"4670\",\"latitude\":-113.3671696,\"longitude\":40.7760212,\"is_sub_step\":false},{\"id\":8350585,\"route_id\":2518645,\"step_index\":\"6\",\"instruction\":\"Continue on Pilot Rd to your destination\",\"distance\":13513,\"distance_unit\":\"m\",\"time\":\"1111\",\"latitude\":-114.2445937,\"longitude\":40.8798252,\"is_sub_step\":false}]"', 483807, 483807, 'no time', 0, 'northwest', 'southeast', '[{"name":"Meadow","description":"279 mi to destination","state":"Utah","country":"US","full_address":"Meadow, UT","lat":"38.885798","lng":"-112.410494","fraction":0.1111111111111111,"type":"City","distance_km":3,"place_id":25391,"slug":"meadow","hash":"jikbwnst"},{"name":"Van","description":"Traveled 70 mi from origin","state":"Utah","country":"US","full_address":"Van, UT 84624","lat":"39.230513","lng":"-112.668560","fraction":0.2222222222222222,"type":"State","distance_km":7,"place_id":44570,"slug":"van","hash":"z1b02cn5"},{"name":"Hinckley","description":"209 mi to destination","state":"Utah","country":"US","full_address":"Hinckley, UT","lat":"39.324955","lng":"-112.671061","fraction":0.3333333333333333,"type":"City","distance_km":10,"place_id":18118,"slug":"hinckley","hash":"7feyz5z0"},{"name":"Joy","description":"Traveled 140 mi from origin","state":"Utah","country":"US","full_address":"Joy, UT","lat":"39.572725","lng":"-113.058578","fraction":0.4444444444444444,"type":"State","distance_km":5,"place_id":37570,"slug":"joy","hash":"1z0li34u"},{"name":"Clifton","description":"Traveled 209 mi from origin","state":"Utah","country":"US","full_address":"Clifton, UT 84034","lat":"40.104382","lng":"-113.817220","fraction":0.6666666666666666,"type":"State","distance_km":14,"place_id":73349,"slug":"clifton","hash":"wkfmin6i"},{"name":"Gold Hill","description":"70 mi to destination","state":"Utah","country":"US","full_address":"Gold Hill, UT 84034","lat":"40.166389","lng":"-113.829722","fraction":0.7777777777777778,"type":"City","distance_km":17,"place_id":63093,"slug":"gold-hill","hash":"1h8g6rsk"},{"name":"Wendover","description":"Traveled 279 mi from origin","state":"Utah","country":"US","full_address":"Wendover, UT 84083","lat":"40.737152","lng":"-114.037510","fraction":0.8888888888888888,"type":"City","distance_km":5,"place_id":15716,"slug":"wendover","hash":"vwdb8oz1"}]', 1, 7, '{"distanceInMiles":300.6244796003331,"distanceMilesFormatted":"300.6 miles","distanceFormatted":"300.6 miles","distanceKmFormatted":"484 km","timeHours":4.8,"timeFormatted":"4 hours 48 minutes","avgSpeed":60,"routeDescriptors":["highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}', null, 'monroe-vwgxevev/clifside-wc9fm2yp', 0, null, null, 0, '"[{\"name\":\"Meadow\",\"description\":\"279 mi to destination\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Meadow, UT\",\"lat\":\"38.885798\",\"lng\":\"-112.410494\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":3,\"place_id\":25391,\"slug\":\"meadow\",\"hash\":\"jikbwnst\"},{\"name\":\"Van\",\"description\":\"Traveled 70 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Van, UT 84624\",\"lat\":\"39.230513\",\"lng\":\"-112.668560\",\"fraction\":0.2222222222222222,\"type\":\"State\",\"distance_km\":7,\"place_id\":44570,\"slug\":\"van\",\"hash\":\"z1b02cn5\"},{\"name\":\"Hinckley\",\"description\":\"209 mi to destination\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Hinckley, UT\",\"lat\":\"39.324955\",\"lng\":\"-112.671061\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":10,\"place_id\":18118,\"slug\":\"hinckley\",\"hash\":\"7feyz5z0\"},{\"name\":\"Joy\",\"description\":\"Traveled 140 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Joy, UT\",\"lat\":\"39.572725\",\"lng\":\"-113.058578\",\"fraction\":0.4444444444444444,\"type\":\"State\",\"distance_km\":5,\"place_id\":37570,\"slug\":\"joy\",\"hash\":\"1z0li34u\"},{\"name\":\"Clifton\",\"description\":\"Traveled 209 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Clifton, UT 84034\",\"lat\":\"40.104382\",\"lng\":\"-113.817220\",\"fraction\":0.6666666666666666,\"type\":\"State\",\"distance_km\":14,\"place_id\":73349,\"slug\":\"clifton\",\"hash\":\"wkfmin6i\"},{\"name\":\"Gold Hill\",\"description\":\"70 mi to destination\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Gold Hill, UT 84034\",\"lat\":\"40.166389\",\"lng\":\"-113.829722\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":17,\"place_id\":63093,\"slug\":\"gold-hill\",\"hash\":\"1h8g6rsk\"},{\"name\":\"Wendover\",\"description\":\"Traveled 279 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Wendover, UT 84083\",\"lat\":\"40.737152\",\"lng\":\"-114.037510\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":5,\"place_id\":15716,\"slug\":\"wendover\",\"hash\":\"vwdb8oz1\"}]"', 7, 889922, '2025-05-18 09:04:41', '2025-05-18 09:04:41') returning "id"
      Bindings
      • 0: 10936
      • 1: Monroe
      • 2: Monroe, UT 84754
      • 3: monroe
      • 4: vwgxevev
      • 5: 38.629972
      • 6: -112.120757
      • 7: Monroe
      • 8: Utah
      • 9: US
      • 10: America/Denver
      • 11: 42444
      • 12: Clifside
      • 13: Clifside, NV 89830
      • 14: clifside
      • 15: wc9fm2yp
      • 16: 40.916039
      • 17: -114.277242
      • 18: 
      • 19: Nevada
      • 20: US
      • 21: America/Los_Angeles
      • 22: 2518645
      • 23: I-80 W
      • 24: 483807
      • 25: m
      • 26: 17301
      • 27: 300.62363939700003
      • 28: 483807
      • 29: 4 hours 48 minutes
      • 30: 4 hours 48 minutes
      • 31: 483.807
      • 32: 483.8 km
      • 33: 
      • 34: 288
      • 35: 1
      • 36: Your destination is in a different time zone.
      • 37: 300.6 mi
      • 38: 195.08260951902153
      • 39: 0.19508260951902154
      • 40: "[{\"id\":8350579,\"route_id\":2518645,\"step_index\":\"0\",\"instruction\":\"Get on I-70 E\\\/US-89 N in Richfield from UT-118 N\",\"distance\":16369,\"distance_unit\":\"m\",\"time\":\"777\",\"latitude\":-112.1048086,\"longitude\":38.6940043,\"is_sub_step\":false},{\"id\":8350580,\"route_id\":2518645,\"step_index\":\"1\",\"instruction\":\"Continue on I-70 E\\\/US-89 N. Take US-50 W and I-15 N to I-15BL\\\/UT-28 N in Nephi. Take exit 222 from I-15 N\",\"distance\":124136,\"distance_unit\":\"m\",\"time\":\"4146\",\"latitude\":-111.9762632,\"longitude\":39.2191561,\"is_sub_step\":false},{\"id\":8350581,\"route_id\":2518645,\"step_index\":\"2\",\"instruction\":\"Follow UT-132 W and Old Hwy 148\\\/Rte 1812 to US-6 E\",\"distance\":39620,\"distance_unit\":\"m\",\"time\":\"1643\",\"latitude\":-112.0197232,\"longitude\":39.686938,\"is_sub_step\":false},{\"id\":8350582,\"route_id\":2518645,\"step_index\":\"3\",\"instruction\":\"\",\"distance\":24543,\"distance_unit\":\"m\",\"time\":\"818\",\"latitude\":-112.1706456,\"longitude\":39.8164742,\"is_sub_step\":false},{\"id\":8350583,\"route_id\":2518645,\"step_index\":\"4\",\"instruction\":\"Get on I-80 W in Tooele County from Mormon Trail and UT-138 W\",\"distance\":111914,\"distance_unit\":\"m\",\"time\":\"4136\",\"latitude\":-112.347468,\"longitude\":40.3152899,\"is_sub_step\":false},{\"id\":8350584,\"route_id\":2518645,\"step_index\":\"5\",\"instruction\":\"Follow I-80 W to Pilot Rd in Elko County. Take exit 398 from I-80 W\",\"distance\":153712,\"distance_unit\":\"m\",\"time\":\"4670\",\"latitude\":-113.3671696,\"longitude\":40.7760212,\"is_sub_step\":false},{\"id\":8350585,\"route_id\":2518645,\"step_index\":\"6\",\"instruction\":\"Continue on Pilot Rd to your destination\",\"distance\":13513,\"distance_unit\":\"m\",\"time\":\"1111\",\"latitude\":-114.2445937,\"longitude\":40.8798252,\"is_sub_step\":false}]"
      • 41: 483807
      • 42: 483807
      • 43: no time
      • 44: 0
      • 45: northwest
      • 46: southeast
      • 47: [{"name":"Meadow","description":"279 mi to destination","state":"Utah","country":"US","full_address":"Meadow, UT","lat":"38.885798","lng":"-112.410494","fraction":0.1111111111111111,"type":"City","distance_km":3,"place_id":25391,"slug":"meadow","hash":"jikbwnst"},{"name":"Van","description":"Traveled 70 mi from origin","state":"Utah","country":"US","full_address":"Van, UT 84624","lat":"39.230513","lng":"-112.668560","fraction":0.2222222222222222,"type":"State","distance_km":7,"place_id":44570,"slug":"van","hash":"z1b02cn5"},{"name":"Hinckley","description":"209 mi to destination","state":"Utah","country":"US","full_address":"Hinckley, UT","lat":"39.324955","lng":"-112.671061","fraction":0.3333333333333333,"type":"City","distance_km":10,"place_id":18118,"slug":"hinckley","hash":"7feyz5z0"},{"name":"Joy","description":"Traveled 140 mi from origin","state":"Utah","country":"US","full_address":"Joy, UT","lat":"39.572725","lng":"-113.058578","fraction":0.4444444444444444,"type":"State","distance_km":5,"place_id":37570,"slug":"joy","hash":"1z0li34u"},{"name":"Clifton","description":"Traveled 209 mi from origin","state":"Utah","country":"US","full_address":"Clifton, UT 84034","lat":"40.104382","lng":"-113.817220","fraction":0.6666666666666666,"type":"State","distance_km":14,"place_id":73349,"slug":"clifton","hash":"wkfmin6i"},{"name":"Gold Hill","description":"70 mi to destination","state":"Utah","country":"US","full_address":"Gold Hill, UT 84034","lat":"40.166389","lng":"-113.829722","fraction":0.7777777777777778,"type":"City","distance_km":17,"place_id":63093,"slug":"gold-hill","hash":"1h8g6rsk"},{"name":"Wendover","description":"Traveled 279 mi from origin","state":"Utah","country":"US","full_address":"Wendover, UT 84083","lat":"40.737152","lng":"-114.037510","fraction":0.8888888888888888,"type":"City","distance_km":5,"place_id":15716,"slug":"wendover","hash":"vwdb8oz1"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":300.6244796003331,"distanceMilesFormatted":"300.6 miles","distanceFormatted":"300.6 miles","distanceKmFormatted":"484 km","timeHours":4.8,"timeFormatted":"4 hours 48 minutes","avgSpeed":60,"routeDescriptors":["highway","long-distance"],"journeyType":"extended road trip","activeFeatures":["toll sections"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}
      • 51: 
      • 52: monroe-vwgxevev/clifside-wc9fm2yp
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Meadow\",\"description\":\"279 mi to destination\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Meadow, UT\",\"lat\":\"38.885798\",\"lng\":\"-112.410494\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":3,\"place_id\":25391,\"slug\":\"meadow\",\"hash\":\"jikbwnst\"},{\"name\":\"Van\",\"description\":\"Traveled 70 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Van, UT 84624\",\"lat\":\"39.230513\",\"lng\":\"-112.668560\",\"fraction\":0.2222222222222222,\"type\":\"State\",\"distance_km\":7,\"place_id\":44570,\"slug\":\"van\",\"hash\":\"z1b02cn5\"},{\"name\":\"Hinckley\",\"description\":\"209 mi to destination\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Hinckley, UT\",\"lat\":\"39.324955\",\"lng\":\"-112.671061\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":10,\"place_id\":18118,\"slug\":\"hinckley\",\"hash\":\"7feyz5z0\"},{\"name\":\"Joy\",\"description\":\"Traveled 140 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Joy, UT\",\"lat\":\"39.572725\",\"lng\":\"-113.058578\",\"fraction\":0.4444444444444444,\"type\":\"State\",\"distance_km\":5,\"place_id\":37570,\"slug\":\"joy\",\"hash\":\"1z0li34u\"},{\"name\":\"Clifton\",\"description\":\"Traveled 209 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Clifton, UT 84034\",\"lat\":\"40.104382\",\"lng\":\"-113.817220\",\"fraction\":0.6666666666666666,\"type\":\"State\",\"distance_km\":14,\"place_id\":73349,\"slug\":\"clifton\",\"hash\":\"wkfmin6i\"},{\"name\":\"Gold Hill\",\"description\":\"70 mi to destination\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Gold Hill, UT 84034\",\"lat\":\"40.166389\",\"lng\":\"-113.829722\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":17,\"place_id\":63093,\"slug\":\"gold-hill\",\"hash\":\"1h8g6rsk\"},{\"name\":\"Wendover\",\"description\":\"Traveled 279 mi from origin\",\"state\":\"Utah\",\"country\":\"US\",\"full_address\":\"Wendover, UT 84083\",\"lat\":\"40.737152\",\"lng\":\"-114.037510\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":5,\"place_id\":15716,\"slug\":\"wendover\",\"hash\":\"vwdb8oz1\"}]"
      • 58: 7
      • 59: 889922
      • 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#70distance430μsselect exists(select "id" from "routes" where "origin_destination_id" = 889922 limit 1) as "exists"
      Bindings
      • 0: 889922
      Backtrace
      • app/Models/OriginDestination.php:70
      • app/Services/DistanceCalculationService.php:1179
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#1186distance660μsselect * from "routes" where "routes"."origin_destination_id" = 889922 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889922
      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#1186distance520μsselect * from "route_directions" where "route_directions"."route_id" in (2518643, 2518644, 2518645) 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#225distance970μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:41' where "id" = 2518645
      Bindings
      • 0: 2025-05-18 09:04:41
      • 1: 2518645
      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#235distance360μsselect * from "origin_destinations" where "origin_destinations"."id" = 889922 limit 1
      Bindings
      • 0: 889922
      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#244distance390μsselect * from "places" where "places"."id" = 10936 limit 1
      Bindings
      • 0: 10936
      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" = 42444 limit 1
      Bindings
      • 0: 42444
      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#24distance310μsselect * from "route_waypoints" where "route_id" = 2518645
      Bindings
      • 0: 2518645
      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" = 10936 limit 1
      Bindings
      • 0: 10936
      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#104distance380μsselect * from "places" where "places"."id" = 42444 limit 1
      Bindings
      • 0: 42444
      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#226distance84.96msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.883979444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.36036644444)) + sin(radians(38.883979444444)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 25391 limit 1
      Bindings
      • 0: 25391
      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.26msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.137986888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.59997588889)) + sin(radians(39.137986888889)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 44570 limit 1
      Bindings
      • 0: 44570
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance97.26msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.391994333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.83958533333)) + sin(radians(39.391994333333)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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#158distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 18118 limit 1
      Bindings
      • 0: 18118
      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.11msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.646001777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.07919477778)) + sin(radians(39.646001777778)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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" = 37570 limit 1
      Bindings
      • 0: 37570
      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#226distance85.5msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.900009222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.31880422222)) + sin(radians(39.900009222222)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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.66msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.154016666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.55841366667)) + sin(radians(40.154016666667)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance830μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 73350 limit 1
      Bindings
      • 0: 73350
      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.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.408024111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.79802311111)) + sin(radians(40.408024111111)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance560μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 63093 limit 1
      Bindings
      • 0: 63093
      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.21msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.662031555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-114.03763255556)) + sin(radians(40.662031555556)) * 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" != 10936 and "places"."id" != 42444 order by "distance" asc limit 1
      Bindings
      • 0: 10936
      • 1: 42444
      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
    • distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance1.19msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance270μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance640μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance270μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance490μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance3.82msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance570μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance530μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance270μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance530μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance450μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance340μsselect * from "route_waypoints" where "route_id" = ?
    • distance380μsselect * from "places" where "places"."id" = ? limit 1
    • distance1.3msselect * from "places" where "places"."id" = ? limit 1
    • distance91.1msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.883979444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.36036644444)) + sin(radians(38.883979444444)) * 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
    • distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance97.05msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.137986888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.59997588889)) + sin(radians(39.137986888889)) * 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
    • distance590μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance97.34msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.391994333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-112.83958533333)) + sin(radians(39.391994333333)) * 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
    • distance620μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance89.51msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.646001777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.07919477778)) + sin(radians(39.646001777778)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance540μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance89.33msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.900009222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.31880422222)) + sin(radians(39.900009222222)) * 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
    • distance96.91msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.154016666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.55841366667)) + sin(radians(40.154016666667)) * 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
    • distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance93.57msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.408024111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-113.79802311111)) + sin(radians(40.408024111111)) * 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
    • distance86.14msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.662031555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-114.03763255556)) + sin(radians(40.662031555556)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance1.73msselect "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
    • distance680μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance370μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance790μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance630μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance610μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance570μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance680μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance360μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance300μsselect * from "states" where "states"."id" = ? limit 1
    • distance1.55msselect * from "locations" where "locations"."id" = ? limit 1
    • distance280μsselect * from "states" where "states"."id" = ? limit 1
    • distance440μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance350μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance770μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance380μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.84msselect * from "images" where "images"."place_id" in (10936)
    • distance560μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.91msselect * from "images" where "images"."place_id" in (42444)
    • distance520μsselect * from "routes" where "origin_destination_id" = ?
    • distance670μ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"
    • distance590μsselect * from "route_directions" where "route_directions"."route_id" in (2518643, 2518644, 2518645) order by "step_index" asc, "step_index" asc
    • distance500μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance410μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance410μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance890μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance500μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance430μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance660μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteDirection
    45RouteDirection.php#?
    App\Models\RouteWaypoint
    35RouteWaypoint.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\Image
    4Image.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\Country
    2Country.php#?
    App\Models\City
    1City.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:42GET/distance/monroe-vwgxevev/clifside-wc9fm2yp612169121