Cheap flights Dubai — Sofia (DXB — SOF)

  1. Flights
  2. United Arab Emirates
  3. Dubai

Good to know - Cheap tickets Dubai — Sofia

Cheapest flight found $226
Minimal flight time 5h 0m
Flight distance 3490 km
Most popular airline flydubai

Popular airlines flying Dubai — Sofia

Flight Dubai – Sofia is served by 40 airlines.  4 airlines operate direct flights.


Airlines with direct flights


Other airlines flying with transfers

Routes from nearby cities to Sofia

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

search

Al Ain — Sofia

search

Abu Dhabi — Sofia

search

Doha — Sofia

search

Ras al-Khaimah — Sofia

search

Muscat — Sofia

search

Sharjah — Sofia

The most frequent flight to Sofia is from Sharjah. The cheapest airfare can be purchased with a flight from Abu Dhabi from $78. The nearest airports from Dubai with a flight to Sofia are in Doha.

Popular International routes from Dubai

search

Dubai — Moscow

search

Dubai — Male

search

Dubai — Sorong

search

Dubai — Southampton

search

Dubai — Sapporo

Popular routes from Sofia

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

search

Sofia — Moscow

search

Sofia — Saint Petersburg

search

Sofia — Paris

search

Sofia — Yerevan

search

Sofia — Tokyo

Popular domestic routes from Dubai

search

Dubai — Abu Dhabi

search

Dubai — Sharjah

search

Dubai — Ras al-Khaimah

search

Dubai — Al-fujairah

search

Dubai — Al Ain

Related pages

Return flights Sofia – Dubai

Schedule of direct flights Dubai — Sofia

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

