The most frequent flight to Sarajevo is from Tivat. The cheapest airfare can be purchased with a flight from Tirana from $45. The nearest airports from Skopje with a flight to Sarajevo are in Dubrovnik.

Popular International routes from Skopje

Skopje — Moscow

from $96 one-way

Skopje — Chicago

from $478 one-way

Skopje — San Jose

from $1,070 round-trip

Skopje — Thessaloniki

from $73 one-way

Skopje — Sofia

from $35 one-way

Popular routes from Sarajevo

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

Sarajevo — Moscow

from $127 one-way

Sarajevo — Saint Petersburg

from $162 one-way

Sarajevo — Istanbul

from $10 one-way

Sarajevo — Chicago

from $608 one-way

Sarajevo — Kazan

from $86 one-way

Popular domestic routes from Skopje

Skopje — Ohrid

from $37 one-way

Return flights Sarajevo – Skopje

Schedule of direct flights Skopje — Sarajevo

Messages Timeline Exceptions Views53 Route Queries86 Models440 Mails Gate N+1 Queries4 Session Request

Request history8.3.0490ms5MBGET cheap-flights-from-{slug}

Booting (27.17ms)time
Application (462ms)time
1 x Application (94.45%)
462ms
1 x Booting (5.55%)
27.17ms

53 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
6x components.airlines-columnairlines-column.blade.php#?blade
4x components.routes-listroutes-list.blade.php#?blade
21x components.routeListItemrouteListItem.blade.php#?blade
1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
2x components.routes-columnroutes-column.blade.php#?blade
1x components.related-linksrelated-links.blade.php#?blade
1x layouts.mainmain.blade.php#?blade
1x headerheader.blade.php#?blade
2x menumenu.blade.php#?blade
1x footerfooter.blade.php#?blade
1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
1x footer_scriptsfooter_scripts.blade.php#?blade
1x components.currencycurrency.blade.php#?blade
2x components.popuppopup.blade.php#?blade
1x components.languagelanguage.blade.php#?blade

uri: GET cheap-flights-from-{slug}
middleware: web
controller: App\Http\Controllers\RoutesController@view
namespace
prefix: /
where
as: route
file: app/Http/Controllers/RoutesController.php:96-299

86 statements were executed (38 duplicates)Show only duplicates115ms

QueryDetector.php#25aviaticketsConnection Established

Backtrace

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

SitesRelationshipsSqlRepository.php#34aviatickets3.71msselect * from `sites_relationships` where `us` = 'cheap-flights-from-skopje-to-sarajevo-skp-sjj' limit 1

Bindings	0: cheap-flights-from-skopje-to-sarajevo-skp-sjj
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#125aviatickets1.04msselect * from `flights_by` where `flights_by`.`id` = '307313' 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.06msselect * from `cities` where `cities`.`id` = 5650 limit 1

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

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

Bindings	0: 5628
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.2msselect * from `countries` where `countries`.`id` = 216 limit 1

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

DomainRouteFactory.php#33aviatickets1.08ms

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

Bindings	0: 307313
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.44msselect * 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.79ms

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

Bindings	0: 5650 1: 5628 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.58msselect * from `monthly_price_statistics` where `origin_city_id` = 5650 and `destination_city_id` = 5628 limit 1

Bindings	0: 5650 1: 5628
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.65ms

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

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

AirlineSqlRepository.php#470aviatickets1.11msselect * from `airlines` where `airlines`.`id` in (3204, 3768, 259328)

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.31msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5650

Bindings	0: 5650
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.36msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5628

Bindings	0: 5628
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.36ms

select * from `airlines` where `id` in (489, 1921, 3314, 3915, 4303, 4557, 4929, 5432, 18268, 19968, 24064, 57275, 158502, 17235528) order by `name` asc

Bindings	0: 489 1: 1921 2: 3314 3: 3915 4: 4303 5: 4557 6: 4929 7: 5432 8: 18268 9: 19968 10: 24064 11: 57275 12: 158502 13: 17235528
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#558aviatickets990μs

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

Bindings	0: 5650 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#73aviatickets1.8ms

