SitesRelationshipsSqlRepository.php#34aviatickets4.03msselect * from `sites_relationships` where `us` = 'cheap-flights-from-london-to-derry-lon-ldy' limit 1

Bindings	0: cheap-flights-from-london-to-derry-lon-ldy
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.7msselect * from `flights_by` where `flights_by`.`id` = '192605' and `flights_by`.`id` is not null limit 1

Bindings	0: [object Object]
Backtrace	app/Http/Controllers/RoutesController.php:125 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#135aviatickets1.32msselect * from `cities` where `cities`.`id` = 3654 limit 1

Bindings	0: 3654
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#136aviatickets910μsselect * from `countries` where `countries`.`id` = 17 limit 1

Bindings	0: 17
Backtrace	app/Http/Controllers/RoutesController.php:136 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

RoutesController.php#137aviatickets940μsselect * from `cities` where `cities`.`id` = 3500 limit 1

Bindings	0: 3500
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#138aviatickets970μsselect * from `countries` where `countries`.`id` = 17 limit 1

Bindings	0: 17
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#33aviatickets950μs

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

Bindings	0: 192605
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#31aviatickets940μsselect * 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.67ms

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

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

Bindings	0: 3654 1: 3500
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.81ms

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

Bindings	0: 3654 1: 3500
Backtrace	app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:470 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/AirlineSqlRepository.php:461 app/Http/Controllers/RoutesController.php:162

AirlineSqlRepository.php#470aviatickets1.3msselect * from `airlines` where `airlines`.`id` in (4282, 17878)

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#502aviatickets5.81msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3654

Bindings	0: 3654
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.16msselect distinct `airline_id` from `timetables` where `origin_city_id` = 3500

Bindings	0: 3500
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.33msselect * from `airlines` where `id` in (1352, 2293, 5829, 65567, 17141650) order by `name` asc

Bindings	0: 1352 1: 2293 2: 5829 3: 65567 4: 17141650
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.06ms

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

Bindings	0: 3654 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.76ms

select * from `flights_by` where `origin_city_id` in (7710, 1004, 3030, 6878, 1366, 4535, 8328, 638, 4480, 823) and `destination_city_id` = 3500 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 7710 1: 1004 2: 3030 3: 6878 4: 1366 5: 4535 6: 8328 7: 638 8: 4480 9: 823 10: 3500 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

OfferSqlRepository.php#52aviatickets1.02msselect * from `offers` where `origin_city_id` = 3654 and `destination_city_id` = 3500

Bindings	0: 3654 1: 3500
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.23ms

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

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

LocalRouteRepository.php#447aviatickets900μsselect * from `cities` where `cities`.`id` in (3654)

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.11msselect * from `cities` where `cities`.`id` in (3505, 3510, 3511)

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#447aviatickets1msselect * from `sites_relationships` where `sites_relationships`.`id` in (192606, 192608, 192609)

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

Bindings	0: 125
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.67ms

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

Bindings	0: 3654 1: 17 2: 0 3: 0 4: 192606
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#412aviatickets900μsselect * from `cities` where `cities`.`id` in (3654)

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#412aviatickets970μsselect * from `cities` where `cities`.`id` in (2686, 4081)

Backtrace

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

LocalRouteRepository.php#412aviatickets950μsselect * from `sites_relationships` where `sites_relationships`.`id` in (192450, 192731)

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#412aviatickets890μsselect * from `countries` where `countries`.`id` in (134, 248)

Backtrace

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

LocalRouteRepository.php#149aviatickets1.41ms

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

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

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 (494, 684, 4539, 5582, 5610)

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.29msselect * from `countries` where `countries`.`id` in (70, 92, 136)

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#149aviatickets950μsselect * from `sites_relationships` where `sites_relationships`.`id` in (1150908, 1150910, 1150931, 1267418, 1267419)

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

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

Bindings	0: 3654 1: 17 2: 0 3: 0
Backtrace	app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363 app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets880μsselect * from `cities` where `cities`.`id` in (3654)

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#359aviatickets930μsselect * from `cities` where `cities`.`id` in (537, 2122, 3670, 3796, 9244)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

LocalRouteRepository.php#359aviatickets850μsselect * from `sites_relationships` where `sites_relationships`.`id` in (191971, 192235, 192332, 192643, 192669)

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#359aviatickets980μsselect * from `countries` where `countries`.`id` in (17)

Backtrace

app/Avia/Infrastructure/Repository/LocalRouteRepository.php:359
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:363
app/Avia/Infrastructure/Repository/LocalRouteRepository.php:330

