SitesRelationshipsSqlRepository.php#34aviatickets4.53msselect * from `sites_relationships` where `us` = 'cheap-flights-from-zanzibar-to-lyon-znz-lys' limit 1

Bindings	0: cheap-flights-from-zanzibar-to-lyon-znz-lys
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#125aviatickets970μsselect * from `flights_by` where `flights_by`.`id` = '887689' 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#135aviatickets930μsselect * from `cities` where `cities`.`id` = 7479 limit 1

Bindings	0: 7479
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#136aviatickets1msselect * from `countries` where `countries`.`id` = 234 limit 1

Bindings	0: 234
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.07msselect * from `cities` where `cities`.`id` = 3774 limit 1

Bindings	0: 3774
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.12msselect * from `countries` where `countries`.`id` = 120 limit 1

Bindings	0: 120
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#33aviatickets930μs

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

Bindings	0: 887689
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.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.14ms

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

Bindings	0: 7479 1: 3774 2: 2025-05-03 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.19msselect * from `monthly_price_statistics` where `origin_city_id` = 7479 and `destination_city_id` = 3774 limit 1

Bindings	0: 7479 1: 3774
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.11ms

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

Bindings	0: 7479 1: 3774
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.01msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7479

Bindings	0: 7479
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#502aviatickets2.12msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3774

Bindings	0: 3774
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.2ms

select * from `airlines` where `id` in (136, 1864, 2949, 3630, 4078, 4929, 5075, 17920, 65824, 259328) order by `name` asc

Bindings	0: 136 1: 1864 2: 2949 3: 3630 4: 4078 5: 4929 6: 5075 7: 17920 8: 65824 9: 259328
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.12ms

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

Bindings	0: 7479 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.16ms

select * from `flights_by` where `origin_city_id` in (3063, 8666, 6053, 3887, 8876, 3807, 4277, 8388, 2830, 2666) and `destination_city_id` = 3774 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3063 1: 8666 2: 6053 3: 3887 4: 8876 5: 3807 6: 4277 7: 8388 8: 2830 9: 2666 10: 3774 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.49msselect * from `cities` where `cities`.`id` in (3807)

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

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.36msselect * from `sites_relationships` where `sites_relationships`.`id` in (1152712)

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

Bindings	0: 3807
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#52aviatickets940μsselect * from `offers` where `origin_city_id` = 7479 and `destination_city_id` = 3774

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

LocalRouteRepository.php#447aviatickets1.54ms

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

Bindings	0: 7479 1: 887689 2: 234 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:447 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:451 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:202

LocalRouteRepository.php#447aviatickets1.12msselect * from `cities` where `cities`.`id` in (7479)

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.03msselect * from `cities` where `cities`.`id` in (3884, 4212, 4880)

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#447aviatickets900μsselect * from `sites_relationships` where `sites_relationships`.`id` in (887690, 887693, 887698)

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#125aviatickets1msselect * from `countries` where `countries`.`id` = 219 limit 1

Bindings	0: 219
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.44ms

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

