Your 'Port' has been chosen Clear this filter or visit another page to change

Cape Town, South Africa

Cape Town and surrounding regions are regarded as one of the most beautiful regions in the world. The city is a rare cultural gem resulting from the amalgamation of Indonesian, French, Dutch, British and German settlers, the local Bushman and Hottentot tribes and the Bantu tribes from the north.

The impressive presence of Table Mountain, flanked by the legendary Devil's Peak and historical Signal Hill, stands proudly above the city. Beautiful white sandy beaches along a peaceful coastline frame the Cape Peninsula.

Cape Town boasts a multitude of entertainment, ranging from outdoor activities and adventures in the sun to a roaring night life under neon signs. The vast range of shopping opportunities includes haggling with shopholders at Greenmarket Square Flea Market, as well as breezing through sophisticated and stylish shopping malls. The huge variety of restaurants reflects the multicultured history of the Cape and caters for everyone's taste, from fast-food outlets and casual to the chic to the very elegant.

Cruise Season – Oct – April
Currency – Rand (R)
Language – Xhosa, English and Afrikaans
Land Area – km²
Electricity – South African/Indian-style plug with two round metal pins above a large round grounding pin
Time – GMT plus two hours
International Country Telephone Code – + 27

#	Query	Time
(1)	connect	0.00082898139953613
(2)	DESCRIBE `ports`	0.0021209716796875
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'cape-town-south-africa') AND (orchid_available = 1) LIMIT 1	0.0018699169158936
(4)	DESCRIBE `destinations`	0.0028328895568848
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 52)))	0.0007021427154541
(6)	DESCRIBE `avid_specials`	0.0018959045410156
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '52' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0016789436340332
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66')	0.00043106079101562
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '66')	0.0024240016937256
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '66')	0.0022449493408203
(11)	DESCRIBE `cruises`	0.0041930675506592
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76010, 76034, 76011, 76012, 76013, 76014, 80944, 75354, 75434, 75435)) ORDER BY FIND_IN_SET(id, '76010,76034,76011,76012,76013,76014,80944,75354,75434,75435')	0.003432035446167
(13)	DESCRIBE `cruiselines`	0.0025138854980469
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('15', '91', '151', '49', '23', '19', '28', '24', '114', '159', '14', '20', '29', '187', '12', '18')) ORDER BY FIND_IN_SET(id, '15,91,151,49,23,19,28,24,114,159,14,20,29,187,12,18')	0.0018489360809326
(15)	DESCRIBE `ships`	0.0042860507965088
(16)	SELECT `ships`.* FROM `ships` WHERE (id IN ('258', '585', '545', '616', '508', '1108', '610', '341', '780', '790', '338', '652', '695', '1262', '66', '105', '147', '448', '818', '74', '775')) ORDER BY FIND_IN_SET(id, '258,585,545,616,508,1108,610,341,780,790,338,652,695,1262,66,105,147,448,818,74,775')	0.0018467903137207
(17)	DESCRIBE `cruisetypes`	0.0014379024505615
(18)	DESCRIBE `destinations`	0.0023329257965088
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '52', '30', '38', '8', '28', '7', '35')) ORDER BY FIND_IN_SET(id, '40,52,30,38,8,28,7,35')	0.00097513198852539
(20)	DESCRIBE `ports`	0.0020918846130371
(21)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66)))	0.00037813186645508

Query

Time

(1)

connect

0.00082898139953613

(2)

DESCRIBE `ports`

0.0021209716796875

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'cape-town-south-africa') AND (orchid_available = 1) LIMIT 1

0.0018699169158936

(4)

DESCRIBE `destinations`

0.0028328895568848

(5)

SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 52)))

0.0007021427154541

(6)

DESCRIBE `avid_specials`

0.0018959045410156

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '52' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0016789436340332

(8)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66')

0.00043106079101562

(9)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '66')

0.0024240016937256

(10)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '66')

0.0022449493408203

(11)

DESCRIBE `cruises`

0.0041930675506592

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (76010, 76034, 76011, 76012, 76013, 76014, 80944, 75354, 75434, 75435)) ORDER BY FIND_IN_SET(id, '76010,76034,76011,76012,76013,76014,80944,75354,75434,75435')

0.003432035446167

(13)

DESCRIBE `cruiselines`

0.0025138854980469

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('15', '91', '151', '49', '23', '19', '28', '24', '114', '159', '14', '20', '29', '187', '12', '18')) ORDER BY FIND_IN_SET(id, '15,91,151,49,23,19,28,24,114,159,14,20,29,187,12,18')

0.0018489360809326

(15)

DESCRIBE `ships`

0.0042860507965088

(16)

SELECT `ships`.* FROM `ships` WHERE (id IN ('258', '585', '545', '616', '508', '1108', '610', '341', '780', '790', '338', '652', '695', '1262', '66', '105', '147', '448', '818', '74', '775')) ORDER BY FIND_IN_SET(id, '258,585,545,616,508,1108,610,341,780,790,338,652,695,1262,66,105,147,448,818,74,775')

0.0018467903137207

(17)

DESCRIBE `cruisetypes`

0.0014379024505615

(18)

DESCRIBE `destinations`

0.0023329257965088

(19)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '52', '30', '38', '8', '28', '7', '35')) ORDER BY FIND_IN_SET(id, '40,52,30,38,8,28,7,35')

0.00097513198852539

(20)

DESCRIBE `ports`

0.0020918846130371

(21)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66)))

0.00037813186645508

Find Your Cruise

Cape Town, South Africa

Database Profiling Report