Doctors Cave Beach

Messages Timeline Exceptions Views33 Route Queries41 Models71 Auth Gate Session Request

8.1.27213ms5MBGET tour/{slug}

Booting (53.51ms)
Application (159ms)
1 x Application (74.82%)
159.30ms
1 x Booting (25.13%)
53.51ms

33 templates were rendered

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

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

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

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`__currentLoopData`
14	`item`
15	`key`
16	`loop`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`__currentLoopData`
14	`item`
15	`key`
16	`loop`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`__currentLoopData`
14	`item`
15	`key`
16	`loop`
17	`cat`
18	`location`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`__currentLoopData`
14	`item`
15	`key`
16	`loop`
17	`cat`
18	`location`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`__currentLoopData`
14	`item`
15	`key`
16	`loop`
17	`cat`
18	`location`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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
price
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)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Tour::frontend.layouts.details.tour-form-book-wizard (themes/BC/Tour/Views/frontend/layouts/details/tour-form-book-wizard.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Booking::frontend.global.enquiry-form-wizard (themes/Base/Booking/Views/frontend/global/enquiry-form-wizard.blade.php)18bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
popular_locations
14
__currentLoopData
15
l
16
loop
17
service_type
Tour::frontend.layouts.details.open-hours (themes/BC/Tour/Views/frontend/layouts/details/open-hours.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Tour::frontend.layouts.details.tour-related (themes/BC/Tour/Views/frontend/layouts/details/tour-related.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Tour::frontend.layouts.search.loop-grid (themes/BC/Tour/Views/frontend/layouts/search/loop-grid.blade.php)18bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
__currentLoopData
14
item
15
k
16
loop
17
include_param

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`popular_locations`
14	`__currentLoopData`
15	`l`
16	`loop`
17	`service_type`

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`__currentLoopData`
14	`item`
15	`k`
16	`loop`
17	`include_param`

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


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

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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
price
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score

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

Layout::parts.favicon (modules/Layout/parts/favicon.blade.php)13bladefile


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

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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)13bladefile


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

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

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


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

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

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


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

Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
Language::frontend.switcher (themes/BC/Language/Views/frontend/switcher.blade.php)13bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
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	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`

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


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

Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)15bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
logo_id
14
logo

Params
0	`__env`
1	`app`
2	`errors`
3	`row`
4	`price`
5	`translation`
6	`tour_related`
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	`price`
5	`translation`
6	`tour_related`
7	`booking_data`
8	`review_list`
9	`seo_meta`
10	`body_class`
11	`breadcrumbs`
12	`review_score`
13	`logo_id`
14	`logo`

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


__env
app
errors
row
price
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
logo_id
logo

Core::frontend.currency-switcher (themes/BC/Core/Views/frontend/currency-switcher.blade.php)15bladefile
Params
0
__env
1
app
2
errors
3
row
4
price
5
translation
6
tour_related
7
booking_data
8
review_list
9
seo_meta
10
body_class
11
breadcrumbs
12
review_score
13
logo_id
14
logo

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

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

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


__env
app
errors
row
price
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
logo_id
logo

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

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


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

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

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


__env
app
errors
row
price
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
list_widget_footers

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

Layout::parts.cookie-consent-init (modules/Layout/parts/cookie-consent-init.blade.php)14bladefile


__env
app
errors
row
price
translation
tour_related
booking_data
review_list
seo_meta
body_class
breadcrumbs
review_score
list_widget_footers

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

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:109-148

41 statements were executed, 20 of which were duplicated, 21 unique. Show only duplicated64.19ms

select * from `bravo_tours` where `slug` = 'dolphin-cove-ocho-rios' and `bravo_tours`.`deleted_at` is null limit 114.67ms/modules/Tour/Controllers/TourController.php:111jamaicataxi

Metadata
Bindings	0. dolphin-cove-ocho-rios
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:111 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /modules/Tour/Controllers/TourController.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 (1) and `bravo_locations`.`deleted_at` is null2.41ms/modules/Tour/Controllers/TourController.php:111jamaicataxi

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:111 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Tour/Controllers/TourController.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 (1)1.88ms/modules/Tour/Controllers/TourController.php:111jamaicataxi

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /modules/Tour/Controllers/TourController.php:111 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /modules/Tour/Controllers/TourController.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_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (12)2.19ms/modules/Tour/Controllers/TourController.php:111jamaicataxi

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:111 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Tour/Controllers/TourController.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` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (12)1.68ms/modules/Tour/Controllers/TourController.php:111jamaicataxi

Metadata
Bindings	0. tour 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Tour/Controllers/TourController.php:111 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /modules/Tour/Controllers/TourController.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_tour_pricing` where `tour_id` = 122.16ms/modules/Tour/Controllers/TourController.php:118jamaicataxi

Metadata
Bindings	0. 12
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /modules/Tour/Controllers/TourController.php:118 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /modules/Tour/Controllers/TourController.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_tours` where `location_id` = 1 and `status` = 'publish' and `id` not in (12) and `bravo_tours`.`deleted_at` is null limit 4

1.27ms/modules/Tour/Controllers/TourController.php:120jamaicataxi

Metadata
Bindings	0. 1 1. publish 2. 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	14. /modules/Tour/Controllers/TourController.php:120 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /modules/Tour/Controllers/TourController.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 (1) and `bravo_locations`.`deleted_at` is null380μs/modules/Tour/Controllers/TourController.php:120jamaicataxi

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

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	24. /modules/Tour/Controllers/TourController.php:120 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 26. /modules/Tour/Controllers/TourController.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_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (13)860μs/modules/Tour/Controllers/TourController.php:120jamaicataxi

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Tour/Controllers/TourController.php:120 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Tour/Controllers/TourController.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` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (13)360μs/modules/Tour/Controllers/TourController.php:120jamaicataxi

Metadata
Bindings	0. tour 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Tour/Controllers/TourController.php:120 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Tour/Controllers/TourController.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` = 12 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null

1.87ms/modules/Tour/Models/Tour.php:921jamaicataxi

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

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

2.07ms/modules/Tour/Models/Tour.php:683jamaicataxi

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	21. /modules/Tour/Models/Tour.php:683 22. /modules/Tour/Controllers/TourController.php:129 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Tour/Controllers/TourController.php:35 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `bravo_seo` where `object_id` = 12 and `object_model` = 'tour' limit 11.25ms/app/BaseModel.php:199jamaicataxi

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

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

1.58ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:165jamaicataxi

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

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

800μs/modules/Tour/Models/Tour.php:847jamaicataxi

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

790μs/modules/Tour/Models/Tour.php:859jamaicataxi

Metadata
Bindings	0. 12 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:859 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 * from `bravo_tour_category` where `bravo_tour_category`.`id` = 6 and `bravo_tour_category`.`id` is not null and `bravo_tour_category`.`deleted_at` is null limit 1

2.42msview::Tour::frontend.layouts.details.tour-detail:226jamaicataxi

Metadata
Bindings	0. 6
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:226 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 (6)

1.56msview::Tour::frontend.layouts.details.tour-detail:226jamaicataxi

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	26. view::Tour::frontend.layouts.details.tour-detail:226 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` = 12 and `bravo_tour_term`.`tour_id` is not null2.2msview::Tour::frontend.layouts.details.tour-attributes:2jamaicataxi

Metadata
Bindings	0. 12
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 `bravo_terms` where `bravo_terms`.`id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13) and `bravo_terms`.`deleted_at` is null

2.94ms/modules/Core/Models/Terms.php:42jamaicataxi

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	16. /modules/Core/Models/Terms.php:42 17. view::Tour::frontend.layouts.details.tour-attributes:3 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 20. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70

select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13)

