Cheap flights Pisa — Asturias (PSA — OVD)

  1. Flights
  2. Italy
  3. Pisa

Good to know - Cheap tickets Pisa — Asturias

Cheapest flight found $116
Minimal flight time 2h 5m
Flight distance 1320 km
Most popular airline Enter Air

Popular airlines flying Pisa — Asturias

Flight Pisa – Asturias is served by 10 airlines.  1 airlines operate direct flights.


Airlines with direct flights


Other airlines flying with transfers

Routes from nearby cities to Asturias

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

search

Bologna — Asturias

search

Genoa — Asturias

search

Milan — Asturias

search

Venice — Asturias

search

Verona — Asturias

search

Florence — Asturias

Most often, departures to Asturias are from Milan, this is the cheapest flight from $29. The nearest airports from Pisa with a flight to Asturias are located in Genoa.

Popular International routes from Pisa

search

Pisa — Moscow

search

Pisa — Saint Petersburg

search

Pisa — Paris

search

Pisa — West Palm Beach

search

Pisa — Ponta Delgada (Azores)

Popular routes from Asturias

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

search

Asturias — Moscow

search

Asturias — Saint Petersburg

search

Asturias — Bogota

search

Asturias — Samara

search

Asturias — Miami

Popular domestic routes from Pisa

search

Pisa — Palermo

search

Pisa — Rome

search

Pisa — Catania

search

Pisa — Cagliari

search

Pisa — Milan

Related pages

Return flights Asturias – Pisa

Schedule of direct flights Pisa — Asturias

We use cookies and similar technologies for different purposes. Read the privacy policy. If you use the site you agree to them.

