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

Just a moment while we calculate your route...

Distance from Pine Top to Staley

Driving Distance
101.8 mi • 163.9 km
Flying Distance
74.0 mi • 119.0 km
A
B
Leaflet © OpenStreetMap contributors
55 mph avg speed
Southwest direction
1 hr 49 min travel time

Route Information

The driving distance from Pine Top, Oklahoma to Staley, Oklahoma is 101.8 mi (163.9 km)

The straight-line (air) distance is 74.0 mi (119.0 km)

The estimated flight time is 0 hr 9 min

The estimated travel time by road is 1 hour 49 minutes

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

Location Details

Origin:


No image available
Place Pine Top
State/Province Oklahoma
Country US
Latitude 34.67732
Longitude -95.741929
GPS 34.67732° N, 95.741929° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Staley
State/Province Oklahoma
Country US
Latitude 33.826769
Longitude -96.529992
GPS 33.826769° N, 96.529992° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Pine Top, Oklahoma to Staley, Oklahoma covers 101.8 mi (163.9 km) in a southwest direction. This mixed highways and local roads, substantial route typically takes 1 hour 49 minutes under normal conditions.

Drivers have 3 route options between these locations (87.3-101.8 miles / 140-164 km). The primary route shown here saves 21 minutes compared to alternatives.

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

Available Routes

US-69 S and State Hwy 48 S
101.8 mi 1 hour 49 minutes
Shortest
State Hwy 48 S
101.4 mi 1 hour 51 minutes
US-69 S
87.3 mi 1 hour 31 minutes
Fastest

How is the distance calculated?

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

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

Journey Waypoints

