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

Just a moment while we calculate your route...

Distance from Markham to Litton

Driving Distance
31.7 mi 51 km
Flying Distance
23.0 mi 37.1 km
A
B
Leaflet © OpenStreetMap contributors

Route Information

The driving distance from Markham, Mississippi to Litton, Mississippi is 31.7 mi (51 km)

The straight-line (air) distance is 23.0 mi (37.1 km)

The estimated flight time is 0 hr 3 min

The estimated travel time by road is 37 minutes

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

Location Details

Origin:


No image available
Place Markham
State/Province Mississippi
Country US
Latitude 33.404842
Longitude -90.5612
GPS 33.404842° N, 90.5612° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:


No image available
Place Litton
State/Province Mississippi
Country US
Latitude 33.645947
Longitude -90.837322
GPS 33.645947° N, 90.837322° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Markham, Mississippi to Litton, Mississippi covers 31.7 mi (51 km) in a northwest direction. This mixed highways and local roads, moderate route typically takes 37 minutes under normal conditions.

Drivers have 3 route options between these locations (31.6-35.1 miles / 51-56 km). The primary route shown here saves 4 minutes compared to alternatives.

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

Available Routes

US-49W N and MS-448 W
31.7 mi 37 minutes
Shortest
US-82 W and MS-448 W
35.1 mi 41 minutes
MS-448 W
31.6 mi 37 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.

