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

Just a moment while we calculate your route...

Distance from Pidcoke to Blevins

Driving Distance
62.1 mi • 99.9 km
Flying Distance
40.4 mi • 65.0 km
A
B
Leaflet © OpenStreetMap contributors
54 mph avg speed
East direction
1 hr 1 min travel time

Route Information

The driving distance from Pidcoke, Texas to Blevins, Texas is 62.1 mi (99.9 km)

The straight-line (air) distance is 40.4 mi (65.0 km)

The estimated flight time is 0 hr 5 min

The estimated travel time by road is 1 hour 1 minute

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

Location Details

Origin:

Pidcoke
Place Pidcoke
State/Province Texas
Country US
Latitude 31.279057
Longitude -97.888358
GPS 31.279057° N, 97.888358° W
Local Time 4:04 AM
Timezone America/Chicago

Destination:

Blevins
Place Blevins
State/Province Texas
Country US
Latitude 31.223231
Longitude -97.208612
GPS 31.223231° N, 97.208612° W
Local Time 4:04 AM
Timezone America/Chicago

Journey Summary

Traveling from Pidcoke, Texas to Blevins, Texas covers 62.1 mi (99.9 km) in a east direction. This mixed highways and local roads, moderate route typically takes 1 hour 1 minute under normal conditions.

Drivers have 3 route options between these locations (55.0-62.1 miles / 89-100 km). The primary route shown here saves 10 minutes compared to alternatives.

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

Available Routes

I-14
62.1 mi 1 hour 1 minute
Shortest
TX-36 S
59.2 mi 1 hour 8 minutes
FM107
55 mi 59 minutes
Fastest

How is the distance calculated?

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

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

Journey Waypoints

