2 Hour Molokini Express

(4.4)
$60
Ages 4 and up
We can?t accommodate pregnant passengers, fragile elderly, or those with back or neck problems. And there are no wheel chair accommodations or provisions for service animals.
Why We Love It -  Perfect for snorkelers who like to sleep in. This ride gets you to Molokini after the crowds have left.

Enjoy an incredibly safe, fast and affordable snorkeling adventure. Avoid the crowds and sleep in; this tour leaves at 11:30 am! 


If you want to enjoy seeing abundant marine life and have fun in the clear water at Molokini but would rather not spend the entire day out there, this tour is perfect for you. Since the tour leaves later in the morning, you avoid all the large tour boats. Typically you have the crater to yourself!


Molokini is a partially-submerged, crescent-shaped volcanic crater. It is located between Kaho'olawe and Maui. You will snorkel the outer and inner reef of Molokini depending on the weather conditions (see important note below). You will find tropical fish almost everywhere. Awesome visibility, shafts of radiant light, steep drop-offs and towering cliffs make this snorkeling destination extremely unique.

Our powerful rafts will get you to the crater in about fifteen minutes. You will be briefed and equipped with our top-of-the-line snorkeling gear. And enjoy more than an hour of thrilling snorkel time at this stunning location.

A spectacular and popular drift is near the outer reef, which is about three feet in depth at certain points, but then suddenly drops off to about 200 feet. As you glide over this reef you feel like you are flying. This area of the crater may remind you of an abyss because the wall eventually plunges to depths of about 300 feet to 400 feet.


Important note: The Hawaiian trade winds, responsible for our lovely weather year round also can make for choppy seas. Occasionally, the trade winds are quite strong - in that case, we'll stay on the backside of the crater, sheltered from the wind for crystal clear serene water. In very rare cases, the wind may be too strong to visit Molokini and a favorable, shoreline alternative will be selected. Not to worry, in this rare case there are so many other stunning snorkeling spots, you will not be disappointed. Since the rafts are very fast with a shallow draft, you'll be able to access spots the big boats can't get to.

The Ride
Blue Water Rafting has been offering a variety of high adventure snorkeling and sightseeing tours since early 1985. Due to the range of sea conditions encountered and the lively nature of the ride, these tours are not recommended for people with limiting physical conditions. People with previous or current back or neck injuries, recent major surgeries, or are pregnant, should not book the tour and will not be allowed on board.


Our Rafts
Our fast, stable, unsinkable, rigid hull, inflatable rafts carry up to 24 passengers and are powered by environmentally friendly, smoke-free, twin Honda 4 stroke 225 HP outboard motors. Parties wishing to guarantee a particular boat may opt for a private charter. All boats have easy boarding ladders and have approximately 60% shaded canopies.

more
Time 11:30 am
Duration 2 hours
Location Kihei Boat Landing

Please view the cancellation policy and restrictions. You can find addition information in frequently asked questions

Cancellation Policy

100% refundable if cancelled at least 48 hours before check-in. Changes or cancellations should be made through the modify or cancel buttons on your booking confirmation.


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

No pregnant passengers or those with back or neck problems. No Children under 4 years of age; adult supervision required for those under 12. No wheel chair accommodations or service animals.


Frequently Asked Questions

Do You Accommodate People With Disabilities?
Unfortunately this may not be the tour for you.  We can?t accommodate pregnant passengers, fragile elderly, or those with back or neck problems. And there are no wheel chair accommodations or provisions for service animals.

What Kind Of Rafts Do You Use?
Our fast, stable, unsinkable, rigid hulled, inflatable boats are all powered with environmentally friendly, smoke free, twin Honda 4 stroke 225 HP outboard motors. CLOUD IX is a 27? ALMAR RAIV carrying up to 24 passengers KANALOA and PINEAPPLE EXPRESS, are 30? ALMAR RAIVs also carrying up to 24 passengers. Parties wishing to guarantee a particular boat may opt for a private charter. All boats have easy boarding ladders and are approx. 60% shaded by canopies.

