Maldives-Sri Lanka

Messages Timeline Exceptions Views30 Route Queries22 Models24 Auth Gate Session Request

8.1.32366ms36MBGET packages/{slug}

Booting (215ms)
Application (150ms)
1 x Booting (58.92%)
215.45ms
1 x Application (41.01%)
149.98ms

30 templates were rendered

Hotel::frontend.detail (themes/BC/Hotel/Views/frontend/detail.blade.php)9bladefile
Params
0
row
1
translation
2
hotel_related
3
location_category
4
booking_data
5
review_list
6
seo_meta
7
body_class
8
breadcrumbs

Params
0	`row`
1	`translation`
2	`hotel_related`
3	`location_category`
4	`booking_data`
5	`review_list`
6	`seo_meta`
7	`body_class`
8	`breadcrumbs`

Layout::parts.bc (modules/Layout/parts/bc.blade.php)12bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs

Hotel::frontend.layouts.details.hotel-banner (themes/BC/Hotel/Views/frontend/layouts/details/hotel-banner.blade.php)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
Hotel::frontend.layouts.details.hotel-detail (themes/BC/Hotel/Views/frontend/layouts/details/hotel-detail.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Hotel::frontend.layouts.details.hotel-rooms (themes/BC/Hotel/Views/frontend/layouts/details/hotel-rooms.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
star
Booking::frontend.global.enquiry-form (themes/BC/Booking/Views/frontend/global/enquiry-form.blade.php)15bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
star
14
service_type
Hotel::frontend.layouts.details.hotel-attributes (themes/BC/Hotel/Views/frontend/layouts/details/hotel-attributes.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
star
Hotel::frontend.layouts.details.hotel-surrounding (themes/BC/Hotel/Views/frontend/layouts/details/hotel-surrounding.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
star
Hotel::frontend.layouts.details.hotel-review (themes/BC/Hotel/Views/frontend/layouts/details/hotel-review.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`star`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`star`
14	`service_type`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`star`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`star`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Review::frontend.form (themes/BC/Review/Views/frontend/form.blade.php)13bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score

Tour::frontend.layouts.details.vendor (themes/BC/Tour/Views/frontend/layouts/details/vendor.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Hotel::frontend.layouts.details.hotel-form-enquiry (themes/BC/Hotel/Views/frontend/layouts/details/hotel-form-enquiry.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Hotel::frontend.layouts.details.hotel-related-list (themes/BC/Hotel/Views/frontend/layouts/details/hotel-related-list.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Hotel::frontend.layouts.details.hotel-attributes (themes/BC/Hotel/Views/frontend/layouts/details/hotel-attributes.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Hotel::frontend.layouts.details.hotel-form-enquiry-mobile (themes/BC/Hotel/Views/frontend/layouts/details/hotel-form-enquiry-mobile.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
hotel_related
6
location_category
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

layouts.app (resources/views/layouts/app.blade.php)13bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Layout::app (modules/Layout/app.blade.php)13bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Layout::parts.global-script (modules/Layout/parts/global-script.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Layout::parts.topbar (modules/Layout/parts/topbar.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Layout::parts.header (modules/Layout/parts/header.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)16bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon
logo_id
logo

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`
14	`logo_id`
15	`logo`

Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)16bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon
logo_id
logo

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`
14	`logo_id`
15	`logo`

Layout::parts.footer (modules/Layout/parts/footer.blade.php)14bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`

Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)21bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`
14	`list_widget_footers`
15	`__currentLoopData`
16	`item`
17	`key`
18	`loop`
19	`payment_image`
20	`imgUrl`

Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)21bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`
14	`list_widget_footers`
15	`__currentLoopData`
16	`item`
17	`key`
18	`loop`
19	`payment_image`
20	`imgUrl`

Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)21bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`
14	`list_widget_footers`
15	`__currentLoopData`
16	`item`
17	`key`
18	`loop`
19	`payment_image`
20	`imgUrl`

Popup::frontend.popup (themes/Base/Popup/Views/frontend/popup.blade.php)21bladefile


__env
app
errors
row
translation
hotel_related
location_category
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`translation`
5	`hotel_related`
6	`location_category`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`favicon`
14	`list_widget_footers`
15	`__currentLoopData`
16	`item`
17	`key`
18	`loop`
19	`payment_image`
20	`imgUrl`

uri: GET packages/{slug}
middleware: web
controller: Modules\Hotel\Controllers\HotelController@detail
namespace: Modules\Hotel\Controllers
prefix: /packages
where
as: hotel.detail
file: modules/Hotel/Controllers/HotelController.php:101-139

22 statements were executed, 6 of which were duplicated, 16 unique. Show only duplicated13.71ms

select * from `bravo_hotels` where `slug` = 'maldives-sri-lanka-4n5d' and `bravo_hotels`.`deleted_at` is null limit 12.35ms/modules/Hotel/Controllers/HotelController.php:104tripiexa_tour_and_travel

Metadata
Bindings	0. maldives-sri-lanka-4n5d
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Hotel/Controllers/HotelController.php:104 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /modules/Hotel/Controllers/HotelController.php:35 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_locations` where `bravo_locations`.`id` in (32) and `bravo_locations`.`deleted_at` is null440μs/modules/Hotel/Controllers/HotelController.php:104tripiexa_tour_and_travel

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Hotel/Controllers/HotelController.php:104 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Hotel/Controllers/HotelController.php:35 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (32)400μs/modules/Hotel/Controllers/HotelController.php:104tripiexa_tour_and_travel

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /modules/Hotel/Controllers/HotelController.php:104 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /modules/Hotel/Controllers/HotelController.php:35 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (23) and `bravo_hotel_translations`.`deleted_at` is null

590μs/modules/Hotel/Controllers/HotelController.php:104tripiexa_tour_and_travel

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Hotel/Controllers/HotelController.php:104 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Hotel/Controllers/HotelController.php:35 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (23)410μs/modules/Hotel/Controllers/HotelController.php:104tripiexa_tour_and_travel

Metadata
Bindings	0. hotel 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Hotel/Controllers/HotelController.php:104 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Hotel/Controllers/HotelController.php:35 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_hotels` where `location_id` = '32' and `status` = 'publish' and `id` not in (23) and `bravo_hotels`.`deleted_at` is null limit 4

580μs/modules/Hotel/Controllers/HotelController.php:112tripiexa_tour_and_travel

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

select * from `bravo_locations` where `bravo_locations`.`id` in (32) and `bravo_locations`.`deleted_at` is null380μs/modules/Hotel/Controllers/HotelController.php:112tripiexa_tour_and_travel

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Hotel/Controllers/HotelController.php:112 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Hotel/Controllers/HotelController.php:35 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (32)310μs/modules/Hotel/Controllers/HotelController.php:112tripiexa_tour_and_travel

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	24. /modules/Hotel/Controllers/HotelController.php:112 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /modules/Hotel/Controllers/HotelController.php:35 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_hotel_translations` where `locale` = 'en' and `bravo_hotel_translations`.`origin_id` in (12, 21, 22, 25) and `bravo_hotel_translations`.`deleted_at` is null

430μs/modules/Hotel/Controllers/HotelController.php:112tripiexa_tour_and_travel

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Hotel/Controllers/HotelController.php:112 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Hotel/Controllers/HotelController.php:35 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `user_wishlist` where `object_model` = 'hotel' and `user_id` = 0 and `user_wishlist`.`object_id` in (12, 21, 22, 25)

240μs/modules/Hotel/Controllers/HotelController.php:112tripiexa_tour_and_travel

Metadata
Bindings	0. hotel 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Hotel/Controllers/HotelController.php:112 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Hotel/Controllers/HotelController.php:35 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

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

560μs/modules/Hotel/Models/Hotel.php:722tripiexa_tour_and_travel

Metadata
Bindings	0. 23 1. hotel 2. approved
Backtrace	15. /modules/Hotel/Models/Hotel.php:722 16. /modules/Hotel/Controllers/HotelController.php:114 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /modules/Hotel/Controllers/HotelController.php:35 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null330μs/modules/Hotel/Controllers/HotelController.php:119tripiexa_tour_and_travel

Metadata
Bindings	0. publish
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /modules/Hotel/Controllers/HotelController.php:119 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /modules/Hotel/Controllers/HotelController.php:35 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

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

320μs/modules/Hotel/Controllers/HotelController.php:119tripiexa_tour_and_travel

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Hotel/Controllers/HotelController.php:119 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Hotel/Controllers/HotelController.php:35 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `bravo_seo` where `object_id` = 23 and `object_model` = 'hotel' limit 1890μs/app/BaseModel.php:199tripiexa_tour_and_travel

Metadata
Bindings	0. 23 1. hotel
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/BaseModel.php:199 16. /app/BaseModel.php:212 17. /modules/Hotel/Controllers/HotelController.php:122 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /modules/Hotel/Controllers/HotelController.php:35

select * from `bravo_locations` where ('892' between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 32) and `bravo_locations`.`deleted_at` is null

1.62ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:159tripiexa_tour_and_travel

Metadata
Bindings	0. 892 1. 32
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:159 17. /modules/Location/Traits/HasLocation.php:21 18. /modules/Hotel/Controllers/HotelController.php:131 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /modules/Hotel/Controllers/HotelController.php:35

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

440μs/modules/Hotel/Models/Hotel.php:668tripiexa_tour_and_travel

Metadata
Bindings	0. 23 1. hotel 2. approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Hotel/Models/Hotel.php:668 21. view::Hotel::frontend.detail:15 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

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

450μs/modules/Hotel/Models/Hotel.php:680tripiexa_tour_and_travel

Metadata
Bindings	0. 23 1. hotel 2. approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Hotel/Models/Hotel.php:680 21. view::Hotel::frontend.detail:15 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

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

390μs/modules/Booking/Models/Bookable.php:357tripiexa_tour_and_travel

Metadata
Bindings	0. 23 1. hotel 2. approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Booking/Models/Bookable.php:357 21. view::Hotel::frontend.layouts.details.hotel-detail:32 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

select * from `bravo_hotel_term` where `bravo_hotel_term`.`target_id` = 23 and `bravo_hotel_term`.`target_id` is not null

810μsview::Hotel::frontend.layouts.details.hotel-attributes:2tripiexa_tour_and_travel

Metadata
Bindings	0. 23
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::Hotel::frontend.layouts.details.hotel-attributes:2 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 24. /vendor/laravel/framework/src/Illuminate/View/View.php:195

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

750μs/app/Traits/HasTranslations.php:51tripiexa_tour_and_travel

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

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

470μs/app/Traits/HasTranslations.php:51tripiexa_tour_and_travel

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

select * from `core_pages` where `core_pages`.`id` = '12' and `core_pages`.`deleted_at` is null limit 1550μs/app/Helpers/AppHelper.php:627tripiexa_tour_and_travel

Metadata
Bindings	0. 12
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	19. /app/Helpers/AppHelper.php:627 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 25. /vendor/laravel/framework/src/Illuminate/View/View.php:195

Modules\Page\Models\Page: 1
Modules\Core\Models\MenuTranslation: 2
Modules\Review\Models\Review: 3
Modules\Core\Models\SEO: 1
Modules\Location\Models\LocationCategory: 3
Modules\Hotel\Models\HotelTranslation: 5
Modules\Location\Models\LocationTranslation: 2
Modules\Location\Models\Location: 2
Modules\Hotel\Models\Hotel: 5

web: null
sanctum: null

_token: 9f4n9ChYR9yisGbjQ1eoNNygsnMKryUZ4WAfc3Fc
_previous: array:1 [ "url" => "https://www.triptravellers.xyz/packages/maldives-sri-lanka-4n5d" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/packages/maldives-sri-lanka-4n5d

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:23 [▼
  "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, br"
  ]
  "host" => array:1 [▶
    0 => "www.triptravellers.xyz"
  ]
  "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"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "216.73.216.9,172.71.254.15"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "cf-ray" => array:1 [▶
    0 => "94cd38cc8fb6dad8-ORD"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "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"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "216.73.216.9"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-https" => array:1 [▶
    0 => "on"
  ]
]

request_server

  0 of 0   
array:50 [▼
  "PATH" => "/usr/local/bin:/bin:/usr/bin"
  "HTTP_ACCEPT" => "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"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_HOST" => "www.triptravellers.xyz"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_X_FORWARDED_FOR" => "216.73.216.9,172.71.254.15"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_CF_RAY" => "94cd38cc8fb6dad8-ORD"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_CF_CONNECTING_IP" => "216.73.216.9"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_HTTPS" => "on"
  "DOCUMENT_ROOT" => "/home/tripiexa/public_html"
  "REMOTE_ADDR" => "216.73.216.9"
  "REMOTE_PORT" => "50960"
  "SERVER_ADDR" => "199.188.200.109"
  "SERVER_NAME" => "www.triptravellers.xyz"
  "SERVER_ADMIN" => "webmaster@triptravellers.xyz"
  "SERVER_PORT" => "443"
  "REQUEST_SCHEME" => "https"
  "REQUEST_URI" => "/packages/maldives-sri-lanka-4n5d"
  "REDIRECT_URL" => "/public/packages/maldives-sri-lanka-4n5d"
  "REDIRECT_REQUEST_METHOD" => "GET"
  "PROXY_REMOTE_ADDR" => "199.188.200.109"
  "HTTPS" => "on"
  "REDIRECT_STATUS" => "200"
  "SCRIPT_FILENAME" => "/home/tripiexa/public_html/public/index.php"
  "QUERY_STRING" => ""
  "SCRIPT_URI" => "https://www.triptravellers.xyz/packages/maldives-sri-lanka-4n5d"
  "SCRIPT_URL" => "/packages/maldives-sri-lanka-4n5d"
  "SCRIPT_NAME" => "/public/index.php"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "SERVER_SOFTWARE" => "LiteSpeed"
  "REQUEST_METHOD" => "GET"
  "X-LSCACHE" => "on"
  "PHP_SELF" => "/public/index.php"
  "REQUEST_TIME_FLOAT" => 1749436382.3495
  "REQUEST_TIME" => 1749436382
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 09 Jun 2025 02:33:02 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9GVG5CblR4aDFUd3Yzc1Z0aWlWb2c9PSIsInZhbHVlIjoiZFBLcDFLMnhnY3pJQVBNNFhDOEx0cFNBSW93MitENnVvU0hITDZDNGRCd3J2WUR3bk04SGVDYWpDek1peVlpNnZuVDkzUXNrMW5jbzcwMTNDVlZPNU9zWGg2c1lRWE93UC9SdDBiOCsvTWJKTzE0ejZvQTNSTkMrMDdlR2l1c04iLCJtYWMiOiI5NWM2MDE2NzBiYTIzOWU5NGRhZWY5MjA1ZWRmOGY1YTRmNjc5ZWJjZDM0YjRjZjI1YmE2ZDlmYTc5ODEzMzBkIiwidGFnIjoiIn0%3D; expires=Mon, 09 Jun 2025 04:33:02 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im9GVG5CblR4aDFUd3Yzc1Z0aWlWb2c9PSIsInZhbHVlIjoiZFBLcDFLMnhnY3pJQVBNNFhDOEx0cFNBSW93MitENnVvU0hITDZDNGRCd3J2WUR3bk04SGVDYWpDek1peVlpNnZuVDkzU ▶"
    1 => "booking_core_session=eyJpdiI6ImwrNFNQRDY5eTdwSGFZNDFDRnNOV2c9PSIsInZhbHVlIjoiS0dBSXE3a25QcWxscFJuNk1BVUxDT0Q3S042ckprTkxXVjdNTnVCb1hwcVlnVmlNcU11ckFpYmFoT2srUVljU0Z3NFZIakxxTElUcmF5YjBJVzhhTUdHYjl4di84QmVsNjRPSy9UeGxkSjFtUFVFQXIwSmUxdWxPWW82TXFOUzIiLCJtYWMiOiI4MjM2M2IwNDk1ZWFjOTNkOWY1YTVkZTE2MmU4YzIzY2JkOTUxNGJjOThmYzViOTUxZGZkYzEzM2JiYjNkYjI2IiwidGFnIjoiIn0%3D; expires=Mon, 09 Jun 2025 04:33:02 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀booking_core_session=eyJpdiI6ImwrNFNQRDY5eTdwSGFZNDFDRnNOV2c9PSIsInZhbHVlIjoiS0dBSXE3a25QcWxscFJuNk1BVUxDT0Q3S042ckprTkxXVjdNTnVCb1hwcVlnVmlNcU11ckFpYmFoT2srUVl ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9GVG5CblR4aDFUd3Yzc1Z0aWlWb2c9PSIsInZhbHVlIjoiZFBLcDFLMnhnY3pJQVBNNFhDOEx0cFNBSW93MitENnVvU0hITDZDNGRCd3J2WUR3bk04SGVDYWpDek1peVlpNnZuVDkzUXNrMW5jbzcwMTNDVlZPNU9zWGg2c1lRWE93UC9SdDBiOCsvTWJKTzE0ejZvQTNSTkMrMDdlR2l1c04iLCJtYWMiOiI5NWM2MDE2NzBiYTIzOWU5NGRhZWY5MjA1ZWRmOGY1YTRmNjc5ZWJjZDM0YjRjZjI1YmE2ZDlmYTc5ODEzMzBkIiwidGFnIjoiIn0%3D; expires=Mon, 09-Jun-2025 04:33:02 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im9GVG5CblR4aDFUd3Yzc1Z0aWlWb2c9PSIsInZhbHVlIjoiZFBLcDFLMnhnY3pJQVBNNFhDOEx0cFNBSW93MitENnVvU0hITDZDNGRCd3J2WUR3bk04SGVDYWpDek1peVlpNnZuVDkzU ▶"
    1 => "booking_core_session=eyJpdiI6ImwrNFNQRDY5eTdwSGFZNDFDRnNOV2c9PSIsInZhbHVlIjoiS0dBSXE3a25QcWxscFJuNk1BVUxDT0Q3S042ckprTkxXVjdNTnVCb1hwcVlnVmlNcU11ckFpYmFoT2srUVljU0Z3NFZIakxxTElUcmF5YjBJVzhhTUdHYjl4di84QmVsNjRPSy9UeGxkSjFtUFVFQXIwSmUxdWxPWW82TXFOUzIiLCJtYWMiOiI4MjM2M2IwNDk1ZWFjOTNkOWY1YTVkZTE2MmU4YzIzY2JkOTUxNGJjOThmYzViOTUxZGZkYzEzM2JiYjNkYjI2IiwidGFnIjoiIn0%3D; expires=Mon, 09-Jun-2025 04:33:02 GMT; path=/; httponly ◀booking_core_session=eyJpdiI6ImwrNFNQRDY5eTdwSGFZNDFDRnNOV2c9PSIsInZhbHVlIjoiS0dBSXE3a25QcWxscFJuNk1BVUxDT0Q3S042ckprTkxXVjdNTnVCb1hwcVlnVmlNcU11ckFpYmFoT2srUVl ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "9f4n9ChYR9yisGbjQ1eoNNygsnMKryUZ4WAfc3Fc"
  "_previous" => array:1 [▶
    "url" => "https://www.triptravellers.xyz/packages/maldives-sri-lanka-4n5d"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Maldives-Sri Lanka-4N/5D

Available Rooms

Rules

Reviews

Get Updates & More

1 x Booting (58.92%)	215.45ms
1 x Application (41.01%)	149.98ms

Maldives-Sri Lanka-4N/5D

Available Rooms

Rules

Reviews

Related Hotel

Maafushi Island & Hulhumale Island 4 Night 5 Days

Maldives-Centara Ras Fushi Resort & Spa-4N/5N

Maldives-Paradise Island Resort & Spa-3N/4D

Maldives-Sri Lanka-5N/6D

Get Updates & More