Ultimate 9-Line Zip & Dip

(5.0)
$190

Maui's only Zip n' Dip tour!


Experience the ultimate Zipline tour on our 9 line adventure including Maui's only Zip n' Dip line, allowing you to splash into a natural mountain pool. Race your family or friends on our double racing line while enjoying sweeping views of the Pacific Ocean, offshore islands and West Maui Mountains. Book early as this tour fills up fast!


Guests zip 8 lines including 5 lines from the Ka'anapali adventure course, voted the #1 zipline course in Hawaii and then arrive at the Zip n' Dip line into a mountain pool to enjoy one hour of water line fun.

TOUR HIGHLIGHTS
  • Ziplines: 8 ziplines plus zip n' dip experience (or 3 plus zip n' dip experience if you choose our shortened adventure) stretch over Ka?anapali?s remote coastal landscape and open up views of untouched Hawaiian lands and miles of blue Pacific ocean.  
  • Mountain Pool Zipline: Spend time enjoying our open water zipline and paddle boards in a refreshing mountain pool that overlooks Ka?anapali?s Pacific coast line. Includes unlimited zipping on the Zip n' Dip experience. 
  • Double Racing Line: Challenge your spouse, brother, sister, friend or foe to a side-by-side race down our Ka?anapali double line.
  • A Cultural Experience: Our terrific guides will uncover Hawaii?s rich history and keep you laughing most of the tour?it's a fully Hawaiian experience.
COURSE DETAILS

  • Line R: The Dip Line - Enjoy splashing into a fresh mountain pool from Maui's only Zip n' Dip zipline   
  • Line U1: Molokini & Kaho'olawe - Named after Maui's offshore Islands, Molokini and Kaho'olawe, our double racing line will give you a thrilling experience and view! 
  • Line U2: Molokai - Named after Molokai, a beautiful Island view-able offshore, this line is fast and fun!
  • Line U3: Lanai - The Island of Lanai is located directly offshore from Maui and was known as the Pineapple Island in it's past history.  Enjoy amazing views of Lanai from this line on our tour. 
  • Line 4: Wainee - Line 4 opens up views of the Pacific Ocean and the small unpopulated island of Kaho?olawe.Wainee: The name Waine'e means "creeping water". This area is the location of another historically significant place - Moku'ula, or Sacred Island, was a historical and spiritual center of Hawaii and is where Kamehameha III made his home for many years
  • Line 5: Panaewa - Fly 150 feet into the air on the highest line of the tour. Panaewa: The name Panaewa translates to "west side games." David Malo, the noted Hawaiian historian, is buried high in this area. Pu'u Kukui is home to at least 17 endangered species, including koa'ia and a very rare type of geranium.
  • Line 6: Paunau - Get a running start and leap into the air from the takeoff platform of  line 6.Paunau: The name Paunau translates to "the food has been chewed".  At the base of the Paunau ahupua'a is the Hauola stone. Hawaiians believed this to be a healing rock, upon which one could sit, dangle their feet in the water and let the waves wash over them, and by doing so, regain their health.
  • Line 7: Wahikuli - Take a ?trust zip? and let the guides help you zip across line seven backwards. Wahikuli: Wahikuli translates to "a noisy place", but despite the name, you're sure to be far away from anything too noisy. Much like all of the regions in the Lahaina moku, Wahikuli is an area with a lot of historical significance. Legend has it that Pu'u Laina was the first place the Pele, the volcano goddess, appeared on Maui.
  • Line 8: Hanakao'o - The hike from line 7 to 8 opens up some of the most spectacular views of the entire course.Hanakao'o: The name Hanakao'o means "to work with an o'o". An o'o was a long tool used, in ancient times, to plant sweet potatoes and other crops. In this area can be found Pu'u Keka'a, which is known as 'Uhane lele, or Soul Leaping Place of Maui. 
more
Time 9:30am
Please arrive 30 minutes prior to your scheduled tour time.
Duration 4.5 hours
Location Ka'anapali

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

Cancellation Policy

We have a generous cancellation policy.  24 hours or more before your tour and you will receive a 100% refund.  Less than 24 hours, no refund. 


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

  1. Customers MUST be 10 years or older, all customers under 18 must have a legal guardian sign for them.
  2. Customers MUST weigh between 80 & 260 lbs. This Policy is STRICTLY ENFORCED, for your own safety. Customers will be weighed on site if there are questions and WILL NOT be provided a refund if they are outside the limits.
  3. Customers MUST be physically able to hike 1 to 2 miles at elevation over uneven terrain.
  4. Customers with serious neck, back, or joint injuries or Chronic heart problems should use their own discretion about their capabilities to safely participate in this activity. It is STRONGLY RECOMMENDED that anyone with who has had recent surgery, especially on ankles, knees or their back, not participate in this tour. Although we try to always make customers comfortable both physically and mentally, some degree of impact on joints or some degree of customer anxiety about zipping is unavoidable.
  5. Customers MUST NOT have been scuba diving within 24 hours of scheduled tour time.
  6. All customers are REQUIRED to sign a release and waiver of liability prior to taking the tour.
  7. You must not be pregnant.
  8. Absolutely NO SMOKING is allowed on tour.


