Our best promotional tours
The most popular destinations
26%
Orange Bay
Hurghada
0 Review
9H
from
$45 $33
16%
Orange Bay VIP
Hurghada
0 Review
9H
from
$60 $50

Our Happy Clients

Lavinia-Maria Ichim

Lavinia-Maria Ichim

Recomand cu mare drag echipa RA, noi am fost foarte mulțumiți de serviciile lor ❤ Am fost cu ei la snorkeling, cu submarinul, am vizitat orașul Hurghada și am făcut excursia de o zi în Cairo-Giza. Echipa este punctuala si foarte ospitaliera ❤ Nu veți regreta daca iti vei alege în călătoria voastra ❤

Elena Mircea Marinoiu

Elena Mircea Marinoiu

Recomand cu căldură excursiile organizate de RA Excursii.Profesionalism,amabilitate și punctualitate sunt cuvintele cheie.Am fost cu dumnealor la Cairo și în excursia cu submarinul în septembrie 2021.Sper sa revin cât mai curând!

Scacioc Lucian

Scacioc Lucian

prima noastra excursie cu RA si nici nu pot descrie ce frumos a fost, foarte primitori, amabili,primitori, cu cunostinte foarte mari despre cultura egipteana. in concluzue o experienta superba pe care abea ce asteptam sa o repetam cu ei intr-o noua locatie si o noua experienta🤩🥰🎊🎉

Special Offer

Follow us to discover
the best tour offers
tailored to your interests.

See the Offers

Newsletters

Follow us on Ra Holiday YouTube channel.

Follow us

Travel tips

Tips from our travel experts
to make your next trip even better.

Sign up
Bestseller
Highly rated hotel
Read the latest from the blog.
Contrary to popular belief
  • 01/27/2022

Blogs 1

From the iconic to the unexpected, the city of San Francisco never ceases to...
  • 01/27/2022

Blog 2

From the iconic to the unexpected, the city of San Francisco never ceases to...
  • 01/27/2022

Blog 3

