Most often, departures to Lisbon are from Berlin, this is the cheapest flight from $26. The nearest airports from Dresden with a flight to Lisbon are located in Nuremberg.

Popular International routes from Dresden

Dresden — Moscow

from $180 one-way

Dresden — Antalya

from $64 one-way

Dresden — Little Rock

from $1,621 one-way

Dresden — Ljubljana

from $162 one-way

Dresden — London

from $79 one-way

Popular routes from Lisbon

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

Lisbon — Moscow

from $213 one-way

Lisbon — Saint Petersburg

from $332 one-way

Lisbon — Funchal

from $13 one-way

Lisbon — Istanbul

from $60 one-way

Lisbon — Tokyo

from $503 one-way

Popular domestic routes from Dresden

from $109 one-way

from $99 one-way

from $109 one-way

from $85 one-way

from $162 one-way

Return flights Lisbon – Dresden

Schedule of direct flights Dresden — Lisbon

Messages Timeline Exceptions Views54 Route Queries86 Models499 Mails Gate N+1 Queries4 Session Request

Request history8.3.01.26s5MBGET cheap-flights-from-{slug}

Booting (39.32ms)time
Application (1.22s)time
1 x Application (96.88%)
1.22s
1 x Booting (3.12%)
39.32ms

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
4x components.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
24x 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

86 statements were executed (41 duplicates)Show only duplicates420ms

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#34aviatickets15.18msselect * from `sites_relationships` where `us` = 'cheap-flights-from-dresden-to-lisbon-drs-lis' limit 1

Bindings	0: cheap-flights-from-dresden-to-lisbon-drs-lis
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#125aviatickets17.3msselect * from `flights_by` where `flights_by`.`id` = '90922' 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#135aviatickets16.69msselect * from `cities` where `cities`.`id` = 1586 limit 1

Bindings	0: 1586
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#136aviatickets14.14msselect * from `countries` where `countries`.`id` = 125 limit 1

Bindings	0: 125
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.71msselect * from `cities` where `cities`.`id` = 3576 limit 1

Bindings	0: 3576
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#138aviatickets3.92msselect * from `countries` where `countries`.`id` = 215 limit 1

Bindings	0: 215
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#33aviatickets6.53ms

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

Bindings	0: 90922
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#31aviatickets17.77msselect * 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.34ms

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

Bindings	0: 1586 1: 3576 2: 2025-05-11 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.21msselect * from `monthly_price_statistics` where `origin_city_id` = 1586 and `destination_city_id` = 3576 limit 1

Bindings	0: 1586 1: 3576
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.75ms

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

Bindings	0: 1586 1: 3576
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.17msselect * from `airlines` where `airlines`.`id` in (2754)

Backtrace

app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461
app/Http/Controllers/RoutesController.php:162

AirlineSqlRepository.php#502aviatickets1.64msselect distinct `airline_id` from `timetables` where `origin_city_id` = 1586

Bindings	0: 1586
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#502aviatickets2.28msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3576

Bindings	0: 3576
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#90aviatickets4.26ms

select * from `airlines` where `id` in (1314, 1352, 2256, 2293, 2830, 3084, 3314, 3915, 4282, 4543, 5075, 11847, 11914, 17876, 17925, 60775, 65824, 157745, 259328, 5438487, 146726240) order by `name` asc

Bindings	0: 1314 1: 1352 2: 2256 3: 2293 4: 2830 5: 3084 6: 3314 7: 3915 8: 4282 9: 4543 10: 5075 11: 11847 12: 11914 13: 17876 14: 17925 15: 60775 16: 65824 17: 157745 18: 259328 19: 5438487 20: 146726240
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.79ms

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

Bindings	0: 1586 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#73aviatickets3.16ms

select * from `flights_by` where `origin_city_id` in (3511, 8488, 5067, 519, 6752, 5035, 5944, 4514, 822, 3091) and `destination_city_id` = 3576 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3511 1: 8488 2: 5067 3: 519 4: 6752 5: 5035 6: 5944 7: 4514 8: 822 9: 3091 10: 3576 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#73aviatickets2.95msselect * from `cities` where `cities`.`id` in (519, 822, 3091, 3511, 4514, 5035, 5067, 5944, 6752)

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#73aviatickets8.62msselect * from `cities` where `cities`.`id` in (3576)

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#73aviatickets12.84ms

