Sharm El Naga avec plongée

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

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

Booting (368ms)time
Application (678ms)time
1 x Application (64.82%)
678ms
1 x Booting (35.18%)
368ms

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 duplicated135ms

select * from `bravo_tours` where `slug` = 'sharm-el-naga-with-diving' and `bravo_tours`.`deleted_at` is null limit 120.77msraholidayTourController.php#107

Bindings	0: sharm-el-naga-with-diving
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 null450μ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)760μsraholidayTourController.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 (81)3.27msraholidayTourController.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 (81)7.02msraholidayTourController.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 (81) and `bravo_tours`.`deleted_at` is null limit 4

34.99msraholidayTourController.php#115

Bindings	0: 1 1: publish 2: 81
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 null460μ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)340μsraholidayTourController.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)

380μ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)

290μsraholidayTourController.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` = 81 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null

4.72msraholidayTour.php#831

Bindings	0: 81 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` = 81 and `bravo_tour_meta`.`tour_id` is not null limit 1

2.66msraholidayTour.php#592

Bindings	0: 81
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` = 280 and `object_model` = 'tour_translation_fr' limit 13.33msraholidayBaseModel.php#199

Bindings	0: 280 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 null560μsraholidayTourController.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.25msraholidayTourController.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

370μ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` = 81 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

8.51msraholidayTour.php#757

Bindings	0: 81 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` = 81 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

2.63msraholidayTour.php#769

Bindings	0: 81 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` = 81 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

2.23msraholidayBookable.php#359

Bindings	0: 81 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.82msraholidaytour-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)

3.28msraholidaytour-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 1800μ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.41msraholidayBaseModel.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 17.35msraholidayBaseModel.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 1510μ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 `bravo_tour_term` where `bravo_tour_term`.`tour_id` = 81 and `bravo_tour_term`.`tour_id` is not null9.53msraholidaytour-attributes.blade.php#2

Bindings	0: 81
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 (5) and `bravo_terms`.`deleted_at` is null360μsraholidayTerms.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 (5)590μsraholidayTerms.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 null4.88msraholidayTerms.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

2.15msraholidayHasTranslations.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

2.56msraholidayHasTranslations.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.69msraholidayHasTranslations.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\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\Tour\Models\TourTerm: 1TourTerm.php#?
Modules\Core\Models\Terms: 1Terms.php#?
Modules\Core\Models\Attributes: 1Attributes.php#?

web: null
sanctum: null

