Cheap flights Shymkent — Barcelona (CIT — BCN)

Good to know - Cheap tickets Shymkent — Barcelona

Cheapest flight found $228
Flight distance 5434 km
Round-trip from $162
Cheapest month to fly June

Airfare Shymkent – Barcelona by month

Here you can find out in what months how much a ticket Shymkent – Barcelona costs to buy cheap plane tickets.

Month One-way Round-trip
October 2025
September 2025
August 2025
July 2025
June 2025
May 2025
April 2025
March 2025
February 2025
January 2025
December 2024
November 2024

Remember that the optimal time for booking air tickets is 59 days before the departure date, this is the average time at which air tickets were sold at the lowest prices.

Popular airlines flying Shymkent — Barcelona

Flight Shymkent – Barcelona is served by 4 airlines.

Dynamics airfare Shymkent — Barcelona by month for the last year

according to LowCost.Club for the last year

The airfare depends on the departure date. Our chart shows the low season prices on route Shymkent — Barcelona

The graph shows that booking flights Shymkent — Barcelona is best planned for June and flights Shymkent — Barcelona — Shymkent in the month of February.

Flights Shymkent — Barcelona

The selection of cheap flights Shymkent — Barcelona

Here you can find and purchase the cheapest flights Shymkent — Barcelona from $228 and Shymkent — Barcelona — Shymkent from $162.

The price of the flight Shymkent — Barcelona (Spain) — Shymkent from $162 (round-trip).

The average price of the flight Shymkent — Barcelona (Spain) — Shymkent $600 (round-trip).

Low cost flights Shymkent — Barcelona (CIT — BCN)

The distance between Shymkent and Barcelona 3377 miles (or 5434 kilometres).

The time difference between Shymkent and Barcelona is 4 h.

LowCostClub always do a comparison of airfares Shymkent — Barcelona with several airlines (include Air X Charter, MHS Aviation, Pegasus). They will always give you all available options so you can find the cheapest flight to Barcelona. In addition, you can choose the platform where you want to place your orders. There are also special offers for air tickets Shymkent — Barcelona. Last week, for instance, the cheapest round-trip prices stood at $162 while the cheapest one-way price that was available within the last week cost $228

Routes from nearby cities to Barcelona

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

The most frequent flight to Barcelona is from Bishkek. The cheapest airfare can be purchased with a flight from Osh from $47. The nearest airports from Shymkent with a flight to Barcelona are in Turkistan.

Popular International routes from Shymkent

Popular routes from Barcelona

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

Popular domestic routes from Shymkent

FAQ about Shymkent — Barcelona

Yes, you can fly from Shymkent to Barcelona. Shymkent has an airport (Shymkent Airport) for flights. There are non-direct flights through Air X Charter, MHS Aviation, Pegasus, Turkish Airlines.

The price of flights Shymkent — Barcelona starts from $228.

In Shymkent — Shymkent Airport. In Barcelona — Barcelona-El Prat Airport.

High season is considered to be August and the cheapest month is June. Enter your preferred airports (or cities) and dates into the search form above to unlock the latest Shymkent — Barcelona flight deals.

All the following airlines flights Shymkent — Barcelona: Air X Charter, MHS Aviation, Pegasus, Turkish Airlines.

Low price calendar

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

