Cheap flights Lyon — Stavropol (LYS — STW)

Choose your dates to find the flight:

Good to know - Cheap tickets Lyon — Stavropol

Flight distance	2869 km
Round-trip from	$838

Routes from nearby cities to Stavropol

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

Geneva — Stavropol

from $513 one-way

Marseille — Stavropol

from $647 round-trip

Turin — Stavropol

from $307 one-way

Most often, flights to Stavropol are from Geneva. The cheapest plane ticket to Stavropol can be bought from $307 with a departure from Turin, which is also the nearest city from Lyon.

Popular International routes from Lyon

Lyon — Moscow

from $166 one-way

Lyon — Saint Petersburg

from $160 one-way

Lyon — Lamezia-Terme

from $141 one-way

Lyon — Sevilla

from $51 one-way

Lyon — Yekaterinburg

from $324 one-way

Popular routes from Stavropol

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

Stavropol — Moscow

from $25 one-way

Stavropol — Saint Petersburg

from $37 one-way

Stavropol — Istanbul

from $56 one-way

Stavropol — Adler/Sochi

from $18 one-way

Stavropol — Antalya

from $76 one-way

Popular domestic routes from Lyon

from $44 one-way

from $46 one-way

from $27 one-way

from $34 one-way

from $37 one-way

Return flights Stavropol – Lyon

Messages Timeline Exceptions Views44 Route Queries58 Models272 Mails Gate N+1 Queries Session Request

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

Booting (33.1ms)time
Application (308ms)time
1 x Application (90.3%)
308ms
1 x Booting (9.69%)
33.10ms

44 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
18x 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

58 statements were executed (12 duplicates)Show only duplicates76.52ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

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

SitesRelationshipsSqlRepository.php#34aviatickets4.35msselect * from `sites_relationships` where `us` = 'cheap-flights-from-lyon-to-stavropol-lys-stw' limit 1

Bindings	0: cheap-flights-from-lyon-to-stavropol-lys-stw
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#125aviatickets1msselect * from `flights_by` where `flights_by`.`id` = '198931' 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.15msselect * from `cities` where `cities`.`id` = 3774 limit 1

Bindings	0: 3774
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.13msselect * from `countries` where `countries`.`id` = 120 limit 1

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

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

RoutesController.php#138aviatickets1.21msselect * from `countries` where `countries`.`id` = 248 limit 1

Bindings	0: 248
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.15ms

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

Bindings	0: 198931
Backtrace	app/Avia/Infrastructure/Factory/DomainRouteFactory.php:33 app/Http/Controllers/RoutesController.php:143 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

CountriesRepository.php#31aviatickets1.04msselect * from `countries` where `code` = '' limit 1

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

RouteRepository.php#42aviatickets1.27ms

