Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
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
9 January 2020	22	Zaandam, South America & Antarctica ex San Antonio to Buenos Aires
12 January 2020	21	Quest, Ultimate Antarctica & Patagonia ex San Antonio to Buenos Aires
31 January 2020	22	Zaandam, South America & Antarctica ex Buenos Aires to San Antonio
2 February 2020	21	Quest, Ultimate Antarctica & Patagonia ex Buenos Aires to San Antonio
6 February 2020	20	Shadow, Voyage 3002 ex Callao to Buenos Aires
23 February 2020	57	Quest, Antarctica & Amazon Isles ex San Antonio to Miami
23 February 2020	42	Quest, Antarctica & Amazon Isles ex San Antonio to Manaus
1 March 2020	19	Fram, Antarctica Sth Georgia Falklands ex Buenos Aires to Montevideo

Page Navigation: 1 2 3 Next »

Items 1 - 10 of 30

#	Query	Time
(1)	connect	0.00096511840820312
(2)	DESCRIBE `ports`	0.0031280517578125
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'castro-chile') AND (orchid_available = 1) LIMIT 1	0.0098800659179688
(4)	DESCRIBE `cruises`	0.0055098533630371
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (79302, 79303, 76700, 72175, 76701, 72191, 76682, 78229, 78225, 76502)) ORDER BY FIND_IN_SET(id, '79302,79303,76700,72175,76701,72191,76682,78229,78225,76502')	0.0054280757904053
(6)	DESCRIBE `cruises`	0.0054831504821777
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79302')	0.00061297416687012
(8)	DESCRIBE `cruises`	0.003727912902832
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79303')	0.00038790702819824
(10)	DESCRIBE `cruises`	0.0043869018554688
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76700')	0.00060200691223145
(12)	DESCRIBE `cruises`	0.0048470497131348
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72175')	0.00063395500183105
(14)	DESCRIBE `cruises`	0.0052621364593506
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76701')	0.00052499771118164
(16)	DESCRIBE `cruises`	0.004777193069458
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72191')	0.00070500373840332
(18)	DESCRIBE `cruises`	0.0042169094085693
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76682')	0.0004420280456543
(20)	DESCRIBE `cruises`	0.0037541389465332
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78229')	0.00056600570678711
(22)	DESCRIBE `cruises`	0.0038340091705322
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78225')	0.00047087669372559
(24)	DESCRIBE `cruises`	0.0045149326324463
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76502')	0.00038719177246094
(26)	DESCRIBE `cruises`	0.0046229362487793
(27)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701)) ORDER BY FIND_IN_SET(id, '76700,76701')	0.0015370845794678
(28)	DESCRIBE `cruiselines`	0.0040102005004883
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18')) ORDER BY FIND_IN_SET(id, '18')	0.00059986114501953
(30)	DESCRIBE `cruisetypes`	0.0019869804382324
(31)	DESCRIBE `destinations`	0.0024480819702148
(32)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37')) ORDER BY FIND_IN_SET(id, '37')	0.00046896934509277
(33)	DESCRIBE `ships`	0.0050580501556396
(34)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00067901611328125
(35)	DESCRIBE `ships`	0.004584789276123
(36)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00060486793518066
(37)	DESCRIBE `ports`	0.0020220279693604
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882)))	0.00052380561828613

Query

Time

(1)

connect

0.00096511840820312

(2)

DESCRIBE `ports`

0.0031280517578125

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'castro-chile') AND (orchid_available = 1) LIMIT 1

0.0098800659179688

(4)

DESCRIBE `cruises`

0.0055098533630371

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (79302, 79303, 76700, 72175, 76701, 72191, 76682, 78229, 78225, 76502)) ORDER BY FIND_IN_SET(id, '79302,79303,76700,72175,76701,72191,76682,78229,78225,76502')

0.0054280757904053

(6)

DESCRIBE `cruises`

0.0054831504821777

(7)

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

0.00061297416687012

(8)

DESCRIBE `cruises`

0.003727912902832

(9)

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

0.00038790702819824

(10)

DESCRIBE `cruises`

0.0043869018554688

(11)

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

0.00060200691223145

(12)

DESCRIBE `cruises`

0.0048470497131348

(13)

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

0.00063395500183105

(14)

DESCRIBE `cruises`

0.0052621364593506

(15)

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

0.00052499771118164

(16)

DESCRIBE `cruises`

0.004777193069458

(17)

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

0.00070500373840332

(18)

DESCRIBE `cruises`

0.0042169094085693

(19)

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

0.0004420280456543

(20)

DESCRIBE `cruises`

0.0037541389465332

(21)

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

0.00056600570678711

(22)

DESCRIBE `cruises`

0.0038340091705322

(23)

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

0.00047087669372559

(24)

DESCRIBE `cruises`

0.0045149326324463

(25)

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

0.00038719177246094

(26)

DESCRIBE `cruises`

0.0046229362487793

(27)

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

0.0015370845794678

(28)

DESCRIBE `cruiselines`

0.0040102005004883

(29)

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

0.00059986114501953

(30)

DESCRIBE `cruisetypes`

0.0019869804382324

(31)

DESCRIBE `destinations`

0.0024480819702148

(32)

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

0.00046896934509277

(33)

DESCRIBE `ships`

0.0050580501556396

(34)

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

0.00067901611328125

(35)

DESCRIBE `ships`

0.004584789276123

(36)

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

0.00060486793518066

(37)

DESCRIBE `ports`

0.0020220279693604

(38)

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

0.00052380561828613

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report