Cheap flights Kano — Punta Cana (KAN — PUJ)

Choose your dates to find the flight:

Good to know - Cheap tickets Kano — Punta Cana

Cheapest flight found	$2,261
Flight distance	8220 km

Routes from nearby cities to Punta Cana

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

Abuja — Punta Cana

from $1,862 round-trip

Douala — Punta Cana

from $1,549 one-way

Lagos — Punta Cana

from $1,617 round-trip

Most often, they fly to Punta Cana from Lagos, this is the closest city with an airport from Kano. The cheapest ticket can be bought for a flight departing from Douala from $1,549.

Popular International routes from Kano

Kano — Guangzhou

from $808 one-way

Kano — Beijing

from $589 one-way

Kano — Riga

from $1,460 round-trip

Kano — Ho Chi Minh City

from $959 one-way

Kano — Salalah

from $1,384 round-trip

Popular routes from Punta Cana

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

from $462 one-way

from $141 one-way

from $158 one-way

from $294 one-way

Punta Cana — Nashville

from $183 one-way

Popular domestic routes from Kano

Kano — Benin City

from $687 round-trip

Kano — Lagos

from $109 one-way

Kano — Abuja

from $95 one-way

Messages Timeline Exceptions Views42 Route Queries46 Models150 Mails Gate N+1 Queries1 Session Request

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

Booting (36.01ms)time
Application (212ms)time
1 x Application (85.48%)
212ms
1 x Booting (14.51%)
36.01ms

42 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
16x 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

46 statements were executed (7 duplicates)Show only duplicates67.56ms

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#34aviatickets5msselect * from `sites_relationships` where `us` = 'cheap-flights-from-kano-to-punta-cana-kan-puj' limit 1

Bindings	0: cheap-flights-from-kano-to-punta-cana-kan-puj
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.58msselect * from `flights_by` where `flights_by`.`id` = '1145890' 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#135aviatickets2.97msselect * from `cities` where `cities`.`id` = 2868 limit 1

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

Bindings	0: 69
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.74msselect * from `cities` where `cities`.`id` = 5136 limit 1

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

Bindings	0: 79
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#33aviatickets920μs

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

Bindings	0: 1145890
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#31aviatickets740μ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#42aviatickets2.61ms

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

Bindings	0: 2868 1: 5136 2: 2025-05-07 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#66aviatickets7.93msselect * from `monthly_price_statistics` where `origin_city_id` = 2868 and `destination_city_id` = 5136 limit 1

Bindings	0: 2868 1: 5136
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#470aviatickets890μs

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

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

Bindings	0: 2868
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#502aviatickets990μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 5136

Bindings	0: 5136
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#558aviatickets990μs

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

Bindings	0: 2868 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets1.64ms

select * from `flights_by` where `origin_city_id` in (46, 4406, 9334, 749, 3656, 1517, 1239, 7081) and `destination_city_id` = 5136 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 46 1: 4406 2: 9334 3: 749 4: 3656 5: 1517 6: 1239 7: 7081 8: 5136 9: 0 10: 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#73aviatickets890μsselect * from `cities` where `cities`.`id` in (46, 1517, 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#73aviatickets970μsselect * from `cities` where `cities`.`id` in (5136)

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#73aviatickets760μsselect * from `sites_relationships` where `sites_relationships`.`id` in (2567, 193860, 408669)

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#104aviatickets950μsselect * from `cities` where `cities`.`id` = 3656 limit 1

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

Bindings	0: 1517
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#52aviatickets720μsselect * from `offers` where `origin_city_id` = 2868 and `destination_city_id` = 5136

Bindings	0: 2868 1: 5136
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.33ms

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

Bindings	0: 2868 1: 1145890 2: 69 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.47msselect * from `cities` where `cities`.`id` in (2868)

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#447aviatickets960μsselect * from `cities` where `cities`.`id` in (5324, 5572, 5671)

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#447aviatickets700μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1145891, 1145892, 1145893)

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#125aviatickets840μsselect * from `countries` where `countries`.`id` = 51 limit 1

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