MessagesTimelineExceptionsViews52RouteQueries80Models608MailsGateN+1 Queries3SessionRequest
Request history8.3.0PHP Version546msRequest Duration5MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (22.58ms)time
    • Application (523ms)time
    • 1 x Application (95.86%)
      523ms
      1 x Booting (4.14%)
      22.58ms
      52 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
      • 5x 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
      80 statements were executed (38 duplicates)Show only duplicates154ms
      • 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#34aviatickets9.26msselect * from `sites_relationships` where `us` = 'cheap-flights-from-dubai-to-sofia-dxb-sof' limit 1
        Bindings
        • 0: cheap-flights-from-dubai-to-sofia-dxb-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.79msselect * from `flights_by` where `flights_by`.`id` = '96196' 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.05msselect * from `cities` where `cities`.`id` = 8389 limit 1
        Bindings
        • 0: 8389
        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.41msselect * from `countries` where `countries`.`id` = 242 limit 1
        Bindings
        • 0: 242
        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#137aviatickets3.28msselect * 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.56msselect * 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#33aviatickets2.59msselect * from `sites_relationships` where `sites_relationships`.`id` = 96196 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 96196
        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#31aviatickets960μsselect * from `countries` where `code` = '' limit 1
        Bindings
        • 0: 
        Backtrace
        • app/Avia/Infrastructure/Repository/CountriesRepository.php:31
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:61
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:43
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:56
        • app/Avia/Infrastructure/Model/LocalRoute.php:190
      • RouteRepository.php#42aviatickets1.64msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 8389 and `destination_id` = 5723 and `date_update` >= '2025-05-05 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 8389
        • 1: 5723
        • 2: 2025-05-05 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.39msselect * from `monthly_price_statistics` where `origin_city_id` = 8389 and `destination_city_id` = 5723 limit 1
        Bindings
        • 0: 8389
        • 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.2msselect * from `timetables` where `origin_city_id` = 8389 and `destination_city_id` = 5723 order by `time_origin` asc limit 1000
        Bindings
        • 0: 8389
        • 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#470aviatickets1.32msselect * from `airlines` where `airlines`.`id` in (1385, 5714, 5407273, 146726240)
        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.89msselect distinct `airline_id` from `timetables` where `origin_city_id` = 8389
        Bindings
        • 0: 8389
        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.87msselect 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
      • AirlineSqlRepository.php#90aviatickets2.61msselect * from `airlines` where `id` in (95, 229, 331, 926, 1352, 1864, 2146, 2256, 2338, 2949, 2987, 3314, 3630, 3915, 4078, 4543, 4557, 4851, 4929, 5017, 5075, 5432, 11847, 11914, 17859, 17906, 18268, 59953, 65538, 65539, 65551, 68971, 157155, 259328, 642059, 1321150, 1476559, 3737132, 5438487, 17141650) order by `name` asc
        Bindings
        • 0: 95
        • 1: 229
        • 2: 331
        • 3: 926
        • 4: 1352
        • 5: 1864
        • 6: 2146
        • 7: 2256
        • 8: 2338
        • 9: 2949
        • 10: 2987
        • 11: 3314
        • 12: 3630
        • 13: 3915
        • 14: 4078
        • 15: 4543
        • 16: 4557
        • 17: 4851
        • 18: 4929
        • 19: 5017
        • 20: 5075
        • 21: 5432
        • 22: 11847
        • 23: 11914
        • 24: 17859
        • 25: 17906
        • 26: 18268
        • 27: 59953
        • 28: 65538
        • 29: 65539
        • 30: 65551
        • 31: 68971
        • 32: 157155
        • 33: 259328
        • 34: 642059
        • 35: 1321150
        • 36: 1476559
        • 37: 3737132
        • 38: 5438487
        • 39: 17141650
        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#558aviatickets2.27msselect destination_city_id from `flights_by` where `origin_city_id` = 8389 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8389
        • 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.03msselect * from `flights_by` where `origin_city_id` in (5586, 3175, 1892, 14, 347, 2994, 623, 3691, 3843, 1557) and `destination_city_id` = 5723 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5586
        • 1: 3175
        • 2: 1892
        • 3: 14
        • 4: 347
        • 5: 2994
        • 6: 623
        • 7: 3691
        • 8: 3843
        • 9: 1557
        • 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.18msselect * from `cities` where `cities`.`id` in (14, 347, 1557, 3175, 3843, 5586)
        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.04msselect * 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#73aviatickets890μsselect * from `sites_relationships` where `sites_relationships`.`id` in (21996, 89713, 203484, 301557, 1126492, 1148651)
        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.45msselect destination_city_id from `flights_by` where `origin_city_id` = 8389 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8389
        • 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#73aviatickets4.16msselect * from `flights_by` where `origin_city_id` in (5586, 3175, 1892, 14, 347, 2994, 623, 3691, 3843, 1557) and `destination_city_id` = 5723 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5586
        • 1: 3175
        • 2: 1892
        • 3: 14
        • 4: 347
        • 5: 2994
        • 6: 623
        • 7: 3691
        • 8: 3843
        • 9: 1557
        • 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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.81msselect * from `cities` where `cities`.`id` in (14, 347, 1557, 3175, 3843, 5586)
        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.38msselect * 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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets4.11msselect * from `sites_relationships` where `sites_relationships`.`id` in (21996, 89713, 203484, 301557, 1126492, 1148651)
        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.06msselect * from `cities` where `cities`.`id` = 1557 limit 1
        Bindings
        • 0: 1557
        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.34msselect destination_city_id from `flights_by` where `origin_city_id` = 8389 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8389
        • 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.97msselect * from `flights_by` where `origin_city_id` in (5586, 3175, 1892, 14, 347, 2994, 623, 3691, 3843, 1557) and `destination_city_id` = 5723 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5586
        • 1: 3175
        • 2: 1892
        • 3: 14
        • 4: 347
        • 5: 2994
        • 6: 623
        • 7: 3691
        • 8: 3843
        • 9: 1557
        • 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.36msselect * from `cities` where `cities`.`id` in (14, 347, 1557, 3175, 3843, 5586)
        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.53msselect * 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets2.32msselect * from `sites_relationships` where `sites_relationships`.`id` in (21996, 89713, 203484, 301557, 1126492, 1148651)
        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#104aviatickets2.19msselect * from `cities` where `cities`.`id` = 347 limit 1
        Bindings
        • 0: 347
        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#558aviatickets2.61msselect destination_city_id from `flights_by` where `origin_city_id` = 8389 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8389
        • 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#73aviatickets3.07msselect * from `flights_by` where `origin_city_id` in (5586, 3175, 1892, 14, 347, 2994, 623, 3691, 3843, 1557) and `destination_city_id` = 5723 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5586
        • 1: 3175
        • 2: 1892
        • 3: 14
        • 4: 347
        • 5: 2994
        • 6: 623
        • 7: 3691
        • 8: 3843
        • 9: 1557
        • 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:123
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.36msselect * from `cities` where `cities`.`id` in (14, 347, 1557, 3175, 3843, 5586)
        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.93msselect * 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:123
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.02msselect * from `sites_relationships` where `sites_relationships`.`id` in (21996, 89713, 203484, 301557, 1126492, 1148651)
        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.26msselect * from `cities` where `cities`.`id` = 5586 limit 1
        Bindings
        • 0: 5586
        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.1msselect destination_city_id from `flights_by` where `origin_city_id` = 8389 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8389
        • 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.14msselect * from `flights_by` where `origin_city_id` in (5586, 3175, 1892, 14, 347, 2994, 623, 3691, 3843, 1557) and `destination_city_id` = 5723 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5586
        • 1: 3175
        • 2: 1892
        • 3: 14
        • 4: 347
        • 5: 2994
        • 6: 623
        • 7: 3691
        • 8: 3843
        • 9: 1557
        • 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.06msselect * from `cities` where `cities`.`id` in (14, 347, 1557, 3175, 3843, 5586)
        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.87msselect * 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets860μsselect * from `sites_relationships` where `sites_relationships`.`id` in (21996, 89713, 203484, 301557, 1126492, 1148651)
        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.68msselect * from `cities` where `cities`.`id` = 347 limit 1
        Bindings
        • 0: 347
        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#52aviatickets960μsselect * from `offers` where `origin_city_id` = 8389 and `destination_city_id` = 5723
        Bindings
        • 0: 8389
        • 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#447aviatickets1.34msselect * from `flights_by` where `origin_city_id` = 8389 and `id` > 96196 and `destination_country_id` <> 242 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 8389
        • 1: 96196
        • 2: 242
        • 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#447aviatickets910μsselect * from `cities` where `cities`.`id` in (8389)
        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#447aviatickets1msselect * from `cities` where `cities`.`id` in (5732, 5744, 6878)
        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.94msselect * from `sites_relationships` where `sites_relationships`.`id` in (96197, 96198, 96201)
        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` = 114 limit 1
        Bindings
        • 0: 114
        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.38msselect * from `flights_by` where `origin_city_id` = 8389 and `destination_country_id` <> 242 and (`price_one_way` > 0 or `price` > 0) and `id` not in (96197) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 8389
        • 1: 242
        • 2: 0
        • 3: 0
        • 4: 96197
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets900μsselect * from `cities` where `cities`.`id` in (8389)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#412aviatickets2.3msselect * from `cities` where `cities`.`id` in (4006, 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#412aviatickets900μsselect * from `sites_relationships` where `sites_relationships`.`id` in (95903, 95912)
        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#412aviatickets960μsselect * from `countries` where `countries`.`id` in (56, 248)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:412
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:417
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:209
      • LocalRouteRepository.php#149aviatickets2.25msselect * 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#149aviatickets2.94msselect * 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#149aviatickets3.7msselect * 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.09msselect * 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#149aviatickets6.78msselect * 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.36msselect * from `flights_by` where `origin_city_id` = 8389 and `destination_country_id` = 242 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 8389
        • 1: 242
        • 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#359aviatickets970μsselect * from `cities` where `cities`.`id` in (8389)
        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.11msselect * from `cities` where `cities`.`id` in (14, 347, 1892, 3175, 5586)
        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.12msselect * from `sites_relationships` where `sites_relationships`.`id` in (95282, 96116, 96169, 804003, 1045606)
        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#359aviatickets1msselect * from `countries` where `countries`.`id` in (242)
        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.26msselect * from `timetables` where `origin_city_id` = 8389 and `destination_city_id` = 5723 order by `time_origin` asc limit 10
        Bindings
        • 0: 8389
        • 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#39aviatickets1.05msselect * from `airports` where `airports`.`id` in (9997)
        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#39aviatickets980μsselect * from `airports` where `airports`.`id` in (1904, 9353)
        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#39aviatickets1.05msselect * from `airlines` where `airlines`.`id` in (1385, 5714, 5407273, 146726240)
        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.29msselect * from `timetables` where `origin_city_id` = 8389 and `destination_city_id` = 5723 order by `travel_time` asc limit 1
        Bindings
        • 0: 8389
        • 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.07msselect * from `flights_by` where `origin_city_id` = 5723 and `destination_city_id` = 8389 limit 1
        Bindings
        • 0: 5723
        • 1: 8389
        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#520aviatickets840μsselect * from `sites_relationships` where `sites_relationships`.`id` in (310182)
        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
      • RoutesController.php#547aviatickets1.15msselect * 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
      • RoutesController.php#548aviatickets1.07msselect * from `cities` where `cities`.`id` = 8389 limit 1
        Bindings
        • 0: 8389
        Backtrace
        • app/Http/Controllers/RoutesController.php:548
        • 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` = 8389 limit 1
        Bindings
        • 0: 8389
        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#175aviatickets1msselect * 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.91msselect * 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#175aviatickets9.91msselect * 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.99msselect * 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#175aviatickets4.32msselect * 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
      App\Avia\Infrastructure\Model\Timetable
      310Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      103LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      74City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      54SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Airline
      48Airline.php#?
      App\Avia\Infrastructure\Model\Country
      15Country.php#?
      App\Avia\Infrastructure\Model\Airport
      3Airport.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...
          _token
          rshYo5nrHqhhGxeBqwUUWB6aVPeumQpadnX1guLR
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-dubai-to-sofia-dxb-sof?_url=%2Fcheap...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-dubai-to-sofia-dxb-sof
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
            0 of 0   
          array:1 [▼
  "_url" => "/cheap-flights-from-dubai-to-sofia-dxb-sof"
]
          request_request
          []
          request_headers
            0 of 0   
          array:15 [▼
  "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
          []
          response_headers
            0 of 0   
          array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 05:12:22 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""db277a607e0d8dad4345ceaac72f640a""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imt1TjFQZGczeE5laXZPa2tOV0h3ckE9PSIsInZhbHVlIjoidDBPdEtJWFhsM3RzNE92d2xCYmY5cFZ3NWNhUFNoQ2tzaXdaUlg5MnFlem0zdlBYQ09UWVQzemRDK0gyRmdwNzJxaVdLSXk4ek1LOXVhdnNxTHhwMVVGUU5JSThWL0tvYjRwUWtaK0pQVXZlenVtOWJreXhqQTRXd0lGcVdFcDgiLCJtYWMiOiJhZGZlMWQyOWZkMGE3NzBlNDcyOGFmMWQ2N2FhNDgwYWQ1NGFkMTdhNmUzNDM4ZDM4ODM2YzVmOTE1Mzk0OWM5IiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 07:12:22 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Imt1TjFQZGczeE5laXZPa2tOV0h3ckE9PSIsInZhbHVlIjoidDBPdEtJWFhsM3RzNE92d2xCYmY5cFZ3NWNhUFNoQ2tzaXdaUlg5MnFlem0zdlBYQ09UWVQzemRDK0gyRmdwNzJxaVdLS ▶"
    1 => "lowcostclub_session=eyJpdiI6IlZSWDJMS0NJbkxWYkphNjRCYmYySFE9PSIsInZhbHVlIjoiQUhIRG1QSHB2V1lJT1Q3NnV3V09mam8xMW82N3NGV1JyTDZXcWhvZTFlWitBR2kyajZrUVUvSDB5M1B0ZDh2T3dJK2Njb0FFT2kwNlJiM3pyQnl5YTNjVE5WS3VxSGhvczNFeE5jQkFvWXZ3bGxVbzFoTWFNRGhPVUhYWWtkM0kiLCJtYWMiOiJlYzYwZWMzYmJkY2FhYmI3OThhZDg3NWRiMjQ4ODJlOWJlN2FiNmJkMWE5MmUzOTUzOWZiOTNlYWIzNjNlNDkxIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 07:12:22 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlZSWDJMS0NJbkxWYkphNjRCYmYySFE9PSIsInZhbHVlIjoiQUhIRG1QSHB2V1lJT1Q3NnV3V09mam8xMW82N3NGV1JyTDZXcWhvZTFlWitBR2kyajZrUVUvSDB5M1B0ZDh2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imt1TjFQZGczeE5laXZPa2tOV0h3ckE9PSIsInZhbHVlIjoidDBPdEtJWFhsM3RzNE92d2xCYmY5cFZ3NWNhUFNoQ2tzaXdaUlg5MnFlem0zdlBYQ09UWVQzemRDK0gyRmdwNzJxaVdLSXk4ek1LOXVhdnNxTHhwMVVGUU5JSThWL0tvYjRwUWtaK0pQVXZlenVtOWJreXhqQTRXd0lGcVdFcDgiLCJtYWMiOiJhZGZlMWQyOWZkMGE3NzBlNDcyOGFmMWQ2N2FhNDgwYWQ1NGFkMTdhNmUzNDM4ZDM4ODM2YzVmOTE1Mzk0OWM5IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 07:12:22 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Imt1TjFQZGczeE5laXZPa2tOV0h3ckE9PSIsInZhbHVlIjoidDBPdEtJWFhsM3RzNE92d2xCYmY5cFZ3NWNhUFNoQ2tzaXdaUlg5MnFlem0zdlBYQ09UWVQzemRDK0gyRmdwNzJxaVdLS ▶"
    1 => "lowcostclub_session=eyJpdiI6IlZSWDJMS0NJbkxWYkphNjRCYmYySFE9PSIsInZhbHVlIjoiQUhIRG1QSHB2V1lJT1Q3NnV3V09mam8xMW82N3NGV1JyTDZXcWhvZTFlWitBR2kyajZrUVUvSDB5M1B0ZDh2T3dJK2Njb0FFT2kwNlJiM3pyQnl5YTNjVE5WS3VxSGhvczNFeE5jQkFvWXZ3bGxVbzFoTWFNRGhPVUhYWWtkM0kiLCJtYWMiOiJlYzYwZWMzYmJkY2FhYmI3OThhZDg3NWRiMjQ4ODJlOWJlN2FiNmJkMWE5MmUzOTUzOWZiOTNlYWIzNjNlNDkxIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 07:12:22 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlZSWDJMS0NJbkxWYkphNjRCYmYySFE9PSIsInZhbHVlIjoiQUhIRG1QSHB2V1lJT1Q3NnV3V09mam8xMW82N3NGV1JyTDZXcWhvZTFlWitBR2kyajZrUVUvSDB5M1B0ZDh2 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "rshYo5nrHqhhGxeBqwUUWB6aVPeumQpadnX1guLR"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-dubai-to-sofia-dxb-sof?_url=%2Fcheap-flights-from-dubai-to-sofia-dxb-sof"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-07 05:12:22GET/cheap-flights-from-dubai-to-sofia-dxb-sof52806083