Best Bali Tour Package for 4 days

Tour Type

Best Bali Tour Package for 4 days

Group Size

65 persons

Location

Indonesia

Download the Itinerary of this Package

Best Bali Tour Package for 4 days


04 Days 03 Nights

Package Price Valid Till: 30th September 2024

 

 

 

Highlghts:


 Bali's rich culture and history also make it a popular destination for tourists. The island has a vibrant arts scene, with traditional dance and music performances held regularly. Balinese cuisine is also a draw for many visitors, with its distinctive blend of spices and flavors.

In addition to its natural beauty and cultural attractions, Bali offers a range of outdoor activities for adventurous travelers. Visitors can go hiking or cycling in the mountains, snorkeling or diving in the coral reefs, or even try their hand at white-water rafting or zip-lining.

Despite its popularity as a tourist destination, Bali still maintains much of its traditional charm and way of life. Visitors can experience this through homestays, where they stay with local families and learn about Balinese customs and traditions. Overall, Bali offers a unique blend of natural beauty, culture, and adventure, making it a must-visit destination for many travelers.

 

Package Inclusions:


·         Private AC transportation and return airport transfers.

·         Three nights' accommodation and daily breakfast at the hotel.

·         Entrance tickets and parking fees during tours.

·         Wet tissue upon arrival at the airport and one bottle of mineral water (600 ml) per person during the tour.

·         All scheduled tours with a driver cum guide.

·         Indonesian government taxes.

·         Tipping for the driver.

 

Package Exclusions:


·         International air tickets from Dhaka to Bali and back, which cost approximately TK. 34,500 per adult.

·         Extra night accommodation beyond the three nights provided in the package.

·         Lunch and dinner expenses are not included in the package.

·         Water sport activities are not covered in the package.

·         Any other personal costs or expenses that are not mentioned above are not included in the package.

 

Hotel Details:


Hotel Type Hotel Name  Hotel Web Link
3 - Star  Phm Hotels In Bali Click Here to See in Web
4 - Star  Aston Kuta Hotel Click Here to See in Web
5 - Star
Aryaduta Bali Click Here to See in Web

 

Package Price Details (Per Person):


Room Sharing Type 3 - Star  4 - Star  5 - Star 
Adult on Double / Twin Share Basis TK. 20,000 TK. 24,500 TK. 30,500
Child with Bed TK. 13,500 TK. 16,500 TK. 21,500
Child no Bed TK. 5,000 TK. 5,000 TK. 5,500

 

Visa Requirements:


Please click on given link for Indonesia Visa detailsIndonesia Visa Web Link

 

Payment Policy:


Phase-1: A payment of 70% of the total package amount is required at the time of booking to secure your reservation.

Phase-2: The remaining 30% of the total package amount must be paid no later than 10 working days prior to the scheduled travel date.

 

 

Cancellation Policy:


Please note that all sales are final and cancellations will incur a 100% penalty. However, the cancellation policy for air tickets may vary depending on the policy of the airline. We recommend reviewing the airline's cancellation policy before booking your airfare.

 

ITINERARY:

 

DAY 01: ARRIVAL - CHECK IN TO HOTEL (2 HOURS)


Upon arrival, you will be met and greeted by our local tour guide who will transfer you to your hotel for overnight stay.

DAY 02: TANJUNG BENOA (WATER SPORT AREA) – ULUWATU TEMPLE (8 HOURS)


After breakfast at the hotel, we will continue our trip to Tanjung Benoa, Bali's water sports area, where you can enjoy activities such as parasailing, jet skiing, banana boat rides, snorkeling, and diving at your own expense. Next, we will visit the ancient Hindu temple of Uluwatu, perched on a cliff with a breathtaking ocean view, where you can enjoy the sunset if weather permits. Overnight stay at the hotel.

DAY 03: KINTAMANI VOLCANO - CELUK AND MAS HANDICRAFT CENTRE – COFFEE PLANTATION - PURI SAREN (8 HOURS)


After breakfast at the hotel, we will start our tour by visiting the villages of Mas and Celuk, known for their artistic creations such as painting, wood carving, and gold and silver smithing. We will then take you to a coffee plantation and then continue to Kintamani to see the Kintamani Mountain overlooking the beautiful landscape. Finally, we will transfer you to Puri Saren, the palace of Ubud Kingdom, for a cultural experience. Overnight stay at the hotel.

