Cheap flights Surgut — Varadero (SGC — VRA)

Choose your dates to find the flight:

Good to know - Cheap tickets Surgut — Varadero

Cheapest flight found	$547
Flight distance	10368 km
Round-trip from	$1,035

Popular airlines flying Surgut — Varadero

Flight Surgut – Varadero is served by 3 airlines.

Aeroflot (SU)

Nordwind Airlines (N4)

Rossiya (FV)

Routes from nearby cities to Varadero

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

Khanty-Mansiysk — Varadero

from $992 round-trip

Nizhnevartovsk — Varadero

from $816 one-way

Most often, they fly to Varadero from Khanty-Mansiysk, this is the closest city with an airport from Surgut. The cheapest ticket can be bought for a flight departing from Nizhnevartovsk from $816.

Popular International routes from Surgut

from $457 one-way

from $544 one-way

from $369 one-way

from $1,542 round-trip

Surgut — Washington

from $725 one-way

Popular routes from Varadero

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

Varadero — Moscow

from $164 one-way

Varadero — Cancun

from $230 one-way

Varadero — Miami

from $179 one-way

Varadero — Punta Cana

from $158 one-way

Varadero — Mexico City

from $321 one-way

Popular domestic routes from Surgut

Surgut — Moscow

from $24 one-way

Surgut — Adler/Sochi

from $79 one-way

Surgut — Saint Petersburg

from $75 one-way

Surgut — Makhachkala

from $66 one-way

Surgut — Mineralnye Vody

from $84 one-way

Messages Timeline Exceptions Views46 Route Queries56 Models179 Mails Gate N+1 Queries Session Request

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

Booting (30.54ms)time
Application (588ms)time
1 x Application (95.06%)
588ms
1 x Booting (4.94%)
30.54ms

46 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
3x components.airlines-columnairlines-column.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

56 statements were executed (7 duplicates)Show only duplicates174ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

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

SitesRelationshipsSqlRepository.php#34aviatickets5.3msselect * from `sites_relationships` where `us` = 'cheap-flights-from-surgut-to-varadero-sgc-vra' limit 1

Bindings	0: cheap-flights-from-surgut-to-varadero-sgc-vra
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#125aviatickets880μsselect * from `flights_by` where `flights_by`.`id` = '299045' 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#135aviatickets930μsselect * from `cities` where `cities`.`id` = 5563 limit 1

Bindings	0: 5563
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#136aviatickets880μsselect * from `countries` where `countries`.`id` = 248 limit 1

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

Bindings	0: 6574
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.12msselect * from `countries` where `countries`.`id` = 19 limit 1

Bindings	0: 19
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#33aviatickets790μs

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

Bindings	0: 299045
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.84msselect * 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.45ms

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

Bindings	0: 5563 1: 6574 2: 2025-05-04 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.2msselect * from `monthly_price_statistics` where `origin_city_id` = 5563 and `destination_city_id` = 6574 limit 1

Bindings	0: 5563 1: 6574
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.35ms

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

Bindings	0: 5563 1: 6574
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.16msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5563

Bindings	0: 5563
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.29msselect distinct `airline_id` from `timetables` where `origin_city_id` = 6574

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

AirlineSqlRepository.php#90aviatickets1.38msselect * from `airlines` where `id` in (129, 639, 5524) order by `name` asc

Bindings	0: 129 1: 639 2: 5524
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.23ms

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

Bindings	0: 5563 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.02ms

select * from `flights_by` where `origin_city_id` in (2975, 4414, 9367, 2400, 8638, 7662, 7591, 4544, 6202, 6432) and `destination_city_id` = 6574 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 2975 1: 4414 2: 9367 3: 2400 4: 8638 5: 7662 6: 7591 7: 4544 8: 6202 9: 6432 10: 6574 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#73aviatickets4.8msselect * from `cities` where `cities`.`id` in (2400, 4414)

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

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#73aviatickets3.35msselect * from `sites_relationships` where `sites_relationships`.`id` in (134984, 234389)

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

Bindings	0: 2400
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#104aviatickets2.05msselect * from `cities` where `cities`.`id` = 4414 limit 1

Bindings	0: 4414
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.45msselect * from `offers` where `origin_city_id` = 5563 and `destination_city_id` = 6574

Bindings	0: 5563 1: 6574
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.28ms

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

Bindings	0: 5563 1: 299045 2: 248 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#447aviatickets4.17msselect * from `cities` where `cities`.`id` in (5563)

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.87msselect * from `cities` where `cities`.`id` in (6579, 6590, 6623)

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 `sites_relationships` where `sites_relationships`.`id` in (299046, 299047, 299049)

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#125aviatickets4.21msselect * from `countries` where `countries`.`id` = 34 limit 1

Bindings	0: 34
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.03ms

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

