SitesRelationshipsSqlRepository.php#34aviatickets4.95msselect * from `sites_relationships` where `us` = 'cheap-flights-from-toyama-to-bora-bora-toy-bob' limit 1

Bindings	0: cheap-flights-from-toyama-to-bora-bora-toy-bob
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.1msselect * from `flights_by` where `flights_by`.`id` = '1109316' 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.42msselect * from `cities` where `cities`.`id` = 6203 limit 1

Bindings	0: 6203
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.31msselect * from `countries` where `countries`.`id` = 211 limit 1

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

Bindings	0: 767
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.19msselect * from `countries` where `countries`.`id` = 166 limit 1

Bindings	0: 166
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#33aviatickets920μs

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

Bindings	0: 1109316
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.32msselect * 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.59ms

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

Bindings	0: 6203 1: 767 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.55msselect * from `monthly_price_statistics` where `origin_city_id` = 6203 and `destination_city_id` = 767 limit 1

Bindings	0: 6203 1: 767
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.06ms

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

Bindings	0: 6203 1: 767
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.36msselect distinct `airline_id` from `timetables` where `origin_city_id` = 6203

Bindings	0: 6203
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.45msselect distinct `airline_id` from `timetables` where `origin_city_id` = 767

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

LocalRouteRepository.php#558aviatickets1.57ms

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

Bindings	0: 6203 1: 1 2: 1000 3: 0 4: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:558 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:563 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:62

NearbyCitiesAggregateDbProvider.php#73aviatickets3.08ms

select * from `flights_by` where `origin_city_id` in (3225, 4030, 4388, 3007, 6319, 8647, 8419, 6120, 8643, 8786) and `destination_city_id` = 767 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 3225 1: 4030 2: 4388 3: 3007 4: 6319 5: 8647 6: 8419 7: 6120 8: 8643 9: 8786 10: 767 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.52msselect * from `cities` where `cities`.`id` in (6319, 8647)

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

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.2msselect * from `sites_relationships` where `sites_relationships`.`id` in (248943, 342515)

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

Bindings	0: 6319
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.3msselect * from `offers` where `origin_city_id` = 6203 and `destination_city_id` = 767

Bindings	0: 6203 1: 767
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.34ms

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

Bindings	0: 6203 1: 1109316 2: 211 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.55msselect * from `cities` where `cities`.`id` in (6203)

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.52msselect * from `cities` where `cities`.`id` in (776, 887, 1115)

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.16msselect * from `sites_relationships` where `sites_relationships`.`id` in (1109317, 1109318, 1109319)

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#412aviatickets2.01ms

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

