Cheap flights Sihanoukville — Koh Samui (KOS — USM)

Good to know - Cheap tickets Sihanoukville — Koh Samui

Cheapest flight found $306
Flight distance 395 km
Round-trip from $234

Airfare Sihanoukville – Koh Samui by month

Here you can find out in what months how much a ticket Sihanoukville – Koh Samui costs to buy cheap plane tickets.

Month One-way Round-trip
January 2026
October 2025
April 2025
March 2025
February 2025
January 2025
November 2024
October 2024
July 2024

Remember that the optimal time for booking air tickets is 59 days before the departure date, this is the average time at which air tickets were sold at the lowest prices.

Flights Sihanoukville — Koh Samui

The selection of cheap flights Sihanoukville — Koh Samui

Here you can find and purchase the cheapest flights Sihanoukville — Koh Samui from $306 and Sihanoukville — Koh Samui — Sihanoukville from $234.

The price of the flight Sihanoukville — Koh Samui (Thailand) — Sihanoukville from $234 (round-trip).

The average price of the flight Sihanoukville — Koh Samui (Thailand) — Sihanoukville $546 (round-trip).

Low cost flights Sihanoukville — Koh Samui (KOS — USM)

The distance between Sihanoukville and Koh Samui 245 miles (or 395 kilometres).

The time difference between Sihanoukville and Koh Samui is 0 h.

LowCostClub always do a comparison of airfares Sihanoukville — Koh Samui with several airlines (include ). They will always give you all available options so you can find the cheapest flight to Koh Samui. In addition, you can choose the platform where you want to place your orders. There are also special offers for air tickets Sihanoukville — Koh Samui. Last week, for instance, the cheapest round-trip prices stood at $234 while the cheapest one-way price that was available within the last week cost $306

Routes from nearby cities to Koh Samui

A flight from a neighbouring city can help you save money on plane tickets.

The most frequent flight to Koh Samui is from Bangkok. The cheapest airfare can be purchased with a flight from Utapao from $53. The nearest airports from Sihanoukville with a flight to Koh Samui are in Surat Thani.

Popular International routes from Sihanoukville

Popular routes from Koh Samui

If you are going to fly from Koh Samui, then study the popular flights. The most popular flights from Koh Samui:

Popular domestic routes from Sihanoukville

FAQ about Sihanoukville — Koh Samui

Yes, you can fly from Sihanoukville to Koh Samui. Sihanoukville has an airport (Sihanouk International Airport) for flights.

The price of flights Sihanoukville — Koh Samui starts from $306.

In Sihanoukville — Sihanouk International Airport. In Koh Samui — Koh Samui Airport.

High season is considered to be and the cheapest month is . Enter your preferred airports (or cities) and dates into the search form above to unlock the latest Sihanoukville — Koh Samui flight deals.

Low price calendar

We use cookies and similar technologies for different purposes. Read the privacy policy. If you use the site you agree to them.

