Cheap flights Saint Lucia — San Juan (SLU — SJU)

  1. Flights
  2. Saint Lucia
  3. Saint Lucia

Good to know - Cheap tickets Saint Lucia — San Juan

Cheapest flight found $453
Minimal flight time 1h 16m
Flight distance 737 km
Most popular airline NetJets

Popular airlines flying Saint Lucia — San Juan

Flight Saint Lucia – San Juan is served by 12 airlines.  1 airlines operate direct flights.


Airlines with direct flights


Other airlines flying with transfers

Routes from nearby cities to San Juan

A flight from a neighbouring city can help you save money on plane tickets.

search

Bridgetown — San Juan

search

Fort De France — San Juan

search

Dominica — San Juan

search

Abymes — San Juan

search

Saint Vincent — San Juan

search

St. George's — San Juan

search

Port Of Spain — San Juan

search

Saint Kitts — San Juan

search

Antigua — San Juan

The most frequent flight to San Juan is from Bridgetown. The cheapest airfare can be purchased with a flight from Dominica from $203. The nearest airports from Saint Lucia with a flight to San Juan are in Saint Kitts.

Popular International routes from Saint Lucia

search

Saint Lucia — Toronto

search

Saint Lucia — Philadelphia

search

Saint Lucia — Saint Vincent

search

Saint Lucia — Sint Maarten

search

Saint Lucia — Tenerife

Popular routes from San Juan

If you are going to fly from San Juan, then study the popular flights. The most popular flights from San Juan:

search

San Juan — Lima

search

San Juan — Frankfurt

search

San Juan — Tokyo

search

San Juan — Rome

search

San Juan — Seattle

Related pages

Return flights San Juan – Saint Lucia

Schedule of direct flights Saint Lucia — San Juan

We use cookies and similar technologies for different purposes. Read the privacy policy. If you use the site you agree to them.

