Search for Spaces

Messages Timeline Exceptions Views28 Route Queries52 Models65 Mails Auth Gate Session Request

8.1.32365ms5MBGET en/desa

Booting (80.15ms)
Application (285ms)
1 x Application (78.01%)
284.82ms
1 x Booting (21.95%)
80.15ms

28 templates were rendered

Desa::frontend.layouts.search.loop-grid (themes/Mytravel/Desa/Views/frontend/layouts/search/loop-grid.blade.php)3blade
Params
0
row
1
disable_lazyload
2
wrap_class
Desa::frontend.search (themes/Mytravel/Desa/Views/frontend/search.blade.php)7blade
Params
0
rows
1
list_location
2
desa_min_max_price
3
markers
4
blank
5
seo_meta
6
attributes
Desa::frontend.layouts.search.list-item (themes/Mytravel/Desa/Views/frontend/layouts/search/list-item.blade.php)10blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
Desa::frontend.layouts.search.filter-search (themes/Mytravel/Desa/Views/frontend/layouts/search/filter-search.blade.php)10blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
Desa::frontend.layouts.search.form-search-vertical (themes/Mytravel/Desa/Views/frontend/layouts/search/form-search-vertical.blade.php)10blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
Desa::frontend.layouts.search.orderby (themes/Mytravel/Desa/Views/frontend/layouts/search/orderby.blade.php)10blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
Desa::frontend.layouts.search.loop-list (themes/Mytravel/Desa/Views/frontend/layouts/search/loop-list.blade.php)13blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
__currentLoopData
11
row
12
loop
pagination::tailwind (resources/views/vendor/pagination/tailwind.blade.php)2blade
Params
0
paginator
1
elements
vendor.pagination.default (resources/views/vendor/pagination/default.blade.php)5blade
Params
0
__env
1
app
2
errors
3
paginator
4
elements

Params
0	`row`
1	`disable_lazyload`
2	`wrap_class`

Params
0	`rows`
1	`list_location`
2	`desa_min_max_price`
3	`markers`
4	`blank`
5	`seo_meta`
6	`attributes`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`__currentLoopData`
11	`row`
12	`loop`

Params
0	`paginator`
1	`elements`

Params
0	`__env`
1	`app`
2	`errors`
3	`paginator`
4	`elements`

layouts.app (resources/views/layouts/app.blade.php)10blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`

Layout::app (themes/Mytravel/Layout/app.blade.php)10blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes

Layout::parts.seo-meta (themes/Mytravel/Layout/parts/seo-meta.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
Layout::parts.header (themes/Mytravel/Layout/parts/header.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
Layout::parts.topbar (themes/Mytravel/Layout/parts/topbar.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
Core::frontend.currency-switcher (themes/Mytravel/Core/Views/frontend/currency-switcher.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
Language::frontend.switcher (themes/Mytravel/Language/Views/frontend/switcher.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
Layout::parts.notification (themes/Mytravel/Layout/parts/notification.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
Core::frontend.currency-switcher-dropdown (themes/Mytravel/Core/Views/frontend/currency-switcher-dropdown.blade.php)14blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
12
logo_id
13
logo
Language::frontend.switcher-dropdown (themes/Mytravel/Language/Views/frontend/switcher-dropdown.blade.php)14blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file
12
logo_id
13
logo
Layout::parts.footer (themes/Mytravel/Layout/parts/footer.blade.php)12blade
Params
0
__env
1
app
2
errors
3
rows
4
list_location
5
desa_min_max_price
6
markers
7
blank
8
seo_meta
9
attributes
10
favicon
11
file

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`logo_id`
13	`logo`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`logo_id`
13	`logo`

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

Language::frontend.switcher (themes/Mytravel/Language/Views/frontend/switcher.blade.php)18blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

Core::frontend.currency-switcher (themes/Mytravel/Core/Views/frontend/currency-switcher.blade.php)18blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

Layout::parts.login-register-modal (themes/Mytravel/Layout/parts/login-register-modal.blade.php)18blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

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


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

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


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

Layout::parts.chat (themes/Mytravel/Layout/parts/chat.blade.php)18blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

Popup::frontend.popup (themes/Mytravel/Popup/Views/frontend/popup.blade.php)18blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file
info_contact
list_widget_footers
__currentLoopData
item
key
loop

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`
12	`info_contact`
13	`list_widget_footers`
14	`__currentLoopData`
15	`item`
16	`key`
17	`loop`

demo_script (resources/views/demo_script.blade.php)12blade


__env
app
errors
rows
list_location
desa_min_max_price
markers
blank
seo_meta
attributes
favicon
file