Bindings	0: 5563 1: 248 2: 0 3: 0 4: 299046
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.09msselect * from `cities` where `cities`.`id` in (5563)

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.9msselect * from `cities` where `cities`.`id` in (696, 2382)

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#412aviatickets3.62msselect * from `sites_relationships` where `sites_relationships`.`id` in (298486, 298642)

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

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#149aviatickets3.77ms

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

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

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#149aviatickets4.82msselect * from `cities` where `cities`.`id` in (1345, 3884, 3951, 4081, 5136)

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#149aviatickets5.71msselect * from `countries` where `countries`.`id` in (79, 92, 112, 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#149aviatickets3.68msselect * from `sites_relationships` where `sites_relationships`.`id` in (358556, 358593, 358595, 358599, 358617)

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

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

Bindings	0: 5563 1: 248 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#359aviatickets2.68msselect * from `cities` where `cities`.`id` in (5563)

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#359aviatickets2.06msselect * from `cities` where `cities`.`id` in (86, 3505, 3845, 4081, 4148)

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#359aviatickets3.74msselect * from `sites_relationships` where `sites_relationships`.`id` in (298434, 298733, 298768, 298789, 298793)

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#359aviatickets3.42msselect * from `countries` where `countries`.`id` in (248)

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#39aviatickets10.08ms

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

Bindings	0: 5563 1: 6574
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.75ms

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

Bindings	0: 5563 1: 6574
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#520aviatickets970μsselect * from `flights_by` where `origin_city_id` = 6574 and `destination_city_id` = 5563 limit 1

Bindings	0: 6574 1: 5563
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

description-nearbyCities.blade.php#24aviatickets3.19msselect * from `cities` where `cities`.`id` = 5563 limit 1