MessagesTimelineExceptionsViews47RouteQueries52Models184MailsGateN+1 Queries1SessionRequest
Request history8.3.0PHP Version334msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (28.99ms)time
    • Application (305ms)time
    • 1 x Application (91.32%)
      305ms
      1 x Booting (8.68%)
      28.99ms
      47 templates were rendered
      • 1x views_us.routes.viewview.blade.php#?blade
      • 1x routes.viewview.blade.php#?blade
      • 1x index.section-slideshowsection-slideshow.blade.php#?blade
      • 1x components.avia-formavia-form.blade.php#?blade
      • 1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
      • 1x routes.section-advantagessection-advantages.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 4x components.airlines-columnairlines-column.blade.php#?blade
      • 3x components.routes-listroutes-list.blade.php#?blade
      • 19x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 1x components.routes-columnroutes-column.blade.php#?blade
      • 1x components.related-linksrelated-links.blade.php#?blade
      • 1x layouts.mainmain.blade.php#?blade
      • 1x headerheader.blade.php#?blade
      • 2x menumenu.blade.php#?blade
      • 1x footerfooter.blade.php#?blade
      • 1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
      • 1x footer_scriptsfooter_scripts.blade.php#?blade
      • 1x components.currencycurrency.blade.php#?blade
      • 2x components.popuppopup.blade.php#?blade
      • 1x components.languagelanguage.blade.php#?blade
      uri
      GET cheap-flights-from-{slug}
      middleware
      web
      controller
      App\Http\Controllers\RoutesController@view
      namespace
      prefix
      /
      where
      as
      route
      file
      app/Http/Controllers/RoutesController.php:96-299
      52 statements were executed (13 duplicates)Show only duplicates61.24ms
      • QueryDetector.php#25aviaticketsConnection Established
        Backtrace
        • vendor/beyondcode/laravel-query-detector/src/QueryDetector.php:25
        • vendor/beyondcode/laravel-query-detector/src/QueryDetectorMiddleware.php:30
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • app/Http/Middleware/MinifyHtml.php:21
      • SitesRelationshipsSqlRepository.php#34aviatickets4.04msselect * from `sites_relationships` where `us` = 'cheap-flights-from-castries-to-san-juan-slu-sju' limit 1
        Bindings
        • 0: cheap-flights-from-castries-to-san-juan-slu-sju
        Backtrace
        • app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:34
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/SitesRelationships/SitesRelationshipsSqlRepository.php:31
        • app/Http/Controllers/RoutesController.php:113
      • RoutesController.php#125aviatickets1.11msselect * from `flights_by` where `flights_by`.`id` = '308759' and `flights_by`.`id` is not null limit 1
        Bindings
        • 0: [object Object]
        Backtrace
        • app/Http/Controllers/RoutesController.php:125
        • 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:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • RoutesController.php#135aviatickets1.29msselect * from `cities` where `cities`.`id` = 5677 limit 1
        Bindings
        • 0: 5677
        Backtrace
        • app/Http/Controllers/RoutesController.php:135
        • 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:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • RoutesController.php#136aviatickets1.24msselect * from `countries` where `countries`.`id` = 154 limit 1
        Bindings
        • 0: 154
        Backtrace
        • app/Http/Controllers/RoutesController.php:136
        • 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:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • RoutesController.php#137aviatickets1.15msselect * from `cities` where `cities`.`id` = 8758 limit 1
        Bindings
        • 0: 8758
        Backtrace
        • app/Http/Controllers/RoutesController.php:137
        • 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:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • RoutesController.php#138aviatickets1.05msselect * from `countries` where `countries`.`id` = 188 limit 1
        Bindings
        • 0: 188
        Backtrace
        • app/Http/Controllers/RoutesController.php:138
        • 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:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • DomainRouteFactory.php#33aviatickets1.28msselect * from `sites_relationships` where `sites_relationships`.`id` = 308759 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 308759
        Backtrace
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:33
        • app/Http/Controllers/RoutesController.php:143
        • 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:259
      • CountriesRepository.php#31aviatickets1.1msselect * from `countries` where `code` = '' limit 1
        Bindings
        • 0: 
        Backtrace
        • app/Avia/Infrastructure/Repository/CountriesRepository.php:31
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:61
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:43
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:56
        • app/Avia/Infrastructure/Model/LocalRoute.php:190
      • RouteRepository.php#42aviatickets1.13msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 5677 and `destination_id` = 8758 and `date_update` >= '2025-05-04 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 5677
        • 1: 8758
        • 2: 2025-05-04 00:00:00
        Backtrace
        • app/Avia/Infrastructure/Repository/RouteRepository.php:42
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/RouteRepository.php:33
        • app/Http/Controllers/RoutesController.php:150
      • MonthlyPriceStatisticSqlRepository.php#66aviatickets870μsselect * from `monthly_price_statistics` where `origin_city_id` = 5677 and `destination_city_id` = 8758 limit 1
        Bindings
        • 0: 5677
        • 1: 8758
        Backtrace
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:50
        • app/Avia/Application/PriceHandler.php:42
        • app/Http/Controllers/RoutesController.php:156
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • AirlineSqlRepository.php#470aviatickets1.04msselect * from `timetables` where `origin_city_id` = 5677 and `destination_city_id` = 8758 order by `time_origin` asc limit 1000
        Bindings
        • 0: 5677
        • 1: 8758
        Backtrace
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461
        • app/Http/Controllers/RoutesController.php:162
      • AirlineSqlRepository.php#470aviatickets800μsselect * from `airlines` where `airlines`.`id` in (3633)
        Backtrace
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461
        • app/Http/Controllers/RoutesController.php:162
      • AirlineSqlRepository.php#502aviatickets1.24msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5677
        Bindings
        • 0: 5677
        Backtrace
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:502
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:494
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:407
      • AirlineSqlRepository.php#502aviatickets1.51msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8758
        Bindings
        • 0: 8758
        Backtrace
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:502
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:494
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:408
      • AirlineSqlRepository.php#90aviatickets1.19msselect * from `airlines` where `id` in (24, 244, 328, 1659, 2005, 2338, 3023, 5184, 5387, 20641, 42965, 61733) order by `name` asc
        Bindings
        • 0: 24
        • 1: 244
        • 2: 328
        • 3: 1659
        • 4: 2005
        • 5: 2338
        • 6: 3023
        • 7: 5184
        • 8: 5387
        • 9: 20641
        • 10: 42965
        • 11: 61733
        Backtrace
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:90
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:84
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:413
      • LocalRouteRepository.php#558aviatickets1.43msselect destination_city_id from `flights_by` where `origin_city_id` = 5677 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 5677
        • 1: 1
        • 2: 1000
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62
      • NearbyCitiesAggregateDbProvider.php#73aviatickets2.03msselect * from `flights_by` where `origin_city_id` in (1856, 6882, 3067, 549, 7593, 6847, 5946, 9364, 8688, 8813) and `destination_city_id` = 8758 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 1856
        • 1: 6882
        • 2: 3067
        • 3: 549
        • 4: 7593
        • 5: 6847
        • 6: 5946
        • 7: 9364
        • 8: 8688
        • 9: 8813
        • 10: 8758
        • 11: 0
        • 12: 0
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.11msselect * from `cities` where `cities`.`id` in (549, 1856, 3067, 6847, 6882, 7593, 8688, 8813, 9364)
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • NearbyCitiesAggregateDbProvider.php#73aviatickets780μsselect * from `cities` where `cities`.`id` in (8758)
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • NearbyCitiesAggregateDbProvider.php#73aviatickets870μsselect * from `sites_relationships` where `sites_relationships`.`id` in (15847, 32790, 89941, 105847, 118315, 267414, 306245, 317176, 466152)
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • CitySqlRepository.php#104aviatickets1.01msselect * from `cities` where `cities`.`id` = 8813 limit 1
        Bindings
        • 0: 8813
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97
      • CitySqlRepository.php#104aviatickets1.4msselect * from `cities` where `cities`.`id` = 3067 limit 1
        Bindings
        • 0: 3067
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158
      • CitySqlRepository.php#104aviatickets1.28msselect * from `cities` where `cities`.`id` = 549 limit 1
        Bindings
        • 0: 549
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:131
      • OfferSqlRepository.php#52aviatickets1.05msselect * from `offers` where `origin_city_id` = 5677 and `destination_city_id` = 8758
        Bindings
        • 0: 5677
        • 1: 8758
        Backtrace
        • app/Avia/Infrastructure/Repository/OfferSqlRepository.php:52
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/OfferSqlRepository.php:57
        • app/Http/Controllers/RoutesController.php:205
      • LocalRouteRepository.php#447aviatickets1.9msselect * from `flights_by` where `origin_city_id` = 5677 and `id` > 308759 and `destination_country_id` <> 154 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 5677
        • 1: 308759
        • 2: 154
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#447aviatickets1.4msselect * from `cities` where `cities`.`id` in (5677)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#447aviatickets1.2msselect * from `cities` where `cities`.`id` in (5992, 6882, 8814)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#447aviatickets1.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (308761, 308762, 308764)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRoute.php#125aviatickets1.05msselect * from `countries` where `countries`.`id` = 218 limit 1
        Bindings
        • 0: 218
        Backtrace
        • app/Avia/Infrastructure/Model/LocalRoute.php:125
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Model/LocalRoute.php:122
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49
      • LocalRoute.php#125aviatickets870μsselect * from `countries` where `countries`.`id` = 148 limit 1
        Bindings
        • 0: 148
        Backtrace
        • app/Avia/Infrastructure/Model/LocalRoute.php:125
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Model/LocalRoute.php:122
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49
      • LocalRouteRepository.php#412aviatickets1.22msselect * from `flights_by` where `origin_city_id` = 5677 and `destination_country_id` <> 154 and (`price_one_way` > 0 or `price` > 0) and `id` not in (308761) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 5677
        • 1: 154
        • 2: 0
        • 3: 0
        • 4: 308761
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets760μsselect * from `cities` where `cities`.`id` in (5677)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets1.06msselect * from `cities` where `cities`.`id` in (7344, 8673)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets890μsselect * from `sites_relationships` where `sites_relationships`.`id` in (308740, 308772)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets850μsselect * from `countries` where `countries`.`id` in (6, 92)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#149aviatickets1.32msselect * from `flights_by` where `origin_city_id` = 8758 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 8758
        • 1: 0
        • 2: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets870μsselect * from `cities` where `cities`.`id` in (8758)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets1.08msselect * from `cities` where `cities`.`id` in (1949, 3571, 5377, 5531, 6319)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets900μsselect * from `countries` where `countries`.`id` in (92, 97, 109, 125, 211)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets890μsselect * from `sites_relationships` where `sites_relationships`.`id` in (305728, 305830, 305954, 305976, 306038)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#359aviatickets1.43msselect * from `flights_by` where `origin_city_id` = 5677 and `destination_country_id` = 154 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 5677
        • 1: 154
        • 2: 0
        • 3: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330
      • TimetableRepository.php#39aviatickets980μsselect * from `timetables` where `origin_city_id` = 5677 and `destination_city_id` = 8758 order by `time_origin` asc limit 10
        Bindings
        • 0: 5677
        • 1: 8758
        Backtrace
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:39
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:30
        • app/Http/Controllers/RoutesController.php:264
      • TimetableRepository.php#39aviatickets1.13msselect * from `airports` where `airports`.`id` in (6031)
        Backtrace
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:39
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:30
        • app/Http/Controllers/RoutesController.php:264
      • TimetableRepository.php#39aviatickets840μsselect * from `airports` where `airports`.`id` in (7048)
        Backtrace
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:39
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:30
        • app/Http/Controllers/RoutesController.php:264
      • TimetableRepository.php#39aviatickets1.26msselect * from `airlines` where `airlines`.`id` in (3633)
        Backtrace
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:39
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:30
        • app/Http/Controllers/RoutesController.php:264
      • TimetableRepository.php#144aviatickets1.2msselect * from `timetables` where `origin_city_id` = 5677 and `destination_city_id` = 8758 order by `travel_time` asc limit 1
        Bindings
        • 0: 5677
        • 1: 8758
        Backtrace
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:144
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:137
        • app/Http/Controllers/RoutesController.php:274
      • LocalRouteRepository.php#520aviatickets950μsselect * from `flights_by` where `origin_city_id` = 8758 and `destination_city_id` = 5677 limit 1
        Bindings
        • 0: 8758
        • 1: 5677
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514
        • app/Http/Controllers/RoutesController.php:530
      • LocalRouteRepository.php#520aviatickets930μsselect * from `sites_relationships` where `sites_relationships`.`id` in (305991)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514
        • app/Http/Controllers/RoutesController.php:530
      • LocalRoute.php#99aviatickets1.03msselect * from `cities` where `cities`.`id` = 5677 limit 1
        Bindings
        • 0: 5677
        Backtrace
        • app/Avia/Infrastructure/Model/LocalRoute.php:99
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:30
        • app/Http/Controllers/RoutesController.php:536
        • app/Http/Controllers/RoutesController.php:279
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • LocalRoute.php#125aviatickets1.08msselect * from `countries` where `countries`.`id` = 154 limit 1
        Bindings
        • 0: 154
        Backtrace
        • app/Avia/Infrastructure/Model/LocalRoute.php:125
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Model/LocalRoute.php:122
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49
      • RoutesController.php#547aviatickets1.11msselect * from `cities` where `cities`.`id` = 8758 limit 1
        Bindings
        • 0: 8758
        Backtrace
        • app/Http/Controllers/RoutesController.php:547
        • app/Http/Controllers/RoutesController.php:279
        • 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:259
      • description-nearbyCities.blade.php#28aviatickets1.01msselect * from `cities` where `cities`.`id` = 5677 limit 1
        Bindings
        • 0: 5677
        Backtrace
        • view::routes.description-nearbyCities:28
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Avia\Infrastructure\Model\Timetable
      71Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      31LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      31City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      22SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Airline
      14Airline.php#?
      App\Avia\Infrastructure\Model\Country
      12Country.php#?
      App\Avia\Infrastructure\Model\Airport
      2Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...
          _token
          nbdE6LvnTf5GZ7wL00DS9BXNdZIbXTIc0MhzhvZ7
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-castries-to-san-juan-slu-sju?_url=%2...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-castries-to-san-juan-slu-sju
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
            0 of 0   
          array:1 [▼
  "_url" => "/cheap-flights-from-castries-to-san-juan-slu-sju"
]
          request_request
          []
          request_headers
            0 of 0   
          array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "d.lowcost.club"
  ]
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 18:13:10 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""53dc4e71e03c44c1eaf98007130a08ce""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im0rQUR4OGkyMHFJcEUxZmttMVV1cmc9PSIsInZhbHVlIjoiMjhVNjY5N1RNMXhaVVNVQ2xBOTRtNS9hUlVOL3VHZkF5MEdzMVRUMzlrMW9kQllpRTAzSDhhOUprVUZzVkEralgyL3YxYUhtanBHazJ0Y2pJbWtlYjFKVDNiUUt6dmVEeW1WZ285M3dyZGxGc29vbVRqK2JlTXZqZ3NINkNDY3MiLCJtYWMiOiIxOTJiMGU4OWI1NjljMTY0MWJkZmQxZjZlM2E4MzUxYjdiYzQxOThhMjBjOTAwMjk5MzQ1OTdmODZmMDJmODFkIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 20:13:10 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im0rQUR4OGkyMHFJcEUxZmttMVV1cmc9PSIsInZhbHVlIjoiMjhVNjY5N1RNMXhaVVNVQ2xBOTRtNS9hUlVOL3VHZkF5MEdzMVRUMzlrMW9kQllpRTAzSDhhOUprVUZzVkEralgyL3YxY ▶"
    1 => "lowcostclub_session=eyJpdiI6ImZaNGlzRWhXaWVIOEVCZ0k4aVZnR0E9PSIsInZhbHVlIjoiYm1YblE5cU5tSDNUQjREbVpLb1ZIMWtxWEtJWkpjS0JTSHE3K0hsRzVpSEloM2VvVEx4NFRqNUl1TXpUTExDU0RvTXZWRHhUaHZUSCsrVVMreXVtS3lieEpmSFBBYVNKYWJRZmRvb3ptT3AwUFBtVURHMGsvNkh4U0tWeVQyUkEiLCJtYWMiOiI1YTgzZjMyYjc4Yjc2MTY5OTczYjQ4M2NmZTk5OThjNzg0N2YwN2YzMTA5YjM3ZTk0NDM0MWIxNjZlYzczZTRmIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 20:13:10 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6ImZaNGlzRWhXaWVIOEVCZ0k4aVZnR0E9PSIsInZhbHVlIjoiYm1YblE5cU5tSDNUQjREbVpLb1ZIMWtxWEtJWkpjS0JTSHE3K0hsRzVpSEloM2VvVEx4NFRqNUl1TXpUTExD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im0rQUR4OGkyMHFJcEUxZmttMVV1cmc9PSIsInZhbHVlIjoiMjhVNjY5N1RNMXhaVVNVQ2xBOTRtNS9hUlVOL3VHZkF5MEdzMVRUMzlrMW9kQllpRTAzSDhhOUprVUZzVkEralgyL3YxYUhtanBHazJ0Y2pJbWtlYjFKVDNiUUt6dmVEeW1WZ285M3dyZGxGc29vbVRqK2JlTXZqZ3NINkNDY3MiLCJtYWMiOiIxOTJiMGU4OWI1NjljMTY0MWJkZmQxZjZlM2E4MzUxYjdiYzQxOThhMjBjOTAwMjk5MzQ1OTdmODZmMDJmODFkIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 20:13:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im0rQUR4OGkyMHFJcEUxZmttMVV1cmc9PSIsInZhbHVlIjoiMjhVNjY5N1RNMXhaVVNVQ2xBOTRtNS9hUlVOL3VHZkF5MEdzMVRUMzlrMW9kQllpRTAzSDhhOUprVUZzVkEralgyL3YxY ▶"
    1 => "lowcostclub_session=eyJpdiI6ImZaNGlzRWhXaWVIOEVCZ0k4aVZnR0E9PSIsInZhbHVlIjoiYm1YblE5cU5tSDNUQjREbVpLb1ZIMWtxWEtJWkpjS0JTSHE3K0hsRzVpSEloM2VvVEx4NFRqNUl1TXpUTExDU0RvTXZWRHhUaHZUSCsrVVMreXVtS3lieEpmSFBBYVNKYWJRZmRvb3ptT3AwUFBtVURHMGsvNkh4U0tWeVQyUkEiLCJtYWMiOiI1YTgzZjMyYjc4Yjc2MTY5OTczYjQ4M2NmZTk5OThjNzg0N2YwN2YzMTA5YjM3ZTk0NDM0MWIxNjZlYzczZTRmIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 20:13:10 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6ImZaNGlzRWhXaWVIOEVCZ0k4aVZnR0E9PSIsInZhbHVlIjoiYm1YblE5cU5tSDNUQjREbVpLb1ZIMWtxWEtJWkpjS0JTSHE3K0hsRzVpSEloM2VvVEx4NFRqNUl1TXpUTExD ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "nbdE6LvnTf5GZ7wL00DS9BXNdZIbXTIc0MhzhvZ7"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-castries-to-san-juan-slu-sju?_url=%2Fcheap-flights-from-castries-to-san-juan-slu-sju"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-06 18:13:10GET/cheap-flights-from-castries-to-san-juan-slu-sju47521841