Cheap flights Cologne — Valencia (CGN — VLN)

Choose your dates to find the flight:

Good to know - Cheap tickets Cologne — Valencia

Cheapest flight found	$2,220
Flight distance	8077 km

Routes from nearby cities to Valencia

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

Frankfurt — Valencia

from $835 one-way

Dusseldorf — Valencia

from $1,165 one-way

Most often, departures to Valencia are from Frankfurt, this is the cheapest flight from $835. The nearest airports from Cologne with a flight to Valencia are located in Dusseldorf.

Popular International routes from Cologne

Cologne — Moscow

from $139 one-way

Cologne — Saint Petersburg

from $82 one-way

Cologne — Wellington

from $2,001 round-trip

Cologne — Edmonton

from $541 one-way

Cologne — Maun

from $1,486 round-trip

Popular routes from Valencia

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

Valencia — Miami

from $439 one-way

Valencia — Madrid

from $777 one-way

Valencia — Panama City

from $219 one-way

Valencia — Buenos Aires

from $447 one-way

Valencia — Joao Pessoa

from $1,933 round-trip

Popular domestic routes from Cologne

from $45 one-way

from $35 one-way

from $24 one-way

from $47 one-way

from $55 one-way

Return flights Valencia – Cologne

Messages Timeline Exceptions Views43 Route Queries59 Models262 Mails Gate N+1 Queries1 Session Request

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

Booting (27.17ms)time
Application (289ms)time
1 x Application (91.4%)
289ms
1 x Booting (8.59%)
27.17ms

43 templates were rendered

1x views_us.routes.viewview.blade.php#?blade
1x routes.viewview.blade.php#?blade
1x index.section-slideshowsection-slideshow.blade.php#?blade
1x components.avia-formavia-form.blade.php#?blade
1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
1x routes.section-advantagessection-advantages.blade.php#?blade
1x routes.AirlinesListAirlinesList.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
17x 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

59 statements were executed (10 duplicates)Show only duplicates82.39ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

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

SitesRelationshipsSqlRepository.php#34aviatickets3.64msselect * from `sites_relationships` where `us` = 'cheap-flights-from-cologne-to-valencia-cgn-vln' limit 1

Bindings	0: cheap-flights-from-cologne-to-valencia-cgn-vln
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#125aviatickets970μsselect * from `flights_by` where `flights_by`.`id` = '399938' 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.28msselect * from `cities` where `cities`.`id` = 1102 limit 1

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

RoutesController.php#136aviatickets1.38msselect * 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.61msselect * from `cities` where `cities`.`id` = 9161 limit 1

Bindings	0: 9161
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#138aviatickets2.81msselect * from `countries` where `countries`.`id` = 87 limit 1

Bindings	0: 87
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.08ms

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

Bindings	0: 399938
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#31aviatickets2.72msselect * 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.28ms

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

Bindings	0: 1102 1: 9161 2: 2025-05-05 00:00:00
Backtrace	app/Avia/Infrastructure/Repository/RouteRepository.php:42 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/RouteRepository.php:33 app/Http/Controllers/RoutesController.php:150

MonthlyPriceStatisticSqlRepository.php#66aviatickets1.67msselect * from `monthly_price_statistics` where `origin_city_id` = 1102 and `destination_city_id` = 9161 limit 1

Bindings	0: 1102 1: 9161
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.15ms

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

Bindings	0: 1102 1: 9161
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#502aviatickets3.07msselect distinct `airline_id` from `timetables` where `origin_city_id` = 1102

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

AirlineSqlRepository.php#502aviatickets1.2msselect distinct `airline_id` from `timetables` where `origin_city_id` = 9161

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

LocalRouteRepository.php#558aviatickets1.43ms

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

Bindings	0: 1102 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.62ms

select * from `flights_by` where `origin_city_id` in (9260, 1604, 4162, 3074, 1918, 4795, 1949, 3742, 9224, 825) and `destination_city_id` = 9161 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 9260 1: 1604 2: 4162 3: 3074 4: 1918 5: 4795 6: 1949 7: 3742 8: 9224 9: 825 10: 9161 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.14msselect * from `cities` where `cities`.`id` in (1949, 9260)

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

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

