East Maui Waterfalls

Details
Payment
Done!
 Book Another Tour

Thank you for booking!

You're going to have a great time!

Vendor Hike Maui
Tour East Maui Waterfalls
Date April 29, 2016
Time 9:30am 
Exact hotel pick-up times vary.
Passengers
Full Name Age Sandwich
1 Ben Holz 43 Gourmet Veggie Burger
2 Rachel Holz 41 Peanut Butter & Jelly
3 Adam Farren 32 Turkey
Duration 5 - 6 hours
Voucher 17883
Make Changes Cancel Booking

Details & Location

If you have any questions, please call us!

It's unusual for a rain forest valley to have this many waterfalls close together, so this is a popular spot on Maui's famous Hana Highway. But, since we know the owners well, we're the only tour company allowed in the valley. We hike 2.5 miles round trip to four or five waterfalls from 10 to 40 feet high. Great waterfalls, big, clear swimming pools, terrific bamboo and tropical rain forests, fresh-water streams. You may even jump off rock cliffs into the pools. It's fun and it's beautiful. And the waterfalls can't be beat.

This tour meets at the Kahului Park & Ride located at the intersection of Highway 311 & Highway 380 in Kahului. The Park & Ride meeting location is along a large concrete wall with a single row of parking.

If hotel transportation is selected, we will contact you at the number provided the day before your tour to confirm exact pick-up time.

What to bring

