Cheap flights Rotorua — Kerikeri (ROT — KKE)

Good to know - Cheap tickets Rotorua — Kerikeri

Cheapest flight found $88
Flight distance 382 km
Round-trip from $171

Airfare Rotorua – Kerikeri by month

Here you can find out in what months how much a ticket Rotorua – Kerikeri costs to buy cheap plane tickets.

Month One-way Round-trip
April 2024

Remember that the optimal time for booking air tickets is 59 days before the departure date, this is the average time at which air tickets were sold at the lowest prices.

Popular airlines flying Rotorua — Kerikeri

Flight Rotorua – Kerikeri is served by 1 airlines.

Flights Rotorua — Kerikeri

The selection of cheap flights Rotorua — Kerikeri

Here you can find and purchase the cheapest flights Rotorua — Kerikeri from $88 and Rotorua — Kerikeri — Rotorua from $171.

The price of the flight Rotorua — Kerikeri (New Zealand) — Rotorua from $171 (round-trip).

The average price of the flight Rotorua — Kerikeri (New Zealand) — Rotorua $171 (round-trip).

Low cost flights Rotorua — Kerikeri (ROT — KKE)

The distance between Rotorua and Kerikeri 237 miles (or 382 kilometres).

The time difference between Rotorua and Kerikeri is 0 h.

LowCostClub always do a comparison of airfares Rotorua — Kerikeri with several airlines (include Air New Zealand). They will always give you all available options so you can find the cheapest flight to Kerikeri. In addition, you can choose the platform where you want to place your orders. There are also special offers for air tickets Rotorua — Kerikeri. Last week, for instance, the cheapest round-trip prices stood at $171 while the cheapest one-way price that was available within the last week cost $88

Routes from nearby cities to Kerikeri

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

The most frequent flight to Kerikeri is from Auckland, which is the closest city to Rotorua with the lowest price, from $51 per one-way.

Popular International routes from Rotorua

Popular routes from Kerikeri

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

Popular domestic routes from Rotorua

FAQ about Rotorua — Kerikeri

Yes, you can fly from Rotorua to Kerikeri. Rotorua has an airport (Rotorua International Airport) for flights. There is a non-direct flight through Air New Zealand.

The price of flights Rotorua — Kerikeri starts from $88.

In Rotorua — Rotorua International Airport. In Kerikeri — Kerikeri Airport.

High season is considered to be and the cheapest month is . Enter your preferred airports (or cities) and dates into the search form above to unlock the latest Rotorua — Kerikeri flight deals.

All the following airlines flights Rotorua — Kerikeri: Air New Zealand.