Params
0	`__env`
1	`app`
2	`errors`
3	`rows`
4	`list_location`
5	`desa_min_max_price`
6	`markers`
7	`blank`
8	`seo_meta`
9	`attributes`
10	`favicon`
11	`file`

uri: GET en/desa
middleware: web
controller: Modules\Desa\Controllers\DesaController@index
namespace: Modules\Desa\Controllers
prefix: en/desa
where
as: desa.search
file: modules/Desa/Controllers/DesaController.php:37-86

52 statements were executed, 34 of which were duplicated, 18 unique141ms

select count(*) as aggregate from (select `bravo_desas`.*, CASE WHEN IFNULL( bravo_desas.sale_price, 0 ) > 0 THEN bravo_desas.sale_price ELSE bravo_desas.price END AS tmp_min_price from `bravo_desas` where `bravo_desas`.`status` = 'publish' and `bravo_desas`.`deleted_at` is null group by `bravo_desas`.`id`) as `aggregate_table`

4.23ms/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Bindings	0. publish
Backtrace	15. /modules/Desa/Models/Desa.php:1224 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /modules/Desa/Controllers/DesaController.php:34 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `bravo_desas`.*, CASE WHEN IFNULL( bravo_desas.sale_price, 0 ) > 0 THEN bravo_desas.sale_price ELSE bravo_desas.price END AS tmp_min_price from `bravo_desas` where `bravo_desas`.`status` = 'publish' and `bravo_desas`.`deleted_at` is null group by `bravo_desas`.`id` order by `tmp_min_price` asc limit 9 offset 0

910μs/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Bindings	0. publish
Backtrace	15. /modules/Desa/Models/Desa.php:1224 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /modules/Desa/Controllers/DesaController.php:34 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_locations` where `bravo_locations`.`id` in (3) and `bravo_locations`.`deleted_at` is null900μs/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Bindings	0. 3
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Desa/Models/Desa.php:1224 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (3)510μs/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /modules/Desa/Models/Desa.php:1224 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /modules/Desa/Controllers/DesaController.php:34 30. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `user_wishlist` where `object_model` = 'desa' and `user_id` = 0 and `user_wishlist`.`object_id` in (2)510μs/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Bindings	0. desa 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Desa/Models/Desa.php:1224 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desa_translations` where `bravo_desa_translations`.`origin_id` in (2) and `bravo_desa_translations`.`deleted_at` is null

540μs/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Desa/Models/Desa.php:1224 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `bravo_terms`.*, `bravo_desa_term`.`target_id` as `laravel_through_key` from `bravo_terms` inner join `bravo_desa_term` on `bravo_desa_term`.`term_id` = `bravo_terms`.`id` where `bravo_terms`.`attr_id` = 0 and `bravo_desa_term`.`target_id` in (2) and `bravo_terms`.`deleted_at` is null

1.02ms/modules/Desa/Models/Desa.php:1224liburant_ota_dev

Metadata
Bindings	0. 0
Backtrace	19. /modules/Desa/Models/Desa.php:1224 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /modules/Desa/Controllers/DesaController.php:34 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desas` where `bravo_desas`.`id` = 2 and `bravo_desas`.`deleted_at` is null limit 1700μs/modules/Desa/Models/Desa.php:1227liburant_ota_dev

Metadata
Bindings	0. 2
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/Desa/Models/Desa.php:1227 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /modules/Desa/Controllers/DesaController.php:34 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desa_rooms` where `bravo_desa_rooms`.`parent_id` = 2 and `bravo_desa_rooms`.`parent_id` is not null and `status` = 'publish' and `bravo_desa_rooms`.`deleted_at` is null

610μs/modules/Desa/Models/Desa.php:1230liburant_ota_dev

Metadata
Bindings	0. 2 1. publish
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Desa/Models/Desa.php:1230 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /modules/Desa/Controllers/DesaController.php:34 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desa_room_translations` where `bravo_desa_room_translations`.`origin_id` in (1, 2) and `bravo_desa_room_translations`.`deleted_at` is null

540μs/modules/Desa/Models/Desa.php:1230liburant_ota_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	24. /modules/Desa/Models/Desa.php:1230 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /modules/Desa/Controllers/DesaController.php:34 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desa_room_dates` where `target_id` = 1 and `start_date` >= '2025-06-07 00:00:00' and `end_date` <= '2025-06-07 00:00:00' limit 100

680μs/modules/Desa/Models/DesaRoom.php:164liburant_ota_dev

