Hawaii Scuba Diving - Complete Guide to Diving Hawaii

Aloha and welcome to HawaiiScubaDiving.com your complete guide to diving in Hawaii, including dive companies, dive sites and everything else you want to know about diving in Hawaii. Post reviews of dive sites and book diving directly with the companies or click through to their website.

The Hawaiian island chain is made up of 132 islands, though we generally only think of the eight main islands, Ni'ihau, Kauai, Oahu, Molokai, Lanai, Maui, Kahoolawe and Hawaii. Surrounded by the Pacific Ocean and located over 2400 miles from the nearest continent has created a unique underwater environment, in fact over 25% of marine is endemic to Hawaii.

The four most visited islands are Oahu, Maui, Kauai and Hawaii, they each have their own unique characteristics and dive locations. Lanai, Molokai and Ni'ihau are dived less frequently and offer some unique dives and marine life, although generally recommended for intermediate to advanced divers. If you are interested in diving off Kahoolawe you will need to charter a dive boat.

When you are not sun bathing in your bikini on the beach or diving beneath the waves there are plenty of activities to keep you busy, why not try skydiving, a luau, go to the world's most active volcano or kick back and relax on a sunset dinner cruise. Visit our activity page for some suggestions of activities to participate when you are not diving and to arrange a lei greeting for when you arrive into the islands. Also in our activity page you will find a selection of accommodations and information whether you are looking for a Waikiki Hotel or to stay at the Hobbit House on the Big Island.