TimetableRepository.php#39aviatickets1.13ms

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

Bindings	0: 3654 1: 3500
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.76msselect * from `airports` where `airports`.`id` in (3741)

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.5msselect * from `airports` where `airports`.`id` in (3802, 3981, 9651)

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.15msselect * from `airlines` where `airlines`.`id` in (4282, 17878)

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

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

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

Bindings	0: 3500 1: 3654
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.49msselect * from `sites_relationships` where `sites_relationships`.`id` in (183770)

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

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

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

App\Avia\Infrastructure\Model\Timetable: 257Timetable.php#?
App\Avia\Infrastructure\Model\LocalRoute: 27LocalRoute.php#?
App\Avia\Infrastructure\Model\City: 23City.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 18SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 9Country.php#?
App\Avia\Infrastructure\Model\Airline: 9Airline.php#?
App\Avia\Infrastructure\Model\Airport: 4Airport.php#?
App\Avia\Infrastructure\Model\Route: 1Route.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: HtuBceIXiPk93vsH2zS2bcAeY66bMmr2nMc87v7M
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-london-to-derry-lon-ldy?_url=%2Fchea...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-london-to-derry-lon-ldy

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-london-to-derry-lon-ldy"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InVvVjZ4U0xCK2lCRFlyVjBuTDNtY2c9PSIsInZhbHVlIjoiTXMycXI0TVArRlFteXNDcEFhU2xZV3F1OXZlZVhiS1JDbXdkdVRvSFZLRVE4UlJnNGZxRWQrdE0rQ1crdTg2UElWMTZBdzg2M3N4dVlVdmlPa0wxdUVxcHpETkNwOU1sV2dodE5yOVB3SGxjMzdOSllUZkNpaU1aSTJTVnVBcTAiLCJtYWMiOiJiMGNhMmM3MDA4ZDFmNTA5MTcwNGQyNGEwZGM2M2VkMGJkYTJmN2IxN2VmMGU0ZDNlMjY0NjU3ZTUwZjVjZWQ0IiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IlpsakkwaU5wcFRnTno2d2ZXQS9jMVE9PSIsInZhbHVlIjoiR3k5WUFxaGQ1dlg1b2habFZhaDBnbWNhZWxQTytkSHkwZGtncmFmRUNYRkQzeW8vRDBtVFJnTFZ3S3V5RVF3TXBBVmdwQ2VwcDBBamUyT0JLN0JWVDNrY3NDdGRWWHJDZjRTNXdlK1Mzczh0aHczMkNLbFoyVVN6Rld5UWFFWUoiLCJtYWMiOiJmMWQ1YzBkOTFmZjhlYWI1NjgxYjk5NzRmYWJkNDJmYmYxMWE3NzMxMGYwYWExOGMwZjgzY2M4ZGU0OWI4NzFkIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InVvVjZ4U0xCK2lCRFlyVjBuTDNtY2c9PSIsInZhbHVlIjoiTXMycXI0TVArRlFteXNDcEFhU2xZV3F1OXZlZVhiS1JDbXdkdVRvSFZLRVE4UlJnNGZxRWQrdE0rQ1crdTg2UElWMTZBd ▶"
  ]
  "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" => "HtuBceIXiPk93vsH2zS2bcAeY66bMmr2nMc87v7M"
  "lowcostclub_session" => "vyeNVhnt6bK0kR5XF9R92AEMo5qpQ7wUOg4DqdIL"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Mon, 05 May 2025 15:22:05 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""ee8e4f5089a3b31b7973c2f6909e9c69""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllmZVlYUTVTOUdxN1lIUWVkRXVadHc9PSIsInZhbHVlIjoiZFdoM3JWQmRLcjBMMyt3NGR4OFpkb2JCcW1EUE8zTDBBMU1lZ2hSYjVybUd5RGFPUlRCa1VOWjhLMi9BZmVxZHQvSW94V2Q4NXZrd0NhaDJJWHFtZy9wMWN1ZHdHVE9SZkliQm9xMXN1QzBPUWlWT3N4dzRhc2EreUdEOGd1MS8iLCJtYWMiOiIxNWEzMDQ3YTk1ZjhiNDI3NWE5OWQzZTQ0Y2UxNGRkYjg3NmE0MzM3MmMxMjc4NmE3NTkxNGIyZjhkNmU2ZDQyIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 17:22:05 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IllmZVlYUTVTOUdxN1lIUWVkRXVadHc9PSIsInZhbHVlIjoiZFdoM3JWQmRLcjBMMyt3NGR4OFpkb2JCcW1EUE8zTDBBMU1lZ2hSYjVybUd5RGFPUlRCa1VOWjhLMi9BZmVxZHQvSW94V ▶"
    1 => "lowcostclub_session=eyJpdiI6IkVJb1Faa2lrQXVmVitLMjVKalhSb1E9PSIsInZhbHVlIjoiZENyYVYyY2VUSWpyWm43RmU1dTBPbXZzZ2hjR0ZjdGxTL2JYUFNlaFVKNlRkNUZ6Z1JVM0U2RDRrMm5Jd05GTFZUdHJYVzZMUW9IQWpXWjN3N1lqQVl0Q2NBN09vZFhmZm1EQWxVOGVJWXV0bE9pMld4ZVJKMGorS3k0K1lsS0giLCJtYWMiOiI1OWNjZGZlNGExNmNlYTcxOTIzYTVhZTNiZjk3ZDllOGJmMzQxYWFkZTRmMWI5YjI2YTE4YjhkMjZlMDQyMDFiIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 17:22:05 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6IkVJb1Faa2lrQXVmVitLMjVKalhSb1E9PSIsInZhbHVlIjoiZENyYVYyY2VUSWpyWm43RmU1dTBPbXZzZ2hjR0ZjdGxTL2JYUFNlaFVKNlRkNUZ6Z1JVM0U2RDRrMm5Jd05G ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllmZVlYUTVTOUdxN1lIUWVkRXVadHc9PSIsInZhbHVlIjoiZFdoM3JWQmRLcjBMMyt3NGR4OFpkb2JCcW1EUE8zTDBBMU1lZ2hSYjVybUd5RGFPUlRCa1VOWjhLMi9BZmVxZHQvSW94V2Q4NXZrd0NhaDJJWHFtZy9wMWN1ZHdHVE9SZkliQm9xMXN1QzBPUWlWT3N4dzRhc2EreUdEOGd1MS8iLCJtYWMiOiIxNWEzMDQ3YTk1ZjhiNDI3NWE5OWQzZTQ0Y2UxNGRkYjg3NmE0MzM3MmMxMjc4NmE3NTkxNGIyZjhkNmU2ZDQyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 17:22:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IllmZVlYUTVTOUdxN1lIUWVkRXVadHc9PSIsInZhbHVlIjoiZFdoM3JWQmRLcjBMMyt3NGR4OFpkb2JCcW1EUE8zTDBBMU1lZ2hSYjVybUd5RGFPUlRCa1VOWjhLMi9BZmVxZHQvSW94V ▶"
    1 => "lowcostclub_session=eyJpdiI6IkVJb1Faa2lrQXVmVitLMjVKalhSb1E9PSIsInZhbHVlIjoiZENyYVYyY2VUSWpyWm43RmU1dTBPbXZzZ2hjR0ZjdGxTL2JYUFNlaFVKNlRkNUZ6Z1JVM0U2RDRrMm5Jd05GTFZUdHJYVzZMUW9IQWpXWjN3N1lqQVl0Q2NBN09vZFhmZm1EQWxVOGVJWXV0bE9pMld4ZVJKMGorS3k0K1lsS0giLCJtYWMiOiI1OWNjZGZlNGExNmNlYTcxOTIzYTVhZTNiZjk3ZDllOGJmMzQxYWFkZTRmMWI5YjI2YTE4YjhkMjZlMDQyMDFiIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 17:22:05 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6IkVJb1Faa2lrQXVmVitLMjVKalhSb1E9PSIsInZhbHVlIjoiZENyYVYyY2VUSWpyWm43RmU1dTBPbXZzZ2hjR0ZjdGxTL2JYUFNlaFVKNlRkNUZ6Z1JVM0U2RDRrMm5Jd05G ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "HtuBceIXiPk93vsH2zS2bcAeY66bMmr2nMc87v7M"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-london-to-derry-lon-ldy?_url=%2Fcheap-flights-from-london-to-derry-lon-ldy"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-05 15:22:05	GET	/cheap-flights-from-london-to-derry-lon-ldy	46 47 349

1 x Application (90.72%)	278ms
1 x Booting (9.27%)	28.39ms

Cheap flights London — Derry (LON — LDY)

Choose your dates to find the flight:

Good to know - Cheap tickets London — Derry

Popular airlines flying London — Derry

Airlines with direct flights

Other airlines flying with transfers

Sales of tickets from London to Derry in the last 48 hours

Popular International routes from London

Popular routes from Derry

Popular domestic routes from London

Related pages

Select your currency

All currencies

Select your language

All languages