Metadata
Bindings	0. 1 1. 2025-06-07 00:00:00 2. 2025-06-07 00:00:00
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/Desa/Models/DesaRoom.php:164 15. /modules/Desa/Models/DesaRoom.php:70 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1231 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `bravo_desa_room_bookings`.* from `bravo_desa_room_bookings` inner join `bravo_bookings` on `bravo_bookings`.`id` = `bravo_desa_room_bookings`.`booking_id` where `bravo_desa_room_bookings`.`room_id` = 1 and `bravo_bookings`.`status` not in ('draft', 'cancelled', 'unpaid') and `bravo_bookings`.`deleted_at` is null and `bravo_desa_room_bookings`.`start_date` <= '2025-06-07' and `bravo_desa_room_bookings`.`end_date` > '2025-06-07'

910μs/modules/Desa/Models/DesaRoom.php:173liburant_ota_dev

Metadata
Bindings	0. 1 1. draft 2. cancelled 3. unpaid 4. 2025-06-07 5. 2025-06-07
Backtrace	14. /modules/Desa/Models/DesaRoom.php:173 15. /modules/Desa/Models/DesaRoom.php:99 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1231 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

720μs/app/BaseModel.php:274liburant_ota_dev

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/BaseModel.php:274 21. /app/BaseModel.php:292 22. /modules/Desa/Models/Desa.php:986 23. /modules/Desa/Models/Desa.php:1231 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `bravo_desa_room_term` where `bravo_desa_room_term`.`target_id` = 1 and `bravo_desa_room_term`.`target_id` is not null

510μs/modules/Desa/Models/Desa.php:987liburant_ota_dev

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Desa/Models/Desa.php:987 20. /modules/Desa/Models/Desa.php:1231 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `bravo_coupons` where exists (select * from `bravo_coupon_rooms` where `bravo_coupons`.`id` = `bravo_coupon_rooms`.`coupon_id` and `room_id` = 1) and `promotion_type` = 'strike_price' limit 1

1.2ms/modules/Coupon/Models/Coupon.php:160liburant_ota_dev

Metadata
Bindings	0. 1 1. strike_price
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/Coupon/Models/Coupon.php:160 16. /modules/Desa/Models/Desa.php:991 17. /modules/Desa/Models/Desa.php:1231 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Desa/Controllers/DesaController.php:34

select * from `bravo_desa_room_dates` where `target_id` = 2 and `start_date` >= '2025-06-07 00:00:00' and `end_date` <= '2025-06-07 00:00:00' limit 100

720μs/modules/Desa/Models/DesaRoom.php:164liburant_ota_dev

Metadata
Bindings	0. 2 1. 2025-06-07 00:00:00 2. 2025-06-07 00:00:00
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/Desa/Models/DesaRoom.php:164 15. /modules/Desa/Models/DesaRoom.php:70 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1231 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `bravo_desa_room_bookings`.* from `bravo_desa_room_bookings` inner join `bravo_bookings` on `bravo_bookings`.`id` = `bravo_desa_room_bookings`.`booking_id` where `bravo_desa_room_bookings`.`room_id` = 2 and `bravo_bookings`.`status` not in ('draft', 'cancelled', 'unpaid') and `bravo_bookings`.`deleted_at` is null and `bravo_desa_room_bookings`.`start_date` <= '2025-06-07' and `bravo_desa_room_bookings`.`end_date` > '2025-06-07'

600μs/modules/Desa/Models/DesaRoom.php:173liburant_ota_dev

Metadata
Bindings	0. 2 1. draft 2. cancelled 3. unpaid 4. 2025-06-07 5. 2025-06-07
Backtrace	14. /modules/Desa/Models/DesaRoom.php:173 15. /modules/Desa/Models/DesaRoom.php:99 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1231 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `bravo_desa_room_translations` where `bravo_desa_room_translations`.`origin_id` = 2 and `bravo_desa_room_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_desa_room_translations`.`deleted_at` is null limit 1

790μs/app/BaseModel.php:274liburant_ota_dev

Metadata
Bindings	0. 2 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/BaseModel.php:274 21. /app/BaseModel.php:292 22. /modules/Desa/Models/Desa.php:986 23. /modules/Desa/Models/Desa.php:1231 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `bravo_desa_room_term` where `bravo_desa_room_term`.`target_id` = 2 and `bravo_desa_room_term`.`target_id` is not null

440μs/modules/Desa/Models/Desa.php:987liburant_ota_dev

Metadata
Bindings	0. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Desa/Models/Desa.php:987 20. /modules/Desa/Models/Desa.php:1231 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `bravo_coupons` where exists (select * from `bravo_coupon_rooms` where `bravo_coupons`.`id` = `bravo_coupon_rooms`.`coupon_id` and `room_id` = 2) and `promotion_type` = 'strike_price' limit 1

880μs/modules/Coupon/Models/Coupon.php:160liburant_ota_dev

Metadata
Bindings	0. 2 1. strike_price
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/Coupon/Models/Coupon.php:160 16. /modules/Desa/Models/Desa.php:991 17. /modules/Desa/Models/Desa.php:1231 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Desa/Controllers/DesaController.php:34

