The most frequent flight to Asturias is from Menorca. The cheapest airfare can be purchased with a flight from Palma Mallorca from $30. The nearest airports from Barcelona with a flight to Asturias are in Alguaire.

Popular International routes from Barcelona

Barcelona — Moscow

from $212 one-way

Barcelona — Saint Petersburg

from $232 one-way

Barcelona — Paderborn

from $245 one-way

Barcelona — Port Au Prince

from $586 one-way

Barcelona — Paris

from $19 one-way

Popular routes from Asturias

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

Asturias — Moscow

from $190 one-way

Asturias — Saint Petersburg

from $214 one-way

Asturias — Bogota

from $472 one-way

Asturias — Samara

from $281 one-way

Asturias — Miami

from $784 one-way

Popular domestic routes from Barcelona

Barcelona — Tenerife

from $19 one-way

Barcelona — Palma Mallorca

from $6 one-way

Barcelona — Ibiza

from $17 one-way

Barcelona — Madrid

from $10 one-way

Barcelona — Alicante

from $20 one-way

Return flights Asturias – Barcelona

Schedule of direct flights Barcelona — Asturias

Messages Timeline Exceptions Views54 Route Queries85 Models508 Mails Gate N+1 Queries3 Session Request

Request history8.3.0449ms5MBGET cheap-flights-from-{slug}

Booting (29.25ms)time
Application (420ms)time
1 x Application (93.48%)
420ms
1 x Booting (6.51%)
29.25ms

54 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
6x components.airlines-columnairlines-column.blade.php#?blade
1x routes.LastSales48LastSales48.blade.php#?blade
1x components.last-sales-48-recordslast-sales-48-records.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
20x components.routeListItemrouteListItem.blade.php#?blade
1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
2x components.routes-columnroutes-column.blade.php#?blade
1x components.related-linksrelated-links.blade.php#?blade
1x layouts.mainmain.blade.php#?blade
1x headerheader.blade.php#?blade
2x menumenu.blade.php#?blade
1x footerfooter.blade.php#?blade
1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
1x footer_scriptsfooter_scripts.blade.php#?blade
1x components.currencycurrency.blade.php#?blade
2x components.popuppopup.blade.php#?blade
1x components.languagelanguage.blade.php#?blade

uri: GET cheap-flights-from-{slug}
middleware: web
controller: App\Http\Controllers\RoutesController@view
namespace
prefix: /
where
as: route
file: app/Http/Controllers/RoutesController.php:96-299

85 statements were executed (38 duplicates)Show only duplicates115ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

vendor/beyondcode/laravel-query-detector/src/QueryDetector.php:25
vendor/beyondcode/laravel-query-detector/src/QueryDetectorMiddleware.php:30
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
app/Http/Middleware/MinifyHtml.php:21

SitesRelationshipsSqlRepository.php#34aviatickets4.03msselect * from `sites_relationships` where `us` = 'cheap-flights-from-barcelona-to-oviedo-bcn-ovd' limit 1

Bindings	0: cheap-flights-from-barcelona-to-oviedo-bcn-ovd
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#125aviatickets950μsselect * from `flights_by` where `flights_by`.`id` = '27813' 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.09msselect * from `cities` where `cities`.`id` = 472 limit 1

Bindings	0: 472
Backtrace	app/Http/Controllers/RoutesController.php:135 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#136aviatickets1.02msselect * from `countries` where `countries`.`id` = 23 limit 1

Bindings	0: 23
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#137aviatickets1msselect * from `cities` where `cities`.`id` = 4762 limit 1

Bindings	0: 4762
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#138aviatickets1msselect * from `countries` where `countries`.`id` = 23 limit 1

Bindings	0: 23
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#33aviatickets850μs

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

Bindings	0: 27813
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#31aviatickets1msselect * 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.1ms

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

Bindings	0: 472 1: 4762 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#66aviatickets1.05msselect * from `monthly_price_statistics` where `origin_city_id` = 472 and `destination_city_id` = 4762 limit 1

Bindings	0: 472 1: 4762
Backtrace	app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66 app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:50 app/Avia/Application/PriceHandler.php:42 app/Http/Controllers/RoutesController.php:156 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

AirlineSqlRepository.php#470aviatickets1.25ms

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

