Home Page

Messages1 Timeline Exceptions Views49 Route Queries41 Models46 Mails Auth Gate Session Request

warninglog[08:03:20] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...

Booting (362ms)time
Application (576ms)time
1 x Application (61.41%)
576ms
1 x Booting (38.59%)
362ms

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 duplicated135ms

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

8.56msraholidayHasTranslations.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 1390μ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 12.19msraholidayPage.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

5.6msraholidayHasTranslations.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 10006.88msraholidayFormSearchAllService.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)

2.19msraholidayFormSearchAllService.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 null7.24msraholidayFormSearchAllService.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)

390μ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

7.23msraholidayListLocations.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)

440μsraholidayListLocations.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

5.6msraholidayHotel.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

3.97msraholidayTour.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

4.74msraholidayCar.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

7.29msraholidayHotel.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

6.34msraholidayTour.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

2.07msraholidayCar.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

500μ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

320μsraholidayTour.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.69msraholidayCar.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

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

460μsraholidayTour.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

2.62msraholidayCar.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

2.23msraholidayHotel.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

2.33msraholidayTour.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

1.99msraholidayCar.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

2.31msraholidayHotel.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

320μsraholidayTour.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

1.59msraholidayCar.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

5.39msraholidayTour.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`

560μ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

3.31msraholidayListTours.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 null3.12msraholidayListTours.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)

2.11msraholidayListTours.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)

400μ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 (97, 98, 115)3.29msraholidayListTours.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`

6.83msraholidayListHotel.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)330μ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

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