DAY 04: AIRPORT TRANSFER OUT (2 HOURS)


You will have some free time to enjoy your last moments in Bali before being transferred to the airport for your flight back home.

 

 

End of service.

Remarks


·     Please note that confirmation of the tour package always depends on the availability of services at the time of booking.

·     We offer a 5% discount on all our published packages, but this discount does not apply to EMI beneficiaries.

·     All tours and sightseeing are on a shared basis (SIC).

·      Children aged 2-11 years must share a room with two adults and will not be provided with an extra bed. They will occupy a seat on the coach.

·         Child prices only apply if there are two adults. In the case of one adult and one child, you will need to book for two adults.

·       Please note that our tours are not wheelchair accessible.

·      Note that our company only provides consultancy services and does not provide any guarantee for visa approval.

·     Visa processing will start only after receiving all necessary documents.

·    Visa processing time, requirements, and fees are subject to change by the embassy without any prior notice.

·    The embassy reserves the right to ask for any additional documents other than those mentioned in the checklist.

What is included in the Bali Tour Package for 4 days?
The inclusions of the Bali Tour Package for 4 days may vary depending on the travel agency or tour operator offering the package. However, typically it includes accommodation in a hotel, daily breakfast, airport transfers, and guided tours to popular tourist attractions in Bali.
How much does the Bali Tour Package for 4 days cost?
The cost of the Bali Tour Package for 4 days can vary depending on the type of hotel or accommodation, the inclusions of the package, and the time of travel. It's best to check with the travel agency or tour operator for specific pricing and availability.
Are flights included in the Bali Tour Package for 4 days?
Flights are usually not included in the Bali Tour Package for 4 days, but some travel agencies or tour operators may offer a package that includes flights. It's best to check with the provider for specific details.
What are some popular tourist attractions included in the Bali Tour Package for 4 days?
Popular tourist attractions included in the Bali Tour Package for 4 days can vary, but some of the most common are Uluwatu Temple, Tanjung Benoa Beach, Kintamani Volcano, and Mas and Celuk village for their handicraft centers. Some packages may also include activities like water sports, spa treatments, and cultural performances.
Are meals included in the Bali Tour Package for 4 days?
Typically, only daily breakfast is included in the Bali Tour Package for 4 days. However, some packages may include additional meals or offer an option to add meals for an additional fee. It's best to check with the travel agency or tour operator for specific details.
20%
from $217.39 $173.91

Contact Us

+8802-48322622-4
+8801972-944676

Sky View Trade Vally, (13th Floor),66/1 VIP Road Naya Paltan, Dhaka-1000, Bangladesh.

Get direction on google map
Follow Us

from
$217.39 $173.91
Messages {{unread_count}}
Chat with: {{currentConversation.display_name}}
{{chat.display_name ? chat.display_name[0] : ''}}

{{chat.display_name}}

You: {{chat.last_message.content}}

