Cheap flights Saint John — New York (YSJ — NYC)

Good to know - Cheap tickets Saint John — New York

Cheapest flight found $279
Flight distance 835 km
Round-trip from $197
Cheapest month to fly May

Popular airlines flying Saint John — New York

Flight Saint John – New York is served by 2 airlines.

Routes from nearby cities to New York

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

The most frequent flight to New York is from Boston, which is the closest city to Saint John with the lowest price, from $28 per one-way.

Popular International routes from Saint John

Popular routes from New York

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

Popular domestic routes from Saint John

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

Request history8.3.0PHP Version1.01sRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (96.02ms)time
    • Application (916ms)time
    • 1 x Application (90.51%)
      916ms
      1 x Booting (9.49%)
      96.02ms
      52 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
      • 2x components.airlines-columnairlines-column.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 24x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 2x 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 (19 duplicates)Show only duplicates289ms
      • 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#34aviatickets8.06msselect * from `sites_relationships` where `us` = 'cheap-flights-from-saint-john-to-new-york-ysj-nyc' limit 1
        Bindings
        • 0: cheap-flights-from-saint-john-to-new-york-ysj-nyc
        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#125aviatickets3.82msselect * from `flights_by` where `flights_by`.`id` = '371489' 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#135aviatickets6.54msselect * from `cities` where `cities`.`id` = 7321 limit 1
        Bindings
        • 0: 7321
        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#136aviatickets2.18msselect * from `countries` where `countries`.`id` = 6 limit 1
        Bindings
        • 0: 6
        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#137aviatickets6.07msselect * from `cities` where `cities`.`id` = 4539 limit 1
        Bindings
        • 0: 4539
        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#138aviatickets5.61msselect * from `countries` where `countries`.`id` = 92 limit 1
        Bindings
        • 0: 92
        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#33aviatickets7.59msselect * from `sites_relationships` where `sites_relationships`.`id` = 371489 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 371489
        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#31aviatickets3.64msselect * 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.75msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 7321 and `destination_id` = 4539 and `date_update` >= '2025-05-11 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 7321
        • 1: 4539
        • 2: 2025-05-11 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#66aviatickets2.12msselect * from `monthly_price_statistics` where `origin_city_id` = 7321 and `destination_city_id` = 4539 limit 1
        Bindings
        • 0: 7321
        • 1: 4539
        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#470aviatickets2.05msselect * from `timetables` where `origin_city_id` = 7321 and `destination_city_id` = 4539 order by `time_origin` asc limit 1000
        Bindings
        • 0: 7321
        • 1: 4539
        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.66msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7321
        Bindings
        • 0: 7321
        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#502aviatickets6.43msselect distinct `airline_id` from `timetables` where `origin_city_id` = 4539
        Bindings
        • 0: 4539
        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#90aviatickets13.58msselect * from `airlines` where `id` in (328, 2361) order by `name` asc
        Bindings
        • 0: 328
        • 1: 2361
        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#558aviatickets7.4msselect destination_city_id from `flights_by` where `origin_city_id` = 7321 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 7321
        • 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#73aviatickets8.84msselect * from `flights_by` where `origin_city_id` in (9312, 9294, 9286, 8690, 7284, 779, 7241, 7268, 4539, 7299) and `destination_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9312
        • 1: 9294
        • 2: 9286
        • 3: 8690
        • 4: 7284
        • 5: 779
        • 6: 7241
        • 7: 7268
        • 8: 4539
        • 9: 7299
        • 10: 4539
        • 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#73aviatickets4.6msselect * from `cities` where `cities`.`id` in (779, 7241, 7268, 7284, 7299, 8690, 9286, 9294, 9312)
        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#73aviatickets6.78msselect * from `cities` where `cities`.`id` in (4539)
        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#73aviatickets3.01msselect * from `sites_relationships` where `sites_relationships`.`id` in (46606, 273478, 366589, 366889, 368899, 369965, 370381, 370824, 498740)
        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
      • LocalRouteRepository.php#558aviatickets5.48msselect destination_city_id from `flights_by` where `origin_city_id` = 7321 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 7321
        • 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#73aviatickets4.17msselect * from `flights_by` where `origin_city_id` in (9312, 9294, 9286, 8690, 7284, 779, 7241, 7268, 4539, 7299) and `destination_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9312
        • 1: 9294
        • 2: 9286
        • 3: 8690
        • 4: 7284
        • 5: 779
        • 6: 7241
        • 7: 7268
        • 8: 4539
        • 9: 7299
        • 10: 4539
        • 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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets4.99msselect * from `cities` where `cities`.`id` in (779, 7241, 7268, 7284, 7299, 8690, 9286, 9294, 9312)
        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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets6.02msselect * from `cities` where `cities`.`id` in (4539)
        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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets2.12msselect * from `sites_relationships` where `sites_relationships`.`id` in (46606, 273478, 366589, 366889, 368899, 369965, 370381, 370824, 498740)
        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:85
      • CitySqlRepository.php#104aviatickets2.86msselect * from `cities` where `cities`.`id` = 779 limit 1
        Bindings
        • 0: 779
        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
      • OfferSqlRepository.php#52aviatickets1.56msselect * from `offers` where `origin_city_id` = 7321 and `destination_city_id` = 4539
        Bindings
        • 0: 7321
        • 1: 4539
        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#447aviatickets10.02msselect * from `flights_by` where `origin_city_id` = 7321 and `id` > 371489 and `destination_country_id` <> 6 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 7321
        • 1: 371489
        • 2: 6
        • 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#447aviatickets20.88msselect * from `cities` where `cities`.`id` in (7321)
        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#447aviatickets9.65msselect * from `cities` where `cities`.`id` in (5099, 8756, 9221)
        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#447aviatickets7.7msselect * from `sites_relationships` where `sites_relationships`.`id` in (371490, 371492, 371493)
        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#412aviatickets4.56msselect * from `flights_by` where `origin_city_id` = 7321 and `destination_country_id` <> 6 and (`price_one_way` > 0 or `price` > 0) and `id` not in (371490) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 7321
        • 1: 6
        • 2: 0
        • 3: 0
        • 4: 371490
        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.63msselect * from `cities` where `cities`.`id` in (7321)
        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#412aviatickets6.35msselect * from `cities` where `cities`.`id` in (1903, 3654)
        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#412aviatickets6.43msselect * from `sites_relationships` where `sites_relationships`.`id` in (371482, 498843)
        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#412aviatickets6.55msselect * from `countries` where `countries`.`id` in (17, 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#149aviatickets3.65msselect * from `flights_by` where `origin_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 4539
        • 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#149aviatickets2.9msselect * from `cities` where `cities`.`id` in (4539)
        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.76msselect * from `cities` where `cities`.`id` in (2686, 3505, 4081, 5960, 8389)
        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#149aviatickets3.99msselect * from `countries` where `countries`.`id` in (134, 220, 242, 248)
        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.74msselect * from `sites_relationships` where `sites_relationships`.`id` in (239765, 239994, 240116, 240243, 240667)
        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#359aviatickets11.69msselect * from `flights_by` where `origin_city_id` = 7321 and `destination_country_id` = 6 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 7321
        • 1: 6
        • 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
      • LocalRouteRepository.php#359aviatickets6.33msselect * from `cities` where `cities`.`id` in (7321)
        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
      • LocalRouteRepository.php#359aviatickets1.58msselect * from `cities` where `cities`.`id` in (3073, 7268, 9245, 9246, 9368)
        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
      • LocalRouteRepository.php#359aviatickets1.98msselect * from `sites_relationships` where `sites_relationships`.`id` in (371500, 371505, 498865, 885735, 1173481)
        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
      • LocalRouteRepository.php#359aviatickets3.18msselect * from `countries` where `countries`.`id` in (6)
        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#39aviatickets11.12msselect * from `timetables` where `origin_city_id` = 7321 and `destination_city_id` = 4539 order by `time_origin` asc limit 10
        Bindings
        • 0: 7321
        • 1: 4539
        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#144aviatickets2.66msselect * from `timetables` where `origin_city_id` = 7321 and `destination_city_id` = 4539 order by `travel_time` asc limit 1
        Bindings
        • 0: 7321
        • 1: 4539
        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#520aviatickets2.08msselect * from `flights_by` where `origin_city_id` = 4539 and `destination_city_id` = 7321 limit 1
        Bindings
        • 0: 4539
        • 1: 7321
        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#520aviatickets2.51msselect * from `sites_relationships` where `sites_relationships`.`id` in (240855)
        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#99aviatickets15.28msselect * from `cities` where `cities`.`id` = 7321 limit 1
        Bindings
        • 0: 7321
        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
      • RoutesController.php#547aviatickets1.55msselect * from `cities` where `cities`.`id` = 4539 limit 1
        Bindings
        • 0: 4539
        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#12aviatickets12.14msselect * from `cities` where `cities`.`id` = 7321 limit 1
        Bindings
        • 0: 7321
        Backtrace
        • view::routes.description-nearbyCities:12
        • 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
      150Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      55LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      45City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      36SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Country
      9Country.php#?
      App\Avia\Infrastructure\Model\Airline
      2Airline.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\SitesRela...
          _token
          oKa8enCCEvk1GkJyDvGYP2FrOEi4P44VRwWoND7R
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-saint-john-to-new-york-ysj-nyc?_url=...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-saint-john-to-new-york-ysj-nyc
          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-saint-john-to-new-york-ysj-nyc" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpRTzMzdTc1UXZEc2txZmx6Y3BTaUE9PSIsInZhbHVlIjoiSzV4MTkrTHN1ditmSGh1UnZtcTJ1VDgwTURDNW1iRHlvZEdHamZvb3V4blJBMk1iaUhSR1hjWEFuY2pQdHdiNmp2Kzc3aHNvMXpTV01EeU5PK2pmNER0TVBhNWlqWkJUMHc3L0d4VUZNeUdNYWxseXBuYUxPYk52VzM4OUpDdjYiLCJtYWMiOiJhZTk4Yzk3ZWNkZmZlYzRiYmI4Mzc1ZDcwZDQ4YTNhOGUyYmM2ZDEzNTJmYThlMjZmMWU0YWI0MTNlYTA2YTEwIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6ImFWQU5PYmFnYWVveWpJeUhXclFURUE9PSIsInZhbHVlIjoibnBMMmh5Ym9BRmFRODJ5UnNvckkxZU9Ca3Z4WHVZakR4MkdRWkhsNmpLWlpadUZNOFNTTGdFSnFSL2pscCsrTUdGRzROQzk1Vit2MGJMTDQzeVg0Y1Q0bUl6TnVBSTN5SEVIVFJxaVdrTHdYNjdGaFl2bWVDUGJhYXIwelhYb28iLCJtYWMiOiJkMDU1N2QwMTUyYjlkMGI3MWM0NjI2MTc4ZmNlM2I4YWU1ZmU1MWJkNTJhNDQxOWU1NDY4ZjNjODZkM2YwYTZlIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IlpRTzMzdTc1UXZEc2txZmx6Y3BTaUE9PSIsInZhbHVlIjoiSzV4MTkrTHN1ditmSGh1UnZtcTJ1VDgwTURDNW1iRHlvZEdHamZvb3V4blJBMk1iaUhSR1hjWEFuY2pQdHdiNmp2Kzc3a" ] "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
          0 of 0
          array:2 [ "XSRF-TOKEN" => "oKa8enCCEvk1GkJyDvGYP2FrOEi4P44VRwWoND7R" "lowcostclub_session" => "IWeTScZyfrKefmrUui45HwIr0adHJCB5sIjyXyq8" ]
          response_headers
          0 of 0
          array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Tue, 13 May 2025 07:40:11 GMT" ] "etag" => array:1 [ 0 => ""977c9507687396b18e1bf97f2b8bbc34"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik15VjBPUHFkYSswNXdrMzNjaE9qb0E9PSIsInZhbHVlIjoiZHUrSGRsUTBnU2lSS0ZkQkIxZlhRdzYyeXpLUmJWdXVhUjhDYnNTWjRiQUZDOGsreUpZVWpXSmltcTU5ZUpBS2RFZURtZ0hYUUY0VXRxS202KzdiblVnWlpWTFVJRGtFVzZUaVdRZmsybklHZVVJY1FoZXJvVXc0WkRWNnptRloiLCJtYWMiOiJiODdjZmZiMGI5YTUxYTExOGUxYzZkMzliODY2NjY1OTZmMGEwNWUyZjZlMjA0MzUxMDU3YzgzODRmODNiMTAyIiwidGFnIjoiIn0%3D; expires=Tue, 13 May 2025 09:40:11 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ik15VjBPUHFkYSswNXdrMzNjaE9qb0E9PSIsInZhbHVlIjoiZHUrSGRsUTBnU2lSS0ZkQkIxZlhRdzYyeXpLUmJWdXVhUjhDYnNTWjRiQUZDOGsreUpZVWpXSmltcTU5ZUpBS2RFZURtZ" 1 => "lowcostclub_session=eyJpdiI6IjY1bndoVmNkclB6VHJaaHEvaGN6WVE9PSIsInZhbHVlIjoiTTlYU3pQdkhIMEpqRTdGaDNrWUJKWEpLL25FTTFYSG8yUW9rViswaEdkK1FpRCtVc2RlamN1dlU4WDUvV1M5RUloeFlZVmVhYnhGdmhmakRRbmFWeUgzZVZVU08yZDBqWkdNUVdQUFJoeG5ZR0pGMlR4emsrMWNvVEM4YndMejkiLCJtYWMiOiIxZjNjNDhmNTEwNDcyMTA2ZjNiZWZjZThkMTkzYjIxZDI3OGNiNWFhNWE3OTY3ODRiODNkN2E5NzNhM2ExMmYxIiwidGFnIjoiIn0%3D; expires=Tue, 13 May 2025 09:40:11 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6IjY1bndoVmNkclB6VHJaaHEvaGN6WVE9PSIsInZhbHVlIjoiTTlYU3pQdkhIMEpqRTdGaDNrWUJKWEpLL25FTTFYSG8yUW9rViswaEdkK1FpRCtVc2RlamN1dlU4WDUvV1M5" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik15VjBPUHFkYSswNXdrMzNjaE9qb0E9PSIsInZhbHVlIjoiZHUrSGRsUTBnU2lSS0ZkQkIxZlhRdzYyeXpLUmJWdXVhUjhDYnNTWjRiQUZDOGsreUpZVWpXSmltcTU5ZUpBS2RFZURtZ0hYUUY0VXRxS202KzdiblVnWlpWTFVJRGtFVzZUaVdRZmsybklHZVVJY1FoZXJvVXc0WkRWNnptRloiLCJtYWMiOiJiODdjZmZiMGI5YTUxYTExOGUxYzZkMzliODY2NjY1OTZmMGEwNWUyZjZlMjA0MzUxMDU3YzgzODRmODNiMTAyIiwidGFnIjoiIn0%3D; expires=Tue, 13-May-2025 09:40:11 GMT; path=/XSRF-TOKEN=eyJpdiI6Ik15VjBPUHFkYSswNXdrMzNjaE9qb0E9PSIsInZhbHVlIjoiZHUrSGRsUTBnU2lSS0ZkQkIxZlhRdzYyeXpLUmJWdXVhUjhDYnNTWjRiQUZDOGsreUpZVWpXSmltcTU5ZUpBS2RFZURtZ" 1 => "lowcostclub_session=eyJpdiI6IjY1bndoVmNkclB6VHJaaHEvaGN6WVE9PSIsInZhbHVlIjoiTTlYU3pQdkhIMEpqRTdGaDNrWUJKWEpLL25FTTFYSG8yUW9rViswaEdkK1FpRCtVc2RlamN1dlU4WDUvV1M5RUloeFlZVmVhYnhGdmhmakRRbmFWeUgzZVZVU08yZDBqWkdNUVdQUFJoeG5ZR0pGMlR4emsrMWNvVEM4YndMejkiLCJtYWMiOiIxZjNjNDhmNTEwNDcyMTA2ZjNiZWZjZThkMTkzYjIxZDI3OGNiNWFhNWE3OTY3ODRiODNkN2E5NzNhM2ExMmYxIiwidGFnIjoiIn0%3D; expires=Tue, 13-May-2025 09:40:11 GMT; path=/; httponlylowcostclub_session=eyJpdiI6IjY1bndoVmNkclB6VHJaaHEvaGN6WVE9PSIsInZhbHVlIjoiTTlYU3pQdkhIMEpqRTdGaDNrWUJKWEpLL25FTTFYSG8yUW9rViswaEdkK1FpRCtVc2RlamN1dlU4WDUvV1M5" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "oKa8enCCEvk1GkJyDvGYP2FrOEi4P44VRwWoND7R" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-saint-john-to-new-york-ysj-nyc?_url=%2Fcheap-flights-from-saint-john-to-new-york-ysj-nyc" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-13 07:40:11GET/cheap-flights-from-saint-john-to-new-york-ysj-nyc52522983