The most frequent flight to Hanoi is from Oslo. The cheapest airfare can be purchased with a flight from Copenhagen from $445. The nearest airports from Kristiansund with a flight to Hanoi are in Gothenburg.

Popular International routes from Kristiansund

Kristiansund — New York

from $551 one-way

Kristiansund — Oklahoma City

from $8,018 round-trip

Kristiansund — Helsinki

from $119 one-way

Kristiansund — Heraklion

from $432 round-trip

Kristiansund — Hong Kong

from $1,013 one-way

Popular routes from Hanoi

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

from $230 one-way

from $27 one-way

from $27 one-way

from $285 one-way

Hanoi — Saint Petersburg

from $305 one-way

Popular domestic routes from Kristiansund

Kristiansund — Bodo

from $149 one-way

Kristiansund — Alta

from $306 round-trip

Kristiansund — Bardufoss

from $144 one-way

Kristiansund — Tromso

from $136 one-way

Kristiansund — Oslo

from $44 one-way

Messages Timeline Exceptions Views47 Route Queries56 Models247 Mails Gate N+1 Queries Session Request

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

Booting (24.54ms)time
Application (306ms)time
1 x Application (92.58%)
306ms
1 x Booting (7.42%)
24.54ms

47 templates were rendered

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

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#34aviatickets15.23msselect * from `sites_relationships` where `us` = 'cheap-flights-from-kristiansand-to-hanoi-krs-han' limit 1

Bindings	0: cheap-flights-from-kristiansand-to-hanoi-krs-han
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#125aviatickets800μsselect * from `flights_by` where `flights_by`.`id` = '170184' 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#135aviatickets940μsselect * from `cities` where `cities`.`id` = 3308 limit 1

Bindings	0: 3308
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#136aviatickets920μsselect * from `countries` where `countries`.`id` = 98 limit 1

Bindings	0: 98
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.05msselect * from `cities` where `cities`.`id` = 2305 limit 1

Bindings	0: 2305
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.14msselect * from `countries` where `countries`.`id` = 240 limit 1

Bindings	0: 240
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.34ms

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

Bindings	0: 170184
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.37msselect * 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.31ms

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

Bindings	0: 3308 1: 2305 2: 2025-05-06 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.09msselect * from `monthly_price_statistics` where `origin_city_id` = 3308 and `destination_city_id` = 2305 limit 1

Bindings	0: 3308 1: 2305
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.26ms

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

Bindings	0: 3308 1: 2305
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#502aviatickets970μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 3308

Bindings	0: 3308
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.75msselect distinct `airline_id` from `timetables` where `origin_city_id` = 2305

Bindings	0: 2305
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

LocalRouteRepository.php#558aviatickets1.96ms

select destination_city_id from `flights_by` where `origin_city_id` = 3308 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10

Bindings	0: 3308 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.79ms

select * from `flights_by` where `origin_city_id` in (5851, 12, 2308, 2181, 9269, 17, 554, 1255, 87, 4072) and `destination_city_id` = 2305 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5851 1: 12 2: 2308 3: 2181 4: 9269 5: 17 6: 554 7: 1255 8: 87 9: 4072 10: 2305 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.91msselect * from `cities` where `cities`.`id` in (87, 554, 1255, 2181, 5851, 9269)

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.33msselect * from `cities` where `cities`.`id` in (2305)

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 (33010, 75134, 120415, 249748, 1093856, 1165029)

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#104aviatickets1msselect * from `cities` where `cities`.`id` = 2181 limit 1

Bindings	0: 2181
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97

CitySqlRepository.php#104aviatickets1.95msselect * from `cities` where `cities`.`id` = 1255 limit 1

Bindings	0: 1255
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#104aviatickets940μsselect * from `cities` where `cities`.`id` = 9269 limit 1

Bindings	0: 9269
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#52aviatickets910μsselect * from `offers` where `origin_city_id` = 3308 and `destination_city_id` = 2305

Bindings	0: 3308 1: 2305
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.75ms

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

Bindings	0: 3308 1: 170184 2: 98 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRouteRepository.php#447aviatickets1.05msselect * from `cities` where `cities`.`id` in (3308)

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.16msselect * from `cities` where `cities`.`id` in (2340, 2342, 2380)

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#447aviatickets840μsselect * from `sites_relationships` where `sites_relationships`.`id` in (170186, 170187, 170189)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRoute.php#125aviatickets2.2msselect * from `countries` where `countries`.`id` = 247 limit 1