select * from `bravo_desa_room_dates` where `target_id` = 1 and `start_date` >= '2025-06-07 00:00:00' and `end_date` <= '2025-06-07 00:00:00' limit 100

530μs/modules/Desa/Models/DesaRoom.php:164liburant_ota_dev

Metadata
Bindings	0. 1 1. 2025-06-07 00:00:00 2. 2025-06-07 00:00:00
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/Desa/Models/DesaRoom.php:164 15. /modules/Desa/Models/DesaRoom.php:70 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1232 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `bravo_desa_room_bookings`.* from `bravo_desa_room_bookings` inner join `bravo_bookings` on `bravo_bookings`.`id` = `bravo_desa_room_bookings`.`booking_id` where `bravo_desa_room_bookings`.`room_id` = 1 and `bravo_bookings`.`status` not in ('draft', 'cancelled', 'unpaid') and `bravo_bookings`.`deleted_at` is null and `bravo_desa_room_bookings`.`start_date` <= '2025-06-07' and `bravo_desa_room_bookings`.`end_date` > '2025-06-07'

520μs/modules/Desa/Models/DesaRoom.php:173liburant_ota_dev

Metadata
Bindings	0. 1 1. draft 2. cancelled 3. unpaid 4. 2025-06-07 5. 2025-06-07
Backtrace	14. /modules/Desa/Models/DesaRoom.php:173 15. /modules/Desa/Models/DesaRoom.php:99 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1232 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `bravo_coupons` where exists (select * from `bravo_coupon_rooms` where `bravo_coupons`.`id` = `bravo_coupon_rooms`.`coupon_id` and `room_id` = 1) and `promotion_type` = 'strike_price' limit 1

710μs/modules/Coupon/Models/Coupon.php:160liburant_ota_dev

Metadata
Bindings	0. 1 1. strike_price
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/Coupon/Models/Coupon.php:160 16. /modules/Desa/Models/Desa.php:991 17. /modules/Desa/Models/Desa.php:1232 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Desa/Controllers/DesaController.php:34

select * from `bravo_desa_room_dates` where `target_id` = 2 and `start_date` >= '2025-06-07 00:00:00' and `end_date` <= '2025-06-07 00:00:00' limit 100

500μs/modules/Desa/Models/DesaRoom.php:164liburant_ota_dev

Metadata
Bindings	0. 2 1. 2025-06-07 00:00:00 2. 2025-06-07 00:00:00
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/Desa/Models/DesaRoom.php:164 15. /modules/Desa/Models/DesaRoom.php:70 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1232 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `bravo_desa_room_bookings`.* from `bravo_desa_room_bookings` inner join `bravo_bookings` on `bravo_bookings`.`id` = `bravo_desa_room_bookings`.`booking_id` where `bravo_desa_room_bookings`.`room_id` = 2 and `bravo_bookings`.`status` not in ('draft', 'cancelled', 'unpaid') and `bravo_bookings`.`deleted_at` is null and `bravo_desa_room_bookings`.`start_date` <= '2025-06-07' and `bravo_desa_room_bookings`.`end_date` > '2025-06-07'

480μs/modules/Desa/Models/DesaRoom.php:173liburant_ota_dev

Metadata
Bindings	0. 2 1. draft 2. cancelled 3. unpaid 4. 2025-06-07 5. 2025-06-07
Backtrace	14. /modules/Desa/Models/DesaRoom.php:173 15. /modules/Desa/Models/DesaRoom.php:99 16. /modules/Desa/Models/Desa.php:985 17. /modules/Desa/Models/Desa.php:1232 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `bravo_coupons` where exists (select * from `bravo_coupon_rooms` where `bravo_coupons`.`id` = `bravo_coupon_rooms`.`coupon_id` and `room_id` = 2) and `promotion_type` = 'strike_price' limit 1

750μs/modules/Coupon/Models/Coupon.php:160liburant_ota_dev

Metadata
Bindings	0. 2 1. strike_price
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/Coupon/Models/Coupon.php:160 16. /modules/Desa/Models/Desa.php:991 17. /modules/Desa/Models/Desa.php:1232 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Desa/Controllers/DesaController.php:34

select count(*) as aggregate from `bravo_desas` where `id` <> 2 and `slug` = 'paket-live-in-desa-wisata-pentingsari-1' and `bravo_desas`.`deleted_at` is null

770μs/app/BaseModel.php:90liburant_ota_dev

Metadata
Bindings	0. 2 1. paket-live-in-desa-wisata-pentingsari-1
Backtrace	15. /app/BaseModel.php:90 16. /app/BaseModel.php:55 17. /modules/Desa/Models/Desa.php:1235 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Desa/Controllers/DesaController.php:34

