Cheap flights Belfast — Madrid (BFS — MAD)

  1. Flights
  2. United Kingdom
  3. Belfast

Good to know - Cheap tickets Belfast — Madrid

Cheapest flight found $96
Flight distance 1585 km
Round-trip from $199
Cheapest month to fly July

Popular airlines flying Belfast — Madrid

Flight Belfast – Madrid is served by 28 airlines.

Routes from nearby cities to Madrid

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

search

Dublin — Madrid

search

Glasgow — Madrid

search

Islay — Madrid

search

Isle Of Man — Madrid

search

Derry — Madrid

search

Liverpool — Madrid

search

Manchester — Madrid

search

Knock — Madrid

search

Edinburgh — Madrid

Most often, departures to Madrid are from Dublin, this is the cheapest flight from $25. The nearest airports from Belfast with a flight to Madrid are located in Liverpool.

Popular International routes from Belfast

search

Belfast — Dubai

search

Belfast — Valencia

search

Belfast — Menorca

search

Belfast — Mombasa

search

Belfast — Montego Bay

Popular routes from Madrid

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

search

Madrid — Moscow

search

Madrid — Saint Petersburg

search

Madrid — Buenos Aires

search

Madrid — Lima

search

Madrid — Tokyo

Popular domestic routes from Belfast

search

Belfast — London

search

Belfast — Edinburgh

search

Belfast — Inverness

search

Belfast — Glasgow

search

Belfast — Manchester

Related pages

Return flights Madrid – Belfast

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