Low price calendar

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 Version439msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (50.92ms)time
    • Application (388ms)time
    • 1 x Application (88.41%)
      388ms
      1 x Booting (11.59%)
      50.92ms
      54 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.section-MonthlyPricesection-MonthlyPrice.blade.php#?blade
      • 1x routes.section-timetablesection-timetable.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 1x components.airlines-columnairlines-column.blade.php#?blade
      • 1x routes.section-DynamicsAirfaresection-DynamicsAirfare.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.faqfaq.blade.php#?blade
      • 1x components.calendarcalendar.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
      55 statements were executed (18 duplicates)Show only duplicates116ms
      • 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.73msselect * from `sites_relationships` where `us` = 'cheap-flights-from-rotorua-to-kerikeri-rot-kke' limit 1
        Bindings
        • 0: cheap-flights-from-rotorua-to-kerikeri-rot-kke
        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.28msselect * from `flights_by` where `flights_by`.`id` = '284226' 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.11msselect * from `cities` where `cities`.`id` = 5381 limit 1
        Bindings
        • 0: 5381
        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#136aviatickets8.67msselect * from `countries` where `countries`.`id` = 214 limit 1
        Bindings
        • 0: 214
        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.61msselect * from `cities` where `cities`.`id` = 9035 limit 1
        Bindings
        • 0: 9035
        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.4msselect * from `countries` where `countries`.`id` = 214 limit 1
        Bindings
        • 0: 214
        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.47msselect * from `sites_relationships` where `sites_relationships`.`id` = 284226 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 284226
        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.28msselect * 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.56msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 5381 and `destination_id` = 9035 and `date_update` >= '2025-04-29 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 5381
        • 1: 9035
        • 2: 2025-04-29 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.66msselect * from `monthly_price_statistics` where `origin_city_id` = 5381 and `destination_city_id` = 9035 limit 1
        Bindings
        • 0: 5381
        • 1: 9035
        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.33msselect * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 9035 order by `time_origin` asc limit 1000
        Bindings
        • 0: 5381
        • 1: 9035
        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.31msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5381
        Bindings
        • 0: 5381
        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.56msselect distinct `airline_id` from `timetables` where `origin_city_id` = 9035
        Bindings
        • 0: 9035
        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#90aviatickets4.27msselect * from `airlines` where `id` in (343) order by `name` asc
        Bindings
        • 0: 343
        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.48msselect destination_city_id from `flights_by` where `origin_city_id` = 5381 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 5381
        • 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#73aviatickets1.93msselect * from `flights_by` where `origin_city_id` in (6284, 9009, 2107, 8612, 8325, 4472, 4993, 6749, 6701, 9035) and `destination_city_id` = 9035 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 6284
        • 1: 9009
        • 2: 2107
        • 3: 8612
        • 4: 8325
        • 5: 4472
        • 6: 4993
        • 7: 6749
        • 8: 6701
        • 9: 9035
        • 10: 9035
        • 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.12msselect * from `cities` where `cities`.`id` in (2107, 4472, 4993, 6284, 6701, 8325, 8612)
        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.41msselect * from `cities` where `cities`.`id` in (9035)
        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 (8441, 876121, 948747, 1140696, 1159329, 1169994, 1183248)
        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.72msselect * from `cities` where `cities`.`id` = 8325 limit 1
        Bindings
        • 0: 8325
        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#52aviatickets950μsselect * from `offers` where `origin_city_id` = 5381 and `destination_city_id` = 9035
        Bindings
        • 0: 5381
        • 1: 9035
        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.77msselect * from `flights_by` where `origin_city_id` = 5381 and `id` > 284226 and `destination_country_id` <> 214 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 5381
        • 1: 284226
        • 2: 214
        • 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#447aviatickets1msselect * from `cities` where `cities`.`id` in (5381)
        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 `cities` where `cities`.`id` in (3448, 3654, 3873)
        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#447aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` in (284227, 284228, 284230)
        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#412aviatickets1.36msselect * from `flights_by` where `origin_city_id` = 5381 and `destination_country_id` <> 214 and (`price_one_way` > 0 or `price` > 0) and `id` not in (284227) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 5381
        • 1: 214
        • 2: 0
        • 3: 0
        • 4: 284227
        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.1msselect * from `cities` where `cities`.`id` in (5381)
        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.47msselect * from `cities` where `cities`.`id` in (4325, 5907)
        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#412aviatickets990μsselect * from `sites_relationships` where `sites_relationships`.`id` in (284233, 284241)
        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#412aviatickets7.08msselect * from `countries` where `countries`.`id` in (8, 82)
        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#149aviatickets2.37msselect * from `flights_by` where `origin_city_id` = 9035 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 9035
        • 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#149aviatickets1.12msselect * from `cities` where `cities`.`id` in (9035)
        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.36msselect * from `cities` where `cities`.`id` in (70, 3873, 4880, 5907, 8435)
        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.34msselect * from `countries` where `countries`.`id` in (8)
        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.3msselect * from `sites_relationships` where `sites_relationships`.`id` in (166156, 166158, 1190953, 1190967, 1190975)
        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.16msselect * from `flights_by` where `origin_city_id` = 5381 and `destination_country_id` = 214 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 5381
        • 1: 214
        • 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#359aviatickets4.1msselect * from `cities` where `cities`.`id` in (5381)
        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#359aviatickets2.39msselect * from `cities` where `cities`.`id` in (1609, 6701, 6951, 7485, 8355)
        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#359aviatickets9.69msselect * from `sites_relationships` where `sites_relationships`.`id` in (284219, 284221, 284234, 284243, 284245)
        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#359aviatickets860μsselect * from `countries` where `countries`.`id` in (214)
        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#39aviatickets890μsselect * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 9035 order by `time_origin` asc limit 10
        Bindings
        • 0: 5381
        • 1: 9035
        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#144aviatickets3.9msselect * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 9035 order by `travel_time` asc limit 1
        Bindings
        • 0: 5381
        • 1: 9035
        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.12msselect * from `flights_by` where `origin_city_id` = 9035 and `destination_city_id` = 5381 limit 1
        Bindings
        • 0: 9035
        • 1: 5381
        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#520aviatickets860μsselect * from `sites_relationships` where `sites_relationships`.`id` in (166157)
        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#99aviatickets2.25msselect * from `cities` where `cities`.`id` = 5381 limit 1
        Bindings
        • 0: 5381
        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#547aviatickets3.25msselect * from `cities` where `cities`.`id` = 9035 limit 1
        Bindings
        • 0: 9035
        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
      • City.php#136aviatickets2.12msselect * from `airports` where `airports`.`city_id` = 5381 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 5381
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:100
        • 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
      • City.php#136aviatickets1.25msselect * from `airports` where `airports`.`city_id` = 9035 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 9035
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:127
        • 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
      • description-nearbyCities.blade.php#12aviatickets1.04msselect * from `cities` where `cities`.`id` = 5381 limit 1
        Bindings
        • 0: 5381
        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
      • FlightSqlRepository.php#98aviatickets1.01msselect * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 9035
        Bindings
        • 0: 5381
        • 1: 9035
        Backtrace
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:98
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:104
        • app/Avia/Infrastructure/FaqRouteFactory/AreThereDirectFlights.php:21
      • CanWeFlyFromTo.php#30aviatickets1.07msselect * from `airports` where `airports`.`city_id` = 5381 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 5381
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:30
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:313
      • CanWeFlyFromTo.php#35aviatickets1.31msselect * from `airports` where `airports`.`city_id` = 9035 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 9035
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:35
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:313
      • TimetableRepository.php#39aviatickets1.32msselect * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 9035 order by `time_origin` asc limit 1000
        Bindings
        • 0: 5381
        • 1: 9035
        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/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:42
      • TimetableRepository.php#144aviatickets3.04msselect * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 9035 order by `travel_time` asc limit 1
        Bindings
        • 0: 5381
        • 1: 9035
        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/Avia/Infrastructure/FaqRouteFactory/HowLongDoesItTakeToFly.php:27
      • MonthlyPriceStatisticSqlRepository.php#66aviatickets920μsselect * from `monthly_price_statistics` where `origin_city_id` = 5381 and `destination_city_id` = 9035 limit 1
        Bindings
        • 0: 5381
        • 1: 9035
        Backtrace
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:44
        • app/Avia/Infrastructure/FaqRouteFactory/WhatMonthCheapest.php:27
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
      App\Avia\Infrastructure\Model\LocalRoute
      34LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      33City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      25SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Country
      6Country.php#?
      App\Avia\Infrastructure\Model\Airport
      4Airport.php#?
      App\Avia\Infrastructure\Model\Timetable
      3Timetable.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      2MonthlyPriceStatistic.php#?
      App\Avia\Infrastructure\Model\Airline
      1Airline.php#?
          • infoModel: App\Avia\Infrastructure\Model\City => Relation: App\Avia\Infrastructure\Model\Airport - You s...
          _token
          3oLsWRxXmxbJYYEsirHXuPVdQwwXCjksBosxkKaJ
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-rotorua-to-kerikeri-rot-kke?_url=%2F...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-rotorua-to-kerikeri-rot-kke
          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-rotorua-to-kerikeri-rot-kke" ]
          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 => "Thu, 01 May 2025 09:25:58 GMT" ] "etag" => array:1 [ 0 => ""b5aec055dcf2802a090d862dd7b43166"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkRBN2RVekFDWTVRWlgyZW42cCtKUFE9PSIsInZhbHVlIjoiZnFkNk5IbEhzUndlVk9DeHdnMTY0TVZxWVdlbWkrQ3dOd3hkVmI5dTlkS1pJVEdPbEhjU0ltc1g4M3VDQlV3eE91VTlOa1FtakNVTjVIMUd5N1U0OG5EOU15aEJwTGU4MDNQUUxBK3JJaXYxT0s4dVo1NUx4Z0tBb3QwbEZSU1ciLCJtYWMiOiI0NTVlZTE3OTI2MjI1ZmUxN2MwNzEyMWZkZTQ3NjViMTE4ZTY1ODI5NjQ0OTM0MGZkNWQ1M2U5YjU1ODNjMzgwIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 11:25:58 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkRBN2RVekFDWTVRWlgyZW42cCtKUFE9PSIsInZhbHVlIjoiZnFkNk5IbEhzUndlVk9DeHdnMTY0TVZxWVdlbWkrQ3dOd3hkVmI5dTlkS1pJVEdPbEhjU0ltc1g4M3VDQlV3eE91VTlOa" 1 => "lowcostclub_session=eyJpdiI6InlTQzhHaHhHeWNVVXhYV2N4b1BXdXc9PSIsInZhbHVlIjoicXVXSmFTVGUvbHY0K1lwMXRBc2cwTnMyZE04NU8rSmhpWFRGZ2xwT20vcGFLME5RV0lvSVpNQTlic1Z3cVdoMlVtakREMHd1Q1JCbFhqY1V1T1Y4VjI2d051Z3YyajJUaEhJYjZsMDgzYUhMc1NYN1BDd1Y5N2VCcVh2OTdNTnciLCJtYWMiOiI5MWVmNTRjODYzYmRlNzQ4NDdlOTk5MjU2ZWJhYjg5YTA4YTgxMTE5MmQzOWI0OTJjNWVlNzhkNTcwMWFiZGJkIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 11:25:58 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6InlTQzhHaHhHeWNVVXhYV2N4b1BXdXc9PSIsInZhbHVlIjoicXVXSmFTVGUvbHY0K1lwMXRBc2cwTnMyZE04NU8rSmhpWFRGZ2xwT20vcGFLME5RV0lvSVpNQTlic1Z3cVdo" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkRBN2RVekFDWTVRWlgyZW42cCtKUFE9PSIsInZhbHVlIjoiZnFkNk5IbEhzUndlVk9DeHdnMTY0TVZxWVdlbWkrQ3dOd3hkVmI5dTlkS1pJVEdPbEhjU0ltc1g4M3VDQlV3eE91VTlOa1FtakNVTjVIMUd5N1U0OG5EOU15aEJwTGU4MDNQUUxBK3JJaXYxT0s4dVo1NUx4Z0tBb3QwbEZSU1ciLCJtYWMiOiI0NTVlZTE3OTI2MjI1ZmUxN2MwNzEyMWZkZTQ3NjViMTE4ZTY1ODI5NjQ0OTM0MGZkNWQ1M2U5YjU1ODNjMzgwIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 11:25:58 GMT; path=/XSRF-TOKEN=eyJpdiI6IkRBN2RVekFDWTVRWlgyZW42cCtKUFE9PSIsInZhbHVlIjoiZnFkNk5IbEhzUndlVk9DeHdnMTY0TVZxWVdlbWkrQ3dOd3hkVmI5dTlkS1pJVEdPbEhjU0ltc1g4M3VDQlV3eE91VTlOa" 1 => "lowcostclub_session=eyJpdiI6InlTQzhHaHhHeWNVVXhYV2N4b1BXdXc9PSIsInZhbHVlIjoicXVXSmFTVGUvbHY0K1lwMXRBc2cwTnMyZE04NU8rSmhpWFRGZ2xwT20vcGFLME5RV0lvSVpNQTlic1Z3cVdoMlVtakREMHd1Q1JCbFhqY1V1T1Y4VjI2d051Z3YyajJUaEhJYjZsMDgzYUhMc1NYN1BDd1Y5N2VCcVh2OTdNTnciLCJtYWMiOiI5MWVmNTRjODYzYmRlNzQ4NDdlOTk5MjU2ZWJhYjg5YTA4YTgxMTE5MmQzOWI0OTJjNWVlNzhkNTcwMWFiZGJkIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 11:25:58 GMT; path=/; httponlylowcostclub_session=eyJpdiI6InlTQzhHaHhHeWNVVXhYV2N4b1BXdXc9PSIsInZhbHVlIjoicXVXSmFTVGUvbHY0K1lwMXRBc2cwTnMyZE04NU8rSmhpWFRGZ2xwT20vcGFLME5RV0lvSVpNQTlic1Z3cVdo" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "3oLsWRxXmxbJYYEsirHXuPVdQwwXCjksBosxkKaJ" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-rotorua-to-kerikeri-rot-kke?_url=%2Fcheap-flights-from-rotorua-to-kerikeri-rot-kke" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-01 09:25:58GET/cheap-flights-from-rotorua-to-kerikeri-rot-kke54551081