Bindings	0: 472 1: 4762
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#470aviatickets910μsselect * from `airlines` where `airlines`.`id` in (4282, 5323, 17876)

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#502aviatickets2.24msselect distinct `airline_id` from `timetables` where `origin_city_id` = 472

Bindings	0: 472
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.32msselect distinct `airline_id` from `timetables` where `origin_city_id` = 4762

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

select * from `airlines` where `id` in (325, 331, 2293, 2817, 3314, 4912, 5829, 5879, 17856, 24064, 259328, 642059, 2025386, 5675327) order by `name` asc

Bindings	0: 325 1: 331 2: 2293 3: 2817 4: 3314 5: 4912 6: 5829 7: 5879 8: 17856 9: 24064 10: 259328 11: 642059 12: 2025386 13: 5675327
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.32ms

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

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

NearbyCitiesAggregateDbProvider.php#73aviatickets2.04ms

select * from `flights_by` where `origin_city_id` in (8043, 8430, 5284, 6788, 8670, 1025, 6928, 974, 3790, 6140) and `destination_city_id` = 4762 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8043 1: 8430 2: 5284 3: 6788 4: 8670 5: 1025 6: 6928 7: 974 8: 3790 9: 6140 10: 4762 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.09msselect * from `cities` where `cities`.`id` in (3790, 6140, 6788, 6928, 8430)

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

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 `sites_relationships` where `sites_relationships`.`id` in (121404, 201046, 264700, 486098, 1170145)

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

LocalRouteRepository.php#558aviatickets1.14ms

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

Bindings	0: 472 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.5ms

select * from `flights_by` where `origin_city_id` in (8043, 8430, 5284, 6788, 8670, 1025, 6928, 974, 3790, 6140) and `destination_city_id` = 4762 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8043 1: 8430 2: 5284 3: 6788 4: 8670 5: 1025 6: 6928 7: 974 8: 3790 9: 6140 10: 4762 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:85

NearbyCitiesAggregateDbProvider.php#73aviatickets950μsselect * from `cities` where `cities`.`id` in (3790, 6140, 6788, 6928, 8430)

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:85

NearbyCitiesAggregateDbProvider.php#73aviatickets970μsselect * from `cities` where `cities`.`id` in (4762)

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:85

NearbyCitiesAggregateDbProvider.php#73aviatickets740μsselect * from `sites_relationships` where `sites_relationships`.`id` in (121404, 201046, 264700, 486098, 1170145)

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:85

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

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

LocalRouteRepository.php#558aviatickets1.03ms

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

Bindings	0: 472 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.4ms

select * from `flights_by` where `origin_city_id` in (8043, 8430, 5284, 6788, 8670, 1025, 6928, 974, 3790, 6140) and `destination_city_id` = 4762 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8043 1: 8430 2: 5284 3: 6788 4: 8670 5: 1025 6: 6928 7: 974 8: 3790 9: 6140 10: 4762 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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets940μsselect * from `cities` where `cities`.`id` in (3790, 6140, 6788, 6928, 8430)

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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets780μsselect * from `cities` where `cities`.`id` in (4762)

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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.08msselect * from `sites_relationships` where `sites_relationships`.`id` in (121404, 201046, 264700, 486098, 1170145)

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:142

CitySqlRepository.php#104aviatickets850μsselect * from `cities` where `cities`.`id` = 6928 limit 1

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

LocalRouteRepository.php#558aviatickets880μs

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

Bindings	0: 472 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.38ms

select * from `flights_by` where `origin_city_id` in (8043, 8430, 5284, 6788, 8670, 1025, 6928, 974, 3790, 6140) and `destination_city_id` = 4762 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8043 1: 8430 2: 5284 3: 6788 4: 8670 5: 1025 6: 6928 7: 974 8: 3790 9: 6140 10: 4762 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:123

NearbyCitiesAggregateDbProvider.php#73aviatickets930μsselect * from `cities` where `cities`.`id` in (3790, 6140, 6788, 6928, 8430)

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:123

NearbyCitiesAggregateDbProvider.php#73aviatickets800μsselect * from `cities` where `cities`.`id` in (4762)

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:123

NearbyCitiesAggregateDbProvider.php#73aviatickets730μsselect * from `sites_relationships` where `sites_relationships`.`id` in (121404, 201046, 264700, 486098, 1170145)

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:123

