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

Just a moment while we calculate your route...

Distance from Pearson to Pacheco

Driving Distance
67.4 mi • 108.5 km
Flying Distance
46.1 mi • 74.2 km
A
B
Leaflet © OpenStreetMap contributors
47 mph avg speed
West direction
1 hr 17 min travel time

Route Information

The driving distance from Pearson, California to Pacheco, California is 67.4 mi (108.5 km)

The straight-line (air) distance is 46.1 mi (74.2 km)

The estimated flight time is 0 hr 6 min

The estimated travel time by road is 1 hour 17 minutes

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

Location Details

Origin:


No image available
Place Pearson
State/Province California
Country US
Latitude 38.130197
Longitude -121.247169
GPS 38.130197° N, 121.247169° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Destination:

Pacheco
Place Pacheco
State/Province California
Country US
Latitude 37.985411
Longitude -122.072063
GPS 37.985411° N, 122.072063° W
Local Time 2:04 AM
Timezone America/Los_Angeles

Journey Summary

Traveling from Pearson, California to Pacheco, California covers 67.4 mi (108.5 km) in a west direction. This mixed highways and local roads, moderate route typically takes 1 hour 17 minutes under normal conditions.

Drivers have 3 route options between these locations (57.4-87.2 miles / 92-140 km). The primary route shown here saves 17 minutes compared to alternatives.

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

Available Routes

CA-4 W and CA-4
67.4 mi 1 hour 17 minutes
Shortest
I-680 N
87.2 mi 1 hour 26 minutes
CA-12 and CA-4 W
57.4 mi 1 hour 9 minutes
Fastest

How is the distance calculated?

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

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

Journey Waypoints

