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

Just a moment while we calculate your route...

Distance from Reger to Glenwood

Driving Distance
62.2 mi • 100.1 km
Flying Distance
41.5 mi • 66.8 km
A
B
Leaflet © OpenStreetMap contributors
56 mph avg speed
Northeast direction
1 hr 10 min travel time

Route Information

The driving distance from Reger, Missouri to Glenwood, Missouri is 62.2 mi (100.1 km)

The straight-line (air) distance is 41.5 mi (66.8 km)

The estimated flight time is 0 hr 5 min

The estimated travel time by road is 1 hour 10 minutes

Traveling highway, moderate in a northeast direction. Average speeds around 56 mph.

Location Details

Origin:


No image available
Place Reger
State/Province Missouri
Country US
Latitude 40.143907
Longitude -93.19271
GPS 40.143907° N, 93.19271° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Glenwood
State/Province Missouri
Country US
Latitude 40.517528
Longitude -92.576301
GPS 40.517528° N, 92.576301° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Reger, Missouri to Glenwood, Missouri covers 62.2 mi (100.1 km) in a northeast direction. This highway, moderate route typically takes 1 hour 10 minutes under normal conditions.

Drivers have 2 route options between these locations (54.4-62.2 miles / 88-100 km). The primary route shown here saves 8 minutes compared to alternatives.

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

Available Routes

MO-6 E and US-63 N
62.2 mi 1 hour 10 minutes
Shortest
MO-5 and US Hwy 136 E
54.4 mi 1 hour 2 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