Hike Maui Provides:
· Backpack, rain gear, bug repellent, water, snacks and lunch
What to Wear:
· Sneakers or sports sandals · Shorts & T-shirt (clothes you don't mind getting dirty)
· Sunscreen
What to Bring:
· Swimsuit
· Towel
· Camera
· Light snacks, if you wish
· Cash, if you wish to tip your guide
· Adventurous attitude
Please see our frequently asked questions for more information.

Terms

If you need to cancel this tour, please call us at (808) 725 2220

Cancellation Policy

If you cancel 48 hours or more prior to the date of the event, you will receive a full refund less a 10% cancellation fee. If you cancel within 24 hours for any reason, you will receive no refund. If Hike Maui cancels (which we do for dangerous weather), you will receive a full 100% refund.

Restrictions

Age: minimum 6 years old.
You will be required to sign this Participation Agreement on the day of the hike.

You are about to cancel your booking!

Your seats will be released. If you just want to make some changes, please modify your booking

Modify your booking

Please let us know what you would like to change. If you want to cancel your booking, please click here

Type Message Time
info routefilter::before start 3.0994415283203E-6
info routefilter::before cache cleared 0.0025620460510254
info routefilter::before got cookie 0.020653009414673
info routefilter::before end 0.020669221878052
rating start 0.2868230342865
rating end 0.28685903549194
rating start 0.29858803749084
rating end 0.29861617088318
rating start 0.31192922592163
rating end 0.31196212768555
rating start 0.3262619972229
rating end 0.32629704475403
Time Query
0.67ms
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 ('confirmation', '', '', '', 'booking/confirmation/883/5715d6e0cfa1b', '', '', '', '', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '54.144.82.216', '2018-11-14 20:46:14', '2018-11-14 20:46:14')
0.49ms
UPDATE `sessions` SET `campaign` = '', `ad_group` = '', `device` = '', `match_type` = '', `referer` = '', `reseller_id` = '', `updated_at` = '2018-11-14 20:46:14', `visits` = '1' WHERE `id` = '456767'
0.59ms
SELECT * FROM `bookings` WHERE `id` = '883' LIMIT 1
0.09ms
SELECT * FROM `tours` WHERE `id` = '3' LIMIT 1
0.17ms
SELECT * FROM `vendors` WHERE `id` = '2' LIMIT 1
0.10ms
SELECT * FROM `customers` WHERE `id` = '275' LIMIT 1
0.72ms
UPDATE `bookings` SET `booking_customer_id` = '', `updated_at` = '2018-11-14 20:46:14', `a3h_id` = '', `dashboard` = '', `agent_id` = '', `special_notes` = '', `discount` = '', `tax_rate` = '', `views` = '182', `vendor_id` = '', `cleared` = '', `agent_source` = '', `reseller_id` = '', `no_commissions` = '', `discount_id` = '', `cancellation_confirmation` = '', `cancellation_source` = '', `cancellation_reason_old` = '', `cancellation_notes` = '', `pending_status` = '', `pending_timeout` = '', `cancellation_reason` = '', `vendor_host_id` = '', `contract_id` = '', `api_data` = '' WHERE `id` = '883'
83.87ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' AND `source` = 'vendor' AND `to` = 'customer' AND `resolved` IS NULL
84.61ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' AND `source` = 'agent' AND `to` = 'customer' AND `event_type` = 'note' AND `resolved` IS NULL AND `resolved` IS NULL
35.05ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' ORDER BY `created_at` DESC
6.40ms
SELECT * FROM `payments` WHERE `booking_id` = '883' ORDER BY `created_at` DESC LIMIT 1
0.31ms
SELECT * FROM `category_tours` WHERE `id` = '2' LIMIT 1
0.27ms
SELECT * FROM `category_tours` WHERE `banner` = 'popular' AND `id` != '2'
0.10ms
SELECT * FROM `images` WHERE `id` = '2379' 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` = '21' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '21' 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` = '21' 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` = '21' LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '21' 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` = '21' 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` = '21' LIMIT 1
0.13ms
SELECT * FROM `vendors` WHERE `id` = '5' 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` = '21' 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` = '21' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.07ms
SELECT * FROM `images` WHERE `id` = '3202' LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '39' 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` = '39' 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` = '39' 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` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '39' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '11' 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` = '39' 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` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.07ms
SELECT * FROM `images` WHERE `id` = '559' 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` = '55' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '55' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '55' LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '55' 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` = '55' 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` = '55' 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` = '55' LIMIT 1
0.12ms
SELECT * FROM `vendors` WHERE `id` = '24' 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` = '55' 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` = '55' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.07ms
SELECT * FROM `images` WHERE `id` = '632' LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '79' 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` = '79' LIMIT 1
0.13ms
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.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` = '79' 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` = '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.13ms
SELECT * FROM `vendors` WHERE `id` = '1' 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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.09ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.08ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '2' LIMIT 1
0.09ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '2' LIMIT 1
48.82ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' AND `event_type` = 'modify' AND `source` = 'customer' AND `to` = 'agent' ORDER BY `created_at` DESC
0.16ms
SELECT * FROM `vendors` WHERE `id` = '2' LIMIT 1
0.09ms
SELECT * FROM `booking_customers` WHERE `booking_id` = '883' LIMIT 1
0.11ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '2' AND `active` = '1'
0.10ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '2' AND `active` = '1'
0.09ms
SELECT * FROM `booking_options` WHERE `booking_id` = '883'
0.09ms
SELECT * FROM `options` WHERE `id` = '19' LIMIT 1
0.14ms
SELECT * FROM `option_values` WHERE `option_id` = '19' AND `value` = '3' LIMIT 1
0.09ms
SELECT * FROM `options` WHERE `id` = '7' LIMIT 1
0.16ms
SELECT * FROM `option_values` WHERE `option_id` = '7' AND `value` = 'Ben Holz' LIMIT 1
0.14ms
SELECT * FROM `options` WHERE `id` = '7' LIMIT 1
0.08ms
SELECT * FROM `option_values` WHERE `option_id` = '7' AND `value` = 'Rachel Holz' LIMIT 1
0.16ms
SELECT * FROM `options` WHERE `id` = '7' LIMIT 1
0.21ms
SELECT * FROM `option_values` WHERE `option_id` = '7' AND `value` = 'Adam Farren' LIMIT 1
0.14ms
SELECT * FROM `options` WHERE `id` = '3' LIMIT 1
0.09ms
SELECT * FROM `option_values` WHERE `option_id` = '3' AND `value` = '43' LIMIT 1
0.09ms
SELECT * FROM `options` WHERE `id` = '3' LIMIT 1
0.08ms
SELECT * FROM `option_values` WHERE `option_id` = '3' AND `value` = '41' LIMIT 1
0.09ms
SELECT * FROM `options` WHERE `id` = '3' LIMIT 1
0.13ms
SELECT * FROM `option_values` WHERE `option_id` = '3' AND `value` = '32' LIMIT 1
0.14ms
SELECT * FROM `options` WHERE `id` = '4' LIMIT 1
0.09ms
SELECT * FROM `option_values` WHERE `option_id` = '4' AND `value` = 'Gourmet Veggie Burger' LIMIT 1
0.09ms
SELECT * FROM `options` WHERE `id` = '4' LIMIT 1
0.09ms
SELECT * FROM `option_values` WHERE `option_id` = '4' AND `value` = 'Peanut Butter & Jelly' LIMIT 1
0.46ms
SELECT * FROM `options` WHERE `id` = '4' LIMIT 1
0.10ms
SELECT * FROM `option_values` WHERE `option_id` = '4' AND `value` = 'Turkey' LIMIT 1
0.14ms
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` = '2' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'passenger' 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` = '2' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'passenger' ORDER BY `layout` ASC
0.21ms
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` = '2' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'passenger' ORDER BY `layout` ASC
0.22ms
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` = '2' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'passenger' ORDER BY `layout` ASC
0.19ms
SELECT * FROM `vendor_info` WHERE `vendor_id` = '2' LIMIT 1
9.20ms
SELECT `passenger_types`.*, `booking_passengers`.`id` AS `pivot_id`, `booking_passengers`.`created_at` AS `pivot_created_at`, `booking_passengers`.`updated_at` AS `pivot_updated_at`, `booking_passengers`.`booking_id` AS `pivot_booking_id`, `booking_passengers`.`passenger_type_id` AS `pivot_passenger_type_id`, `booking_passengers`.`quantity` AS `pivot_quantity`, `booking_passengers`.`price` AS `pivot_price`, `booking_passengers`.`booking_id` AS `pivot_booking_id`, `booking_passengers`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `booking_passengers` ON `passenger_types`.`id` = `booking_passengers`.`passenger_type_id` WHERE `booking_passengers`.`booking_id` = '883'
0.17ms
SELECT * FROM `booking_options` WHERE `booking_id` = '883' AND `passenger_number` IS NULL
0.16ms
SELECT * FROM `options` WHERE `id` = '19' LIMIT 1
0.18ms
SELECT * FROM `booking_modifications` WHERE `booking_id` = '883' AND `post_tax` IS NULL
0.11ms
SELECT * FROM `booking_coupons` WHERE `booking_id` = '883' LIMIT 1
0.14ms
SELECT * FROM `booking_modifications` WHERE `booking_id` = '883' AND `post_tax` = '1'
10.50ms
SELECT SUM(`amount`) AS `aggregate` FROM `payments` WHERE `booking_id` = '883' AND `status` = '2'
11.09ms
SELECT SUM(`refund`) AS `aggregate` FROM `payments` WHERE `booking_id` = '883' AND `status` = '2'
0.12ms
SELECT SUM(`total`) AS `aggregate` FROM `booking_coupons` WHERE `booking_id` = '883'
0.19ms
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.15ms
SELECT * FROM `categories` WHERE `url_name` = 'helicopter' LIMIT 1
0.23ms
SELECT * FROM `categories` WHERE `url_name` = 'zipline' LIMIT 1
0.10ms
SELECT * FROM `categories` WHERE `url_name` = 'sunset_cruise' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'scenic_tour' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'downhill_biking' LIMIT 1
0.10ms
SELECT * FROM `categories` WHERE `url_name` = 'hiking' LIMIT 1
0.15ms
SELECT * FROM `categories` WHERE `url_name` = 'whale_watching' LIMIT 1
0.09ms
SELECT * FROM `categories` WHERE `url_name` = 'adventure' LIMIT 1