Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
9 January 2020	22	Zaandam, South America & Antarctica ex San Antonio to Buenos Aires
31 January 2020	22	Zaandam, South America & Antarctica ex Buenos Aires to San Antonio
22 February 2020	14	Zaandam, South America Passage ex San Antonio to Buenos Aires
7 March 2020	31	Zaandam, South America, Inca & Panama Canal ex Buenos Aires to Ft Lauderdale
7 March 2020	14	Zaandam, South America Passage ex Buenos Aires to San Antonio
21 March 2020	17	Zaandam, Inca & Panama Canal Discovery ex San Antonio to Ft Lauderdale
21 April 2020	10	Zaandam, The Atlantic Coast ex Fort Lauderdale to Montreal
2 May 2020	7	Zaandam, Canada & New England Discovery Cruise ex Montreal to Boston
9 May 2020	7	Zaandam, Canada & New England Discovery Cruise ex Boston to Montreal
18 July 2020	35	Zaandam, Voyage of the Vikings ex Boston Return

Page Navigation: 1 2 3 Next »

Items 1 - 10 of 25

#	Query	Time
(1)	connect	0.0010209083557129
(2)	DESCRIBE `ships`	0.0045590400695801
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'zaandam') LIMIT 1	0.0020580291748047
(4)	DESCRIBE `cruises`	0.0038859844207764
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701, 76693, 76703, 76702, 76704, 82263, 82264, 82266, 79986)) ORDER BY FIND_IN_SET(id, '76700,76701,76693,76703,76702,76704,82263,82264,82266,79986')	0.0022680759429932
(6)	DESCRIBE `cruises`	0.0036709308624268
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76700')	0.00062084197998047
(8)	DESCRIBE `cruises`	0.0036821365356445
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76701')	0.00062203407287598
(10)	DESCRIBE `cruises`	0.0036690235137939
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76693')	0.00052285194396973
(12)	DESCRIBE `cruises`	0.0039010047912598
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76703')	0.00049901008605957
(14)	DESCRIBE `cruises`	0.0035161972045898
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76702')	0.00031304359436035
(16)	DESCRIBE `cruises`	0.0036640167236328
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76704')	0.00044488906860352
(18)	DESCRIBE `cruises`	0.0037310123443604
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82263')	0.00048398971557617
(20)	DESCRIBE `cruises`	0.0037040710449219
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82264')	0.00043392181396484
(22)	DESCRIBE `cruises`	0.0034511089324951
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82266')	0.00049114227294922
(24)	DESCRIBE `cruises`	0.0032880306243896
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79986')	0.0003809928894043
(26)	DESCRIBE `cruises`	0.0036981105804443
(27)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701, 76693, 76702, 76703, 76704, 82263, 82264, 82266, 79985)) ORDER BY FIND_IN_SET(id, '76700,76701,76693,76702,76703,76704,82263,82264,82266,79985')	0.0018630027770996
(28)	DESCRIBE `cruiselines`	0.0025420188903809
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18')) ORDER BY FIND_IN_SET(id, '18')	0.00051593780517578
(30)	DESCRIBE `cruisetypes`	0.0014421939849854
(31)	DESCRIBE `destinations`	0.0022809505462646
(32)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('11', '48', '12', '37', '38', '43')) ORDER BY FIND_IN_SET(id, '11,48,12,37,38,43')	0.0013298988342285
(33)	DESCRIBE `ships`	0.0037820339202881
(34)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00051999092102051
(35)	DESCRIBE `ships`	0.0036659240722656
(36)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00054693222045898

Query

Time

(1)

connect

0.0010209083557129

(2)

DESCRIBE `ships`

0.0045590400695801

(3)

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

0.0020580291748047

(4)

DESCRIBE `cruises`

0.0038859844207764

(5)

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

0.0022680759429932

(6)

DESCRIBE `cruises`

0.0036709308624268

(7)

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

0.00062084197998047

(8)

DESCRIBE `cruises`

0.0036821365356445

(9)

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

0.00062203407287598

(10)

DESCRIBE `cruises`

0.0036690235137939

(11)

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

0.00052285194396973

(12)

DESCRIBE `cruises`

0.0039010047912598

(13)

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

0.00049901008605957

(14)

DESCRIBE `cruises`

0.0035161972045898

(15)

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

0.00031304359436035

(16)

DESCRIBE `cruises`

0.0036640167236328

(17)

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

0.00044488906860352

(18)

DESCRIBE `cruises`

0.0037310123443604

(19)

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

0.00048398971557617

(20)

DESCRIBE `cruises`

0.0037040710449219

(21)

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

0.00043392181396484

(22)

DESCRIBE `cruises`

0.0034511089324951

(23)

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

0.00049114227294922

(24)

DESCRIBE `cruises`

0.0032880306243896

(25)

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

0.0003809928894043

(26)

DESCRIBE `cruises`

0.0036981105804443

(27)

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

0.0018630027770996

(28)

DESCRIBE `cruiselines`

0.0025420188903809

(29)

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

0.00051593780517578

(30)

DESCRIBE `cruisetypes`

0.0014421939849854

(31)

DESCRIBE `destinations`

0.0022809505462646

(32)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('11', '48', '12', '37', '38', '43')) ORDER BY FIND_IN_SET(id, '11,48,12,37,38,43')

0.0013298988342285

(33)

DESCRIBE `ships`

0.0037820339202881

(34)

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

0.00051999092102051

(35)

DESCRIBE `ships`

0.0036659240722656

(36)

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

0.00054693222045898

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report