The most frequent flight to Sofia is from Detroit. The cheapest airfare can be purchased with a flight from Toronto from $244. The nearest airports from London with a flight to Sofia are in Sudbury.

Popular International routes from London

London — Cancun

from $170 one-way

London — Orlando

from $120 one-way

London — Salvador

from $1,651 round-trip

London — Stockholm

from $998 one-way

London — Stuttgart

from $997 round-trip

Popular routes from Sofia

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

Sofia — Moscow

from $104 one-way

Sofia — Saint Petersburg

from $191 one-way

Sofia — Paris

from $21 one-way

Sofia — Yerevan

from $35 one-way

Sofia — Tokyo

from $450 one-way

Popular domestic routes from London

from $143 one-way

from $232 one-way

from $318 one-way

from $137 one-way

from $176 one-way

Return flights Sofia – London

Messages Timeline Exceptions Views48 Route Queries60 Models281 Mails Gate N+1 Queries1 Session Request

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

Booting (26.58ms)time
Application (362ms)time
1 x Application (93.15%)
362ms
1 x Booting (6.85%)
26.58ms

48 templates were rendered

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

60 statements were executed (10 duplicates)Show only duplicates89.33ms

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.97msselect * from `sites_relationships` where `us` = 'cheap-flights-from-london-to-sofia-yxu-sof' limit 1

Bindings	0: cheap-flights-from-london-to-sofia-yxu-sof
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.05msselect * from `flights_by` where `flights_by`.`id` = '374588' 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.1msselect * from `cities` where `cities`.`id` = 9300 limit 1

Bindings	0: 9300
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.02msselect * from `countries` where `countries`.`id` = 6 limit 1

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

Bindings	0: 5723
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.52msselect * from `countries` where `countries`.`id` = 73 limit 1

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

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

Bindings	0: 374588
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.13msselect * 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.19ms

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

Bindings	0: 9300 1: 5723 2: 2025-04-30 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.71msselect * from `monthly_price_statistics` where `origin_city_id` = 9300 and `destination_city_id` = 5723 limit 1

Bindings	0: 9300 1: 5723
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.57ms

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

Bindings	0: 9300 1: 5723
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#502aviatickets950μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 9300

Bindings	0: 9300
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.52msselect distinct `airline_id` from `timetables` where `origin_city_id` = 5723

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

LocalRouteRepository.php#558aviatickets1.11ms

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

Bindings	0: 9300 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.82ms

select * from `flights_by` where `origin_city_id` in (7287, 8381, 7344, 9259, 4934, 8476, 8364, 9199, 7381, 9181) and `destination_city_id` = 5723 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 7287 1: 8381 2: 7344 3: 9259 4: 4934 5: 8476 6: 8364 7: 9199 8: 7381 9: 9181 10: 5723 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.27msselect * from `cities` where `cities`.`id` in (4934, 7287, 7344, 8364, 8381, 9199, 9259)

Backtrace

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

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

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

select * from `sites_relationships` where `sites_relationships`.`id` in (70292, 92797, 263007, 372344, 498317, 1177929, 1285601)

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

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

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

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

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

OfferSqlRepository.php#52aviatickets1.31msselect * from `offers` where `origin_city_id` = 9300 and `destination_city_id` = 5723

Bindings	0: 9300 1: 5723
Backtrace	app/Avia/Infrastructure/Repository/OfferSqlRepository.php:52 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/OfferSqlRepository.php:57 app/Http/Controllers/RoutesController.php:205

LocalRouteRepository.php#447aviatickets2.22ms

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

Bindings	0: 9300 1: 374588 2: 6 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.01msselect * from `cities` where `cities`.`id` in (9300)

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 (5798, 5824, 8821)

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#447aviatickets960μsselect * from `sites_relationships` where `sites_relationships`.`id` in (374589, 374590, 374591)

Backtrace

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

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

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

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

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

Bindings	0: 9300 1: 6 2: 0 3: 0 4: 374589
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.14msselect * from `cities` where `cities`.`id` in (9300)

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

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#412aviatickets800μsselect * from `sites_relationships` where `sites_relationships`.`id` in (374442, 374550)

Backtrace

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

