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 2.8610229492188E-6
info routefilter::before cache cleared 0.0015490055084229
info routefilter::before got cookie 0.021056890487671
info routefilter::before end 0.021075963973999
rating start 0.39711284637451
rating end 0.39716982841492
rating start 0.43089485168457
rating end 0.43095993995667
rating start 0.45543694496155
rating end 0.45548796653748
rating start 0.47589802742004
rating end 0.47594881057739
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 ('confirmation', '', '', '', 'booking/confirmation/883/5715d6e0cfa1b', '', '', '', '', '', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '54.80.58.121', '2018-09-21 10:03:24', '2018-09-21 10:03:24')
0.52ms
UPDATE `sessions` SET `campaign` = '', `ad_group` = '', `device` = '', `match_type` = '', `referer` = '', `reseller_id` = '', `updated_at` = '2018-09-21 10:03:24', `visits` = '1' WHERE `id` = '383672'
0.60ms
SELECT * FROM `bookings` WHERE `id` = '883' LIMIT 1
0.14ms
SELECT * FROM `tours` WHERE `id` = '3' LIMIT 1
0.26ms
SELECT * FROM `vendors` WHERE `id` = '2' LIMIT 1
0.17ms
SELECT * FROM `customers` WHERE `id` = '275' LIMIT 1
1.09ms
UPDATE `bookings` SET `booking_customer_id` = '', `updated_at` = '2018-09-21 10:03:24', `a3h_id` = '', `dashboard` = '', `agent_id` = '', `special_notes` = '', `discount` = '', `tax_rate` = '', `views` = '164', `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'
151.50ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' AND `source` = 'vendor' AND `to` = 'customer' AND `resolved` IS NULL
86.01ms
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
42.23ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' ORDER BY `created_at` DESC
9.75ms
SELECT * FROM `payments` WHERE `booking_id` = '883' ORDER BY `created_at` DESC LIMIT 1
0.43ms
SELECT * FROM `category_tours` WHERE `id` = '2' LIMIT 1
3.86ms
SELECT * FROM `category_tours` WHERE `banner` = 'popular' AND `id` != '2'
0.14ms
SELECT * FROM `images` WHERE `id` = '2379' 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` = '21' 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` = '21' 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` = '21' 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` = '21' LIMIT 1
0.12ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '21' 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` = '21' 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` = '21' LIMIT 1
0.18ms
SELECT * FROM `vendors` WHERE `id` = '5' 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` = '21' 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` = '21' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT * FROM `images` WHERE `id` = '3202' 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` = '39' 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` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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` = '39' 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` = '39' LIMIT 1
0.12ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '39' 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` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.17ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '39' LIMIT 1
0.21ms
SELECT * FROM `vendors` WHERE `id` = '11' 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` = '39' 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` = '39' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT * FROM `images` WHERE `id` = '559' 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` = '55' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.14ms
SELECT `passenger_types`.*, `tour_passenger_types`.`id` AS `pivot_id`, `tour_passenger_types`.`created_at` AS `pivot_created_at`, `tour_passenger_types`.`updated_at` AS `pivot_updated_at`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id`, `tour_passenger_types`.`price` AS `pivot_price`, `tour_passenger_types`.`retail` AS `pivot_retail`, `tour_passenger_types`.`net_rate` AS `pivot_net_rate`, `tour_passenger_types`.`active` AS `pivot_active`, `tour_passenger_types`.`category_tour_id` AS `pivot_category_tour_id`, `tour_passenger_types`.`passenger_type_id` AS `pivot_passenger_type_id` FROM `passenger_types` INNER JOIN `tour_passenger_types` ON `passenger_types`.`id` = `tour_passenger_types`.`passenger_type_id` WHERE `tour_passenger_types`.`category_tour_id` = '55' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.12ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '55' 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` = '55' 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` = '55' 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` = '55' 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` = '55' LIMIT 1
0.19ms
SELECT * FROM `vendors` WHERE `id` = '24' 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` = '55' 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` = '55' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC LIMIT 1
0.11ms
SELECT * FROM `images` WHERE `id` = '632' 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.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` = '79' AND `tour_passenger_types`.`active` = '1' AND `passenger_types`.`active` = '1' ORDER BY `layout` ASC 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.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.12ms
SELECT `categories`.*, `tour_categories_new`.`id` AS `pivot_id`, `tour_categories_new`.`created_at` AS `pivot_created_at`, `tour_categories_new`.`updated_at` AS `pivot_updated_at`, `tour_categories_new`.`category_tour_id` AS `pivot_category_tour_id`, `tour_categories_new`.`category_id` AS `pivot_category_id` FROM `categories` INNER JOIN `tour_categories_new` ON `categories`.`id` = `tour_categories_new`.`category_id` WHERE `tour_categories_new`.`category_tour_id` = '79' 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` = '79' 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` = '79' LIMIT 1
0.19ms
SELECT * FROM `vendors` WHERE `id` = '1' 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` = '79' 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` = '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` = '2' 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` = '2' LIMIT 1
72.07ms
SELECT * FROM `booking_events` WHERE `booking_id` = '883' AND `event_type` = 'modify' AND `source` = 'customer' AND `to` = 'agent' ORDER BY `created_at` DESC
0.20ms
SELECT * FROM `vendors` WHERE `id` = '2' LIMIT 1
0.57ms
SELECT * FROM `booking_customers` WHERE `booking_id` = '883' LIMIT 1
0.54ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '2' AND `active` = '1'
0.13ms
SELECT * FROM `tour_times_copy` WHERE `category_tour_id` = '2' AND `active` = '1'
11.68ms
SELECT * FROM `booking_options` WHERE `booking_id` = '883'
1.23ms
SELECT * FROM `options` WHERE `id` = '19' LIMIT 1
0.59ms
SELECT * FROM `option_values` WHERE `option_id` = '19' AND `value` = '3' LIMIT 1
0.26ms
SELECT * FROM `options` WHERE `id` = '7' LIMIT 1
0.48ms
SELECT * FROM `option_values` WHERE `option_id` = '7' AND `value` = 'Ben Holz' LIMIT 1
0.10ms
SELECT * FROM `options` WHERE `id` = '7' LIMIT 1
0.49ms
SELECT * FROM `option_values` WHERE `option_id` = '7' AND `value` = 'Rachel Holz' LIMIT 1
0.11ms
SELECT * FROM `options` WHERE `id` = '7' LIMIT 1
0.68ms
SELECT * FROM `option_values` WHERE `option_id` = '7' AND `value` = 'Adam Farren' LIMIT 1
0.27ms
SELECT * FROM `options` WHERE `id` = '3' LIMIT 1
0.42ms
SELECT * FROM `option_values` WHERE `option_id` = '3' AND `value` = '43' LIMIT 1
0.11ms
SELECT * FROM `options` WHERE `id` = '3' LIMIT 1
0.74ms
SELECT * FROM `option_values` WHERE `option_id` = '3' AND `value` = '41' LIMIT 1
0.13ms
SELECT * FROM `options` WHERE `id` = '3' LIMIT 1
0.64ms
SELECT * FROM `option_values` WHERE `option_id` = '3' AND `value` = '32' LIMIT 1
0.30ms
SELECT * FROM `options` WHERE `id` = '4' LIMIT 1
0.25ms
SELECT * FROM `option_values` WHERE `option_id` = '4' AND `value` = 'Gourmet Veggie Burger' LIMIT 1
0.11ms
SELECT * FROM `options` WHERE `id` = '4' LIMIT 1
0.51ms
SELECT * FROM `option_values` WHERE `option_id` = '4' AND `value` = 'Peanut Butter & Jelly' LIMIT 1
0.11ms
SELECT * FROM `options` WHERE `id` = '4' LIMIT 1
0.35ms
SELECT * FROM `option_values` WHERE `option_id` = '4' AND `value` = 'Turkey' LIMIT 1
7.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.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` = '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.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` = '2' AND `options`.`active` = '1' AND `tour_options`.`active` = '1' AND `for` = 'passenger' ORDER BY `layout` ASC
0.13ms
SELECT * FROM `vendor_info` WHERE `vendor_id` = '2' LIMIT 1
22.69ms
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'
10.55ms
SELECT * FROM `booking_options` WHERE `booking_id` = '883' AND `passenger_number` IS NULL
0.15ms
SELECT * FROM `options` WHERE `id` = '19' LIMIT 1
0.72ms
SELECT * FROM `booking_modifications` WHERE `booking_id` = '883' AND `post_tax` IS NULL
0.34ms
SELECT * FROM `booking_coupons` WHERE `booking_id` = '883' LIMIT 1
0.66ms
SELECT * FROM `booking_modifications` WHERE `booking_id` = '883' AND `post_tax` = '1'
9.41ms
SELECT SUM(`amount`) AS `aggregate` FROM `payments` WHERE `booking_id` = '883' AND `status` = '2'
9.95ms
SELECT SUM(`refund`) AS `aggregate` FROM `payments` WHERE `booking_id` = '883' AND `status` = '2'
0.34ms
SELECT SUM(`total`) AS `aggregate` FROM `booking_coupons` WHERE `booking_id` = '883'
0.15ms
SELECT * FROM `categories` WHERE `url_name` = 'luau_and_shows' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'snorkel_and_diving' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'helicopter' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'zipline' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'sunset_cruise' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'scenic_tour' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'downhill_biking' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'hiking' LIMIT 1
0.12ms
SELECT * FROM `categories` WHERE `url_name` = 'whale_watching' LIMIT 1
0.11ms
SELECT * FROM `categories` WHERE `url_name` = 'adventure' LIMIT 1