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

Just a moment while we calculate your route...

Distance from Lyons Switch to Old Eucha

Driving Distance
63 mi • 101.4 km
Flying Distance
41.8 mi • 67.2 km
A
B
Leaflet © OpenStreetMap contributors
45 mph avg speed
Northwest direction
1 hr 16 min travel time

Route Information

The driving distance from Lyons Switch, Oklahoma to Old Eucha, Oklahoma is 63 mi (101.4 km)

The straight-line (air) distance is 41.8 mi (67.2 km)

The estimated flight time is 0 hr 5 min

The estimated travel time by road is 1 hour 16 minutes

Traveling mixed highways and local roads, substantial in a northwest direction. Average speeds around 45 mph.

Location Details

Origin:


No image available
Place Lyons Switch
State/Province Oklahoma
Country US
Latitude 35.77491
Longitude -94.691548
GPS 35.77491° N, 94.691548° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Old Eucha
State/Province Oklahoma
Country US
Latitude 36.344808
Longitude -94.945234
GPS 36.344808° N, 94.945234° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Lyons Switch, Oklahoma to Old Eucha, Oklahoma covers 63 mi (101.4 km) in a northwest direction. This mixed highways and local roads, substantial route typically takes 1 hour 16 minutes under normal conditions.

Drivers have 3 route options between these locations (62.8-67.9 miles / 101-109 km).

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

Available Routes

US-59 N/S Hwy 59
63 mi 1 hour 16 minutes
Shortest Fastest
US-59 N/S Hwy 59 and US-59 N
67.9 mi 1 hour 17 minutes
Tolls
OK-82A
62.8 mi 1 hour 20 minutes

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