CitySqlRepository.php#104aviatickets860μsselect * from `cities` where `cities`.`id` = 3790 limit 1

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

LocalRouteRepository.php#558aviatickets860μs

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

Bindings	0: 472 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.61ms

select * from `flights_by` where `origin_city_id` in (8043, 8430, 5284, 6788, 8670, 1025, 6928, 974, 3790, 6140) and `destination_city_id` = 4762 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8043 1: 8430 2: 5284 3: 6788 4: 8670 5: 1025 6: 6928 7: 974 8: 3790 9: 6140 10: 4762 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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets990μsselect * from `cities` where `cities`.`id` in (3790, 6140, 6788, 6928, 8430)

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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets780μsselect * from `cities` where `cities`.`id` in (4762)

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:142

NearbyCitiesAggregateDbProvider.php#73aviatickets770μsselect * from `sites_relationships` where `sites_relationships`.`id` in (121404, 201046, 264700, 486098, 1170145)

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:142

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

Bindings	0: 6928
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#52aviatickets770μsselect * from `offers` where `origin_city_id` = 472 and `destination_city_id` = 4762

Bindings	0: 472 1: 4762
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#447aviatickets4.81ms

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

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

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.37msselect * from `cities` where `cities`.`id` in (4795, 4805, 9324)

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.06msselect * from `sites_relationships` where `sites_relationships`.`id` in (27819, 27820, 27821)

Backtrace

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

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

Bindings	0: 35
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.88ms

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

Bindings	0: 472 1: 23 2: 0 3: 0 4: 27819
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.15msselect * from `cities` where `cities`.`id` in (472)

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.3msselect * 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#412aviatickets1.1msselect * from `sites_relationships` where `sites_relationships`.`id` in (27636, 27729)

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.13msselect * 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#149aviatickets1.9ms

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