1.87ms/modules/Core/Models/Terms.php:42jamaicataxi

Metadata
Bindings	0. en
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /modules/Core/Models/Terms.php:42 22. view::Tour::frontend.layouts.details.tour-attributes:3 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 `bravo_attrs` where `bravo_attrs`.`id` in (1, 2) and `bravo_attrs`.`deleted_at` is null2.15ms/modules/Core/Models/Terms.php:42jamaicataxi

Metadata
Bindings	0. 1 1. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /modules/Core/Models/Terms.php:42 22. view::Tour::frontend.layouts.details.tour-attributes:3 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 `bravo_popular_locations`3.39msview::Tour::frontend.layouts.details.tour-form-book-wizard:2jamaicataxi

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. view::Tour::frontend.layouts.details.tour-form-book-wizard:2 16. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110 17. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:70 19. /vendor/laravel/framework/src/Illuminate/View/View.php:195

select * from `country_codes` where `popular_order` is not null order by `popular_order` desc3.53ms/app/Helpers/AppHelper.php:1315jamaicataxi

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Helpers/AppHelper.php:1315 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 `bravo_tours` where `bravo_tours`.`id` = 18 and `bravo_tours`.`deleted_at` is null limit 11.06ms/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 18
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:50 22. /modules/Core/Walkers/MenuWalker.php:19 23. /app/Helpers/AppHelper.php:121