MessagesTimelineExceptionsViews53RouteQueries48Models359MailsGateN+1 QueriesSessionRequest
Request history8.3.0PHP Version542msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (23.16ms)time
    • Application (519ms)time
    • 1 x Application (95.73%)
      519ms
      1 x Booting (4.27%)
      23.16ms
      53 templates were rendered
      • 1x views_us.routes.viewview.blade.php#?blade
      • 1x routes.viewview.blade.php#?blade
      • 1x index.section-slideshowsection-slideshow.blade.php#?blade
      • 1x components.avia-formavia-form.blade.php#?blade
      • 1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
      • 1x routes.section-advantagessection-advantages.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 3x components.airlines-columnairlines-column.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 24x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 2x components.routes-columnroutes-column.blade.php#?blade
      • 1x components.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
      48 statements were executed (10 duplicates)Show only duplicates118ms
      • 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#34aviatickets7.11msselect * from `sites_relationships` where `us` = 'cheap-flights-from-belfast-to-madrid-bfs-mad' limit 1
        Bindings
        • 0: cheap-flights-from-belfast-to-madrid-bfs-mad
        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.44msselect * from `flights_by` where `flights_by`.`id` = '32366' 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.97msselect * from `cities` where `cities`.`id` = 537 limit 1
        Bindings
        • 0: 537
        Backtrace
        • app/Http/Controllers/RoutesController.php:135
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • RoutesController.php#136aviatickets940μsselect * from `countries` where `countries`.`id` = 17 limit 1
        Bindings
        • 0: 17
        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.91msselect * from `cities` where `cities`.`id` = 3787 limit 1
        Bindings
        • 0: 3787
        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#138aviatickets2.11msselect * from `countries` where `countries`.`id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Http/Controllers/RoutesController.php:138
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • DomainRouteFactory.php#33aviatickets780μsselect * from `sites_relationships` where `sites_relationships`.`id` = 32366 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 32366
        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.74msselect * 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.75msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 537 and `destination_id` = 3787 and `date_update` >= '2025-05-10 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 537
        • 1: 3787
        • 2: 2025-05-10 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#66aviatickets2.37msselect * from `monthly_price_statistics` where `origin_city_id` = 537 and `destination_city_id` = 3787 limit 1
        Bindings
        • 0: 537
        • 1: 3787
        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.61msselect * from `timetables` where `origin_city_id` = 537 and `destination_city_id` = 3787 order by `time_origin` asc limit 1000
        Bindings
        • 0: 537
        • 1: 3787
        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.71msselect distinct `airline_id` from `timetables` where `origin_city_id` = 537
        Bindings
        • 0: 537
        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#502aviatickets7.25msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3787
        Bindings
        • 0: 3787
        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#90aviatickets4.89msselect * from `airlines` where `id` in (561, 835, 1352, 2293, 2338, 3020, 3084, 4282, 4513, 4537, 4912, 5075, 5829, 11914, 18268, 24064, 25400, 65557, 65824, 70369, 71364, 259328, 642059, 1321150, 5436067, 5438487, 17141650, 146726240) order by `name` asc
        Bindings
        • 0: 561
        • 1: 835
        • 2: 1352
        • 3: 2293
        • 4: 2338
        • 5: 3020
        • 6: 3084
        • 7: 4282
        • 8: 4513
        • 9: 4537
        • 10: 4912
        • 11: 5075
        • 12: 5829
        • 13: 11914
        • 14: 18268
        • 15: 24064
        • 16: 25400
        • 17: 65557
        • 18: 65824
        • 19: 70369
        • 20: 71364
        • 21: 259328
        • 22: 642059
        • 23: 1321150
        • 24: 5436067
        • 25: 5438487
        • 26: 17141650
        • 27: 146726240
        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.5msselect destination_city_id from `flights_by` where `origin_city_id` = 537 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 537
        • 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.52msselect * from `flights_by` where `origin_city_id` in (3500, 3151, 3107, 1607, 6942, 2122, 4458, 9244, 3670, 3796) and `destination_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 3500
        • 1: 3151
        • 2: 3107
        • 3: 1607
        • 4: 6942
        • 5: 2122
        • 6: 4458
        • 7: 9244
        • 8: 3670
        • 9: 3796
        • 10: 3787
        • 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#73aviatickets2.34msselect * from `cities` where `cities`.`id` in (1607, 2122, 3107, 3151, 3500, 3670, 3796, 4458, 9244)
        Backtrace
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35
      • NearbyCitiesAggregateDbProvider.php#73aviatickets3.59msselect * from `cities` where `cities`.`id` in (3787)
        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#73aviatickets2.25msselect * from `sites_relationships` where `sites_relationships`.`id` in (93392, 99345, 117748, 195115, 201583, 235631, 1028231, 1147777, 1148188)
        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.65msselect * from `cities` where `cities`.`id` = 3670 limit 1
        Bindings
        • 0: 3670
        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#104aviatickets970μsselect * from `cities` where `cities`.`id` = 1607 limit 1
        Bindings
        • 0: 1607
        Backtrace
        • app/Avia/Infrastructure/City/CitySqlRepository.php:104
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/City/CitySqlRepository.php:101
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158
      • OfferSqlRepository.php#52aviatickets1.58msselect * from `offers` where `origin_city_id` = 537 and `destination_city_id` = 3787
        Bindings
        • 0: 537
        • 1: 3787
        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.07msselect * from `flights_by` where `origin_city_id` = 537 and `id` > 32366 and `destination_country_id` <> 17 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 537
        • 1: 32366
        • 2: 17
        • 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 (537)
        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#447aviatickets870μsselect * from `cities` where `cities`.`id` in (3790, 3807, 9067)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#447aviatickets2.55msselect * from `sites_relationships` where `sites_relationships`.`id` in (32367, 32369, 32370)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202
      • LocalRouteRepository.php#412aviatickets1.26msselect * from `flights_by` where `origin_city_id` = 537 and `destination_country_id` <> 17 and (`price_one_way` > 0 or `price` > 0) and `id` not in (32367) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 537
        • 1: 17
        • 2: 0
        • 3: 0
        • 4: 32367
        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#412aviatickets830μsselect * from `cities` where `cities`.`id` in (537)
        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#412aviatickets840μsselect * from `cities` where `cities`.`id` in (6543, 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#412aviatickets880μsselect * from `sites_relationships` where `sites_relationships`.`id` in (32279, 32479)
        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#412aviatickets950μsselect * from `countries` where `countries`.`id` in (23, 242)
        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.49msselect * from `flights_by` where `origin_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 3787
        • 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.35msselect * from `cities` where `cities`.`id` in (3787)
        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.55msselect * from `cities` where `cities`.`id` in (877, 3505, 3571, 4081, 6319)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Http/Controllers/RoutesController.php:216
      • LocalRouteRepository.php#149aviatickets1.09msselect * from `countries` where `countries`.`id` in (97, 211, 217, 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.1msselect * from `sites_relationships` where `sites_relationships`.`id` in (199866, 200211, 200222, 200301, 200653)
        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#359aviatickets3.22msselect * from `flights_by` where `origin_city_id` = 537 and `destination_country_id` = 17 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 537
        • 1: 17
        • 2: 0
        • 3: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330
      • LocalRouteRepository.php#359aviatickets2.79msselect * from `cities` where `cities`.`id` in (537)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330
      • LocalRouteRepository.php#359aviatickets3.06msselect * from `cities` where `cities`.`id` in (2122, 3654, 3796, 8465, 9244)
        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#359aviatickets8.24msselect * from `sites_relationships` where `sites_relationships`.`id` in (32283, 32301, 32321, 32359, 32368)
        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#359aviatickets4.9msselect * from `countries` where `countries`.`id` in (17)
        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#39aviatickets5.06msselect * from `timetables` where `origin_city_id` = 537 and `destination_city_id` = 3787 order by `time_origin` asc limit 10
        Bindings
        • 0: 537
        • 1: 3787
        Backtrace
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:39
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/TimetableRepository.php:30
        • app/Http/Controllers/RoutesController.php:264
      • TimetableRepository.php#144aviatickets2.63msselect * from `timetables` where `origin_city_id` = 537 and `destination_city_id` = 3787 order by `travel_time` asc limit 1
        Bindings
        • 0: 537
        • 1: 3787
        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#520aviatickets2.18msselect * from `flights_by` where `origin_city_id` = 3787 and `destination_city_id` = 537 limit 1
        Bindings
        • 0: 3787
        • 1: 537
        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#520aviatickets3.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (199809)
        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.94msselect * from `cities` where `cities`.`id` = 537 limit 1
        Bindings
        • 0: 537
        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.63msselect * from `cities` where `cities`.`id` = 3787 limit 1
        Bindings
        • 0: 3787
        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#20aviatickets2.85msselect * from `cities` where `cities`.`id` = 537 limit 1
        Bindings
        • 0: 537
        Backtrace
        • view::routes.description-nearbyCities:20
        • 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
      App\Avia\Infrastructure\Model\Timetable
      222Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      36LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      36City.php#?
      App\Avia\Infrastructure\Model\Airline
      28Airline.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      27SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Country
      9Country.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
            _token
            i4RUaYBT9Rq0Pzw6GnY2WHicAn1p4GdathBbUf41
            _previous
            array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-belfast-to-madrid-bfs-mad?_url=%2Fch...
            _flash
            array:2 [ "old" => [] "new" => [] ]
            path_info
            /cheap-flights-from-belfast-to-madrid-bfs-mad
            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-belfast-to-madrid-bfs-mad"
]
            request_request
            []
            request_headers
              0 of 0   
            array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjVHWTQrSDhXV2lhWmZGSi9kT0liZXc9PSIsInZhbHVlIjoidFc1SlBzUUNlbEhEanZGTHEwdFhmOEMycFk3QnJ1NGZJQS9vQlFVWTNvMkIvNDI5eFlMY0ZsaGlxOVE3eXdiV01qTGtaa1lSR2VhNmdoTmZ5S1V1TXp5N1Nqa3VhSVZEb25YejlwTU5KSkttWTBNSGJRYlJWNzFUcHlZZW15ZzQiLCJtYWMiOiJlY2M0MTU2YjAwNTVmNTI0N2YyODJlZTk5ZTVmMzEwMTc5OWE4NmNkNmQwNTJjYzliMDFmZWZiZjVlNTNmZjBhIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6Ik5oekRGbXUzTVdQcmZyTDU0OVMraXc9PSIsInZhbHVlIjoidTJUdUxyWGZQTkpvOWZsYWZNUTlVNGFtdnl5cUo1Z2JQTlVoeEZwS20vZlRtZitwMENacktTeEFCdnNMV2IrWGJpRmFPZnJ5TlhialU1Z2lHZzBBaUF0UE9OVEIvSXovcVNKRUJjeHlsdy8ybUh4blhYZ3ZqS0lIS2FXUTZZTU4iLCJtYWMiOiIzYTc5OWQ4NTRkODMzZGViNDFjYmE3MmQ1ZmNjZmQyN2ViMTk2NjRjMDRiYWY5MTMwMzY0NDExNmJlYmI1ZmVlIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjVHWTQrSDhXV2lhWmZGSi9kT0liZXc9PSIsInZhbHVlIjoidFc1SlBzUUNlbEhEanZGTHEwdFhmOEMycFk3QnJ1NGZJQS9vQlFVWTNvMkIvNDI5eFlMY0ZsaGlxOVE3eXdiV01qTGtaa ▶"
  ]
  "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" => "i4RUaYBT9Rq0Pzw6GnY2WHicAn1p4GdathBbUf41"
  "lowcostclub_session" => "odfNBeiR1kBLn8gSy2Wa62xLuhI4cAY0ilu2pK55"
]
            response_headers
              0 of 0   
            array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Mon, 12 May 2025 12:50:20 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""115fd29adbde15f6ad841c30423a2900""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJrS2R5YlFhbmxPRkFKQVY5ZXhMU0E9PSIsInZhbHVlIjoiN3N4SDRZK0N1cmVjbldreDA2M0FuTTZmaTkzakFzVmlwYmN3N3Qzeml1SXpOV29TQ1lxRUpLWE4yNUxRU1VVaGdENytwK3ZmTlFVNStaN2dFY25JcVFkekxYT2ZLaEcvNHVKUFFrWjZveTNFZi9wK0Y2Z2RhSmhkYTZRTGVzZ2MiLCJtYWMiOiJjNzczOTVhMjVlNjJjOWJiN2EzNTM5ZjA0YWNlYzAwNjE3ZDRjZWM0MmNiZGIzYjU5M2RjZDdhMDA1ZWE4OGQ4IiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 14:50:20 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlJrS2R5YlFhbmxPRkFKQVY5ZXhMU0E9PSIsInZhbHVlIjoiN3N4SDRZK0N1cmVjbldreDA2M0FuTTZmaTkzakFzVmlwYmN3N3Qzeml1SXpOV29TQ1lxRUpLWE4yNUxRU1VVaGdENytwK ▶"
    1 => "lowcostclub_session=eyJpdiI6IlZ0WWxtYnB6N05qdngrYklYOFNqMVE9PSIsInZhbHVlIjoiSndLSmUxM2czaGNyMEZLcXJxN0tEUXVWbENka0FMVWUxYzR4ZVp5blZuU3k1bm9XeFRFdFRJbHI0R3Y4K1lxaW5jZisxN3NuQXBpQWdqTW5DZjUvS01JYVRTWUlFRUtOemJkSHRZQVROWUpibGd0TEF4N0tyTkRLZTd1TVAvQ20iLCJtYWMiOiI3N2VjZjhkMzMzMTI4NTI5ZDE1MmFjZmExYmZiMDljNzRlYjYwNTAxY2NiYzliOTU0YzAwYWRlZWJhNDFlM2IyIiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 14:50:20 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IlZ0WWxtYnB6N05qdngrYklYOFNqMVE9PSIsInZhbHVlIjoiSndLSmUxM2czaGNyMEZLcXJxN0tEUXVWbENka0FMVWUxYzR4ZVp5blZuU3k1bm9XeFRFdFRJbHI0R3Y4K1lx ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJrS2R5YlFhbmxPRkFKQVY5ZXhMU0E9PSIsInZhbHVlIjoiN3N4SDRZK0N1cmVjbldreDA2M0FuTTZmaTkzakFzVmlwYmN3N3Qzeml1SXpOV29TQ1lxRUpLWE4yNUxRU1VVaGdENytwK3ZmTlFVNStaN2dFY25JcVFkekxYT2ZLaEcvNHVKUFFrWjZveTNFZi9wK0Y2Z2RhSmhkYTZRTGVzZ2MiLCJtYWMiOiJjNzczOTVhMjVlNjJjOWJiN2EzNTM5ZjA0YWNlYzAwNjE3ZDRjZWM0MmNiZGIzYjU5M2RjZDdhMDA1ZWE4OGQ4IiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 14:50:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlJrS2R5YlFhbmxPRkFKQVY5ZXhMU0E9PSIsInZhbHVlIjoiN3N4SDRZK0N1cmVjbldreDA2M0FuTTZmaTkzakFzVmlwYmN3N3Qzeml1SXpOV29TQ1lxRUpLWE4yNUxRU1VVaGdENytwK ▶"
    1 => "lowcostclub_session=eyJpdiI6IlZ0WWxtYnB6N05qdngrYklYOFNqMVE9PSIsInZhbHVlIjoiSndLSmUxM2czaGNyMEZLcXJxN0tEUXVWbENka0FMVWUxYzR4ZVp5blZuU3k1bm9XeFRFdFRJbHI0R3Y4K1lxaW5jZisxN3NuQXBpQWdqTW5DZjUvS01JYVRTWUlFRUtOemJkSHRZQVROWUpibGd0TEF4N0tyTkRLZTd1TVAvQ20iLCJtYWMiOiI3N2VjZjhkMzMzMTI4NTI5ZDE1MmFjZmExYmZiMDljNzRlYjYwNTAxY2NiYzliOTU0YzAwYWRlZWJhNDFlM2IyIiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 14:50:20 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IlZ0WWxtYnB6N05qdngrYklYOFNqMVE9PSIsInZhbHVlIjoiSndLSmUxM2czaGNyMEZLcXJxN0tEUXVWbENka0FMVWUxYzR4ZVp5blZuU3k1bm9XeFRFdFRJbHI0R3Y4K1lx ▶"
  ]
]
            session_attributes
              0 of 0   
            array:3 [▼
  "_token" => "i4RUaYBT9Rq0Pzw6GnY2WHicAn1p4GdathBbUf41"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-belfast-to-madrid-bfs-mad?_url=%2Fcheap-flights-from-belfast-to-madrid-bfs-mad"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
            ClearShow all
            Date ↕MethodURLData
            #12025-05-12 12:50:20GET/cheap-flights-from-belfast-to-madrid-bfs-mad5348359