Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
6 January 2019	7	Preziosa, Caribbean Cuba & Antilles ex Pointe-a-Pitre Return
27 December 2018	15	Insignia, Caribbean New Year ex Miami to New York
28 December 2018	7	Le Champlain, New Year in the Caribbean ex Fort de France Return
29 December 2018	14	Preziosa, Caribbean, Cuba & Antilles Cruise ex Fort de France Return
29 December 2018	7	Wind, Voyage 2837 ex Bridgetown Return
29 December 2018	7	Jewel, Southern Caribbean Holiday ex San Juan Roundtrip
29 December 2018	7	Star Pride, Windward Islands Surf & Sunsets ex San Juan Return
2 January 2019	9	Serenade, Southern Caribbean ex Ft Lauderdale Return
3 January 2019	128	Viking Sun, World Cruise 2019 ex Miami to London (Greenwich)
3 January 2019	22	Viking Sun, From Miami to South America ex Miami to Buenos Aires

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

Items 1 - 10 of 142

#	Query	Time
(1)	connect	0.00068497657775879
(2)	DESCRIBE `ports`	0.0017681121826172
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'st-georges-grenada') AND (orchid_available = 1) LIMIT 1	0.0024600028991699
(4)	DESCRIBE `cruises`	0.0044088363647461
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (70377, 74395, 71025, 68317, 65402, 73247, 73733, 31730, 71855, 78027)) ORDER BY FIND_IN_SET(id, '70377,74395,71025,68317,65402,73247,73733,31730,71855,78027')	0.0027599334716797
(6)	DESCRIBE `cruises`	0.0043160915374756
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70377')	0.00050687789916992
(8)	DESCRIBE `cruises`	0.0033531188964844
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74395')	0.00032615661621094
(10)	DESCRIBE `cruises`	0.0031230449676514
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71025')	0.00047993659973145
(12)	DESCRIBE `cruises`	0.0033059120178223
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68317')	0.00040698051452637
(14)	DESCRIBE `cruises`	0.0025742053985596
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65402')	0.0003058910369873
(16)	DESCRIBE `cruises`	0.0025179386138916
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73247')	0.00035405158996582
(18)	DESCRIBE `cruises`	0.0031008720397949
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73733')	0.00037193298339844
(20)	DESCRIBE `cruises`	0.0030770301818848
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '31730')	0.00035500526428223
(22)	DESCRIBE `cruises`	0.0025668144226074
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71855')	0.00029492378234863
(24)	DESCRIBE `cruises`	0.0023660659790039
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78027')	0.00029110908508301
(26)	DESCRIBE `cruisetypes`	0.0013589859008789
(27)	DESCRIBE `destinations`	0.0023658275604248
(28)	DESCRIBE `cruiselines`	0.0028419494628906
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00059914588928223
(30)	DESCRIBE `ships`	0.0029449462890625
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00044012069702148
(32)	DESCRIBE `cruiselines`	0.002047061920166
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262)))	0.00046181678771973
(34)	DESCRIBE `ships`	0.0025110244750977
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1492)))	0.00049591064453125
(36)	DESCRIBE `ports`	0.0010769367218018
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308)))	0.00034284591674805

Query

Time

(1)

connect

0.00068497657775879

(2)

DESCRIBE `ports`

0.0017681121826172

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'st-georges-grenada') AND (orchid_available = 1) LIMIT 1

0.0024600028991699

(4)

DESCRIBE `cruises`

0.0044088363647461

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (70377, 74395, 71025, 68317, 65402, 73247, 73733, 31730, 71855, 78027)) ORDER BY FIND_IN_SET(id, '70377,74395,71025,68317,65402,73247,73733,31730,71855,78027')

0.0027599334716797

(6)

DESCRIBE `cruises`

0.0043160915374756

(7)

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

0.00050687789916992

(8)

DESCRIBE `cruises`

0.0033531188964844

(9)

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

0.00032615661621094

(10)

DESCRIBE `cruises`

0.0031230449676514

(11)

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

0.00047993659973145

(12)

DESCRIBE `cruises`

0.0033059120178223

(13)

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

0.00040698051452637

(14)

DESCRIBE `cruises`

0.0025742053985596

(15)

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

0.0003058910369873

(16)

DESCRIBE `cruises`

0.0025179386138916

(17)

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

0.00035405158996582

(18)

DESCRIBE `cruises`

0.0031008720397949

(19)

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

0.00037193298339844

(20)

DESCRIBE `cruises`

0.0030770301818848

(21)

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

0.00035500526428223

(22)

DESCRIBE `cruises`

0.0025668144226074

(23)

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

0.00029492378234863

(24)

DESCRIBE `cruises`

0.0023660659790039

(25)

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

0.00029110908508301

(26)

DESCRIBE `cruisetypes`

0.0013589859008789

(27)

DESCRIBE `destinations`

0.0023658275604248

(28)

DESCRIBE `cruiselines`

0.0028419494628906

(29)

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

0.00059914588928223

(30)

DESCRIBE `ships`

0.0029449462890625

(31)

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

0.00044012069702148

(32)

DESCRIBE `cruiselines`

0.002047061920166

(33)

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

0.00046181678771973

(34)

DESCRIBE `ships`

0.0025110244750977

(35)

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

0.00049591064453125

(36)

DESCRIBE `ports`

0.0010769367218018

(37)

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

0.00034284591674805

My Favourite Cruises

Upcoming Sailings

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Upcoming Sailings

Database Profiling Report