Orange Bay

Messages Timeline Exceptions Views38 Route Queries32 Models31 Mails Auth Gate Session Request

Request history8.1.141.34s7MBGET fr/tour/{slug}

Booting (664ms)time
Application (677ms)time
1 x Application (50.48%)
677ms
1 x Booting (49.52%)
664ms

38 templates were rendered

1x Tour::frontend.detaildetail.blade.php#?blade
1x Layout::parts.bcbc.blade.php#?blade
1x Tour::frontend.layouts.details.tour-bannertour-banner.blade.php#?blade
1x Tour::frontend.layouts.details.tour-detailtour-detail.blade.php#?blade
1x Layout::global.details.gallerygallery.blade.php#?blade
1x Tour::frontend.layouts.details.tour-include-excludetour-include-exclude.blade.php#?blade
1x Tour::frontend.layouts.details.tour-itinerarytour-itinerary.blade.php#?blade
1x Tour::frontend.layouts.details.tour-attributestour-attributes.blade.php#?blade
1x Tour::frontend.layouts.details.tour-faqstour-faqs.blade.php#?blade
1x Hotel::frontend.layouts.details.hotel-surroundinghotel-surrounding.blade.php#?blade
1x Tour::frontend.layouts.details.tour-reviewtour-review.blade.php#?blade
1x Review::frontend.formform.blade.php#?blade
1x Tour::frontend.layouts.details.vendorvendor.blade.php#?blade
1x Tour::frontend.layouts.details.tour-form-booktour-form-book.blade.php#?blade
1x Booking::frontend.global.enquiry-formenquiry-form.blade.php#?blade
1x Tour::frontend.layouts.details.open-hoursopen-hours.blade.php#?blade
1x Tour::frontend.layouts.details.tour-relatedtour-related.blade.php#?blade
4x Tour::frontend.layouts.search.loop-gridloop-grid.blade.php#?blade
1x layouts.appapp.blade.php#?blade
1x Layout::appapp.blade.php#?blade
1x Layout::parts.faviconfavicon.blade.php#?blade
1x Layout::parts.seo-metaseo-meta.blade.php#?blade
1x Layout::parts.global-scriptglobal-script.blade.php#?blade
1x Layout::parts.topbartopbar.blade.php#?blade
2x Core::frontend.currency-switchercurrency-switcher.blade.php#?blade
2x Language::frontend.switcherswitcher.blade.php#?blade
1x Layout::parts.headerheader.blade.php#?blade
1x Layout::parts.footerfooter.blade.php#?blade
1x Layout::parts.login-register-modallogin-register-modal.blade.php#?blade
1x Layout::auth.login-formlogin-form.blade.php#?blade
1x Layout::auth.register-formregister-form.blade.php#?blade
1x Popup::frontend.popuppopup.blade.php#?blade
1x demo_scriptdemo_script.blade.php#?blade

uri: GET fr/tour/{slug}
middleware: web
controller: \Modules\Tour\Controllers\TourController@detail
namespace: Modules\Tour\Controllers
prefix: fr/tour
where
file: modules/Tour/Controllers/TourController.php:105-142

32 statements were executed, 10 of which were duplicates, 22 unique. Show only duplicated98.16ms

select * from `bravo_tours` where `slug` = 'orange-bay-beach-your-perfect-getaway' and `bravo_tours`.`deleted_at` is null limit 1

4.67msraholidayTourController.php#107

Bindings	0: orange-bay-beach-your-perfect-getaway
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. modules/Tour/Controllers/TourController.php:107 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. modules/Tour/Controllers/TourController.php:36 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` is null370μsraholidayTourController.php#107

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. modules/Tour/Controllers/TourController.php:107 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. modules/Tour/Controllers/TourController.php:36 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_location_translations` where `locale` = 'fr' and `bravo_location_translations`.`origin_id` in (1)2.31msraholidayTourController.php#107

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	26. modules/Tour/Controllers/TourController.php:107 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. modules/Tour/Controllers/TourController.php:36 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 30. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_tour_translations` where `locale` = 'fr' and `bravo_tour_translations`.`origin_id` in (97)9.4msraholidayTourController.php#107

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. modules/Tour/Controllers/TourController.php:107 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. modules/Tour/Controllers/TourController.php:36 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (97)2.24msraholidayTourController.php#107

Bindings	0: tour 1: 0
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. modules/Tour/Controllers/TourController.php:107 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. modules/Tour/Controllers/TourController.php:36 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_tours` where `location_id` = 1 and `status` = 'publish' and `id` not in (97) and `bravo_tours`.`deleted_at` is null limit 4