update `bravo_desas` set `price` = 365000, `sale_price` = 0, `bravo_desas`.`updated_at` = '2025-06-07 22:36:11' where `id` = 2

98.26ms/app/BaseModel.php:58liburant_ota_dev

Metadata
Bindings	0. 365000 1. 0 2. 2025-06-07 22:36:11 3. 2
Backtrace	13. /app/BaseModel.php:58 14. /modules/Desa/Models/Desa.php:1235 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /modules/Desa/Controllers/DesaController.php:34 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select count(*) as aggregate from (select `bravo_desas`.*, CASE WHEN IFNULL( bravo_desas.sale_price, 0 ) > 0 THEN bravo_desas.sale_price ELSE bravo_desas.price END AS tmp_min_price from `bravo_desas` where `bravo_desas`.`status` = 'publish' and `bravo_desas`.`deleted_at` is null group by `bravo_desas`.`id`) as `aggregate_table`

1.19ms/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Bindings	0. publish
Backtrace	15. /modules/Desa/Models/Desa.php:1243 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /modules/Desa/Controllers/DesaController.php:34 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `bravo_desas`.*, CASE WHEN IFNULL( bravo_desas.sale_price, 0 ) > 0 THEN bravo_desas.sale_price ELSE bravo_desas.price END AS tmp_min_price from `bravo_desas` where `bravo_desas`.`status` = 'publish' and `bravo_desas`.`deleted_at` is null group by `bravo_desas`.`id` order by `tmp_min_price` asc limit 9 offset 0

840μs/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Bindings	0. publish
Backtrace	15. /modules/Desa/Models/Desa.php:1243 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /modules/Desa/Controllers/DesaController.php:34 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_locations` where `bravo_locations`.`id` in (3) and `bravo_locations`.`deleted_at` is null880μs/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Bindings	0. 3
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Desa/Models/Desa.php:1243 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (3)770μs/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /modules/Desa/Models/Desa.php:1243 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 29. /modules/Desa/Controllers/DesaController.php:34 30. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 31. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `user_wishlist` where `object_model` = 'desa' and `user_id` = 0 and `user_wishlist`.`object_id` in (2)600μs/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Bindings	0. desa 1. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Desa/Models/Desa.php:1243 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desa_translations` where `bravo_desa_translations`.`origin_id` in (2) and `bravo_desa_translations`.`deleted_at` is null

530μs/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /modules/Desa/Models/Desa.php:1243 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 24. /modules/Desa/Controllers/DesaController.php:34 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select `bravo_terms`.*, `bravo_desa_term`.`target_id` as `laravel_through_key` from `bravo_terms` inner join `bravo_desa_term` on `bravo_desa_term`.`term_id` = `bravo_terms`.`id` where `bravo_terms`.`attr_id` = 0 and `bravo_desa_term`.`target_id` in (2) and `bravo_terms`.`deleted_at` is null

510μs/modules/Desa/Models/Desa.php:1243liburant_ota_dev

