Cheap flights Kirkwall — Lagos (KOI — LOS)

Choose your dates to find the flight:

Good to know - Cheap tickets Kirkwall — Lagos

Cheapest flight found	$824
Flight distance	5848 km
Round-trip from	$1,791

Routes from nearby cities to Lagos

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

from $916 round-trip

from $628 one-way

from $782 round-trip

from $777 round-trip

from $801 round-trip

The most frequent flight to Lagos is from Aberdeen. The cheapest airfare can be purchased with a flight from Dundee from $628. The nearest airports from Kirkwall with a flight to Lagos are in Newcastle.

Popular International routes from Kirkwall

Kirkwall — Lagos

from $824 one-way

Kirkwall — Taipei

from $760 one-way

Kirkwall — Mexico City

from $1,371 round-trip

Kirkwall — Milan

from $544 round-trip

Kirkwall — Malta

from $382 one-way

Popular routes from Lagos

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

from $523 one-way

from $1,112 one-way

from $939 one-way

from $1,112 one-way

from $960 one-way

Popular domestic routes from Kirkwall

from $160 one-way

from $163 one-way

from $832 round-trip

from $607 round-trip

Kirkwall — Shetland Islands

from $124 one-way

Messages Timeline Exceptions Views46 Route Queries56 Models212 Mails Gate N+1 Queries Session Request

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

Booting (23.89ms)time
Application (311ms)time
1 x Application (92.87%)
311ms
1 x Booting (7.13%)
23.89ms

46 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
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

56 statements were executed (7 duplicates)Show only duplicates80.6ms

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.57msselect * from `sites_relationships` where `us` = 'cheap-flights-from-kirkwall-to-lagos-koi-los' limit 1

Bindings	0: cheap-flights-from-kirkwall-to-lagos-koi-los
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.13msselect * from `flights_by` where `flights_by`.`id` = '1170276' 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.12msselect * from `cities` where `cities`.`id` = 6797 limit 1

Bindings	0: 6797
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.34msselect * from `countries` where `countries`.`id` = 17 limit 1

Bindings	0: 17
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.64msselect * from `cities` where `cities`.`id` = 3656 limit 1

Bindings	0: 3656
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.25msselect * from `countries` where `countries`.`id` = 69 limit 1

Bindings	0: 69
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.02ms

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

Bindings	0: 1170276
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.3msselect * 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.44ms

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

Bindings	0: 6797 1: 3656 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#66aviatickets950μsselect * from `monthly_price_statistics` where `origin_city_id` = 6797 and `destination_city_id` = 3656 limit 1

Bindings	0: 6797 1: 3656
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.25ms

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

Bindings	0: 6797 1: 3656
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.09msselect distinct `airline_id` from `timetables` where `origin_city_id` = 6797

Bindings	0: 6797
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.47msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3656

Bindings	0: 3656
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.65ms

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

Bindings	0: 6797 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.24ms

select * from `flights_by` where `origin_city_id` in (5054, 6754, 8791, 8465, 50, 1536, 507, 9244, 2122, 6927) and `destination_city_id` = 3656 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 5054 1: 6754 2: 8791 3: 8465 4: 50 5: 1536 6: 507 7: 9244 8: 2122 9: 6927 10: 3656 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.1msselect * from `cities` where `cities`.`id` in (50, 1536, 2122, 6927, 9244)

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#73aviatickets990μsselect * from `cities` where `cities`.`id` in (3656)

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#73aviatickets920μsselect * from `sites_relationships` where `sites_relationships`.`id` in (2855, 99331, 117735, 232129, 1137460)

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

Bindings	0: 6927
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.22msselect * from `cities` where `cities`.`id` = 1536 limit 1

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

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

Bindings	0: 50
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#52aviatickets1.16msselect * from `offers` where `origin_city_id` = 6797 and `destination_city_id` = 3656

Bindings	0: 6797 1: 3656
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.3ms

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