3.75msraholidayTourController.php#115

Bindings	0: 1 1: publish 2: 97
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. modules/Tour/Controllers/TourController.php:115 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. modules/Tour/Controllers/TourController.php:36 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` is null350μsraholidayTourController.php#115

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. modules/Tour/Controllers/TourController.php:115 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. modules/Tour/Controllers/TourController.php:36 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_location_translations` where `locale` = 'fr' and `bravo_location_translations`.`origin_id` in (1)8.95msraholidayTourController.php#115

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	25. modules/Tour/Controllers/TourController.php:115 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. modules/Tour/Controllers/TourController.php:36 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_tour_translations` where `locale` = 'fr' and `bravo_tour_translations`.`origin_id` in (68, 69, 70, 71)

370μsraholidayTourController.php#115

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. modules/Tour/Controllers/TourController.php:115 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. modules/Tour/Controllers/TourController.php:36 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (68, 69, 70, 71)

1.92msraholidayTourController.php#115

Bindings	0: tour 1: 0
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. modules/Tour/Controllers/TourController.php:115 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. modules/Tour/Controllers/TourController.php:36 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select count(*) as aggregate from `bravo_review` where `object_id` = 97 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null

910μsraholidayTour.php#831

Bindings	0: 97 1: tour 2: approved
Backtrace	16. modules/Tour/Models/Tour.php:831 17. modules/Tour/Controllers/TourController.php:117 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. modules/Tour/Controllers/TourController.php:36 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `bravo_tour_meta` where `bravo_tour_meta`.`tour_id` = 97 and `bravo_tour_meta`.`tour_id` is not null limit 1

3.11msraholidayTour.php#592

Bindings	0: 97
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	22. modules/Tour/Models/Tour.php:592 23. modules/Tour/Controllers/TourController.php:123 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. modules/Tour/Controllers/TourController.php:36 26. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `bravo_seo` where `object_id` = 376 and `object_model` = 'tour_translation_fr' limit 15.03msraholidayBaseModel.php#199

Bindings	0: 376 1: tour_translation_fr
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/BaseModel.php:199 17. app/BaseModel.php:214 18. modules/Tour/Controllers/TourController.php:125 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. modules/Tour/Controllers/TourController.php:36

select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null2.16msraholidayTourController.php#133

Bindings	0: publish
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	15. modules/Tour/Controllers/TourController.php:133 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. modules/Tour/Controllers/TourController.php:36 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `location_category_translations` where `locale` = 'fr' and `location_category_translations`.`origin_id` in (1, 2, 3)

2.12msraholidayTourController.php#133

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. modules/Tour/Controllers/TourController.php:133 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. modules/Tour/Controllers/TourController.php:36 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_locations` where (2 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 1) and `bravo_locations`.`deleted_at` is null

350μsraholidayQueryBuilder.php#165

Bindings	0: 2 1: 1
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	15. vendor/kalnoy/nestedset/src/QueryBuilder.php:165 18. modules/Location/Traits/HasLocation.php:21 19. modules/Tour/Controllers/TourController.php:135 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. modules/Tour/Controllers/TourController.php:36

select  AVG(rate_number) as score_total , COUNT(id) as total_review  from `bravo_review` where `object_id` = 97 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

1.33msraholidayTour.php#757