Metadata
Bindings	0. 0
Backtrace	19. /modules/Desa/Models/Desa.php:1243 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /modules/Desa/Controllers/DesaController.php:34 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_desa_translations` where `bravo_desa_translations`.`origin_id` = 2 and `bravo_desa_translations`.`origin_id` is not null and `locale` = 'en' and `bravo_desa_translations`.`deleted_at` is null limit 1

690μs/app/BaseModel.php:274liburant_ota_dev

Metadata
Bindings	0. 2 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/BaseModel.php:274 21. /app/BaseModel.php:292 22. view::Desa::frontend.layouts.search.loop-grid:16 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `media_files` where `media_files`.`id` is null and `media_files`.`deleted_at` is null limit 1500μs/app/BaseModel.php:138liburant_ota_dev

Metadata
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	18. /app/BaseModel.php:138 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 22. /app/BaseModel.php:139 23. /modules/Media/Helpers/FileHelper.php:44

select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 10001.43ms/modules/Desa/Controllers/DesaController.php:62liburant_ota_dev

Metadata
Bindings	0. publish
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/Desa/Controllers/DesaController.php:62 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /modules/Desa/Controllers/DesaController.php:34 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (1, 2, 3, 4, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60)

1.47ms/modules/Desa/Controllers/DesaController.php:62liburant_ota_dev

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /modules/Desa/Controllers/DesaController.php:62 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /modules/Desa/Controllers/DesaController.php:34 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select MIN( price ) AS min_price ,
MAX( price ) AS max_price  from `bravo_desas` where `status` = 'publish' and `bravo_desas`.`deleted_at` is null limit 1

940μs/modules/Desa/Models/Desa.php:650liburant_ota_dev

Metadata
Bindings	0. publish
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /modules/Desa/Models/Desa.php:650 16. /modules/Desa/Controllers/DesaController.php:63 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /modules/Desa/Controllers/DesaController.php:34 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `bravo_attrs` where `service` = 'desa' and `bravo_attrs`.`deleted_at` is null order by `position` desc970μs/modules/Desa/Controllers/DesaController.php:78liburant_ota_dev

Metadata
Bindings	0. desa
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /modules/Desa/Controllers/DesaController.php:78 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /modules/Desa/Controllers/DesaController.php:34 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `media_files` where `media_files`.`id` is null and `media_files`.`deleted_at` is null limit 1570μs/app/BaseModel.php:138liburant_ota_dev

Metadata
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	18. /app/BaseModel.php:138 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:426 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:418 22. /app/BaseModel.php:139 23. /modules/Media/Helpers/FileHelper.php:44

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

680μs/app/BaseModel.php:274liburant_ota_dev

Metadata
Bindings	0. 3 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/BaseModel.php:274 21. /app/BaseModel.php:292 22. view::Desa::frontend.layouts.search.loop-list:43 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `bravo_attrs` where `bravo_attrs`.`id` = 0 and `bravo_attrs`.`deleted_at` is null limit 1690μs/modules/Desa/Models/Desa.php:126liburant_ota_dev

Metadata
Bindings	0. 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. /modules/Desa/Models/Desa.php:126 20. view::Desa::frontend.layouts.search.loop-list:54 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61

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

1.19ms/app/BaseModel.php:274liburant_ota_dev

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/BaseModel.php:274 21. /app/BaseModel.php:292 22. /app/Helpers/AppHelper.php:111 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `core_pages` where `core_pages`.`id` = 4 and `core_pages`.`deleted_at` is null limit 11.16ms/modules/Core/Walkers/MenuWalker.php:36liburant_ota_dev

Metadata
Bindings	0. 4
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:19 21. /app/Helpers/AppHelper.php:116 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

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	19. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:19 21. /app/Helpers/AppHelper.php:116 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

1.14ms/app/BaseModel.php:274liburant_ota_dev

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/BaseModel.php:274 21. /app/BaseModel.php:292 22. /app/Helpers/AppHelper.php:111 25. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 26. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

Metadata
Bindings	0. 4
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:19 21. /app/Helpers/AppHelper.php:116 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

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	19. /modules/Core/Walkers/MenuWalker.php:36 20. /modules/Core/Walkers/MenuWalker.php:19 21. /app/Helpers/AppHelper.php:116 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `core_pages` where `core_pages`.`id` = '9' and `core_pages`.`deleted_at` is null limit 1700μs/app/Helpers/AppHelper.php:628liburant_ota_dev

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. /app/Helpers/AppHelper.php:628 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

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

850μs/app/BaseModel.php:274liburant_ota_dev

Metadata
Bindings	0. 2 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/BaseModel.php:274 21. /app/BaseModel.php:292 22. view::Popup::frontend.popup:6 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

Modules\Page\Models\Page: 5
Modules\Desa\Models\DesaRoom: 2
Modules\Location\Models\Location: 54
Modules\Desa\Models\Desa: 4

web: null
api: null
sanctum: null

_token: aHcLVXfwzXq5PuiBXVqgL4JWGMVXbgSKXUM47uDh
_previous: array:1 [ "url" => "https://api-traveloka-dev.liburanterus.com/en/desa?orderby=price_low_high" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/desa

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "orderby" => "price_low_high"
]

request_request

  0 of 0   
array:1 [▼
  "orderby" => "price_low_high"
]

request_headers

  0 of 0   
array:18 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkNieUk3bGRQM0lTWldobDdjK3hORmc9PSIsInZhbHVlIjoiRER3Nno1cGdOV2hHbTlqa09Ydmo5ZVQ1TE5SWkJ3ZUZFUmkwUXJKaFNHUVgraFZ2WCswa09Nd1VIdytLZUJrZkFCYTQ2cVVlbHlKaTA0OTRKTGtPZVM1N2dWVUIzV1J4YnBySmhjMmVDM2dNYXJXY1ZFSVFLV3ZVRVA2MVAxWk0iLCJtYWMiOiI0MGFmMDkwZTY3ZjVjM2IxNWUxZjlmMzg1ZWRiNWJiMGQ4NzRiZmM1OWNjMjk5ZTA2MDI3NjYyMWY3YjI3ZGRkIiwidGFnIjoiIn0%3D; liburanterus_session=eyJpdiI6ImJuUDhpT0tVVG1kb283bEs5NW1ra1E9PSIsInZhbHVlIjoiTE0ydzNWaUxteUd3anVKV2d1bCtraFBOTjJyWkRqQkwzUmgwb0JKc0tuczBHU205U2JmVmZtcy9RL1dRb0hVckgvUUNiSlUwYzRNek1RT0NOeVd0UlBTVjF4aENyZWJKMFZrQlZyWEdtRjU4b0w2SHRPTnZxSHpqVTkxQ2hDU0giLCJtYWMiOiI2NzE1ZGUyNTFkMjdiODI0N2JlODk1NDY5ZDA2MTI1ZjIxN2FiNGYwYTMwOTE1ZWJkYTY1NGEwMWI4NTU1YTI0IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkNieUk3bGRQM0lTWldobDdjK3hORmc9PSIsInZhbHVlIjoiRER3Nno1cGdOV2hHbTlqa09Ydmo5ZVQ1TE5SWkJ3ZUZFUmkwUXJKaFNHUVgraFZ2WCswa09Nd1VIdytLZUJrZkFCYTQ2c ▶"
  ]
  "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "api-traveloka-dev.liburanterus.com"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:43 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IkNieUk3bGRQM0lTWldobDdjK3hORmc9PSIsInZhbHVlIjoiRER3Nno1cGdOV2hHbTlqa09Ydmo5ZVQ1TE5SWkJ3ZUZFUmkwUXJKaFNHUVgraFZ2WCswa09Nd1VIdytLZUJrZkFCYTQ2cVVlbHlKaTA0OTRKTGtPZVM1N2dWVUIzV1J4YnBySmhjMmVDM2dNYXJXY1ZFSVFLV3ZVRVA2MVAxWk0iLCJtYWMiOiI0MGFmMDkwZTY3ZjVjM2IxNWUxZjlmMzg1ZWRiNWJiMGQ4NzRiZmM1OWNjMjk5ZTA2MDI3NjYyMWY3YjI3ZGRkIiwidGFnIjoiIn0%3D; liburanterus_session=eyJpdiI6ImJuUDhpT0tVVG1kb283bEs5NW1ra1E9PSIsInZhbHVlIjoiTE0ydzNWaUxteUd3anVKV2d1bCtraFBOTjJyWkRqQkwzUmgwb0JKc0tuczBHU205U2JmVmZtcy9RL1dRb0hVckgvUUNiSlUwYzRNek1RT0NOeVd0UlBTVjF4aENyZWJKMFZrQlZyWEdtRjU4b0w2SHRPTnZxSHpqVTkxQ2hDU0giLCJtYWMiOiI2NzE1ZGUyNTFkMjdiODI0N2JlODk1NDY5ZDA2MTI1ZjIxN2FiNGYwYTMwOTE1ZWJkYTY1NGEwMWI4NTU1YTI0IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkNieUk3bGRQM0lTWldobDdjK3hORmc9PSIsInZhbHVlIjoiRER3Nno1cGdOV2hHbTlqa09Ydmo5ZVQ1TE5SWkJ3ZUZFUmkwUXJKaFNHUVgraFZ2WCswa09Nd1VIdytLZUJrZkFCYTQ2c ▶"
  "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "api-traveloka-dev.liburanterus.com"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "api-traveloka-dev.liburanterus.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "10.24.49.239"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "24034"
  "REMOTE_ADDR" => "216.73.216.93"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "DOCUMENT_ROOT" => "/var/www/api-traveloka-dev.liburanterus.com/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/en/desa?orderby=price_low_high"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "orderby=price_low_high"
  "SCRIPT_FILENAME" => "/var/www/api-traveloka-dev.liburanterus.com/public/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1749310570.897
  "REQUEST_TIME" => 1749310570
]

request_cookies

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "aHcLVXfwzXq5PuiBXVqgL4JWGMVXbgSKXUM47uDh"
  "liburanterus_session" => "8axQJpR5EhQhxw4ibcX1ZeocXEVdMKsbgllzyTzE"
]

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 => "Sat, 07 Jun 2025 15:36:11 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1CcGVTVmJGVDh2S0VaMEV6MXBZRlE9PSIsInZhbHVlIjoiclFRNlYvT3g3WGpOdU1nNEJLT3k1ZWFQMmZUNEFlSXAvSUh4MjJad3k4MWt2L3YzcDY4MUIvSGdoLy9aOEMxS3RWWENxa1pVWU9xZm9BM29xSnZyMldtWUh0WnU3QWRxYThhQUI1eG5PbDZQT01lcUJ5Q3hOM3p4cWM3TVZ0dngiLCJtYWMiOiI4NzY5ZmIwNGI1OTI1ZmQ1ZDIxZjdjN2FkZWNlMzY2YzJkOTYxMjVjM2Y4OWM1YThkM2YwMTFjMmUzY2Q0Y2FjIiwidGFnIjoiIn0%3D; expires=Sat, 07-Jun-2025 17:36:11 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1CcGVTVmJGVDh2S0VaMEV6MXBZRlE9PSIsInZhbHVlIjoiclFRNlYvT3g3WGpOdU1nNEJLT3k1ZWFQMmZUNEFlSXAvSUh4MjJad3k4MWt2L3YzcDY4MUIvSGdoLy9aOEMxS3RWWENxa ▶"
    1 => "liburanterus_session=eyJpdiI6IkJ5ZmdNKzQvQjNhREp3UXNjMlk2Z2c9PSIsInZhbHVlIjoieUVBVkw3eTZaTjRZWjhYSGpuVHZlOS9nY3RYN01SUFlWRE5tMzVidzVuZ3dVYkpNK1hEQ3BNc2haazk1cVNWWUx1MDdqcGhHSnhBTm9YNFQ2OFZmREFuaWVESUQ4VWVvS1lPRkxMOUR6YTZPWUhuakxVVW1qTWVkWVFLTTJFVTUiLCJtYWMiOiJhOTRiYWFmZjRhZWU0MmE1N2QwZGZjM2UwZDQwMDA5YTllMTQ1MDAzZDI4NDFjMDJjZjBkNjIyZjVlNzgxMzNhIiwidGFnIjoiIn0%3D; expires=Sat, 07-Jun-2025 17:36:11 GMT; Max-Age=7200; path=/; httponly ◀liburanterus_session=eyJpdiI6IkJ5ZmdNKzQvQjNhREp3UXNjMlk2Z2c9PSIsInZhbHVlIjoieUVBVkw3eTZaTjRZWjhYSGpuVHZlOS9nY3RYN01SUFlWRE5tMzVidzVuZ3dVYkpNK1hEQ3BNc2haazk1cVN ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1CcGVTVmJGVDh2S0VaMEV6MXBZRlE9PSIsInZhbHVlIjoiclFRNlYvT3g3WGpOdU1nNEJLT3k1ZWFQMmZUNEFlSXAvSUh4MjJad3k4MWt2L3YzcDY4MUIvSGdoLy9aOEMxS3RWWENxa1pVWU9xZm9BM29xSnZyMldtWUh0WnU3QWRxYThhQUI1eG5PbDZQT01lcUJ5Q3hOM3p4cWM3TVZ0dngiLCJtYWMiOiI4NzY5ZmIwNGI1OTI1ZmQ1ZDIxZjdjN2FkZWNlMzY2YzJkOTYxMjVjM2Y4OWM1YThkM2YwMTFjMmUzY2Q0Y2FjIiwidGFnIjoiIn0%3D; expires=Sat, 07-Jun-2025 17:36:11 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1CcGVTVmJGVDh2S0VaMEV6MXBZRlE9PSIsInZhbHVlIjoiclFRNlYvT3g3WGpOdU1nNEJLT3k1ZWFQMmZUNEFlSXAvSUh4MjJad3k4MWt2L3YzcDY4MUIvSGdoLy9aOEMxS3RWWENxa ▶"
    1 => "liburanterus_session=eyJpdiI6IkJ5ZmdNKzQvQjNhREp3UXNjMlk2Z2c9PSIsInZhbHVlIjoieUVBVkw3eTZaTjRZWjhYSGpuVHZlOS9nY3RYN01SUFlWRE5tMzVidzVuZ3dVYkpNK1hEQ3BNc2haazk1cVNWWUx1MDdqcGhHSnhBTm9YNFQ2OFZmREFuaWVESUQ4VWVvS1lPRkxMOUR6YTZPWUhuakxVVW1qTWVkWVFLTTJFVTUiLCJtYWMiOiJhOTRiYWFmZjRhZWU0MmE1N2QwZGZjM2UwZDQwMDA5YTllMTQ1MDAzZDI4NDFjMDJjZjBkNjIyZjVlNzgxMzNhIiwidGFnIjoiIn0%3D; expires=Sat, 07-Jun-2025 17:36:11 GMT; path=/; httponly ◀liburanterus_session=eyJpdiI6IkJ5ZmdNKzQvQjNhREp3UXNjMlk2Z2c9PSIsInZhbHVlIjoieUVBVkw3eTZaTjRZWjhYSGpuVHZlOS9nY3RYN01SUFlWRE5tMzVidzVuZ3dVYkpNK1hEQ3BNc2haazk1cVN ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "aHcLVXfwzXq5PuiBXVqgL4JWGMVXbgSKXUM47uDh"
  "_previous" => array:1 [▶
    "url" => "https://api-traveloka-dev.liburanterus.com/en/desa?orderby=price_low_high"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 desa found

Need My Travel Help?

Contact Info

Perusahaan

Produk

Dukungan

Mailing List

1 x Application (78.01%)	284.82ms
1 x Booting (21.95%)	80.15ms

Price Range (Rp)

Desa Star

Review Score