Frequently Asked Questions

What time do we need to check in for our tour?
We do require everyone to arrive (30) minutes prior to their tour time.

Where do we check in?
We have a check-in office at the Fairway Shops in Ka'anapali for our Ka'anapali tours and Ka'anapali Zip n' Dip tour. Driving directions are included with your confirmation email.

I have hiking-style sandals - can I wear those?
For your safety, we require that you wear shoes with a fully enclosed heel and toe - tennis/athletic shoes or hiking type shoes are best. No hiking sandals, Teva's, Keene's, Crocs, Tom's, Vibram FiveFinger shoes or Skecher Shapers allowed on the course.  Shoes must be snug to your foot, no loose fitting or un-laced Converse style shoes allowed.

Do I have to wear long pants?
No, but they tend to be more comfortable when wearing a harness and are recommended.

Can I bring my camera/phone?
Yes, you may bring your camera/phone along to snap photos along the way. Your guides will also take many photos of you zipping. All the pictures from your tour will be available for $15. You can also rent a Go-Pro camera.

How good of shape do I need to be in?
Ziplining isn't strenuous, but you need to be able to hike about 1/2 mile and climb steps. We have had people from age 10 to 100 do the course without problems.

Is there an age requirement?
Guests MUST be 10 years or older. Anyone under the age of 18 will be required to have a completed waiver and have a responsible adult sign the form for them.

I'm going scuba-diving the day before my tour, is that ok?
Customers MUST NOT have been scuba diving within 24 hours of scheduled tour time for all courses.

What's the cancellation policy?
We have a generous cancellation policy. 24 hours or more before your tour and you will receive a 100% refund. Less than 24 hours, no refund. 

Are there any health issues I should consider?
Customers with serious neck, back, or joint injuries or chronic heart problems should use their own discretion about their capabilities to safely participate in this activity. It is STRONGLY RECOMMENDED that anyone with who has had recent surgery, especially on ankles, knees or their back, not participate in this tour. Although we try to always make customers comfortable both physically and mentally, some degree of impact on joints or some degree of customer anxiety about zipping is unavoidable.

Are there weight restrictions?
Customers MUST weigh between 80 & 260 lbs. This Policy is STRICTLY ENFORCED, for your own safety. All participants will be weighed at check in and those that do not comply will not be allowed to zip and no refunds will be issued.

Is ziplining safe?
Safety is our top priority, and it shows. Over 3 million zipline crossings - we've set the industry standard in zip lining safety. All equipment is tested to hold at least 5,000 lbs. Each zipline has a minimum breaking strength of over 26,000 lbs.

Sophisticated engineering
From concept to design to installation, we work closely with Glynn Geotechnical Engineering to develop our zipline courses. Glynn is an internationally recognized firm, licensed in 46 States for structural and geotechnical engineering work, and recognized as the leader in the Aerial Adventure engineering industry.
Thoroughly trained guides
We believe that your safety starts with guides that have a comprehensive understanding of the ziplining industry and safety best practices.Each of our guides go through an 80-hour training process, and a period of ?assistant guiding??a time where ?junior? guides are paired up with more experienced guides to get on-course training and experience. The industry standard for this process is a short 40-hour training process.
Daily course inspections, yearly professional inspections
Every day, our trained staff thoroughly inspects all the ziplines, platforms, trails, and equipment of each course. And at least once a year an accredited ACCT inspector conducts a comprehensive review of each course, equipment, and all current practices.