select * from `sites_relationships` where `sites_relationships`.`id` in (30505, 49409, 126796, 186213, 238228, 267660, 268842, 322885, 364274)

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

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

Bindings	0: 215
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#558aviatickets3.81ms

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

Bindings	0: 1586 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.93ms

select * from `flights_by` where `origin_city_id` in (3511, 8488, 5067, 519, 6752, 5035, 5944, 4514, 822, 3091) and `destination_city_id` = 3576 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3511 1: 8488 2: 5067 3: 519 4: 6752 5: 5035 6: 5944 7: 4514 8: 822 9: 3091 10: 3576 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#73aviatickets2.08msselect * from `cities` where `cities`.`id` in (519, 822, 3091, 3511, 4514, 5035, 5067, 5944, 6752)

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#73aviatickets5.85msselect * from `cities` where `cities`.`id` in (3576)

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#73aviatickets2.16ms

select * from `sites_relationships` where `sites_relationships`.`id` in (30505, 49409, 126796, 186213, 238228, 267660, 268842, 322885, 364274)

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#104aviatickets2.29msselect * from `cities` where `cities`.`id` = 4514 limit 1

Bindings	0: 4514
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#558aviatickets9.21ms

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

Bindings	0: 1586 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#73aviatickets5.08ms

select * from `flights_by` where `origin_city_id` in (3511, 8488, 5067, 519, 6752, 5035, 5944, 4514, 822, 3091) and `destination_city_id` = 3576 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3511 1: 8488 2: 5067 3: 519 4: 6752 5: 5035 6: 5944 7: 4514 8: 822 9: 3091 10: 3576 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#73aviatickets4.57msselect * from `cities` where `cities`.`id` in (519, 822, 3091, 3511, 4514, 5035, 5067, 5944, 6752)

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#73aviatickets10.4msselect * from `cities` where `cities`.`id` in (3576)

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#73aviatickets4.91ms

select * from `sites_relationships` where `sites_relationships`.`id` in (30505, 49409, 126796, 186213, 238228, 267660, 268842, 322885, 364274)

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#104aviatickets2.51msselect * from `cities` where `cities`.`id` = 519 limit 1

Bindings	0: 519
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#558aviatickets4.93ms

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

Bindings	0: 1586 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.75ms

select * from `flights_by` where `origin_city_id` in (3511, 8488, 5067, 519, 6752, 5035, 5944, 4514, 822, 3091) and `destination_city_id` = 3576 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3511 1: 8488 2: 5067 3: 519 4: 6752 5: 5035 6: 5944 7: 4514 8: 822 9: 3091 10: 3576 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#73aviatickets3.14msselect * from `cities` where `cities`.`id` in (519, 822, 3091, 3511, 4514, 5035, 5067, 5944, 6752)

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#73aviatickets4.32msselect * from `cities` where `cities`.`id` in (3576)

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#73aviatickets1.51ms

select * from `sites_relationships` where `sites_relationships`.`id` in (30505, 49409, 126796, 186213, 238228, 267660, 268842, 322885, 364274)

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#104aviatickets5.75msselect * from `cities` where `cities`.`id` = 519 limit 1

Bindings	0: 519
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#558aviatickets1.53ms

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

Bindings	0: 1586 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.55ms

select * from `flights_by` where `origin_city_id` in (3511, 8488, 5067, 519, 6752, 5035, 5944, 4514, 822, 3091) and `destination_city_id` = 3576 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3511 1: 8488 2: 5067 3: 519 4: 6752 5: 5035 6: 5944 7: 4514 8: 822 9: 3091 10: 3576 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#73aviatickets4.23msselect * from `cities` where `cities`.`id` in (519, 822, 3091, 3511, 4514, 5035, 5067, 5944, 6752)

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

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#73aviatickets2.9ms

select * from `sites_relationships` where `sites_relationships`.`id` in (30505, 49409, 126796, 186213, 238228, 267660, 268842, 322885, 364274)

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#104aviatickets3.14msselect * from `cities` where `cities`.`id` = 519 limit 1