select * from `bravo_tours` where `bravo_tours`.`id` = 16 and `bravo_tours`.`deleted_at` is null limit 1470μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 16
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:50 22. /modules/Core/Walkers/MenuWalker.php:19 23. /app/Helpers/AppHelper.php:121

select * from `bravo_tours` where `bravo_tours`.`id` = 15 and `bravo_tours`.`deleted_at` is null limit 1410μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 15
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:50 22. /modules/Core/Walkers/MenuWalker.php:19 23. /app/Helpers/AppHelper.php:121

select * from `core_pages` where `core_pages`.`id` = 10 and `core_pages`.`deleted_at` is null limit 1720μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 10
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 12 and `core_pages`.`deleted_at` is null limit 1350μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 11 and `core_pages`.`deleted_at` is null limit 1330μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 11
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 9 and `core_pages`.`deleted_at` is null limit 1380μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 9
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 1 and `core_pages`.`deleted_at` is null limit 1370μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

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	19. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `bravo_tours` where `bravo_tours`.`id` = 18 and `bravo_tours`.`deleted_at` is null limit 1650μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 18
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:50 22. /modules/Core/Walkers/MenuWalker.php:19 23. /app/Helpers/AppHelper.php:121

select * from `bravo_tours` where `bravo_tours`.`id` = 16 and `bravo_tours`.`deleted_at` is null limit 1460μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 16
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:50 22. /modules/Core/Walkers/MenuWalker.php:19 23. /app/Helpers/AppHelper.php:121

select * from `bravo_tours` where `bravo_tours`.`id` = 15 and `bravo_tours`.`deleted_at` is null limit 1360μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 15
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:50 22. /modules/Core/Walkers/MenuWalker.php:19 23. /app/Helpers/AppHelper.php:121

select * from `core_pages` where `core_pages`.`id` = 10 and `core_pages`.`deleted_at` is null limit 1320μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 10
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 12 and `core_pages`.`deleted_at` is null limit 1450μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 11 and `core_pages`.`deleted_at` is null limit 1310μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 11
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 9 and `core_pages`.`deleted_at` is null limit 1360μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

Metadata
Bindings	0. 9
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. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

select * from `core_pages` where `core_pages`.`id` = 1 and `core_pages`.`deleted_at` is null limit 1620μs/modules/Core/Walkers/MenuWalker.php:36jamaicataxi

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	19. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:50 21. /modules/Core/Walkers/MenuWalker.php:19 22. /app/Helpers/AppHelper.php:121 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:110

Modules\Page\Models\Page: 10
Modules\Core\Models\CountryCode: 5
Modules\Location\Models\PopularLocation: 9
Modules\Core\Models\Attributes: 2
Modules\Core\Models\Terms: 12
Modules\Tour\Models\TourTerm: 12
Modules\Tour\Models\TourCategoryTranslation: 1
Modules\Tour\Models\TourCategory: 1
Modules\Review\Models\Review: 2
Modules\Core\Models\SEO: 1
Modules\Tour\Models\TourMeta: 1
Modules\Tour\Models\TourTranslation: 2
Modules\Location\Models\LocationTranslation: 2
Modules\Location\Models\Location: 3
Modules\Tour\Models\Tour: 8

web: null
sanctum: null