_token: utZZqE1Ll2PIGlfkc8fwlUPXVhlAdTquDovaBJwu
bc_current_currency: usd
_previous: array:1 [ "url" => "https://raholiday.com/fr/tour/sharm-el-naga-with-diving" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/fr/tour/sharm-el-naga-with-diving

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "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"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNFRHJSSVdQcTh2T2VtZ3R1OGNveVE9PSIsInZhbHVlIjoiTmdhUzNxUFprODBDK09oZ2F2MGNVMzBxTzdQWTBuejlRbERjRGJtUGpXdG5wdTFvUmpwTFg2OUMwUGpnOCsyVWRwNWs0c1N3NmszdlNNN0pna2lUSGY1WjRSMzZwWU9UR2xTM1k4c0FWcGxsR040KzUveWRlNEVqOGZZLzA1QzMiLCJtYWMiOiI3YzA5MjQwMmEzOWIzZDlkODEyYWVmNDU0NjNiYzJkYjJkYjRiNjI1OWYzNDZhMDQ5ZmQ0MjAyZTNkZDc2ZTVlIiwidGFnIjoiIn0%3D; ra_holiday_session=eyJpdiI6ImNLTDlwYUtlYmo5SllTUEtnVkp6WUE9PSIsInZhbHVlIjoiSGExRHpZSisvaUt0REpKcDZKNUxHTTVGN1lMUjNXM3Ztd0NLY0VJNWRmWjJnSDRPeTV6RGVPUy9vTEFBbjEyWWxoMS9NcmszUTd4ay8yZmRRQTBnZnNKRjRkR2VEcURoakhXNndjelNCd0pzUCsyaEp2TVNkdW1aak9SMVFGZjIiLCJtYWMiOiJiNzgzMGI5NDJjMjEzNWQ4ODNlNzMzMjNjMjUyZTFmYTZkN2U0ODZlNTBlOWIzMzY0YzA2ZWE3NTU5OWUyNmE2IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkNFRHJSSVdQcTh2T2VtZ3R1OGNveVE9PSIsInZhbHVlIjoiTmdhUzNxUFprODBDK09oZ2F2MGNVMzBxTzdQWTBuejlRbERjRGJtUGpXdG5wdTFvUmpwTFg2OUMwUGpnOCsyVWRwNWs0c ▶"
  ]
  "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

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "utZZqE1Ll2PIGlfkc8fwlUPXVhlAdTquDovaBJwu"
  "ra_holiday_session" => "STGRMyDReuAUSZj9DgqMJQVNwqBIXBtClpo6ZKqk"
]

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 => "Mon, 19 May 2025 05:33:57 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRpejBaSGZNMC95MU14ZGowWEZaRkE9PSIsInZhbHVlIjoiaWZsdlBUUStOQzdaOE10SVFxTWg1blZnWTNkUENKTGxqSGVKcDlXbEExTzh3cEJsc1N2QlcvaHhuQzRnVXRyQ3NlSDluQkkyV3R3WldGdXNodEkwWlRWYWNKRXVSZm8rR3ptQnZFdlErSlVvZzVTOEtza2V0Mzk3OGlJck93VDIiLCJtYWMiOiI0Y2M1NWRhOWIxM2NiYmY4ZDlmM2NjNTdjZjUxNDg4Yjg0ZGE1NDMwYWRiYWZhYTBmNjc2YTAxMTVjYzc2ZjdlIiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 07:33:58 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlRpejBaSGZNMC95MU14ZGowWEZaRkE9PSIsInZhbHVlIjoiaWZsdlBUUStOQzdaOE10SVFxTWg1blZnWTNkUENKTGxqSGVKcDlXbEExTzh3cEJsc1N2QlcvaHhuQzRnVXRyQ3NlSDluQ ▶"
    1 => "ra_holiday_session=eyJpdiI6Inh3cE55Z0laOVNuWDU1Rzh4TzlqS1E9PSIsInZhbHVlIjoiN3p0UnZab20xTnFncHNKL0tLcjVjQ0JvL3BBSENxZjZoWFpnZWl5SkU5cGIzd1BNL0Z3NlEvQ2lSNnR3ZHBtYkgvd29oUGhxMmtsUFhkYkV3Ly9CVlZ4d2NENytiaFJPdVV2MHNYRXg1SjRSNFFYUlNKdTc2TC92SGZkblhTQ2EiLCJtYWMiOiI4YzgyM2NhNDg1OGM5YzgwMWYyMTQzZTNhOWI5OTBhMWExZjM2MzY5YzlhYWExZmI4NTdjYzUwMmQyNjZmMGNlIiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 07:33:58 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀ra_holiday_session=eyJpdiI6Inh3cE55Z0laOVNuWDU1Rzh4TzlqS1E9PSIsInZhbHVlIjoiN3p0UnZab20xTnFncHNKL0tLcjVjQ0JvL3BBSENxZjZoWFpnZWl5SkU5cGIzd1BNL0Z3NlEvQ2lSNnR3ZHBtY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlRpejBaSGZNMC95MU14ZGowWEZaRkE9PSIsInZhbHVlIjoiaWZsdlBUUStOQzdaOE10SVFxTWg1blZnWTNkUENKTGxqSGVKcDlXbEExTzh3cEJsc1N2QlcvaHhuQzRnVXRyQ3NlSDluQkkyV3R3WldGdXNodEkwWlRWYWNKRXVSZm8rR3ptQnZFdlErSlVvZzVTOEtza2V0Mzk3OGlJck93VDIiLCJtYWMiOiI0Y2M1NWRhOWIxM2NiYmY4ZDlmM2NjNTdjZjUxNDg4Yjg0ZGE1NDMwYWRiYWZhYTBmNjc2YTAxMTVjYzc2ZjdlIiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 07:33:58 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlRpejBaSGZNMC95MU14ZGowWEZaRkE9PSIsInZhbHVlIjoiaWZsdlBUUStOQzdaOE10SVFxTWg1blZnWTNkUENKTGxqSGVKcDlXbEExTzh3cEJsc1N2QlcvaHhuQzRnVXRyQ3NlSDluQ ▶"
    1 => "ra_holiday_session=eyJpdiI6Inh3cE55Z0laOVNuWDU1Rzh4TzlqS1E9PSIsInZhbHVlIjoiN3p0UnZab20xTnFncHNKL0tLcjVjQ0JvL3BBSENxZjZoWFpnZWl5SkU5cGIzd1BNL0Z3NlEvQ2lSNnR3ZHBtYkgvd29oUGhxMmtsUFhkYkV3Ly9CVlZ4d2NENytiaFJPdVV2MHNYRXg1SjRSNFFYUlNKdTc2TC92SGZkblhTQ2EiLCJtYWMiOiI4YzgyM2NhNDg1OGM5YzgwMWYyMTQzZTNhOWI5OTBhMWExZjM2MzY5YzlhYWExZmI4NTdjYzUwMmQyNjZmMGNlIiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 07:33:58 GMT; path=/; httponly ◀ra_holiday_session=eyJpdiI6Inh3cE55Z0laOVNuWDU1Rzh4TzlqS1E9PSIsInZhbHVlIjoiN3p0UnZab20xTnFncHNKL0tLcjVjQ0JvL3BBSENxZjZoWFpnZWl5SkU5cGIzd1BNL0Z3NlEvQ2lSNnR3ZHBtY ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "utZZqE1Ll2PIGlfkc8fwlUPXVhlAdTquDovaBJwu"
  "bc_current_currency" => "usd"
  "_previous" => array:1 [▶
    "url" => "https://raholiday.com/fr/tour/sharm-el-naga-with-diving"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-19 05:33:58	GET	/fr/tour/sharm-el-naga-with-diving	38 32 29

Sharm El Naga avec plongée

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 (64.82%)	678ms
1 x Booting (35.18%)	368ms

Sharm El Naga avec plongée

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