Bindings	0: 519
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#52aviatickets3.39msselect * from `offers` where `origin_city_id` = 1586 and `destination_city_id` = 3576

Bindings	0: 1586 1: 3576
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#447aviatickets2.92ms

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

Bindings	0: 1586 1: 90922 2: 125 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#447aviatickets2.03msselect * from `cities` where `cities`.`id` in (1586)

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#447aviatickets4.47msselect * from `cities` where `cities`.`id` in (3585, 3654, 9265)

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#447aviatickets4.09msselect * from `sites_relationships` where `sites_relationships`.`id` in (90923, 90924, 90926)

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#125aviatickets3.29msselect * from `countries` where `countries`.`id` = 66 limit 1

Bindings	0: 66
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#412aviatickets2.01ms

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

Bindings	0: 1586 1: 125 2: 0 3: 0 4: 90923
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.5msselect * from `cities` where `cities`.`id` in (1586)

Backtrace

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

LocalRouteRepository.php#412aviatickets4.45msselect * from `cities` where `cities`.`id` in (407, 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#412aviatickets12.26msselect * from `sites_relationships` where `sites_relationships`.`id` in (90752, 90949)

Backtrace

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

LocalRouteRepository.php#412aviatickets2.3msselect * from `countries` where `countries`.`id` in (134, 248)

Backtrace

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

LocalRouteRepository.php#149aviatickets6.53ms

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

Bindings	0: 3576 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#149aviatickets8.03msselect * from `cities` where `cities`.`id` in (3576)

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.59msselect * from `cities` where `cities`.`id` in (1923, 2686, 3505, 4081, 6319)

Backtrace

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

LocalRouteRepository.php#149aviatickets9.09msselect * from `countries` where `countries`.`id` in (134, 211, 215, 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#149aviatickets13.18msselect * from `sites_relationships` where `sites_relationships`.`id` in (189419, 189505, 189577, 189652, 189940)

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

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

Bindings	0: 1586 1: 125 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.59msselect * from `cities` where `cities`.`id` in (1586)

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.86msselect * from `cities` where `cities`.`id` in (519, 1102, 1949, 4191, 9260)

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#359aviatickets4.2msselect * from `sites_relationships` where `sites_relationships`.`id` in (90759, 90793, 90821, 90842, 90957)

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

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#39aviatickets3.27ms

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

Bindings	0: 1586 1: 3576
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.99msselect * from `airports` where `airports`.`id` in (68)

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.99msselect * from `airports` where `airports`.`id` in (1860)

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.13msselect * from `airlines` where `airlines`.`id` in (2754)

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#144aviatickets2.28ms

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

Bindings	0: 1586 1: 3576
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#520aviatickets16.61msselect * from `flights_by` where `origin_city_id` = 3576 and `destination_city_id` = 1586 limit 1

Bindings	0: 3576 1: 1586
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#520aviatickets4.72msselect * from `sites_relationships` where `sites_relationships`.`id` in (189377)

Backtrace

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

LocalRoute.php#99aviatickets2.92msselect * from `cities` where `cities`.`id` = 1586 limit 1

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

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

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

description-nearbyCities.blade.php#20aviatickets12.42msselect * from `cities` where `cities`.`id` = 1586 limit 1

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

LocalRouteRepository.php#175aviatickets1.61msselect * 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#175aviatickets3.26msselect * 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#175aviatickets4.37msselect * 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#175aviatickets3.29msselect * 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#175aviatickets6.42msselect * 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#149aviatickets4.2ms

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#149aviatickets2.46msselect * 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#149aviatickets4.68msselect * 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#149aviatickets4.32msselect * 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#149aviatickets3.48ms

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: 149Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 127LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 99City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 78SitesRelationship.php#?
App\Avia\Infrastructure\Model\Airline: 23Airline.php#?
App\Avia\Infrastructure\Model\Country: 20Country.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...
infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...