Bindings	0: 97 1: tour 2: approved
Hints	0: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. modules/Tour/Models/Tour.php:757 22. view::Tour::frontend.detail:15 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select COUNT( CASE WHEN rate_number = 5 THEN rate_number ELSE NULL END ) AS rate_5,
COUNT( CASE WHEN rate_number = 4 THEN rate_number ELSE NULL END ) AS rate_4,
COUNT( CASE WHEN rate_number = 3 THEN rate_number ELSE NULL END ) AS rate_3,
COUNT( CASE WHEN rate_number = 2 THEN rate_number ELSE NULL END ) AS rate_2,
COUNT( CASE WHEN rate_number = 1 THEN rate_number ELSE NULL END ) AS rate_1  from `bravo_review` where `object_id` = 97 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

1.27msraholidayTour.php#769

Bindings	0: 97 1: tour 2: approved
Hints	0: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. modules/Tour/Models/Tour.php:769 22. view::Tour::frontend.detail:15 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select  	COUNT( id ) AS total_review, COUNT( CASE WHEN rate_number >= 4 THEN 1 ELSE null END )  as total_review_recommend  from `bravo_review` where `object_id` = 97 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

2.28msraholidayBookable.php#359

Bindings	0: 97 1: tour 2: approved
Hints	0: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. modules/Booking/Models/Bookable.php:359 22. view::Tour::frontend.layouts.details.tour-detail:24 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `bravo_tour_category` where `bravo_tour_category`.`id` = 6 and `bravo_tour_category`.`id` is not null and `bravo_tour_category`.`deleted_at` is null limit 1

1.26msraholidaytour-detail.blade.php#50

Bindings	0: 6
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	22. view::Tour::frontend.layouts.details.tour-detail:50 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 27. vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `bravo_tour_category_translations` where `locale` = 'fr' and `bravo_tour_category_translations`.`origin_id` in (6)

1.15msraholidaytour-detail.blade.php#50

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	27. view::Tour::frontend.layouts.details.tour-detail:50 29. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 30. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 31. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 32. vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1580μsraholidayBaseModel.php#135

Bindings	0:
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	19. app/BaseModel.php:135 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 23. app/BaseModel.php:136 24. modules/Media/Helpers/FileHelper.php:42

select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1710μsraholidayBaseModel.php#135

Bindings	0:
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	19. app/BaseModel.php:135 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 23. app/BaseModel.php:136 24. modules/Media/Helpers/FileHelper.php:42

select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1480μsraholidayBaseModel.php#135

Bindings	0:
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	19. app/BaseModel.php:135 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 23. app/BaseModel.php:136 24. modules/Media/Helpers/FileHelper.php:42

select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 12.21msraholidayBaseModel.php#135

Bindings	0:
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	19. app/BaseModel.php:135 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429 23. app/BaseModel.php:136 24. modules/Media/Helpers/FileHelper.php:42

select * from `bravo_tour_term` where `bravo_tour_term`.`tour_id` = 97 and `bravo_tour_term`.`tour_id` is not null2.87msraholidaytour-attributes.blade.php#2

Bindings	0: 97
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. view::Tour::frontend.layouts.details.tour-attributes:2 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 25. vendor/laravel/framework/src/Illuminate/View/View.php:207

select * from `bravo_terms` where `bravo_terms`.`id` in (3, 5) and `bravo_terms`.`deleted_at` is null5.73msraholidayTerms.php#42

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	17. modules/Core/Models/Terms.php:42 18. view::Tour::frontend.layouts.details.tour-attributes:3 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `bravo_terms_translations` where `locale` = 'fr' and `bravo_terms_translations`.`origin_id` in (3, 5)2.05msraholidayTerms.php#42

Bindings	0: fr
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	22. modules/Core/Models/Terms.php:42 23. view::Tour::frontend.layouts.details.tour-attributes:3 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `bravo_attrs` where `bravo_attrs`.`id` in (1) and `bravo_attrs`.`deleted_at` is null320μsraholidayTerms.php#42

Bindings	0: 1
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	22. modules/Core/Models/Terms.php:42 23. view::Tour::frontend.layouts.details.tour-attributes:3 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 1 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'fr' limit 1

8.74msraholidayHasTranslations.php#51

Bindings	0: 1 1: fr
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Traits/HasTranslations.php:51 22. view::Tour::frontend.layouts.details.tour-attributes:7 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'fr' limit 1

16.88msraholidayHasTranslations.php#51

