SitesRelationshipsSqlRepository.php#34aviatickets3.94msselect * from `sites_relationships` where `us` = 'cheap-flights-from-doha-to-zaragoza-doh-zaz' limit 1

Bindings	0: cheap-flights-from-doha-to-zaragoza-doh-zaz
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.57msselect * from `flights_by` where `flights_by`.`id` = '1001490' 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.19msselect * from `cities` where `cities`.`id` = 1557 limit 1

Bindings	0: 1557
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.82msselect * from `countries` where `countries`.`id` = 62 limit 1

Bindings	0: 62
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#137aviatickets2.07msselect * from `cities` where `cities`.`id` = 7414 limit 1

Bindings	0: 7414
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#138aviatickets3.53msselect * 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#33aviatickets2.01ms

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

Bindings	0: 1001490
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#31aviatickets4.96msselect * 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.5ms

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

Bindings	0: 1557 1: 7414 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#66aviatickets4.99msselect * from `monthly_price_statistics` where `origin_city_id` = 1557 and `destination_city_id` = 7414 limit 1

Bindings	0: 1557 1: 7414
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#470aviatickets9.81ms

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

Bindings	0: 1557 1: 7414
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#470aviatickets4.3msselect * from `airlines` where `airlines`.`id` in (4078)

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#502aviatickets2.41msselect distinct `airline_id` from `timetables` where `origin_city_id` = 1557

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

AirlineSqlRepository.php#502aviatickets1.15msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7414

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

AirlineSqlRepository.php#90aviatickets2.3ms

select * from `airlines` where `id` in (1652, 2216, 2218, 2817, 3084, 3915, 5075, 5432, 897295, 5436067) order by `name` asc

Bindings	0: 1652 1: 2216 2: 2218 3: 2817 4: 3084 5: 3915 6: 5075 7: 5432 8: 897295 9: 5436067
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.59ms

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

Bindings	0: 1557 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#73aviatickets15.07ms

select * from `flights_by` where `origin_city_id` in (424, 1530, 347, 8389, 5586, 14, 3175, 5923, 5429, 3394) and `destination_city_id` = 7414 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 424 1: 1530 2: 347 3: 8389 4: 5586 5: 14 6: 3175 7: 5923 8: 5429 9: 3394 10: 7414 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.01msselect * from `cities` where `cities`.`id` in (5586, 8389)

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

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#73aviatickets810μsselect * from `sites_relationships` where `sites_relationships`.`id` in (96418, 1006985)

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

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

OfferSqlRepository.php#52aviatickets1.72msselect * from `offers` where `origin_city_id` = 1557 and `destination_city_id` = 7414

Bindings	0: 1557 1: 7414
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.66ms

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

Bindings	0: 1557 1: 1001490 2: 62 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#447aviatickets2.36msselect * from `cities` where `cities`.`id` in (1557)

Backtrace

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

LocalRouteRepository.php#447aviatickets1.35msselect * from `cities` where `cities`.`id` in (115, 175, 485)

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.53msselect * from `sites_relationships` where `sites_relationships`.`id` in (1020469, 1020471, 1020473)

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

Bindings	0: 31
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.17ms

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

Bindings	0: 1557 1: 62 2: 0 3: 0 4: 1020469
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 (1557)

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#412aviatickets870μsselect * from `cities` where `cities`.`id` in (877, 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#412aviatickets660μsselect * from `sites_relationships` where `sites_relationships`.`id` in (89297, 89573)

Backtrace

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

LocalRouteRepository.php#412aviatickets800μsselect * from `countries` where `countries`.`id` in (217, 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#149aviatickets3.5ms

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