Pine Top
Oklahoma , US
Wesley
Oklahoma, US
10.8 mi
Fugate
Oklahoma, US
18.3 mi
Bruno
Oklahoma, US
29.8 mi
Caney
Oklahoma, US
40.9 mi
Caddo
Oklahoma, US
48.3 mi
Armstrong
Oklahoma, US
55.3 mi
Calera
Oklahoma, US
64.6 mi
Staley
Oklahoma , US
Messages40RequestTimelineExceptionsViews2Queries159Models93MailsGate
SettingsRequest history4.49sRequest 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/pine-top-bsd3ksn2/staley-r7gq1v7f
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:28] LOG.warning: No denormalized route found for origin-destination ID: 889911
  • infolog[09:04:28] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 34...
  • infolog[09:04:28] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:30] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:30] LOG.info: Processing route #1 data for origin-destination ID: 889911 { "origin": "Pin...
  • infolog[09:04:30] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:30] LOG.info: Saved 3 directions for route ID: 2518617
  • infolog[09:04:30] LOG.info: Found a shorter route: 140496 meters for route ID: 2518617
  • infolog[09:04:30] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:30] LOG.info: Processing route #2 data for origin-destination ID: 889911 { "origin": "Pin...
  • infolog[09:04:30] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 4 nested sub-directions for direction index 0
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 8 nested sub-directions for direction index 1
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:30] LOG.info: Saved 3 directions for route ID: 2518619
  • infolog[09:04:30] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:30] LOG.info: Processing route #3 data for origin-destination ID: 889911 { "origin": "Pin...
  • infolog[09:04:30] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 4 nested sub-directions for direction index 0
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 11 nested sub-directions for direction index 1
  • debuglog[09:04:30] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:30] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • infolog[09:04:30] LOG.info: Saved 3 directions for route ID: 2518620
  • infolog[09:04:31] LOG.info: Successfully denormalized route data { "origin_destination_id": 889911, ...
  • infolog[09:04:31] LOG.info: Saved 3 routes for origin-destination ID: 889911
  • infolog[09:04:31] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518617, ...
  • infolog[09:04:31] LOG.info: Incremented view count for route { "id": 2518617, "name": "US-69 S", ...
  • infolog[09:04:32] LOG.info: Updated denormalized route for route { "route_id": 2518617, "views": 1 ...
  • infolog[09:04:32] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518617, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/pine-top-bsd3ksn2/staley-r7gq1v7f
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
4.5s
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 => "941a2ff1db96c985-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:32 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "XPLdQKrGobDNYH7WRnZoNAETPVyLoljTtbqhAAvc"
]
  • Booting (8.81ms)time
  • Application (4.48s)time
  • Routing (353μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (37μs)
  • 1 x Application (99.8%)
    4.48s
    1 x Booting (0.2%)
    8.81ms
    1 x Routing (0.01%)
    353μs
    1 x Preparing Response (0%)
    37μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    159 statements were executed (102 duplicates)Show only duplicatesdistance2.5s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 59 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance11.93msselect * from "sessions" where "id" = 'oFvKbc7JlXmQUtXIcrFRwMW72fdZ1ggWa2rPGhf4' limit 1
      Bindings
      • 0: oFvKbc7JlXmQUtXIcrFRwMW72fdZ1ggWa2rPGhf4
      Backtrace
      • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:96
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:116
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:104
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:88
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:146
    • RouteController.php#548distance6.47msselect * from "places" where "slug" = 'pine-top' and ("hash" = 'bsd3ksn2') limit 1
      Bindings
      • 0: pine-top
      • 1: bsd3ksn2
      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#548distance610μsselect * from "places" where "slug" = 'staley' and ("hash" = 'r7gq1v7f') limit 1
      Bindings
      • 0: staley
      • 1: r7gq1v7f
      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#104distance760μsselect * from "origin_destinations" where ("origin_id" = 34131 and "destination_id" = 73008) limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      Backtrace
      • app/Http/Controllers/RouteController.php:104
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
    • RouteController.php#104distance2.07msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (34131, 73008, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 34131
      • 1: 73008
      • 2: 2025-05-18 09:04:28
      • 3: 2025-05-18 09:04:28
      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.31msselect * from "denormalised_routes" where "origin_destination_id" = 889911 limit 1
      Bindings
      • 0: 889911
      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#70distance680μsselect exists(select "id" from "routes" where "origin_destination_id" = 889911 limit 1) as "exists"
      Bindings
      • 0: 889911
      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.62msdelete from "routes" where "origin_destination_id" = 889911
      Bindings
      • 0: 889911
      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#172distance4.42msselect * from "places" where "places"."id" = 34131 limit 1
      Bindings
      • 0: 34131
      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#173distance930μsselect * from "places" where "places"."id" = 73008 limit 1
      Bindings
      • 0: 73008
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance1.96msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889911, 'US-69 S', 140496, 'm', 5489, 0, 'No', 33.8100048, 34.720748, null, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 889911
      • 1: US-69 S
      • 2: 140496
      • 3: m
      • 4: 5489
      • 5: 0
      • 6: No
      • 7: 33.8100048
      • 8: 34.720748
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:30
      • 12: 2025-05-18 09:04:30
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance2.26msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518617, 0, 'Follow Pittsburg Rd and OK-63 W to US-69 S/Garfield Ave in Kiowa', 18101, 'm', 1212, -95.8207122, 34.6987977, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518617
      • 1: 0
      • 2: Follow Pittsburg Rd and OK-63 W to US-69 S/Garfield Ave in Kiowa
      • 3: 18101
      • 4: m
      • 5: 1212
      • 6: -95.82071219999999
      • 7: 34.6987977
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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.42msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518617, 1, 'Follow US-69 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S/US-75 S', 120186, 'm', 4177, -96.21754215, 34.26583815, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518617
      • 1: 1
      • 2: Follow US-69 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S/US-75 S
      • 3: 120186
      • 4: m
      • 5: 4177
      • 6: -96.21754214999999
      • 7: 34.26583815
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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.2msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518617, 2, 'Drive to US-69 N/US-75 N in Colbert', 2209, 'm', 100, -96.5327652, 33.8183714, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518617
      • 1: 2
      • 2: Drive to US-69 N/US-75 N in Colbert
      • 3: 2209
      • 4: m
      • 5: 100
      • 6: -96.53276519999999
      • 7: 33.8183714
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance2.78msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889911, 'US-69 S and State Hwy 48 S', 163868, 'm', 6573, 0, 'No', 33.8100048, 34.720748, null, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 889911
      • 1: US-69 S and State Hwy 48 S
      • 2: 163868
      • 3: m
      • 4: 6573
      • 5: 0
      • 6: No
      • 7: 33.8100048
      • 8: 34.720748
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:30
      • 12: 2025-05-18 09:04:30
      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.51msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518619, 0, 'Follow Pittsburg Rd to OK-63 W in Pittsburg', 13193, 'm', 938, -95.794578, 34.6968397, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518619
      • 1: 0
      • 2: Follow Pittsburg Rd to OK-63 W in Pittsburg
      • 3: 13193
      • 4: m
      • 5: 938
      • 6: -95.79457799999999
      • 7: 34.6968397
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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.26msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518619, 1, 'Take US-69 S, State Hwy 7 W, State Hwy 48 S and US-69 S/US-75 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S/US-75 S', 148466, 'm', 5535, -96.1913843, 34.26583815, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518619
      • 1: 1
      • 2: Take US-69 S, State Hwy 7 W, State Hwy 48 S and US-69 S/US-75 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S/US-75 S
      • 3: 148466
      • 4: m
      • 5: 5535
      • 6: -96.1913843
      • 7: 34.26583815
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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 (2518619, 2, 'Drive to US-69 N/US-75 N in Colbert', 2209, 'm', 100, -96.5327652, 33.8183714, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518619
      • 1: 2
      • 2: Drive to US-69 N/US-75 N in Colbert
      • 3: 2209
      • 4: m
      • 5: 100
      • 6: -96.53276519999999
      • 7: 33.8183714
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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.37msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889911, 'State Hwy 48 S', 163218, 'm', 6696, 0, 'No', 33.8100048, 34.720748, null, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 889911
      • 1: State Hwy 48 S
      • 2: 163218
      • 3: m
      • 4: 6696
      • 5: 0
      • 6: No
      • 7: 33.8100048
      • 8: 34.720748
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:30
      • 12: 2025-05-18 09:04:30
      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.23msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518620, 0, 'Follow Pittsburg Rd to OK-63 W in Pittsburg', 13193, 'm', 938, -95.794578, 34.6968397, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518620
      • 1: 0
      • 2: Follow Pittsburg Rd to OK-63 W in Pittsburg
      • 3: 13193
      • 4: m
      • 5: 938
      • 6: -95.79457799999999
      • 7: 34.6968397
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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.04msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518620, 1, 'Take OK-131 W, OK-31 W, State Hwy 48 S and US-69 S/US-75 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S/US-75 S', 147816, 'm', 5658, -96.1913843, 34.26583815, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518620
      • 1: 1
      • 2: Take OK-131 W, OK-31 W, State Hwy 48 S and US-69 S/US-75 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S/US-75 S
      • 3: 147816
      • 4: m
      • 5: 5658
      • 6: -96.1913843
      • 7: 34.26583815
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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.15msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518620, 2, 'Drive to US-69 N/US-75 N in Colbert', 2209, 'm', 100, -96.5327652, 33.8183714, 0, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518620
      • 1: 2
      • 2: Drive to US-69 N/US-75 N in Colbert
      • 3: 2209
      • 4: m
      • 5: 100
      • 6: -96.53276519999999
      • 7: 33.8183714
      • 8: 0
      • 9: 2025-05-18 09:04:30
      • 10: 2025-05-18 09:04:30
      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#24distance830μsselect * from "route_waypoints" where "route_id" = 2518617
      Bindings
      • 0: 2518617
      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#103distance520μsselect * from "origin_destinations" where "origin_destinations"."id" = 889911 limit 1
      Bindings
      • 0: 889911
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#103distance500μsselect * from "places" where "places"."id" = 34131 limit 1
      Bindings
      • 0: 34131
      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#104distance380μsselect * from "places" where "places"."id" = 73008 limit 1
      Bindings
      • 0: 73008
      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#226distance118msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.582814333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-95.829491555556)) + sin(radians(34.582814333333)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#158distance900μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 62473 limit 1
      Bindings
      • 0: 62473
      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#226distance110msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.488308666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-95.917054111111)) + sin(radians(34.488308666667)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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.25msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 70290 limit 1
      Bindings
      • 0: 70290
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.39msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.393803)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.004616666667)) + sin(radians(34.393803)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance620μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 32228 limit 1
      Bindings
      • 0: 32228
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance90.54msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.299297333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.092179222222)) + sin(radians(34.299297333333)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#226distance91.77msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.204791666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.179741777778)) + sin(radians(34.204791666667)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#158distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 22336 limit 1
      Bindings
      • 0: 22336
      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.37msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.110286)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.267304333333)) + sin(radians(34.110286)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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" = 16472 limit 1
      Bindings
      • 0: 16472
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance91.05msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.015780333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.354866888889)) + sin(radians(34.015780333333)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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.05msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 28155 limit 1
      Bindings
      • 0: 28155
      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#226distance104msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.921274666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.442429444444)) + sin(radians(33.921274666667)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#158distance760μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 10083 limit 1
      Bindings
      • 0: 10083
      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#78distance430μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 62473) limit 1
      Bindings
      • 0: 2518617
      • 1: 62473
      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.43msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 62473, 0.11111111111111, 4, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 62473
      • 2: 0.1111111111111111
      • 3: 4
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      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" = 2518617 and "place_id" = 70290) limit 1
      Bindings
      • 0: 2518617
      • 1: 70290
      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.07msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 70290, 0.22222222222222, 2, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 70290
      • 2: 0.2222222222222222
      • 3: 2
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      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" = 2518617 and "place_id" = 32228) limit 1
      Bindings
      • 0: 2518617
      • 1: 32228
      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#78distance3.82msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 32228, 0.33333333333333, 5, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 32228
      • 2: 0.3333333333333333
      • 3: 5
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      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#78distance430μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 22336) limit 1
      Bindings
      • 0: 2518617
      • 1: 22336
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance820μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 22336, 0.55555555555556, 3, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 22336
      • 2: 0.5555555555555556
      • 3: 3
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 16472) limit 1
      Bindings
      • 0: 2518617
      • 1: 16472
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.25msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 16472, 0.66666666666667, 1, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 16472
      • 2: 0.6666666666666666
      • 3: 1
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 28155) limit 1
      Bindings
      • 0: 2518617
      • 1: 28155
      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#78distance2.14msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 28155, 0.77777777777778, 3, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 28155
      • 2: 0.7777777777777778
      • 3: 3
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      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#78distance520μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 10083) limit 1
      Bindings
      • 0: 2518617
      • 1: 10083
      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.02msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518617, 10083, 0.88888888888889, 1, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 2518617
      • 1: 10083
      • 2: 0.8888888888888888
      • 3: 1
      • 4: 2025-05-18 09:04:31
      • 5: 2025-05-18 09:04:31
      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#366distance610μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518617 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518617
      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#45distance890μsselect * from "denormalised_routes" where "origin_destination_id" = 889911 limit 1
      Bindings
      • 0: 889911
      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#123distance670μsselect * from "route_directions" where "route_directions"."route_id" = 2518617 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518617
      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#198distance580μsselect * from "locations" where "locations"."id" = 34131 limit 1
      Bindings
      • 0: 34131
      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#215distance380μ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#330distance440μ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#198distance390μsselect * from "locations" where "locations"."id" = 73008 limit 1
      Bindings
      • 0: 73008
      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#198distance590μsselect * from "cities" where "cities"."id" = 10368 limit 1
      Bindings
      • 0: 10368
      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#215distance410μ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#330distance330μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance1.9msinsert 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 (34131, 'Pine Top', 'Pine Top, OK 74560', 'pine-top', 'bsd3ksn2', 34.67732, -95.741929, null, 'Oklahoma', 'US', 'America/Chicago', 73008, 'Staley', 'Staley, Colbert, OK 74733', 'staley', 'r7gq1v7f', 33.826769, -96.529992, 'Colbert', 'Oklahoma', 'US', 'America/Chicago', 2518617, 'US-69 S', 140496, 'm', 5489, 87.300140016, 140496, '1 hour 31 minutes', '1 hour 31 minutes', 140.496, '140.5 km', null, 91, 0, 'No', '87.3 mi', 74.020950117312, 0.074020950117312, '"[{\"id\":8350489,\"route_id\":2518617,\"step_index\":\"0\",\"instruction\":\"Follow Pittsburg Rd and OK-63 W to US-69 S\\\/Garfield Ave in Kiowa\",\"distance\":18101,\"distance_unit\":\"m\",\"time\":\"1212\",\"latitude\":-95.8207122,\"longitude\":34.6987977,\"is_sub_step\":false},{\"id\":8350491,\"route_id\":2518617,\"step_index\":\"1\",\"instruction\":\"Follow US-69 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S\\\/US-75 S\",\"distance\":120186,\"distance_unit\":\"m\",\"time\":\"4177\",\"latitude\":-96.2175422,\"longitude\":34.2658382,\"is_sub_step\":false},{\"id\":8350494,\"route_id\":2518617,\"step_index\":\"2\",\"instruction\":\"Drive to US-69 N\\\/US-75 N in Colbert\",\"distance\":2209,\"distance_unit\":\"m\",\"time\":\"100\",\"latitude\":-96.5327652,\"longitude\":33.8183714,\"is_sub_step\":false}]"', 140496, 140496, '21 minutes', 0, 'southwest', 'northeast', '[{"name":"Wesley","description":"106 mi to destination","state":"Oklahoma","country":"US","full_address":"Wesley, OK 74525","lat":"34.587780","lng":"-95.897500","fraction":0.1111111111111111,"type":"City","distance_km":4,"place_id":62473,"slug":"wesley","hash":"b3fljicr"},{"name":"Fugate","description":"Traveled 26 mi from origin","state":"Oklahoma","country":"US","full_address":"Fugate, OK 74569","lat":"34.457317","lng":"-95.921931","fraction":0.2222222222222222,"type":"State","distance_km":2,"place_id":70290,"slug":"fugate","hash":"wb5fjo6t"},{"name":"Bruno","description":"79 mi to destination","state":"Oklahoma","country":"US","full_address":"Bruno, OK 74525","lat":"34.344260","lng":"-96.075267","fraction":0.3333333333333333,"type":"State","distance_km":5,"place_id":32228,"slug":"bruno","hash":"21u626qe"},{"name":"Caney","description":"53 mi to destination","state":"Oklahoma","country":"US","full_address":"Caney, OK","lat":"34.232313","lng":"-96.214156","fraction":0.5555555555555556,"type":"City","distance_km":3,"place_id":22336,"slug":"caney","hash":"vkqa40bc"},{"name":"Caddo","description":"Traveled 79 mi from origin","state":"Oklahoma","country":"US","full_address":"Caddo, OK 74729","lat":"34.126760","lng":"-96.263323","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":16472,"slug":"caddo","hash":"f3689gnn"},{"name":"Armstrong","description":"26 mi to destination","state":"Oklahoma","country":"US","full_address":"Armstrong, OK 74701","lat":"34.051485","lng":"-96.345269","fraction":0.7777777777777778,"type":"City","distance_km":3,"place_id":28155,"slug":"armstrong","hash":"cvaic04o"},{"name":"Calera","description":"Traveled 106 mi from origin","state":"Oklahoma","country":"US","full_address":"Calera, OK 74730","lat":"33.934543","lng":"-96.428602","fraction":0.8888888888888888,"type":"City","distance_km":1,"place_id":10083,"slug":"calera","hash":"9239uev6"}]', 1, 7, '{"distanceInMiles":87.30038400835126,"distanceMilesFormatted":"87.3 miles","distanceFormatted":"87.3 miles","distanceKmFormatted":"140 km","timeHours":1.5166666666666666,"timeFormatted":"1 hour 31 minutes","avgSpeed":55,"routeDescriptors":["mixed highways and local roads","substantial"],"journeyType":"major journey","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southwest"}', null, 'pine-top-bsd3ksn2/staley-r7gq1v7f', 0, null, null, 0, '"[{\"name\":\"Wesley\",\"description\":\"106 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Wesley, OK 74525\",\"lat\":\"34.587780\",\"lng\":\"-95.897500\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":4,\"place_id\":62473,\"slug\":\"wesley\",\"hash\":\"b3fljicr\"},{\"name\":\"Fugate\",\"description\":\"Traveled 26 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Fugate, OK 74569\",\"lat\":\"34.457317\",\"lng\":\"-95.921931\",\"fraction\":0.2222222222222222,\"type\":\"State\",\"distance_km\":2,\"place_id\":70290,\"slug\":\"fugate\",\"hash\":\"wb5fjo6t\"},{\"name\":\"Bruno\",\"description\":\"79 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Bruno, OK 74525\",\"lat\":\"34.344260\",\"lng\":\"-96.075267\",\"fraction\":0.3333333333333333,\"type\":\"State\",\"distance_km\":5,\"place_id\":32228,\"slug\":\"bruno\",\"hash\":\"21u626qe\"},{\"name\":\"Caney\",\"description\":\"53 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Caney, OK\",\"lat\":\"34.232313\",\"lng\":\"-96.214156\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":3,\"place_id\":22336,\"slug\":\"caney\",\"hash\":\"vkqa40bc\"},{\"name\":\"Caddo\",\"description\":\"Traveled 79 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Caddo, OK 74729\",\"lat\":\"34.126760\",\"lng\":\"-96.263323\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":16472,\"slug\":\"caddo\",\"hash\":\"f3689gnn\"},{\"name\":\"Armstrong\",\"description\":\"26 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Armstrong, OK 74701\",\"lat\":\"34.051485\",\"lng\":\"-96.345269\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":3,\"place_id\":28155,\"slug\":\"armstrong\",\"hash\":\"cvaic04o\"},{\"name\":\"Calera\",\"description\":\"Traveled 106 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Calera, OK 74730\",\"lat\":\"33.934543\",\"lng\":\"-96.428602\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":1,\"place_id\":10083,\"slug\":\"calera\",\"hash\":\"9239uev6\"}]"', 3, 889911, '2025-05-18 09:04:31', '2025-05-18 09:04:31') returning "id"
      Bindings
      • 0: 34131
      • 1: Pine Top
      • 2: Pine Top, OK 74560
      • 3: pine-top
      • 4: bsd3ksn2
      • 5: 34.67732
      • 6: -95.741929
      • 7: 
      • 8: Oklahoma
      • 9: US
      • 10: America/Chicago
      • 11: 73008
      • 12: Staley
      • 13: Staley, Colbert, OK 74733
      • 14: staley
      • 15: r7gq1v7f
      • 16: 33.826769
      • 17: -96.529992
      • 18: Colbert
      • 19: Oklahoma
      • 20: US
      • 21: America/Chicago
      • 22: 2518617
      • 23: US-69 S
      • 24: 140496
      • 25: m
      • 26: 5489
      • 27: 87.300140016
      • 28: 140496
      • 29: 1 hour 31 minutes
      • 30: 1 hour 31 minutes
      • 31: 140.496
      • 32: 140.5 km
      • 33: 
      • 34: 91
      • 35: 0
      • 36: No
      • 37: 87.3 mi
      • 38: 74.02095011731181
      • 39: 0.07402095011731182
      • 40: "[{\"id\":8350489,\"route_id\":2518617,\"step_index\":\"0\",\"instruction\":\"Follow Pittsburg Rd and OK-63 W to US-69 S\\\/Garfield Ave in Kiowa\",\"distance\":18101,\"distance_unit\":\"m\",\"time\":\"1212\",\"latitude\":-95.8207122,\"longitude\":34.6987977,\"is_sub_step\":false},{\"id\":8350491,\"route_id\":2518617,\"step_index\":\"1\",\"instruction\":\"Follow US-69 S to U.S.75 Frontage Rd in Denison. Take exit 74 from US-69 S\\\/US-75 S\",\"distance\":120186,\"distance_unit\":\"m\",\"time\":\"4177\",\"latitude\":-96.2175422,\"longitude\":34.2658382,\"is_sub_step\":false},{\"id\":8350494,\"route_id\":2518617,\"step_index\":\"2\",\"instruction\":\"Drive to US-69 N\\\/US-75 N in Colbert\",\"distance\":2209,\"distance_unit\":\"m\",\"time\":\"100\",\"latitude\":-96.5327652,\"longitude\":33.8183714,\"is_sub_step\":false}]"
      • 41: 140496
      • 42: 140496
      • 43: 21 minutes
      • 44: 0
      • 45: southwest
      • 46: northeast
      • 47: [{"name":"Wesley","description":"106 mi to destination","state":"Oklahoma","country":"US","full_address":"Wesley, OK 74525","lat":"34.587780","lng":"-95.897500","fraction":0.1111111111111111,"type":"City","distance_km":4,"place_id":62473,"slug":"wesley","hash":"b3fljicr"},{"name":"Fugate","description":"Traveled 26 mi from origin","state":"Oklahoma","country":"US","full_address":"Fugate, OK 74569","lat":"34.457317","lng":"-95.921931","fraction":0.2222222222222222,"type":"State","distance_km":2,"place_id":70290,"slug":"fugate","hash":"wb5fjo6t"},{"name":"Bruno","description":"79 mi to destination","state":"Oklahoma","country":"US","full_address":"Bruno, OK 74525","lat":"34.344260","lng":"-96.075267","fraction":0.3333333333333333,"type":"State","distance_km":5,"place_id":32228,"slug":"bruno","hash":"21u626qe"},{"name":"Caney","description":"53 mi to destination","state":"Oklahoma","country":"US","full_address":"Caney, OK","lat":"34.232313","lng":"-96.214156","fraction":0.5555555555555556,"type":"City","distance_km":3,"place_id":22336,"slug":"caney","hash":"vkqa40bc"},{"name":"Caddo","description":"Traveled 79 mi from origin","state":"Oklahoma","country":"US","full_address":"Caddo, OK 74729","lat":"34.126760","lng":"-96.263323","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":16472,"slug":"caddo","hash":"f3689gnn"},{"name":"Armstrong","description":"26 mi to destination","state":"Oklahoma","country":"US","full_address":"Armstrong, OK 74701","lat":"34.051485","lng":"-96.345269","fraction":0.7777777777777778,"type":"City","distance_km":3,"place_id":28155,"slug":"armstrong","hash":"cvaic04o"},{"name":"Calera","description":"Traveled 106 mi from origin","state":"Oklahoma","country":"US","full_address":"Calera, OK 74730","lat":"33.934543","lng":"-96.428602","fraction":0.8888888888888888,"type":"City","distance_km":1,"place_id":10083,"slug":"calera","hash":"9239uev6"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":87.30038400835126,"distanceMilesFormatted":"87.3 miles","distanceFormatted":"87.3 miles","distanceKmFormatted":"140 km","timeHours":1.5166666666666666,"timeFormatted":"1 hour 31 minutes","avgSpeed":55,"routeDescriptors":["mixed highways and local roads","substantial"],"journeyType":"major journey","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"southwest"}
      • 51: 
      • 52: pine-top-bsd3ksn2/staley-r7gq1v7f
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Wesley\",\"description\":\"106 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Wesley, OK 74525\",\"lat\":\"34.587780\",\"lng\":\"-95.897500\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":4,\"place_id\":62473,\"slug\":\"wesley\",\"hash\":\"b3fljicr\"},{\"name\":\"Fugate\",\"description\":\"Traveled 26 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Fugate, OK 74569\",\"lat\":\"34.457317\",\"lng\":\"-95.921931\",\"fraction\":0.2222222222222222,\"type\":\"State\",\"distance_km\":2,\"place_id\":70290,\"slug\":\"fugate\",\"hash\":\"wb5fjo6t\"},{\"name\":\"Bruno\",\"description\":\"79 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Bruno, OK 74525\",\"lat\":\"34.344260\",\"lng\":\"-96.075267\",\"fraction\":0.3333333333333333,\"type\":\"State\",\"distance_km\":5,\"place_id\":32228,\"slug\":\"bruno\",\"hash\":\"21u626qe\"},{\"name\":\"Caney\",\"description\":\"53 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Caney, OK\",\"lat\":\"34.232313\",\"lng\":\"-96.214156\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":3,\"place_id\":22336,\"slug\":\"caney\",\"hash\":\"vkqa40bc\"},{\"name\":\"Caddo\",\"description\":\"Traveled 79 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Caddo, OK 74729\",\"lat\":\"34.126760\",\"lng\":\"-96.263323\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":16472,\"slug\":\"caddo\",\"hash\":\"f3689gnn\"},{\"name\":\"Armstrong\",\"description\":\"26 mi to destination\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Armstrong, OK 74701\",\"lat\":\"34.051485\",\"lng\":\"-96.345269\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":3,\"place_id\":28155,\"slug\":\"armstrong\",\"hash\":\"cvaic04o\"},{\"name\":\"Calera\",\"description\":\"Traveled 106 mi from origin\",\"state\":\"Oklahoma\",\"country\":\"US\",\"full_address\":\"Calera, OK 74730\",\"lat\":\"33.934543\",\"lng\":\"-96.428602\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":1,\"place_id\":10083,\"slug\":\"calera\",\"hash\":\"9239uev6\"}]"
      • 58: 3
      • 59: 889911
      • 60: 2025-05-18 09:04:31
      • 61: 2025-05-18 09:04:31
      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#70distance400μsselect exists(select "id" from "routes" where "origin_destination_id" = 889911 limit 1) as "exists"
      Bindings
      • 0: 889911
      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#1186distance580μsselect * from "routes" where "routes"."origin_destination_id" = 889911 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889911
      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#1186distance480μsselect * from "route_directions" where "route_directions"."route_id" in (2518617, 2518619, 2518620) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance940μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:31' where "id" = 2518617
      Bindings
      • 0: 2025-05-18 09:04:31
      • 1: 2518617
      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#235distance390μsselect * from "origin_destinations" where "origin_destinations"."id" = 889911 limit 1
      Bindings
      • 0: 889911
      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#244distance430μsselect * from "places" where "places"."id" = 34131 limit 1
      Bindings
      • 0: 34131
      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#245distance400μsselect * from "places" where "places"."id" = 73008 limit 1
      Bindings
      • 0: 73008
      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#24distance350μsselect * from "route_waypoints" where "route_id" = 2518617
      Bindings
      • 0: 2518617
      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#103distance640μsselect * from "places" where "places"."id" = 34131 limit 1
      Bindings
      • 0: 34131
      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#104distance420μsselect * from "places" where "places"."id" = 73008 limit 1
      Bindings
      • 0: 73008
      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#226distance89.61msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.582814333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-95.829491555556)) + sin(radians(34.582814333333)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#158distance820μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 62473 limit 1
      Bindings
      • 0: 62473
      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.63msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.488308666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-95.917054111111)) + sin(radians(34.488308666667)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#158distance770μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 70290 limit 1
      Bindings
      • 0: 70290
      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#226distance95.85msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.393803)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.004616666667)) + sin(radians(34.393803)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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" = 32228 limit 1
      Bindings
      • 0: 32228
      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#226distance110msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.299297333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.092179222222)) + sin(radians(34.299297333333)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#226distance98.11msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.204791666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.179741777778)) + sin(radians(34.204791666667)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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#158distance470μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 22336 limit 1
      Bindings
      • 0: 22336
      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#226distance89.61msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.110286)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.267304333333)) + sin(radians(34.110286)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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" = 16472 limit 1
      Bindings
      • 0: 16472
      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.84msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.015780333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.354866888889)) + sin(radians(34.015780333333)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 28155 limit 1
      Bindings
      • 0: 28155
      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#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.921274666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.442429444444)) + sin(radians(33.921274666667)) * 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" != 34131 and "places"."id" != 73008 order by "distance" asc limit 1
      Bindings
      • 0: 34131
      • 1: 73008
      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" = 10083 limit 1
      Bindings
      • 0: 10083
      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" = 2518617 and "place_id" = 62473) limit 1
      Bindings
      • 0: 2518617
      • 1: 62473
      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#78distance970μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:32' where "id" = 6300290
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:32
      • 2: 6300290
      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#78distance420μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 70290) limit 1
      Bindings
      • 0: 2518617
      • 1: 70290
      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#78distance2.68msupdate "route_waypoints" set "fraction" = 0.22222222222222, "updated_at" = '2025-05-18 09:04:32' where "id" = 6300292
      Bindings
      • 0: 0.2222222222222222
      • 1: 2025-05-18 09:04:32
      • 2: 6300292
      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#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 32228) limit 1
      Bindings
      • 0: 2518617
      • 1: 32228
      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#78distance660μsupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:32' where "id" = 6300293
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:32
      • 2: 6300293
      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#78distance2.41msselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 22336) limit 1
      Bindings
      • 0: 2518617
      • 1: 22336
      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#78distance830μsupdate "route_waypoints" set "fraction" = 0.55555555555556, "updated_at" = '2025-05-18 09:04:32' where "id" = 6300294
      Bindings
      • 0: 0.5555555555555556
      • 1: 2025-05-18 09:04:32
      • 2: 6300294
      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#78distance430μsselect * from "route_waypoints" where ("route_id" = 2518617 and "place_id" = 16472) limit 1
      Bindings
      • 0: 2518617
      • 1: 16472
      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
    • distance660μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance2.57msselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance770μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance720μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance520μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance2.11msselect * from "route_waypoints" where "route_id" = ?
    • distance420μsselect * from "places" where "places"."id" = ? limit 1
    • distance360μsselect * from "places" where "places"."id" = ? limit 1
    • distance91.89msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.582814333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-95.829491555556)) + sin(radians(34.582814333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance91.35msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.488308666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-95.917054111111)) + sin(radians(34.488308666667)) * 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
    • distance93.74msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.393803)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.004616666667)) + sin(radians(34.393803)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance1.32msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance94.57msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.299297333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.092179222222)) + sin(radians(34.299297333333)) * 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
    • distance88.72msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.204791666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.179741777778)) + sin(radians(34.204791666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance1.52msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance112msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.110286)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.267304333333)) + sin(radians(34.110286)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance97.04msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(34.015780333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.354866888889)) + sin(radians(34.015780333333)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance96.05msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.921274666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-96.442429444444)) + sin(radians(33.921274666667)) * 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
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance810μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance690μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance440μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance840μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance740μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance350μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance620μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance570μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance570μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance420μsselect * from "states" where "states"."id" = ? limit 1
    • distance260μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance280μsselect * from "states" where "states"."id" = ? limit 1
    • distance500μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance510μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance710μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance400μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.36msselect * from "images" where "images"."place_id" in (34131)
    • distance610μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.16msselect * from "images" where "images"."place_id" in (73008)
    • distance420μsselect * from "routes" where "origin_destination_id" = ?
    • distance460μ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"
    • distance320μsselect * from "route_directions" where "route_directions"."route_id" in (2518617, 2518619, 2518620) order by "step_index" asc, "step_index" asc
    • distance270μ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
    • distance300μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance540μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance310μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance280μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance390μ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
    21RouteDirection.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\Country
    2Country.php#?
    App\Models\City
    1City.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:32GET/distance/pine-top-bsd3ksn2/staley-r7gq1v7f40215993