Bindings	0: 1 1: fr
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Traits/HasTranslations.php:51 22. app/Helpers/AppHelper.php:112 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'fr' limit 1

2.29msraholidayHasTranslations.php#51

Bindings	0: 1 1: fr
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Traits/HasTranslations.php:51 22. app/Helpers/AppHelper.php:112 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

Modules\Tour\Models\Tour: 5Tour.php#?
Modules\Tour\Models\TourTranslation: 5TourTranslation.php#?
Modules\Location\Models\LocationCategory: 3LocationCategory.php#?
Modules\Review\Models\Review: 3Review.php#?
Modules\Location\Models\Location: 2Location.php#?
Modules\Location\Models\LocationTranslation: 2LocationTranslation.php#?
Modules\Tour\Models\TourTerm: 2TourTerm.php#?
Modules\Core\Models\Terms: 2Terms.php#?
Modules\Core\Models\MenuTranslation: 2MenuTranslation.php#?
Modules\Tour\Models\TourMeta: 1TourMeta.php#?
Modules\Core\Models\SEO: 1SEO.php#?
Modules\Tour\Models\TourCategory: 1TourCategory.php#?
Modules\Tour\Models\TourCategoryTranslation: 1TourCategoryTranslation.php#?
Modules\Core\Models\Attributes: 1Attributes.php#?

web: null
sanctum: null

