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

Just a moment while we calculate your route...

Distance from Rabbit Hash to Alert

Driving Distance
43.6 mi • 70.2 km
Flying Distance
26.7 mi • 43.0 km
A
B
Leaflet © OpenStreetMap contributors
50 mph avg speed
North direction
57 min travel time

Route Information

The driving distance from Rabbit Hash, Kentucky to Alert, Ohio is 43.6 mi (70.2 km)

The straight-line (air) distance is 26.7 mi (43.0 km)

The estimated flight time is 0 hr 3 min

The estimated travel time by road is 57 minutes

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

Location Details

Origin:

Rabbit Hash
Place Rabbit Hash
State/Province Kentucky
Country US
Latitude 38.941449
Longitude -84.847171
GPS 38.941449° N, 84.847171° W
Local Time 5:04 AM
Timezone America/New_York

Destination:


No image available
Place Alert
State/Province Ohio
Country US
Latitude 39.32497
Longitude -84.778244
GPS 39.32497° N, 84.778244° W
Local Time 5:04 AM
Timezone America/New_York

Journey Summary

Traveling from Rabbit Hash, Kentucky to Alert, Ohio covers 43.6 mi (70.2 km) in a north direction. This mixed highways and local roads, moderate route typically takes 57 minutes under normal conditions.

Drivers have 2 route options between these locations (41.1-43.6 miles / 66-70 km). The primary route shown here saves 5 minutes compared to alternatives.

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

Available Routes

KY 3608, I-275 W and OH-128 N/Hamilton Cleves Pike Rd
43.6 mi 57 minutes
Shortest
KY 3608 and I-275 W
41.1 mi 53 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