Bindings	0: 4762 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 (4762)

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.33msselect * from `cities` where `cities`.`id` in (770, 3361, 3505, 3951, 4081)

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 (92, 121, 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 (252699, 252754, 252770, 252776, 1157995)

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

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

Bindings	0: 472 1: 23 2: 0 3: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets1.23msselect * from `cities` where `cities`.`id` in (472)

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#359aviatickets13.17msselect * from `cities` where `cities`.`id` in (178, 2540, 3787, 5992, 6928)

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.09msselect * from `sites_relationships` where `sites_relationships`.`id` in (27154, 27510, 27683, 27851, 28042)

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

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

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

Bindings	0: 472 1: 4762
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#39aviatickets1.14msselect * from `airports` where `airports`.`id` in (5090)

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#39aviatickets870μsselect * from `airports` where `airports`.`id` in (94)

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#39aviatickets1.04msselect * from `airlines` where `airlines`.`id` in (5323, 17876)

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

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

Bindings	0: 472 1: 4762
Backtrace	app/Avia/Infrastructure/Repository/TimetableRepository.php:144 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/TimetableRepository.php:137 app/Http/Controllers/RoutesController.php:274

LocalRouteRepository.php#520aviatickets1.8msselect * from `flights_by` where `origin_city_id` = 4762 and `destination_city_id` = 472 limit 1

Bindings	0: 4762 1: 472
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#520aviatickets790μsselect * from `sites_relationships` where `sites_relationships`.`id` in (252690)

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

RoutesController.php#547aviatickets940μsselect * from `cities` where `cities`.`id` = 4762 limit 1

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

RoutesController.php#548aviatickets1.83msselect * from `cities` where `cities`.`id` = 472 limit 1

Bindings	0: 472
Backtrace	app/Http/Controllers/RoutesController.php:548 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#28aviatickets920μsselect * from `cities` where `cities`.`id` = 472 limit 1

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

LocalRouteRepository.php#175aviatickets910μsselect * 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.64msselect * 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#175aviatickets990μsselect * 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#175aviatickets890μsselect * from `countries` where `countries`.`id` in (17, 70, 79, 92, 105)

Backtrace

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

LocalRouteRepository.php#175aviatickets800μsselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.4ms

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#149aviatickets860μ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.01msselect * 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#149aviatickets990μ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#149aviatickets860μ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: 222Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 107LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 79City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 58SitesRelationship.php#?
App\Avia\Infrastructure\Model\Airline: 19Airline.php#?
App\Avia\Infrastructure\Model\Country: 17Country.php#?
App\Avia\Infrastructure\Model\Route: 3Route.php#?
App\Avia\Infrastructure\Model\Airport: 2Airport.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\SitesRela...

_token: Nn7mnSXzLaApNDnSkaA9F5l838maB3qJyO1IBBSI
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-barcelona-to-oviedo-bcn-ovd?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-barcelona-to-oviedo-bcn-ovd

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-barcelona-to-oviedo-bcn-ovd"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpFWlFveWpPQXYydVlUQm5vQ0E1eGc9PSIsInZhbHVlIjoieEVUMjl6YXNybFhpaDFOcXRXbjgwa3NuQjRYVlM2NTdTMkgwMGdDUzRVT3I1QmVHNmI0cThudlVNblk1WFBDK0o5ckJiVC9xeTJWMXI3Y25TRWxDc0lnellpM1BuVFlSMEJPOVNJNkJxVFJsNTZVb2wrMTIrZWtyWG5UTldja0kiLCJtYWMiOiI3ZjdkNjhiNzUwZDJhNjQ2NDNkNzFmZTc0ZmIyMTg1YWRjOGYzNDAzYWJiZjkwYzljZTg0NGQxYjQ3MmQ5NjllIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IkdrOE84cDVPbVU1bVorL2NEczM0bXc9PSIsInZhbHVlIjoiMjcvajdkWWd1YmluSGM2MWdQR084VzUxemVTTURCUm91ZDE5aUJvME5WWkdleXdLR1A4SWhnYnFFRWRydjl2LzFkcGs0NGtWaHh2WWFFdnFwK2pvVnhXWlFKcnhCSURaWmJhditwZ3JyUFZkbjQzUFFNQTdpZ3pKL0NRUWJyd08iLCJtYWMiOiIxNDZkMjg4MjVkZjU4Y2YwYTNiZWFjZGQ2NDI0ODYzOTI3NmZmMTY4NDlhYmZkZmUzNTM3MjM2ZDA3NjVhOGNlIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImpFWlFveWpPQXYydVlUQm5vQ0E1eGc9PSIsInZhbHVlIjoieEVUMjl6YXNybFhpaDFOcXRXbjgwa3NuQjRYVlM2NTdTMkgwMGdDUzRVT3I1QmVHNmI0cThudlVNblk1WFBDK0o5ckJiV ▶"
  ]
  "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" => "Nn7mnSXzLaApNDnSkaA9F5l838maB3qJyO1IBBSI"
  "lowcostclub_session" => "RGxwiTdHankA28949pkSrSr6TGU071yaO3iDAkzw"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Fri, 09 May 2025 03:35:32 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""899624bf0cf63a0bcb0032040d3e97a0""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJpTk1uemdvU2N5NVRQM2V5ZnNoTGc9PSIsInZhbHVlIjoibVlFUEF2NWZtRFNtaGQxU0pudVFveDg4bWhDU1VEemd1M0dHaGZTYkk1Q1NTeEpZTHo0TWpZQVRVNFlneGFxUytlbXlmMEpCWFNxSm9leCsvYUUvK1lPdXYxdlhqUitwWHF0OW9zWGh1ZVVPR2E2clNEdEtMK05iL3FqZm05bWsiLCJtYWMiOiI5YTM2MDEyMmRlZDliMzYxY2ViMDliYTY4NTZkNDI1YjdlYzQ5NzU0M2RmMWU3YTQ3MjY2MDZhNGNkMzFiMjU0IiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 05:35:33 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlJpTk1uemdvU2N5NVRQM2V5ZnNoTGc9PSIsInZhbHVlIjoibVlFUEF2NWZtRFNtaGQxU0pudVFveDg4bWhDU1VEemd1M0dHaGZTYkk1Q1NTeEpZTHo0TWpZQVRVNFlneGFxUytlbXlmM ▶"
    1 => "lowcostclub_session=eyJpdiI6InF3VEdwb2FBOUlPYmJLK1ZZTlFzSXc9PSIsInZhbHVlIjoiaDRIa0xGQ280QncrNzNkTWRlT0pabUJlMmJleGRsQkJjUUlGWnBLS1FNSm4rK2NJcHNFcWFxZWY4TUhUUG5DdDZZaEZtRzhuSFBtSVpHV25WbkNEZ3ByZG03SUJDbmR2aG13VkFubkpIQmNqOFU4ZVRpSE5RekFocDZvUitTZisiLCJtYWMiOiIzM2Y5NTI4ZmZhMGYzMTk5ZGIzNmM3YmQxMTVmZWFhMzcwNmU3ZjlkMGExMWYxNTg1ZWZmYTI1NWI5NDg0ZDBkIiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 05:35:33 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6InF3VEdwb2FBOUlPYmJLK1ZZTlFzSXc9PSIsInZhbHVlIjoiaDRIa0xGQ280QncrNzNkTWRlT0pabUJlMmJleGRsQkJjUUlGWnBLS1FNSm4rK2NJcHNFcWFxZWY4TUhUUG5D ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJpTk1uemdvU2N5NVRQM2V5ZnNoTGc9PSIsInZhbHVlIjoibVlFUEF2NWZtRFNtaGQxU0pudVFveDg4bWhDU1VEemd1M0dHaGZTYkk1Q1NTeEpZTHo0TWpZQVRVNFlneGFxUytlbXlmMEpCWFNxSm9leCsvYUUvK1lPdXYxdlhqUitwWHF0OW9zWGh1ZVVPR2E2clNEdEtMK05iL3FqZm05bWsiLCJtYWMiOiI5YTM2MDEyMmRlZDliMzYxY2ViMDliYTY4NTZkNDI1YjdlYzQ5NzU0M2RmMWU3YTQ3MjY2MDZhNGNkMzFiMjU0IiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 05:35:33 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlJpTk1uemdvU2N5NVRQM2V5ZnNoTGc9PSIsInZhbHVlIjoibVlFUEF2NWZtRFNtaGQxU0pudVFveDg4bWhDU1VEemd1M0dHaGZTYkk1Q1NTeEpZTHo0TWpZQVRVNFlneGFxUytlbXlmM ▶"
    1 => "lowcostclub_session=eyJpdiI6InF3VEdwb2FBOUlPYmJLK1ZZTlFzSXc9PSIsInZhbHVlIjoiaDRIa0xGQ280QncrNzNkTWRlT0pabUJlMmJleGRsQkJjUUlGWnBLS1FNSm4rK2NJcHNFcWFxZWY4TUhUUG5DdDZZaEZtRzhuSFBtSVpHV25WbkNEZ3ByZG03SUJDbmR2aG13VkFubkpIQmNqOFU4ZVRpSE5RekFocDZvUitTZisiLCJtYWMiOiIzM2Y5NTI4ZmZhMGYzMTk5ZGIzNmM3YmQxMTVmZWFhMzcwNmU3ZjlkMGExMWYxNTg1ZWZmYTI1NWI5NDg0ZDBkIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 05:35:33 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6InF3VEdwb2FBOUlPYmJLK1ZZTlFzSXc9PSIsInZhbHVlIjoiaDRIa0xGQ280QncrNzNkTWRlT0pabUJlMmJleGRsQkJjUUlGWnBLS1FNSm4rK2NJcHNFcWFxZWY4TUhUUG5D ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Nn7mnSXzLaApNDnSkaA9F5l838maB3qJyO1IBBSI"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-barcelona-to-oviedo-bcn-ovd?_url=%2Fcheap-flights-from-barcelona-to-oviedo-bcn-ovd"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-09 03:35:33	GET	/cheap-flights-from-barcelona-to-oviedo-bcn-ovd	54 85 508 3

1 x Application (93.48%)	420ms
1 x Booting (6.51%)	29.25ms

Cheap flights Barcelona — Asturias (BCN — OVD)

Choose your dates to find the flight:

Good to know - Cheap tickets Barcelona — Asturias

Popular airlines flying Barcelona — Asturias

Airlines with direct flights

Other airlines flying with transfers

Sales of tickets from Barcelona to Asturias in the last 48 hours

Routes from nearby cities to Asturias

Popular International routes from Barcelona

Popular routes from Asturias

Popular domestic routes from Barcelona

Related pages

Select your currency

All currencies

Select your language

All languages