3.23msraholidayHasTranslations.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: fkzKmT1YFUo5gCcX2A6ByzDR7S6F9JHwULUw0YwB
_previous: array:1 [ "url" => "https://raholiday.com" ]
_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=eyJpdiI6InhVNXh5SytYbzBicUVJSFpZYTBuSUE9PSIsInZhbHVlIjoiRXB1L2ZvSUVKWm13L3Vqd0l4V01sMHZ6dTJWaG93MXBHakRiYS95cTFwRVFGczkzVzh4WGplSGFlWHFqdXNhSnI5RVdMWFg1UHFNakowaERUV3IvOUZNeE9YVUFub1liQWFJSnVac0VuNUxKWjU4SWFpeXNVMVRPVnFaS1poR3EiLCJtYWMiOiIxNDcxMTE3YTJkN2U5MmYyMmVjMDllOWZiNGY4NjRlNmUwYmZkOTRmZTkzMTllYjZkN2I4ZmEzMWVhMTM0NjZlIiwidGFnIjoiIn0%3D; ra_holiday_session=eyJpdiI6Im44cmxScVI3ZkJMWnU3N21TQ0hTZEE9PSIsInZhbHVlIjoic3hDUzlsQlFZdnZBOUovdittbEhzNFo1Y0FTM3pZMVowWHM5TkNsK0h3WW9zTklINk4yZ2lDNVJ6U28wNWlhdWl2MGdySXFoYWRpNDEvNkNyQXk0Qi9WQnFrd085YXZWZGdjSzIvRENidzRoMWhZdlVKQkVnV0RnYW9qYXMrWm8iLCJtYWMiOiI4M2I5MWNhYzA3NDU3ZmUxOGM0NTcyZTE2ZjNhODEyNTQ0NzJmOTA5MDBiZjg1ZDRjNzBhMDc4Mjc2OWE4OTcxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InhVNXh5SytYbzBicUVJSFpZYTBuSUE9PSIsInZhbHVlIjoiRXB1L2ZvSUVKWm13L3Vqd0l4V01sMHZ6dTJWaG93MXBHakRiYS95cTFwRVFGczkzVzh4WGplSGFlWHFqdXNhSnI5RVdMW ▶"
  ]
  "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" => "fkzKmT1YFUo5gCcX2A6ByzDR7S6F9JHwULUw0YwB"
  "ra_holiday_session" => "Ox16csDFZ0n3sDtUUKYzNB9hoHLg8XkFkAV2Obcz"
]

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 08:03:20 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJtYSt2cVh4a1lRL3V4SGdZc3BSVHc9PSIsInZhbHVlIjoiRTEvYytTNVlWbW5pZHlKL2o5NXU1akhocmRuZzVUcVpOVEpIRERXUFYxU01ra1ZBUmt5NnZSeExqaTNBYnRybzZiSXdIRW50Ry9rZHozZ215Z2dGWXljUVRHUEpJaThtb1c0dkpoRENuNlhDeVF3ZmxLWXhIZ3NkSVNHeDlkNnYiLCJtYWMiOiJjYTliYzJkMDA1YjljNzdmMjEzMzgwNDhhNWNhNjU4MDdmMTNiMTdiYjBiODgxMDM3OTUzNTFiMTg3OGM1MmI5IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 10:03:21 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJtYSt2cVh4a1lRL3V4SGdZc3BSVHc9PSIsInZhbHVlIjoiRTEvYytTNVlWbW5pZHlKL2o5NXU1akhocmRuZzVUcVpOVEpIRERXUFYxU01ra1ZBUmt5NnZSeExqaTNBYnRybzZiSXdIR ▶"
    1 => "ra_holiday_session=eyJpdiI6ImcyTFpGVnloU2xuZkVLcW51NDFUcVE9PSIsInZhbHVlIjoib01zLzVlbHQyRWZFbUFtaVY1RHRROWVnaWpiTjlrSytSTnpyR1c0QzdWL3NVMTArVFlXT0hRSmpDV0pQd29hWEFRREpFQm94ZVpTUnVJNm82ZHlhZXdrdlVSUTMvQ2EzTnNHdU0zNFNhYTAwaXNzMFN0WjlnQmRXRElaQStUMFQiLCJtYWMiOiJlZmJmNjgxOTYyYzA5ZWRkYzFiNDEyZDMzNTdkNmZmZTA4NWMxMmEyMGZiYmY3M2IyMTIyYWZjMzAyYjkxZjJlIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 10:03:21 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀ra_holiday_session=eyJpdiI6ImcyTFpGVnloU2xuZkVLcW51NDFUcVE9PSIsInZhbHVlIjoib01zLzVlbHQyRWZFbUFtaVY1RHRROWVnaWpiTjlrSytSTnpyR1c0QzdWL3NVMTArVFlXT0hRSmpDV0pQd29hW ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJtYSt2cVh4a1lRL3V4SGdZc3BSVHc9PSIsInZhbHVlIjoiRTEvYytTNVlWbW5pZHlKL2o5NXU1akhocmRuZzVUcVpOVEpIRERXUFYxU01ra1ZBUmt5NnZSeExqaTNBYnRybzZiSXdIRW50Ry9rZHozZ215Z2dGWXljUVRHUEpJaThtb1c0dkpoRENuNlhDeVF3ZmxLWXhIZ3NkSVNHeDlkNnYiLCJtYWMiOiJjYTliYzJkMDA1YjljNzdmMjEzMzgwNDhhNWNhNjU4MDdmMTNiMTdiYjBiODgxMDM3OTUzNTFiMTg3OGM1MmI5IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 10:03:21 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InJtYSt2cVh4a1lRL3V4SGdZc3BSVHc9PSIsInZhbHVlIjoiRTEvYytTNVlWbW5pZHlKL2o5NXU1akhocmRuZzVUcVpOVEpIRERXUFYxU01ra1ZBUmt5NnZSeExqaTNBYnRybzZiSXdIR ▶"
    1 => "ra_holiday_session=eyJpdiI6ImcyTFpGVnloU2xuZkVLcW51NDFUcVE9PSIsInZhbHVlIjoib01zLzVlbHQyRWZFbUFtaVY1RHRROWVnaWpiTjlrSytSTnpyR1c0QzdWL3NVMTArVFlXT0hRSmpDV0pQd29hWEFRREpFQm94ZVpTUnVJNm82ZHlhZXdrdlVSUTMvQ2EzTnNHdU0zNFNhYTAwaXNzMFN0WjlnQmRXRElaQStUMFQiLCJtYWMiOiJlZmJmNjgxOTYyYzA5ZWRkYzFiNDEyZDMzNTdkNmZmZTA4NWMxMmEyMGZiYmY3M2IyMTIyYWZjMzAyYjkxZjJlIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 10:03:21 GMT; path=/; httponly ◀ra_holiday_session=eyJpdiI6ImcyTFpGVnloU2xuZkVLcW51NDFUcVE9PSIsInZhbHVlIjoib01zLzVlbHQyRWZFbUFtaVY1RHRROWVnaWpiTjlrSytSTnpyR1c0QzdWL3NVMTArVFlXT0hRSmpDV0pQd29hW ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 08:03:21	GET	/	1 49 41 46

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 (61.41%)	576ms
1 x Booting (38.59%)	362ms