Reger
Missouri , US
Milan
Missouri, US
5.4 mi
Sorrell
Missouri, US
10.3 mi
Green City
Missouri, US
15.3 mi
Pennville
Missouri, US
19.9 mi
Martinstown
Missouri, US
28.9 mi
Worthington
Missouri, US
32.2 mi
Livonia
Missouri, US
35.4 mi
Glenwood
Missouri , US
Messages30RequestTimelineExceptionsViews2Queries155Models86MailsGate
SettingsRequest history5.75sRequest 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/reger-i6b81f4m/glenwood-kalgw2s1
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:21] LOG.warning: No denormalized route found for origin-destination ID: 889903
  • infolog[09:04:21] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 46...
  • infolog[09:04:21] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #1 data for origin-destination ID: 889903 { "origin": "Reg...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 2 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 4 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 2 nested sub-directions for direction index 2
  • infolog[09:04:24] LOG.info: Saved 3 directions for route ID: 2518600
  • infolog[09:04:24] LOG.info: Found a shorter route: 87592 meters for route ID: 2518600
  • infolog[09:04:24] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:24] LOG.info: Processing route #2 data for origin-destination ID: 889903 { "origin": "Reg...
  • infolog[09:04:24] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 2 nested sub-directions for direction index 0
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 6 nested sub-directions for direction index 1
  • debuglog[09:04:24] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:24] LOG.info: Ignoring 1 nested sub-directions for direction index 2
  • infolog[09:04:24] LOG.info: Saved 3 directions for route ID: 2518601
  • infolog[09:04:25] LOG.info: Successfully denormalized route data { "origin_destination_id": 889903, ...
  • infolog[09:04:25] LOG.info: Saved 2 routes for origin-destination ID: 889903
  • infolog[09:04:25] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518600, ...
  • infolog[09:04:25] LOG.info: Incremented view count for route { "id": 2518600, "name": "MO-5 and US ...
  • infolog[09:04:26] LOG.info: Updated denormalized route for route { "route_id": 2518600, "views": 1 ...
  • infolog[09:04:26] LOG.info: Found existing routes { "route_count": 2, "default_route_id": 2518600, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/reger-i6b81f4m/glenwood-kalgw2s1
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
5.76s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:23 [▼
  "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-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "connection" => array:1 [▶
    0 => "Keep-Alive"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.15.219.78"
  ]
  "host" => array:1 [▶
    0 => "routedistance.io"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-ray" => array:1 [▶
    0 => "941a2fc7dc07c97c-IAD"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 18 May 2025 09:04:27 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "txNjCzb81alXx38hrBzGyGi9dgInKLHPAZGPieyg"
]
  • Booting (7.94ms)time
  • Application (5.74s)time
  • Routing (375μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (32μs)
  • 1 x Application (99.86%)
    5.74s
    1 x Booting (0.14%)
    7.94ms
    1 x Routing (0.01%)
    375μs
    1 x Preparing Response (0%)
    32μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    155 statements were executed (100 duplicates)Show only duplicatesdistance2.62s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 55 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance12.88msselect * from "sessions" where "id" = 'yvabyVjvPIF0GMyf4SfZpHIZVoRR5P3tlZD8uqGz' limit 1
      Bindings
      • 0: yvabyVjvPIF0GMyf4SfZpHIZVoRR5P3tlZD8uqGz
      Backtrace
      • vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:96
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:116
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:104
      • vendor/laravel/framework/src/Illuminate/Session/Store.php:88
      • vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:146
    • RouteController.php#548distance6.55msselect * from "places" where "slug" = 'reger' and ("hash" = 'i6b81f4m') limit 1
      Bindings
      • 0: reger
      • 1: i6b81f4m
      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#548distance850μsselect * from "places" where "slug" = 'glenwood' and ("hash" = 'kalgw2s1') limit 1
      Bindings
      • 0: glenwood
      • 1: kalgw2s1
      Backtrace
      • app/Http/Controllers/RouteController.php:548
      • app/Http/Controllers/RouteController.php:60
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • RouteController.php#104distance1.38msselect * from "origin_destinations" where ("origin_id" = 46464 and "destination_id" = 26641) limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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.94msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (46464, 26641, '2025-05-18 09:04:21', '2025-05-18 09:04:21') returning "id"
      Bindings
      • 0: 46464
      • 1: 26641
      • 2: 2025-05-18 09:04:21
      • 3: 2025-05-18 09:04:21
      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.32msselect * from "denormalised_routes" where "origin_destination_id" = 889903 limit 1
      Bindings
      • 0: 889903
      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" = 889903 limit 1) as "exists"
      Bindings
      • 0: 889903
      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#158distance790μsdelete from "routes" where "origin_destination_id" = 889903
      Bindings
      • 0: 889903
      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#172distance480μsselect * from "places" where "places"."id" = 46464 limit 1
      Bindings
      • 0: 46464
      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#173distance410μsselect * from "places" where "places"."id" = 26641 limit 1
      Bindings
      • 0: 26641
      Backtrace
      • app/Services/DistanceCalculationService.php:173
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#225distance1.46msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889903, 'MO-5 and US Hwy 136 E', 87592, 'm', 3749, 0, 'No', 40.1383542, 40.5184987, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889903
      • 1: MO-5 and US Hwy 136 E
      • 2: 87592
      • 3: m
      • 4: 3749
      • 5: 0
      • 6: No
      • 7: 40.138354199999995
      • 8: 40.518498699999995
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance1.16msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518600, 0, 'Take Delta Rd to MO-6 E', 266, 'm', 39, -93.1925374, 40.14289485, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518600
      • 1: 0
      • 2: Take Delta Rd to MO-6 E
      • 3: 266
      • 4: m
      • 5: 39
      • 6: -93.1925374
      • 7: 40.14289485
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#548distance800μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518600, 1, 'Follow MO-5 N and US Hwy 136 E to State Hwy AA in Glenwood Township', 81556, 'm', 3437, -92.90896735, 40.3138926, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518600
      • 1: 1
      • 2: Follow MO-5 N and US Hwy 136 E to State Hwy AA in Glenwood Township
      • 3: 81556
      • 4: m
      • 5: 3437
      • 6: -92.90896735
      • 7: 40.313892599999996
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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 (2518600, 2, 'Follow State Hwy AA to your destination in Glenwood', 5770, 'm', 273, -92.60065775, 40.503008, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518600
      • 1: 2
      • 2: Follow State Hwy AA to your destination in Glenwood
      • 3: 5770
      • 4: m
      • 5: 273
      • 6: -92.60065775
      • 7: 40.503008
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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#225distance960μsinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889903, 'MO-6 E and US-63 N', 100063, 'm', 4202, 0, 'No', 40.1383542, 40.5225361, null, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 889903
      • 1: MO-6 E and US-63 N
      • 2: 100063
      • 3: m
      • 4: 4202
      • 5: 0
      • 6: No
      • 7: 40.138354199999995
      • 8: 40.522536099999996
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:24
      • 12: 2025-05-18 09:04:24
      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#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518601, 0, 'Take Delta Rd to MO-6 E', 266, 'm', 39, -93.1925374, 40.14289485, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518601
      • 1: 0
      • 2: Take Delta Rd to MO-6 E
      • 3: 266
      • 4: m
      • 5: 39
      • 6: -93.1925374
      • 7: 40.14289485
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518601, 1, 'Follow MO-6 E and US-63 N to your destination in Glenwood', 99673, 'm', 4116, -92.8682609, 40.33044515, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518601
      • 1: 1
      • 2: Follow MO-6 E and US-63 N to your destination in Glenwood
      • 3: 99673
      • 4: m
      • 5: 4116
      • 6: -92.8682609
      • 7: 40.330445149999996
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      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 (2518601, 2, '', 124, 'm', 47, -92.5760627, 40.5180813, 0, '2025-05-18 09:04:24', '2025-05-18 09:04:24') returning "id"
      Bindings
      • 0: 2518601
      • 1: 2
      • 2: 
      • 3: 124
      • 4: m
      • 5: 47
      • 6: -92.57606270000001
      • 7: 40.5180813
      • 8: 0
      • 9: 2025-05-18 09:04:24
      • 10: 2025-05-18 09:04:24
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance660μsselect * from "route_waypoints" where "route_id" = 2518600
      Bindings
      • 0: 2518600
      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#103distance340μsselect * from "origin_destinations" where "origin_destinations"."id" = 889903 limit 1
      Bindings
      • 0: 889903
      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#103distance420μsselect * from "places" where "places"."id" = 46464 limit 1
      Bindings
      • 0: 46464
      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" = 26641 limit 1
      Bindings
      • 0: 26641
      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#226distance99.81msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.185420444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.124220111111)) + sin(radians(40.185420444444)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance880μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 12358 limit 1
      Bindings
      • 0: 12358
      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.52msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.226933888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.055730222222)) + sin(radians(40.226933888889)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 87243 limit 1
      Bindings
      • 0: 87243
      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.41msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.268447333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.987240333333)) + sin(radians(40.268447333333)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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" = 19980 limit 1
      Bindings
      • 0: 19980
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance99.92msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.309960777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.918750444444)) + sin(radians(40.309960777778)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#226distance107msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.351474222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.850260555556)) + sin(radians(40.351474222222)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance2.42msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 51990 limit 1
      Bindings
      • 0: 51990
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance110msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.392987666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.781770666667)) + sin(radians(40.392987666667)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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.77msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 86648 limit 1
      Bindings
      • 0: 86648
      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#226distance112msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.434501111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.713280777778)) + sin(radians(40.434501111111)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance580μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 30800 limit 1
      Bindings
      • 0: 30800
      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#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.476014555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.644790888889)) + sin(radians(40.476014555556)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance790μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 31249 limit 1
      Bindings
      • 0: 31249
      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#78distance440μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 12358) limit 1
      Bindings
      • 0: 2518600
      • 1: 12358
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.73msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 12358, 0.11111111111111, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 12358
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance470μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 87243) limit 1
      Bindings
      • 0: 2518600
      • 1: 87243
      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#78distance980μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 87243, 0.22222222222222, 2, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 87243
      • 2: 0.2222222222222222
      • 3: 2
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance390μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 19980) limit 1
      Bindings
      • 0: 2518600
      • 1: 19980
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.01msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 19980, 0.33333333333333, 2, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 19980
      • 2: 0.3333333333333333
      • 3: 2
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 51990) limit 1
      Bindings
      • 0: 2518600
      • 1: 51990
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.07msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 51990, 0.55555555555556, 5, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 51990
      • 2: 0.5555555555555556
      • 3: 5
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 86648) limit 1
      Bindings
      • 0: 2518600
      • 1: 86648
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance1.01msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 86648, 0.66666666666667, 1, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 86648
      • 2: 0.6666666666666666
      • 3: 1
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance330μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 30800) limit 1
      Bindings
      • 0: 2518600
      • 1: 30800
      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#78distance870μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 30800, 0.77777777777778, 2, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 30800
      • 2: 0.7777777777777778
      • 3: 2
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      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" = 2518600 and "place_id" = 31249) limit 1
      Bindings
      • 0: 2518600
      • 1: 31249
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance820μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518600, 31249, 0.88888888888889, 3, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 2518600
      • 1: 31249
      • 2: 0.8888888888888888
      • 3: 3
      • 4: 2025-05-18 09:04:25
      • 5: 2025-05-18 09:04:25
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#366distance560μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518600 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518600
      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#45distance370μsselect * from "denormalised_routes" where "origin_destination_id" = 889903 limit 1
      Bindings
      • 0: 889903
      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#123distance570μsselect * from "route_directions" where "route_directions"."route_id" = 2518600 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518600
      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#198distance430μsselect * from "locations" where "locations"."id" = 46464 limit 1
      Bindings
      • 0: 46464
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:153
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance500μsselect * from "cities" where "cities"."id" = 23739 limit 1
      Bindings
      • 0: 23739
      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#215distance300μsselect * from "states" where "states"."id" = 35 limit 1
      Bindings
      • 0: 35
      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#330distance300μ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#198distance310μsselect * from "locations" where "locations"."id" = 26641 limit 1
      Bindings
      • 0: 26641
      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#198distance270μsselect * from "cities" where "cities"."id" = 3875 limit 1
      Bindings
      • 0: 3875
      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#215distance280μsselect * from "states" where "states"."id" = 35 limit 1
      Bindings
      • 0: 35
      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#330distance260μ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.75msinsert 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 (46464, 'Reger', 'Reger, MO 63556', 'reger', 'i6b81f4m', 40.143907, -93.19271, 'Reger', 'Missouri', 'US', 'America/Chicago', 26641, 'Glenwood', 'Glenwood, MO 63541', 'glenwood', 'kalgw2s1', 40.517528, -92.576301, 'Glenwood', 'Missouri', 'US', 'America/Chicago', 2518600, 'MO-5 and US Hwy 136 E', 87592, 'm', 3749, 54.427128632, 87592, '1 hour 2 minutes', '1 hour 2 minutes', 87.592, '87.6 km', null, 62, 0, 'No', '54.4 mi', 41.478833523481, 0.041478833523481, '"[{\"id\":8350437,\"route_id\":2518600,\"step_index\":\"0\",\"instruction\":\"Take Delta Rd to MO-6 E\",\"distance\":266,\"distance_unit\":\"m\",\"time\":\"39\",\"latitude\":-93.1925374,\"longitude\":40.1428949,\"is_sub_step\":false},{\"id\":8350438,\"route_id\":2518600,\"step_index\":\"1\",\"instruction\":\"Follow MO-5 N and US Hwy 136 E to State Hwy AA in Glenwood Township\",\"distance\":81556,\"distance_unit\":\"m\",\"time\":\"3437\",\"latitude\":-92.9089674,\"longitude\":40.3138926,\"is_sub_step\":false},{\"id\":8350439,\"route_id\":2518600,\"step_index\":\"2\",\"instruction\":\"Follow State Hwy AA to your destination in Glenwood\",\"distance\":5770,\"distance_unit\":\"m\",\"time\":\"273\",\"latitude\":-92.6006578,\"longitude\":40.503008,\"is_sub_step\":false}]"', 87592, 87592, '8 minutes', 0, 'northeast', 'southwest', '[{"name":"Milan","description":"59 mi to destination","state":"Missouri","country":"US","full_address":"Milan, MO 63556","lat":"40.202241","lng":"-93.125209","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":12358,"slug":"milan","hash":"vd40ybym"},{"name":"Sorrell","description":"Traveled 15 mi from origin","state":"Missouri","country":"US","full_address":"Sorrell, MO 63545","lat":"40.215020","lng":"-93.020485","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":87243,"slug":"sorrell","hash":"bejd81vf"},{"name":"Green City","description":"45 mi to destination","state":"Missouri","country":"US","full_address":"Green City, MO 63545","lat":"40.268632","lng":"-92.953261","fraction":0.3333333333333333,"type":"City","distance_km":2,"place_id":19980,"slug":"green-city","hash":"jmtp7m29"},{"name":"Pennville","description":"30 mi to destination","state":"Missouri","country":"US","full_address":"Pennville, MO 63545","lat":"40.362798","lng":"-92.946871","fraction":0.5555555555555556,"type":"City","distance_km":5,"place_id":51990,"slug":"pennville","hash":"u1ix2w8h"},{"name":"Martinstown","description":"Traveled 45 mi from origin","state":"Missouri","country":"US","full_address":"Martinstown, MO 63565","lat":"40.410580","lng":"-92.770476","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":86648,"slug":"martinstown","hash":"k1qboyab"},{"name":"Worthington","description":"15 mi to destination","state":"Missouri","country":"US","full_address":"Worthington, MO 63567","lat":"40.408360","lng":"-92.688807","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":30800,"slug":"worthington","hash":"8xf97h85"},{"name":"Livonia","description":"Traveled 59 mi from origin","state":"Missouri","country":"US","full_address":"Livonia, MO 63551","lat":"40.491414","lng":"-92.700195","fraction":0.8888888888888888,"type":"City","distance_km":3,"place_id":31249,"slug":"livonia","hash":"h2rkbhva"}]', 1, 7, '{"distanceInMiles":54.427280748629876,"distanceMilesFormatted":"54.4 miles","distanceFormatted":"54.4 miles","distanceKmFormatted":"88 km","timeHours":1.0333333333333334,"timeFormatted":"1 hour 2 minutes","avgSpeed":56,"routeDescriptors":["highway","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northeast"}', null, 'reger-i6b81f4m/glenwood-kalgw2s1', 0, null, null, 0, '"[{\"name\":\"Milan\",\"description\":\"59 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Milan, MO 63556\",\"lat\":\"40.202241\",\"lng\":\"-93.125209\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":12358,\"slug\":\"milan\",\"hash\":\"vd40ybym\"},{\"name\":\"Sorrell\",\"description\":\"Traveled 15 mi from origin\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Sorrell, MO 63545\",\"lat\":\"40.215020\",\"lng\":\"-93.020485\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":87243,\"slug\":\"sorrell\",\"hash\":\"bejd81vf\"},{\"name\":\"Green City\",\"description\":\"45 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Green City, MO 63545\",\"lat\":\"40.268632\",\"lng\":\"-92.953261\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":2,\"place_id\":19980,\"slug\":\"green-city\",\"hash\":\"jmtp7m29\"},{\"name\":\"Pennville\",\"description\":\"30 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Pennville, MO 63545\",\"lat\":\"40.362798\",\"lng\":\"-92.946871\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":5,\"place_id\":51990,\"slug\":\"pennville\",\"hash\":\"u1ix2w8h\"},{\"name\":\"Martinstown\",\"description\":\"Traveled 45 mi from origin\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Martinstown, MO 63565\",\"lat\":\"40.410580\",\"lng\":\"-92.770476\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":86648,\"slug\":\"martinstown\",\"hash\":\"k1qboyab\"},{\"name\":\"Worthington\",\"description\":\"15 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Worthington, MO 63567\",\"lat\":\"40.408360\",\"lng\":\"-92.688807\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":30800,\"slug\":\"worthington\",\"hash\":\"8xf97h85\"},{\"name\":\"Livonia\",\"description\":\"Traveled 59 mi from origin\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Livonia, MO 63551\",\"lat\":\"40.491414\",\"lng\":\"-92.700195\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":3,\"place_id\":31249,\"slug\":\"livonia\",\"hash\":\"h2rkbhva\"}]"', 3, 889903, '2025-05-18 09:04:25', '2025-05-18 09:04:25') returning "id"
      Bindings
      • 0: 46464
      • 1: Reger
      • 2: Reger, MO 63556
      • 3: reger
      • 4: i6b81f4m
      • 5: 40.143907
      • 6: -93.19271
      • 7: Reger
      • 8: Missouri
      • 9: US
      • 10: America/Chicago
      • 11: 26641
      • 12: Glenwood
      • 13: Glenwood, MO 63541
      • 14: glenwood
      • 15: kalgw2s1
      • 16: 40.517528
      • 17: -92.576301
      • 18: Glenwood
      • 19: Missouri
      • 20: US
      • 21: America/Chicago
      • 22: 2518600
      • 23: MO-5 and US Hwy 136 E
      • 24: 87592
      • 25: m
      • 26: 3749
      • 27: 54.427128632
      • 28: 87592
      • 29: 1 hour 2 minutes
      • 30: 1 hour 2 minutes
      • 31: 87.592
      • 32: 87.6 km
      • 33: 
      • 34: 62
      • 35: 0
      • 36: No
      • 37: 54.4 mi
      • 38: 41.47883352348086
      • 39: 0.041478833523480856
      • 40: "[{\"id\":8350437,\"route_id\":2518600,\"step_index\":\"0\",\"instruction\":\"Take Delta Rd to MO-6 E\",\"distance\":266,\"distance_unit\":\"m\",\"time\":\"39\",\"latitude\":-93.1925374,\"longitude\":40.1428949,\"is_sub_step\":false},{\"id\":8350438,\"route_id\":2518600,\"step_index\":\"1\",\"instruction\":\"Follow MO-5 N and US Hwy 136 E to State Hwy AA in Glenwood Township\",\"distance\":81556,\"distance_unit\":\"m\",\"time\":\"3437\",\"latitude\":-92.9089674,\"longitude\":40.3138926,\"is_sub_step\":false},{\"id\":8350439,\"route_id\":2518600,\"step_index\":\"2\",\"instruction\":\"Follow State Hwy AA to your destination in Glenwood\",\"distance\":5770,\"distance_unit\":\"m\",\"time\":\"273\",\"latitude\":-92.6006578,\"longitude\":40.503008,\"is_sub_step\":false}]"
      • 41: 87592
      • 42: 87592
      • 43: 8 minutes
      • 44: 0
      • 45: northeast
      • 46: southwest
      • 47: [{"name":"Milan","description":"59 mi to destination","state":"Missouri","country":"US","full_address":"Milan, MO 63556","lat":"40.202241","lng":"-93.125209","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":12358,"slug":"milan","hash":"vd40ybym"},{"name":"Sorrell","description":"Traveled 15 mi from origin","state":"Missouri","country":"US","full_address":"Sorrell, MO 63545","lat":"40.215020","lng":"-93.020485","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":87243,"slug":"sorrell","hash":"bejd81vf"},{"name":"Green City","description":"45 mi to destination","state":"Missouri","country":"US","full_address":"Green City, MO 63545","lat":"40.268632","lng":"-92.953261","fraction":0.3333333333333333,"type":"City","distance_km":2,"place_id":19980,"slug":"green-city","hash":"jmtp7m29"},{"name":"Pennville","description":"30 mi to destination","state":"Missouri","country":"US","full_address":"Pennville, MO 63545","lat":"40.362798","lng":"-92.946871","fraction":0.5555555555555556,"type":"City","distance_km":5,"place_id":51990,"slug":"pennville","hash":"u1ix2w8h"},{"name":"Martinstown","description":"Traveled 45 mi from origin","state":"Missouri","country":"US","full_address":"Martinstown, MO 63565","lat":"40.410580","lng":"-92.770476","fraction":0.6666666666666666,"type":"City","distance_km":1,"place_id":86648,"slug":"martinstown","hash":"k1qboyab"},{"name":"Worthington","description":"15 mi to destination","state":"Missouri","country":"US","full_address":"Worthington, MO 63567","lat":"40.408360","lng":"-92.688807","fraction":0.7777777777777778,"type":"City","distance_km":2,"place_id":30800,"slug":"worthington","hash":"8xf97h85"},{"name":"Livonia","description":"Traveled 59 mi from origin","state":"Missouri","country":"US","full_address":"Livonia, MO 63551","lat":"40.491414","lng":"-92.700195","fraction":0.8888888888888888,"type":"City","distance_km":3,"place_id":31249,"slug":"livonia","hash":"h2rkbhva"}]
      • 48: 1
      • 49: 7
      • 50: {"distanceInMiles":54.427280748629876,"distanceMilesFormatted":"54.4 miles","distanceFormatted":"54.4 miles","distanceKmFormatted":"88 km","timeHours":1.0333333333333334,"timeFormatted":"1 hour 2 minutes","avgSpeed":56,"routeDescriptors":["highway","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northeast"}
      • 51: 
      • 52: reger-i6b81f4m/glenwood-kalgw2s1
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Milan\",\"description\":\"59 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Milan, MO 63556\",\"lat\":\"40.202241\",\"lng\":\"-93.125209\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":12358,\"slug\":\"milan\",\"hash\":\"vd40ybym\"},{\"name\":\"Sorrell\",\"description\":\"Traveled 15 mi from origin\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Sorrell, MO 63545\",\"lat\":\"40.215020\",\"lng\":\"-93.020485\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":87243,\"slug\":\"sorrell\",\"hash\":\"bejd81vf\"},{\"name\":\"Green City\",\"description\":\"45 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Green City, MO 63545\",\"lat\":\"40.268632\",\"lng\":\"-92.953261\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":2,\"place_id\":19980,\"slug\":\"green-city\",\"hash\":\"jmtp7m29\"},{\"name\":\"Pennville\",\"description\":\"30 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Pennville, MO 63545\",\"lat\":\"40.362798\",\"lng\":\"-92.946871\",\"fraction\":0.5555555555555556,\"type\":\"City\",\"distance_km\":5,\"place_id\":51990,\"slug\":\"pennville\",\"hash\":\"u1ix2w8h\"},{\"name\":\"Martinstown\",\"description\":\"Traveled 45 mi from origin\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Martinstown, MO 63565\",\"lat\":\"40.410580\",\"lng\":\"-92.770476\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":1,\"place_id\":86648,\"slug\":\"martinstown\",\"hash\":\"k1qboyab\"},{\"name\":\"Worthington\",\"description\":\"15 mi to destination\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Worthington, MO 63567\",\"lat\":\"40.408360\",\"lng\":\"-92.688807\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":2,\"place_id\":30800,\"slug\":\"worthington\",\"hash\":\"8xf97h85\"},{\"name\":\"Livonia\",\"description\":\"Traveled 59 mi from origin\",\"state\":\"Missouri\",\"country\":\"US\",\"full_address\":\"Livonia, MO 63551\",\"lat\":\"40.491414\",\"lng\":\"-92.700195\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":3,\"place_id\":31249,\"slug\":\"livonia\",\"hash\":\"h2rkbhva\"}]"
      • 58: 3
      • 59: 889903
      • 60: 2025-05-18 09:04:25
      • 61: 2025-05-18 09:04:25
      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#70distance490μsselect exists(select "id" from "routes" where "origin_destination_id" = 889903 limit 1) as "exists"
      Bindings
      • 0: 889903
      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#1186distance730μsselect * from "routes" where "routes"."origin_destination_id" = 889903 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889903
      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#1186distance510μsselect * from "route_directions" where "route_directions"."route_id" in (2518600, 2518601) order by "step_index" asc, "step_index" asc
      Backtrace
      • app/Services/DistanceCalculationService.php:1186
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • Route.php#225distance1.15msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:25' where "id" = 2518600
      Bindings
      • 0: 2025-05-18 09:04:25
      • 1: 2518600
      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#235distance440μsselect * from "origin_destinations" where "origin_destinations"."id" = 889903 limit 1
      Bindings
      • 0: 889903
      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#244distance480μsselect * from "places" where "places"."id" = 46464 limit 1
      Bindings
      • 0: 46464
      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#245distance520μsselect * from "places" where "places"."id" = 26641 limit 1
      Bindings
      • 0: 26641
      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#24distance1.07msselect * from "route_waypoints" where "route_id" = 2518600
      Bindings
      • 0: 2518600
      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#103distance6.34msselect * from "places" where "places"."id" = 46464 limit 1
      Bindings
      • 0: 46464
      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#104distance520μsselect * from "places" where "places"."id" = 26641 limit 1
      Bindings
      • 0: 26641
      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#226distance175msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.185420444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.124220111111)) + sin(radians(40.185420444444)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance820μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 12358 limit 1
      Bindings
      • 0: 12358
      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#226distance104msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.226933888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.055730222222)) + sin(radians(40.226933888889)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 87243 limit 1
      Bindings
      • 0: 87243
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance97.19msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.268447333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.987240333333)) + sin(radians(40.268447333333)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance680μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 19980 limit 1
      Bindings
      • 0: 19980
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance93.66msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.309960777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.918750444444)) + sin(radians(40.309960777778)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#226distance91.22msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.351474222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.850260555556)) + sin(radians(40.351474222222)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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.1msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 51990 limit 1
      Bindings
      • 0: 51990
      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.2msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.392987666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.781770666667)) + sin(radians(40.392987666667)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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" = 86648 limit 1
      Bindings
      • 0: 86648
      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#226distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.434501111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.713280777778)) + sin(radians(40.434501111111)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      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#158distance790μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 30800 limit 1
      Bindings
      • 0: 30800
      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#226distance100msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.476014555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.644790888889)) + sin(radians(40.476014555556)) * 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" != 46464 and "places"."id" != 26641 order by "distance" asc limit 1
      Bindings
      • 0: 46464
      • 1: 26641
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance750μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 31249 limit 1
      Bindings
      • 0: 31249
      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#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 12358) limit 1
      Bindings
      • 0: 2518600
      • 1: 12358
      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#78distance960μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300243
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:26
      • 2: 6300243
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 87243) limit 1
      Bindings
      • 0: 2518600
      • 1: 87243
      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#78distance920μsupdate "route_waypoints" set "fraction" = 0.22222222222222, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300244
      Bindings
      • 0: 0.2222222222222222
      • 1: 2025-05-18 09:04:26
      • 2: 6300244
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance340μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 19980) limit 1
      Bindings
      • 0: 2518600
      • 1: 19980
      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#78distance730μsupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300245
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:26
      • 2: 6300245
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 51990) limit 1
      Bindings
      • 0: 2518600
      • 1: 51990
      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#78distance670μsupdate "route_waypoints" set "fraction" = 0.55555555555556, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300246
      Bindings
      • 0: 0.5555555555555556
      • 1: 2025-05-18 09:04:26
      • 2: 6300246
      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#78distance370μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 86648) limit 1
      Bindings
      • 0: 2518600
      • 1: 86648
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance620μsupdate "route_waypoints" set "fraction" = 0.66666666666667, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300247
      Bindings
      • 0: 0.6666666666666666
      • 1: 2025-05-18 09:04:26
      • 2: 6300247
      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#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518600 and "place_id" = 30800) limit 1
      Bindings
      • 0: 2518600
      • 1: 30800
      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#78distance630μsupdate "route_waypoints" set "fraction" = 0.77777777777778, "updated_at" = '2025-05-18 09:04:26' where "id" = 6300248
      Bindings
      • 0: 0.7777777777777778
      • 1: 2025-05-18 09:04:26
      • 2: 6300248
      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
    • distance360μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance790μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance660μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance380μsselect * from "route_waypoints" where "route_id" = ?
    • distance420μsselect * from "places" where "places"."id" = ? limit 1
    • distance330μsselect * from "places" where "places"."id" = ? limit 1
    • distance101msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.185420444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.124220111111)) + sin(radians(40.185420444444)) * 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
    • distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance93.66msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.226933888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-93.055730222222)) + sin(radians(40.226933888889)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance630μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance97.56msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.268447333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.987240333333)) + sin(radians(40.268447333333)) * 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
    • distance710μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance109msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.309960777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.918750444444)) + sin(radians(40.309960777778)) * 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
    • distance103msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.351474222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.850260555556)) + sin(radians(40.351474222222)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance790μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance103msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.392987666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.781770666667)) + sin(radians(40.392987666667)) * 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
    • distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance98.3msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.434501111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.713280777778)) + sin(radians(40.434501111111)) * 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
    • distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance89.87msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(40.476014555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-92.644790888889)) + sin(radians(40.476014555556)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance620μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance880μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance570μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance380μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance1.27msupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance320μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance620μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance290μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance580μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance600μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance280μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance550μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance290μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance250μsselect * from "states" where "states"."id" = ? limit 1
    • distance230μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance210μsselect * from "states" where "states"."id" = ? limit 1
    • distance470μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance330μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance670μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance410μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.83msselect * from "images" where "images"."place_id" in (46464)
    • distance560μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.28msselect * from "images" where "images"."place_id" in (26641)
    • distance580μsselect * from "routes" where "origin_destination_id" = ?
    • distance620μ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"
    • distance440μsselect * from "route_directions" where "route_directions"."route_id" in (2518600, 2518601) order by "step_index" asc, "step_index" asc
    • distance310μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance320μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance560μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance330μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance300μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance430μ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
    15RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Route
    5Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:27GET/distance/reger-i6b81f4m/glenwood-kalgw2s130215586