Bindings	0: 6797 1: 1170276 2: 17 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#447aviatickets13.37msselect * from `cities` where `cities`.`id` in (6797)

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.95msselect * from `cities` where `cities`.`id` in (3884, 3958, 4003)

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#447aviatickets970μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1170277, 1170278, 1170279)

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#125aviatickets1.01msselect * from `countries` where `countries`.`id` = 2 limit 1

Bindings	0: 2
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.3ms

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

Bindings	0: 6797 1: 17 2: 0 3: 0 4: 1170277
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#412aviatickets870μsselect * from `cities` where `cities`.`id` in (6797)

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#412aviatickets840μsselect * from `cities` where `cities`.`id` in (3656, 6206)

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#412aviatickets660μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1170276, 1170284)

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#412aviatickets750μsselect * from `countries` where `countries`.`id` in (67, 69)

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

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

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

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#149aviatickets840μsselect * from `cities` where `cities`.`id` in (1115, 3098, 4081, 7738, 8893)

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#149aviatickets900μsselect * from `countries` where `countries`.`id` in (6, 92, 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#149aviatickets860μsselect * from `sites_relationships` where `sites_relationships`.`id` in (193584, 193610, 193679, 193790, 193995)

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

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

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

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 `cities` where `cities`.`id` in (507, 823, 2122, 3654, 8791)

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#359aviatickets840μsselect * from `sites_relationships` where `sites_relationships`.`id` in (167645, 167648, 167650, 1170270, 1274940)

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

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

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

Bindings	0: 6797 1: 3656
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#144aviatickets910μs

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

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

Bindings	0: 3656 1: 6797
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.18msselect * from `cities` where `cities`.`id` = 6797 limit 1

