Cheap flights Bogota — Madrid (BOG — MAD)

Good to know - Cheap tickets Bogota — Madrid

Cheapest flight found $342
Minimal flight time 5h 10m
Flight distance 8021 km
Most popular airline Avianca

Sales of tickets from Bogota to Madrid in the last 48 hours

2025-08-08 one-way

2025-06-29 one-way

2025-12-18 one-way

Routes from nearby cities to Madrid

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

The most frequent flight to Madrid is from Pereira. The cheapest airfare can be purchased with a flight from Medellin from $344. The nearest airports from Bogota with a flight to Madrid are in Barrancabermeja.

Popular International routes from Bogota

Popular routes from Madrid

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

Popular domestic routes from Bogota

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

Request history8.3.0PHP Version487msRequest Duration5MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (26.61ms)time
    • Application (460ms)time
    • 1 x Application (94.53%)
      460ms
      1 x Booting (5.47%)
      26.61ms
      59 templates were rendered
      • 1x views_us.routes.viewview.blade.php#?blade
      • 1x routes.viewview.blade.php#?blade
      • 1x index.section-slideshowsection-slideshow.blade.php#?blade
      • 1x components.avia-formavia-form.blade.php#?blade
      • 1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
      • 1x routes.section-advantagessection-advantages.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 6x components.airlines-columnairlines-column.blade.php#?blade
      • 1x routes.LastSales48LastSales48.blade.php#?blade
      • 1x components.last-sales-48-recordslast-sales-48-records.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 25x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 2x components.routes-columnroutes-column.blade.php#?blade
      • 1x components.related-linksrelated-links.blade.php#?blade
      • 1x layouts.mainmain.blade.php#?blade
      • 1x headerheader.blade.php#?blade
      • 2x menumenu.blade.php#?blade
      • 1x footerfooter.blade.php#?blade
      • 1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
      • 1x footer_scriptsfooter_scripts.blade.php#?blade
      • 1x components.currencycurrency.blade.php#?blade
      • 2x components.popuppopup.blade.php#?blade
      • 1x components.languagelanguage.blade.php#?blade
      uri
      GET cheap-flights-from-{slug}
      middleware
      web
      controller
      App\Http\Controllers\RoutesController@view
      namespace
      prefix
      /
      where
      as
      route
      file
      app/Http/Controllers/RoutesController.php:96-299
      86 statements were executed (36 duplicates)Show only duplicates134ms
      • 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#34aviatickets6.16msselect * from `sites_relationships` where `us` = 'cheap-flights-from-bogota-to-madrid-bog-mad' limit 1
        Bindings
        • 0: cheap-flights-from-bogota-to-madrid-bog-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.38msselect * from `flights_by` where `flights_by`.`id` = '43977' 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.32msselect * from `cities` where `cities`.`id` = 770 limit 1
        Bindings
        • 0: 770
        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.2msselect * from `countries` where `countries`.`id` = 121 limit 1
        Bindings
        • 0: 121
        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.2msselect * 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#138aviatickets1.06msselect * from `countries` where `countries`.`id` = 23 limit 1
        Bindings
        • 0: 23
        Backtrace
        • app/Http/Controllers/RoutesController.php:138
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • DomainRouteFactory.php#33aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` = 43977 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 43977
        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#31aviatickets2.01msselect * from `countries` where `code` = '' limit 1
        Bindings
        • 0: 
        Backtrace
        • app/Avia/Infrastructure/Repository/CountriesRepository.php:31
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:61
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:43
        • app/Avia/Infrastructure/Provider/CurrentCurrencyProvider.php:56
        • app/Avia/Infrastructure/Model/LocalRoute.php:190
      • RouteRepository.php#42aviatickets2.56msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 770 and `destination_id` = 3787 and `date_update` >= '2025-05-05 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 770
        • 1: 3787
        • 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.26msselect * from `monthly_price_statistics` where `origin_city_id` = 770 and `destination_city_id` = 3787 limit 1
        Bindings
        • 0: 770
        • 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#470aviatickets2.12msselect * from `timetables` where `origin_city_id` = 770 and `destination_city_id` = 3787 order by `time_origin` asc limit 1000
        Bindings
        • 0: 770
        • 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#470aviatickets1.46msselect * from `airlines` where `airlines`.`id` in (89, 513, 2817)
        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#502aviatickets3.46msselect distinct `airline_id` from `timetables` where `origin_city_id` = 770
        Bindings
        • 0: 770
        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#502aviatickets3.1msselect 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#90aviatickets1.75msselect * from `airlines` where `id` in (24, 136, 319, 328, 410, 926, 2005, 2179, 2216, 2338, 3084, 3194, 3314, 4078, 4929, 5184, 5238, 11834, 11908, 11914, 21061, 59095) order by `name` asc
        Bindings
        • 0: 24
        • 1: 136
        • 2: 319
        • 3: 328
        • 4: 410
        • 5: 926
        • 6: 2005
        • 7: 2179
        • 8: 2216
        • 9: 2338
        • 10: 3084
        • 11: 3194
        • 12: 3314
        • 13: 4078
        • 14: 4929
        • 15: 5184
        • 16: 5238
        • 17: 11834
        • 18: 11908
        • 19: 11914
        • 20: 21061
        • 21: 59095
        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#558aviatickets1.29msselect destination_city_id from `flights_by` where `origin_city_id` = 770 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 770
        • 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.18msselect * from `flights_by` where `origin_city_id` in (9164, 2535, 4305, 4874, 388, 8392, 8577, 4525, 1697, 1185) and `destination_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9164
        • 1: 2535
        • 2: 4305
        • 3: 4874
        • 4: 388
        • 5: 8392
        • 6: 8577
        • 7: 4525
        • 8: 1697
        • 9: 1185
        • 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#73aviatickets1.24msselect * from `cities` where `cities`.`id` in (388, 1185, 1697, 2535, 4305, 4525, 4874, 8392, 8577, 9164)
        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.41msselect * 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#73aviatickets1.21msselect * from `sites_relationships` where `sites_relationships`.`id` in (23460, 70844, 141227, 204351, 258125, 452904, 1156833, 1178816, 1193147, 1262118)
        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.09msselect destination_city_id from `flights_by` where `origin_city_id` = 770 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 770
        • 1: 1
        • 2: 1000
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.56msselect * from `flights_by` where `origin_city_id` in (9164, 2535, 4305, 4874, 388, 8392, 8577, 4525, 1697, 1185) and `destination_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9164
        • 1: 2535
        • 2: 4305
        • 3: 4874
        • 4: 388
        • 5: 8392
        • 6: 8577
        • 7: 4525
        • 8: 1697
        • 9: 1185
        • 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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.07msselect * from `cities` where `cities`.`id` in (388, 1185, 1697, 2535, 4305, 4525, 4874, 8392, 8577, 9164)
        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#73aviatickets970μsselect * 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:85
      • NearbyCitiesAggregateDbProvider.php#73aviatickets880μsselect * from `sites_relationships` where `sites_relationships`.`id` in (23460, 70844, 141227, 204351, 258125, 452904, 1156833, 1178816, 1193147, 1262118)
        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.09msselect * from `cities` where `cities`.`id` = 1697 limit 1
        Bindings
        • 0: 1697
        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#558aviatickets1msselect destination_city_id from `flights_by` where `origin_city_id` = 770 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 770
        • 1: 1
        • 2: 1000
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.82msselect * from `flights_by` where `origin_city_id` in (9164, 2535, 4305, 4874, 388, 8392, 8577, 4525, 1697, 1185) and `destination_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9164
        • 1: 2535
        • 2: 4305
        • 3: 4874
        • 4: 388
        • 5: 8392
        • 6: 8577
        • 7: 4525
        • 8: 1697
        • 9: 1185
        • 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets2.58msselect * from `cities` where `cities`.`id` in (388, 1185, 1697, 2535, 4305, 4525, 4874, 8392, 8577, 9164)
        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.91msselect * 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.44msselect * from `sites_relationships` where `sites_relationships`.`id` in (23460, 70844, 141227, 204351, 258125, 452904, 1156833, 1178816, 1193147, 1262118)
        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.1msselect * from `cities` where `cities`.`id` = 8577 limit 1
        Bindings
        • 0: 8577
        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#558aviatickets1msselect destination_city_id from `flights_by` where `origin_city_id` = 770 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 770
        • 1: 1
        • 2: 1000
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.79msselect * from `flights_by` where `origin_city_id` in (9164, 2535, 4305, 4874, 388, 8392, 8577, 4525, 1697, 1185) and `destination_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9164
        • 1: 2535
        • 2: 4305
        • 3: 4874
        • 4: 388
        • 5: 8392
        • 6: 8577
        • 7: 4525
        • 8: 1697
        • 9: 1185
        • 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:123
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.9msselect * from `cities` where `cities`.`id` in (388, 1185, 1697, 2535, 4305, 4525, 4874, 8392, 8577, 9164)
        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.23msselect * 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:123
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.49msselect * from `sites_relationships` where `sites_relationships`.`id` in (23460, 70844, 141227, 204351, 258125, 452904, 1156833, 1178816, 1193147, 1262118)
        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.15msselect * from `cities` where `cities`.`id` = 4874 limit 1
        Bindings
        • 0: 4874
        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.24msselect destination_city_id from `flights_by` where `origin_city_id` = 770 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 770
        • 1: 1
        • 2: 1000
        • 3: 0
        • 4: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563
        • app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.88msselect * from `flights_by` where `origin_city_id` in (9164, 2535, 4305, 4874, 388, 8392, 8577, 4525, 1697, 1185) and `destination_city_id` = 3787 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 9164
        • 1: 2535
        • 2: 4305
        • 3: 4874
        • 4: 388
        • 5: 8392
        • 6: 8577
        • 7: 4525
        • 8: 1697
        • 9: 1185
        • 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets1.18msselect * from `cities` where `cities`.`id` in (388, 1185, 1697, 2535, 4305, 4525, 4874, 8392, 8577, 9164)
        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#73aviatickets890μsselect * 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:142
      • NearbyCitiesAggregateDbProvider.php#73aviatickets940μsselect * from `sites_relationships` where `sites_relationships`.`id` in (23460, 70844, 141227, 204351, 258125, 452904, 1156833, 1178816, 1193147, 1262118)
        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.16msselect * from `cities` where `cities`.`id` = 8577 limit 1
        Bindings
        • 0: 8577
        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.1msselect * from `offers` where `origin_city_id` = 770 and `destination_city_id` = 3787
        Bindings
        • 0: 770
        • 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.39msselect * from `flights_by` where `origin_city_id` = 770 and `id` > 43977 and `destination_country_id` <> 121 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 770
        • 1: 43977
        • 2: 121
        • 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#447aviatickets990μsselect * from `cities` where `cities`.`id` in (770)
        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#447aviatickets920μsselect * from `cities` where `cities`.`id` in (3797, 3799, 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#447aviatickets710μsselect * from `sites_relationships` where `sites_relationships`.`id` in (43979, 43980, 43981)
        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#125aviatickets860μsselect * from `countries` where `countries`.`id` = 81 limit 1
        Bindings
        • 0: 81
        Backtrace
        • app/Avia/Infrastructure/Model/LocalRoute.php:125
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Model/LocalRoute.php:122
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:49
      • LocalRoute.php#125aviatickets1.06msselect * from `countries` where `countries`.`id` = 20 limit 1
        Bindings
        • 0: 20
        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.44msselect * from `flights_by` where `origin_city_id` = 770 and `destination_country_id` <> 121 and (`price_one_way` > 0 or `price` > 0) and `id` not in (43979) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 770
        • 1: 121
        • 2: 0
        • 3: 0
        • 4: 43979
        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.16msselect * from `cities` where `cities`.`id` in (770)
        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.68msselect * from `cities` where `cities`.`id` in (2686, 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#412aviatickets1.16msselect * from `sites_relationships` where `sites_relationships`.`id` in (43932, 43999)
        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#412aviatickets6.89msselect * from `countries` where `countries`.`id` in (134, 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.35msselect * 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#149aviatickets1.06msselect * 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#149aviatickets1.39msselect * 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#149aviatickets4.75msselect * 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#149aviatickets820μsselect * 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#359aviatickets1.47msselect * from `flights_by` where `origin_city_id` = 770 and `destination_country_id` = 121 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 770
        • 1: 121
        • 2: 0
        • 3: 0
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330
      • LocalRouteRepository.php#359aviatickets1.16msselect * from `cities` where `cities`.`id` in (770)
        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.19msselect * from `cities` where `cities`.`id` in (1319, 6597, 8724, 8754, 9057)
        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.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (43736, 43836, 43962, 44081, 44188)
        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.08msselect * from `countries` where `countries`.`id` in (121)
        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.49msselect * from `timetables` where `origin_city_id` = 770 and `destination_city_id` = 3787 order by `time_origin` asc limit 10
        Bindings
        • 0: 770
        • 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#39aviatickets1.05msselect * from `airports` where `airports`.`id` in (4058)
        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.03msselect * from `airports` where `airports`.`id` in (995)
        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.01msselect * from `airlines` where `airlines`.`id` in (513, 2817)
        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.35msselect * from `timetables` where `origin_city_id` = 770 and `destination_city_id` = 3787 order by `travel_time` asc limit 1
        Bindings
        • 0: 770
        • 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#520aviatickets1.02msselect * from `flights_by` where `origin_city_id` = 3787 and `destination_city_id` = 770 limit 1
        Bindings
        • 0: 3787
        • 1: 770
        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#520aviatickets960μsselect * from `sites_relationships` where `sites_relationships`.`id` in (199843)
        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.12msselect * 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
      • RoutesController.php#548aviatickets950μsselect * from `cities` where `cities`.`id` = 770 limit 1
        Bindings
        • 0: 770
        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.27msselect * from `cities` where `cities`.`id` = 770 limit 1
        Bindings
        • 0: 770
        Backtrace
        • view::routes.description-nearbyCities:28
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • LocalRouteRepository.php#175aviatickets1.16msselect * 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.25msselect * from `cities` where `cities`.`id` in (537, 779, 3448, 3796, 4539)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#175aviatickets1.72msselect * 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.5msselect * from `countries` where `countries`.`id` in (17, 70, 79, 92, 105)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#175aviatickets1.39msselect * from `sites_relationships` where `sites_relationships`.`id` in (32301, 46235, 46251, 180255, 201516, 240458)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:175
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:179
        • app/Avia/Application/SeoRoutesHandler.php:40
      • LocalRouteRepository.php#149aviatickets2.16msselect * from `flights_by` where `origin_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) and `id` not in (240458, 46235, 180255, 46251, 201516, 32301) order by `count` desc limit 9
        Bindings
        • 0: 4539
        • 1: 0
        • 2: 0
        • 3: 240458
        • 4: 46235
        • 5: 180255
        • 6: 46251
        • 7: 201516
        • 8: 32301
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets960μsselect * from `cities` where `cities`.`id` in (4539)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets1.21msselect * from `cities` where `cities`.`id` in (1115, 1903, 2686, 3445, 3448, 3505, 3951, 4081, 8389)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets1.04msselect * from `countries` where `countries`.`id` in (92, 134, 242, 248)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Avia/Application/SeoRoutesHandler.php:54
      • LocalRouteRepository.php#149aviatickets880μsselect * from `sites_relationships` where `sites_relationships`.`id` in (239645, 239765, 239824, 239994, 240101, 240103, 240116, 240218, 240243)
        Backtrace
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153
        • app/Avia/Application/SeoRoutesHandler.php:54
      App\Avia\Infrastructure\Model\Timetable
      259Timetable.php#?
      App\Avia\Infrastructure\Model\LocalRoute
      132LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      104City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      83SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Airline
      27Airline.php#?
      App\Avia\Infrastructure\Model\Country
      20Country.php#?
      App\Avia\Infrastructure\Model\Route
      3Route.php#?
      App\Avia\Infrastructure\Model\Airport
      2Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      1MonthlyPriceStatistic.php#?
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\City - Yo...
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: App\Avia\Infrastructure\Model\SitesRela...
          • infoModel: App\Avia\Infrastructure\Model\LocalRoute => Relation: destinationCountry - You should add `wi...
          _token
          giJVGSndgc9sMuWnMnJWFtz3CmIZbT4P7j8bVO2w
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-bogota-to-madrid-bog-mad?_url=%2Fche...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-bogota-to-madrid-bog-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-bogota-to-madrid-bog-mad" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik84SUJLZG9Rd3dvTDdEYmtpdndCR3c9PSIsInZhbHVlIjoiR0F5WUw2WGxiWXl3QzVhcGx1bEVxN3dvM2RyeUwwd2Jxek4yTjB3RElZa2w4aTNFMEZxYWJZOCt2ZDQySnQ5eWZCeTVBYXlGa2pmT0RBM2ZVMGROc1ppMndzSXdyNURydUJRc0hhTXd3cDlwOWZoRkdnMHhxazNzczNNSGZyUWciLCJtYWMiOiIxNTFjZDg2NGIzMDhmNzkzMDNhMDFiNjg4NmQ4Zjk2MDA2NTNkY2NhMTMzYWM4YWY0NjZiOTM4MDc2YjI2ODAzIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IkJadUZUNDJWTFFwZXFCQTdGZVo4Z0E9PSIsInZhbHVlIjoiWGtTeUU0SjdkRzJzQWNPWkVXMzloYndZUld3T2VjeS9aQXgwekZiSHZPODhJa0NiRTBCV1RUMGtjTVVPaHJQYWRWcjE2bE8xaWJTVFJ0ZnhJYm8wcm4xdWZjNEMwN0ZOcmVvSUd3RXI4S3RqRHFxNm13RGhRYUdFVmd1ZFhTWmoiLCJtYWMiOiIzMTdjMDMyZjViYTA1NzY1MjM2OGI5ZTZhMjY4NGMxODkwYWNiMDMzZDYzNjRhZDI1MDUxODA5MjhhYmM5OTg4IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6Ik84SUJLZG9Rd3dvTDdEYmtpdndCR3c9PSIsInZhbHVlIjoiR0F5WUw2WGxiWXl3QzVhcGx1bEVxN3dvM2RyeUwwd2Jxek4yTjB3RElZa2w4aTNFMEZxYWJZOCt2ZDQySnQ5eWZCeTVBY" ] "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" => "giJVGSndgc9sMuWnMnJWFtz3CmIZbT4P7j8bVO2w" "lowcostclub_session" => "xDIohF2Yxe5DDiIttzEQFFebRQ2umk8pKZa5jyub" ]
          response_headers
          0 of 0
          array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Wed, 07 May 2025 00:18:22 GMT" ] "etag" => array:1 [ 0 => ""1441f885c252a1b2d1f12a7097a28e88"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik5ROC94R2hKb3JmUTI3NmFWc2tmd0E9PSIsInZhbHVlIjoiWEc1Rmx5WXo4aXNBckVCd2dXa1BaRWtLdWswT1BpQXJLUmd0em9iUlR2NDRnc1FUTlgvc3Z6R1VBd045Q1NkUjRCWXR4Tk52QjN6a1A1ZHVVUHpzSTh3a29oMkREcTlXVU10ZjAvNExGZjRzcStZTUgwT0cvdjlBcTZQVkd0ejIiLCJtYWMiOiJlNzk5YjI0NmYzYTBmZmI3NTA1YmE3OGI2ZTkwMmQ2Zjc1M2Y2NmUwNDQwODM0MWRhYTU3MzJhMjIwYTYyYjMwIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 02:18:22 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ik5ROC94R2hKb3JmUTI3NmFWc2tmd0E9PSIsInZhbHVlIjoiWEc1Rmx5WXo4aXNBckVCd2dXa1BaRWtLdWswT1BpQXJLUmd0em9iUlR2NDRnc1FUTlgvc3Z6R1VBd045Q1NkUjRCWXR4T" 1 => "lowcostclub_session=eyJpdiI6IjcvZmNabURhNHpXNVRFekRpY3FiNkE9PSIsInZhbHVlIjoiMVVzdzlEbXRrcjY5ZUhGVmVpNUZlZGtSKzVpOFg4SCtqc3EvNWhJVFNSOHVPckJFbUFrYWRad2NPcmhJMStSbUNycDV5aXdneHdFOFg3TVRxMHFJUkdDbFdmOEdXRk5TVC9sQytIK0hmNFlKdlpjNlQvTkovVm1Wa3EwL3VueWwiLCJtYWMiOiI1MjFiM2ViMTdjZTkyMTBjY2VhYThiNDU0MTEyZTVhMzBmMDIwZGFjYzE5NGVmYzZmN2NhZmRmNzliNTM4NGZlIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 02:18:22 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6IjcvZmNabURhNHpXNVRFekRpY3FiNkE9PSIsInZhbHVlIjoiMVVzdzlEbXRrcjY5ZUhGVmVpNUZlZGtSKzVpOFg4SCtqc3EvNWhJVFNSOHVPckJFbUFrYWRad2NPcmhJMStS" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik5ROC94R2hKb3JmUTI3NmFWc2tmd0E9PSIsInZhbHVlIjoiWEc1Rmx5WXo4aXNBckVCd2dXa1BaRWtLdWswT1BpQXJLUmd0em9iUlR2NDRnc1FUTlgvc3Z6R1VBd045Q1NkUjRCWXR4Tk52QjN6a1A1ZHVVUHpzSTh3a29oMkREcTlXVU10ZjAvNExGZjRzcStZTUgwT0cvdjlBcTZQVkd0ejIiLCJtYWMiOiJlNzk5YjI0NmYzYTBmZmI3NTA1YmE3OGI2ZTkwMmQ2Zjc1M2Y2NmUwNDQwODM0MWRhYTU3MzJhMjIwYTYyYjMwIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 02:18:22 GMT; path=/XSRF-TOKEN=eyJpdiI6Ik5ROC94R2hKb3JmUTI3NmFWc2tmd0E9PSIsInZhbHVlIjoiWEc1Rmx5WXo4aXNBckVCd2dXa1BaRWtLdWswT1BpQXJLUmd0em9iUlR2NDRnc1FUTlgvc3Z6R1VBd045Q1NkUjRCWXR4T" 1 => "lowcostclub_session=eyJpdiI6IjcvZmNabURhNHpXNVRFekRpY3FiNkE9PSIsInZhbHVlIjoiMVVzdzlEbXRrcjY5ZUhGVmVpNUZlZGtSKzVpOFg4SCtqc3EvNWhJVFNSOHVPckJFbUFrYWRad2NPcmhJMStSbUNycDV5aXdneHdFOFg3TVRxMHFJUkdDbFdmOEdXRk5TVC9sQytIK0hmNFlKdlpjNlQvTkovVm1Wa3EwL3VueWwiLCJtYWMiOiI1MjFiM2ViMTdjZTkyMTBjY2VhYThiNDU0MTEyZTVhMzBmMDIwZGFjYzE5NGVmYzZmN2NhZmRmNzliNTM4NGZlIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 02:18:22 GMT; path=/; httponlylowcostclub_session=eyJpdiI6IjcvZmNabURhNHpXNVRFekRpY3FiNkE9PSIsInZhbHVlIjoiMVVzdzlEbXRrcjY5ZUhGVmVpNUZlZGtSKzVpOFg4SCtqc3EvNWhJVFNSOHVPckJFbUFrYWRad2NPcmhJMStS" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "giJVGSndgc9sMuWnMnJWFtz3CmIZbT4P7j8bVO2w" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-bogota-to-madrid-bog-mad?_url=%2Fcheap-flights-from-bogota-to-madrid-bog-mad" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-07 00:18:22GET/cheap-flights-from-bogota-to-madrid-bog-mad59866314