_token: IjzgQCIMCQZ3doHzLOAOiViQJMXELWzx2FUfITHa
detail_back_url: tour/dolphin-cove-ocho-rios
_previous: array:1 [ "url" => "https://jamaicataxi.co.uk/tour/dolphin-cove-ocho-rios" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/tour/dolphin-cove-ocho-rios

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:21 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.224.16.219"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.224.16.219"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "jamaicataxi.co.uk"
  ]
  "host" => array:1 [▶
    0 => "jamaicataxi.co.uk"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:58 [▼
  "USER" => "jamaicataxi"
  "HOME" => "/home/jamaicataxi"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "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_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "close"
  "HTTP_X_FORWARDED_FOR" => "18.224.16.219"
  "HTTP_X_REAL_IP" => "18.224.16.219"
  "HTTP_X_FORWARDED_HOST" => "jamaicataxi.co.uk"
  "HTTP_HOST" => "jamaicataxi.co.uk"
  "PHP_VALUE" => """
    \n
    error_log=/home/jamaicataxi/logs/php/error.log;\n
    memory_limit=512M;\n
    max_execution_time=60;\n
    max_input_time=60;\n
    max_input_vars=10000;\n
    post_max_size=64M;\n
    upload_max_filesize=64M;\n
    date.timezone=UTC;\n
    display_errors=off;
    """
  "HTTPS" => "on"
  "MGT" => "1"
  "GEOIP_LONGITUDE" => "-71.1028"
  "GEOIP_LATITUDE" => "42.3646"
  "GEOIP_CITY_CONTINENT_CODE" => "NA"
  "GEOIP_POSTAL_CODE" => "02139"
  "GEOIP_CITY" => "Cambridge"
  "GEOIP_REGION" => "MA"
  "GEOIP_CITY_COUNTRY_NAME" => "United States"
  "GEOIP_CITY_COUNTRY_CODE3" => "USA"
  "GEOIP_CITY_COUNTRY_CODE" => "US"
  "GEOIP_COUNTRY_NAME" => "United States"
  "GEOIP_COUNTRY_CODE3" => "USA"
  "GEOIP_COUNTRY_CODE" => "US"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "jamaicataxi.co.uk"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "127.0.0.1"
  "REMOTE_PORT" => ""
  "REMOTE_ADDR" => "18.224.16.219"
  "SERVER_SOFTWARE" => "nginx/1.21.4"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "DOCUMENT_ROOT" => "/home/jamaicataxi/htdocs/jamaicataxi.co.uk/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/tour/dolphin-cove-ocho-rios"
  "SCRIPT_NAME" => "/index.php"
  "SCRIPT_FILENAME" => "/home/jamaicataxi/htdocs/jamaicataxi.co.uk/public/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743932903.7842
  "REQUEST_TIME" => 1743932903
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Sun, 06 Apr 2025 09:48:23 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImorWktud3dPNVFTcUpjYitOT1pqbUE9PSIsInZhbHVlIjoiaEFHQ3VyRSthRWJoOG5zWWJCeTQ1WXVMREVIRWM1RkFnbGxtL3pqZk1BbjhxNm9jeDBYY1FZMmdpbVFETVNaOWhQcFducTN5UFBEbUs3UXZVOGtsUURuTEZ2cUE4UXFQUDUrRVVCU3E4VjNtcXRIYWZIMFF6clMzOHBRZ0RHemYiLCJtYWMiOiI2YmRjMGUxYjYzZDAyMzE5MDExODVkOTUyMzc4YjliY2UzOTgxYzU2NmI3MTBjN2FmMTZkNjM4ZGYzYjFmZTA1IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 11:48:23 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImorWktud3dPNVFTcUpjYitOT1pqbUE9PSIsInZhbHVlIjoiaEFHQ3VyRSthRWJoOG5zWWJCeTQ1WXVMREVIRWM1RkFnbGxtL3pqZk1BbjhxNm9jeDBYY1FZMmdpbVFETVNaOWhQcFduc ▶"
    1 => "booking_core_session=eyJpdiI6IjlLL1hsQ2QxQ0x2QTlHMzEvWDlWd2c9PSIsInZhbHVlIjoiejEwM3VOSjlkdFZFR1YrQjhKVklzTENzN3ZCUTgzelV6bTljWnhteU9mZHhUdWJhZ3BZWU8wYmt4ckRKOGdrNlcweHlBeG5Wc3lJNyttQkZ6Wm5KeFJHbTI3elY5US8yYzJycFBHTVFzeFZPZFZrSTYyRkJqYjAyN1NyMjlBa2QiLCJtYWMiOiI0ODFiNTI3MTliOGUzMjA5NjFkNzExNjI0YjJkZWEyNGFmNWU4YTg0NmRkMmU3YzA0ZjUwNzk0ZmJkZDY2YmNmIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 11:48:23 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀booking_core_session=eyJpdiI6IjlLL1hsQ2QxQ0x2QTlHMzEvWDlWd2c9PSIsInZhbHVlIjoiejEwM3VOSjlkdFZFR1YrQjhKVklzTENzN3ZCUTgzelV6bTljWnhteU9mZHhUdWJhZ3BZWU8wYmt4ckRKOGd ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImorWktud3dPNVFTcUpjYitOT1pqbUE9PSIsInZhbHVlIjoiaEFHQ3VyRSthRWJoOG5zWWJCeTQ1WXVMREVIRWM1RkFnbGxtL3pqZk1BbjhxNm9jeDBYY1FZMmdpbVFETVNaOWhQcFducTN5UFBEbUs3UXZVOGtsUURuTEZ2cUE4UXFQUDUrRVVCU3E4VjNtcXRIYWZIMFF6clMzOHBRZ0RHemYiLCJtYWMiOiI2YmRjMGUxYjYzZDAyMzE5MDExODVkOTUyMzc4YjliY2UzOTgxYzU2NmI3MTBjN2FmMTZkNjM4ZGYzYjFmZTA1IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 11:48:23 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImorWktud3dPNVFTcUpjYitOT1pqbUE9PSIsInZhbHVlIjoiaEFHQ3VyRSthRWJoOG5zWWJCeTQ1WXVMREVIRWM1RkFnbGxtL3pqZk1BbjhxNm9jeDBYY1FZMmdpbVFETVNaOWhQcFduc ▶"
    1 => "booking_core_session=eyJpdiI6IjlLL1hsQ2QxQ0x2QTlHMzEvWDlWd2c9PSIsInZhbHVlIjoiejEwM3VOSjlkdFZFR1YrQjhKVklzTENzN3ZCUTgzelV6bTljWnhteU9mZHhUdWJhZ3BZWU8wYmt4ckRKOGdrNlcweHlBeG5Wc3lJNyttQkZ6Wm5KeFJHbTI3elY5US8yYzJycFBHTVFzeFZPZFZrSTYyRkJqYjAyN1NyMjlBa2QiLCJtYWMiOiI0ODFiNTI3MTliOGUzMjA5NjFkNzExNjI0YjJkZWEyNGFmNWU4YTg0NmRkMmU3YzA0ZjUwNzk0ZmJkZDY2YmNmIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 11:48:23 GMT; path=/; httponly ◀booking_core_session=eyJpdiI6IjlLL1hsQ2QxQ0x2QTlHMzEvWDlWd2c9PSIsInZhbHVlIjoiejEwM3VOSjlkdFZFR1YrQjhKVklzTENzN3ZCUTgzelV6bTljWnhteU9mZHhUdWJhZ3BZWU8wYmt4ckRKOGd ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "IjzgQCIMCQZ3doHzLOAOiViQJMXELWzx2FUfITHa"
  "detail_back_url" => "tour/dolphin-cove-ocho-rios"
  "_previous" => array:1 [▶
    "url" => "https://jamaicataxi.co.uk/tour/dolphin-cove-ocho-rios"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Doctors Cave Beach

Overview

HIGHLIGHTS

Included/Excluded

Itinerary

Duration

Tour Type

Location

Travel Styles

Facilities

FAQs

When and where does the tour end?

When and where does the tour start?

Do you arrange airport transfers?

What is the age range

Tour Location

Extras:

1 x Application (74.82%)	159.30ms
1 x Booting (25.13%)	53.51ms

Doctors Cave Beach

Overview

HIGHLIGHTS

Included/Excluded

Itinerary

Duration

Tour Type

Location

Travel Styles

Facilities

FAQs

When and where does the tour end?

When and where does the tour start?

Do you arrange airport transfers?

What is the age range

Tour Location

Passengers & Luggage

Extras:

You might also like