Bindings	0: 7414 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.54msselect * from `cities` where `cities`.`id` in (7414)

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.66msselect * from `cities` where `cities`.`id` in (1985, 4081, 5324, 5981, 8596)

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.3msselect * from `countries` where `countries`.`id` in (8, 23, 51, 119, 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#149aviatickets4.44msselect * from `sites_relationships` where `sites_relationships`.`id` in (376647, 376679, 376698, 500935, 1111052)

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

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

Bindings	0: 1557 1: 62 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

TimetableRepository.php#39aviatickets3.91ms

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

Bindings	0: 1557 1: 7414
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.1msselect * from `airports` where `airports`.`id` in (7962)

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#39aviatickets4.52msselect * from `airports` where `airports`.`id` in (129)

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#39aviatickets3.09msselect * from `airlines` where `airlines`.`id` in (4078)

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

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

Bindings	0: 1557 1: 7414
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#520aviatickets970μsselect * from `flights_by` where `origin_city_id` = 7414 and `destination_city_id` = 1557 limit 1

Bindings	0: 7414 1: 1557
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#520aviatickets770μsselect * from `sites_relationships` where `sites_relationships`.`id` in (376635)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:520
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:514
app/Http/Controllers/RoutesController.php:530

RoutesController.php#547aviatickets1.15msselect * from `cities` where `cities`.`id` = 7414 limit 1

Bindings	0: 7414
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#548aviatickets980μsselect * from `cities` where `cities`.`id` = 1557 limit 1

Bindings	0: 1557
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#12aviatickets1.09msselect * from `cities` where `cities`.`id` = 1557 limit 1

Bindings	0: 1557
Backtrace	view::routes.description-nearbyCities:12 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: 139Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 24LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 22City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 15SitesRelationship.php#?
App\Avia\Infrastructure\Model\Airline: 12Airline.php#?
App\Avia\Infrastructure\Model\Country: 10Country.php#?
App\Avia\Infrastructure\Model\Airport: 2Airport.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: ZR0V7HVPvem6nC57yplIpcbAqEwAy5FBdAQLUfia
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-doha-to-zaragoza-doh-zaz?_url=%2Fche...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-doha-to-zaragoza-doh-zaz

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-doha-to-zaragoza-doh-zaz"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjZFc0pIdm5hZTd6Z256WHJnRi9ST1E9PSIsInZhbHVlIjoiTWpNOFhxejJiVWsyaGcxZ2hLTzkrOFN1ZUtmZjFxK3BGM2dzZHU0dlJJU1VrZE5FWFJJeHhvbW0xY3BRVDFJV2lzRmNhbHk2ZlBjeDZmN2hZMERLT2JmMlp3Vm1IS20rSlRSelFVbGd6RU9XQXpLS25QZldBQnNUOHJjOFJsdkwiLCJtYWMiOiIwN2Q5YjMxMWYwNDQ1YTY5ZTlhOGM0NzQ4ZWVhNTQxNjkxMWMyYTc3ZTJhMjM3N2M5ZDFiNGVmZThmMzQ4NThlIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IlZYc1FYTVFpaDRJeWFmYlM2aGRocEE9PSIsInZhbHVlIjoieEJ5RFk2Y3luRTU2cVllVWdWM1FWdlJTdmRMT0Uyd2pKM20rRGRGSElnWFpsQ2wxTXBWalRVVEtSZHZvaEVWYVhjbVRGdTlZcHdmanhWTlFiaEs1RDcxaDJTa0VBWWIzc2dBckhPMWs4Z3RIbXJ3aTU5Ymo2RG5vYXJLcmdnQTciLCJtYWMiOiIzYjExZDIxNjcyYTIzYzhjNGZlMzBmNjZiOGFhYzBmZWI1MWFmYTUzM2UwZmE4YzJiNWFjYWJmMDIwZWQxNWU4IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjZFc0pIdm5hZTd6Z256WHJnRi9ST1E9PSIsInZhbHVlIjoiTWpNOFhxejJiVWsyaGcxZ2hLTzkrOFN1ZUtmZjFxK3BGM2dzZHU0dlJJU1VrZE5FWFJJeHhvbW0xY3BRVDFJV2lzRmNhb ▶"
  ]
  "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" => "ZR0V7HVPvem6nC57yplIpcbAqEwAy5FBdAQLUfia"
  "lowcostclub_session" => "bJA5gB2RIIQtsY5A3QVq9uPAZzcWTorCsdlhS4rL"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Mon, 12 May 2025 08:30:51 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""cad5ba7d0472b487186a71e37d17cb83""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijg5VjB2bGlOeG5vUjFVMXlyeDNHMGc9PSIsInZhbHVlIjoiVk1SNForYmNwam1SNkp3UkQ4MkxwOW1zR25XdG5OUFlib0tJd01YLzZXMVF0TjVBeTFWaXhFNmRDOUxYWnRUK29uR0thU043UFZEeTdxek1valhCWkt2VENaMyt1aXE1MTQwMU1hMnlEclpvakJhREdMUHJjR2ZjbVo5Z0p0bTEiLCJtYWMiOiI1NjEwZWFjNjg5ZjFmYzY0NjI0OTEwYWZlYzA2MzVmNDVhZDhjNDY4ZTljNmRmYTdjZDIzZDg0NWY1MDJlYmI3IiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 10:30:51 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ijg5VjB2bGlOeG5vUjFVMXlyeDNHMGc9PSIsInZhbHVlIjoiVk1SNForYmNwam1SNkp3UkQ4MkxwOW1zR25XdG5OUFlib0tJd01YLzZXMVF0TjVBeTFWaXhFNmRDOUxYWnRUK29uR0thU ▶"
    1 => "lowcostclub_session=eyJpdiI6InlkcFREMXl1Z3F0MzJ1cll2dGFjeEE9PSIsInZhbHVlIjoiaXR3Q1pNSHVrTTRCYUZMZ0hacGZ5VmQrNUpEWjltMGR2dDZyV0tDUUkvanl4TGtVc09VR3dhZlpOem45VTFkQ3VBTW5kYVpaaG1sVFRCa0lwdXhycGJrL1V6Y21wVXlORjhSU2VraEExK0ZQbGlDQ1NGTHhBcStqTEpvNkZ4WHYiLCJtYWMiOiJmYzcwOTE4ZTVhOWU1ZjlmMDMyYTJiOTU4MmZkYThjMDQ4ODk5YjgyYmEwYjY3ZWI1ZTJjNGZiYjUyNzViZGRiIiwidGFnIjoiIn0%3D; expires=Mon, 12 May 2025 10:30:51 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6InlkcFREMXl1Z3F0MzJ1cll2dGFjeEE9PSIsInZhbHVlIjoiaXR3Q1pNSHVrTTRCYUZMZ0hacGZ5VmQrNUpEWjltMGR2dDZyV0tDUUkvanl4TGtVc09VR3dhZlpOem45VTFk ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijg5VjB2bGlOeG5vUjFVMXlyeDNHMGc9PSIsInZhbHVlIjoiVk1SNForYmNwam1SNkp3UkQ4MkxwOW1zR25XdG5OUFlib0tJd01YLzZXMVF0TjVBeTFWaXhFNmRDOUxYWnRUK29uR0thU043UFZEeTdxek1valhCWkt2VENaMyt1aXE1MTQwMU1hMnlEclpvakJhREdMUHJjR2ZjbVo5Z0p0bTEiLCJtYWMiOiI1NjEwZWFjNjg5ZjFmYzY0NjI0OTEwYWZlYzA2MzVmNDVhZDhjNDY4ZTljNmRmYTdjZDIzZDg0NWY1MDJlYmI3IiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 10:30:51 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijg5VjB2bGlOeG5vUjFVMXlyeDNHMGc9PSIsInZhbHVlIjoiVk1SNForYmNwam1SNkp3UkQ4MkxwOW1zR25XdG5OUFlib0tJd01YLzZXMVF0TjVBeTFWaXhFNmRDOUxYWnRUK29uR0thU ▶"
    1 => "lowcostclub_session=eyJpdiI6InlkcFREMXl1Z3F0MzJ1cll2dGFjeEE9PSIsInZhbHVlIjoiaXR3Q1pNSHVrTTRCYUZMZ0hacGZ5VmQrNUpEWjltMGR2dDZyV0tDUUkvanl4TGtVc09VR3dhZlpOem45VTFkQ3VBTW5kYVpaaG1sVFRCa0lwdXhycGJrL1V6Y21wVXlORjhSU2VraEExK0ZQbGlDQ1NGTHhBcStqTEpvNkZ4WHYiLCJtYWMiOiJmYzcwOTE4ZTVhOWU1ZjlmMDMyYTJiOTU4MmZkYThjMDQ4ODk5YjgyYmEwYjY3ZWI1ZTJjNGZiYjUyNzViZGRiIiwidGFnIjoiIn0%3D; expires=Mon, 12-May-2025 10:30:51 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6InlkcFREMXl1Z3F0MzJ1cll2dGFjeEE9PSIsInZhbHVlIjoiaXR3Q1pNSHVrTTRCYUZMZ0hacGZ5VmQrNUpEWjltMGR2dDZyV0tDUUkvanl4TGtVc09VR3dhZlpOem45VTFk ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "ZR0V7HVPvem6nC57yplIpcbAqEwAy5FBdAQLUfia"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-doha-to-zaragoza-doh-zaz?_url=%2Fcheap-flights-from-doha-to-zaragoza-doh-zaz"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-12 08:30:51	GET	/cheap-flights-from-doha-to-zaragoza-doh-zaz	40 48 225

1 x Application (89.05%)	431ms
1 x Booting (10.95%)	52.94ms

Cheap flights Doha — Zaragoza (DOH — ZAZ)

Choose your dates to find the flight:

Good to know - Cheap tickets Doha — Zaragoza

Popular airlines flying Doha — Zaragoza

Airlines with direct flights

Other airlines flying with transfers

Routes from nearby cities to Zaragoza

Popular International routes from Doha

Popular routes from Zaragoza

Related pages

Select your currency

All currencies

Select your language

All languages