MessagesTimelineExceptionsViews51RouteQueries52Models194MailsGateN+1 QueriesSessionRequest
Request history8.3.0PHP Version377msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (33.58ms)time
    • Application (343ms)time
    • 1 x Application (91.09%)
      343ms
      1 x Booting (8.91%)
      33.58ms
      51 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.airlines-columnairlines-column.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 21x 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
      52 statements were executed (12 duplicates)Show only duplicates108ms
      • 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#34aviatickets5.29msselect * from `sites_relationships` where `us` = 'cheap-flights-from-pisa-to-oviedo-psa-ovd' limit 1
        Bindings
        • 0: cheap-flights-from-pisa-to-oviedo-psa-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#125aviatickets2.64msselect * from `flights_by` where `flights_by`.`id` = '269907' 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.89msselect * from `cities` where `cities`.`id` = 5086 limit 1
        Bindings
        • 0: 5086
        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#136aviatickets9.66msselect * from `countries` where `countries`.`id` = 109 limit 1
        Bindings
        • 0: 109
        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.94msselect * 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#138aviatickets1.15msselect * 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#33aviatickets1.02msselect * from `sites_relationships` where `sites_relationships`.`id` = 269907 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 269907
        Backtrace
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:33
        • app/Http/Controllers/RoutesController.php:143
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • CountriesRepository.php#31aviatickets1.04msselect * 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.23msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 5086 and `destination_id` = 4762 and `date_update` >= '2025-05-07 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 5086
        • 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.26msselect * from `monthly_price_statistics` where `origin_city_id` = 5086 and `destination_city_id` = 4762 limit 1
        Bindings
        • 0: 5086
        • 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#470aviatickets2.24msselect * from `timetables` where `origin_city_id` = 5086 and `destination_city_id` = 4762 order by `time_origin` asc limit 1000
        Bindings
        • 0: 5086
        • 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#470aviatickets1.01msselect * from `airlines` where `airlines`.`id` in (259328)
        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.34msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5086
        Bindings
        • 0: 5086
        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#502aviatickets3.18msselect 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#90aviatickets10.12msselect * from `airlines` where `id` in (331, 2293, 4282, 4912, 5323, 5829, 17876, 59814, 642059, 2025386) order by `name` asc
        Bindings
        • 0: 331
        • 1: 2293
        • 2: 4282
        • 3: 4912
        • 4: 5323
        • 5: 5829
        • 6: 17876
        • 7: 59814
        • 8: 642059
        • 9: 2025386
        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.54msselect destination_city_id from `flights_by` where `origin_city_id` = 5086 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 5086
        • 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.99msselect * from `flights_by` where `origin_city_id` in (6929, 718, 2164, 583, 4872, 5352, 6579, 3958, 8315, 6497) and `destination_city_id` = 4762 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 6929
        • 1: 718
        • 2: 2164
        • 3: 583
        • 4: 4872
        • 5: 5352
        • 6: 6579
        • 7: 3958
        • 8: 8315
        • 9: 6497
        • 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.51msselect * from `cities` where `cities`.`id` in (718, 2164, 3958, 6497, 6579, 6929)
        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.04msselect * 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#73aviatickets1.14msselect * from `sites_relationships` where `sites_relationships`.`id` in (40911, 210963, 352608, 358995, 415552, 1083003)
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • CitySqlRepository.php#104aviatickets1.24msselect * from `cities` where `cities`.`id` = 2164 limit 1
        Bindings
        • 0: 2164
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97
      • CitySqlRepository.php#104aviatickets1.28msselect * from `cities` where `cities`.`id` = 3958 limit 1
        Bindings
        • 0: 3958
        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#52aviatickets1.25msselect * from `offers` where `origin_city_id` = 5086 and `destination_city_id` = 4762
        Bindings
        • 0: 5086
        • 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#447aviatickets3.3msselect * from `flights_by` where `origin_city_id` = 5086 and `id` > 269907 and `destination_country_id` <> 109 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 5086
        • 1: 269907
        • 2: 109
        • 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.26msselect * from `cities` where `cities`.`id` in (5086)
        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.4msselect * from `cities` where `cities`.`id` in (4805, 4857, 9317)
        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.1msselect * from `sites_relationships` where `sites_relationships`.`id` in (269909, 269910, 269911)
        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.69msselect * from `flights_by` where `origin_city_id` = 5086 and `destination_country_id` <> 109 and (`price_one_way` > 0 or `price` > 0) and `id` not in (269909) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 5086
        • 1: 109
        • 2: 0
        • 3: 0
        • 4: 269909
        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#412aviatickets940μsselect * from `cities` where `cities`.`id` in (5086)
        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.03msselect * 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#412aviatickets910μsselect * from `sites_relationships` where `sites_relationships`.`id` in (269821, 269868)
        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#412aviatickets910μsselect * 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.62msselect * 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.26msselect * 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.21msselect * 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.16msselect * 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.08msselect * 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.45msselect * from `flights_by` where `origin_city_id` = 5086 and `destination_country_id` = 109 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 5086
        • 1: 109
        • 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.08msselect * from `cities` where `cities`.`id` in (5086)
        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.26msselect * from `cities` where `cities`.`id` in (983, 1313, 3958, 4991, 5377)
        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.19msselect * from `sites_relationships` where `sites_relationships`.`id` in (269670, 269695, 269859, 269921, 269952)
        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.14msselect * from `countries` where `countries`.`id` in (109)
        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.28msselect * from `timetables` where `origin_city_id` = 5086 and `destination_city_id` = 4762 order by `time_origin` asc limit 10
        Bindings
        • 0: 5086
        • 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#39aviatickets1.2msselect * from `airports` where `airports`.`id` in (5434)
        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 (259328)
        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.43msselect * from `timetables` where `origin_city_id` = 5086 and `destination_city_id` = 4762 order by `travel_time` asc limit 1
        Bindings
        • 0: 5086
        • 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.17msselect * from `flights_by` where `origin_city_id` = 4762 and `destination_city_id` = 5086 limit 1
        Bindings
        • 0: 4762
        • 1: 5086
        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#520aviatickets13.24msselect * from `sites_relationships` where `sites_relationships`.`id` in (252797)
        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#547aviatickets1.49msselect * 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.54msselect * from `cities` where `cities`.`id` = 5086 limit 1
        Bindings
        • 0: 5086
        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#20aviatickets1.12msselect * from `cities` where `cities`.`id` = 5086 limit 1
        Bindings
        • 0: 5086
        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
      82Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      33LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      33City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      24SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Airline
      12Airline.php#?
      App\Avia\Infrastructure\Model\Country
      7Country.php#?
      App\Avia\Infrastructure\Model\Airport
      2Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
            _token
            ReswjzJrKcD4tuySFu0TOHbhIpgbYkCXUESOSJk8
            _previous
            array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-pisa-to-oviedo-psa-ovd?_url=%2Fcheap...
            _flash
            array:2 [ "old" => [] "new" => [] ]
            path_info
            /cheap-flights-from-pisa-to-oviedo-psa-ovd
            status_code
            200
            status_text
            OK
            format
            html
            content_type
            text/html; charset=UTF-8
            request_query
              0 of 0   
            array:1 [▼
  "_url" => "/cheap-flights-from-pisa-to-oviedo-psa-ovd"
]
            request_request
            []
            request_headers
              0 of 0   
            array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InliVnVQM1hIN1NPODE0Q3l3ZkRrRkE9PSIsInZhbHVlIjoidGdLb3ZhTm1LNUlqUHZyZnlPcVBqcFNhR0hTenJ6Q0RPckVZVnpKZDdsUG1lN3hnb2JNQUg1SXZrOUx2a3lxdkQwcGttOWJOdXhXdU1mSlNjVUhhNXA4aVh0bnRpU1JyRUFrVzRJdG1qWTRuVE45RWc2RS9nMW51R0lZaGlITzAiLCJtYWMiOiI0YTllZjY4OGRiMWYzN2U5MzhkYjAxMmFiY2UwNmE3MjU0MzVhNTZiYWNkNzY5ODAwMDM1M2YyMzlmMDc0NmJlIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IndyNEd3VFRHeExWblg5b1luZDlEU3c9PSIsInZhbHVlIjoiNDYwV2xNZnBnS1FyQ0x5Z09MaEtyWFg5anBQdE14OGNzREhCWXZtT3ZJRkFmY2wrSFJqWTVsa24zUTJwYVJHSzZTVFBOZnQzVUJkbnk3UVdFbjJqODVKWmJObXFkaTFFSTAvZ0RwRndobDZRZTFHdDU4cVM5YUkwNGxNdlhWcDIiLCJtYWMiOiI2ZTJhNzIzMTMxNzQ5ZjgwNWE2N2JjMDIyMjIxYWI0NGYzZGExZDJhMmQ0Y2IxODUzYjI2MmEzNDZhNTdlYjllIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InliVnVQM1hIN1NPODE0Q3l3ZkRrRkE9PSIsInZhbHVlIjoidGdLb3ZhTm1LNUlqUHZyZnlPcVBqcFNhR0hTenJ6Q0RPckVZVnpKZDdsUG1lN3hnb2JNQUg1SXZrOUx2a3lxdkQwcGttO ▶"
  ]
  "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" => "ReswjzJrKcD4tuySFu0TOHbhIpgbYkCXUESOSJk8"
  "lowcostclub_session" => "WBXwzQoFfFjygxq2qPuscLxT4GrOI9QVQcP1UXOC"
]
            response_headers
              0 of 0   
            array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Fri, 09 May 2025 20:22:15 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""5c65b90962bb9e49d4332cfce2688612""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1NK2pvdkVIL09VUXdJM2VTMHN0anc9PSIsInZhbHVlIjoiekxBaU9Wd21SRHZqNUd1cytYVTROdXVrY214T3REckZIOTBGV2NuZ1I0b1h6WWJwT2g1Zi96NVBiQkZLaDhVbVNsVzh1OVVHNlBSSG1tSnFtT2Q1Y08zVWlkVS9HejFCU1k1RXZ2Yk1WNjZ2b0ZhQXlkLzFjM0RHZ2I0RG1HVFAiLCJtYWMiOiI1NWYzOTYyODA0MzUwYmQ5YmY4YzE3OWNjYTI1ZDlhMmE4NGM0MGQ3M2JjOTJiODU1YjdjNWUxYmZmZWVmN2M0IiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 22:22:15 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im1NK2pvdkVIL09VUXdJM2VTMHN0anc9PSIsInZhbHVlIjoiekxBaU9Wd21SRHZqNUd1cytYVTROdXVrY214T3REckZIOTBGV2NuZ1I0b1h6WWJwT2g1Zi96NVBiQkZLaDhVbVNsVzh1O ▶"
    1 => "lowcostclub_session=eyJpdiI6IjkxQytmZ0pSQitpNGZOTnQyUUFaSUE9PSIsInZhbHVlIjoibDJ2T0h0WWJSVVM3UEI4VzZ6WXo3MU1CeXV4ZjY5L1R6OEMxU0dmQmxiWTJCcXU3ekVHU1VPaTBGdHZIVXIzQnJ3OXhJSVF1MmVtOHR6TVg4b3Z3WVBCNGRqQ1kwd2xMWnRUYnh6N2hqSXRvZjJTQ1RDMEdpZ2dmVlk2RGRGV0wiLCJtYWMiOiI2MjBhOWIyZjg2OTE4ZTE2ZTE5NGQ1YzRjYjlmYmY1ZmNjNmJkNTMwODc0NGFkYzhiYjJjNGY1ODA0MmNjZmRiIiwidGFnIjoiIn0%3D; expires=Fri, 09 May 2025 22:22:15 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjkxQytmZ0pSQitpNGZOTnQyUUFaSUE9PSIsInZhbHVlIjoibDJ2T0h0WWJSVVM3UEI4VzZ6WXo3MU1CeXV4ZjY5L1R6OEMxU0dmQmxiWTJCcXU3ekVHU1VPaTBGdHZIVXIz ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1NK2pvdkVIL09VUXdJM2VTMHN0anc9PSIsInZhbHVlIjoiekxBaU9Wd21SRHZqNUd1cytYVTROdXVrY214T3REckZIOTBGV2NuZ1I0b1h6WWJwT2g1Zi96NVBiQkZLaDhVbVNsVzh1OVVHNlBSSG1tSnFtT2Q1Y08zVWlkVS9HejFCU1k1RXZ2Yk1WNjZ2b0ZhQXlkLzFjM0RHZ2I0RG1HVFAiLCJtYWMiOiI1NWYzOTYyODA0MzUwYmQ5YmY4YzE3OWNjYTI1ZDlhMmE4NGM0MGQ3M2JjOTJiODU1YjdjNWUxYmZmZWVmN2M0IiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 22:22:15 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1NK2pvdkVIL09VUXdJM2VTMHN0anc9PSIsInZhbHVlIjoiekxBaU9Wd21SRHZqNUd1cytYVTROdXVrY214T3REckZIOTBGV2NuZ1I0b1h6WWJwT2g1Zi96NVBiQkZLaDhVbVNsVzh1O ▶"
    1 => "lowcostclub_session=eyJpdiI6IjkxQytmZ0pSQitpNGZOTnQyUUFaSUE9PSIsInZhbHVlIjoibDJ2T0h0WWJSVVM3UEI4VzZ6WXo3MU1CeXV4ZjY5L1R6OEMxU0dmQmxiWTJCcXU3ekVHU1VPaTBGdHZIVXIzQnJ3OXhJSVF1MmVtOHR6TVg4b3Z3WVBCNGRqQ1kwd2xMWnRUYnh6N2hqSXRvZjJTQ1RDMEdpZ2dmVlk2RGRGV0wiLCJtYWMiOiI2MjBhOWIyZjg2OTE4ZTE2ZTE5NGQ1YzRjYjlmYmY1ZmNjNmJkNTMwODc0NGFkYzhiYjJjNGY1ODA0MmNjZmRiIiwidGFnIjoiIn0%3D; expires=Fri, 09-May-2025 22:22:15 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjkxQytmZ0pSQitpNGZOTnQyUUFaSUE9PSIsInZhbHVlIjoibDJ2T0h0WWJSVVM3UEI4VzZ6WXo3MU1CeXV4ZjY5L1R6OEMxU0dmQmxiWTJCcXU3ekVHU1VPaTBGdHZIVXIz ▶"
  ]
]
            session_attributes
              0 of 0   
            array:3 [▼
  "_token" => "ReswjzJrKcD4tuySFu0TOHbhIpgbYkCXUESOSJk8"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-pisa-to-oviedo-psa-ovd?_url=%2Fcheap-flights-from-pisa-to-oviedo-psa-ovd"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
            ClearShow all
            Date ↕MethodURLData
            #12025-05-09 20:22:15GET/cheap-flights-from-pisa-to-oviedo-psa-ovd5152194