Request history8.3.0PHP Version355msRequest Duration4MBMemory UsageGET cheap-flights-from-{slug}Route
    • Booting (21.64ms)time
    • Application (333ms)time
    • 1 x Application (93.9%)
      333ms
      1 x Booting (6.1%)
      21.64ms
      52 templates were rendered
      • 1x views_us.routes.viewview.blade.php#?blade
      • 1x routes.viewview.blade.php#?blade
      • 1x index.section-slideshowsection-slideshow.blade.php#?blade
      • 1x components.avia-formavia-form.blade.php#?blade
      • 1x breadcrumbs::bootstrap4bootstrap4.blade.php#?blade
      • 1x routes.section-advantagessection-advantages.blade.php#?blade
      • 1x routes.section-MonthlyPricesection-MonthlyPrice.blade.php#?blade
      • 1x routes.section-timetablesection-timetable.blade.php#?blade
      • 1x routes.AirlinesListAirlinesList.blade.php#?blade
      • 1x routes.section-DynamicsAirfaresection-DynamicsAirfare.blade.php#?blade
      • 4x components.routes-listroutes-list.blade.php#?blade
      • 21x components.routeListItemrouteListItem.blade.php#?blade
      • 1x routes.description-nearbyCitiesdescription-nearbyCities.blade.php#?blade
      • 2x components.routes-columnroutes-column.blade.php#?blade
      • 1x components.faqfaq.blade.php#?blade
      • 1x components.calendarcalendar.blade.php#?blade
      • 1x components.related-linksrelated-links.blade.php#?blade
      • 1x layouts.mainmain.blade.php#?blade
      • 1x headerheader.blade.php#?blade
      • 2x menumenu.blade.php#?blade
      • 1x footerfooter.blade.php#?blade
      • 1x components.footer-popular-flightsfooter-popular-flights.blade.php#?blade
      • 1x footer_scriptsfooter_scripts.blade.php#?blade
      • 1x components.currencycurrency.blade.php#?blade
      • 2x components.popuppopup.blade.php#?blade
      • 1x components.languagelanguage.blade.php#?blade
      uri
      GET cheap-flights-from-{slug}
      middleware
      web
      controller
      App\Http\Controllers\RoutesController@view
      namespace
      prefix
      /
      where
      as
      route
      file
      app/Http/Controllers/RoutesController.php:96-299
      55 statements were executed (16 duplicates)Show only duplicates80.72ms
      • QueryDetector.php#25aviaticketsConnection Established
        Backtrace
        • vendor/beyondcode/laravel-query-detector/src/QueryDetector.php:25
        • vendor/beyondcode/laravel-query-detector/src/QueryDetectorMiddleware.php:30
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • app/Http/Middleware/MinifyHtml.php:21
      • SitesRelationshipsSqlRepository.php#34aviatickets6.32msselect * from `sites_relationships` where `us` = 'cheap-flights-from-sihanoukville-to-koh-samui-kos-usm' limit 1
        Bindings
        • 0: cheap-flights-from-sihanoukville-to-koh-samui-kos-usm
        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#125aviatickets2.96msselect * from `flights_by` where `flights_by`.`id` = '167812' 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.29msselect * from `cities` where `cities`.`id` = 8793 limit 1
        Bindings
        • 0: 8793
        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.15msselect * from `countries` where `countries`.`id` = 28 limit 1
        Bindings
        • 0: 28
        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` = 6906 limit 1
        Bindings
        • 0: 6906
        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.11msselect * from `countries` where `countries`.`id` = 89 limit 1
        Bindings
        • 0: 89
        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#33aviatickets1.15msselect * from `sites_relationships` where `sites_relationships`.`id` = 167812 and `sites_relationships`.`id` is not null limit 1
        Bindings
        • 0: 167812
        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.09msselect * 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.34msselect `depart_date`, `return_date`, `number_of_changes`, `value` from `flights_2025` where `origin_id` = 8793 and `destination_id` = 6906 and `date_update` >= '2025-04-28 00:00:00' order by `value` asc limit 10
        Bindings
        • 0: 8793
        • 1: 6906
        • 2: 2025-04-28 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#66aviatickets3.38msselect * from `monthly_price_statistics` where `origin_city_id` = 8793 and `destination_city_id` = 6906 limit 1
        Bindings
        • 0: 8793
        • 1: 6906
        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.27msselect * from `timetables` where `origin_city_id` = 8793 and `destination_city_id` = 6906 order by `time_origin` asc limit 1000
        Bindings
        • 0: 8793
        • 1: 6906
        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#502aviatickets960μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 8793
        Bindings
        • 0: 8793
        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#502aviatickets990μsselect distinct `airline_id` from `timetables` where `origin_city_id` = 6906
        Bindings
        • 0: 6906
        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.1msselect destination_city_id from `flights_by` where `origin_city_id` = 8793 and `distance` between 1 and 1000 and (`price_one_way` > 0 or `price` > 0) order by `distance` asc limit 10
        Bindings
        • 0: 8793
        • 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.92msselect * from `flights_by` where `origin_city_id` in (5058, 5005, 9313, 5281, 5572, 3165, 6906, 696, 6437, 8374) and `destination_city_id` = 6906 and (`price_one_way` > 0 or `price` > 0) limit 10
        Bindings
        • 0: 5058
        • 1: 5005
        • 2: 9313
        • 3: 5281
        • 4: 5572
        • 5: 3165
        • 6: 6906
        • 7: 696
        • 8: 6437
        • 9: 8374
        • 10: 6906
        • 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#73aviatickets3msselect * from `cities` where `cities`.`id` in (696, 3165, 5005, 5058, 5281, 5572, 6437, 8374, 9313)
        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.3msselect * from `cities` where `cities`.`id` in (6906)
        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.5msselect * from `sites_relationships` where `sites_relationships`.`id` in (39625, 87270, 265849, 268291, 277949, 299950, 326673, 348808, 349945)
        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.56msselect * from `cities` where `cities`.`id` = 6437 limit 1
        Bindings
        • 0: 6437
        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.43msselect * from `cities` where `cities`.`id` = 3165 limit 1
        Bindings
        • 0: 3165
        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
      • OfferSqlRepository.php#52aviatickets1.22msselect * from `offers` where `origin_city_id` = 8793 and `destination_city_id` = 6906
        Bindings
        • 0: 8793
        • 1: 6906
        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.87msselect * from `flights_by` where `origin_city_id` = 8793 and `id` > 167812 and `destination_country_id` <> 28 and (`price_one_way` > 0 or `price` > 0) order by `id` asc limit 3
        Bindings
        • 0: 8793
        • 1: 167812
        • 2: 28
        • 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.24msselect * from `cities` where `cities`.`id` in (8793)
        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.21msselect * from `cities` where `cities`.`id` in (3165, 6590, 8905)
        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.45msselect * from `sites_relationships` where `sites_relationships`.`id` in (167813, 167814, 167815)
        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#412aviatickets1.85msselect * from `flights_by` where `origin_city_id` = 8793 and `destination_country_id` <> 28 and (`price_one_way` > 0 or `price` > 0) and `id` not in (167813) order by `revenue` desc limit 2 offset 0
        Bindings
        • 0: 8793
        • 1: 28
        • 2: 0
        • 3: 0
        • 4: 167813
        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.14msselect * from `cities` where `cities`.`id` in (8793)
        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.14msselect * from `cities` where `cities`.`id` in (696, 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.04msselect * from `sites_relationships` where `sites_relationships`.`id` in (167773, 167796)
        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 `countries` where `countries`.`id` in (89, 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.38msselect * from `flights_by` where `origin_city_id` = 6906 and (`price_one_way` > 0 or `price` > 0) and 1 = 1 order by `revenue` desc limit 5
        Bindings
        • 0: 6906
        • 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#149aviatickets980μsselect * from `cities` where `cities`.`id` in (6906)
        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#149aviatickets2.09msselect * from `cities` where `cities`.`id` in (696, 2382, 3505, 4081, 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.06msselect * from `countries` where `countries`.`id` in (89, 136, 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#149aviatickets890μsselect * from `sites_relationships` where `sites_relationships`.`id` in (349175, 349255, 349300, 349323, 349390)
        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.41msselect * from `flights_by` where `origin_city_id` = 8793 and `destination_country_id` = 28 and (`price_one_way` > 0 or `price` > 0) order by `revenue` desc limit 5 offset 0
        Bindings
        • 0: 8793
        • 1: 28
        • 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.04msselect * from `cities` where `cities`.`id` in (8793)
        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 (5005, 5281)
        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 (167799, 167802)
        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 `countries` where `countries`.`id` in (28)
        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.11msselect * from `timetables` where `origin_city_id` = 8793 and `destination_city_id` = 6906 order by `time_origin` asc limit 10
        Bindings
        • 0: 8793
        • 1: 6906
        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#144aviatickets910μsselect * from `timetables` where `origin_city_id` = 8793 and `destination_city_id` = 6906 order by `travel_time` asc limit 1
        Bindings
        • 0: 8793
        • 1: 6906
        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#520aviatickets1msselect * from `flights_by` where `origin_city_id` = 6906 and `destination_city_id` = 8793 limit 1
        Bindings
        • 0: 6906
        • 1: 8793
        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#520aviatickets760μsselect * from `sites_relationships` where `sites_relationships`.`id` in (349287)
        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
      • LocalRoute.php#99aviatickets1.76msselect * from `cities` where `cities`.`id` = 8793 limit 1
        Bindings
        • 0: 8793
        Backtrace
        • app/Avia/Infrastructure/Model/LocalRoute.php:99
        • app/Avia/Infrastructure/Factory/DomainRouteFactory.php:30
        • app/Http/Controllers/RoutesController.php:536
        • app/Http/Controllers/RoutesController.php:279
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • RoutesController.php#547aviatickets1msselect * from `cities` where `cities`.`id` = 6906 limit 1
        Bindings
        • 0: 6906
        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
      • City.php#136aviatickets1.21msselect * from `airports` where `airports`.`city_id` = 8793 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 8793
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:100
        • 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
      • City.php#136aviatickets1.09msselect * from `airports` where `airports`.`city_id` = 6906 and `airports`.`city_id` is not null and `is_active` = 1 and `is_active` = '1'
        Bindings
        • 0: 6906
        • 1: 1
        • 2: 1
        Backtrace
        • app/Avia/Infrastructure/Model/City.php:136
        • view::routes.view:127
        • 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
      • description-nearbyCities.blade.php#28aviatickets1.29msselect * from `cities` where `cities`.`id` = 8793 limit 1
        Bindings
        • 0: 8793
        Backtrace
        • view::routes.description-nearbyCities:28
        • 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
      • FlightSqlRepository.php#98aviatickets930μsselect * from `timetables` where `origin_city_id` = 8793 and `destination_city_id` = 6906
        Bindings
        • 0: 8793
        • 1: 6906
        Backtrace
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:98
        • vendor/laravel/framework/src/Illuminate/Cache/Repository.php:396
        • vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • app/Avia/Infrastructure/Repository/FlightSqlRepository.php:104
        • app/Avia/Infrastructure/FaqRouteFactory/AreThereDirectFlights.php:21
      • CanWeFlyFromTo.php#30aviatickets1.14msselect * from `airports` where `airports`.`city_id` = 8793 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 8793
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:30
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:313
      • CanWeFlyFromTo.php#35aviatickets1.05msselect * from `airports` where `airports`.`city_id` = 6906 and `airports`.`city_id` is not null and `is_active` = 1
        Bindings
        • 0: 6906
        • 1: 1
        Backtrace
        • app/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:35
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
        • vendor/laravel/framework/src/Illuminate/View/Component.php:135
        • view::routes.view:313
      • TimetableRepository.php#39aviatickets1.01msselect * from `timetables` where `origin_city_id` = 8793 and `destination_city_id` = 6906 order by `time_origin` asc limit 1000
        Bindings
        • 0: 8793
        • 1: 6906
        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/Avia/Infrastructure/FaqRouteFactory/CanWeFlyFromTo.php:42
      • TimetableRepository.php#144aviatickets1.18msselect * from `timetables` where `origin_city_id` = 8793 and `destination_city_id` = 6906 order by `travel_time` asc limit 1
        Bindings
        • 0: 8793
        • 1: 6906
        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/Avia/Infrastructure/FaqRouteFactory/HowLongDoesItTakeToFly.php:27
      • MonthlyPriceStatisticSqlRepository.php#66aviatickets1.9msselect * from `monthly_price_statistics` where `origin_city_id` = 8793 and `destination_city_id` = 6906 limit 1
        Bindings
        • 0: 8793
        • 1: 6906
        Backtrace
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:66
        • app/Avia/Infrastructure/Repository/MonthlyPriceStatisticSqlRepository.php:44
        • app/Avia/Infrastructure/FaqRouteFactory/WhatMonthCheapest.php:27
        • app/Avia/Domain/Faq/FaqRouteAggregate.php:32
        • app/View/Components/FaqRoute.php:39
      App\Avia\Infrastructure\Model\LocalRoute
      33LocalRoute.php#?
      App\Avia\Infrastructure\Model\City
      33City.php#?
      App\Avia\Infrastructure\Model\SitesRelationship
      24SitesRelationship.php#?
      App\Avia\Infrastructure\Model\Country
      8Country.php#?
      App\Avia\Infrastructure\Model\Timetable
      7Timetable.php#?
      App\Avia\Infrastructure\Model\Airport
      4Airport.php#?
      App\Avia\Infrastructure\Model\MonthlyPriceStatistic
      2MonthlyPriceStatistic.php#?
          • infoModel: App\Avia\Infrastructure\Model\City => Relation: App\Avia\Infrastructure\Model\Airport - You s...
          _token
          cbjyJ4yC1kgUAbW95HZ7CMIM2nXWQsmpUk029Fgo
          _previous
          array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-sihanoukville-to-koh-samui-kos-usm?_...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /cheap-flights-from-sihanoukville-to-koh-samui-kos-usm
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "_url" => "/cheap-flights-from-sihanoukville-to-koh-samui-kos-usm" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "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
          []
          
          response_headers
          0 of 0
          array:6 [ "cache-control" => array:1 [ 0 => "max-age=604800, public" ] "date" => array:1 [ 0 => "Wed, 30 Apr 2025 23:21:02 GMT" ] "etag" => array:1 [ 0 => ""e0a4037fe920604ecc845a8e2aadf488"" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJ1LzhrTCt4MGlNWEEwWVpQamQrR2c9PSIsInZhbHVlIjoiTTBKWXBjTTZQRXlad3VBZkphbDEyS3dSVUpxN29QeDBpamlyUTliTTdEdXozejV4YVNpRm9aZzl5WHBUVjdoY1U4c3Y5Ty9XT2NCc1RXS2UxT3ZqSk13NkZDZUw5Nk85TkpQNkdRUGZIU3l0Q3d2M3pqTXdYb3oxTlRiUE5DNGwiLCJtYWMiOiIzOWVmZGQxMzc3OWJkNmRhMmFiNmQ1MWE5MGU0YzM1Mjg0NTcxMGZiYjhjYTNmOTQxNTE5YmU0NTg1YTU0Zjk0IiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 01:21:02 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IkJ1LzhrTCt4MGlNWEEwWVpQamQrR2c9PSIsInZhbHVlIjoiTTBKWXBjTTZQRXlad3VBZkphbDEyS3dSVUpxN29QeDBpamlyUTliTTdEdXozejV4YVNpRm9aZzl5WHBUVjdoY1U4c3Y5T" 1 => "lowcostclub_session=eyJpdiI6IlRob2NrT0pYc0NGUTIvWU9FbzZYTXc9PSIsInZhbHVlIjoiUTBYV05JZCtyUEcxejY5aGlHZk9lUTFjRnBuWVd2bFowUFFzelpBYUVHbWx6a0RvZlNRZTFUUVlVYS9aWnJGS1hmaTFvUVZONE9PNHIrUUFEUzkrUktObTZlV3VNNUZINGJ0TzRObGRJb0lBZ0RPSElEN2J2M3FuR1pYN3hlYUoiLCJtYWMiOiI2MDkwOWNjNGQwNDgxNzM3NWIzNzI3NGY1ZmQ2MTU3ZGE5ZjE0MzU0MjVhYTMxNTE5YzdmM2VhNDZlMTQwM2ZjIiwidGFnIjoiIn0%3D; expires=Thu, 01 May 2025 01:21:02 GMT; Max-Age=7200; path=/; httponly; samesite=laxlowcostclub_session=eyJpdiI6IlRob2NrT0pYc0NGUTIvWU9FbzZYTXc9PSIsInZhbHVlIjoiUTBYV05JZCtyUEcxejY5aGlHZk9lUTFjRnBuWVd2bFowUFFzelpBYUVHbWx6a0RvZlNRZTFUUVlVYS9aWnJG" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkJ1LzhrTCt4MGlNWEEwWVpQamQrR2c9PSIsInZhbHVlIjoiTTBKWXBjTTZQRXlad3VBZkphbDEyS3dSVUpxN29QeDBpamlyUTliTTdEdXozejV4YVNpRm9aZzl5WHBUVjdoY1U4c3Y5Ty9XT2NCc1RXS2UxT3ZqSk13NkZDZUw5Nk85TkpQNkdRUGZIU3l0Q3d2M3pqTXdYb3oxTlRiUE5DNGwiLCJtYWMiOiIzOWVmZGQxMzc3OWJkNmRhMmFiNmQ1MWE5MGU0YzM1Mjg0NTcxMGZiYjhjYTNmOTQxNTE5YmU0NTg1YTU0Zjk0IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 01:21:02 GMT; path=/XSRF-TOKEN=eyJpdiI6IkJ1LzhrTCt4MGlNWEEwWVpQamQrR2c9PSIsInZhbHVlIjoiTTBKWXBjTTZQRXlad3VBZkphbDEyS3dSVUpxN29QeDBpamlyUTliTTdEdXozejV4YVNpRm9aZzl5WHBUVjdoY1U4c3Y5T" 1 => "lowcostclub_session=eyJpdiI6IlRob2NrT0pYc0NGUTIvWU9FbzZYTXc9PSIsInZhbHVlIjoiUTBYV05JZCtyUEcxejY5aGlHZk9lUTFjRnBuWVd2bFowUFFzelpBYUVHbWx6a0RvZlNRZTFUUVlVYS9aWnJGS1hmaTFvUVZONE9PNHIrUUFEUzkrUktObTZlV3VNNUZINGJ0TzRObGRJb0lBZ0RPSElEN2J2M3FuR1pYN3hlYUoiLCJtYWMiOiI2MDkwOWNjNGQwNDgxNzM3NWIzNzI3NGY1ZmQ2MTU3ZGE5ZjE0MzU0MjVhYTMxNTE5YzdmM2VhNDZlMTQwM2ZjIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 01:21:02 GMT; path=/; httponlylowcostclub_session=eyJpdiI6IlRob2NrT0pYc0NGUTIvWU9FbzZYTXc9PSIsInZhbHVlIjoiUTBYV05JZCtyUEcxejY5aGlHZk9lUTFjRnBuWVd2bFowUFFzelpBYUVHbWx6a0RvZlNRZTFUUVlVYS9aWnJG" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "cbjyJ4yC1kgUAbW95HZ7CMIM2nXWQsmpUk029Fgo" "_previous" => array:1 [ "url" => "https://d.lowcost.club/cheap-flights-from-sihanoukville-to-koh-samui-kos-usm?_url=%2Fcheap-flights-from-sihanoukville-to-koh-samui-kos-usm" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-30 23:21:02GET/cheap-flights-from-sihanoukville-to-koh-samui-kos-usm52551111