Is There A Minimum Age Requirement?
Child age limit: 4 years minimum. (adult supervision required under 12) Children under 4 years may be accommodated on Private Charters (no infants).

What Is Your Policy Regarding Weather?
Tours depart rain or shine. Inclement weather conditions are usually temporary and rain gear is provided. Cancellations due to weather are extremely uncommon and all parties are instructed to appear at the boat ramp no matter what the weather seems to them.These tours are best reserved for those who are adventurous in spirit and in reasonably good physical condition. Destinations are weather permitting and alternate sites may be chosen. However, it is rare for us not to reach our destination whether it be Molokini or Kanaio. If the captain deems the conditions to be unsafe for departure, a full refund will apply. No shows are non-refundable.

Is Breakfast and/or Lunch Included?
On tours less than 3 hours, only beverages are included. For longer tours, lunch is deli style consisting turkey and roast beef, veggies & dip, cheddar and Swiss cheeses, whole wheat buns, and condiments with a delicious homemade style chocolate chip cookie. Beverages are Hawaiian fruit juices and bottled water. Breakfast on the Kanaio/ Molokini consists of assorted fresh island fruit, muffins, Hawaiian fruit juices, and bottled water. Kanaio Coast Tour has a fruit and beverage break between sightseeing and snorkeling.PLEASE NOTE: No alcohol allowed on board.


Reviews

Review Summary
(4.4)
show reviews  hide reviews 

- May 2019 -

jeffvandyk

We just came back from a Molokini express snorkeling trip and had a great time. Tim and Laura were great guides and we had a blast. Especially the ride back through the choppy water.

(5.0)
- Sep 2019 -

SteveG63368 O'fallon, Missouri

We did the 2 hour Express Molokini Snorkel trip with Captain Tim and Spencer. They were a lot of fun and answered every question. They are very knowledgeable about the area. This is by far the best way to snorkel Molokini!!! After a fast, fun ride out, you arrive at the reef to find it all to yourselves as the big boats have all returned to the docks. You have plenty of time to drift along and take it all in. I was even lucky enough to spot an octopus at the end of the swim.

(5.0)
- Aug 2019 -

jopunks1112

Had a great trip on the Molokini Express. Quick ride straight out to Molokini with a small group of people, which was the perfect atmosphere. The snorkeling was fantastic and really special. I'd never seen a coral reef so close before, so I was really excited to see all the amazing fish and we had a good amount of time to explore! Crew are super friendly, helpful and very knowledgeable about the island & happy to answer any questions. They were helpful getting us all get back into the boat and super attentive. Was also grateful that our group had a good sense of humor and there were lots of laughs on the way back when getting splashed by the waves. I will have fond lasting memories of this trip. Thank you 2 Hour Molokini Express!

(5.0)

Brenda A.

BEST TIME EVER! I was lucky enough to get the last seat on a 6-person Express raft to snorkel Molokini and do a whale watch. First, the guides were...

(5.0)

Vivian C.

My boyfriend and I went on the kamaaina snorkeling trip with Shane and he was SO much fun! It was only us three on the boat due to Covid and shane made sure...

(5.0)

Amy J.

We did this whale watching boat ride on Maui! Mark the owner was our captain and his jokes were fantastic. Very laid back ride. They got us as close as we...