Pearson
California , US
Villinger
California, US
6.9 mi
Isleton
California, US
19.9 mi
Bethel Island
California, US
22.8 mi
Emmaton
California, US
26.6 mi
Antioch
California, US
31.6 mi
Pittsburg
California, US
35.4 mi
Bay Point
California, US
39.5 mi
Pacheco
California , US
Messages44RequestTimelineExceptionsViews2Queries162Models99MailsGate
SettingsRequest history4.48sRequest 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/pearson-4zr8mffe/pacheco-yezad7yh
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:37] LOG.warning: No denormalized route found for origin-destination ID: 889920
  • infolog[09:04:37] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 72...
  • infolog[09:04:37] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:39] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:39] LOG.info: Processing route #1 data for origin-destination ID: 889920 { "origin": "Pea...
  • infolog[09:04:39] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 8 nested sub-directions for direction index 0
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 4 nested sub-directions for direction index 1
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:39] LOG.info: Saved 3 directions for route ID: 2518640
  • infolog[09:04:39] LOG.info: Found a shorter route: 92400 meters for route ID: 2518640
  • infolog[09:04:39] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:39] LOG.info: Processing route #2 data for origin-destination ID: 889920 { "origin": "Pea...
  • infolog[09:04:39] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 8 nested sub-directions for direction index 0
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 4 nested sub-directions for direction index 1
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 4 nested sub-directions for direction index 2
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 2 nested sub-directions for direction index 3
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 3 nested sub-directions for direction index 4
  • infolog[09:04:39] LOG.info: Saved 5 directions for route ID: 2518641
  • infolog[09:04:39] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:39] LOG.info: Processing route #3 data for origin-destination ID: 889920 { "origin": "Pea...
  • infolog[09:04:39] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 8 nested sub-directions for direction index 0
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 12 nested sub-directions for direction index 1
  • debuglog[09:04:39] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:39] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:39] LOG.info: Saved 3 directions for route ID: 2518642
  • infolog[09:04:40] LOG.info: Successfully denormalized route data { "origin_destination_id": 889920, ...
  • infolog[09:04:40] LOG.info: Saved 3 routes for origin-destination ID: 889920
  • infolog[09:04:40] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518640, ...
  • infolog[09:04:40] LOG.info: Incremented view count for route { "id": 2518640, "name": "CA-12 and CA...
  • infolog[09:04:40] LOG.info: Updated denormalized route for route { "route_id": 2518640, "views": 1 ...
  • infolog[09:04:40] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518640, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/pearson-4zr8mffe/pacheco-yezad7yh
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
4.49s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a301e1c36c985-IAD"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:41 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "b4EPKbB6lLXE6GkJiD198PXuxHvbkiY6PcDTMoH5"
]
  • Booting (9.94ms)time
  • Application (4.47s)time
  • Routing (495μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (34μs)
  • 1 x Application (99.78%)
    4.47s
    1 x Booting (0.22%)
    9.94ms
    1 x Routing (0.01%)
    495μs
    1 x Preparing Response (0%)
    34μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    162 statements were executed (101 duplicates)Show only duplicatesdistance2.32s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 62 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance15.94msselect * from "sessions" where "id" = 'OxwIOFBm0t553fO8hqbqUNUiJIxYAxUCgiwC0XO2' limit 1
      Bindings
      • 0: OxwIOFBm0t553fO8hqbqUNUiJIxYAxUCgiwC0XO2
      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.93msselect * from "places" where "slug" = 'pearson' and ("hash" = '4zr8mffe') limit 1
      Bindings
      • 0: pearson
      • 1: 4zr8mffe
      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#548distance840μsselect * from "places" where "slug" = 'pacheco' and ("hash" = 'yezad7yh') limit 1
      Bindings
      • 0: pacheco
      • 1: yezad7yh
      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#104distance860μsselect * from "origin_destinations" where ("origin_id" = 72737 and "destination_id" = 7216) limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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.18msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (72737, 7216, '2025-05-18 09:04:37', '2025-05-18 09:04:37') returning "id"
      Bindings
      • 0: 72737
      • 1: 7216
      • 2: 2025-05-18 09:04:37
      • 3: 2025-05-18 09:04:37
      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.5msselect * from "denormalised_routes" where "origin_destination_id" = 889920 limit 1
      Bindings
      • 0: 889920
      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#70distance610μsselect exists(select "id" from "routes" where "origin_destination_id" = 889920 limit 1) as "exists"
      Bindings
      • 0: 889920
      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#158distance1.05msdelete from "routes" where "origin_destination_id" = 889920
      Bindings
      • 0: 889920
      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#172distance630μsselect * from "places" where "places"."id" = 72737 limit 1
      Bindings
      • 0: 72737
      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#173distance420μsselect * from "places" where "places"."id" = 7216 limit 1
      Bindings
      • 0: 7216
      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.71msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889920, 'CA-12 and CA-4 W', 92400, 'm', 4185, 0, 'No', 37.9854114, 38.1552252, null, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 889920
      • 1: CA-12 and CA-4 W
      • 2: 92400
      • 3: m
      • 4: 4185
      • 5: 0
      • 6: No
      • 7: 37.9854114
      • 8: 38.1552252
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:39
      • 12: 2025-05-18 09:04:39
      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.14msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518640, 0, 'Take E Lodi Ave and N Davis Rd to CA-12', 10105, 'm', 884, -121.29072395, 38.1232992, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 0
      • 2: Take E Lodi Ave and N Davis Rd to CA-12
      • 3: 10105
      • 4: m
      • 5: 884
      • 6: -121.29072395
      • 7: 38.1232992
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518640, 1, 'Follow CA-12, CA-160 S and CA-4 W to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4 W', 81244, 'm', 3172, -121.70469375, 38.07322415, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 1
      • 2: Follow CA-12, CA-160 S and CA-4 W to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4 W
      • 3: 81244
      • 4: m
      • 5: 3172
      • 6: -121.70469375
      • 7: 38.07322415
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518640, 2, 'Follow Pacheco Blvd to Temple Dr in Pacheco', 1051, 'm', 129, -122.07318515, 37.9897796, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 2
      • 2: Follow Pacheco Blvd to Temple Dr in Pacheco
      • 3: 1051
      • 4: m
      • 5: 129
      • 6: -122.07318515000001
      • 7: 37.98977959999999
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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.02msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889920, 'CA-4 W and CA-4', 108482, 'm', 4633, 0, 'No', 37.8892874, 38.1301968, null, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 889920
      • 1: CA-4 W and CA-4
      • 2: 108482
      • 3: m
      • 4: 4633
      • 5: 0
      • 6: No
      • 7: 37.8892874
      • 8: 38.1301968
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:39
      • 12: 2025-05-18 09:04:39
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518641, 0, 'Get on CA-99 S from S Guild Ave, Auto Center Rd, Pixley Pkwy and E Kettleman Ln', 2867, 'm', 371, -121.25288575, 38.1219453, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518641
      • 1: 0
      • 2: Get on CA-99 S from S Guild Ave, Auto Center Rd, Pixley Pkwy and E Kettleman Ln
      • 3: 2867
      • 4: m
      • 5: 371
      • 6: -121.25288575
      • 7: 38.12194529999999
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518641, 1, 'Continue on CA-99 S to Stockton', 24751, 'm', 868, -121.2830491, 38.0257482, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518641
      • 1: 1
      • 2: Continue on CA-99 S to Stockton
      • 3: 24751
      • 4: m
      • 5: 868
      • 6: -121.2830491
      • 7: 38.0257482
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518641, 2, 'Continue to Contra Costa County', 38252, 'm', 1826, -121.5150381, 37.91343905, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518641
      • 1: 2
      • 2: Continue to Contra Costa County
      • 3: 38252
      • 4: m
      • 5: 1826
      • 6: -121.5150381
      • 7: 37.91343905000001
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518641, 3, 'Follow CA-4 to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4', 41561, 'm', 1439, -121.89353185, 37.96001035, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518641
      • 1: 3
      • 2: Follow CA-4 to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4
      • 3: 41561
      • 4: m
      • 5: 1439
      • 6: -121.89353184999997
      • 7: 37.96001035
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518641, 4, 'Follow Pacheco Blvd to Temple Dr in Pacheco', 1051, 'm', 129, -122.07318515, 37.9897796, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518641
      • 1: 4
      • 2: Follow Pacheco Blvd to Temple Dr in Pacheco
      • 3: 1051
      • 4: m
      • 5: 129
      • 6: -122.07318515000001
      • 7: 37.98977959999999
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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.1msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889920, 'I-680 N', 140388, 'm', 5188, 0, 'No', 37.6996851, 38.1301968, null, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 889920
      • 1: I-680 N
      • 2: 140388
      • 3: m
      • 4: 5188
      • 5: 0
      • 6: No
      • 7: 37.699685099999996
      • 8: 38.1301968
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:39
      • 12: 2025-05-18 09:04:39
      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#548distance770μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518642, 0, 'Get on CA-99 S from S Guild Ave, Auto Center Rd, Pixley Pkwy and E Kettleman Ln', 2867, 'm', 371, -121.25288575, 38.1219453, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518642
      • 1: 0
      • 2: Get on CA-99 S from S Guild Ave, Auto Center Rd, Pixley Pkwy and E Kettleman Ln
      • 3: 2867
      • 4: m
      • 5: 371
      • 6: -121.25288575
      • 7: 38.12194529999999
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518642, 1, 'Continue on CA-99 S. Take I-5 S, I-205 W, I-580 W and I-680 N to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4 W', 136470, 'm', 4688, -121.6592062, 37.9067954, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518642
      • 1: 1
      • 2: Continue on CA-99 S. Take I-5 S, I-205 W, I-580 W and I-680 N to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4 W
      • 3: 136470
      • 4: m
      • 5: 4688
      • 6: -121.65920619999997
      • 7: 37.9067954
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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 (2518642, 2, 'Follow Pacheco Blvd to Temple Dr in Pacheco', 1051, 'm', 129, -122.07318515, 37.9897796, 0, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518642
      • 1: 2
      • 2: Follow Pacheco Blvd to Temple Dr in Pacheco
      • 3: 1051
      • 4: m
      • 5: 129
      • 6: -122.07318515000001
      • 7: 37.98977959999999
      • 8: 0
      • 9: 2025-05-18 09:04:39
      • 10: 2025-05-18 09:04:39
      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#24distance660μsselect * from "route_waypoints" where "route_id" = 2518640
      Bindings
      • 0: 2518640
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#103distance400μsselect * from "origin_destinations" where "origin_destinations"."id" = 889920 limit 1
      Bindings
      • 0: 889920
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#103distance460μsselect * from "places" where "places"."id" = 72737 limit 1
      Bindings
      • 0: 72737
      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#104distance430μsselect * from "places" where "places"."id" = 7216 limit 1
      Bindings
      • 0: 7216
      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#226distance98.47msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.114109666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.33882388889)) + sin(radians(38.114109666667)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance4.26msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 89926 limit 1
      Bindings
      • 0: 89926
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance94.48msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.098022333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.43047877778)) + sin(radians(38.098022333333)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#226distance99.44msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.081935)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.52213366667)) + sin(radians(38.081935)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance820μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 20761 limit 1
      Bindings
      • 0: 20761
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance91.52msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.065847666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.61378855556)) + sin(radians(38.065847666667)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance780μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 12216 limit 1
      Bindings
      • 0: 12216
      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.98msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.049760333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.70544344444)) + sin(radians(38.049760333333)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance700μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 40206 limit 1
      Bindings
      • 0: 40206
      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.07msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.033673)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.79709833333)) + sin(radians(38.033673)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance730μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 56 limit 1
      Bindings
      • 0: 56
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance98.76msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.017585666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.88875322222)) + sin(radians(38.017585666667)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 783 limit 1
      Bindings
      • 0: 783
      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.83msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.001498333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.98040811111)) + sin(radians(38.001498333333)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance620μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 2001 limit 1
      Bindings
      • 0: 2001
      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#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 89926) limit 1
      Bindings
      • 0: 2518640
      • 1: 89926
      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.27msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518640, 89926, 0.11111111111111, 3, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 89926
      • 2: 0.1111111111111111
      • 3: 3
      • 4: 2025-05-18 09:04:39
      • 5: 2025-05-18 09:04:39
      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#78distance580μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 20761) limit 1
      Bindings
      • 0: 2518640
      • 1: 20761
      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 (2518640, 20761, 0.33333333333333, 7, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 20761
      • 2: 0.3333333333333333
      • 3: 7
      • 4: 2025-05-18 09:04:39
      • 5: 2025-05-18 09:04:39
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 12217) limit 1
      Bindings
      • 0: 2518640
      • 1: 12217
      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#78distance710μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518640, 12217, 0.44444444444444, 4, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 12217
      • 2: 0.4444444444444444
      • 3: 4
      • 4: 2025-05-18 09:04:39
      • 5: 2025-05-18 09:04:39
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 40206) limit 1
      Bindings
      • 0: 2518640
      • 1: 40206
      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 (2518640, 40206, 0.55555555555556, 3, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 40206
      • 2: 0.5555555555555556
      • 3: 3
      • 4: 2025-05-18 09:04:39
      • 5: 2025-05-18 09:04:39
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 56) limit 1
      Bindings
      • 0: 2518640
      • 1: 56
      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#78distance710μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518640, 56, 0.66666666666667, 2, '2025-05-18 09:04:39', '2025-05-18 09:04:39') returning "id"
      Bindings
      • 0: 2518640
      • 1: 56
      • 2: 0.6666666666666666
      • 3: 2
      • 4: 2025-05-18 09:04:39
      • 5: 2025-05-18 09:04:39
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 783) limit 1
      Bindings
      • 0: 2518640
      • 1: 783
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance780μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518640, 783, 0.77777777777778, 1, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518640
      • 1: 783
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:40
      • 5: 2025-05-18 09:04:40
      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" = 2518640 and "place_id" = 2001) limit 1
      Bindings
      • 0: 2518640
      • 1: 2001
      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#78distance820μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518640, 2001, 0.88888888888889, 2, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 2518640
      • 1: 2001
      • 2: 0.8888888888888888
      • 3: 2
      • 4: 2025-05-18 09:04:40
      • 5: 2025-05-18 09:04:40
      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#366distance520μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518640 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518640
      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#45distance440μsselect * from "denormalised_routes" where "origin_destination_id" = 889920 limit 1
      Bindings
      • 0: 889920
      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" = 2518640 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518640
      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#198distance400μsselect * from "locations" where "locations"."id" = 72737 limit 1
      Bindings
      • 0: 72737
      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#198distance500μsselect * from "cities" where "cities"."id" = 600 limit 1
      Bindings
      • 0: 600
      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#215distance320μsselect * from "states" where "states"."id" = 3 limit 1
      Bindings
      • 0: 3
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:154
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance340μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:155
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance340μsselect * from "locations" where "locations"."id" = 7216 limit 1
      Bindings
      • 0: 7216
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:167
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance350μsselect * from "cities" where "cities"."id" = 5554 limit 1
      Bindings
      • 0: 5554
      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" = 3 limit 1
      Bindings
      • 0: 3
      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#330distance300μ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.94msinsert 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 (72737, 'Pearson', 'Pearson, Lodi, CA 95240', 'pearson', '4zr8mffe', 38.130197, -121.247169, 'Lodi', 'California', 'US', 'America/Los_Angeles', 7216, 'Pacheco', 'Pacheco, CA', 'pacheco', 'yezad7yh', 37.985411, -122.072063, 'Pacheco', 'California', 'US', 'America/Los_Angeles', 2518640, 'CA-12 and CA-4 W', 92400, 'm', 4185, 57.4146804, 92400, '1 hour 9 minutes', '1 hour 9 minutes', 92.4, '92.4 km', null, 70, 0, 'No', '57.4 mi', 45.978271302642, 0.045978271302642, '"[{\"id\":8350556,\"route_id\":2518640,\"step_index\":\"0\",\"instruction\":\"Take E Lodi Ave and N Davis Rd to CA-12\",\"distance\":10105,\"distance_unit\":\"m\",\"time\":\"884\",\"latitude\":-121.290724,\"longitude\":38.1232992,\"is_sub_step\":false},{\"id\":8350557,\"route_id\":2518640,\"step_index\":\"1\",\"instruction\":\"Follow CA-12, CA-160 S and CA-4 W to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4 W\",\"distance\":81244,\"distance_unit\":\"m\",\"time\":\"3172\",\"latitude\":-121.7046938,\"longitude\":38.0732242,\"is_sub_step\":false},{\"id\":8350558,\"route_id\":2518640,\"step_index\":\"2\",\"instruction\":\"Follow Pacheco Blvd to Temple Dr in Pacheco\",\"distance\":1051,\"distance_unit\":\"m\",\"time\":\"129\",\"latitude\":-122.0731852,\"longitude\":37.9897796,\"is_sub_step\":false}]"', 92400, 92400, '17 minutes', 0, 'west', 'east', '[{"name":"Villinger","description":"66 mi to destination","state":"California","country":"US","full_address":"Villinger, CA 95242","lat":"38.144085","lng":"-121.373561","fraction":0.1111111111111111,"type":"State","distance_km":3,"place_id":89926,"slug":"villinger","hash":"2falukq8"},{"name":"Isleton","description":"49 mi to destination","state":"California","country":"US","full_address":"Isleton, CA 95641","lat":"38.161805","lng":"-121.611543","fraction":0.3333333333333333,"type":"City","distance_km":7,"place_id":20761,"slug":"isleton","hash":"dhlcuwp7"},{"name":"Bethel Island","description":"Traveled 33 mi from origin","state":"California","country":"US","full_address":"Bethel Island, CA","lat":"38.014922","lng":"-121.640509","fraction":0.4444444444444444,"type":"City","distance_km":4,"place_id":12217,"slug":"bethel-island","hash":"cd5yz5t9"},{"name":"Emmaton","description":"33 mi to destination","state":"California","country":"US","full_address":"Emmaton, CA 94571","lat":"38.080197","lng":"-121.732177","fraction":0.5555555555555556,"type":"City","distance_km":3,"place_id":40206,"slug":"emmaton","hash":"u8bpc7zf"},{"name":"Antioch","description":"Traveled 49 mi from origin","state":"California","country":"US","full_address":"Antioch, CA","lat":"38.004921","lng":"-121.805789","fraction":0.6666666666666666,"type":"City","distance_km":2,"place_id":56,"slug":"antioch","hash":"6xa3hvr3"},{"name":"Pittsburg","description":"16 mi to destination","state":"California","country":"US","full_address":"Pittsburg, CA","lat":"38.027976","lng":"-121.884681","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":783,"slug":"pittsburg","hash":"ikknjuxj"},{"name":"Bay Point","description":"Traveled 66 mi from origin","state":"California","country":"US","full_address":"Bay Point, CA","lat":"38.029087","lng":"-121.961627","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":2001,"slug":"bay-point","hash":"uz1fezb6"}]', 1, 7, '{"distanceInMiles":57.41484086644215,"distanceMilesFormatted":"57.4 miles","distanceFormatted":"57.4 miles","distanceKmFormatted":"92 km","timeHours":1.15,"timeFormatted":"1 hour 9 minutes","avgSpeed":47,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"west"}', null, 'pearson-4zr8mffe/pacheco-yezad7yh', 0, null, null, 0, '"[{\"name\":\"Villinger\",\"description\":\"66 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Villinger, CA 95242\",\"lat\":\"38.144085\",\"lng\":\"-121.373561\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":3,\"place_id\":89926,\"slug\":\"villinger\",\"hash\":\"2falukq8\"},{\"name\":\"Isleton\",\"description\":\"49 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Isleton, CA 95641\",\"lat\":\"38.161805\",\"lng\":\"-121.611543\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":7,\"place_id\":20761,\"slug\":\"isleton\",\"hash\":\"dhlcuwp7\"},{\"name\":\"Bethel Island\",\"description\":\"Traveled 33 mi from origin\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Bethel Island, CA\",\"lat\":\"38.014922\",\"lng\":\"-121.640509\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":4,\"place_id\":12217,\"slug\":\"bethel-island\",\"hash\":\"cd5yz5t9\"},{\"name\":\"Emmaton\",\"description\":\"33 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Emmaton, CA 94571\",\"lat\":\"38.080197\",\"lng\":\"-121.732177\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":3,\"place_id\":40206,\"slug\":\"emmaton\",\"hash\":\"u8bpc7zf\"},{\"name\":\"Antioch\",\"description\":\"Traveled 49 mi from origin\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Antioch, CA\",\"lat\":\"38.004921\",\"lng\":\"-121.805789\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":2,\"place_id\":56,\"slug\":\"antioch\",\"hash\":\"6xa3hvr3\"},{\"name\":\"Pittsburg\",\"description\":\"16 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Pittsburg, CA\",\"lat\":\"38.027976\",\"lng\":\"-121.884681\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":783,\"slug\":\"pittsburg\",\"hash\":\"ikknjuxj\"},{\"name\":\"Bay Point\",\"description\":\"Traveled 66 mi from origin\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Bay Point, CA\",\"lat\":\"38.029087\",\"lng\":\"-121.961627\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":2001,\"slug\":\"bay-point\",\"hash\":\"uz1fezb6\"}]"', 3, 889920, '2025-05-18 09:04:40', '2025-05-18 09:04:40') returning "id"
      Bindings
      • 0: 72737
      • 1: Pearson
      • 2: Pearson, Lodi, CA 95240
      • 3: pearson
      • 4: 4zr8mffe
      • 5: 38.130197
      • 6: -121.247169
      • 7: Lodi
      • 8: California
      • 9: US
      • 10: America/Los_Angeles
      • 11: 7216
      • 12: Pacheco
      • 13: Pacheco, CA
      • 14: pacheco
      • 15: yezad7yh
      • 16: 37.985411
      • 17: -122.072063
      • 18: Pacheco
      • 19: California
      • 20: US
      • 21: America/Los_Angeles
      • 22: 2518640
      • 23: CA-12 and CA-4 W
      • 24: 92400
      • 25: m
      • 26: 4185
      • 27: 57.4146804
      • 28: 92400
      • 29: 1 hour 9 minutes
      • 30: 1 hour 9 minutes
      • 31: 92.4
      • 32: 92.4 km
      • 33: 
      • 34: 70
      • 35: 0
      • 36: No
      • 37: 57.4 mi
      • 38: 45.978271302641936
      • 39: 0.04597827130264193
      • 40: "[{\"id\":8350556,\"route_id\":2518640,\"step_index\":\"0\",\"instruction\":\"Take E Lodi Ave and N Davis Rd to CA-12\",\"distance\":10105,\"distance_unit\":\"m\",\"time\":\"884\",\"latitude\":-121.290724,\"longitude\":38.1232992,\"is_sub_step\":false},{\"id\":8350557,\"route_id\":2518640,\"step_index\":\"1\",\"instruction\":\"Follow CA-12, CA-160 S and CA-4 W to Pacheco Blvd in Vine Hill. Take exit 12A from CA-4 W\",\"distance\":81244,\"distance_unit\":\"m\",\"time\":\"3172\",\"latitude\":-121.7046938,\"longitude\":38.0732242,\"is_sub_step\":false},{\"id\":8350558,\"route_id\":2518640,\"step_index\":\"2\",\"instruction\":\"Follow Pacheco Blvd to Temple Dr in Pacheco\",\"distance\":1051,\"distance_unit\":\"m\",\"time\":\"129\",\"latitude\":-122.0731852,\"longitude\":37.9897796,\"is_sub_step\":false}]"
      • 41: 92400
      • 42: 92400
      • 43: 17 minutes
      • 44: 0
      • 45: west
      • 46: east
      • 47: [{"name":"Villinger","description":"66 mi to destination","state":"California","country":"US","full_address":"Villinger, CA 95242","lat":"38.144085","lng":"-121.373561","fraction":0.1111111111111111,"type":"State","distance_km":3,"place_id":89926,"slug":"villinger","hash":"2falukq8"},{"name":"Isleton","description":"49 mi to destination","state":"California","country":"US","full_address":"Isleton, CA 95641","lat":"38.161805","lng":"-121.611543","fraction":0.3333333333333333,"type":"City","distance_km":7,"place_id":20761,"slug":"isleton","hash":"dhlcuwp7"},{"name":"Bethel Island","description":"Traveled 33 mi from origin","state":"California","country":"US","full_address":"Bethel Island, CA","lat":"38.014922","lng":"-121.640509","fraction":0.4444444444444444,"type":"City","distance_km":4,"place_id":12217,"slug":"bethel-island","hash":"cd5yz5t9"},{"name":"Emmaton","description":"33 mi to destination","state":"California","country":"US","full_address":"Emmaton, CA 94571","lat":"38.080197","lng":"-121.732177","fraction":0.5555555555555556,"type":"City","distance_km":3,"place_id":40206,"slug":"emmaton","hash":"u8bpc7zf"},{"name":"Antioch","description":"Traveled 49 mi from origin","state":"California","country":"US","full_address":"Antioch, CA","lat":"38.004921","lng":"-121.805789","fraction":0.6666666666666666,"type":"City","distance_km":2,"place_id":56,"slug":"antioch","hash":"6xa3hvr3"},{"name":"Pittsburg","description":"16 mi to destination","state":"California","country":"US","full_address":"Pittsburg, CA","lat":"38.027976","lng":"-121.884681","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":783,"slug":"pittsburg","hash":"ikknjuxj"},{"name":"Bay Point","description":"Traveled 66 mi from origin","state":"California","country":"US","full_address":"Bay Point, CA","lat":"38.029087","lng":"-121.961627","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":2001,"slug":"bay-point","hash":"uz1fezb6"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":57.41484086644215,"distanceMilesFormatted":"57.4 miles","distanceFormatted":"57.4 miles","distanceKmFormatted":"92 km","timeHours":1.15,"timeFormatted":"1 hour 9 minutes","avgSpeed":47,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"west"}
      • 51: 
      • 52: pearson-4zr8mffe/pacheco-yezad7yh
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Villinger\",\"description\":\"66 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Villinger, CA 95242\",\"lat\":\"38.144085\",\"lng\":\"-121.373561\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":3,\"place_id\":89926,\"slug\":\"villinger\",\"hash\":\"2falukq8\"},{\"name\":\"Isleton\",\"description\":\"49 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Isleton, CA 95641\",\"lat\":\"38.161805\",\"lng\":\"-121.611543\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":7,\"place_id\":20761,\"slug\":\"isleton\",\"hash\":\"dhlcuwp7\"},{\"name\":\"Bethel Island\",\"description\":\"Traveled 33 mi from origin\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Bethel Island, CA\",\"lat\":\"38.014922\",\"lng\":\"-121.640509\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":4,\"place_id\":12217,\"slug\":\"bethel-island\",\"hash\":\"cd5yz5t9\"},{\"name\":\"Emmaton\",\"description\":\"33 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Emmaton, CA 94571\",\"lat\":\"38.080197\",\"lng\":\"-121.732177\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":3,\"place_id\":40206,\"slug\":\"emmaton\",\"hash\":\"u8bpc7zf\"},{\"name\":\"Antioch\",\"description\":\"Traveled 49 mi from origin\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Antioch, CA\",\"lat\":\"38.004921\",\"lng\":\"-121.805789\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":2,\"place_id\":56,\"slug\":\"antioch\",\"hash\":\"6xa3hvr3\"},{\"name\":\"Pittsburg\",\"description\":\"16 mi to destination\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Pittsburg, CA\",\"lat\":\"38.027976\",\"lng\":\"-121.884681\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":783,\"slug\":\"pittsburg\",\"hash\":\"ikknjuxj\"},{\"name\":\"Bay Point\",\"description\":\"Traveled 66 mi from origin\",\"state\":\"California\",\"country\":\"US\",\"full_address\":\"Bay Point, CA\",\"lat\":\"38.029087\",\"lng\":\"-121.961627\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":2001,\"slug\":\"bay-point\",\"hash\":\"uz1fezb6\"}]"
      • 58: 3
      • 59: 889920
      • 60: 2025-05-18 09:04:40
      • 61: 2025-05-18 09:04:40
      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#70distance440μsselect exists(select "id" from "routes" where "origin_destination_id" = 889920 limit 1) as "exists"
      Bindings
      • 0: 889920
      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#1186distance500μsselect * from "routes" where "routes"."origin_destination_id" = 889920 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889920
      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#1186distance420μsselect * from "route_directions" where "route_directions"."route_id" in (2518640, 2518641, 2518642) 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#225distance800μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:40' where "id" = 2518640
      Bindings
      • 0: 2025-05-18 09:04:40
      • 1: 2518640
      Backtrace
      • app/Models/Route.php:225
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#235distance340μsselect * from "origin_destinations" where "origin_destinations"."id" = 889920 limit 1
      Bindings
      • 0: 889920
      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#244distance380μsselect * from "places" where "places"."id" = 72737 limit 1
      Bindings
      • 0: 72737
      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" = 7216 limit 1
      Bindings
      • 0: 7216
      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#24distance300μsselect * from "route_waypoints" where "route_id" = 2518640
      Bindings
      • 0: 2518640
      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#103distance330μsselect * from "places" where "places"."id" = 72737 limit 1
      Bindings
      • 0: 72737
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#104distance340μsselect * from "places" where "places"."id" = 7216 limit 1
      Bindings
      • 0: 7216
      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#226distance81.17msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.114109666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.33882388889)) + sin(radians(38.114109666667)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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" = 89926 limit 1
      Bindings
      • 0: 89926
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance86.18msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.098022333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.43047877778)) + sin(radians(38.098022333333)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#226distance87.32msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.081935)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.52213366667)) + sin(radians(38.081935)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 20761 limit 1
      Bindings
      • 0: 20761
      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#226distance84.12msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.065847666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.61378855556)) + sin(radians(38.065847666667)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance530μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 12216 limit 1
      Bindings
      • 0: 12216
      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.82msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.049760333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.70544344444)) + sin(radians(38.049760333333)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance850μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 40206 limit 1
      Bindings
      • 0: 40206
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance86.81msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.033673)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.79709833333)) + sin(radians(38.033673)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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#158distance750μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 56 limit 1
      Bindings
      • 0: 56
      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#226distance99.79msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.017585666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.88875322222)) + sin(radians(38.017585666667)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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" = 783 limit 1
      Bindings
      • 0: 783
      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#226distance98.57msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.001498333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.98040811111)) + sin(radians(38.001498333333)) * 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" != 72737 and "places"."id" != 7216 order by "distance" asc limit 1
      Bindings
      • 0: 72737
      • 1: 7216
      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" = 2001 limit 1
      Bindings
      • 0: 2001
      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#78distance340μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 89926) limit 1
      Bindings
      • 0: 2518640
      • 1: 89926
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance1msupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:40' where "id" = 6300341
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:40
      • 2: 6300341
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance340μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 20761) limit 1
      Bindings
      • 0: 2518640
      • 1: 20761
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance620μsupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:40' where "id" = 6300342
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:40
      • 2: 6300342
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518640 and "place_id" = 12217) limit 1
      Bindings
      • 0: 2518640
      • 1: 12217
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance610μsupdate "route_waypoints" set "fraction" = 0.44444444444444, "updated_at" = '2025-05-18 09:04:40' where "id" = 6300343
      Bindings
      • 0: 0.4444444444444444
      • 1: 2025-05-18 09:04:40
      • 2: 6300343
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance600μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance630μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance270μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance260μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance670μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance490μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance330μsselect * from "route_waypoints" where "route_id" = ?
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance300μsselect * from "places" where "places"."id" = ? limit 1
    • distance85.16msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.114109666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.33882388889)) + sin(radians(38.114109666667)) * 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
    • distance86.81msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.098022333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.43047877778)) + sin(radians(38.098022333333)) * 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
    • distance90.63msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.081935)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.52213366667)) + sin(radians(38.081935)) * 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
    • distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance84.86msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.065847666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.61378855556)) + sin(radians(38.065847666667)) * 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
    • distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance89.76msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.049760333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.70544344444)) + sin(radians(38.049760333333)) * 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
    • distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance90.07msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.033673)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.79709833333)) + sin(radians(38.033673)) * 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
    • distance84.59msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.017585666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.88875322222)) + sin(radians(38.017585666667)) * 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
    • distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance86.87msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.001498333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-121.98040811111)) + sin(radians(38.001498333333)) * 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
    • distance350μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance830μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance610μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μ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
    • distance660μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance750μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance600μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance350μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance310μsselect * from "states" where "states"."id" = ? limit 1
    • distance290μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance260μsselect * from "states" where "states"."id" = ? limit 1
    • distance460μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance350μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance740μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.95msselect * from "images" where "images"."place_id" in (72737)
    • distance670μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.01msselect * from "images" where "images"."place_id" in (7216)
    • distance550μsselect * from "routes" where "origin_destination_id" = ?
    • distance570μ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"
    • distance430μsselect * from "route_directions" where "route_directions"."route_id" in (2518640, 2518641, 2518642) order by "step_index" asc, "step_index" asc
    • distance460μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance350μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance470μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance610μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance520μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance360μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance500μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    35RouteWaypoint.php#?
    App\Models\RouteDirection
    25RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
    App\Models\Image
    1Image.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:41GET/distance/pearson-4zr8mffe/pacheco-yezad7yh44216299