Home Page

Messages1 Timeline Exceptions Views54 Route Queries41 Models58 Mails Auth Gate Session Request

warninglog[04:33:05] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...

Booting (306ms)time
Application (725ms)time
1 x Application (70.33%)
725ms
1 x Booting (29.66%)
306ms

54 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
8x 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 duplicated77.48ms

select * from `core_pages` where `id` = '10' and `status` = 'publish' and `core_pages`.`deleted_at` is null limit 12.42msraholidayHomeController.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 1

670μsraholidayHasTranslations.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 1520μsraholidayBaseModel.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 14.16msraholidayPage.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 1

380μ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. 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 1000550μsraholidayFormSearchAllService.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)

840μsraholidayFormSearchAllService.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 null4.01msraholidayFormSearchAllService.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)

330μsraholidayFormSearchAllService.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 6

830μsraholidayListLocations.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)

3.56msraholidayListLocations.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 null

2.41msraholidayHotel.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 null

5.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 null

1.35msraholidayCar.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 null

380μsraholidayHotel.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 null

1.35msraholidayTour.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 null

460μsraholidayCar.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 null

390μsraholidayHotel.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 null

4.2msraholidayTour.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 null

3.23msraholidayCar.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 null

5.14msraholidayHotel.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 null

1.35msraholidayTour.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 null

4.47msraholidayCar.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 null

550μsraholidayHotel.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 null

4.92msraholidayTour.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 null

330μ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 null

670μsraholidayHotel.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 null

1.33msraholidayTour.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 null

640μsraholidayCar.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 null

350μsraholidayTour.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`

420μsraholidayListTours.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 0

570μsraholidayListTours.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, 3, 4) and `bravo_locations`.`deleted_at` is null340μsraholidayListTours.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, 3, 4)

330μsraholidayListTours.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 (64, 66, 67, 87, 97, 98, 112, 113)

560μsraholidayListTours.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 (64, 66, 67, 87, 97, 98, 112, 113)

4.44msraholidayListTours.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`

600μsraholidayListHotel.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 6

400μsraholidayListNews.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)910μsraholidayListNews.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 1

4.2msraholidayHasTranslations.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 1

