Most often, departures to Varadero are from Skopje, this is the cheapest flight from $1,024. The nearest airports from Tirana with a flight to Varadero are located in Bari.

Popular International routes from Tirana

Tirana — Saint Petersburg

from $72 one-way

Tirana — Moscow

from $105 one-way

Tirana — Wroclaw

from $101 one-way

Tirana — Winnipeg

from $958 round-trip

Tirana — Bydgoszcz

from $216 one-way

Popular routes from Varadero

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

Varadero — Moscow

from $164 one-way

Varadero — Cancun

from $230 one-way

Varadero — Miami

from $179 one-way

Varadero — Punta Cana

from $158 one-way

Varadero — Mexico City

from $321 one-way

Return flights Varadero – Tirana

Messages Timeline Exceptions Views41 Route Queries45 Models167 Mails Gate N+1 Queries Session Request

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

Booting (26.13ms)time
Application (270ms)time
1 x Application (91.18%)
270ms
1 x Booting (8.82%)
26.13ms

41 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
2x components.airlines-columnairlines-column.blade.php#?blade
3x components.routes-listroutes-list.blade.php#?blade
15x components.routeListItemrouteListItem.blade.php#?blade
1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
1x 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

45 statements were executed (11 duplicates)Show only duplicates64.95ms

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#34aviatickets3.73msselect * from `sites_relationships` where `us` = 'cheap-flights-from-tirana-to-varadero-tia-vra' limit 1

Bindings	0: cheap-flights-from-tirana-to-varadero-tia-vra
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#125aviatickets860μsselect * from `flights_by` where `flights_by`.`id` = '485194' 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.01msselect * from `cities` where `cities`.`id` = 6074 limit 1

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

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

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

Bindings	0: 19
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#33aviatickets810μs

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

Bindings	0: 485194
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#31aviatickets860μ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.12ms

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

Bindings	0: 6074 1: 6574 2: 2025-05-12 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.04msselect * from `monthly_price_statistics` where `origin_city_id` = 6074 and `destination_city_id` = 6574 limit 1

Bindings	0: 6074 1: 6574
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#470aviatickets830μs

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

Bindings	0: 6074 1: 6574
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.08msselect distinct `airline_id` from `timetables` where `origin_city_id` = 6074

Bindings	0: 6074
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#502aviatickets740μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 6574

Bindings	0: 6574
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:502 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:494 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:408

AirlineSqlRepository.php#90aviatickets1.72msselect * from `airlines` where `id` in (1864, 17856) order by `name` asc

Bindings	0: 1864 1: 17856
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:90 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:84 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:413

LocalRouteRepository.php#558aviatickets1.21ms

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

Bindings	0: 6074 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.98ms

select * from `flights_by` where `origin_city_id` in (4610, 6043, 6090, 8694, 5650, 9255, 1445, 1092, 814, 2629) and `destination_city_id` = 6574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 4610 1: 6043 2: 6090 3: 8694 4: 5650 5: 9255 6: 1445 7: 1092 8: 814 9: 2629 10: 6574 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.43msselect * from `cities` where `cities`.`id` in (814, 1445, 5650, 6043, 8694)

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#73aviatickets1msselect * from `cities` where `cities`.`id` in (6574)

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.64msselect * from `sites_relationships` where `sites_relationships`.`id` in (82763, 327199, 394303, 478255, 1076018)

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

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

Bindings	0: 5650
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#52aviatickets780μsselect * from `offers` where `origin_city_id` = 6074 and `destination_city_id` = 6574

Bindings	0: 6074 1: 6574
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.68ms

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

Bindings	0: 6074 1: 485194 2: 80 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.23msselect * from `cities` where `cities`.`id` in (6074)

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.28msselect * from `cities` where `cities`.`id` in (966, 6752, 9246)

Backtrace

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

LocalRouteRepository.php#447aviatickets2.7msselect * from `sites_relationships` where `sites_relationships`.`id` in (485196, 485198, 560891)

Backtrace

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

LocalRouteRepository.php#412aviatickets1.32ms

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

Bindings	0: 6074 1: 80 2: 0 3: 0 4: 485196
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#412aviatickets960μsselect * from `cities` where `cities`.`id` in (6074)

Backtrace

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