select * from `flights_by` where `origin_city_id` in (8694, 4610, 2629, 5723, 6074, 5644, 6043, 6090, 1445, 1092) and `destination_city_id` = 5628 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8694 1: 4610 2: 2629 3: 5723 4: 6074 5: 5644 6: 6043 7: 6090 8: 1445 9: 1092 10: 5628 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.56msselect * from `cities` where `cities`.`id` in (1092, 1445, 2629, 4610, 5644, 5723, 6043, 6074, 6090, 8694)

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (64312, 82715, 243589, 269540, 306929, 310527, 327135, 328598, 329493, 1024177)

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

LocalRouteRepository.php#558aviatickets1.45ms

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

Bindings	0: 5650 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.46ms

select * from `flights_by` where `origin_city_id` in (8694, 4610, 2629, 5723, 6074, 5644, 6043, 6090, 1445, 1092) and `destination_city_id` = 5628 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8694 1: 4610 2: 2629 3: 5723 4: 6074 5: 5644 6: 6043 7: 6090 8: 1445 9: 1092 10: 5628 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:85

NearbyCitiesAggregateDbProvider.php#73aviatickets1.59msselect * from `cities` where `cities`.`id` in (1092, 1445, 2629, 4610, 5644, 5723, 6043, 6074, 6090, 8694)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.37msselect * from `cities` where `cities`.`id` in (5628)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.41ms

select * from `sites_relationships` where `sites_relationships`.`id` in (64312, 82715, 243589, 269540, 306929, 310527, 327135, 328598, 329493, 1024177)

Backtrace

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

CitySqlRepository.php#104aviatickets1.52msselect * from `cities` where `cities`.`id` = 1445 limit 1

Bindings	0: 1445
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:97

LocalRouteRepository.php#558aviatickets1.43ms

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

Bindings	0: 5650 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.64ms

select * from `flights_by` where `origin_city_id` in (8694, 4610, 2629, 5723, 6074, 5644, 6043, 6090, 1445, 1092) and `destination_city_id` = 5628 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8694 1: 4610 2: 2629 3: 5723 4: 6074 5: 5644 6: 6043 7: 6090 8: 1445 9: 1092 10: 5628 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.85msselect * from `cities` where `cities`.`id` in (1092, 1445, 2629, 4610, 5644, 5723, 6043, 6074, 6090, 8694)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.75msselect * from `cities` where `cities`.`id` in (5628)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.48ms

select * from `sites_relationships` where `sites_relationships`.`id` in (64312, 82715, 243589, 269540, 306929, 310527, 327135, 328598, 329493, 1024177)

Backtrace

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

CitySqlRepository.php#104aviatickets1.32msselect * from `cities` where `cities`.`id` = 6074 limit 1

Bindings	0: 6074
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158

LocalRouteRepository.php#558aviatickets1.58ms

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

Bindings	0: 5650 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.71ms

select * from `flights_by` where `origin_city_id` in (8694, 4610, 2629, 5723, 6074, 5644, 6043, 6090, 1445, 1092) and `destination_city_id` = 5628 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8694 1: 4610 2: 2629 3: 5723 4: 6074 5: 5644 6: 6043 7: 6090 8: 1445 9: 1092 10: 5628 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:123

NearbyCitiesAggregateDbProvider.php#73aviatickets1.53msselect * from `cities` where `cities`.`id` in (1092, 1445, 2629, 4610, 5644, 5723, 6043, 6074, 6090, 8694)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.07msselect * from `cities` where `cities`.`id` in (5628)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.09ms

select * from `sites_relationships` where `sites_relationships`.`id` in (64312, 82715, 243589, 269540, 306929, 310527, 327135, 328598, 329493, 1024177)

Backtrace

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

CitySqlRepository.php#104aviatickets1.47msselect * from `cities` where `cities`.`id` = 6090 limit 1

Bindings	0: 6090
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:131

LocalRouteRepository.php#558aviatickets1.17ms

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

Bindings	0: 5650 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.14ms

select * from `flights_by` where `origin_city_id` in (8694, 4610, 2629, 5723, 6074, 5644, 6043, 6090, 1445, 1092) and `destination_city_id` = 5628 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 8694 1: 4610 2: 2629 3: 5723 4: 6074 5: 5644 6: 6043 7: 6090 8: 1445 9: 1092 10: 5628 11: 0 12: 0
Backtrace	app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:142

