Cheap flights Herat — Larnaca (HEA — LCA)

Choose your dates to find the flight:

Good to know - Cheap tickets Herat — Larnaca

Flight distance	2611 km
Round-trip from	$4,186

Routes from nearby cities to Larnaca

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

Kabul — Larnaca

from $718 round-trip

Mashad — Larnaca

from $236 one-way

Tehran — Larnaca

from $239 one-way

Most often, departures to Larnaca are from Mashad, this is the cheapest flight from $236. The nearest airports from Herat with a flight to Larnaca are located in Tehran.

Popular International routes from Herat

Herat — Larnaca

from $4,186 round-trip

from $508 one-way

from $1,318 one-way

from $2,610 one-way

from $1,609 one-way

Popular routes from Larnaca

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

Larnaca — Moscow

from $113 one-way

Larnaca — Tokyo

from $405 one-way

Larnaca — Saint Petersburg

from $146 one-way

Larnaca — Yerevan

from $23 one-way

Larnaca — Male

from $197 one-way

Popular domestic routes from Herat

Herat — Mazar-I-Sharif

from $108 one-way

Herat — Kandahar

from $774 one-way

Herat — Kabul

from $70 one-way

Messages Timeline Exceptions Views42 Route Queries54 Models257 Mails Gate N+1 Queries Session Request

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

Booting (26ms)time
Application (312ms)time
1 x Application (92.31%)
312ms
1 x Booting (7.69%)
26.00ms

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

54 statements were executed (7 duplicates)Show only duplicates69.4ms

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.67msselect * from `sites_relationships` where `us` = 'cheap-flights-from-herat-to-larnaca-hea-lca' limit 1