(5.0)
Type Message Time
info routefilter::before start 2.1457672119141E-6
info routefilter::before cache cleared 0.0047421455383301
info routefilter::before got cookie 0.027469158172607
info routefilter::before end 0.027485132217407
rating start 1.143383026123
rating end 1.1434462070465
rating start 1.1645610332489
rating end 1.1646101474762
rating start 1.1851961612701
rating end 1.1852471828461
rating start 1.2022211551666
rating end 1.2022500038147
rating start 1.2128779888153
rating end 1.2129080295563
rating start 1.2136571407318
rating end 1.2136900424957
rating start 1.2143821716309
rating end 1.2144150733948
rating start 1.2151010036469
rating end 1.2151319980621
rating start 1.2157440185547
rating end 1.2157590389252
rating start 1.2163860797882
rating end 1.2164001464844
rating start 1.2170209884644
rating end 1.2170391082764
Time Query
0.88ms
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/2_hour_molokini_express', '', '', '', '', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '3.235.107.209', '2020-08-08 13:01:52', '2020-08-08 13:01:52')
0.98ms
UPDATE `sessions` SET `campaign` = '', `ad_group` = '', `device` = '', `match_type` = '', `referer` = '', `reseller_id` = '', `updated_at` = '2020-08-08 13:01:52', `visits` = '1' WHERE `id` = '1301735'
0.57ms
SELECT * FROM `category_tours` WHERE `url_name` = '2_hour_molokini_express' LIMIT 1
0.19ms
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` = '161'
0.21ms
SELECT * FROM `categories` WHERE `staging` = '1'
0.21ms
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` = '161' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC
0.17ms
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` = '161' LIMIT 1
0.12ms
SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `category_tour_id` = '161'
0.20ms
SELECT * FROM `reviews` WHERE `category_tour_id` = '161'
0.25ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.12ms
SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `vendor_id` = '138'
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` = '161' LIMIT 1
0.38ms
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.21ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '19' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '18' LIMIT 1
0.16ms
SELECT * FROM `vendors` WHERE `id` = '23' LIMIT 1
0.16ms
SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1
0.21ms
SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '122' LIMIT 1
0.24ms
SELECT * FROM `vendors` WHERE `id` = '8' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '135' LIMIT 1
0.27ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '138' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '126' LIMIT 1
0.26ms
SELECT * FROM `vendors` WHERE `id` = '141' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.21ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '142' LIMIT 1
0.21ms
SELECT * FROM `vendors` WHERE `id` = '143' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '143' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '143' LIMIT 1
0.21ms
SELECT * FROM `vendors` WHERE `id` = '148' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '152' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '130' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '165' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '171' LIMIT 1
0.21ms
SELECT * FROM `vendors` WHERE `id` = '149' LIMIT 1
0.23ms
SELECT * FROM `images` WHERE `id` = '596' LIMIT 1
0.21ms
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.20ms
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.19ms
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.19ms
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.18ms
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.20ms
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.19ms
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.20ms
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.20ms
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.14ms
SELECT * FROM `images` WHERE `id` = '563' LIMIT 1
0.20ms
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.20ms
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.18ms
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.17ms
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.17ms
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.22ms
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.18ms
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.20ms
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.20ms
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.16ms
SELECT * FROM `images` WHERE `id` = '604' LIMIT 1
0.21ms
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.21ms
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.18ms
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.18ms
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.17ms
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.19ms
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.17ms
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.23ms
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.20ms
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.23ms
SELECT * FROM `images` WHERE `id` = '3005' LIMIT 1
0.26ms
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` = '161' 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` = '161' 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` = '161' 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` = '161' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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` = '161' 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` = '161' 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` = '161' 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` = '161' AND `category_tour_tags`.`active` = '1'
0.10ms
SELECT * FROM `category_tour_tags` WHERE `tag_id` = '13' AND `category_tour_id` = '161' LIMIT 1
0.12ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '161' AND `active` = '1' LIMIT 1
0.10ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '161' AND `active` = '1' LIMIT 1
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` = '161' 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` = '161' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC
0.10ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '1' AND `active` = '1'
0.08ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '2' AND `active` = '1'
0.08ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '3' AND `active` = '1'
0.08ms
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.08ms
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.13ms
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.09ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '13' AND `active` = '1'
0.09ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '161' LIMIT 1
0.09ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '161' 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` = '161' 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` = '161' 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` = '161' 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` = '161' 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` = '161' 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` = '161' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.14ms
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` = '161' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'luau_and_shows' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'snorkel_and_diving' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'helicopter' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'zipline' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'sunset_cruise' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'scenic_tour' LIMIT 1
0.14ms
SELECT * FROM `categories` WHERE `url_name` = 'downhill_biking' LIMIT 1
0.14ms
SELECT * FROM `categories` WHERE `url_name` = 'hiking' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'whale_watching' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'adventure' LIMIT 1