Request history8.3.0PHP Version431msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (30.04ms)time
    • Application (401ms)time
    • 1 x Application (93.02%)
      401ms
      1 x Booting (6.97%)
      30.04ms
      58 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.section-MonthlyPricesection-MonthlyPrice.blade.php#?blade
      • 1x routes.section-timetablesection-timetable.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 2x components.airlines-columnairlines-column.blade.php#?blade
      • 1x routes.section-DynamicsAirfaresection-DynamicsAirfare.blade.php#?blade
      • 1x routes.script-dynamicsOfAirfarescript-dynamicsOfAirfare.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 24x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 2x components.routes-columnroutes-column.blade.php#?blade
      • 1x components.faqfaq.blade.php#?blade
      • 1x components.calendarcalendar.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
      49 statements were executed (15 duplicates)Show only duplicates72.6ms
      • 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.4msselect * from `sites_relationships` where `us` = 'cheap-flights-from-shimkent-to-barcelona-cit-bcn' limit 1
        Bindings
        • 0: cheap-flights-from-shimkent-to-barcelona-cit-bcn
        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#125aviatickets890μsselect * from `flights_by` where `flights_by`.`id` = '68380' 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.23msselect * from `cities` where `cities`.`id` = 1143 limit 1
        Bindings
        • 0: 1143
        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.09msselect * from `countries` where `countries`.`id` = 106 limit 1
        Bindings
        • 0: 106
        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#137aviatickets1msselect * from `cities` where `cities`.`id` = 472 limit 1
        Bindings
        • 0: 472
        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#138aviatickets810μsselect * from `countries` where `countries`.`id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Http/Controllers/RoutesController.php:138
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • DomainRouteFactory.php#33aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` = 68380 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 68380
        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#31aviatickets910μsselect * 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#42aviatickets2.09msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 1143 and `destination_id` = 472 and `date_update` >= '2025-04-26 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 1143
        • 1: 472
        • 2: 2025-04-26 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.3msselect * from `monthly_price_statistics` where `origin_city_id` = 1143 and `destination_city_id` = 472 limit 1
        Bindings
        • 0: 1143
        • 1: 472
        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.01msselect * from `timetables` where `origin_city_id` = 1143 and `destination_city_id` = 472 order by `time_origin` asc limit 1000
        Bindings
        • 0: 1143
        • 1: 472
        Backtrace
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461
        • app/Http/Controllers/RoutesController.php:162
      • AirlineSqlRepository.php#502aviatickets2.2msselect distinct `airline_id` from `timetables` where `origin_city_id` = 472
        Bindings
        • 0: 472
        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.1msselect * from `airlines` where `id` in (3915, 4929, 17925, 5407273) order by `name` asc
        Bindings
        • 0: 3915
        • 1: 4929
        • 2: 17925
        • 3: 5407273
        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
      • NearbyCitiesAggregateDbProvider.php#73aviatickets2.13msselect * from `flights_by` where `origin_city_id` in (5960, 9489, 1528, 4436, 3452, 1865, 414, 4727, 5643, 8999) and `destination_city_id` = 472 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5960
        • 1: 9489
        • 2: 1528
        • 3: 4436
        • 4: 3452
        • 5: 1865
        • 6: 414
        • 7: 4727
        • 8: 5643
        • 9: 8999
        • 10: 472
        • 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.55msselect * from `cities` where `cities`.`id` in (1528, 1865, 3452, 4436, 4727, 5643, 5960, 8999, 9489)
        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.21msselect * from `cities` where `cities`.`id` in (472)
        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#73aviatickets810μsselect * from `sites_relationships` where `sites_relationships`.`id` in (106081, 111892, 181905, 235110, 250391, 306282, 323702, 408955, 1198242)
        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.12msselect * from `cities` where `cities`.`id` = 9489 limit 1
        Bindings
        • 0: 9489
        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.15msselect * from `cities` where `cities`.`id` = 4727 limit 1
        Bindings
        • 0: 4727
        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.88msselect * from `offers` where `origin_city_id` = 1143 and `destination_city_id` = 472
        Bindings
        • 0: 1143
        • 1: 472
        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.31msselect * from `flights_by` where `origin_city_id` = 1143 and `id` > 68380 and `destination_country_id` <> 106 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 1143
        • 1: 68380
        • 2: 106
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#447aviatickets2.12msselect * from `cities` where `cities`.`id` in (1143)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#447aviatickets2.37msselect * from `cities` where `cities`.`id` in (511, 519, 571)
        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.55msselect * from `sites_relationships` where `sites_relationships`.`id` in (68381, 68382, 68383)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#412aviatickets1.82msselect * from `flights_by` where `origin_city_id` = 1143 and `destination_country_id` <> 106 and (`price_one_way` > 0 or `price` > 0) and `id` not in (68381) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 1143
        • 1: 106
        • 2: 0
        • 3: 0
        • 4: 68381
        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.24msselect * from `cities` where `cities`.`id` in (1143)
        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.41msselect * from `cities` where `cities`.`id` in (4081, 4761)
        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.27msselect * from `sites_relationships` where `sites_relationships`.`id` in (68569, 68605)
        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.49msselect * 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#149aviatickets2.17msselect * from `flights_by` where `origin_city_id` = 472 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 472
        • 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.21msselect * from `cities` where `cities`.`id` in (472)
        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.37msselect * from `cities` where `cities`.`id` in (1811, 2686, 3505, 4081, 6319)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets1.15msselect * from `countries` where `countries`.`id` in (124, 134, 211, 248)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets1.31msselect * from `sites_relationships` where `sites_relationships`.`id` in (27405, 27532, 27636, 27729, 28096)
        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
      • TimetableRepository.php#39aviatickets1.3msselect * from `timetables` where `origin_city_id` = 1143 and `destination_city_id` = 472 order by `time_origin` asc limit 10
        Bindings
        • 0: 1143
        • 1: 472
        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.28msselect * from `timetables` where `origin_city_id` = 1143 and `destination_city_id` = 472 order by `travel_time` asc limit 1
        Bindings
        • 0: 1143
        • 1: 472
        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.22msselect * from `flights_by` where `origin_city_id` = 472 and `destination_city_id` = 1143 limit 1
        Bindings
        • 0: 472
        • 1: 1143
        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#520aviatickets1.19msselect * from `sites_relationships` where `sites_relationships`.`id` in (27302)
        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.33msselect * from `cities` where `cities`.`id` = 1143 limit 1
        Bindings
        • 0: 1143
        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.31msselect * from `cities` where `cities`.`id` = 472 limit 1
        Bindings
        • 0: 472
        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
      • City.php#136aviatickets1.4msselect * from `airports` where `airports`.`city_id` = 1143 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 1143
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:95
        • 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
      • City.php#136aviatickets1.55msselect * from `airports` where `airports`.`city_id` = 472 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 472
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:122
        • 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
      • description-nearbyCities.blade.php#28aviatickets1.26msselect * from `cities` where `cities`.`id` = 1143 limit 1
        Bindings
        • 0: 1143
        Backtrace
        • view::routes.description-nearbyCities:28
        • 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
      • FlightSqlRepository.php#98aviatickets1.25msselect * from `timetables` where `origin_city_id` = 1143 and `destination_city_id` = 472
        Bindings
        • 0: 1143
        • 1: 472
        Backtrace
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:98
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:104
        • app/Avia/Infrastructure/FaqRouteFactory/AreThereDirectFlights.php:21
      • CanWeFlyFromTo.php#30aviatickets1.79msselect * from `airports` where `airports`.`city_id` = 1143 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 1143
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:30
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:305
      • CanWeFlyFromTo.php#35aviatickets1.54msselect * from `airports` where `airports`.`city_id` = 472 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 472
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:35
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:305
      • TimetableRepository.php#39aviatickets1.3msselect * from `timetables` where `origin_city_id` = 1143 and `destination_city_id` = 472 order by `time_origin` asc limit 1000
        Bindings
        • 0: 1143
        • 1: 472
        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/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:42
      • TimetableRepository.php#144aviatickets1.27msselect * from `timetables` where `origin_city_id` = 1143 and `destination_city_id` = 472 order by `travel_time` asc limit 1
        Bindings
        • 0: 1143
        • 1: 472
        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/Avia/Infrastructure/FaqRouteFactory/HowLongDoesItTakeToFly.php:27
      • MonthlyPriceStatisticSqlRepository.php#66aviatickets1.09msselect * from `monthly_price_statistics` where `origin_city_id` = 1143 and `destination_city_id` = 472 limit 1
        Bindings
        • 0: 1143
        • 1: 472
        Backtrace
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:44
        • app/Avia/Infrastructure/FaqRouteFactory/WhatMonthCheapest.php:27
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
      App\Avia\Infrastructure\Model\Timetable
      158Timetable.php#?
      App\Avia\Infrastructure\Model\City
      30City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      22SitesRelationship.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      21LocalRoute.php#?
      App\Avia\Infrastructure\Model\Country
      7Country.php#?
      App\Avia\Infrastructure\Model\Airline
      4Airline.php#?
      App\Avia\Infrastructure\Model\Airport
      4Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      2MonthlyPriceStatistic.php#?
          • infoModel: App\Avia\Infrastructure\Model\City => Relation: App\Avia\Infrastructure\Model\Airport - You s...
          _token
          B4IgDHgAGEFvESR07x9PXXz238xQcxFFjdEErdAo
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-shimkent-to-barcelona-cit-bcn?_url=%...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-shimkent-to-barcelona-cit-bcn
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "_url" => "/cheap-flights-from-shimkent-to-barcelona-cit-bcn" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IldkUzdLc1dSRkNldzBUT3UrSVFybkE9PSIsInZhbHVlIjoiRFF2Vmk4azk0RC9KZ2xQak53OGZ0T3NGZ0g2bURKUXU4bmZlL0lvVTNYVSs2Zm9DUnV3Vzk5SUNiRXErYmtGeVpVcUpWUjhKWkRwaUNTeStQelJIQTJGbzVWQWhsYU1vRFZTNE41ditnd1lqWmRDaVRSQWN2OTdkOVdFNmV3Q0UiLCJtYWMiOiI5ZDhjNWUxYjYxNmNhOTZjNTFhMjMyYmYzYTFiY2FhNjk2YjE3YjllMTZlNGMyOGY2MjRlNzE4NGQ0YTMzNjQ0IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjBsR2xpNjBUbkpQUXRnRkpHOEk2Smc9PSIsInZhbHVlIjoidnVNbDF1cTZBamc3N1JYTk16UVRvWUcwYm1qTk5tRDNDM2E2YWMyRjcreVN5VlpyRWgzS0FrckNCYmQrVWl5d2kwQWZJczdWTGNWOU5vM0hLNG5DZlh0WnNjeTF2a2g1Mm5FaXZJa1hCdUpsb29LajFTT0w5TlhISmhWV0FBcFkiLCJtYWMiOiJmN2ViZDQ4NTliY2M1YTNhN2RiYTVhNmQxMmFiODRkZTljMDU4OTVkYmMwY2YyOTRiYzI1YTYxNjUwZjQ5NjU0IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IldkUzdLc1dSRkNldzBUT3UrSVFybkE9PSIsInZhbHVlIjoiRFF2Vmk4azk0RC9KZ2xQak53OGZ0T3NGZ0g2bURKUXU4bmZlL0lvVTNYVSs2Zm9DUnV3Vzk5SUNiRXErYmtGeVpVcUpWU" ] "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "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" => "B4IgDHgAGEFvESR07x9PXXz238xQcxFFjdEErdAo" "lowcostclub_session" => "QIJMQiKgCxSzUuhcJxlMEUz0dcb8W2xovhq8b5OD" ]
          response_headers
          0 of 0
          array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Mon, 28 Apr 2025 13:56:15 GMT" ] "etag" => array:1 [ 0 => ""a89c1adb3b7f3e6f249af832728f8fe2"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Img0cURoNE0rUWY2M2tGV0plVzJXS1E9PSIsInZhbHVlIjoiZXF4T0lINkZrSmN4cTZvU0ViVEswZ3paMVE1K29qMkI4c2ViN3dTbW5yNUFUTUZNc2VTekdDbW52bzZaV2kzQnpCdHZJVmJqcVhOaTVld0xQK2d6eU1QckZTM2pCMEtjYVRhS3VheEtyM1pmdEJZMlVjRkFOaFM5cEtqemMwbUMiLCJtYWMiOiI4NWU2N2UyNDY0YWM0ZDM3YmNmYjlkZDIyZDM4NTliNWI5MmUyZmY3NzhiNWQyNzRmNzgxMWU0ODdmMmMyOGMyIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 15:56:15 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Img0cURoNE0rUWY2M2tGV0plVzJXS1E9PSIsInZhbHVlIjoiZXF4T0lINkZrSmN4cTZvU0ViVEswZ3paMVE1K29qMkI4c2ViN3dTbW5yNUFUTUZNc2VTekdDbW52bzZaV2kzQnpCdHZJV" 1 => "lowcostclub_session=eyJpdiI6IkpXbjI4ek1aV1NqeHdjS2JjemNGUWc9PSIsInZhbHVlIjoiakszbStiK0MxQ2k0WWpha1VqTi93ZFpmRHV0ZXVtOS80VTV5U3VUaU85aU9QZVNUbmoxTFFHdWVzVTVETFBpZ3lsY3lIVjVBcm9vRHB4cFNxOFdzVUQ3UmY5ZTBpTVFXdWtTSUVFdU9TQkJoeENiRWtQNzUrZXUzT09zUE9nM08iLCJtYWMiOiI4MWZlN2Q2Yjk2NzI4Y2QwMDIzZmMxMGJjMDk0YTNhYzY4OGRhYzAwYWQ5YzRmNGNiODRhZGE3MzhmY2NhMjA1IiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 15:56:15 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6IkpXbjI4ek1aV1NqeHdjS2JjemNGUWc9PSIsInZhbHVlIjoiakszbStiK0MxQ2k0WWpha1VqTi93ZFpmRHV0ZXVtOS80VTV5U3VUaU85aU9QZVNUbmoxTFFHdWVzVTVETFBp" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Img0cURoNE0rUWY2M2tGV0plVzJXS1E9PSIsInZhbHVlIjoiZXF4T0lINkZrSmN4cTZvU0ViVEswZ3paMVE1K29qMkI4c2ViN3dTbW5yNUFUTUZNc2VTekdDbW52bzZaV2kzQnpCdHZJVmJqcVhOaTVld0xQK2d6eU1QckZTM2pCMEtjYVRhS3VheEtyM1pmdEJZMlVjRkFOaFM5cEtqemMwbUMiLCJtYWMiOiI4NWU2N2UyNDY0YWM0ZDM3YmNmYjlkZDIyZDM4NTliNWI5MmUyZmY3NzhiNWQyNzRmNzgxMWU0ODdmMmMyOGMyIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 15:56:15 GMT; path=/XSRF-TOKEN=eyJpdiI6Img0cURoNE0rUWY2M2tGV0plVzJXS1E9PSIsInZhbHVlIjoiZXF4T0lINkZrSmN4cTZvU0ViVEswZ3paMVE1K29qMkI4c2ViN3dTbW5yNUFUTUZNc2VTekdDbW52bzZaV2kzQnpCdHZJV" 1 => "lowcostclub_session=eyJpdiI6IkpXbjI4ek1aV1NqeHdjS2JjemNGUWc9PSIsInZhbHVlIjoiakszbStiK0MxQ2k0WWpha1VqTi93ZFpmRHV0ZXVtOS80VTV5U3VUaU85aU9QZVNUbmoxTFFHdWVzVTVETFBpZ3lsY3lIVjVBcm9vRHB4cFNxOFdzVUQ3UmY5ZTBpTVFXdWtTSUVFdU9TQkJoeENiRWtQNzUrZXUzT09zUE9nM08iLCJtYWMiOiI4MWZlN2Q2Yjk2NzI4Y2QwMDIzZmMxMGJjMDk0YTNhYzY4OGRhYzAwYWQ5YzRmNGNiODRhZGE3MzhmY2NhMjA1IiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 15:56:15 GMT; path=/; httponlylowcostclub_session=eyJpdiI6IkpXbjI4ek1aV1NqeHdjS2JjemNGUWc9PSIsInZhbHVlIjoiakszbStiK0MxQ2k0WWpha1VqTi93ZFpmRHV0ZXVtOS80VTV5U3VUaU85aU9QZVNUbmoxTFFHdWVzVTVETFBp" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "B4IgDHgAGEFvESR07x9PXXz238xQcxFFjdEErdAo" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-shimkent-to-barcelona-cit-bcn?_url=%2Fcheap-flights-from-shimkent-to-barcelona-cit-bcn" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-28 13:56:15GET/cheap-flights-from-shimkent-to-barcelona-cit-bcn58492481