7.24msraholidayHasTranslations.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: 15Location.php#?
Modules\Location\Models\LocationTranslation: 15LocationTranslation.php#?
Modules\Tour\Models\Tour: 8Tour.php#?
Modules\Tour\Models\TourTranslation: 8TourTranslation.php#?
Modules\Tour\Models\TourCategory: 3TourCategory.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: JFOA0Kx5YmcmnCSvDwuWZSpD7ykikqk6zw1HWQJ5
_previous: array:1 [ "url" => "https://raholiday.com/public" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

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=eyJpdiI6IlllRUdtT2RQN29tOUxHbzdNU0xya3c9PSIsInZhbHVlIjoiTUo1MFhUU1IwVEpIZENUb2ZhTTF6dDdMZmNwMXNiYzlhUjNkK0tOV3lUR25SaGlDa2htWk9FMmxtOHQ3SktXalVXUmlWcU5oWVRFVEpsWU5LOVVqdTYxQ0wrRTI1TkxEQTZmSkNlUG82UUtUMG9aeml5NWZSTThpaGpZRFBDMEgiLCJtYWMiOiIyNzdmMzAzYThmOGY0ZjgzYzM3ZTE3MWYwYWQ1YmU1NTQ2NmM5MWFjMWI1NTQ1ZDA5YTgxMTA2NGJjOGNmYTczIiwidGFnIjoiIn0%3D; ra_holiday_session=eyJpdiI6Ikh5MnJITS96bytiaGlqcThxM1BvUVE9PSIsInZhbHVlIjoiU29ZRlgzSXJKeEFyblBPQ29KcEY5N2JUU2ovRWdvbWE2dnN4U2Uvenp4bEZXV0tzQ2RLSjF3L0x0eWVKNjJnN1B5M0pwS3NmSVY5V2oxUlM4YnFEcWFzV0RESys5MWJPUnpYUWpmZlhmdUx2M0lnaGE4dStrMm9Za0VnaktFYlAiLCJtYWMiOiI4M2M1ZmZmYzJiMDQxZGVkMTVkNTYwNTM1MTM0MGFhNzU2ZjIxZDU5YmJmNDRiMGYxOWY5NzhjZjYxMGRjOTcxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IlllRUdtT2RQN29tOUxHbzdNU0xya3c9PSIsInZhbHVlIjoiTUo1MFhUU1IwVEpIZENUb2ZhTTF6dDdMZmNwMXNiYzlhUjNkK0tOV3lUR25SaGlDa2htWk9FMmxtOHQ3SktXalVXUmlWc ▶"
  ]
  "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" => "JFOA0Kx5YmcmnCSvDwuWZSpD7ykikqk6zw1HWQJ5"
  "ra_holiday_session" => "sUlhTv20gAEwR6xR9v2ouX87F2IIIxApeeANsIap"
]

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, 10 May 2025 04:33:05 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikl4aWRTSnhwRkZXMXpQN2RyRmczY0E9PSIsInZhbHVlIjoiYjdFajN0ZVRzV2Z4N1BKNFhCNDRjZCtYWDRiaTROd01ML2ZSc0N1RWdsU1Mxejloelpobzh4L1krWjhtaDNZMDNJRWRMazQ0Z2d2NDNwcEp5VGVoSkFWMU9CaFkrUWY3bGpad3laaTVrcmN6Wk8wOHRrWG9KYlEwSWNwazFOZU4iLCJtYWMiOiI1N2ZiZmNhMjg3YTk4MTMwNzkwZDMzMWE2OTdkMmRhNzE0ZTI1OTMwMDM0ZGUwODJlOWIyMDRjNjFiMDZmYjIzIiwidGFnIjoiIn0%3D; expires=Sat, 10 May 2025 06:33:06 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ikl4aWRTSnhwRkZXMXpQN2RyRmczY0E9PSIsInZhbHVlIjoiYjdFajN0ZVRzV2Z4N1BKNFhCNDRjZCtYWDRiaTROd01ML2ZSc0N1RWdsU1Mxejloelpobzh4L1krWjhtaDNZMDNJRWRMa ▶"
    1 => "ra_holiday_session=eyJpdiI6InhuUjM3YzdQU21VNWNYU2JwZzhQWmc9PSIsInZhbHVlIjoiaEtmMjQyZ2laeWhadlg0dEN6WWdmbXN2bEx4S3BzSEhmWElVYytkTTJSbjkzcGZaemtMMldIVllSUjlsTlU0aHlDL3YwbFVSUE5VZFdjWXlDRG9ZMVhZYk11VWZma0Q1b2JDR2FCRVhmdjdZQUJ2UzB5RkRVOW44ekxIbnZLNjQiLCJtYWMiOiJjNWJmZGFhYWQwMDMzYzRkNmY4MGQyNTI1MjNhZTM1NDcxNjA3YmM1YTc3M2UzNGI4ZGUzOTcxNTJhYjYzNTVjIiwidGFnIjoiIn0%3D; expires=Sat, 10 May 2025 06:33:06 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀ra_holiday_session=eyJpdiI6InhuUjM3YzdQU21VNWNYU2JwZzhQWmc9PSIsInZhbHVlIjoiaEtmMjQyZ2laeWhadlg0dEN6WWdmbXN2bEx4S3BzSEhmWElVYytkTTJSbjkzcGZaemtMMldIVllSUjlsTlU0a ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikl4aWRTSnhwRkZXMXpQN2RyRmczY0E9PSIsInZhbHVlIjoiYjdFajN0ZVRzV2Z4N1BKNFhCNDRjZCtYWDRiaTROd01ML2ZSc0N1RWdsU1Mxejloelpobzh4L1krWjhtaDNZMDNJRWRMazQ0Z2d2NDNwcEp5VGVoSkFWMU9CaFkrUWY3bGpad3laaTVrcmN6Wk8wOHRrWG9KYlEwSWNwazFOZU4iLCJtYWMiOiI1N2ZiZmNhMjg3YTk4MTMwNzkwZDMzMWE2OTdkMmRhNzE0ZTI1OTMwMDM0ZGUwODJlOWIyMDRjNjFiMDZmYjIzIiwidGFnIjoiIn0%3D; expires=Sat, 10-May-2025 06:33:06 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ikl4aWRTSnhwRkZXMXpQN2RyRmczY0E9PSIsInZhbHVlIjoiYjdFajN0ZVRzV2Z4N1BKNFhCNDRjZCtYWDRiaTROd01ML2ZSc0N1RWdsU1Mxejloelpobzh4L1krWjhtaDNZMDNJRWRMa ▶"
    1 => "ra_holiday_session=eyJpdiI6InhuUjM3YzdQU21VNWNYU2JwZzhQWmc9PSIsInZhbHVlIjoiaEtmMjQyZ2laeWhadlg0dEN6WWdmbXN2bEx4S3BzSEhmWElVYytkTTJSbjkzcGZaemtMMldIVllSUjlsTlU0aHlDL3YwbFVSUE5VZFdjWXlDRG9ZMVhZYk11VWZma0Q1b2JDR2FCRVhmdjdZQUJ2UzB5RkRVOW44ekxIbnZLNjQiLCJtYWMiOiJjNWJmZGFhYWQwMDMzYzRkNmY4MGQyNTI1MjNhZTM1NDcxNjA3YmM1YTc3M2UzNGI4ZGUzOTcxNTJhYjYzNTVjIiwidGFnIjoiIn0%3D; expires=Sat, 10-May-2025 06:33:06 GMT; path=/; httponly ◀ra_holiday_session=eyJpdiI6InhuUjM3YzdQU21VNWNYU2JwZzhQWmc9PSIsInZhbHVlIjoiaEtmMjQyZ2laeWhadlg0dEN6WWdmbXN2bEx4S3BzSEhmWElVYytkTTJSbjkzcGZaemtMMldIVllSUjlsTlU0a ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "JFOA0Kx5YmcmnCSvDwuWZSpD7ykikqk6zw1HWQJ5"
  "_previous" => array:1 [▶
    "url" => "https://raholiday.com/public"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-10 04:33:06	GET	/public/	1 54 41 58

Let's discover Egypt together

Your adventure starts with us

Let's discover Egypt together

Your adventure starts with us

Hurghada

Aswan

Cairo

Luxor

Alexandria

Siwa

Our Happy Clients

Lavinia-Maria Ichim

Elena Mircea Marinoiu

Scacioc Lucian

Special Offer

Newsletters

Travel tips

Blogs 1

Blog 2

Blog 3

Get Updates & More

Copyright © 2022 RA Holiday Co. All rights reserved.

Developed by

1 x Application (70.33%)	725ms
1 x Booting (29.66%)	306ms