SettingsRequest history4.14sRequest 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/markham-gvapenoc/litton-c39ovap4
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[09:04:28] LOG.warning: No denormalized route found for origin-destination ID: 889910
  • infolog[09:04:28] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 51...
  • infolog[09:04:28] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:29] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:29] LOG.info: Processing route #1 data for origin-destination ID: 889910 { "origin": "Mar...
  • infolog[09:04:29] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:29] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:29] LOG.info: Ignoring 6 nested sub-directions for direction index 0
  • debuglog[09:04:29] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:29] LOG.info: Ignoring 1 nested sub-directions for direction index 1
  • debuglog[09:04:29] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:29] LOG.info: Ignoring 1 nested sub-directions for direction index 2
  • infolog[09:04:29] LOG.info: Saved 3 directions for route ID: 2518612
  • infolog[09:04:29] LOG.info: Found a shorter route: 50814 meters for route ID: 2518612
  • infolog[09:04:29] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:29] LOG.info: Processing route #2 data for origin-destination ID: 889910 { "origin": "Mar...
  • infolog[09:04:29] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:29] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:29] LOG.info: Ignoring 7 nested sub-directions for direction index 0
  • infolog[09:04:29] LOG.info: Saved 1 directions for route ID: 2518613
  • infolog[09:04:29] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:29] LOG.info: Processing route #3 data for origin-destination ID: 889910 { "origin": "Mar...
  • infolog[09:04:29] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:29] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:29] LOG.info: Ignoring 6 nested sub-directions for direction index 0
  • infolog[09:04:29] LOG.info: Saved 1 directions for route ID: 2518614
  • infolog[09:04:30] LOG.info: Successfully denormalized route data { "origin_destination_id": 889910, ...
  • infolog[09:04:30] LOG.info: Saved 3 routes for origin-destination ID: 889910
  • infolog[09:04:30] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518612, ...
  • infolog[09:04:30] LOG.info: Incremented view count for route { "id": 2518612, "name": "MS-448 W", ...
  • infolog[09:04:31] LOG.info: Updated denormalized route for route { "route_id": 2518612, "views": 1 ...
  • infolog[09:04:31] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518612, ...
status
200 OK
full_url
https://routedistance.io/distance/markham-gvapenoc/litton-c39ovap4
action_name
distance.show
controller_action
App\Http\Controllers\RouteController@show
uri
GET distance/{origin}/{destination}
controller
App\Http\Controllers\RouteController@show
file
app/Http/Controllers/RouteController.php:52-140
middleware
web
duration
4.15s
peak_memory
4MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
0 of 0
array:23 [ "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "Keep-Alive" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-connecting-ip" => array:1 [ 0 => "3.15.219.78" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "x-forwarded-for" => array:1 [ 0 => "3.15.219.78" ] "host" => array:1 [ 0 => "routedistance.io" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "cf-ray" => array:1 [ 0 => "941a2ff03b86c985-IAD" ] ]
request_cookies
[]
response_headers
0 of 0
array:3 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 18 May 2025 09:04:32 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] ]
session_attributes
0 of 0
array:1 [ "_token" => "Bda3yv3HoE4G5WP6OVba6fqJ0jZRxKWpLd1tnKb5" ]
  • Booting (15.18ms)time
  • Application (4.12s)time
  • Routing (371μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (35μs)
  • 1 x Application (99.63%)
    4.12s
    1 x Booting (0.37%)
    15.18ms
    1 x Routing (0.01%)
    371μs
    1 x Preparing Response (0%)
    35μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    137 statements were executed (92 duplicates)Show only duplicatesdistance2.4s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 37 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance14.53msselect * from "sessions" where "id" = 'DUFp7FvABRfiPkmPbmi1Q9PR51RppLU1A4EwLrOA' limit 1
      Bindings
      • 0: DUFp7FvABRfiPkmPbmi1Q9PR51RppLU1A4EwLrOA
      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" = 'markham' and ("hash" = 'gvapenoc') limit 1
      Bindings
      • 0: markham
      • 1: gvapenoc
      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#548distance550μsselect * from "places" where "slug" = 'litton' and ("hash" = 'c39ovap4') limit 1
      Bindings
      • 0: litton
      • 1: c39ovap4
      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#104distance790μsselect * from "origin_destinations" where ("origin_id" = 51806 and "destination_id" = 38256) limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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.88msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (51806, 38256, '2025-05-18 09:04:28', '2025-05-18 09:04:28') returning "id"
      Bindings
      • 0: 51806
      • 1: 38256
      • 2: 2025-05-18 09:04:28
      • 3: 2025-05-18 09:04:28
      Backtrace
      • app/Http/Controllers/RouteController.php:104
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
    • RouteDenormalisationService.php#256distance1.53msselect * from "denormalised_routes" where "origin_destination_id" = 889910 limit 1
      Bindings
      • 0: 889910
      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" = 889910 limit 1) as "exists"
      Bindings
      • 0: 889910
      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#158distance980μsdelete from "routes" where "origin_destination_id" = 889910
      Bindings
      • 0: 889910
      Backtrace
      • app/Services/DistanceCalculationService.php:158
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#172distance630μsselect * from "places" where "places"."id" = 51806 limit 1
      Bindings
      • 0: 51806
      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#173distance450μsselect * from "places" where "places"."id" = 38256 limit 1
      Bindings
      • 0: 38256
      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.6msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889910, 'MS-448 W', 50814, 'm', 2262, 0, 'No', 33.3779565, 33.6459471, null, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 889910
      • 1: MS-448 W
      • 2: 50814
      • 3: m
      • 4: 2262
      • 5: 0
      • 6: No
      • 7: 33.377956499999996
      • 8: 33.6459471
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:29
      • 12: 2025-05-18 09:04:29
      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.28msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518612, 0, 'Take US-49W N and MS-448 W to Gilbert Rd in Bolivar County', 41139, 'm', 1808, -90.67124365, 33.492033, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 2518612
      • 1: 0
      • 2: Take US-49W N and MS-448 W to Gilbert Rd in Bolivar County
      • 3: 41139
      • 4: m
      • 5: 1808
      • 6: -90.67124365
      • 7: 33.49203299999999
      • 8: 0
      • 9: 2025-05-18 09:04:29
      • 10: 2025-05-18 09:04:29
      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 (2518612, 1, '', 4427, 'm', 206, -90.78090855, 33.62600785, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 2518612
      • 1: 1
      • 2: 
      • 3: 4427
      • 4: m
      • 5: 206
      • 6: -90.78090854999999
      • 7: 33.62600784999999
      • 8: 0
      • 9: 2025-05-18 09:04:29
      • 10: 2025-05-18 09:04:29
      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 (2518612, 2, '', 5248, 'm', 248, -90.80897695, 33.64590705, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 2518612
      • 1: 2
      • 2: 
      • 3: 5248
      • 4: m
      • 5: 248
      • 6: -90.80897695
      • 7: 33.645907050000005
      • 8: 0
      • 9: 2025-05-18 09:04:29
      • 10: 2025-05-18 09:04:29
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance1.32msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889910, 'US-49W N and MS-448 W', 50984, 'm', 2272, 0, 'No', 33.3779565, 33.6459471, null, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 889910
      • 1: US-49W N and MS-448 W
      • 2: 50984
      • 3: m
      • 4: 2272
      • 5: 0
      • 6: No
      • 7: 33.377956499999996
      • 8: 33.6459471
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:29
      • 12: 2025-05-18 09:04:29
      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#548distance850μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518613, 0, '', 50984, 'm', 2272, -90.69931205, 33.5119464, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 2518613
      • 1: 0
      • 2: 
      • 3: 50984
      • 4: m
      • 5: 2272
      • 6: -90.69931204999999
      • 7: 33.5119464
      • 8: 0
      • 9: 2025-05-18 09:04:29
      • 10: 2025-05-18 09:04:29
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#225distance1.04msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889910, 'US-82 W and MS-448 W', 56476, 'm', 2491, 0, 'No', 33.404842, 33.6459471, null, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 889910
      • 1: US-82 W and MS-448 W
      • 2: 56476
      • 3: m
      • 4: 2491
      • 5: 0
      • 6: No
      • 7: 33.404841999999995
      • 8: 33.6459471
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:29
      • 12: 2025-05-18 09:04:29
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance730μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518614, 0, '', 56476, 'm', 2491, -90.67122175, 33.5254476, 0, '2025-05-18 09:04:29', '2025-05-18 09:04:29') returning "id"
      Bindings
      • 0: 2518614
      • 1: 0
      • 2: 
      • 3: 56476
      • 4: m
      • 5: 2491
      • 6: -90.67122174999999
      • 7: 33.5254476
      • 8: 0
      • 9: 2025-05-18 09:04:29
      • 10: 2025-05-18 09:04:29
      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#24distance640μsselect * from "route_waypoints" where "route_id" = 2518612
      Bindings
      • 0: 2518612
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#103distance450μsselect * from "origin_destinations" where "origin_destinations"."id" = 889910 limit 1
      Bindings
      • 0: 889910
      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#103distance440μsselect * from "places" where "places"."id" = 51806 limit 1
      Bindings
      • 0: 51806
      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#104distance360μsselect * from "places" where "places"."id" = 38256 limit 1
      Bindings
      • 0: 38256
      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#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.431631444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.591880222222)) + sin(radians(33.431631444444)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#158distance970μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 84665 limit 1
      Bindings
      • 0: 84665
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance88.98msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.458420888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.622560444444)) + sin(radians(33.458420888889)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 4619 limit 1
      Bindings
      • 0: 4619
      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#226distance96.54msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.485210333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.653240666667)) + sin(radians(33.485210333333)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#226distance95.96msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.511999777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.683920888889)) + sin(radians(33.511999777778)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 64422 limit 1
      Bindings
      • 0: 64422
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.61msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.538789222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.714601111111)) + sin(radians(33.538789222222)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance690μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 96828 limit 1
      Bindings
      • 0: 96828
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance93.99msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.565578666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.745281333333)) + sin(radians(33.565578666667)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#226distance89.57msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.592368111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.775961555556)) + sin(radians(33.592368111111)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#158distance490μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 13580 limit 1
      Bindings
      • 0: 13580
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance94.66msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.619157555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.806641777778)) + sin(radians(33.619157555556)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#78distance860μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 84665) limit 1
      Bindings
      • 0: 2518612
      • 1: 84665
      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.56msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518612, 84665, 0.11111111111111, 1, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518612
      • 1: 84665
      • 2: 0.1111111111111111
      • 3: 1
      • 4: 2025-05-18 09:04:30
      • 5: 2025-05-18 09:04:30
      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#78distance440μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 4619) limit 1
      Bindings
      • 0: 2518612
      • 1: 4619
      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#78distance1msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518612, 4619, 0.22222222222222, 2, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518612
      • 1: 4619
      • 2: 0.2222222222222222
      • 3: 2
      • 4: 2025-05-18 09:04:30
      • 5: 2025-05-18 09:04:30
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 64422) limit 1
      Bindings
      • 0: 2518612
      • 1: 64422
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance4.67msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518612, 64422, 0.44444444444444, 3, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518612
      • 1: 64422
      • 2: 0.4444444444444444
      • 3: 3
      • 4: 2025-05-18 09:04:30
      • 5: 2025-05-18 09:04:30
      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#78distance410μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 96828) limit 1
      Bindings
      • 0: 2518612
      • 1: 96828
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance970μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518612, 96828, 0.55555555555556, 2, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518612
      • 1: 96828
      • 2: 0.5555555555555556
      • 3: 2
      • 4: 2025-05-18 09:04:30
      • 5: 2025-05-18 09:04:30
      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" = 2518612 and "place_id" = 13580) limit 1
      Bindings
      • 0: 2518612
      • 1: 13580
      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.98msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518612, 13580, 0.77777777777778, 1, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 2518612
      • 1: 13580
      • 2: 0.7777777777777778
      • 3: 1
      • 4: 2025-05-18 09:04:30
      • 5: 2025-05-18 09:04:30
      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#366distance4.85msselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518612 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518612
      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#45distance590μsselect * from "denormalised_routes" where "origin_destination_id" = 889910 limit 1
      Bindings
      • 0: 889910
      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" = 2518612 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518612
      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#198distance330μsselect * from "locations" where "locations"."id" = 51806 limit 1
      Bindings
      • 0: 51806
      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#215distance330μsselect * from "states" where "states"."id" = 43 limit 1
      Bindings
      • 0: 43
      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#330distance3.38msselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:155
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance340μsselect * from "locations" where "locations"."id" = 38256 limit 1
      Bindings
      • 0: 38256
      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#198distance4.19msselect * from "cities" where "cities"."id" = 21654 limit 1
      Bindings
      • 0: 21654
      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#215distance320μsselect * from "states" where "states"."id" = 43 limit 1
      Bindings
      • 0: 43
      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#330distance270μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance1.92msinsert 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 (51806, 'Markham', 'Markham, MS 38761', 'markham', 'gvapenoc', 33.404842, -90.5612, null, 'Mississippi', 'US', 'America/Chicago', 38256, 'Litton', 'Litton, MS 38730', 'litton', 'c39ovap4', 33.645947, -90.837322, 'Litton', 'Mississippi', 'US', 'America/Chicago', 2518612, 'MS-448 W', 50814, 'm', 2262, 31.574345994, 50814, '37 minutes', '37 minutes', 50.814, '50.8 km', null, 38, 0, 'No', '31.6 mi', 23.0317426339, 0.0230317426339, '"[{\"id\":8350474,\"route_id\":2518612,\"step_index\":\"0\",\"instruction\":\"Take US-49W N and MS-448 W to Gilbert Rd in Bolivar County\",\"distance\":41139,\"distance_unit\":\"m\",\"time\":\"1808\",\"latitude\":-90.6712437,\"longitude\":33.492033,\"is_sub_step\":false},{\"id\":8350475,\"route_id\":2518612,\"step_index\":\"1\",\"instruction\":\"\",\"distance\":4427,\"distance_unit\":\"m\",\"time\":\"206\",\"latitude\":-90.7809086,\"longitude\":33.6260079,\"is_sub_step\":false},{\"id\":8350476,\"route_id\":2518612,\"step_index\":\"2\",\"instruction\":\"\",\"distance\":5248,\"distance_unit\":\"m\",\"time\":\"248\",\"latitude\":-90.808977,\"longitude\":33.6459071,\"is_sub_step\":false}]"', 50814, 50814, '4 minutes', 0, 'northwest', 'southeast', '[{"name":"Baird","description":"33 mi to destination","state":"Mississippi","country":"US","full_address":"Baird, MS 38751","lat":"33.425119","lng":"-90.583423","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":84665,"slug":"baird","hash":"h60e7omz"},{"name":"Indianola","description":"Traveled 8 mi from origin","state":"Mississippi","country":"US","full_address":"Indianola, MS 38751","lat":"33.450951","lng":"-90.655092","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":4619,"slug":"indianola","hash":"upb9hfdl"},{"name":"Boyer","description":"Traveled 16 mi from origin","state":"Mississippi","country":"US","full_address":"Boyer, MS 38751","lat":"33.536784","lng":"-90.637869","fraction":0.4444444444444444,"type":"City","distance_km":3,"place_id":64422,"slug":"boyer","hash":"6tzfz29u"},{"name":"Frazier","description":"16 mi to destination","state":"Mississippi","country":"US","full_address":"Frazier, MS 38773","lat":"33.567060","lng":"-90.732039","fraction":0.5555555555555556,"type":"State","distance_km":2,"place_id":96828,"slug":"frazier","hash":"hnh54dbs"},{"name":"Shaw","description":"8 mi to destination","state":"Mississippi","country":"US","full_address":"Shaw, MS 38773","lat":"33.601782","lng":"-90.773708","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":13580,"slug":"shaw","hash":"x1lrhqm2"}]', 1, 5, '{"distanceInMiles":31.57443424012328,"distanceMilesFormatted":"31.6 miles","distanceFormatted":"31.6 miles","distanceKmFormatted":"51 km","timeHours":0.6166666666666667,"timeFormatted":"37 minutes","avgSpeed":53,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}', null, 'markham-gvapenoc/litton-c39ovap4', 0, null, null, 0, '"[{\"name\":\"Baird\",\"description\":\"33 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Baird, MS 38751\",\"lat\":\"33.425119\",\"lng\":\"-90.583423\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":84665,\"slug\":\"baird\",\"hash\":\"h60e7omz\"},{\"name\":\"Indianola\",\"description\":\"Traveled 8 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Indianola, MS 38751\",\"lat\":\"33.450951\",\"lng\":\"-90.655092\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":4619,\"slug\":\"indianola\",\"hash\":\"upb9hfdl\"},{\"name\":\"Boyer\",\"description\":\"Traveled 16 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Boyer, MS 38751\",\"lat\":\"33.536784\",\"lng\":\"-90.637869\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":3,\"place_id\":64422,\"slug\":\"boyer\",\"hash\":\"6tzfz29u\"},{\"name\":\"Frazier\",\"description\":\"16 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Frazier, MS 38773\",\"lat\":\"33.567060\",\"lng\":\"-90.732039\",\"fraction\":0.5555555555555556,\"type\":\"State\",\"distance_km\":2,\"place_id\":96828,\"slug\":\"frazier\",\"hash\":\"hnh54dbs\"},{\"name\":\"Shaw\",\"description\":\"8 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Shaw, MS 38773\",\"lat\":\"33.601782\",\"lng\":\"-90.773708\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":13580,\"slug\":\"shaw\",\"hash\":\"x1lrhqm2\"}]"', 3, 889910, '2025-05-18 09:04:30', '2025-05-18 09:04:30') returning "id"
      Bindings
      • 0: 51806
      • 1: Markham
      • 2: Markham, MS 38761
      • 3: markham
      • 4: gvapenoc
      • 5: 33.404842
      • 6: -90.5612
      • 7: 
      • 8: Mississippi
      • 9: US
      • 10: America/Chicago
      • 11: 38256
      • 12: Litton
      • 13: Litton, MS 38730
      • 14: litton
      • 15: c39ovap4
      • 16: 33.645947
      • 17: -90.837322
      • 18: Litton
      • 19: Mississippi
      • 20: US
      • 21: America/Chicago
      • 22: 2518612
      • 23: MS-448 W
      • 24: 50814
      • 25: m
      • 26: 2262
      • 27: 31.574345994
      • 28: 50814
      • 29: 37 minutes
      • 30: 37 minutes
      • 31: 50.814
      • 32: 50.8 km
      • 33: 
      • 34: 38
      • 35: 0
      • 36: No
      • 37: 31.6 mi
      • 38: 23.03174263390036
      • 39: 0.02303174263390036
      • 40: "[{\"id\":8350474,\"route_id\":2518612,\"step_index\":\"0\",\"instruction\":\"Take US-49W N and MS-448 W to Gilbert Rd in Bolivar County\",\"distance\":41139,\"distance_unit\":\"m\",\"time\":\"1808\",\"latitude\":-90.6712437,\"longitude\":33.492033,\"is_sub_step\":false},{\"id\":8350475,\"route_id\":2518612,\"step_index\":\"1\",\"instruction\":\"\",\"distance\":4427,\"distance_unit\":\"m\",\"time\":\"206\",\"latitude\":-90.7809086,\"longitude\":33.6260079,\"is_sub_step\":false},{\"id\":8350476,\"route_id\":2518612,\"step_index\":\"2\",\"instruction\":\"\",\"distance\":5248,\"distance_unit\":\"m\",\"time\":\"248\",\"latitude\":-90.808977,\"longitude\":33.6459071,\"is_sub_step\":false}]"
      • 41: 50814
      • 42: 50814
      • 43: 4 minutes
      • 44: 0
      • 45: northwest
      • 46: southeast
      • 47: [{"name":"Baird","description":"33 mi to destination","state":"Mississippi","country":"US","full_address":"Baird, MS 38751","lat":"33.425119","lng":"-90.583423","fraction":0.1111111111111111,"type":"City","distance_km":1,"place_id":84665,"slug":"baird","hash":"h60e7omz"},{"name":"Indianola","description":"Traveled 8 mi from origin","state":"Mississippi","country":"US","full_address":"Indianola, MS 38751","lat":"33.450951","lng":"-90.655092","fraction":0.2222222222222222,"type":"City","distance_km":2,"place_id":4619,"slug":"indianola","hash":"upb9hfdl"},{"name":"Boyer","description":"Traveled 16 mi from origin","state":"Mississippi","country":"US","full_address":"Boyer, MS 38751","lat":"33.536784","lng":"-90.637869","fraction":0.4444444444444444,"type":"City","distance_km":3,"place_id":64422,"slug":"boyer","hash":"6tzfz29u"},{"name":"Frazier","description":"16 mi to destination","state":"Mississippi","country":"US","full_address":"Frazier, MS 38773","lat":"33.567060","lng":"-90.732039","fraction":0.5555555555555556,"type":"State","distance_km":2,"place_id":96828,"slug":"frazier","hash":"hnh54dbs"},{"name":"Shaw","description":"8 mi to destination","state":"Mississippi","country":"US","full_address":"Shaw, MS 38773","lat":"33.601782","lng":"-90.773708","fraction":0.7777777777777778,"type":"City","distance_km":1,"place_id":13580,"slug":"shaw","hash":"x1lrhqm2"}]
      • 48: 1
      • 49: 5
      • 50: {"distanceInMiles":31.57443424012328,"distanceMilesFormatted":"31.6 miles","distanceFormatted":"31.6 miles","distanceKmFormatted":"51 km","timeHours":0.6166666666666667,"timeFormatted":"37 minutes","avgSpeed":53,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":[],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"northwest"}
      • 51: 
      • 52: markham-gvapenoc/litton-c39ovap4
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Baird\",\"description\":\"33 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Baird, MS 38751\",\"lat\":\"33.425119\",\"lng\":\"-90.583423\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":1,\"place_id\":84665,\"slug\":\"baird\",\"hash\":\"h60e7omz\"},{\"name\":\"Indianola\",\"description\":\"Traveled 8 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Indianola, MS 38751\",\"lat\":\"33.450951\",\"lng\":\"-90.655092\",\"fraction\":0.2222222222222222,\"type\":\"City\",\"distance_km\":2,\"place_id\":4619,\"slug\":\"indianola\",\"hash\":\"upb9hfdl\"},{\"name\":\"Boyer\",\"description\":\"Traveled 16 mi from origin\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Boyer, MS 38751\",\"lat\":\"33.536784\",\"lng\":\"-90.637869\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":3,\"place_id\":64422,\"slug\":\"boyer\",\"hash\":\"6tzfz29u\"},{\"name\":\"Frazier\",\"description\":\"16 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Frazier, MS 38773\",\"lat\":\"33.567060\",\"lng\":\"-90.732039\",\"fraction\":0.5555555555555556,\"type\":\"State\",\"distance_km\":2,\"place_id\":96828,\"slug\":\"frazier\",\"hash\":\"hnh54dbs\"},{\"name\":\"Shaw\",\"description\":\"8 mi to destination\",\"state\":\"Mississippi\",\"country\":\"US\",\"full_address\":\"Shaw, MS 38773\",\"lat\":\"33.601782\",\"lng\":\"-90.773708\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":1,\"place_id\":13580,\"slug\":\"shaw\",\"hash\":\"x1lrhqm2\"}]"
      • 58: 3
      • 59: 889910
      • 60: 2025-05-18 09:04:30
      • 61: 2025-05-18 09:04:30
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance420μsselect exists(select "id" from "routes" where "origin_destination_id" = 889910 limit 1) as "exists"
      Bindings
      • 0: 889910
      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#1186distance590μsselect * from "routes" where "routes"."origin_destination_id" = 889910 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889910
      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#1186distance410μsselect * from "route_directions" where "route_directions"."route_id" in (2518612, 2518613, 2518614) 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.24msupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:30' where "id" = 2518612
      Bindings
      • 0: 2025-05-18 09:04:30
      • 1: 2518612
      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#235distance350μsselect * from "origin_destinations" where "origin_destinations"."id" = 889910 limit 1
      Bindings
      • 0: 889910
      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#244distance320μsselect * from "places" where "places"."id" = 51806 limit 1
      Bindings
      • 0: 51806
      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#245distance320μsselect * from "places" where "places"."id" = 38256 limit 1
      Bindings
      • 0: 38256
      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#24distance250μsselect * from "route_waypoints" where "route_id" = 2518612
      Bindings
      • 0: 2518612
      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#103distance280μsselect * from "places" where "places"."id" = 51806 limit 1
      Bindings
      • 0: 51806
      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#104distance270μsselect * from "places" where "places"."id" = 38256 limit 1
      Bindings
      • 0: 38256
      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#226distance88.83msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.431631444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.591880222222)) + sin(radians(33.431631444444)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#158distance600μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 84665 limit 1
      Bindings
      • 0: 84665
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance92.94msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.458420888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.622560444444)) + sin(radians(33.458420888889)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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" = 4619 limit 1
      Bindings
      • 0: 4619
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance89.23msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.485210333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.653240666667)) + sin(radians(33.485210333333)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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.94msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.511999777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.683920888889)) + sin(radians(33.511999777778)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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.29msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 64422 limit 1
      Bindings
      • 0: 64422
      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#226distance87.29msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.538789222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.714601111111)) + sin(radians(33.538789222222)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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" = 96828 limit 1
      Bindings
      • 0: 96828
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance89.76msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.565578666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.745281333333)) + sin(radians(33.565578666667)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#226distance92.58msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.592368111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.775961555556)) + sin(radians(33.592368111111)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#158distance660μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 13580 limit 1
      Bindings
      • 0: 13580
      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.92msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.619157555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.806641777778)) + sin(radians(33.619157555556)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      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#78distance560μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 84665) limit 1
      Bindings
      • 0: 2518612
      • 1: 84665
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance970μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:31' where "id" = 6300278
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:31
      • 2: 6300278
      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" = 2518612 and "place_id" = 4619) limit 1
      Bindings
      • 0: 2518612
      • 1: 4619
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance1.8msupdate "route_waypoints" set "fraction" = 0.22222222222222, "updated_at" = '2025-05-18 09:04:31' where "id" = 6300279
      Bindings
      • 0: 0.2222222222222222
      • 1: 2025-05-18 09:04:31
      • 2: 6300279
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance380μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 64422) limit 1
      Bindings
      • 0: 2518612
      • 1: 64422
      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#78distance680μsupdate "route_waypoints" set "fraction" = 0.44444444444444, "updated_at" = '2025-05-18 09:04:31' where "id" = 6300280
      Bindings
      • 0: 0.4444444444444444
      • 1: 2025-05-18 09:04:31
      • 2: 6300280
      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#78distance440μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 96828) limit 1
      Bindings
      • 0: 2518612
      • 1: 96828
      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#78distance790μsupdate "route_waypoints" set "fraction" = 0.55555555555556, "updated_at" = '2025-05-18 09:04:31' where "id" = 6300281
      Bindings
      • 0: 0.5555555555555556
      • 1: 2025-05-18 09:04:31
      • 2: 6300281
      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#78distance410μsselect * from "route_waypoints" where ("route_id" = 2518612 and "place_id" = 13580) limit 1
      Bindings
      • 0: 2518612
      • 1: 13580
      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#78distance750μsupdate "route_waypoints" set "fraction" = 0.77777777777778, "updated_at" = '2025-05-18 09:04:31' where "id" = 6300282
      Bindings
      • 0: 0.7777777777777778
      • 1: 2025-05-18 09:04:31
      • 2: 6300282
      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
    • RouteDenormalisationService.php#45distance650μsselect * from "denormalised_routes" where "origin_destination_id" = 889910 limit 1
      Bindings
      • 0: 889910
      Backtrace
      • app/Services/RouteDenormalisationService.php:45
      • app/Models/Route.php:279
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#24distance440μsselect * from "route_waypoints" where "route_id" = 2518612
      Bindings
      • 0: 2518612
      Backtrace
      • app/Services/RouteWaypointService.php:24
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • RouteWaypointService.php#103distance440μsselect * from "places" where "places"."id" = 51806 limit 1
      Bindings
      • 0: 51806
      Backtrace
      • app/Services/RouteWaypointService.php:103
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#104distance390μsselect * from "places" where "places"."id" = 38256 limit 1
      Bindings
      • 0: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:104
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance91.06msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.431631444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.591880222222)) + sin(radians(33.431631444444)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance740μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 84665 limit 1
      Bindings
      • 0: 84665
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance98.44msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.458420888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.622560444444)) + sin(radians(33.458420888889)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 4619 limit 1
      Bindings
      • 0: 4619
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#226distance92.84msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.485210333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.653240666667)) + sin(radians(33.485210333333)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#226distance108msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.511999777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.683920888889)) + sin(radians(33.511999777778)) * 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" != 51806 and "places"."id" != 38256 order by "distance" asc limit 1
      Bindings
      • 0: 51806
      • 1: 38256
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#158distance640μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 64422 limit 1
      Bindings
      • 0: 64422
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:1083
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • distance88.51msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.538789222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.714601111111)) + sin(radians(33.538789222222)) * 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
    • distance770μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.565578666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.745281333333)) + sin(radians(33.565578666667)) * 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
    • distance89.3msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.592368111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.775961555556)) + sin(radians(33.592368111111)) * 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
    • distance85.82msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(33.619157555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-90.806641777778)) + sin(radians(33.619157555556)) * 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
    • distance510μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance920μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance310μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance610μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance350μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance710μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance360μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance690μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance620μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance340μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance290μsselect * from "states" where "states"."id" = ? limit 1
    • distance300μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance300μsselect * from "states" where "states"."id" = ? limit 1
    • distance500μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance350μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance830μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance440μsselect * from "places" where "places"."id" = ? limit 1
    • distance23.25msselect * from "images" where "images"."place_id" in (51806)
    • distance3.88msselect * from "places" where "places"."id" = ? limit 1
    • distance22.31msselect * from "images" where "images"."place_id" in (38256)
    • distance550μsselect * from "routes" where "origin_destination_id" = ?
    • distance470μ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"
    • distance370μsselect * from "route_directions" where "route_directions"."route_id" in (2518612, 2518613, 2518614) order by "step_index" asc, "step_index" asc
    • distance300μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance280μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance300μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance2.85msselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance360μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance350μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance490μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    25RouteWaypoint.php#?
    App\Models\Place
    14Place.php#?
    App\Models\RouteDirection
    13RouteDirection.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\Country
    2Country.php#?
    App\Models\City
    1City.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:32GET/distance/markham-gvapenoc/litton-c39ovap432213775