Bindings	0: 6797
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.19msselect * 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.15msselect * 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.08msselect * 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.15msselect * 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.22msselect * 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.7ms

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#149aviatickets990μ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.45msselect * 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.03msselect * 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.37ms

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: 58Timetable.php#?
App\Avia\Infrastructure\Model\City: 52City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 46LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 37SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 18Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: n2RNBR8H7E0uyRvQoaLTo6KZ26n2qVkMJ6UWP1PS
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-kirkwall-to-lagos-koi-los?_url=%2Fch...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-kirkwall-to-lagos-koi-los

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-kirkwall-to-lagos-koi-los"
]

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 20:08:59 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""397185324eaf054673749791eabee4e1""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpQTVBQc2Q4TE9sZVkzencvQmRoMXc9PSIsInZhbHVlIjoiTmMrQ3Y2dGF4bDlPcnM1ZWR1N25Ha1VtOXoyTEkrV2M3UzF4Y3hKbGJMNWNOa01IcGRnWmkraWJ1MHRVdzRIV05mRk42cGhPeXk3Q1RmL21Ob1NlZFBRNndYMWt4b291TVJRRUEyTTJ3K0xpWDZWOTZlaTB0QVRBYlBXb2IzZ08iLCJtYWMiOiI3MTMyOTJlMTNkY2UzOWYwY2ZhMDMzY2NkNDc1ODY1MDgwMmI5NDVmOTdkY2ViODgxMGFhMzllMGY2NWIzNTg5IiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 22:08:59 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImpQTVBQc2Q4TE9sZVkzencvQmRoMXc9PSIsInZhbHVlIjoiTmMrQ3Y2dGF4bDlPcnM1ZWR1N25Ha1VtOXoyTEkrV2M3UzF4Y3hKbGJMNWNOa01IcGRnWmkraWJ1MHRVdzRIV05mRk42c ▶"
    1 => "lowcostclub_session=eyJpdiI6ImhOOGlzWTBwNTMzeTFLMGdWNE5YT3c9PSIsInZhbHVlIjoiMjR4Z0NhbWoxZ2YvOFU3bm1MR3Fwbm1KL3BsZlVuZ2puVFU1RmpNak9ZeEp3NDlBSHZuNnp2LzFaQWR2Ry91Qmp5dy9rWGk2NnowQVNTbnQ1WjcwMDd0c2JMYkxycWR3ZFZtcHRWRng4VUJ1TVJ2RXJDL3VCWlpESmFUNGE1eUkiLCJtYWMiOiJmZTFkZDIxMTk0OTkyOTUzYmJjYTY5MGI3NTU3Y2RmNjU5M2IzZWExZTlkYjU2N2U5NzM2MmE2YzkyZmJlOTU5IiwidGFnIjoiIn0%3D; expires=Thu, 08 May 2025 22:08:59 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6ImhOOGlzWTBwNTMzeTFLMGdWNE5YT3c9PSIsInZhbHVlIjoiMjR4Z0NhbWoxZ2YvOFU3bm1MR3Fwbm1KL3BsZlVuZ2puVFU1RmpNak9ZeEp3NDlBSHZuNnp2LzFaQWR2Ry91 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpQTVBQc2Q4TE9sZVkzencvQmRoMXc9PSIsInZhbHVlIjoiTmMrQ3Y2dGF4bDlPcnM1ZWR1N25Ha1VtOXoyTEkrV2M3UzF4Y3hKbGJMNWNOa01IcGRnWmkraWJ1MHRVdzRIV05mRk42cGhPeXk3Q1RmL21Ob1NlZFBRNndYMWt4b291TVJRRUEyTTJ3K0xpWDZWOTZlaTB0QVRBYlBXb2IzZ08iLCJtYWMiOiI3MTMyOTJlMTNkY2UzOWYwY2ZhMDMzY2NkNDc1ODY1MDgwMmI5NDVmOTdkY2ViODgxMGFhMzllMGY2NWIzNTg5IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 22:08:59 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpQTVBQc2Q4TE9sZVkzencvQmRoMXc9PSIsInZhbHVlIjoiTmMrQ3Y2dGF4bDlPcnM1ZWR1N25Ha1VtOXoyTEkrV2M3UzF4Y3hKbGJMNWNOa01IcGRnWmkraWJ1MHRVdzRIV05mRk42c ▶"
    1 => "lowcostclub_session=eyJpdiI6ImhOOGlzWTBwNTMzeTFLMGdWNE5YT3c9PSIsInZhbHVlIjoiMjR4Z0NhbWoxZ2YvOFU3bm1MR3Fwbm1KL3BsZlVuZ2puVFU1RmpNak9ZeEp3NDlBSHZuNnp2LzFaQWR2Ry91Qmp5dy9rWGk2NnowQVNTbnQ1WjcwMDd0c2JMYkxycWR3ZFZtcHRWRng4VUJ1TVJ2RXJDL3VCWlpESmFUNGE1eUkiLCJtYWMiOiJmZTFkZDIxMTk0OTkyOTUzYmJjYTY5MGI3NTU3Y2RmNjU5M2IzZWExZTlkYjU2N2U5NzM2MmE2YzkyZmJlOTU5IiwidGFnIjoiIn0%3D; expires=Thu, 08-May-2025 22:08:59 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6ImhOOGlzWTBwNTMzeTFLMGdWNE5YT3c9PSIsInZhbHVlIjoiMjR4Z0NhbWoxZ2YvOFU3bm1MR3Fwbm1KL3BsZlVuZ2puVFU1RmpNak9ZeEp3NDlBSHZuNnp2LzFaQWR2Ry91 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "n2RNBR8H7E0uyRvQoaLTo6KZ26n2qVkMJ6UWP1PS"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-kirkwall-to-lagos-koi-los?_url=%2Fcheap-flights-from-kirkwall-to-lagos-koi-los"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-08 20:08:59	GET	/cheap-flights-from-kirkwall-to-lagos-koi-los	46 56 212

1 x Application (92.87%)	311ms
1 x Booting (7.13%)	23.89ms

Cheap flights Kirkwall — Lagos (KOI — LOS)

Choose your dates to find the flight:

Good to know - Cheap tickets Kirkwall — Lagos

Routes from nearby cities to Lagos

Popular International routes from Kirkwall

Popular routes from Lagos

Popular domestic routes from Kirkwall

Select your currency

All currencies

Select your language

All languages