Bindings	0: 7479 1: 234 2: 0 3: 0 4: 887690
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.2msselect * from `cities` where `cities`.`id` in (7479)

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.09msselect * from `cities` where `cities`.`id` in (4081, 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#412aviatickets1.38msselect * from `sites_relationships` where `sites_relationships`.`id` in (377042, 377097)

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.28msselect * from `countries` where `countries`.`id` in (242, 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#149aviatickets1.5ms

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

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

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.13msselect * from `cities` where `cities`.`id` in (1811, 2686, 3430, 3505, 4081)

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 (124, 134, 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#149aviatickets980μsselect * from `sites_relationships` where `sites_relationships`.`id` in (198584, 198650, 198697, 198706, 198763)

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

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

Bindings	0: 7479 1: 234 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.15msselect * from `cities` where `cities`.`id` in (7479)

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.1msselect * from `cities` where `cities`.`id` in (287, 2830, 3063, 3887, 6868)

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.3msselect * from `sites_relationships` where `sites_relationships`.`id` in (377004, 377033, 377067, 377091, 1009191)

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 (234)

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

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

Bindings	0: 7479 1: 3774
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.91ms

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

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

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

LocalRouteRepository.php#520aviatickets1.58msselect * from `sites_relationships` where `sites_relationships`.`id` in (199019)

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

Bindings	0: 3774
Backtrace	app/Http/Controllers/RoutesController.php:547 app/Http/Controllers/RoutesController.php:279 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

RoutesController.php#548aviatickets1.45msselect * from `cities` where `cities`.`id` = 7479 limit 1

Bindings	0: 7479
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#32aviatickets1.02msselect * from `cities` where `cities`.`id` = 3774 limit 1

Bindings	0: 3774
Backtrace	view::routes.description-nearbyCities:32 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

description-nearbyCities.blade.php#32aviatickets990μsselect * from `cities` where `cities`.`id` = 7479 limit 1

Bindings	0: 7479
Backtrace	view::routes.description-nearbyCities:32 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#149aviatickets1.51ms

select * from `flights_by` where `origin_city_id` = 4539 and (`price_one_way` > 0 or `price` > 0) and `id` not in (240458, 46235, 180255, 46251, 201516, 32301) order by `count` desc limit 9

Bindings	0: 4539 1: 0 2: 0 3: 240458 4: 46235 5: 180255 6: 46251 7: 201516 8: 32301
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:149 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:153 app/Avia/Application/SeoRoutesHandler.php:54

LocalRouteRepository.php#149aviatickets890μ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.1msselect * 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.14msselect * 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#149aviatickets1.03ms

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

Backtrace

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

App\Avia\Infrastructure\Model\Timetable: 149Timetable.php#?
App\Avia\Infrastructure\Model\City: 38City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 37LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 28SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 13Country.php#?
App\Avia\Infrastructure\Model\Airline: 10Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: VabNsgZCb2Jd85o8ZtJCAW7Uwz0yv8JX1p1V4qY4
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-zanzibar-to-lyon-znz-lys?_url=%2Fche...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-zanzibar-to-lyon-znz-lys

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-zanzibar-to-lyon-znz-lys"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVPYWhYb2hjckxUMmV4QSt6UVlsYnc9PSIsInZhbHVlIjoiK1JxaDVGVUJURElWbFc3NEN6QTJPdm9JRlpwbGVHU1h5T1VYWWZ0MHNCSm14dWU0TmhUSFN6SUxaaWRtRTVraDN4M1dKamtDNFcvQWo2V2pHQWdSQ09mL2pOQXFJNWtsSUFZUTNPY3haNDg5emY4MExoS2xwZVRvekxMOWV2cWMiLCJtYWMiOiI0MTdhYTYxNGI3NmMwMjE3MDM4OWRmNjgyMjcyOTE1OWY3NDBkMTVjOTYyZTQyOWIzYTNjZWQ0MDIwOGIyZThhIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6InZzR2VjSHk2K0ROa0t5YXRmZW5NOEE9PSIsInZhbHVlIjoiTHZZeGIyekNtNFhjdmFOSFVRWkFRczNHVG9lM2NmbGg5WjJzeFBDOXJtUTFEWXRSN1ZTNXhTQzAvK09UOXBPOVJVSElSZUVaUDVYbnFhT3NLaWtrS09wcXJXSFp4RUkzV284Nkt1QmRmWVRJaVRwaWptM3BzMzBIVmpDdmJ4VEIiLCJtYWMiOiI3NjIyNDYyM2NmM2RkYTgwYWRkYWIxNGUwYjYzYmY3ODc3NjVmYzZmOGNiMzc3MjA2YmExOGJlZWEwMmNjNGZmIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InVPYWhYb2hjckxUMmV4QSt6UVlsYnc9PSIsInZhbHVlIjoiK1JxaDVGVUJURElWbFc3NEN6QTJPdm9JRlpwbGVHU1h5T1VYWWZ0MHNCSm14dWU0TmhUSFN6SUxaaWRtRTVraDN4M1dKa ▶"
  ]
  "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" => "VabNsgZCb2Jd85o8ZtJCAW7Uwz0yv8JX1p1V4qY4"
  "lowcostclub_session" => "cWNSfHUccw3Z4jnfYyxakLN2GwaZ3S42UH8ONWnX"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Mon, 05 May 2025 14:37:53 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""1d48092863c7f1365773df810845064b""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktqSzZHYXBPV042czNpSS9IaStjWmc9PSIsInZhbHVlIjoiQ1NOSndTQnhEdlN4UmJkeFVSRUJ5YXd3QlZ5Q1FpVFRoU1NzcXJmaEo3WkorV0ZkR3hOYVhTL1NTUkJaRGphbms1MVNqbjM1VDc4WUZiN1FvZVVlQ0MyMHNySFhWUkViSVZuQjJXd04zZUozZ1Y3OTl2QnRDNUx1aFhWUmxmVW8iLCJtYWMiOiJhMDU2NmU4OWM0OGExM2NmMjlkNjY5NWY5NzcxZjUwODZiODMzNDQyZmEzNjBjZGMyYTAyYjNkYTQ4NDVjZDYyIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 16:37:53 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IktqSzZHYXBPV042czNpSS9IaStjWmc9PSIsInZhbHVlIjoiQ1NOSndTQnhEdlN4UmJkeFVSRUJ5YXd3QlZ5Q1FpVFRoU1NzcXJmaEo3WkorV0ZkR3hOYVhTL1NTUkJaRGphbms1MVNqb ▶"
    1 => "lowcostclub_session=eyJpdiI6InVHVVVmdXROTW5tQ0VHbEsxNUZyNEE9PSIsInZhbHVlIjoiQmgweWtDa2EvZkgwVHU5QlRzdWJENTBUWldjbjA2YnNsUTlnd2dJclRVVTBsRGRhRWNiZVVYZjdXM0RsdWJuTnBOS3JKeGRFemd6RkplZVdPN29uYWswL0tJenlVMDZRV2pnMGlxZXpnWlZFSUZpY3ZONG1yZmZVdEFpdXJmMUkiLCJtYWMiOiJmZmUwYjFhZWI1YTI2Y2FlMDg5YmU0NWQ5YTRhNmUyNjFmMjAxOTlmODlhMzYxZmRjY2MzYTI4MTdhM2UzOWU5IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 16:37:53 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6InVHVVVmdXROTW5tQ0VHbEsxNUZyNEE9PSIsInZhbHVlIjoiQmgweWtDa2EvZkgwVHU5QlRzdWJENTBUWldjbjA2YnNsUTlnd2dJclRVVTBsRGRhRWNiZVVYZjdXM0RsdWJu ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktqSzZHYXBPV042czNpSS9IaStjWmc9PSIsInZhbHVlIjoiQ1NOSndTQnhEdlN4UmJkeFVSRUJ5YXd3QlZ5Q1FpVFRoU1NzcXJmaEo3WkorV0ZkR3hOYVhTL1NTUkJaRGphbms1MVNqbjM1VDc4WUZiN1FvZVVlQ0MyMHNySFhWUkViSVZuQjJXd04zZUozZ1Y3OTl2QnRDNUx1aFhWUmxmVW8iLCJtYWMiOiJhMDU2NmU4OWM0OGExM2NmMjlkNjY5NWY5NzcxZjUwODZiODMzNDQyZmEzNjBjZGMyYTAyYjNkYTQ4NDVjZDYyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 16:37:53 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IktqSzZHYXBPV042czNpSS9IaStjWmc9PSIsInZhbHVlIjoiQ1NOSndTQnhEdlN4UmJkeFVSRUJ5YXd3QlZ5Q1FpVFRoU1NzcXJmaEo3WkorV0ZkR3hOYVhTL1NTUkJaRGphbms1MVNqb ▶"
    1 => "lowcostclub_session=eyJpdiI6InVHVVVmdXROTW5tQ0VHbEsxNUZyNEE9PSIsInZhbHVlIjoiQmgweWtDa2EvZkgwVHU5QlRzdWJENTBUWldjbjA2YnNsUTlnd2dJclRVVTBsRGRhRWNiZVVYZjdXM0RsdWJuTnBOS3JKeGRFemd6RkplZVdPN29uYWswL0tJenlVMDZRV2pnMGlxZXpnWlZFSUZpY3ZONG1yZmZVdEFpdXJmMUkiLCJtYWMiOiJmZmUwYjFhZWI1YTI2Y2FlMDg5YmU0NWQ5YTRhNmUyNjFmMjAxOTlmODlhMzYxZmRjY2MzYTI4MTdhM2UzOWU5IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 16:37:53 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6InVHVVVmdXROTW5tQ0VHbEsxNUZyNEE9PSIsInZhbHVlIjoiQmgweWtDa2EvZkgwVHU5QlRzdWJENTBUWldjbjA2YnNsUTlnd2dJclRVVTBsRGRhRWNiZVVYZjdXM0RsdWJu ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "VabNsgZCb2Jd85o8ZtJCAW7Uwz0yv8JX1p1V4qY4"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-zanzibar-to-lyon-znz-lys?_url=%2Fcheap-flights-from-zanzibar-to-lyon-znz-lys"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-05 14:37:53	GET	/cheap-flights-from-zanzibar-to-lyon-znz-lys	45 54 276

1 x Application (89.69%)	280ms
1 x Booting (10.3%)	32.14ms

Cheap flights Zanzibar — Lyon (ZNZ — LYS)

Choose your dates to find the flight:

Good to know - Cheap tickets Zanzibar — Lyon

Popular airlines flying Zanzibar — Lyon

Routes from nearby cities to Lyon

Popular International routes from Zanzibar

Popular routes from Lyon

Popular domestic routes from Zanzibar

Related pages

Select your currency

All currencies

Select your language

All languages