_token: CD2U55DaEU4Yv73FfM6SMH9V6VWPVmnvZRd9psMc
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-dresden-to-lisbon-drs-lis?_url=%2Fch...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-dresden-to-lisbon-drs-lis

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-dresden-to-lisbon-drs-lis"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1oZ1hqVkpKS3NHdStDdTJjbU5MWEE9PSIsInZhbHVlIjoiQU8zeHFUb3BKV2p2SEg4TDZJQmxlSVZxUzVHQ3RFMHdkcktMUjNzUk9zaWs3VVkxTnFpaFZXSTFZWDRqSzl5WGRwdVBkMER3Vmk4QXR5bW9admtqYzA2TDlGWngvL0VyTjZJM3BxYmN6bWttakp5Nm9iZitwVlJDWnlWbXJQTEEiLCJtYWMiOiI3M2Y2ZWE2MWI2NDBlZTJjOGRlMDExMDIxMmIxZjUzNDYxYWVjMGJhNzkwMjFiNzNlYmYwNjgyZGQ4M2Q5YTE0IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6ImlLRys0bmxuVUFPNUVMZVorUUFPRHc9PSIsInZhbHVlIjoicURmNVpvTEZGaTVXb2FxdmU5NmFKVi9ZdlUxUDdONmtsVzJ1MFI1WHhwU1VQSURjSVlkNDB0NEJ6ck5NcDZqbXBVZm9aZk1oaE9OREdtc3NwN3hQVlo3eThOb25GbWlnQ28zb0I5Vis3Snk2Wk5kaTdCZUQ3dmR3dEx5bFh1THQiLCJtYWMiOiIzOTE3YTI1MzBjYTM3ZTg1NDNiNWMwNDE0Yjg0NjhiZDQ4OGM2OGI1MGU1ZjY2MTEzY2JjNzc2NTVmZjlhYjkxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Ik1oZ1hqVkpKS3NHdStDdTJjbU5MWEE9PSIsInZhbHVlIjoiQU8zeHFUb3BKV2p2SEg4TDZJQmxlSVZxUzVHQ3RFMHdkcktMUjNzUk9zaWs3VVkxTnFpaFZXSTFZWDRqSzl5WGRwdVBkM ▶"
  ]
  "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" => "CD2U55DaEU4Yv73FfM6SMH9V6VWPVmnvZRd9psMc"
  "lowcostclub_session" => "bFSMDRLGawhp0QG9b2e45hHCyrjjBTVqlU41R2sF"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 13 May 2025 04:35:19 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""29e2c10ef7e100ac4625b449f2f860ea""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlY3dTlTTlpJK3U4c2NXa0tlVnhuUnc9PSIsInZhbHVlIjoiTWdzOEFvV2sySWtvN2VvQkdOU2pxOXRzVmdhNGxzeldpT1Q1eDBUc2d4eXpSVmluSGh2SGhvQ1EvQlZ3MkExKzdFelcySGtnNk5VWGJEMThYck1kOW1RS3NyRVJveWY2Q3h5V1FtV1NxYVZ5YVNVZkdLSUVZTjJUemhwMEd1QTIiLCJtYWMiOiJhN2M0NzBlY2MzNmUwZTE1ODdmZTZlYmIxOWQwMDZkY2I0MWU0YzNmNGQyN2ZhMWNkMDVlYzI0M2M2NGJhNDFkIiwidGFnIjoiIn0%3D; expires=Tue, 13 May 2025 06:35:19 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlY3dTlTTlpJK3U4c2NXa0tlVnhuUnc9PSIsInZhbHVlIjoiTWdzOEFvV2sySWtvN2VvQkdOU2pxOXRzVmdhNGxzeldpT1Q1eDBUc2d4eXpSVmluSGh2SGhvQ1EvQlZ3MkExKzdFelcyS ▶"
    1 => "lowcostclub_session=eyJpdiI6IlJRVDk0WDFFc3ZBNGhjaStqSEhmbXc9PSIsInZhbHVlIjoiRU96MTMweFNNaEN3bGNyMFlhb0RQSXVnWjA0blZSbWhzY1pnMGlEYmMxOXVSU29DSWVxdFpEd0pYNWpHTVFSOHJNNXhyNno4UjBBallQOGdRMUdCTHJrZm9DQXFvc1RRMlowQWM0YVd2TE9KZ2RpZEQvNFN5SzI2dUhPcW0wRzEiLCJtYWMiOiI3Mzk0Y2E2MWI5NmE0NjU3YTE0Y2NmZDQ2MjgwNmFmNzRmNDNlNDUyYjFkNTQwNDUwYTBlZTI1Y2U5ZDEzYTExIiwidGFnIjoiIn0%3D; expires=Tue, 13 May 2025 06:35:19 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlJRVDk0WDFFc3ZBNGhjaStqSEhmbXc9PSIsInZhbHVlIjoiRU96MTMweFNNaEN3bGNyMFlhb0RQSXVnWjA0blZSbWhzY1pnMGlEYmMxOXVSU29DSWVxdFpEd0pYNWpHTVFS ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlY3dTlTTlpJK3U4c2NXa0tlVnhuUnc9PSIsInZhbHVlIjoiTWdzOEFvV2sySWtvN2VvQkdOU2pxOXRzVmdhNGxzeldpT1Q1eDBUc2d4eXpSVmluSGh2SGhvQ1EvQlZ3MkExKzdFelcySGtnNk5VWGJEMThYck1kOW1RS3NyRVJveWY2Q3h5V1FtV1NxYVZ5YVNVZkdLSUVZTjJUemhwMEd1QTIiLCJtYWMiOiJhN2M0NzBlY2MzNmUwZTE1ODdmZTZlYmIxOWQwMDZkY2I0MWU0YzNmNGQyN2ZhMWNkMDVlYzI0M2M2NGJhNDFkIiwidGFnIjoiIn0%3D; expires=Tue, 13-May-2025 06:35:19 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlY3dTlTTlpJK3U4c2NXa0tlVnhuUnc9PSIsInZhbHVlIjoiTWdzOEFvV2sySWtvN2VvQkdOU2pxOXRzVmdhNGxzeldpT1Q1eDBUc2d4eXpSVmluSGh2SGhvQ1EvQlZ3MkExKzdFelcyS ▶"
    1 => "lowcostclub_session=eyJpdiI6IlJRVDk0WDFFc3ZBNGhjaStqSEhmbXc9PSIsInZhbHVlIjoiRU96MTMweFNNaEN3bGNyMFlhb0RQSXVnWjA0blZSbWhzY1pnMGlEYmMxOXVSU29DSWVxdFpEd0pYNWpHTVFSOHJNNXhyNno4UjBBallQOGdRMUdCTHJrZm9DQXFvc1RRMlowQWM0YVd2TE9KZ2RpZEQvNFN5SzI2dUhPcW0wRzEiLCJtYWMiOiI3Mzk0Y2E2MWI5NmE0NjU3YTE0Y2NmZDQ2MjgwNmFmNzRmNDNlNDUyYjFkNTQwNDUwYTBlZTI1Y2U5ZDEzYTExIiwidGFnIjoiIn0%3D; expires=Tue, 13-May-2025 06:35:19 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlJRVDk0WDFFc3ZBNGhjaStqSEhmbXc9PSIsInZhbHVlIjoiRU96MTMweFNNaEN3bGNyMFlhb0RQSXVnWjA0blZSbWhzY1pnMGlEYmMxOXVSU29DSWVxdFpEd0pYNWpHTVFS ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "CD2U55DaEU4Yv73FfM6SMH9V6VWPVmnvZRd9psMc"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-dresden-to-lisbon-drs-lis?_url=%2Fcheap-flights-from-dresden-to-lisbon-drs-lis"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-13 04:35:19	GET	/cheap-flights-from-dresden-to-lisbon-drs-lis	54 86 499 4

1 x Application (96.88%)	1.22s
1 x Booting (3.12%)	39.32ms

Cheap flights Dresden — Lisbon (DRS — LIS)

Choose your dates to find the flight:

Good to know - Cheap tickets Dresden — Lisbon

Popular airlines flying Dresden — Lisbon

Airlines with direct flights

Other airlines flying with transfers

Routes from nearby cities to Lisbon

Popular International routes from Dresden

Popular routes from Lisbon

Popular domestic routes from Dresden

Related pages

Select your currency

All currencies

Select your language

All languages