Pidcoke
Texas , US
Middle Crossing
Texas, US
7.1 mi
Flat
Texas, US
15.4 mi
The Grove
Texas, US
21.5 mi
Meador Grove
Texas, US
25.5 mi
Pendleton
Texas, US
32.4 mi
Troy
Texas, US
34.9 mi
Blevins
Texas , US
Messages36RequestTimelineExceptionsViews2Queries149Models93MailsGate
SettingsRequest history4.24sRequest 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/pidcoke-i81h3w2r/blevins-7qqvlk5q
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:32] LOG.warning: No denormalized route found for origin-destination ID: 889915
  • infolog[09:04:32] LOG.info: Using DistanceCalculationService to calculate route { "origin_place_id": 38...
  • infolog[09:04:32] LOG.info: Executing distance calculation command: python3 /var/www/distance_v2/scripts/di...
  • infolog[09:04:34] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:34] LOG.info: Processing route #1 data for origin-destination ID: 889915 { "origin": "Pid...
  • infolog[09:04:34] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 1 nested sub-directions for direction index 0
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 5 nested sub-directions for direction index 2
  • infolog[09:04:34] LOG.info: Saved 3 directions for route ID: 2518626
  • infolog[09:04:34] LOG.info: Found a shorter route: 88510 meters for route ID: 2518626
  • infolog[09:04:34] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:34] LOG.info: Processing route #2 data for origin-destination ID: 889915 { "origin": "Pid...
  • infolog[09:04:34] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 5 nested sub-directions for direction index 0
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 3 nested sub-directions for direction index 1
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 5 nested sub-directions for direction index 2
  • infolog[09:04:34] LOG.info: Saved 3 directions for route ID: 2518627
  • infolog[09:04:34] LOG.info: Route info structure: ["route","distance","time","latitude","longitude","tolls"...
  • infolog[09:04:34] LOG.info: Processing route #3 data for origin-destination ID: 889915 { "origin": "Pid...
  • infolog[09:04:34] LOG.info: Found directions in sub_directions key
  • debuglog[09:04:34] LOG.debug: Direction structure: ["direction_text","distance","time","latitude","longitude...
  • infolog[09:04:34] LOG.info: Ignoring 14 nested sub-directions for direction index 0
  • infolog[09:04:34] LOG.info: Saved 1 directions for route ID: 2518628
  • infolog[09:04:35] LOG.info: Successfully denormalized route data { "origin_destination_id": 889915, ...
  • infolog[09:04:35] LOG.info: Saved 3 routes for origin-destination ID: 889915
  • infolog[09:04:35] LOG.info: Successfully calculated and saved routes { "primary_route_id": 2518626, ...
  • infolog[09:04:35] LOG.info: Incremented view count for route { "id": 2518626, "name": "FM107", ...
  • infolog[09:04:35] LOG.info: Updated denormalized route for route { "route_id": 2518626, "views": 1 ...
  • infolog[09:04:35] LOG.info: Found existing routes { "route_count": 3, "default_route_id": 2518626, ...
warninginfodebug
status
200 OK
full_url
https://routedistance.io/distance/pidcoke-i81h3w2r/blevins-7qqvlk5q
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.25s
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 => "941a2ff2dbb5c985-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:36 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "BgBusmfxvmXkuppHmLqo4H5qqZh69SMYfFpeijmr"
]
  • Booting (13.77ms)time
  • Application (4.23s)time
  • Routing (471μs)
  • View: route.showviews
  • View: layouts.appviews
  • Preparing Response (36μs)
  • 1 x Application (99.67%)
    4.23s
    1 x Booting (0.32%)
    13.77ms
    1 x Routing (0.01%)
    471μs
    1 x Preparing Response (0%)
    36μs
    2 x View (0%)
    0μs
    2 templates were rendered
    • route.showshow.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    149 statements were executed (95 duplicates)Show only duplicatesdistance2.41s
    • # Query soft limit for Debugbar is reached after 100 queries, additional 49 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • DatabaseSessionHandler.php#96distance16.16msselect * from "sessions" where "id" = 'MsIqJ5zdKpCLgbTlptX6Y84xrBBZ5L78IUhMu7gc' limit 1
      Bindings
      • 0: MsIqJ5zdKpCLgbTlptX6Y84xrBBZ5L78IUhMu7gc
      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#548distance7.99msselect * from "places" where "slug" = 'pidcoke' and ("hash" = 'i81h3w2r') limit 1
      Bindings
      • 0: pidcoke
      • 1: i81h3w2r
      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#548distance580μsselect * from "places" where "slug" = 'blevins' and ("hash" = '7qqvlk5q') limit 1
      Bindings
      • 0: blevins
      • 1: 7qqvlk5q
      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#104distance4.61msselect * from "origin_destinations" where ("origin_id" = 38402 and "destination_id" = 48061) limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      Backtrace
      • app/Http/Controllers/RouteController.php:104
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:211
    • RouteController.php#104distance2.47msinsert into "origin_destinations" ("origin_id", "destination_id", "updated_at", "created_at") values (38402, 48061, '2025-05-18 09:04:32', '2025-05-18 09:04:32') returning "id"
      Bindings
      • 0: 38402
      • 1: 48061
      • 2: 2025-05-18 09:04:32
      • 3: 2025-05-18 09:04:32
      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#256distance2.02msselect * from "denormalised_routes" where "origin_destination_id" = 889915 limit 1
      Bindings
      • 0: 889915
      Backtrace
      • app/Services/RouteDenormalisationService.php:256
      • app/Http/Controllers/RouteController.php:111
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:265
    • OriginDestination.php#70distance1.51msselect exists(select "id" from "routes" where "origin_destination_id" = 889915 limit 1) as "exists"
      Bindings
      • 0: 889915
      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#158distance830μsdelete from "routes" where "origin_destination_id" = 889915
      Bindings
      • 0: 889915
      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#172distance640μsselect * from "places" where "places"."id" = 38402 limit 1
      Bindings
      • 0: 38402
      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#173distance350μsselect * from "places" where "places"."id" = 48061 limit 1
      Bindings
      • 0: 48061
      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.66msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889915, 'FM107', 88510, 'm', 3569, 0, 'No', 31.2231961, 31.435061, null, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 889915
      • 1: FM107
      • 2: 88510
      • 3: m
      • 4: 3569
      • 5: 0
      • 6: No
      • 7: 31.2231961
      • 8: 31.435060999999997
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:34
      • 12: 2025-05-18 09:04:34
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance1.23msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518626, 0, '', 20209, 'm', 652, -97.83585975, 31.3559272, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 0
      • 2: 
      • 3: 20209
      • 4: m
      • 5: 652
      • 6: -97.83585975
      • 7: 31.3559272
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance1.12msinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518626, 1, 'Continue on W Main St to FM107', 7879, 'm', 496, -97.74794135, 31.4254579, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 1
      • 2: Continue on W Main St to FM107
      • 3: 7879
      • 4: m
      • 5: 496
      • 6: -97.74794134999999
      • 7: 31.425457899999998
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      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#548distance820μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518626, 2, 'Continue on FM107. Drive to County Rd 452 in Falls County', 60422, 'm', 2421, -97.45162715, 31.31952545, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 2
      • 2: Continue on FM107. Drive to County Rd 452 in Falls County
      • 3: 60422
      • 4: m
      • 5: 2421
      • 6: -97.45162715
      • 7: 31.31952545
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      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.06msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889915, 'I-14', 99902, 'm', 3665, 0, 'No', 31.0458203, 31.279099, null, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 889915
      • 1: I-14
      • 2: 99902
      • 3: m
      • 4: 3665
      • 5: 0
      • 6: No
      • 7: 31.0458203
      • 8: 31.279099
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:34
      • 12: 2025-05-18 09:04:34
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518627, 0, 'Follow FM116 S and State Hwy 9 to I-14 in Copperas Cove', 22449, 'm', 827, -97.88094745, 31.19994685, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518627
      • 1: 0
      • 2: Follow FM116 S and State Hwy 9 to I-14 in Copperas Cove
      • 3: 22449
      • 4: m
      • 5: 827
      • 6: -97.88094745000001
      • 7: 31.199946850000003
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      Backtrace
      • app/Services/DistanceCalculationService.php:548
      • app/Services/DistanceCalculationService.php:241
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • DistanceCalculationService.php#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518627, 1, 'Follow I-14 and I-35 N to S Central Ave/I 35 N Frontage Rd in Troy. Take exit 308 from I-35 N', 63142, 'm', 2009, -97.57970395, 31.1181208, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518627
      • 1: 1
      • 2: Follow I-14 and I-35 N to S Central Ave/I 35 N Frontage Rd in Troy. Take exit 308 from I-35 N
      • 3: 63142
      • 4: m
      • 5: 2009
      • 6: -97.57970395
      • 7: 31.118120800000003
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      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#548distance780μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518627, 2, 'Take FM935 E and Deer Creek Rd to County Rd 452 in Falls County', 14311, 'm', 829, -97.25914195, 31.2067183, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518627
      • 1: 2
      • 2: Take FM935 E and Deer Creek Rd to County Rd 452 in Falls County
      • 3: 14311
      • 4: m
      • 5: 829
      • 6: -97.25914195
      • 7: 31.2067183
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      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.22msinsert into "routes" ("origin_destination_id", "name", "distance", "distance_unit", "time", "has_tolls", "tolls", "latitude", "longitude", "polyline", "views", "updated_at", "created_at") values (889915, 'TX-36 S', 95327, 'm', 4126, 0, 'No', 31.1786384, 31.435061, null, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 889915
      • 1: TX-36 S
      • 2: 95327
      • 3: m
      • 4: 4126
      • 5: 0
      • 6: No
      • 7: 31.178638399999997
      • 8: 31.435060999999997
      • 9: 
      • 10: 0
      • 11: 2025-05-18 09:04:34
      • 12: 2025-05-18 09:04:34
      Backtrace
      • app/Services/DistanceCalculationService.php:225
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • DistanceCalculationService.php#548distance750μsinsert into "route_directions" ("route_id", "step_index", "instruction", "distance", "distance_unit", "time", "latitude", "longitude", "is_sub_step", "updated_at", "created_at") values (2518628, 0, 'Take Farm To Market 116, TX-36 S and FM1237 E to County Rd 452 in Falls County', 95327, 'm', 4126, -97.5485171, 31.3068497, 0, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518628
      • 1: 0
      • 2: Take Farm To Market 116, TX-36 S and FM1237 E to County Rd 452 in Falls County
      • 3: 95327
      • 4: m
      • 5: 4126
      • 6: -97.5485171
      • 7: 31.306849699999994
      • 8: 0
      • 9: 2025-05-18 09:04:34
      • 10: 2025-05-18 09:04:34
      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#24distance670μsselect * from "route_waypoints" where "route_id" = 2518626
      Bindings
      • 0: 2518626
      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#103distance350μsselect * from "origin_destinations" where "origin_destinations"."id" = 889915 limit 1
      Bindings
      • 0: 889915
      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#103distance400μsselect * from "places" where "places"."id" = 38402 limit 1
      Bindings
      • 0: 38402
      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#104distance310μsselect * from "places" where "places"."id" = 48061 limit 1
      Bindings
      • 0: 48061
      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#226distance103msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.272854111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.812830666667)) + sin(radians(31.272854111111)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance960μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 101916 limit 1
      Bindings
      • 0: 101916
      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#226distance89.35msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.266651222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.737303333333)) + sin(radians(31.266651222222)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#226distance90.26msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.260448333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.661776)) + sin(radians(31.260448333333)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance710μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 19766 limit 1
      Bindings
      • 0: 19766
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance92.99msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.254245444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.586248666667)) + sin(radians(31.254245444444)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance540μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 92505 limit 1
      Bindings
      • 0: 92505
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance95.6msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.248042555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.510721333333)) + sin(radians(31.248042555556)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.241839666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.435194)) + sin(radians(31.241839666667)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance1.88msselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 34245 limit 1
      Bindings
      • 0: 34245
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance98.27msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.235636777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.359666666667)) + sin(radians(31.235636777778)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 19200 limit 1
      Bindings
      • 0: 19200
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
    • RouteWaypointService.php#226distance92.77msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.229433888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.284139333333)) + sin(radians(31.229433888889)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
    • RouteWaypointService.php#158distance650μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 11013 limit 1
      Bindings
      • 0: 11013
      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#78distance350μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 101915) limit 1
      Bindings
      • 0: 2518626
      • 1: 101915
      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.33msinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518626, 101915, 0.11111111111111, 4, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 101915
      • 2: 0.1111111111111111
      • 3: 4
      • 4: 2025-05-18 09:04:34
      • 5: 2025-05-18 09:04:34
      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#78distance290μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 19766) limit 1
      Bindings
      • 0: 2518626
      • 1: 19766
      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#78distance720μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518626, 19766, 0.33333333333333, 4, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 19766
      • 2: 0.3333333333333333
      • 3: 4
      • 4: 2025-05-18 09:04:34
      • 5: 2025-05-18 09:04:34
      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#78distance270μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 92505) limit 1
      Bindings
      • 0: 2518626
      • 1: 92505
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance820μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518626, 92505, 0.44444444444444, 4, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 92505
      • 2: 0.4444444444444444
      • 3: 4
      • 4: 2025-05-18 09:04:34
      • 5: 2025-05-18 09:04:34
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance320μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 34245) limit 1
      Bindings
      • 0: 2518626
      • 1: 34245
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance910μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518626, 34245, 0.66666666666667, 3, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 34245
      • 2: 0.6666666666666666
      • 3: 3
      • 4: 2025-05-18 09:04:34
      • 5: 2025-05-18 09:04:34
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Services/DistanceCalculationService.php:325
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 19200) limit 1
      Bindings
      • 0: 2518626
      • 1: 19200
      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#78distance730μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518626, 19200, 0.77777777777778, 3, '2025-05-18 09:04:34', '2025-05-18 09:04:34') returning "id"
      Bindings
      • 0: 2518626
      • 1: 19200
      • 2: 0.7777777777777778
      • 3: 3
      • 4: 2025-05-18 09:04:34
      • 5: 2025-05-18 09:04:34
      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#78distance260μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 11013) limit 1
      Bindings
      • 0: 2518626
      • 1: 11013
      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#78distance930μsinsert into "route_waypoints" ("route_id", "place_id", "fraction", "distance_from_route", "updated_at", "created_at") values (2518626, 11013, 0.88888888888889, 2, '2025-05-18 09:04:35', '2025-05-18 09:04:35') returning "id"
      Bindings
      • 0: 2518626
      • 1: 11013
      • 2: 0.8888888888888888
      • 3: 2
      • 4: 2025-05-18 09:04:35
      • 5: 2025-05-18 09:04:35
      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#366distance490μsselect count(*) as aggregate from "route_directions" where "route_directions"."route_id" = 2518626 and "route_directions"."route_id" is not null
      Bindings
      • 0: 2518626
      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#45distance350μsselect * from "denormalised_routes" where "origin_destination_id" = 889915 limit 1
      Bindings
      • 0: 889915
      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#123distance600μsselect * from "route_directions" where "route_directions"."route_id" = 2518626 and "route_directions"."route_id" is not null order by "step_index" asc, "step_index" asc
      Bindings
      • 0: 2518626
      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#198distance340μsselect * from "locations" where "locations"."id" = 38402 limit 1
      Bindings
      • 0: 38402
      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#198distance440μsselect * from "cities" where "cities"."id" = 21699 limit 1
      Bindings
      • 0: 21699
      Backtrace
      • app/Models/Place.php:198
      • app/Services/RouteDenormalisationService.php:153
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#215distance300μsselect * from "states" where "states"."id" = 22 limit 1
      Bindings
      • 0: 22
      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#330distance330μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:155
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • Place.php#198distance270μsselect * from "locations" where "locations"."id" = 48061 limit 1
      Bindings
      • 0: 48061
      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#198distance280μsselect * from "cities" where "cities"."id" = 15360 limit 1
      Bindings
      • 0: 15360
      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#215distance250μsselect * from "states" where "states"."id" = 22 limit 1
      Bindings
      • 0: 22
      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#330distance250μsselect * from "countries" where "countries"."id" = 1 limit 1
      Bindings
      • 0: 1
      Backtrace
      • app/Models/Place.php:330
      • app/Services/RouteDenormalisationService.php:169
      • app/Services/RouteDenormalisationService.php:66
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
    • RouteDenormalisationService.php#70distance2.66msinsert 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 (38402, 'Pidcoke', 'Pidcoke, TX 76528', 'pidcoke', 'i81h3w2r', 31.279057, -97.888358, 'Pidcoke', 'Texas', 'US', 'America/Chicago', 48061, 'Blevins', 'Blevins, TX 76524', 'blevins', '7qqvlk5q', 31.223231, -97.208612, 'Blevins', 'Texas', 'US', 'America/Chicago', 2518626, 'FM107', 88510, 'm', 3569, 54.99754721, 88510, '59 minutes', '59 minutes', 88.51, '88.5 km', null, 59, 0, 'No', '55 mi', 40.335998504457, 0.040335998504457, '"[{\"id\":8350518,\"route_id\":2518626,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":20209,\"distance_unit\":\"m\",\"time\":\"652\",\"latitude\":-97.8358598,\"longitude\":31.3559272,\"is_sub_step\":false},{\"id\":8350519,\"route_id\":2518626,\"step_index\":\"1\",\"instruction\":\"Continue on W Main St to FM107\",\"distance\":7879,\"distance_unit\":\"m\",\"time\":\"496\",\"latitude\":-97.7479414,\"longitude\":31.4254579,\"is_sub_step\":false},{\"id\":8350520,\"route_id\":2518626,\"step_index\":\"2\",\"instruction\":\"Continue on FM107. Drive to County Rd 452 in Falls County\",\"distance\":60422,\"distance_unit\":\"m\",\"time\":\"2421\",\"latitude\":-97.4516272,\"longitude\":31.3195255,\"is_sub_step\":false}]"', 88510, 88510, '10 minutes', 0, 'east', 'west', '[{"name":"Middle Crossing","description":"58 mi to destination","state":"Texas","country":"US","full_address":"Middle Crossing, TX","lat":"31.214354","lng":"-97.794194","fraction":0.1111111111111111,"type":"City","distance_km":4,"place_id":101915,"slug":"middle-crossing","hash":"2s9r7phx"},{"name":"Flat","description":"43 mi to destination","state":"Texas","country":"US","full_address":"Flat, TX","lat":"31.308781","lng":"-97.630018","fraction":0.3333333333333333,"type":"City","distance_km":4,"place_id":19766,"slug":"flat","hash":"vfd34zlj"},{"name":"The Grove","description":"Traveled 29 mi from origin","state":"Texas","country":"US","full_address":"The Grove, TX 76528","lat":"31.273056","lng":"-97.525000","fraction":0.4444444444444444,"type":"City","distance_km":4,"place_id":92505,"slug":"the-grove","hash":"66fvqb4t"},{"name":"Meador Grove","description":"Traveled 43 mi from origin","state":"Texas","country":"US","full_address":"Meador Grove, TX 76557","lat":"31.285450","lng":"-97.456957","fraction":0.6666666666666666,"type":"City","distance_km":3,"place_id":34245,"slug":"meador-grove","hash":"7ogcvhdy"},{"name":"Pendleton","description":"14 mi to destination","state":"Texas","country":"US","full_address":"Pendleton, TX","lat":"31.195176","lng":"-97.348617","fraction":0.7777777777777778,"type":"City","distance_km":3,"place_id":19200,"slug":"pendleton","hash":"bomukc7p"},{"name":"Troy","description":"Traveled 58 mi from origin","state":"Texas","country":"US","full_address":"Troy, TX","lat":"31.206842","lng":"-97.302782","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":11013,"slug":"troy","hash":"xjx0xoy7"}]', 1, 6, '{"distanceInMiles":54.9977009208744,"distanceMilesFormatted":"55 miles","distanceFormatted":"55 miles","distanceKmFormatted":"89 km","timeHours":0.9833333333333333,"timeFormatted":"59 minutes","avgSpeed":54,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"east"}', null, 'pidcoke-i81h3w2r/blevins-7qqvlk5q', 0, null, null, 0, '"[{\"name\":\"Middle Crossing\",\"description\":\"58 mi to destination\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Middle Crossing, TX\",\"lat\":\"31.214354\",\"lng\":\"-97.794194\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":4,\"place_id\":101915,\"slug\":\"middle-crossing\",\"hash\":\"2s9r7phx\"},{\"name\":\"Flat\",\"description\":\"43 mi to destination\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Flat, TX\",\"lat\":\"31.308781\",\"lng\":\"-97.630018\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":4,\"place_id\":19766,\"slug\":\"flat\",\"hash\":\"vfd34zlj\"},{\"name\":\"The Grove\",\"description\":\"Traveled 29 mi from origin\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"The Grove, TX 76528\",\"lat\":\"31.273056\",\"lng\":\"-97.525000\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":4,\"place_id\":92505,\"slug\":\"the-grove\",\"hash\":\"66fvqb4t\"},{\"name\":\"Meador Grove\",\"description\":\"Traveled 43 mi from origin\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Meador Grove, TX 76557\",\"lat\":\"31.285450\",\"lng\":\"-97.456957\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":3,\"place_id\":34245,\"slug\":\"meador-grove\",\"hash\":\"7ogcvhdy\"},{\"name\":\"Pendleton\",\"description\":\"14 mi to destination\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Pendleton, TX\",\"lat\":\"31.195176\",\"lng\":\"-97.348617\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":3,\"place_id\":19200,\"slug\":\"pendleton\",\"hash\":\"bomukc7p\"},{\"name\":\"Troy\",\"description\":\"Traveled 58 mi from origin\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Troy, TX\",\"lat\":\"31.206842\",\"lng\":\"-97.302782\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":11013,\"slug\":\"troy\",\"hash\":\"xjx0xoy7\"}]"', 3, 889915, '2025-05-18 09:04:35', '2025-05-18 09:04:35') returning "id"
      Bindings
      • 0: 38402
      • 1: Pidcoke
      • 2: Pidcoke, TX 76528
      • 3: pidcoke
      • 4: i81h3w2r
      • 5: 31.279057
      • 6: -97.888358
      • 7: Pidcoke
      • 8: Texas
      • 9: US
      • 10: America/Chicago
      • 11: 48061
      • 12: Blevins
      • 13: Blevins, TX 76524
      • 14: blevins
      • 15: 7qqvlk5q
      • 16: 31.223231
      • 17: -97.208612
      • 18: Blevins
      • 19: Texas
      • 20: US
      • 21: America/Chicago
      • 22: 2518626
      • 23: FM107
      • 24: 88510
      • 25: m
      • 26: 3569
      • 27: 54.99754721
      • 28: 88510
      • 29: 59 minutes
      • 30: 59 minutes
      • 31: 88.51
      • 32: 88.5 km
      • 33: 
      • 34: 59
      • 35: 0
      • 36: No
      • 37: 55 mi
      • 38: 40.335998504456725
      • 39: 0.040335998504456724
      • 40: "[{\"id\":8350518,\"route_id\":2518626,\"step_index\":\"0\",\"instruction\":\"\",\"distance\":20209,\"distance_unit\":\"m\",\"time\":\"652\",\"latitude\":-97.8358598,\"longitude\":31.3559272,\"is_sub_step\":false},{\"id\":8350519,\"route_id\":2518626,\"step_index\":\"1\",\"instruction\":\"Continue on W Main St to FM107\",\"distance\":7879,\"distance_unit\":\"m\",\"time\":\"496\",\"latitude\":-97.7479414,\"longitude\":31.4254579,\"is_sub_step\":false},{\"id\":8350520,\"route_id\":2518626,\"step_index\":\"2\",\"instruction\":\"Continue on FM107. Drive to County Rd 452 in Falls County\",\"distance\":60422,\"distance_unit\":\"m\",\"time\":\"2421\",\"latitude\":-97.4516272,\"longitude\":31.3195255,\"is_sub_step\":false}]"
      • 41: 88510
      • 42: 88510
      • 43: 10 minutes
      • 44: 0
      • 45: east
      • 46: west
      • 47: [{"name":"Middle Crossing","description":"58 mi to destination","state":"Texas","country":"US","full_address":"Middle Crossing, TX","lat":"31.214354","lng":"-97.794194","fraction":0.1111111111111111,"type":"City","distance_km":4,"place_id":101915,"slug":"middle-crossing","hash":"2s9r7phx"},{"name":"Flat","description":"43 mi to destination","state":"Texas","country":"US","full_address":"Flat, TX","lat":"31.308781","lng":"-97.630018","fraction":0.3333333333333333,"type":"City","distance_km":4,"place_id":19766,"slug":"flat","hash":"vfd34zlj"},{"name":"The Grove","description":"Traveled 29 mi from origin","state":"Texas","country":"US","full_address":"The Grove, TX 76528","lat":"31.273056","lng":"-97.525000","fraction":0.4444444444444444,"type":"City","distance_km":4,"place_id":92505,"slug":"the-grove","hash":"66fvqb4t"},{"name":"Meador Grove","description":"Traveled 43 mi from origin","state":"Texas","country":"US","full_address":"Meador Grove, TX 76557","lat":"31.285450","lng":"-97.456957","fraction":0.6666666666666666,"type":"City","distance_km":3,"place_id":34245,"slug":"meador-grove","hash":"7ogcvhdy"},{"name":"Pendleton","description":"14 mi to destination","state":"Texas","country":"US","full_address":"Pendleton, TX","lat":"31.195176","lng":"-97.348617","fraction":0.7777777777777778,"type":"City","distance_km":3,"place_id":19200,"slug":"pendleton","hash":"bomukc7p"},{"name":"Troy","description":"Traveled 58 mi from origin","state":"Texas","country":"US","full_address":"Troy, TX","lat":"31.206842","lng":"-97.302782","fraction":0.8888888888888888,"type":"City","distance_km":2,"place_id":11013,"slug":"troy","hash":"xjx0xoy7"}]
      • 48: 1
      • 49: 6
      • 50: {"distanceInMiles":54.9977009208744,"distanceMilesFormatted":"55 miles","distanceFormatted":"55 miles","distanceKmFormatted":"89 km","timeHours":0.9833333333333333,"timeFormatted":"59 minutes","avgSpeed":54,"routeDescriptors":["mixed highways and local roads","moderate"],"journeyType":"regional trip","activeFeatures":["scenic views"],"dayPart":"morning","dayNote":"weekend","trafficNote":"typical weekend traffic patterns","direction":"east"}
      • 51: 
      • 52: pidcoke-i81h3w2r/blevins-7qqvlk5q
      • 53: 0
      • 54: 
      • 55: 
      • 56: 0
      • 57: "[{\"name\":\"Middle Crossing\",\"description\":\"58 mi to destination\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Middle Crossing, TX\",\"lat\":\"31.214354\",\"lng\":\"-97.794194\",\"fraction\":0.1111111111111111,\"type\":\"City\",\"distance_km\":4,\"place_id\":101915,\"slug\":\"middle-crossing\",\"hash\":\"2s9r7phx\"},{\"name\":\"Flat\",\"description\":\"43 mi to destination\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Flat, TX\",\"lat\":\"31.308781\",\"lng\":\"-97.630018\",\"fraction\":0.3333333333333333,\"type\":\"City\",\"distance_km\":4,\"place_id\":19766,\"slug\":\"flat\",\"hash\":\"vfd34zlj\"},{\"name\":\"The Grove\",\"description\":\"Traveled 29 mi from origin\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"The Grove, TX 76528\",\"lat\":\"31.273056\",\"lng\":\"-97.525000\",\"fraction\":0.4444444444444444,\"type\":\"City\",\"distance_km\":4,\"place_id\":92505,\"slug\":\"the-grove\",\"hash\":\"66fvqb4t\"},{\"name\":\"Meador Grove\",\"description\":\"Traveled 43 mi from origin\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Meador Grove, TX 76557\",\"lat\":\"31.285450\",\"lng\":\"-97.456957\",\"fraction\":0.6666666666666666,\"type\":\"City\",\"distance_km\":3,\"place_id\":34245,\"slug\":\"meador-grove\",\"hash\":\"7ogcvhdy\"},{\"name\":\"Pendleton\",\"description\":\"14 mi to destination\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Pendleton, TX\",\"lat\":\"31.195176\",\"lng\":\"-97.348617\",\"fraction\":0.7777777777777778,\"type\":\"City\",\"distance_km\":3,\"place_id\":19200,\"slug\":\"pendleton\",\"hash\":\"bomukc7p\"},{\"name\":\"Troy\",\"description\":\"Traveled 58 mi from origin\",\"state\":\"Texas\",\"country\":\"US\",\"full_address\":\"Troy, TX\",\"lat\":\"31.206842\",\"lng\":\"-97.302782\",\"fraction\":0.8888888888888888,\"type\":\"City\",\"distance_km\":2,\"place_id\":11013,\"slug\":\"troy\",\"hash\":\"xjx0xoy7\"}]"
      • 58: 3
      • 59: 889915
      • 60: 2025-05-18 09:04:35
      • 61: 2025-05-18 09:04:35
      Backtrace
      • app/Services/RouteDenormalisationService.php:70
      • app/Services/DistanceCalculationService.php:386
      • app/Http/Controllers/RouteController.php:258
      • app/Http/Controllers/RouteController.php:116
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • OriginDestination.php#70distance480μsselect exists(select "id" from "routes" where "origin_destination_id" = 889915 limit 1) as "exists"
      Bindings
      • 0: 889915
      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#1186distance670μsselect * from "routes" where "routes"."origin_destination_id" = 889915 and "routes"."origin_destination_id" is not null order by "distance" asc
      Bindings
      • 0: 889915
      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#1186distance490μsselect * from "route_directions" where "route_directions"."route_id" in (2518626, 2518627, 2518628) 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#225distance910μsupdate "routes" set "views" = "views" + 1, "updated_at" = '2025-05-18 09:04:35' where "id" = 2518626
      Bindings
      • 0: 2025-05-18 09:04:35
      • 1: 2518626
      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#235distance410μsselect * from "origin_destinations" where "origin_destinations"."id" = 889915 limit 1
      Bindings
      • 0: 889915
      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#244distance420μsselect * from "places" where "places"."id" = 38402 limit 1
      Bindings
      • 0: 38402
      Backtrace
      • app/Models/Route.php:244
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • Route.php#245distance380μsselect * from "places" where "places"."id" = 48061 limit 1
      Bindings
      • 0: 48061
      Backtrace
      • app/Models/Route.php:245
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • RouteWaypointService.php#24distance320μsselect * from "route_waypoints" where "route_id" = 2518626
      Bindings
      • 0: 2518626
      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#103distance370μsselect * from "places" where "places"."id" = 38402 limit 1
      Bindings
      • 0: 38402
      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#104distance390μsselect * from "places" where "places"."id" = 48061 limit 1
      Bindings
      • 0: 48061
      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#226distance93.46msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.272854111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.812830666667)) + sin(radians(31.272854111111)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance720μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 101916 limit 1
      Bindings
      • 0: 101916
      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.95msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.266651222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.737303333333)) + sin(radians(31.266651222222)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#226distance99.5msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.260448333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.661776)) + sin(radians(31.260448333333)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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" = 19766 limit 1
      Bindings
      • 0: 19766
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance102msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.254245444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.586248666667)) + sin(radians(31.254245444444)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance700μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 92505 limit 1
      Bindings
      • 0: 92505
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance99.41msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.248042555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.510721333333)) + sin(radians(31.248042555556)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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.15msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.241839666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.435194)) + sin(radians(31.241839666667)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      Backtrace
      • app/Services/RouteWaypointService.php:226
      • app/Services/RouteWaypointService.php:140
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
    • RouteWaypointService.php#158distance670μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 34245 limit 1
      Bindings
      • 0: 34245
      Backtrace
      • app/Services/RouteWaypointService.php:158
      • app/Services/RouteWaypointService.php:53
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
    • RouteWaypointService.php#226distance91.39msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.235636777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.359666666667)) + sin(radians(31.235636777778)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance540μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 19200 limit 1
      Bindings
      • 0: 19200
      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.39msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.229433888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.284139333333)) + sin(radians(31.229433888889)) * 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" != 38402 and "places"."id" != 48061 order by "distance" asc limit 1
      Bindings
      • 0: 38402
      • 1: 48061
      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#158distance540μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = 11013 limit 1
      Bindings
      • 0: 11013
      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#78distance310μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 101915) limit 1
      Bindings
      • 0: 2518626
      • 1: 101915
      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#78distance990μsupdate "route_waypoints" set "fraction" = 0.11111111111111, "updated_at" = '2025-05-18 09:04:35' where "id" = 6300306
      Bindings
      • 0: 0.1111111111111111
      • 1: 2025-05-18 09:04:35
      • 2: 6300306
      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#78distance300μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 19766) limit 1
      Bindings
      • 0: 2518626
      • 1: 19766
      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.04msupdate "route_waypoints" set "fraction" = 0.33333333333333, "updated_at" = '2025-05-18 09:04:35' where "id" = 6300307
      Bindings
      • 0: 0.3333333333333333
      • 1: 2025-05-18 09:04:35
      • 2: 6300307
      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#78distance980μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 92505) limit 1
      Bindings
      • 0: 2518626
      • 1: 92505
      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.09msupdate "route_waypoints" set "fraction" = 0.44444444444444, "updated_at" = '2025-05-18 09:04:35' where "id" = 6300308
      Bindings
      • 0: 0.4444444444444444
      • 1: 2025-05-18 09:04:35
      • 2: 6300308
      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#78distance280μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 34245) limit 1
      Bindings
      • 0: 2518626
      • 1: 34245
      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#78distance570μsupdate "route_waypoints" set "fraction" = 0.66666666666667, "updated_at" = '2025-05-18 09:04:35' where "id" = 6300309
      Bindings
      • 0: 0.6666666666666666
      • 1: 2025-05-18 09:04:35
      • 2: 6300309
      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#78distance290μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 19200) limit 1
      Bindings
      • 0: 2518626
      • 1: 19200
      Backtrace
      • app/Services/RouteWaypointService.php:78
      • app/Models/Route.php:261
      • app/Services/DistanceCalculationService.php:1190
      • app/Services/DistanceCalculationService.php:1058
      • app/Http/Controllers/RouteController.php:120
    • RouteWaypointService.php#78distance620μsupdate "route_waypoints" set "fraction" = 0.77777777777778, "updated_at" = '2025-05-18 09:04:35' where "id" = 6300310
      Bindings
      • 0: 0.7777777777777778
      • 1: 2025-05-18 09:04:35
      • 2: 6300310
      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#78distance270μsselect * from "route_waypoints" where ("route_id" = 2518626 and "place_id" = 11013) limit 1
      Bindings
      • 0: 2518626
      • 1: 11013
      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#78distance650μsupdate "route_waypoints" set "fraction" = 0.88888888888889, "updated_at" = '2025-05-18 09:04:35' where "id" = 6300311
      Bindings
      • 0: 0.8888888888888888
      • 1: 2025-05-18 09:04:35
      • 2: 6300311
      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#45distance490μsselect * from "denormalised_routes" where "origin_destination_id" = 889915 limit 1
      Bindings
      • 0: 889915
      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#24distance310μsselect * from "route_waypoints" where "route_id" = 2518626
      Bindings
      • 0: 2518626
      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
    • distance340μsselect * from "places" where "places"."id" = ? limit 1
    • distance320μsselect * from "places" where "places"."id" = ? limit 1
    • distance90.08msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.272854111111)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.812830666667)) + sin(radians(31.272854111111)) * 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
    • distance590μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance92.65msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.266651222222)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.737303333333)) + sin(radians(31.266651222222)) * 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
    • distance94.21msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.260448333333)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.661776)) + sin(radians(31.260448333333)) * 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
    • distance550μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance91.03msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.254245444444)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.586248666667)) + sin(radians(31.254245444444)) * 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
    • distance540μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance92.32msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.248042555556)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.510721333333)) + sin(radians(31.248042555556)) * 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
    • distance92.96msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.241839666667)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.435194)) + sin(radians(31.241839666667)) * 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
    • distance560μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance90.64msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.235636777778)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.359666666667)) + sin(radians(31.235636777778)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance610μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance94.11msselect "places"."id", "places"."place", "places"."formatted_address", "places"."lat", "places"."lng", "places"."location_id", (3959 * acos(cos(radians(31.229433888889)) * cos(radians(lat)) * cos(radians(lng) - radians(-97.284139333333)) + sin(radians(31.229433888889)) * sin(radians(lat)))) AS distance, "places"."slug", "places"."hash", "locations"."country_id", "countries"."name" as "country_name" from "places" inner join "locations" on "places"."location_id" = "locations"."id" left join "countries" on "locations"."country_id" = "countries"."id" where "places"."lat" is not null and "places"."lng" is not null and "locations"."neighborhood_id" is null and "locations"."street_id" is null and "places"."id" != ? and "places"."id" != ? order by "distance" asc limit 1
    • distance620μsselect "locations".*, "states"."name" as "state_name" from "locations" left join "states" on "locations"."state_id" = "states"."id" where "locations"."id" = ? limit 1
    • distance380μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance880μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance760μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance300μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance630μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance330μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance630μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance400μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance680μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance390μsselect * from "route_waypoints" where ("route_id" = ? and "place_id" = ?) limit 1
    • distance800μsupdate "route_waypoints" set "fraction" = ?, "updated_at" = ? where "id" = ?
    • distance450μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance360μsselect * from "states" where "states"."id" = ? limit 1
    • distance350μsselect * from "locations" where "locations"."id" = ? limit 1
    • distance310μsselect * from "states" where "states"."id" = ? limit 1
    • distance570μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance450μsselect * from "denormalised_routes" where "origin_destination_id" = ? limit 1
    • distance790μsupdate "denormalised_routes" set "views" = ?, "updated_at" = ? where "id" = ?
    • distance460μsselect * from "places" where "places"."id" = ? limit 1
    • distance22.25msselect * from "images" where "images"."place_id" in (38402)
    • distance430μsselect * from "places" where "places"."id" = ? limit 1
    • distance21.54msselect * from "images" where "images"."place_id" in (48061)
    • distance550μsselect * from "routes" where "origin_destination_id" = ?
    • distance700μ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"
    • distance650μsselect * from "route_directions" where "route_directions"."route_id" in (2518626, 2518627, 2518628) order by "step_index" asc, "step_index" asc
    • distance510μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance480μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance420μsselect * from "route_waypoints" where "route_waypoints"."route_id" = ? and "route_waypoints"."route_id" is not null
    • distance630μsselect "comments".*, "routes"."id" as "laravel_through_key" from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance360μsselect count(*) as aggregate from "comments" inner join "routes" on "routes"."id" = "comments"."route_id" where "routes"."id" = ?
    • distance520μsselect * from "routes" where "routes"."id" = ? limit 1
    • distance470μsselect * from "comments" where "comments"."route_id" = ? and "comments"."route_id" is not null order by "created_at" desc
    App\Models\RouteWaypoint
    30RouteWaypoint.php#?
    App\Models\RouteDirection
    17RouteDirection.php#?
    App\Models\Place
    14Place.php#?
    App\Models\Image
    8Image.php#?
    App\Models\Route
    7Route.php#?
    App\Models\Location
    4Location.php#?
    App\Models\State
    4State.php#?
    App\Models\DenormalisedRoute
    3DenormalisedRoute.php#?
    App\Models\OriginDestination
    2OriginDestination.php#?
    App\Models\City
    2City.php#?
    App\Models\Country
    2Country.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-05-18 09:04:36GET/distance/pidcoke-i81h3w2r/blevins-7qqvlk5q36214993