LocalRouteRepository.php#412aviatickets970μsselect * from `cities` where `cities`.`id` in (3505, 4081)

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 `sites_relationships` where `sites_relationships`.`id` in (328494, 328527)

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.18msselect * from `countries` where `countries`.`id` in (248)

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#149aviatickets4.36ms

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

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

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.46msselect * from `cities` where `cities`.`id` in (1345, 3884, 3951, 4081, 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.23msselect * from `countries` where `countries`.`id` in (79, 92, 112, 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 (358556, 358593, 358595, 358599, 358617)

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#359aviatickets4.71ms

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

Bindings	0: 6074 1: 80 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

TimetableRepository.php#39aviatickets1.74ms

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

Bindings	0: 6074 1: 6574
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#144aviatickets840μs

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

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

Bindings	0: 6574 1: 6074
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514 app/Http/Controllers/RoutesController.php:530

LocalRouteRepository.php#520aviatickets1.27msselect * from `sites_relationships` where `sites_relationships`.`id` in (1274625)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514
app/Http/Controllers/RoutesController.php:530

LocalRoute.php#99aviatickets940μsselect * from `cities` where `cities`.`id` = 6074 limit 1

Bindings	0: 6074
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:99 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:30 app/Http/Controllers/RoutesController.php:536 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

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

RoutesController.php#547aviatickets1.42msselect * from `cities` where `cities`.`id` = 6574 limit 1

Bindings	0: 6574
Backtrace	app/Http/Controllers/RoutesController.php:547 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

description-nearbyCities.blade.php#20aviatickets3.59msselect * from `cities` where `cities`.`id` = 6074 limit 1

Bindings	0: 6074
Backtrace	view::routes.description-nearbyCities:20 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

App\Avia\Infrastructure\Model\Timetable: 85Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 27LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 26City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 18SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 8Country.php#?
App\Avia\Infrastructure\Model\Airline: 2Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: FUahVbbziTDkVDNL2Y5iwSSVh5PQiuk4KXlb9seE
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-tirana-to-varadero-tia-vra?_url=%2Fc...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-tirana-to-varadero-tia-vra

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-tirana-to-varadero-tia-vra"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllSU04vVUMzL3diemhObklBaEp6K3c9PSIsInZhbHVlIjoiME41emVib2F0VU9yaXNnR2JsaHVzeEhhTnh5S3E1RnAxaE8rYmlIUG9xbFBmaklVWlRJTDhoZ05qVk9hS3lSQS9VOVpmUFNsaVZXVmdUaGhqZ0FzaFo2bDNoTVJLanBPYmQ3bDVkYkcxalNva2lWNThKVCtwN3JETVpGRnhWS1AiLCJtYWMiOiJkNDQwNDYzM2Q5N2RhMDlmMjcwZTkzZmI0MDZjMmFkZmNjYjQ5NDI5NDZiZjRmMGEyYWFlYjU0ZmRjYzY3YWU2IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6Ikg3MVNIZzhzRjRSWi9tUko0Z1N4c3c9PSIsInZhbHVlIjoiWXNKOXdMR295UStiRitTbmRta05STjk3L1B6b2pGNHJ4c0RraGpuT2FnVnNCS0NCaUFNZTVrNXVLRHBnbjJudHZ3MTdrNS9zSlFVZEdaSkZjYmRxZHBoSDJnN2VTanFJL1BpTHk1dVBTTXBPbExZWmJWejNIckVhVmhzTWpOc0ciLCJtYWMiOiJhNjQxYTg2YTM4NjUwMDM0YTJlZGQ0MTkwOTgzODA3ZmVkMWEyMTBjYTBkM2NmNWY2Yzg1M2YxY2U3YTU5NGY2IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IllSU04vVUMzL3diemhObklBaEp6K3c9PSIsInZhbHVlIjoiME41emVib2F0VU9yaXNnR2JsaHVzeEhhTnh5S3E1RnAxaE8rYmlIUG9xbFBmaklVWlRJTDhoZ05qVk9hS3lSQS9VOVpmU ▶"
  ]
  "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

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "FUahVbbziTDkVDNL2Y5iwSSVh5PQiuk4KXlb9seE"
  "lowcostclub_session" => "uEoV85fdxiRc9GNewu1hy5Qk0ZjZxjuyA3Li1bEI"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 14 May 2025 12:29:38 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""06eb5e9d31f968af24c5a865f9f6dfac""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijh4UVVzcEhDcUVTdW1CUHN6bGhJdVE9PSIsInZhbHVlIjoiNWIrZGZyU2pJOFpjWWY1L3VwdFVtSnEvU2FDYkQyaUQrbEdyY3hRWnIvMklBREhRN1I5WXBzQXpRRzNxSnA4MTA0eUVEcFBISHhSK25VTEsvRmRBY3V1NDVzUTlYc0xEOVdnclM1YXBFNmlIT0IxUlpGUUlNdTEwN3BSd09vN0siLCJtYWMiOiJlZGY0YWYyN2VmYWNiZDcwM2M5MzIxMjhjYTUwNjkzODgwMDFmZTQ2YjE3MzhiODc1YmQ2YzJmMjRlNjQxMDdlIiwidGFnIjoiIn0%3D; expires=Wed, 14 May 2025 14:29:38 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ijh4UVVzcEhDcUVTdW1CUHN6bGhJdVE9PSIsInZhbHVlIjoiNWIrZGZyU2pJOFpjWWY1L3VwdFVtSnEvU2FDYkQyaUQrbEdyY3hRWnIvMklBREhRN1I5WXBzQXpRRzNxSnA4MTA0eUVEc ▶"
    1 => "lowcostclub_session=eyJpdiI6ImNhSmJ1a3FWaXdxSjFvY0FQanNPNUE9PSIsInZhbHVlIjoiUEFxb0hEamJ1TzVmdkhEOG9BajNpcjRDcWJEWFAzK1pmM25lcVVOK1U0aHdhVW9DcHNmdjlOZ3hLTW1rV2U3QWlEZ0RUQ0Y4Rk40c0prVnhZeXhDNnozb2t1bFBPc213cmJ4TGNkOFdiVzYrRlJUNFBDdExYT08vOExYQWU4T3AiLCJtYWMiOiJiNTkzNGNjMzAwMjU0YzAwNWI1M2E1ZGIzMDczNzNkOTY2ZmE0ZDNiODgwMTU1ZDFmYzVkNWZiOGJmN2YwYWE3IiwidGFnIjoiIn0%3D; expires=Wed, 14 May 2025 14:29:38 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6ImNhSmJ1a3FWaXdxSjFvY0FQanNPNUE9PSIsInZhbHVlIjoiUEFxb0hEamJ1TzVmdkhEOG9BajNpcjRDcWJEWFAzK1pmM25lcVVOK1U0aHdhVW9DcHNmdjlOZ3hLTW1rV2U3 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijh4UVVzcEhDcUVTdW1CUHN6bGhJdVE9PSIsInZhbHVlIjoiNWIrZGZyU2pJOFpjWWY1L3VwdFVtSnEvU2FDYkQyaUQrbEdyY3hRWnIvMklBREhRN1I5WXBzQXpRRzNxSnA4MTA0eUVEcFBISHhSK25VTEsvRmRBY3V1NDVzUTlYc0xEOVdnclM1YXBFNmlIT0IxUlpGUUlNdTEwN3BSd09vN0siLCJtYWMiOiJlZGY0YWYyN2VmYWNiZDcwM2M5MzIxMjhjYTUwNjkzODgwMDFmZTQ2YjE3MzhiODc1YmQ2YzJmMjRlNjQxMDdlIiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 14:29:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijh4UVVzcEhDcUVTdW1CUHN6bGhJdVE9PSIsInZhbHVlIjoiNWIrZGZyU2pJOFpjWWY1L3VwdFVtSnEvU2FDYkQyaUQrbEdyY3hRWnIvMklBREhRN1I5WXBzQXpRRzNxSnA4MTA0eUVEc ▶"
    1 => "lowcostclub_session=eyJpdiI6ImNhSmJ1a3FWaXdxSjFvY0FQanNPNUE9PSIsInZhbHVlIjoiUEFxb0hEamJ1TzVmdkhEOG9BajNpcjRDcWJEWFAzK1pmM25lcVVOK1U0aHdhVW9DcHNmdjlOZ3hLTW1rV2U3QWlEZ0RUQ0Y4Rk40c0prVnhZeXhDNnozb2t1bFBPc213cmJ4TGNkOFdiVzYrRlJUNFBDdExYT08vOExYQWU4T3AiLCJtYWMiOiJiNTkzNGNjMzAwMjU0YzAwNWI1M2E1ZGIzMDczNzNkOTY2ZmE0ZDNiODgwMTU1ZDFmYzVkNWZiOGJmN2YwYWE3IiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 14:29:38 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6ImNhSmJ1a3FWaXdxSjFvY0FQanNPNUE9PSIsInZhbHVlIjoiUEFxb0hEamJ1TzVmdkhEOG9BajNpcjRDcWJEWFAzK1pmM25lcVVOK1U0aHdhVW9DcHNmdjlOZ3hLTW1rV2U3 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "FUahVbbziTDkVDNL2Y5iwSSVh5PQiuk4KXlb9seE"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-tirana-to-varadero-tia-vra?_url=%2Fcheap-flights-from-tirana-to-varadero-tia-vra"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-14 12:29:38	GET	/cheap-flights-from-tirana-to-varadero-tia-vra	41 45 167

1 x Application (91.18%)	270ms
1 x Booting (8.82%)	26.13ms

Cheap flights Tirana — Varadero (TIA — VRA)

Choose your dates to find the flight:

Good to know - Cheap tickets Tirana — Varadero

Popular airlines flying Tirana — Varadero

Routes from nearby cities to Varadero

Popular International routes from Tirana

Popular routes from Varadero

Related pages

Select your currency

All currencies

Select your language

All languages