_token: dSsbHuAwDAcX7hinP9jxj44NvxS6NbaEY25EHZvi
_previous: array:1 [ "url" => "https://raholiday.com/fr/tour/orange-bay-beach-your-perfect-getaway" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/fr/tour/orange-bay-beach-your-perfect-getaway

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "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"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "host" => array:1 [▶
    0 => "raholiday.com"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 17 May 2025 02:28:42 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitUWDZrTlhQQTc5MDFrREFJMExsalE9PSIsInZhbHVlIjoiSGNFWUMwZlVQTVFnYnpJcnJiUHgzbUF2dzdwL3h6dGM3ZHNRTWpyRGRBQzcwZWNTajY2MDFhdWRIK1F1THBZUmdnd3JacmxYMFF5cUVXb3VRTW5zZGpiUGRjR2w0N1UzNHlhRVBlZmlTbDdlZlBKdzQ4Zzg5MUo3QVI4VGpnak8iLCJtYWMiOiIzMDAxMmEyMzAxMWU4MmM4NDk1ZGIwYjk2ZDM2NjU2NDgyMWQ3N2U5ZmVhYWM0NmFjYzM0MzY2OTBiN2Y4NjZjIiwidGFnIjoiIn0%3D; expires=Sat, 17 May 2025 04:28:43 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IitUWDZrTlhQQTc5MDFrREFJMExsalE9PSIsInZhbHVlIjoiSGNFWUMwZlVQTVFnYnpJcnJiUHgzbUF2dzdwL3h6dGM3ZHNRTWpyRGRBQzcwZWNTajY2MDFhdWRIK1F1THBZUmdnd3Jac ▶"
    1 => "ra_holiday_session=eyJpdiI6Ik1xczJ6V2R6RmxHYzEvUE0rYTBLc3c9PSIsInZhbHVlIjoiNzZVb3k4Z012cWVLVzQ0b1ZKbjY4RnpyY3ltN3pDYlJxRUsvKzJabGx0bEtlMzFDYTNqcW5hWmVVZFl0RzVXK1kweDJVaGpsUnFkZWdmMWtobVVjcXlLRUxTZzlWNVppVWpjQWJSbDdybFZwbkNMbnA5K3pJSGtwbmNHNDUxR3IiLCJtYWMiOiIzYzRkYTEwNmViMmFiYmEzMzhlNjBkYWJhYTM5YjUyZTAxMGYzZGIyNWQwY2U4OGUwOWZmN2NmNjc0MWY1ZDI5IiwidGFnIjoiIn0%3D; expires=Sat, 17 May 2025 04:28:43 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀ra_holiday_session=eyJpdiI6Ik1xczJ6V2R6RmxHYzEvUE0rYTBLc3c9PSIsInZhbHVlIjoiNzZVb3k4Z012cWVLVzQ0b1ZKbjY4RnpyY3ltN3pDYlJxRUsvKzJabGx0bEtlMzFDYTNqcW5hWmVVZFl0RzVXK ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitUWDZrTlhQQTc5MDFrREFJMExsalE9PSIsInZhbHVlIjoiSGNFWUMwZlVQTVFnYnpJcnJiUHgzbUF2dzdwL3h6dGM3ZHNRTWpyRGRBQzcwZWNTajY2MDFhdWRIK1F1THBZUmdnd3JacmxYMFF5cUVXb3VRTW5zZGpiUGRjR2w0N1UzNHlhRVBlZmlTbDdlZlBKdzQ4Zzg5MUo3QVI4VGpnak8iLCJtYWMiOiIzMDAxMmEyMzAxMWU4MmM4NDk1ZGIwYjk2ZDM2NjU2NDgyMWQ3N2U5ZmVhYWM0NmFjYzM0MzY2OTBiN2Y4NjZjIiwidGFnIjoiIn0%3D; expires=Sat, 17-May-2025 04:28:43 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IitUWDZrTlhQQTc5MDFrREFJMExsalE9PSIsInZhbHVlIjoiSGNFWUMwZlVQTVFnYnpJcnJiUHgzbUF2dzdwL3h6dGM3ZHNRTWpyRGRBQzcwZWNTajY2MDFhdWRIK1F1THBZUmdnd3Jac ▶"
    1 => "ra_holiday_session=eyJpdiI6Ik1xczJ6V2R6RmxHYzEvUE0rYTBLc3c9PSIsInZhbHVlIjoiNzZVb3k4Z012cWVLVzQ0b1ZKbjY4RnpyY3ltN3pDYlJxRUsvKzJabGx0bEtlMzFDYTNqcW5hWmVVZFl0RzVXK1kweDJVaGpsUnFkZWdmMWtobVVjcXlLRUxTZzlWNVppVWpjQWJSbDdybFZwbkNMbnA5K3pJSGtwbmNHNDUxR3IiLCJtYWMiOiIzYzRkYTEwNmViMmFiYmEzMzhlNjBkYWJhYTM5YjUyZTAxMGYzZGIyNWQwY2U4OGUwOWZmN2NmNjc0MWY1ZDI5IiwidGFnIjoiIn0%3D; expires=Sat, 17-May-2025 04:28:43 GMT; path=/; httponly ◀ra_holiday_session=eyJpdiI6Ik1xczJ6V2R6RmxHYzEvUE0rYTBLc3c9PSIsInZhbHVlIjoiNzZVb3k4Z012cWVLVzQ0b1ZKbjY4RnpyY3ltN3pDYlJxRUsvKzJabGx0bEtlMzFDYTNqcW5hWmVVZFl0RzVXK ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "dSsbHuAwDAcX7hinP9jxj44NvxS6NbaEY25EHZvi"
  "_previous" => array:1 [▶
    "url" => "https://raholiday.com/fr/tour/orange-bay-beach-your-perfect-getaway"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-17 02:28:43	GET	/fr/tour/orange-bay-beach-your-perfect-getaway	38 32 31

Orange Bay

Duration

Tour Type

Location

Overview

Included/Excluded

Travel Styles

FAQs

De quoi ai-je besoin pour compléter ma réservation ?

Comment puis-je connaître l'heure de prise en charge ?

Le transport est-il inclus dans le prix ?

Tour Location

Reviews

Get Updates & More

Copyright © 2022 RA Holiday Co. Tous droits réservés

Développé par

1 x Application (50.48%)	677ms
1 x Booting (49.52%)	664ms

Orange Bay

Duration

Tour Type

Location

Overview

Included/Excluded

Travel Styles

FAQs

De quoi ai-je besoin pour compléter ma réservation ?

Comment puis-je connaître l'heure de prise en charge ?

Le transport est-il inclus dans le prix ?

Tour Location

Reviews

You might also like

Get Updates & More

Copyright © 2022 RA Holiday Co. Tous droits réservés

Développé par