NearbyCitiesAggregateDbProvider.php#73aviatickets1.4msselect * from `cities` where `cities`.`id` in (1092, 1445, 2629, 4610, 5644, 5723, 6043, 6074, 6090, 8694)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets1.41msselect * from `cities` where `cities`.`id` in (5628)

Backtrace

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

NearbyCitiesAggregateDbProvider.php#73aviatickets960μs

select * from `sites_relationships` where `sites_relationships`.`id` in (64312, 82715, 243589, 269540, 306929, 310527, 327135, 328598, 329493, 1024177)

Backtrace

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

CitySqlRepository.php#104aviatickets1.22msselect * from `cities` where `cities`.`id` = 6074 limit 1

Bindings	0: 6074
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#52aviatickets990μsselect * from `offers` where `origin_city_id` = 5650 and `destination_city_id` = 5628

Bindings	0: 5650 1: 5628
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#447aviatickets1.99ms

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

Bindings	0: 5650 1: 307313 2: 224 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.08msselect * from `cities` where `cities`.`id` in (5650)

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.07msselect * from `cities` where `cities`.`id` in (5632, 5644, 5723)

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#447aviatickets950μsselect * from `sites_relationships` where `sites_relationships`.`id` in (307314, 307315, 307316)

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#125aviatickets910μsselect * from `countries` where `countries`.`id` = 15 limit 1

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

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

Bindings	0: 73
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.59ms

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