LocalRoute.php#125aviatickets1.19msselect * from `countries` where `countries`.`id` = 54 limit 1

Bindings	0: 54
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.25ms

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

Bindings	0: 2868 1: 69 2: 0 3: 0 4: 1145891
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.27msselect * from `cities` where `cities`.`id` in (2868)

Backtrace

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

LocalRouteRepository.php#412aviatickets2.18msselect * from `cities` where `cities`.`id` in (684, 8447)

Backtrace

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

LocalRouteRepository.php#412aviatickets2.19msselect * from `sites_relationships` where `sites_relationships`.`id` in (158098, 158104)

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#412aviatickets4.19msselect * from `countries` where `countries`.`id` in (70)

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

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

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

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.14msselect * from `cities` where `cities`.`id` in (2309, 3787, 4081, 8324, 8617)

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.08msselect * from `countries` where `countries`.`id` in (19, 23, 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#149aviatickets840μsselect * from `sites_relationships` where `sites_relationships`.`id` in (271588, 271612, 271706, 271769, 271785)

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

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

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

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 (46, 749, 3656)

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#359aviatickets800μsselect * from `sites_relationships` where `sites_relationships`.`id` in (158091, 158101, 158127)

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

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

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

Bindings	0: 2868 1: 5136
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#144aviatickets860μs

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

Bindings	0: 2868 1: 5136
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#520aviatickets870μsselect * from `flights_by` where `origin_city_id` = 5136 and `destination_city_id` = 2868 limit 1

Bindings	0: 5136 1: 2868
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#24aviatickets950μsselect * from `cities` where `cities`.`id` = 2868 limit 1

Bindings	0: 2868
Backtrace	view::routes.description-nearbyCities:24 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

App\Avia\Infrastructure\Model\Timetable: 70Timetable.php#?
App\Avia\Infrastructure\Model\City: 26City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 25LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 18SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 10Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...

_token: hUAPqZc8Z9sxpDYTG8raMyW3Tb5AOnczMonErL30
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-kano-to-punta-cana-kan-puj?_url=%2Fc...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-kano-to-punta-cana-kan-puj

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-kano-to-punta-cana-kan-puj"
]

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 => "Fri, 09 May 2025 23:30:29 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""70c3a2f697137f6713f771495d5444a4""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InREQTJWWVFuWEd6ZTlLZ0RTZGg3MWc9PSIsInZhbHVlIjoiY3l2amtYZWYzMVJGd2xFQ210YUZFbERXMTllZFQ4YXhHK2FBbHk5cGQ2V0VxckFHUHlhUmhRSi93ZGlvcnVtL2x5M2xuYmRMNmhlaW9TeEpyOVNNK3A0Nmt3dEh4Yi9NZWo4aG5DT1Qzb1J6djlhZS9JM3h6ZHNtRXRLcXl6MmMiLCJtYWMiOiJjZGQwNjE0NWU1ODJiNzIzZTM0NTU2YTY1YmJmZmE2Yzg2ZjBiZmFiYmI5ODMxMGU3NmU3ZWQ3YjRlZDI4MTU5IiwidGFnIjoiIn0%3D; expires=Sat, 10 May 2025 01:30:29 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InREQTJWWVFuWEd6ZTlLZ0RTZGg3MWc9PSIsInZhbHVlIjoiY3l2amtYZWYzMVJGd2xFQ210YUZFbERXMTllZFQ4YXhHK2FBbHk5cGQ2V0VxckFHUHlhUmhRSi93ZGlvcnVtL2x5M2xuY ▶"
    1 => "lowcostclub_session=eyJpdiI6InI1Mno5NXFXVlhtQk0zRjFlek4yTlE9PSIsInZhbHVlIjoiSFRKQUoyUFp5cEZkN2YxT1V2cGR4NDh3YzY2b3ZwR00yTGg3a3J4UmhlSGhBdFR6aDhqZDUwM29uOGFrTWI5NHZCREVYZnl3YTVQaFNOdW1hTkhiQWpDNERWUndlaWc2bnp5VlpNS1MxQTBGSk9RYXY5eXhoUzkxQVVGTFRNUlIiLCJtYWMiOiI1M2M0ZGQ0ZDJiZGUyYjhjYjA3ZDg3ZWRlM2I5NTI4MzNlM2JjYzBmZTg3OGI5NmYyZmRmYmFiMDA2ZTNhNTA3IiwidGFnIjoiIn0%3D; expires=Sat, 10 May 2025 01:30:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6InI1Mno5NXFXVlhtQk0zRjFlek4yTlE9PSIsInZhbHVlIjoiSFRKQUoyUFp5cEZkN2YxT1V2cGR4NDh3YzY2b3ZwR00yTGg3a3J4UmhlSGhBdFR6aDhqZDUwM29uOGFrTWI5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InREQTJWWVFuWEd6ZTlLZ0RTZGg3MWc9PSIsInZhbHVlIjoiY3l2amtYZWYzMVJGd2xFQ210YUZFbERXMTllZFQ4YXhHK2FBbHk5cGQ2V0VxckFHUHlhUmhRSi93ZGlvcnVtL2x5M2xuYmRMNmhlaW9TeEpyOVNNK3A0Nmt3dEh4Yi9NZWo4aG5DT1Qzb1J6djlhZS9JM3h6ZHNtRXRLcXl6MmMiLCJtYWMiOiJjZGQwNjE0NWU1ODJiNzIzZTM0NTU2YTY1YmJmZmE2Yzg2ZjBiZmFiYmI5ODMxMGU3NmU3ZWQ3YjRlZDI4MTU5IiwidGFnIjoiIn0%3D; expires=Sat, 10-May-2025 01:30:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InREQTJWWVFuWEd6ZTlLZ0RTZGg3MWc9PSIsInZhbHVlIjoiY3l2amtYZWYzMVJGd2xFQ210YUZFbERXMTllZFQ4YXhHK2FBbHk5cGQ2V0VxckFHUHlhUmhRSi93ZGlvcnVtL2x5M2xuY ▶"
    1 => "lowcostclub_session=eyJpdiI6InI1Mno5NXFXVlhtQk0zRjFlek4yTlE9PSIsInZhbHVlIjoiSFRKQUoyUFp5cEZkN2YxT1V2cGR4NDh3YzY2b3ZwR00yTGg3a3J4UmhlSGhBdFR6aDhqZDUwM29uOGFrTWI5NHZCREVYZnl3YTVQaFNOdW1hTkhiQWpDNERWUndlaWc2bnp5VlpNS1MxQTBGSk9RYXY5eXhoUzkxQVVGTFRNUlIiLCJtYWMiOiI1M2M0ZGQ0ZDJiZGUyYjhjYjA3ZDg3ZWRlM2I5NTI4MzNlM2JjYzBmZTg3OGI5NmYyZmRmYmFiMDA2ZTNhNTA3IiwidGFnIjoiIn0%3D; expires=Sat, 10-May-2025 01:30:29 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6InI1Mno5NXFXVlhtQk0zRjFlek4yTlE9PSIsInZhbHVlIjoiSFRKQUoyUFp5cEZkN2YxT1V2cGR4NDh3YzY2b3ZwR00yTGg3a3J4UmhlSGhBdFR6aDhqZDUwM29uOGFrTWI5 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "hUAPqZc8Z9sxpDYTG8raMyW3Tb5AOnczMonErL30"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-kano-to-punta-cana-kan-puj?_url=%2Fcheap-flights-from-kano-to-punta-cana-kan-puj"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-09 23:30:29	GET	/cheap-flights-from-kano-to-punta-cana-kan-puj	42 46 150 1

1 x Application (85.48%)	212ms
1 x Booting (14.51%)	36.01ms

Cheap flights Kano — Punta Cana (KAN — PUJ)

Choose your dates to find the flight:

Good to know - Cheap tickets Kano — Punta Cana

Routes from nearby cities to Punta Cana

Popular International routes from Kano

Popular routes from Punta Cana

Popular domestic routes from Kano

Select your currency

All currencies

Select your language

All languages