Bindings	0: 247
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:125 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Model/LocalRoute.php:122 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49

LocalRouteRepository.php#412aviatickets1.51ms

select * from `flights_by` where `origin_city_id` = 3308 and `destination_country_id` <> 98 and (`price_one_way` > 0 or `price` > 0) and `id` not in (170186) order by `revenue` desc limit 2 offset 0

Bindings	0: 3308 1: 98 2: 0 3: 0 4: 170186
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#412aviatickets930μsselect * from `cities` where `cities`.`id` in (3308)

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#412aviatickets900μsselect * from `cities` where `cities`.`id` in (4539, 4622)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#412aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` in (170233, 1149232)

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#412aviatickets820μsselect * from `countries` where `countries`.`id` in (92)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#149aviatickets1.64ms

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

Bindings	0: 2305 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.15msselect * from `cities` where `cities`.`id` in (2305)

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.23msselect * from `cities` where `cities`.`id` in (1419, 2595, 3505, 4081, 8622)

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.1msselect * from `countries` where `countries`.`id` in (240, 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#149aviatickets3.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (128161, 128247, 128301, 128344, 128364)

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

select * from `flights_by` where `origin_city_id` = 3308 and `destination_country_id` = 98 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0

Bindings	0: 3308 1: 98 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.48msselect * from `cities` where `cities`.`id` in (3308)

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#359aviatickets940μsselect * from `cities` where `cities`.`id` in (181, 776, 3032, 6197, 9269)

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#359aviatickets710μsselect * from `sites_relationships` where `sites_relationships`.`id` in (170158, 170235, 170265, 434908, 1063885)

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#359aviatickets790μsselect * from `countries` where `countries`.`id` in (98)

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#39aviatickets940μs

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

Bindings	0: 3308 1: 2305
Backtrace	app/Avia/Infrastructure/Repository/TimetableRepository.php:39 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/TimetableRepository.php:30 app/Http/Controllers/RoutesController.php:264

TimetableRepository.php#144aviatickets1.34ms

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

Bindings	0: 3308 1: 2305
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#520aviatickets1msselect * from `flights_by` where `origin_city_id` = 2305 and `destination_city_id` = 3308 limit 1

Bindings	0: 2305 1: 3308
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#28aviatickets1.03msselect * from `cities` where `cities`.`id` = 3308 limit 1

Bindings	0: 3308
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#175aviatickets1.02msselect * 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.07msselect * 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#175aviatickets3.85msselect * 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.07msselect * 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#175aviatickets800μsselect * 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.53ms

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#149aviatickets930μ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.42msselect * 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.02msselect * 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#149aviatickets930μs

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\Timetable: 92Timetable.php#?
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: 16Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: mjbsmdH1svTJVBKwgUu3jmnY759bHpMeYdFUEoT3
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-kristiansand-to-hanoi-krs-han?_url=%...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-kristiansand-to-hanoi-krs-han

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-kristiansand-to-hanoi-krs-han"
]

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, 08 May 2025 18:39:05 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""a3b76a24d951149e5dd30221a29869e0""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii9CUlVqTzZablgyVGUxK1ZpczVuY3c9PSIsInZhbHVlIjoiajV5QmtubDJVSHJodVlUZysyR05wZVdHckoxN0dNWHpvb1lDL0ZwcDNpb3pXRDAwTW5WM1k4aWYwR2FJRm94ZkFKWW1ONDBUME1zaEVYeEI1eC8zOXVZbWpXTXJXcHRtc1UvMmtVOGVUMk9yNHhFb1BsbFFNUnZBK3lTcit6NTgiLCJtYWMiOiIzYjk1ODgxNDcwYThmZWYyNjhmNWU2Njg0NzU4MGVkMWFkNTMyNTA5MDNhNThhOTQxZDlhMDRkZTQxM2ZmY2VmIiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 20:39:05 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ii9CUlVqTzZablgyVGUxK1ZpczVuY3c9PSIsInZhbHVlIjoiajV5QmtubDJVSHJodVlUZysyR05wZVdHckoxN0dNWHpvb1lDL0ZwcDNpb3pXRDAwTW5WM1k4aWYwR2FJRm94ZkFKWW1ON ▶"
    1 => "lowcostclub_session=eyJpdiI6IitXOEtoTzlmbFBqaUxxUUZVRU1uOUE9PSIsInZhbHVlIjoiaVgyREs2c2M2c0hZOHhpTmMvbXdUdmpPZFVHUXo1UGNKZXBpUSt3TVB5a3MxZ0wzYUJMOVZDbExLMkt3dVIxdHNLRlN4RTVLVlk5eHlVQ09ZWkhkZ0haQldrT0prWDYyeWdJZWtqOU9oZldIVUova2pzL0JQcnhnRGhPOVlWb20iLCJtYWMiOiIyNDQ5Zjg0N2U5MWQ4Y2ZlMjhiMjI3NzNiOWU1NGE1NWZjNDE3MTFlNWZiMmQwZWIyNjdmNmE4OGY5YzViNDEyIiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 20:39:05 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IitXOEtoTzlmbFBqaUxxUUZVRU1uOUE9PSIsInZhbHVlIjoiaVgyREs2c2M2c0hZOHhpTmMvbXdUdmpPZFVHUXo1UGNKZXBpUSt3TVB5a3MxZ0wzYUJMOVZDbExLMkt3dVIx ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii9CUlVqTzZablgyVGUxK1ZpczVuY3c9PSIsInZhbHVlIjoiajV5QmtubDJVSHJodVlUZysyR05wZVdHckoxN0dNWHpvb1lDL0ZwcDNpb3pXRDAwTW5WM1k4aWYwR2FJRm94ZkFKWW1ONDBUME1zaEVYeEI1eC8zOXVZbWpXTXJXcHRtc1UvMmtVOGVUMk9yNHhFb1BsbFFNUnZBK3lTcit6NTgiLCJtYWMiOiIzYjk1ODgxNDcwYThmZWYyNjhmNWU2Njg0NzU4MGVkMWFkNTMyNTA5MDNhNThhOTQxZDlhMDRkZTQxM2ZmY2VmIiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 20:39:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ii9CUlVqTzZablgyVGUxK1ZpczVuY3c9PSIsInZhbHVlIjoiajV5QmtubDJVSHJodVlUZysyR05wZVdHckoxN0dNWHpvb1lDL0ZwcDNpb3pXRDAwTW5WM1k4aWYwR2FJRm94ZkFKWW1ON ▶"
    1 => "lowcostclub_session=eyJpdiI6IitXOEtoTzlmbFBqaUxxUUZVRU1uOUE9PSIsInZhbHVlIjoiaVgyREs2c2M2c0hZOHhpTmMvbXdUdmpPZFVHUXo1UGNKZXBpUSt3TVB5a3MxZ0wzYUJMOVZDbExLMkt3dVIxdHNLRlN4RTVLVlk5eHlVQ09ZWkhkZ0haQldrT0prWDYyeWdJZWtqOU9oZldIVUova2pzL0JQcnhnRGhPOVlWb20iLCJtYWMiOiIyNDQ5Zjg0N2U5MWQ4Y2ZlMjhiMjI3NzNiOWU1NGE1NWZjNDE3MTFlNWZiMmQwZWIyNjdmNmE4OGY5YzViNDEyIiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 20:39:05 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IitXOEtoTzlmbFBqaUxxUUZVRU1uOUE9PSIsInZhbHVlIjoiaVgyREs2c2M2c0hZOHhpTmMvbXdUdmpPZFVHUXo1UGNKZXBpUSt3TVB5a3MxZ0wzYUJMOVZDbExLMkt3dVIx ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "mjbsmdH1svTJVBKwgUu3jmnY759bHpMeYdFUEoT3"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-kristiansand-to-hanoi-krs-han?_url=%2Fcheap-flights-from-kristiansand-to-hanoi-krs-han"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-08 18:39:05	GET	/cheap-flights-from-kristiansand-to-hanoi-krs-han	47 56 247

1 x Application (92.58%)	306ms
1 x Booting (7.42%)	24.54ms

Cheap flights Kristiansund — Hanoi (KRS — HAN)

Choose your dates to find the flight:

Good to know - Cheap tickets Kristiansund — Hanoi

Routes from nearby cities to Hanoi

Popular International routes from Kristiansund

Popular routes from Hanoi

Popular domestic routes from Kristiansund

Select your currency

All currencies

Select your language

All languages