Lyons Switch
Oklahoma , US
Stony Point
Oklahoma, US
5.1 mi
Titanic
Oklahoma, US
9.8 mi
Proctor
Oklahoma, US
14.1 mi
Chewey
Oklahoma, US
23.1 mi
Oaks
Oklahoma, US
28.5 mi
Leach
Oklahoma, US
32.4 mi
Bull Hollow
Oklahoma, US
39.1 mi
Old Eucha
Oklahoma , US
Messages49RequestTimelineExceptionsViews2Queries164Models106MailsGate
SettingsRequest history3.28sRequest 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/lyons-switch-jehry2o2/old-eucha-qb6l83k5
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:48] LOG.warning: No denormalized route found for origin-destination ID: 889937
  • infolog[09:04:48] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 20...
  • infolog[09:04:48] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:49] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:49] LOG.info: Processing route #1 data for origin-destination ID: 889937 { "origin": "Lyo...
  • infolog[09:04:49] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 4 nested sub-directions for direction index 1
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 7 nested sub-directions for direction index 2
  • infolog[09:04:49] LOG.info: Saved 3 directions for route ID: 2518682
  • infolog[09:04:49] LOG.info: Found a shorter route: 101406 meters for route ID: 2518682
  • infolog[09:04:49] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:49] LOG.info: Processing route #2 data for origin-destination ID: 889937 { "origin": "Lyo...
  • infolog[09:04:49] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 3 nested sub-directions for direction index 0
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 7 nested sub-directions for direction index 1
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 4 nested sub-directions for direction index 2
  • infolog[09:04:49] LOG.info: Saved 3 directions for route ID: 2518683
  • infolog[09:04:49] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:49] LOG.info: Processing route #3 data for origin-destination ID: 889937 { "origin": "Lyo...
  • infolog[09:04:49] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 2 nested sub-directions for direction index 0
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 6 nested sub-directions for direction index 1
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 2 nested sub-directions for direction index 3
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 3 nested sub-directions for direction index 4
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 2 nested sub-directions for direction index 5
  • debuglog[09:04:49] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:49] LOG.info: Ignoring 1 nested sub-directions for direction index 6
  • infolog[09:04:49] LOG.info: Saved 7 directions for route ID: 2518684
  • infolog[09:04:49] LOG.info: Found a shorter route: 101128 meters for route ID: 2518684
  • infolog[09:04:49] LOG.info: Successfully denormalized route data { "origin_destination_id": 889937, ...
  • infolog[09:04:49] LOG.info: Saved 3 routes for origin-destination ID: 889937
  • infolog[09:04:49] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518684, ...
  • infolog[09:04:49] LOG.info: Incremented view count for route { "id": 2518684, "name": "OK-82A", ...
  • infolog[09:04:50] LOG.info: Updated denormalized route for route { "route_id": 2518684, "views": 1 ...
  • infolog[09:04:50] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518684, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/lyons-switch-jehry2o2/old-eucha-qb6l83k5
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
3.29s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a3064ed5bc985-IAD"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:51 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "rZ3EHcPI66HKKOLL8INbsV1ZT58DdxxjkUTfvUvW"
]
  • Booting (9.98ms)time
  • Application (3.27s)time
  • Routing (462μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (39μs)
  • 1 x Application (99.7%)
    3.27s
    1 x Booting (0.3%)
    9.98ms
    1 x Routing (0.01%)
    462μs
    1 x Preparing Response (0%)
    39μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    164 statements were executed (101 duplicates)Show only duplicatesdistance2.55s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 64 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance16.34msselect * from "sessions" where "id" = 'Pg0ssBVZZj9Drahml0cZ9NX5vAdJhpdvaaQ73UsH' limit 1
      Bindings
      • 0: Pg0ssBVZZj9Drahml0cZ9NX5vAdJhpdvaaQ73UsH
      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#548distance16.57msselect * from "places" where "slug" = 'lyons-switch' and ("hash" = 'jehry2o2') limit 1
      Bindings
      • 0: lyons-switch
      • 1: jehry2o2
      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" = 'old-eucha' and ("hash" = 'qb6l83k5') limit 1
      Bindings
      • 0: old-eucha
      • 1: qb6l83k5
      Backtrace
      • app/Http/Controllers/RouteController.php:548
      • app/Http/Controllers/RouteController.php:60
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • RouteController.php#104distance1.24msselect * from "origin_destinations" where ("origin_id" = 20159 and "destination_id" = 31384) limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#104distance3.55msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (20159, 31384, '2025-05-18 09:04:48', '2025-05-18 09:04:48') returning "id"
      Bindings
      • 0: 20159
      • 1: 31384
      • 2: 2025-05-18 09:04:48
      • 3: 2025-05-18 09:04:48
      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.69msselect * from "denormalised_routes" where "origin_destination_id" = 889937 limit 1
      Bindings
      • 0: 889937
      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#70distance1.01msselect exists(select "id" from "routes" where "origin_destination_id" = 889937 limit 1) as "exists"
      Bindings
      • 0: 889937
      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#158distance2.19msdelete from "routes" where "origin_destination_id" = 889937
      Bindings
      • 0: 889937
      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#172distance710μsselect * from "places" where "places"."id" = 20159 limit 1
      Bindings
      • 0: 20159
      Backtrace
      • app/Services/DistanceCalculationService.php:172
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#173distance1.7msselect * from "places" where "places"."id" = 31384 limit 1
      Bindings
      • 0: 31384
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance2.26msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889937, 'US-59 N/S Hwy 59', 101406, 'm', 4603, 0, 'No', 35.7749095, 36.3448076, null, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 889937
      • 1: US-59 N/S Hwy 59
      • 2: 101406
      • 3: m
      • 4: 4603
      • 5: 0
      • 6: No
      • 7: 35.7749095
      • 8: 36.344807599999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:49
      • 12: 2025-05-18 09:04:49
      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.64msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518682, 0, 'Take E 850 Rd and E 844 Rd/E844 Rd to US-59 N/S Hwy 59 in Stilwell', 7765, 'm', 525, -94.6604901, 35.7898443, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518682
      • 1: 0
      • 2: Take E 850 Rd and E 844 Rd/E844 Rd to US-59 N/S Hwy 59 in Stilwell
      • 3: 7765
      • 4: m
      • 5: 525
      • 6: -94.66049009999999
      • 7: 35.7898443
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance940μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518682, 1, 'Follow US-59 N to Tulsa Ave in Kansas', 66006, 'm', 2717, -94.6721444, 36.00517925, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518682
      • 1: 1
      • 2: Follow US-59 N to Tulsa Ave in Kansas
      • 3: 66006
      • 4: m
      • 5: 2717
      • 6: -94.6721444
      • 7: 36.00517925
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance850μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518682, 2, 'Take County Rd 586, County Rd 487 and County Rd 470 to County Rd 530', 27635, 'm', 1361, -94.86282555, 36.2746715, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518682
      • 1: 2
      • 2: Take County Rd 586, County Rd 487 and County Rd 470 to County Rd 530
      • 3: 27635
      • 4: m
      • 5: 1361
      • 6: -94.86282555
      • 7: 36.2746715
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#225distance930μsinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889937, 'US-59 N/S Hwy 59 and US-59 N', 109268, 'm', 4671, 1, 'This route has tolls.', 35.7749095, 36.3448076, null, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 889937
      • 1: US-59 N/S Hwy 59 and US-59 N
      • 2: 109268
      • 3: m
      • 4: 4671
      • 5: 1
      • 6: This route has tolls.
      • 7: 35.7749095
      • 8: 36.344807599999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:49
      • 12: 2025-05-18 09:04:49
      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#548distance950μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518683, 0, 'Take OK-100 E to US-59 N/S Hwy 59 in Stilwell', 8927, 'm', 568, -94.65949795, 35.7922178, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518683
      • 1: 0
      • 2: Take OK-100 E to US-59 N/S Hwy 59 in Stilwell
      • 3: 8927
      • 4: m
      • 5: 568
      • 6: -94.65949794999999
      • 7: 35.792217799999996
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.14msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518683, 1, 'Follow US-59 N and OK-10 N to W 47 Rd in Delaware County', 83396, 'm', 3284, -94.6870592, 36.0766006, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518683
      • 1: 1
      • 2: Follow US-59 N and OK-10 N to W 47 Rd in Delaware County
      • 3: 83396
      • 4: m
      • 5: 3284
      • 6: -94.6870592
      • 7: 36.0766006
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.08msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518683, 2, 'Follow W 47 Rd, County Rd 487 and County Rd 470 to County Rd 530', 16945, 'm', 819, -94.87774035, 36.32675815, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518683
      • 1: 2
      • 2: Follow W 47 Rd, County Rd 487 and County Rd 470 to County Rd 530
      • 3: 16945
      • 4: m
      • 5: 819
      • 6: -94.87774034999998
      • 7: 36.326758149999996
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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.2msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889937, 'OK-82A', 101128, 'm', 4835, 0, 'No', 35.7749095, 36.3448076, null, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 889937
      • 1: OK-82A
      • 2: 101128
      • 3: m
      • 4: 4835
      • 5: 0
      • 6: No
      • 7: 35.7749095
      • 8: 36.344807599999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:49
      • 12: 2025-05-18 09:04:49
      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#548distance800μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 0, 'Take S 4690 Rd/N4690 Rd to OK-100 E', 5430, 'm', 330, -94.67877825, 35.79176135, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 0
      • 2: Take S 4690 Rd/N4690 Rd to OK-100 E
      • 3: 5430
      • 4: m
      • 5: 330
      • 6: -94.67877825
      • 7: 35.791761349999994
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance840μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 1, 'Take OK-51 W and US-62 W to N 4514 Rd/OK-82A in Grandview', 45263, 'm', 2070, -94.80771435, 35.89722705, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 1
      • 2: Take OK-51 W and US-62 W to N 4514 Rd/OK-82A in Grandview
      • 3: 45263
      • 4: m
      • 5: 2070
      • 6: -94.80771435
      • 7: 35.89722705
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.78msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 2, 'Continue to Johnson Prairie', 10441, 'm', 548, -94.9625203, 36.0307568, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 2
      • 2: Continue to Johnson Prairie
      • 3: 10441
      • 4: m
      • 5: 548
      • 6: -94.9625203
      • 7: 36.0307568
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance2.71msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 3, 'Follow OK-82A to N 549 Rd/N 556 Rd/New Talaquah in Rocky Ford', 12122, 'm', 617, -94.9324995, 36.1089742, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 3
      • 2: Follow OK-82A to N 549 Rd/N 556 Rd/New Talaquah in Rocky Ford
      • 3: 12122
      • 4: m
      • 5: 617
      • 6: -94.93249949999999
      • 7: 36.108974200000006
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance900μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 4, 'Take N4540 Rd to County Rd 504 in Delaware County', 11980, 'm', 540, -94.91779665, 36.19300975, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 4
      • 2: Take N4540 Rd to County Rd 504 in Delaware County
      • 3: 11980
      • 4: m
      • 5: 540
      • 6: -94.91779665
      • 7: 36.19300975
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#548distance940μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 5, 'Follow County Rd 504 to County Rd 530/D0480 Rd in Kenwood', 11056, 'm', 502, -94.95413405, 36.27979855, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 5
      • 2: Follow County Rd 504 to County Rd 530/D0480 Rd in Kenwood
      • 3: 11056
      • 4: m
      • 5: 502
      • 6: -94.95413405
      • 7: 36.279798549999995
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance890μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518684, 6, '', 4836, 'm', 228, -94.9569053, 36.3305299, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 6
      • 2: 
      • 3: 4836
      • 4: m
      • 5: 228
      • 6: -94.95690529999999
      • 7: 36.330529899999995
      • 8: 0
      • 9: 2025-05-18 09:04:49
      • 10: 2025-05-18 09:04:49
      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#24distance880μsselect * from "route_waypoints" where "route_id" = 2518684
      Bindings
      • 0: 2518684
      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#103distance450μsselect * from "origin_destinations" where "origin_destinations"."id" = 889937 limit 1
      Bindings
      • 0: 889937
      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#103distance820μsselect * from "places" where "places"."id" = 20159 limit 1
      Bindings
      • 0: 20159
      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#104distance510μsselect * from "places" where "places"."id" = 31384 limit 1
      Bindings
      • 0: 31384
      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#226distance94.95msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.838232)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.719735333333)) + sin(radians(35.838232)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance1.04msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 36005 limit 1
      Bindings
      • 0: 36005
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance92.44msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.901554)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.747922666667)) + sin(radians(35.901554)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 22664 limit 1
      Bindings
      • 0: 22664
      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#226distance99.33msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.964876)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.77611)) + sin(radians(35.964876)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance1.01msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 26584 limit 1
      Bindings
      • 0: 26584
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.52msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.028198)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.804297333333)) + sin(radians(36.028198)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#226distance89.76msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.09152)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.832484666667)) + sin(radians(36.09152)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 23311 limit 1
      Bindings
      • 0: 23311
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance95.8msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.154842)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.860672)) + sin(radians(36.154842)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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.91msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 24643 limit 1
      Bindings
      • 0: 24643
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance95.24msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.218164)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.888859333333)) + sin(radians(36.218164)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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" = 24810 limit 1
      Bindings
      • 0: 24810
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.39msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.281486)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.917046666667)) + sin(radians(36.281486)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 28160 limit 1
      Bindings
      • 0: 28160
      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#78distance2.5msselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 36005) limit 1
      Bindings
      • 0: 2518684
      • 1: 36005
      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.54msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518684, 36005, 0.11111111111111, 1, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 36005
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance390μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 22664) limit 1
      Bindings
      • 0: 2518684
      • 1: 22664
      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#78distance5.83msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518684, 22664, 0.22222222222222, 1, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 22664
      • 2: 0.2222222222222222
      • 3: 1
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 26584) limit 1
      Bindings
      • 0: 2518684
      • 1: 26584
      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.01msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518684, 26584, 0.33333333333333, 0, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 26584
      • 2: 0.3333333333333333
      • 3: 0
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      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" = 2518684 and "place_id" = 23311) limit 1
      Bindings
      • 0: 2518684
      • 1: 23311
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance970μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518684, 23311, 0.55555555555556, 4, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 23311
      • 2: 0.5555555555555556
      • 3: 4
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      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#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 24643) limit 1
      Bindings
      • 0: 2518684
      • 1: 24643
      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 (2518684, 24643, 0.66666666666667, 1, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 24643
      • 2: 0.6666666666666666
      • 3: 1
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      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#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 24810) limit 1
      Bindings
      • 0: 2518684
      • 1: 24810
      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#78distance900μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518684, 24810, 0.77777777777778, 2, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 24810
      • 2: 0.7777777777777778
      • 3: 2
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 28160) limit 1
      Bindings
      • 0: 2518684
      • 1: 28160
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance860μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518684, 28160, 0.88888888888889, 2, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 2518684
      • 1: 28160
      • 2: 0.8888888888888888
      • 3: 2
      • 4: 2025-05-18 09:04:49
      • 5: 2025-05-18 09:04:49
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#366distance600μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518684 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518684
      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" = 889937 limit 1
      Bindings
      • 0: 889937
      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" = 2518684 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518684
      Backtrace
      • app/Services/RouteDenormalisationService.php:123
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • Place.php#198distance440μsselect * from "locations" where "locations"."id" = 20160 limit 1
      Bindings
      • 0: 20160
      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#198distance540μsselect * from "cities" where "cities"."id" = 13459 limit 1
      Bindings
      • 0: 13459
      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#215distance350μsselect * from "states" where "states"."id" = 31 limit 1
      Bindings
      • 0: 31
      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" = 31383 limit 1
      Bindings
      • 0: 31383
      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#198distance290μsselect * from "cities" where "cities"."id" = 19544 limit 1
      Bindings
      • 0: 19544
      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#215distance290μsselect * from "states" where "states"."id" = 31 limit 1
      Bindings
      • 0: 31
      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#330distance290μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance2.22msinsert 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 (20159, 'Lyons Switch', 'Lyons Switch, OK', 'lyons-switch', 'jehry2o2', 35.77491, -94.691548, 'Lyons Switch', 'Oklahoma', 'US', 'America/Chicago', 31384, 'Old Eucha', 'Old Eucha, OK', 'old-eucha', 'qb6l83k5', 36.344808, -94.945234, 'Old Eucha', 'Oklahoma', 'US', 'America/Chicago', 2518684, 'OK-82A', 101128, 'm', 4835, 62.838006488, 101128, '1 hour 20 minutes', '1 hour 20 minutes', 101.128, '101.1 km', null, 81, 0, 'No', '62.8 mi', 41.848004522478, 0.041848004522478, '"[{\"id\":8350700,\"route_id\":2518684,\"step_index\":\"0\",\"instruction\":\"Take S 4690 Rd\\\/N4690 Rd to OK-100 E\",\"distance\":5430,\"distance_unit\":\"m\",\"time\":\"330\",\"latitude\":-94.6787783,\"longitude\":35.7917614,\"is_sub_step\":false},{\"id\":8350701,\"route_id\":2518684,\"step_index\":\"1\",\"instruction\":\"Take OK-51 W and US-62 W to N 4514 Rd\\\/OK-82A in Grandview\",\"distance\":45263,\"distance_unit\":\"m\",\"time\":\"2070\",\"latitude\":-94.8077144,\"longitude\":35.8972271,\"is_sub_step\":false},{\"id\":8350702,\"route_id\":2518684,\"step_index\":\"2\",\"instruction\":\"Continue to Johnson Prairie\",\"distance\":10441,\"distance_unit\":\"m\",\"time\":\"548\",\"latitude\":-94.9625203,\"longitude\":36.0307568,\"is_sub_step\":false},{\"id\":8350703,\"route_id\":2518684,\"step_index\":\"3\",\"instruction\":\"Follow OK-82A to N 549 Rd\\\/N 556 Rd\\\/New Talaquah in Rocky Ford\",\"distance\":12122,\"distance_unit\":\"m\",\"time\":\"617\",\"latitude\":-94.9324995,\"longitude\":36.1089742,\"is_sub_step\":false},{\"id\":8350704,\"route_id\":2518684,\"step_index\":\"4\",\"instruction\":\"Take N4540 Rd to County Rd 504 in Delaware County\",\"distance\":11980,\"distance_unit\":\"m\",\"time\":\"540\",\"latitude\":-94.9177967,\"longitude\":36.1930098,\"is_sub_step\":false},{\"id\":8350705,\"route_id\":2518684,\"step_index\":\"5\",\"instruction\":\"Follow County Rd 504 to County Rd 530\\\/D0480 Rd in Kenwood\",\"distance\":11056,\"distance_unit\":\"m\",\"time\":\"502\",\"latitude\":-94.9541341,\"longitude\":36.2797986,\"is_sub_step\":false},{\"id\":8350706,\"route_id\":2518684,\"step_index\":\"6\",\"instruction\":\"\",\"distance\":4836,\"distance_unit\":\"m\",\"time\":\"228\",\"latitude\":-94.9569053,\"longitude\":36.3305299,\"is_sub_step\":false}]"', 101128, 101128, 'no time', 0, 'northwest', 'southeast', '[{"name":"Stony Point","description":"60 mi to destination","state":"Oklahoma","country":"US","full_address":"Stony Point, Oklahoma 74960","lat":"35.847865","lng":"-94.705503","fraction":0.1111111111111111,"type":"State","distance_km":1,"place_id":36005,"slug":"stony-point","hash":"a0y11x4o"},{"name":"Titanic","description":"Traveled 15 mi from origin","state":"Oklahoma","country":"US","full_address":"Titanic, OK","lat":"35.901096","lng":"-94.771805","fraction":0.2222222222222222,"type":"City","distance_km":1,"place_id":22664,"slug":"titanic","hash":"o2afurx7"},{"name":"Proctor","description":"45 mi to destination","state":"Oklahoma","country":"US","full_address":"Proctor, OK 74464","lat":"35.966199","lng":"-94.777451","fraction":0.3333333333333333,"type":"City","distance_km":0,"place_id":26584,"slug":"proctor","hash":"cek084ya"},{"name":"Chewey","description":"30 mi to destination","state":"Oklahoma","country":"US","full_address":"Chewey, OK","lat":"36.103697","lng":"-94.767450","fraction":0.5555555555555556,"type":"City","distance_km":4,"place_id":23311,"slug":"chewey","hash":"w650hqtf"},{"name":"Oaks","description":"Traveled 45 mi from origin","state":"Oklahoma","country":"US","full_address":"Oaks, OK","lat":"36.166198","lng":"-94.854675","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":24643,"slug":"oaks","hash":"xf8j0nr5"},{"name":"Leach","description":"15 mi to destination","state":"Oklahoma","country":"US","full_address":"Leach, OK 74364","lat":"36.204810","lng":"-94.922454","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":24810,"slug":"leach","hash":"lrbqtj1q"},{"name":"Bull Hollow","description":"Traveled 60 mi from origin","state":"Oklahoma","country":"US","full_address":"Bull Hollow, OK","lat":"36.313696","lng":"-94.907177","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":28160,"slug":"bull-hollow","hash":"8ks93nzv"}]', 1, 7, '{"distanceInMiles":62.83818211192166,"distanceMilesFormatted":"62.8 miles","distanceFormatted":"62.8 miles","distanceKmFormatted":"101 km","timeHours":1.3333333333333333,"timeFormatted":"1 hour 20 minutes","avgSpeed":45,"routeDescriptors":["mixed highways and local roads","substantial"],"journeyType":"major journey","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}', null, 'lyons-switch-jehry2o2/old-eucha-qb6l83k5', 0, null, null, 0, '"[{\"name\":\"Stony Point\",\"description\":\"60 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Stony Point, Oklahoma 74960\",\"lat\":\"35.847865\",\"lng\":\"-94.705503\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":1,\"place_id\":36005,\"slug\":\"stony-point\",\"hash\":\"a0y11x4o\"},{\"name\":\"Titanic\",\"description\":\"Traveled 15 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Titanic, OK\",\"lat\":\"35.901096\",\"lng\":\"-94.771805\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":1,\"place_id\":22664,\"slug\":\"titanic\",\"hash\":\"o2afurx7\"},{\"name\":\"Proctor\",\"description\":\"45 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Proctor, OK 74464\",\"lat\":\"35.966199\",\"lng\":\"-94.777451\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":0,\"place_id\":26584,\"slug\":\"proctor\",\"hash\":\"cek084ya\"},{\"name\":\"Chewey\",\"description\":\"30 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Chewey, OK\",\"lat\":\"36.103697\",\"lng\":\"-94.767450\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":4,\"place_id\":23311,\"slug\":\"chewey\",\"hash\":\"w650hqtf\"},{\"name\":\"Oaks\",\"description\":\"Traveled 45 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Oaks, OK\",\"lat\":\"36.166198\",\"lng\":\"-94.854675\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":24643,\"slug\":\"oaks\",\"hash\":\"xf8j0nr5\"},{\"name\":\"Leach\",\"description\":\"15 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Leach, OK 74364\",\"lat\":\"36.204810\",\"lng\":\"-94.922454\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":24810,\"slug\":\"leach\",\"hash\":\"lrbqtj1q\"},{\"name\":\"Bull Hollow\",\"description\":\"Traveled 60 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Bull Hollow, OK\",\"lat\":\"36.313696\",\"lng\":\"-94.907177\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":28160,\"slug\":\"bull-hollow\",\"hash\":\"8ks93nzv\"}]"', 7, 889937, '2025-05-18 09:04:49', '2025-05-18 09:04:49') returning "id"
      Bindings
      • 0: 20159
      • 1: Lyons Switch
      • 2: Lyons Switch, OK
      • 3: lyons-switch
      • 4: jehry2o2
      • 5: 35.77491
      • 6: -94.691548
      • 7: Lyons Switch
      • 8: Oklahoma
      • 9: US
      • 10: America/Chicago
      • 11: 31384
      • 12: Old Eucha
      • 13: Old Eucha, OK
      • 14: old-eucha
      • 15: qb6l83k5
      • 16: 36.344808
      • 17: -94.945234
      • 18: Old Eucha
      • 19: Oklahoma
      • 20: US
      • 21: America/Chicago
      • 22: 2518684
      • 23: OK-82A
      • 24: 101128
      • 25: m
      • 26: 4835
      • 27: 62.838006488
      • 28: 101128
      • 29: 1 hour 20 minutes
      • 30: 1 hour 20 minutes
      • 31: 101.128
      • 32: 101.1 km
      • 33: 
      • 34: 81
      • 35: 0
      • 36: No
      • 37: 62.8 mi
      • 38: 41.84800452247774
      • 39: 0.041848004522477736
      • 40: "[{\"id\":8350700,\"route_id\":2518684,\"step_index\":\"0\",\"instruction\":\"Take S 4690 Rd\\\/N4690 Rd to OK-100 E\",\"distance\":5430,\"distance_unit\":\"m\",\"time\":\"330\",\"latitude\":-94.6787783,\"longitude\":35.7917614,\"is_sub_step\":false},{\"id\":8350701,\"route_id\":2518684,\"step_index\":\"1\",\"instruction\":\"Take OK-51 W and US-62 W to N 4514 Rd\\\/OK-82A in Grandview\",\"distance\":45263,\"distance_unit\":\"m\",\"time\":\"2070\",\"latitude\":-94.8077144,\"longitude\":35.8972271,\"is_sub_step\":false},{\"id\":8350702,\"route_id\":2518684,\"step_index\":\"2\",\"instruction\":\"Continue to Johnson Prairie\",\"distance\":10441,\"distance_unit\":\"m\",\"time\":\"548\",\"latitude\":-94.9625203,\"longitude\":36.0307568,\"is_sub_step\":false},{\"id\":8350703,\"route_id\":2518684,\"step_index\":\"3\",\"instruction\":\"Follow OK-82A to N 549 Rd\\\/N 556 Rd\\\/New Talaquah in Rocky Ford\",\"distance\":12122,\"distance_unit\":\"m\",\"time\":\"617\",\"latitude\":-94.9324995,\"longitude\":36.1089742,\"is_sub_step\":false},{\"id\":8350704,\"route_id\":2518684,\"step_index\":\"4\",\"instruction\":\"Take N4540 Rd to County Rd 504 in Delaware County\",\"distance\":11980,\"distance_unit\":\"m\",\"time\":\"540\",\"latitude\":-94.9177967,\"longitude\":36.1930098,\"is_sub_step\":false},{\"id\":8350705,\"route_id\":2518684,\"step_index\":\"5\",\"instruction\":\"Follow County Rd 504 to County Rd 530\\\/D0480 Rd in Kenwood\",\"distance\":11056,\"distance_unit\":\"m\",\"time\":\"502\",\"latitude\":-94.9541341,\"longitude\":36.2797986,\"is_sub_step\":false},{\"id\":8350706,\"route_id\":2518684,\"step_index\":\"6\",\"instruction\":\"\",\"distance\":4836,\"distance_unit\":\"m\",\"time\":\"228\",\"latitude\":-94.9569053,\"longitude\":36.3305299,\"is_sub_step\":false}]"
      • 41: 101128
      • 42: 101128
      • 43: no time
      • 44: 0
      • 45: northwest
      • 46: southeast
      • 47: [{"name":"Stony Point","description":"60 mi to destination","state":"Oklahoma","country":"US","full_address":"Stony Point, Oklahoma 74960","lat":"35.847865","lng":"-94.705503","fraction":0.1111111111111111,"type":"State","distance_km":1,"place_id":36005,"slug":"stony-point","hash":"a0y11x4o"},{"name":"Titanic","description":"Traveled 15 mi from origin","state":"Oklahoma","country":"US","full_address":"Titanic, OK","lat":"35.901096","lng":"-94.771805","fraction":0.2222222222222222,"type":"City","distance_km":1,"place_id":22664,"slug":"titanic","hash":"o2afurx7"},{"name":"Proctor","description":"45 mi to destination","state":"Oklahoma","country":"US","full_address":"Proctor, OK 74464","lat":"35.966199","lng":"-94.777451","fraction":0.3333333333333333,"type":"City","distance_km":0,"place_id":26584,"slug":"proctor","hash":"cek084ya"},{"name":"Chewey","description":"30 mi to destination","state":"Oklahoma","country":"US","full_address":"Chewey, OK","lat":"36.103697","lng":"-94.767450","fraction":0.5555555555555556,"type":"City","distance_km":4,"place_id":23311,"slug":"chewey","hash":"w650hqtf"},{"name":"Oaks","description":"Traveled 45 mi from origin","state":"Oklahoma","country":"US","full_address":"Oaks, OK","lat":"36.166198","lng":"-94.854675","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":24643,"slug":"oaks","hash":"xf8j0nr5"},{"name":"Leach","description":"15 mi to destination","state":"Oklahoma","country":"US","full_address":"Leach, OK 74364","lat":"36.204810","lng":"-94.922454","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":24810,"slug":"leach","hash":"lrbqtj1q"},{"name":"Bull Hollow","description":"Traveled 60 mi from origin","state":"Oklahoma","country":"US","full_address":"Bull Hollow, OK","lat":"36.313696","lng":"-94.907177","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":28160,"slug":"bull-hollow","hash":"8ks93nzv"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":62.83818211192166,"distanceMilesFormatted":"62.8 miles","distanceFormatted":"62.8 miles","distanceKmFormatted":"101 km","timeHours":1.3333333333333333,"timeFormatted":"1 hour 20 minutes","avgSpeed":45,"routeDescriptors":["mixed highways and local roads","substantial"],"journeyType":"major journey","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}
      • 51: 
      • 52: lyons-switch-jehry2o2/old-eucha-qb6l83k5
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Stony Point\",\"description\":\"60 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Stony Point, Oklahoma 74960\",\"lat\":\"35.847865\",\"lng\":\"-94.705503\",\"fraction\":0.1111111111111111,\"type\":\"State\",\"distance_km\":1,\"place_id\":36005,\"slug\":\"stony-point\",\"hash\":\"a0y11x4o\"},{\"name\":\"Titanic\",\"description\":\"Traveled 15 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Titanic, OK\",\"lat\":\"35.901096\",\"lng\":\"-94.771805\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":1,\"place_id\":22664,\"slug\":\"titanic\",\"hash\":\"o2afurx7\"},{\"name\":\"Proctor\",\"description\":\"45 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Proctor, OK 74464\",\"lat\":\"35.966199\",\"lng\":\"-94.777451\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":0,\"place_id\":26584,\"slug\":\"proctor\",\"hash\":\"cek084ya\"},{\"name\":\"Chewey\",\"description\":\"30 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Chewey, OK\",\"lat\":\"36.103697\",\"lng\":\"-94.767450\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":4,\"place_id\":23311,\"slug\":\"chewey\",\"hash\":\"w650hqtf\"},{\"name\":\"Oaks\",\"description\":\"Traveled 45 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Oaks, OK\",\"lat\":\"36.166198\",\"lng\":\"-94.854675\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":24643,\"slug\":\"oaks\",\"hash\":\"xf8j0nr5\"},{\"name\":\"Leach\",\"description\":\"15 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Leach, OK 74364\",\"lat\":\"36.204810\",\"lng\":\"-94.922454\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":24810,\"slug\":\"leach\",\"hash\":\"lrbqtj1q\"},{\"name\":\"Bull Hollow\",\"description\":\"Traveled 60 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Bull Hollow, OK\",\"lat\":\"36.313696\",\"lng\":\"-94.907177\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":28160,\"slug\":\"bull-hollow\",\"hash\":\"8ks93nzv\"}]"
      • 58: 7
      • 59: 889937
      • 60: 2025-05-18 09:04:49
      • 61: 2025-05-18 09:04:49
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance480μsselect exists(select "id" from "routes" where "origin_destination_id" = 889937 limit 1) as "exists"
      Bindings
      • 0: 889937
      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#1186distance680μsselect * from "routes" where "routes"."origin_destination_id" = 889937 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889937
      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#1186distance460μsselect * from "route_directions" where "route_directions"."route_id" in (2518682, 2518683, 2518684) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance1.04msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:49' where "id" = 2518684
      Bindings
      • 0: 2025-05-18 09:04:49
      • 1: 2518684
      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#235distance400μsselect * from "origin_destinations" where "origin_destinations"."id" = 889937 limit 1
      Bindings
      • 0: 889937
      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#244distance410μsselect * from "places" where "places"."id" = 20159 limit 1
      Bindings
      • 0: 20159
      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#245distance350μsselect * from "places" where "places"."id" = 31384 limit 1
      Bindings
      • 0: 31384
      Backtrace
      • app/Models/Route.php:245
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance320μsselect * from "route_waypoints" where "route_id" = 2518684
      Bindings
      • 0: 2518684
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#103distance340μsselect * from "places" where "places"."id" = 20159 limit 1
      Bindings
      • 0: 20159
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#104distance320μsselect * from "places" where "places"."id" = 31384 limit 1
      Bindings
      • 0: 31384
      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#226distance91.46msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.838232)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.719735333333)) + sin(radians(35.838232)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance560μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 36005 limit 1
      Bindings
      • 0: 36005
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance93.97msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.901554)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.747922666667)) + sin(radians(35.901554)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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" = 22664 limit 1
      Bindings
      • 0: 22664
      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#226distance88.52msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.964876)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.77611)) + sin(radians(35.964876)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#158distance580μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 26584 limit 1
      Bindings
      • 0: 26584
      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#226distance94.01msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.028198)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.804297333333)) + sin(radians(36.028198)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#226distance86.9msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.09152)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.832484666667)) + sin(radians(36.09152)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#158distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 23311 limit 1
      Bindings
      • 0: 23311
      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.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.154842)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.860672)) + sin(radians(36.154842)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#158distance520μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 24643 limit 1
      Bindings
      • 0: 24643
      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.98msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.218164)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.888859333333)) + sin(radians(36.218164)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 24810 limit 1
      Bindings
      • 0: 24810
      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#226distance92.69msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.281486)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.917046666667)) + sin(radians(36.281486)) * 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" != 20159 and "places"."id" != 31384 order by "distance" asc limit 1
      Bindings
      • 0: 20159
      • 1: 31384
      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#158distance590μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 28160 limit 1
      Bindings
      • 0: 28160
      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#78distance360μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 36005) limit 1
      Bindings
      • 0: 2518684
      • 1: 36005
      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#78distance68.01msupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:50' where "id" = 6300450
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:50
      • 2: 6300450
      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#78distance520μsselect * from "route_waypoints" where ("route_id" = 2518684 and "place_id" = 22664) limit 1
      Bindings
      • 0: 2518684
      • 1: 22664
      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#78distance1.41msupdate "route_waypoints" set "fraction" = 0.22222222222222, "updated_at" = '2025-05-18 09:04:50' where "id" = 6300451
      Bindings
      • 0: 0.2222222222222222
      • 1: 2025-05-18 09:04:50
      • 2: 6300451
      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
    • distance380μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance7.5msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance420μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance26.83msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance560μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance12.91msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance390μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance750μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance3.18msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance530μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance340μsselect * from "route_waypoints" where "route_id" = ?
    • distance350μsselect * from "places" where "places"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance89.41msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.838232)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.719735333333)) + sin(radians(35.838232)) * 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
    • distance790μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance93.39msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.901554)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.747922666667)) + sin(radians(35.901554)) * 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
    • distance96.93msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(35.964876)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.77611)) + sin(radians(35.964876)) * 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
    • distance570μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance105msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.028198)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.804297333333)) + sin(radians(36.028198)) * 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
    • distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.09152)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.832484666667)) + sin(radians(36.09152)) * 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
    • distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance87.04msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.154842)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.860672)) + sin(radians(36.154842)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance520μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance91.18msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.218164)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.888859333333)) + sin(radians(36.218164)) * 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
    • distance93.53msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(36.281486)) * cos(radians(lat)) * cos(radians(lng) - radians(-94.917046666667)) + sin(radians(36.281486)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance400μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance1.01msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance360μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance800μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance690μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance690μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance660μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance370μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance690μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance670μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance400μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance370μsselect * from "states" where "states"."id" = ? limit 1
    • distance370μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance350μsselect * from "states" where "states"."id" = ? limit 1
    • distance540μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance450μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance910μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance520μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.24msselect * from "images" where "images"."place_id" in (20159)
    • distance560μsselect * from "places" where "places"."id" = ? limit 1
    • distance25.69msselect * from "images" where "images"."place_id" in (31384)
    • distance550μsselect * from "routes" where "origin_destination_id" = ?
    • distance490μ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"
    • distance410μsselect * from "route_directions" where "route_directions"."route_id" in (2518682, 2518683, 2518684) order by "step_index" asc, "step_index" asc
    • distance330μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance250μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance290μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance530μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance360μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance310μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance470μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    35RouteWaypoint.php#?
    App\Models\RouteDirection
    33RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:51GET/distance/lyons-switch-jehry2o2/old-eucha-qb6l83k5492164106