LocalRouteRepository.php#412aviatickets940μsselect * from `countries` where `countries`.`id` in (92, 112)

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

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

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

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.07msselect * from `cities` where `cities`.`id` in (1811, 3505, 4081, 4805, 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#149aviatickets2.34msselect * from `countries` where `countries`.`id` in (120, 124, 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 (310195, 310331, 310384, 310438, 310597)

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

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

Bindings	0: 9300 1: 6 2: 0 3: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets1.06msselect * from `cities` where `cities`.`id` in (9300)

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.39msselect * from `cities` where `cities`.`id` in (3073, 7225, 7241, 9246, 9286)

Backtrace

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

LocalRouteRepository.php#359aviatickets1.09msselect * from `sites_relationships` where `sites_relationships`.`id` in (374619, 374621, 374622, 374623, 374635)

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

Backtrace

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

TimetableRepository.php#39aviatickets1.11ms

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

Bindings	0: 9300 1: 5723
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.2ms

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

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

Bindings	0: 5723 1: 9300
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.07msselect * from `sites_relationships` where `sites_relationships`.`id` in (310648)

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

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

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

Bindings	0: 9300
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#175aviatickets1.17msselect * 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.15msselect * 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.11msselect * 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.56msselect * 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.07msselect * 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#149aviatickets4.31ms

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#149aviatickets3.67msselect * 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.27msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3505, 3951, 4081, 8389)

Backtrace

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

LocalRouteRepository.php#149aviatickets3.81msselect * 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#149aviatickets2.07ms

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

Backtrace

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

App\Avia\Infrastructure\Model\Timetable: 115Timetable.php#?
App\Avia\Infrastructure\Model\City: 56City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 49LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 40SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 20Country.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

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

_token: 5a2mXAfYELSFwhJAq0Oxuk8YrBez5ZZ5mRX5uAE0
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-london-to-sofia-yxu-sof?_url=%2Fchea...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-london-to-sofia-yxu-sof

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-london-to-sofia-yxu-sof"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InpxekpnN2pDZXNXa045WUtYbXFQOWc9PSIsInZhbHVlIjoiVUNmTUhPa0J3Y3NGK0o5eXo2Vms1Tzc3cDVQM2UxU1hOazRDdlE2d3NxOFZPRkJVRzd5WEFULytXK3g3NWpZNjZzSWZiSW1tMW9NTnhGejJick96ZzBad2I5Tnk1NTZXa2JSa2Zab3ZlUlkvWW5oK3lodnBmb3VDaTNZN0ptL2MiLCJtYWMiOiI5ZGJjNDBkNjljMjlmYzY1ZDFjMTExMTRkNWY0NTJhNTk5NzdkMWFmOTU2OGU5YzU5ZTE4OWM0NDFhMmI3NzFmIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjBzaGlHL0xRcmkvVlhMZGRabGNrSUE9PSIsInZhbHVlIjoieUg1TEY1UmVCS1ZyQUZucWoxd2xsVHZleFFJaXgxT2FTK0d1NytVZXlGQWNLaVVJTFk0NzBYNEgvNDRWcVBEM3lnVUVHRUoxdXdKNEV1NVI0cEFuV1c3MzVsYk1qbW1UZHlEZ3NaaTRYVTZQS3BHaCt1a0NPeVFjaDZGdDZRVlYiLCJtYWMiOiJhNTY4MTRjODZhOTQyMDJiY2RlOTRmOGVhZWM2ZDAyNzBiMWQzMmY0NzY3Y2QxMjUwYjI2Njg5ZmZmZTE0NGFmIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InpxekpnN2pDZXNXa045WUtYbXFQOWc9PSIsInZhbHVlIjoiVUNmTUhPa0J3Y3NGK0o5eXo2Vms1Tzc3cDVQM2UxU1hOazRDdlE2d3NxOFZPRkJVRzd5WEFULytXK3g3NWpZNjZzSWZiS ▶"
  ]
  "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" => "5a2mXAfYELSFwhJAq0Oxuk8YrBez5ZZ5mRX5uAE0"
  "lowcostclub_session" => "rn9BN1YzQCutauRd0Lj1u070DgpqiFl4H6btccFX"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Fri, 02 May 2025 12:38:41 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""edc59b64e19283f037a9f859b93439b1""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBnTjVBV21oV25yejZjY3BHdVRNaHc9PSIsInZhbHVlIjoiLzJPcEtHZyticEhHOWdBRjNZbkNKWlFocTc0VSs1a2ljODVDYjBXRkVySGxHQy9FRjdXQVhIRjZiQ25ZRGczTnRiM3dFeG93UmpYQ3d1ek1jdFN1MkkvM3kydUdrWnpERnJNN2gvVG5RNWp2aEMxcFJuTzVTdkNwekwxREN6akkiLCJtYWMiOiJmNjFiYWM0NTU2NDI5YThhYjVlOGVkMTgwNGEzNTkwMDBmOTVhOGEzZjU2YTRlMGI2OTM1NTQ5ZGEzYzhmYmEyIiwidGFnIjoiIn0%3D; expires=Fri, 02 May 2025 14:38:41 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InBnTjVBV21oV25yejZjY3BHdVRNaHc9PSIsInZhbHVlIjoiLzJPcEtHZyticEhHOWdBRjNZbkNKWlFocTc0VSs1a2ljODVDYjBXRkVySGxHQy9FRjdXQVhIRjZiQ25ZRGczTnRiM3dFe ▶"
    1 => "lowcostclub_session=eyJpdiI6IlRpVXFjZXVOTFo5Y0s1YkZSTmkxQ0E9PSIsInZhbHVlIjoiellzTmcvKzVYaU1pMFZZMjhsYkFIL05yN2ZRalAraHBCeUhyR0ZxNkxoS2NOcUZoNWJXRTc5MFRva284L1RxWGZubkxOcStCZ2xSQlBoK3N6eTNrUnQ0YTJBRFJTWnVUTzJyYnlHdHRrd1JYVW9IQXB2S3VVYWtrOGV5b2ZnVEsiLCJtYWMiOiIzMTkyNjFmNTgzNzUzYzhmMTg5Y2IxNGFjMzYwOGY5NmE2Zjc5MmMzOWJmN2UxZWMxOTQ2YTQ4ZWI1MzZhNGU2IiwidGFnIjoiIn0%3D; expires=Fri, 02 May 2025 14:38:41 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlRpVXFjZXVOTFo5Y0s1YkZSTmkxQ0E9PSIsInZhbHVlIjoiellzTmcvKzVYaU1pMFZZMjhsYkFIL05yN2ZRalAraHBCeUhyR0ZxNkxoS2NOcUZoNWJXRTc5MFRva284L1Rx ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBnTjVBV21oV25yejZjY3BHdVRNaHc9PSIsInZhbHVlIjoiLzJPcEtHZyticEhHOWdBRjNZbkNKWlFocTc0VSs1a2ljODVDYjBXRkVySGxHQy9FRjdXQVhIRjZiQ25ZRGczTnRiM3dFeG93UmpYQ3d1ek1jdFN1MkkvM3kydUdrWnpERnJNN2gvVG5RNWp2aEMxcFJuTzVTdkNwekwxREN6akkiLCJtYWMiOiJmNjFiYWM0NTU2NDI5YThhYjVlOGVkMTgwNGEzNTkwMDBmOTVhOGEzZjU2YTRlMGI2OTM1NTQ5ZGEzYzhmYmEyIiwidGFnIjoiIn0%3D; expires=Fri, 02-May-2025 14:38:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InBnTjVBV21oV25yejZjY3BHdVRNaHc9PSIsInZhbHVlIjoiLzJPcEtHZyticEhHOWdBRjNZbkNKWlFocTc0VSs1a2ljODVDYjBXRkVySGxHQy9FRjdXQVhIRjZiQ25ZRGczTnRiM3dFe ▶"
    1 => "lowcostclub_session=eyJpdiI6IlRpVXFjZXVOTFo5Y0s1YkZSTmkxQ0E9PSIsInZhbHVlIjoiellzTmcvKzVYaU1pMFZZMjhsYkFIL05yN2ZRalAraHBCeUhyR0ZxNkxoS2NOcUZoNWJXRTc5MFRva284L1RxWGZubkxOcStCZ2xSQlBoK3N6eTNrUnQ0YTJBRFJTWnVUTzJyYnlHdHRrd1JYVW9IQXB2S3VVYWtrOGV5b2ZnVEsiLCJtYWMiOiIzMTkyNjFmNTgzNzUzYzhmMTg5Y2IxNGFjMzYwOGY5NmE2Zjc5MmMzOWJmN2UxZWMxOTQ2YTQ4ZWI1MzZhNGU2IiwidGFnIjoiIn0%3D; expires=Fri, 02-May-2025 14:38:41 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlRpVXFjZXVOTFo5Y0s1YkZSTmkxQ0E9PSIsInZhbHVlIjoiellzTmcvKzVYaU1pMFZZMjhsYkFIL05yN2ZRalAraHBCeUhyR0ZxNkxoS2NOcUZoNWJXRTc5MFRva284L1Rx ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "5a2mXAfYELSFwhJAq0Oxuk8YrBez5ZZ5mRX5uAE0"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-london-to-sofia-yxu-sof?_url=%2Fcheap-flights-from-london-to-sofia-yxu-sof"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-02 12:38:41	GET	/cheap-flights-from-london-to-sofia-yxu-sof	48 60 281 1

1 x Application (93.15%)	362ms
1 x Booting (6.85%)	26.58ms

Cheap flights London — Sofia (YXU — SOF)

Choose your dates to find the flight:

Good to know - Cheap tickets London — Sofia

Routes from nearby cities to Sofia

Popular International routes from London

Popular routes from Sofia

Popular domestic routes from London

Related pages

Select your currency

All currencies

Select your language

All languages