{{chat.unread_count }}
8.1.32PHP Version946msRequest Duration6MBMemory UsageGET tour/{slug}RouteAuth status
    • Booting (84.16ms)
    • Application (862ms)
    • 1 x Application (91.11%)
      862ms
      1 x Booting (8.89%)
      84.16ms
      45 templates were rendered
      • Tour::frontend.detail (modules/Tour/Views/frontend/detail.blade.php)9blade
        Params
        0
        row
        1
        translation
        2
        hajj_related
        3
        tour_related
        4
        visa_related
        5
        booking_data
        6
        review_list
        7
        seo_meta
        8
        body_class
      • Tour::frontend.layouts.details.tour-banner (modules/Tour/Views/frontend/layouts/details/tour-banner.blade.php)12blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
      • Tour::frontend.layouts.details.tour-detail (modules/Tour/Views/frontend/layouts/details/tour-detail.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.details.global-contact (modules/Tour/Views/frontend/layouts/details/global-contact.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        location
        14
        cat
        15
        __currentLoopData
        16
        item
        17
        key
        18
        loop
      • Tour::frontend.layouts.details.tour-review (modules/Tour/Views/frontend/layouts/details/tour-review.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Review::frontend.form (modules/Review/Views/frontend/form.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.details.tour-form-book (modules/Tour/Views/frontend/layouts/details/tour-form-book.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Booking::frontend.global.enquiry-form (modules/Booking/Views/frontend/global/enquiry-form.blade.php)14blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        service_type
      • Tour::frontend.layouts.details.open-hours (modules/Tour/Views/frontend/layouts/details/open-hours.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.details.tour-right-sidebar (modules/Tour/Views/frontend/layouts/details/tour-right-sidebar.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.details.tour-sidebar (modules/Tour/Views/frontend/layouts/details/tour-sidebar.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.sidebars.recent_tour (modules/Tour/Views/frontend/layouts/sidebars/recent_tour.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_tour (modules/Tour/Views/frontend/layouts/sidebars/recent_tour.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_tour (modules/Tour/Views/frontend/layouts/sidebars/recent_tour.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_tour (modules/Tour/Views/frontend/layouts/sidebars/recent_tour.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_tour (modules/Tour/Views/frontend/layouts/sidebars/recent_tour.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_tour (modules/Tour/Views/frontend/layouts/sidebars/recent_tour.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.details.visa-sidebar (modules/Tour/Views/frontend/layouts/details/visa-sidebar.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.sidebars.recent_visa (modules/Tour/Views/frontend/layouts/sidebars/recent_visa.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_visa (modules/Tour/Views/frontend/layouts/sidebars/recent_visa.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_visa (modules/Tour/Views/frontend/layouts/sidebars/recent_visa.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_visa (modules/Tour/Views/frontend/layouts/sidebars/recent_visa.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_visa (modules/Tour/Views/frontend/layouts/sidebars/recent_visa.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.sidebars.recent_visa (modules/Tour/Views/frontend/layouts/sidebars/recent_visa.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.details.tour-related (modules/Tour/Views/frontend/layouts/details/tour-related.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Tour::frontend.layouts.search.loop-grid (modules/Tour/Views/frontend/layouts/search/loop-grid.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.search.loop-grid (modules/Tour/Views/frontend/layouts/search/loop-grid.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.search.loop-grid (modules/Tour/Views/frontend/layouts/search/loop-grid.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • Tour::frontend.layouts.search.loop-grid (modules/Tour/Views/frontend/layouts/search/loop-grid.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        __currentLoopData
        14
        item
        15
        k
        16
        loop
        17
        include_param
      • layouts.app (resources/views/layouts/app.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Layout::app (modules/Layout/app.blade.php)13blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
      • Layout::parts.seo-meta (modules/Layout/parts/seo-meta.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
      • schema (resources/views/schema.blade.php)2blade
        Params
        0
        slot
        1
        __laravel_slots
      • Layout::parts.topbar (modules/Layout/parts/topbar.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
      • Core::frontend.currency-switcher (modules/Core/Views/frontend/currency-switcher.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
      • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
      • Layout::parts.header (modules/Layout/parts/header.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
      • Core::frontend.currency-switcher (modules/Core/Views/frontend/currency-switcher.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        logo_id
        16
        logo
      • Language::frontend.switcher (modules/Language/Views/frontend/switcher.blade.php)17blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        logo_id
        16
        logo
      • Layout::parts.footer (modules/Layout/parts/footer.blade.php)15blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
      • Layout::parts.login-register-modal (modules/Layout/parts/login-register-modal.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        list_widget_footers
        16
        __currentLoopData
        17
        item
        18
        key
        19
        loop
      • Layout::auth.login-form (modules/Layout/auth/login-form.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        list_widget_footers
        16
        __currentLoopData
        17
        item
        18
        key
        19
        loop
      • Layout::auth.register-form (modules/Layout/auth/register-form.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        list_widget_footers
        16
        __currentLoopData
        17
        item
        18
        key
        19
        loop
      • Layout::parts.chat (modules/Layout/parts/chat.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        list_widget_footers
        16
        __currentLoopData
        17
        item
        18
        key
        19
        loop
      • Popup::frontend.popup (modules/Popup/Views/frontend/popup.blade.php)20blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        row
        4
        translation
        5
        hajj_related
        6
        tour_related
        7
        visa_related
        8
        booking_data
        9
        review_list
        10
        seo_meta
        11
        body_class
        12
        review_score
        13
        favicon
        14
        file
        15
        list_widget_footers
        16
        __currentLoopData
        17
        item
        18
        key
        19
        loop
      uri
      GET tour/{slug}
      middleware
      web
      controller
      \Modules\Tour\Controllers\TourController@detail
      namespace
      Modules\Tour\Controllers
      prefix
      /tour
      where
      as
      tour-category.details
      file
      modules/Tour/Controllers/TourController.php:95-125
      33 statements were executed, 6 of which were duplicated, 27 unique437ms
      • select * from `bravo_tours` where `slug` = 'best-bali-tour-package-for-4-days' and `bravo_tours`.`deleted_at` is null limit 129.94ms/modules/Tour/Controllers/TourController.php:97nariaholidays_main
        Metadata
        Bindings
        • 0. best-bali-tour-package-for-4-days
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. /modules/Tour/Controllers/TourController.php:97
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /modules/Tour/Controllers/TourController.php:42
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_locations` where `bravo_locations`.`id` in ('100') and `bravo_locations`.`deleted_at` is null1.82ms/modules/Tour/Controllers/TourController.php:97nariaholidays_main
        Metadata
        Bindings
        • 0. 100
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Tour/Controllers/TourController.php:97
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Tour/Controllers/TourController.php:42
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (100)2.2ms/modules/Tour/Controllers/TourController.php:97nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 25. /modules/Tour/Controllers/TourController.php:97
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /modules/Tour/Controllers/TourController.php:42
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_tour_translations` where `bravo_tour_translations`.`origin_id` in (56)2.58ms/modules/Tour/Controllers/TourController.php:97nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Tour/Controllers/TourController.php:97
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Tour/Controllers/TourController.php:42
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (56)4.82ms/modules/Tour/Controllers/TourController.php:97nariaholidays_main
        Metadata
        Bindings
        • 0. tour
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 20. /modules/Tour/Controllers/TourController.php:97
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /modules/Tour/Controllers/TourController.php:42
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_spaces` where `status` = 'publish' and `id` not in (56) and `bravo_spaces`.`deleted_at` is null order by `id` desc limit 618.49ms/modules/Tour/Controllers/TourController.php:107nariaholidays_main
        Metadata
        Bindings
        • 0. publish
        • 1. 56
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /modules/Tour/Controllers/TourController.php:107
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Tour/Controllers/TourController.php:42
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_locations` where `bravo_locations`.`id` in ('117', '122', '140', '141', '144', '160') and `bravo_locations`.`deleted_at` is null5.39ms/modules/Tour/Controllers/TourController.php:107nariaholidays_main
        Metadata
        Bindings
        • 0. 117
        • 1. 122
        • 2. 140
        • 3. 141
        • 4. 144
        • 5. 160
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:107
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (117, 122, 140, 141, 144, 160)12.36ms/modules/Tour/Controllers/TourController.php:107nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. /modules/Tour/Controllers/TourController.php:107
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /modules/Tour/Controllers/TourController.php:42
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_space_translations` where `bravo_space_translations`.`origin_id` in (8, 9, 10, 11, 12, 13) and `bravo_space_translations`.`deleted_at` is null17.65ms/modules/Tour/Controllers/TourController.php:107nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:107
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `user_wishlist` where `object_model` = 'hajj' and `user_id` = 0 and `user_wishlist`.`object_id` in (8, 9, 10, 11, 12, 13)9.57ms/modules/Tour/Controllers/TourController.php:107nariaholidays_main
        Metadata
        Bindings
        • 0. hajj
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:107
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_tours` where `status` = 'publish' and `id` not in (56) and `bravo_tours`.`deleted_at` is null order by `id` desc limit 418.81ms/modules/Tour/Controllers/TourController.php:108nariaholidays_main
        Metadata
        Bindings
        • 0. publish
        • 1. 56
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /modules/Tour/Controllers/TourController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Tour/Controllers/TourController.php:42
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_locations` where `bravo_locations`.`id` in ('143', '165', '167', '168') and `bravo_locations`.`deleted_at` is null40.08ms/modules/Tour/Controllers/TourController.php:108nariaholidays_main
        Metadata
        Bindings
        • 0. 143
        • 1. 165
        • 2. 167
        • 3. 168
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_location_translations` where `bravo_location_translations`.`origin_id` in (143, 165, 167, 168)10.99ms/modules/Tour/Controllers/TourController.php:108nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. /modules/Tour/Controllers/TourController.php:108
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /modules/Tour/Controllers/TourController.php:42
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_tour_translations` where `bravo_tour_translations`.`origin_id` in (103, 104, 106, 108)11.12ms/modules/Tour/Controllers/TourController.php:108nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (103, 104, 106, 108)4.57ms/modules/Tour/Controllers/TourController.php:108nariaholidays_main
        Metadata
        Bindings
        • 0. tour
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:108
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_cars` where `status` = 'publish' and `id` not in (56) and `bravo_cars`.`deleted_at` is null order by `id` desc limit 68.21ms/modules/Tour/Controllers/TourController.php:109nariaholidays_main
        Metadata
        Bindings
        • 0. publish
        • 1. 56
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /modules/Tour/Controllers/TourController.php:109
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /modules/Tour/Controllers/TourController.php:42
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_locations` where `bravo_locations`.`id` in ('') and `bravo_locations`.`deleted_at` is null16.16ms/modules/Tour/Controllers/TourController.php:109nariaholidays_main
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:109
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `bravo_car_translations` where `bravo_car_translations`.`origin_id` in (172, 173, 174, 175, 176, 177) and `bravo_car_translations`.`deleted_at` is null6.88ms/modules/Tour/Controllers/TourController.php:109nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:109
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select * from `user_wishlist` where `object_model` = 'visa' and `user_id` = 0 and `user_wishlist`.`object_id` in (172, 173, 174, 175, 176, 177)23.12ms/modules/Tour/Controllers/TourController.php:109nariaholidays_main
        Metadata
        Bindings
        • 0. visa
        • 1. 0
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /modules/Tour/Controllers/TourController.php:109
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /modules/Tour/Controllers/TourController.php:42
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select count(*) as aggregate from `bravo_review` where `object_id` = 56 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null10.8ms/modules/Tour/Models/Tour.php:829nariaholidays_main
        Metadata
        Bindings
        • 0. 56
        • 1. tour
        • 2. approved
        Backtrace
        • 15. /modules/Tour/Models/Tour.php:829
        • 16. /modules/Tour/Controllers/TourController.php:111
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /modules/Tour/Controllers/TourController.php:42
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `bravo_tour_meta` where `bravo_tour_meta`.`tour_id` = 56 and `bravo_tour_meta`.`tour_id` is not null limit 118ms/modules/Tour/Models/Tour.php:603nariaholidays_main
        Metadata
        Bindings
        • 0. 56
        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:603
        • 22. /modules/Tour/Controllers/TourController.php:118
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 24. /modules/Tour/Controllers/TourController.php:42
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `bravo_seo` where `object_id` = 56 and `object_model` = 'tour' limit 130.26ms/app/BaseModel.php:236nariaholidays_main
        Metadata
        Bindings
        • 0. 56
        • 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:236
        • 16. /app/BaseModel.php:249
        • 17. /modules/Tour/Controllers/TourController.php:120
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /modules/Tour/Controllers/TourController.php:42
      • select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 56 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 116.59ms/modules/Tour/Models/Tour.php:755nariaholidays_main
        Metadata
        Bindings
        • 0. 56
        • 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:755
        • 21. view::Tour::frontend.detail:217
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • 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` = 56 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 123.53ms/modules/Tour/Models/Tour.php:767nariaholidays_main
        Metadata
        Bindings
        • 0. 56
        • 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:767
        • 21. view::Tour::frontend.detail:217
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
      • select * from `bravo_tour_category` where `bravo_tour_category`.`id` = '28' and `bravo_tour_category`.`id` is not null and `bravo_tour_category`.`deleted_at` is null limit 17.38msview::Tour::frontend.layouts.details.tour-detail:105nariaholidays_main
        Metadata
        Bindings
        • 0. 28
        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:105
        • 23. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 26. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `bravo_tour_category_translations` where `bravo_tour_category_translations`.`origin_id` in (28)5.42msview::Tour::frontend.layouts.details.tour-detail:105nariaholidays_main
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 26. view::Tour::frontend.layouts.details.tour-detail:105
        • 28. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 29. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 31. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 16.65ms/app/BaseModel.php:138nariaholidays_main
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 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 `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 121.43ms/app/BaseModel.php:138nariaholidays_main
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 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 `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 12.51ms/app/BaseModel.php:138nariaholidays_main
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 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 `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 17.86ms/app/BaseModel.php:138nariaholidays_main
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 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 `core_pages` where `core_pages`.`id` = 10 and `core_pages`.`deleted_at` is null limit 116.69ms/modules/Core/Walkers/MenuWalker.php:36nariaholidays_main
        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: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` = 10 and `core_pages`.`deleted_at` is null limit 111.27ms/modules/Core/Walkers/MenuWalker.php:36nariaholidays_main
        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: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` = '' and `core_pages`.`deleted_at` is null limit 113.38ms/app/Helpers/AppHelper.php:628nariaholidays_main
        Metadata
        Bindings
        • 0. 
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 19. /app/Helpers/AppHelper.php: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
      Modules\Page\Models\Page
      2
      Modules\Tour\Models\TourCategory
      1
      Modules\Review\Models\Review
      2
      Modules\Core\Models\SEO
      1
      Modules\Tour\Models\TourMeta
      1
      Modules\Visa\Models\Visa
      6
      Modules\Hajj\Models\Hajj
      6
      Modules\Location\Models\Location
      11
      Modules\Tour\Models\Tour
      5
        web
        null
        api
        null
        sanctum
        null
          _token
          0FLSgLqNJxES8pOWK5XCJa2gKlB0TZYUcGfm7Abv
          bc_current_currency
          usd
          _previous
          array:1 [ "url" => "https://www.nariatravels.com/tour/best-bali-tour-package-for-4-days" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /tour/best-bali-tour-package-for-4-days
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:24 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilp4VDlvZ2RzbDZ3QWVOekRvSTIzOUE9PSIsInZhbHVlIjoienh2SVROeitvakc0MkNURytPQk51UmJGK0ZFa1FFK3grWXZQb3piZU80Tm9kWCt6dXhIWlViN0NRbndRcHp3elNvSTkzV01TUGovZ2p5ZkJxaUQzRVJTUkczbXNtbkcyQldzdkpLNmZEZDNMcHpBY3dHVUIvRU9iUU1zY2plb0wiLCJtYWMiOiI5MjVlYTk0NmI5YTU3NWJmYjVlNjFhNDNhMDZiOTlmMmI5M2ZhYzEwN2VjZTA0Y2ZiMzY3YWJjOTcyZTNjODZlIiwidGFnIjoiIn0%3D; naria_travels_tours_session=eyJpdiI6IjluSkQ2UDJPem44SmRxY0RYdTJLeEE9PSIsInZhbHVlIjoiOVhVbjFwVys3R0ZqcGQ1amgzWkJPaks2a3ZJeHZNTnlNOStwV05QRHk0SzNtUlFkTzc3MFkrVGZsYWVPSnVGSXY0eFJkcU5VcW15SDZvQVEyTW5FcitlbmxDa3VxMVVIQWVmUndpVnRIZWNvd1d1b1FZaGljMjJuNWVsSFAybHAiLCJtYWMiOiJhYTczNDFiMGZlNGIxOTFiNmJmNjA0YmQ5ZDI0Y2Q4OTQ2MWQ4NzU4ZGEwMTFlNDEyMzdhNDMxZjJmZTlhN2ZhIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6Ilp4VDlvZ2RzbDZ3QWVOekRvSTIzOUE9PSIsInZhbHVlIjoienh2SVROeitvakc0MkNURytPQk51UmJGK0ZFa1FFK3grWXZQb3piZU80Tm9kWCt6dXhIWlViN0NRbndRcHp3elNvSTkzV" ] "host" => array:1 [ 0 => "www.nariatravels.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "x-forwarded-for" => array:1 [ 0 => "18.117.129.247,172.71.254.6" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] "cf-ray" => array:1 [ 0 => "947c36fb6ea1eae8-ORD" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "cf-connecting-ip" => array:1 [ 0 => "18.117.129.247" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-https" => array:1 [ 0 => "on" ] ]
          request_server
          0 of 0
          array:52 [ "PHP_INI_SCAN_DIR" => "/home/nariaholidays/.system-php/ini/8.1/nariatravels.com.nariaholidays.com" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6Ilp4VDlvZ2RzbDZ3QWVOekRvSTIzOUE9PSIsInZhbHVlIjoienh2SVROeitvakc0MkNURytPQk51UmJGK0ZFa1FFK3grWXZQb3piZU80Tm9kWCt6dXhIWlViN0NRbndRcHp3elNvSTkzV01TUGovZ2p5ZkJxaUQzRVJTUkczbXNtbkcyQldzdkpLNmZEZDNMcHpBY3dHVUIvRU9iUU1zY2plb0wiLCJtYWMiOiI5MjVlYTk0NmI5YTU3NWJmYjVlNjFhNDNhMDZiOTlmMmI5M2ZhYzEwN2VjZTA0Y2ZiMzY3YWJjOTcyZTNjODZlIiwidGFnIjoiIn0%3D; naria_travels_tours_session=eyJpdiI6IjluSkQ2UDJPem44SmRxY0RYdTJLeEE9PSIsInZhbHVlIjoiOVhVbjFwVys3R0ZqcGQ1amgzWkJPaks2a3ZJeHZNTnlNOStwV05QRHk0SzNtUlFkTzc3MFkrVGZsYWVPSnVGSXY0eFJkcU5VcW15SDZvQVEyTW5FcitlbmxDa3VxMVVIQWVmUndpVnRIZWNvd1d1b1FZaGljMjJuNWVsSFAybHAiLCJtYWMiOiJhYTczNDFiMGZlNGIxOTFiNmJmNjA0YmQ5ZDI0Y2Q4OTQ2MWQ4NzU4ZGEwMTFlNDEyMzdhNDMxZjJmZTlhN2ZhIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6Ilp4VDlvZ2RzbDZ3QWVOekRvSTIzOUE9PSIsInZhbHVlIjoienh2SVROeitvakc0MkNURytPQk51UmJGK0ZFa1FFK3grWXZQb3piZU80Tm9kWCt6dXhIWlViN0NRbndRcHp3elNvSTkzV" "HTTP_HOST" => "www.nariatravels.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_X_FORWARDED_FOR" => "18.117.129.247,172.71.254.6" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "HTTP_CF_RAY" => "947c36fb6ea1eae8-ORD" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_CF_CONNECTING_IP" => "18.117.129.247" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_HTTPS" => "on" "DOCUMENT_ROOT" => "/home/nariaholidays/nariatravels.com" "REMOTE_ADDR" => "18.117.129.247" "REMOTE_PORT" => "34602" "SERVER_ADDR" => "68.65.120.98" "SERVER_NAME" => "www.nariatravels.com" "SERVER_ADMIN" => "webmaster@nariatravels.com.nariaholidays.com" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/tour/best-bali-tour-package-for-4-days" "REDIRECT_URL" => "/public/tour/best-bali-tour-package-for-4-days" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "68.65.120.98" "HTTPS" => "on" "REDIRECT_STATUS" => "200" "SCRIPT_FILENAME" => "/home/nariaholidays/nariatravels.com/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://www.nariatravels.com/tour/best-bali-tour-package-for-4-days" "SCRIPT_URL" => "/tour/best-bali-tour-package-for-4-days" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1748586961.25 "REQUEST_TIME" => 1748586961 ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "0FLSgLqNJxES8pOWK5XCJa2gKlB0TZYUcGfm7Abv" "naria_travels_tours_session" => "xqVEdQIFAQpo2J3eoi2U4DcfecXtUrPLh3mBWIXF" ]
          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 => "Fri, 30 May 2025 06:36:01 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InplM1I2N2FIZGV4WU5PYTk0c2pPN0E9PSIsInZhbHVlIjoiVE9lellPMjE5Qy84alNSQ09hdmN6bGYzOVY3Tm9obWN5Yk9GMFVYZkdjd2FQUWc3R3h4TVlpbXViSW1mS2xrRnBYUHdORCtDYnVpSkJyNzBWcFVyemIzdHp0bEF5dmtXckhwVnZoY1cybCtkZE1peFJrVkFCYVRVckhNVEo1Qm4iLCJtYWMiOiI3ZDhiNThkOTM0NDhkNmVkZjhkOWJmYmI0OGU0YjE5MTFlNTBkN2NlZmNhZjYzZmMxZTA1M2M3N2ZlODBjOTAyIiwidGFnIjoiIn0%3D; expires=Fri, 30-May-2025 08:36:02 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InplM1I2N2FIZGV4WU5PYTk0c2pPN0E9PSIsInZhbHVlIjoiVE9lellPMjE5Qy84alNSQ09hdmN6bGYzOVY3Tm9obWN5Yk9GMFVYZkdjd2FQUWc3R3h4TVlpbXViSW1mS2xrRnBYUHdOR" 1 => "naria_travels_tours_session=eyJpdiI6Ik9uT3I1OWN5SzVieFJoejUwbWM4c3c9PSIsInZhbHVlIjoiQnZxYjhaQWQ4SUtLYndncXIxOGZaSUNzVU1FM2hYbnZXZno5WVNlUmJTMUVZQXI1YjNndVk0YUhVYktyMTVEUXpRckpLYU1WZVpQbFlSNkJwOFBvcmxpbGplUzdxdWZUZWp4SlFuTzNFSmVKVFZmODRBV3h3MWFpR0ZSd3VPOTYiLCJtYWMiOiIyNDJhNTU3NmJlNDI1ZjJhNjEwNmNkYzUyODE1Y2Q2ZTBiYTQ1NDRhYjY2MzVhZmRiMjZhNjkxNWQ4YTI2NGJlIiwidGFnIjoiIn0%3D; expires=Fri, 30-May-2025 08:36:02 GMT; Max-Age=7200; path=/; httponlynaria_travels_tours_session=eyJpdiI6Ik9uT3I1OWN5SzVieFJoejUwbWM4c3c9PSIsInZhbHVlIjoiQnZxYjhaQWQ4SUtLYndncXIxOGZaSUNzVU1FM2hYbnZXZno5WVNlUmJTMUVZQXI1YjNndVk0YUhV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InplM1I2N2FIZGV4WU5PYTk0c2pPN0E9PSIsInZhbHVlIjoiVE9lellPMjE5Qy84alNSQ09hdmN6bGYzOVY3Tm9obWN5Yk9GMFVYZkdjd2FQUWc3R3h4TVlpbXViSW1mS2xrRnBYUHdORCtDYnVpSkJyNzBWcFVyemIzdHp0bEF5dmtXckhwVnZoY1cybCtkZE1peFJrVkFCYVRVckhNVEo1Qm4iLCJtYWMiOiI3ZDhiNThkOTM0NDhkNmVkZjhkOWJmYmI0OGU0YjE5MTFlNTBkN2NlZmNhZjYzZmMxZTA1M2M3N2ZlODBjOTAyIiwidGFnIjoiIn0%3D; expires=Fri, 30-May-2025 08:36:02 GMT; path=/XSRF-TOKEN=eyJpdiI6InplM1I2N2FIZGV4WU5PYTk0c2pPN0E9PSIsInZhbHVlIjoiVE9lellPMjE5Qy84alNSQ09hdmN6bGYzOVY3Tm9obWN5Yk9GMFVYZkdjd2FQUWc3R3h4TVlpbXViSW1mS2xrRnBYUHdOR" 1 => "naria_travels_tours_session=eyJpdiI6Ik9uT3I1OWN5SzVieFJoejUwbWM4c3c9PSIsInZhbHVlIjoiQnZxYjhaQWQ4SUtLYndncXIxOGZaSUNzVU1FM2hYbnZXZno5WVNlUmJTMUVZQXI1YjNndVk0YUhVYktyMTVEUXpRckpLYU1WZVpQbFlSNkJwOFBvcmxpbGplUzdxdWZUZWp4SlFuTzNFSmVKVFZmODRBV3h3MWFpR0ZSd3VPOTYiLCJtYWMiOiIyNDJhNTU3NmJlNDI1ZjJhNjEwNmNkYzUyODE1Y2Q2ZTBiYTQ1NDRhYjY2MzVhZmRiMjZhNjkxNWQ4YTI2NGJlIiwidGFnIjoiIn0%3D; expires=Fri, 30-May-2025 08:36:02 GMT; path=/; httponlynaria_travels_tours_session=eyJpdiI6Ik9uT3I1OWN5SzVieFJoejUwbWM4c3c9PSIsInZhbHVlIjoiQnZxYjhaQWQ4SUtLYndncXIxOGZaSUNzVU1FM2hYbnZXZno5WVNlUmJTMUVZQXI1YjNndVk0YUhV" ] ]
          session_attributes
          0 of 0
          array:5 [ "_token" => "0FLSgLqNJxES8pOWK5XCJa2gKlB0TZYUcGfm7Abv" "bc_current_currency" => "usd" "_previous" => array:1 [ "url" => "https://www.nariatravels.com/tour/best-bali-tour-package-for-4-days" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]