Cheap flights Bakersfield — Halifax (BFL — YHZ)

Good to know - Cheap tickets Bakersfield — Halifax

Flight distance 4739 km
Round-trip from $803

Popular airlines flying Bakersfield — Halifax

Flight Bakersfield – Halifax is served by 1 airlines.

Routes from nearby cities to Halifax

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

The most frequent flight to Halifax is from San Diego. The cheapest airfare can be purchased with a flight from Los Angeles from $291. The nearest airports from Bakersfield with a flight to Halifax are in Las Vegas.

Popular International routes from Bakersfield

Popular routes from Halifax

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

Popular domestic routes from Bakersfield

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 Version721msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (45.11ms)time
    • Application (675ms)time
    • 1 x Application (93.74%)
      675ms
      1 x Booting (6.26%)
      45.11ms
      49 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
      • 1x components.airlines-columnairlines-column.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 22x 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
      56 statements were executed (7 duplicates)Show only duplicates253ms
      • 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#34aviatickets16.26msselect * from `sites_relationships` where `us` = 'cheap-flights-from-bakersfield-to-halifax-bfl-yhz' limit 1
        Bindings
        • 0: cheap-flights-from-bakersfield-to-halifax-bfl-yhz
        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.22msselect * from `flights_by` where `flights_by`.`id` = '786004' 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.41msselect * from `cities` where `cities`.`id` = 532 limit 1
        Bindings
        • 0: 532
        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#136aviatickets3.26msselect * from `countries` where `countries`.`id` = 92 limit 1
        Bindings
        • 0: 92
        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#137aviatickets2.61msselect * from `cities` where `cities`.`id` = 9286 limit 1
        Bindings
        • 0: 9286
        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#138aviatickets2.62msselect * from `countries` where `countries`.`id` = 6 limit 1
        Bindings
        • 0: 6
        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#33aviatickets3.18msselect * from `sites_relationships` where `sites_relationships`.`id` = 786004 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 786004
        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#31aviatickets2.79msselect * 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#42aviatickets10.67msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 532 and `destination_id` = 9286 and `date_update` >= '2025-05-11 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 532
        • 1: 9286
        • 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#66aviatickets1.6msselect * from `monthly_price_statistics` where `origin_city_id` = 532 and `destination_city_id` = 9286 limit 1
        Bindings
        • 0: 532
        • 1: 9286
        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.44msselect * from `timetables` where `origin_city_id` = 532 and `destination_city_id` = 9286 order by `time_origin` asc limit 1000
        Bindings
        • 0: 532
        • 1: 9286
        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.26msselect distinct `airline_id` from `timetables` where `origin_city_id` = 532
        Bindings
        • 0: 532
        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.53msselect distinct `airline_id` from `timetables` where `origin_city_id` = 9286
        Bindings
        • 0: 9286
        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.79msselect * from `airlines` where `id` in (5184) order by `name` asc
        Bindings
        • 0: 5184
        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#558aviatickets2.02msselect destination_city_id from `flights_by` where `origin_city_id` = 532 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 532
        • 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.15msselect * from `flights_by` where `origin_city_id` in (5479, 1843, 3448, 8645, 589, 4150, 5099, 5623, 5470, 3445) and `destination_city_id` = 9286 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5479
        • 1: 1843
        • 2: 3448
        • 3: 8645
        • 4: 589
        • 5: 4150
        • 6: 5099
        • 7: 5623
        • 8: 5470
        • 9: 3445
        • 10: 9286
        • 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#73aviatickets2.32msselect * from `cities` where `cities`.`id` in (3445, 3448, 4150, 5099, 5470, 5479, 5623)
        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.43msselect * from `cities` where `cities`.`id` in (9286)
        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.42msselect * from `sites_relationships` where `sites_relationships`.`id` in (181274, 289431, 437460, 473303, 477245, 841569, 1160105)
        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#104aviatickets2.21msselect * from `cities` where `cities`.`id` = 3445 limit 1
        Bindings
        • 0: 3445
        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#104aviatickets14.29msselect * from `cities` where `cities`.`id` = 3448 limit 1
        Bindings
        • 0: 3448
        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.37msselect * from `cities` where `cities`.`id` = 5470 limit 1
        Bindings
        • 0: 5470
        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#52aviatickets2.95msselect * from `offers` where `origin_city_id` = 532 and `destination_city_id` = 9286
        Bindings
        • 0: 532
        • 1: 9286
        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#447aviatickets2.62msselect * from `flights_by` where `origin_city_id` = 532 and `id` > 786004 and `destination_country_id` <> 92 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 532
        • 1: 786004
        • 2: 92
        • 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#447aviatickets3.97msselect * from `cities` where `cities`.`id` in (532)
        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.56msselect * from `cities` where `cities`.`id` in (201, 4051, 9245)
        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#447aviatickets2.38msselect * from `sites_relationships` where `sites_relationships`.`id` in (786005, 1016281, 1081148)
        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#412aviatickets2.93msselect * from `flights_by` where `origin_city_id` = 532 and `destination_country_id` <> 92 and (`price_one_way` > 0 or `price` > 0) and `id` not in (786005) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 532
        • 1: 92
        • 2: 0
        • 3: 0
        • 4: 786005
        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#412aviatickets2.69msselect * from `cities` where `cities`.`id` in (532)
        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#412aviatickets3.03msselect * from `cities` where `cities`.`id` in (4051, 5632)
        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#412aviatickets3.59msselect * from `sites_relationships` where `sites_relationships`.`id` in (388570, 1081148)
        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#412aviatickets19.01msselect * from `countries` where `countries`.`id` in (15, 58)
        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#149aviatickets4.19msselect * from `flights_by` where `origin_city_id` = 9286 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 9286
        • 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.57msselect * from `cities` where `cities`.`id` in (9286)
        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#149aviatickets22.89msselect * from `cities` where `cities`.`id` in (774, 1462, 3785, 4051, 4081)
        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.26msselect * from `countries` where `countries`.`id` in (58, 123, 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.21msselect * from `sites_relationships` where `sites_relationships`.`id` in (366725, 366765, 366855, 366873, 366874)
        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#359aviatickets2.17msselect * from `flights_by` where `origin_city_id` = 532 and `destination_country_id` = 92 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 532
        • 1: 92
        • 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#359aviatickets6msselect * from `cities` where `cities`.`id` in (532)
        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#359aviatickets4.98msselect * from `cities` where `cities`.`id` in (4539, 4923, 7738, 8617, 8756)
        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.21msselect * from `sites_relationships` where `sites_relationships`.`id` in (32050, 32067, 32120, 32134, 32157)
        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.84msselect * from `countries` where `countries`.`id` in (92)
        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#39aviatickets3.76msselect * from `timetables` where `origin_city_id` = 532 and `destination_city_id` = 9286 order by `time_origin` asc limit 10
        Bindings
        • 0: 532
        • 1: 9286
        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#144aviatickets5.94msselect * from `timetables` where `origin_city_id` = 532 and `destination_city_id` = 9286 order by `travel_time` asc limit 1
        Bindings
        • 0: 532
        • 1: 9286
        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#520aviatickets1.7msselect * from `flights_by` where `origin_city_id` = 9286 and `destination_city_id` = 532 limit 1
        Bindings
        • 0: 9286
        • 1: 532
        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
      • description-nearbyCities.blade.php#28aviatickets7.81msselect * from `cities` where `cities`.`id` = 532 limit 1
        Bindings
        • 0: 532
        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
      • LocalRouteRepository.php#175aviatickets2.16msselect * from `flights_by` where `id` in (240458, 46235, 180255, 46251, 201516, 32301)
        Bindings
        • 0: 240458
        • 1: 46235
        • 2: 180255
        • 3: 46251
        • 4: 201516
        • 5: 32301
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#175aviatickets3.56msselect * from `cities` where `cities`.`id` in (537, 779, 3448, 3796, 4539)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#175aviatickets5.49msselect * from `cities` where `cities`.`id` in (2122, 3301, 5136, 7738, 8381, 8447)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#175aviatickets14.16msselect * from `countries` where `countries`.`id` in (17, 70, 79, 92, 105)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#175aviatickets2.72msselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#149aviatickets5.33msselect * from `flights_by` where `origin_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) and `id` not in (240458, 46235, 180255, 46251, 201516, 32301) order by `count` desc limit 9
        Bindings
        • 0: 4539
        • 1: 0
        • 2: 0
        • 3: 240458
        • 4: 46235
        • 5: 180255
        • 6: 46251
        • 7: 201516
        • 8: 32301
        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/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets3.16msselect * 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/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets10.5msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3505, 3951, 4081, 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/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets5.11msselect * from `countries` where `countries`.`id` in (92, 134, 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/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets9.66msselect * from `sites_relationships` where `sites_relationships`.`id` in (239645, 239765, 239824, 239994, 240101, 240103, 240116, 240218, 240243)
        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/Avia/Application/SeoRoutesHandler.php:54
      App\Avia\Infrastructure\Model\City
      54City.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      48LocalRoute.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      39SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Timetable
      39Timetable.php#?
      App\Avia\Infrastructure\Model\Country
      17Country.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
      App\Avia\Infrastructure\Model\Airline
      1Airline.php#?
            _token
            QPCSpTIrzucTg6fcBqyylZrFQbO1JwHcfoEurF9k
            _previous
            array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-bakersfield-to-halifax-bfl-yhz?_url=...
            _flash
            array:2 [ "old" => [] "new" => [] ]
            path_info
            /cheap-flights-from-bakersfield-to-halifax-bfl-yhz
            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-bakersfield-to-halifax-bfl-yhz" ]
            request_request
            []
            
            request_headers
            0 of 0
            array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjZhakJkZGFpN2sxN1k3VFBsenRFVkE9PSIsInZhbHVlIjoiVXdpT05CZGMxSXc1SVRXUERuS2xsWjVlQy9KRE12a3RhVzgzYU1zc2p2N2JnNEk5MUVVOHdHNFljNnU3UDA5eWV2QzdteHZLNVNtK0M4bWF3d0xXMmJpSVpOaHQ4NTAxdkpRV3BOcUlvajNITkRkRnYvYVdmNXZ4VDNyV2Z2SkkiLCJtYWMiOiJkZjBmZDcwODBmMTlkZDdjNWY2MDU4NGE5NDBmOGFlYWQyM2RiZmY1MWUwNTU4ZTQ4NjI5ZTlhZTlkZDllMDRlIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IlovQUkxenZGT3ZzSTVOK0szRDVFeFE9PSIsInZhbHVlIjoiMUgxNGJSRUhnam9rVUxGVmE0a1RIOE9nWHBCZlgxS1BlN292N09sTkJmWkF6U2h4YktHZkJ2UCt3cFBtK1dGcWFRclNuUnNuNVk1aFFZSXJXTFdBQzd6L3lCdEVjOHJicTN4ZmJOKzZTeGMvZlY5MlZWVU9rRlRaL3JEMnkxOTAiLCJtYWMiOiI0YTBiZjRmN2FjZTViYmRiNTc5Y2U3YjUzNWUyYWRmNTFmM2Y5MzI5ZmU0MmU3YzY3MzY3Y2Y1YjAyNGMzMjY2IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IjZhakJkZGFpN2sxN1k3VFBsenRFVkE9PSIsInZhbHVlIjoiVXdpT05CZGMxSXc1SVRXUERuS2xsWjVlQy9KRE12a3RhVzgzYU1zc2p2N2JnNEk5MUVVOHdHNFljNnU3UDA5eWV2Qzdte" ] "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" => "QPCSpTIrzucTg6fcBqyylZrFQbO1JwHcfoEurF9k" "lowcostclub_session" => "6nnYrUUr66PfMQGqAJSoHWlHPEQ1QSib4d1Jrxh0" ]
            response_headers
            0 of 0
            array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Tue, 13 May 2025 09:04:55 GMT" ] "etag" => array:1 [ 0 => ""7b186c4c56a5a940c094477071c286ed"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkRqMDVTTk8vd3YweDZNc3lGc2ZKMEE9PSIsInZhbHVlIjoiaXBJRk9iQUkyZWlGdDNMN1JmNE1IZFE4QnAwM2diUXVhUkM0b1dLblFIcGpiYTB6dkhVSjlJMmhybjAwQlJRaXU0Z0k1R0t0YXFOQ2JWUWI2YXNDeWY0WWwwenVxWUtCb3oxMXJlcUdWeXRmclgxSTdzQWZVVEtJNVQ0Q3NaTlEiLCJtYWMiOiI5NDg3MzQwZmIyNTU4YWM4NDY3MjcwMTk5N2E2Yjc3NGJmZDUwMzg5NTlkOWRmMDFhZjUyNjI4MmI4M2U1OWE5IiwidGFnIjoiIn0%3D; expires=Tue, 13 May 2025 11:04:55 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkRqMDVTTk8vd3YweDZNc3lGc2ZKMEE9PSIsInZhbHVlIjoiaXBJRk9iQUkyZWlGdDNMN1JmNE1IZFE4QnAwM2diUXVhUkM0b1dLblFIcGpiYTB6dkhVSjlJMmhybjAwQlJRaXU0Z0k1R" 1 => "lowcostclub_session=eyJpdiI6IitPeWx3OXpxQmcreW1kTVpJME1lT2c9PSIsInZhbHVlIjoiQ09iSHpWTXBmazBNbHVTb1hzbWFMUWF0VTBOTnVvOHdtUHlpQ3U5VUs4T0tleEprb3ZzdDIyNmxzOWVyQTI4WkFrZzZBbXBCd2VUbVFNOFg0QUkzV0JHUmFGNXovdXBJRVIyWmwvWGgwTDdsUmlWSFdVeUFlQTNLUTlGaThNaG0iLCJtYWMiOiJjNjY2OTVmNWU5OTdiMGJkMWQ3MWQ4MjVkYjk3OGJjNDAwNWMxNjYwYjVkZmQwZjU3NGJjZjI3OGM0OWRhMzBiIiwidGFnIjoiIn0%3D; expires=Tue, 13 May 2025 11:04:55 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6IitPeWx3OXpxQmcreW1kTVpJME1lT2c9PSIsInZhbHVlIjoiQ09iSHpWTXBmazBNbHVTb1hzbWFMUWF0VTBOTnVvOHdtUHlpQ3U5VUs4T0tleEprb3ZzdDIyNmxzOWVyQTI4" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkRqMDVTTk8vd3YweDZNc3lGc2ZKMEE9PSIsInZhbHVlIjoiaXBJRk9iQUkyZWlGdDNMN1JmNE1IZFE4QnAwM2diUXVhUkM0b1dLblFIcGpiYTB6dkhVSjlJMmhybjAwQlJRaXU0Z0k1R0t0YXFOQ2JWUWI2YXNDeWY0WWwwenVxWUtCb3oxMXJlcUdWeXRmclgxSTdzQWZVVEtJNVQ0Q3NaTlEiLCJtYWMiOiI5NDg3MzQwZmIyNTU4YWM4NDY3MjcwMTk5N2E2Yjc3NGJmZDUwMzg5NTlkOWRmMDFhZjUyNjI4MmI4M2U1OWE5IiwidGFnIjoiIn0%3D; expires=Tue, 13-May-2025 11:04:55 GMT; path=/XSRF-TOKEN=eyJpdiI6IkRqMDVTTk8vd3YweDZNc3lGc2ZKMEE9PSIsInZhbHVlIjoiaXBJRk9iQUkyZWlGdDNMN1JmNE1IZFE4QnAwM2diUXVhUkM0b1dLblFIcGpiYTB6dkhVSjlJMmhybjAwQlJRaXU0Z0k1R" 1 => "lowcostclub_session=eyJpdiI6IitPeWx3OXpxQmcreW1kTVpJME1lT2c9PSIsInZhbHVlIjoiQ09iSHpWTXBmazBNbHVTb1hzbWFMUWF0VTBOTnVvOHdtUHlpQ3U5VUs4T0tleEprb3ZzdDIyNmxzOWVyQTI4WkFrZzZBbXBCd2VUbVFNOFg0QUkzV0JHUmFGNXovdXBJRVIyWmwvWGgwTDdsUmlWSFdVeUFlQTNLUTlGaThNaG0iLCJtYWMiOiJjNjY2OTVmNWU5OTdiMGJkMWQ3MWQ4MjVkYjk3OGJjNDAwNWMxNjYwYjVkZmQwZjU3NGJjZjI3OGM0OWRhMzBiIiwidGFnIjoiIn0%3D; expires=Tue, 13-May-2025 11:04:55 GMT; path=/; httponlylowcostclub_session=eyJpdiI6IitPeWx3OXpxQmcreW1kTVpJME1lT2c9PSIsInZhbHVlIjoiQ09iSHpWTXBmazBNbHVTb1hzbWFMUWF0VTBOTnVvOHdtUHlpQ3U5VUs4T0tleEprb3ZzdDIyNmxzOWVyQTI4" ] ]
            session_attributes
            0 of 0
            array:3 [ "_token" => "QPCSpTIrzucTg6fcBqyylZrFQbO1JwHcfoEurF9k" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-bakersfield-to-halifax-bfl-yhz?_url=%2Fcheap-flights-from-bakersfield-to-halifax-bfl-yhz" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
            ClearShow all
            Date ↕MethodURLData
            #12025-05-13 09:04:55GET/cheap-flights-from-bakersfield-to-halifax-bfl-yhz4956199