Discover Lanai

Trilogy Excursions (4.7)
$220

The best way to experience Lana'i


Set sail from the harbor and enjoy breakfast on board. Then get ready for a day of swimming, snorkeling, sunbathing, beach volleyball and the increasingly popular SNUBA. Head off on an optional tour of Lana'i town before tucking into a tasty Kiawe wood BBQ overlooking Manele Bay.


We depart from Lahaina Harbor at around 10 am (seasonally we offer a sunrise departure at 6:30 am--this is the "Crew's Favorite"!) for the one and a half hour sail to this very special island. Because we are the only company with permission to bring guests to Hulopo'e Marine Preserve, we pay close attention to both your safety and comfort. Our crew, as well as our island-born Beach Boys, are trained in CPR and First Aid and are experts at ensuring your safety in and out of the water. For those wanting to deepen their ocean adventure, we recommend upgrading to SNUBA.

Besides swimming, snorkeling, sunbathing, and beach volleyball, we also offer a guided tour of Lana'i's historic plantation town narrated by island-born Cultural Guides. Our Kiawe wood BBQ dinner, served at the Hale O Manele overlooking Manele Bay, is considered by many to be one of the best in Hawai'i! The return sail to Maui can be restful and relaxing, or wet & wild, but it is always safe and lots of fun. So whether you are a sunrise or sunset kind-of-person, many of our guests write to tell us that Discovering Lana'i was the highlight of their whole vacation! Come out and discover for yourself why we have been chosen #1 sailing company on Maui for over 42 years.

Included
  • Fresh-water showers, beach mats, lawn chairs, the shade of palm trees, and one of the most beautiful beaches in all of Hawaii
  • Snorkeling equipment and an optional SNUBA upgrade
  • For safety purposes, we require our passengers to wear a type of flotation while snorkeling.
  • Discover Lanai offers two comfortable options for guests to choose from.
  • Guided snorkel-reef tour with a trained naturalist
  • Whale Watching December - April
  • Narrated Island Tour of Lana'i plantation town by certified Hawaiian Cultural Guides
  • Only company in Hawaii with permission to escort guests to Hulopo'e Beach & Marine Preserve
  • Crew ensure your safety in and out of the water
  • State-of-the-art medical emergency equipment on the boats and at the beach
  • Staff are all CPR trained and certified
  • Lunch is served at Hale O Manele Pavilion overlooking Manele Harbor

Food and DRINKS
  • Breakfast - Mom Coon's 4th generation recipe Cinnamon Rolls, Fresh Fruit, Kona Coffee, Hot Tea and Cocoa, and Pineapple Juice. En route to Lana'i, the 6:30 am tour will serve an Egg Croissant
  • Sandwich and the 10 am will serve a variety of Deli Wraps
  • BBQ meal - Captain Coon’s kiawe pulehu (grilled) BBQ Chicken *GF, Asian Stir-fried Noodles,
  • Seasonal Vegetable, Tossed Green Salad with Mom's Secret Blue Cheese Dressing, Assorted Rolls, and Fresh Hawaiian Pineapple
  • Beverages - wide assortment of non-alcoholic beverages. Our premium selection of adult beverages are available after your ocean activities. Bar Includes Moloka'i Mule, Lana'i Tai, Locally Brewed Beer, and White Wine. For guests ages 21 years and older, two premium beverages are included on the return sail! *Must have I.D. present
    Dietary restrictions - Vegetarian and vegan meals are available only upon request when booking your reservation. *GF- gluten free
     

more
Time 6:30 am or 10:00 am
Not available Saturday and Sunday
Duration 8.5 hours
Location Lahaina Harbor

Please view the cancellation policy and restrictions.

Cancellation Policy

1 - 8 Guests = Must cancel 48 Hours prior to trip departure time 
9 or more Guests = Must cancel 72 Hours prior to trip departure time  
Or full amount will be charged for your tour.


Last Minute Bookings

Please be aware that these bookings are subject to confirmation. If this is a same-day or next-day booking, there is a reasonable chance this will not be confirmed. For bookings that are confirmed, there will be no cancellations or refunds.


Restrictions

Entering and exiting the boat and accessing the on-board restrooms requires ascending and descending steep stairs.  Customers must have the necessary mobility to navigate this.
No wheelchairs or walkers permitted (small or collapsable cane okay).