Bindings	0: 5563
Backtrace	view::routes.description-nearbyCities:24 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#175aviatickets14.68msselect * 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#175aviatickets5.88msselect * 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#175aviatickets6.79msselect * 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#175aviatickets2.42msselect * 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#175aviatickets3.16msselect * 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.82ms

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.01msselect * 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#149aviatickets2.27msselect * 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#149aviatickets3.46msselect * 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#149aviatickets1.84ms

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\City: 48City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 43LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 34SitesRelationship.php#?
App\Avia\Infrastructure\Model\Timetable: 32Timetable.php#?
App\Avia\Infrastructure\Model\Country: 18Country.php#?
App\Avia\Infrastructure\Model\Airline: 3Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: oP7NpFwgCiK1uZUgUKhnLvoo4pLR88LbPLQvigIM
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-surgut-to-varadero-sgc-vra?_url=%2Fc...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-surgut-to-varadero-sgc-vra

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-surgut-to-varadero-sgc-vra"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImlwTGszTHFSTldUNTFNU29hdHpDK0E9PSIsInZhbHVlIjoia3F1aTN0SG9CV2hKRWxiZzg2N2Rtc0xUU1ZBdi9mNU0vTm5kUjl2dGNsTE52QzdtSUhMZ2VBVk1sU0JSUWdqRVJOaE9YVkZYbUdlY0R6Y3dGK2hHVjRVU3ZVZitwNkdzRTZGZnFqVjk0d1ZXSjNYc1RjMkJHSU83dmtYSmF0eUkiLCJtYWMiOiI4Nzk5YzAwYmIyMTU4YTk2YTdiNzM1ODVmYzE3MTY1MGE1NGUxNTBkYzk1NGNhNTlhZTg1YjNiOWFmYWQ1MTRlIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6Ik9ReHFuVEJWby9ueE1QV0tvaXZIVlE9PSIsInZhbHVlIjoiT2FVYmlyOHNFTGdnQWZXeEFYVlBYblpEaFZtMHR2V3lsYThQMnp1N3RLNUxMZ2JUa3hQbVBrMnhCYk9sSHJJeXlPTitEK1I0RWVrdERWVnFQcXRWUjdONzdFTnVvK2pDcXFvMEpFckR1Y1ZHaEdPclFtbWNaMVZPZnF3QkgyakwiLCJtYWMiOiIyNWM0ZDdlMzQ4NjYwMDlkOGY4YjE0MjdhN2UyYzk1NGRjZTRiZjY4ODhlMmU1NzMwZGUwZjlmNmEwOGEzMzJlIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImlwTGszTHFSTldUNTFNU29hdHpDK0E9PSIsInZhbHVlIjoia3F1aTN0SG9CV2hKRWxiZzg2N2Rtc0xUU1ZBdi9mNU0vTm5kUjl2dGNsTE52QzdtSUhMZ2VBVk1sU0JSUWdqRVJOaE9YV ▶"
  ]
  "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" => "oP7NpFwgCiK1uZUgUKhnLvoo4pLR88LbPLQvigIM"
  "lowcostclub_session" => "ntH9PxwwnZ9Djnb8gA5ZvP9MT1LD8MMx0YinM7Lj"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 06:02:38 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""5945960070d1264184192cf5250d665e""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlNDalRJYkNTYnQ2Y3JWWVd3dEs0aUE9PSIsInZhbHVlIjoiT2g0Q0NvSFQvaWl2L1lueC9BeXlhVVhHMEh6NFBzQzg1ZHFjV3hqUWJxVm04c1N6SVF1MndiOFRoUGc2MDFHVjlJWDF1RURKY2tKMFpGQitZS1IyaE9zbUtYV1JYbDlIT29RcjBWMjE2VXlBVmlmQURsaFFoQnBQazdTSnk5SjEiLCJtYWMiOiI2MTVlMzA4N2U1NjJkMTU1ZDhkY2RmNzIxNzJhMjU0OGJkMWE0ZmFkZjNlOTM5ODQ5OTQ2YjIyNzY2ODgzNjE3IiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 08:02:38 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlNDalRJYkNTYnQ2Y3JWWVd3dEs0aUE9PSIsInZhbHVlIjoiT2g0Q0NvSFQvaWl2L1lueC9BeXlhVVhHMEh6NFBzQzg1ZHFjV3hqUWJxVm04c1N6SVF1MndiOFRoUGc2MDFHVjlJWDF1R ▶"
    1 => "lowcostclub_session=eyJpdiI6IkVydERCdTBBTWRPMTRCZ3pHYW9vK1E9PSIsInZhbHVlIjoiRDY1am9FS3dXeWM1Sm5qTm51cjFrcHZNVTFEV0dQUVdkNXZJdE1BNTQ0dGdXa2JYL0NUbzFzWUN3NnJiaSs0aHc3alAveEVacmZ1UUtEYlBhSy9QT05QV1JyczdMNFA0ME10c01TU1V4cU9NeFE3Z3F0MXlIc0J0Ky9ycjZTdkMiLCJtYWMiOiI2MGY0NGI1OWI2M2Q1NTJkYjJlOTVlZGNkZTBlNzUxMjgwODY5NWU0MmRhNjRlYjFlM2RkNzFhZjlmZWE2MmU5IiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 08:02:38 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IkVydERCdTBBTWRPMTRCZ3pHYW9vK1E9PSIsInZhbHVlIjoiRDY1am9FS3dXeWM1Sm5qTm51cjFrcHZNVTFEV0dQUVdkNXZJdE1BNTQ0dGdXa2JYL0NUbzFzWUN3NnJiaSs0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlNDalRJYkNTYnQ2Y3JWWVd3dEs0aUE9PSIsInZhbHVlIjoiT2g0Q0NvSFQvaWl2L1lueC9BeXlhVVhHMEh6NFBzQzg1ZHFjV3hqUWJxVm04c1N6SVF1MndiOFRoUGc2MDFHVjlJWDF1RURKY2tKMFpGQitZS1IyaE9zbUtYV1JYbDlIT29RcjBWMjE2VXlBVmlmQURsaFFoQnBQazdTSnk5SjEiLCJtYWMiOiI2MTVlMzA4N2U1NjJkMTU1ZDhkY2RmNzIxNzJhMjU0OGJkMWE0ZmFkZjNlOTM5ODQ5OTQ2YjIyNzY2ODgzNjE3IiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 08:02:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlNDalRJYkNTYnQ2Y3JWWVd3dEs0aUE9PSIsInZhbHVlIjoiT2g0Q0NvSFQvaWl2L1lueC9BeXlhVVhHMEh6NFBzQzg1ZHFjV3hqUWJxVm04c1N6SVF1MndiOFRoUGc2MDFHVjlJWDF1R ▶"
    1 => "lowcostclub_session=eyJpdiI6IkVydERCdTBBTWRPMTRCZ3pHYW9vK1E9PSIsInZhbHVlIjoiRDY1am9FS3dXeWM1Sm5qTm51cjFrcHZNVTFEV0dQUVdkNXZJdE1BNTQ0dGdXa2JYL0NUbzFzWUN3NnJiaSs0aHc3alAveEVacmZ1UUtEYlBhSy9QT05QV1JyczdMNFA0ME10c01TU1V4cU9NeFE3Z3F0MXlIc0J0Ky9ycjZTdkMiLCJtYWMiOiI2MGY0NGI1OWI2M2Q1NTJkYjJlOTVlZGNkZTBlNzUxMjgwODY5NWU0MmRhNjRlYjFlM2RkNzFhZjlmZWE2MmU5IiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 08:02:38 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IkVydERCdTBBTWRPMTRCZ3pHYW9vK1E9PSIsInZhbHVlIjoiRDY1am9FS3dXeWM1Sm5qTm51cjFrcHZNVTFEV0dQUVdkNXZJdE1BNTQ0dGdXa2JYL0NUbzFzWUN3NnJiaSs0 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "oP7NpFwgCiK1uZUgUKhnLvoo4pLR88LbPLQvigIM"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-surgut-to-varadero-sgc-vra?_url=%2Fcheap-flights-from-surgut-to-varadero-sgc-vra"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-06 06:02:38	GET	/cheap-flights-from-surgut-to-varadero-sgc-vra	46 56 179

1 x Application (95.06%)	588ms
1 x Booting (4.94%)	30.54ms

Cheap flights Surgut — Varadero (SGC — VRA)

Choose your dates to find the flight:

Good to know - Cheap tickets Surgut — Varadero

Popular airlines flying Surgut — Varadero

Routes from nearby cities to Varadero

Popular International routes from Surgut

Popular routes from Varadero

Popular domestic routes from Surgut

Select your currency

All currencies

Select your language

All languages