Do my parents or guardian have to zip with me if I am under age 18?
Kids 15-17 years old need an adult signature on their waiver but can take part in our tours without an adult in their group on tour EXCEPT for Ka'anapali Zip n' Dip tours! 
Example: 15 & 16 year old friends can zip without a parent or adult in their party as long as they have an adult sign the waiver for them at check-in first.Kids 14 years and younger need to have an adult on tour with them and an adult must sign the waiver for each child. The adult can be a parent, relative, or friend and must be 18 years or older.
Example: 14 & 17 year old siblings need an adult or 18 year old to zip as part of their group, in addition to having an adult sign the waiver for them.  (Note if it were just the 17 year old, they could go with just an adult signature on their waiver - but because they have a 14 year old in the group they also need an adult to zip as part of their group)
Ka'anapali Zip n' Dip tours: Requires 1 adult to participate with each party regardless of the age of the minors.
Example: Jones party of 2 (15 and 16 year old's) cannot go on 4 line Zip n' Dip without their 18 year old sibling or another adult.


Reviews

Review Summary
(5.0)
show reviews  hide reviews 

- Oct 2018 -

GSWRD510

We booked an 8-line Zip course for the Ka'anapali location. You meet at the store front, then two of the guides (ours were Gavin and Bobo) drive you up the mountside in a 15-person van. The van ride up the mountain is about 20 mins one way. It is an EXTREMELY bumpy ride due to the rough terrain. Part of the experience I guess. You stop halfway to put on the gear and to store away your belongings. They also provide you with a small fannypack so that you can bring your phone/camera/other small things. Definitely wear closed toe shoes, there is a bit of hiking (easy hiking) involved as you go from zip line tower to zip line tower. Some of the zip line towers are connected, others require you to hike for a few minutes to the next tower. Our guides were funny, shared local restaurant knowledge with us, and overall provided a bit of comedic relief/entertainment. The zip line process is very safe and secure, I never felt nervous about my safety. Next time I'm trying the 11-line one!

(5.0)
- Oct 2018 -

maggiejuengst

My husband and I went on the 8 line zipline for our honeymoon. We had Jesse and Shawn and they were seriously amazing! They made the experience so fun. The road up to the ziplining was very very bumpy but nothing crazy, after that its all fun and walking to the different lines. Would definitely recommend Jesse and Shawn and this place

(5.0)
- Sep 2018 -

Sonia P

My husband and I chose the 8-line zip-line tour during our stay in Maui. This was our first time zip-lining, so we didn't really know what to expect. We were both a little nervous about it initially, but in the end we had so much fun! Our guides Bobo and Kevin were hilarious! They were cracking jokes the whole time, making our whole group feel at ease and getting us excited. They always prioritized safety, and they were there to send us off and catch us every step of the way. They also were very knowledgeable about the island and its history. Additionally, the staff at the main office was very friendly. You can tell that everyone enjoys what they're doing, which makes you more excited about the experience. The ziplining was over a valley with beautiful views of the island. With each line, you could see most of Ka'anapali, the ocean, and Lanai in the distance. Definitely wear comfortable clothes that you don't mind getting dirty, because the natural red dirt will get all over. You're also able to bring your phone/camera with you to capture all the views as well as some great action shots of the actual ziplining. Overall, it was a memorable experience, and we would definitely do it again!

(5.0)

Krystal A.

First experience zip-lining and it was a blast! The west side views of Maui were amazing. Our guides, Manny and Kaleb, really made our experience fun,...

(5.0)

Wayne E.

Well I have been wanting to try ziplining for a long time we were in Maui...so now was the time! The wife and I walked in and were met by Patrick, very...

(5.0)

Mariah S.

Wow, what a day we had with Ultimate 9-Line Zip & Dip! We went for the longer, 11-line zip and started at 7:30am. The trip up to the top of the mountain itself was quite an...

(5.0)
Type Message Time
info routefilter::before start 1.9073486328125E-6
info routefilter::before cache cleared 0.0021178722381592
info routefilter::before got cookie 0.016435861587524
info routefilter::before end 0.016445875167847
rating start 0.91907382011414
rating end 0.91914200782776
rating start 0.9405369758606
rating end 0.94058895111084
rating start 0.96144700050354
rating end 0.96149897575378
rating start 0.98047304153442
rating end 0.98052787780762
rating start 1.0034339427948
rating end 1.003485918045
rating start 1.0048289299011
rating end 1.0049028396606
rating start 1.0061550140381
rating end 1.0062160491943
rating start 1.0075199604034
rating end 1.0075778961182
rating start 1.0087108612061
rating end 1.0087380409241
rating start 1.0099339485168
rating end 1.0099730491638
rating start 1.011855840683
rating end 1.0118989944458
Time Query
0.66ms
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/ultimate_9-line_zip_dip', '', '', '', '', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '3.236.108.61', '2020-07-03 07:40:38', '2020-07-03 07:40:38')
0.60ms
UPDATE `sessions` SET `campaign` = '', `ad_group` = '', `device` = '', `match_type` = '', `referer` = '', `reseller_id` = '', `updated_at` = '2020-07-03 07:40:38', `visits` = '1' WHERE `id` = '1263761'
0.35ms
SELECT * FROM `category_tours` WHERE `url_name` = 'ultimate_9-line_zip_dip' LIMIT 1
0.13ms
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` = '79'
0.13ms
SELECT * FROM `categories` WHERE `staging` = '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` = '79' 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` = '79' LIMIT 1
0.11ms
SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `category_tour_id` = '79'
0.16ms
SELECT * FROM `vendors` WHERE `id` = '1' LIMIT 1
0.06ms
SELECT COUNT(*) AS `aggregate` FROM `reviews` WHERE `vendor_id` = '1'
0.08ms
SELECT * FROM `reviews` WHERE `vendor_id` = '1'
0.26ms
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` = '79' LIMIT 1
0.41ms
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` = '1' AND `active` = '1'
0.24ms
SELECT * FROM `vendors` WHERE `id` = '1' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '15' LIMIT 1
0.24ms
SELECT * FROM `vendors` WHERE `id` = '1' LIMIT 1
0.19ms
SELECT * FROM `vendors` WHERE `id` = '15' LIMIT 1
0.22ms
SELECT * FROM `vendors` WHERE `id` = '1' LIMIT 1
0.23ms
SELECT * FROM `vendors` WHERE `id` = '1' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '146' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '147' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '147' LIMIT 1
0.24ms
SELECT * FROM `vendors` WHERE `id` = '147' LIMIT 1
0.19ms
SELECT * FROM `vendors` WHERE `id` = '164' LIMIT 1
0.19ms
SELECT * FROM `vendors` WHERE `id` = '1' LIMIT 1
0.17ms
SELECT * FROM `images` WHERE `id` = '2818' LIMIT 1
0.18ms
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` = '31' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.16ms
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` = '31' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.16ms
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` = '31' LIMIT 1
0.16ms
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` = '31' LIMIT 1
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` = '31' 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` = '31' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.21ms
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` = '31' 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` = '31' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.18ms
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` = '31' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.18ms
SELECT * FROM `images` WHERE `id` = '939' LIMIT 1
0.17ms
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` = '96' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.16ms
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` = '96' 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` = '96' LIMIT 1
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` = '96' 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` = '96' LIMIT 1
0.18ms
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` = '96' 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` = '96' LIMIT 1
0.17ms
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` = '96' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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` = '96' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT * FROM `images` WHERE `id` = '4898' LIMIT 1
0.16ms
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` = '98' 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` = '98' 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` = '98' 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` = '98' LIMIT 1
0.34ms
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` = '98' LIMIT 1
0.18ms
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` = '98' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.21ms
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` = '98' LIMIT 1
0.18ms
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` = '98' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.15ms
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` = '98' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.19ms
SELECT * FROM `images` WHERE `id` = '632' 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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.17ms
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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
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` = '79' 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` = '79' LIMIT 1
0.17ms
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` = '79' AND `category_tour_tags`.`active` = '1'
0.18ms
SELECT * FROM `category_tour_tags` WHERE `tag_id` = '13' AND `category_tour_id` = '79' LIMIT 1
0.32ms
SELECT * FROM `vendor_info` WHERE `vendor_id` = '1' LIMIT 1
0.18ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '79' AND `active` = '1' ORDER BY `value` ASC
0.17ms
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` = '79' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC
0.16ms
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` = '79' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'tour' ORDER BY `layout` ASC
0.13ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '1' AND `active` = '1'
0.16ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '2' AND `active` = '1'
0.13ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '3' AND `active` = '1'
0.19ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '4' AND `active` = '1'
0.11ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '5' AND `active` = '1'
0.11ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '6' AND `active` = '1'
0.13ms
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.13ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '12' AND `active` = '1'
0.11ms
SELECT COUNT(*) AS `aggregate` FROM `category_tours` WHERE `category_id` = '13' AND `active` = '1'
0.11ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '79' LIMIT 1
0.13ms
SELECT * FROM `tour_blackout` WHERE `category_tour_id` = '79' LIMIT 1
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` = '79' LIMIT 1
0.16ms
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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.16ms
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` = '79' 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` = '79' LIMIT 1
0.17ms
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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.18ms
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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.21ms
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` = '79' LIMIT 1
0.16ms
SELECT * FROM `categories` WHERE `url_name` = 'luau_and_shows' LIMIT 1
0.13ms
SELECT * FROM `categories` WHERE `url_name` = 'snorkel_and_diving' LIMIT 1
0.16ms
SELECT * FROM `categories` WHERE `url_name` = 'helicopter' LIMIT 1
0.13ms
SELECT * FROM `categories` WHERE `url_name` = 'zipline' LIMIT 1
0.19ms
SELECT * FROM `categories` WHERE `url_name` = 'sunset_cruise' LIMIT 1
0.16ms
SELECT * FROM `categories` WHERE `url_name` = 'scenic_tour' LIMIT 1
0.18ms
SELECT * FROM `categories` WHERE `url_name` = 'downhill_biking' LIMIT 1
0.14ms
SELECT * FROM `categories` WHERE `url_name` = 'hiking' LIMIT 1
0.18ms
SELECT * FROM `categories` WHERE `url_name` = 'whale_watching' LIMIT 1
0.16ms
SELECT * FROM `categories` WHERE `url_name` = 'adventure' LIMIT 1