Most often, departures to Rarotonga are from Auckland, this is the cheapest flight from $105. The nearest airports from Rotorua with a flight to Rarotonga are located in Napier.

Popular International routes from Rotorua

Rotorua — Nadi

from $258 one-way

Rotorua — Sydney

from $232 one-way

Rotorua — Seoul

from $568 one-way

Rotorua — Tokyo

from $561 one-way

Rotorua — Toronto

from $805 one-way

Popular routes from Rarotonga

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

Rarotonga — Honolulu

from $390 one-way

Rarotonga — Los Angeles

from $556 one-way

Rarotonga — Denpasar

from $464 one-way

Rarotonga — Manila

from $988 one-way

Rarotonga — Moscow

from $1,021 one-way

Popular domestic routes from Rotorua

Rotorua — Christchurch

from $63 one-way

from $72 one-way

from $74 one-way

from $57 one-way

from $89 one-way

Return flights Rarotonga – Rotorua

Messages Timeline Exceptions Views47 Route Queries58 Models164 Mails Gate N+1 Queries Session Request

Request history8.3.0309ms4MBGET cheap-flights-from-{slug}

Booting (16.25ms)time
Application (293ms)time
1 x Application (94.74%)
293ms
1 x Booting (5.26%)
16.25ms

47 templates were rendered

1x views_us.routes.viewview.blade.php#?blade
1x routes.viewview.blade.php#?blade
1x index.section-slideshowsection-slideshow.blade.php#?blade
1x components.avia-formavia-form.blade.php#?blade
1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
1x routes.section-advantagessection-advantages.blade.php#?blade
1x routes.AirlinesListAirlinesList.blade.php#?blade
1x components.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
20x 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

58 statements were executed (10 duplicates)Show only duplicates75.77ms

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#34aviatickets10msselect * from `sites_relationships` where `us` = 'cheap-flights-from-rotorua-to-rarotonga-rot-rar' limit 1

Bindings	0: cheap-flights-from-rotorua-to-rarotonga-rot-rar
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.12msselect * from `flights_by` where `flights_by`.`id` = '1161901' 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#136aviatickets1.12msselect * 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.09msselect * from `cities` where `cities`.`id` = 5220 limit 1

Bindings	0: 5220
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#138aviatickets860μsselect * from `countries` where `countries`.`id` = 162 limit 1

Bindings	0: 162
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#33aviatickets880μs

select * from `sites_relationships` where `sites_relationships`.`id` = 1161901 and `sites_relationships`.`id` is not null limit 1

Bindings	0: 1161901
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#31aviatickets800μsselect * 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.87ms