NearbyCitiesAggregateDbProvider.php#73aviatickets1msselect * from `sites_relationships` where `sites_relationships`.`id` in (95013, 111648)

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.08msselect * from `cities` where `cities`.`id` = 9260 limit 1

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

Bindings	0: 1949
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.19msselect * from `offers` where `origin_city_id` = 1102 and `destination_city_id` = 9161

Bindings	0: 1102 1: 9161
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.18ms

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

Bindings	0: 1102 1: 399938 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#447aviatickets1.22msselect * from `cities` where `cities`.`id` in (1102)

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.35msselect * from `cities` where `cities`.`id` in (3073, 4190, 6701)

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.12msselect * from `sites_relationships` where `sites_relationships`.`id` in (399940, 399944, 526288)

Backtrace

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

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

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

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

Bindings	0: 196
Backtrace	app/Avia/Infrastructure/Model/LocalRoute.php:125 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Model/LocalRoute.php:122 app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49

LocalRouteRepository.php#412aviatickets1.75ms

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

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

Backtrace

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

LocalRouteRepository.php#412aviatickets1.15msselect * from `cities` where `cities`.`id` in (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#412aviatickets790μsselect * from `sites_relationships` where `sites_relationships`.`id` in (64864, 64919)

Backtrace

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

LocalRouteRepository.php#412aviatickets990μsselect * from `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.26ms

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

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

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.32msselect * from `cities` where `cities`.`id` in (877, 3787, 3951, 5127, 8475)

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.28msselect * from `countries` where `countries`.`id` in (23, 61, 81, 92, 217)

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#149aviatickets900μsselect * from `sites_relationships` where `sites_relationships`.`id` in (355675, 355719, 355727, 355751, 1193115)

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

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

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

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.36msselect * from `cities` where `cities`.`id` in (519, 1949, 2304, 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#359aviatickets1.12msselect * from `sites_relationships` where `sites_relationships`.`id` in (64594, 64698, 64739, 64772, 64931)

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.3msselect * 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#39aviatickets1.27ms

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

Bindings	0: 1102 1: 9161
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.21ms

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

Bindings	0: 1102 1: 9161
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.08msselect * from `flights_by` where `origin_city_id` = 9161 and `destination_city_id` = 1102 limit 1

Bindings	0: 9161 1: 1102
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#520aviatickets840μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1115950)

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#99aviatickets1.22msselect * from `cities` where `cities`.`id` = 1102 limit 1

Bindings	0: 1102
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.15msselect * from `cities` where `cities`.`id` = 9161 limit 1

Bindings	0: 9161
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#20aviatickets1.21msselect * from `cities` where `cities`.`id` = 1102 limit 1

Bindings	0: 1102
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.3msselect * from `flights_by` where `id` in (240458, 46235, 180255, 46251, 201516, 32301)

Bindings	0: 240458 1: 46235 2: 180255 3: 46251 4: 201516 5: 32301
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179 app/Avia/Application/SeoRoutesHandler.php:40

LocalRouteRepository.php#175aviatickets1.72msselect * from `cities` where `cities`.`id` in (537, 779, 3448, 3796, 4539)

Backtrace

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

LocalRouteRepository.php#175aviatickets1.25msselect * from `cities` where `cities`.`id` in (2122, 3301, 5136, 7738, 8381, 8447)

Backtrace

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

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

Backtrace

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

LocalRouteRepository.php#149aviatickets1.7ms

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#149aviatickets990μsselect * from `cities` where `cities`.`id` in (4539)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.22msselect * 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#149aviatickets970μsselect * from `countries` where `countries`.`id` in (92, 134, 242, 248)

Backtrace

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

LocalRouteRepository.php#149aviatickets900μs

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

Backtrace

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

App\Avia\Infrastructure\Model\Timetable: 112Timetable.php#?
App\Avia\Infrastructure\Model\City: 50City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 44LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 35SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 20Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...

_token: Vgi91TQxcmJjqCNvRqKDmFFZ9IZ8ku0bpfP12eQg
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-cologne-to-valencia-cgn-vln?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-cologne-to-valencia-cgn-vln

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-cologne-to-valencia-cgn-vln"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImhCV3N5bFVkSnpKc2JuK1dnWS9mMFE9PSIsInZhbHVlIjoiZDdsc3ZRanU4ZE5aaTR3MnVid1BESkFKeCtJVHlaU1pFV1FQYzdkWUc4Sm91TWRGVUdXdjNTYy9CMG1WU3BYSFFESkRGY0ZZQTZRTW5qOGxIdHNVSFlDbEFBMWpiS0RsMldCOXpuOHAvYmFGSmt1QjhTS2hBcVMvVTZIc2lESXciLCJtYWMiOiJlNDIzMzAwZjhiM2NjZjA0NzMwYTdiZjk5YWI5YmRjMGY5NTJhNjY1MmE1YzVjOWMzMjYwN2ZjMTg5MzNkMzQzIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6ImNVMVAxNjhFQWZRQjA4ZDlDenJXMVE9PSIsInZhbHVlIjoiNW1yVGFMZlRvNWk2aUs5d2xLVktjN0doSzRrMUtHTE5BdjlyaHdJUTJrYlI5NUlhcDM1NmZ4VnQxZGVBQXdEZ1VCRFY5WDAzUkJ5TXZlNW1iK0dJeCs2MHgvTnFRRWRPNmVyUXpXK3UrY1dhZXBMQ2xHMmVUQmR5c1NRRlNDcGgiLCJtYWMiOiJmNDdiMTA1Y2JiOTAwNWJkZDZmNjY5NzJjOTk5NzFlYWY5ODEzYTFiMDhhYzdiOTU5ZGMyNTVhMmQ3NjI4NWZhIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImhCV3N5bFVkSnpKc2JuK1dnWS9mMFE9PSIsInZhbHVlIjoiZDdsc3ZRanU4ZE5aaTR3MnVid1BESkFKeCtJVHlaU1pFV1FQYzdkWUc4Sm91TWRGVUdXdjNTYy9CMG1WU3BYSFFESkRGY ▶"
  ]
  "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" => "Vgi91TQxcmJjqCNvRqKDmFFZ9IZ8ku0bpfP12eQg"
  "lowcostclub_session" => "UaITnysa5qVD5z9eJthkbKUbVtgwtRCtUfujYCxO"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 15:38:04 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""c025fc5ebc42c922bfedf1d75869d26a""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii9QaFQrTVNOeU1pajJrNktCcHhBa1E9PSIsInZhbHVlIjoiSVIyL0gzekhjQVdFSDlPeU51Q21uTXVxUjFGWXdjNnNmeTI0R0txajZKcW1BRUNuOUJNTUhScVgwMEo1aFYzWlZ0MnNld29VSytSQTd0OUlNWDR0VWVoV0RSazMwY3dQWTJQbGJzUFZSZCsyeXozWERtcS9HZTV0QXhDdFRLd0EiLCJtYWMiOiI2Y2E1OTY3N2FkNGJmNzE3MTAwZmQxZGM3YjZjNjRlN2NiZWQ3ODk5NDBlYWU5Mjc2ODVkZTNkMmZlMzU0OTY1IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 17:38:04 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ii9QaFQrTVNOeU1pajJrNktCcHhBa1E9PSIsInZhbHVlIjoiSVIyL0gzekhjQVdFSDlPeU51Q21uTXVxUjFGWXdjNnNmeTI0R0txajZKcW1BRUNuOUJNTUhScVgwMEo1aFYzWlZ0MnNld ▶"
    1 => "lowcostclub_session=eyJpdiI6IlZnTWljMWVGTlg3UGpOSDBWVW5JMFE9PSIsInZhbHVlIjoiUE85SlZzRzVpbUhnUWhpay9Jd0ZMYUtYc2gvN1g3bjZWanl0L0lBTmQwTVMrQXNSUVVXcnJZZXJoTXM1dmorUlJ5aGNSVmU5TSsxNS9lQXZxMjFHMlBkUG95TVE4aWgzL2tVVGhUeW5DYmI2R3F5TVowdzA2R0RaQjh6aHJzeWkiLCJtYWMiOiJkMTNmOTBhMDNiM2VlZTI0NTMzOGZmOWY2NTM5MDIxMTU1M2FiNmU2NzM2ZGY0NmJlZmFkYmVlMjljOWUyMTkwIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 17:38:04 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlZnTWljMWVGTlg3UGpOSDBWVW5JMFE9PSIsInZhbHVlIjoiUE85SlZzRzVpbUhnUWhpay9Jd0ZMYUtYc2gvN1g3bjZWanl0L0lBTmQwTVMrQXNSUVVXcnJZZXJoTXM1dmor ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ii9QaFQrTVNOeU1pajJrNktCcHhBa1E9PSIsInZhbHVlIjoiSVIyL0gzekhjQVdFSDlPeU51Q21uTXVxUjFGWXdjNnNmeTI0R0txajZKcW1BRUNuOUJNTUhScVgwMEo1aFYzWlZ0MnNld29VSytSQTd0OUlNWDR0VWVoV0RSazMwY3dQWTJQbGJzUFZSZCsyeXozWERtcS9HZTV0QXhDdFRLd0EiLCJtYWMiOiI2Y2E1OTY3N2FkNGJmNzE3MTAwZmQxZGM3YjZjNjRlN2NiZWQ3ODk5NDBlYWU5Mjc2ODVkZTNkMmZlMzU0OTY1IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 17:38:04 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ii9QaFQrTVNOeU1pajJrNktCcHhBa1E9PSIsInZhbHVlIjoiSVIyL0gzekhjQVdFSDlPeU51Q21uTXVxUjFGWXdjNnNmeTI0R0txajZKcW1BRUNuOUJNTUhScVgwMEo1aFYzWlZ0MnNld ▶"
    1 => "lowcostclub_session=eyJpdiI6IlZnTWljMWVGTlg3UGpOSDBWVW5JMFE9PSIsInZhbHVlIjoiUE85SlZzRzVpbUhnUWhpay9Jd0ZMYUtYc2gvN1g3bjZWanl0L0lBTmQwTVMrQXNSUVVXcnJZZXJoTXM1dmorUlJ5aGNSVmU5TSsxNS9lQXZxMjFHMlBkUG95TVE4aWgzL2tVVGhUeW5DYmI2R3F5TVowdzA2R0RaQjh6aHJzeWkiLCJtYWMiOiJkMTNmOTBhMDNiM2VlZTI0NTMzOGZmOWY2NTM5MDIxMTU1M2FiNmU2NzM2ZGY0NmJlZmFkYmVlMjljOWUyMTkwIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 17:38:04 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlZnTWljMWVGTlg3UGpOSDBWVW5JMFE9PSIsInZhbHVlIjoiUE85SlZzRzVpbUhnUWhpay9Jd0ZMYUtYc2gvN1g3bjZWanl0L0lBTmQwTVMrQXNSUVVXcnJZZXJoTXM1dmor ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Vgi91TQxcmJjqCNvRqKDmFFZ9IZ8ku0bpfP12eQg"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-cologne-to-valencia-cgn-vln?_url=%2Fcheap-flights-from-cologne-to-valencia-cgn-vln"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-07 15:38:04	GET	/cheap-flights-from-cologne-to-valencia-cgn-vln	43 59 262 1

1 x Application (91.4%)	289ms
1 x Booting (8.59%)	27.17ms

Cheap flights Cologne — Valencia (CGN — VLN)

Choose your dates to find the flight:

Good to know - Cheap tickets Cologne — Valencia

Routes from nearby cities to Valencia

Popular International routes from Cologne

Popular routes from Valencia

Popular domestic routes from Cologne

Related pages

Select your currency

All currencies

Select your language

All languages