From the iconic to the unexpected, the city of San Francisco never ceases to...
Request history8.1.14PHP Version3.34sRequest Duration6MBMemory UsageGET /RouteAuth status
  • warninglog[19:16:50] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (756ms)time
  • Application (2.58s)time
  • 1 x Application (77.37%)
    2.58s
    1 x Booting (22.63%)
    756ms
    49 templates were rendered
    • 1x Page::frontend.detaildetail.blade.php#?blade
    • 1x Template::frontend.blocks.form-search-all-service.indexindex.blade.php#?blade
    • 1x Template::frontend.blocks.form-search-all-service.style-slider-ver2style-slider-ver2.blade.php#?blade
    • 1x Template::frontend.blocks.form-search-all-service.form-searchform-search.blade.php#?blade
    • 1x Hotel::frontend.layouts.search.form-searchform-search.blade.php#?blade
    • 1x Hotel::frontend.layouts.search.fields.locationlocation.blade.php#?blade
    • 1x Hotel::frontend.layouts.search.fields.datedate.blade.php#?blade
    • 1x Hotel::frontend.layouts.search.fields.guestsguests.blade.php#?blade
    • 1x Tour::frontend.layouts.search.form-searchform-search.blade.php#?blade
    • 1x Tour::frontend.layouts.search.fields.locationlocation.blade.php#?blade
    • 1x Tour::frontend.layouts.search.fields.datedate.blade.php#?blade
    • 1x Location::frontend.blocks.list-locations.indexindex.blade.php#?blade
    • 6x Location::frontend.blocks.list-locations.looploop.blade.php#?blade
    • 1x Tour::frontend.blocks.list-tour.indexindex.blade.php#?blade
    • 1x Tour::frontend.blocks.list-tour.style-normalstyle-normal.blade.php#?blade
    • 3x Tour::frontend.layouts.search.loop-gridloop-grid.blade.php#?blade
    • 1x Template::frontend.blocks.testimonial.indexindex.blade.php#?blade
    • 1x Template::frontend.blocks.offer-block.indexindex.blade.php#?blade
    • 1x Hotel::frontend.blocks.list-hotel.indexindex.blade.php#?blade
    • 1x News::frontend.blocks.list-news.indexindex.blade.php#?blade
    • 3x News::frontend.blocks.list-news.looploop.blade.php#?blade
    • 1x Tour::frontend.blocks.box-category-tour.indexindex.blade.php#?blade
    • 1x Template::frontend.blocks.texttext.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 /
    middleware
    web
    controller
    App\Http\Controllers\HomeController@index
    namespace
    App\Http\Controllers
    prefix
    where
    file
    app/Http/Controllers/HomeController.php:31-61
    41 statements were executed, 4 of which were duplicates, 37 unique. Show only duplicated919ms
    • select * from `core_pages` where `id` = '10' and `status` = 'publish' and `core_pages`.`deleted_at` is null limit 1195msraholidayHomeController.php#34
      Bindings
      • 0: 10
      • 1: publish
      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/Http/Controllers/HomeController.php:34
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `core_page_translations` where `core_page_translations`.`origin_id` = 10 and `core_page_translations`.`origin_id` is not null and `locale` = 'en' limit 130.3msraholidayHasTranslations.php#51
      Bindings
      • 0: 10
      • 1: en
      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/Http/Controllers/HomeController.php:37
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `bravo_seo` where `object_id` = 10 and `object_model` = 'page' limit 116.59msraholidayBaseModel.php#199
      Bindings
      • 0: 10
      • 1: page
      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:212
      • 18. app/Http/Controllers/HomeController.php:38
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `core_templates` where `core_templates`.`id` = 1 and `core_templates`.`id` is not null limit 16.4msraholidayPage.php#79
      Bindings
      • 0: 1
      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. modules/Page/Models/Page.php:79
      • 22. view::Page::frontend.detail:5
      • 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_template_translations` where `core_template_translations`.`origin_id` = 1 and `core_template_translations`.`origin_id` is not null and `locale` = 'en' limit 118.08msraholidayHasTranslations.php#51
      Bindings
      • 0: 1
      • 1: en
      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. modules/Page/Models/Page.php:81
      • 23. view::Page::frontend.detail:5
      • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 100024.37msraholidayFormSearchAllService.php#129
      Bindings
      • 0: publish
      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/Template/Blocks/FormSearchAllService.php:129
      • 18. modules/Template/Blocks/RootBlock.php:10
      • 21. modules/Page/Models/Page.php:82
      • 22. view::Page::frontend.detail:5
      • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1, 2, 3, 4, 5, 6)24.18msraholidayFormSearchAllService.php#129
      Bindings
      • 0: en
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 20. modules/Template/Blocks/FormSearchAllService.php:129
      • 23. modules/Template/Blocks/RootBlock.php:10
      • 26. modules/Page/Models/Page.php:82
      • 27. view::Page::frontend.detail:5
      • 29. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • select * from `bravo_tour_category` where `status` = 'publish' and `bravo_tour_category`.`deleted_at` is null26.4msraholidayFormSearchAllService.php#130
      Bindings
      • 0: publish
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 15. modules/Template/Blocks/FormSearchAllService.php:130
      • 18. modules/Template/Blocks/RootBlock.php:10
      • 21. modules/Page/Models/Page.php:82
      • 22. view::Page::frontend.detail:5
      • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • select * from `bravo_tour_category_translations` where `locale` = 'en' and `bravo_tour_category_translations`.`origin_id` in (1, 5, 6)6.04msraholidayFormSearchAllService.php#130
      Bindings
      • 0: en
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 20. modules/Template/Blocks/FormSearchAllService.php:130
      • 23. modules/Template/Blocks/RootBlock.php:10
      • 26. modules/Page/Models/Page.php:82
      • 27. view::Page::frontend.detail:5
      • 29. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null order by `id` asc limit 620.68msraholidayListLocations.php#168
      Bindings
      • 0: publish
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 15. modules/Location/Blocks/ListLocations.php:168
      • 16. modules/Location/Blocks/ListLocations.php:132
      • 19. modules/Template/Blocks/RootBlock.php:10
      • 22. modules/Page/Models/Page.php:82
      • 23. view::Page::frontend.detail:5
    • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1, 2, 3, 4, 5, 6)22.97msraholidayListLocations.php#168
      Bindings
      • 0: en
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 20. modules/Location/Blocks/ListLocations.php:168
      • 21. modules/Location/Blocks/ListLocations.php:132
      • 24. modules/Template/Blocks/RootBlock.php:10
      • 27. modules/Page/Models/Page.php:82
      • 28. view::Page::frontend.detail:5
    • select count(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 1 and `bravo_locations`.`_rgt` <= 2 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null1.8msraholidayHotel.php#730
      Bindings
      • 0: 1
      • 1: 2
      • 2: publish
      Backtrace
      • 16. modules/Hotel/Models/Hotel.php:730
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_tours`.`id`) as aggregate from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 1 and `bravo_locations`.`_rgt` <= 2 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null14.68msraholidayTour.php#814
      Bindings
      • 0: 1
      • 1: 2
      • 2: publish
      Backtrace
      • 16. modules/Tour/Models/Tour.php:814
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_cars`.`id`) as aggregate from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 1 and `bravo_locations`.`_rgt` <= 2 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null31.32msraholidayCar.php#656
      Bindings
      • 0: 1
      • 1: 2
      • 2: publish
      Backtrace
      • 16. modules/Car/Models/Car.php:656
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 3 and `bravo_locations`.`_rgt` <= 4 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null11.86msraholidayHotel.php#730
      Bindings
      • 0: 3
      • 1: 4
      • 2: publish
      Backtrace
      • 16. modules/Hotel/Models/Hotel.php:730
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_tours`.`id`) as aggregate from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 3 and `bravo_locations`.`_rgt` <= 4 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null930μsraholidayTour.php#814
      Bindings
      • 0: 3
      • 1: 4
      • 2: publish
      Backtrace
      • 16. modules/Tour/Models/Tour.php:814
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_cars`.`id`) as aggregate from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 3 and `bravo_locations`.`_rgt` <= 4 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null42.08msraholidayCar.php#656
      Bindings
      • 0: 3
      • 1: 4
      • 2: publish
      Backtrace
      • 16. modules/Car/Models/Car.php:656
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 5 and `bravo_locations`.`_rgt` <= 6 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null9.59msraholidayHotel.php#730
      Bindings
      • 0: 5
      • 1: 6
      • 2: publish
      Backtrace
      • 16. modules/Hotel/Models/Hotel.php:730
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_tours`.`id`) as aggregate from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 5 and `bravo_locations`.`_rgt` <= 6 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null21.18msraholidayTour.php#814
      Bindings
      • 0: 5
      • 1: 6
      • 2: publish
      Backtrace
      • 16. modules/Tour/Models/Tour.php:814
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_cars`.`id`) as aggregate from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 5 and `bravo_locations`.`_rgt` <= 6 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null42.49msraholidayCar.php#656
      Bindings
      • 0: 5
      • 1: 6
      • 2: publish
      Backtrace
      • 16. modules/Car/Models/Car.php:656
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 7 and `bravo_locations`.`_rgt` <= 8 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null39.26msraholidayHotel.php#730
      Bindings
      • 0: 7
      • 1: 8
      • 2: publish
      Backtrace
      • 16. modules/Hotel/Models/Hotel.php:730
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_tours`.`id`) as aggregate from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 7 and `bravo_locations`.`_rgt` <= 8 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null14.93msraholidayTour.php#814
      Bindings
      • 0: 7
      • 1: 8
      • 2: publish
      Backtrace
      • 16. modules/Tour/Models/Tour.php:814
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_cars`.`id`) as aggregate from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 7 and `bravo_locations`.`_rgt` <= 8 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null18.72msraholidayCar.php#656
      Bindings
      • 0: 7
      • 1: 8
      • 2: publish
      Backtrace
      • 16. modules/Car/Models/Car.php:656
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 9 and `bravo_locations`.`_rgt` <= 10 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null32.92msraholidayHotel.php#730
      Bindings
      • 0: 9
      • 1: 10
      • 2: publish
      Backtrace
      • 16. modules/Hotel/Models/Hotel.php:730
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_tours`.`id`) as aggregate from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 9 and `bravo_locations`.`_rgt` <= 10 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null41.06msraholidayTour.php#814
      Bindings
      • 0: 9
      • 1: 10
      • 2: publish
      Backtrace
      • 16. modules/Tour/Models/Tour.php:814
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_cars`.`id`) as aggregate from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 9 and `bravo_locations`.`_rgt` <= 10 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null420μsraholidayCar.php#656
      Bindings
      • 0: 9
      • 1: 10
      • 2: publish
      Backtrace
      • 16. modules/Car/Models/Car.php:656
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_hotels`.`id`) as aggregate from `bravo_hotels` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_hotels`.`location_id` and `bravo_locations`.`_lft` >= 11 and `bravo_locations`.`_rgt` <= 12 where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null17.18msraholidayHotel.php#730
      Bindings
      • 0: 11
      • 1: 12
      • 2: publish
      Backtrace
      • 16. modules/Hotel/Models/Hotel.php:730
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_tours`.`id`) as aggregate from `bravo_tours` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_tours`.`location_id` and `bravo_locations`.`_lft` >= 11 and `bravo_locations`.`_rgt` <= 12 where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null9.15msraholidayTour.php#814
      Bindings
      • 0: 11
      • 1: 12
      • 2: publish
      Backtrace
      • 16. modules/Tour/Models/Tour.php:814
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(`bravo_cars`.`id`) as aggregate from `bravo_cars` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_cars`.`location_id` and `bravo_locations`.`_lft` >= 11 and `bravo_locations`.`_rgt` <= 12 where `bravo_cars`.`status` = 'publish' and `bravo_cars`.`deleted_at` is null4.32msraholidayCar.php#656
      Bindings
      • 0: 11
      • 1: 12
      • 2: publish
      Backtrace
      • 16. modules/Car/Models/Car.php:656
      • 17. modules/Location/Models/Location.php:78
      • 18. view::Location::frontend.blocks.list-locations.loop:29
      • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select * from `bravo_tour_category` where (0 = 1 or 0 = 1 and `status` = 'publish') and `bravo_tour_category`.`deleted_at` is null5.81msraholidayTour.php#1004
      Bindings
      • 0: publish
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 15. modules/Tour/Models/Tour.php:1004
      • 16. modules/Tour/Blocks/ListTours.php:176
      • 17. modules/Tour/Blocks/ListTours.php:157
      • 20. modules/Template/Blocks/RootBlock.php:10
      • 23. modules/Page/Models/Page.php:82
    • select count(*) as aggregate from (select `bravo_tours`.* from `bravo_tours` where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null group by `bravo_tours`.`id`) as `aggregate_table`5.22msraholidayListTours.php#178
      Bindings
      • 0: publish
      Backtrace
      • 16. modules/Tour/Blocks/ListTours.php:178
      • 17. modules/Tour/Blocks/ListTours.php:157
      • 20. modules/Template/Blocks/RootBlock.php:10
      • 23. modules/Page/Models/Page.php:82
      • 24. view::Page::frontend.detail:5
    • select `bravo_tours`.* from `bravo_tours` where `bravo_tours`.`status` = 'publish' and `bravo_tours`.`deleted_at` is null group by `bravo_tours`.`id` order by `bravo_tours`.`id` asc limit 8 offset 03.41msraholidayListTours.php#178
      Bindings
      • 0: publish
      Backtrace
      • 16. modules/Tour/Blocks/ListTours.php:178
      • 17. modules/Tour/Blocks/ListTours.php:157
      • 20. modules/Template/Blocks/RootBlock.php:10
      • 23. modules/Page/Models/Page.php:82
      • 24. view::Page::frontend.detail:5
    • select * from `bravo_locations` where `bravo_locations`.`id` in (1, 4) and `bravo_locations`.`deleted_at` is null20.61msraholidayListTours.php#178
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 21. modules/Tour/Blocks/ListTours.php:178
      • 22. modules/Tour/Blocks/ListTours.php:157
      • 25. modules/Template/Blocks/RootBlock.php:10
      • 28. modules/Page/Models/Page.php:82
      • 29. view::Page::frontend.detail:5
    • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1, 4)4.96msraholidayListTours.php#178
      Bindings
      • 0: en
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 26. modules/Tour/Blocks/ListTours.php:178
      • 27. modules/Tour/Blocks/ListTours.php:157
      • 30. modules/Template/Blocks/RootBlock.php:10
      • 33. modules/Page/Models/Page.php:82
      • 34. view::Page::frontend.detail:5
    • select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (97, 98, 115)6.86msraholidayListTours.php#178
      Bindings
      • 0: tour
      • 1: 0
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 21. modules/Tour/Blocks/ListTours.php:178
      • 22. modules/Tour/Blocks/ListTours.php:157
      • 25. modules/Template/Blocks/RootBlock.php:10
      • 28. modules/Page/Models/Page.php:82
      • 29. view::Page::frontend.detail:5
    • select * from `bravo_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (97, 98, 115)13.73msraholidayListTours.php#178
      Bindings
      • 0: en
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 21. modules/Tour/Blocks/ListTours.php:178
      • 22. modules/Tour/Blocks/ListTours.php:157
      • 25. modules/Template/Blocks/RootBlock.php:10
      • 28. modules/Page/Models/Page.php:82
      • 29. view::Page::frontend.detail:5
    • select count(*) as aggregate from (select `bravo_hotels`.* from `bravo_hotels` where `bravo_hotels`.`status` = 'publish' and `bravo_hotels`.`deleted_at` is null group by `bravo_hotels`.`id`) as `aggregate_table`35.91msraholidayListHotel.php#161
      Bindings
      • 0: publish
      Backtrace
      • 16. modules/Hotel/Blocks/ListHotel.php:161
      • 17. modules/Hotel/Blocks/ListHotel.php:140
      • 20. modules/Template/Blocks/RootBlock.php:10
      • 23. modules/Page/Models/Page.php:82
      • 24. view::Page::frontend.detail:5
    • select `core_news`.* from `core_news` where `core_news`.`status` = 'publish' and `core_news`.`deleted_at` is null group by `core_news`.`id` order by `core_news`.`id` asc limit 631.49msraholidayListNews.php#134
      Bindings
      • 0: publish
      Backtrace
      • 15. modules/News/Blocks/ListNews.php:134
      • 16. modules/News/Blocks/ListNews.php:89
      • 19. modules/Template/Blocks/RootBlock.php:10
      • 22. modules/Page/Models/Page.php:82
      • 23. view::Page::frontend.detail:5
    • select * from `core_news_translations` where `locale` = 'en' and `core_news_translations`.`origin_id` in (9, 10, 11)23.28msraholidayListNews.php#134
      Bindings
      • 0: en
      Hints
      • 0: Use SELECT * only if you need all columns from table
      Backtrace
      • 20. modules/News/Blocks/ListNews.php:134
      • 21. modules/News/Blocks/ListNews.php:89
      • 24. modules/Template/Blocks/RootBlock.php:10
      • 27. modules/Page/Models/Page.php:82
      • 28. view::Page::frontend.detail:5
    • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 1870μsraholidayHasTranslations.php#51
      Bindings
      • 0: 1
      • 1: en
      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` = 'en' limit 121.57msraholidayHasTranslations.php#51
      Bindings
      • 0: 1
      • 1: en
      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\Location\Models\Location
    14Location.php#?
    Modules\Location\Models\LocationTranslation
    14LocationTranslation.php#?
    Modules\Tour\Models\TourCategory
    3TourCategory.php#?
    Modules\Tour\Models\Tour
    3Tour.php#?
    Modules\Tour\Models\TourTranslation
    3TourTranslation.php#?
    Modules\News\Models\News
    3News.php#?
    Modules\Core\Models\MenuTranslation
    2MenuTranslation.php#?
    Modules\Page\Models\Page
    1Page.php#?
    Modules\Core\Models\SEO
    1SEO.php#?
    Modules\Template\Models\Template
    1Template.php#?
    Modules\Template\Models\TemplateTranslation
    1TemplateTranslation.php#?
      web
      null
      sanctum
      null
        _token
        FCtA7cKOfcCKsTmpts9JWnVlHrdZZyAZIKo0Q5tz
        _previous
        array:1 [ "url" => "https://raholiday.com" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /
        status_code
        200
        
        status_text
        OK
        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=eyJpdiI6Ikl1dE9rZTE3YndaZHRGNEZlWFdyZkE9PSIsInZhbHVlIjoiL3VzWHhDVjNJTWZLYVZvMjFoMmtnSUtKcGZHUDNyUDJWZGQ0WnRzNkVwZEJkSHU0dlU4cmZPQXhoTnI5Tkk5QzgwbXNPLzU1dnRLd3JrTHIyN2ZIVHJRRUxyZDhwdU1hOFJoSDJTdVAwZmRXT1ljOENwTjN4eHh3aHg0NnFPTkQiLCJtYWMiOiI1OWEyNWIxMzhmMTQ0ZjNhODIzZGQ3OTEzMWRhOGUxMzA3N2RiYTlhMDY1ZjNjZDVkNmY4NTU0ZDVjN2QzMjg3IiwidGFnIjoiIn0%3D; ra_holiday_session=eyJpdiI6ImlWODZJS25vNW5VUWZLWXhMOUZsMXc9PSIsInZhbHVlIjoiVDlaZFRaTnFiTUQ0cXNrMkxud3I0OUNhYWxuUkJNbDRDWnZIT2JxOFRES0FGZDhSaTMwb1c1WjAxaUJBMXlEWWlPWnB1R3NYSHVjTHdkMkhsODhyeUMvaGtieGJiVG5YemN4ZTB5ODYyNXJUZzZvTWVBQ0RCVkxURWs0RW1TbkkiLCJtYWMiOiJhNjUyNDljZmM3NWVjZGRiYzY2NjYwZDgwMDg5MTAzMDAzZGRlZTRiYmYyMGY0YTU3ZWFhNTFlOTJkNTAzZjU0IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6Ikl1dE9rZTE3YndaZHRGNEZlWFdyZkE9PSIsInZhbHVlIjoiL3VzWHhDVjNJTWZLYVZvMjFoMmtnSUtKcGZHUDNyUDJWZGQ0WnRzNkVwZEJkSHU0dlU4cmZPQXhoTnI5Tkk5QzgwbXNPL" ] "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "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" => "FCtA7cKOfcCKsTmpts9JWnVlHrdZZyAZIKo0Q5tz" "ra_holiday_session" => "bMDcykqvpPC1tt1diCgGXWa6pxR0oIULXoiu3qvl" ]
        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, 07 Apr 2025 19:16:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkdvQXZmd25Kb2JqVm4xODRPUGNYb3c9PSIsInZhbHVlIjoibmpHUmgvcHozOVI3M0N2bFVHaXhaamVIbm9JKzFZNmVWczBrbmFnMFUwS0wxWjdhb3hINmNFYjErT3BlS3N4Mmlha3B0Nk5hQy9qMFE3eFJTVnZITTJUd0VLVTJyR0VwR1dBVWFwRzVDcDBDNUQ4Um53OWJEanY1MDdsSEt6UXEiLCJtYWMiOiJkYTY5MzczYjFmNzBiYjllYjQzOGE0Yjk3ODZlNzY4YzU1YzcxZGRkMTVjMzQ5NTJlMDdiZmM0ZjJlYTQ0ZTljIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 21:16:52 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkdvQXZmd25Kb2JqVm4xODRPUGNYb3c9PSIsInZhbHVlIjoibmpHUmgvcHozOVI3M0N2bFVHaXhaamVIbm9JKzFZNmVWczBrbmFnMFUwS0wxWjdhb3hINmNFYjErT3BlS3N4Mmlha3B0N" 1 => "ra_holiday_session=eyJpdiI6IllrVGFOSkUyc1lhcXZBVVo1Z3M0Umc9PSIsInZhbHVlIjoiVnlMV2RhV0R3RFF4T2lnRlRMd2tYeGhQbEh5U2grdTBxblJFS2RDQlNTQnBMKzhDN3A3R1ltUW5hTCtmeUV0Si82ZmdiRlh6UERUR081dW4yei8xTFZDY3o2ZG9YWm5LWFdxOUdxMno5ekt6aTNCbEdOa3REa1JUMWhzT2thSFoiLCJtYWMiOiIwYjM4Njk4ZjYwN2Q0N2I1MGEzZWE0NGFkMjFlZDVhYjNkMzk5ZTI4NzFlNGUxZDQ0ZDMxZGQzN2M3YTljOWIxIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 21:16:52 GMT; Max-Age=7200; path=/; httponly; samesite=laxra_holiday_session=eyJpdiI6IllrVGFOSkUyc1lhcXZBVVo1Z3M0Umc9PSIsInZhbHVlIjoiVnlMV2RhV0R3RFF4T2lnRlRMd2tYeGhQbEh5U2grdTBxblJFS2RDQlNTQnBMKzhDN3A3R1ltUW5hTCtmeUV0S" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkdvQXZmd25Kb2JqVm4xODRPUGNYb3c9PSIsInZhbHVlIjoibmpHUmgvcHozOVI3M0N2bFVHaXhaamVIbm9JKzFZNmVWczBrbmFnMFUwS0wxWjdhb3hINmNFYjErT3BlS3N4Mmlha3B0Nk5hQy9qMFE3eFJTVnZITTJUd0VLVTJyR0VwR1dBVWFwRzVDcDBDNUQ4Um53OWJEanY1MDdsSEt6UXEiLCJtYWMiOiJkYTY5MzczYjFmNzBiYjllYjQzOGE0Yjk3ODZlNzY4YzU1YzcxZGRkMTVjMzQ5NTJlMDdiZmM0ZjJlYTQ0ZTljIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 21:16:52 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkdvQXZmd25Kb2JqVm4xODRPUGNYb3c9PSIsInZhbHVlIjoibmpHUmgvcHozOVI3M0N2bFVHaXhaamVIbm9JKzFZNmVWczBrbmFnMFUwS0wxWjdhb3hINmNFYjErT3BlS3N4Mmlha3B0N" 1 => "ra_holiday_session=eyJpdiI6IllrVGFOSkUyc1lhcXZBVVo1Z3M0Umc9PSIsInZhbHVlIjoiVnlMV2RhV0R3RFF4T2lnRlRMd2tYeGhQbEh5U2grdTBxblJFS2RDQlNTQnBMKzhDN3A3R1ltUW5hTCtmeUV0Si82ZmdiRlh6UERUR081dW4yei8xTFZDY3o2ZG9YWm5LWFdxOUdxMno5ekt6aTNCbEdOa3REa1JUMWhzT2thSFoiLCJtYWMiOiIwYjM4Njk4ZjYwN2Q0N2I1MGEzZWE0NGFkMjFlZDVhYjNkMzk5ZTI4NzFlNGUxZDQ0ZDMxZGQzN2M3YTljOWIxIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 21:16:52 GMT; path=/; httponlyra_holiday_session=eyJpdiI6IllrVGFOSkUyc1lhcXZBVVo1Z3M0Umc9PSIsInZhbHVlIjoiVnlMV2RhV0R3RFF4T2lnRlRMd2tYeGhQbEh5U2grdTBxblJFS2RDQlNTQnBMKzhDN3A3R1ltUW5hTCtmeUV0S" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "FCtA7cKOfcCKsTmpts9JWnVlHrdZZyAZIKo0Q5tz" "_previous" => array:1 [ "url" => "https://raholiday.com" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-07 19:16:52GET/1494146
        2025-04-07 - 2025-04-08
        2025-04-07 - 2025-04-08