Rabbit Hash
Kentucky , US
Belleview
Kentucky, US
3.3 mi
Camp Shor
Indiana, US
3.9 mi
Idlewild
Kentucky, US
9.8 mi
Finney
Ohio, US
12.7 mi
Elizabethtown
Ohio, US
15.2 mi
Whitewater Township
Ohio, US
17.8 mi
Harrison
Ohio, US
21.8 mi
Alert
Ohio , US
Messages38RequestTimelineExceptionsViews2Queries160Models100MailsGate
SettingsRequest history3.33sRequest 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/rabbit-hash-iqb2fudj/alert-jbmie7f5
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:43] LOG.warning: No denormalized route found for origin-destination ID: 889928
  • infolog[09:04:43] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 28...
  • infolog[09:04:43] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:43] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:43] LOG.info: Processing route #1 data for origin-destination ID: 889928 { "origin": "Rab...
  • infolog[09:04:43] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 2 nested sub-directions for direction index 0
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 4 nested sub-directions for direction index 1
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 4 nested sub-directions for direction index 3
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 5 nested sub-directions for direction index 4
  • infolog[09:04:43] LOG.info: Saved 5 directions for route ID: 2518661
  • infolog[09:04:43] LOG.info: Found a shorter route: 66146 meters for route ID: 2518661
  • infolog[09:04:43] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:43] LOG.info: Processing route #2 data for origin-destination ID: 889928 { "origin": "Rab...
  • infolog[09:04:43] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 2 nested sub-directions for direction index 0
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 4 nested sub-directions for direction index 1
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 3 nested sub-directions for direction index 2
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 4 nested sub-directions for direction index 3
  • debuglog[09:04:43] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:43] LOG.info: Ignoring 6 nested sub-directions for direction index 4
  • infolog[09:04:43] LOG.info: Saved 5 directions for route ID: 2518662
  • infolog[09:04:44] LOG.info: Successfully denormalized route data { "origin_destination_id": 889928, ...
  • infolog[09:04:44] LOG.info: Saved 2 routes for origin-destination ID: 889928
  • infolog[09:04:44] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518661, ...
  • infolog[09:04:44] LOG.info: Incremented view count for route { "id": 2518661, "name": "KY 3608 and ...
  • infolog[09:04:45] LOG.info: Updated denormalized route for route { "route_id": 2518661, "views": 1 ...
  • infolog[09:04:45] LOG.info: Found existing routes { "route_count": 2, "default_route_id": 2518661, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/rabbit-hash-iqb2fudj/alert-jbmie7f5
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
3.34s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a30403cb2c985-IAD"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:46 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "VojRanvlX6yE1rfExubTNrC4VIORIMuf9lQYg1Rx"
]
  • Booting (6.95ms)time
  • Application (3.33s)time
  • Routing (341μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (45μs)
  • 1 x Application (99.79%)
    3.33s
    1 x Booting (0.21%)
    6.95ms
    1 x Routing (0.01%)
    341μs
    1 x Preparing Response (0%)
    45μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    160 statements were executed (99 duplicates)Show only duplicatesdistance2.64s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 60 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance12.41msselect * from "sessions" where "id" = 'mofRh1MzWPcYU6TDvC9ETG3Sjt195d5lGBBDNsUt' limit 1
      Bindings
      • 0: mofRh1MzWPcYU6TDvC9ETG3Sjt195d5lGBBDNsUt
      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
    • DatabaseSessionHandler.php#280distance1.69msdelete from "sessions" where "last_activity" <= 1747551883
      Bindings
      • 0: 1747551883
      Backtrace
      • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:280
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:177
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:118
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
      • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:208
    • RouteController.php#548distance6.78msselect * from "places" where "slug" = 'rabbit-hash' and ("hash" = 'iqb2fudj') limit 1
      Bindings
      • 0: rabbit-hash
      • 1: iqb2fudj
      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" = 'alert' and ("hash" = 'jbmie7f5') limit 1
      Bindings
      • 0: alert
      • 1: jbmie7f5
      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#104distance810μsselect * from "origin_destinations" where ("origin_id" = 28506 and "destination_id" = 33625) limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#104distance1.87msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (28506, 33625, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 28506
      • 1: 33625
      • 2: 2025-05-18 09:04:43
      • 3: 2025-05-18 09:04:43
      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.53msselect * from "denormalised_routes" where "origin_destination_id" = 889928 limit 1
      Bindings
      • 0: 889928
      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#70distance640μsselect exists(select "id" from "routes" where "origin_destination_id" = 889928 limit 1) as "exists"
      Bindings
      • 0: 889928
      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.18msdelete from "routes" where "origin_destination_id" = 889928
      Bindings
      • 0: 889928
      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#172distance430μsselect * from "places" where "places"."id" = 28506 limit 1
      Bindings
      • 0: 28506
      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#173distance340μsselect * from "places" where "places"."id" = 33625 limit 1
      Bindings
      • 0: 33625
      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#225distance4.19msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889928, 'KY 3608 and I-275 W', 66146, 'm', 3181, 0, 'No', 38.9409846, 39.32497, null, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 889928
      • 1: KY 3608 and I-275 W
      • 2: 66146
      • 3: m
      • 4: 3181
      • 5: 0
      • 6: No
      • 7: 38.9409846
      • 8: 39.32497
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:43
      • 12: 2025-05-18 09:04:43
      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.77msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518661, 0, 'Take Rabbit Hash Hill Rd to KY-338 N', 1714, 'm', 147, -84.8378952, 38.9415458, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518661
      • 1: 0
      • 2: Take Rabbit Hash Hill Rd to KY-338 N
      • 3: 1714
      • 4: m
      • 5: 147
      • 6: -84.83789519999999
      • 7: 38.94154579999999
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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#548distance760μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518661, 1, 'Take KY-18 E to KY-20/KY 3608 in Belleview', 6683, 'm', 375, -84.82483835, 38.96742725, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518661
      • 1: 1
      • 2: Take KY-18 E to KY-20/KY 3608 in Belleview
      • 3: 6683
      • 4: m
      • 5: 375
      • 6: -84.82483835000001
      • 7: 38.96742725
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance740μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518661, 2, 'Get on I-275 W', 19917, 'm', 1031, -84.8340004, 39.04183845, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518661
      • 1: 2
      • 2: Get on I-275 W
      • 3: 19917
      • 4: m
      • 5: 1031
      • 6: -84.8340004
      • 7: 39.04183844999999
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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.61msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518661, 3, 'Continue on I-275 W to Harrison. Take exit 1 from I-74/US-52 W', 28095, 'm', 981, -84.78350665, 39.17481765, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518661
      • 1: 3
      • 2: Continue on I-275 W to Harrison. Take exit 1 from I-74/US-52 W
      • 3: 28095
      • 4: m
      • 5: 981
      • 6: -84.78350665
      • 7: 39.17481765000001
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance720μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518661, 4, 'Take Carolina Trace Rd and New Biddinger Rd to Alert New London Rd in Okeana', 9737, 'm', 647, -84.7889656, 39.29240445, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518661
      • 1: 4
      • 2: Take Carolina Trace Rd and New Biddinger Rd to Alert New London Rd in Okeana
      • 3: 9737
      • 4: m
      • 5: 647
      • 6: -84.78896560000001
      • 7: 39.29240445000001
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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#225distance3.29msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889928, 'KY 3608, I-275 W and OH-128 N/Hamilton Cleves Pike Rd', 70213, 'm', 3478, 0, 'No', 38.9409846, 39.32497, null, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 889928
      • 1: KY 3608, I-275 W and OH-128 N/Hamilton Cleves Pike Rd
      • 2: 70213
      • 3: m
      • 4: 3478
      • 5: 0
      • 6: No
      • 7: 38.9409846
      • 8: 39.32497
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:43
      • 12: 2025-05-18 09:04:43
      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.74msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518662, 0, 'Take Rabbit Hash Hill Rd to KY-338 N', 1714, 'm', 147, -84.8378952, 38.9415458, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518662
      • 1: 0
      • 2: Take Rabbit Hash Hill Rd to KY-338 N
      • 3: 1714
      • 4: m
      • 5: 147
      • 6: -84.83789519999999
      • 7: 38.94154579999999
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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#548distance670μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518662, 1, 'Take KY-18 E to KY-20/KY 3608 in Belleview', 6683, 'm', 375, -84.82483835, 38.96742725, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518662
      • 1: 1
      • 2: Take KY-18 E to KY-20/KY 3608 in Belleview
      • 3: 6683
      • 4: m
      • 5: 375
      • 6: -84.82483835000001
      • 7: 38.96742725
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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#548distance3.77msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518662, 2, 'Get on I-275 W', 19917, 'm', 1031, -84.8340004, 39.04183845, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518662
      • 1: 2
      • 2: Get on I-275 W
      • 3: 19917
      • 4: m
      • 5: 1031
      • 6: -84.8340004
      • 7: 39.04183844999999
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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#548distance680μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518662, 3, 'Continue on I-275 W to Crosby Township', 29378, 'm', 1151, -84.76904305, 39.1725214, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518662
      • 1: 3
      • 2: Continue on I-275 W to Crosby Township
      • 3: 29378
      • 4: m
      • 5: 1151
      • 6: -84.76904305
      • 7: 39.1725214
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance690μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518662, 4, 'Continue on Crosby Rd. Take New Haven Rd, Oxford Rd and Howards Creek Rd to Alert New London Rd in Okeana', 12521, 'm', 774, -84.7428384, 39.2904675, 0, '2025-05-18 09:04:43', '2025-05-18 09:04:43') returning "id"
      Bindings
      • 0: 2518662
      • 1: 4
      • 2: Continue on Crosby Rd. Take New Haven Rd, Oxford Rd and Howards Creek Rd to Alert New London Rd in Okeana
      • 3: 12521
      • 4: m
      • 5: 774
      • 6: -84.7428384
      • 7: 39.290467500000005
      • 8: 0
      • 9: 2025-05-18 09:04:43
      • 10: 2025-05-18 09:04:43
      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#24distance580μsselect * from "route_waypoints" where "route_id" = 2518661
      Bindings
      • 0: 2518661
      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#103distance320μsselect * from "origin_destinations" where "origin_destinations"."id" = 889928 limit 1
      Bindings
      • 0: 889928
      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#103distance4.92msselect * from "places" where "places"."id" = 28506 limit 1
      Bindings
      • 0: 28506
      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#104distance330μsselect * from "places" where "places"."id" = 33625 limit 1
      Bindings
      • 0: 33625
      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#226distance136msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.984062444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.839512444444)) + sin(radians(38.984062444444)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance990μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 25711 limit 1
      Bindings
      • 0: 25711
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance98.29msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.026675888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.831853888889)) + sin(radians(39.026675888889)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 67675 limit 1
      Bindings
      • 0: 67675
      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#226distance108msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.069289333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.824195333333)) + sin(radians(39.069289333333)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 88719 limit 1
      Bindings
      • 0: 88719
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance95.44msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.111902777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.816536777778)) + sin(radians(39.111902777778)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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.34msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 56916 limit 1
      Bindings
      • 0: 56916
      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#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.154516222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.808878222222)) + sin(radians(39.154516222222)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 24359 limit 1
      Bindings
      • 0: 24359
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance94.26msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.197129666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.801219666667)) + sin(radians(39.197129666667)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 101362 limit 1
      Bindings
      • 0: 101362
      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#226distance113msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.239743111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.793561111111)) + sin(radians(39.239743111111)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance590μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 3560 limit 1
      Bindings
      • 0: 3560
      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.34msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.282356555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.785902555556)) + sin(radians(39.282356555556)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#78distance450μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 25711) limit 1
      Bindings
      • 0: 2518661
      • 1: 25711
      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#78distance4.71msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 25711, 0.11111111111111, 1, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 25711
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 67675) limit 1
      Bindings
      • 0: 2518661
      • 1: 67675
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance760μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 67675, 0.22222222222222, 2, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 67675
      • 2: 0.2222222222222222
      • 3: 2
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      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#78distance280μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 88719) limit 1
      Bindings
      • 0: 2518661
      • 1: 88719
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance900μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 88719, 0.33333333333333, 2, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 88719
      • 2: 0.3333333333333333
      • 3: 2
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 56916) limit 1
      Bindings
      • 0: 2518661
      • 1: 56916
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance780μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 56916, 0.44444444444444, 2, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 56916
      • 2: 0.4444444444444444
      • 3: 2
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 24359) limit 1
      Bindings
      • 0: 2518661
      • 1: 24359
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance890μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 24359, 0.55555555555556, 0, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 24359
      • 2: 0.5555555555555556
      • 3: 0
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      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" = 2518661 and "place_id" = 101362) limit 1
      Bindings
      • 0: 2518661
      • 1: 101362
      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#78distance830μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 101362, 0.66666666666667, 1, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 101362
      • 2: 0.6666666666666666
      • 3: 1
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      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" = 2518661 and "place_id" = 3560) limit 1
      Bindings
      • 0: 2518661
      • 1: 3560
      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#78distance740μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518661, 3560, 0.77777777777778, 1, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 2518661
      • 1: 3560
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:44
      • 5: 2025-05-18 09:04:44
      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#366distance530μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518661 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518661
      Backtrace
      • app/Services/DistanceCalculationService.php:366
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteDenormalisationService.php#45distance440μsselect * from "denormalised_routes" where "origin_destination_id" = 889928 limit 1
      Bindings
      • 0: 889928
      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#123distance580μsselect * from "route_directions" where "route_directions"."route_id" = 2518661 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518661
      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#198distance360μsselect * from "locations" where "locations"."id" = 28506 limit 1
      Bindings
      • 0: 28506
      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#198distance470μsselect * from "cities" where "cities"."id" = 18005 limit 1
      Bindings
      • 0: 18005
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:153
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#215distance350μsselect * from "states" where "states"."id" = 7 limit 1
      Bindings
      • 0: 7
      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#330distance350μ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#198distance300μsselect * from "locations" where "locations"."id" = 33625 limit 1
      Bindings
      • 0: 33625
      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#198distance340μsselect * from "cities" where "cities"."id" = 20394 limit 1
      Bindings
      • 0: 20394
      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#215distance300μsselect * from "states" where "states"."id" = 20 limit 1
      Bindings
      • 0: 20
      Backtrace
      • app/Models/Place.php:215
      • app/Services/RouteDenormalisationService.php:168
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#330distance300μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance2.05msinsert 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 (28506, 'Rabbit Hash', 'Rabbit Hash, KY', 'rabbit-hash', 'iqb2fudj', 38.941449, -84.847171, 'Rabbit Hash', 'Kentucky', 'US', 'America/New_York', 33625, 'Alert', 'Alert, OH 45053', 'alert', 'jbmie7f5', 39.32497, -84.778244, 'Alert', 'Ohio', 'US', 'America/New_York', 2518661, 'KY 3608 and I-275 W', 66146, 'm', 3181, 41.101206166, 66146, '53 minutes', '53 minutes', 66.146, '66.1 km', null, 53, 0, 'No', '41.1 mi', 26.754981402983, 0.026754981402983, '"[{\"id\":8350627,\"route_id\":2518661,\"step_index\":\"0\",\"instruction\":\"Take Rabbit Hash Hill Rd to KY-338 N\",\"distance\":1714,\"distance_unit\":\"m\",\"time\":\"147\",\"latitude\":-84.8378952,\"longitude\":38.9415458,\"is_sub_step\":false},{\"id\":8350628,\"route_id\":2518661,\"step_index\":\"1\",\"instruction\":\"Take KY-18 E to KY-20\\\/KY 3608 in Belleview\",\"distance\":6683,\"distance_unit\":\"m\",\"time\":\"375\",\"latitude\":-84.8248384,\"longitude\":38.9674273,\"is_sub_step\":false},{\"id\":8350629,\"route_id\":2518661,\"step_index\":\"2\",\"instruction\":\"Get on I-275 W\",\"distance\":19917,\"distance_unit\":\"m\",\"time\":\"1031\",\"latitude\":-84.8340004,\"longitude\":39.0418385,\"is_sub_step\":false},{\"id\":8350630,\"route_id\":2518661,\"step_index\":\"3\",\"instruction\":\"Continue on I-275 W to Harrison. Take exit 1 from I-74\\\/US-52 W\",\"distance\":28095,\"distance_unit\":\"m\",\"time\":\"981\",\"latitude\":-84.7835067,\"longitude\":39.1748177,\"is_sub_step\":false},{\"id\":8350631,\"route_id\":2518661,\"step_index\":\"4\",\"instruction\":\"Take Carolina Trace Rd and New Biddinger Rd to Alert New London Rd in Okeana\",\"distance\":9737,\"distance_unit\":\"m\",\"time\":\"647\",\"latitude\":-84.7889656,\"longitude\":39.2924045,\"is_sub_step\":false}]"', 66146, 66146, '5 minutes', 0, 'north', 'south', '[{"name":"Belleview","description":"38 mi to destination","state":"Kentucky","country":"US","full_address":"Belleview, KY","lat":"38.986171","lng":"-84.825504","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":25711,"slug":"belleview","hash":"dtc9ogiy"},{"name":"Camp Shor","description":"Traveled 10 mi from origin","state":"Indiana","country":"US","full_address":"Camp Shor, Randolph Township, IN 47040","lat":"38.998115","lng":"-84.849116","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":67675,"slug":"camp-shor","hash":"jiizry08"},{"name":"Idlewild","description":"29 mi to destination","state":"Kentucky","country":"US","full_address":"Idlewild, KY 41080","lat":"39.077559","lng":"-84.794949","fraction":0.3333333333333333,"type":"City","distance_km":2,"place_id":88719,"slug":"idlewild","hash":"1pa8ewib"},{"name":"Finney","description":"Traveled 19 mi from origin","state":"Ohio","country":"US","full_address":"Finney, Shawnee, OH 45052","lat":"39.118947","lng":"-84.788560","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":56916,"slug":"finney","hash":"mao5dmkf"},{"name":"Elizabethtown","description":"19 mi to destination","state":"Ohio","country":"US","full_address":"Elizabethtown, OH 45052","lat":"39.158668","lng":"-84.804672","fraction":0.5555555555555556,"type":"City","distance_km":0,"place_id":24359,"slug":"elizabethtown","hash":"pa9icv6x"},{"name":"Whitewater Township","description":"Traveled 29 mi from origin","state":"Ohio","country":"US","full_address":"Whitewater Township, OH","lat":"39.193745","lng":"-84.783772","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":101362,"slug":"whitewater-township","hash":"y392q78y"},{"name":"Harrison","description":"10 mi to destination","state":"Ohio","country":"US","full_address":"Harrison, OH 45030","lat":"39.253697","lng":"-84.791600","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":3560,"slug":"harrison","hash":"26xqgu48"}]', 1, 7, '{"distanceInMiles":41.10132103843812,"distanceMilesFormatted":"41.1 miles","distanceFormatted":"41.1 miles","distanceKmFormatted":"66 km","timeHours":0.8833333333333333,"timeFormatted":"53 minutes","avgSpeed":50,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"north"}', null, 'rabbit-hash-iqb2fudj/alert-jbmie7f5', 0, null, null, 0, '"[{\"name\":\"Belleview\",\"description\":\"38 mi to destination\",\"state\":\"Kentucky\",\"country\":\"US\",\"full_address\":\"Belleview, KY\",\"lat\":\"38.986171\",\"lng\":\"-84.825504\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":25711,\"slug\":\"belleview\",\"hash\":\"dtc9ogiy\"},{\"name\":\"Camp Shor\",\"description\":\"Traveled 10 mi from origin\",\"state\":\"Indiana\",\"country\":\"US\",\"full_address\":\"Camp Shor, Randolph Township, IN 47040\",\"lat\":\"38.998115\",\"lng\":\"-84.849116\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":67675,\"slug\":\"camp-shor\",\"hash\":\"jiizry08\"},{\"name\":\"Idlewild\",\"description\":\"29 mi to destination\",\"state\":\"Kentucky\",\"country\":\"US\",\"full_address\":\"Idlewild, KY 41080\",\"lat\":\"39.077559\",\"lng\":\"-84.794949\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":2,\"place_id\":88719,\"slug\":\"idlewild\",\"hash\":\"1pa8ewib\"},{\"name\":\"Finney\",\"description\":\"Traveled 19 mi from origin\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Finney, Shawnee, OH 45052\",\"lat\":\"39.118947\",\"lng\":\"-84.788560\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":56916,\"slug\":\"finney\",\"hash\":\"mao5dmkf\"},{\"name\":\"Elizabethtown\",\"description\":\"19 mi to destination\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Elizabethtown, OH 45052\",\"lat\":\"39.158668\",\"lng\":\"-84.804672\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":0,\"place_id\":24359,\"slug\":\"elizabethtown\",\"hash\":\"pa9icv6x\"},{\"name\":\"Whitewater Township\",\"description\":\"Traveled 29 mi from origin\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Whitewater Township, OH\",\"lat\":\"39.193745\",\"lng\":\"-84.783772\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":101362,\"slug\":\"whitewater-township\",\"hash\":\"y392q78y\"},{\"name\":\"Harrison\",\"description\":\"10 mi to destination\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Harrison, OH 45030\",\"lat\":\"39.253697\",\"lng\":\"-84.791600\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":3560,\"slug\":\"harrison\",\"hash\":\"26xqgu48\"}]"', 5, 889928, '2025-05-18 09:04:44', '2025-05-18 09:04:44') returning "id"
      Bindings
      • 0: 28506
      • 1: Rabbit Hash
      • 2: Rabbit Hash, KY
      • 3: rabbit-hash
      • 4: iqb2fudj
      • 5: 38.941449
      • 6: -84.847171
      • 7: Rabbit Hash
      • 8: Kentucky
      • 9: US
      • 10: America/New_York
      • 11: 33625
      • 12: Alert
      • 13: Alert, OH 45053
      • 14: alert
      • 15: jbmie7f5
      • 16: 39.32497
      • 17: -84.778244
      • 18: Alert
      • 19: Ohio
      • 20: US
      • 21: America/New_York
      • 22: 2518661
      • 23: KY 3608 and I-275 W
      • 24: 66146
      • 25: m
      • 26: 3181
      • 27: 41.101206166000004
      • 28: 66146
      • 29: 53 minutes
      • 30: 53 minutes
      • 31: 66.146
      • 32: 66.1 km
      • 33: 
      • 34: 53
      • 35: 0
      • 36: No
      • 37: 41.1 mi
      • 38: 26.754981402982757
      • 39: 0.02675498140298276
      • 40: "[{\"id\":8350627,\"route_id\":2518661,\"step_index\":\"0\",\"instruction\":\"Take Rabbit Hash Hill Rd to KY-338 N\",\"distance\":1714,\"distance_unit\":\"m\",\"time\":\"147\",\"latitude\":-84.8378952,\"longitude\":38.9415458,\"is_sub_step\":false},{\"id\":8350628,\"route_id\":2518661,\"step_index\":\"1\",\"instruction\":\"Take KY-18 E to KY-20\\\/KY 3608 in Belleview\",\"distance\":6683,\"distance_unit\":\"m\",\"time\":\"375\",\"latitude\":-84.8248384,\"longitude\":38.9674273,\"is_sub_step\":false},{\"id\":8350629,\"route_id\":2518661,\"step_index\":\"2\",\"instruction\":\"Get on I-275 W\",\"distance\":19917,\"distance_unit\":\"m\",\"time\":\"1031\",\"latitude\":-84.8340004,\"longitude\":39.0418385,\"is_sub_step\":false},{\"id\":8350630,\"route_id\":2518661,\"step_index\":\"3\",\"instruction\":\"Continue on I-275 W to Harrison. Take exit 1 from I-74\\\/US-52 W\",\"distance\":28095,\"distance_unit\":\"m\",\"time\":\"981\",\"latitude\":-84.7835067,\"longitude\":39.1748177,\"is_sub_step\":false},{\"id\":8350631,\"route_id\":2518661,\"step_index\":\"4\",\"instruction\":\"Take Carolina Trace Rd and New Biddinger Rd to Alert New London Rd in Okeana\",\"distance\":9737,\"distance_unit\":\"m\",\"time\":\"647\",\"latitude\":-84.7889656,\"longitude\":39.2924045,\"is_sub_step\":false}]"
      • 41: 66146
      • 42: 66146
      • 43: 5 minutes
      • 44: 0
      • 45: north
      • 46: south
      • 47: [{"name":"Belleview","description":"38 mi to destination","state":"Kentucky","country":"US","full_address":"Belleview, KY","lat":"38.986171","lng":"-84.825504","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":25711,"slug":"belleview","hash":"dtc9ogiy"},{"name":"Camp Shor","description":"Traveled 10 mi from origin","state":"Indiana","country":"US","full_address":"Camp Shor, Randolph Township, IN 47040","lat":"38.998115","lng":"-84.849116","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":67675,"slug":"camp-shor","hash":"jiizry08"},{"name":"Idlewild","description":"29 mi to destination","state":"Kentucky","country":"US","full_address":"Idlewild, KY 41080","lat":"39.077559","lng":"-84.794949","fraction":0.3333333333333333,"type":"City","distance_km":2,"place_id":88719,"slug":"idlewild","hash":"1pa8ewib"},{"name":"Finney","description":"Traveled 19 mi from origin","state":"Ohio","country":"US","full_address":"Finney, Shawnee, OH 45052","lat":"39.118947","lng":"-84.788560","fraction":0.4444444444444444,"type":"City","distance_km":2,"place_id":56916,"slug":"finney","hash":"mao5dmkf"},{"name":"Elizabethtown","description":"19 mi to destination","state":"Ohio","country":"US","full_address":"Elizabethtown, OH 45052","lat":"39.158668","lng":"-84.804672","fraction":0.5555555555555556,"type":"City","distance_km":0,"place_id":24359,"slug":"elizabethtown","hash":"pa9icv6x"},{"name":"Whitewater Township","description":"Traveled 29 mi from origin","state":"Ohio","country":"US","full_address":"Whitewater Township, OH","lat":"39.193745","lng":"-84.783772","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":101362,"slug":"whitewater-township","hash":"y392q78y"},{"name":"Harrison","description":"10 mi to destination","state":"Ohio","country":"US","full_address":"Harrison, OH 45030","lat":"39.253697","lng":"-84.791600","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":3560,"slug":"harrison","hash":"26xqgu48"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":41.10132103843812,"distanceMilesFormatted":"41.1 miles","distanceFormatted":"41.1 miles","distanceKmFormatted":"66 km","timeHours":0.8833333333333333,"timeFormatted":"53 minutes","avgSpeed":50,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"north"}
      • 51: 
      • 52: rabbit-hash-iqb2fudj/alert-jbmie7f5
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Belleview\",\"description\":\"38 mi to destination\",\"state\":\"Kentucky\",\"country\":\"US\",\"full_address\":\"Belleview, KY\",\"lat\":\"38.986171\",\"lng\":\"-84.825504\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":25711,\"slug\":\"belleview\",\"hash\":\"dtc9ogiy\"},{\"name\":\"Camp Shor\",\"description\":\"Traveled 10 mi from origin\",\"state\":\"Indiana\",\"country\":\"US\",\"full_address\":\"Camp Shor, Randolph Township, IN 47040\",\"lat\":\"38.998115\",\"lng\":\"-84.849116\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":67675,\"slug\":\"camp-shor\",\"hash\":\"jiizry08\"},{\"name\":\"Idlewild\",\"description\":\"29 mi to destination\",\"state\":\"Kentucky\",\"country\":\"US\",\"full_address\":\"Idlewild, KY 41080\",\"lat\":\"39.077559\",\"lng\":\"-84.794949\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":2,\"place_id\":88719,\"slug\":\"idlewild\",\"hash\":\"1pa8ewib\"},{\"name\":\"Finney\",\"description\":\"Traveled 19 mi from origin\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Finney, Shawnee, OH 45052\",\"lat\":\"39.118947\",\"lng\":\"-84.788560\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":2,\"place_id\":56916,\"slug\":\"finney\",\"hash\":\"mao5dmkf\"},{\"name\":\"Elizabethtown\",\"description\":\"19 mi to destination\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Elizabethtown, OH 45052\",\"lat\":\"39.158668\",\"lng\":\"-84.804672\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":0,\"place_id\":24359,\"slug\":\"elizabethtown\",\"hash\":\"pa9icv6x\"},{\"name\":\"Whitewater Township\",\"description\":\"Traveled 29 mi from origin\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Whitewater Township, OH\",\"lat\":\"39.193745\",\"lng\":\"-84.783772\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":101362,\"slug\":\"whitewater-township\",\"hash\":\"y392q78y\"},{\"name\":\"Harrison\",\"description\":\"10 mi to destination\",\"state\":\"Ohio\",\"country\":\"US\",\"full_address\":\"Harrison, OH 45030\",\"lat\":\"39.253697\",\"lng\":\"-84.791600\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":3560,\"slug\":\"harrison\",\"hash\":\"26xqgu48\"}]"
      • 58: 5
      • 59: 889928
      • 60: 2025-05-18 09:04:44
      • 61: 2025-05-18 09:04:44
      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#70distance420μsselect exists(select "id" from "routes" where "origin_destination_id" = 889928 limit 1) as "exists"
      Bindings
      • 0: 889928
      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#1186distance520μsselect * from "routes" where "routes"."origin_destination_id" = 889928 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889928
      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#1186distance380μsselect * from "route_directions" where "route_directions"."route_id" in (2518661, 2518662) 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#225distance760μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:44' where "id" = 2518661
      Bindings
      • 0: 2025-05-18 09:04:44
      • 1: 2518661
      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" = 889928 limit 1
      Bindings
      • 0: 889928
      Backtrace
      • app/Models/Route.php:235
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#244distance380μsselect * from "places" where "places"."id" = 28506 limit 1
      Bindings
      • 0: 28506
      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#245distance380μsselect * from "places" where "places"."id" = 33625 limit 1
      Bindings
      • 0: 33625
      Backtrace
      • app/Models/Route.php:245
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance300μsselect * from "route_waypoints" where "route_id" = 2518661
      Bindings
      • 0: 2518661
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#103distance340μsselect * from "places" where "places"."id" = 28506 limit 1
      Bindings
      • 0: 28506
      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#104distance310μsselect * from "places" where "places"."id" = 33625 limit 1
      Bindings
      • 0: 33625
      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#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.984062444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.839512444444)) + sin(radians(38.984062444444)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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" = 25711 limit 1
      Bindings
      • 0: 25711
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance98.51msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.026675888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.831853888889)) + sin(radians(39.026675888889)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance3.51msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 67675 limit 1
      Bindings
      • 0: 67675
      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.27msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.069289333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.824195333333)) + sin(radians(39.069289333333)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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" = 88719 limit 1
      Bindings
      • 0: 88719
      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.4msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.111902777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.816536777778)) + sin(radians(39.111902777778)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance2.64msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 56916 limit 1
      Bindings
      • 0: 56916
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance91.92msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.154516222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.808878222222)) + sin(radians(39.154516222222)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#158distance1.23msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 24359 limit 1
      Bindings
      • 0: 24359
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance99.76msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.197129666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.801219666667)) + sin(radians(39.197129666667)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance590μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 101362 limit 1
      Bindings
      • 0: 101362
      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#226distance113msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.239743111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.793561111111)) + sin(radians(39.239743111111)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 3560 limit 1
      Bindings
      • 0: 3560
      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#226distance107msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.282356555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.785902555556)) + sin(radians(39.282356555556)) * 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" != 28506 and "places"."id" != 33625 order by "distance" asc limit 1
      Bindings
      • 0: 28506
      • 1: 33625
      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#78distance550μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 25711) limit 1
      Bindings
      • 0: 2518661
      • 1: 25711
      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#78distance26.73msupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:45' where "id" = 6300394
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:45
      • 2: 6300394
      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#78distance720μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 67675) limit 1
      Bindings
      • 0: 2518661
      • 1: 67675
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance1.54msupdate "route_waypoints" set "fraction" = 0.22222222222222, "updated_at" = '2025-05-18 09:04:45' where "id" = 6300395
      Bindings
      • 0: 0.2222222222222222
      • 1: 2025-05-18 09:04:45
      • 2: 6300395
      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#78distance3.48msselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 88719) limit 1
      Bindings
      • 0: 2518661
      • 1: 88719
      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#78distance23.17msupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:45' where "id" = 6300396
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:45
      • 2: 6300396
      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#78distance770μsselect * from "route_waypoints" where ("route_id" = 2518661 and "place_id" = 56916) limit 1
      Bindings
      • 0: 2518661
      • 1: 56916
      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
    • distance1.06msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance480μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance800μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance430μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance770μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance480μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance790μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance720μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance450μsselect * from "route_waypoints" where "route_id" = ?
    • distance510μsselect * from "places" where "places"."id" = ? limit 1
    • distance420μsselect * from "places" where "places"."id" = ? limit 1
    • distance117msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(38.984062444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.839512444444)) + sin(radians(38.984062444444)) * 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.44msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance113msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.026675888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.831853888889)) + sin(radians(39.026675888889)) * 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
    • distance95.86msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.069289333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.824195333333)) + sin(radians(39.069289333333)) * 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
    • distance700μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance95.98msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.111902777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.816536777778)) + sin(radians(39.111902777778)) * 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
    • distance84.31msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.154516222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.808878222222)) + sin(radians(39.154516222222)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance520μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance89.9msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.197129666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.801219666667)) + sin(radians(39.197129666667)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance92.09msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.239743111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.793561111111)) + sin(radians(39.239743111111)) * 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
    • distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance90.55msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(39.282356555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-84.785902555556)) + sin(radians(39.282356555556)) * 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
    • distance500μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance1.05msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance640μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance290μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance650μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance590μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance360μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance750μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance400μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance730μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance420μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance710μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance440μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance380μsselect * from "states" where "states"."id" = ? limit 1
    • distance350μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance340μsselect * from "states" where "states"."id" = ? limit 1
    • distance580μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance470μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance790μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance460μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.14msselect * from "images" where "images"."place_id" in (28506)
    • distance520μsselect * from "places" where "places"."id" = ? limit 1
    • distance25.93msselect * from "images" where "images"."place_id" in (33625)
    • distance720μsselect * from "routes" where "origin_destination_id" = ?
    • distance570μsselect exists(select * from (select "id", "route_id", row_number() over (partition by "route_directions"."route_id") as "laravel_row" from "route_directions") as "laravel_table" where "laravel_row" <= 1 order by "laravel_row") as "exists"
    • distance380μsselect * from "route_directions" where "route_directions"."route_id" in (2518661, 2518662) order by "step_index" asc, "step_index" asc
    • distance300μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance1.64msselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance730μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance730μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance310μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance410μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    35RouteWaypoint.php#?
    App\Models\RouteDirection
    25RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Route
    5Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\Image
    4Image.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:46GET/distance/rabbit-hash-iqb2fudj/alert-jbmie7f5382160100