Bindings	0: cheap-flights-from-herat-to-larnaca-hea-lca
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` = '1263822' 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.37msselect * from `cities` where `cities`.`id` = 2335 limit 1

Bindings	0: 2335
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#136aviatickets1msselect * from `countries` where `countries`.`id` = 176 limit 1

Bindings	0: 176
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.24msselect * from `cities` where `cities`.`id` = 3470 limit 1

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

Bindings	0: 10
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#33aviatickets860μs

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

Bindings	0: 1263822
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#31aviatickets990μsselect * from `countries` where `code` = '' limit 1

Bindings	0:
Backtrace	app/Avia/Infrastructure/Repository/CountriesRepository.php:31 app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:61 app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:43 app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:56 app/Avia/Infrastructure/Model/LocalRoute.php:190

RouteRepository.php#42aviatickets1.58ms

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

Bindings	0: 2335 1: 3470 2: 2025-05-05 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#66aviatickets900μsselect * from `monthly_price_statistics` where `origin_city_id` = 2335 and `destination_city_id` = 3470 limit 1

Bindings	0: 2335 1: 3470
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#470aviatickets880μs

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

Bindings	0: 2335 1: 3470
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.17msselect distinct `airline_id` from `timetables` where `origin_city_id` = 2335

Bindings	0: 2335
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.68msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3470

Bindings	0: 3470
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.18ms

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

Bindings	0: 2335 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.86ms

select * from `flights_by` where `origin_city_id` in (3933, 8482, 9319, 2891, 6067) and `destination_city_id` = 3470 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3933 1: 8482 2: 9319 3: 2891 4: 6067 5: 3470 6: 0 7: 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.01msselect * from `cities` where `cities`.`id` in (2891, 3933, 6067)

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

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 (158328, 208491, 328018)

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

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

Bindings	0: 3933
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#52aviatickets920μsselect * from `offers` where `origin_city_id` = 2335 and `destination_city_id` = 3470

Bindings	0: 2335 1: 3470
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.37ms

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

Bindings	0: 2335 1: 1263822 2: 176 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.19msselect * from `cities` where `cities`.`id` in (2335)

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.13msselect * from `cities` where `cities`.`id` in (4761, 5067)

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#447aviatickets950μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1263823, 1263824)

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

select * from `flights_by` where `origin_city_id` = 2335 and `destination_country_id` <> 176 and (`price_one_way` > 0 or `price` > 0) and `id` not in (1263823) order by `revenue` desc limit 3 offset 0

Bindings	0: 2335 1: 176 2: 0 3: 0 4: 1263823
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#412aviatickets950μsselect * from `cities` where `cities`.`id` in (2335)

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#412aviatickets990μsselect * from `cities` where `cities`.`id` in (2686, 3470, 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#412aviatickets1.1msselect * from `sites_relationships` where `sites_relationships`.`id` in (129785, 129790, 1263822)

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.14msselect * from `countries` where `countries`.`id` in (10, 134, 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#149aviatickets1.31ms

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

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

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#149aviatickets960μsselect * from `cities` where `cities`.`id` in (1811, 3505, 4006, 4081, 6319)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets1.18msselect * from `countries` where `countries`.`id` in (56, 124, 211, 248)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets1.01msselect * from `sites_relationships` where `sites_relationships`.`id` in (182625, 182773, 182822, 182827, 183043)

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#359aviatickets3.46ms

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

Bindings	0: 2335 1: 176 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#359aviatickets2.61msselect * from `cities` where `cities`.`id` in (2335)

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#359aviatickets2.05msselect * from `cities` where `cities`.`id` in (2891, 8482, 9319)

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#359aviatickets3.5msselect * from `sites_relationships` where `sites_relationships`.`id` in (129787, 129788, 129791)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets1.5msselect * from `countries` where `countries`.`id` in (176)

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

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

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

TimetableRepository.php#144aviatickets1.08ms

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

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

Bindings	0: 3470 1: 2335
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#20aviatickets900μsselect * from `cities` where `cities`.`id` = 2335 limit 1

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

LocalRouteRepository.php#175aviatickets1.28msselect * 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.02msselect * 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.17msselect * 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.01msselect * 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#175aviatickets820μsselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#149aviatickets1.59ms

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#149aviatickets920μ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.07msselect * 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#149aviatickets810μsselect * 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#149aviatickets960μs

select * from `sites_relationships` where `sites_relationships`.`id` in (239645, 239765, 239824, 239994, 240101, 240103, 240116, 240218, 240243)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
app/Avia/Application/SeoRoutesHandler.php:54

App\Avia\Infrastructure\Model\Timetable: 120Timetable.php#?
App\Avia\Infrastructure\Model\City: 47City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 37LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 33SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 19Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: 5ug9U5difxDmSnLkgNT5uOz8Pg4NdV7QQczIwL5w
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-herat-to-larnaca-hea-lca?_url=%2Fche...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-herat-to-larnaca-hea-lca

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-herat-to-larnaca-hea-lca"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlzR3JkdE4vNFp3ODFUQWpoMnpTMVE9PSIsInZhbHVlIjoiY1hZT3dLdFhFNnRjQ2RMazNTUTZNVkVacTMwRVVjeWF3YndkWk1LQURKQTBlREtvV2lla25veG1teVRaVXhZcm5yVHJ0UzVoQy9FeURBaWtDb3VjK2ozTmRkVmxlOTZyRVY1ZzVack0xRTJpa1RObmxGM3B6TnBFQS9nNmt0MkQiLCJtYWMiOiI2ZWE1OTU0ZjNlZDAzNmNiNGJjNGRjZThmMjUxMmNjNGIwYzgyYTA3NTVlYWZhMjIyNzFmZmNmYjc1OTA0ODQ4IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IkxsWS9obzNkRGVpelhVK1BpNkZuL2c9PSIsInZhbHVlIjoieEVqTTErdmE1bGlaeUFIL2doNEVFeER2VXF2SUw2Zm9XUkxkVDlOdnRaVDN5b0h5VTdiZXN5NDJ5UHVrYmNMRkQ2bnB6ejN3bWdQM2RGWnJOaVVudVRCelF6ODB3Q0ZqK01URmw1T0xHR0YzVGN2aHd6azVPbjBsWDVaL0V0cWwiLCJtYWMiOiI5ZTExZjJhYzRkMDgyZGY4NmEzZTFmZmQ5ZjM3MmNjZTRlNmQ1ZDUzZWZhMWIxY2ZkYmZiNTI4YjUwNzg2NTQ4IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjlzR3JkdE4vNFp3ODFUQWpoMnpTMVE9PSIsInZhbHVlIjoiY1hZT3dLdFhFNnRjQ2RMazNTUTZNVkVacTMwRVVjeWF3YndkWk1LQURKQTBlREtvV2lla25veG1teVRaVXhZcm5yVHJ0U ▶"
  ]
  "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" => "5ug9U5difxDmSnLkgNT5uOz8Pg4NdV7QQczIwL5w"
  "lowcostclub_session" => "VUjHkVQZJEAgLcQZomu99p0eDWkMkk0OXscFxKLQ"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 20:57:39 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""aed8c5b3763388633ad844d49a612655""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNKblptcHBtRktRSDdTYTZ5MXNzOFE9PSIsInZhbHVlIjoiQlhsK3lsNVhERm5NTjkyQ3QyWk8ydXNiaTlucjRLb09JQzhPSGJ3TVY1d1R0enp1cjZUd3JiSnVCUksvdU1kdjBSRDkrU201dXRUY0VxOVpETVUxN05KRGJJSG01MTNiVlVVWHpWK3dzakY5UU5RY0gyTTRCMTg2YmlUU2ZET2kiLCJtYWMiOiI3YzlhZDM1Njk3YzU2YjM3Y2RlODI4ZDUzMjg5MThmYjFiZWM3NDYxYWViM2VjMmYxMTlhYjVhZTBlOWNiYTczIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 22:57:39 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImNKblptcHBtRktRSDdTYTZ5MXNzOFE9PSIsInZhbHVlIjoiQlhsK3lsNVhERm5NTjkyQ3QyWk8ydXNiaTlucjRLb09JQzhPSGJ3TVY1d1R0enp1cjZUd3JiSnVCUksvdU1kdjBSRDkrU ▶"
    1 => "lowcostclub_session=eyJpdiI6IjhLQzZBREdEQnNKYUlONFRwaWZMbUE9PSIsInZhbHVlIjoicHJCUldDWmtXUnh3MmVoR0VWd1JVbHpOak92V09zeThwaVR5QVFSY284OE8xVEc2dVNSbWE4VW5HZU12ZFgxZHdIWW02R2oxTUpsOG1VU2svV1RKZFBEMnNERUIwcHpQUERzcmZ4Wlg2VjlmRVpwUnFvTGFyaGNJU3hsZ2pSM2giLCJtYWMiOiJjZDZhYzRiNzgxMWYxZmY4MDQ4MDk1ZGJkYjQyNjAwOTcxZDdkMTUwYzBmYjNhMzk0YzBjNzI5M2NiODg3YzZmIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 22:57:39 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjhLQzZBREdEQnNKYUlONFRwaWZMbUE9PSIsInZhbHVlIjoicHJCUldDWmtXUnh3MmVoR0VWd1JVbHpOak92V09zeThwaVR5QVFSY284OE8xVEc2dVNSbWE4VW5HZU12ZFgx ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNKblptcHBtRktRSDdTYTZ5MXNzOFE9PSIsInZhbHVlIjoiQlhsK3lsNVhERm5NTjkyQ3QyWk8ydXNiaTlucjRLb09JQzhPSGJ3TVY1d1R0enp1cjZUd3JiSnVCUksvdU1kdjBSRDkrU201dXRUY0VxOVpETVUxN05KRGJJSG01MTNiVlVVWHpWK3dzakY5UU5RY0gyTTRCMTg2YmlUU2ZET2kiLCJtYWMiOiI3YzlhZDM1Njk3YzU2YjM3Y2RlODI4ZDUzMjg5MThmYjFiZWM3NDYxYWViM2VjMmYxMTlhYjVhZTBlOWNiYTczIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 22:57:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImNKblptcHBtRktRSDdTYTZ5MXNzOFE9PSIsInZhbHVlIjoiQlhsK3lsNVhERm5NTjkyQ3QyWk8ydXNiaTlucjRLb09JQzhPSGJ3TVY1d1R0enp1cjZUd3JiSnVCUksvdU1kdjBSRDkrU ▶"
    1 => "lowcostclub_session=eyJpdiI6IjhLQzZBREdEQnNKYUlONFRwaWZMbUE9PSIsInZhbHVlIjoicHJCUldDWmtXUnh3MmVoR0VWd1JVbHpOak92V09zeThwaVR5QVFSY284OE8xVEc2dVNSbWE4VW5HZU12ZFgxZHdIWW02R2oxTUpsOG1VU2svV1RKZFBEMnNERUIwcHpQUERzcmZ4Wlg2VjlmRVpwUnFvTGFyaGNJU3hsZ2pSM2giLCJtYWMiOiJjZDZhYzRiNzgxMWYxZmY4MDQ4MDk1ZGJkYjQyNjAwOTcxZDdkMTUwYzBmYjNhMzk0YzBjNzI5M2NiODg3YzZmIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 22:57:39 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjhLQzZBREdEQnNKYUlONFRwaWZMbUE9PSIsInZhbHVlIjoicHJCUldDWmtXUnh3MmVoR0VWd1JVbHpOak92V09zeThwaVR5QVFSY284OE8xVEc2dVNSbWE4VW5HZU12ZFgx ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "5ug9U5difxDmSnLkgNT5uOz8Pg4NdV7QQczIwL5w"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-herat-to-larnaca-hea-lca?_url=%2Fcheap-flights-from-herat-to-larnaca-hea-lca"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-07 20:57:39	GET	/cheap-flights-from-herat-to-larnaca-hea-lca	42 54 257

1 x Application (92.31%)	312ms
1 x Booting (7.69%)	26.00ms

Cheap flights Herat — Larnaca (HEA — LCA)

Choose your dates to find the flight:

Good to know - Cheap tickets Herat — Larnaca

Routes from nearby cities to Larnaca

Popular International routes from Herat

Popular routes from Larnaca

Popular domestic routes from Herat

Select your currency

All currencies

Select your language

All languages