Bindings	0: 5650 1: 224 2: 0 3: 0 4: 307314
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 `cities` where `cities`.`id` in (5650)

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.08msselect * from `cities` where `cities`.`id` in (1115, 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#412aviatickets880μsselect * from `sites_relationships` where `sites_relationships`.`id` in (307107, 307244)

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 `countries` where `countries`.`id` in (92, 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.32ms

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

Bindings	0: 5628 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 (5628)

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 (1115, 2686, 3430, 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.02msselect * from `countries` where `countries`.`id` in (92, 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#149aviatickets1.17msselect * from `sites_relationships` where `sites_relationships`.`id` in (304707, 304762, 304784, 304787, 304814)

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

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

Bindings	0: 5650 1: 224 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#359aviatickets960μsselect * from `cities` where `cities`.`id` in (5650)

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 (4610)

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#359aviatickets910μsselect * from `sites_relationships` where `sites_relationships`.`id` in (307259)

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#359aviatickets920μsselect * from `countries` where `countries`.`id` in (224)

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#39aviatickets1ms

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

Bindings	0: 5650 1: 5628
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#39aviatickets940μsselect * from `airports` where `airports`.`id` in (6020)

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#39aviatickets910μsselect * from `airports` where `airports`.`id` in (6047)

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#39aviatickets970μsselect * from `airlines` where `airlines`.`id` in (3204, 3768, 259328)

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

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

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

Bindings	0: 5628 1: 5650
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#520aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` in (304868)

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

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

Bindings	0: 5628
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#28aviatickets1.11msselect * from `cities` where `cities`.`id` = 5650 limit 1

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

LocalRouteRepository.php#175aviatickets960μsselect * 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.18msselect * from `cities` where `cities`.`id` in (537, 779, 3448, 3796, 4539)

Backtrace

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

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

Backtrace

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

LocalRouteRepository.php#175aviatickets1.03msselect * from `countries` where `countries`.`id` in (17, 70, 79, 92, 105)

Backtrace

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

LocalRouteRepository.php#175aviatickets1.24msselect * 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.85ms

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.16msselect * 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.38msselect * 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#149aviatickets1.21msselect * 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#149aviatickets920μs

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

Backtrace

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

App\Avia\Infrastructure\Model\LocalRoute: 128LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 100City.php#?
App\Avia\Infrastructure\Model\Timetable: 91Timetable.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 79SitesRelationship.php#?
App\Avia\Infrastructure\Model\Airline: 20Airline.php#?
App\Avia\Infrastructure\Model\Country: 19Country.php#?
App\Avia\Infrastructure\Model\Airport: 2Airport.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

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

_token: iN4V3G1JGV5knTyTpnm7glfjvKKg9eXF2ouyBZN1
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-skopje-to-sarajevo-skp-sjj?_url=%2Fc...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-skopje-to-sarajevo-skp-sjj

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-skopje-to-sarajevo-skp-sjj"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlhTUUpFNkZWQ2luajFjWWFXWHJyWlE9PSIsInZhbHVlIjoiL2ViTDZzcktWSG1BZmFJSHhLZ2Y0cUxnTFU2OE04V3NKcXJPYmVuU2hFOXZONzNqRDVzNXhrZ0s1MHpUZGNPUkdrYVJ5eDkrZ0tPN0dEb2thYmpMSGRoMlRpSnNZa2JmQmUrdkVwZGV1Rm56TXNsL0JCZ0xPQmZpV3FYWHcyQVQiLCJtYWMiOiIxNDQ0OGJjODA3NTg1YjM0ODY0NDk2MjMyNmU3MmVmNTIxZDU4YzQ1ZTk3MWVlOWI0MmQwNDc0ODVjN2RlNzQ1IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjhnWlo5ODVUZjVVTkxKd3I4QjJIYnc9PSIsInZhbHVlIjoibUd6SVB3b21KL1c3L1h6cVQ3MWxDMitzay9VNGNCNnQ0OHZpdERua3Nkc0FpMG5HMHNsNHBET0xDM1E1QlIxcUI4ODg4NlUvTVM1QlVyM2tMYXgzVWRrL21TM1ZYVkRPM2JFVXRKdUZqWFBSZGZkVTl1YkxuejJRV0VOa2ZLdHgiLCJtYWMiOiI2NTQ0ZGUwZmY1NzlmYzA4NjEwNGVlNzUxMGMzYzA0MGJkNjE3ODg1YTk3ZDI0YjcyOGE5YzA5NWM4MzU5YTEwIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlhTUUpFNkZWQ2luajFjWWFXWHJyWlE9PSIsInZhbHVlIjoiL2ViTDZzcktWSG1BZmFJSHhLZ2Y0cUxnTFU2OE04V3NKcXJPYmVuU2hFOXZONzNqRDVzNXhrZ0s1MHpUZGNPUkdrYVJ5e ▶"
  ]
  "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" => "iN4V3G1JGV5knTyTpnm7glfjvKKg9eXF2ouyBZN1"
  "lowcostclub_session" => "wGFPz8hZmBSIXCv3ZXttsopsUrT1o9Pf404daalb"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 13:13:08 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""ad906d917fd1d849026a811478687a9f""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklLc0EvL2tTNElCdkF4RjZYbUlaUHc9PSIsInZhbHVlIjoiSWpZSmZtVUdTdXp3aU50NENod0FneVU2Sko0bk92K0ZmY1dEbWRjSkVyWVhpa3BnQjMwaXpwM2hXZFp1Q3paOURadEhQbHF0RjdPc1B4Z2U4eGxRdHlOVElNQ2xhejNnQVd0RnR4YklqSFJoWmxJSGdJMm1VQ0k4UUJZTTZQUkgiLCJtYWMiOiIxNmIzOGE2ZDRmMjk5NTNkODk0YWExNjU0ZTRmZDM4MTJlY2NlMzIxYmJhNGFiM2JkNDYxMDQ1YWRmMzczOGRjIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 15:13:08 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IklLc0EvL2tTNElCdkF4RjZYbUlaUHc9PSIsInZhbHVlIjoiSWpZSmZtVUdTdXp3aU50NENod0FneVU2Sko0bk92K0ZmY1dEbWRjSkVyWVhpa3BnQjMwaXpwM2hXZFp1Q3paOURadEhQb ▶"
    1 => "lowcostclub_session=eyJpdiI6IjZCR0xGTEEvZlFUNU5BWHUwdmlqekE9PSIsInZhbHVlIjoiRS9MeUdHK25aOTNtTTdCaUJXQkFvNnVsZnVFYlM3c1pMbDR0aVY2VzZlYU05WkpwVU12R25WRnJVbi8vaFlZT3F3aFA2OTBqTW1qUjZNcTFRWGxhbFZZWWkyd3RZeTVaRUhlbW1rdzZzVGo1UW5tbTI3YldCMkRkNk1ScEpWdGwiLCJtYWMiOiIwNWQ0OWU5YmVmOTQ4OTk2NmI1ZWMzZjNjZjU1ZjkyMjcwNTA1NGY0NjRhZGRhMDcwMTkzNmY3ZDc1MTc0MDM1IiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 15:13:08 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IjZCR0xGTEEvZlFUNU5BWHUwdmlqekE9PSIsInZhbHVlIjoiRS9MeUdHK25aOTNtTTdCaUJXQkFvNnVsZnVFYlM3c1pMbDR0aVY2VzZlYU05WkpwVU12R25WRnJVbi8vaFlZ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklLc0EvL2tTNElCdkF4RjZYbUlaUHc9PSIsInZhbHVlIjoiSWpZSmZtVUdTdXp3aU50NENod0FneVU2Sko0bk92K0ZmY1dEbWRjSkVyWVhpa3BnQjMwaXpwM2hXZFp1Q3paOURadEhQbHF0RjdPc1B4Z2U4eGxRdHlOVElNQ2xhejNnQVd0RnR4YklqSFJoWmxJSGdJMm1VQ0k4UUJZTTZQUkgiLCJtYWMiOiIxNmIzOGE2ZDRmMjk5NTNkODk0YWExNjU0ZTRmZDM4MTJlY2NlMzIxYmJhNGFiM2JkNDYxMDQ1YWRmMzczOGRjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 15:13:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IklLc0EvL2tTNElCdkF4RjZYbUlaUHc9PSIsInZhbHVlIjoiSWpZSmZtVUdTdXp3aU50NENod0FneVU2Sko0bk92K0ZmY1dEbWRjSkVyWVhpa3BnQjMwaXpwM2hXZFp1Q3paOURadEhQb ▶"
    1 => "lowcostclub_session=eyJpdiI6IjZCR0xGTEEvZlFUNU5BWHUwdmlqekE9PSIsInZhbHVlIjoiRS9MeUdHK25aOTNtTTdCaUJXQkFvNnVsZnVFYlM3c1pMbDR0aVY2VzZlYU05WkpwVU12R25WRnJVbi8vaFlZT3F3aFA2OTBqTW1qUjZNcTFRWGxhbFZZWWkyd3RZeTVaRUhlbW1rdzZzVGo1UW5tbTI3YldCMkRkNk1ScEpWdGwiLCJtYWMiOiIwNWQ0OWU5YmVmOTQ4OTk2NmI1ZWMzZjNjZjU1ZjkyMjcwNTA1NGY0NjRhZGRhMDcwMTkzNmY3ZDc1MTc0MDM1IiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 15:13:08 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IjZCR0xGTEEvZlFUNU5BWHUwdmlqekE9PSIsInZhbHVlIjoiRS9MeUdHK25aOTNtTTdCaUJXQkFvNnVsZnVFYlM3c1pMbDR0aVY2VzZlYU05WkpwVU12R25WRnJVbi8vaFlZ ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "iN4V3G1JGV5knTyTpnm7glfjvKKg9eXF2ouyBZN1"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-skopje-to-sarajevo-skp-sjj?_url=%2Fcheap-flights-from-skopje-to-sarajevo-skp-sjj"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-06 13:13:08	GET	/cheap-flights-from-skopje-to-sarajevo-skp-sjj	53 86 440 4

1 x Application (94.45%)	462ms
1 x Booting (5.55%)	27.17ms

Cheap flights Skopje — Sarajevo (SKP — SJJ)

Choose your dates to find the flight:

Good to know - Cheap tickets Skopje — Sarajevo

Popular airlines flying Skopje — Sarajevo

Airlines with direct flights

Other airlines flying with transfers

Routes from nearby cities to Sarajevo

Popular International routes from Skopje

Popular routes from Sarajevo

Popular domestic routes from Skopje

Related pages

Select your currency

All currencies

Select your language

All languages