Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
26 December 2019	17	Roald Amundsen, Antarctica Falklands & Chilean Fjords ex Santiago Return
28 December 2019	20	Greg Mortimer, South Georgia & Antarctic Odyssey ex Ushuaia Return
29 December 2019	22	Fram, Ultimate Expedition Antarctica Falklands & Sth Georgia ex Ushuia Return
4 January 2020	128	Amsterdam, Grand World Voyage 2020 ex Ft Lauderdale Return
4 January 2020	14	Star, South America (Westbound) ex Buenos Aires to San Antonio
5 January 2020	77	Volendam, Grand South America & Antarctica ex Ft Lauderdale Return
5 January 2020	41	Volendam, Grand South America & Antarctica ex Ft Lauderdale to Buenos Aires
5 January 2020	16	Coral, Antarctica & Cape Horn ex San Antonio to Buenos Aires
5 January 2020	15	Pursuit, Antarctica Pursuit ex Buenos Aires Return
6 January 2020	140	Whisper, Legends of Cruising - World Cruise 2020 ex Ft Lauderdale to Amsterdam

Page Navigation: 1 2 3 4 5 6 7 8 9 10 Next »

Items 1 - 10 of 130

#	Query	Time
(1)	connect	0.00095796585083008
(2)	DESCRIBE `ports`	0.0023379325866699
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'port-stanley-falkland-islands') AND (orchid_available = 1) LIMIT 1	0.016083002090454
(4)	DESCRIBE `cruises`	0.0060648918151855
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (69671, 74471, 66738, 77504, 74540, 79302, 79303, 76869, 77509, 75504)) ORDER BY FIND_IN_SET(id, '69671,74471,66738,77504,74540,79302,79303,76869,77509,75504')	0.0025789737701416
(6)	DESCRIBE `cruises`	0.0039210319519043
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69671')	0.00040698051452637
(8)	DESCRIBE `cruises`	0.0037121772766113
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74471')	0.00053310394287109
(10)	DESCRIBE `cruises`	0.0042099952697754
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66738')	0.00051999092102051
(12)	DESCRIBE `cruises`	0.0035371780395508
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77504')	0.00041508674621582
(14)	DESCRIBE `cruises`	0.0035459995269775
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74540')	0.00044107437133789
(16)	DESCRIBE `cruises`	0.003352165222168
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79302')	0.00041985511779785
(18)	DESCRIBE `cruises`	0.0034470558166504
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79303')	0.00051689147949219
(20)	DESCRIBE `cruises`	0.0037059783935547
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76869')	0.00037813186645508
(22)	DESCRIBE `cruises`	0.0033891201019287
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77509')	0.00038003921508789
(24)	DESCRIBE `cruises`	0.0037651062011719
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75504')	0.00049996376037598
(26)	DESCRIBE `cruises`	0.0038478374481201
(27)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701, 76693, 76702, 76703)) ORDER BY FIND_IN_SET(id, '76700,76701,76693,76702,76703')	0.0015630722045898
(28)	DESCRIBE `cruiselines`	0.003878116607666
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18')) ORDER BY FIND_IN_SET(id, '18')	0.00075101852416992
(30)	DESCRIBE `cruisetypes`	0.0023369789123535
(31)	DESCRIBE `destinations`	0.003486156463623
(32)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37')) ORDER BY FIND_IN_SET(id, '37')	0.00054192543029785
(33)	DESCRIBE `ships`	0.0040290355682373
(34)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00075411796569824
(35)	DESCRIBE `ships`	0.004364013671875
(36)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00070905685424805
(37)	DESCRIBE `ports`	0.0024819374084473
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737)))	0.00061392784118652

Query

Time

(1)

connect

0.00095796585083008

(2)

DESCRIBE `ports`

0.0023379325866699

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'port-stanley-falkland-islands') AND (orchid_available = 1) LIMIT 1

0.016083002090454

(4)

DESCRIBE `cruises`

0.0060648918151855

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (69671, 74471, 66738, 77504, 74540, 79302, 79303, 76869, 77509, 75504)) ORDER BY FIND_IN_SET(id, '69671,74471,66738,77504,74540,79302,79303,76869,77509,75504')

0.0025789737701416

(6)

DESCRIBE `cruises`

0.0039210319519043

(7)

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

0.00040698051452637

(8)

DESCRIBE `cruises`

0.0037121772766113

(9)

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

0.00053310394287109

(10)

DESCRIBE `cruises`

0.0042099952697754

(11)

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

0.00051999092102051

(12)

DESCRIBE `cruises`

0.0035371780395508

(13)

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

0.00041508674621582

(14)

DESCRIBE `cruises`

0.0035459995269775

(15)

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

0.00044107437133789

(16)

DESCRIBE `cruises`

0.003352165222168

(17)

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

0.00041985511779785

(18)

DESCRIBE `cruises`

0.0034470558166504

(19)

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

0.00051689147949219

(20)

DESCRIBE `cruises`

0.0037059783935547

(21)

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

0.00037813186645508

(22)

DESCRIBE `cruises`

0.0033891201019287

(23)

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

0.00038003921508789

(24)

DESCRIBE `cruises`

0.0037651062011719

(25)

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

0.00049996376037598

(26)

DESCRIBE `cruises`

0.0038478374481201

(27)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701, 76693, 76702, 76703)) ORDER BY FIND_IN_SET(id, '76700,76701,76693,76702,76703')

0.0015630722045898

(28)

DESCRIBE `cruiselines`

0.003878116607666

(29)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18')) ORDER BY FIND_IN_SET(id, '18')

0.00075101852416992

(30)

DESCRIBE `cruisetypes`

0.0023369789123535

(31)

DESCRIBE `destinations`

0.003486156463623

(32)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37')) ORDER BY FIND_IN_SET(id, '37')

0.00054192543029785

(33)

DESCRIBE `ships`

0.0040290355682373

(34)

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

0.00075411796569824

(35)

DESCRIBE `ships`

0.004364013671875

(36)

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

0.00070905685424805

(37)

DESCRIBE `ports`

0.0024819374084473

(38)

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

0.00061392784118652

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report