Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
29 December 2019	5	Affinity, Marlborough Sounds New Year Cruise ex Havelock to Picton
6 January 2020	5	Affinity, Marlborough Sounds Cruise & Walk ex Picton Return
20 February 2020	4	Affinity, Marlborough Sounds Pelorus Cruise & Walk ex Havelock Return
27 February 2020	6	Affinity, Marlborough Sounds ex Picton to Havelock
23 March 2020	10	Affinity, Marlborough Sounds Ultimate NZ Cruise ex Golden Bay to Picton
13 May 2020	5	Affinity, Stewart Island Scenic Cruise ex Bluff Return
2 June 2020	6	Affinity, Fiordland Cruise ex Te Anau Return
11 June 2020	6	Affinity, Fiordland with Helicopter Flight out of Fiords ex Te Anau Return
17 June 2020	4	Affinity, Fiordland Cruise with Helicopter Flight Into Fiords ex Te Anau Return
14 July 2020	10	Affinity, Fiordland Cruise with Helicopter Flight ex Te Anau Return

Page Navigation: 1 2 Next »

Items 1 - 10 of 11

#	Query	Time
(1)	connect	0.0013730525970459
(2)	DESCRIBE `ships`	0.012416124343872
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'affinity') LIMIT 1	0.0098640918731689
(4)	DESCRIBE `cruises`	0.0063068866729736
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (47858, 52327, 85811, 28353, 36218, 47869, 35988, 47871, 47872, 47873)) ORDER BY FIND_IN_SET(id, '47858,52327,85811,28353,36218,47869,35988,47871,47872,47873')	0.002810001373291
(6)	DESCRIBE `cruises`	0.0055139064788818
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47858')	0.00070595741271973
(8)	DESCRIBE `cruises`	0.0055088996887207
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52327')	0.00068902969360352
(10)	DESCRIBE `cruises`	0.005836009979248
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85811')	0.0006868839263916
(12)	DESCRIBE `cruises`	0.0052440166473389
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '28353')	0.00059103965759277
(14)	DESCRIBE `cruises`	0.005216121673584
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '36218')	0.00063490867614746
(16)	DESCRIBE `cruises`	0.0050668716430664
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47869')	0.00061798095703125
(18)	DESCRIBE `cruises`	0.0052559375762939
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '35988')	0.00065898895263672
(20)	DESCRIBE `cruises`	0.0051147937774658
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47871')	0.00047802925109863
(22)	DESCRIBE `cruises`	0.0036990642547607
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47872')	0.00056004524230957
(24)	DESCRIBE `cruises`	0.0045759677886963
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47873')	0.00059294700622559
(26)	DESCRIBE `cruisetypes`	0.002655029296875
(27)	DESCRIBE `destinations`	0.0045859813690186
(28)	DESCRIBE `cruiselines`	0.0043089389801025
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00087904930114746
(30)	DESCRIBE `ships`	0.0058169364929199
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568)))	0.00079894065856934
(32)	DESCRIBE `cruiselines`	0.0042669773101807
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00084185600280762
(34)	DESCRIBE `ships`	0.0039341449737549
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568)))	0.00086283683776855

Query

Time

(1)

connect

0.0013730525970459

(2)

DESCRIBE `ships`

0.012416124343872

(3)

SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'affinity') LIMIT 1

0.0098640918731689

(4)

DESCRIBE `cruises`

0.0063068866729736

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (47858, 52327, 85811, 28353, 36218, 47869, 35988, 47871, 47872, 47873)) ORDER BY FIND_IN_SET(id, '47858,52327,85811,28353,36218,47869,35988,47871,47872,47873')

0.002810001373291

(6)

DESCRIBE `cruises`

0.0055139064788818

(7)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47858')

0.00070595741271973

(8)

DESCRIBE `cruises`

0.0055088996887207

(9)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52327')

0.00068902969360352

(10)

DESCRIBE `cruises`

0.005836009979248

(11)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85811')

0.0006868839263916

(12)

DESCRIBE `cruises`

0.0052440166473389

(13)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '28353')

0.00059103965759277

(14)

DESCRIBE `cruises`

0.005216121673584

(15)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '36218')

0.00063490867614746

(16)

DESCRIBE `cruises`

0.0050668716430664

(17)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47869')

0.00061798095703125

(18)

DESCRIBE `cruises`

0.0052559375762939

(19)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '35988')

0.00065898895263672

(20)

DESCRIBE `cruises`

0.0051147937774658

(21)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47871')

0.00047802925109863

(22)

DESCRIBE `cruises`

0.0036990642547607

(23)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47872')

0.00056004524230957

(24)

DESCRIBE `cruises`

0.0045759677886963

(25)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47873')

0.00059294700622559

(26)

DESCRIBE `cruisetypes`

0.002655029296875

(27)

DESCRIBE `destinations`

0.0045859813690186

(28)

DESCRIBE `cruiselines`

0.0043089389801025

(29)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))

0.00087904930114746

(30)

DESCRIBE `ships`

0.0058169364929199

(31)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568)))

0.00079894065856934

(32)

DESCRIBE `cruiselines`

0.0042669773101807

(33)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))

0.00084185600280762

(34)

DESCRIBE `ships`

0.0039341449737549

(35)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 568)))

0.00086283683776855

Find Your Cruise

Upcoming Sailings

Database Profiling Report