Bindings	0: 6203 1: 211 2: 0 3: 0 4: 1109317
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 `cities` where `cities`.`id` in (6203)

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.19msselect * from `cities` where `cities`.`id` in (4081, 8905)

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#412aviatickets920μsselect * from `sites_relationships` where `sites_relationships`.`id` in (335598, 335621)

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.67msselect * from `countries` where `countries`.`id` in (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.13ms

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

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

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.34msselect * from `cities` where `cities`.`id` in (4081, 4539, 6319, 8325, 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/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets1.54msselect * from `countries` where `countries`.`id` in (92, 211, 214, 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/Http/Controllers/RoutesController.php:216

LocalRouteRepository.php#149aviatickets1.56msselect * from `sites_relationships` where `sites_relationships`.`id` in (43247, 43280, 43286, 43304, 392633)

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

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

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

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.27msselect * from `cities` where `cities`.`id` in (1988, 4620, 5744, 6319, 8647)

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#359aviatickets900μsselect * from `sites_relationships` where `sites_relationships`.`id` in (335585, 335602, 335603, 335613, 335615)

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.01msselect * from `countries` where `countries`.`id` in (211)

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

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

Bindings	0: 6203 1: 767
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.13ms

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

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

Bindings	0: 767 1: 6203
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

description-nearbyCities.blade.php#12aviatickets1.21msselect * from `cities` where `cities`.`id` = 6203 limit 1

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

LocalRouteRepository.php#149aviatickets1.93ms

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#149aviatickets1.16msselect * 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.9msselect * 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.5msselect * 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.09ms

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\LocalRoute: 37LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 36City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 28SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 13Country.php#?
App\Avia\Infrastructure\Model\Timetable: 6Timetable.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: uynYjMetosDn2bZxnRvZTT85c6JqfpPnCluPvxlD
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-toyama-to-bora-bora-toy-bob?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-toyama-to-bora-bora-toy-bob

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-toyama-to-bora-bora-toy-bob"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxCb3k5Ulo5VWNqRDFObjdadFIyZVE9PSIsInZhbHVlIjoiT0JvN0xFb1I2SFJuTFkvakMzOThwVkhtNXA4bTRMVkZOeFcrS1oybGNzYnJqb2NJNmxqWFpRd3FSNnZiNk5UZlpJVExqK0E1WVg3MlhCZG1pTTJIZFFpb2xMMWxpa3pkcVNpZkw1TVZDanpjQ2ZCanFEMlVmdHhIQ01pRU5uWXgiLCJtYWMiOiIwNjE3NDYwNzlkODRmYWYzYjk2ZTJmZDdmZmFlNDg2Y2RjY2UyNDhiODgxMjNmNDI0OGNkMzFlMzkzOTRjYWE4IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IkUrcWxEdDhyVXh3aElIL2wrZENWN1E9PSIsInZhbHVlIjoiVWhxTkNKeHFEQ2hUcVZDYVlxS0kwTksvODZGSnpGOXA1d3VJVGcxOXI0b2dQME1nQ1Rtd0J0bi9zQlorVklQdG9TK3JYd1E3MGpZOGZhK294YXFjZ2JQaFhEampMNXNWaWNFR0lEbDc1RnltYUF6QmVRN2M5a1FIN2t0ajc2d2EiLCJtYWMiOiJjNjU4MWNhZjZmYmYzN2I1ZTlkYzdmMGJjM2U1ZGRjNTMyOTZiNzk0ZGI0Mjk1YjNlMzcyODA4ZWI5NTEwNjZmIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkxCb3k5Ulo5VWNqRDFObjdadFIyZVE9PSIsInZhbHVlIjoiT0JvN0xFb1I2SFJuTFkvakMzOThwVkhtNXA4bTRMVkZOeFcrS1oybGNzYnJqb2NJNmxqWFpRd3FSNnZiNk5UZlpJVExqK ▶"
  ]
  "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" => "uynYjMetosDn2bZxnRvZTT85c6JqfpPnCluPvxlD"
  "lowcostclub_session" => "Bn9mPwP8rJOaSRMd6FOiD9cx8lTd1Pq3LQjFdHxW"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Mon, 05 May 2025 13:44:21 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""216b5439819f35adbc921dedbde055a6""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlpSlcrT2haQmdoQ0ROY1VWTUhMRHc9PSIsInZhbHVlIjoidGQwSmU3clkzZm1MTlp1bnlua24rblFRdHJNQktIQXBJbTE1SGwvRFJ5Ym4wYkd2YUxCSXQrdFVKcjhBTU5oOW1jajFpL1lCZ090RTBtZjg1QUk1ZWZIa2lSSFd4VW1UYnl3akQxekVWUlpNWnBIY0NFY3JHMFZtMWZFTk5GQUMiLCJtYWMiOiI2M2QyYzY4Y2Y5ZWJjM2JiNWU1MzM2OGFkZmQ5YTZiMDJmMDFjYWIyYjlhZWI1Y2M0ZDJjNjkzZWVhYTBjZDE3IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 15:44:21 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjlpSlcrT2haQmdoQ0ROY1VWTUhMRHc9PSIsInZhbHVlIjoidGQwSmU3clkzZm1MTlp1bnlua24rblFRdHJNQktIQXBJbTE1SGwvRFJ5Ym4wYkd2YUxCSXQrdFVKcjhBTU5oOW1jajFpL ▶"
    1 => "lowcostclub_session=eyJpdiI6IkE2TmUvdCs2ZEhDdmtMRnRWL2ZPbVE9PSIsInZhbHVlIjoiMWl2OXFOV2Y3VjlUWW1CVHlSTVlxd1F4SUFZR0VYQVpTR0U0SGJSZGowUGZRMmFYWkNqcmExMWIvUVg0QTFBMG1rMUNHckV4YkZDcmZ6aDFkTzJzdmdCT2FQS0JsRUpLZVZHeGNwSVA1ZGJUc2tHN3hLWm4yVWRzVm81b09id1kiLCJtYWMiOiI4OGQzNGVlMDI4NzE1NGUwZDc3ZjI5YWVmYmM0Njg4ZWRmMTVlODMwYjNiNGU4ZjliYTVkMGY0NDI5Njk3MGRlIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 15:44:21 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IkE2TmUvdCs2ZEhDdmtMRnRWL2ZPbVE9PSIsInZhbHVlIjoiMWl2OXFOV2Y3VjlUWW1CVHlSTVlxd1F4SUFZR0VYQVpTR0U0SGJSZGowUGZRMmFYWkNqcmExMWIvUVg0QTFB ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlpSlcrT2haQmdoQ0ROY1VWTUhMRHc9PSIsInZhbHVlIjoidGQwSmU3clkzZm1MTlp1bnlua24rblFRdHJNQktIQXBJbTE1SGwvRFJ5Ym4wYkd2YUxCSXQrdFVKcjhBTU5oOW1jajFpL1lCZ090RTBtZjg1QUk1ZWZIa2lSSFd4VW1UYnl3akQxekVWUlpNWnBIY0NFY3JHMFZtMWZFTk5GQUMiLCJtYWMiOiI2M2QyYzY4Y2Y5ZWJjM2JiNWU1MzM2OGFkZmQ5YTZiMDJmMDFjYWIyYjlhZWI1Y2M0ZDJjNjkzZWVhYTBjZDE3IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 15:44:21 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjlpSlcrT2haQmdoQ0ROY1VWTUhMRHc9PSIsInZhbHVlIjoidGQwSmU3clkzZm1MTlp1bnlua24rblFRdHJNQktIQXBJbTE1SGwvRFJ5Ym4wYkd2YUxCSXQrdFVKcjhBTU5oOW1jajFpL ▶"
    1 => "lowcostclub_session=eyJpdiI6IkE2TmUvdCs2ZEhDdmtMRnRWL2ZPbVE9PSIsInZhbHVlIjoiMWl2OXFOV2Y3VjlUWW1CVHlSTVlxd1F4SUFZR0VYQVpTR0U0SGJSZGowUGZRMmFYWkNqcmExMWIvUVg0QTFBMG1rMUNHckV4YkZDcmZ6aDFkTzJzdmdCT2FQS0JsRUpLZVZHeGNwSVA1ZGJUc2tHN3hLWm4yVWRzVm81b09id1kiLCJtYWMiOiI4OGQzNGVlMDI4NzE1NGUwZDc3ZjI5YWVmYmM0Njg4ZWRmMTVlODMwYjNiNGU4ZjliYTVkMGY0NDI5Njk3MGRlIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 15:44:21 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IkE2TmUvdCs2ZEhDdmtMRnRWL2ZPbVE9PSIsInZhbHVlIjoiMWl2OXFOV2Y3VjlUWW1CVHlSTVlxd1F4SUFZR0VYQVpTR0U0SGJSZGowUGZRMmFYWkNqcmExMWIvUVg0QTFB ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "uynYjMetosDn2bZxnRvZTT85c6JqfpPnCluPvxlD"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-toyama-to-bora-bora-toy-bob?_url=%2Fcheap-flights-from-toyama-to-bora-bora-toy-bob"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-05 13:44:21	GET	/cheap-flights-from-toyama-to-bora-bora-toy-bob	43 48 121

1 x Application (91.68%)	316ms
1 x Booting (8.32%)	28.69ms

Cheap flights Toyama — Bora Bora (TOY — BOB)

Choose your dates to find the flight:

Good to know - Cheap tickets Toyama — Bora Bora

Routes from nearby cities to Bora Bora

Popular International routes from Toyama

Popular routes from Bora Bora

Popular domestic routes from Toyama

Select your currency

All currencies

Select your language

All languages