SitesRelationshipsSqlRepository.php#34aviatickets4.54msselect * from `sites_relationships` where `us` = 'cheap-flights-from-cairo-to-charleston-cai-chs' limit 1

Bindings	0: cheap-flights-from-cairo-to-charleston-cai-chs
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` = '397567' 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` = 985 limit 1

Bindings	0: 985
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.06msselect * from `countries` where `countries`.`id` = 16 limit 1

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

Bindings	0: 7569
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` = 92 limit 1

Bindings	0: 92
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#33aviatickets990μs

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

Bindings	0: 397567
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#31aviatickets960μ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#42aviatickets1.66ms

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

Bindings	0: 985 1: 7569 2: 2025-05-02 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.39msselect * from `monthly_price_statistics` where `origin_city_id` = 985 and `destination_city_id` = 7569 limit 1

Bindings	0: 985 1: 7569
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.28ms

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

Bindings	0: 985 1: 7569
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#502aviatickets8.76msselect distinct `airline_id` from `timetables` where `origin_city_id` = 985

Bindings	0: 985
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.2msselect distinct `airline_id` from `timetables` where `origin_city_id` = 7569

Bindings	0: 7569
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.21msselect * from `airlines` where `id` in (3633, 4078) order by `name` asc

Bindings	0: 3633 1: 4078
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.24ms

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

Bindings	0: 985 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.09ms

select * from `flights_by` where `origin_city_id` in (9328, 340, 1794, 275, 8789, 6142, 2445, 8167, 208, 3763) and `destination_city_id` = 7569 and (`price_one_way` > 0 or `price` > 0) limit 10

Bindings	0: 9328 1: 340 2: 1794 3: 275 4: 8789 5: 6142 6: 2445 7: 8167 8: 208 9: 3763 10: 7569 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.54msselect * from `cities` where `cities`.`id` in (2445, 6142, 8789)

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

Backtrace

app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:73
vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:58
app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:35

NearbyCitiesAggregateDbProvider.php#73aviatickets2.03msselect * from `sites_relationships` where `sites_relationships`.`id` in (486184, 1143092, 1186286)

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

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

CitySqlRepository.php#104aviatickets1.29msselect * from `cities` where `cities`.`id` = 2445 limit 1

Bindings	0: 2445
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:158

CitySqlRepository.php#104aviatickets960μsselect * from `cities` where `cities`.`id` = 8789 limit 1

Bindings	0: 8789
Backtrace	app/Avia/Infrastructure/City/CitySqlRepository.php:104 vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396 vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 app/Avia/Infrastructure/City/CitySqlRepository.php:101 app/Avia/Infrastructure/Provider/NearbyCitiesAggregateDbProvider.php:131

OfferSqlRepository.php#52aviatickets2.56msselect * from `offers` where `origin_city_id` = 985 and `destination_city_id` = 7569

Bindings	0: 985 1: 7569
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#447aviatickets3.49ms

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

Bindings	0: 985 1: 397567 2: 16 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.3msselect * from `cities` where `cities`.`id` in (985)

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.27msselect * from `cities` where `cities`.`id` in (1287, 1319, 8365)

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.04msselect * from `sites_relationships` where `sites_relationships`.`id` in (397573, 397574, 397579)

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.29msselect * from `countries` where `countries`.`id` = 128 limit 1

Bindings	0: 128
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.5ms

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

Bindings	0: 985 1: 16 2: 0 3: 0 4: 397573
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#412aviatickets980μsselect * from `cities` where `cities`.`id` in (985)

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

Backtrace

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

LocalRouteRepository.php#412aviatickets1.07msselect * from `sites_relationships` where `sites_relationships`.`id` in (58572, 58709)

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.26msselect * from `countries` where `countries`.`id` in (94, 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.62ms

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

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

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.25msselect * from `cities` where `cities`.`id` in (616, 1607, 3576, 4051, 8893)

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.18msselect * from `countries` where `countries`.`id` in (6, 29, 58, 215, 247)

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.19msselect * from `sites_relationships` where `sites_relationships`.`id` in (400923, 401014, 401112, 401145, 401318)

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

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

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

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.22msselect * from `cities` where `cities`.`id` in (317, 2445, 3763, 8789, 9116)

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#359aviatickets920μsselect * from `sites_relationships` where `sites_relationships`.`id` in (58284, 58541, 58669, 58851, 58921)

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#359aviatickets1msselect * from `countries` where `countries`.`id` in (16)

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

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

Bindings	0: 985 1: 7569
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.37ms

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

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

Bindings	0: 7569 1: 985
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#520aviatickets1msselect * from `sites_relationships` where `sites_relationships`.`id` in (400971)

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

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

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

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

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

App\Avia\Infrastructure\Model\Timetable: 136Timetable.php#?
App\Avia\Infrastructure\Model\City: 32City.php#?
App\Avia\Infrastructure\Model\LocalRoute: 30LocalRoute.php#?
App\Avia\Infrastructure\Model\SitesRelationship: 21SitesRelationship.php#?
App\Avia\Infrastructure\Model\Country: 11Country.php#?
App\Avia\Infrastructure\Model\Airline: 2Airline.php#?
App\Avia\Infrastructure\Model\MonthlyPriceStatistic: 1MonthlyPriceStatistic.php#?

_token: HSCwfk3ziTlBFStKZ6dxrmlFv17h4J8urTA7wF0D
_previous: array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-cairo-to-charleston-cai-chs?_url=%2F...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cheap-flights-from-cairo-to-charleston-cai-chs

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "_url" => "/cheap-flights-from-cairo-to-charleston-cai-chs"
]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InBmREcxN2dISG45UHhhRlY4WElYSFE9PSIsInZhbHVlIjoiOVdLeUdoQStzTGpEUWR5VGRHRHFvdTRhVlFaYXp5d21RSHdqN2NOR0NGWHhNWGFWaGV2bkdTd1M0RVg2MDhxYmFKYlN6Sm5QVXg3VitCUFVYdHpoamVDY2tVNUVHVURtVVkxT3BhYTB5NFM5dzNOOXM1dU5MZ1dsUWtVOWxiNW4iLCJtYWMiOiI3YjNjZWQ2OTYxNzQ1YTY4MjYzZTI3MjgyYmJiNGZjZmY3ZjYyODNkNDhkODQ4ZDA0ODJiZGM5YTMzZmI2Y2VlIiwidGFnIjoiIn0%3D; lowcostclub_session=eyJpdiI6IjF5TGo1SktvVkhDT0xHbzdXdDBjM2c9PSIsInZhbHVlIjoiempncFd0TU9SU3hxOFRtblQvMW0xVGtnQVdCWFoyY3hVVStyckJrWEFQR2NYaWp3OWpzZFNJUXAxOFh3YzB2Q2tvd0ZDUitINFF3OFdrenYxUk9oYSttMXNablExcktxMXhzRlVEYmdOY25CYytJekhQbnBrSXZEMmFzNUc4dkUiLCJtYWMiOiIyMzExZDBiYzE1NGNhZTUzYWY2M2Q4OWMyYmU3NGQ0MzkxZGU1YjA2Nzg1YjVhYzA5ODczMzE3ZGM2YjQ2YTA1IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InBmREcxN2dISG45UHhhRlY4WElYSFE9PSIsInZhbHVlIjoiOVdLeUdoQStzTGpEUWR5VGRHRHFvdTRhVlFaYXp5d21RSHdqN2NOR0NGWHhNWGFWaGV2bkdTd1M0RVg2MDhxYmFKYlN6S ▶"
  ]
  "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" => "HSCwfk3ziTlBFStKZ6dxrmlFv17h4J8urTA7wF0D"
  "lowcostclub_session" => "B6K91txxA07JTKzAZbIl5HnEaNDzdv7JYwfma7fg"
]

response_headers

  0 of 0   
array:6 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=604800, public"
  ]
  "date" => array:1 [▶
    0 => "Sun, 04 May 2025 16:02:23 GMT"
  ]
  "etag" => array:1 [▶
    0 => ""4cbfa7885311db5b9aaa017983a36496""
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1UTVIzSlIyMkhqMFovVExtSWVJNXc9PSIsInZhbHVlIjoieXlDOFZ4YVJNcE9VUUdUbTBzMFhSV2RldE9OZkpHOGw2bXZFMllLTEkveWFhd1Juc0xUSExKVXFzN1dtRk1CSzBEVlovWFhEQW96V2VUdERkQUpnaEpNeXdNMEtjZDZnL29BcXF2S2pRUXRVdlFvL1BKV21xMXB3eGVtNGcwcmoiLCJtYWMiOiIwNmJmZGE5NjVjMTlhODQ3Njc1YjNhOTdmOTA4YWI3MWUzZmU1NDkyNDY0NzFiNDczNGZkZTAyYTQ1Zjg4NjdiIiwidGFnIjoiIn0%3D; expires=Sun, 04 May 2025 18:02:23 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik1UTVIzSlIyMkhqMFovVExtSWVJNXc9PSIsInZhbHVlIjoieXlDOFZ4YVJNcE9VUUdUbTBzMFhSV2RldE9OZkpHOGw2bXZFMllLTEkveWFhd1Juc0xUSExKVXFzN1dtRk1CSzBEVlovW ▶"
    1 => "lowcostclub_session=eyJpdiI6InRlc2wzYnlHRkNoM0JyazhiYlBnRXc9PSIsInZhbHVlIjoidDhpVHdvdlMxdXFueXN6THlPL2JqVDZRTmJ1alROUjBmSjhINVdnY1kvako1QnBnSUcyTllIR3Y0MzZhbkl2SU5oZDM3YUE2VjNzaGVOblRBSHVNbTNaNlJhVldGSXR4MkZicmJpR2VRNHUxTGF2NGhOR1JkZVliWkN1QkpTTlgiLCJtYWMiOiI4ZTE2MzVmNzU2MmMyMTVhODY4MTA4ODRhOTE2ZDc0ZmQ3YzNhZWQ1ZDQ5MzlkOTk4YjJlMjY3Njg5OTk3MDg3IiwidGFnIjoiIn0%3D; expires=Sun, 04 May 2025 18:02:23 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀lowcostclub_session=eyJpdiI6InRlc2wzYnlHRkNoM0JyazhiYlBnRXc9PSIsInZhbHVlIjoidDhpVHdvdlMxdXFueXN6THlPL2JqVDZRTmJ1alROUjBmSjhINVdnY1kvako1QnBnSUcyTllIR3Y0MzZhbkl2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik1UTVIzSlIyMkhqMFovVExtSWVJNXc9PSIsInZhbHVlIjoieXlDOFZ4YVJNcE9VUUdUbTBzMFhSV2RldE9OZkpHOGw2bXZFMllLTEkveWFhd1Juc0xUSExKVXFzN1dtRk1CSzBEVlovWFhEQW96V2VUdERkQUpnaEpNeXdNMEtjZDZnL29BcXF2S2pRUXRVdlFvL1BKV21xMXB3eGVtNGcwcmoiLCJtYWMiOiIwNmJmZGE5NjVjMTlhODQ3Njc1YjNhOTdmOTA4YWI3MWUzZmU1NDkyNDY0NzFiNDczNGZkZTAyYTQ1Zjg4NjdiIiwidGFnIjoiIn0%3D; expires=Sun, 04-May-2025 18:02:23 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik1UTVIzSlIyMkhqMFovVExtSWVJNXc9PSIsInZhbHVlIjoieXlDOFZ4YVJNcE9VUUdUbTBzMFhSV2RldE9OZkpHOGw2bXZFMllLTEkveWFhd1Juc0xUSExKVXFzN1dtRk1CSzBEVlovW ▶"
    1 => "lowcostclub_session=eyJpdiI6InRlc2wzYnlHRkNoM0JyazhiYlBnRXc9PSIsInZhbHVlIjoidDhpVHdvdlMxdXFueXN6THlPL2JqVDZRTmJ1alROUjBmSjhINVdnY1kvako1QnBnSUcyTllIR3Y0MzZhbkl2SU5oZDM3YUE2VjNzaGVOblRBSHVNbTNaNlJhVldGSXR4MkZicmJpR2VRNHUxTGF2NGhOR1JkZVliWkN1QkpTTlgiLCJtYWMiOiI4ZTE2MzVmNzU2MmMyMTVhODY4MTA4ODRhOTE2ZDc0ZmQ3YzNhZWQ1ZDQ5MzlkOTk4YjJlMjY3Njg5OTk3MDg3IiwidGFnIjoiIn0%3D; expires=Sun, 04-May-2025 18:02:23 GMT; path=/; httponly ◀lowcostclub_session=eyJpdiI6InRlc2wzYnlHRkNoM0JyazhiYlBnRXc9PSIsInZhbHVlIjoidDhpVHdvdlMxdXFueXN6THlPL2JqVDZRTmJ1alROUjBmSjhINVdnY1kvako1QnBnSUcyTllIR3Y0MzZhbkl2 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "HSCwfk3ziTlBFStKZ6dxrmlFv17h4J8urTA7wF0D"
  "_previous" => array:1 [▶
    "url" => "https://d.lowcost.club/cheap-flights-from-cairo-to-charleston-cai-chs?_url=%2Fcheap-flights-from-cairo-to-charleston-cai-chs"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-04 16:02:23	GET	/cheap-flights-from-cairo-to-charleston-cai-chs	46 51 233

1 x Application (93.84%)	335ms
1 x Booting (6.15%)	21.93ms

Cheap flights Cairo — Charleston (CAI — CHS)

Choose your dates to find the flight:

Good to know - Cheap tickets Cairo — Charleston

Popular airlines flying Cairo — Charleston

Routes from nearby cities to Charleston

Popular International routes from Cairo

Popular routes from Charleston

Popular domestic routes from Cairo

Related pages

Select your currency

All currencies

Select your language

All languages