(default) 131 queries took 83 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `pages`	9	9	3
2	DESCRIBE `sites`	20	20	2
3	DESCRIBE `company_types`	2	2	2
4	DESCRIBE `tour_categories`	10	10	2
5	DESCRIBE `islands`	16	16	2
6	DESCRIBE `suggestions`	6	6	2
7	DESCRIBE `dive_companies`	49	49	5
8	DESCRIBE `systemsettings`	11	11	3
9	DESCRIBE `memberships`	8	8	2
10	DESCRIBE `menu_items`	10	10	2
11	DESCRIBE `manage_urls`	5	5	4
12	DESCRIBE `services`	6	6	3
13	DESCRIBE `companies_rates`	6	6	1
14	DESCRIBE `photos`	7	7	2
15	DESCRIBE `banners`	7	7	2
16	DESCRIBE `zones`	5	5	1
17	DESCRIBE `payments`	8	8	1
18	DESCRIBE `flashes`	11	11	1
19	DESCRIBE `featurecosts`	3	3	1
20	DESCRIBE `flashphotocosts`	3	3	2
21	DESCRIBE `tourfeaturecosts`	3	3	3
22	SELECT * FROM `pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`page_status` = 'active' ORDER BY `Page`.`id` DESC LIMIT 1	1	1	1
23	SELECT `MenuItems`.`parent_id` FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`page_id` = 1 ORDER BY `MenuItems`.`id` DESC LIMIT 1	0	0	1
24	DESCRIBE `link_categories`	9	9	1
25	DESCRIBE `comp_ads`	5	5	1
26	DESCRIBE `reviews`	14	14	1
27	DESCRIBE `feature_durations`	5	5	1
28	SELECT `Island`.`id`, `Island`.`island_name`, `Island`.`display_url_id`, `Island`.`company_url_id`, `Island`.`site_url_id`, `Island`.`tour_url_id` FROM `islands` AS `Island` WHERE `Island`.`status` = 'Active' ORDER BY `Island`.`order` ASC	6	6	0
29	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
30	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
31	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
32	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
33	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
34	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	1
35	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`menu_id` = 2 AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	9	9	0
36	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`menu_id` = 1 AND `MenuItems`.`parent_id` = 0 AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	9	9	0
37	SELECT `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_description` FROM `pages` AS `Page` WHERE `id` = 1 LIMIT 1	1	1	1
38	SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`display_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1	0	0	4
39	SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`company_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1	0	0	2
40	SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`site_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1	0	0	2
41	SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`tour_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1	0	0	2
42	SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,Dive.company_name FROM `manage_urls` AS `ManageUrls` inner JOIN dive_companies AS `Dive` ON (`ManageUrls`.`id` = `Dive`.`display_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1	0	0	4
43	SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,Site.site_name FROM `manage_urls` AS `ManageUrls` inner JOIN sites AS `Site` ON (`ManageUrls`.`id` = `Site`.`display_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1	0	0	3
44	SELECT * FROM `banners` AS `Banner` WHERE `Banner`.`status` = 'Active' and (`Banner`.`position`='0' or `Banner`.`position`='1') ORDER BY rand() ASC	3	3	2
45	SELECT `Island`.`id`, `Island`.`island_name`, `Island`.`display_url_id`, `Island`.`company_url_id`, `Island`.`site_url_id`, `Island`.`tour_url_id` FROM `islands` AS `Island` WHERE `Island`.`status` = 'Active' ORDER BY `Island`.`order` ASC	6	6	1
46	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
47	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
48	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
49	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
50	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
51	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
52	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 32 LIMIT 1	1	1	0
53	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 2 LIMIT 1	1	1	0
54	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 11 LIMIT 1	1	1	0
55	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 5 LIMIT 1	1	1	0
56	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 8 LIMIT 1	1	1	1
57	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 14 LIMIT 1	1	1	0
58	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 17 LIMIT 1	1	1	0
59	SELECT `Island`.`id`, `Island`.`island_name`, `Island`.`display_url_id`, `Island`.`company_url_id`, `Island`.`site_url_id`, `Island`.`tour_url_id` FROM `islands` AS `Island` WHERE `Island`.`status` = 'Active' ORDER BY `Island`.`order` ASC	6	6	0
60	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
61	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
62	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
63	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
64	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
65	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
66	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 33 LIMIT 1	1	1	0
67	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 3 LIMIT 1	1	1	0
68	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 12 LIMIT 1	1	1	0
69	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 6 LIMIT 1	1	1	0
70	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 9 LIMIT 1	1	1	0
71	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 15 LIMIT 1	1	1	0
72	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 18 LIMIT 1	1	1	0
73	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '17' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	3	3	0
74	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 39 LIMIT 1	1	1	0
75	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 40 LIMIT 1	1	1	0
76	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 41 LIMIT 1	1	1	0
77	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 42 LIMIT 1	1	1	1
78	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '18' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	1	1	1
79	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 43 LIMIT 1	1	1	1
80	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 722 LIMIT 1	1	1	0
81	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '19' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	2	2	0
82	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 44 LIMIT 1	1	1	0
83	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 59 LIMIT 1	1	1	0
84	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 60 LIMIT 1	1	1	0
85	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '20' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	2	2	1
86	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 45 LIMIT 1	1	1	0
87	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 46 LIMIT 1	1	1	0
88	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 103 LIMIT 1	1	1	0
89	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '27' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	4	4	1
90	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 47 LIMIT 1	1	1	0
91	SELECT `Island`.`id`, `Island`.`island_name`, `Island`.`display_url_id`, `Island`.`company_url_id`, `Island`.`site_url_id`, `Island`.`tour_url_id` FROM `islands` AS `Island` WHERE `Island`.`status` = 'Active' ORDER BY `Island`.`order` ASC	6	6	0
92	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
93	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
94	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
95	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
96	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
97	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1	1	1	0
98	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 129 LIMIT 1	1	1	0
99	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 132 LIMIT 1	1	1	0
100	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 130 LIMIT 1	1	1	0
101	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 131 LIMIT 1	1	1	0
102	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 134 LIMIT 1	1	1	0
103	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 133 LIMIT 1	1	1	0
104	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 48 LIMIT 1	1	1	0
105	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 49 LIMIT 1	1	1	0
106	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 50 LIMIT 1	1	1	0
107	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 291 LIMIT 1	1	1	0
108	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '28' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	5	5	0
109	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 51 LIMIT 1	1	1	0
110	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 68 LIMIT 1	1	1	0
111	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 69 LIMIT 1	1	1	0
112	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 70 LIMIT 1	1	1	0
113	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 71 LIMIT 1	1	1	0
114	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 72 LIMIT 1	1	1	0
115	SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '29' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC	5	5	0
116	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 52 LIMIT 1	1	1	0
117	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 53 LIMIT 1	1	1	0
118	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 54 LIMIT 1	1	1	0
119	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 55 LIMIT 1	1	1	0
120	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 57 LIMIT 1	1	1	0
121	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 56 LIMIT 1	1	1	0
122	SELECT `Dive`.`id`, `Dive`.`display_url_id`, `Dive`.`island_id`, `Dive`.`company_logo`, `Dive`.`company_name`, `Dive`.`brief_description` FROM `dive_companies` AS `Dive` inner JOIN feature_durations AS `T1` ON (`Dive`.`id` = `T1`.`company_id`) WHERE `Dive`.`type_id` = 1 AND `Dive`.`account_status` = 'active' AND `Dive`.`featured` = 'yes' AND `Dive`.`expire_date` > '2013-06-19 06:13:18' AND `T1`.`start_date` <= '2013-06-19' AND `T1`.`expire_date` >= '2013-06-19' GROUP BY `Dive`.`id` ORDER BY rand() ASC	0	0	3
123	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 75 LIMIT 1	1	1	0
124	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 36 LIMIT 1	1	1	0
125	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 78 LIMIT 1	1	1	0
126	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 0 LIMIT 1	0	0	0
127	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 74 LIMIT 1	1	1	0
128	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 0 LIMIT 1	0	0	0
129	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 76 LIMIT 1	1	1	0
130	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 188 LIMIT 1	1	1	0
131	SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 594 LIMIT 1	1	1	0

(default) 131 queries took 83 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `pages`

DESCRIBE `sites`

DESCRIBE `company_types`

DESCRIBE `tour_categories`

DESCRIBE `islands`

DESCRIBE `suggestions`

DESCRIBE `dive_companies`

DESCRIBE `systemsettings`

DESCRIBE `memberships`

DESCRIBE `menu_items`

DESCRIBE `manage_urls`

DESCRIBE `services`

DESCRIBE `companies_rates`

DESCRIBE `photos`

DESCRIBE `banners`

DESCRIBE `zones`

DESCRIBE `payments`

DESCRIBE `flashes`

DESCRIBE `featurecosts`

DESCRIBE `flashphotocosts`

DESCRIBE `tourfeaturecosts`

SELECT * FROM `pages` AS `Page` WHERE `Page`.`id` = 1 AND `Page`.`page_status` = 'active' ORDER BY `Page`.`id` DESC LIMIT 1

SELECT `MenuItems`.`parent_id` FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`page_id` = 1 ORDER BY `MenuItems`.`id` DESC LIMIT 1

DESCRIBE `link_categories`

DESCRIBE `comp_ads`

DESCRIBE `reviews`

DESCRIBE `feature_durations`

SELECT `Island`.`id`, `Island`.`island_name`, `Island`.`display_url_id`, `Island`.`company_url_id`, `Island`.`site_url_id`, `Island`.`tour_url_id` FROM `islands` AS `Island` WHERE `Island`.`status` = 'Active' ORDER BY `Island`.`order` ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`menu_id` = 2 AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`menu_id` = 1 AND `MenuItems`.`parent_id` = 0 AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT `Page`.`meta_title`, `Page`.`meta_keywords`, `Page`.`meta_description` FROM `pages` AS `Page` WHERE `id` = 1 LIMIT 1

SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`display_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`company_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`site_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,islands.island_name FROM `manage_urls` AS `ManageUrls` inner JOIN islands AS `islands` ON (`ManageUrls`.`id` = `islands`.`tour_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,Dive.company_name FROM `manage_urls` AS `ManageUrls` inner JOIN dive_companies AS `Dive` ON (`ManageUrls`.`id` = `Dive`.`display_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT ManageUrls.id,ManageUrls.actual_url,ManageUrls.display_url,Site.site_name FROM `manage_urls` AS `ManageUrls` inner JOIN sites AS `Site` ON (`ManageUrls`.`id` = `Site`.`display_url_id`) WHERE `ManageUrls`.`display_url` = '%2F' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT * FROM `banners` AS `Banner` WHERE `Banner`.`status` = 'Active' and (`Banner`.`position`='0' or `Banner`.`position`='1') ORDER BY rand() ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 32 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 2 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 11 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 5 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 8 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 14 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 17 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 33 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 3 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 12 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 6 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 9 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 15 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 18 LIMIT 1

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '17' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 39 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 40 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 41 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 42 LIMIT 1

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '18' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 43 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 722 LIMIT 1

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '19' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 44 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 59 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 60 LIMIT 1

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '20' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 45 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 46 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 103 LIMIT 1

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '27' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 47 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 1 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 10 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 4 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 7 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 13 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 16 ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 129 LIMIT 1

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 132 LIMIT 1

100

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 130 LIMIT 1

101

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 131 LIMIT 1

102

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 134 LIMIT 1

103

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 133 LIMIT 1

104

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 48 LIMIT 1

105

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 49 LIMIT 1

106

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 50 LIMIT 1

107

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 291 LIMIT 1

108

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '28' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

109

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 51 LIMIT 1

110

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 68 LIMIT 1

111

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 69 LIMIT 1

112

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 70 LIMIT 1

113

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 71 LIMIT 1

114

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 72 LIMIT 1

115

SELECT * FROM `menu_items` AS `MenuItems` WHERE `MenuItems`.`parent_id` = '29' AND `MenuItems`.`status` = 'Active' ORDER BY `MenuItems`.`order` ASC

116

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 52 LIMIT 1

117

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 53 LIMIT 1

118

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 54 LIMIT 1

119

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 55 LIMIT 1

120

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 57 LIMIT 1

121

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 56 LIMIT 1

122

SELECT `Dive`.`id`, `Dive`.`display_url_id`, `Dive`.`island_id`, `Dive`.`company_logo`, `Dive`.`company_name`, `Dive`.`brief_description` FROM `dive_companies` AS `Dive` inner JOIN feature_durations AS `T1` ON (`Dive`.`id` = `T1`.`company_id`) WHERE `Dive`.`type_id` = 1 AND `Dive`.`account_status` = 'active' AND `Dive`.`featured` = 'yes' AND `Dive`.`expire_date` > '2013-06-19 06:13:18' AND `T1`.`start_date` <= '2013-06-19' AND `T1`.`expire_date` >= '2013-06-19' GROUP BY `Dive`.`id` ORDER BY rand() ASC

123

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 75 LIMIT 1

124

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 36 LIMIT 1

125

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 78 LIMIT 1

126

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 0 LIMIT 1

127

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 74 LIMIT 1

128

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 0 LIMIT 1

129

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 76 LIMIT 1

130

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 188 LIMIT 1

131

SELECT `ManageUrls`.`display_url` FROM `manage_urls` AS `ManageUrls` WHERE `ManageUrls`.`id` = 594 LIMIT 1