select `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 3774 and `destination_id` = 9278 and `date_update` >= '2025-04-29 00:00:00' order by `value` asc limit 10

Bindings	0: 3774 1: 9278 2: 2025-04-29 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.02msselect * from `monthly_price_statistics` where `origin_city_id` = 3774 and `destination_city_id` = 9278 limit 1

Bindings	0: 3774 1: 9278
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.21ms

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

Bindings	0: 3774 1: 9278
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.71msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3774

Bindings	0: 3774
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.12msselect distinct `airline_id` from `timetables` where `origin_city_id` = 9278

Bindings	0: 9278
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.57ms

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

Bindings	0: 3774 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.31ms

select * from `flights_by` where `origin_city_id` in (1196, 2258, 1081, 1520, 6231, 9114, 819, 4094, 4146, 8536) and `destination_city_id` = 9278 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 1196 1: 2258 2: 1081 3: 1520 4: 6231 5: 9114 6: 819 7: 4094 8: 4146 9: 8536 10: 9278 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.15msselect * from `cities` where `cities`.`id` in (2258, 4146, 6231)

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

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 (125329, 221303, 338070)

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

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

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

OfferSqlRepository.php#52aviatickets1.28msselect * from `offers` where `origin_city_id` = 3774 and `destination_city_id` = 9278

Bindings	0: 3774 1: 9278
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.76ms

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

Bindings	0: 3774 1: 198931 2: 120 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.41msselect * from `cities` where `cities`.`id` in (3774)

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.09msselect * from `cities` where `cities`.`id` in (5856, 5861, 8522)

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#447aviatickets910μsselect * from `sites_relationships` where `sites_relationships`.`id` in (198932, 198933, 198934)

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.13msselect * from `countries` where `countries`.`id` = 248 limit 1

Bindings	0: 248
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.63ms

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

Bindings	0: 3774 1: 120 2: 0 3: 0 4: 198932
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209

LocalRouteRepository.php#412aviatickets940μsselect * from `cities` where `cities`.`id` in (3774)

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#412aviatickets1msselect * from `cities` where `cities`.`id` in (3505, 4081)

Backtrace

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

LocalRouteRepository.php#412aviatickets1.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (198706, 198763)

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#412aviatickets900μ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.29ms

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

Bindings	0: 9278 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#149aviatickets970μsselect * from `cities` where `cities`.`id` in (9278)

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.27msselect * from `cities` where `cities`.`id` in (86, 407, 2686, 3505, 4081)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.09msselect * from `countries` where `countries`.`id` in (134, 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#149aviatickets810μsselect * from `sites_relationships` where `sites_relationships`.`id` in (315805, 315835, 316024, 316083, 316128)

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

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

Bindings	0: 3774 1: 120 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.09msselect * from `cities` where `cities`.`id` in (3774)

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.13msselect * from `cities` where `cities`.`id` in (768, 4342, 4805, 6140, 8315)

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.01msselect * from `sites_relationships` where `sites_relationships`.`id` in (198410, 198470, 198785, 198818, 198956)

Backtrace

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

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

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#39aviatickets940μs

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

Bindings	0: 3774 1: 9278
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.33ms

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

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

Bindings	0: 9278 1: 3774
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#520aviatickets960μsselect * from `sites_relationships` where `sites_relationships`.`id` in (316103)

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

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

Bindings	0: 9278
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#16aviatickets1.54msselect * from `cities` where `cities`.`id` = 3774 limit 1

Bindings	0: 3774
Backtrace	view::routes.description-nearbyCities:16 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.45msselect * 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.24msselect * 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#175aviatickets2.14msselect * 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.09msselect * 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#175aviatickets940μsselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.75ms

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#149aviatickets1.04msselect * 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.67msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3951, 4081, 4805, 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#149aviatickets1.03msselect * from `countries` where `countries`.`id` in (92, 120, 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#149aviatickets870μs

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

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: 122Timetable.php#?
App\Avia\Infrastructure\Model\City: 51City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 45LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 36SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 17Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: z2G4p6v6UwdiNpAvGTqWqvZYFyIcVinq6Nc3gywy
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-lyon-to-stavropol-lys-stw?_url=%2Fch...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-lyon-to-stavropol-lys-stw

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-lyon-to-stavropol-lys-stw"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlVjUmxMQmxFUjRabzZKcDRyQkJDdmc9PSIsInZhbHVlIjoiWVFNQk50c2JORGcvdGpTZnNoaFdId2RCSXN4Z1lTcFcwS0xXUGR5enRwdXl1RWJ3SFdMdTZPcFZhRHh6QkI3Z3JlRi80NGxabktjZ3cwdGcwTnR2ZVhtUnY0Z3RtcmlrNks5YXllalRTRTBma3FFcWhwNjhWbEMwM1pHWjFxK2kiLCJtYWMiOiI2MzIzNjNlYTM2MzczY2QwNTQ0ZDgwZGIwZjIyZGU4Mjk1MzFkM2FhMTkxMTQ4NTk1OWEzYmQxY2UxYWUwYTAwIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IldYUzJjT2dmd0E0MnZyWUJwa0dkREE9PSIsInZhbHVlIjoiaTJPMkNjczNNUGg0SjBuUFJnVzRSS0ZDbFhBM3ZJNEJ2NWp0VFY0TFRYKzRwQ2swTUU3YjQrdElTYmlBODMzZCtFQ3Q3cTNhVG1RSzhMWkNMclp4ZndFOGpCUEl4UGdPRy9jVmhzMmNJaTRpSDhuMmQwSnQwQ25sbDhTNlFWSy8iLCJtYWMiOiI4MTk2YzNiYjMxYjJlMzFkNmY5OTYxMTI5NjgzODYzMmFjNzJkYmM2NDA0ODc4YTA4OWU1ZGI0NmNhYTg2MTZlIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlVjUmxMQmxFUjRabzZKcDRyQkJDdmc9PSIsInZhbHVlIjoiWVFNQk50c2JORGcvdGpTZnNoaFdId2RCSXN4Z1lTcFcwS0xXUGR5enRwdXl1RWJ3SFdMdTZPcFZhRHh6QkI3Z3JlRi80N ▶"
  ]
  "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" => "z2G4p6v6UwdiNpAvGTqWqvZYFyIcVinq6Nc3gywy"
  "lowcostclub_session" => "Xygi0YUKPUlnrUe3CrUzIcAmLLJWNAL9b11uOvHw"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Thu, 01 May 2025 21:27:38 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""84160aaa24f91911f349d38d7c7cc8bc""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVSYTExQ1ZaM2dxNmV0L1NJRkNTREE9PSIsInZhbHVlIjoiY0t4NjRDMTV5QTJTcy9aMlBST1hQL2xsVUZYY2paZU80aDdGMWNRa1ZRSXlrQ25nOXI5cmxOa3FJR3pXRU90RUNQdHZHOHc5WGhwUTBVNkNXQVJ0UDk0TDZZZVV0YmpjVFFWTmRybXpnd3BxMk5BSGQ3cXFITFFBRXNpeUswS1AiLCJtYWMiOiJjNjk1ZTMwMjJhODY1NTFlODY4NmIwNjc2ZTFlM2M3ODRjY2JkNWQwNGY5N2NlZWRkNjMxNDJlM2RiNjkzMDBmIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 23:27:38 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImVSYTExQ1ZaM2dxNmV0L1NJRkNTREE9PSIsInZhbHVlIjoiY0t4NjRDMTV5QTJTcy9aMlBST1hQL2xsVUZYY2paZU80aDdGMWNRa1ZRSXlrQ25nOXI5cmxOa3FJR3pXRU90RUNQdHZHO ▶"
    1 => "lowcostclub_session=eyJpdiI6IlJReUt4L3FNOW1YT0Z2NHQ0dHM2Wmc9PSIsInZhbHVlIjoiaFN4a2tOZ1MwVWNCa3hza3FlcW5rT1N0MExSQjhycThmK2R1NXdrY1pkbHU5K21MdkRJUkZISEJNeTRYQW1uZlg5c203T3EwckdRNXhlbG9rKzhnNCtKT1ZYU2VxcEUwN1U0RHR0ekM3bHptSXovd0I0aTlrWnBjMk81ajhkNjQiLCJtYWMiOiJmNmUzM2YzNmZhMzI0ODUwNDQ0NzM0ZTBhMTRlNmJhNjBjMTI4YjRmMDg5NDZiODlmZmExN2YyZmRhYzdjYzVkIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 23:27:38 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlJReUt4L3FNOW1YT0Z2NHQ0dHM2Wmc9PSIsInZhbHVlIjoiaFN4a2tOZ1MwVWNCa3hza3FlcW5rT1N0MExSQjhycThmK2R1NXdrY1pkbHU5K21MdkRJUkZISEJNeTRYQW1u ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImVSYTExQ1ZaM2dxNmV0L1NJRkNTREE9PSIsInZhbHVlIjoiY0t4NjRDMTV5QTJTcy9aMlBST1hQL2xsVUZYY2paZU80aDdGMWNRa1ZRSXlrQ25nOXI5cmxOa3FJR3pXRU90RUNQdHZHOHc5WGhwUTBVNkNXQVJ0UDk0TDZZZVV0YmpjVFFWTmRybXpnd3BxMk5BSGQ3cXFITFFBRXNpeUswS1AiLCJtYWMiOiJjNjk1ZTMwMjJhODY1NTFlODY4NmIwNjc2ZTFlM2M3ODRjY2JkNWQwNGY5N2NlZWRkNjMxNDJlM2RiNjkzMDBmIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 23:27:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVSYTExQ1ZaM2dxNmV0L1NJRkNTREE9PSIsInZhbHVlIjoiY0t4NjRDMTV5QTJTcy9aMlBST1hQL2xsVUZYY2paZU80aDdGMWNRa1ZRSXlrQ25nOXI5cmxOa3FJR3pXRU90RUNQdHZHO ▶"
    1 => "lowcostclub_session=eyJpdiI6IlJReUt4L3FNOW1YT0Z2NHQ0dHM2Wmc9PSIsInZhbHVlIjoiaFN4a2tOZ1MwVWNCa3hza3FlcW5rT1N0MExSQjhycThmK2R1NXdrY1pkbHU5K21MdkRJUkZISEJNeTRYQW1uZlg5c203T3EwckdRNXhlbG9rKzhnNCtKT1ZYU2VxcEUwN1U0RHR0ekM3bHptSXovd0I0aTlrWnBjMk81ajhkNjQiLCJtYWMiOiJmNmUzM2YzNmZhMzI0ODUwNDQ0NzM0ZTBhMTRlNmJhNjBjMTI4YjRmMDg5NDZiODlmZmExN2YyZmRhYzdjYzVkIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 23:27:38 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlJReUt4L3FNOW1YT0Z2NHQ0dHM2Wmc9PSIsInZhbHVlIjoiaFN4a2tOZ1MwVWNCa3hza3FlcW5rT1N0MExSQjhycThmK2R1NXdrY1pkbHU5K21MdkRJUkZISEJNeTRYQW1u ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "z2G4p6v6UwdiNpAvGTqWqvZYFyIcVinq6Nc3gywy"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-lyon-to-stavropol-lys-stw?_url=%2Fcheap-flights-from-lyon-to-stavropol-lys-stw"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-01 21:27:38	GET	/cheap-flights-from-lyon-to-stavropol-lys-stw	44 58 272

1 x Application (90.3%)	308ms
1 x Booting (9.69%)	33.10ms

Cheap flights Lyon — Stavropol (LYS — STW)

Choose your dates to find the flight:

Good to know - Cheap tickets Lyon — Stavropol

Routes from nearby cities to Stavropol

Popular International routes from Lyon

Popular routes from Stavropol

Popular domestic routes from Lyon

Related pages

Select your currency

All currencies

Select your language

All languages