Frequently Asked Questions


Reviews

Review Summary
(4.7)
show reviews  hide reviews 

- Sep 2019 -

jessierwhite

Do this, don’t wait! Discover Lanai is like private excursion to an exclusive beach! Our crew (Captain Turtle, Brayden, Angelo, Lol & Alissa) did not disappoint! Fun, courteous, knowledgeable & will make the hours fly by. You know it’s a great company when their crew has been there for many years. Enjoy snorkeling or snuba, beach time, hiking, Lanai City tour, great food & some true sailing off at sunset. The views are incredible. I’m no photographer but you don’t have to worry because there’s a crew member that takes care of capturing your trip & all those underwater shots too. Snuba & photos are an extra cost but totally worth it, & absolutely no pressure involved. You’ll leave with a belly full of food, a smile on your face, and a plan to for your next Trilogy excursion! I’ve used other tour companies here but this company is far better, a real 5 star.

(5.0)
- Sep 2019 -

ekw207

The Discover Lana'i trip was 100% worth the $220 per person it costs. I am careful about how I spend money on vacation and I felt based on other reviews I read that I would go for it. I was not disappointed! This trip exceeded my expectations. If you are on the fence, do it. I'm going to address some of the things I was looking for in a review and that it seems others look for: 1) Will I see dolphins? Probably! We did! I actually chose this cruise because it is a Dolphin Smart business and does not force dolphin interactions or otherwise harass dolphins. It sounds like people see them all the time on this trip, but dolphin sightings were not guaranteed on the Discover Lana'i tour. There is a pod in the channel between Maui and Lana'i and I did the early morning trip when the dolphins are finishing up their feeding for the night. They typically sleep and are less active during the day but they came and surfed our bow for about 30 minutes on the trip to Lana'i. In addition, on the way back we lucked out and saw false killer whales! The crew said this only happens about 2 times a year but I was so excited and felt so lucky I could hardly contain myself. Lots of marine life this trip! 2) Solo travel - I did this trip as a solo traveler and I had a great time, everyone was friendly, there was time to be by myself if I wanted but plenty of time to socialize. I never felt unsafe or not part of the group. 3) Food - I am a vegetarian (not vegan - I do eat eggs and dairy) and let them know ahead of time. Really the only thing I couldn't eat was the bacon and egg sandwich for breakfast and the BBQ chicken, everything else was delicious and they had plenty of alternatives for me. 4) Is this trip good for kids? Definitely for older kids yes! There was only one kid on our trip (about 12 years old) and he had a blast. Trilogy's website says kids are welcome and encouraged and they were very safety conscious so I'm sure anyone would be fine. I think I would have been nervous bringing young kids under 5 years old because at times the boat was little rough (in the wind in the afternoon) and waves at any beach can get high (when you're heading out to snorkel). If you have kids who can swim well and listen to directions I think everyone would have a good time.

(5.0)
- Jun 2019 -

Sean P.

Went on the Discover Lana’i trip with Captain Turtle and Dan and Lol and Brent. This was by far one of if not the best excursion I had during my time at Maui. Very interactive crew that makes sure everyone is safe and accounted for and they are all super easy going and talkative. For me traveling solo amongst a bunch of couples and families this was what I consider to be “A+” hospitality. Food on the trip was good, drinks on the way back were good and the barbecue was great. You have to go see sweetheart rock and snorkel both were awesome, the island tour was also very informative and cool. All in all great trip, worth every penny!

(5.0)

Dani F.

Thank you for not canceling our reservation during these unpredictable times! We did the Molokini Express Snorkle. It was so much fun! Their photographer...

(5.0)

Myles F.

This review is incredibly overdue, but I have to thank Captain Jeff & Crew! My wife and I purchased the Discover Molokini tour and it turned out to be an...

(5.0)

Taryn S.

Trust in all the 5-star reviews! Fantastic! We did the Deluxe Sunset Sail that leaves from Kaanapali Beach and had the best time. January is whale season,...

(5.0)
Type Message Time
info routefilter::before start 1.9073486328125E-6
info routefilter::before cache cleared 0.0026910305023193
info routefilter::before got cookie 0.018469095230103
info routefilter::before end 0.018484115600586
rating start 0.94944906234741
rating end 0.94950294494629
rating start 0.96210312843323
rating end 0.96213507652283
rating start 0.97397494316101
rating end 0.97400593757629
rating start 0.98610496520996
rating end 0.98614096641541
rating start 0.99665594100952
rating end 0.9966869354248
rating start 0.99743390083313
rating end 0.99746704101562
rating start 0.9985499382019
rating end 0.99858498573303
rating start 0.999342918396
rating end 0.99937701225281
rating start 1.0000019073486
rating end 1.0000169277191
rating start 1.0006079673767
rating end 1.0006220340729
rating start 1.0012860298157
rating end 1.0013020038605
Time Query
0.65ms
INSERT INTO `sessions` (`source`, `campaign`, `ad_group`, `keyword`, `landing_page`, `device`, `match_type`, `position`, `referer`, `reseller_id`, `user_agent`, `ip_address`, `updated_at`, `created_at`) VALUES ('direct', '', '', '', 'tour/show/discover_lanai', '', '', '', '', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '3.226.241.176', '2020-09-18 07:23:20', '2020-09-18 07:23:20')
0.44ms
UPDATE `sessions` SET `campaign` = '', `ad_group` = '', `device` = '', `match_type` = '', `referer` = '', `reseller_id` = '', `updated_at` = '2020-09-18 07:23:20', `visits` = '1' WHERE `id` = '1345337'
0.36ms
SELECT * FROM `category_tours` WHERE `url_name` = 'discover_lanai' LIMIT 1
0.09ms
SELECT `images`.*, `category_tour_images`.`id` AS `pivot_id`, `category_tour_images`.`created_at` AS `pivot_created_at`, `category_tour_images`.`updated_at` AS `pivot_updated_at`, `category_tour_images`.`category_tour_id` AS `pivot_category_tour_id`, `category_tour_images`.`image_id` AS `pivot_image_id` FROM `images` INNER JOIN `category_tour_images` ON `images`.`id` = `category_tour_images`.`image_id` WHERE `category_tour_images`.`category_tour_id` = '25'
0.13ms
SELECT * FROM `categories` WHERE `staging` = '1'
0.13ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC
0.12ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.08ms
SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `category_tour_id` = '25'
0.12ms
SELECT * FROM `reviews` WHERE `category_tour_id` = '25'
0.19ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.09ms
SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `vendor_id` = '8'
0.15ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.32ms
SELECT `category_tours`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_id` AS `pivot_category_id`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id` FROM `category_tours` INNER JOIN `tour_categories_new` ON `category_tours`.`id` = `tour_categories_new`.`category_tour_id` WHERE `tour_categories_new`.`category_id` = '8' AND `active` = '1'
0.23ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.27ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.26ms
SELECT * FROM `vendors` WHERE `id` = '19' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '18' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '23' LIMIT 1
0.15ms
SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1
0.11ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.11ms
SELECT * FROM `vendors` WHERE `id` = '135' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '126' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '141' LIMIT 1
0.11ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.11ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.14ms
SELECT * FROM `vendors` WHERE `id` = '143' LIMIT 1
0.15ms
SELECT * FROM `vendors` WHERE `id` = '143' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '143' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '148' LIMIT 1
0.14ms
SELECT * FROM `vendors` WHERE `id` = '152' LIMIT 1
0.14ms
SELECT * FROM `vendors` WHERE `id` = '130' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.16ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.14ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '171' LIMIT 1
0.11ms
SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1
0.09ms
SELECT * FROM `images` WHERE `id` = '563' LIMIT 1
0.13ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '26' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '26' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '26' LIMIT 1
0.10ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '26' LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '26' LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '26' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.10ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '26' LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '26' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '26' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.07ms
SELECT * FROM `images` WHERE `id` = '604' LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '36' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '36' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '36' LIMIT 1
0.12ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '36' LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '36' LIMIT 1
0.12ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '36' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '36' LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '36' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '36' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.07ms
SELECT * FROM `images` WHERE `id` = '761' LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '47' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '47' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '47' LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '47' LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '47' LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '47' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.10ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '47' LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '47' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '47' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT * FROM `images` WHERE `id` = '596' LIMIT 1
0.14ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.10ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.10ms
SELECT `tags`.*, `category_tour_tags`.`id` AS `pivot_id`, `category_tour_tags`.`created_at` AS `pivot_created_at`, `category_tour_tags`.`updated_at` AS `pivot_updated_at`, `category_tour_tags`.`category_tour_id` AS `pivot_category_tour_id`, `category_tour_tags`.`tag_id` AS `pivot_tag_id`, `category_tour_tags`.`reason` AS `pivot_reason`, `category_tour_tags`.`category_tour_id` AS `pivot_category_tour_id`, `category_tour_tags`.`tag_id` AS `pivot_tag_id` FROM `tags` INNER JOIN `category_tour_tags` ON `tags`.`id` = `category_tour_tags`.`tag_id` WHERE `category_tour_tags`.`category_tour_id` = '25' AND `category_tour_tags`.`active` = '1'
0.08ms
SELECT * FROM `category_tour_tags` WHERE `tag_id` = '13' AND `category_tour_id` = '25' LIMIT 1
0.10ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '25' AND `active` = '1' ORDER BY `value` ASC
0.11ms
SELECT `options`.*, `tour_options`.`id` AS `pivot_id`, `tour_options`.`created_at` AS `pivot_created_at`, `tour_options`.`updated_at` AS `pivot_updated_at`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id`, `tour_options`.`price` AS `pivot_price`, `tour_options`.`active` AS `pivot_active`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id` FROM `options` INNER JOIN `tour_options` ON `options`.`id` = `tour_options`.`option_id` WHERE `tour_options`.`category_tour_id` = '25' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC
0.13ms
SELECT `options`.*, `tour_options`.`id` AS `pivot_id`, `tour_options`.`created_at` AS `pivot_created_at`, `tour_options`.`updated_at` AS `pivot_updated_at`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id`, `tour_options`.`price` AS `pivot_price`, `tour_options`.`active` AS `pivot_active`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id` FROM `options` INNER JOIN `tour_options` ON `options`.`id` = `tour_options`.`option_id` WHERE `tour_options`.`category_tour_id` = '25' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC
0.12ms
SELECT `options`.*, `tour_options`.`id` AS `pivot_id`, `tour_options`.`created_at` AS `pivot_created_at`, `tour_options`.`updated_at` AS `pivot_updated_at`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id`, `tour_options`.`price` AS `pivot_price`, `tour_options`.`active` AS `pivot_active`, `tour_options`.`category_tour_id` AS `pivot_category_tour_id`, `tour_options`.`option_id` AS `pivot_option_id` FROM `options` INNER JOIN `tour_options` ON `options`.`id` = `tour_options`.`option_id` WHERE `tour_options`.`category_tour_id` = '25' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC
0.08ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '1' AND `active` = '1'
0.09ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '2' AND `active` = '1'
0.07ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '3' AND `active` = '1'
0.07ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '4' AND `active` = '1'
0.08ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '5' AND `active` = '1'
0.07ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '6' AND `active` = '1'
0.08ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '8' AND `active` = '1'
0.07ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '11' AND `active` = '1'
0.09ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '12' AND `active` = '1'
0.07ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '13' AND `active` = '1'
0.07ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '25' LIMIT 1
0.07ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '25' LIMIT 1
0.06ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '25' LIMIT 1
0.06ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '25' LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.13ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '25' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '25' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'luau_and_shows' LIMIT 1
0.08ms
SELECT * FROM `categories` WHERE `url_name` = 'snorkel_and_diving' LIMIT 1
0.13ms
SELECT * FROM `categories` WHERE `url_name` = 'helicopter' LIMIT 1
0.10ms
SELECT * FROM `categories` WHERE `url_name` = 'zipline' LIMIT 1
0.07ms
SELECT * FROM `categories` WHERE `url_name` = 'sunset_cruise' LIMIT 1
0.07ms
SELECT * FROM `categories` WHERE `url_name` = 'scenic_tour' LIMIT 1
0.07ms
SELECT * FROM `categories` WHERE `url_name` = 'downhill_biking' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'hiking' LIMIT 1
0.08ms
SELECT * FROM `categories` WHERE `url_name` = 'whale_watching' LIMIT 1
0.07ms
SELECT * FROM `categories` WHERE `url_name` = 'adventure' LIMIT 1