Halong Bay Day Tour

Messages Timeline Exceptions Views31 Route Queries20 Models15 Auth Gate Session Request

8.1.32408ms36MBGET tour/{slug}

Booting (249ms)
Application (158ms)
1 x Booting (61.09%)
248.98ms
1 x Application (38.85%)
158.36ms

31 templates were rendered

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

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs

Tour::frontend.layouts.details.tour-banner (themes/BC/Tour/Views/frontend/layouts/details/tour-banner.blade.php)11bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
Tour::frontend.layouts.details.tour-detail (themes/BC/Tour/Views/frontend/layouts/details/tour-detail.blade.php)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
Tour::frontend.layouts.details.tour-include-exclude (themes/BC/Tour/Views/frontend/layouts/details/tour-include-exclude.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
12
cat
13
location
Tour::frontend.layouts.details.tour-itinerary (themes/BC/Tour/Views/frontend/layouts/details/tour-itinerary.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
12
cat
13
location
Tour::frontend.layouts.details.tour-attributes (themes/BC/Tour/Views/frontend/layouts/details/tour-attributes.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
12
cat
13
location
Tour::frontend.layouts.details.tour-faqs (themes/BC/Tour/Views/frontend/layouts/details/tour-faqs.blade.php)14bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
12
cat
13
location
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
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
12
cat
13
location
Tour::frontend.layouts.details.tour-review (themes/BC/Tour/Views/frontend/layouts/details/tour-review.blade.php)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score

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

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

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

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

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

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

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

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

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

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


__env
app
errors
row
translation
tour_related
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)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
Tour::frontend.layouts.details.tour-form-book (themes/BC/Tour/Views/frontend/layouts/details/tour-form-book.blade.php)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
Booking::frontend.global.enquiry-form (themes/BC/Booking/Views/frontend/global/enquiry-form.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
12
service_type
Tour::frontend.layouts.details.open-hours (themes/BC/Tour/Views/frontend/layouts/details/open-hours.blade.php)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score
Tour::frontend.layouts.details.tour-related (themes/BC/Tour/Views/frontend/layouts/details/tour-related.blade.php)12bladefile
Params
0
__env
1
app
2
errors
3
row
4
translation
5
tour_related
6
booking_data
7
review_list
8
seo_meta
9
body_class
10
breadcrumbs
11
review_score

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

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

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

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

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

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon
logo_id
logo

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon
logo_id
logo

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

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

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


__env
app
errors
row
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
reviewData
score_total
favicon
list_widget_footers
__currentLoopData
item
key
loop
payment_image
imgUrl

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

uri: GET tour/{slug}
middleware: web
controller: \Modules\Tour\Controllers\TourController@detail
namespace: Modules\Tour\Controllers
prefix: /tour
where
file: modules/Tour/Controllers/TourController.php:95-130

20 statements were executed, 2 of which were duplicated, 18 unique. Show only duplicated15.94ms

select * from `bravo_tours` where `slug` = 'halong-bay-day-tour' and `bravo_tours`.`deleted_at` is null limit 12.36ms/modules/Tour/Controllers/TourController.php:97tripiexa_tour_and_travel

Metadata
Bindings	0. halong-bay-day-tour
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/Tour/Controllers/TourController.php:97 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /modules/Tour/Controllers/TourController.php:33 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 (420) and `bravo_locations`.`deleted_at` is null410μs/modules/Tour/Controllers/TourController.php:97tripiexa_tour_and_travel

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:97 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Tour/Controllers/TourController.php:33 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 (420)450μs/modules/Tour/Controllers/TourController.php:97tripiexa_tour_and_travel

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

select * from `bravo_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (61)460μs/modules/Tour/Controllers/TourController.php:97tripiexa_tour_and_travel

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

select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (61)350μs/modules/Tour/Controllers/TourController.php:97tripiexa_tour_and_travel

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

select * from `bravo_tours` where `location_id` = '420' and `status` = 'publish' and `id` not in (61) and `bravo_tours`.`deleted_at` is null limit 4

900μs/modules/Tour/Controllers/TourController.php:105tripiexa_tour_and_travel

Metadata
Bindings	0. 420 1. publish 2. 61
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/Tour/Controllers/TourController.php:105 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /modules/Tour/Controllers/TourController.php:33 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

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

440μs/modules/Tour/Models/Tour.php:835tripiexa_tour_and_travel

Metadata
Bindings	0. 61 1. tour 2. approved
Backtrace	15. /modules/Tour/Models/Tour.php:835 16. /modules/Tour/Controllers/TourController.php:107 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /modules/Tour/Controllers/TourController.php:33 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `bravo_tour_meta` where `bravo_tour_meta`.`tour_id` = 61 and `bravo_tour_meta`.`tour_id` is not null limit 1

420μs/modules/Tour/Models/Tour.php:597tripiexa_tour_and_travel

Metadata
Bindings	0. 61
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	21. /modules/Tour/Models/Tour.php:597 22. /modules/Tour/Controllers/TourController.php:112 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Tour/Controllers/TourController.php:33 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `bravo_seo` where `object_id` = 61 and `object_model` = 'tour' limit 12.24ms/app/BaseModel.php:199tripiexa_tour_and_travel

Metadata
Bindings	0. 61 1. tour
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/Tour/Controllers/TourController.php:114 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /modules/Tour/Controllers/TourController.php:33

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

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

Metadata
Bindings	0. 2763 1. 420
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/Tour/Controllers/TourController.php:123 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /modules/Tour/Controllers/TourController.php:33

select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` = 266 and `bravo_location_translations`.`origin_id` is not null and `locale` = 'en' limit 1

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

Metadata
Bindings	0. 266 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. /modules/Location/Traits/HasLocation.php:23 22. /modules/Tour/Controllers/TourController.php:123 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Tour/Controllers/TourController.php:33

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

650μs/modules/Tour/Models/Tour.php:761tripiexa_tour_and_travel

Metadata
Bindings	0. 61 1. tour 2. approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Tour/Models/Tour.php:761 21. view::Tour::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` = 61 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

550μs/modules/Tour/Models/Tour.php:773tripiexa_tour_and_travel

Metadata
Bindings	0. 61 1. tour 2. approved
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Tour/Models/Tour.php:773 21. view::Tour::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` = 61 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 61 1. tour 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::Tour::frontend.layouts.details.tour-detail:24 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_tour_category` where `bravo_tour_category`.`id` = '1' and `bravo_tour_category`.`id` is not null and `bravo_tour_category`.`deleted_at` is null limit 1

580μsview::Tour::frontend.layouts.details.tour-detail:31tripiexa_tour_and_travel

Metadata
Bindings	0. 1
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	21. view::Tour::frontend.layouts.details.tour-detail:31 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 26. /vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `bravo_tour_category_translations` where `locale` = 'en' and `bravo_tour_category_translations`.`origin_id` in (1)

420μsview::Tour::frontend.layouts.details.tour-detail:31tripiexa_tour_and_travel

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	26. view::Tour::frontend.layouts.details.tour-detail:31 28. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 29. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 31. /vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `bravo_tour_term` where `bravo_tour_term`.`tour_id` = 61 and `bravo_tour_term`.`tour_id` is not null470μsview::Tour::frontend.layouts.details.tour-attributes:2tripiexa_tour_and_travel

Metadata
Bindings	0. 61
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. view::Tour::frontend.layouts.details.tour-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

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

600μ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 1750μ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\Tour\Models\TourCategory: 1
Modules\Review\Models\Review: 3
Modules\Core\Models\SEO: 1
Modules\Tour\Models\TourMeta: 1
Modules\Tour\Models\TourTranslation: 1
Modules\Location\Models\LocationTranslation: 2
Modules\Location\Models\Location: 2
Modules\Tour\Models\Tour: 1

web: null
sanctum: null

_token: 9M3H6zPLSfH8YVSVwtZXjZvhuJhfoAZUDg8zTgSg
_previous: array:1 [ "url" => "https://www.triptravellers.xyz/public/tour/halong-bay-day-tour" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/tour/halong-bay-day-tour

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.67,172.70.127.6"
  ]
  "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 => "950f945d5d49dadb-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.67"
  ]
  "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.67,172.70.127.6"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_CF_RAY" => "950f945d5d49dadb-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.67"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_HTTPS" => "on"
  "DOCUMENT_ROOT" => "/home/tripiexa/public_html"
  "REMOTE_ADDR" => "216.73.216.67"
  "REMOTE_PORT" => "47950"
  "SERVER_ADDR" => "199.188.200.109"
  "SERVER_NAME" => "www.triptravellers.xyz"
  "SERVER_ADMIN" => "webmaster@triptravellers.xyz"
  "SERVER_PORT" => "443"
  "REQUEST_SCHEME" => "https"
  "REQUEST_URI" => "/public/tour/halong-bay-day-tour"
  "REDIRECT_URL" => "/public/tour/halong-bay-day-tour"
  "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/public/tour/halong-bay-day-tour"
  "SCRIPT_URL" => "/public/tour/halong-bay-day-tour"
  "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" => 1750132193.0179
  "REQUEST_TIME" => 1750132193
]

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 => "Tue, 17 Jun 2025 03:49:53 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InQxRFpKQ0FPaVVsUUtmWlFLYXkvZ3c9PSIsInZhbHVlIjoiV21DZDg5dDltelBTWWYvVUtmdzlUQk5aTnMwSi9aSktOTWJueXhXT09QYzJQREV6SDVMQWlTZjRjME1xSnNtUlZIaHQ3SjZ6cHJuV1E1MTUvNHNhOXRuL3l0RXNNWU82czFOVTFhbzZZSGFuRzBZZUhXQTJBSDZIVkFKa1VWSXAiLCJtYWMiOiI3MGE1MWFlMmU4OWY4MTc3MDg1NjZmY2I4MWFhMTUyYmMyZGMxODY1YzllZTRhNjQ5M2ViNmZjMWRjNDRjZWQwIiwidGFnIjoiIn0%3D; expires=Tue, 17 Jun 2025 05:49:53 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InQxRFpKQ0FPaVVsUUtmWlFLYXkvZ3c9PSIsInZhbHVlIjoiV21DZDg5dDltelBTWWYvVUtmdzlUQk5aTnMwSi9aSktOTWJueXhXT09QYzJQREV6SDVMQWlTZjRjME1xSnNtUlZIaHQ3S ▶"
    1 => "booking_core_session=eyJpdiI6IlZWekRkS3RGK1FmcUpNR0pCN25kaWc9PSIsInZhbHVlIjoiOFhFVVBzbHE2RHlvb245U0VFRVVYWWF4ZWJWU3NIekw5dGg2K1VOS0hhZjJrU3dITnR6UENqaW5zVHd2V0ZzMWFaeTMrYng2UDdDV2E0WjEwbHV4UkwvaCt3L251Rkp2N2Y4ZS8xU2o4c3llUVRReG81V1ZaMkNUd3ZHT1JYN0QiLCJtYWMiOiI3YmZlMDcyODJiNzkzZDhjN2I4MDViYTMwZDY2N2ZlNDdlNmVhNDJlOWViZmVmYzFiZTc4NWNkMTVjMjNmNDNmIiwidGFnIjoiIn0%3D; expires=Tue, 17 Jun 2025 05:49:53 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀booking_core_session=eyJpdiI6IlZWekRkS3RGK1FmcUpNR0pCN25kaWc9PSIsInZhbHVlIjoiOFhFVVBzbHE2RHlvb245U0VFRVVYWWF4ZWJWU3NIekw5dGg2K1VOS0hhZjJrU3dITnR6UENqaW5zVHd2V0Z ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InQxRFpKQ0FPaVVsUUtmWlFLYXkvZ3c9PSIsInZhbHVlIjoiV21DZDg5dDltelBTWWYvVUtmdzlUQk5aTnMwSi9aSktOTWJueXhXT09QYzJQREV6SDVMQWlTZjRjME1xSnNtUlZIaHQ3SjZ6cHJuV1E1MTUvNHNhOXRuL3l0RXNNWU82czFOVTFhbzZZSGFuRzBZZUhXQTJBSDZIVkFKa1VWSXAiLCJtYWMiOiI3MGE1MWFlMmU4OWY4MTc3MDg1NjZmY2I4MWFhMTUyYmMyZGMxODY1YzllZTRhNjQ5M2ViNmZjMWRjNDRjZWQwIiwidGFnIjoiIn0%3D; expires=Tue, 17-Jun-2025 05:49:53 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InQxRFpKQ0FPaVVsUUtmWlFLYXkvZ3c9PSIsInZhbHVlIjoiV21DZDg5dDltelBTWWYvVUtmdzlUQk5aTnMwSi9aSktOTWJueXhXT09QYzJQREV6SDVMQWlTZjRjME1xSnNtUlZIaHQ3S ▶"
    1 => "booking_core_session=eyJpdiI6IlZWekRkS3RGK1FmcUpNR0pCN25kaWc9PSIsInZhbHVlIjoiOFhFVVBzbHE2RHlvb245U0VFRVVYWWF4ZWJWU3NIekw5dGg2K1VOS0hhZjJrU3dITnR6UENqaW5zVHd2V0ZzMWFaeTMrYng2UDdDV2E0WjEwbHV4UkwvaCt3L251Rkp2N2Y4ZS8xU2o4c3llUVRReG81V1ZaMkNUd3ZHT1JYN0QiLCJtYWMiOiI3YmZlMDcyODJiNzkzZDhjN2I4MDViYTMwZDY2N2ZlNDdlNmVhNDJlOWViZmVmYzFiZTc4NWNkMTVjMjNmNDNmIiwidGFnIjoiIn0%3D; expires=Tue, 17-Jun-2025 05:49:53 GMT; path=/; httponly ◀booking_core_session=eyJpdiI6IlZWekRkS3RGK1FmcUpNR0pCN25kaWc9PSIsInZhbHVlIjoiOFhFVVBzbHE2RHlvb245U0VFRVVYWWF4ZWJWU3NIekw5dGg2K1VOS0hhZjJrU3dITnR6UENqaW5zVHd2V0Z ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "9M3H6zPLSfH8YVSVwtZXjZvhuJhfoAZUDg8zTgSg"
  "_previous" => array:1 [▶
    "url" => "https://www.triptravellers.xyz/public/tour/halong-bay-day-tour"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Halong Bay Day Tour

Tour Type

Location

Overview

Included/Excluded

Reviews

Get Updates & More

1 x Booting (61.09%)	248.98ms
1 x Application (38.85%)	158.36ms