Test Tour

Messages Timeline Exceptions Views31 Route Queries18 Models12 Auth Gate Session Request

8.1.292.84s6MBGET tour/{slug}

Booting (911ms)
Application (1.93s)
1 x Application (67.91%)
1.93s
1 x Booting (32.08%)
910.90ms

31 templates were rendered

Tour::frontend.detail (themes/Mytravel/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
Tour::frontend.layouts.details.tour-banner (themes/Mytravel/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/Mytravel/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/Mytravel/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
reviewData
13
score_total
Tour::frontend.layouts.details.tour-attributes (themes/Mytravel/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
reviewData
13
score_total
Tour::frontend.layouts.details.tour-itinerary (themes/Mytravel/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
reviewData
13
score_total
Tour::frontend.layouts.details.tour-faqs (themes/Mytravel/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
reviewData
13
score_total
Hotel::frontend.layouts.details.hotel-surrounding (themes/Mytravel/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
reviewData
13
score_total
Tour::frontend.layouts.details.tour-review (themes/Mytravel/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
Review::frontend.form (themes/Mytravel/Review/Views/frontend/form.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/Mytravel/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/Mytravel/Booking/Views/frontend/global/enquiry-form.blade.php)16bladefile
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
bpSp
13
bp
14
sp
15
service_type
Tour::frontend.layouts.details.open-hours (themes/Mytravel/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.vendor (themes/Mytravel/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
Booking::frontend.booking.booking-why-book-us (themes/Mytravel/Booking/Views/frontend/booking/booking-why-book-us.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/Mytravel/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	`row`
1	`translation`
2	`tour_related`
3	`booking_data`
4	`review_list`
5	`seo_meta`
6	`body_class`
7	`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	`reviewData`
13	`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`

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`

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`

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`

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	`bpSp`
13	`bp`
14	`sp`
15	`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`

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 (themes/Mytravel/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 (themes/Mytravel/Layout/parts/seo-meta.blade.php)16bladefile


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

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	`file`

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


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

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	`file`

Layout::parts.header (themes/Mytravel/Layout/parts/header.blade.php)16bladefile


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

Language::frontend.switcher-dropdown (themes/Mytravel/Language/Views/frontend/switcher-dropdown.blade.php)16bladefile
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
file
Core::frontend.currency-switcher-dropdown (themes/Mytravel/Core/Views/frontend/currency-switcher-dropdown.blade.php)16bladefile
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
file

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	`file`

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	`file`

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	`file`

Layout::parts.footer (themes/Mytravel/Layout/parts/footer.blade.php)16bladefile


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

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	`file`

Language::frontend.switcher (themes/Mytravel/Language/Views/frontend/switcher.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
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

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	`file`
16	`info_contact`
17	`list_widget_footers`
18	`__currentLoopData`
19	`item`
20	`key`
21	`loop`

Core::frontend.currency-switcher (themes/Mytravel/Core/Views/frontend/currency-switcher.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
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

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	`file`
16	`info_contact`
17	`list_widget_footers`
18	`__currentLoopData`
19	`item`
20	`key`
21	`loop`

Layout::parts.login-register-modal (themes/Mytravel/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
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

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	`file`
16	`info_contact`
17	`list_widget_footers`
18	`__currentLoopData`
19	`item`
20	`key`
21	`loop`

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
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

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	`file`
16	`info_contact`
17	`list_widget_footers`
18	`__currentLoopData`
19	`item`
20	`key`
21	`loop`

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
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

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	`file`
16	`info_contact`
17	`list_widget_footers`
18	`__currentLoopData`
19	`item`
20	`key`
21	`loop`

Popup::frontend.popup (themes/Mytravel/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
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

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	`file`
16	`info_contact`
17	`list_widget_footers`
18	`__currentLoopData`
19	`item`
20	`key`
21	`loop`

demo_script (resources/views/demo_script.blade.php)16bladefile


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

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	`file`

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:106-141

18 statements were executed660ms

select * from `bravo_tours` where `slug` = 'test-tour' and `bravo_tours`.`deleted_at` is null limit 16.61ms/modules/Tour/Controllers/TourController.php:108tripsap_new

Metadata
Bindings	0. test-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:108 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 (11) and `bravo_locations`.`deleted_at` is null97.48ms/modules/Tour/Controllers/TourController.php:108tripsap_new

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:108 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 (11)960μs/modules/Tour/Controllers/TourController.php:108tripsap_new

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /modules/Tour/Controllers/TourController.php:108 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 (19)182ms/modules/Tour/Controllers/TourController.php:108tripsap_new

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:108 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 (19)810μs/modules/Tour/Controllers/TourController.php:108tripsap_new

Metadata
Bindings	0. tour 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:108 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` = 11 and `status` = 'publish' and `id` not in (19) and `bravo_tours`.`deleted_at` is null limit 4

840μs/modules/Tour/Controllers/TourController.php:116tripsap_new

Metadata
Bindings	0. 11 1. publish 2. 19
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:116 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` = 19 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null

1.18ms/modules/Tour/Models/Tour.php:835tripsap_new

Metadata
Bindings	0. 19 1. tour 2. approved
Backtrace	15. /modules/Tour/Models/Tour.php:835 16. /modules/Tour/Controllers/TourController.php:118 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` = 19 and `bravo_tour_meta`.`tour_id` is not null limit 1

1.09ms/modules/Tour/Models/Tour.php:597tripsap_new

Metadata
Bindings	0. 19
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:123 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` = 19 and `object_model` = 'tour' limit 11.06ms/app/BaseModel.php:199tripsap_new

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

select * from `bravo_locations` where (50 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 11) and `bravo_locations`.`deleted_at` is null

182ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:159tripsap_new

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

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

3.57ms/modules/Tour/Models/Tour.php:761tripsap_new

Metadata
Bindings	0. 19 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:12 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` = 19 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1

1.03ms/modules/Tour/Models/Tour.php:773tripsap_new

Metadata
Bindings	0. 19 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:12 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_term` where `bravo_tour_term`.`tour_id` = 19 and `bravo_tour_term`.`tour_id` is not null2.06msview::Tour::frontend.layouts.details.tour-attributes:2tripsap_new

Metadata
Bindings	0. 19
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 `users` where `id` = 13 and `users`.`deleted_at` is null limit 11.33ms/app/Helpers/AppHelper.php:1255tripsap_new

Metadata
Bindings	0. 13
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/Helpers/AppHelper.php:1255 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 21. /vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `users` where `users`.`id` = 13 and `users`.`deleted_at` is null limit 186.38msview::Tour::frontend.layouts.details.vendor:2tripsap_new

Metadata
Bindings	0. 13
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. view::Tour::frontend.layouts.details.vendor:2 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

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.28ms/app/Traits/HasTranslations.php:51tripsap_new

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 `countries` where `is_active` = 1990μs/app/Helpers/AppHelper.php:1242tripsap_new

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/AppHelper.php:1242 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 20. /vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `core_pages` where `core_pages`.`id` = '' and `core_pages`.`deleted_at` is null limit 187.96ms/app/Helpers/AppHelper.php:627tripsap_new

Metadata
Bindings	0.
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

App\Models\Country: 1
Modules\Core\Models\MenuTranslation: 1
App\User: 1
App\Models\User: 1
Modules\Review\Models\Review: 2
Modules\Core\Models\SEO: 1
Modules\Tour\Models\TourMeta: 1
Modules\Tour\Models\TourTranslation: 1
Modules\Location\Models\LocationTranslation: 1
Modules\Location\Models\Location: 1
Modules\Tour\Models\Tour: 1

web: null
sanctum: null

_token: YLlxsTtYRPAAsAOd56zf2VTIFEejt3Jz3TzWJ3tW
_previous: array:1 [ "url" => "http://new.tripsapata.com/tour/test-tour" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/tour/test-tour

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "cf-connecting-ip" => array:1 [▶
    0 => "216.73.216.123"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "http"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"http"}"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "new.tripsapata.com"
  ]
  "cf-ray" => array:1 [▶
    0 => "96076608abb2b402-YYZ"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.3.65.84,216.73.216.123"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-z2zcl (squid/6.10)"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
]

request_server

  0 of 0   
array:56 [▼
  "USER" => "tripsap"
  "HOME" => "/home/tripsap"
  "SCRIPT_NAME" => "/public/index.php"
  "REQUEST_URI" => "/tour/test-tour"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/public/tour/test-tour"
  "REMOTE_PORT" => "32158"
  "SCRIPT_FILENAME" => "/home/tripsap/new.tripsapata.com/public/index.php"
  "SERVER_ADMIN" => "webmaster@new.tripsapata.com"
  "CONTEXT_DOCUMENT_ROOT" => "/home/tripsap/new.tripsapata.com"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "http"
  "DOCUMENT_ROOT" => "/home/tripsap/new.tripsapata.com"
  "REMOTE_ADDR" => "172.70.80.169"
  "SERVER_PORT" => "80"
  "SERVER_ADDR" => "185.196.20.72"
  "SERVER_NAME" => "new.tripsapata.com"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶"
  "HTTP_CF_CONNECTING_IP" => "216.73.216.123"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "http"
  "HTTP_CF_VISITOR" => "{"scheme":"http"}"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_HOST" => "new.tripsapata.com"
  "HTTP_CF_RAY" => "96076608abb2b402-YYZ"
  "HTTP_X_FORWARDED_FOR" => "10.3.65.84,216.73.216.123"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_VIA" => "1.1 squid-proxy-5b5d847c96-z2zcl (squid/6.10)"
  "HTTP_ACCEPT_ENCODING" => "gzip"
  "HTTP_CF_IPCOUNTRY" => "US"
  "proxy-nokeepalive" => "1"
  "SCRIPT_URI" => "http://new.tripsapata.com/tour/test-tour"
  "SCRIPT_URL" => "/tour/test-tour"
  "UNIQUE_ID" => "aHiMi3oYforCXaJtT--iUQAAAks"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SCRIPT_URI" => "http://new.tripsapata.com/tour/test-tour"
  "REDIRECT_SCRIPT_URL" => "/tour/test-tour"
  "REDIRECT_UNIQUE_ID" => "aHiMi3oYforCXaJtT--iUQAAAks"
  "REDIRECT_REDIRECT_STATUS" => "200"
  "REDIRECT_REDIRECT_SCRIPT_URI" => "http://new.tripsapata.com/tour/test-tour"
  "REDIRECT_REDIRECT_SCRIPT_URL" => "/tour/test-tour"
  "REDIRECT_REDIRECT_UNIQUE_ID" => "aHiMi3oYforCXaJtT--iUQAAAks"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/public/index.php"
  "REQUEST_TIME_FLOAT" => 1752730763.8728
  "REQUEST_TIME" => 1752730763
  "argv" => []
  "argc" => 0
]

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 => "Thu, 17 Jul 2025 05:39:25 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImszMHdTTWtpd1ZwOFM2RXdGcmlzZ0E9PSIsInZhbHVlIjoibFlHaDVzZytaVVNLMlU5NSt5RkZIU3RUMUpFNzUvT0J3YXpDWVlYL3pnckNMS2NGVWJSdjVRS0VvUnY5Z3kzVkY5M1VRQlNmYnJCdDBkbGJUYWswanUxdUhyNlFCWW16bDVNUXBpUlNHTE9DbHVlcksvOTBrTk1vaEVxbTZZR2YiLCJtYWMiOiJhNzk2Njk3Y2NkYzdhM2NmZGU3ODVkYjdmZTFhZWExMTY2NzliMDE3OTI3MzM0ZmE1N2U5ODgwYTI4MGM3YWVlIiwidGFnIjoiIn0%3D; expires=Thu, 17 Jul 2025 07:39:26 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImszMHdTTWtpd1ZwOFM2RXdGcmlzZ0E9PSIsInZhbHVlIjoibFlHaDVzZytaVVNLMlU5NSt5RkZIU3RUMUpFNzUvT0J3YXpDWVlYL3pnckNMS2NGVWJSdjVRS0VvUnY5Z3kzVkY5M1VRQ ▶"
    1 => "tripsapata_session=eyJpdiI6Ikg4QzRWVzZaUjg0cHc3NjhxUmpCdkE9PSIsInZhbHVlIjoic1R2WVg5ZGo0YXRhRm1rR2E1Zjc2cFRUOW5FYXpmN1JzN3lITlJ5OVlDQVpkMWcrOENjYVN1NmJORHpXY0xQUEdwSkxzSWhBT0JBVEVLSENsZ0p0TXpDTnFkRldJUDNvV2ZCWEx5Tk9JMHZ5UkVqTmxMWVQ2WktZL1ZLelVTYXUiLCJtYWMiOiJiOTJiYWZkMDdkODZmNTU1Y2RlOGI1OGQ1Y2U3MThiNjc1NDkzZjI1MDgwMmFlOTNmZjBkMDY2NWZkYzk3N2U3IiwidGFnIjoiIn0%3D; expires=Thu, 17 Jul 2025 07:39:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀tripsapata_session=eyJpdiI6Ikg4QzRWVzZaUjg0cHc3NjhxUmpCdkE9PSIsInZhbHVlIjoic1R2WVg5ZGo0YXRhRm1rR2E1Zjc2cFRUOW5FYXpmN1JzN3lITlJ5OVlDQVpkMWcrOENjYVN1NmJORHpXY0xQU ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImszMHdTTWtpd1ZwOFM2RXdGcmlzZ0E9PSIsInZhbHVlIjoibFlHaDVzZytaVVNLMlU5NSt5RkZIU3RUMUpFNzUvT0J3YXpDWVlYL3pnckNMS2NGVWJSdjVRS0VvUnY5Z3kzVkY5M1VRQlNmYnJCdDBkbGJUYWswanUxdUhyNlFCWW16bDVNUXBpUlNHTE9DbHVlcksvOTBrTk1vaEVxbTZZR2YiLCJtYWMiOiJhNzk2Njk3Y2NkYzdhM2NmZGU3ODVkYjdmZTFhZWExMTY2NzliMDE3OTI3MzM0ZmE1N2U5ODgwYTI4MGM3YWVlIiwidGFnIjoiIn0%3D; expires=Thu, 17-Jul-2025 07:39:26 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImszMHdTTWtpd1ZwOFM2RXdGcmlzZ0E9PSIsInZhbHVlIjoibFlHaDVzZytaVVNLMlU5NSt5RkZIU3RUMUpFNzUvT0J3YXpDWVlYL3pnckNMS2NGVWJSdjVRS0VvUnY5Z3kzVkY5M1VRQ ▶"
    1 => "tripsapata_session=eyJpdiI6Ikg4QzRWVzZaUjg0cHc3NjhxUmpCdkE9PSIsInZhbHVlIjoic1R2WVg5ZGo0YXRhRm1rR2E1Zjc2cFRUOW5FYXpmN1JzN3lITlJ5OVlDQVpkMWcrOENjYVN1NmJORHpXY0xQUEdwSkxzSWhBT0JBVEVLSENsZ0p0TXpDTnFkRldJUDNvV2ZCWEx5Tk9JMHZ5UkVqTmxMWVQ2WktZL1ZLelVTYXUiLCJtYWMiOiJiOTJiYWZkMDdkODZmNTU1Y2RlOGI1OGQ1Y2U3MThiNjc1NDkzZjI1MDgwMmFlOTNmZjBkMDY2NWZkYzk3N2U3IiwidGFnIjoiIn0%3D; expires=Thu, 17-Jul-2025 07:39:26 GMT; path=/; httponly ◀tripsapata_session=eyJpdiI6Ikg4QzRWVzZaUjg0cHc3NjhxUmpCdkE9PSIsInZhbHVlIjoic1R2WVg5ZGo0YXRhRm1rR2E1Zjc2cFRUOW5FYXpmN1JzN3lITlJ5OVlDQVpkMWcrOENjYVN1NmJORHpXY0xQU ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "YLlxsTtYRPAAsAOd56zf2VTIFEejt3Jz3TzWJ3tW"
  "_previous" => array:1 [▶
    "url" => "http://new.tripsapata.com/tour/test-tour"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Home

Tour

Hotel

Event

Contact

Test Tour

Description

Reviews

0/5

Excellent

Very Good

Average

Poor

Terrible

No Review

THE RICH HOTEL AND APARTMENTS

Why Book With Us?

No-hassle best price guarantee

Customer care available 24/7

Hand-picked Tours & Activities

Free Travel Insureance

Need TripSapata Help?

Company

Other Services

Support

Mailing List

1 x Application (67.91%)	1.93s
1 x Booting (32.08%)	910.90ms