select `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 5381 and `destination_id` = 5220 and `date_update` >= '2025-05-03 00:00:00' order by `value` asc limit 10

Bindings	0: 5381 1: 5220 2: 2025-05-03 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.33msselect * from `monthly_price_statistics` where `origin_city_id` = 5381 and `destination_city_id` = 5220 limit 1

Bindings	0: 5381 1: 5220
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.06ms

select * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 5220 order by `time_origin` asc limit 1000

Bindings	0: 5381 1: 5220
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#502aviatickets940μsselect 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.14msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5220

Bindings	0: 5220
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#90aviatickets880μsselect * 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.03ms

select 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#73aviatickets2.71ms

select * from `flights_by` where `origin_city_id` in (6284, 9009, 2107, 8612, 8325, 4472, 4993, 6749, 6701, 9035) and `destination_city_id` = 5220 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: 5220 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.09msselect * from `cities` where `cities`.`id` in (4472, 4993, 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#73aviatickets960μsselect * from `cities` where `cities`.`id` in (5220)

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.38msselect * from `sites_relationships` where `sites_relationships`.`id` in (8604, 265251, 363556, 455427, 1280992)

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.21msselect * from `cities` where `cities`.`id` = 8612 limit 1

Bindings	0: 8612
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#104aviatickets870μsselect * 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:158

OfferSqlRepository.php#52aviatickets770μsselect * from `offers` where `origin_city_id` = 5381 and `destination_city_id` = 5220

Bindings	0: 5381 1: 5220
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.19ms

select * from `flights_by` where `origin_city_id` = 5381 and `id` > 1161901 and `destination_country_id` <> 214 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3

Bindings	0: 5381 1: 1161901 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#447aviatickets890μsselect * 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#447aviatickets870μsselect * from `cities` where `cities`.`id` in (5537, 6319, 7344)

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#447aviatickets930μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1161902, 1161903, 1161905)

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.95ms

select * 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 (1161902) order by `revenue` desc limit 2 offset 0

Bindings	0: 5381 1: 214 2: 0 3: 0 4: 1161902
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.21msselect * 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.1msselect * 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#412aviatickets970μ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#412aviatickets980μsselect * 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#149aviatickets1.47ms

select * from `flights_by` where `origin_city_id` = 5220 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5

Bindings	0: 5220 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#149aviatickets990μsselect * from `cities` where `cities`.`id` in (5220)

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.15msselect * from `cities` where `cities`.`id` in (1574, 3448, 4051, 4081, 8458)

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.18msselect * from `countries` where `countries`.`id` in (58, 92, 114, 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.31msselect * from `sites_relationships` where `sites_relationships`.`id` in (275191, 275194, 275197, 468003, 468007)

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.38ms

select * 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#359aviatickets1.11msselect * 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#359aviatickets1.31msselect * 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#359aviatickets930μsselect * 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#359aviatickets970μ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#39aviatickets1.05ms

select * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 5220 order by `time_origin` asc limit 10

Bindings	0: 5381 1: 5220
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#144aviatickets960μs

select * from `timetables` where `origin_city_id` = 5381 and `destination_city_id` = 5220 order by `travel_time` asc limit 1

Bindings	0: 5381 1: 5220
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.01msselect * from `flights_by` where `origin_city_id` = 5220 and `destination_city_id` = 5381 limit 1

Bindings	0: 5220 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#520aviatickets950μsselect * from `sites_relationships` where `sites_relationships`.`id` in (468009)

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#99aviatickets980μsselect * 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#547aviatickets970μsselect * from `cities` where `cities`.`id` = 5220 limit 1

Bindings	0: 5220
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#20aviatickets1msselect * from `cities` where `cities`.`id` = 5381 limit 1

Bindings	0: 5381
Backtrace	view::routes.description-nearbyCities:20 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#175aviatickets1.01msselect * 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#175aviatickets1.42msselect * 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#175aviatickets1.21msselect * 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#175aviatickets1.48msselect * 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#175aviatickets1.06msselect * 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#149aviatickets1.74ms

select * 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#149aviatickets980μsselect * 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#149aviatickets1.15msselect * 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#149aviatickets1.34msselect * 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#149aviatickets1.35ms

select * 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: 53City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 47LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 38SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 18Country.php#?
App\Avia\Infrastructure\Model\Timetable: 6Timetable.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?
App\Avia\Infrastructure\Model\Airline: 1Airline.php#?

_token: 1uuzQvf2ZwhdfP4uPVgE8E99GTLeI8uhISNSdi3w
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-rotorua-to-rarotonga-rot-rar?_url=%2...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-rotorua-to-rarotonga-rot-rar

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-rotorua-to-rarotonga-rot-rar"
]

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 => "Mon, 05 May 2025 11:12:54 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""dc2dbc999603b244af5b2ddf5ac9bf33""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijd6d25MS1haN3F6NHVKMk5Hb0lMc2c9PSIsInZhbHVlIjoidEdPU3RGRXhUYURyZ1ExSmlHZCs2OGEwbVpUMmlzaWthbEp6OEJHdWlNOFV1dTdGbEdYTTVHdkhOcnJyYURaTzE4cHNYeHdrQ2dhTmhHd0lGMVd3MW5zNTlOaVAxd21ETnBCeWtpcEFhL2JMOFg1bXd4VEFJaGtmVWlOU1VZNEwiLCJtYWMiOiJlODY2ZGQwNTA4Nzc0NDQzMDJiZGJmYzNiNmM5N2JiYWU2ODc0Yzg4OTFkZTUzYzNmNzY3MWE1MDgwNDRkMzZlIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 13:12:54 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ijd6d25MS1haN3F6NHVKMk5Hb0lMc2c9PSIsInZhbHVlIjoidEdPU3RGRXhUYURyZ1ExSmlHZCs2OGEwbVpUMmlzaWthbEp6OEJHdWlNOFV1dTdGbEdYTTVHdkhOcnJyYURaTzE4cHNYe ▶"
    1 => "lowcostclub_session=eyJpdiI6IjZIL002SlJPRWNiT2I3eTlkKzArUmc9PSIsInZhbHVlIjoiZ1N3cHRyRjJjeVRJUEoraVU0TjdJTG9xNmtiWHNseWVYcmRwTGNZWmtSME5WYkhtb0dlcXk5aGNSNndUY3RlbUs2N2VMbjVEWFRRZVptSnRlK2xkVE9ES0RMb2kzQ0JhakhIcnFCeG5tL2FxWjJ2MGtyYWFPZ1JQOCtuRzFGYS8iLCJtYWMiOiJhNzgzYjAxMDgxMTZiMDhjOWRiNGYwZDBmOTQ1MjgwMzA1NDcyN2E3OTdlNzk4ZDE1NTI4MDJiNjIwZGIxOTJiIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 13:12:54 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjZIL002SlJPRWNiT2I3eTlkKzArUmc9PSIsInZhbHVlIjoiZ1N3cHRyRjJjeVRJUEoraVU0TjdJTG9xNmtiWHNseWVYcmRwTGNZWmtSME5WYkhtb0dlcXk5aGNSNndUY3Rl ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijd6d25MS1haN3F6NHVKMk5Hb0lMc2c9PSIsInZhbHVlIjoidEdPU3RGRXhUYURyZ1ExSmlHZCs2OGEwbVpUMmlzaWthbEp6OEJHdWlNOFV1dTdGbEdYTTVHdkhOcnJyYURaTzE4cHNYeHdrQ2dhTmhHd0lGMVd3MW5zNTlOaVAxd21ETnBCeWtpcEFhL2JMOFg1bXd4VEFJaGtmVWlOU1VZNEwiLCJtYWMiOiJlODY2ZGQwNTA4Nzc0NDQzMDJiZGJmYzNiNmM5N2JiYWU2ODc0Yzg4OTFkZTUzYzNmNzY3MWE1MDgwNDRkMzZlIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 13:12:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijd6d25MS1haN3F6NHVKMk5Hb0lMc2c9PSIsInZhbHVlIjoidEdPU3RGRXhUYURyZ1ExSmlHZCs2OGEwbVpUMmlzaWthbEp6OEJHdWlNOFV1dTdGbEdYTTVHdkhOcnJyYURaTzE4cHNYe ▶"
    1 => "lowcostclub_session=eyJpdiI6IjZIL002SlJPRWNiT2I3eTlkKzArUmc9PSIsInZhbHVlIjoiZ1N3cHRyRjJjeVRJUEoraVU0TjdJTG9xNmtiWHNseWVYcmRwTGNZWmtSME5WYkhtb0dlcXk5aGNSNndUY3RlbUs2N2VMbjVEWFRRZVptSnRlK2xkVE9ES0RMb2kzQ0JhakhIcnFCeG5tL2FxWjJ2MGtyYWFPZ1JQOCtuRzFGYS8iLCJtYWMiOiJhNzgzYjAxMDgxMTZiMDhjOWRiNGYwZDBmOTQ1MjgwMzA1NDcyN2E3OTdlNzk4ZDE1NTI4MDJiNjIwZGIxOTJiIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 13:12:54 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjZIL002SlJPRWNiT2I3eTlkKzArUmc9PSIsInZhbHVlIjoiZ1N3cHRyRjJjeVRJUEoraVU0TjdJTG9xNmtiWHNseWVYcmRwTGNZWmtSME5WYkhtb0dlcXk5aGNSNndUY3Rl ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "1uuzQvf2ZwhdfP4uPVgE8E99GTLeI8uhISNSdi3w"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-rotorua-to-rarotonga-rot-rar?_url=%2Fcheap-flights-from-rotorua-to-rarotonga-rot-rar"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-05 11:12:54	GET	/cheap-flights-from-rotorua-to-rarotonga-rot-rar	47 58 164

1 x Application (94.74%)	293ms
1 x Booting (5.26%)	16.25ms

Cheap flights Rotorua — Rarotonga (ROT — RAR)

Choose your dates to find the flight:

Good to know - Cheap tickets Rotorua — Rarotonga

Popular airlines flying Rotorua — Rarotonga

Routes from nearby cities to Rarotonga

Popular International routes from Rotorua

Popular routes from Rarotonga

Popular domestic routes from Rotorua

Related pages

Select your currency

All currencies

Select your language

All languages