Hawaii Scuba Diving - Advertise Hawaii Diving

Home >> Oahu Dive Sites >> Unnamed Reef

Write Reviews for "Unnamed Reef"
Please fill out the following simply form to post a review or add a site. We will not show your email address. Required Fields *
Your Name:*
Your Location:*
Email Address:*
Review:*
You can also add the following information that you feel applies to this site.
Rating:	Poor 12345 Excellent
Recommended Skill Level:*	(Beginner / Intermediate / Advanced)
Visibility:*	(Feet / Metres)
Access:*	(Boat / Shore)
Date of your Dive:

Authentication Code:*

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

(default) 137 queries took 67 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `dive_companies`

DESCRIBE `contacts`

DESCRIBE `sites`

DESCRIBE `pages`

DESCRIBE `islands`

DESCRIBE `systemsettings`

DESCRIBE `memberships`

DESCRIBE `menu_items`

DESCRIBE `manage_urls`

DESCRIBE `services`

DESCRIBE `companies_rates`

DESCRIBE `photos`

DESCRIBE `banners`

DESCRIBE `bookings`

DESCRIBE `payments`

DESCRIBE `zones`

DESCRIBE `reviews`

DESCRIBE `link_categories`

DESCRIBE `island_tourcats`

DESCRIBE `tour_categories`

DESCRIBE `comp_ads`

DESCRIBE `company_types`

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 * FROM `sites` AS `Site` WHERE `Site`.`id` = 28 ORDER BY `Site`.`id` ASC LIMIT 1

SELECT * FROM `islands` AS `Island` WHERE `Island`.`id` = 18 ORDER BY `Island`.`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 `MenuItems`.`id`, `MenuItems`.`menu_id`, `MenuItems`.`page_id`, `MenuItems`.`item_title`, `MenuItems`.`addedon`, `MenuItems`.`status`, `MenuItems`.`order`, `MenuItems`.`url`, `MenuItems`.`parent_id`, `MenuItems`.`display_url_id` FROM `menu_items` AS `MenuItems` WHERE `id` = 45 LIMIT 1

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

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

DESCRIBE `suggestions`

DESCRIBE `flashes`

DESCRIBE `featurecosts`

DESCRIBE `flashphotocosts`

DESCRIBE `tourfeaturecosts`

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` = '%2Ffunction%2Fwritesitereview%2F28' 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` = '%2Ffunction%2Fwritesitereview%2F28' 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` = '%2Ffunction%2Fwritesitereview%2F28' 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` = '%2Ffunction%2Fwritesitereview%2F28' 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` = '%2Ffunction%2Fwritesitereview%2F28' 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` = '%2Ffunction%2Fwritesitereview%2F28' ORDER BY `ManageUrls`.`id` DESC LIMIT 1

SELECT * FROM `banners` AS `Banner` WHERE `Banner`.`status` = 'Active' and (`Banner`.`position`='0' or `Banner`.`position`='5') 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

100

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

101

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

102

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

103

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

104

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

105

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

106

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

107

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

108

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

109

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

110

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

111

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

112

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

113

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

114

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

115

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

116

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

117

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

118

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

119

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

120

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

121

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

122

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

123

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

124

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

125

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

126

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

127

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

128

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 14:45:29' AND `T1`.`start_date` <= '2013-06-19' AND `T1`.`expire_date` >= '2013-06-19' GROUP BY `Dive`.`id` ORDER BY rand() ASC

129

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

130

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

131

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

132

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

133

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

134

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

135

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

136

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

137

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